
Example (made-up, exactly as in the file): a $7,590.00 Shopify Payments deposit for 140 orders is $78.22 short of the payout its orders add up to, $566.30 of it is sales tax you owe, not income, and Shopify kept $9.05 of card fees on $312.00 of refunds - money lost if you book the deposit as sales.
Try it freeFull version · $47 →
What you get: QuickBooks Online and Xero journal import files for every payout at once with your account names, all-lines CSV, the month-end close report to print/PDF, bank statement import and matching, saved…
Example (made-up, exactly as in the file): a $7,590.00 Shopify Payments deposit for 140 orders is $78.22 short of the payout its orders add up to, $566.30 of it is sales tax you owe, not income, and Shopify kept $9.05 of card fees on $312.00 of refunds - money lost if you book the deposit as sales.
Sync apps push orders into QuickBooks; this rebuilds the payout itself from your plan's card rate, the 30¢ per charge, the 1% on international cards and the $15 US chargeback fee, then writes the balanced journal entry, so you see the gap before you reconcile the bank. Type one payout from Shopify (Finance > Payouts) below; the gap and the journal entry appear at once.
| Card fees Shopify takes (rate + 30¢ per charge + 1% international) | $295.78 |
| Rebuilt payout (charges - refunds - adjustments - fees) | $7,668.22 |
| Gap: bank deposit - rebuilt payout (0.00 = reconciled) | -$78.22 |
| Debit: unreconciled difference to suspense | $78.22 |
| Credit: sales income (charges without sales tax) | $7,853.70 |
| Credit: sales tax payable (owed, not income) | $566.30 |
| Total debits (bank + fees + refunds + adjustments + suspense) | $8,420.00 |
| Total credits (sales income + sales tax payable) | $8,420.00 |
| Journal check: debits - credits (must be 0.00) | $0.00 |
| Effective card fee rate on charges | 3.51% |
| Card fees Shopify kept on refunded sales (rate part) | $9.05 |
| Share of the deposit that is sales tax you owe | 7.46% |
Full version — $21 once · The .xlsx you keep: a 31-row payout log for the month that stays red until each gap is 0.00, the month-end journal entry from its totals, the 2026 Shopify Payments rate table, a gap checklist and an empty copy
Everything updates as you type. Nothing is uploaded. This runs in your browser.
What you lose: a Shopify Payments deposit is one net number. In the made-up example the $7,590.00 deposit still holds $566.30 of sales tax you owe (7.46% of it), and it already lost $295.78 of card fees, $312.00 of refunds and a $144.00 chargeback. Booked as sales, the tax is counted as income and the fees never reach your expenses. And the deposit is $78.22 short of what its own charges add up to, money you cannot explain at month end.
The rules a calculator app does not know: Shopify Payments US online card rates are 2.9% (Basic), 2.7% (Grow), 2.5% (Advanced) and 2.25% (Plus) + 30¢ per charge, premium cards 3.5/3.3/3.1/2.95%, international cards +1% (shopify.com/pricing, read 11 November 2026). A US chargeback takes the disputed amount and a $15 fee (Shopify Help, chargeback process). On a refund, "the original credit card transaction fee isn't refunded to you" (Shopify Help, refunds): 2.9% × $312.00 = $9.05 kept in the example.
Where the gap usually is: premium cards, reserves, holds, a negative balance and adjustments all change a payout (Shopify Help, lower or missing payouts). Open the payout's transactions and look for those lines; until then the gap sits in suspense, not in sales.
What others charge: payout-to-books apps on the Shopify App Store list A2X from $29 a month, Bold QuickBooks Sync Pro $19.99 to $59.99, Bookkeep $19 to $199, Payout Match $19 and Finaloop $245 a month (read 11 November 2026). A 1-star review of Bold Sync Pro says it "does not provide the costs of the transaction for payment processing". Here the fees are the first row.
No risk: the reconciliation above is free and complete for your own payout, no sign-up. The full version is a file you own: paid once, no subscription. It does not connect to Shopify, QuickBooks or Xero; you copy the payout in and post the entry yourself.
Next step: type the journal entry into QuickBooks Online or Xero against the deposit, then look up any gap in the payout's transactions. Do it for every payout before you file sales tax for the month.
Rates are Shopify's published US rates on the date above and change; overwrite the card rate with your plan's rate.
QuickBooks Online and Xero journal import files for every payout at once with your account names, all-lines CSV, the month-end close report to print/PDF, bank statement import and matching, saved months with carry-over, one key for the team.
One payment, one licence key for this tool. The key is shown right after payment.
Bold QuickBooks Sync Pro $19.99–$59.99/month ($0.15 per order over 200 on Starter); A2X $29–$115/month by orders; Synder from $65/month; Bookkeep $19–$99/month (read 2026-11-10).
Buy the full version — $47I have a keyPaste this code into your page. It runs in your visitor’s browser and stays up to date. Nothing your visitors type is stored.
For businesses: your name and logo instead of ours, and each visitor’s result + e-mail in your inbox (only when they tick consent) — Pro from $19/month. See Pro →
shopify payout reconciliation: rebuild a payout from charges, refunds, $15 chargebacks and card fees, find the gap to the bank, get the journal entry.
Yes. The free version on this page works without an account. The full version ($47) adds: QuickBooks Online and Xero journal import files for every payout at once with your account names, all-lines CSV, the month-end close report to print/PDF, bank statement import and matching, saved…
1. Put your own numbers into the free version below — no sign-up. 2. Your result shows up right here, as you type. 3. Want to keep it, print it or do it again next time? That is what the full version adds — see "What you get".
One question, answered by the person who built it. Your email only if you want the answer sent.
For a team or company: for an invoice with your company details, a quote or several licences, write to support@getreadystack.com.
ReadyStack is a small team. We build each tool for one job people keep asking about, from the rules and sources named on the page, and we run it on the worked example you see here before it goes live.
How we check our pages: each rule names its source and the day we read it.
Something looks wrong, or you are stuck? Write to support@getreadystack.com or use the contact form. It goes to our own inbox, not to a bot.
ReadyStack
Calculators, templates and deadlines for the rules that change every year — free in your browser.