How to Export Expense Reports for Your Accountant (eXpense Tutorial)

Tracking expenses is only half the job. The other half is handing clean, audit-ready data to your accountant — in a format they can import without manual re-entry. eXpense supports CSV, PDF, and direct integrations with major accounting platforms. This tutorial walks through the export workflow that minimises friction with your accountant and prevents reconciliation errors at tax time.

Tutorial: the monthly export workflow

Step 1 — Prepare before exporting. Open eXpense on the macOS app (the larger screen makes review faster). Filter by month. Look for: uncategorised expenses (highlighted in yellow), missing receipt attachments (a small icon), unusual amounts (over 2x your monthly average for that category — these often turn out to be misread by OCR). Fix these before exporting.

Step 2 — Map categories to tax codes. If your accountant uses specific account codes (e.g. QuickBooks chart of accounts), open eXpense Settings → Categories. For each category, add the matching tax code in the "Account code" field. Example: eXpense category "Business meals" maps to QuickBooks account "5200 - Meals & Entertainment". This mapping persists across all future exports — set it up once.

Step 3 — Choose the export format. File → Export. Choose CSV if your accountant uses spreadsheet-based workflows (Excel, Google Sheets) or accounting software with CSV import (QuickBooks Online, Xero, Wave). Choose PDF if your accountant prefers a formatted report (commonly UK firms, some EU advisors). Choose "Accounting Package" for direct exports to QuickBooks Online (IIF format) or Xero (CSV with their column ordering).

Step 4 — Select the date range. Quarterly (Jan-Mar, Apr-Jun, etc.) is the most common for VAT returns. Monthly is better for cash flow reviews. Year-to-date is useful for mid-year tax planning. eXpense remembers your last 5 date ranges for one-tap re-export.

Step 5 — Include attachments. CSV: enable "Include receipt images" — this creates a separate ZIP file with all receipts numbered to match the CSV rows. PDF: receipts are embedded as thumbnails automatically. Without attachments, the export is incomplete for tax purposes — auditors require visual proof.

Step 6 — Send to your accountant. File → Share → Mail (or Drive, or Dropbox). eXpense pre-fills the subject line with the period covered and your name. Add a short note: "March 2026 expenses, 47 receipts, total EUR 2,847.50, see attached."

Setting up category-to-tax-code mappings

The biggest source of accounting friction is mismatched categories. eXpense's default categories are pragmatic for personal use, but your accountant likely thinks in chart-of-accounts codes. The fix is to set up the mapping once and never touch it again.

For UK accountants (VAT scheme):

• Office Supplies → 7700 Stationery & Office Supplies (VAT 20%)
• Software/SaaS → 7600 Subscriptions (VAT 20%, reverse charge for non-UK suppliers)
• Travel/Train → 7400 Transport (VAT 0% on UK rail, 20% on taxis, 0% on international air)
• Meals (client) → 7301 Entertainment (VAT non-deductible)
• Meals (own/team) → 7302 Subsistence (VAT 20% deductible)

For Spanish autonomos (IVA scheme):

• Office Supplies → 629 Suministros (IVA 21%)
• Software/SaaS → 623 Servicios profesionales (IVA 21%)
• Travel domestic → 624 Transportes (IVA 10% on Spanish rail, 21% on taxis)
• Meals (client) → 627 Relaciones publicas (IVA deductible only up to 1%)
• Phone/Internet → 629 Suministros (IVA 21%)

For German Selbststaendige (MwSt scheme):

• Bueromaterial → 4940 Bueromaterial (MwSt 19%)
• Software → 4806 Software (MwSt 19%, MOSS for non-EU)
• Reisen (Bahn) → 4673 Fahrtkosten (MwSt 7% on Bahn, 19% on taxi)
• Bewirtung Geschaeftspartner → 4654 Bewirtungskosten (70% deductible)
• Telefon/Internet → 4920 Telefonkosten (MwSt 19%)

Freelancer workflow: monthly close in 15 minutes

Most freelancers procrastinate on expense tracking until tax season, then spend a weekend reconstructing receipts. The alternative — a 15-minute monthly close — is far less painful.

Last Sunday of each month:

1. Open eXpense, filter to current month (2 min)
2. Review uncategorised + missing-receipt entries (5 min)
3. Compare total against bank statement to catch missed expenses (3 min)
4. Export CSV + receipt ZIP (1 min)
5. Email to accountant with running totals (4 min)

Set a recurring calendar event for the last Sunday at 18:00. After 3 months of consistent practice, the habit sticks and tax season becomes a non-event.

Comparison: export formats and use cases

Frequently asked questions

What formats does eXpense export?

eXpense exports to two main formats: CSV (comma-separated values, with columns for date, merchant, category, amount, currency, VAT, payment method, notes) suitable for direct import into Excel, Google Sheets, QuickBooks, Xero, and most accounting software; and PDF (formatted report with running totals, category breakdowns, and embedded receipt thumbnails for audit purposes). You can also export individual receipts as JPG.

Can I customise the categories?

Yes, eXpense ships with 18 default categories (Meals, Travel, Office Supplies, Software, etc.) but you can add unlimited custom categories. Each category can have a tax code mapping (e.g. UK VAT rate 20%, Spanish IVA 21%, German MwSt 19%) so the export pre-fills the correct rate for your accountant. Categories can also have keyword rules — 'Uber' auto-categorises to 'Travel', 'AWS' to 'Software'.

Does the export include receipt images?

The PDF export includes receipt thumbnails inline next to each expense — auditors can verify amounts visually. The CSV export references a separate ZIP file with full-resolution receipt JPGs named by date+merchant. For digital tax compliance (e.g. UK Making Tax Digital, Spain Verifactu, Italy Fattura Elettronica), keeping the original receipt image is mandatory — eXpense handles this automatically.

How often should I export to my accountant?

For freelancers in most EU countries, quarterly export is standard (VAT returns are usually quarterly). Some accountants prefer monthly to keep up with cash flow questions. For employed people with reimbursable business expenses, export at the end of each reimbursement cycle (often monthly). The key is consistency — pick a rhythm and stick to it.