1) Module HUD
- Module #: 4 / 13
- Time: 20–30 min
- Outcome: “After this, you can run Banking without wrecking your books: clean rules, clean matches, fewer duplicates, and a workflow that keeps job costs assignable later.”
- Prereqs: [Module 2 — Essential QBO Setup for Contractors] + [Module 3 — Easy COA Your CPA Will Love]
- Stop here if: you just want accurate monthly financials and you’re willing to code transactions cleanly (no fancy automation).
- Level tags used in this module: ✅ Baseline / 🛠️ Operator Upgrade / ⚠️ Advanced
2) Answer Box (snippet block)
- What it is (2 lines)
Banking is your transaction intake line: bank activity comes in, you match it to what already exists, and you categorize what doesn’t.
Used right, it saves time. Used wrong, it manufactures duplicates and lies. - When to use it (2–4 bullets)
- You’re tired of manual entry and want faster month-end
- You need a consistent way to categorize job costs and overhead
- You’re seeing duplicates (bank download + manual entry)
- You want rules, but only the ones that don’t backfire
- The common mistakeS (1-2 line)
Clicking Add when it should be Match… then wondering why revenue/expenses doubled. - The fixES (1-2 line)
Default to matching. Use rules only for repeatable overhead. Keep job costs reviewable and attachable to Projects when needed.
3) The mental model (keep short)
- Bank feeds are for intake, not for “doing accounting automatically.”
- Your job is to decide: Match, Add, or “investigate.”
- Rules are safest for repeatable overhead (fuel, software, insurance).
- Job costs often need context (which job?) → don’t over-automate them.
- If you enter bills/invoices, bank feeds should mostly Match.
- The goal is a clean Profit and Loss, not a clean conscience.
4) Do this in QBO (step-by-step)
- Go to Banking
- Click Link account (if you haven’t) and connect your checking + credit cards
- After linking, in Banking, pick the account tab (checking/credit card) you’re working on
- Set your baseline workflow (✅ Baseline)
- For each transaction, decide in this order:
- Look for Match (preferred)
- If no match exists, use Add and categorize correctly
- If it’s unclear, leave it for review (don’t guess fast)
- Clean up the big three contractor repeats
- Fuel/vehicles: categorize to your overhead account (example: Vehicles/Fuel)
- Merchant fees: categorize to Bank/Merchant Fees
- Office/software subscriptions: categorize to Office & Software
- Build rules safely (🛠️ Operator Upgrade)
- In Banking, open a transaction that repeats (example: QuickBooks payment, cell phone, insurance)
- Click Create rule (or rule option shown on the transaction)
- In the rule:
- Use a specific “contains” description (avoid broad words like “Home Depot”)
- Set the category (overhead)
- Do not auto-add if the vendor description is messy
- Save the rule
Pro tip: Rules for overhead are fine. Rules for job costs are how you accidentally code $18,000 to “Materials” with no job and no clue.
- Prevent duplicates (⚠️ Advanced)
- If you already create bills/invoices:
- When payments hit the bank feed, you should mostly see Match
- If you’re seeing duplicates:
- Stop manual entering “bank-style” expenses and also adding from bank feed (pick one method per transaction type)
Warning: If you click Add on a transaction that already exists as a bill/payment, you just duplicated it. QBO is innocent. Your mouse is the criminal.
- Job costs + jobs (when applicable)
- If you are using Projects:
- Prefer entering vendor bills in Expenses first for job costs (so payments match later)
- If you must Add from Banking, categorize to Job Costs and note the job context for later cleanup (don’t pretend it’s “done”)
5) Real-world example (mandatory)
You buy materials for three jobs from the same supply house.
Scenario A (clean, match-first):
- You enter a bill in Expenses for $2,400 and assign it to the correct Project
- Later, the bank payment shows up in Banking as $2,400
- You click Match
Result: No duplicate expense. Job stays properly assigned.
Scenario B (the duplicate factory):
- You enter the bill in Expenses
- Bank payment comes in
- You click Add and categorize it as Job Costs
Result: You now have the bill AND the bank-feed expense. Your Profit and Loss is lying by $2,400.
6) Run this report now (mandatory checkpoint)
- Report name: Profit and Loss
- Filters/settings:
- Date range = last full month
- Click Run report
- What “good” looks like:
- Expenses aren’t doubled
- Merchant fees and subscriptions land consistently
- Job costs are not randomly scattered across overhead
- What “broken” looks like:
- Expenses feel “too high” vs reality
- Big vendors appear twice (once as bill, once as expense)
- Uncategorized or “Ask My Accountant” is stacking up
- One fix if broken:
- Find one duplicated vendor/payment and trace it: open the line item → identify whether it’s a bill/payment + bank-feed add. Delete/recode the duplicate transaction (do not nuke history blindly).
7) Lab (do it on your file)
- [PASS/FAIL] You connected checking and credit cards in Banking
- [PASS/FAIL] You can explain the difference between Match and Add
- [PASS/FAIL] You processed at least 20 transactions without guessing
- [PASS/FAIL] You created 2–5 safe rules for repeatable overhead
- [PASS/FAIL] You did NOT create a broad rule for a big vendor (example: generic “Home Depot”)
- [PASS/FAIL] You found and fixed at least 1 duplicate (if duplicates exist)
- [PASS/FAIL] You reduced Uncategorized / “Ask My Accountant” vs last month
- [PASS/FAIL] You ran Profit and Loss and it looks believable
8) Knowledge check (3 questions)
- What’s the default priority: Match or Add (and why)?
- Name two categories that are safe to automate with rules.
- What’s the most common way bank feeds create duplicate expenses?
9) Next + Related
- Previous: [Module 3 — Easy COA Your CPA Will Love]
- Next: [Module 5 — Advanced Products & Services (Start simple → grow)]
- Related modules (2–3)
- [Module 10 — Monthly Close]
- [Module 12 — QBO Cleanup / Rebuild]
- [Module 9 — Enhanced Job Costing & Profit Reporting]
- Don’t do this warnings
- Don’t click Add when there’s a valid Match. That’s how duplicates are born.
- Don’t create broad rules for job-cost vendors unless you enjoy forensic accounting later.
- Don’t “fix” messy feeds by making more rules. Fix the workflow.
Fast now = slow forever.
FAQ (short)
Should I enter bills first or just use bank feeds?
If you want clean job assignment and fewer duplicates, enter bills for vendor-heavy job costs in Expenses so bank payments Match later.
Why does QBO show both Match and Add?
Because sometimes a transaction already exists (match it) and sometimes it doesn’t (add it). The button isn’t advice.
What rules are safest?
Repeatable overhead: software, insurance, phone, bank fees. Avoid rules for mixed job-cost vendors.
How do I stop duplicates fast?
Pick one workflow: either (a) enter bills/invoices and use bank feeds to Match, or (b) don’t enter bills and code carefully from Banking. Mixing both without discipline doubles everything.
Do bank feeds help with job costing?
Indirectly. They help you get clean transaction intake—but job costing accuracy depends on how you categorize and (when applicable) assign to Projects.