Bookkeeping

Income from five platforms means five sets of records to reconcile

Started by OrbitKettle • November 18, 2026 • 15 replies
OrbitKettle

I sell on Etsy, Amazon Handmade, eBay, Faire, and my own website. Every month each one gives me a different report with different date ranges and different fee labels. Bank deposits don't match any single platform total. I'm spending at least six hours a month just trying to figure out what actually came in. There has to be a saner way than five spreadsheets and a calculator.

scrimshaw_sam

The bank deposit approach is the problem. Each platform batches payouts on its own schedule and nets out fees and refunds and sometimes shipping labels. You can't reconcile deposits to sales. Reconcile each platform's report to its own payout ledger, then reconcile those ledgers to the bank.

PlaidCurtain77

How do you handle Faire? Their commission structure is different from the others and the reporting is honestly the weakest of the bunch.

mossandmortar

Six hours is not that bad for five channels. I know that sounds dismissive but most people underestimate this. Two of my clients spend double that and they only have three platforms.

thursday_next

What accounting software are you using? That matters a lot. Some of them connect to Etsy and eBay natively now.

scrimshaw_sam

Native connection still pull gross sales into the bank feed and then people wonder why their books say they made more than they actually received. You still have to book the fees separately or the P&L lies to you.

Kestrel_Loops

Faire. I gave up and just export the CSV and treat it as one lump per payout. Life is too short.

PlaidCurtain77

That works until you have a chargeback or a damaged shipment and then you're digging through a payout you can't itemize. I've been burned by the lump approach twice.

gray_bus_stop

Pick one cutoff date a month, say the 5th, and reconcile every platform's activity through that date only. It won't match the bank perfectly in real time but it'll match by the next cycle. Consistency beats precision here.

copperwire

The date range thing drives me up the wall. Amazon reports in UTC or something close to it and eBay uses my local time and by the time I line them up the last day of the month is split across two reports.

thursday_next

gray_bus_stop has the right idea but I'd add: download all five reports on the same day, not spread across the week. The cutoff drift gets worse if you pull them whenever you remember.

mossandmortar

Honestly, for five platforms you might be at the point where a bookkeeper costs less than your own time. Six hours a month at what your labor is worth. If you'd rather soend that on product or listings, outsource the reconciliation.

scrimshaw_sam

Even with a bookkeeper you still have to gather the reports. They're not going to log into your Faire account. So the six hours doesn't fully go away unless you automate the exports too.

Kestrel_Loops

Does anyone actually get the owner's website reconciliation right? Mine is Shopify and the payouts include sales tax and shipping in weird ways that make my monthly gross look inflated.

copperwire

Shopify payouts net out too. Sales tax is a pass-through, noot your revenue. Treat it as a liability the moment it's collected and it stops inflating anything.

OrbitKettle

The Faire lump approach is what I've been doing and copperwire you just described exactly why my gross income number has been wrong for three months. I didn't catch the sales tax inflation. Going to try the single cutoff date instead of chasing Exact matches.


Post a reply

🚀 Start Your Free LLC