A Form 1099-K from Shopify, Walmart, or TikTok Shop reports the gross payments that platform processed for you, not your revenue and not your deposits. So the form will almost never equal a number in your books. Matching it means building a bridge: start from the form's Box 1a figure, then list every refund, fee, discount, shipping charge, and timing gap until you land on the gross sales and the cash deposits recorded in QuickBooks or Xero. If every gap has a name and a source report, the books and the form agree. What you then report is a question for your CPA.
The IRS page "Understanding your Form 1099-K" states that payment apps and online marketplaces must send the form when payments for goods or services total over $20,000 in more than 200 transactions. The IRS says the One, Big, Beautiful Bill retroactively reinstated that threshold, the one in effect before the American Rescue Plan Act of 2021. The current Instructions for Form 1099-K carry the same over-$20,000 and over-200 test for each calendar year, so it governs the forms for calendar 2026 that platforms must furnish by January 31, 2027.
Two caveats from the same IRS pages. A platform may still send a form below the threshold. And some states set lower reporting thresholds of their own, so a seller under the federal line can still get one. Shopify's help page, for example, lists several states with lower 2025 thresholds and tells sellers to check their state's site because the figures change.
Getting a form, or not getting one, changes nothing about what the books should contain. The IRS says plainly that sales income is reportable whether or not a form arrives.
The IRS instructions define the Box 1a "gross amount" as the total of reportable transactions without adjustment for credits, discounts, fees, refunds, shipping amounts, or anything else, with monthly totals in Boxes 5a through 5l. Each platform applies that definition to its own data, and the details differ in ways that matter for the bridge.
Shopify's help center says the form covers only transactions processed through Shopify Payments. Sales through PayPal Express, manual payment methods, or cash are not on it. The form is built on the date a transaction posted to Shopify Payments in UTC, not the order date, so an order placed December 31 that posts January 1 lands on the next year's form. Refunds, chargebacks, processing fees, and Shopify Balance bills are not deducted. Reporting runs at the taxpayer ID level, so two stores under one EIN are combined to test the threshold. Shopify also offers a 1099-K transaction export, which is the file to reconcile against.
The practical consequence: a Shopify store that takes a meaningful share of orders through another gateway will see a form well below its booked sales, and that gap is correct.
Walmart's developer documentation, updated July 2026, describes a Tax Forms API that lists available 1099-K forms by payout year and returns each as a PDF, and Seller Center help carries a guide to retrieving the form. The figure follows the IRS gross definition. Because Walmart organizes forms by payout year in its own documentation, confirm in Seller Center which date drives the monthly boxes before you start matching months. That single detail decides whether your December and January reconcile or fight each other.
TikTok Shop's "1099-K and Tax Form FAQs" page, dated May 14, 2026, is the most explicit of the three. The form reports unadjusted gross sales, which TikTok defines as product sales price plus shipping fees minus seller-provided discounts. Months are assigned by when the buyer's payment was processed. Refunds, referral fees, creator commissions, shipping costs, and chargeback fees are not subtracted. TikTok gives the reconciliation formula outright: SKU subtotal before discount, minus SKU seller discount, plus original shipping fee, minus shipping fee seller discount, counting only orders with a Paid Time. It adds one trap. In a multi-item order the shipping fee repeats on every line of the export but is reported on the form once. The form lives in Seller Center under Finances, then Tax.
Illustrative numbers. Take a seller whose 2026 TikTok Shop Form 1099-K shows $184,600.00 in Box 1a. The books are on accrual, revenue recorded by order date.
The books show $168,200.00 of TikTok product sales before seller discounts, $2,500.00 of seller-funded discounts posted to a marketing expense account, and $13,590.00 of shipping income. Put on the same basis as TikTok's formula, that is $168,200.00 minus $2,500.00 plus $13,590.00, which equals $179,290.00. The form says $184,600.00. The gap is $5,310.00.
Two items explain it.
The bridge closes to the cent. Both items are errors in the books, not in the form, and both get corrected before the CPA sees the file. The cutoff entry moves $6,450.00 back into December. The shipping entry reduces shipping income by $1,140.00.
One more note on the $2,500.00 of discounts. TikTok's figure is already net of them, so a ledger that books gross sales and records the discount as marketing spend will always run above the form by exactly that amount. Whether discounts belong as contra-revenue or expense is a chart-of-accounts decision; the bridge just has to show it.
Now from the form to the cash that hit the bank in 2026.
If 2026 TikTok deposits in the bank feed total $139,894.00, the form, the revenue accounts, the fee accounts, and the bank all tie. TikTok's own FAQ warns that the settlement gap between buyer payment and wallet settlement can run a few weeks, which is why the two timing lines exist.
Most failed reconciliations trace to the same handful of causes.
A form that genuinely looks wrong after the bridge is built goes back to the issuer. Shopify's help page says its support team handles access problems, tax-information updates, and admin errors on the form. TikTok directs tax-information corrections to the tax settings in Seller Center.
The bridge is short when every settlement is split into its parts in the ledger: gross sales, shipping income, refunds, each fee type, and the net deposit, each dated to the period it belongs to. ConnectBooks reconciles the transactions, fees, and returns in settlements from Shopify, Walmart, and TikTok Shop and syncs them to QuickBooks Online or Xero, as summarized entries or item-level detail, which gives the bridge its refund and fee lines by channel. Matching the 1099-K is listed as a feature of the Gold tier on the pricing page.
Amazon and eBay forms follow the same IRS definition with their own reporting quirks, covered in the 1099-K for Amazon sellers and the eBay 1099-K.
Reconciliation tells you whether the form and the books describe the same sales. It does not tell you which figure goes on which line of a return, how a state form interacts with a federal one, or what to do about a prior year that never tied. Bring the finished bridges, both of them, to your CPA in January. A one-page schedule per platform, with each reconciling item tied to a source report, is the document they will ask for first.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
