Bank reconciliation in QuickBooks, done to the cent
Reconciliation is how you know the books are complete. I match every bank, credit card and loan account in QuickBooks to its statement, find what is missing or doubled, and leave each month closed with a difference of zero.
- Checking, savings, cards and loans
- Missing and duplicate entries found
- A report for every month

Why your accounts won’t reconcile
If you have tried the Reconcile screen and the difference would not go to zero, there is always a specific reason. These are the usual ones:
- Transactions on the statement that were never entered
- Entries in QuickBooks that never happened at the bank
- A deposit recorded as several payments, or several as one
- An opening balance that was wrong from the first reconciliation
- Previously reconciled transactions that were edited or deleted later
- Bank feed duplicates after an account was reconnected
Forcing the difference through with an adjustment entry hides the problem and carries it into every later month. I find the actual cause instead.
How I handle it, step by step
- Accounts and period
You tell me which accounts and which months. I check when each account was last properly reconciled, because that is where I have to start.
- Statements matched line by line
I compare the statement to QuickBooks for each month and mark what agrees.
- Gaps and doubles fixed
Missing transactions are added, duplicates are removed and wrong amounts or dates are corrected.
- Old reconciliations repaired
If a past reconciliation was broken by later edits, I trace the changed entries and put the month back in balance.
- Month closed
Each month is finished in the Reconcile screen with a zero difference, then I move to the next.
- Reports saved
You get the reconciliation report for every account and month, and a list of any old uncleared items that need a decision from you.
Credit cards and loans count too
Many files have a reconciled checking account and nothing else. Credit cards hold a large share of the expenses, and loan accounts decide how much of each payment is interest. I reconcile all of them, because a Balance Sheet is only right when every account on it agrees with a statement.
Old checks that never cleared? Uncleared items from long ago are common. I list them for you with dates and amounts so you can decide what happened to each one, and I book the result properly.
What I need from you
Accountant access to QuickBooks Online and the statements for each account and month in scope. For loans, the lender’s statement or payment schedule.
Questions about bank reconciliation
How many months can you reconcile at once?
As many as needed. I have reconciled several years across more than one account in a single project. The work always runs month by month in order.
Can you fix a reconciliation that someone else forced?
Yes. I look at the adjustment that was used, find what it was covering and replace it with the correct entries.
Do you need my online banking login?
No. Statements are enough. I never ask for banking passwords.
Want every account to agree with the bank?
Tell me which accounts and how many months. I’ll check where the last good reconciliation was and send a fixed price.
- Free check of your accounts
- Fixed quote per project
- Zero difference on every month closed
Tell me where your books stand
A few details are enough. I’ll reply with what I see and a fixed quote.