Home › Merge Guides › Depop + Facebook Marketplace › Year-End Sales Summary walkthrough
The Best Way to Merge Depop and Facebook Marketplace Data for Year-End Sales Summary
If you're doing year-end sales summary by hand right now, here's the fastest path from "two exports" to "one usable sheet," and why the manual version keeps breaking.
Step by step
- Decide your target columns once. Most people settle on Date, Channel, Order ID, and Total — set that up in CSV Experts and you won't redo it.
- Import the Depop file first. The first time you see this file shape, you map each of its columns to your target list.
- Import the Facebook Marketplace file the same way. Its columns get mapped once too — after that, every future file with this shape merges with no extra clicks.
- Check the merged totals. Dates and numbers are normalized automatically, so a European "24,00" and a US "24.00" both land as the same value.
- Export. CSV or Excel, ready for year-end sales summary.
What actually goes wrong if you do this by hand
Depop gives you a transaction date column, while Facebook Marketplace gives you an order date recorded through Meta's commerce backend — line those up manually across a few hundred rows and it's easy to miscount a week. On top of that, Depop's export like Poshmark, the export is minimal and mixes sold, refunded, and offer-related rows together, and Facebook Marketplace's many sellers use Marketplace only for listings with no built-in checkout, so exports may only exist via a connected store's own platform. Individually those are minor quirks; combined into one spreadsheet by hand, they're where most reconciliation errors for year-end sales summary actually come from.
Why it matters for year-end sales summary
A year-end summary across channels means twelve months of exports from each platform, all needing the same cleanup before they can be totalled together.
Just want the quick column-difference reference instead? See the short version.