Field guide · Remodelers · QuickBooks Online

Estimate vs actual reports in QuickBooks Online for remodelers

QuickBooks Online keeps its Estimates vs. actuals report for Advanced and Intuit Enterprise Suite. On Plus, enter each bid’s costs as a budget subdivided by customer, book every cost to the job under the same cost accounts, and run Budgets vs. Actuals. QuickBooks Time Elite compares hours worked to the hours you bid.

Published · Get the PDF

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.

  1. 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.
  2. Write every bid with the same names. One bid line per cost account.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. 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.”

  1. Create the project in QuickBooks Online first, then in QuickBooks Time open the QuickBooks dropdown and choose Import > Projects.
  2. 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.
  3. Split by trade if you bid that way. New service items must be added in QuickBooks first, then imported into QuickBooks Time.
  4. 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 accountBidActualOver (under)
Labor18,00021,4003,400
Materials24,00023,100(900)
Subcontractors15,50017,2001,700
Equipment rental1,200950(250)
Permits and fees1,8001,8000
Dumpsters and disposal1,5002,100600
Total62,00066,5504,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?

OptionGood forWatch for
Budgets vs. Actuals on PlusBids written by cost accountOne year per budget; account totals only
Spreadsheet from a Profit and Loss by Customer exportA quick look at a few finished jobsRebuilt by hand every month
Upgrade to AdvancedLine-by-line cost estimates and the Estimates vs. actuals reportMoving open bids in; the same tagging habits
Bring in an outside team (Reports & answers)Every job compared from your booksWho 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

Have one problem in mind?

Walk us through it on a free 30-minute call. Within two business days you get a one-page note on what we’d fix first, yours to keep.

Walk us through one problemFree 30-minute call.