ProAdvisor Prep: Module 4 — Matching, Reconciling & The Glorious $0.00

We’ve arrived at Module 4: Matching and Reconciling Accounts.

And after everything we’ve done so far, this module answers a pretty important question:

How the hell do we know our books are actually right?

In Module 3, bank transactions came pouring into QBO and we learned that automation does not relieve us of the responsibility to use our brains.

We reviewed.

We categorized.

We matched instead of adding duplicates.

We created rules without accidentally building an automated accounting disaster.

Now it’s time to check our work.

That’s reconciliation.

And yes, there is a $0.00 involved.

This may be the first time in my life I’ve been this excited about having absolutely nothing.

What Are We Actually Doing When We Reconcile?

Reconciliation is basically QuickBooks versus reality.

We have the transactions recorded in QBO.

We have the statement from the bank or credit-card company.

Now we’re going to compare them.

Transaction by transaction.

Amount by amount.

Until we can establish that the activity recorded in QuickBooks agrees with the statement for that period.

Intuit’s current guidance describes reconciliation as matching the transactions entered in QBO with the corresponding bank or credit-card statement. Before starting, the transactions for that statement period should already be added and categorized.

That last part matters.

Reconciliation isn’t where we dump a month’s financial chaos and ask QuickBooks to sort it out.

We’ve already been doing the bookkeeping.

Now we’re checking it.

Your First Job: Make Sure You’re Comparing the Right Shit

Before you start checking transactions, QBO needs information from the statement you’re reconciling.

Most importantly:

Which account are we reconciling?

What’s the statement ending date?

What’s the statement ending balance?

And if this account has been reconciled previously:

Does the beginning balance make sense?

Current QBO also shows the last statement ending date so you can confirm that your next statement begins where the previous reconciliation left off.

Take ten seconds here.

Seriously.

Because if the bank statement says:

$5,423.00

and you type:

$5,432.00

you have just purchased yourself a completely unnecessary $9 scavenger hunt.

You can spend the next hour interrogating perfectly innocent transactions.

Or you can check your damn typing first.

I recommend Option B.

And Now We Match

Once the reconciliation begins, compare the transactions in QuickBooks with the transactions on the statement.

See it on both?

Check it off.

See another?

Check it off.

As transactions are selected, QBO updates the cleared balance and the difference.

And our beautiful little destination is:

$0.00

When the difference reaches zero, QBO considers the account balanced for that reconciliation. You can then finish the reconciliation, and QuickBooks saves a reconciliation report that you can access later through the reconciliation history.

But here’s something I want to make very clear:

Your job isn’t to MAKE the screen say $0.00.

Your job is to determine why it says $0.00.

Those are not the same thing.

If you have to invent numbers or force adjustments simply to reach zero, you haven’t successfully reconciled anything.

You’ve decorated the problem.

C, R and Blank

In the account register, QBO uses reconciliation statuses.

Blank = Uncleared

The transaction isn’t currently marked cleared or reconciled.

That’s it.

It does not automatically mean the transaction “hasn’t hit the bank feed yet.”

C = Cleared

The transaction has been marked as cleared.

R = Reconciled

The transaction has been included in a completed reconciliation.

Intuit’s current documentation specifically describes the status cycle as:

R → C → Blank

when manually removing a transaction from reconciliation status.

This is worth understanding because changing a previously reconciled transaction can affect future reconciliations.

Which brings us nicely to…

DO NOT GO FUCKING WITH OLD RECONCILED TRANSACTIONS FOR FUN

An R deserves respect.

If somebody changes, deletes, or otherwise alters something that was already reconciled, the next reconciliation’s beginning balance can be wrong.

Then QBO gets upset.

Then you get upset.

Then somebody eventually says:

“But it balanced last month!”

Exactly.

Something changed.

QuickBooks has a Reconcile Discrepancy Report specifically to help identify changes affecting a previously reconciled account. Current Intuit guidance says it can show what changed, how it affected the balance, and information useful for tracking down the problem.

That’s not an inconvenience.

That’s a clue.

Follow it.

Your Difference Isn’t Zero. Now What?

This is where I want you to resist the temptation to start randomly changing things.

Investigate.

First, check the painfully obvious stuff:

Did you enter the correct ending balance?

Did you enter the correct ending date?

Are you reconciling the correct account?

Is the beginning balance correct?

Did you miss a transaction?

Did something get entered twice?

Is an amount wrong?

Is something dated incorrectly?

Was a transaction changed after a previous reconciliation?

Did the bank combine several payments into one deposit while QBO shows the individual payments separately?

Current Intuit troubleshooting guidance specifically calls out incorrect ending information and situations where the bank combines payments differently from how they’re recorded in QBO.

The difference is telling you something.

Your job is to find out what.

Please Don’t Force It to Zero Just Because You’re Tired

There are legitimate situations where accounting professionals use reconciliation adjustments.

That does not mean:

“I’m off by $37.42, I’ve looked at this for eleven minutes, fuck it.”

An unexplained difference is information.

Maybe something is missing.

Maybe something is duplicated.

Maybe something was changed.

Maybe the beginning balance was already wrong.

Maybe you’re reconciling against incorrect statement information.

Whatever it is, throwing an adjustment at it can hide the underlying problem rather than solve it.

So our Resistance Accountant rule is:

Investigate first. Adjust with an actual reason.

If you don’t understand why an adjustment is appropriate, that’s when you stop and ask someone who does.

That’s not failure.

That’s accounting.

What If I’m Months Behind?

Then we start digging.

If you’re cleaning up an account that hasn’t been reconciled in several statement periods, work from the oldest unreconciled information forward.

Why?

Because reconciliation builds on reconciliation.

The ending balance from one period becomes the foundation for what follows.

Intuit even provides specific guidance for reconciling accounts with multiple months or years of outstanding statements.

Trying to establish April while January through March are still wandering around unsupervised is not the kind of adventure we’re looking for.

Module 4 Scavenger Hunt

You knew damn well there was going to be one.

Using your training/practice environment and your official course materials, see if you can find and explain:

• Where reconciliation currently lives in QBO.
• Where you choose the account you’re reconciling.
• Where the statement ending balance goes.
• Where the statement ending date goes.
• How QBO displays the reconciliation difference.
• What Blank, C, and R mean in the register.
• Where completed reconciliation reports are stored.
• What happens when you remove a reconciled transaction from a reconciliation.
• Where you would investigate a beginning-balance discrepancy.
• How you would determine whether a missing $25 is actually missing before changing anything.

Bonus mission:

Find a transaction marked R.

Don’t touch the motherfucker.

Just admire it.

😹

Resistance Coffee & Books Has Fucked Something Up Again

Our fictional client returns.

Their bank statement says the account ended the month at:

$8,247.32

You’ve entered the statement information correctly and worked through the transactions.

QBO says:

Difference: $24.99

Interesting.

You notice the amount immediately because Resistance Coffee & Books pays $24.99 every month for a software subscription.

What do you do?

A.

Create a $24.99 reconciliation adjustment and go to lunch.

B.

Investigate whether that recurring transaction is missing, duplicated, incorrectly dated, or recorded for the wrong amount.

C.

Change the statement ending balance by $24.99 so QBO stops complaining.

If you picked B, excellent.

If you picked C, Wallace, the German Shepherd would like a word.

If you picked A without investigating first, Gertrude the Sphynx is already on her way to make an oily butt print on your desk.

Mini-Quiz: Can You Make Zero Mean Something?

Question 1

What is the goal of reconciliation?

A. Make QBO display $0.00 by any means necessary.
B. Compare QBO activity with the statement and resolve differences until the account legitimately balances.
C. Check at least 50 transactions because accounting enjoys arbitrary numbers.

Question 2

A transaction displays R in the register.

That means:

A. Reviewed
B. Reconciled
C. Really fucking important

Technically B.

Emotionally, C has merit.

Question 3

Your reconciliation is off by $9.

What’s the first thing you should do?

A. Create an adjustment.
B. Start deleting transactions.
C. Verify the account, statement date, ending balance, and other basic inputs before hunting deeper.

Question 4

Your beginning balance doesn’t match the ending balance from the previous reconciliation.

What does that suggest?

A. Something affecting previously reconciled activity may have changed and needs investigation.
B. QBO has become sentient.
C. Change the beginning balance until it looks nicer.

Question 5

You’ve found a transaction that was reconciled incorrectly.

Should you start changing reconciliation statuses without considering what comes afterward?

A. Absolutely. Chaos builds character.
B. No. Understand the effect and reconcile correctly afterward.
C. Only on Fridays.

Answers: B, B, C, A, B.

What I Actually Want You to Learn From Module 4

Getting to $0.00 feels good.

But zero isn’t the skill.

Understanding why you’re at zero is the skill.

Reconciliation is one of those places where the human still matters enormously.

Software can compare numbers.

It can download transactions.

It can suggest matches.

Current QBO can even offer AI-assisted reconciliation features in some workflows.

Fine.

Use the tools.

But when something doesn’t agree, somebody still needs to understand enough about the books to ask:

Why?

That’s what we’re building here.

Not humans who know how to make QuickBooks stop displaying an error.

Humans who can look at a discrepancy and investigate what happened.

Module 4 Mission

Get the statement.

Verify your starting information.

Compare the transactions.

Investigate the difference.

Respect the R.

Don’t manufacture a zero.

And when you finally reach a legitimate:

$0.00

Enjoy that shit.

You earned it.

See you in Module 5, Resistance Accountant.

*For the current official workflow alongside the tutorial, here’s Intuit’s reconciliation guide.