How to clean up a messy ServiceTitan QuickBooks integration? 7 steps
By the ReconoSync team · Published · Updated
Clean a messy ServiceTitan QuickBooks integration by stopping duplicate posting, then tying Undeposited Funds, AR, and the bank to last week’s settlement report before you touch history. Keep the native sync. Void confirmed extras with a memo. Do not disconnect or re-export wholesale.
This is the click path for a bookkeeper who inherited several ServiceTitan shops in QuickBooks Online. A field service management system, or FSM, is the shop’s job, invoice, and payment app. ServiceTitan is that FSM. A batch is the group of invoices or payments meant to export together. The processor payout is the lump that hit checking.
What the mess looks like
Income is high. Undeposited Funds will not zero. AR aging in QuickBooks does not match ServiceTitan. The Pending Export Report still has errors. One bookkeeper on r/Bookkeeping in July 2026 described about $20,000 of ServiceTitan deposit-report lines that never hit the bank, and about $50,000 of bank deposits missing from the ServiceTitan report. Treat those as unverified. Treat the lists as separate.
| Symptom | What is usually true |
|---|---|
| Two invoices with the same number | Someone typed it in QuickBooks, then exported it |
| Two Receive Payment records for one job | Sync posted it, and the bank feed or a typed payment posted it again |
| Undeposited Funds keeps growing | Payments exported, never grouped, or the bank line was Categorized |
| AR aging disagrees | Pending, bypassed, or unapplied items live in one file only |
| Batch says Exported, invoice missing | Per-record status is still Error or Bypass |
| Two deposits for one bank line | Touchless journal plus a deposit built from Undeposited Funds |
Stop writing the same cash twice
Do this before you void anything.
- Record invoices and payments only in ServiceTitan. ServiceTitan’s QBD-versus-QBO help, read 2026-10-15, says editing exported invoices is not supported for QuickBooks Online. A customer or amount change in QuickBooks is how later payments fail with TxnID Cannot Be Linked.
- On the bank feed, take Match. Intuit’s categorize help, updated 2026-08-24, treats Categorize or Post as a new ledger entry. Turn off bank rules that auto-add processor deposits to income.
- Do not disconnect ServiceTitan to refresh it. ServiceTitan’s QBO onboarding, read 2026-10-15, disconnects business units from Settings, Integrations, QuickBooks Online. That does not remove what already posted. Intuit’s duplicate-transactions help, read 2026-10-15, says reconnecting a bank account downloads past dates again.
- Search QuickBooks by invoice number before you re-export. ServiceTitan’s not-seeing-an-invoice help, read 2026-10-15, says a batch can show Exported while one record still sits Pending, and a bypass still shows Exported but never creates the invoice.
Leave the live ServiceTitan payment alone. Recording it again in QuickBooks is how income doubles.
Pull the four lists
| List | Where | What it shows |
|---|---|---|
| Pending Export Report | Reports, Legacy Reports, Pending Export | Posted invoices and payments that have not successfully exported, plus errors |
| ServiceTitan deposit or settlement | Accounting, Bank Deposits, or Adyen or TSYS Settlement | Gross, fees, net, which payments were in the lump |
| Undeposited Funds | Chart of accounts, detail type Undeposited Funds | Each exported payment still waiting on a Bank Deposit |
| Bank statement | The bank, not the feed | Each posted lump, once |
ServiceTitan’s Pending Export Report, read 2026-10-15, is also the bypass screen. Bypass marks the row Exported in ServiceTitan and never sends it. Use it when the invoice is already in QuickBooks. QBO onboarding tells you to leave Accounts Receivable and Undeposited Funds active. Deactivating either one dumps the next export somewhere Match cannot see.
Fix mapping so new exports land
The backlog will refill if pricebook items, payment types, and names are still wrong. Open the Pending Export Report with Show Only Errors. ServiceTitan’s common QBO errors, read 2026-10-15:
| Error | What to do |
|---|---|
| Duplicate Document Number | Search QuickBooks. Same invoice: bypass. Different job, same number: change the ServiceTitan number, then export. |
| Duplicate name already exists | A customer, vendor, or employee already uses that name. Rename the QuickBooks record, then retry. |
| GL account does not exist | Map the pricebook item to an account already in QuickBooks, or create that account first. |
| TxnID Cannot Be Linked | Customer changed after export. Reassign the QuickBooks invoice to the ServiceTitan name, then retry. Object Not Found: invoice was deleted in QuickBooks. Bypass the payment and enter it by hand. |
| AccountRef is missing | Payment type has no GL account, or Export As is Payment, which always goes to Undeposited Funds. Set a GL account only for Journal Entry. |
Clear Undeposited Funds against the bank
Payments that exported sit in Undeposited Funds at gross. The bank shows one processor lump, often net of fees. Until those payments sit on one Bank Deposit that equals the bank line, Match has nothing the same size.
That grouping is how to reconcile ServiceTitan deposits in QuickBooks Online. Why the lists disagree is why ServiceTitan batch deposits don’t match the bank. ServiceTitan’s Adyen autobatching help, read 2026-10-15, uses a $5,000 gross deposit with $125 of fees, Total $4,875. Put the fee as a negative line on the same deposit.
If the bank is already reconciled and Undeposited Funds is still huge, the cash was Categorized. Undo those added lines from Categorized or Posted, then Match them to the deposits you build. Do not journal Undeposited Funds to income to force a zero.
On a Touchless shop, ServiceTitan’s setup guide, read 2026-10-15, says to clean Undeposited Funds first. Match the bank line to the journal ServiceTitan already sent. A second deposit is the same cash twice.
Remove confirmed duplicates
Confirm the cash hit the bank once. Keep the copy applied to the invoice and linked to a deposit, or the copy marked R or C. Intuit’s duplicate-transactions help, read 2026-10-15, is statement first, then the register sorted by amount. Match the bank download to the ServiceTitan entry, or exclude the extra copy.
Intuit’s void-or-delete help, updated 2026-09-07, lets you void payments and invoices. Void keeps a zero record. Deleted lines cannot be restored. Add a memo with the ServiceTitan invoice number and “duplicate of export already in the file.” Finding twins is how to find duplicate transactions in QuickBooks Online. If the extra copy is still on the Pending Export Report, bypass it.
Tie AR as of one cutoff date
Run ServiceTitan AR Transactions as of a date you pick. Run the QuickBooks A/R aging summary for that same date with Aging set to Report date. Compare totals, then customers, then invoices. That comparison is why AR aging in QuickBooks doesn’t match ServiceTitan.
Do not journal the gap to Accounts Receivable. ServiceTitan’s collect-what-you’re-owed help, read 2026-10-15, says manual journals posted directly to AR bypass the sub-ledger and create discrepancies. Export or bypass what is still pending. Apply unapplied payments. Export missing adjustment invoices.
Historical mess: pick a cutoff
Pick a Monday. From that date forward, new invoices and payments export once and Match the bank. Work backward one week at a time.
Do not undo the ServiceTitan sync wholesale. Do not bulk-delete Undeposited Funds. Do not open a new QuickBooks company while the live shop is still exporting into the old one. If the shop wants Touchless later, export existing batches, clean Undeposited Funds, and reconcile AR first. Switching the path is not the cleanup.
What never to do
| Move | Do it? |
|---|---|
| Disconnect ServiceTitan to refresh the integration | No |
| Re-export a batch without searching QuickBooks | No |
| Categorize the processor lump as income | No |
| Journal Undeposited Funds or AR to force a zero | No |
| Edit an exported invoice in QuickBooks Online | No |
| Void a payment marked R or C | No |
| Run Touchless and the Undeposited Funds deposit on the same cash | No |
The native ServiceTitan sync wins the posting job. It is included with the FSM and creates the invoices and payments so you are not retyping them. Undeposited Funds, reconciled by a careful bookkeeper who records cash only in ServiceTitan and Matches the bank feed, does tie out. Someone still has to group the payments and pick the extra copy.
If a payment was recorded twice, confirm it against the settlement report before you void either QuickBooks copy. Keep the memo. Prefer exclude or void with a memo over a bulk delete.
Pull last week’s ServiceTitan deposit or Adyen or TSYS settlement report, the Pending Export Report, the Undeposited Funds detail, the QuickBooks A/R aging for that same as-of date, and the bank statement. Start with those five files. They already exist.
Frequently asked questions
Should I disconnect ServiceTitan from QuickBooks to clean it up?
No. Disconnecting does not remove what already posted. ServiceTitan's QBO onboarding, read 2026-10-15, disconnects business units from Settings, Integrations, QuickBooks Online. Intuit's duplicate-transactions help, read 2026-10-15, says reconnecting a bank account downloads past dates again. Search QuickBooks first. Bypass what is already there.
Should I re-export a batch that already shows Exported?
Not until you search QuickBooks by invoice number. ServiceTitan's not-seeing-an-invoice help, read 2026-10-15, says a batch can show Exported while one record still sits Pending, and a bypass still shows Exported but never creates the invoice. Duplicate Document Number means that number is already in QuickBooks. Bypass that row.
What if Undeposited Funds is huge and the bank is already reconciled?
The payments exported. The bank lines were likely Categorized as income. Undo those added lines from Categorized, group the payments into Bank Deposits that equal the statement, then Match. Do not journal Undeposited Funds to income to force a zero. ServiceTitan's Touchless setup, read 2026-10-15, says to clean that account before you change the export path.
Should I switch to Touchless Integration to clean this up?
No. Touchless is a new posting path. ServiceTitan's setup guide, read 2026-10-15, says to clean Undeposited Funds, reconcile AR, and export existing batches first. Running Touchless on top of the old Undeposited Funds path creates two QuickBooks deposits for one bank line. Finish the cleanup on the path the shop is on.