The QBO Mini Guide for Trades: A 15-Minute Blueprint for Clean Books

Introduction: Stop Doing Bookkeeping in Your Truck

Let's be honest: you didn't get into the trades to stare at spreadsheets. Your day is spent quoting jobs, running for parts, and keeping clients happy. The last thing you want to do after a 10-hour day on the tools is sit in your truck trying to make sense of crumpled supplier receipts and confusing accounting software.

Generic bookkeeping advice doesn’t work for contractors. You manage complex projects, juggle subcontractors, and need to know exactly what a job cost you in materials and labor.

This mini guide is your 15-minute blueprint. We are cutting out the accounting jargon and giving you the exact steps to streamline your QuickBooks Online (QBO) setup. The goal is simple: spend less time on paperwork, keep the CRA happy, and actually see which jobs are putting money in your pocket.

Chapter 1: Nailing the Foundation (Your Chart of Accounts)

Most business owners plug their bank account into QBO and start categorizing things based on the default list the software provides. For a trades business, that default list is a recipe for disaster. 

Your Chart of Accounts is the filing cabinet for your business. If the folders are wrong, your financial reports will be useless. 

The Golden Rule: Separate Direct Costs from Overhead

You need to know exactly what it costs to deliver your service versus what it costs just to keep the lights on.

Cost of Goods Sold (COGS): These are the direct costs tied to a specific job. For a plumber, this means having dedicated accounts for Job Materials, Subcontractor Labor, and Equipment Rentals specific to a site. 

Overhead (Expenses): These are the costs you pay regardless of whether you book a job today. This includes truck insurance, shop rent, software subscriptions, and advertising. 

The Tradesman’s Chart of Accounts Cheat Sheet

Do not use the default QBO setup. Customize your list to look something like this so your reports actually make sense:

Income (Money Coming In)

Service & Labor Income: Revenue strictly from your billable hours.

Parts & Materials Income: Revenue from the markup on items you supply to the job.

Cost of Goods Sold (COGS - The Direct Cost of Jobs)

Job Materials: The actual cost of the pipes, fixtures, wire, or lumber used on a specific site.

Subcontractor Costs: Payments made to other trades working under your banner.

Job-Specific Equipment Rental: The cost of renting a trenching machine or scissor lift for a specific project.

Permits & Job Fees: Municipal permit fees directly tied to a client's project.

Expenses (Overhead - Keeping the Lights On)

Auto & Truck Expenses: Fuel, repairs, and maintenance for the fleet.

Insurance: Liability insurance and commercial vehicle coverage.

Small Tools & Supplies: Consumables and hand tools that aren't tied to one specific job.

Liabilities (Money You Owe)

GST/HST Payable: The sales tax you collected, minus the Input Tax Credits (ITCs) from your expenses.

Payroll Liabilities / WCB: Source deductions and premiums waiting to be remitted.

Shareholder Loan: The crucial account for tracking owner's personal vs. business spending.

Pro Tip: The 1-to-1 Rule for Specific Jobs

If you want to know exactly how profitable a specific type of service is—like hot water tank replacements—your Chart of Accounts needs to reflect that on both sides of the equation. 

Example: Hot Water Tank Installs

The Income Account: Income: Hot Water Tank Installs

The Matching COGS Account: COGS: Hot Water Tank Materials

Matching these accounts tells you immediately if you need to raise your prices or find a better supplier.

Chapter 2: Job Costing (Are You Actually Making Money?)

You just finished a massive three-day rough-in. The invoice was huge, but after paying your guys and settling the supplier bill, did you actually make a profit? Job costing is the secret weapon for trades businesses. It transforms your bookkeeping from a year-end tax chore into a real-time tool for making money.

How to Track and Analyze Your Profit by Project:

1. Assign Every Penny: In QBO, use the "Projects" feature. When you buy materials at a supplier, tag that expense to the specific project. When you run payroll or enter time via QuickBooks Time, allocate those specific labor hours to the project.

2. Labor Billed vs. Labor Worked: This is where many contractors bleed cash. By tracking time to the project, you can compare the labor hours you actually paid your crew for against the flat-rate or estimated hours you charged the client. If you quoted 10 hours but the crew took 16, you instantly see exactly how much profit you lost to inefficiency.

3. Materials vs. Markup: Pull a Project Profitability Report to see a side-by-side comparison of your actual material costs (from your supplier bills) versus the parts revenue you invoiced. Did you actually hit that 30% markup you planned, or did extra runs to the supply house eat your margin?

4. Identify the Winners and Losers: Over time, this data reveals patterns. You might discover that boiler replacements yield a 45% profit margin because you have the process dialed in, while custom bathroom rough-ins actually lose you money due to unpredictable labor hours. Once you know why certain jobs are profitable, you know exactly what kind of work to prioritize quoting.

Chapter 3: Getting Paid Faster (Mobile Invoicing & Quoting)

Cash flow is the lifeblood of a service business. You aren't a bank, so stop letting your clients treat you like one. Getting paid faster requires setting strict terms and making it frictionless for the customer to hand over their money.

Quote on the Spot: Create an estimate while standing in the client's mechanical room. You can email it to them immediately and even capture their signature on your phone screen to approve the work.

Require a Deposit Upfront: For bigger jobs, never float the cost of materials out of your own pocket. Use QBO to send an estimate and require a 30% to 50% deposit before ordering expensive fixtures, boilers, or custom parts. You can easily apply this deposit as a credit on their final invoice.

Use Progress Invoicing for Long Jobs: If a custom build or large installation is going to take a month, don't wait until the end to get paid. Turn on "Progress Invoicing" in QBO so you can easily bill 25% at the start, 50% at the rough-in stage, and the remainder upon completion—all directly from the original estimate.

* Set Terms to "Due on Receipt": If you are doing residential service work, there is no reason to offer "Net 30" terms. Change your default invoice terms in QBO to "Due on Receipt." The expectation should be that payment happens when the tools are packed up.

Automate Late Fees: QBO allows you to automatically apply late fees to overdue invoices (Account and Settings > Sales > Late fees). Sometimes, just having a note on your invoice that states "A 2% monthly late fee applies to overdue balances" is enough to bump your invoice to the top of their to-pay list.

Take Payment in the Driveway: Set up digital payments through QBO. When you convert an estimate to an invoice on your phone, the client receives an email with a "Pay Now" button, allowing them to pay securely via credit card or bank transfer before you even put your truck in drive.

Chapter 4: Taming the Receipt Chaos

The "shoebox on the dashboard" method is the fastest way to lose out on tax deductions and drive your bookkeeper crazy. Thermal receipts from suppliers fade quickly, and losing a receipt means losing out on claiming that expense and the associated GST/HST input tax credits. 

The Paperless Workflow (QBO vs. Dext):

Get in the habit of dealing with receipts the moment they are handed to you at the supplier counter.

Depending on the size of your operation, you have two great options:

1. For Lower Volume (QBO App): If you only have a handful of receipts a week, use the QBO mobile app's built-in scanner. Snap a photo, and the software will read the date, amount, and supplier name, matching it to the bank transaction when it downloads. 

2. For High Volume (Dext): If you have multiple crew members buying materials daily, integrate an app like Dext with your QBO. Your guys can snap photos on their phones, or you can auto-forward emailed supplier invoices directly to a Dext email address. Dext is incredibly powerful at extracting line items and taxes, and it pushes the data straight into QBO.

The Ultimate Audit Trail: Whether you use QBO's native app or Dext, the most important benefit is that the digital image of the receipt is permanently attached to the transaction inside your QBO ledger. If the CRA ever audits you, you don't need to dig through boxes of faded paper—the proof is just one click away.

Chapter 5: Handling the Tricky Stuff (Canadian Compliance & Owners)

Running a corporation in Canada comes with strict reporting rules. Messing these up can lead to massive headaches and penalties at year-end.

1. The Dreaded Shareholder Loan

It happens: you forget the company card and use your personal debit card to buy gas for the work truck, or you accidentally use the business card to buy groceries. 

The Detail: Track these meticulously through a Shareholder Loan account (a Liability account) in QBO. When you buy business supplies personally, log it as a Journal Entry or Expense paid out of the Shareholder Loan. This ensures you capture the business expense (and the tax deduction). Conversely, if you use company funds for personal items, it gets coded here as well. If this account ends up owing you money, great. If you owe the company money at year-end, it can trigger personal tax consequences, so keep this balanced!

2. Managing Subcontractors (T5018s)

If you hire other trades to help on a job, the CRA requires you to report those payments on a T5018 slip if they total more than $500 in a reporting period.

The Detail: In QBO, when you set up a subcontractor in your Vendor list, check the box that says "Track payments for T5018." Ensure you have their Business Number (GST number) on file before they start work. By coding all their invoices correctly to "Subcontractor Costs," generating the T5018 summary report at year-end takes three clicks instead of three days.

3. GST/HST Remittances

Sales tax isn't your money; you are just holding it for the government. 

The Detail: Ensure every item in your Chart of Accounts and every service you sell has the correct default tax code applied. QBO tracks the GST you collected on sales and subtracts the GST you paid on materials (your Input Tax Credits, or ITCs). By logging every receipt accurately, you maximize your ITCs, which legally lowers the amount you have to remit to the CRA. 

Chapter 6: The 15-Minute Weekly Bookkeeping Routine

Bookkeeping doesn't have to be a monumental monthly chore. By setting aside just 15 minutes a week—maybe on a Friday afternoon—you can keep your books pristine and catch errors before they snowball.

The 15-Minute Friday Checklist:

1. Clear the Bank Feed: Go through your downloaded bank and credit card transactions. Match them to the receipts you uploaded via QBO or Dext. (Crucial: Always click "Match" to an existing invoice payment; if you click "Add" on a payment that is already in the system, you will artificially double your income!).

2. Review Accounts Receivable (Who Owes You): Run an A/R Aging report. See whose invoices are sitting past your "Due on Receipt" terms. Send a quick email reminder straight from QBO with a link to pay. 

3. Review Accounts Payable (Who You Owe): Check your outstanding supplier bills. Schedule payments so you don't miss out on any early-payment discounts from your wholesalers.

4. Catch Unbilled Time & Expenses: Did you buy a specific part on your credit card for the Smith job and mark it "Billable" in QBO? Check your unbilled activity to ensure you actually added those parts and your crew's tracked labor hours to the final invoice before you hit send. Don't leave money on the table.

5. Check "Undeposited Funds": This is a classic QBO trap. If you receive a payment but it hasn't actually cleared your real-world bank account yet, QBO holds it in "Undeposited Funds." Ensure this account only holds checks or transfers that are genuinely waiting to clear. If there are old balances here, your income is likely overstated. 

6. Spot-Check Your Real Bank Balance: Log into your actual bank account online and compare the balance to the checking account balance shown in QBO. If they are completely different after clearing your bank feed, you know immediately that a transaction was duplicated, missed, or misdated.

7. Empty the Shoebox: Check your pockets, the truck console, and your inbox. Snap photos of any loose receipts and upload them before the weekend starts.

By keeping up with this routine, month-end becomes effortless, and you will always know exactly how much cash you really have in the bank.

April Vanloo

Anchor Peak Bookkeeping

Simplifying the numbers so you can focus on the job.

Still feeling overwhelmed by your job costing? You don't have to tackle your bookkeeping alone.

Click here to schedule a free discovery call with me, and let's get your books working as hard as you do!

Book Now