PKParseKit
Start free
Menu

Guides · Invoice to CSV

Invoice to CSV: turn a folder of PDFs into one bookkeeping spreadsheet

Month-end for a freelancer is a folder, not a single PDF. Figma, the host, a contractor invoice, a client cost you paid and need back. ParseKit turns that pile into one CSV a spreadsheet can open, with the same seven columns every time.

Why “one PDF chat” breaks monthly bookkeeping

A chat window is a fair place to ask what the total is on the invoice you have open. It is a poor ledger. Each reply is a fresh paragraph. One vendor comes back as a sentence. The next comes back as a table whose headers have drifted: Total, Amount due, Grand total. You still copy cells by hand, and next month the shape has moved again.

Bookkeeping needs a file you can sort, filter, and send. A transcript of prompts does not pivot, and it does not stay stable from January to December. If you have been pasting invoices into a chatbot, the ChatGPT comparison spells out where that habit costs a month.

What a bookkeeping-ready CSV actually needs

A useful export is boring on purpose. The useful parts are the ones a bookkeeper already expects:

  • One row per charge, with the fields a bookkeeper can sort.
  • The same header row in January and in December.
  • Amounts as numbers, with currency in its own column, so USD and BDT are not added together by accident.
  • A pointer back to the file, for the day someone asks where a row came from.

When the columns change on every export, SUMIFs and pivots break. That is the job of a fixed schema: extract invoice data to CSV in a shape you can reuse. The fixed-schema guide is why those columns stay locked.

Batch upload vs pasting invoices one by one

Pasting one invoice into a prompt feels quick the first time. At a dozen vendor PDFs it becomes a ritual: open, upload, wait, copy, rename, repeat. A batch is the other direction. Drop the folder. Get one spreadsheet.

ParseKit is built for that pile — PDF invoices in one job — for freelancers and tiny agencies who share a drive of vendor files. It is a bookkeeping CSV, which leaves enterprise accounts-payable suites and general-purpose document chat to tools built for those jobs.

The ParseKit schema: date, vendor, amount, currency, category, notes, source_file

Every batch lands on these columns, in this order: date | vendor | amount | currency | category | notes | source_file.

  • date — the invoice or charge date.
  • vendor — who you paid.
  • amount — the number, without a currency symbol glued to it.
  • currency — USD, EUR, BDT, or whatever the document says.
  • category — a short label you can fix before you close the month (software, hosting, travel, contractor, and similar).
  • notes — the line that reminds you what the charge was.
  • source_file — the filename, so the row points back at the PDF.
date,vendor,amount,currency,category,notes,source_file
2026-03-03,Figma,15.00,USD,software,FigJam seats,figma-1842.pdf
2026-03-01,Superhost Digital,24.00,USD,hosting,northshore.example,hosting.pdf

Phone photos of receipts follow the same header. The receipt-to-CSV guide covers that pile.

Excel and Google Sheets: open, sort, pivot, hand to your accountant

Download the CSV and open it in Excel or Google Sheets (File → Import, or open the file directly). Sort by vendor. Pivot category by month. Share the sheet, or attach the CSV, when you hand the month to a bookkeeper.

QuickBooks is optional at this step. If you later import into accounting software, a stable CSV is a file someone can map. ParseKit fills the spreadsheet. It does not sync an accounts-payable platform, and it does not replace the general ledger.

Free vs Pro ($39/mo) for freelancers and tiny agencies

Free is 3 batches a month, up to 8 files each. That is enough to run a real folder and see the CSV. No card.

Pro is $39/mo for higher caps and priority when the pile is a shared drive of vendor PDFs — a tiny agency, not an AP department. About an hour of receipt typing, priced as a month of the tool. Paid checkout is Lemon Squeezy, and it may still be pending. Until that checkout is open, create a free account and upgrade later.

Start on the ParseKit homepage flow: free signup first. Pro stays $39/mo when Lemon Squeezy is live.

Start free — 3 batches/monthSee Free vs Pro on the homepage

FAQ

Can a batch mix currencies?

Yes. Amount and currency are separate columns. Filter or sort by currency before you total a column, or convert in the sheet. A single SUM of mixed currencies will lie to you.

What about messy scans?

Phone photos and rough PDFs are part of a freelancer folder. Read the rows before they hit the books. ParseKit extracts; you still confirm the amounts.

Who is this for?

Freelancers and tiny agencies who need invoice data in one bookkeeping spreadsheet. The product is that CSV. Enterprise invoice capture and a general “chat with any PDF” tool are different products.

Start free — 3 batches, no card