Guide

E-commerce bookkeeping for Shopify and Amazon sellers: the complete guide

Your Shopify dashboard says one number, your Amazon account says another, and your bank shows a third. E-commerce bookkeeping is the work of turning those into one set of books you can trust: real revenue, real fees, real margins and the tax you actually owe. This guide shows how it works and what a sound month-end looks like.

Prepared by Cloud Accounting Studio, overseen by Paul le Roux, CA(SA). Last reviewed: 20 November 2026.

Key takeaways

  • A platform payout is a net figure. Good e-commerce books record the gross sale and every deduction separately: fees, refunds, reserves, shipping and tax.
  • Inventory drives profit. Cost of goods sold should include landed cost, not just the supplier invoice.
  • Sales tax and VAT you collect, or that a marketplace collects for you, are not your revenue.
  • For 2025 and 2026, payment apps and marketplaces must issue Form 1099-K once your payments exceed US$20,000 and 200 transactions. Card payments have no threshold. Income is taxable whether or not you get a form.
  • The IRS general rule is to keep records for 3 years, with 4, 6 and 7-year exceptions.
  • Cross-border sellers need books that also support Form 5472, VAT returns and customs records.

What e-commerce bookkeeping is

E-commerce bookkeeping is recording and reconciling the transactions of an online store so the accounts match what really happened. It covers sales by channel, platform fees, refunds and chargebacks, inventory and cost of goods sold, sales tax and VAT, payouts to the bank, and the costs of running the business.

It differs from general bookkeeping in one way that changes everything: your money reaches you through platforms that deduct costs before they pay you. A general bookkeeper who records each payout as "sales" will understate revenue, hide your fees and miss the tax you collected. Your margins will look wrong, and your tax returns will be built on the wrong numbers.

Why payouts break ordinary bookkeeping

Shopify payouts

Shopify Payments pays out on a daily, weekly or monthly schedule, depending on what you choose. Each payout bundles many orders, less processing fees, refunds and any adjustments. Shopify's payout and transaction reports break down the transactions, fees and payouts for a date range. Those reports, not the bank deposit, are the starting point for the books.

If you also take payments through other gateways, each one pays out on its own cycle, with its own fees. Every gateway needs its own clearing account so each payout can be matched to the orders inside it.

Amazon settlements

Amazon pays sellers by settlement period. Each settlement report lists sales, Amazon's fees (referral, fulfilment, storage and advertising, where you use them), refunds, reimbursements and any reserve it holds back. One deposit can contain hundreds of lines, and some belong to earlier periods.

The method that works is the same as for Shopify. Post the settlement to an Amazon clearing account at the gross level, then clear it against the bank deposit. Whatever is left in the clearing account is a reserve, a timing difference or an error to chase.

Every other channel

Etsy, wholesale orders, your own site and pop-up sales each add a revenue stream with its own fees and timing. The rule does not change: one clearing account per channel, gross sales in, every deduction out, and the payout matched to the bank.

A chart of accounts built for online sellers

The chart of accounts is the list of categories in your books. An online seller needs a few that a general business does not:

AccountWhy it matters
Sales by channel (Shopify, Amazon, other)Shows which channel actually makes money
Refunds and returnsKept apart from sales so the return rate is visible
Platform and payment feesOften the second-largest cost after stock
Fulfilment and shippingSeparates outbound delivery from inbound freight on stock
Clearing accounts, one per channel or gatewayProves every payout ties to its orders
Inventory (asset) and cost of goods soldStock is an asset until it sells
Sales tax and VAT payableTax collected for governments, not income
Marketplace reserves receivableMoney earned but held back by the platform
Owner contributions and distributionsEssential for single-member US LLCs owned from abroad, which must report them on Form 5472

Inventory and cost of goods sold

Inventory is where most e-commerce books go wrong. Expensing stock when you pay for it makes a big buying month look like a loss and a quiet month look like a windfall. Record stock as an asset, and move it to cost of goods sold as it sells.

Landed cost

The cost of a unit is more than the supplier's price. Landed cost adds inbound freight, insurance, customs duty and broker fees to bring the goods to your warehouse. Leave those out and your margin looks better than it is.

If you import into the US, your broker arrangements change in 2027. From 5 January 2027, most foreign importers of record must use a licensed, CTPAT-validated customs broker. See our guide to importing into the US.

Inventory methods for tax

US tax law lets some smaller businesses use simpler inventory methods, based on a gross receipts test. Whether your business qualifies, and which method suits it, depends on your revenue history and your facts, so ask us for the threshold confirmed for your tax year. Request a consultation and we will confirm it against the IRS rules for your situation.

Sales tax and VAT belong on the balance sheet

When you charge sales tax or VAT, you collect it for a government. It goes to a liability account, not to sales. When a marketplace collects the tax for you, the books should show the gross sale and the tax the marketplace handled, so your revenue is not overstated and your filings reconcile.

Whether you need your own US state registrations, even where a marketplace collects for you, depends on the state. Our sister brand, Sales Tax Compliance USA, covers that in depth.

If you sell into Europe or the UK, VAT works differently again: IOSS, OSS, UK VAT registration and import VAT. See the EU and UK VAT map.

Form 1099-K: what the platforms tell the IRS

Form 1099-K reports payments you received through payment card processors, payment apps and online marketplaces. The IRS confirms the federal thresholds after the One Big Beautiful Bill Act of July 2025:

How you were paidFederal Form 1099-K threshold (2025 and 2026)
Payment apps and online marketplaces (third-party settlement organisations)Third-party settlement organisations: gross payments over US$20,000 and more than 200 transactions
Payment card transactionsNo threshold

Three points matter for your books. A platform may issue a 1099-K below the threshold. Some states set lower reporting thresholds. And the form shows gross payments, before fees and refunds, so your books must reconcile the gross figure to the net income on your return. Selling income is reportable whether or not you receive a form. A seller that a platform has documented as a foreign person may fall under a foreign-payee exception and receive no form at all, which does not change what the books must show.

The month-end routine

Good books come from a routine, done the same way every month:

StepWhat is done
1. Import platform reportsPayout and settlement reports for every channel and gateway
2. Post gross, then deductionsSales, refunds, fees, shipping and tax to their own accounts
3. Clear to the bankEach clearing account matched to deposits; differences explained
4. Reconcile bank and cardsEvery account ties to its statement
5. Update inventoryPurchases and landed costs in; cost of goods sold out
6. Check tax balancesSales tax and VAT payable agree to the returns due
7. Review and reportProfit and loss by channel, gross margin, cash and stock on hand

If steps 3 and 4 leave unexplained differences, the books are not finished. Small gaps compound, and by year-end they are expensive to unpick.


Not sure how far your books are from this? Our free instant check asks where you sell, your platforms and your revenue band, and shows which services you are likely to need, with our "from" prices.


Cash or accrual?

Cash basis records income when money arrives and costs when you pay them. Accrual basis records them when they are earned or incurred. For a seller with stock and platform reserves, accrual-style management accounts give a truer picture of margin, even if the tax return follows a different method.

Which method your tax return may use depends on your entity, your revenue and the rules for your tax year. We confirm that as part of setting up your books.

How long to keep records

The IRS general rule is to keep records that support a return for 3 years. There are longer periods in some cases:

  • 6 years if you leave out income of more than 25% of the gross income shown on the return;
  • 7 years if you claim a loss from worthless securities or a bad debt deduction;
  • at least 4 years for employment tax records, after the tax is due or paid, whichever is later;
  • indefinitely if a return was not filed or was fraudulent.

Keep platform reports, supplier invoices, customs documents and bank statements together, so any figure in the books can be traced back to its source.

Cross-border sellers: the extra layer

If you sell into the US from abroad, or own a US company from abroad, your books have extra jobs:

  • Form 5472. A single-member US LLC wholly owned by a non-US person, and treated as a disregarded entity, must report transactions with its owner, including contributions and distributions, on Form 5472 with a pro forma Form 1120. The penalty for not filing is US$25,000. Your books are the source. See our foreign-owned US company guide.
  • VAT. Selling into the EU or UK can mean VAT registrations and returns that your books must support. See UK VAT for overseas sellers.
  • Customs. Duty, broker fees and bonds belong in landed cost, and brokers will ask for financial statements under the new US importer rule.
  • EU entities. In some EU countries, keeping a company's accounts is a reserved activity. France reserves it to registered accountants, and Germany limits it to qualified people. Where that applies, the books are kept by licensed local partners where the law requires it, confirmed in your assessment, and we coordinate the US side.

What we do

We specialise in e-commerce accounting and tax for cross-border sellers. Our e-commerce bookkeeping service covers channel reconciliation, inventory and landed cost, sales tax and VAT balances, monthly reports and year-end, with one point of contact. Because we also handle foreign-owned US company compliance, EU and UK VAT coordination and, through Sales Tax Compliance USA, US sales tax, the books are built to feed every filing you have.

Frequently asked questions

What is the difference between e-commerce bookkeeping and general bookkeeping? E-commerce bookkeeping records sales at gross, splits out platform fees, refunds and reserves, tracks inventory and landed cost, and keeps collected tax off the revenue line. General bookkeeping often records platform payouts as sales, which hides all of that.

Can I just record my Shopify or Amazon deposits as income? No. A deposit is net of fees, refunds and holdbacks. Recording it as income understates revenue and costs, and your books will not reconcile to the Form 1099-K the platform reports.

Do I get a Form 1099-K from Amazon or Shopify? For 2025 and 2026, a payment app or marketplace must issue one when your payments exceed US$20,000 and 200 transactions. Card payments have no threshold. You report the income either way.

Is sales tax collected by a marketplace my income? No. It is tax collected for the state. Your books should show it separately so revenue is not overstated.

How often should e-commerce books be closed? Monthly. Platform reports, inventory and tax balances move too fast for a quarterly or annual catch-up.


Want books that match every platform and every filing? Take the free instant check, or contact us to talk about your channels.


Official sources

  • IRS, Form 1099-K FAQs, general information: irs.gov
  • IRS, How long should I keep records?: irs.gov

Last reviewed: 20 November 2026. This guide is general information about bookkeeping practice and the IRS rules cited. It is not tax advice for your business.