Troubleshooting Reconciling in QuickBooks Online: A Guide to Getting That $0.00 Difference
Reconciling your bank or credit card accounts in QuickBooks Online (QBO) is a key part of closing your books and ensuring accuracy. But what happens when the numbers don’t line up? One of the most common challenges is troubleshooting the current reconciling items. The transactions that should or shouldn’t be checked off to match your bank statement.
This blog post walks you through best practices for identifying and resolving reconciling issues using QBO’s built-in tools, filters, and workflows.
What Are Current Reconciling Items?
Once you’ve confirmed the beginning balance and entered the ending balance and date from your bank statement, QBO displays a list of unreconciled transactions up to that statement date. Your job is to compare these with the statement and check off the ones that cleared the bank. The goal: make the difference in the upper-right corner of the reconcile screen reach $0.00.
If everything lines up, great! You’re done. But if there’s a discrepancy, it’s time to start troubleshooting.
Tools to Help You Work Through the Grid
The QBO reconciliation screen gives you several tools to make this easier:
- Column Sorting: Click any column header (Date, Amount, Description, etc.) to sort transactions.
- Cleared Date: If your account is connected to QBO’s bank feed, this shows the actual date the transaction cleared the bank.
- Filters: Use filters to narrow down by date, transaction type, or amount.
- Inline Edits: Click on any transaction to edit details directly or select “Edit” to open the full transaction form.
- Checkboxes: The far-right column lets you mark whether a transaction has cleared and should be included in the reconciliation.
If your QBO account is connected to the bank feed and you used the Banking screen to match or add transactions, many of these will already be marked as “cleared” (checked). Thank you, automation!
Common Scenarios That Cause Reconciling Differences
Let’s go through common situations that could cause the difference not to be zero and how to resolve each.
1. Incorrect Ending Balance or Date
Before anything else, double-check the ending balance and date you entered. If either one is off even slightly, your reconciliation won’t work.
An incorrect ending date might hide transactions that should be included. An incorrect balance will create a difference that’s impossible to close without a fake adjustment.
2. Compare Statement Subtotals
Use the totals on your bank statement to compare the total deposits and total withdrawals with the sub-totals in the reconciliation screen. If one side is way off, that points to where the problem lies.
3. Date Issues: Same-Day and Future-Dated Transactions
Sometimes, transactions on the same day as your statement’s end date appear in QBO but aren’t actually on the statement. This happens most frequently with credit card accounts.
Let’s say your bank statement ends on June 30th, and you processed a credit card payment on June 30th. It shows up in QBO with a matching cleared date. But if that payment didn’t appear on the statement, you need to uncheck it.
Another issue: current-cleared, future-dated transactions. A great example is payroll.
If your payroll was dated July 1 but cleared the bank on June 30, QBO might not show it in the June reconciliation grid unless it’s linked to the bank feed. If it’s not, you’ll need to:
- Adjust the filter to show future-dated transactions.
- Manually check it off if appropriate.
- Or change the transaction date to June 30 (if it aligns with your accounting method).
- Alternatively, you can enter adjusting journal entries to reflect the June withdrawal and reverse it in July.
4. Incorrect Transaction Amounts
The amount you check off in QBO must exactly match the statement. If the difference in your reconciliation equals a transaction amount, you may have found your culprit.
QuickBooks helps automate most of this, but errors can still creep in. For example:
- Transposition errors: If someone typed $202.00 instead of $220.00, the difference of $18.00 is divisible by 9. A classic sign of a transposed digit.
- Interest or fees: These can be missed in non-connected accounts. Make sure you’ve recorded any interest income or bank service charges that appear on the statement.
To fix an incorrect amount, click on the transaction and edit it in place, or open the full form and make the correction.
5. Missed or Incorrectly Coded Transactions
If you’re reconciling a loan account, like a mortgage or line of credit, be careful with payments. These often include both principal and interest. If the interest portion wasn’t recorded, the balance won’t match.
You can fix this by:
- Editing the payment to split it between principal (to the loan account) and interest (to the interest expense account), or
- Creating a journal entry to record the missing interest.
6. When All Else Fails: Start Over or Use a Bank Adjustment
Sometimes the best troubleshooting tool is to simply deselect all checkboxes and start fresh. Go line-by-line with your bank statement in hand, checking off one transaction at a time. Use sorting and filters to speed this up.
If you still can’t locate the difference, and you’ve ruled out errors in QBO, there’s one final possibility: a bank error. In this case:
- Record an adjusting entry for the difference (such as a journal entry with a wash account).
- Check that entry off so you can complete the reconciliation.
- Contact your bank and verify whether they’ll correct it.
- If they do, reverse the adjusting entry on the next statement.
Final Thoughts: Let QBO Help You, But Trust Your Eyes
QuickBooks Online does an excellent job of automating reconciliations, especially when your bank is connected. It pulls in transaction data, matches it, and even checks off cleared items for you.
But no system is foolproof. You still need to review each item, verify dates and amounts, and be prepared to troubleshoot when the math doesn’t work.
By using the tips and strategies outlined here, you can confidently address reconciling issues and bring that difference to zero. Whether it’s a mistyped amount, a transaction that cleared early, or just a simple oversight, you now know how to track it down.
Happy reconciling!
Need help getting QBO set up? Let us know!
