Reconciling Accounts Receivable

Select the Accounting Overview option on the Overview Menu and the following screen will come into view. The following fields are for information only and cannot be changed from this screen.

In the Accounts Receivable section, General Ledger Totals Receivables in GL and the Subsidiary Ledger Total Receivables amounts should be the same. The Trouble Scan button may be used to isolate suspect records. Trouble Scan allows each suspect transaction and/or a complete listing of all suspect transactions to be viewed. The system looks for transactions from the Accounts Receivable module which did not go to the proper control accounts. It also searches for transactions made to A/R control accounts that did not originate in the accounts receivable module.

Once suspect transactions have been isolated, the Trial Balance tab may be used to View the Transactions in question. Highlight the desired account and press the View Transactions button and a complete listing of all transactions for the selected account will be listed. The View Detail by Account button will list all the transactions for the highlighted account for one fiscal period and the Beginning and Ending Balances for this account.

The same information contained in the balance back overview screen may be obtained through printing a GL Summary Trial Balance Listing and an A/R AS-OF Invoice Analysis Report.

GL Summary Trial Balance Listing

Print a General Ledger Summary Trial Balance report for the fiscal period that is being closed. Make sure the general ledger is in balance by confirming that the total at the bottom of the ending beginning balance column is zero.

A/R AS-OF Invoice Analysis Report

Print this report for Billings, Invoices and Receipts. Since this is not on a historical basis, an adjustment for any billings after the chosen fiscal period will have to be made before comparing this report with the balances in Accounts Receivable and Retention Receivable. Note: To avoid confusion, print this report at the month end, before any new billings or receipts are posted to the subsequent month.