One Trip, One Expense Report
You are back, and a week of flights, hotels, taxis and dinners is scattered across your inbox and your card statement. Somebody wants one report for the trip — and the fiddly part is not adding it up. It is deciding what belongs in it.
Ask for the report instead of building it
If you have ExpenseBot connected to an AI assistant, you do not open a screen or learn where the filters live. You say what you want:
"Create a report for my Mexico trip, but leave out personal expenses."
Then, in order:
- It works out the trip and the dates from what you said and from expenses you actually have.
- It shows you the set before changing anything — how many expenses match, the totals in their original currencies, a few representative rows, and exactly which personal expenses it plans to leave out. If a report already covers some of them, it says so.
- You confirm. Nothing is grouped, changed or created until you approve what you were shown.
- It builds the report from exactly the expenses you approved and tells you the real counts, including anything that conflicted or failed. Never "all done" when it was partial.
- You get the links back: the finished report, Review expenses, and the Google Sheet.
Then the next thing is one more sentence, in the same conversation:
- "Share it with my accountant." — it asks you to confirm the recipient first.
- "Download that report as a PDF."
- "Take me to bill the client for this trip." — opens the Bill Client screen.
This works from Claude, ChatGPT, Cursor, or any other MCP-compatible assistant — one account behind all of them. See connecting ExpenseBot to an AI assistant.
The trip's receipts are already in your inbox
Travel is the one category that documents itself. The airline emailed the itinerary, the hotel emailed the folio, the rideshare emailed every ride, and the restaurant emailed the card receipt. None of that needs forwarding.
ExpenseBot's overnight Gmail scan reads those emails where they already are and writes the vendor, date, tax and total into a Google Sheet in your own Drive. By the time you are home, the trip week is largely captured. Anything you paid in cash you photograph.
Per-diem instead of receipts? The per diem calculator covers that case.
Keeping personal spending out of a business trip
This is the part that makes trip reports annoying rather than long. The bar round that was not business. The extra night you stayed on. The gift you bought on the last afternoon. Nobody remembers which was which three weeks later, and a report that quietly includes them is a problem you find out about later.
Expenses tagged Personal — or sitting in a personal category — are left out of the report by default, and the preview names them before anything is created. You see the exclusions as a list, not as a silent subtraction, so a mis-tagged expense is obvious while you can still fix it.
Nothing is deleted. The expense stays on your sheet with its receipt; it simply is not part of the business report.
Or do it by hand
None of this requires an AI assistant. In ExpenseBot, group the trip's expenses in Review expenses, then create the report from the Reports screen — the same grouping, the same report, the same exclusions.
The conversation is a faster route to the same result, not a different one. If you would rather look at a list and click, that path is fully supported and always has been. For recurring reports that build themselves on a schedule, see automated expense reports.
What it will not do
These are deliberate limits. A tool that guesses about your expense report is worse than one that asks.
- It does not invent trip membership. If you ask for a trip with no matching expenses, it says so — it will not manufacture one or create an empty report to satisfy the wording of your request.
- It does not reconstruct your itinerary. It matches the criteria you gave against expenses you actually recorded.
- It does not send an invoice. "Bill the client" opens the screen; what happens there is your call.
- It does not email a report on its own. Sharing is always a separate confirmation with the recipient named.
- It does not change a report you already created. A report is a snapshot; later expenses need a new one.
- One expense belongs to one group. If a receipt is already on a trip and you ask to file it under a client, it explains the conflict and asks which you want.
Trip expense report FAQ
How do I create an expense report for one trip?
Connect ExpenseBot to an AI assistant and ask for it in plain language — for example "Create a report for my Mexico trip, but leave out personal expenses." ExpenseBot works out the trip and date criteria, shows you the matching expenses and which personal ones it plans to exclude, waits for you to confirm, then builds the report from exactly what you approved. You can also do it by hand: group the expenses in Review expenses, then create the report from the Reports screen.
How do I keep personal spending out of a business trip report?
Expenses tagged Personal or in a personal category are left out of the report by default, and the preview names them before anything is created, so you can see exactly what is being excluded and correct it if something is mis-tagged. Nothing is removed from your records — the expense stays on your sheet, it simply is not part of the business report.
Does ExpenseBot know which expenses belong to my trip?
It matches on the criteria you give it — dates, location, merchants — against expenses you actually recorded. It does not reconstruct an itinerary and it does not invent trip membership. If nothing matches what you asked for, it tells you and creates nothing rather than producing an empty report.
Can I send the report to my accountant or bill a client for it?
Yes, both are one more sentence in the same conversation. "Share it with my accountant" asks you to confirm the recipient before anything is sent. "Take me to bill the client for this trip" opens the Bill Client screen in ExpenseBot — it does not create or send an invoice on its own; you decide what happens there.
What if I add more trip receipts after the report is made?
A report is a snapshot of the expenses it was built from, so later expenses are not added to it retroactively. Add the new receipts and create a fresh report for the trip. ExpenseBot will tell you if a report already covers some of the expenses you are about to group.
Do I need to forward my travel receipts?
No. Flights, hotels, rideshares and restaurant confirmations already arrive in your inbox as email, and the overnight Gmail scan reads them there — vendor, date, tax and total — and writes each one to a Google Sheet in your own Drive. Anything paid in cash you can photograph.
More answers on the ExpenseBot FAQ.
Your next trip can report itself
Connect Gmail once. The receipts land as they arrive, and the report is one sentence away when you get home. 60 days free, no credit card.