Where Your Numbers Live: Sage, QuickBooks and HubSpot

HubSpot forecasts revenue. Sage and QuickBooks book it. When the two disagree it's because nobody decided which number is the truth. Here's the split.

HubSpot forecasts revenue. Your accounting system books it. When the two disagree, and they will, it is almost never a sync bug. It is that nobody decided which number is the truth for which question.

This is the quietest and most expensive confusion in a contractor's stack, because the numbers look like they should match and they are not supposed to.

What number does HubSpot actually hold?

A forecast, not a fact. The deal amount in HubSpot is what you expect the job to be worth, weighted by how likely you are to win it. It drives your pipeline, your sales forecast, and your follow-up. It is a sales number.

It is not revenue. HubSpot does not know what you actually invoiced, what the owner actually paid, or what retainage is being held. Asking HubSpot "how much money did we make" gets you an estimate dressed up as an answer.

What does accounting hold?

The facts. Sage or QuickBooks owns what was invoiced, what was paid, what it cost, what revenue you can recognize, and what retainage is outstanding. These are the numbers your accountant, your bank, and the IRS care about. Accounting is the system of record for money that has actually moved or is contractually owed.

What accounting is weak at is the future. It knows what happened, not what is in the pipeline.

Where do they disagree, and why?

Everywhere a job changes between the bid and the final invoice, which is every job. The HubSpot deal was the original bid. The contract value grew with change orders. The billed-to-date number is lower than the contract because the job is in progress. The collected number is lower still because of payment terms and retainage. Four different numbers, all correct, all describing the same job at different points. They disagree because they are answering different questions.

Which number is the truth for which question?

Trouble starts when someone runs a cash decision off a HubSpot forecast, or a sales forecast off an accounting report. Each number is right for its own question and misleading for the others.

What should sync, and in which direction?

Less than people expect. A closed-won deal in HubSpot should create or flag a customer and a contract value in accounting, so the win is not re-keyed. Executed change orders should update the contract value where accounting owns it. Payment status can flow back to HubSpot so sales can see which clients are current. Beyond that, forcing the forecast and the ledger to match just corrupts both.

How to decide

For each money question your team asks in a week, write down which system should answer it. Then make sure your reports pull from that system and only that one. The goal is not one number everywhere. It is the right number for each question, and a clean handoff at the two moments that matter: won bid and executed change order.

Related: AIA progress billing and the gap ServiceIQ closes.

Knowledge Base