After a business trip you may hold forty receipts, a card statement and a phone full of UPI confirmations. Do not start with the receipts. Start with the statement, list every payment it shows for the trip dates, and then attach each receipt to its line. Whatever is left without a line is cash, and that is what you reconstruct by hand.
Why the statement should lead
A pile of receipts is in the order you collected them. A statement is in date order, complete, and not easily lost. When you work from the statement, you cannot forget a payment; when you work from the pile, you can. For a gig worker or freelancer the report may go to a client who is reimbursing travel, or to your own CA, so completeness matters more than speed.
The six-step routine
- Choose the trip window: first day of travel to last day of return, plus one day for late-posting card entries.
- Pull the statement for each account and card you used. Download as PDF, CSV or Excel if your bank offers it; do not share your net-banking login with anyone to do this.
- Mark each line that belongs to the trip.
- Sort the paper and phone receipts into the same date order.
- Match each receipt to a marked line. Write the match in a column: statement line number, receipt present yes or no.
- List what is left over: cash spends and anything with no receipt. These are the lines you explain in a sentence each.
A worked example with made-up figures
Say a three-day client trip had these items. Amounts are illustrative only.
| Date | Item | Paid by | Amount | Receipt? |
|---|---|---|---|---|
| Day 1 | Train to client city | Card | ₹1,150 | Yes |
| Day 1 | Cab from station | UPI | ₹420 | Screenshot |
| Day 2 | Lunch with client | Card | ₹1,380 | Yes |
| Day 2 | Hotel, two nights | Card | ₹6,400 | Yes |
| Day 3 | Auto and parking | Cash | ₹260 | No |
| Day 3 | Return flight | Card | ₹4,950 | Yes |
The total is 1,150 plus 420 plus 1,380 plus 6,400 plus 260 plus 4,950, which is ₹14,560. Of this, ₹260 is cash with no receipt and should be listed as such in a line of its own, with a short note on what it was for.
How do I handle receipts with no statement line?
Cash is the usual cause. Write a line for it in the report, mark it as cash, and keep a photo of any receipt you did get. Do not backdate or invent a receipt to make the page look tidy; a plain honest line is more useful to a client or a CA than a perfect-looking one that cannot be checked.
Where an app helps and where a sheet does
A sheet with the columns above is enough for one trip. When trips happen monthly, repeating it by hand gets slow. SpendixAI lets you upload a statement as PDF, CSV or Excel, review the rows before saving, keep a receipt with its transaction, and use the Report builder to filter and group by category or date, then download a CSV. It is not a reimbursement or approvals tool, so if a client needs a formal claim form you will still fill that yourself.
Before you send the report
- Does the total match the sum of the lines?
- Is every line either matched to a receipt or listed with a reason?
- Are the dates inside the trip window?
- Are personal items such as a gift or a family dinner removed?
- Have you kept the original statement and receipts for later questions?
Useful ideas start with a clearer picture of your own spending.
Explore your reports


