Accounting Report Module

You are looking at an old Manual of pc/MRP,
the Complete MRP Inventory/Accounting Package.

Please click below for
the latest pc/MRP Manual

Please click below to
reach the pc/MRP Main Page

Manual Logo

Main Page Logo

 

ACCOUNTING REPORT MODULE

Accounting report errors can occur due to duplicate transaction numbers, duplicate blank transaction numbers and incorrect dates. Accounting's Audit Option will automatically locate these transactions and allow you to correct them.

Duplicate transaction numbers can cause an accounting report to loop on the duplicate number. To correct this delete one of the first duplicate transaction number. If necessary the transaction can be re-entered with a new transaction number.

Duplicate blank transaction numbers can cause an accounting report to loop on the blank transaction printing out only lines and no transactions. To correct this, delete the blank transaction numbers.

Invalid dates such as 03/99/92 can cause a transaction report to skip all remaining transaction for month 03. Use the accounting audit option to locate any invalid dates and then edit the transaction's date.

14.7.1 General Ledger Transaction Reports

Selection 1 prints out or displays all General Ledger Transactions in the transaction data base file for:
M Month
T Time period
S Balance for a specific date

A All transactions regardless of time

Include all transactions for a:

C Chart of accts #
V Vendor/customer acct #
H Check #
D Related Document #
I Invoice #
R Receiver #
A All transactions

Types of transactions to include:

A All
S Cash sales only
O Receivable vouchers only
R Receivable payments only
P Cash purchases only
I Accounts payable vouchers only
E Payable payments only
W Payroll checks only

14.7.2 All Transactions For A Specified Chart Of Accounts (T Accts)

Selection 2 prints out or displays all transactions in the transaction database file for a specified chart of account for:

M Month
T Time period

S Balance for a specific date
A All transactions regardless of time

Types of transactions to include:

A All

S Cash sales only
O Receivable vouchers only
R Receivable payments only
P Cash purchases only
I Accounts payable vouchers only
E Payable payments only
W Payroll checks only

14.7.3 Current Balance For A Specified Account

Prints out and totals the account's beginning balance and transactions for the current month. For this report to be correct all prior months to the current month must have been current and posted. This is the fastest method for providing your current balance in a chart of accounts, such as your checking account.

14.7.4 Account Payables Reports

Allows you to print out accounts payable reports. You can select all open, all closed and aging reports of 30, 60 and 90 days.

If you run an open accounts payable summary report and the balance due for a receiver is less than or equal to 0 and the complete field does not contain a Y, the customer PO# field will contain the words Error Unmarked. You can edit the receiver record and put a Y in the complete field.

14.7.5 Account Receivable Reports

Allows you to print out accounts receivable reports. You can select all open, all closed and aging reports of 30, 60 and 90 days.

14.7.6 FIFO Inventory Value Report

Prints out or displays a FIFO Inventory Value Report. This report uses the receivers and the quantity onhand to determine the value of the inventory.

14.7.7 Sales Tax Report

The sales tax report option prints and or displays a sales tax report for a specified time period. The sales tax reports will include all invoices entered during the time period you specify.

If you select In State, pc/MRP will sort and subtotal sales taxes due on the invoice tax codes, such as taxable, resale, out of stare, US government, etc. The report (taxlog.frx) will consist of invoices created during the time period specified. The invoices must contain sales tax codes (automatically inserted from sales orders into invoices). If you create a custom in state report, it must be named ctaxlog.frx.

If you select Out of State, pc/MRP will sort and subtotal sales taxes due by the invoice state and tax entity code such as CA01, CA02, NY01, etc. The report (taxlogo.frx) will consist of invoices created during the time period specified. . The invoices must contain tax entity codes (automatically inserted from the address book into sales orders and then into invoices). If you create a custom out of state report, it must be named ctaxlogo.frx.

If you select Out of State for a specified state, pc/MRP will sort and subtotal sales taxes due by the tax entity code such as CA01, CA02 for the specified state such as CA. The report (taxlogo.frx) will consist of invoices created during the time period specified for the specified state. The invoices must contain tax entity codes (automatically inserted from the address book into sales orders and then into invoices). If you create a custom out of state report, it must be named, ctaxlogo.frx

If you are required to pay state sales taxes for only the county you are based in, print out the instate report.

If you are required to pay state sales taxes for other counties in your state, print out the instate report and the out of state report for a specified state (yours.)

If you are required to print out sales taxes to two or more states, print out the instate report and the out of state report.

14.7.8 Sales Commission Report

Prints out or displays a Sales Commission Report for a specified month. subtotaled by Salesman. Commissions can be based on:

14.7.9 Cash Out Projection Report (POs)

The Cash Out Projection Report is based on outstanding purchase orders being paid off 30 days from the expected delivery date for each PO line item. Users will be prompted to enter a date range.  pc/MRP will display the cost of all Purchase Orders where the expected delivery date  + 30 days falls into that range. 

14.7.10 Cost Of Sales Report

pc/MRP will allow you to print out a cost of sales report for a specified month based on invoices. Each invoice contains theoretical cost of the BOM based on cost-roll-ups or the cost based on stockroom transactions issued to those invoices. pc/MRP's Configuration Menu, Option 17, will allow you to select how the cost of sale for each invoice is obtained from inventory, from the Cost field from Related Purchase Orders, or turned off (P/R/O).

If the costs are populated from inventory, option 35 in the settings and utilities defines if standard or average costs will be in the cost of sale.  For costs to work correctly from inventory all parts in inventory must have a standard or average cost populated and the "Cost Roll Up Option" in inventory module must be ran periodically to update the cost of all assemblies.

14.7.11 Purchasing Price Variance Report

Accounting's Purchase Price Variation Report compares standard costs or average costs listed in the Inventory Module with the actual purchase price from the receiver. Purchasing can use this report to show management the cost savings per month over list prices.

14.7.12 Check Reconciliation Report

pc/MRP allows you to print out a check reconciliation report for all checks or uncleared checks only. Select All checks to see a running pc/MRP and bank balances from day 1. Select Uncleared checks only to see the difference in the pc/MRP and bank balance only. Select Last 160 days only (assumes all checks over 160 days have been cleared), to see the last 160 days of bank transactions comparing pc/MRP's balance with the banks balance.

Select how you would like this report sorted by transaction number, date, or check number. Enter the checking accounts chart of accounts number. pc/MRP will then display/print the reconciled running balances between the bank statement and pc/MRP's transaction files. The balance column contains pc/MRP's balance. The cleared balance column contains the bank's balance. The uncleared balance column contains the differences in the two balances.

The Last 160 days only report first totals up all checking transactions greater than or equal to 160 days old. If pc/MRP finds any deposits or checks have not been cleared over or equal to 160 days old, it will display an error message with the transaction number and return back to the main menu. If all the 160 days and older checks have been cleared, pc/MRP puts the total of all the checks into a memory variable named mprevtot. It then goes on to create a report listing each checking transaction less than 159 days old, a running balance for pc/MRP, a running balance for the bank, and the difference based on if the check cleared or not.

To automatically clear all checks greater than 160 days old, go to accounting, select "Pay Bills/Print/Clear Checks", and select "Clear all checks for a date range".