Self-employed bookkeeping: hand your accountant a clean spreadsheet

What accountants actually want

A preparer can work from a spreadsheet. They cannot work quickly from a folder of vendor invoices, email forwards, and camera-roll photos. The useful delivery is one row per charge, amounts as numbers, currency in its own column, and a way to open the original when a figure looks off.

“Hand the accountant an invoice spreadsheet” means you already did the sorting. They still decide what is deductible. ParseKit does not file a return and does not give tax advice. It stops the part where you type the year from scratch the week before the appointment.

Fixed headers beat AI prose summaries

A paragraph that says “you spent about $400 on software” is not a bookkeeping CSV export. Neither is a table whose headers change every time you ask. Accountants reconcile cells. Prose makes them rebuild the cells.

• One header row, repeated on every monthly file.
• One expense per line, including receipt photos and invoice PDFs.
• No summary page standing in for the rows.

A year of monthly exports that still match

January’s file and November’s file should stack. Same column names, same order. You can paste each month under the last, or keep twelve tabs that a preparer can open without learning a new layout. The failure mode is a clever export in March that renamed vendor to merchant and dropped currency. April’s sheet no longer lines up, and the year becomes twelve dialects.

Close each month while you still remember the charge. A note written in April is useful. A note you invent in January of the next year, staring at a blurry photo, is a guess. The Google Sheets expense guide is the place those monthly files land if Sheets is your ledger.

Notes and source_file: fewer “where did this come from?” emails

Two columns do most of the follow-up work. Notes is the line you would have typed in the margin: client lunch with Northwind, FigJam seats, domain renewal. source_file is the filename of the PDF or photo, so the row points at the original.

When someone asks about a number, you reply with the row and the file name, not a search through three inboxes. Keep the original under the name you uploaded. The column stores that name. It does not replace your archive.

DIY Sheets or accounting software — pick by complexity

A solo year of software, hosting, travel, and a few contractors fits in a sheet. You do not need a general ledger to know what you spent. Move to QuickBooks, Xero, or whatever your preparer already uses when the books grow past that: payroll, inventory, sales tax you must file, or a bookkeeper who will only work in their system.

ParseKit does not sync those products and does not pretend to. A stable CSV is a file someone can map later. “Freelancer bookkeeping without QuickBooks” is a real path for a lot of people. It is not a claim that a spreadsheet replaces a ledger once the business needs one.

Tiny agencies: one CSV a month is enough to start

Two or three people and a shared drive are not an accounts-payable department. One person dumps the vendor PDFs and receipt photos. One person reviews categories. One CSV leaves the month. That is a small agency bookkeeping spreadsheet, not an approval workflow. The tiny agency expense CSV is that setup in more detail.

If the folder is large enough that someone is retyping it, the monthly batch workflow is the ritual: folder, parse, download, archive. Enterprise AP — vendor portals, three-way match, a payables team — is a different product from this export.

Free vs Pro ($39/mo) when the year spikes

Free is 3 batches a month. A quiet month of receipts fits. Tax season, a launch, or a shared agency folder often does not. Pro is $39/mo for higher caps and the same columns, so a busy quarter does not invent a second schema.

Checkout is Lemon Squeezy when it is live. Until then, start free and run a real month. This page is not a buy button. The point of starting before the crunch is that December’s header already matches January’s.