How QuickBooks Users Compare Estimated and Actual Project Costs
Users need help comparing estimated and actual project costs in QuickBooks Advanced, seeking steps to set up estimates, track expenses, and run variance reports.
April 2025 - QuickBooks Online Advanced users often ask how to see whether a project stayed on budget. The core of the question lies in setting up a cost estimate, entering actual expenses, and then viewing a report that shows the difference. Many users report confusion about where to begin, especially when they need to enable certain options before they can add products or services to expense forms. The process involves a few distinct stages: configuring expense settings, mapping items to expense accounts, creating the estimate, recording real‑world costs, and finally running the comparison report. Each step builds on the previous one, and skipping any part can leave the estimate versus actual report blank or misleading. Below is a clear, non‑technical walkthrough that follows the accepted community solution, written in plain language for everyday QuickBooks users.
Setting Up Expense Settings for Project Estimates
Before you can create a project cost estimate you must turn on the item table for expense and purchase forms. This setting lets you select products or services when you enter a bill, expense, or purchase order. To enable it go to the gear icon, choose Account and Settings, then select the Expenses tab. Locate the Bills and expenses section and click Edit. Check the box labeled Show item table on expense and purchase forms, then click Save and Done. Once this is active you will see a column for product or service on every expense‑related screen, which is required for the next steps.
Creating a Project Cost Estimate
With the item table turned on you can now build an estimate that forecasts both costs and revenue for a specific project. Navigate to the Projects center via the All apps menu, pick the project you want to work on, and choose Add to project ▼ followed by Project estimate. In the estimate grid fill in the Product/service column with the item you plan to use. Enter the estimated quantity in the Qty field. If you want to forecast cost only, type your expected unit cost in the Rate field and leave the Customer rate blank. If you prefer to forecast revenue only, leave Rate empty and enter the amount you plan to charge the customer in the Customer rate column. When both rates are supplied QuickBooks automatically calculates the markup percentage; editing the markup will adjust the customer rate accordingly. Continue adding lines for every product or service that should be part of the estimate, then save the form. The estimate can be shared with the client, but the client will not see your internal costs or markup.
Tracking Revenues and Expenses
After the estimate is saved you begin to record actual work and costs as the project progresses. For each bill, expense, or time activity related to the project, make sure to select the correct project from the Project drop‑down on the transaction form. This links the expense to the project so it will be counted in the actual totals. When you enter a bill or expense choose the appropriate product or service in the item column; the amount you post will flow into the actual cost side of the project. Similarly, when you record an invoice or receive a payment, associate it with the project to capture actual revenue. Consistent use of the project field on every transaction ensures that the data feeding the comparison report is complete and accurate.
Running the Estimate vs Actual Report
Once you have both an estimate and actual transactions posted, you can view the variance report that shows how close the project came to its original forecast. From the Projects center open the project you are reviewing, then select the Reports tab and choose Project estimate vs. actual. The report displays each line item from the estimate alongside the summed actual amounts, with a difference column that highlights overruns or savings. You can adjust the date range if you want to see performance for a specific period, and you can export the report to Excel for further analysis. If the report appears empty, double‑check that the estimate was saved, that expenses and revenues are tagged to the correct project, and that the item table setting is enabled.
By following these steps users gain a clear view of project profitability without needing to consult external documentation. The process relies on built‑in QuickBooks features: expense settings, item‑based estimates, project tagging, and the estimate versus actual report. When each piece is in place the software automatically surfaces the information needed to answer the question of whether a project stayed on budget, helping users make informed decisions about future work.