Who this is for
- US Shopify store owners, as sole proprietors, partnerships or corporations, who keep their own books
- Stores whose payouts, bank deposits, sales reports and Forms 1099-K do not agree
- Stores that also take payments through another gateway
Not covered here
- Which states to collect sales tax in, and filing the returns
- Where sales and fees go on the income tax return
- Whether to import every order or post payout summaries
- Correcting a wrong or duplicate Form 1099-K
- Inventory and cost of goods sold
Why doesn't my Shopify payout match my sales for the same days?
A Shopify payout is a net transfer sent on Shopify's payout schedule, while a sales report adds up orders by the day they were placed. They differ by everything taken out of the payout and by the dates each one uses. Shopify's help page on lower or missing payouts (vendor documentation) lists the usual causes. Shopify can change screens and timing, so check its current help pages. The fix is to stop comparing a payout with sales: match one payout to one bank line, then record that payout's sales, refunds and fees from its export. The steps are below.
| Why the two differ | What happens |
|---|---|
| Different dates | An order is dated when it is placed. A payout follows the daily, weekly or monthly schedule you choose, counts business days only (payout timing), and can take 1 to 3 more business days to reach the bank |
| Netting | Fees come out of each charge before the payout is sent. Refunds, disputes, adjustments, reserves and holds also change the payout; each is covered below |
| Other payment providers | Orders paid through another gateway are not in Shopify Payments payouts at all |
A store is no longer simple when more than one provider sends payouts or a Form 1099-K, payouts arrive in more than one currency, a reserve or negative balance is open, the store moved into an LLC or S corporation during the year, or months of payouts were never matched. Those cases turn on which numbers are right for which year, not on a better export.
Gather before you start: every payout export for the period, the bank statements for the account that receives payouts, the order export, a list of refunds and chargebacks, and each provider's Form 1099-K. The method that works for every payment platform is in Reconciling sales, payouts and Form 1099-K.
Which Shopify screen shows what: the Payouts page, the payments activity report or the sales reports?
Use the Payouts page to match one deposit, the payments activity report to check a period, and reports built from orders for sales. Shopify says the activity report is not a statement of revenue for accounting purposes (vendor documentation).
| Where | What it shows | Use it for |
|---|---|---|
| Payouts page | Each payout by date, with status, payout ID, amount, destination bank account, bank reference and a breakdown of charges, refunds, adjustments, fees, reserves and retried payouts (payout details) | Matching one payout to one bank line |
| Payout transactions export (CSV) | One line per transaction: date, type, order, card brand, card source, payout status, payout date, available-on date, amount, fee and net | Building the entry for one payout and finding the orders and refunds inside it |
| Payments activity report | Shopify Payments balance activity for a date range and one payout currency: starting balance, charges, refunds, disputes, adjustments, fees, reserves and holds, payouts, ending balance. It leaves out Shopify billing fees and third-party payment providers, and lags about 3 days | A month-end check of what Shopify still owes you |
| Reports built from orders and sales | Sales by order date | Sales by period; Shopify says their totals and timing can differ from the payments report |
A gap between order-date sales and balance activity can arise with no error, because they measure different things. A gap that stays after you list refunds, fees, reserves and timing needs a closer look.
How do I match one bank deposit to one Shopify payout?
Match on three things in order: the payout amount, the bank reference (also called the trace ID) and the date the money reached the bank. Then match the payout's transactions to your orders.
- On the Payouts page, open the payout and note its ID, status, amount and bank reference.
- Find the bank line for that amount. Shopify says a payout marked Deposited can take 1 to 3 business days to appear, and weekends and holidays add time. Not every bank uses the reference, so a missing reference does not mean the money did not arrive (vendor documentation).
- Export the payout's transactions. Shopify defines net as the amount less the fee, so add up the net column and compare it with the payout amount. If they differ, compare the file with the breakdown on the payout's page (adjustments, reserves, retried payouts) before you book anything.
- Put the payout ID in the memo of the entry and tick the bank line off against it.
A payout date can list more than one payout, so match each payout, not the day. The IRS says to make sure the bank statement, your checkbook and your books agree, and to reconcile each month.
How do I record a Shopify payout: sales, fees, refunds, chargebacks and the deposit?
Record each part of the payout in its own account through a Shopify clearing account, then match the bank deposit to the clearing account, not to sales. The clearing account holds what Shopify owes you until the money reaches your bank. This is a tracing method, not an IRS-prescribed entry: the IRS lets you choose any recordkeeping system that clearly shows your income and expenses.
| Line in the payout | Book treatment | Why |
|---|---|---|
| Customer charges | Sales | Gross receipts. Form 1099-K gross is not reduced for fees, refunds or discounts, and the IRS says you can deduct those items from the gross amount (IRS) |
| Sales tax collected for a state | Liability, not sales, when the tax is imposed on the buyer | Publication 334: buyer-imposed sales tax you must collect and pay over is not income. Tax imposed on you as the seller goes in gross receipts. Your state decides which applies |
| Refunds | Reduce sales (returns and allowances) | Publication 334: credits for returned merchandise are deducted from gross sales |
| Processing fees | Expense, shown on its own | Shopify does not return the original card fee when you refund (vendor documentation), so a refunded order still carries its fee |
| Chargeback | Keep the disputed amount in clearing while it is open; if lost, treat it as a refund | Shopify takes the disputed amount and dispute fees from the payout |
| Dispute fee | Expense | A cost of selling |
| Adjustments | Read the line type first | Shopify says adjustments can raise or lower a payout |
| Reserve held or released | Stays in clearing | Not an expense, and not a new sale when it is released |
| The deposit | Bank in, clearing out | A transfer, never a second sale |
Post one entry per payout: credit sales and any sales tax collected (to its liability account), debit returns and fees, and debit clearing for what Shopify still owes you, any reserve included. Post the deposit as a second entry; only the amount that reached the bank leaves clearing. A payout date is when Shopify pays you, not when the sale was made, so date Entry 1 on purpose. Dated by order, sales match the sales report: take each sale and refund from the payout export on its own date, and add orders not yet in any payout from the order export, which the payout exports leave out. They sit in clearing. Dated by payout, the books are simpler, but sales run behind the sales report and can land in the wrong year; use it only if the year-end rules below count the payout date as your income date. Pick one approach and use it all year. When both entries are in, the clearing account for that payout is back to zero, except for any reserve. If a connector or bank feed also creates the sale or the deposit, income can be counted twice: see Duplicate income in your books. Whether to post every order or only payout summaries is in Every order or payout summaries.
Why is my Shopify payout lower than expected, or missing?
Usually because the payout was reduced by something on the list below, or because the money is still on its way to the bank. Shopify's lower or missing payouts page gives these causes.
| Cause | What Shopify says | In the books |
|---|---|---|
| Refunds | The refunded amount comes out of the next available payout. In the US, if the balance cannot cover a refund, the shortfall is debited from the bank account (refunds) | Reduces sales. A bank debit for a refund is a refund, not an expense |
| Chargebacks | The disputed amount and dispute fees are deducted | Clearing while open; refund if lost; fee is an expense |
| Adjustments | Can increase or decrease the final amount | Identify the line, then book it |
| Reserve | A temporary hold on part, in some cases all, of transactions; released into later payouts, sometimes as one large amount if released early (reserves) | Stays in clearing; a later payout can exceed that period's sales |
| Payout hold | Usually delays the entire payout; in some cases only part of the funds is held back and the rest is paid | Clearing |
| Negative balance | The payout can be reduced to cover past fees or refunds that exceeded earnings | Clearing; lowers a later payout |
| Currency | If the payout currency differs from the selling currency, conversion applies and fees might apply | Book the amount that was paid; see Foreign currency accounts in US books |
| Bank details | A wrong number gives a Failed status; a change does not redirect a payout already in transit | The payout stays in clearing until it arrives |
If a deposit is missing, Shopify's steps include confirming the status is Deposited, waiting 1 to 3 business days, checking that the bank details match, checking for holds, and giving the bank the trace ID; if the bank needs more detail, give it the settlement date, amount and currency. Keep the unmatched payout in clearing until it lands.
What about orders paid outside Shopify Payments, such as another gateway?
Treat each payment provider as its own source, with its own clearing account, payouts and Form 1099-K. Shopify's payout pages and activity report cover Shopify Payments; the activity report leaves out third-party processors and third-party payment methods (vendor documentation).
- Payouts: the other provider pays on its own schedule, and its statements, not Shopify's, explain its deposits.
- Two sets of fees: Shopify says a store using a third-party provider pays a transaction fee to Shopify and the provider's card fees (payout fees). Shopify billing fees are outside the activity report, so match them to the card or account that paid them.
- Orders paid another way: cash, bank transfer and similar payments reach neither provider's payouts. Track them as their own source.
- Check: split the order export by how each order was paid. Each total should be explained by one provider's statements.
Why do Shopify revenue and my books disagree at month-end or year-end?
Shopify revenue follows orders and your bank follows payouts, so the difference is money Shopify still owes you. The clearing account should hold that balance every month-end.
At month-end, if sales are dated by order, the clearing balance should equal payouts not yet sent, payouts sent but not yet in the bank, and any reserve. If they are dated by payout, it should hold payouts sent but not yet in the bank, and any reserve. Shopify's Payouts page shows a Pending amount (money captured but not yet in a scheduled payout, reserve excluded) and a Reserve amount (reserves). Compare the clearing balance with the activity report's ending balance for the same dates and currency, plus any payout in transit. Shopify does not say whether pending or reserved amounts are in that balance, so check the report's reserves and holds group before you treat a difference as an error. The report lags about 3 days, so run it after month-end has settled. A difference often traces to a payout, refund or day that is missing or counted twice, or to a fee, reserve or currency effect.
Refunds posted in a later month than the sale, orders on another provider, fees billed outside the payout and edits to a closed month also open month-end gaps.
At year-end, the result depends on your accounting method (Publication 538):
- Accrual: income generally counts in the year all events fixing your right to it have occurred and the amount can be determined with reasonable accuracy, so an order that is complete in December is December income even if the payout lands in January. Money received before the goods ship can fall under the advance payment rules, which are for your preparer.
- Cash: income counts when you actually or constructively receive it. Money credited to your account or made available without restriction counts; money received by your agent counts; substantial restrictions on your control can mean it does not.
Whether money sitting in a Shopify Payments balance or reserve at year-end counts as received depends on facts such as whether the processor acts as your agent and what restrictions apply. The sources do not settle it for every store. A store that sells merchandise should settle its method with its preparer before year-end: Cash or accrual for a small business.
Why is my Shopify 1099-K different from payouts and from sales?
Form 1099-K box 1a is gross payments before fees, refunds, shipping and discounts, counted in the year the issuer submits the instruction to transfer the funds, so it matches neither net payouts nor order-date sales. The IRS instructions define gross amount as the total without regard to credits, discounts, fees, refunded amounts, shipping or other amounts.
| What you are comparing | Why it differs |
|---|---|
| Form against payouts | Refunds, fees, disputes, adjustments and reserves come out of payouts but not out of the form. A reserve released from an earlier period can also raise a payout |
| Form against sales | Sales tax paid with the sale can be in the form's gross though it is not your receipts (Publication 334). Orders paid another way are not on it, and orders on another provider are on that provider's form |
| Form against the year of sale | A payment counts in the year the issuer submits the instruction to transfer the funds (instructions), not the year of the order |
| Form against the entity | A change of business entity or tax ID can leave the form not matching the new entity's return (IRS) |
To bridge one form:
- List every Form 1099-K by issuer, named in the Filer box. Bridge each form on its own.
- Start from box 1a. Boxes 5a through 5l show the gross by month, so compare month by month.
- Compare box 1a with that processor's gross charges settled in the same year, from the payout files. Settle missing, duplicate and other-payee transactions first.
- Then run two separate bridges, as in Reconciling sales, payouts and Form 1099-K: from gross payments to your book sales (sales tax in the gross, other providers, orders paid another way, timing), and from gross payments to bank deposits (refunds, fees, disputes, reserves, backup withholding). Box 4 shows backup withholding, which applies when a payee's tax ID was not furnished as required (instructions). It is tax withheld for you, not a fee.
The box at the top of the form that says Payment card or Third party network decides the rule, and the Filer box names who sent it. Payment card transactions are reported no matter how many payments or how much. Third party network transactions, from a payment app or marketplace, are reported above $20,000 in more than 200 transactions. A form can still arrive below that, and a state may set a lower threshold (IRS FAQs). One filer sends separate forms for the two types (instructions). A store that takes payments through several providers can get several forms. Without a form you still report the income (IRS). Do not post the form as sales: it is a check on books that already hold the sales.
If a form is duplicated, names the wrong payee or shows a wrong amount, the IRS says to ask the issuer for a corrected form, that the IRS cannot correct it, and not to wait to file. See Wrong or corrected platform tax form.
What do I give a bookkeeper or CPA from a Shopify store?
Give the payout, order, bank and form records for every provider and every month, plus the list of what was refunded or disputed.
| Gather | What it settles |
|---|---|
| Payout transaction exports for the whole period | Each payout's sales, refunds, fees and adjustments |
| Payments activity report for each payout currency, saved as a PDF | Balances at each month-end |
| Order export with refunds, for every channel | Gross sales by order date |
| Bank statements for the account that receives payouts | Which deposits were payouts |
| Each provider's statements and every Form 1099-K | Gross by provider, for the bridge |
| List of refunds and chargebacks, with dates | Which payouts they reduced |
| Shopify bills and invoices for plans and apps | Fees that are not in payouts |
| Sales tax reports | Tax collected, kept apart from sales |
| The opening clearing balance and last year's return | Where this year starts |
Keep these records until the period of limitations for the return runs out (Publication 583): generally 3 years after filing, 6 if the return left out income of over a quarter of the gross income shown, and with no limit for a return never filed. See How long to keep business records.
Example
These examples are illustrative. All amounts are in US dollars.
One payout
Orders paid are $5,000, refunds are $400 and processing fees are $150. The payout and the bank deposit are $4,450. The export's net column adds up to $4,450.
| Entry 1: the payout | Debit | Credit |
|---|---|---|
| Shopify clearing | $4,450 | |
| Sales returns and allowances | $400 | |
| Processing fees | $150 | |
| Sales | $5,000 |
| Entry 2: the deposit | Debit | Credit |
|---|---|---|
| Bank | $4,450 | |
| Shopify clearing | $4,450 |
The books show $5,000 of sales, $400 of refunds, $150 of fees and $4,450 in the bank. Clearing is zero. The example has no sales tax, shipping or reserve.
Orders placed December 30, paid out January 3
Orders of $3,000 are placed and shipped on December 30 and paid out on January 3. Ignore fees and refunds. On an accrual basis the sales belong to December; dating them by payout would put them in January. Orders paid for but not shipped by December 31 are a separate question for the preparer. The books carry $3,000 in Shopify clearing at December 31 and the January deposit clears it. On the cash method the answer depends on whether the money counts as received by year-end, which is a question for the preparer. If the processor submits the transfer instruction in January, the payment also falls in the next year's Form 1099-K, so the December books and the December form will not agree.
An S corporation with two providers
An S corporation store takes $180,000 through Shopify Payments and $60,000 through another gateway. It receives two Forms 1099-K totaling $240,000 and deposits of $226,000. Bridged one form at a time, the gap is refunds and fees.
| Shopify Payments | Other gateway | Total | |
|---|---|---|---|
| Form 1099-K, box 1a | $180,000 | $60,000 | $240,000 |
| Refunds | -$5,000 | -$1,500 | -$6,500 |
| Fees | -$5,500 | -$2,000 | -$7,500 |
| Deposits | $169,500 | $56,500 | $226,000 |
Books that show $226,000 of sales may have recorded deposits as sales. Books that show $240,000 of sales, $6,500 of refunds and $7,500 of fees tie to both forms and to the bank. The figures assume no sales tax, shipping, reserve or timing differences; a real form needs those checked first.
Different for you?
- Shopify revenue, payouts and your books still disagree after a full year: the open months may need a bridge, and a filed year that booked deposits as sales may need to be rebuilt from the payout files, depending on what was filed. Bring the payout exports, bank statements and every Form 1099-K to bookkeeping; for longer gaps see Catching up on overdue books.
- More than one provider sent a Form 1099-K and the totals do not bridge: each form needs its own bridge, and one of them may be wrong or belong to another payee. Take the forms and statements to bookkeeping; for a wrong form see Wrong or corrected platform tax form.
- The store moved into an LLC or S corporation during the year: the IRS says an entity or tax ID change can leave the form not matching the new entity's return. Tell the processor of the new name and tax ID right away, and keep records that support the income and deductions of both entities. Settle that with bookkeeping; see also Books after an S corporation election.
- Payouts landed in a personal account: see Business income in a personal account.
- You are unsure what Shopify does and does not do as bookkeeping: see Does Shopify do bookkeeping?.
- You need to know which states to collect sales tax in: see Shopify sales tax by state.
- You need to place sales and fees on the income tax return: see Online seller income tax.
- You are weighing a bookkeeper for the store: see Ecommerce bookkeeper: cost and scope for what drives the fee, or take the payout exports and statements to bookkeeping.
Figures on this page
| Figure | Value | Source |
|---|---|---|
| Federal Form 1099-K marketplace payment threshold Marketplace or payment-app payments must exceed this amount and exceed 200 transactions before federal third-party network reporting is required; payment-card transactions have no such threshold. | $20,000 | IRS: Understanding your Form 1099-K Checked |
Primary sources
- Shopify Help Center: Shopify Payments payouts (vendor documentation, not a government source)
- Shopify Help Center: Viewing and exporting payout details (vendor documentation)
- Shopify Help Center: Payments activity report (vendor documentation)
- Shopify Help Center: Lower or missing payouts (vendor documentation)
- Shopify Help Center: Payout timing (vendor documentation)
- Shopify Help Center: Refunds and payouts (vendor documentation)
- Shopify Help Center: Reserves (vendor documentation)
- Shopify Help Center: Payout fees (vendor documentation)
- IRS: What to do with Form 1099-K
- IRS: Instructions for Form 1099-K
- IRS: Understanding your Form 1099-K
- IRS: Form 1099-K FAQs
- IRS: Publication 583
- IRS: Publication 538
- IRS: Publication 334
- IRS: What kind of records should I keep?
About this guide
Published by Cloud Accounting under standing professional approval. This version has no separately recorded personal review. It explains general rules for the tax year shown. It is not advice for your situation.
Changes
- : First published.