The core of ecommerce bookkeeping multiple channels is one habit: never record a payout as a sale. Each platform deducts its own fees, refunds and adjustments before money reaches your bank, on its own schedule and in its own report format. So for each channel, every month, you record three things separately: gross sales, what the platform took out, and what was deposited. Then you check that the deposits match your bank. Once each channel balances on its own, combining them is simple arithmetic.
This article walks through that method for a seller running Etsy alongside a Shopify store. It is a record-keeping method, not tax advice. How income, fees and collected taxes are treated depends on your country and, in some countries, your state or province. Take your finished records to an accountant or tax professional where you live for that part.
Why two channels are more than twice the work
A seller with one marketplace often keeps books by reading the deposit and the platform’s summary. That works because there is one source of truth. Add a second channel and three things change at once.
- Two report formats. Each platform names, groups and dates transactions its own way. A “fee” on one may be split into several line types on the other.
- Two schedules. Money from the two channels arrives on different days, so a bank deposit rarely lines up neatly with a calendar month of sales on either platform.
- Costs that belong to neither payout. Some costs of running a store are billed separately rather than deducted from what you are paid, so they never show up in a payout report at all.
The result is an easy error to make: treating the bank deposit as income. The deposit is a net figure. It hides the fees, and if you only record deposits, you have no record of what you actually sold or what each channel actually cost you.
Ecommerce bookkeeping multiple channels: the three-line rule
For every channel, every period, keep three lines apart:
| Line | What it is | Where it usually comes from |
|---|---|---|
| Gross sales | What customers paid for products (and shipping, if you charge it) | The platform’s sales or transaction report |
| Platform deductions | Fees, refunds, chargebacks, adjustments, reserves | The same report, broken out by type |
| Deposits | What actually reached your bank | Payout report, checked against your bank statement |
Gross sales minus deductions should explain the deposits, allowing for timing. If it does not, something is missing, and it is better to find it now than at year end.
Shopify: where the numbers are, at the time of writing
Shopify’s records are documented in its help center, which I read on 2026-10-02. If you use Shopify Payments, two reports do most of the work.
The first is the payout transaction export. Shopify’s guide to viewing and exporting payout details (checked on 2026-10-02) describes exporting transactions to a CSV file, which Shopify says is emailed to you and the store owner. The columns it lists include Transaction Date, Type, Order, Payout Status, Payout Date, Amount, Fee and Net, where Net is “the difference between the amount and the fee.” Those three columns map directly to the three-line rule.
The second is the Shopify Payments activity report (checked on 2026-10-02), found under Finance, then Documents. Shopify describes it as showing starting and ending balances, gross activity, fees, payouts and net movement for a date range, with transactions grouped by type such as charges, refunds, disputes, reserves and adjustments. It exports to PDF.
One line on that page matters a great deal for this method: the activity report excludes Shopify billing fees and third-party payment processors. In other words, charges on your Shopify bill are not in it, and neither are payments taken through another processor. Those have to be recorded from their own sources, or your Shopify channel will look cheaper than it is.
Last checked: 2026-10-02. Menu paths in the Shopify admin change; if a path above does not match your admin, search the help center for the report name.
Etsy: use Etsy’s own current instructions
Etsy provides its own financial records for sellers. I was not able to read Etsy’s help pages on the day of writing, so I am not going to describe the menu paths, report names or fee lines from memory. Fees and how they appear are exactly the details that change.
What the method needs from Etsy is the same three lines: gross sales for the period, every deduction by type, and the deposits. Check Etsy’s Help Center for how to export those for a month at a time, and for how Etsy’s records treat fees, refunds and any held funds. Then apply the same three-line rule. If you want to understand what each Etsy fee is before you categorize it, our walkthrough of Etsy seller fees, the whole stack on one sale explains the structure.
The monthly routine, step by step
This is a routine you can run in an evening once it is set up.
1. Close each channel separately
Export the period’s records from Shopify and from Etsy. Do not merge them yet. Work through one channel at a time until it balances.
2. Record gross sales by channel
Enter each channel’s gross sales as its own income line, for example “Sales: Etsy” and “Sales: Store.” Keeping them separate is what later lets you see which channel is carrying the business.
3. Record each deduction type as its own expense
Fees, refunds and adjustments go in as separate lines, labeled by channel. Avoid lumping them into one “platform costs” line. The detail is what makes the comparison between channels honest.
4. Match deposits to the bank
Take each deposit listed in the payout records and find it on your bank statement. A deposit that appears in the platform report but not the bank, or the reverse, is the first thing to investigate.
5. Add the costs no payout shows
This is the step most easily skipped. Record the costs that were billed to you rather than deducted from a payout. On Shopify that includes the billing fees the activity report excludes. Add packaging, postage bought outside either platform, and anything else the business paid for directly.
6. Only then, combine
With each channel balanced, total the income and costs across both. This combined view is what your accountant needs. The per-channel view is what you need.
Things that fall between the two channels
Running two channels creates a few situations that neither platform’s report handles for you.
One stock pool, two channels. If both channels sell from the same shelf, the cost of the goods you sold has to be split by where each unit sold, not by where you bought the materials. Track units sold per channel and apply the same cost per unit.
A return that crosses over. A customer who bought on one channel may contact you through the other. The refund still belongs to the channel that took the original payment. Record it there, regardless of where the conversation happened.
Timing at month end. A sale near the end of the month may be paid out the following month. That is normal. Record the sale in the month it happened and the deposit when it arrived, and the mismatch will clear the next month.
Different currencies. If one channel pays you in a different currency from the other, record the amount actually received and keep the platform’s report alongside it. How exchange differences are treated is a question for your accountant.
Software, spreadsheets and when to hand it over
A spreadsheet with one tab per channel and one combined tab can be enough for a small seller. Accounting software and connector tools exist that pull platform data in automatically. Whether they are worth it depends on order volume, how much time the manual routine takes you, and what your accountant works with. I am not recommending a specific product here. If you consider one, check that it records gross sales and fees separately rather than importing net deposits, because a tool that imports deposits as sales automates the exact mistake this method exists to prevent.
Bringing in a bookkeeper or accountant makes sense when the routine takes longer than you can sustain, when you register for sales tax or VAT anywhere, or when you are unsure how something should be classified. Those are judgment calls that depend on where you are registered and how your business is set up.
What the per-channel books tell you
Clean per-channel records do more than satisfy year end. They show what each channel actually costs once every fee and separately billed charge is included, which is the number most channel comparisons skip. If you are weighing whether your store is pulling its weight against the marketplace, that per-channel cost is the honest input for working out your own break-even point, and it keeps a fee calculator used honestly grounded in your real figures rather than published rates alone.
FAQ
Should I record my Etsy and Shopify deposits as income?
The deposit is a net figure after the platform’s deductions. For clean books, record gross sales and each deduction separately, then use the deposit to check that the two reconcile.
How often should I reconcile two sales channels?
A monthly close is a workable rhythm for many small sellers. Higher-volume sellers may prefer to reconcile more often so problems surface sooner.
Why does my Shopify Payments activity report not show my subscription?
Shopify’s help center says the Shopify Payments activity report excludes Shopify billing fees and third-party payment processors. Record charges on your Shopify bill separately.
Do I need separate bank accounts for each channel?
Not necessarily. What matters is that each deposit can be traced to its channel. Some sellers find one business account easier to manage; others prefer separation. Ask your accountant what suits your setup.
Is this the same as preparing my taxes?
No. This method produces organized records. How those records are taxed depends on your country and registration, so take them to a qualified tax professional where you live.