How do I reconcile Accounts Receivable to General Ledger?
Description

Cause

Resolution
Post Entries and verify setup:

  1. Post in Accounts Receivable and General Ledger using Task, Post Entries.
  2. Check your posting journals and verify there are no rejections. If there are rejections, fix them before continuing with the following steps.
  3. In Accounts Receivable, from File, select Company Settings, AR settings, GL settings, Balance Sheet Accounts.
  4. Write down the following accounts:
    • Accounts receivable account
    • Retainage receivable account
    • Customer cash receipt account

Reconciliation:
Section 1 - In Accounts Receivable:

  1. From the Reports menu, select Aging, Detail by Customer.
  2. Select the Current AR transaction file.
  3. Enter the Aging As Of Date for the month you are reconciling. Note the month-end date that you enter.
  4. For the Aging Basis, select Accounting date.
  5. Select the Include Retainage Column check box (if necessary).
  6. If your accounts receivable and customer cash receipt account are the same General Ledger accounts, click Start to print the report.
  7. If your accounts receivable and customer cash receipt account are not the same General Ledger accounts:
    1. Click Conditions.
    2. Add a condition for Cash Receipt Type not equal to Customer Cash Receipt.
    3. Click Start to print the report.

Section 2 - In General Ledger:

  1. In General Ledger, from the Reports menu, select Year-to-date Ledger.
  2. Select the Modify date range check box.
  3. Enter the Start date as the beginning date for the month you are reconciling, which should be the same month previously entered in Section 1, step 3.
  4. Enter the End date as the ending date for the month you are reconciling.
    Note: The End date should be the date that you entered on the AR Aging Detail by Customer report in Section 1, step 3. Reconcile one month at a time.
  5. If using prefixes:
    1. Click Conditions
    2. Add a condition for base account equal to your accounts receivable account noted from your Accounts Receivable settings.
  6. If not using Prefixes:
    1. Range on the accounts receivable account that you noted from your Accounts Receivable settings.
  7. Click Start to print the report.

Section 3 - Review the Reports:

  1. If your accounts receivable and retainage receivable accounts are the same: Compare the ending balance for all accounts of the Year-to-Date Ledger to the Amount column Report total plus the Retainage column total (do not pay attention to the negative sign) on the Aging Detail by Customer report.
  2. If your Accounts receivable and Retainage receivable accounts are different:
    1. Compare the ending balance for the accounts receivable account on the Year-to-Date Ledger to the Amount column Report Total on the Aging Detail by Customer.
    2. Repeat Section 2, steps 1 - 7, only change the Accounts Receivable account to the Retainage receivable account.
    3. Compare the ending balance for the Retainage Receivable on the Year-to-Date Ledger to the Retainage column Report Total on the Aging Detail by Customer Retainage column Total. The retainage amount on the Aging detail by Customer will show a negative amount; ignore the negative sign it just means on the report that the retainage is still held, not billed.

If this month is not in balance, print the reports for the previous month and verify you are still in balance. Repeat the steps above until you find the last month that is out of balance. Follow Accounts Receivable and General Ledger are out of balance to troubleshoot.

NOTE: Debit and credit amounts for invoices, cash receipts and adjustments may appear differently as a positive or a negative in General Ledger reports (including the Batch Reconciliation from GL report in Accounts Receivable) based on the type of transaction entered.
To reconcile customer cash receipt account (if the customer cash receipt account is not equal to the accounts receivable account):

  1. From Reports, select Aging, Detail by Customer.
  2. Select the Current AR transaction file.
  3. Enter the Aging As Of Date for the month you are reconciling. Note the month-end date that you enter.
  4. For the Aging Basis, select Accounting date.
  5. Select the Include Retainage Column check box (if necessary).
  6. Click Conditions.
  7. Add a condition for Cash Receipt Type equal to Customer Cash Receipt.
  8. Click Start to print the report.

Compare this report to the YTD ledger for the Customer Cash Receipt account. See Section 2 above for steps on how to run the YTD ledger using necessary prefix conditions and/or ranging on the customer deposit account.



[BCB:156:Chat 300 CRE US:ECB]


Steps to duplicate
Related Solutions

How do debits and credits appear on different General Ledger reports and inquiries?
How can I print an Accounts Receivable Aging or Statement report by GL Prefix?