QuickBooks : Integrations
QuickBooks integrations: the books, app by app.
A sync moves transactions into QuickBooks; it doesn't prove they belong there. This reference takes eight sales, payment, payables and field-service apps and sets out what each vendor documents about its QuickBooks connection, the report the books have to agree with, and the exception the vendor itself warns about.
Reviewed before delivery: before the file comes back to you, each account in it is reconciled to its statement and anything unresolved is written down. The six review steps.
Every app statement here comes from that vendor's own pages (help centers, developer docs, integration pages), linked where it is stated and checked November 2026.
Quick answer
Whatever the app syncs, each payout must equal a bank deposit, with the gross sales, fees, refunds and holds behind it in their own accounts. Post them through one clearing account per app; if it is back at zero after each deposit, the payout ties. The matrix names the vendor report that proves it for each app.
This reference belongs to QuickBooks bookkeeping and file management. A sync that has already gone wrong? Go straight to the cleanup.
The tie-out rule
A payout equals a deposit, and a clearing account per app proves it.
When an app keeps its fees and refunds before paying out, the bank sees only the net. The books need the whole payout: sales at gross, each deduction on its own line, and the deposit clearing what is left. Posted through one clearing account per app, the payout and the deposit meet at zero.
Illustrative example — not client data. Assumptions stated.
| Entry | Debit | Credit | Amount | Taken from |
|---|---|---|---|---|
| Sales in the payout | Payout clearing | Sales | $1,000.00 | The payout detail, gross column |
| Fees the app kept | Merchant fees | Payout clearing | $30.00 | The payout detail, fees |
| Refund paid out of the payout | Sales refunds | Payout clearing | $50.00 | The payout detail, refunds |
| Payout reaches the bank | Checking | Payout clearing | $920.00 | The bank statement |
| Clearing balance after the deposit | — | — | $0.00 | $1,000.00 − $30.00 − $50.00 − $920.00 |
Assumptions: one payout covering one week of card sales, with the fees and one refund taken out before the money was sent; no reserve, chargeback or sales tax in the period; the deposit has posted to the bank by the time the month is closed. The amounts are invented.
A balance left in clearing after a payout points to one of three things: a payout dated in one month and deposited in the next, money the app is still holding back, or a sale recorded twice, once by the sync and once when the bank deposit was added as income. The month-end schedule names which one it is.
Reference matrix
Eight apps, the record each payout ties to, and the exception each vendor documents.
Each cell restates that vendor's own documentation, and the last column links the pages with the date they were checked. Where a vendor documents no QuickBooks connector, the cell says so.
| App | What it syncs to QuickBooks | The record the books must show | The exception the vendor documents | The proof | Vendor sources |
|---|---|---|---|---|---|
| Shopify | Store sales: not documented publicly by the vendor. The Help Center pages checked don't describe what the QuickBooks Online app syncs; one tells merchants on QuickBooks Online to install it. Documented: a Shopify Balance account syncs its Shopify Balance transactions into QuickBooks Online. | Each Shopify Payments payout: a net amount, an issue date and a summary of fees and gross amounts by transaction type. Processing fees are deducted before the payout is sent. | A reserve holds part, sometimes all, of the transactions for a set period. After a payout is marked Deposited, Shopify says to allow 1 to 3 business days for the bank. | Each deposit equals one payout's net; the summary's gross, refunds and fees clear the store's clearing account to zero. | Help Center: Shopify Balance and QuickBooks Online; Help Center: QuickBooks integration; Dev Docs: payout object; Help Center: lower or missing payouts; Help Center: reserves. Checked November 2026. |
| Stripe | Not set out here; whatever connector a file uses is checked against the payout reconciliation report. | The Payout reconciliation report, matching each payout to the payments and other transactions it relates to; per payout, an Itemized CSV of every payment, refund, dispute and fee. | Stripe can't identify which transactions an instant payout contains; reconciling it is the account holder's job. The report groups a payout by estimated arrival date, and a payout might arrive before its reconciliation data is ready. | Each standard payout's itemized lines total its deposit; instant payouts are matched by hand against the transaction history before the close. | Stripe Docs: payout reconciliation report. Checked November 2026. |
| Square | Per Intuit's help for the QuickBooks Online Square Connector, a payout added to the books records a bank deposit linked to its sales and fees, and fees import as an expense with each sales receipt. | Each transfer under Banking, View all transfers, with the card payments included in it and a CSV export. Net total is total collected minus fees minus other withholdings. | Payments accepted after the daily transfer cut-off can land in the following transfer. With Square same-day transfers, a daily balance over $10,000 arrives as multiple transfers. | Each transfer's card payments, less fees, equal its deposit; a day's missing payments are found in the next transfer before anything is called short. | QuickBooks Help: Square Connector; Support Center: match transfers to sales; Support Center: sales summary; Support Center: transfer options. Checked November 2026. |
| PayPal | Not documented publicly by the vendor. PayPal's statements help page gives no QuickBooks import steps and sends QuickBooks users to Intuit's support site; activity downloads as a QuickBooks file, among others. | The Balance report: all payments, disputes and fee-incurring events, on the PayPal website or by SFTP, for reconciling sales, refunds, disputes, fees and withdrawals against end-of-day balances. | Net-billed fees come off the balance at the time of the transaction; gross-billed fees, such as IC++ fees, are billed periodically and not deducted from the transaction. | Each withdrawal matches a bank deposit, and the account's balance in the books agrees with the report's end-of-day balance at month-end. | PayPal: statements and reports; PayPal Developer: Balance report. Checked November 2026. |
| Amazon | Not documented publicly by the vendor. Amazon's Selling Partner API documentation index doesn't mention QuickBooks; for order finances it documents the Finances API. | The Flat File V2 Settlement Report for Seller Central sellers: every charge and fee in amount-type, amount-description and amount, with settlement-id, start and end dates, deposit-date and total-amount. | Settlement reports can't be requested or scheduled; Amazon schedules them automatically. | Each settlement's total-amount equals the deposit on its deposit-date, and its amount-type rows clear the settlement to zero. | SP-API docs: documentation index; SP-API docs: settlement reports. Checked November 2026. |
| Toast | Through xtraCHEF: the chart of accounts and vendors import into xtraCHEF; xtraCHEF invoices sync as Bills, deposits and returns as Vendor Credits; Toast sales data posts as a Journal Entry in QuickBooks Online. | The Reconciliation report: every payout sent to the bank, with Payout Details splitting card payments, refunds, fees and withholdings. The Credit column is the amount sent, net of fees, withholdings, refunds and chargebacks. | The Sent date is the deposit date, not the sales date. xtraCHEF raises an alert when Toast sales data changes after that day's entry synced; the fix is to check that day's numbers and re-upload the journal entry if needed. | Each payout's Credit equals one deposit, and its Payout Details tie back to the sales entries for the days it covers. | Toast Central: xtraCHEF and QuickBooks Online; Toast Central: Reconciliation report; Toast Central: sales sync help. Checked November 2026. |
| BILL | Not set out here; whatever the sync posts is checked against BILL's payment detail. | One debit a day for all check payments processed that day, so individual check numbers don't need matching. | ACH: the funding account is debited on the process date and the vendor credited after 2-3 US business days. Checks expire after 90 days and are voided, funds returned; virtual cards expire after 20 days and are reissued as check or ACH. | Each daily check debit equals that day's check payments; each ACH debit matches its payment on the process date. | BILL Developer docs: disbursement methods. Checked November 2026. |
| Jobber | One-way, Jobber to QuickBooks Online: clients, products and services, invoices and payments. Jobber Payments payouts can sync with their fees, which go to a Jobber Payments Fees account. | The Jobber Payments payouts report: each payout into the bank account, including instant payouts and their fees. | Instant payouts can't be reconciled until the next standard payout is created. With payout syncing off, payments arrive at the full amount in Unapplied or Undeposited funds. | Each deposit equals its payout less the fees moved to their own account; nothing is left in the holding account. | Help Center: how items sync; Help Center: fees and payouts sync; Help Center: reconcile Jobber Payments. Checked November 2026. |
Checked: , every cell against the vendor page linked in its row. Vendors change their documentation without notice, so each row carries the date its pages were last read. Each app has its own section below, with what can go wrong in the vendor's own words and what we take on for it.
Shopify
Shopify sends payouts net of processing fees, so the books rebuild the gross.
- What it does in QuickBooks
- The QuickBooks Online connection documented in Shopify's Help Center is for Shopify Balance: a Balance account can be connected to QuickBooks Online to sync its Shopify Balance transactions. For store sales, the Help Center pages we checked don't describe what the QuickBooks Online app syncs; the QuickBooks Desktop page tells merchants on QuickBooks Online to install that app to integrate their data. What it posts in a given file is read from the file, not assumed.
- What the records must show
- Shopify's developer docs describe each Shopify Payments payout as a transfer from the Shopify Payments balance to the bank account, with a net amount, an issue date and a payout summary breaking fees and gross amounts down by transaction type: charges, refunds, adjustments. Because Shopify deducts each transaction's processing fees before the payout is sent, the books carry the gross from that summary and the fees as their own expense.
- What can go wrong
- A Shopify Payments reserve is a temporary hold on a portion, in some cases all, of the transactions for a specified period, so a payout can arrive lower than the sales behind it. And once Shopify marks a payout Deposited, its help says to allow 1 to 3 business days for the bank to process it: a payout dated on the last day of a month can reach the bank in the next.
- How the reconciliation proves it
- Each bank deposit is matched to one payout's net amount, and the summary's gross, refunds and fees clear the store's clearing account to zero. Whatever remains is either a reserve still held or a payout still in transit, and the month-end schedule says which.
- What we take on
- Store payouts mapped through a clearing account in your own file and tied out at each monthly close; or, where payouts were booked as sales and the fees went missing, a file cleanup of the months affected. Selling on more than one channel is covered on e-commerce bookkeeping.
Stripe
Stripe's payout reconciliation report ties each payout to the transactions inside it.
- What it does in QuickBooks
- Not set out here. Whatever connector carries Stripe's sales into QuickBooks, its postings are checked against the payout report below.
- What the records must show
- Stripe's Payout reconciliation report matches the payouts received in the bank account with the batches of payments and other transactions they relate to. For one payout, its Itemized CSV lists every payment, refund, dispute, fee and other balance transaction included. That file is the posting source: sales at gross, fees and disputes each on their own line.
- What can go wrong
- Stripe can't identify which transactions an instant payout contains, because the account holder controls its timing and amount; reconciling instant payouts against the transaction history is left to the account holder. The report also groups a payout by its estimated arrival date, not the date the bank posts the deposit, and a payout might arrive before its reconciliation data is ready.
- How the reconciliation proves it
- Each standard payout's itemized lines add up to its deposit and clear its clearing account. An instant payout is matched line by line against the transaction history before the month closes, and a payout near month-end is checked against the date the bank actually posted it.
- What we take on
- Each payout posted from its itemized detail rather than as a single deposit, as part of your monthly books; or a cleanup of the QuickBooks file when months of payouts sit in it as sales. The channel side of an online business is on bookkeeping for online sellers.
Square
Square lists the card payments inside each transfer, and that list is what a deposit ties to.
- What it does in QuickBooks
- Intuit's help for the QuickBooks Online Square Connector says that when a payout is added to the books, the app records a bank deposit that links with the individual sales transactions and fees, and that fees on sales import as an expense with each sales receipt.
- What the records must show
- In the Square Dashboard, Banking, then View all transfers lists each transfer; a transfer's details show the individual card payments in it, and Export downloads the transaction details as a CSV file. Square's sales summary defines Net total as total collected minus fees minus other withholdings, so the books carry the collected amount and the fees, not the net alone.
- What can go wrong
- Square's help says payments accepted after the daily transfer cut-off can be included in the following transfer, so one transfer may not show every payment expected for that day. With Square same-day transfers, a daily balance over $10,000 arrives as multiple transfers, per Square's transfer options.
- How the reconciliation proves it
- Each transfer's card payments, less fees, are matched to its deposit. Payments missing from one day's transfer are looked for in the next before anything is booked as short, and several transfers on one day are added back together against that day's sales.
- What we take on
- The connection's sales, fees and payouts mapped to your chart and cleared when the books are closed each month; or a QuickBooks file cleanup when the imported transfers no longer tie to the deposits. How a day's sales feed the ledger of a food business is on books for restaurants and cafés.
PayPal
PayPal's Balance report is the record for reconciling sales, refunds, disputes, fees and withdrawals.
- What it does in QuickBooks
- Not documented publicly by the vendor. PayPal's statements and reports help page gives no QuickBooks import steps of its own; it sends QuickBooks users to Intuit's support site for downloading transaction history directly into QuickBooks. The same page says transaction activity downloads for up to the past seven years as a PDF, Quicken, QuickBooks, CSV or TAB file, up to 12 months per request.
- What the records must show
- PayPal's Balance report lists all payments, disputes and fee-incurring events, is available on the PayPal website and the SFTP server, and is for reconciling sales, refunds, disputes, fees and withdrawals against end-of-day PayPal balances. The books follow it: sales at gross, fees as an expense, withdrawals as transfers to the bank.
- What can go wrong
- In PayPal's Balance report, net-billed fees are charged at the time of the transaction and deducted up front from the balance, while gross-billed fees, such as interchange plus plus (IC++) fees, are billed periodically and not deducted immediately from the transaction. One month's fees can therefore turn up in two different places.
- How the reconciliation proves it
- The account is kept as its own bank-type account. Each withdrawal matches a bank deposit, the balance in the books agrees with the report's end-of-day balance on the last day of the month, and periodically billed fees are posted when billed, so sales are not reduced twice.
- What we take on
- The account reconciled to its month-end balance under ongoing monthly bookkeeping; or cleanup work on the file when downloaded activity was imported over months already entered. Running sales from several channels through one account is covered on multichannel seller bookkeeping.
Amazon Seller Central
Amazon's V2 settlement report carries every charge and fee a deposit is made of.
- What it does in QuickBooks
- Not documented publicly by the vendor. Amazon's Selling Partner API documentation index doesn't mention QuickBooks; for financial information on orders it documents the Finances API. That check covers Amazon's developer documentation only.
- What the records must show
- Amazon's Flat File V2 Settlement Report is a tab-delimited file for Seller Central sellers that puts every charge and fee into three columns, amount-type, amount-description and amount, where the type columns name the charge or fee. Each report also carries a settlement-id, a settlement start and end date, a deposit-date and a total-amount, alongside per-row transaction-type, order-id and sku.
- What can go wrong
- Amazon's settlement reports cannot be requested or scheduled; Amazon schedules them automatically. The books therefore work to Amazon's settlement periods, each with its own start and end date, rather than to dates the seller picks.
- How the reconciliation proves it
- Each settlement's total-amount equals the bank deposit on its deposit-date. Its rows, summed by amount-type, post to sales, fees and refunds, so the settlement's clearing account ends at zero.
- What we take on
- Each settlement posted from its report, summarized by amount-type, at every month's close; or a cleanup of the affected months when deposits were booked as sales and the fees didn't reach the ledger. Marketplace selling alongside other channels is on marketplace seller bookkeeping.
Toast
Toast posts its sales to QuickBooks Online as a journal entry, through xtraCHEF.
- What it does in QuickBooks
- Toast's QuickBooks Online integration runs through xtraCHEF: it imports the chart of accounts (general ledger codes) and vendors into xtraCHEF, syncs xtraCHEF invoices as Bills, syncs deposits and returns as Vendor Credits, and posts Toast sales data as a Journal Entry in QuickBooks Online.
- What the records must show
- Toast's Reconciliation report lists every payout Toast sent to the bank account, with any instant deposit transactions, for a location and date range; each payout's Payout Details break it into card payments, refunds, fees, withholdings and a transaction-by-transaction list. On that report, the Credit column is the amount sent to the bank, minus fees, withholdings, refunds and chargebacks.
- What can go wrong
- On Toast's report, the Sent date is the date the deposit happened, not the date of the sales, so a payout covers sales from earlier dates. And xtraCHEF raises a sync alert when Toast sales data changes after that day's entry has synced to QuickBooks; the stated fix is to double-check that day's numbers and re-upload the journal entry if needed.
- How the reconciliation proves it
- Each payout's Credit equals one bank deposit, and its Payout Details tie back to the sales journal entries for the days it covers. A day flagged as changed after its sync is checked against the point of sale before the month closes.
- What we take on
- The sales journal mapped to your chart and each payout cleared against it, month after month; or a file-level cleanup when changed days were left un-uploaded and sales stopped agreeing with deposits. The wider restaurant ledger, tips and prime cost included, is on the restaurant books page.
BILL (bill.com)
BILL makes one debit a day for every check it processed that day.
- What it does in QuickBooks
- Not set out here. Whatever the sync posts to QuickBooks Online is checked against the payment detail BILL's developer docs describe below.
- What the records must show
- BILL's developer docs say it makes a single debit for all check payments processed in a single day, so individual check numbers don't need to be matched. The bank line to tie is the day's debit; the payments behind it are the bill payments the sync posted.
- What can go wrong
- For BILL ACH payments, the funding account is debited on the payment process date and the vendor's bank account is credited only after BILL waits 2-3 US business days for the debit to settle. BILL checks expire after 90 days and are voided automatically, with the funds returned to the funding account; an unprocessed virtual card expires after 20 days, is voided, and BILL reissues the payment as a check or ACH.
- How the reconciliation proves it
- Each daily check debit equals the sum of that day's check payments, and each ACH debit matches its payment on the process date. A returned expired check and a reissued card payment each appear once, reversing or replacing the original, so the vendor's balance stays right.
- What we take on
- Payables tied to the ledger and each debit matched, as part of monthly books in your own file; or a cleanup of the file's payables when voided and reissued payments have left vendor balances wrong. Running payables and receivables end to end, approvals and payment runs included, is AP and AR management.
Jobber
Jobber syncs one way, from Jobber to QuickBooks Online.
- What it does in QuickBooks
- Jobber's QuickBooks Online integration is one-way: clients, products and services, invoices and payments sync from Jobber to QuickBooks. Jobber can also sync Jobber Payments payouts, including the fees; the fees from each payout are removed from the deposit into the Checking account and allocated to a Jobber Payments Fees account.
- What the records must show
- Jobber's Jobber Payments payouts report shows each payout of funds into the bank account, including instant payouts and instant payout fees. Every deposit on the bank statement should be one line on that report.
- What can go wrong
- In Jobber's payout sync, instant payouts cannot be reconciled until the next standard payout is created. And when payout syncing is not enabled, Jobber Payments sync to QuickBooks at the full payment amount, allocated to Unapplied funds or Undeposited funds.
- How the reconciliation proves it
- With payout sync on, each deposit equals its payout less the fees moved to their own account. With it off, the payments held in the holding account are grouped into each deposit and the difference is posted as fees, so the holding account returns to zero.
- What we take on
- Payout sync mapped and each instant payout cleared once the next standard payout lands, every month; or a QuickBooks cleanup when months of payments are stranded in a holding account. Job costing for contractors is on construction and trades bookkeeping.
Native or third-party
Who builds the connection changes what you can check, not what the books must show.
Some connections are documented. Jobber publishes what its side sends to QuickBooks, Toast routes its side through xtraCHEF, and for Square, Intuit's help sets out the QuickBooks Online connector, as their rows above show. Those pages are the specification a file can be checked against.
Some document none. For store sales on Shopify, and on PayPal and Amazon, the vendor pages we checked set out no QuickBooks sync of their own. There, the vendor's own payout or settlement report is the record, and any connector's postings are checked against it.
Whichever route a file uses, the test from the top of this page holds: each payout clears its clearing account to zero against the deposit. No connector is chosen here on price or promoted; deciding which apps to connect at all is part of QuickBooks consulting.
When a sync breaks
A broken sync is repaired from the vendor's reports outward, not from the file inward.
The file is the thing in doubt, so it can't be the reference. The repair starts from the vendor's record of what was paid out and works back into QuickBooks.
Stop new postings
The connection, or the bank rule auto-adding its deposits, is paused while the damage is measured, so fresh entries don't land on top of it.
Pull the vendor's record
Every payout, transfer or settlement for the months affected, from the reports named above, set beside the bank statements for the same months.
Rebuild through clearing
Each payout's gross, fees, refunds and holds are posted through the clearing account and its deposit matched; duplicates from the sync or the feed are excluded.
Remap, restart, prove
The account mapping is corrected, the connection restarted from a clean date, and its first month put through the clearing-account test before it is trusted.
A broken sync over sound records is a QuickBooks cleanup ($850–$2,500, file-only scope). When the months underneath need rebuilding too, it is a bookkeeping cleanup ($1,800–$6,000). Keeping every connection tied after that is part of the monthly bookkeeping service ($550–$1,800 a month). Each is a fixed fee, scoped in writing after the free books review. What the range covers.
Everholt & Co. is not affiliated with any app named here; the names describe the subject.
FAQ · Updated November 2026
What owners ask about apps that sync to QuickBooks.
Will you set up the QuickBooks connector for my app?
Which payment, sales and payables apps do you reconcile in QuickBooks?
What if the app sync and the bank feed both record the same sales?
Is integration work a one-time fix or part of monthly bookkeeping?
Why doesn't my payout match the sales for that day?
Should I use a connector app or import the payout reports myself?
The vendor pages behind these answers: Shopify's payouts help, Stripe's payout reconciliation report, Square's transfers help, PayPal's Balance report, Amazon's settlement reports, Toast's Reconciliation report, BILL's disbursement methods and Jobber's payouts reconciliation help. Each is also cited in the matrix and in that app's own section.
Sources — checked November 2026: Amazon Selling Partner API docs — documentation index; Amazon Selling Partner API docs — Settlement Reports; BILL Developer docs — AP payment disbursement methods; Jobber Help Center — How Items Sync Between Jobber and QuickBooks Online: NEW QuickBooks Integration (updated October 29, 2026); Jobber Help Center — How Jobber Payments Fees and Payouts Sync to QuickBooks Online (updated October 29, 2026); Jobber Help Center — How to Reconcile Jobber Payments with QuickBooks (updated June 6, 2023); PayPal — How to View and Download Statements and Reports; PayPal Developer — Balance Reconciliation report (last updated October 13, 2026); QuickBooks Online Help — Connect and manage Square transactions in QuickBooks Online (updated August 5, 2026); Shopify Dev Docs — ShopifyPaymentsPayout object (GraphQL Admin API 2026-10); Shopify Help Center — Connecting your Shopify Balance account to QuickBooks Online in the United States; Shopify Help Center — Integrating QuickBooks Desktop accounting software with Shopify; Shopify Help Center — Navigating your Shopify Payments payouts to resolve lower or missing payouts; Shopify Help Center — Overview of reserves in Shopify Payments; Square Support Center — Match transfers to sales; Square Support Center — Set up and edit transfer options; Square Support Center — View sales summary, sales trends and payment methods reports; Stripe Docs — Payout reconciliation report; Toast Central — Reconciliation Report and Payout Details Overview (last updated September 17, 2026); Toast Central — xtraCHEF: Get Help With Sales Syncs to QuickBooks (last updated July 7, 2026); Toast Central — xtraCHEF: Get Started With QuickBooks Online Sales Syncing (last updated August 24, 2026).
Get a free books review
Let us test what your apps are posting.
Give us access to the QuickBooks file and the apps' payout reports. We run each connection against the deposits, name what it is posting wrong, and tell you whether the fix is a mapping change, a file cleanup or a records job. The free books review closes with a written scope and one fixed fee; no price is guessed on the call.