Tracking Job Costs and Profitability in QuickBooks Desktop for Mac

Tracking costs against specific customer jobs is a core workflow in QuickBooks Desktop for Mac, but users frequently struggle to connect expenses, time, and mileage to the correct project. Without properly assigning these costs at the transaction level, job profitability reports will display incomplete or inaccurate data, leaving businesses unable to determine whether a project is actually making money. To capture job costs accurately, every related transaction must be tied to a specific customer or job.

Recording Time, Purchases, and Mileage

Job costing begins at the data-entry stage. For labor, hours must be recorded using either a weekly timesheet or a single activity entry. Each time entry must be marked as billable and assigned to the specific customer job. This ensures the time is tracked internally for cost purposes and remains available to pass along to the client on a future invoice.

For job-related purchases, such as materials or subcontractor services, users must enter the transaction through a bill, check, or credit card charge. On the Items tab, the user must assign each purchased item or service to the correct job using the Customer:Job column. Other general expenses, such as freight or postage, are handled similarly. They are recorded on the Expenses tab of the transaction and assigned to the specific job in the Customer:Job column.

Mileage is recorded separately through the Enter Mileage window, found under the Company menu. Users can adjust the billing amount for mileage directly on the invoice later if they need to charge the client a rate higher than the standard default.

Preparing Estimates and Invoices

Before invoicing a client for these tracked costs, certain settings must be enabled. From the QuickBooks menu, users need to access Settings, select Sales and Invoicing, and enable the preference for customer and job estimates. This unlocks the ability to pull previously recorded costs directly onto an invoice.

To create the invoice, users navigate to the Customers menu and select Create Invoices. After selecting the appropriate Customer:Job, clicking the Time/Costs button opens a window displaying all pending billable entries for that specific project. The window is divided into separate tabs for Time, Expenses, Mileage, and Items. Users can select individual costs in the Use column to add them to the invoice, or click Select All to include everything at once.

If a cost appears in this window that the business never intends to bill to the customer, it can be placed in the Hide column. This permanently removes the expense from the billing window without altering the original transaction or deleting the cost from internal accounting records.

Managing Markups and Sales Tax

When passing expenses through to a client, users can adjust the markup directly in the Expenses tab by changing the markup amount or percentage and selecting the appropriate markup account. This adjustment only applies to the current invoice and does not alter the company-wide default markup settings. If the business prefers not to reveal the markup amount to the client, the invoice can be configured to print the selected time and costs as a single line item.

For tax compliance, users can ensure that billable expenses are taxed correctly by checking the option indicating that selected expenses are taxable within the Expenses tab. A “T” will appear next to the expense on the invoice, indicating that the item is subject to sales tax.

For time entries, the Time tab includes an Options menu. This allows users to combine all activities sharing the same service item into a single line on the invoice, keeping the document clean and concise. Users can also dictate how QuickBooks populates the description field on the final invoice.

Reviewing Profitability

Once all time, purchases, and mileage have been assigned to jobs and invoiced, management can review the financial results. Navigate to the Reports menu and select Jobs, Time, & Mileage. Running reports from this section allows users to compare total revenues billed against the actual costs incurred, providing a clear picture of overall job profitability. For businesses dealing with complex project accounting or damaged company files that threaten historical cost data, maintaining strict assignment practices at the transaction level is essential for accurate reporting.