Receipt to CSV on a Mac
By Kayabyte · Last updated 29 October 2026
Receipts pile up as photos, email PDFs and crumpled paper. Expense reports and bookkeeping want rows: date, merchant, total, tax, and sometimes the items. Here is a way to get there that keeps the images on your Mac.
1. Get a clean image
Photograph the receipt flat, in good light, against a plain background, with the whole receipt in frame. Scans at 200 to 300 dpi work best. For email receipts, save the PDF.
2. Type it, or copy it
For a few receipts, typing date, merchant and total into a spreadsheet is fine. Copy and paste works for PDFs with real text. Photos need text recognition; Preview and Live Text on a Mac can copy text out of an image, though not in a table.
3. Check what you captured
A receipt has built-in checks: the items add up to the subtotal, the subtotal plus tax equals the total. Compare them before you file the row.
4. Where Balanced helps
Balanced reads receipt photos, scans and PDFs on your Mac using Apple’s on-device text recognition and fixed rules, not AI. It shows the header (merchant, date, currency, subtotal, tax, total) and the line items, runs the checks above and marks lines that do not add up. A receipt that shows only a total is shown as not checkable. Export as CSV or Excel, one row per receipt or one row per item, and combine many receipts into one file. Nothing is uploaded.
Honest limits: invoices vary a lot, so check the header and the line table in the preview; a poor scan or a photo taken at an angle can misread digits (the checks usually catch it); a password-protected PDF has to be unlocked first. Nothing here is accounting or tax advice. Faint thermal paper and crumpled receipts are the hardest cases.
Download Balanced and try it free: the free version reads and checks everything, exports up to 3 invoices in one file, and needs Pro beyond that. Pro is USD 59 per year or USD 7.99 per month, for up to 3 Macs. See pricing and the help page. macOS 14 or later.
Related guides
More guides
- How to import an Amazon settlement report into QuickBooks Online (or Xero)
- How to export Apple Card transactions to a spreadsheet
- Balanced vs DocuClipper, ProperConvert, Dext and Craftybase
- How to convert a Bank of America statement to Excel
- How to turn a bank statement into Beancount
- The best bank statement converter for Mac
- How to turn a Chase statement into Excel or CSV
- How to convert a PDF bank statement to CSV
- How to convert a PDF bank statement to Excel
- Dext, Hubdoc and AutoEntry alternatives on Mac
- DocuClipper alternatives for Mac: online service or an app on your Mac
- eBay transaction report to Excel or QuickBooks
- Etsy sales tax and fees bookkeeping
- How to convert an Etsy monthly statement to a Schedule C worksheet
- How to import a bank statement into Actual Budget
- How to import a PDF bank statement into Xero
- How to import a PDF bank statement into YNAB
- Import supplier invoices into Xero bills
- Bookkeeping for marketplace sellers on a Mac
- PayPal activity CSV to QuickBooks or Xero
- How to convert a PDF bank statement to OFX
- How to import a PDF bank statement into QuickBooks as a QBO file
- How to get a PDF bank statement into Quicken (QIF or QFX)
- A private bank statement converter for Mac: keep your statements off other people’s servers
- ProperConvert alternatives for Mac: what to compare before you pay
- Shopify payouts reconciliation
- Stripe payouts reconciliation
- Why a converted bank statement doesn’t add up (and how to fix it)