Why doesn’t QuickBooks Online Plus show estimate vs actual?
- The report is Advanced only. Intuit’s features page says, “In QuickBooks Online Advanced, running an estimates versus actuals report lets you monitor budget health.”
- So are cost estimates. Project estimates, with a cost rate and a customer rate on each line, are for Advanced and Intuit Enterprise Suite.
- So are cost groups. Intuit lists them for Advanced with the QuickBooks Construction Add-on, and Intuit Enterprise Suite.
- Plus does have budgets. Intuit says “budgeting is only available in QuickBooks Online Plus and Advanced,” and a budget can be subdivided by customer.
How do you set up estimate vs actual on Plus?
Budgets work by account, so your expense accounts become your cost codes.
- Pick five to eight cost accounts. For example: Labor, Materials, Subcontractors, Equipment rental, Permits and fees, Dumpsters and disposal. Each must already be in your chart of accounts.
- Write every bid with the same names. One bid line per cost account.
- Turn on job tracking. Go to Settings > Account and settings > Expenses and turn on Track expenses and items by customer. Then make each job a project, as in our guide to QuickBooks Online job costing for contractors.
- Enter the bid as a budget. Go to Settings > Budgeting or Reports > Financial planning > Budgets. Choose Profit and loss, the year, and a subdivided budget for specific customers, then enter each job’s bid cost per account by month.
- Or import it. Select Import budget, download the P&L budget template, and fill in amounts per account. The template warns: “Do not add new columns or rows for additional accounts.” The file must be an Excel file of 10MB or less.
- Book every cost to the job. On bills, checks and expenses, choose the cost account and set Customer/Project on every line. A supplier bill covering two jobs needs two lines.
- Get labor onto the job. Add employee timesheets to the project. If payroll cost isn’t reaching jobs, see payroll costs not showing in projects.
- Run the comparison. In the Budgets list, open the dropdown in the Options column and choose Run Budgets vs. Actuals report. Set the dates from the job’s start to today, then use Export/Print > Export to Excel to keep a copy.
When a homeowner signs a change order, add its cost to the budget that day, or it shows up as an overrun.
How do you track labor hours against the bid?
QuickBooks Time Elite lets each project carry an hours estimate. Intuit says, “Any timesheet tracked against that project will count toward those total hours.”
- Create the project in QuickBooks Online first, then in QuickBooks Time open the QuickBooks dropdown and choose Import > Projects.
- Add the estimate. Go to Projects, select the project, choose +Add Estimate, pick By hours or By service items, then Add estimate. The estimate type can’t be changed after you save.
- Split by trade if you bid that way. New service items must be added in QuickBooks first, then imported into QuickBooks Time.
- Watch the Overview tab. It shows hours worked against hours estimated, and the hours remaining.
Time tracked before the project existed has to be edited to add the project.
How do you check the comparison is right?
Example: a kitchen remodel
| Cost account | Bid | Actual | Over (under) |
|---|---|---|---|
| Labor | 18,000 | 21,400 | 3,400 |
| Materials | 24,000 | 23,100 | (900) |
| Subcontractors | 15,500 | 17,200 | 1,700 |
| Equipment rental | 1,200 | 950 | (250) |
| Permits and fees | 1,800 | 1,800 | 0 |
| Dumpsters and disposal | 1,500 | 2,100 | 600 |
| Total | 62,000 | 66,550 | 4,550 |
Before you trust a row:
- Totals agree. The job’s actual total should match its cost in Profit and Loss by Customer for the same dates.
- Nothing is off the job. Run Profit and Loss, select Customize, set Columns to Customers, and look for job costs with no customer, often bank feed purchases.
- Labor is priced once. Intuit says “hourly cost rates only apply to time that is tracked after the hourly cost rate is set,” and switching between Payroll Expenses and Hourly Costs in one project changes every project.
- The job fits in one budget. Each budget covers one year, so a job that runs past year-end needs its bid split across two budgets.
- Bills are in. A subcontractor bill that hasn’t been entered makes the job look under budget.
What changes on QuickBooks Online Advanced?
Go to All apps > Projects > Projects, select the project, then Add to project > Project estimate. Each line takes a quantity, your cost rate and the customer rate; customers see only the sales side.
First turn on Show Items table on expense and purchase forms under Settings > Account and settings > Expenses, and give each item you buy an expense or cost of goods sold account. On each bill or expense, enter the estimate’s products and services in Item details, with the project set.
The report is under the project’s Project Reports > Estimates vs. actuals. Estimate details appear in reports only after you mark the estimate Accepted or Declined.
What are your options?
| Option | Good for | Watch for |
|---|---|---|
| Budgets vs. Actuals on Plus | Bids written by cost account | One year per budget; account totals only |
| Spreadsheet from a Profit and Loss by Customer export | A quick look at a few finished jobs | Rebuilt by hand every month |
| Upgrade to Advanced | Line-by-line cost estimates and the Estimates vs. actuals report | Moving open bids in; the same tagging habits |
| Bring in an outside team (Reports & answers) | Every job compared from your books | Who keeps the cost codes clean afterward |
FAQ
Is there an estimate vs actual report in QuickBooks Online Plus? No. Intuit lists it for Advanced and Intuit Enterprise Suite; on Plus, a budget subdivided by customer and the Budgets vs. Actuals report give a similar comparison.
Can QuickBooks Time compare hours to my bid? Yes, in QuickBooks Time Elite, with an hours estimate on each project. Dollar comparisons still come from QuickBooks Online.
Should I use products and services or accounts as cost codes on Plus? Accounts, because Plus budgets are entered per account. Keep the list short so bids and books use the same names.
Sources
- Compare project cost estimates vs. actuals in QuickBooks Online, Intuit QuickBooks Support,
- Create budgets in QuickBooks Online, Intuit QuickBooks Support,
- Create and import budgets in QuickBooks Online, Intuit QuickBooks Support,
- Set up and use projects in QuickBooks Time, Intuit QuickBooks Support,
- Track hourly labor costs and profitability by project in QuickBooks Online, Intuit QuickBooks Support,
- Job & Project Costing Software | QuickBooks, Intuit QuickBooks,