Compare the Two Reports
Compare the amounts on the Accounts Receivable Aging Report by Account to the ending balances of the Accounts Receivable that appear on the Trial Balance. The two should be the same. If you discover an account balance that does not match the amount on the Accounts Receivable Aging Report, print the General Ledger Detail of that account.
Select the following options on the Print General Ledger Detail Report screen:
- In the Select Accounts group box, select One in the Range Option drop-down list. This option prints the General Ledger Detail information for a single account.
- In Include Level ___ and below, enter 1. This is the highest level of the account. If you want to see the General Ledger Detail at a lower level, indicate that here. For example, you have four levels for your Accounts Receivable account. You may want to see the General Ledger Detail at level four. Each level from level four down to level one will be printed. (Keep in mind that you should print the General Ledger Detail at the same level that you printed the Accounts Receivable Aging Report.)
- Review the General Ledger Detail Report. There should be amounts next to the field labeled Cash Receipt. These transactions are from Cash Receipt Journal postings. Amounts in the Invoice field come from Billing Journal postings. There should not be any amounts next to Journal Entry or Voucher. If there are amounts in these fields, you may have discovered why the reports are not in balance. When Journal Entries are posted to an Accounts Receivable account, the Manage Accounts Receivable History screen is not updated.
Parent Topic: A/R Aging Report To The G/L