How Do You Track Material and Inventory Across Job Sites?#

Track two things separately. Material you buy for a specific job should be ordered against that job, and its supplier bill coded to the job and cost code. Stock you hold (in the shop, the trucks and the site trailers) should be tracked by location and checked out to the job that uses it, with leftovers returned. QuickBooks Online counts stock on hand but not by location, so if you have a shop, trucks and several sites, you need a system that knows both the locations and the jobs. Appello does that alongside QuickBooks Online.

Why is material on an ICI job different from a service van?#

Most inventory advice is written for service companies restocking vans with the same fittings every week. An ICI trade contractor's material mostly doesn't work like that.

On a hospital insulation job, most of the material is bought for that job: the pipe cover, the duct wrap and the aluminum jacketing, ordered from the distributor and delivered to site. A smaller share comes out of your own stock: tape, adhesive, bands, screws, and the leftover jacketing from the last job.

Those two need different tracking:

• Job-bought material gets its cost from the supplier's bill. The questions are "Did we order it?", "Did it arrive?", "Is the bill coded to the right job and cost code?"
• Stock gets its cost from what you paid when it went on the shelf. The questions are "Where is it?", "Who took it, to which job?", "What came back?"

Mix them up and either the job cost is wrong or the shop count is.

What are your options?#

Every vendor fact comes from the vendor's own website, checked October 14, 2026. Links are in the sources at the end.

Option	Stock by location (shop, truck, site)	Move stock between locations	Charge stock to a job	Built for
Spreadsheet	If someone keeps it up	By hand	By hand	Anyone
QuickBooks Online Plus or Advanced	Tracks quantity on hand; Intuit's inventory help article doesn't cover locations	Not described in Intuit's help article	Through the bill or invoice	General small business
QuickBooks Desktop Enterprise with Advanced Inventory	Yes, "multiple inventory sites or locations"	Yes	Through the bill or invoice	General business; Platinum and Diamond subscriptions only
Ply	Warehouses, trucks and job sites, with barcode scanning	Yes	Yes	Service trades (HVAC, plumbing, electrical, roofing); connects to QuickBooks, ServiceTitan, Jobber and others
Appello	Warehouses, vehicles and staging areas or site trailers, with reorder thresholds	Yes	Check out to a job and cost code; return what's left	ICI trade contractors: the same system runs timesheets, schedule, job cost and billing

Can QuickBooks track inventory by job site?#

Not on its own in QuickBooks Online. Intuit's help article says inventory is available on Plus and Advanced and tracks quantity on hand, but it doesn't describe stock by location or transfers between them, and QuickBooks' own support team has answered that QuickBooks Online "doesn't have multiple locations for inventory" and can't transfer inventory between locations.

QuickBooks Desktop Enterprise can, with Advanced Inventory: Intuit says it manages "products across multiple inventory sites or locations" and transfers between them, on the Platinum and Diamond subscriptions only.

For most subs, QuickBooks is fine as the ledger. The tracking happens somewhere else and the supplier bills land in QuickBooks against the job.

How do you track material bought for a job?#

1. Order it against the job. Every order carries the job, what's needed and the required-by date. "Pipe cover for Level 3, needed Tuesday" is a line, not a phone call.
2. Track each line, not just the order. A distributor ships 80% and backorders the rest. You need to know which 20% is still coming before the crew runs out.
3. Code the bill to the job and cost code. When the supplier's invoice arrives, it goes to the job and the cost code it belongs to (cold pipe, duct, jacketing). That's what makes material show up in your budget vs actual.
4. Keep supplier pricing current. Load each distributor's price sheet when it changes, so estimates and orders use this month's prices.

How do you track stock in the shop, trucks and site trailers?#

1. Make every place that holds stock a location. The shop, each truck, each site trailer or sea can.
2. Set a reorder point on the items you always need. Tape, adhesive, bands and screws. Then you find out the shop is low before a foreman does.
3. Record every move. Shop to truck is a transfer. Truck to the hospital job is a checkout, to the job and, ideally, the cost code. Unused material back to the shop is a return. Damaged or lost gets adjusted, with the reason.
4. Count once in a while. Set the counted total and let the system record the difference.

The result is a record that answers "where are the six boxes of jacketing?" and "what did this job actually draw from our stock?"

What about leftovers at the end of a job?#

That's where most material quietly disappears. At closeout, half-rolls of jacketing and part-boxes of fittings go back on a truck, get dumped in a corner of the shop, and get bought again for the next job.

Record the return to a location, and two things happen: the stock is available for the next job, and the finished job's material shows only what it used.

What should you test in a demo?#

• "Show me our shop, two trucks and a site trailer as locations, with what's in each."
• "Transfer six boxes of jacketing from the shop to Truck 2, then check four out to the hospital job's jacketing cost code."
• "Return two boxes from the job to the shop. What does the job show as issued now?"
• "Show me a material order for next Tuesday with one line on backorder."
• "Show me a supplier bill from QuickBooks Online on the job's budget vs actual."

Where is Appello not the right fit?#

Appello is built for ICI trade contractors, often union, with about 20 to 400 field staff. It isn't built for:

• Residential builders and renovators. Their material runs through a lumber yard account and a builder platform, not shop stock and site trailers.
• General contractors who need document control and submittals for the whole building. That's a GC platform's job.
• A one-person shop with no field crew. A spreadsheet and QuickBooks Online will cover you.

Where does Appello fit?#

Appello runs material alongside the rest of the job, so the material, the hours and the billing all land on the same job and cost codes.

• The catalogue. Materials priced per unit or per dimension, by supplier, with distributor discounts and part numbers. Supplier price sheets load through Appello's AI connector, which checks the sheet, applies it to the catalogue and updates pricing by source.
• Material orders. Ordered against the job, with a required-by date and priority. Each line carries the quantity ordered, received and on backorder, so a partial shipment leaves the rest on backorder, and the order exports to PDF. A status board shows every order across every job.
• Inventory by location. Warehouses, vehicles and staging areas or site trailers as locations, each with stock levels, reorder points and low-stock flags. Transfer between locations, adjust with a reason, check out to a job and cost code, and return what's left. A movement ledger records every move, who made it and the unit cost, and each job shows the materials issued to it, net of returns.
• Job cost. Supplier bills are entered in Appello or synced from QuickBooks Online and coded to the job and cost code, so material lands on budget vs actual next to labour from approved timesheets.
• Work orders. On service and T&M work, the tech logs materials from the catalogue on the phone, and they go on the invoice.
• Equipment. Lifts, tools and PPE are tracked separately, with QR labels and check-out and check-in.

Bring a supplier price sheet and a list of your trucks to a demo, and we'll set them up and check stock out to a job.

FAQ#

How do I get our starting stock into the system?
Set up each location, then record a starting count and unit cost for each item you hold there. Appello's team sets up your locations and starting stock with you during onboarding, so you don't have to key the whole shop in yourself.

Should job-specific material go through inventory?
Usually not. If it's bought for one job and delivered to that site, code the supplier bill to the job and cost code. Use inventory for stock you hold and draw from across jobs.

How do I charge shop stock to a job?
Check it out of the location to the job, and the cost code if you can. Return what comes back, so the job shows only what it used.

Do I need barcode scanners?
Not to start. A clear list of locations, reorder points on the items you always run out of, and a habit of recording moves will do more than scanners on day one.

How is this different from equipment tracking?
Material gets used up; equipment comes back. Track lifts, tools and harnesses as equipment with check-out and inspections. Our post on construction equipment tracking covers that side.

Sources#

All accessed October 14, 2026.

• Intuit, Set up and track your inventory in QuickBooks Online and QuickBooks Desktop Enterprise Advanced Inventory
• Intuit Community, Set Up Multiple Inventory Sites For Distributors in QBO (QuickBooks Team, June 18, 2020: "In QBO, it doesn't have multiple locations for inventory" and transferring inventory between locations "is unavailable in QuickBooks Online")
• Ply, home page
• Appello documentation, Inventory Management and Material Orders

Related reading#

• Material Tracking and Cost Control for Subcontractors
• Construction Equipment Tracking: From Chaos to Control
• How Job Costing Works for ICI Subcontractors
• What Construction Software Works with QuickBooks for Subcontractors?
• Appello Materials & Inventory