How to reconcile accounts receivable

The reconciliation of accounts receivable is the process of matching the detailed amounts of unpaid customer billings to the accounts receivable total stated in the general ledger. This matching process is important, because it proves that the general ledger figure for receivables is justified. The two information sources for this reconciliation are noted below:

  • General ledger. There is usually an account in the general ledger that is specifically designated for the sole compilation of all receivables related to customers (known as trade receivables). All other receivables, such as those for employee advances, are classified in other accounts. After all transactions have been recorded for a reporting period and all subsidiary ledger balances have been posted to the general ledger, the resulting ending balance in the receivables account is the summary total to be verified through a reconciliation.

  • Receivables detail. The detailed listing of unpaid customer billings that should match the ending balance in the general ledger is usually recorded in a subsidiary sales ledger. To extract this information for reconciliation purposes, ensure that all invoices have been issued for the reporting period, and then print the aged accounts receivable report as of the final day of the period. The totals on this report are then compared to the receivable total in the general ledger.

Related AccountingTools Courses

Bookkeeping Guidebook

How to Audit Receivables

New Controller Guidebook

Accounts Receivable Reconciling Items

When the reconciliation is conducted, there may be differences between the two amounts. Here are several possible reasons for these differences:

  • Journal entry only made to the general ledger account. A journal entry might have been made to the general ledger account that bypassed the subsidiary sales ledger. This is the most common reason for a difference.

  • Posting made to wrong account. A billing might have been accidentally posted to an account other than the trade receivables account. This is the least common reason for a difference, since the billing module is set to automatically record all billings to the correct account.

  • Difference in report dates. The aged receivables report might have been run as of a different date than the date used to obtain the general ledger balance.

When to Reconcile Receivables

This reconciliation process is typically conducted as part of the month-end closing activities prior to issuance of the financial statements. If the reconciliation is not conducted and there turns out to be an error in the general ledger, this means there could be a material inaccuracy in the financial statements.

At a minimum, there should be a reconciliation of accounts receivable at the end of the fiscal year, so that any inaccuracies related to receivables will have been removed from the financial statements prior to their examination by the company's external auditors.

Related Articles

Accounts Receivable Accounting

Accounts Receivable Analysis

How to Calculate Average Accounts Receivable

How to Write Off a Bad Debt

Schedule of Accounts Receivable