How do I track costs by job in QuickBooks?
Start by enabling the Projects feature in QuickBooks Online. Go to Settings, then Account and Settings, then Sales. Turn on “Organize all job-related activity in one place” and save. Now you can create projects under any customer and assign transactions to them.
When you enter a bill, write a check, or categorize a bank transaction, you’ll see a Customer/Project field. Pick the right project every time. Materials from the hardware store go to the specific job. Subcontractor invoices go to the specific job. Every expense that relates to a project needs that project assigned or it won’t show up in your job cost reports.
Income works the same way. When you create an invoice, assign it to the project. Progress billings, final invoices, change order billing. All assigned to the project so you can see revenue against costs.
Labor is trickier. QuickBooks doesn’t automatically split payroll costs by job unless you’re using the Time Tracking feature and have it integrated with payroll. Most small businesses either use QBO’s built-in time tracking or import time data from an outside app. Either way, someone needs to record hours by project and make sure that data connects to your job costs. If your crew works on multiple jobs in a day, they need to track time by job, not just total hours worked.
The Project Profitability report is where the value shows up. Run it weekly for active jobs, at minimum monthly. You’ll see income minus costs by project so you can catch overruns before they eat your margin. Waiting until a job is done to check profitability means you find out too late to do anything about it.
Where job costing fails is inconsistent coding. You track religiously for three weeks, then get busy and start dumping expenses into general categories without assigning projects. Two months later your reports are worthless because half the expenses aren’t attached to anything. The system only works if every transaction gets coded correctly, every time.
For construction businesses with complex needs like phase tracking, retention, or work-in-progress reporting, QuickBooks may need workarounds or you might need construction-specific software. Construction job costing requires more detailed tracking than most service businesses, and the right setup depends on how you estimate and bill your projects.
If setting this up feels overwhelming, that’s normal. The mechanics are simple but building the habits is hard, especially when you’re running jobs and don’t have time to stay on top of the books. A San Diego bookkeeping service familiar with job costing can configure your QuickBooks correctly from the start and handle the ongoing coding so your reports actually mean something.
San Diego's Small Business Bookkeeper
The Next Step:
A Short Conversation
A quick call to tell us about your business. We'll listen, answer your questions, and give you a clear price quote.
More Questions
How do I separate business and personal expenses?
Open a dedicated business bank account and use it exclusively for business transactions. Add a business credit card, pay yourself intentionally, and keep personal spending completely out of business accounts.
Read answerHow do I set up QuickBooks Online for my business?
QuickBooks Online walks you through the basics when you create an account. The real work is configuring your chart of accounts, bank connections, and tracking features to match how your business actually operates.
Read answerWhat is TOT and how do I track it?
TOT stands for Transient Occupancy Tax. It's a local tax on short-term lodging that you collect from guests and remit to the city. In San Diego, the rate is 10.5% and you need to track it separately from your rental income.
Read answerHow do I catch up on months of bookkeeping?
Start by gathering all bank and credit card statements for the months you're behind. Work chronologically from the oldest month forward, reconciling each account before moving to the next. The key is tackling it systematically rather than jumping around.
Read answerWhat is Form 990 and when is it due?
Form 990 is the annual information return tax-exempt organizations file with the IRS. It's due on the 15th day of the 5th month after your fiscal year ends, which means May 15 for calendar year organizations.
Read answerWhat is outsourced bookkeeping?
Outsourced bookkeeping means hiring an external firm or individual to handle your financial record-keeping instead of doing it yourself or employing someone in-house. The bookkeeper works remotely through cloud accounting software.
Read answer