match receipts to card lines for an expense report
the station receipt and the card slip can be the same train fare. give a bot the receipts for one trip and the relevant card lines.
ask for a draft expense report that ties each claim to its evidence. you get missing receipts and ambiguous matches back before they reach the expense approver.

the routine
name the trip and the statement range before matching. store legible receipts together in the trip’s folder.
paste this into a chat with your bot
every friday at 2 pm, prepare the trip marked ready in the "travel ledger" google sheet. read its card lines and trip notes from trips!a2:j80. in your project folder, look under travel/receipts/ for the folder named for that trip id. compare each receipt there with merchant, transaction date, amount and currency. give each proposed claim its statement row and receipt filename. list unpaired card rows and unpaired receipts separately.
keep posted amounts and original currencies in separate columns. group possible duplicates for my review. leave business purpose blank unless my trip notes explain it. leave personal items out of the claim. return a draft here without editing the sheet or submitting anything.- when
- fridays at 2 pm for the trip you marked ready
- needs
- read only google sheets, receipt files and trip notes with a business purpose. use your workbook, range and receipts folder in the message.
what comes back looks like this (an example, not a real inbox)
example trip draft for monica
row 14 | rail fare | £23.60 | rail-ticket.pdf | depot visit
possible second copy | card-slip.jpg | same fare and time, no extra claim
row 17 | £8.40 | no receipt match | ask travellergive each purchase a trail
one purchase should lead back to one claim. number the card rows and keep the original receipt filenames. a ticket shows the journey. a terminal slip shows payment. both can support the same expense. counting the files would double it.
reconcile the two piles
work from the card rows, then look at what's left.
let the traveller explain the awkward entries
only the traveller knows who paid for lunch. ask for the attendees or project when your policy needs them. the approver decides whether a split bill, tip or missing receipt qualifies.
if your employer requires expense software with policy enforcement and an approval trail, file there. dusk bot can prepare the evidence before you open it.
the guard rails
- hide full card numbers and unrelated purchases before sharing the files. keep the last few digits only if needed for matching.
- use read only access for the statement sheet. keep originals intact for the expense approver.
- never convert currencies using a guessed rate. keep the posted charge and original receipt amount visible.
what it looks like
an invented depot visit
before
monica has a rail ticket and a card slip for £23.60. the statement shows one charge. a separate £8.40 line has no matching image.after the bot
the rail fare appears once with both files beside it. the smaller charge stays under missing evidence until monica finds the receipt or uses the employer's exception process.an illustration with made-up names and numbers.
try it in 2 minutes
- pick a trip with a receipt and its card slip
- save both in the folder for that trip id
- ask how many distinct purchases the evidence supports
mistakes people make
claiming the whole restaurant bill after splitting it
use the amount the traveller actually paid. keep the itemized bill for context.
pairing by amount alone
two identical fares can be separate journeys. look at dates, ticket references and payment evidence.
what it could save you
around 15 minutes per trip with this workload
10 purchases × 3 minutes collating evidence = 30 minutes
30 minutes - 15 minutes preparing files and reviewing matches = 15 minutesa rough estimate. it assumes:
- use a recent trip with ten purchases
- include photographing, filing and correcting receipts in the comparison
- count filing and approval time if either method changes it
questions
what happens to a receipt for a cash purchase?
keep it under unpaired receipts. confirm how you paid, record the business purpose and follow the employer's cash expense rules.
can the bot decide which expenses are reimbursable?
give that decision to your approver. the draft shows what you spent and where the evidence sits. a good match alone says nothing about eligibility.
sources
- composio: google sheets actions, checked 12 november 2026
- dusk bot docs: files and connected apps
- dusk bot docs: routines
drafted with ai help from the dusk bot docs and the sources listed on this page, then checked against them. if something here is wrong or out of date, write to [email protected].
match weekly receipts to the sheet you already keep
a google sheets bot that flags low stock by row
an invoice follow-up bot that leaves reminders for review
claude connectors: connect the job you actually need
add new records to the end of a google sheets table
copy one google sheets tab into another spreadsheet