Set up your accounting so the data is worth something later

In year one, accounting feels like a compliance chore. In year three, it is the only complete record of what your business actually did, if you set it up so that it can be.

Most e-commerce founders eventually ask a version of the same question: which channel, product or campaign actually makes money? The answer lives in your accounting data. Whether you can get it depends on decisions made long before you thought to ask.

Why your platform analytics cannot answer this

Shopify knows what it sold. Meta knows what it spent. Stripe knows what it settled. None of them knows what your supplier charged or what the customs agent invoiced. They also do not know what your VAT actually cost you in each country, or what the currency conversion took.

Accounting is the only system that sees every euro from every source. That gives it an advantage over every analytics dashboard you use. Yet many businesses set up their books only for the tax return, not for the questions they will want answered later.

Your chart of accounts shapes your data

A minimal chart of accounts satisfies the annual report but tells you very little. The chart of accounts is the list of categories every transaction is recorded under. The most useful step is to keep apart the things that behave differently:

  • Cost of goods separate from fulfilment. Product cost and shipping cost grow differently and respond to different decisions
  • Platform fees separate from payment processing fees. One is a channel cost and the other a payment method cost, so they belong in different comparisons
  • Advertising split by platform, not one marketing account
  • Refunds and chargebacks separate from discounts. All three reduce revenue, and each means something different
  • Currency conversion losses as their own line. Otherwise they quietly distort your margin

None of this is unusual. But all of it disappears if a platform payout is posted as one revenue line.

Dimensions are what make analysis possible

Accounts answer what was spent. Dimensions answer where it belongs. A dimension is a tag on each transaction, such as the sales channel. Most accounting software supports them, and many small companies never use them.

For e-commerce, these dimensions are worth having from day one:

  • Channel. Own store, Amazon, Etsy, wholesale, with each marketplace kept separate
  • Country or VAT jurisdiction. Your obligations and your margin both differ by country
  • Product line or category. Not each SKU (stock keeping unit, a single product variant), which is unmanageable, but the groups you actually make decisions about

With those three in place, questions that would take a week of spreadsheet work become a report. One example is margin by channel after all costs. Another is whether your German sales are profitable once local VAT and returns are counted. You can also see which category funds the others.

Adding dimensions later does not fix history. You can start tagging today, but in practice nobody recodes two years of transactions. So the comparison you want in year three has to be set up in year one. It is one of the cheapest decisions in e-commerce accounting, and one of the most often skipped.

Reconciliation is what makes the data trustworthy

Structure is worthless if the numbers are wrong. Reconciling means checking that your books agree with the platform's and the processor's own records. For e-commerce, you do this every month.

Gross sales, fees, refunds, chargebacks and reserves are each recorded separately. The resulting balance should then match what the processor says it holds.

A business that reconciles monthly has a dataset. A business that posts payouts as revenue has a bank statement with extra steps. No amount of analysis on top of it will give a correct answer.

When you hold stock

If you hold stock, the moment you record the cost of goods decides whether monthly margin means anything. Say you expense purchases as you buy them. A month with a large restock then looks terrible and the next month looks excellent, though nothing changed. Matching the cost of goods to the sales it belongs to takes more work. Without it, monthly reporting is noise.

What good looks like at each stage

  • Starting out. Correct account separation and monthly reconciliation. Tag the channel even if you have only one, because you will add a second
  • Multi-channel. All three dimensions in use, monthly margin by channel, and VAT tracked by jurisdiction
  • Holding stock. Cost of goods properly matched, inventory valued, and margin by product line meaningful
  • Scaling. Accounting data feeds reports your operations team actually reads, not just statements filed once a year

Frequently asked questions

Why can't Shopify analytics tell me my real profit?

Because it only sees what it sold. It does not see supplier invoices, customs charges, VAT in each country, currency conversion or refunds settled elsewhere. Accounting is the only system that sees every cost.

What dimensions should an e-commerce business track?

Channel, country or VAT jurisdiction, and product line or category. With those three you can measure margin by channel after all costs, profitability by country, and which categories subsidise others.

Can I add accounting dimensions later?

You can start tagging at any time, but in practice old transactions do not get recoded. Any comparison you want across years has to be set up before the period you want to compare.

How does inventory affect monthly reporting?

If purchases are expensed when bought rather than matched to sales, a month with a large restock looks like a loss and the next looks unusually profitable. Without proper cost of goods matching, monthly margin is noise.

Tagsecommerce accountingchart of accountsdata structureunit economics

This page is for general information. For a better answer, get in touch and receive a personal recommendation.

Back to all articles

Get a fixed quote for your company

Complete the request in about two minutes. Receive a written quote usually within one working day.