How to export your expenses to CSV for taxes
Your accountant does not want photos of receipts — they want one tidy spreadsheet. Here is how to make that a one-tap job instead of an April panic.
Every year it goes the same way. Tax season arrives, and somewhere in a drawer or a phone gallery sits the shoebox — a fistful of faded thermal receipts, a few screenshots, a vague memory that there was a coworking membership in March. You spend a weekend reconstructing a year of spending from fragments, and you still under-claim because half the cash payments left no trace at all. There is a better way, and it is almost embarrassingly simple: keep your expenses in a form you can export, and the whole ritual collapses into a single tap.
That form is the CSV — comma-separated values, a plain-text spreadsheet that every program on earth can read. It is the universal language between you and any accountant or any tax tool. Your bookkeeper uses one system, your tax software uses another, you use a third; CSV is the neutral ground where all of them meet. Get your year into a clean CSV and you are done arguing about formats forever.
What a useful expense CSV contains
A CSV is only as good as its columns. A wall of amounts with no context is barely better than the shoebox. The columns that actually earn their place are the ones that let your accountant — or future you — understand each line without asking a single follow-up question.
Date tells the period it belongs to. Amount and currency belong together: 250 means nothing on its own when you spend in baht one week and euros the next. Category sorts the deductible from the personal. Note or merchant is the memory jog that turns "12.40" into "client lunch, Café Lente." And payment method separates the card spending your bank already knows about from the cash it never saw.
| Column | Example | Why it matters |
|---|---|---|
| date | 2026-03-04 | Pins the expense to a tax period |
| amount | 1200.00 | The number, kept exact |
| currency | THB | An amount is meaningless without it |
| category | Software | Separates deductible from personal |
| note | Figma subscription | The line you'll thank yourself for |
| method | Card | Tells cash apart from card |
Keep it export-ready all year
Here is the part nobody tells you: the export is the easy bit. The real trick is capture. A clean CSV in April is just the receipt for good habits the previous twelve months — and a messy one is the receipt for none. If you log as you spend, December is a download. If you don't, December is archaeology.
Three habits do almost all the work. Log as you spend, ideally in the seconds after you pay, while you still remember what it was for. Categorize at entry, not in a giant sorting session months later — a category chosen in the moment is far more accurate than one guessed from a bank line that just says "PAYPAL." And keep the original currency; converting on the fly loses information, and you may need the as-spent figure for some jurisdictions. The cash payments are the ones that vanish first, which is exactly why a fast manual habit beats a bank feed — see our piece on the expense app without a bank connection for why feeds miss most of your real spending.
How to export from ExpenseAI
We build ExpenseAI, so the obvious caveat applies — but the flow is genuinely the boring one we wanted. First, open the month or date range you need: a single month for a quarterly handoff, or the full year come tax time. Second, tap Export. Third, choose CSV. The file lands in your email or in Files, with the columns already labelled so your accountant doesn't have to decode a thing. If you've been spending across borders, multi-currency totals are preserved rather than flattened into one mystery number, so the original baht, dong or euro figures survive the trip into the spreadsheet.
To be candid about the model: capture is free, and CSV export is a Premium feature — $2.99 a month or $29.90 a year. The free tier is there so the habit costs nothing to start; export earns its keep the moment a real spreadsheet has to leave the app and go to someone who does taxes for a living.
From CSV to your accountant (or tax software)
Once the file is out, you have options. Open it in Google Sheets or Excel and it becomes a working spreadsheet you can total, filter and pivot however you like. Or skip that entirely and hand the raw CSV to your accountant — it is precisely what they would have typed in by hand anyway. Most bookkeeping tools ingest CSV directly too: QuickBooks, Xero and Wave all import it, usually with a one-time step where you map your columns to theirs.
For the self-employed working abroad, categories like software, coworking space, professional services, travel and a portion of communications are the usual suspects for deductions — but this is where honesty matters more than enthusiasm. Rules vary enormously by country, by residency status and by how you're registered, and what's deductible in one place is plainly not in another. Keep your categories general and complete, and let the person who knows your jurisdiction decide what counts. In other words: ask your accountant. A good CSV makes that conversation a five-minute one instead of a forensic investigation.
The habit that makes tax season boring
The whole point is to make April uneventful. Capture-as-you-go beats reconstruct-later every single time, because the information you need — what it was, in which currency, for which purpose — is only fully available in the moment you pay. Wait three months and you're guessing; wait a year and you're inventing. Log it once, categorize it once, and the export at the end is just pressing a button. If most of your spending is cash, the tracking cash abroad guide covers the discipline that keeps those payments from disappearing, and our comparison shows how the export options stack up across tools. Do the small thing all year, and the big thing takes care of itself.