Module 3: Transaction Categorization

Where we are in the workflow: Invoice it → Track it → Collect it → Categorize it → Reconcile it → Report it. In Module 2 you recorded what customers owe and pay. Now you record everything else that happens in the bank account.

Module goal: You will be able to work through a client's bank feed accurately and efficiently. That means knowing whether each line should be matched, categorized, transferred, split, or held for a question. You will also be able to clean up uncategorized items and automate the routine ones with bank rules.

Running case continues: It is the end of September, and Bright Path Cleaning Co.'s bank feed is full of unreviewed transactions. Dana Reyes says, "I'm not sure what half of these are. Can you just make them right?"

Key Terms for This Module

• Bank feed: the stream of transactions imported from the bank, waiting for review.
• Match: linking a feed line to a transaction that already exists in QBO.
• Categorize (Add): creating a new transaction in QBO from a feed line and assigning it to an account.
• Payee: the customer or vendor on the transaction.
• Transfer: money moving between the client's own accounts. It is neither income nor an expense.
• Owner transaction: money the owner puts in or takes out. It is equity, not income or expense.
• Split: dividing one bank transaction across several accounts.
• Bank rule: a saved instruction that categorizes future matching transactions automatically.

Lesson 3.1: The Bank Feed

Learning Objectives

• Explain what the bank feed is, and what "for review" means.
• Use a consistent decision process for every transaction.
• Process a feed in an efficient order.
• Escalate unclear transactions to the client properly.

Content and Theory

In Lesson 1.5 you connected the bank. The feed brings in raw bank data. But a transaction sitting "for review" is not yet in the books. It is only in a waiting room. Your reports, including the P&L, only reflect transactions once they have been accepted, either by matching them to an existing entry or by adding them with a category.

The Banking page usually has tabs for For review, Categorized (or Reviewed), and Excluded. Exact labels vary by version.

The five-question decision process. For every line, ask in this order:

1. Is this a customer payment for something already invoiced, or a deposit I've already recorded? If yes, match it (Lesson 3.2).
2. Is this money moving between the client's own accounts? (Savings, credit card payment, and so on.) If yes, record a transfer (Lesson 3.5).
3. Is this the owner putting money in or taking money out? If yes, it is an owner transaction, which is equity (Lesson 3.6).
4. Is this a loan? Money borrowed or a loan payment is a liability, and the interest portion is an expense.
5. Otherwise, is it income or an expense? Then choose the right category (Lessons 3.3 and 3.4).

If you can't answer with confidence, don't guess. Hold the item and ask the client (Lesson 3.8).

Recommended processing order (this saves time and prevents errors):

1. Matches first: deposits and payments that already exist in QBO.
2. Transfers: between the client's own accounts.
3. Rule-friendly items: repeat vendors you can categorize with confidence.
4. Everything else: categorize manually.
5. Questions: collect the unknowns into one list for the client.

Step-by-Step Walkthrough

1. Go to Banking (Transactions) and select the account, such as Business Checking (…4417).
2. Open the For review tab and note the count and the date range.
3. Sort by date and work from oldest to newest, so dates and balances stay logical.
4. Expand a transaction. Check the date, description, and amount, and look at whether QBO suggests a match or a category.
5. Apply the five-question decision process, then click Match, Add, or the appropriate option.
6. Fill in the Payee, Category, and (if useful) Memo.
7. Use batch actions for groups of similar, confirmed items, but only after you've checked each one.
8. When you finish, open the Categorized tab and spot-check a sample of what you did.
9. Send the client your list of questions (use the Client Question Log template).

Real-World Example

Bright Path's checking feed has 21 transactions "for review" for September.

Solution breakdown:

• Three are deposits or payments that already exist from Module 2, so they are matches.
• Two are transfers (a credit card payment and a savings transfer).
• One is Dana putting money into the business, which is an owner transaction.
• Four are recurring subscriptions and bills, which are rule candidates.
• Two have no information at all, so they go on the question list.
• The rest are ordinary expenses, income, or splits.

Sorted this way, a "messy" feed becomes a set of small, clear decisions.

Best Practices and Common Pitfalls

• ✅ Work in a consistent order every time. A routine prevents missed items.
• ✅ Always fill in the Payee. It makes reports and rules far more useful.
• ✅ Only accept a QBO-suggested category if you understand why it fits. QBO learns from past entries, including past mistakes.
• ⚠️ Never use "Accept all" on a batch without reviewing each line.
• ⚠️ Don't use Exclude as a shortcut for "I don't know what this is." Excluded transactions never reach the books, and they create differences during reconciliation. Use it only for true duplicates or items you've confirmed don't belong, and document why.
• ⚠️ Don't process transactions dated before the books' start date or before a closed period.

Tool Translation: In Xero, statement lines appear in the Reconcile tab, where you use Find and Match, Create, or Transfer for each line.

Sheets companion: A "Categorization Cheat Sheet" with the five-question process at the top and a list of the client's common vendors and their categories.

Lesson 3.2: Match vs. Categorize

Learning Objectives

• Distinguish matching from categorizing.
• Identify when a feed line already exists in QBO.
• Avoid the duplicate-income and duplicate-expense errors that come from choosing wrong.

Content and Theory

This is the most important skill in bookkeeping software, and the biggest source of beginner mistakes.

• Match means: "This feed line is the bank's record of something I've already entered in QBO." QBO links them. No new transaction is created.
• Categorize (Add) means: "This is brand new. Nothing in QBO represents it yet." QBO creates a new transaction and posts it to the account you choose.

If you add something that should have been matched, the transaction exists twice. If it was income, revenue is overstated. If it was an expense, costs are overstated.

When to match:

• A deposit that groups customer payments you recorded (Lesson 2.3).
• A payment you already recorded by hand, such as a check written in QBO.
• A refund you already entered as a Refund Receipt (Lesson 2.6).
• A transfer you've already recorded from the other account's side.
• A bill payment you already entered.

When to categorize/add:

• Card purchases, subscriptions, and bank fees that nobody entered manually.
• Deposits with no invoice, sales receipt, or payment behind them.
• Owner contributions and draws.

How QBO helps: It looks for existing transactions with a similar amount and date and suggests a match. It can also show a Find match option so you can search manually. Read the suggestion. Just because QBO proposes a match doesn't mean it's the right one.

Rule of thumb: If a customer payment or invoice is involved, check for an existing payment or deposit before you categorize anything as income.

Step-by-Step Walkthrough

Matching a deposit

1. Open the deposit line in the feed. If QBO shows a suggested match, click it and compare the amount, date, and payee/customer to the feed line.
2. If the details agree, click Match.
3. If there is no suggestion but you know the payments are in Undeposited Funds, create a Bank deposit that totals exactly the feed amount (Lesson 2.3), then match.
4. If the amounts don't agree, don't force it. Use Find match and investigate the difference.

Undoing a wrong decision

1. Open the Categorized tab and find the transaction.
2. Choose Undo. If it was matched, the link is removed and the original transaction stays. If it was added, the new transaction is removed.
3. Redo it correctly.

Real-World Example

The feed shows a $1,450 deposit on September 23. In Module 2, you already recorded Harper's $1,350 and Ramon Lopez's $100 payments and grouped them into a $1,450 Bank Deposit.

Solution breakdown:

• Correct: Match the feed line to the existing $1,450 bank deposit. Income is unchanged (it was recorded on the invoices).
• Wrong: Add the deposit and categorize it as "Residential Cleaning Income." The $1,450 is now counted as income again, and A/R still shows the invoices as open or as paid twice. A/R and income are both wrong.

Best Practices and Common Pitfalls

• ✅ Before adding any deposit, ask: "Is there an invoice, payment, sales receipt, or bank deposit for this?"
• ✅ Check that amounts match to the cent before you accept a match.
• ✅ If several deposits look similar, compare dates and payee names.
• ⚠️ Don't match a feed line to the wrong transaction just because the amounts happen to be equal.
• ⚠️ Watch for the same expense appearing twice: once entered manually and once from the feed. Match, don't add.
• ⚠️ If you find that income is doubled, fix it by undoing the wrongly added transaction. Don't "reduce" income with a journal entry.

Tool Translation: In Xero, the Match tab links a statement line to an existing invoice payment or bill. Create makes a new transaction.

Sheets companion: A "Match or Add?" one-page flowchart students keep beside them while working.

Lesson 3.3: Categorizing Income

Learning Objectives

• Correctly categorize money coming in.
• Separate true income from deposits that are not income.
• Record income that has no invoice.

Content and Theory

Not every deposit is income. This is one of the most common errors in small-business books, and it makes a business look more (or less) profitable than it is.

What a deposit might be:

• Customer payment on an invoice: match it (Lesson 3.2). Income was already recorded.
• Sale with no invoice: a customer who paid the same day. This is income, ideally entered as a Sales Receipt so the customer and item are recorded, or categorized to the right income account with the payee filled in.
• Owner contribution: the owner moved personal money in. This is equity, not income.
• Loan proceeds: this is a liability, not income.
• Transfer from another account: not income (Lesson 3.5).
• Vendor refund: a refund of something the business bought. It reduces that expense, so categorize it to the original expense account rather than income.
• Interest earned: income, categorized to Interest Income.
• Sales tax collected: if the client collects sales tax, it is owed to the government and is a liability, not income.

Rule: Income is money earned by delivering the business's goods or services (or interest). Everything else that lands in the bank is something different.

Step-by-Step Walkthrough

Categorizing a same-day sale with no invoice

1. Open the deposit line in the feed. Confirm there is no matching invoice, payment, or deposit.
2. Ask Dana (or check her notes) what the deposit was for.
3. Preferred: create a Sales Receipt for the customer with the correct item, then match the feed line to it.
4. Alternative: click Add as a deposit, select the customer as Payee, and choose the correct income account. Add a memo.

Categorizing interest

1. Select Add and choose Interest Income as the category.
2. Create a rule if it will recur (Lesson 3.9).

Real-World Example

Bright Path's feed contains three deposits that are not customer invoice payments: (1) a $150 Zelle from "K Okafor," (2) a $2,000 Zelle from "D Reyes," and (3) $0.87 of interest.

Solution breakdown:

• K Okafor $150: Dana says it was a same-day cleaning with no invoice. This is real income. Enter it as a Sales Receipt (or add it as a deposit to Residential Cleaning Income).
• D Reyes $2,000: Dana moved money from her personal savings. This is an owner contribution, categorized to equity (Lesson 3.6), not income.
• Interest $0.87: categorize to Interest Income.

If Dana's $2,000 had been booked as income, her September profit would have looked $2,000 better than reality.

Best Practices and Common Pitfalls

• ✅ Always identify the source of a deposit before choosing a category.
• ✅ Prefer a Sales Receipt for same-day sales, since it keeps customer and item detail.
• ✅ Ask the client whether they collect sales tax, and handle it separately if they do.
• ⚠️ Never categorize a loan, a transfer, or an owner deposit as income.
• ⚠️ Don't categorize a vendor refund as income. Reduce the expense.
• ⚠️ Watch for unlabeled payments (like Zelle, Venmo, and PayPal) that are easy to misclassify.

Tool Translation: In Xero, a deposit with no invoice is created as a receive money transaction with the right account code.

Sheets companion: A "What Kind of Deposit?" checklist using the list above.

Lesson 3.4: Categorizing Expenses

Learning Objectives

• Choose the correct expense category using clear reasoning.
• Recognize expenses that need special treatment, like loan payments and large equipment.
• Handle vendors and payees consistently.

Content and Theory

An expense is a cost of running the business. Accurate expense categories matter because they affect profit, taxes, and the client's decisions.

How to choose a category:

1. Ask what the money was for, not just who was paid. "Amazon" could be cleaning supplies, office supplies, or a personal purchase.
2. Use the client's own chart of accounts (Lesson 1.4) and pick the closest existing category before creating a new one.
3. Be consistent. The same vendor and purpose should always land in the same category.
4. If unsure, ask.

Common expense types for a service business like Bright Path:

• Cleaning Supplies: products and equipment consumed in the work.
• Vehicle: Fuel: gas for work travel.
• Insurance: business liability and similar coverage.
• Software and Subscriptions: for example, Adobe or scheduling tools.
• Advertising and Marketing: online ads, flyers, and promotions.
• Utilities (Phone): business phone service.
• Contract Labor: paying independent helpers.
• Bank Charges: monthly service fees.

Special cases:

• Loan payments: only the interest is an expense. The principal reduces the loan liability. Split it using the lender's statement (Lesson 3.7).
• Large equipment or vehicle purchases: these may need to be recorded as a fixed asset rather than an immediate expense. Ask the client's tax preparer.
• Personal purchases: not business expenses. They are owner draws (Lesson 3.6).
• Credit card payments: not an expense. The expenses were recorded when the card was used (Lesson 3.5).
• Sales tax and payroll taxes: these usually have their own accounts. Ask before categorizing.

Step-by-Step Walkthrough

1. Expand the feed line and click Add (or review the suggestion).
2. Set or confirm the Payee. Pick from the vendor list rather than typing a new variation of the name.
3. Choose the Category that matches the purpose.
4. Add a short memo for anything unusual ("Cleaning cloths, receipt confirmed").
5. Click Add.
6. For vendors you see every month, note them as rule candidates (Lesson 3.9).

Real-World Example

Bright Path's feed shows: SUNSET CLEANING SUPPLY $212.40, SHELL OIL $48.20, STATE FARM INS $96.00, VERIZON WIRELESS $82.15, FACEBK ADS $75.00, MONTHLY SERVICE FEE $15.00, and AMAZON MKTPLACE $63.98 (Dana says cleaning cloths).

Solution breakdown:

• Sunset Cleaning Supply: Cleaning Supplies
• Shell Oil: Vehicle: Fuel
• State Farm: Insurance
• Verizon: Utilities: Phone
• Facebook Ads: Advertising and Marketing
• Monthly service fee: Bank Charges
• Amazon: Cleaning Supplies, but only because Dana confirmed what it was. Without that, it would go on the question list.

Best Practices and Common Pitfalls

• ✅ Categorize based on purpose, and keep a note of how you decided.
• ✅ Ask for receipts on unclear or large purchases. Store them in the client's cloud folder.
• ✅ Keep vendor names consistent so reports group correctly.
• ⚠️ Don't dump uncertain items into "Miscellaneous." It hides problems.
• ⚠️ Don't categorize by vendor alone. Big-box stores and online marketplaces sell everything.
• ⚠️ Avoid creating a new expense account for every one-off purchase.

Tool Translation: In Xero, choose an account code for each spend money line, with a contact as the payee.

Sheets companion: A "Vendor to Category Map" listing each recurring vendor and its default category.

Lesson 3.5: Transfers

Learning Objectives

• Recognize transfers between the client's own accounts.
• Record credit card payments and savings transfers correctly.
• Avoid double-counting expenses when paying a credit card.

Content and Theory

A transfer moves money from one of the client's accounts to another. It changes where the money is, but not how much the business has, and it is neither income nor an expense.

Common transfers:

• Checking to savings (and back).
• Checking to pay the business credit card.
• Moving money between two bank accounts.
• Payouts from a payment processor, when the processor is set up as its own account.

The two-sided nature of transfers. A transfer appears on both accounts. If Dana pays $350 from checking to her Visa, the checking feed shows money out and the Visa feed shows a payment received. In the books there should be one transfer that touches both. Recording it twice, or recording either side as an expense or income, produces errors.

Why credit card payments are not expenses: The expense was recorded when the card was used. Paying the card bill only reduces the card liability and reduces the bank. Counting the payment as an expense too would double-count every purchase.

Step-by-Step Walkthrough

Recording a credit card payment

1. In the checking feed, open the line "ONLINE PMT TO VISA …8821."
2. Choose Add as a Transfer (or the "Record as transfer" option, depending on your version).
3. Set the destination account to the Business Visa.
4. Save it.
5. In the Visa feed, find the "PAYMENT THANK YOU" line. QBO should suggest a match to the transfer you just made. Confirm the amount and date, then Match.

Recording a savings transfer

1. Open the line "ONLINE TRANSFER TO SAV …9902."
2. Add it as a Transfer to the Business Savings account.
3. When the savings feed shows the matching deposit, match it to the transfer.

Real-World Example

Bright Path's checking feed shows a $350 payment to the Visa on September 8 and a $500 transfer to savings on September 16. The Visa feed shows a $350 payment credit on September 8.

Solution breakdown:

• The $350 goes in as a transfer from checking to the Visa, and the Visa line is matched to it.
• The $500 goes in as a transfer from checking to Business Savings.
• Neither affects the P&L.
• Common error: categorizing the $350 as "Credit Card Payment" expense, or categorizing the Visa's $350 credit as income. Each mistake distorts profit.

Best Practices and Common Pitfalls

• ✅ Connect all of the client's accounts to feeds where possible, so both sides of a transfer are visible.
• ✅ After processing, confirm the transfer shows in both registers.
• ⚠️ Never categorize a transfer as an expense or as income.
• ⚠️ Watch for transfers that show on only one side because the other account isn't connected. Note them and check the second account's statement.
• ⚠️ Transfers to personal accounts are not transfers. They are owner draws (Lesson 3.6).

Tool Translation: In Xero, use the Transfer tab when reconciling so the transaction posts once and appears on both bank accounts.

Sheets companion: A "Transfer Tracker" listing each transfer's date, amount, from-account, and to-account, so nothing is left one-sided.

Lesson 3.6: Owner Transactions

Learning Objectives

• Distinguish owner contributions and draws from income and expenses.
• Handle personal expenses paid from business accounts, and business expenses paid personally.
• Understand why the client's business structure changes the account names, and when to involve the tax preparer.

Content and Theory

The owner's money and the business's money are different. When they mix, the books need a clear way to show it.

• Owner contribution (investment): the owner puts personal money into the business. It increases equity.
• Owner draw (or distribution): the owner takes money out of the business for personal use. It decreases equity.

Neither one goes on the P&L. They are on the Balance Sheet in the equity section.

Account names depend on the business structure:

• Sole proprietor or single-member LLC: commonly Owner's Investment and Owner's Draw.
• Partnership or multi-member LLC: Partner (or Member) Contributions and Draws, tracked per person.
• Corporation: Shareholder Distributions or Dividends, and owner pay often runs through payroll. This needs guidance from the tax preparer.

Always ask the client what their business structure is and check with their tax preparer if you are unsure.

Common mixed situations:

• Personal purchase on a business account: categorize it as an owner draw, not as an expense.
• Business purchase on the owner's personal card: the business owes the owner, or the owner is contributing. The tax preparer or client should decide how to record it. Keep the receipt.
• Owner loans to the business: a loan from the owner is a liability, not a contribution. Ask the client which it is, because it changes the balance sheet.
• Mixed purchases (business and personal in one): split it (Lesson 3.7).

Step-by-Step Walkthrough

Owner contribution

1. In the feed, open the deposit (for example, "ZELLE FROM D REYES $2,000").
2. Confirm with the client what it was.
3. Click Add as a deposit, choose the owner as payee, and select Owner's Investment (equity).
4. Add a memo: "Owner contribution for cash flow."

Owner draw

1. Open the outgoing line that is personal.
2. Click Add and select Owner's Draw as the category.
3. If it was mixed, use a split (Lesson 3.7).

Real-World Example

Dana moved $2,000 from personal savings to the business account on September 6. Separately, she made a $186.00 Costco purchase that included $56.00 of personal groceries. She also took a $100 ATM withdrawal and didn't say what it was for.

Solution breakdown:

• The $2,000 goes to Owner's Investment. It is not income.
• The Costco purchase is split: $130.00 to Cleaning Supplies and $56.00 to Owner's Draw (Lesson 3.7).
• The $100 ATM withdrawal goes on the question list. If it was personal cash, it becomes an Owner's Draw. If it was cash for a business expense, ask for the receipt.

Best Practices and Common Pitfalls

• ✅ Ask about the business structure early, and record the right account names for it.
• ✅ Encourage the client to keep personal and business money separate. A dedicated business account and card make categorizing much easier.
• ⚠️ Never book a personal expense as a business expense. It can create tax problems for the client.
• ⚠️ Don't assume an owner deposit is a contribution. It might be a loan.
• ⚠️ Don't decide the tax treatment of owner pay for corporations yourself. Involve the tax preparer.

Tool Translation: In Xero, use equity accounts such as Owner Funds Introduced and Owner Drawings.

Sheets companion: A one-page "Client Entity Type and Owner Accounts" sheet completed at onboarding.

Lesson 3.7: Splits

Learning Objectives

• Identify transactions that must be split.
• Split a transaction across multiple categories, and make sure the parts add up.
• Record loan payments correctly.

Content and Theory

Sometimes one bank transaction belongs in more than one account. QBO lets you split it so the total matches the bank exactly, while each part lands where it belongs.

Common reasons to split:

• Mixed business and personal purchase: business part to the expense, personal part to Owner's Draw.
• Loan payment: the principal goes to the loan liability, and the interest goes to Interest Expense.
• Different expense types on one receipt: for example, cleaning supplies and office supplies on one store purchase.
• Payment processor deposits: gross sales, less fees, equals the deposit received.
• Payments that include tax or tips.

The golden rule of splits: the parts must add up to the exact bank amount. If they don't, QBO will not let you save, or your books won't tie to the bank later.

Step-by-Step Walkthrough

1. Open the feed line and click Split.
2. Enter the first part: category and amount.
3. Add another line for each additional part.
4. Check that the total of all parts equals the bank amount. QBO usually shows how much is left to allocate.
5. Add a memo for each part where helpful.
6. Click Add to save.

Real-World Example

Example 1: The $186.00 Costco purchase. Dana says $56.00 was personal groceries.

• Line 1: Cleaning Supplies, $130.00
• Line 2: Owner's Draw, $56.00
• Total: $186.00, which matches the bank.

Example 2: A $425.00 loan payment to First State Bank. The loan statement shows $360.00 principal and $65.00 interest.

• Line 1: Loan Payable (liability), $360.00
• Line 2: Interest Expense, $65.00
• Total: $425.00.

Without the split, the whole $425 would be an expense (overstating costs) or the whole $425 would reduce the loan (understating costs). Both are wrong.

Best Practices and Common Pitfalls

• ✅ For loan payments, get the split from the lender's statement each month. Amounts change as the loan balance falls.
• ✅ Ask the client for the breakdown of mixed purchases. Don't estimate.
• ✅ Create a bank rule with a split when the pattern is fixed and repeats (Lesson 3.9).
• ⚠️ Don't split a transaction just to avoid deciding. Every part needs a real reason.
• ⚠️ Don't forget to check that the split total equals the bank total.
• ⚠️ Don't put the full loan payment into an expense account.

Tool Translation: In Xero, use Split when creating a transaction during reconciliation, or add multiple lines on a spend money entry.

Sheets companion: A "Split Log" for repeated splits (such as loan payments), with the monthly principal/interest breakdown.

Lesson 3.8: Uncategorized Transactions

Learning Objectives

• Explain what uncategorized transactions are and why they're a problem.
• Find and clear uncategorized items in the books.
• Hold unclear items properly and get answers from the client.

Content and Theory

QBO uses default catch-all accounts when a transaction is posted without a real category: Uncategorized Income, Uncategorized Expense, and Uncategorized Asset. They also appear from imports, old entries, and matches gone wrong.

Why they matter: Uncategorized amounts make the P&L unreliable. Income and expenses are sitting in the wrong place, so profit may be misstated and the client can't see where money is really going. An accountant or tax preparer will refuse to rely on a file with large uncategorized balances.

Where uncategorized items come from:

• Accepting a transaction in a hurry.
• Bulk-accepting a feed without reviewing.
• Imported data with no category.
• Old transactions the client entered themselves.

Two kinds of "unknown":

• Unknown to you, but the client knows. Ask.
• Unknown to everyone. Ask for a statement, receipt, or other proof. If nothing can be found, discuss with the client and their tax preparer how to record it.

Holding accounts: While waiting for an answer, some bookkeepers post a question item to a temporary account such as Ask My Accountant (which exists in many QBO files) or a custom Questions for Client account. Make the rule clear: it must be cleared to zero at every month-end (Module 5). It is a waiting room, not a permanent home.

Step-by-Step Walkthrough

Find uncategorized items

1. Run the Profit and Loss for the period and look for balances in Uncategorized Income, Uncategorized Expense, and any holding accounts.
2. Open the Chart of Accounts and click Run report beside each uncategorized account, or run Transaction Detail by Account.
3. List every transaction: date, payee, amount.

Clear them

1. Open each transaction and change the category to the correct account. Some versions also offer a bulk Reclassify transactions tool for accountants. Use it carefully.
2. For transactions you can't identify, fill in the Client Question Log: date, amount, description, and your question.
3. Send the log to the client in one message. Don't send single questions every day.
4. Apply their answers, and note the answers in the memo field.
5. Re-run the P&L and confirm the uncategorized balances are zero.

A good client question names the transaction and offers options:

"Hi Dana, two items I need your help with. (1) Sept 15, Venmo payment, $150.00. What was this for? (2) Sept 26, ATM withdrawal, $100.00. Was this personal, or for a business expense? If it was for the business, could you send the receipt? Thanks!"

Real-World Example

Bright Path's P&L for September shows $150 in Uncategorized Expense (a Venmo payment) and $100 in Uncategorized Expense (an ATM withdrawal).

Solution breakdown:

• Move both items to a holding account (or leave them out of the "accepted" list) and send Dana the question above.
• Dana replies: "The Venmo was my Saturday helper, and the ATM cash was for me." So the Venmo goes to Contract Labor and the ATM withdrawal to Owner's Draw.
• Re-run the P&L. Uncategorized Expense is now $0.

Best Practices and Common Pitfalls

• ✅ Aim for zero uncategorized balances at every month-end.
• ✅ Batch your questions into one clear message with dates and amounts.
• ✅ Record the client's answer in the memo so there's an audit trail.
• ⚠️ Don't let questions pile up for months. Old transactions are harder to remember.
• ⚠️ Don't guess to make the balance zero. An honest question beats a wrong category.
• ⚠️ Don't leave a holding account with a balance and call it "done."

Tool Translation: In Xero, unreconciled or unexplained items can be handled with the Discuss tab, and a suspense-type account is used as a temporary holding place.

Sheets companion: The Client Question Log template: date, description, amount, question asked, date sent, client answer, and category applied.

Lesson 3.9: Bank Rules

Learning Objectives

• Explain what bank rules do and when they help.
• Create a rule with the right conditions and actions.
• Decide when a rule is a bad idea.
• Maintain rules over time.

Content and Theory

Bank rules tell QBO how to handle future feed transactions that meet certain conditions. Instead of categorizing the same Adobe charge every month, a rule can categorize it for you.

A rule has two parts:

• Conditions: what the transaction must look like, such as description contains "ADOBE," money out, and from a certain account.
• Actions: what QBO should do, such as set the transaction type, payee, category, memo, or even a split.

Auto-add or review? Many versions let a rule either automatically add transactions or only suggest them for you to review. As a beginner, start with suggest and review. Only turn on auto-add for rules you have watched work correctly for several months.

Good candidates for rules:

• Fixed subscriptions and bills (software, insurance, phone).
• Bank fees and interest.
• Recurring loan payments with a fixed split (with care as the split changes).
• Regular transfers between the client's accounts.

Bad candidates for rules:

• Vendors that sell everything, such as Amazon, Walmart, Costco, and Target.
• Deposits from customers (they should be matched to invoices).
• Anything where the category changes month to month.
• Personal-and-business mixed spending.

A bad rule doesn't save time. It creates the same wrong entry every month, quietly.

Step-by-Step Walkthrough

Create a rule

1. Go to Banking, then Rules, and click New rule (or create one directly from a transaction).
2. Name it clearly, for example "Adobe Acrobat – Software".
3. Choose Money out or Money in, and the bank account(s).
4. Set the conditions: the description contains a stable part of the text, such as "ADOBE". Avoid text that includes changing numbers.
5. Set the actions: transaction type (Expense), category (Software and Subscriptions), payee (Adobe), and an optional memo.
6. Choose review (recommended at first) or auto-add.
7. Save, then watch the next few transactions that the rule touches.

Maintain your rules

1. Review the rule list every quarter.
2. Edit or delete rules for vendors the client no longer uses.
3. If a rule categorizes something wrongly, fix the rule, not just that one transaction.
4. Keep a Rules Register (below).

Real-World Example

Bright Path has four clear monthly items: Adobe Acrobat ($14.99), State Farm ($96.00), Verizon ($82.15), and Facebook Ads (variable).

Solution breakdown:

• Adobe: Description contains "ADOBE" → Software and Subscriptions. No amount condition, in case the price changes.
• State Farm: Description contains "STATE FARM" → Insurance.
• Verizon: Description contains "VERIZON" → Utilities: Phone.
• Facebook Ads: Description contains "FACEBK" → Advertising and Marketing. The amount varies, so don't include an amount condition.
• No rules for Costco or Amazon. They mix business and personal, and various purposes.
• All set to review for the first three months.

Best Practices and Common Pitfalls

• ✅ Use stable, distinctive text in conditions.
• ✅ Start in review mode, and turn on auto-add only once you trust the rule.
• ✅ Keep a Rules Register (name, condition, category, date created, why).
• ⚠️ Watch for overlapping rules, where two rules match the same transaction.
• ⚠️ Don't create a rule from a transaction you have not fully verified.
• ⚠️ Never build rules for customer deposits. They belong to matching.
• ⚠️ A rule doesn't replace review. Skim the feed even when rules are working.

Tool Translation: Xero also has bank rules, with conditions on the description, amount, and payee, and can suggest or auto-code transactions.

Sheets companion: The Rules Register: rule name, account, conditions, category, mode (review or auto), created date, last reviewed date.

Module 3 Knowledge Check

Answer each question. Your answers are checked only when you click Check answers — nothing is revealed until then.

Module 3 Practical Exercise: Clear Bright Path's September Bank Feed

Scenario: Dana texts you: "I have a bunch of transactions sitting in the bank feed. Can you go through them and make them right? Ask me if you're not sure." Work in the same practice file you used in Modules 1 and 2. If you do not have a live feed, import the transactions below into the checking account as a CSV.

Business Checking (…4417): September Feed

1. Sep 2, ADOBE ACROBAT, -$14.99
2. Sep 3, SUNSET CLEANING SUPPLY, -$212.40
3. Sep 4, SHELL OIL 5563, -$48.20
4. Sep 5, COSTCO WHSE, -$186.00 (Dana: "$56 of this was my personal groceries")
5. Sep 6, ZELLE FROM D REYES, +$2,000.00 (Dana: "I moved this from my personal savings to help cash flow")
6. Sep 8, ONLINE PMT TO VISA …8821, -$350.00
7. Sep 9, STATE FARM INS, -$96.00
8. Sep 10, VERIZON WIRELESS, -$82.15
9. Sep 12, DEPOSIT, +$240.00 (from Module 2: Santos cash $120 and Patel check $120)
10. Sep 14, CHECK #1108, -$120.00 (from Module 2: Patel refund)
11. Sep 15, VENMO PAYMENT, -$150.00 (no information)
12. Sep 16, ONLINE TRANSFER TO SAV …9902, -$500.00
13. Sep 17, FIRST STATE BANK LOAN PMT, -$425.00 (loan statement: $360.00 principal, $65.00 interest)
14. Sep 18, MONTHLY SERVICE FEE, -$15.00
15. Sep 19, ZELLE FROM K OKAFOR, +$150.00 (Dana: "same-day cleaning, I didn't send an invoice")
16. Sep 22, FACEBK ADS, -$75.00
17. Sep 23, DEPOSIT, +$1,450.00 (from Module 2: Harper $1,350 and Lopez $100)
18. Sep 25, AMAZON MKTPLACE, -$63.98 (Dana: "cleaning cloths, I have the receipt")
19. Sep 26, ATM WITHDRAWAL, -$100.00 (no information)
20. Sep 30, INTEREST PAID, +$0.87

Business Visa (…8821): September Feed

21. Sep 8, PAYMENT THANK YOU, +$350.00

Tasks

1. Sort the 21 transactions into five groups using the decision process from Lesson 3.1: match, transfer, owner transaction, income or expense, and question for client.
2. Process each transaction in QBO in the recommended order (matches first, transfers, rule-friendly items, manual items, questions).
3. Create the two splits (Costco and the loan payment) so each total equals the bank amount.
4. Handle the two unknown items (Venmo and the ATM withdrawal) by holding them and sending a question to Dana. Do not guess.
5. Create bank rules for the four suitable recurring items, set to review mode, and explain in one sentence each why you did not create rules for Costco and Amazon.
6. Complete a Client Question Log and write the message to Dana (use the format from Lesson 3.8).
7. Simulate Dana's reply: "The Venmo was my Saturday helper. The ATM cash was for me." Apply her answers.
8. Run the September P&L and confirm that Uncategorized Income and Uncategorized Expense are both $0.
9. Write a short summary to Dana (5 to 8 sentences): what you completed, what you asked, and one suggestion to keep personal and business spending separate.

Deliverables

Screenshots of the Categorized tab, the two splits, the Rules list, and the September P&L; your Client Question Log; the message to Dana; and the summary.

Self-Assessment Rubric

• Match vs. categorize: Excellent means all three matches (lines 9, 10, 17) plus the card payment line (21) were matched, with no duplicate income. Needs work means any deposit categorized as new income.
• Transfers and owner transactions: Excellent means the card payment and savings transfer are transfers, and the $2,000 is equity. Needs work means transfers booked as expenses or the $2,000 booked as income.
• Splits: Excellent means both splits add up to the bank amount with the right accounts. Needs work means the loan booked entirely as an expense.
• Rules: Excellent means only stable, recurring items, set to review, with reasons given. Needs work means rules for Amazon or Costco, or for customer deposits.
• Client communication: Excellent means one clear message listing dates and amounts with no guessing. Needs work means unknown items were categorized on a guess.

Stretch Challenge

Dana asks: "Can you tell me how much I actually spent on cleaning supplies this month?" Run the P&L (or a transaction report filtered to that account) and give her the number, plus a sentence explaining why the Costco purchase counts only $130.00 rather than $186.00.

---

Check Your Work

Finished the exercise? Compare your work against the answers below.