Reconcile out of balance issues for Accounts Receivable and General Ledger

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

• Accounts Receivable and General Ledger are out of balance due to missing batches.
• AR Batch Reconciliation doesn't match the GL Reports when you use Service Management.

Entries posted to the wrong GL account

Correct entries posted to the wrong account.

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?