Reconciling and troubleshooting out of balance issues for Accounts Receivable and General Ledger
Description

Cause

Resolution
[BCB:5:Third-party support:ECB]

 

Note: Follow each step in order.

1. Start the reconciliation process:

2. Verify everything posted in AR and GL:

3. Check for entries originated in an application other than Accounts Receivable, Billings or Service Management:

4. Overbilled retainage:

5. Aging Report includes Customer Cash Receipts

  • Verify if the Customer Cash Receipts account in AR Settings, GL Settings, Balance Sheet Accounts is the same as your receivables account
  • If it isn't, run the aging with a condition of Cash Receipt Type NE to Customer Cash Receipt
  • See How do I reconcile to my AR customer cash receipt account?

6. Batches missing from General Ledger or Accounts Receivable:

7. Entries posted to the wrong GL account:

 

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




Steps to duplicate
Related Solutions

How can I see all unapplied cash receipts in Accounts Receivable?
How can I print an Accounts Receivable Aging or Statement report by GL Prefix?