How to match supply house invoices to jobs in QuickBooks?
By the Truceipts team · Published · Updated
Enter each supply-house invoice as a Bill in QuickBooks Online, pick the job in Customer/Project on every line, then match the later statement payment to those bills. The PDF does not know the job. The tag on the bill is what puts the cost on the project.
This is the click path for a 5-to-15 tech shop on Jobber, Housecall Pro, or Workiz: the settings, the mixed-invoice split, what never to tag, and why a Ferguson PDF still leaves jobs empty.
What has to be on before a bill can hit a job
The email knows the vendor and the amount. It does not know the job. You have to give QuickBooks a job to pick, and a column to pick it in.
| Setting | Where | What it does |
|---|---|---|
| Plan | Subscription and billing | Plus is the floor. Simple Start and Essentials have no Projects. |
| Organize all job-related activity in one place | Account and settings, Advanced | Turns Projects on. Intuit’s Projects help (updated 2026-10-06) puts this on Plus, Advanced, and Intuit Enterprise Suite. |
| Track expenses and items by customer | Account and settings, Expenses | Shows the Customer/Project column on bills. |
Turn on Organize all job-related activity in one place, then create a project named for the job address or ticket. Sub-customers work too. Classes on Plus are for a trade or a crew, not individual jobs.
Prices are USD from each vendor’s own page, read 2026-11-14. Housecall Pro’s Basic and Essentials cards are on its LLM info page (updated 2026-09-10, prices as of July 2026). Confirm the quote, including any Mechanical Package.
| Tool | Cost | How a supply-house invoice gets a job |
|---|---|---|
| QuickBooks Online | Plus $140/mo list. Advanced $340/mo list. 50 percent off for 3 months that day. | Customer/Project on each bill line. Simple Start and Essentials have no Projects. |
| Jobber | Grow $229/mo billed annually, 5 users. Plus $399/mo. Extra users $29/mo. | Plus scans a PDF when the job number is on the PO. The match lives in Jobber. |
| Housecall Pro | Basic $59/mo billed annually, 1 user. Essentials $149/mo billed annually, 5 users. Confirm the quote. | Costs you log on the job. Job costing does not push supplier bills into QuickBooks. |
| ServiceTitan | Quote-only, per technician. No list price. | You switch. Office tags POs against the job. |
You do not need Make expenses and items billable to job-cost. That switch puts a cost on the customer’s invoice. Enter billable expenses (updated 2026-08-04) is a Plus and Advanced reimbursement tool. Leave Billable off on flat-rate tickets.
If the Jobber, Housecall Pro, or Workiz sync dumped every invoice onto one customer, there is nothing real to tag a Ferguson bill against. Is QuickBooks job costing worth it for a small contractor? covers when the tagging holds.
Put the job number on the purchase order first
Matching in QuickBooks is a lookup, not a guess. Ask Ferguson, Johnstone, CED, Graybar, and Rexel to print the job number or street in the PO field. Have techs give the street name at the counter if they do not have the number.
Jobber’s supplier invoice scanning (updated 2026-10-01) looks for that number in the PO, the reference, and the notes, then attaches a draft expense to the Jobber job. That match lives in Jobber. It does not fill Customer/Project on the QuickBooks bill. A blank PO is the usual miss. On r/Plumbing, shops said materials land on the wrong job when nobody codes the PO.
Enter the bill and tag the job
Do this when the invoice arrives, not when you pay the statement. Intuit’s bills-vs-expenses help (updated 2026-08-05) is the split: a bill is pay-later. An expense is pay-now. Card swipes are a different path: how to assign credit card expenses to jobs.
On r/Bookkeeping, the project overview stays empty until a transaction is tied to that project and coded to a cost account. The bill does not have to be paid. It has to be entered.
- Select + Create, then Bill. Intuit’s enter-bills help (updated 2026-08-05) is that path.
- Pick the vendor. Enter the Bill date, Due date, and Bill no. exactly as they appear.
- Code the line to materials or cost of goods sold, not Inventory Asset, unless you actually stock and sell parts as inventory.
- In Customer/Project, pick the job. Vendor is who you owe. Customer/Project is where the parts went.
- Leave Billable off on flat-rate work. Select Save and close.
If you already created a purchase order, pick the vendor and select Add on the open PO. Intuit’s add-PO help (updated 2026-07-16) copies the items across and closes the PO. You posted last week’s bills to Materials and never picked a job? Open the bill, pick the project on each line, save. Do not use a journal entry. Journal entries have no Customer/Project column.
Split one invoice across two jobs
A tech who grabs parts for Elm Street and Oak Avenue on the same Ferguson ticket posts one amount. Until you split it, both jobs are wrong.
- On the bill, add a line per job.
- Category, amount, and Customer/Project on each line. The lines must add up to the invoice total.
- Select Save and close.
Pay the statement without tagging a job
Ferguson, Johnstone, and CED send a monthly statement. One ACH or check pays twenty invoices. That payment is not a job cost.
Intuit’s pay-bills help (updated 2026-09-22) is the close: Expenses & Pay Bills, then Pay bills, pick the checking account, tick the bills that statement covers, save. Then match the downloaded ACH to that bill payment. Do not Categorize the ACH to Materials. That posts the whole statement as a new expense and double-counts every invoice. Do not use a Check or Expense to pay an open bill.
A return is a vendor credit (updated 2026-09-15). Use the same category as the original parts, pick the job in Customer/Project, and apply it on Pay bills.
What never gets a job tag
| Transaction | What it is | Job tag? |
|---|---|---|
| Supply-house invoice on a charge account | The purchase | Yes, on each bill line |
| Mixed invoice | One PDF, two jobs | Yes, split by line |
| Statement ACH or check | Paying the open bills down | No. Use Pay bills |
| Vendor credit or return | Parts that came back | Yes, same job as the original bill |
| Truck stock off the van | Never hit the invoice | Only if someone logs quantity used |
| Fuel, shop tools, restock with no job | Overhead | No |
The statement payment is the mistake shops make most. The expense was recorded when the invoice arrived. Paying Ferguson just closes those bills.
Why matching still leaves jobs empty
QuickBooks wins the report. The project overview is a real P&L when income and costs share the tag. The PDF does not fill the tag for you.
A five-truck week is emailed Ferguson invoices with a blank PO, a mixed Johnstone ticket, a return with no number, and a capacitor off the van. Each one needs someone who knows which job it belongs to. That knowledge lives in the field. The tagging happens in the office.
The FSM does not close the gap. Housecall Pro’s job costing does not push supplier bills into QuickBooks. Jobber’s profit bar lives in Jobber. Truck-stock parts never even hit the invoice. How to track material costs per job for an electrical contractor covers that hole. Wait until month-end and last week’s closed jobs still show revenue and almost no material. The click path works. The week does not.
Four ways shops actually keep the tags current
1. Run the bills as designed
Stay on Plus. Projects on. Enter each supply-house invoice as a bill the day it lands, with Customer/Project on every line. Split mixed invoices before you Pay bills. Right answer when the owner still sees every PDF. It breaks the first week nobody tags. Switching the FSM to ServiceTitan for built-in POs is a different decision.
2. Make the invoice name the job
Job number on every PO. Techs give the street at the counter. Receipt snapped into the FSM job the same day. The office is matching, not reconstructing Friday from memory. It still fails when two jobs share one ticket.
3. Hire a job-costing VA
Job posts for the role ask someone to assign 5 to 10 transactions a day to the right job by property address. Offshore listings for that work commonly run about $800 to $1,100 a month. A person can split a receipt and chase a credit with no PO. You still train them on your jobs and check their work.
4. Use software that tags from the FSM and the inbox
A newer set of tools leaves the FSM and QuickBooks in place and matches card swipes, supply-house bills, timecards, and sub invoices to a job using tech, time, address, and supplier. Anything they cannot place goes to a short exception list. We make Truceipts, which does this, so weigh that suggestion accordingly. Ask whether a tool only adds tags, whether changes can be undone, and whether it shows why it matched each cost.
How to tell this week
You know the matching is working when last week’s closed jobs show supply-house bills on the project overview, mixed invoices are split, and the statement payment has no job tag. If the overview shows revenue and almost no cost, the feature is on and the bills were never tagged.
Pull last week’s ten closed jobs from the FSM. Lay each one next to the supplier PDFs in your inbox and the bills in QuickBooks. Start with those three files. They already exist.
Frequently asked questions
Do I need to mark a supply-house bill billable to put it on a job?
No. Billable puts the cost on the customer's next invoice. Profit by job only needs Customer/Project filled in on each line of the bill. Intuit's billable-expense help, updated 2026-08-04, is a Plus and Advanced reimbursement tool. On flat-rate work, leave Billable off so you do not invoice parts already in the price.
Why is the Customer/Project column missing on my bills?
Turn on Track expenses and items by customer under Settings, Account and settings, Expenses, Bills and expenses. You also need a customer, sub-customer, or project to pick. Projects are on Plus, Advanced, and Intuit Enterprise Suite after you turn on Organize all job-related activity in one place. Intuit's pricing page, read 2026-11-14, lists Plus at $140 a month and Advanced at $340 a month at list.
Should I assign the monthly Ferguson statement payment to a job?
No. The cost was recorded when you entered each invoice as a bill. The ACH or check that pays the statement is a bill payment, not a new expense. Intuit's bills-vs-expenses help, updated 2026-08-05, says to close bills with Pay bills. Tagging that dump onto one job double-counts every invoice you already posted.
What if one supply-house invoice covers parts for two jobs?
Split the bill. Add a line per job with category, amount, and Customer/Project on each. The lines must add up to the invoice total. A credit with no PO still belongs to some job. Put the job number in the PO field next time so the PDF names it.
Does Jobber's invoice scan put the cost on the QuickBooks project?
No. Jobber's supplier invoice scanning, updated 2026-10-01, matches a scan to a Jobber job using the job number on the PO. That expense lives in Jobber. The QuickBooks project still needs Customer/Project on the bill. The Jobber QuickBooks sync does not create a Project per ticket.