Shopify Payments payout reconciliation: match every payout to its orders, refunds and fees in KNKTD OS
One bank deposit, dozens of transactions behind it. KNKTD OS breaks every Shopify Payments payout into its charges, refunds, fees and chargebacks, checks it adds up to the cent, and gives your accountant journals that balance.
· 7 min read
In short: The KNKTD OS Payouts report reads every Shopify Payments payout and the balance transactions inside it: charges, refunds, fees, chargebacks, reserves and other adjustments, each linked to its order where there is one. It checks that those transactions add up to the amount that reached the bank, to the cent, and produces clearing-account journals for your accountant to post. It covers Shopify Payments only. PayPal and other payment methods settle to their own accounts and are reconciled from their own statements.
A Shopify Payments deposit is one line in the bank feed and dozens of events behind it. Monday's payout might hold Friday's orders, a refund from last week, a chargeback, the fee on every charge, and a hold released from a reserve. The bank shows the net. The orders show the gross. Most brands reconcile the two by downloading Shopify's payout export and working through it in a spreadsheet at month end.
The Payouts report does that work continuously, from the same records that hold the orders.
Turning it on
Payout reconciliation uses the same opt-in as payment fees on the Profit & Loss report. In Settings → Shopify, the Payment fees card has a Read payment fees switch. It is off by default. Turning it on needs a one-time reconnect so the store can grant access to its payments account, payment fees and payouts. Payouts are read, never changed.
Once it is on, an hourly sync reads payouts and their transactions. The last 30 days of payouts are read again on every run, because a payout's status keeps moving (scheduled, in transit, paid) and a bank can still reject one days after it showed as paid. History is read back 24 months in chunks, so an established store fills in over its first few runs. A store with no active Shopify Payments account is checked again on every run, so it starts syncing by itself if it switches Shopify Payments on later.
When the list is empty or incomplete, the report says why: not connected, switch off, reconnect needed, first sync still running, last sync failed, or older history still being read. It never just says "no payouts".
The Payouts report
The report lives in Analytics → Reports → Payouts and is filtered by payout date, in the workspace's reporting time zone. At the top is one card per payout currency: Paid to your bank, then what is On the way (scheduled or in transit), the Fees kept by Shopify, anything that Failed, and what is Still in the balance, meaning processed but not yet in any payout. A store paid out in two currencies gets two cards. The streams are never added together.
A Reconciliation card counts how many payouts in the range add up, how many do not, and how many have not been checked yet.
Below that, each row of the table is one deposit in the bank feed:
| Column | What it shows |
|---|---|
| Payout date | The day Shopify issued it (the bank posts it 1–3 business days later) |
| Status | Scheduled, In transit, Paid, Failed or Canceled |
| Bank reference | The reference Shopify sends to the bank, searchable |
| Charges | Customer payments paid out in this payout |
| Refunds | Refunds taken out of it |
| Adjustments | Chargebacks, reserves and other adjustments together |
| Fees | Processing fees Shopify kept |
| Net deposited | What reached the bank |
| Check | Adds up, Off by an amount, or Not yet checked |
Matching the bank feed means finding the row with the same amount and bank reference.
One payout, opened
Clicking a payout date opens its page, with the net amount, the date and the bank reference in the header. The page has four parts.
Does it add up? puts two columns side by side. One is the total of the payout's own transactions, by kind. The other is Shopify's summary of the same payout. Both end in the net deposited. If the transactions come to more or less than what reached the bank, the card says by how much and in which direction. The usual causes are transactions not synced yet or moved to another payout by Shopify. A payout that does not add up is read again once a day. When a failed payout's funds are paid again in a later one, that amount shows as its own line.
Journal is the entry that posts this payout, covered below.
What the charges paid for splits the payout's charges into products, shipping, each tax by name, duties, and anything left over such as tips or rounding. Each charge is split in proportion to its order's own figures. The page is clear that this is an allocation, not a ledger, and points to the Tax report for filing sales tax.
Transactions lists every row in the payout: date, type (Charge, Refund, Chargeback, Chargeback won, Chargeback fee, Reserve or Other), the order it belongs to, amount, fee and net. The order number links to the order in the orders module, so a chargeback or a refund leads straight to the order, its customer and its shipment.
The clearing-account method
The report is built around a clearing account, which is how many accountants handle payment processors. Sales go into a Shopify Payments clearing account when they are made. Each payout takes money out of it when it reaches the bank. Whatever is left is what Shopify Payments has charged but not yet paid out.
Each payout's journal debits the bank for the net, credits the clearing account for the charges less refunds, and debits fees and chargebacks to their own accounts. Here is an example payout with 1,000.00 in charges, a 100.00 refund, a 50.00 chargeback, and 47.00 in fees including a chargeback fee. It deposits 803.00:
| Account | Debit | Credit |
|---|---|---|
| Bank | 803.00 | |
| Shopify Payments clearing | 900.00 | |
| Payment processing fees | 47.00 | |
| Chargebacks | 50.00 |
Reserves post to Payment processor reserve, and anything else to Other payment processor adjustments. The accounts are named by what they hold, and your accountant maps them to your own chart of accounts.
The other half is the sales journal: one entry per day and currency, debiting clearing for that day's Shopify Payments charges less refunds. It credits Sales, Shipping income, each tax as its own payable (a charge carrying GST and QST posts to GST payable and QST payable), Duties collected, and other income. A charge that cannot be matched to an order posts to Sales (not matched to an order) instead of disappearing.
The Clearing account card on the report proves the two halves meet. For each currency it shows the opening balance, sales in, paid out and closing balance, and checks the closing balance against the charges and refunds that no paid payout covers yet. When they agree, it says Matches what is not paid out yet and shows how much of that is already in a payout on its way. When they do not, it shows Off by and the amount.
Exports
Four CSV downloads, with amounts in each payout's own currency:
- Export payouts: one row per payout in the range, with the same breakdown as the table.
- Export journal: the journal lines for every paid payout in the range whose transactions add up. A payout that does not add up is left out rather than posted unbalanced, and the table says how many were left out.
- Export sales journal: the daily entries into the clearing account.
- Export transactions: every transaction in one payout, with its order and the charge's split.
The journal files are plain lines (date, reference, currency, account, debit, credit, memo). Posting them to your accounting software is up to you or your accountant.
Other payment methods
Only Shopify Payments exposes payouts and balance transactions, so only Shopify Payments is reconciled here. Orders paid another way are not ignored, though. The clearing account card lists the range's totals for each other payment method, such as PayPal or manual payments, with order counts, so you know what to reconcile from those statements.
How it connects to the P&L
The transactions behind the Payouts report are the same ones the Profit & Loss report takes its Payment processing fees and Chargebacks lost lines from. The actual Shopify Payments fee on every charge, refund and chargeback comes off profit, not an estimate. For days not synced yet, a Shopify Payments rate you set can estimate the fee, and the report marks it as estimated. Other payment methods are estimated from fee rates you set for them. Cash Flow counts fees the same way, so the three reports agree on what the processor kept. The rest of the reporting, from sales velocity to margin and returns, is covered in the analytics module article.
Payouts has its own permission under reports, separate from the other reports, because bank references and deposits are finance data.
What it is not
The Payouts report is a reconciliation tool. It is not accounting software, it does not file tax returns, and it does not post to a ledger by itself. It gives your accountant a checked breakdown of every deposit and journals that balance. What they do with them stays their decision.
Pricing
The Payouts report is part of the analytics module, included on every plan. Plans start at $100 USD per month for two team members, with a 14-day free trial. See current pricing.
Bottom line
Shopify Payments payout reconciliation is tedious because the bank sees one number and the store sees hundreds. KNKTD OS reads both sides, links each transaction to its order, checks that every payout adds up to the cent, and gives the clearing account a balance you can prove. Month end then means reviewing the payouts that do not add up, not rebuilding all of them.
Frequently asked questions
How does KNKTD OS reconcile Shopify Payments payouts?
An hourly sync reads every Shopify Payments payout and the balance transactions paid out in it — charges, refunds, fees, chargebacks, reserves and adjustments — each linked to its order where there is one. The Payouts report then checks that those transactions add up to the amount that reached the bank, and marks each payout as adds up, off by an amount, or not yet checked.
Does it reconcile PayPal or other payment methods?
No. Only Shopify Payments exposes payouts and balance transactions, so only Shopify Payments is reconciled. The report lists the period’s totals for every other payment method, such as PayPal, with order counts, so they can be reconciled from their own statements.
What is the clearing-account method?
Sales go into a Shopify Payments clearing account when they are made, and each payout takes money out when it reaches the bank, so the balance is what Shopify has charged but not yet paid out. KNKTD OS exports a daily sales journal into clearing and a journal per payout out of it, and checks that the closing balance matches what no paid payout covers yet.
How do payouts connect to the Profit & Loss report?
The same synced transactions give the Profit & Loss report its Payment processing fees and Chargebacks lost lines, so the fee taken off profit is the actual fee on each Shopify Payments charge, refund and chargeback. Cash Flow counts fees the same way, so the reports agree on what the processor kept.