How do I import my Whatnot data into Seller Ledger?

Seller Ledger now offers an automated way to import your Whatnot sales, fee and payout information.

If you would rather use the more manual CSV upload, like we wrote in our blog post when we first launched the feature, you certainly may. But there are a couple of important considerations:

Make sure you are importing your "Ledger" details

Because Whatnot is a newer platform, they are still making changes to their financial reporting to sellers. We have seen customers try to upload a different report that was rolled out after our integration went live.

To export it, open your Whatnot Seller Hub, choose the Financials menu and then "Ledger". Pick the date range you want to import, click "Export Data" and save the file.

Then open your Whatnot account from your dashboard and go to its upload page. If you connected Whatnot with the browser extension, that is the "Report uploads" tab. It has two cards: "Upload ledger export" takes the ledger CSV, and "Upload settlement statement" takes the weekly settlement statement, which you download from your Whatnot statements & reports page by clicking "Download CSV" on the week's row. Upload each week's statement separately. Tips and shipping adjustments only come in from the ledger export, so upload that too. If you set up your Whatnot account by uploading CSVs, the upload page has one card, "Upload Whatnot CSV", and it takes the ledger export.

Upload the original, unmodified CSV file

This is a top tip for all of our CSV import options from online sales channels. We built the integration to work with the default ledger details report that Whatnot provides. This means we relied on the format of their data. If you try opening the file in a spreadsheet before uploading to Seller Ledger, there is a good chance it will change some of the data formatting without your knowledge (Excel, for example, is notorious for changing date formats, even if you don't make any changes.)

If your upload fails

The Upload History on the upload page shows why a file was rejected. "Missing required columns" followed by a list means the file does not have those column headings, which usually means it is not the ledger export. The ledger export has a date column headed either "Date" or "Created Date", plus "Message", "Amount", "Listing ID", "Order ID", "Status" and "Transaction Type". Dates are written like "Mar 5, 2026, 3:04:05 PM", which is the format a spreadsheet tends to change.

If you upload a weekly settlement statement to the ledger card, or the ledger export to the settlement card, the message tells you which card to use instead.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.