Skip to main content

How to Reconcile Accounts Receivable in QuickBooks

· 6 min read
Debits

Introduction​

Reconciling your Accounts Receivable (AR) in QuickBooks ensures that the amount owed by customers aligns with your financial records. This process is critical for maintaining accurate financial statements and helps ensure that all customer payments and invoices are recorded properly. Regular reconciliation of Accounts Receivable prevents errors, identifies missed payments, and keeps your business’s cash flow in check. This guide will walk you through how to reconcile Accounts Receivable in QuickBooks.

What is Accounts Receivable Reconciliation?​

Accounts Receivable reconciliation involves verifying that the money owed to your business by customers (via invoices) matches the payments received. The reconciliation process ensures that all transactions are correctly reflected in your books, and it helps identify discrepancies such as missing payments, unapplied credits, or incorrect entries.

Step 1: Prepare for Reconciliation​

1.1: Gather Relevant Documents​

Before you begin the reconciliation process, it’s important to have the following documents on hand:

  1. Customer Invoices: Collect all customer invoices that have been issued for the period you’re reconciling.
  2. Payment Receipts: Gather receipts for payments received during the period.
  3. Bank Statements: Have your bank or credit card statements available to verify that the amounts deposited match what is recorded in QuickBooks.

1.2: Run Key Reports​

  1. Accounts Receivable Aging Summary: Go to Reports > Customers and Receivables > A/R Aging Summary. This report provides a summary of outstanding invoices by age, helping you identify any overdue amounts.
  2. Accounts Receivable Aging Detail: For more granular information, run the A/R Aging Detail report, which lists each customer’s outstanding balance along with invoice dates and amounts.

Review these reports to ensure that the amounts owed by customers match what is recorded in QuickBooks.

Step 2: Review and Adjust Transactions​

2.1: Check for Unapplied Payments​

  1. Navigate to Receive Payments: Go to + New > Receive Payment to review customer payments that may not have been correctly applied to invoices.
  2. Match Payments to Invoices: Ensure that all payments are properly applied to the corresponding invoices. If a payment is unapplied, you can match it to the correct invoice to avoid overstating your Accounts Receivable.

2.2: Check for Missing Invoices or Payments​

  1. Look for Missing Entries: If the Accounts Receivable report shows more or less than expected, check if any invoices or payments were missed.
  2. Record Missing Transactions: If you find that a customer payment was not recorded or an invoice was not issued, go to + New > Receive Payment or + New > Invoice to enter the missing transaction.

2.3: Review Customer Credits​

  1. Check for Unapplied Credits: Go to + New > Credit Memo to review any customer credits that may not have been applied. Applying credits to the corresponding customer invoices helps ensure the Accounts Receivable balance is correct.
  2. Apply Credits: If a customer has a credit that hasn’t been applied to their outstanding balance, apply the credit by navigating to + New > Receive Payment and selecting the credit memo for the corresponding customer.

Step 3: Reconcile Accounts Receivable with the General Ledger​

3.1: Verify the Accounts Receivable Balance in the General Ledger​

  1. Run a Trial Balance Report: Go to Reports > Trial Balance. This report provides a summary of the debits and credits in your General Ledger, including the Accounts Receivable account.
  2. Compare Balances: Compare the total in the Accounts Receivable account on the Trial Balance report with the balance in your A/R Aging Summary report. The totals should match. If they don’t, further investigation is needed.

3.2: Investigate Discrepancies​

  1. Look for Journal Entries: Check whether any manual journal entries were made that might affect the Accounts Receivable balance. Journal entries that bypass the usual workflow can cause discrepancies.
  2. Review the Accounts Receivable Register: Go to Accounting > Chart of Accounts, find the Accounts Receivable account, and click View Register to review all transactions affecting AR. Look for any irregular or missing entries.

Step 4: Reconcile Customer Accounts​

4.1: Match Invoices to Payments​

  1. Review Customer Accounts: Go to Sales > Customers and select a customer to view their transactions.
  2. Check Payment Applications: Ensure that each customer’s invoices are matched with their payments. If payments are not correctly applied to invoices, adjust them to ensure the correct balances are reflected.

4.2: Correct Overpayments or Underpayments​

  1. Handle Overpayments: If a customer has overpaid, you can issue a refund or apply the overpayment as a credit toward future invoices. Go to + New > Refund Receipt to issue a refund, or apply the overpayment to the next invoice during the next payment cycle.
  2. Adjust for Underpayments: If a customer underpaid, you may need to follow up with them or adjust the outstanding invoice to reflect the correct balance.

Step 5: Finalize the Reconciliation​

5.1: Generate the Final Reports​

  1. Run the A/R Aging Summary Again: After making all necessary adjustments, generate the A/R Aging Summary report once more to ensure everything is correct.
  2. Check the General Ledger: Run the Trial Balance report again to verify that the balance in Accounts Receivable matches your A/R Aging Summary.

5.2: Complete Reconciliation​

  1. Mark as Reconciled: Once all invoices, payments, and credits are correctly applied, mark your AR account as reconciled. While QuickBooks does not have a formal reconciliation process for Accounts Receivable like it does for bank accounts, regular reviews and adjustments ensure the account stays accurate.
  2. Save Reports for Your Records: Save or print the reconciliation reports for your records. This documentation is helpful for future audits or reviews.

Best Practices for Managing Accounts Receivable in QuickBooks​

  1. Reconcile Monthly: Make it a habit to reconcile Accounts Receivable every month to catch discrepancies early and prevent errors from accumulating.
  2. Monitor Aging Reports: Regularly review the A/R Aging Summary and A/R Aging Detail reports to stay on top of overdue accounts and follow up with customers as needed.
  3. Apply Payments Promptly: Ensure that customer payments are applied to the correct invoices immediately to avoid discrepancies in your AR balance.
  4. Keep Clear Communication with Customers: Regularly communicate with customers about outstanding balances and payment terms to reduce the likelihood of missed or delayed payments.

Conclusion​

Reconciling Accounts Receivable in QuickBooks is essential for maintaining the accuracy of your financial statements and ensuring that the money owed to your business is properly tracked. By following the steps outlined in this guide, you can identify and correct any discrepancies, apply payments correctly, and ensure that your AR balances match your bank statements and general ledger. Regular reconciliation not only helps with cash flow management but also improves your financial decision-making.