Why doesn't AR aging in QuickBooks match ServiceTitan? 6 causes

By the ReconoSync team · Published · Updated

They don’t match because ServiceTitan’s AR report includes invoices and payments that have not landed in QuickBooks, and QuickBooks ages only what it received, often on a different as-of date and due date. Fix the source, then re-run both reports as of the same day.

A field service management system, or FSM, is the shop’s job, invoice, and payment app. ServiceTitan is that FSM. QuickBooks Online is the books. The native sync posts the invoices and payments so you are not retyping them. An A/R aging report groups unpaid customer balances by how long they have been outstanding. Each system builds that list from its own file.

Two reports, two lists

ServiceTitan’s AR Transactions report, read 2026-10-09, is outstanding invoices as of a date you pick, with aging buckets, unapplied payments, and a Net Amount column. Intuit’s A/R aging help, updated 2026-08-05, is the same job on the QuickBooks file.

List What it shows Why it disagrees
ServiceTitan AR Transactions Open invoices as of that date, including unapplied payments you leave on Pending, posted-not-exported, and bypassed items still live here
ServiceTitan Pending Export Report Posted invoices and payments that have not successfully exported This is the usual gap
QuickBooks A/R aging Open invoices and credits that actually exist in the file Only what exported, aged from QuickBooks due dates
QuickBooks customer One customer’s invoices, payments, and credits A payment on the parent and an invoice on a location look like two people

ServiceTitan’s own AR-to-GL troubleshooting, read 2026-10-09, says to run AR Transactions, compare the total to Accounts Receivable on the balance sheet for the same date, and post any pending batches.

The export never landed, or only part of it did

Invoices and payments in ServiceTitan are posted, then exported, as separate batches. Until both sides of a job have exported, ServiceTitan still ages the job and QuickBooks does not.

ServiceTitan’s Pending Export Report, read 2026-10-09, lists posted invoices and payments that have not successfully exported, plus export errors. Not seeing an invoice in QuickBooks Online, read 2026-10-09, is the usual miss: a batch can show Exported while individual items still sit Pending. Bypass marks the row Exported in ServiceTitan and never creates it in QuickBooks. In-progress jobs cannot be batched. Zero-dollar payments do not transfer.

ServiceTitan’s collect-what-you’re-owed help says it outright: “Exported” does not mean fully synced. If QuickBooks rejected a record, the batch can still say Exported. Always read the per-record status. One bookkeeper on r/Bookkeeping in June 2026 described the connection dropping and leaving a backlog of unexported payments.

Search QuickBooks by invoice number before you re-export. Confirm against the Pending Export Report. Prefer exclude or void with a memo over a bulk delete.

Payments without their invoice, and negative AR

ServiceTitan’s payments overview, read 2026-10-09, is apply, batch, post, export. A positive payment credits Accounts Receivable and debits Undeposited Funds. Invoice batches are a different export. If the invoice is still pending, on error, or bypassed, the payment can still go. QuickBooks then holds an unapplied credit. That customer goes negative on the A/R aging, and the invoice still looks open in ServiceTitan.

TxnID Cannot Be Linked, read 2026-10-09, is the other half of the same mess. ServiceTitan’s common QBO errors, read 2026-10-09, say it usually happens when the customer on the invoice was changed after export, so the payment cannot find the invoice. Object Not Found is the invoice that was deleted in QuickBooks after it exported. Bypass that payment and enter it by hand against the invoice that is actually there, after you confirm both files.

AR Transactions can split Open Invoice and Unapplied Credit into their own columns. QuickBooks nets them on the customer. The company total can look close while the buckets and the customer rows do not. Apply the credit. The click path is how to fix Unapplied Cash Payment Income in QuickBooks Online. Payments that did export still sit in Undeposited Funds until you group them; that is a bank-deposit job, covered in how to reconcile ServiceTitan deposits in QuickBooks Online. Why the batch still disagrees with the bank is why ServiceTitan batch deposits don’t match the bank.

Credits and adjustments in one file only

You cannot edit an invoice after it has exported to QuickBooks Online. ServiceTitan’s adjustment-invoice help, read 2026-10-09, is the correction path: add an adjustment invoice, batch it, export it. A net-positive adjustment exports as an invoice. A net-negative adjustment exports as a credit memo. Write-offs, refunds, and cleared balances all use that same document.

If the adjustment exists only in ServiceTitan, ServiceTitan’s AR drops and QuickBooks still ages the original invoice. If someone voids or credits only in QuickBooks, the next ServiceTitan payment cannot link. ServiceTitan’s collect-what-you’re-owed help also flags a known issue: a negative adjustment invoice exported without an associated payment may use items from the original invoice, overstating the credit. Verify the credit memo after export. Do not journal the gap to Accounts Receivable; those journals bypass the customer sub-ledger.

The as-of date and the due date are different jobs

Totals can match and the buckets still disagree.

ServiceTitan’s AR Transactions As of Date shows outstanding invoices on or before that date. Their example is a $100 invoice dated 3 March with a $20 payment dated 1 April: as of 31 March the invoice still shows $100. Intuit’s match-aging help, updated 2026-08-04, says the QuickBooks aging report defaults to Current, which is why it will not match a balance sheet or a ServiceTitan as-of report. Set Aging to Report date, and use the same calendar day on both reports.

The buckets are a second mismatch. ServiceTitan excludes invoices with no payment term from the aging columns; those amounts sit in Net Amount. ServiceTitan’s due-date help, read 2026-10-09, says ServiceTitan does not export the invoice’s payment term to QuickBooks Online. QuickBooks then applies its preferred invoice term, so due dates land days after the invoice date. QuickBooks ages from that due date. ServiceTitan ages from its own terms. The 1–30 and 31–60 columns will not line up until the terms match.

Invoices edited or voided after export

ServiceTitan’s QBD-versus-QBO help, read 2026-10-09, says editing exported invoices is not supported for QuickBooks Online. If someone changes the customer, amount, date, tax, or line items in QuickBooks, or deletes the invoice, later payments fail with TxnID Cannot Be Linked or Object Not Found. Put the QuickBooks invoice back to the ServiceTitan values, or bypass the payment and apply it by hand after you confirm both files. Keep the memo.

Location versus customer

ServiceTitan’s AR Transactions lists Customer Name as the Bill To and Location Name as the service location. ServiceTitan’s QBD-versus-QBO help, read 2026-10-09, says an account can be configured so QuickBooks Online creates a sub-customer per location and exports invoices and credit memos there instead of the parent. That is optional.

When it is on, ServiceTitan still ages the Bill To. QuickBooks ages each location as its own customer. The company total can match while the customer rows look like a different list. Sub-customer export also fails when the parent is not in QuickBooks yet, or when a location name already exists as a customer, vendor, or employee. Fix the name, then export.

Tie both reports out

Run ServiceTitan AR Transactions as of month-end. Run the QuickBooks A/R aging summary for that same date with Aging set to Report date. Compare the two totals.

If the totals disagree, open the Pending Export Report. Export or fix what is still pending or on error. Search QuickBooks for every bypassed invoice; those are in ServiceTitan and not in QuickBooks by design.

If the totals agree and the customers do not, pick the largest gap and go invoice by invoice. Apply unapplied payments. Export missing adjustments. Reassign the QuickBooks invoice to the same customer name as ServiceTitan, then apply the payment.

If the totals and the customers agree and the buckets do not, the due dates are different. Set QuickBooks terms, or accept that ServiceTitan is aging from terms QuickBooks never received.

Check each fix against ServiceTitan’s export history first. Prefer exclude or void with a memo over a bulk delete.

What still works

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. A careful bookkeeper who exports both sides of each job, applies the payments, and runs both agings as of the same date does tie out.

Pull last month’s ServiceTitan AR Transactions, the Pending Export Report, the QuickBooks A/R aging summary for that same as-of date with Aging set to Report date, and the customer that is off. Start with those four files. They already exist.

Frequently asked questions

Does ServiceTitan export payment terms to QuickBooks Online?

No. ServiceTitan's due-date help, read 2026-10-09, says payment terms export automatically only for QuickBooks Desktop and Intacct. QuickBooks Online applies its own preferred invoice term, so due dates and aging buckets can disagree even when the invoice totals match. Set the preferred term in QuickBooks, or set terms on individual invoices after export.

Why is a customer negative on the QuickBooks AR aging after a ServiceTitan payment?

The payment exported without an invoice to apply to, or it landed on a different customer. ServiceTitan exports invoices and payments as separate batches. An unapplied payment is a credit on that QuickBooks customer. Apply it once the invoice is in QuickBooks under the same name. Do not type a second payment.

What does Exported mean if the invoice is not in QuickBooks?

ServiceTitan's collect-what-you're-owed help, read 2026-10-09, says Exported does not mean fully synced. A batch can show Exported while one record still sits on Error. Bypass marks it Exported in ServiceTitan and never sends it. Check the Pending Export Report and search QuickBooks by invoice number before you re-export.

Should I journal the AR difference so QuickBooks matches ServiceTitan?

No. A journal to Accounts Receivable bypasses the customer sub-ledger. ServiceTitan's own AR-to-GL troubleshooting names those journals as a cause of mismatch. Fix the missing invoice, unapplied payment, or unexported adjustment, then re-run both reports as of the same date.

How do I run both AR reports as of the same date?

In ServiceTitan, run AR Transactions and set As of Date. In QuickBooks Online, run Accounts receivable aging summary, set that same date as the report period, and set Aging to Report date, not Current. Intuit's match-aging help, updated 2026-08-04, is that click path. Then compare totals, then customers, then invoices.

Related

Set up your client books

Month-to-month. No card needed today. Privacy