ProAdvisor Prep: Module 3 — Taming the Bank Feed

We’ve made it to Module 3: Managing Banking Feeds.

This is where QuickBooks starts doing some genuinely useful shit for us.

It’s also where clicking buttons without understanding what they’re doing can create an absolutely spectacular mess.

So that’s fun.

In Module 2, we set up our fictional client, cleaned up their incoming data, learned why import order matters, and established one of the guiding principles of this entire series:

Just because software can automate something doesn’t mean you should stop paying attention to it.

That lesson becomes considerably more important here.

Because now we’re connecting the books to the bank.

So What Exactly Is a Bank Feed?

At its simplest, connecting a bank or credit-card account allows QuickBooks to bring transaction information from that financial institution into QBO.

This eliminates a hell of a lot of manual entry.

But here’s the important part:

Imported bank activity is not automatically the same thing as properly recorded accounting activity.

QuickBooks brings you information.

Then you have decisions to make.

Is this a new transaction?

Does it correspond to something already recorded?

What account should it affect?

Is the suggested category correct?

Should it be excluded?

Is QuickBooks trying to match it to the right thing?

The bank feed gives you data.

Your job is to give that data meaning.

And THAT is why we’re learning this instead of just turning on automation and wandering away.

Welcome to the Waiting Room

When transactions arrive through the bank feed, you’ll generally encounter them first in the area awaiting review.

Think of this as QBO saying:

“The bank sent me these. What the hell do you want me to do with them?”

This is where you’ll review transaction details and determine the correct action.

QuickBooks may make suggestions based on information it recognizes and previous activity.

Sometimes those suggestions are helpful.

Sometimes the machine is very confidently full of shit.

Sound familiar?

Look at the transaction.

Look at the payee.

Look at the amount.

Look at the suggested category.

Look at what already exists in the books.

Then decide.

Don’t turn reviewing into clicking.

ADD and MATCH Are Not the Same Damn Thing

This is probably one of the biggest concepts I want firmly lodged in your brain from this module.

ADD

You’re telling QuickBooks:

This bank transaction represents something that isn’t already recorded. Create it in the books.

MATCH

You’re telling QuickBooks:

This bank activity corresponds to a transaction that’s already in the books. Connect them.

That distinction matters.

Imagine your client created an invoice for $1,000 and properly recorded the customer’s payment.

Later, the $1,000 deposit comes through the bank feed.

The income has already been recorded.

If you treat the bank-feed transaction as brand-new income instead of matching it to what already exists, you’ve potentially created a duplicate.

Your books now tell a different story from reality.

And accounting gets rather particular about reality.

Before you click Add, ask yourself:

Could this already exist in QuickBooks?

That one question can save you an impressive amount of bullshit.

What Happens After You Categorize Something?

Once you’ve dealt with a transaction, it moves out of the review queue into the area containing processed/categorized activity.

And thankfully, if you realize:

OH SHIT.

…you aren’t necessarily doomed.

QBO provides ways to undo bank-feed actions and return transactions for review.

This is another reason I want you practicing inside a safe training environment.

Do something.

Watch what happens.

Undo it.

Watch what happens.

Do it again correctly.

That’s infinitely more useful than memorizing:

“Undo means undo.”

No shit.

Learn what actually changes in the books.

And Then We Have Excluded Transactions

Sometimes a downloaded transaction shouldn’t be added to the books from the feed.

That’s where Exclude comes in.

But I don’t want you learning:

“Excluded = trash.”

Because that’s too simplistic.

Excluding tells QuickBooks not to add that downloaded bank-feed item to the books through this workflow.

There can be legitimate reasons for doing that—but you need to understand why you’re excluding something.

Don’t exclude transactions because:

• you don’t recognize them,
• you’re not sure what category to use,
• they look inconvenient,
• or you’re hoping they’ll stop staring at you.

An unfamiliar transaction is a question, not automatically an exclusion.

Investigate first.

BANK RULES: Where We Teach the Machine

Now we’ve arrived at one of the genuinely cool parts.

Bank rules.

Rules allow you to tell QuickBooks how to handle transactions meeting particular conditions.

For example, maybe a business has a recurring software charge from the same vendor every month.

Instead of manually making the same categorization decision repeatedly, you may be able to create a rule that recognizes that transaction and handles part of the work for you.

Excellent.

We like efficiency.

But remember our AI side quest?

Same principle.

USE THE MACHINE. DON’T SURRENDER YOUR BRAIN TO IT.

A poorly designed rule can efficiently categorize a whole bunch of shit incorrectly.

That’s actually worse than making one manual mistake because now you’ve automated your mistake.

Congratulations.

You have achieved scalable incompetence.

😹

So when you create a rule, think about how specific its conditions are.

Ask yourself:

Could something else accidentally satisfy this rule?

If the answer is yes, tighten it.

And be especially thoughtful before allowing rules to automatically add transactions without human review.

Automation is fantastic when you understand exactly what you’ve automated.

The Three Bank-Feed Habits I Want You to Build

1. Look for a Match Before Creating Something New

Before adding a downloaded transaction, check whether the underlying activity already exists.

Existing transaction? Match.

Actually new activity? Then consider adding/categorizing it.

Do not create duplicates just because the Add button looked inviting.

2. Treat QuickBooks Suggestions as Suggestions

QuickBooks can help.

It cannot crawl inside your client’s head and discover what they were doing at Target last Tuesday.

Review the information.

If you’re unsure, investigate.

3. Never Automate Something You Don’t Understand Manually

This one goes beyond QuickBooks.

Before creating a rule to do something repeatedly, make sure you understand how you would handle the transaction yourself.

Then automate the repetition.

Knowledge first. Automation second.

That’s how technology makes you better instead of merely making you faster at being wrong.

Module 3 Scavenger Hunt

You knew this was coming.

Open the practice environment you’re using with your training and find the bank-transaction area.

Your mission:

• Locate transactions waiting for review.
• Find a transaction QBO has suggested a category for.
• Identify where you would change that category.
• Find where QBO offers a possible match.
• Explain to yourself why Match and Add produce different results.
• Find previously processed/categorized bank activity.
• Locate the option for undoing a bank-feed action.
• Find excluded transactions.
• Find the Bank Rules area.
• Explore the conditions available when creating a rule.
• Determine whether automatic processing is optional for the rule you’re creating.

And now the important part:

Pick one transaction and don’t touch it yet.

Look at it and decide what you think should happen.

Then explain why.

Only after you’ve made the accounting decision should you worry about which QuickBooks button performs it.

That’s the habit I want.

Let’s Give Our Fake Client a Banking Problem

Remember Resistance Coffee & Books from Module 2?

Business is booming.

Apparently exhausted accountants really like caffeine and questionable literature.

We already recorded a $75 monthly software expense in QBO.

Now a $75 charge from that same software company appears in the bank feed.

What do you do?

If your immediate response is:

ADD IT!

I am taking your mouse away.

😹

First, investigate whether the downloaded transaction corresponds to the expense already recorded.

If it does, you’re looking for a match, not another expense.

That’s the difference between operating QuickBooks and understanding QuickBooks.

Mini-Quiz: Are We Clicking With Purpose?

Question 1

A $1,200 customer payment was already recorded in QBO. The corresponding $1,200 deposit now appears in the bank feed.

What should you investigate first?

A. Add it as new income
B. Whether QBO can match it to the existing transaction
C. Exclude it because it’s already in QuickBooks

Question 2

QuickBooks suggests that a transaction belongs in Office Supplies.

What does that mean?

A. QBO has made a suggestion you should review
B. QBO has consulted the accounting gods and its decision is final
C. You are legally prohibited from changing it

Question 3

You processed a bank-feed transaction incorrectly.

What’s your next move?

A. Sell the business
B. Investigate the processed/categorized activity and the available undo options
C. Reconnect the bank until reality changes

Question 4

You’ve created a rule that catches transactions from a recurring vendor.

Before allowing it to automatically process transactions, what should you ask?

A. Could this rule accidentally catch transactions I don’t intend it to?
B. Does automatic sound cooler than manual?
C. How quickly can I stop looking at this?

Question 5

You don’t recognize a transaction.

Should you immediately exclude it?

A. Yes
B. No—investigate what it is first
C. Only if it looks expensive

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

If you selected A for Question 1, please report to Gertrude the Sphynx for remedial training.

She looks disappointed in you.

What I Actually Want You to Learn From Module 3

The bank feed isn’t bookkeeping magic.

It’s a tool that brings information to you and makes repetitive work considerably easier.

You are still the decision-maker.

That’s the skill I’m trying to build throughout this entire ProAdvisor series.

Not:

Where is the button?

But:

Why am I pressing it?

When you understand the difference between creating and matching, when you know why something should be excluded, when you can evaluate a suggested category instead of blindly accepting it, and when you can design a useful rule without unleashing automated chaos—

you’re not just learning QBO anymore.

You’re learning to manage the machine.

Which seems rather appropriate around here.

Module 3 Mission

Connect.

Review.

Investigate.

Match before you add.

Use rules carefully.

Undo mistakes and figure out why they happened.

And never confuse automation with understanding.

The machine can bring us the transactions.

The Resistance Accountants still have to know what the hell they mean.

See you in Module 4.