This month's expense receipts, in your spreadsheet without typing them one by one
Scan the receipts with your phone, give it your template and get the sheet back filled in, with the VAT apart and the receipts that will not do already marked.
How it is done today
The crumpled receipts arrive from petrol stations, taxis and restaurants. You make out each one, type the date, the business, the net amount and the VAT, and at the end you hand back the ones that are no good as an invoice. A whole morning, every month.
Estimated times
- By hand1 h 30 min
- With AI15 min
Estimated times, not measured with users.
What you need
- The receipts scanned with your phone into one PDF (the document scanner in the camera or the notes app).
- Your expense sheet template in Excel, empty.
- An AI assistant that reads PDFs and gives back Excel files.
Steps
- Lay the receipts on the desk ten at a time and scan one page per batch, all in the same PDF.
- Open your AI assistant, attach the template and the PDF, and paste the request below.
- Download the Excel file and add up the totals of the paper receipts yourself. Compare with the sheet's total.
- Check only the rows marked "unreadable" or "not deductible" and hand those receipts back to whoever brought them.
The request
Attached are our expense sheet template and a PDF with [number] receipts from [name] for [period]. Fill in the template with one row per receipt: date, business, issuer's tax number, category ([your categories]), net amount, VAT rate, VAT amount and total. If a receipt shows no tax number or does not break down the VAT, write "not deductible" in the notes column. If an amount cannot be read clearly, leave the cell empty and write "unreadable": do not guess it or round it. At the end, tell me how many receipts you read, so I can compare with the number I gave you.
What to check
- The sum of the paper receipts matches the sheet's total. If it does not, find the missing row before going on.
- The number of rows is the number of receipts. AI sometimes skips one lying sideways or merges two in the same photo.
- No amount is "guessed": a half-faded receipt should come out as "unreadable", not with a figure that looks plausible.
Privacy
Receipts carry names, and sometimes number plates or card numbers. Use the assistant your company has approved for expense data and do not upload full bank statements.
What you take away
A photo of several pieces of paper is already a table. What makes the difference is giving it your template and telling it what to do when it is not sure.
Do it in RUMBO with your files
RUMBO has an accounting trick that practises it with forty sample receipts, and then you do it with your own in Work.
Do it in RUMBOOne guide like this every week
One task a week. Free, and you can leave with one click from any email.
More guides
- Managers, team leads and office
From your meeting notes to minutes with tasks, owners and dates
Give it your notes as they are, handwritten or dictated, and get minutes ready to send and a table of who does what by when.
- By hand2 h
- With AI25 min
- Sales
From a voice note in the car to the follow-up email and the CRM record
As you leave a visit you dictate what happened for two minutes, and five minutes later you have the email to the client and the CRM fields filled in.
- By hand25 min
- With AI5 min
