Business

Build a reimbursement claim list from your bank statement

Turn a bank statement into a clean reimbursement claim list: pick the work expenses, add receipts and purpose, total them with a formula and send one neat file.

Editorial illustration for Build a reimbursement claim list from your bank statement

To build a reimbursement claim from a bank statement, copy only the work-related rows into a fresh sheet, add the purpose and the receipt for each one, and total them. Do it within a week or two of the trip or purchase, while you still remember what each charge was for.

Which columns does a claim list need?

  • Date of the expense, as on the receipt.
  • Merchant or vendor name.
  • Purpose in one line: client lunch, airport cab, software for the project.
  • Amount in rupees, and the original currency and amount if it was foreign.
  • How you paid: card, UPI, cash.
  • Receipt reference or file name.
  • Project or client code, if your employer asks for one.
  • Status: claimed, approved, paid.

Your employer's form may ask for different columns. Check the policy first, and follow its order so your claim is easy to approve.

How do you pick the right rows?

  1. Download the statement for the period as PDF, CSV or Excel, from your own bank's usual route.
  2. Mark each row business, personal or unsure. Do not guess on the unsure ones; check with the receipt or your calendar.
  3. Remove anything your policy does not cover, such as personal items bought on the same card.
  4. Split mixed bills. A restaurant bill that includes a personal portion needs only the work share claimed.
  5. Sort by date and make sure no duplicate row is in the list; the same charge can appear as a hold and as a final debit.

A worked example with made-up numbers

Say you travelled for a client meeting and these were the work charges:

DateMerchant typePurposeAmount in rupees
3 MarchCabHome to airport780
3 MarchMealLunch with client1,450
4 MarchHotelOne night4,800
4 MarchCabHotel to client office360
5 MarchCabAirport return820

The total is 780 plus 1,450 plus 4,800 plus 360 plus 820, which is ₹8,210. If you had also spent ₹300 on a personal snack on the same card, it stays out. The claim is ₹8,210, not the card total.

How do you total it with a formula?

Put amounts in column D, a type in column F with the word Business for the claimable rows, and use:

  • =SUMIFS($D$2:$D$200,$F$2:$F$200,"Business") for the claim total
  • =COUNTIFS($F$2:$F$200,"Business",$G$2:$G$200,"") to count claimable rows that still have no receipt, if column G holds the receipt name

Both work in Excel and Google Sheets. The second one is the check people forget: fix the receipt-less rows before the claim leaves your hands.

What if some expenses were in another currency?

Record the original amount and currency, plus the rupee amount that appears on your statement, and claim the rupee figure unless your policy says otherwise. Do not re-convert at a rate you looked up later.

Where can SpendixAI help?

If your statements are already imported into SpendixAI, you can keep a business category, attach receipts to the transactions, filter the business rows in the Report builder and download a CSV, which becomes your claim sheet. You still need to check the rows against your employer's policy.

How long should you wait before claiming?

Many employers set a window for claims, and late claims can be rejected, so find the deadline in your policy and diarise it. A good habit is a fixed weekly slot, say Friday evening, when you move the week's work charges into the sheet and photograph any loose receipts. A claim built in small weekly pieces is far less painful than one built from a month-old statement. If an expense was paid by a colleague or the company card, note that on the row so it is not claimed twice.

Before you submit

  • Total matches the formula and your own addition.
  • Every row has a receipt or a written reason why not.
  • Dates are within the claim window set by your employer.
  • You have kept a copy of the final file.
SPENDIXAI JOURNAL

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

Explore your reports