Shopify reconciliation, explained

Your 1099-K doesn't match your Shopify sales. Here's the walk.

Published
Short answer

A Form 1099-K reports the gross payments one processor handled for you, with no deduction for refunds, shipping or fees, so it usually reads higher than your Shopify Net Sales. Walk from the form to Net Sales by taking off sales tax, shipping charged and refunds, then adding orders paid through any other processor.

What a 1099-K counts

The form comes from a payment processor, and it covers only the payments that processor handled for you. The IRS instructions define box 1a, the gross amount, as the total of your reportable payment transactions "without regard to any adjustments for credits, cash equivalents, discount amounts, fees, refunded amounts, shipping amounts, or any other amounts." The amount of each transaction is fixed on the date of the transaction, and boxes 5a to 5l split the year's gross by month.

When you get one: the IRS says a third party settlement organization reports when payments exceed $20,000 and the transactions exceed 200 in the calendar year, while payment card transactions are reported at any amount. You can also receive a form below the threshold.

Sources: IRS: Instructions for Form 1099-K (read 2026-11-13) · IRS: Understanding your Form 1099-K (read 2026-11-13) · IRS: What to do with Form 1099-K (read 2026-11-13)

Why it reads higher than Net Sales

Shopify computes net sales as gross sales minus discounts minus sales reversals (returns), and keeps taxes and shipping out of it (they are part of total sales instead). So four things separate the two numbers:

Gift cards add one more line when you sell many: the money for a card is collected when it is sold, while Shopify counts the sale when the card is spent (gift cards in Shopify reports). Sources: Shopify Help Center: Analytics data points (fields) reference · Shopify Help Center: Sales reports

The walk, line by line (SAMPLE NUMBERS)

LineWhere to find itAmount
Form 1099-K gross amount (box 1a)The form from your payment processor$412,300
Sales tax collectedShopify Finance reports: taxes-$24,100
Shipping charged to customersShopify Sales report: shipping charges-$18,600
Refunds and returnsShopify Sales report: returns-$15,200
Payments that are sales on this form$354,400
Orders paid through another processorOn that processor's own form, not this one+$21,000
Shopify Net Sales, same calendar yearShopify Sales report$375,400
ResidualAnything left is a named line, never absorbed$0

SAMPLE NUMBERS, not a real store. Pull each line for the same calendar year in your store's timezone. If the residual is not zero, it is a line you have not found yet: a gift card sale, a chargeback, an order from another sales channel, or a refund on an order from the year before.

Orders that cross the year-end

The form fixes each payment on the date of the transaction, and it does not deduct refunds at all. Shopify dates a refund on the day it was issued. So an order paid on December 30 and refunded on January 4 is in this year's form at full value, while the refund comes off next year's Shopify net sales. Our reasoning: list the refunds issued in early January against orders from December; they are the usual cause of a residual at year-end.

What to hand your accountant

If the gross amount on the form is wrong, the IRS says to ask the issuer for a corrected form. If you work with an accountant on several stores, our partner page covers one login for all your clients. Why the money in your bank differs from sales is on payout versus sales.

Common questions

Why is my 1099-K higher than my Shopify net sales?

The IRS instructions say the gross amount on a 1099-K is reported without adjustments for credits, discounts, fees, refunds or shipping. Shopify net sales takes refunds and discounts off and leaves shipping and taxes out, so the form starts higher. Taking those lines off the form's gross walks it down to net sales.

Does the 1099-K include sales tax?

The IRS pages on Form 1099-K do not mention sales tax. Our reasoning: the form counts what customers paid, and the sales tax you collected was part of what they paid, so it sits inside the gross amount. Shopify keeps taxes out of net sales, which is why tax is the first line on the walk.

What is the 1099-K reporting threshold?

As read on irs.gov on 2026-11-13: a third party settlement organization reports when your payments exceed $20,000 and the number of transactions exceeds 200 in the calendar year. Payment card transactions are reported at any amount. The IRS also says you may receive a form below the threshold.

Which year does an order land in on the 1099-K?

The IRS instructions say the dollar amount of each transaction is determined on the date of the transaction, and the form splits the gross amount by month. An order placed on December 31 and refunded in January is in December's gross, and the refund is not deducted on the form at all.

Is the 1099-K amount my taxable income?

Not by itself. The IRS says a payment reported on a Form 1099-K is not automatically taxable, and that fees, credits, refunds, shipping, cash equivalents and discounts can be deducted from the gross amount. How to report it is a question for your accountant.

What this does not tell you

This is not tax advice. It explains what the form counts and how it relates to Shopify's reports. How to report the amount, and what is taxable, is for your accountant or tax preparer. The IRS statements are quoted from the pages linked below as they read on 2026-11-13; check them before you file.

The lines marked as our reasoning are not IRS or Shopify statements. The worked example uses SAMPLE NUMBERS, not a real store.

Want your Net Sales tied to your Shopify orders, to the cent?

Install ProfitRoot and see these steps on your own orders.

Install free from the Shopify App Store

Orders synced from a connected Shopify store are transmitted to and stored on our servers so they can be recomputed on later visits.

Related
Your Shopify payout doesn't match your salesGross sales vs net sales in ShopifyHow to make a Shopify number defensibleAll Shopify reconciliation guides

Sources last checked 2026-11-13.