How do bookkeepers catch sync errors across many client QuickBooks files? 4 steps
By the ReconoSync team · Published · Updated
Bookkeepers catch sync errors across many client QuickBooks files by keeping a weekly list of every book, clearing each field-app error log, then matching that week’s payout or batch report, Undeposited Funds, and bank statement. Failed exports show in the log. Silent mismatches show when those three lists disagree.
This is the weekly pass for a bookkeeper who closes several ServiceTitan, Housecall Pro, or Jobber shops in QuickBooks Online. A field service management system, or FSM, is the shop’s job, invoice, and payment app. A batch is the group of payments meant to equal one bank deposit. A payout is that deposit hitting checking, often net of processing fees.
Two kinds of errors
The native sync posts invoices and payments. Catching what it got wrong is a second job. Mix them and you spend month-end inside one file while the other nine drift.
| Kind | Where it shows | What it is | What it is not |
|---|---|---|---|
| Export failure | Jobber, ServiceTitan, or Housecall Pro error log | A record that never posted: closed period, duplicate invoice number, missing tax rate | A payment that posted twice |
| Silent mismatch | Payout report vs Undeposited Funds vs the bank | Duplicate payment, fee-netted deposit, missed bank-feed line | An item sitting in the error log |
The native sync wins the posting job. It is included with the FSM on the plans that offer it. Its log is the right first stop. It does not see a line that already posted.
Keep one list of every client book
You cannot catch errors across files if you only remember which book you opened last. One row per client: the FSM, last payout date, last bank rec date, open error-log count, and the Undeposited Funds balance.
Intuit’s client-list help, updated 2026-08-17, is All Apps, Clients, Client list, then the Bookkeeping tab. The Books review column shows which clients still have open month-end tasks. Intuit’s Books review help, updated 2026-08-07, flags uncategorized transactions, transactions without payees, and unapplied payments inside each file.
Add the columns Intuit does not have: FSM error-log count, last payout or batch ID you matched, and whether Undeposited Funds holds only this week’s unsettled cards. A spreadsheet next to that tab is enough. One bookkeeper on r/Bookkeeping in August 2024 described a Google Doc per client for review notes, so the same miss is not asked twice.
Switch files and clear the native log
Intuit’s switch-companies help, updated 2026-08-05, is GO TO QUICKBOOKS in the toolbar, then the company. When you are done, open the dropdown beside the client name. Select Back to practice, or the next company.
Same four steps, every file, every week: native FSM error log; Books review Transaction review and Account reconciliation; this week’s payout or batch report against Undeposited Funds and the bank; write the result on the tracker, then switch. Open the FSM first, while you still remember which shop you are in.
| FSM | Where the log lives | What it lists |
|---|---|---|
| Jobber | Gear, Connected Apps, QuickBooks, or the top-nav alert | Errors that blocked posting. Warnings that posted, then changed. Jobber’s common-errors help, updated 2026-08-21 |
| ServiceTitan | Reports, Legacy Reports, Pending Export | Posted transactions not yet exported, plus rows still on error. Pending Export Report, updated 2026-03-27 |
| Housecall Pro | QuickBooks icon, Sync Alerts | Invalid item, duplicate name, tax rate that does not match, closed period, invoice number already taken. Housecall Pro Sync Alerts, updated 2026-09-03 |
On Jobber, clear Clients, then Products, then Invoices, then Payments, then Payouts. A later error often cascades from an earlier one. Filter ServiceTitan to Show Only Errors. On Housecall Pro, resolve the alert in QuickBooks first, then Sync again. Do not Dismiss unless you already posted that invoice by hand and wrote the memo.
Keep the sync on. Jobber’s connect help, updated 2026-04-08, says disconnecting and reconnecting to the same QuickBooks company can reset sync mappings if you choose Reset and Import. Work the failed exports. Then check the books.
Match the four lists the log never sees
A payment that posted twice does not appear in the error log. Neither does a deposit that hit the bank net of fees while Undeposited Funds still holds gross, nor a bank-feed line that never arrived. Those show when you pull four lists.
| List | Where | What it shows |
|---|---|---|
| FSM payout, batch, or invoice list | Jobber Payments Payouts, ServiceTitan Bank Deposits, Housecall Pro My Money | Gross, fees, net, which invoices were in the lump |
| Undeposited Funds | Chart of accounts, detail type Undeposited Funds, even if renamed Payments to deposit | Each exported payment as its own line |
| Bank statement | The bank, not the feed | Each posted lump, once |
| Bank feed | All apps, Accounting, Bank transactions | For review, Categorized or Posted, and Excluded |
One bookkeeper on r/Bookkeeping in March 2026 described pulling the Jobber Payments Payout report, matching each payout to the bank, then building the QuickBooks deposit from Undeposited Funds so the total equaled gross minus fees. A firm with many Jobber clients said the same on r/Bookkeeping in September 2026: the bank deposit is the truth, and everything else is a component of it. Reconcile weekly. The longer you wait, the harder the match.
Do not type a new deposit for the bank total so the rec screen clears. That double-counts the cash. Group the payments you already have, put the fee on that deposit, then Match. Intuit’s categorize help, updated 2026-08-24, treats Categorize or Post as a new ledger entry. Turn auto-add off on any bank rule that posts processor deposits to income. The statement is the list you reconcile. The feed is only what the bank sent QuickBooks.
Fix the extra copy with how to find duplicate transactions in QuickBooks Online. The Jobber pair is how to fix duplicate payments from the Jobber QuickBooks sync. Two invoices for one Housecall Pro job is why Housecall Pro creates duplicate invoices in QuickBooks. Gross next to a net bank line is how to reconcile ServiceTitan deposits in QuickBooks Online. A missing feed line is why the QuickBooks Online bank feed is missing transactions.
What Books review catches, and what it misses
If you work in QuickBooks Online Accountant, Books review is the in-file pass you already have. Open the client company. Select Books review. On Transaction review, work uncategorized lines, missing payees, and unapplied payments. On Account reconciliation, use Select accounts so the list is the accounts you actually rec.
It wins the QuickBooks-file job. Uncategorized spend, an unapplied payment, and a bank that has not been rec’d this month all show without opening the register by hand. The Client list Bookkeeping tab then shows which files still have open tasks.
It stops at the FSM. Books review does not read a ServiceTitan deposit report, a Housecall Pro payout, or a Jobber Payments Payout report, and it does not match a batch ID to the bank. A review layer that scans many QuickBooks files will flag duplicates and stuck Undeposited Funds inside the file the same way. It still will not tell you this week’s settlement is short of the payments in Undeposited Funds. You still pull that report. Tools that check the field-app sync after the fact are a separate list: best software to check field service app syncs to QuickBooks for errors.
After you find the extra copy
Confirm the cash hit the bank once. Keep the copy that is applied, deposited, or already marked R or C. Prefer exclude or void with a memo over a bulk delete. Do not undo the FSM sync wholesale. Do not undo the whole reconciliation for one extra line.
| Where the extra copy sits | What to do |
|---|---|
| FSM error log | Fix the cause, then retry. Clients, then products, then invoices, then payments, then payouts |
| For review | Exclude. Undo from Excluded if you miss |
| Categorized or Posted | Undo, then Match or Exclude |
| Unapplied payment in Undeposited Funds | Void the unapplied copy after the payout report confirms one cash event |
| Second invoice for one job | Void the extra invoice with a memo that names the job and the invoice you are keeping |
A clearing account, reconciled by a careful bookkeeper who records cash only in the FSM and Matches the bank feed, still ties out.
How to tell this week is closed
| Check | Closed looks like |
|---|---|
| Native error log | No open errors. Warnings you already accepted are noted on the tracker |
| Books review | Transaction review and Account reconciliation are done for this week, or parked with a reason |
| Undeposited Funds | Holds only payments that have not hit the bank yet |
| Payouts | Last week’s processor lumps are matched. Deposit totals equal the statement to the cent, fees on the same deposit |
| Tracker | Every client row has this week’s payout ID, or a written gap |
If a row still has a gap, leave it unmatched until you know which list is wrong. A bad match in QuickBooks makes AR look cleaner than it is.
Pull this week’s payout or batch report from Jobber, ServiceTitan, or Housecall Pro, the QuickBooks Undeposited Funds detail, the bank statement, and the native error log for each client. Start with those files. They already exist.
Frequently asked questions
Can QuickBooks Online Accountant show every client's sync errors on one screen?
The Client list Bookkeeping tab, updated 2026-08-17, shows Books review status per client, including uncategorized bank lines, unapplied payments, and recon progress. It does not list Jobber, ServiceTitan, or Housecall Pro export errors. Those live in each field app. Open that company, then that shop's error log.
Does a clean field-app error log mean that client's books tied out?
No. Jobber's error log, updated 2026-08-21, lists records that failed to export. A payment that posted twice, a deposit net of fees, or a bank-feed line that never arrived does not appear there. ServiceTitan's Pending Export Report and Housecall Pro Sync Alerts work the same way. Pull the payout report and the bank.
Should I wait until month-end to check every client file?
No. One bookkeeper on r/Bookkeeping in March 2026 said to reconcile weekly, not monthly, because matching gets harder as payouts pile up. Run the same pass each week. Native log, payout or batch report, Undeposited Funds, and the bank statement. Write the result on the tracker, then switch files.
Should I type a new deposit so the bank rec clears?
No. That records the cash a second time. Group the payments already in Undeposited Funds, put the processor fee on that deposit, then Match the bank feed. Intuit's categorize help, updated 2026-08-24, treats Categorize or Post as a new ledger entry. A bank rule that auto-adds processor deposits to income does the same overnight.