Bookkeeping from the CSV: your customer export as a working ledger

The email from the accountant is four lines long and asks for the year's sales in a format they can open. What you have is a payout history, a folder of screenshots, some DM threads about refunds and a memory of roughly how the summer went. This is the point where most creators lose a weekend. It is also the point at which a single export would have done the job, if you had been taking one all along.

Why creator bookkeeping falls apart

It is rarely laziness. It is that the money arrives in a shape that hides the detail. A payout is a net figure covering several sales, minus processing, landing days after the fact. Nothing in that number tells you which product sold, whether a discount applied, whether one line was a delivery fee or whether a membership renewed. To reconstruct a year from payouts alone is genuinely difficult work, and it gets harder the longer you leave it.

The second problem is that a creator business has more transaction types than a shop. A shop sells things. You might sell a file, a seat on a call, a monthly membership that renews on its own, a bundle, a tip someone left because they liked a post, and a free lead magnet that is not revenue at all but still creates a customer record. Those need different treatment and they all look identical from the bank's side.

What is honestly hard, and worth saying plainly, is that no export makes you compliant. A CSV is raw material. It still needs categorising, and the categories depend on where you live and how you are registered. What the export removes is the archaeology, which is the part that eats the weekend.

Screenshots versus one export

The customer list is not a marketing feature that happens to hold data. It is the most complete record you have of who paid you what, and it is downloadable in full on every plan.

Turning the export into a ledger

The aim is not a beautiful accounting system. It is one file per month that a professional can read without asking you follow-up questions. Twenty minutes on the last day of the month is enough.

1. 1Open the customer list in your dashboard and export the full CSV on the last day of the month.
2. 2Save it with a date in the filename, such as customers-2026-05.csv, and never edit the original file.
3. 3Make a copy called ledger-2026-05 and do all your working in the copy, so the raw export stays untouched as evidence.
4. 4Add three columns of your own: gross amount, processing fee, and category.
5. 5Categorise each row into digital, physical, booking, membership, tip or lead magnet, because those six labels answer most accountant questions.
6. 6Note refunds as negative rows rather than deleting the original, so the history still shows what happened.
7. 7Put the twelve monthly files in one folder and hand over the folder, not a summary you typed from memory.

The columns worth adding by hand are the ones no export can know for you:

• Whether an amount was a delivery fee rather than product revenue, since only physical orders carry one.
• Whether a payment was a first sale or a membership renewal, which matters if you account for subscriptions across the period they cover.
• Whether the money came from a customer at all, or from affiliate commission, which is a separate income stream arriving in the same Stripe account.
• Any cost you paid that month that relates directly to an order, such as packaging and postage on physical items.

A worked example with ordinary numbers

A modest month: 22 digital sales at £15, four coaching calls at £80, nine memberships renewing at £9, one physical order at £40 with a £5 delivery fee, and 61 lead magnet claims at £0. The export shows every one of those as a row. Categorised, it becomes £330 digital, £320 bookings, £81 membership, £40 physical, £5 delivery and £0 from the lead magnets, against a gross of £776 before Stripe's processing.

The 61 free claims are the interesting part. They earn nothing this month and they are the reason next month has anyone in it. Because they arrive as customer records with a lifetime value of zero, you can see the conversion honestly: how many of last month's free claims appear in this month's paid rows. That is a business number, not a tax number, and it is sitting in the same file for free.

The mistake most people make

Waiting until the year ends. An export taken in January describes the list as it is in January, not as it was in June, and a year of activity compressed into one file is much harder to categorise than twelve small ones. The second mistake is editing the raw export in place. Once you have typed over a cell, you no longer have a record, you have a working document, and the two should never be the same file. Copy first, work second.

A ledger is not a piece of software. It is a habit with a filename. If you are moving from somewhere else, bringing your list across takes a CSV and a few minutes, and from that point on the export does the remembering for you. What you spend on the platform to do it is on the pricing page, and the export itself costs nothing on any tier.