Reconcile Bank Accounts in QuickBooks Online

Reconciling your bank accounts in QuickBooks Online ensures your records match your actual bank statement, catching errors, missing transactions, and fraudulent charges early. This guide walks you through the built-in reconciliation tool, from opening it to resolving discrepancies.

What You’ll Need

• Your latest bank or credit card statement (PDF or paper).
• Access to QuickBooks Online as an admin or with accountant permissions.
• All recent transactions already entered or downloaded into QuickBooks.

Step-by-Step

1. Open the Reconciliation page. Go to the Gear icon (top right) → Tools → Reconcile. If you don’t see it, go to Accounting → Reconcile.
2. Select the account. In the Account dropdown, choose the bank or credit card account you want to reconcile.
3. Enter statement details. Type the Ending balance and Ending date from your statement. If there are any service charges or interest earned, enter those amounts and the dates they appear on the statement. QuickBooks will add them as transactions.
4. Click “Start reconciling.” The reconciliation window opens, showing all transactions that have cleared (marked with a checkmark) and those that haven’t.
5. Match transactions. Go through your statement line by line. Click the checkbox next to each transaction in QuickBooks that appears on your statement. If a transaction is missing, add it by clicking Add and entering the details. If the amounts differ, edit the transaction or note the discrepancy.
6. Watch the difference. The Difference field at the bottom shows the amount you’re off. Your goal is to get this to $0.00.
7. Finish when the difference is zero. Once every cleared transaction is checked and the difference is $0.00, click Finish now. QuickBooks will lock those transactions and generate a reconciliation report.
8. Review the report. Save or print the report for your records. It shows the starting balance, cleared transactions, and ending balance.

Common Mistakes

• Entering the wrong ending balance. A simple typo can cause a huge difference. Double-check the number.
• Missing bank fees or interest. If you don’t enter service charges, they’ll cause a permanent difference.
• Checking transactions that haven’t cleared. Only check items that appear on the statement. Pending transactions should remain unchecked.
• Deleting transactions instead of correcting. Deleting can mess up your books. Edit or void instead.
• Reconciling too often or too rarely. Monthly is best; doing it weekly can be overkill, but waiting months makes it harder.

Tips

• Use the “Hide transactions below the $0.01” option to focus on real differences.
• Sort transactions by date or amount to match your statement more easily.
• Reconcile in a quiet environment to avoid mistakes.
• If you have many transactions, do it in batches — reconcile a partial period, then the rest.
• Keep all reconciliation reports in a dedicated folder for audits.

Troubleshooting

Difference won’t go to zero: Start by checking the ending balance and dates. Then look for transactions that are in QuickBooks but not on the statement (or vice versa). Use the Locate button to find a specific transaction. If you’re still stuck, you can Undo the reconciliation and start over.

Missing transactions: If a transaction isn’t in QuickBooks, add it manually. If it’s a bank fee, add it as a Bank Service Fee expense. For interest, create an Interest Earned income account.

Amounts don’t match: Compare the transaction in QuickBooks with the statement. If the amount is wrong, edit it. If it’s a duplicate, void the extra one.

You accidentally finished with a difference: QuickBooks allows you to finish even if the difference isn’t zero, but it creates an adjustment transaction. To fix, go to Accounting → Reconcile → History, find the reconciliation, and select Undo.

Frequently Asked Questions

Q: How often should I reconcile?
A: Monthly, right after your statement arrives. This keeps errors manageable.

Q: What if my bank statement doesn’t match at all?
A: Check for missing transactions, incorrect amounts, or a wrong starting balance. If you’re truly stuck, contact your accountant or QuickBooks support.

Q: Can I reconcile an account with a negative balance?
A: Yes, just enter the negative ending balance. QuickBooks handles it.

Q: What does “cleared” mean?
A: It means the transaction has appeared on your bank statement, so it’s confirmed by the bank.

Q: Can I undo a reconciliation?
A: Yes, go to Accounting → Reconcile → History, select the reconciliation, and click Undo. This reopens the period for editing.

Q: What if I find a transaction that was already reconciled but shouldn’t have been?
A: Undo the reconciliation for that period, fix the transaction, and re-reconcile.

Related

• Payment Gateway Companies: What Evidence Supports
• 3D Printing Nuclear Reactor Components: How-To
• EA Lays Off Employees, Cancels Respawn Star Wars Shooter?