Reconcile out of balance issues for Accounts Receivable and General Ledger
Description
Cause
Resolution

CAUTION:

Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.

Follow the outlined steps in order.

Start the reconciliation process

Determine if you’re out of balance before following the steps below.

Verify everything posted in AR and GL

Post entries for Accounts Receivable and General Ledger.

Check for entries from other applications

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

Overbilled retainage

Correct any overbilled retainage.

Aging Report includes Customer Cash Receipts

  1. Verify if the Customer Cash Receipts account is the same as your receivables account. Check this in AR Settings, GL Settings, Balance Sheet Accounts.
  2. If it isn't, add a condition to the aging report. Use the condition of Cash Receipt Type NE to Customer Cash Receipt.
  3. Reconcile your customer cash receipt account.

Batches missing from General Ledger or Accounts Receivable

Entries posted to the wrong GL account

Correct entries posted to the wrong 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?