If you use QuickBooks, reconciling your accounts is one of the best ways to catch errors, confirm your balances, and keep your books accurate. It may sound technical, but the process is straightforward once you know what to match and where to look.
This guide explains how to reconcile in QuickBooks step by step, what the reconciliation report means, and how to fix common problems if your accounts do not balance. The goal is simple: make sure your QuickBooks records match your bank or credit card statement.
How To Reconcile In QuickBooks
To reconcile in QuickBooks, compare the transactions in your QuickBooks account with your bank or credit card statement, then mark each transaction as cleared until the difference is zero. Start with the statement ending balance and ending date, review deposits and payments one by one, and finish by saving the reconciliation report.
What reconciliation means in QuickBooks
Reconciliation is the process of checking that the transactions recorded in QuickBooks match the transactions that actually cleared your bank or credit card account. It helps you find missing entries, duplicate transactions, bank fees, and timing differences before they become larger bookkeeping problems.
Why it matters
- It helps you spot errors early.
- It shows whether your cash balance is accurate.
- It makes tax preparation and financial reporting more reliable.
- It can help you notice fraud or unauthorized charges.
Before you start reconciling
Have your bank or credit card statement ready before you begin. You will need the statement ending date, ending balance, and a list of cleared transactions. If you are reconciling a foreign-currency account or an account with fees, make sure you understand how your bank reports those amounts, since exchange rates and charges can affect the balance.
What you need
- Your bank or credit card statement
- Access to QuickBooks Online or QuickBooks Desktop
- The account you want to reconcile
- Time to review transactions carefully
Step-by-step: how to reconcile in QuickBooks
1. Open the reconciliation tool
In QuickBooks, go to the reconciliation area from the accounting or bookkeeping menu. The exact path can vary slightly depending on whether you use QuickBooks Online or Desktop, but the goal is the same: choose the account you want to reconcile.
2. Select the correct account
Choose the bank account, credit card account, or other balance sheet account that matches your statement. Make sure you are using the right account, especially if you have multiple checking accounts, savings accounts, or business credit cards.
3. Enter the statement ending date and balance
Type in the ending date and ending balance from your statement. These numbers should come directly from your bank or card provider. Do not use your current online balance unless it matches the statement date, because pending transactions can make it different.
4. Review the list of transactions
QuickBooks will show the transactions recorded in that account. Compare each item to your statement and mark the ones that cleared. Usually, you will check off deposits, payments, transfers, bank fees, and interest entries that appear on both records.
5. Match transactions carefully
Go line by line and compare dates, amounts, and descriptions. Small differences are common, especially when:
- a transaction posts on a different date than expected
- a deposit was recorded with the wrong amount
- a bank fee or interest charge was missed
- a payment was entered twice
6. Watch the difference amount
QuickBooks will show a difference between your statement balance and the transactions you have marked. Your goal is to bring that difference to zero. If the difference is not zero, something is missing, entered incorrectly, or matched to the wrong account.
7. Finish and save the reconciliation
Once the difference is zero, complete the reconciliation and save the report. This creates a record of the process and gives you a reference point for future bookkeeping reviews.
How to reconcile in QuickBooks Online
In QuickBooks Online, the process is usually done from the Accounting or Bookkeeping section. After selecting the account, you enter the statement information, review the list of cleared transactions, and confirm the reconciliation when the difference reaches zero. If you are new to the platform, it may help to learn the basic layout first using a QuickBooks walkthrough.
Helpful QuickBooks Online habits
- Reconcile monthly, not just once a year.
- Review uncategorized or uncleared transactions before starting.
- Keep bank statements organized by month.
- Use consistent naming for payees and categories.
How to reconcile in QuickBooks Desktop
In QuickBooks Desktop, the reconciliation screen works similarly, but the navigation is different. You still select the account, enter the statement ending balance and date, and then clear each transaction that appears on the statement. The main difference is the layout, not the accounting logic.
Desktop-specific tip
If you use Desktop and the reconciliation seems off, check whether transactions were entered into the correct register and whether any prior reconciliation was changed. Even a small edit to a past transaction can affect later balances.
Common reconciliation problems and how to fix them
The difference is not zero
If the reconciliation does not balance, do not force it to finish. Instead, look for the most common causes:
- a missing transaction in QuickBooks
- a duplicate entry
- a typo in the amount
- a transaction posted to the wrong account
- an uncleared bank fee, refund, or interest item
The ending balance does not match the statement
Double-check that you entered the correct statement ending balance and date. If the statement is correct, the issue is likely in your QuickBooks records. Compare the statement against the register again and look for items that were entered incorrectly or not entered at all.
A transaction appears in QuickBooks but not on the statement
This often means the transaction has not cleared yet, or it was recorded in advance of the bank posting. Leave it unchecked if it truly has not cleared by the statement date. If it should have cleared, contact your bank if needed and review whether the transaction was entered in the correct account.
A transaction appears on the statement but not in QuickBooks
Add the missing transaction to QuickBooks if it is legitimate and belongs in the account. Common examples include bank service charges, automatic interest, card fees, and small adjustments.
Example of a simple reconciliation
Suppose your bank statement shows an ending balance of $5,000 on the last day of the month. In QuickBooks, you find deposits totaling $8,000 and payments totaling $3,200 that match the statement, but there is also a $20 bank fee on the statement that was never entered. If you add that fee correctly, the difference should move closer to zero and the reconciliation can be completed.
This is only an illustration. The exact numbers will depend on your own account activity, and the goal is not to “make the math work” by guessing. It is to make sure every legitimate transaction is recorded accurately.
Best practices for easier reconciliations
Reconcile regularly
Monthly reconciliation is usually easier than waiting several months. The longer you wait, the more transactions you must review and the harder it becomes to trace errors.
Keep business and personal accounts separate
If you run a business, separate accounts make reconciliation much cleaner. Mixing personal and business spending can create confusion, especially when you are trying to categorize expenses correctly.
Review transactions as they are entered
Accurate bookkeeping throughout the month reduces reconciliation problems later. Check payees, dates, amounts, and categories when you enter transactions instead of waiting until month-end.
Save reports and supporting documents
Keep copies of statements, receipts, and reconciliation reports. These records can help you explain differences later and support your books if you need to review past activity.
When to ask for help
If your reconciliation keeps failing, or if you are unsure whether a transaction should be edited, deleted, or reclassified, it may be worth asking a bookkeeper or accountant for help. This is especially useful if the account has many transactions, foreign currency activity, merchant deposits, or prior-period adjustments.
Quick answers to common questions
How often should I reconcile in QuickBooks?
Most users reconcile every month, after the bank or credit card statement closes. Monthly reconciliation is usually the easiest way to keep books accurate and catch mistakes early.
What if I made a mistake in a past reconciliation?
If a past transaction was changed after reconciliation, later balances can be affected. In some cases, you may need to review the prior period and correct the transaction carefully. If you are unsure, get professional help before making changes.
Can I reconcile without a bank statement?
You can review transactions in QuickBooks, but a proper reconciliation should be based on an official statement or equivalent account record. Without it, you may not have a reliable ending balance to compare against.
Final takeaway
Learning how to reconcile in QuickBooks is mostly about careful comparison: statement in one hand, QuickBooks in the other. When you match transactions, resolve differences, and save the report each month, you improve the accuracy of your books and make future bookkeeping much easier. If you want to keep building your QuickBooks skills, you may also find how to use QuickBooks Online and how to unreconcile in QuickBooks Online helpful.