Settled
Features How it works Pricing FAQ For bookkeepers
Install on Shopify

Settled › Guides

Shopify 1099-K vs payouts: why the numbers never match

Updated November 3, 2026

A US merchant opens the 1099-K and the total is higher than what reached the bank. The form is not wrong and neither is the bank. They count different things. This guide explains the difference and gives you a worksheet. It does not tell you how to file. For that, ask the person who files for you.

What the 1099-K reports, and what it does not

A 1099-K reports gross payment volume: the total of card payments processed for you in the year. It is a volume figure. It does not subtract fees, refunds or chargebacks, and it does not care when the money reached your bank.

It is also not a profit figure and not a revenue figure for your books. Whether and how an amount counts on your return is a question for your accountant.

Why it will never equal your deposits

Your deposits are net and they follow the payout calendar. Five things separate the two numbers:

  • Fees. Taken before the deposit. They are in the form's gross total and not in your bank.
  • Refunds. Taken from a later payout. The sale is in the gross volume and the refund reduces the deposit.
  • Chargebacks. Pulled from a payout, sometimes with a dispute fee.
  • Reserves. Money held back and not yet in the bank at year-end, or released in a later year.
  • Timing. A December sale can be paid out in January.

Add those up and a gap between the form and the bank is normal. It is the sum of lines that each have a source. Ask your accountant what to do about the ones that matter for your return. Do not net them yourself on a guess.

Where to get the numbers

  • Payout data for the year. In Shopify admin open Finances → Payouts, set the date range to the whole year and export. Export the payout transactions too, because they hold the fee, refund and reserve lines.
  • The 1099-K itself. Look in your Shopify Payments settings under Settings → Payments for the tax forms area. If you cannot find it, ask Shopify Support where yours is.
One deposit explained: sales, fees, refunds and reserves line by line, matched to orders
Gross to net for one payout: sales, fees, refunds and reserves on separate lines.

The reconciliation worksheet

Copy this into a spreadsheet and fill in each line from the year's export:

LineSourceAmount
Gross card volumeSum of charge amounts in the transactions export
− FeesSum of the Fee column
− RefundsSum of refund rows
− Chargebacks and dispute feesSum of dispute rows
− Net reserve held at year-endReserve lines minus release lines
± AdjustmentsSum of adjustment rows
= Deposits for the yearSum of payout rows, compare with the bank

If the last line matches the bank, the gap between the form and the bank is explained. If it does not, find the payout where it breaks and check that payout alone.

Timing traps

  • December sales paid out in January. They are in this year's volume and next year's deposits. Mark which side of the year boundary each payout falls on.
  • Refunds across the year boundary. A refund in January for a sale in December reduces next year's deposits, not this year's.
  • Reserves that carry over. A reserve taken in November and released in February is held on December 31.

Which date your return uses is not something this article can tell you. Ask the person who files for you.

What to hand your accountant

Give them the worksheet and the underlying exports, not a screenshot of the dashboard. A dashboard total cannot be traced back to rows, and an export can. Add one line of context for anything unusual, such as "reserve of 250.00 held since June" or "refund on an order from last December". Then let them decide how it goes on the return.

Skip the manual sum

Settled Payouts shows the gross-to-net math for every payout, and on Growth it exports the year as one XLSX with a summary of payouts and a detail sheet of every balance transaction.

Year exports (CSV, XLSX, PDF) are on Growth ($39/month) and Scale. 14-day free trial, no card required. Plans: Starter $19, Growth $39, Scale $79 per month.

Search Settled Payouts on the App Store

Keep reading

  • Why is my Shopify payout less than my sales?
  • Shopify Payments activity report for bookkeepers
  • Reconciliation checklist
Settled formats and explains data Shopify already provides — it is not tax or legal advice. Menu names in Shopify, PayPal, QuickBooks and Xero change over time; if a label differs, look for the closest match. Ask your accountant how to treat any amount in your books.
Settled

Payout dates, hold explanations, and reconciliation for Shopify Payments merchants.

Product

  • Features
  • Pricing
  • Sample payout
  • FAQ

Resources

  • Payout timing guide
  • Reserve & hold glossary
  • Reconciliation checklist
  • Help center
  • For bookkeepers
  • Guides

Company

  • About
  • Contact
  • Privacy
  • Terms
  • Buy me a coffee
© 2026 Settled. All rights reserved. Built for Shopify merchants · Not affiliated with Shopify Inc.