← Back home

Seller guides

How to track payout fees across multiple stores in one spreadsheet

One sheet, one row per order, every fee in its own column — so you can see what each sale really earns.

Small business owner reviewing payout fee charts and a spreadsheet at a desk

Why this guide exists

Every marketplace takes its cut, and every cut is different. A seller running several stores sees a dozen different fee names across a dozen different statements — and none of them shows the whole picture. This guide builds the one place where the whole picture lives: a single spreadsheet that turns scattered payout statements into a clear answer about what each store actually earns.

The problem one spreadsheet solves

Every marketplace takes its cut — and every cut is different. One platform charges a percentage of the sale plus a fixed fee per order. Another adds a payment processing fee, a category fee, and a charge for the advertising that put your listing in front of a buyer. A third holds a reserve and releases it weeks later. Look at any single payout and the numbers look small. Add them up across three or four stores for a month and the total is real money — money you cannot manage if you cannot see it.

That is the problem a single spreadsheet solves. Not a dashboard, not a paid analytics tool, not a different app per store. One sheet, one row per order, every fee in its own column, and a summary at the top that answers the only question that matters: after every fee, what did this store actually earn? When the answer is in front of you every week, pricing stops being guesswork. You know which store is the most profitable, which product line carries the heaviest fees, and which fee changed last month without you noticing.

This guide shows you how to build that spreadsheet from scratch: the columns it needs, how to fill it without spending your evenings on data entry, how to read it once the numbers are in, and the mistakes that make a fee tracker useless. It is written for sellers running more than one store on verified accounts, and it assumes nothing about your accounting background — only that you want the true number, not the number the marketplace shows you.

The columns your spreadsheet needs

  • Order date — the day the order was placed, so fees line up with the month and the payout they belong to.
  • Store — which store the order came from, so each store's fees can be totalled separately.
  • Marketplace — the platform, because the same store can sell on more than one marketplace and each one charges differently.
  • Order total — what the customer paid, before any fee is taken out.
  • Marketplace fee — the platform's percentage or flat fee for the sale, exactly as shown on the payout statement.
  • Payment processing fee — the separate charge for moving the money, which many sellers forget is a fee at all.
  • Advertising fee — any promoted-listing or ad spend tied to that order, recorded on the order it belongs to, not lumped into a monthly total.
  • Shipping charged vs shipping paid — what the customer paid for shipping, and what it actually cost you, so a shipping loss shows up as a fee in disguise.
  • Refund or adjustment — any money returned to the customer, or any correction the platform applied after the sale.
  • Net received — the payout that actually landed in your account for this order, the number every other column exists to explain.
  • Fee as a percentage of the order — a formula column, net fee divided by order total, so stores and products can be compared fairly.
  • Notes — one short line for anything unusual: a first-order hold, a fee change, a dispute, a promotion that skewed the numbers.

Filling it in without losing your evenings

A tracker that takes an hour a day to maintain will be abandoned by next Tuesday, so the way you fill it matters as much as what is in it. The simplest routine that works is a weekly one: once a week, open each store's payout statement, and enter the orders for that week in one sitting. Payout statements already list the fees per order — you are copying numbers, not calculating them. Fifteen to twenty minutes a week covers most multi-store sellers, and the habit is what keeps the sheet honest.

Enter orders in the week they were paid out, not the week they were placed, if your goal is cash flow. But enter them in the week they were placed if your goal is comparing products and stores. Pick one rule and stick to it — mixing the two is how the same order gets counted twice, or not at all. A short note at the top of the sheet stating the rule you chose will save you from arguing with yourself three months from now.

Use the marketplace's own words for each fee, at least at first. If the statement calls it a referral fee, write referral fee. If it calls it a transaction fee, write transaction fee. Renaming fees into your own categories too early hides the differences between platforms, and the differences are the whole point. Once you have a few months of data you can group fees into your own categories — but only after you have seen what each platform actually charges, in its own language.

Reading the sheet: what the numbers are telling you

Once the sheet has a month of orders, it starts answering questions no single payout statement can. Start with the simplest one: fee as a percentage of the order total, averaged by store. Two stores can sell the same product at the same price and keep very different amounts, because their fee mix is different. The store with the lower percentage is not automatically the better store — it might also have lower traffic or slower payouts — but the gap is now a fact you can act on instead of a feeling.

Then look at the fee mix inside one store. Sort the month's orders by the advertising fee column. If a handful of orders carry most of the ad spend, those listings are doing the heavy lifting — and if they are also the orders with the thinnest net margin, the advertising is buying sales that barely pay for themselves. The same sort works for refunds: a product with a high refund rate is not a fee problem, it is a listing or quality problem wearing a fee costume, and the spreadsheet is what reveals the disguise.

Watch for changes, not just totals. A fee that was steady for months and then moves — even slightly — deserves a note in the sheet and a look at the platform's fee announcement. Marketplaces change fee structures quietly, and a seller who tracks fees notices in the first week. A seller who does not notice finds out at tax time, or when a product that used to be profitable quietly stops being one.

  • Compare fee percentage by store first — it is the fastest way to see which store earns its keep.
  • Sort by advertising fee to find the listings whose ad spend eats the margin they create.
  • Sort by refund column to find products whose return rate is the real cost, not the fee itself.
  • Flag any fee that moves month to month — a quiet fee change is the most expensive surprise.
  • Check the net received column against your bank statement every month; a gap between the two is a missing order, a hold, or an error worth chasing.

The weekly and monthly routine

The spreadsheet earns its keep in a short weekly routine. Open the sheet, add the week's orders, and check three things before you close it: the fee percentage for the week against the previous week, any order whose net received looks wrong, and any fee column that is blank where it should not be. Blank cells are the tracker's silent failure — a missing fee is not a zero fee, and a row with gaps will quietly understate what a store costs to run.

Once a month, spend a little longer. Total each store, compare the month with the one before it, and write two or three sentences at the top of the sheet about what changed and why. That monthly note is the most valuable part of the whole system. It turns a pile of numbers into a record you can actually use — when you raise a price, drop a product, or move a listing to another store, the note tells you whether the decision worked.

Keep the sheet in one place and keep it backed up. A spreadsheet that lives only on one laptop is one spilled coffee away from losing a year of fee history. If more than one person touches it, agree on who enters what and when, so two people do not enter the same week twice. And keep the raw payout statements too — the spreadsheet is your summary, the statements are your proof, and both matter when a platform's numbers and yours disagree.

Habits that keep the tracker honest

  • Enter orders once a week, in one sitting, from the payout statement — never from memory.
  • Record every fee in its own column; lumping fees together hides the one that changed.
  • Use a formula for the fee percentage column so it can never be mistyped.
  • Check net received against the bank statement every month and chase any gap the same day.
  • Write a two-sentence monthly note about what changed and why — future you will need it.
  • Keep the raw payout statements filed by month, so the spreadsheet can always be checked.
  • Review the sheet before changing a price, so the new price is set from the true margin, not the list price.

Mistakes that make a fee tracker useless

  • Tracking only the marketplace fee and ignoring payment processing, advertising, and shipping losses.
  • Mixing orders from different months in one block, so no month can be compared with another.
  • Leaving fee cells blank instead of zero — a blank is not a zero, and it hides real costs.
  • Entering orders from memory days later instead of from the payout statement.
  • Building a beautiful sheet with twenty columns and abandoning it because it takes too long to fill.
  • Comparing stores by total sales instead of by fee percentage — the busiest store is not always the most profitable.
  • Never checking the sheet against the bank statement, so a missing payout goes unnoticed for months.

Real KYC

Every account backed by a genuine document set, cross-checked before handover.

Fees you can see

One sheet that shows the true margin of every store, so pricing is set from facts, not feelings.

Warranty in writing

Replacement or refund policy documented before payment — not after.

Ready to see what your stores really earn?

Every account in our catalog runs through the same verification checks before it reaches you. Ask us anything before you order.