Bank Reconciliation

Bank Reconciliation

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
Calculator on a bank statement
Difference: $0.00on every account I close

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

  1. 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.

  2. Statements matched line by line

    I compare the statement to QuickBooks for each month and mark what agrees.

  3. Gaps and doubles fixed

    Missing transactions are added, duplicates are removed and wrong amounts or dates are corrected.

  4. Old reconciliations repaired

    If a past reconciliation was broken by later edits, I trace the changed entries and put the month back in balance.

  5. Month closed

    Each month is finished in the Reconcile screen with a zero difference, then I move to the next.

  6. 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.

FAQ

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.

Work with me

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.

Your details stay private. I reply within one business day.