How to Reconcile an Account in QuickBooks

See QuickBooks: Tips and Tricks for similar articles.

An important part of keeping accurate, up-to-date financial records is ensuring that the transactions you record in QuickBooks match the records of your financial institution. Instead of manually "balancing your checkbook" you can use the Reconcile feature of QuickBooks to quickly reconcile your bank, credit card, or loan account. The following steps show how to perform an account reconciliation.

This feature works the same in versions 2011–2016 of QuickBooks.
  1. Review your bank statement to confirm the period of the reconciliation.
  2. From the Home page, in the Banking section, click Reconcile.Reconcile on Home Page
  3. From the Account drop-down list, select the account to reconcile.Account Drop-down List
  4. In the Statement Date field, type or select the ending date of the bank statement you are reconciling.Statement Date Field
  5. In the Beginning Balance field, compare the amount shown to the opening balance amount from your bank statement.
  6. In the Ending Balance field, type the ending balance shown on your bank statement.Ending Balance Field
  7. In the Service Charge field, type the amount and date of any unrecorded service charges from your bank statement.
  8. From the Account drop-down list, select the account for the service charge.Account Drop-down List
  9. In the Interest Earned field, type the amount and date of any unrecorded interest from your bank statement.
  10. From the Account drop-down list, select the account for the interest earned.Account Drop-down List
  11. Verify that the amounts from the Begin Reconciliation window match the amounts from your bank statement, then click Continue.
  12. The Reconcile window is used to reconcile the individual transactions from your account statement. In this window, payments and deductions from your account are listed on the left side and deposits and credits to your account are listed on the right side. Transactions in this window are sorted by date in ascending order. Transactions can be sorted by another field by clicking the field column heading. An up arrow indicates the column is sorted in ascending order (smallest to largest). A down arrow indicates the column is sorted in descending order (largest to smallest).Reconcile Window

  13. In the Reconcile window, click the transactions that are listed on the bank statement you are reconciling to mark them as cleared. When the ending balance equals the cleared balance, the difference will show 0.00. Verify the account is reconciled and that the information is correct, then click Reconcile Now.Reconcile Window
  14. In the Select Reconciliation Report dialog box, select the type of reconciliation report to display or print and click the output option you desire.Select Reconciliation Report Dialog BboxPrinting both reconciliation reports for your records is recommended.Reconciliation SummaryReconciliation Detail

Reconciliation reports can be printed each time you reconcile an account. Reconciliation reports can be saved in PDF format or you can print a hard copy in case any account discrepancies occur during the next reconciliation.

QuickBooks updates your transactions in the Reconcile window as soon as you record or save changes. If you notice an error, you can double-click to zoom in to a transaction or you can record a transaction using the normal methods in QuickBooks.

If you realize that, as part of the reconciliation, you've incorrectly entered the service charge, interest earned, ending balance, or any other information, click the Modify button. QuickBooks redisplays the Begin Reconciliation dialog box. Update the amount and then click Continue to return to the Reconciliation window.


Related Articles

  1. How to Transfer Funds Between Bank Accounts in QuickBooks
  2. How to Create a Company File in QuickBooks Using Express Start
  3. How to Create a Profit and Loss Report in QuickBooks
  4. How to Customize an Invoice Form in QuickBooks
  5. How to Add Inventory Items in QuickBooks
  6. How to Write Checks and Enter Bills in QuickBooks
  7. How to Use the Account Register in QuickBooks
  8. How to Delete and Void Checks in QuickBooks
  9. How to Export a QuickBooks Report to Microsoft Excel
  10. How to Add Credit Card Accounts in QuickBooks
  11. How to Run a Sales Tax Report in QuickBooks
  12. How to Enter a Credit Memo in QuickBooks
  13. How to QuickZoom on a Report Item in QuickBooks
  14. How to Track Time for a Single Activity in QuickBooks
  15. How to Customize the Icon Bar in QuickBooks
  16. How to Customize Preferences in QuickBooks
  17. How to Create a Memorized Report in QuickBooks
  18. How to Change the Default Sales Tax in QuickBooks
  19. How to Create a Sales Tax Group in QuickBooks
  20. How to Add a Filter to a Report in QuickBooks
  21. How to Perform an Advanced Find in QuickBooks
  22. How to Add Items to the Item List in QuickBooks
  23. How to Close a Company File in QuickBooks
  24. How to Change the Header and Footer in a QuickBooks Report
  25. How to Enter Credit Card Charges in QuickBooks
  26. How to Run a Time Tracking Report in QuickBooks
  27. How to Add Vendors in QuickBooks
  28. How to Select Payments to Include in a Deposit in QuickBooks
  29. How to Apply Sales Tax to an Invoice in QuickBooks
  30. How to Quick Add a Name in a Timesheet in QuickBooks
  31. How to Use the Open Window List in QuickBooks
  32. How to Record and Receive Customer Payments in QuickBooks
  33. How to Track Vehicle Mileage in QuickBooks
  34. How to Reconcile an Account in QuickBooks (this article)
  35. How to Delete a Memorized Transaction in QuickBooks
  36. How to Record a Sales Tax Payment in QuickBooks
  37. How to Create a Memorized Transfer in QuickBooks
  38. How to Set up a Vehicle List in QuickBooks
  39. How to Enable Class Tracking in QuickBooks
  40. How to Set Up a List of Class Items in QuickBooks
  41. How to Edit a Memorized Transaction in QuickBooks