99.987% uptime·0 security breaches·35+ years in education·Built and supported in the U.S.
Posted October 03, 2018
Identifying Discrepancy in Accounts Receivable Reconciliation
When reconciliation is conducted, there may be differences between the customer balance and the general ledger balance.  Any of the following reasons can account for these differences:

- There are journal entries posted to the accounts receivable account. In DAT, there is a report called [Finance] AR Reconciliation - Summary, that breaks down transactions by description.  This will help you identify if there are any journal entries associated with your accounts receivable account.
- There are miscellaneous receipts posted to the accounts receivable account.  In DAT, there is a report called [Finance] AR Reconciliation - Summary, that breaks down transactions by description.  This will help you identify if there are any miscellaneous receipts associated with your accounts receivable account.
- There are invoices that credit the accounts receivable account instead of debiting it.  In DAT, there is a report called
[Finance] AR Reconciliation - Invoices Debiting AR Account that will help you identify such invoices.
- There are receipts/credits that debit the accounts receivable account instead of crediting it.  In DAT, there is a report called [Finance] AR Reconciliation - Receipts/Credits Debiting AR Account that will help you identify such receipts/credits.
- The parameters specified in the Customer Balance Configuration screen do not match those that are specified in the General Ledger screen.  Example:  Unposted transactions may be set to show on Customer Balance - - Configuration screen whereas the General Ledger screen only takes into account posted transactions.

Similarly, there may be differences between the customer balance and the customer aging report.  Any of the following reasons can account for these differences:

- There are invoices that credit the accounts receivable account instead of debiting it.  In DAT, there is a report called
[Finance] AR Reconciliation - Invoices Debiting AR Account that will help you identify such invoices.
- There are receipts/credits that debit the accounts receivable account instead of crediting it.   In DAT, there is a report called [Finance] AR Reconciliation - Receipts/Credits Debiting AR Account that will help you identify such receipts/credits.
- The parameters specified in the Customer Balance Configuration screen do not match those that are specified in the Aging Report.  Example:  Unposted transactions may be set to show on Customer Balance Configuration screen whereas the A/R Aging Report may be configured to show posted transactions only.
Update

Streamlined Selector and Widget Configuration

1 min read · Updated April 26, 2026

Was this article helpful?

Your feedback goes to the team that maintains this article.

Thanks. We use this to improve the article.

Still have questions?

Live chat is staffed weekdays 8 am to 7 pm ET. Tickets get a response within one business day.

Open a ticket

New to PCR Educator?

If you landed here from a search and want to see what PCR can do, the demo is the fastest way in. Thirty minutes, no commitment.

Book a demo