Business

Reimbursement claim list from a bank statement: a forum answer

A reader asks how to turn a bank statement into a reimbursement claim list. Numbered steps, a worked trip, what finance teams check and where it falls short.

Editorial illustration for Reimbursement claim list from a bank statement: a forum answer

The question: my company wants a list of business expenses for reimbursement and all I have is a bank statement, so how do I build it? Mark the business lines, add the purpose and the proof for each, total them, and give finance exactly the columns they ask for. The statement proves money left your account. It does not prove what it was for, and that gap is what the list has to fill.

Step by step

  1. Find out first what your finance team wants: a form, a sheet, or a PDF, and whether they need original bills or accept photos. Build to that, not to your own taste.
  2. Download the statement for the period of the trip or the month, using your bank's official download.
  3. Copy only the debit lines into a sheet. Add columns: date, vendor, business purpose, amount, proof (bill, ticket, screenshot) and a status column.
  4. Mark each line Business, Personal or Unsure. Do the Unsure ones last, once you have checked bills.
  5. Delete the Personal lines from the claim sheet, or keep them on a second tab so you can show you separated them.
  6. Match each Business line with a bill. A line with no proof goes in a separate section, since the policy may refuse it.
  7. Total the claim and check it against the sum of the individual lines.

A worked example with made-up amounts

Say a two-day client visit shows a cab at ₹640, a train ticket at ₹1,285, lunch at ₹480, a hotel at ₹3,200 and printing at ₹120. The claim comes to ₹640 + ₹1,285 + ₹480 + ₹3,200 + ₹120 = ₹5,725.

DateVendorPurposeAmount (₹)Proof
Day 1CabAirport to client office640App receipt
Day 1RailwaysReturn ticket1,285Ticket PDF
Day 1RestaurantClient lunch480Bill photo
Day 2HotelOne night3,200Invoice
Day 2Print shopProposal copies120Slip

What if a line looks like a personal expense?

Keep it off the claim. Mixed bills, such as a dinner where you also paid for a friend, should be split on the bill, and only your own business share belongs in the list. If you are unsure, ask the person who approves claims, and write down the answer.

What finance teams usually check

  • Dates fall inside the claim period.
  • Amounts match the bill, not just the statement. A tip or round-off may differ.
  • No expense appears twice, for example once from the card and once from UPI.
  • The purpose is something a stranger could understand.

Where a tool fits

When this repeats every month, SpendixAI can import the statement for review, let you filter the business transactions, keep receipts with their transactions and export the result, with CSV download available for reports. You would still check each line against the bill yourself.

Making the list easy to approve

The approver is usually busy and slightly suspicious, which is reasonable. Make their job short. Put the total at the top, group lines by day, and use the same wording as the policy where you can. A line that says client lunch, two people is quicker to approve than one that says food. If a bill is in a language or format the approver may not read quickly, add a one-line translation in the purpose column.

  • Sort by date, oldest first.
  • Name each proof file after its row number.
  • Keep amounts in rupees with no rounding unless the bill itself is rounded.
  • Send everything as one file or one bundle, not six emails.

Before you submit

  • The total matches the lines.
  • Every row has proof or a note about why not.
  • You kept a copy of what you sent.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports