Skip to main content

How to Reconcile Accounts Receivable in QuickBooks

· 5 min read
Debits

Introduction​

Reconciling your Accounts Receivable (AR) in QuickBooks is essential for ensuring that your records accurately reflect the money owed to your business. The reconciliation process helps confirm that your financial transactions related to customer payments, invoices, and credit memos are correctly recorded in your system. This guide will walk you through the process of reconciling Accounts Receivable in QuickBooks, helping you maintain accurate and up-to-date records.

What is Accounts Receivable Reconciliation?​

Accounts Receivable reconciliation involves verifying that the amount of money recorded as receivable in QuickBooks matches the actual payments received from customers. By reconciling AR regularly, you can identify discrepancies such as missed payments, overpayments, or unapplied credits. Regular reconciliation helps you spot errors early, ensuring your business’s financial statements are accurate.

Step 1: Prepare for Reconciliation​

1.1: Review Accounts Receivable Reports​

  1. Generate AR Aging Summary: Go to Reports > Customers and Receivables > A/R Aging Summary. This report shows the amount owed by each customer and how long those amounts have been outstanding.
  2. Review Aging Details: Take note of any overdue payments or irregularities in customer balances. This will help you address potential issues during reconciliation.

1.2: Gather Supporting Documents​

  1. Collect Invoices and Payments: Ensure that you have all the invoices, credit memos, and payment receipts related to the period you're reconciling.
  2. Check Bank Statements: Have the bank statements on hand that show deposits for customer payments to cross-check with your records in QuickBooks.

Step 2: Reconcile Accounts Receivable​

2.1: Access Reconciliation Tool​

  1. Navigate to the Reconciliation Tool: In QuickBooks, go to Accounting > Reconcile.
  2. Choose the AR Account: Select the Accounts Receivable account you want to reconcile.

2.2: Match Transactions​

  1. Enter Statement Ending Balance: Enter the statement balance from your bank account, which reflects the total amount of customer payments deposited into the account.
  2. Select the Date Range: Choose the period you’re reconciling, such as the current month or a custom date range that matches your bank statement.
  3. Match Invoices and Payments: Go through the list of payments and invoices, checking off those that have been cleared and match with your records.

2.3: Resolve Discrepancies​

  1. Unmatched Transactions: If there are unmatched transactions (e.g., payments recorded in QuickBooks but not deposited), investigate why they haven't been reflected in the bank account or why they are missing from your records.
  2. Check for Data Entry Errors: Ensure that the amounts recorded in QuickBooks match those on your invoices and bank deposits. Correct any typos or errors in amounts or dates.

2.4: Apply Customer Credits (if Necessary)​

  1. Review Unapplied Credits: Sometimes, customer credits or overpayments may not be applied correctly. Navigate to Customers > Receive Payments and look for any unapplied credits.
  2. Apply Credits: Apply these credits to the corresponding invoices to ensure the balances are correct.

Step 3: Adjust Accounts Receivable (if Necessary)​

3.1: Record Missing Payments​

  1. Locate Missing Payments: If a payment is recorded on your bank statement but not in QuickBooks, create a new payment entry by going to + New > Receive Payment.
  2. Apply to Customer Account: Enter the customer’s name, the payment amount, and apply the payment to the correct open invoice.

3.2: Handle Overpayments or Errors​

  1. Overpayments: If a customer has overpaid, you can record the overpayment as a credit to be applied to future invoices or issue a refund. To record a refund, go to + New > Refund Receipt and enter the relevant details.
  2. Adjustments for Errors: For errors or discrepancies that require an adjustment, use a journal entry to correct the AR balance. Go to + New > Journal Entry, debit the appropriate account, and credit the AR account (or vice versa).

Step 4: Finalize the Reconciliation​

4.1: Review the Final Balance​

  1. Recheck the Ending Balance: Ensure that the final balance in your Accounts Receivable account matches your bank statement or other source documents.
  2. Generate an A/R Aging Report: Run the A/R Aging Summary report again after reconciliation to confirm that customer balances are accurate.

4.2: Reconcile the Account​

  1. Reconcile: Once everything is matched and corrected, click Finish Now in the reconciliation tool to complete the process.
  2. Save Reports: Save or print a copy of the reconciliation report for your records. This report will show the transactions you reconciled, along with any changes or adjustments made.

Step 5: Review and Maintain Accurate AR Records​

5.1: Regularly Reconcile Accounts Receivable​

  1. Set a Schedule: Make it a routine to reconcile your AR account monthly or quarterly to avoid discrepancies from building up over time.
  2. Monitor Aging Reports: Continuously monitor the A/R Aging Summary and A/R Aging Detail reports to keep track of overdue accounts and outstanding payments.

5.2: Automate Processes​

  1. Use Automation Tools: Consider using automated payment reminders and invoice systems within QuickBooks to streamline the accounts receivable process and reduce manual errors.
  2. Sync with Bank Accounts: If possible, connect your QuickBooks account with your bank to automatically import and match transactions, reducing manual data entry.

Conclusion​

Reconciling your Accounts Receivable in QuickBooks is a critical task to ensure your financial records are accurate and up-to-date. By following the steps outlined in this guide, you can confidently reconcile your AR accounts, resolve discrepancies, and maintain accurate financial reports. Regularly reconciling AR will help you identify issues early, prevent errors, and ensure a clear financial picture for your business.