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.
Income from five platforms means five sets of records to reconcile
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.
How do you handle Faire? Their commission structure is different from the others and the reporting is honestly the weakest of the bunch.
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.
What accounting software are you using? That matters a lot. Some of them connect to Etsy and eBay natively now.
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.
Faire. I gave up and just export the CSV and treat it as one lump per payout. Life is too short.
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.
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.
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.
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.
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.
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.
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.
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.
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.