Turn a pile of receipts into a table

Whether it is a shared holiday, a work trip or a month of household spending, the tedious part is typing it all up. Read the receipts aloud into your phone or type them roughly, and ask AI to turn the mess into a table with categories and totals.

For shared costs, add: “split it between [names], [name] paid for these lines — who owes whom?” You get the final numbers without the group-chat arithmetic. Leave out card numbers and anything else you would not write on a postcard.

Why a table changes what you see

A pile of receipts is noise. The same information in a table, with a total at the bottom of each category, is an answer. You see at a glance that the month’s “few small things” came to more than the electricity bill, or that a work trip cost exactly what you need to claim. Turning one into the other by hand is tedious enough that most people never do it. AI does it in seconds, and that is the whole value of this hack.

Three ways to get the data in

1. 1

   Type it roughly

   “12 March, supermarket, 43.20. 13 March, petrol, 55.” Messy is fine. One line per purchase is ideal.

2. 2

   Photograph the receipts

   If your app accepts images, a clear photo of each receipt works. Lay them flat, with good light, one or two per picture.

3. 3

   Paste from your bank

   Copy the lines from your online statement, or export them, and paste in the dates, descriptions and amounts. Remove account numbers first.

A worked example

After a five-day work trip there are fourteen receipts in a jacket pocket. They are typed in as rough lines. The request is a table with date, shop, category and amount, with totals per category and overall.

What comes back is a clean table with four categories: travel 186.40, accommodation 412.00, meals 97.35 and other 23.10, for a total of 718.85. It flags two things: one receipt has no date, and two meals on the same evening look like possible duplicates. That flagging is useful. You check the pocket, find that one of them was a colleague’s receipt, and correct the total before submitting it.

Useful things to ask for

• “Add a column for payment method: card, cash or company card.”
• “Separate what I can claim from what is personal, using these rules: [paste your employer’s policy or your own rule].”
• “Convert the amounts in [currency] to [currency] using this rate: [rate]. Show both columns.”
• “Total by week as well as by category.”
• “Sort by amount, largest first, and show each category as a percentage of the total.”
• “Format the table so I can paste it straight into a spreadsheet.”
• “Write a two-line summary of this month’s spending in plain language.”

Always check the numbers

This matters. AI is good at structure and usually good at arithmetic, but it can misread a digit in a photo, skip a line or add incorrectly, especially with long lists. Before you rely on a total, count the rows against your receipts and check the sum with a calculator or the spreadsheet’s own formula. The most reliable method is to let AI build the table and let the spreadsheet do the adding. For anything going to an employer, an accountant or a tax office, a wrong total is your responsibility, not the tool’s.

Privacy and paperwork

Receipts can carry more than prices: the last digits of a card, a loyalty number, your name, sometimes an address. Remove or cover what is not needed before you paste or photograph. Never share full card numbers, bank account numbers or passwords. If the receipts belong to your employer’s business, check whether you are allowed to put that information into an outside AI tool at all. Many workplaces have rules about this.

Keep the originals. A table is a summary, not proof. Tax authorities and employers usually require the receipt itself, on paper or as an image, and the length of time you must keep it depends on your country. Check the official guidance.

Make it a monthly habit

Once you have done this for a trip, try it for a month of household spending. Put receipts in one envelope, or take a photo of each as you get it and keep them in one album. On the last day of the month, spend ten minutes turning them into a table. Ask for the same categories each time so the months can be compared. After three months, ask AI what changed and where the biggest swings were. This is the least painful way to learn where your money goes, and it is the natural first step to a simple budget.

For the self-employed and side projects

If you run a small business or have freelance income, a monthly table of expenses by category saves hours at tax time. Ask for categories that match the ones your tax return or accountant uses. Add a column for the business purpose of each expense while you still remember it. Keep in mind that what counts as an allowable expense is defined by your tax authority, and AI can be wrong about it. Use the table to get organised, and take the rules from the official source or a qualified accountant.

Common mistakes

• Trusting the total without checking it.
• Mixing personal and work receipts in one pile.
• Using different category names each month, so nothing can be compared.
• Throwing away the originals after making the table.
• Leaving it for six months. Faded receipts and forgotten purchases are much harder to sort.

Quick questions

1. 1

   Can it read handwritten or faded receipts?

   Sometimes. Check those lines carefully, or type them in yourself.

2. 2

   Which categories should I use?

   Five to eight that mean something to you: food, transport, home, health, fun, work, other.

3. 3

   Is a spreadsheet necessary?

   No, but pasting the table into one lets the software check the sums and keep a history.