DEV Community

vernonroque
vernonroque

Posted on

Turning a Folder of Receipts into a Clean Spreadsheet — No Manual Entry, No Duplicates


If you've ever had to manually enter receipts into a spreadsheet, you know the drill: retype every line item, double-check you haven't already logged that one, then do the math to convert a foreign currency total into your home currency. It's slow, and it's exactly the kind of task that's easy to mess up when you're doing it by hand.

I built a small app to solve that. It takes a batch of receipt images and turns them into clean, spreadsheet-ready data — automatically.

What it does

The app is a simple front-end on top of a receipt parser API, and it handles three things that usually cause the most friction when processing receipts manually:

  • Batch upload — drop in a whole folder of receipt images at once instead of processing them one by one.
  • Deduplication — if the same receipt gets uploaded twice (easy to do when you're going through a big batch), it's automatically caught instead of showing up as a duplicate line item.
  • Foreign currency conversion — receipts in different currencies get normalized automatically, so you're not manually converting totals before you can compare or total them up.

Getting your data out

Once your receipts are processed, you have two ways to get the data where you need it:

  • Export to CSV — download a clean file ready to open in any spreadsheet tool.
  • Copy and paste into Google Sheets — for a faster workflow, the output is formatted so you can paste it directly into a sheet without reformatting.

Setup

There's no complicated onboarding. To start using it:

  1. Paste in your API key
  2. Paste in the API endpoint
  3. Start uploading receipts

That's the entire setup — no configuration files, no separate integration step.

Try it

If you're dealing with a stack of receipts — whether it's expense reports, bookkeeping, or just cleaning up your own records — give it a try:

Let me know what you think, or if there's a feature you'd want to see added.

Top comments (0)