Guide
How do I stop re-entering the same job in my field service software and QuickBooks?
Decide which system owns each piece of information, then let data flow one way from the owner to the other. For most shops, the field service system owns customers, jobs and invoices, and QuickBooks owns the chart of accounts, bills, payroll and the bank.
Double entry and mismatched revenue both come from the same cause. Two systems are each being treated as the place where the truth is kept.
Why the two revenue numbers differ
Owners often assume one system is wrong. Usually both are right, by their own rules. The rules differ in a few predictable places.
- Timing. The field system counts a job when it is completed. QuickBooks counts it by invoice date, or by payment date if the books are on a cash basis.
- Edits after the sync. An invoice is corrected in one system after it has already copied to the other. The copy never hears about it.
- Deposits and prepayments. Money collected before the work is done is revenue in one system and a liability in the other.
- Memberships and maintenance plans. A plan sold in January may be counted at once in the field system and spread across the year in the books.
- Discounts, refunds and credits. They are applied to the job in the field system and entered separately, or not at all, in QuickBooks.
- Sales tax. One number includes it. The other does not.
- Item mapping. Price book items point at the wrong income accounts, so totals match while the categories do not.
- Duplicates. The same customer exists twice under slightly different names, and invoices attach to both.
Each of these is small. Together they produce a month-end where nobody trusts either number, and someone spends days reconciling by hand.
Why double entry starts
Nobody chooses double entry. It grows out of reasonable decisions made one at a time.
The sync was set up in a hurry during onboarding. It threw errors, so someone turned it off and typed the invoices instead. Or the sync works, but the bookkeeper does not trust it, so every invoice gets checked and corrected by hand. Or the field system was added years after QuickBooks, and the old habits stayed.
The office staff are not the problem here. They are doing the job a connection should do, and usually doing it carefully.
How to pick the system of record
A system of record is the one place where a fact is created and changed. Every other system receives a copy and does not edit it. Pick an owner for each kind of record.
- Customers and service locations: the field service system. That is where they are created and where techs see them.
- Jobs, estimates and invoices: the field service system. Invoices flow to QuickBooks and are never edited there.
- The price book: the field service system. Each item maps to one QuickBooks income account.
- Customer payments: wherever they are collected, which is usually the field system. They flow to QuickBooks once.
- Chart of accounts, vendor bills, bank and credit card activity: QuickBooks.
- Payroll: your payroll system, fed by approved time from the field system.
The hard part is not the list. It is the rule that follows from it: if an invoice is wrong, fix it in the field system and let the correction flow. Never fix it in QuickBooks. One exception, made once, brings the mismatch back.
Steps an office manager can take this week
None of these need a developer or a consultant.
- Pull last month's revenue from both systems. Write the two numbers and the difference at the top of a page.
- Check the basis. Confirm whether each report is by completion date, invoice date or payment date. Rerun them on the same basis and see how much of the gap closes.
- Pick twenty invoices at random. Compare each one line by line across both systems. Note every difference and group them by cause.
- Look at the sync log. Most field service systems list records that failed to sync. Count them and read the error messages.
- Review the item mapping. Open the price book and check that every item points at a real, current QuickBooks account.
- Search for duplicate customers in both systems. Merge the obvious ones.
- Write down who is allowed to edit an invoice, and where. Share that one rule with everyone who touches billing.
- List every place the same information is typed twice. Estimate the minutes per week for each.
By the end of the week you will know whether you have a settings problem, a habit problem or a real gap. Most shops find it is mostly the first two.
What the fix looks like
Start with what you already pay for. ServiceTitan, Housecall Pro and Jobber each offer their own QuickBooks sync. Configured carefully, it removes most double entry.
- Agree the system of record for each field, using the list above.
- Clean the data the sync depends on: duplicate customers, unmapped items, retired accounts.
- Turn the native sync on in one direction and map it deliberately.
- Run in parallel for a full month. Keep the manual process going and compare the two results at month end.
- When the numbers agree, stop the manual entry. Keep a short monthly check on failed syncs.
Custom work comes in only where the native sync stops. Common cases are job costing detail the sync does not carry, payroll built from job-based pay, or a second entity with its own books.
That is the kind of connection we build. See how we handle integrations.
When this isn't worth doing
- The gap is small and explained. If timing accounts for the whole difference, you need a note on the report, not a project.
- The volume is low. A shop writing a few invoices a day can re-key them faster than it can maintain a sync.
- You are changing field service software soon. Fix the rules now and build the connection on the new system.
- The books are months behind. Catch up first. A sync into a ledger nobody has closed will not help.
If you are weighing whether to change systems at all, this guide may help. Should we replace our field service software or extend it?
Questions owners ask
How do I get field service software and accounting to agree on revenue?
Put both reports on the same basis first — completion, invoice or payment date. Then name one system of record for invoices and stop editing them anywhere else. Most of the remaining gap comes from deposits, memberships and items mapped to the wrong accounts.
Which system should be the source of truth, the field software or QuickBooks?
The field service system for customers, jobs, invoices and the price book. QuickBooks for the chart of accounts, bills, bank activity and the financial statements. Data flows from the first to the second.
Our sync is already on. Why are we still re-entering jobs?
Usually because someone stopped trusting it. Check the failed-sync log and the item mapping. Once errors are cleared and a parallel month matches, the checking can stop.
Do I need custom software for this?
Usually not. The native sync covers most shops. Custom work is for what it leaves out, such as job costing detail or payroll built from job-based pay.
How do I know what the double entry is costing us?
List each place the same data is typed twice and the minutes per week. That gives you hours. A Profit Map goes further and prices the errors and delays that follow from it.
Prove the gap. Then close it.
The Profit Map shows what double entry and mismatched numbers cost, using your data. Or book a call and walk us through what you found this week.