A CSV export is only useful if the information behind it is clean. If your accountant receives a spreadsheet full of vague merchants, missing taxes, and mystery categories, they still have to chase you for context before they can do anything with it.
The better workflow is simple: scan receipts as they happen, review the details while the purchase is still fresh, then export a clean CSV and PDF package when it is time to hand records over.
What your accountant actually needs from receipts
Most accountants do not want a pile of images with no structure. They need enough detail to connect each purchase to a business activity and to sort it into the right bookkeeping category.
A useful receipt export usually includes:
- the purchase date,
- the merchant or supplier,
- the total amount,
- any sales tax shown on the receipt,
- the category or expense type,
- a short note when the business purpose is not obvious,
- and access to the original receipt image if a line item needs to be checked.
The CSV is the working file. The receipt images and PDF report are the backup. Together, they give your accountant a summary they can sort, filter, and import without losing the evidence behind each row.
Step 1: Scan receipts before they fade or disappear
The handoff starts long before export day. Scan paper receipts as soon as possible, especially thermal receipts that fade quickly or get damaged in a wallet, glove box, or backpack.
If you need a capture routine, start with this practical guide to scanning receipts with an iPhone for expense tracking. The key is not perfection; it is consistency. Good lighting, the full receipt in frame, and a quick review after scanning prevent most end-of-month cleanup.
For digital receipts, save the screenshot or PDF in the same system you use for paper receipts. Your accountant should not have to reconcile one set of expenses from your inbox, another from your camera roll, and a third from a shoebox.
Step 2: Review the fields while the purchase is fresh
OCR can pull the obvious details from a receipt, but you are still the best source of context. Review each record quickly before you move on.
Check that:
- the merchant name is recognizable,
- the date matches the purchase,
- the total is right,
- GST/HST or other tax lines were captured when shown,
- the category makes sense,
- and the note explains anything that would be unclear later.
For example, “coffee” may be too vague. “Client meeting after site visit” gives your accountant a useful clue. “Hardware store” may need a note if the purchase was for a customer job, office repair, or vehicle kit.
Step 3: Use categories your accountant can map
Categories should be specific enough to help, but not so detailed that the export becomes noisy. If you create twenty near-identical categories, your accountant may spend more time merging them than using them.
A practical setup might group receipts into plain-language buckets such as supplies, software, meals, travel, vehicle, subcontractors, phone, or office. Your exact categories depend on your business and bookkeeping setup, so ask your accountant what they prefer if you already work with one.
The goal is to make the CSV easy to scan. Every row should answer: what was purchased, when, from whom, for how much, and why it belongs in the business records.
Step 4: Keep mileage and receipt context together
Receipts rarely tell the whole story for vehicle-related work. A fuel, parking, toll, maintenance, or car-wash receipt is more useful when it is connected to mileage context and a business purpose.
If you drive for client work, deliveries, site visits, or gig jobs, keep your mileage records in the same workflow as your receipts. That way, the export does not separate vehicle costs from the trips that explain them.
This is especially helpful for freelancers who do a quarterly review. Instead of reconstructing driving notes from a calendar, you can give your accountant a cleaner record of receipts, mileage, dates, and business context.
Step 5: Export both CSV and PDF
When your records are reviewed, export them in the formats that solve different problems.
A CSV is best for analysis and bookkeeping because it can be opened in spreadsheet software or imported into accounting tools. Your accountant can filter by date, category, merchant, tax amount, or total.
A PDF report is easier to read as a human summary. It is helpful when someone needs to skim categories, confirm a date range, or keep a static copy with the receipt images. If a question comes up later, the PDF and receipt images support the rows in the CSV.
Before sending anything, open the CSV yourself and spot-check a few rows. Look for blank merchants, obvious category mistakes, duplicate receipts, or totals that look wrong. A five-minute review can save a long email thread later.
A clean accountant handoff checklist
Before you send the file, confirm that:
- the export covers the right date range,
- personal receipts are excluded or clearly marked,
- categories are consistent,
- large or unusual purchases have notes,
- mileage records are included when relevant,
- receipt images are retained as backup,
- and the CSV opens correctly on your computer.
If you are preparing for tax season, you may also want a year-round receipt structure. This guide on organizing receipts for taxes in Canada covers the broader system behind the export.
Make the export boring
The best accountant handoff is boring in the best way: clear rows, clear categories, readable receipts, and no mystery expenses. That does not require a complicated bookkeeping system. It requires a simple habit that turns each receipt into structured data before it gets lost.
PKTD is built for that workflow: on-device receipt scanning, automatic GST/HST capture, mileage tracking, and CSV/PDF exports that keep the original receipt context close by. See the receipt and export features or download PKTD on the App Store when you are ready to stop turning receipt cleanup into an end-of-month project.