ServiceTitan QuickBooks Cleanup

The Core Problem

Three systems, three revenue numbers, and all of them are honest

Almost every ServiceTitan shop that calls us describes the same thing. The owner pulls up the ServiceTitan dashboard and sees one revenue figure. The bookkeeper pulls up the QuickBooks profit and loss and sees a different one. The bank statement shows a third. Nobody can explain the difference, so nobody trusts any of them, and decisions get made on gut feel while the file quietly gets worse.

Here is the thing worth understanding before you spend another dollar chasing it: all three numbers can be technically correct at the same time. They are measuring different things. ServiceTitan is measuring what you invoiced, tax included, memberships included, the moment the tech closed the job. QuickBooks is supposed to be measuring what you earned, which is a smaller number once sales tax and unperformed membership work come out. The bank is measuring what you were paid, which is smaller again once the processor keeps its cut and the finance company keeps its dealer fee.

The problem is not that the three numbers differ. The problem is that nobody has ever built the bridge between them, so the differences are invisible, unbooked, and growing. That bridge is what a real cleanup produces. If you want the diagnosis before the fix, read why ServiceTitan revenue does not match QuickBooks. This page is about the fix, and about the engagement that delivers it.

ServiceTitan is field service management software. In the standard setup it has no general ledger of its own: QuickBooks is the book of record, and ServiceTitan feeds it through batch export. That means every accounting mistake in your ServiceTitan configuration gets faithfully, automatically, repeatedly written into your books, month after month, until somebody stops it. For the whole picture of how the two systems fit together, start at the ServiceTitan resource hub.

Side by Side

What you see in ServiceTitan vs what lands in QuickBooks vs what the bank says

Seven transactions a home service company runs every week. Illustrative numbers, real mechanics. In every row the three systems disagree, and in every row the reason is specific and fixable.

The transaction	What you see in ServiceTitan	What lands in QuickBooks	What the bank says
A $12,000 furnace install paid on a card	Invoice total $12,000. Revenue $12,000. Job closed, tech paid, done.	Invoice $12,000, payment $12,000, and the payment parks in Undeposited Funds.	A deposit of $11,652 lands two days later. The processor kept roughly 2.9%.
Friday's card batch	Six payments totaling $8,400, closed out in one batch at end of day.	Six separate payment records, each one its own line, none of them netted.	One lump ACH of $8,157 on Tuesday. Nothing in QuickBooks equals $8,157.
A card payment that beat its invoice	Payment collected in the field and posted to the job. Looks perfect.	An unapplied customer payment with no invoice to sit against. A/R goes negative.	The deposit arrives on the normal schedule, indifferent to your export order.
A $199 annual maintenance membership sold in January	Membership sold. Two visits scheduled. Revenue recognized when a visit is performed.	The full $199 can hit income on the first visit instead of half, and again on the second.	$199 collected in January and never again. Cash and income are on different timelines.
A $14,000 system financed through GreenSky or Wisetack	Invoice $14,000, marked paid in full. The customer owes you nothing.	A $14,000 payment. Again into Undeposited Funds, batched with the card payments.	The lender remits $12,740, net of the dealer fee. The batch will never match.
Sales tax on a $10,000 job	$825 of tax on the invoice, exported as an invoice line item, not a tax rate.	$825 lands in a revenue or other income account. Income is overstated.	You remit the $825 to the state anyway. The sales tax liability report cannot see it.
A technician's Tuesday	7.5 billable hours across three jobs. Job costing shows labor on each one.	One payroll journal entry to Wages Expense. No job, no business unit.	Net paychecks and tax payments clear. The cash is right, the job cost is fiction.

The Mechanics

The six things that actually break the file

This is not a mystery and it is not bad luck. In nearly every ServiceTitan file we open, the gap between the three numbers is made of these six components, usually all six at once.

01

Merchant fees are never booked

ServiceTitan exports the gross invoice value. The bank receives the amount net of processing fees. Sell a $10,000 system on a card and the bank may receive $9,700. If that $300 never lands in QuickBooks as an expense, the account will not reconcile. Not this month, not ever. Multiply it across every card payment you took this year and you have a five-figure hole that also means your P&L never showed you what card processing actually costs.

02

Undeposited Funds becomes a landfill

ServiceTitan's default behavior sends QuickBooks payments to Undeposited Funds. That account is meant to be a holding pen you empty every time you make a deposit. Without a merchant clearing account in between, nothing ever clears it, and the balance grows every month. We routinely open files with six figures sitting in Undeposited Funds, which means the balance sheet is overstating cash. See ServiceTitan undeposited funds for the full anatomy.

03

Batch export runs in the wrong order

ServiceTitan pushes invoices, payments, adjustments and bills to QuickBooks through batch export, and the order matters more than anyone tells you. Bills should export before invoices, or consumed inventory gets mis-costed on the job it was used on. When a card processor auto-batches and a payment exports before its invoice reaches QuickBooks, the payment has no invoice to apply against and you get negative accounts receivable out of nowhere.

04

Membership revenue is recognized wrong

Memberships are the single most common source of overstated income in a ServiceTitan file. A plan with two visits a year can recognize the full annual amount on each visit instead of half. A dismissed recurring service event permanently mis-recognizes the deferred balance, and nothing ever comes back to correct it. Revenue can also land on the business unit that sold the membership instead of the one that performed the work, so your unit P&Ls are wrong too. This is the heart of ServiceTitan deferred revenue.

05

Financing payouts get batched with everything else

Third-party financing through GreenSky, Synchrony or Wisetack does not behave like a card payment. The lender pays you on its own schedule, net of a dealer fee, in its own remittance. If those financing payments and financing fees are batched together with your card payments, the batch total will never equal a bank line, and no amount of clicking will make it. Financing has to be its own payment type with its own clearing account. See ServiceTitan financing payouts.

06

Sales tax exports as a line item

When sales tax comes across as an invoice line item rather than a QuickBooks tax rate, two things break at once. Your income is overstated by the entire amount of tax you collected, which for a shop in a high-rate jurisdiction can be seven or eight percent of top-line revenue. And the QuickBooks sales tax liability report goes blind, so the number you file on cannot be pulled from your own books.

Worked Example

A month that does not tie, from a million dollars down to the bank

Abstractions do not persuade owners. Arithmetic does. So here is a clean, round month for a home service company running ServiceTitan, built from the six mechanisms above. The numbers are illustrative, but every step is a real reconciling item we book in cleanups.

What ServiceTitan says: $1,000,000

ServiceTitan reports invoiced revenue of $1,000,000 for the month. That is the number the owner quotes on the phone. It is the total face value of everything the technicians closed out, tax included, memberships included, financed jobs included, whether or not the money arrived and whether or not the work has been performed.

What the P&L should say: $907,000

Two things have to come out before that becomes earned revenue.

Sales tax: $62,000. That money was never yours. It belongs to the state and it should be sitting in Sales Tax Payable, not in an income account. Invoiced revenue net of tax is $938,000.
Membership deferral: $31,000. You sold $40,000 of annual maintenance plans this month and performed maybe $9,000 of the work. The other $31,000 is a liability, not income. Earned revenue is $907,000.

So the correct QuickBooks P&L reads $907,000, not $1,000,000. That is a $93,000 gap on a single month, and if your file has been running this way for two years, the accumulated overstatement is what your CPA is going to have to unwind at tax time, usually in a hurry and usually at their hourly rate.

What the bank saw: $871,700

Now follow the cash. Of the $1,000,000 invoiced, say $900,000 was actually collected in the month and $100,000 is still sitting in accounts receivable.

$700,000 on cards. At roughly 2.9%, the processor withheld about $20,300. The bank received $679,700, not $700,000.
$100,000 financed. The lender remitted about $92,000 after its dealer fee. The other $8,000 is a real cost of sale that nobody booked.
$100,000 in checks, cash and ACH. This lands in full. This is the only part of your cash that behaves the way your bookkeeper assumes all of it does.

Total deposits: $871,700. So ServiceTitan says $1,000,000, the P&L should say $907,000, and the bank says $871,700. Three numbers, all defensible, none equal, and roughly $28,300 of merchant and dealer fees that are real expenses and appear nowhere in your profit and loss.

Why this gets worse, not better

None of this self-corrects. Undeposited Funds only ever grows. Deferred revenue only ever drifts further from reality. Negative A/R accumulates. And because the file still opens and still prints a P&L, nothing forces the issue until a lender asks for financials, a private equity buyer starts a quality of earnings review, or the IRS asks a question. That is usually when we get the call, and it is the worst possible time to be discovering that two years of books need restating.

The Engagement

How a ServiceTitan QuickBooks cleanup actually runs

This is a defined, scoped engagement with a beginning and an end, not an open hourly meter. Here is the sequence, in the order we run it, and why the order matters.

1 Diagnostic: we read the file, not your description of it

We start with a free Audit. We look at the actual QuickBooks file and the actual ServiceTitan configuration: your Undeposited Funds balance and how old it is, whether a merchant clearing account exists, your payment type mapping, your invoice item to GL account mapping, your sales tax setup, your membership and deferred revenue configuration, your export error log, and how far your A/R has gone negative. You get a written read on what is broken and how deep it goes, whether or not you hire us.

2 Stop the bleeding before touching history

There is no point cleaning up two years of history while the export keeps writing the same errors every night. So we fix the configuration first: payment type mapping, the merchant clearing account, the batch export order so bills go before invoices, financing as its own payment type, sales tax as a tax rate rather than a line item, and the GL account mappings that throw QuickBooks error 3140. From this point forward, the file stops getting worse while we clean what is behind us.

3 Rebuild the cash path, batch by batch

This is the heavy lifting and there is no shortcut. Every merchant batch gets matched to its bank deposit, and the difference gets booked to merchant fees. Financing remittances get matched to their originating invoices and the dealer fee gets booked as a cost of sale. Once the cash path is rebuilt, the merchant clearing account clears to zero and every bank line has a home. This is the step that finally makes the account reconcile.

4 Empty Undeposited Funds and unwind negative A/R

With the cash path rebuilt, we work through the Undeposited Funds balance transaction by transaction: what was really deposited, what was double counted, what is a duplicate from a failed and re-run export, and what is genuinely still in transit. Unapplied payments get matched to the invoices they belong to, which is what pulls A/R back out of negative territory. What is left over is investigated, not plugged.

5 Restate memberships and deferred revenue

We rebuild the deferred revenue schedule from the membership data: what was sold, what has been performed, and what is still owed to the customer. Then we correct the balance, split recognition properly across the visits in each plan, and fix revenue that landed on the business unit that sold the membership rather than the one that performed the work. This is usually the single largest correcting entry in the whole cleanup.

6 Fix job cost, inventory and labor

The job costing flyout locks once an invoice is posted and exported, so payroll adjustments made afterward never reach job cost. We reconcile labor, including burden, to the jobs it belongs to, and check the burden rate is not double counting payroll costs already sitting in the account. On the parts side, a wrong price on one vendor bill permanently shifts the weighted average cost for that SKU, so we look for the bills that poisoned your part costs. Technicians can also mark materials as used without ever allocating them, in which case no job ever carried the cost.

7 Reconcile forward, then hand it back with the rules

We reconcile every account, every month, from the cleanup start date to today, and close each period as we go. Then you get the file back along with the written rules that keep it clean: the export order, the payment type map, the clearing accounts, the month-end sequence. A cleanup that does not come with the rules is a cleanup you will be paying for again in eighteen months.

What You Get Back

What a clean ServiceTitan file looks like

This is the definition of done. If a cleanup does not deliver every one of these, it was a tidy-up, not a cleanup.

Undeposited Funds sits at or near zero, and every dollar that left it was traced, not written off.

A merchant clearing account that batches in and clears out, so every card batch ties to a real bank deposit.

Merchant fees on the P&L as their own expense line, so you can finally see what card processing costs you.

Every bank and credit card account reconciled to statement, month by month, with no unexplained differences.

Accounts receivable that is not negative, with every payment applied to the invoice it belongs to.

A deferred revenue schedule that ties, with membership income recognized as the work is performed, not when it is sold.

Sales tax as a tax rate, so the liability report works and your income is not inflated by money you owe the state.

Financing payouts booked at net, with dealer fees recognized as a cost of sale instead of vanishing.

Labor in job cost, including burden, so your margin by job and by business unit means something.

A written rulebook for export order, mappings and month end, so the file stays clean after we leave.

Honest Scope

What a cleanup can and cannot do for you

We would rather tell you the limits up front than discover them together in month three.

A cleanup cannot invent data that was never captured

If technicians marked materials as used without ever allocating them to a job, that job cost is gone. We can correct the inventory value and stop the leak going forward, but we cannot retroactively reconstruct which truck used which part on which call. The same is true of labor hours never entered. Cleanup restores the integrity of the books. It does not manufacture history.

A cleanup does not fix your operations

If your pricebook is wrong, your close rate is thin, or you are underpricing installs, clean books will show you that in high definition. They will not fix it. What they will do is make every subsequent operational decision defensible, because for the first time the numbers you are deciding on are real.

It takes as long as it takes, and we will tell you how long before you commit

A single year of a straightforward file with one business unit is a different job from three years of a twelve-truck, four-unit, membership-heavy shop with a financing program and an inventory problem. After the free Audit, you get a scope and a fixed price. What we will not do is start a monthly bookkeeping engagement on a file we know is broken and quietly bill you to fix it forever.

Cleanup ends. Bookkeeping does not.

A cleanup is a one-time engagement that gets you to a trustworthy starting point. Keeping the file there is a different job, and it is the one we do every month for ServiceTitan bookkeeping services clients: the reconciliations, the deferred revenue roll, the merchant clearing, the close. If what you actually want is a named person who makes the accounting judgment calls and also knows the software, that is a ServiceTitan accountant. And if the export itself is the thing that is broken rather than the history behind it, start with ServiceTitan and QuickBooks integration.

FinTruction is based in Coppell, Texas, and works remotely with HVAC, plumbing, electrical, roofing and multi-trade home service companies across the United States. We work with ServiceTitan-run shops every day. We are not a ServiceTitan reseller and we do not sell you software. We fix the accounting underneath it.

Start with a free Audit of the actual file

Give us read access to your QuickBooks and tell us how ServiceTitan is configured. We will come back with a written read on exactly where your three numbers diverge, how much is sitting in Undeposited Funds, what your deferred revenue balance should be, and what it takes to clean it. No cost, no obligation, and the findings are yours to keep even if you never hire us.

You will know the size of the problem before you spend a dollar on the solution.

Get a Free Cleanup Audit

Answers

Frequently Asked Questions

Why does my ServiceTitan revenue not match my QuickBooks P&L?

Because they are measuring different things and nobody built the bridge between them. ServiceTitan reports what you invoiced, which includes sales tax and the full face value of memberships you have not yet performed. QuickBooks is supposed to report what you earned, which is smaller once sales tax is moved to a liability and unperformed membership revenue is deferred. When sales tax exports as an invoice line item and memberships recognize the full annual amount on the first visit, your P&L will show more income than you actually earned, and it will never agree with ServiceTitan or with reality.

Why do my ServiceTitan deposits never match my bank statement?

Merchant fees. ServiceTitan exports the gross invoice value, but the bank receives the amount net of card processing fees. Sell a $10,000 system on a card and the bank may receive $9,700. If that $300 is never booked as an expense, there is nothing in QuickBooks that equals what hit the bank, so the account cannot reconcile. Third-party financing makes it worse, because lenders such as GreenSky, Synchrony or Wisetack remit on their own schedule net of a dealer fee. Financing payments must not be batched with card payments or the batch will never match a bank line.

Why is my Undeposited Funds balance so large, and why does it never go down?

ServiceTitan's default sends QuickBooks payments to Undeposited Funds, which is meant to be a temporary holding account that empties every time you make a deposit. Without a merchant clearing account in between, nothing ever empties it, so the balance only grows. That means your balance sheet is overstating cash. Clearing it properly means matching every merchant batch to its bank deposit and booking the difference to merchant fees, which is one of the heaviest parts of a cleanup and one of the most valuable.

Why is my accounts receivable negative in QuickBooks?

Almost always because a payment exported to QuickBooks before its invoice did. The card processor auto-batches, the payment lands in QuickBooks, and there is no invoice for it to apply against, so it sits as an unapplied credit and drives A/R below zero. It can also happen when an invoice fails to export, when a batch times out, or when an invoice is voided in ServiceTitan after its payment already synced. The fix is to correct the export order and then apply each orphaned payment to the invoice it belongs to.

How does ServiceTitan get membership revenue wrong?

Several ways, all of them well documented. A membership with two visits a year can recognize the full annual amount on each visit instead of half, which doubles the income you report. A dismissed recurring service event permanently mis-recognizes the deferred balance, and nothing later comes back to correct it. And revenue can land on the business unit that sold the membership rather than the one that performed the work, so your unit level P&Ls are wrong even when the company total is right. Correcting deferred revenue is usually the single largest entry in a cleanup.

How long does a ServiceTitan QuickBooks cleanup take, and what does it cost?

It is scoped and fixed, not hourly, and both the timeline and the price depend on how many months are broken and how complex the shop is. One year of a single business unit file with a modest membership base is a very different job from three years of a multi-unit shop with a financing program and an inventory problem. We do not guess at it. The free Audit exists precisely so we can scope and price it accurately rather than open an hourly meter and hope. You will know the timeline and the number before any work begins.

Can I just fix this in ServiceTitan support?

ServiceTitan support can help you with ServiceTitan. They will tell you how a setting behaves and how the export works. What they will not do, and reasonably so, is make accounting judgment calls on your behalf: how your deferred revenue should be recognized, how to unwind two years of Undeposited Funds, whether an entry should be restated or corrected prospectively, or what your P&L should have said. Those are accounting decisions, and they need an accountant who also knows the software.

Do you also fix the ServiceTitan side, or only QuickBooks?

Both, because fixing only QuickBooks guarantees you will be back. We correct the configuration that is producing the errors: payment type mapping, the merchant clearing account, batch export order so bills go before invoices, financing as its own payment type, sales tax as a tax rate rather than a line item, and the GL account mappings that trigger QuickBooks error 3140. Then we clean the history behind it. You get the corrected file and the written rules that keep it clean.

We are preparing for a sale or a raise. Does this matter?

It matters more than almost anything else you could spend the money on. A quality of earnings review will find the overstated revenue, the missing merchant fees, the deferred revenue balance that does not tie, and the Undeposited Funds landfill, and every one of those findings costs you either purchase price or credibility. Cleaning the file before diligence starts is dramatically cheaper than defending it during diligence.

Keep Reading

More on ServiceTitan & Your Books

Why ServiceTitan Revenue Doesn't Match QuickBooks The diagnosis behind the cleanup.

ServiceTitan Undeposited Funds Why the balance never clears.

ServiceTitan Bookkeeping Services Keeping the file clean after the cleanup.

ServiceTitan QuickBooks Cleanup: Three Numbers, None of Them Agree

Three systems, three revenue numbers, and all of them are honest

What you see in ServiceTitan vs what lands in QuickBooks vs what the bank says

The six things that actually break the file

Merchant fees are never booked

Undeposited Funds becomes a landfill

Batch export runs in the wrong order

Membership revenue is recognized wrong

Financing payouts get batched with everything else

Sales tax exports as a line item

A month that does not tie, from a million dollars down to the bank

What ServiceTitan says: $1,000,000

What the P&L should say: $907,000

What the bank saw: $871,700

Why this gets worse, not better

How a ServiceTitan QuickBooks cleanup actually runs

What a clean ServiceTitan file looks like

What a cleanup can and cannot do for you

A cleanup cannot invent data that was never captured

A cleanup does not fix your operations

It takes as long as it takes, and we will tell you how long before you commit

Cleanup ends. Bookkeeping does not.

Start with a free Audit of the actual file

Frequently Asked Questions

More on ServiceTitan & Your Books

What Contracting Owners Say

Hear it straight from a contractor we work with

Find out what your books should actually say

Get your ServiceTitan books audited, free

ServiceTitan QuickBooks Cleanup: Three Numbers, None of Them Agree

Three systems, three revenue numbers, and all of them are honest

What you see in ServiceTitan vs what lands in QuickBooks vs what the bank says

The six things that actually break the file

Merchant fees are never booked

Undeposited Funds becomes a landfill

Batch export runs in the wrong order

Membership revenue is recognized wrong

Financing payouts get batched with everything else

Sales tax exports as a line item

A month that does not tie, from a million dollars down to the bank

What ServiceTitan says: $1,000,000

What the P&L should say: $907,000

What the bank saw: $871,700

Why this gets worse, not better

How a ServiceTitan QuickBooks cleanup actually runs

What a clean ServiceTitan file looks like

What a cleanup can and cannot do for you

A cleanup cannot invent data that was never captured

A cleanup does not fix your operations

It takes as long as it takes, and we will tell you how long before you commit

Cleanup ends. Bookkeeping does not.

Start with a free Audit of the actual file

Frequently Asked Questions

More on ServiceTitan & Your Books

What Contracting Owners Say

Hear it straight from a contractor we work with

Find out what your books should actually say

Get your ServiceTitan books audited, free

Construction accounting services

Popular contractor guides

Construction accounting by city