Health and family

Flexi-benefit plan: tracking claims against your annual limit

A claim sheet for a flexi-benefit plan: log each bill against the annual limit in your salary structure and see how much of the component is still unused.

Editorial illustration for Flexi-benefit plan: tracking claims against your annual limit

A flexible-benefit plan lets you claim certain bills against a component of your salary, up to an annual limit shown in your salary structure. To track it, set up a sheet with the limit at the top, one row per bill, a running total of what you have claimed, and a balance that falls as each claim is approved.

What do you need from your salary structure first?

Open your latest salary letter or the payroll portal and note, for each flexible component, three things: the annual limit, the period it covers (often April to March), and what kinds of bills it accepts. Copy the wording exactly. Whether a component is paid out in your monthly salary if unclaimed, or lost, depends on your employer's policy, so find that sentence and write it in the sheet too. Tax treatment is a matter for your payroll team or CA; this sheet is only for records.

How should the sheet be laid out?

Cell or columnContent
B1Annual limit, for example 24000
A columnBill date
B columnBill description
C columnAmount on the bill
D columnAmount claimed
E columnStatus: Not submitted, Submitted, Approved, Rejected
B2Total approved: =SUMIFS($D$5:$D$200, $E$5:$E$200, "Approved")
B3Balance: =B1-B2

These formulas work the same in Excel and Google Sheets. SUMIFS takes the sum range first, then each criteria range and its condition. If you want to know what is still in the pipeline, add a Submitted total using the same formula with "Submitted" as the condition, and compare it with the balance.

What does a worked example look like?

Take an imaginary limit of ₹24,000. You claim ₹6,000 in May and ₹4,500 in August, both approved. Your approved total is 6,000 + 4,500 = ₹10,500 and the balance is 24,000 - 10,500 = ₹13,500. A further bill of ₹3,000 is submitted but not yet approved, so if it is accepted the balance will be 13,500 - 3,000 = ₹10,500. Seeing both numbers tells you whether you still need to find bills before the cut-off.

What happens when a bill is more than the limit?

If a bill exceeds what remains, you can usually claim only up to the balance, and the rest is your own cost. Record the full bill in column C and the smaller figure in column D, so the difference is visible. Check with HR whether a partial claim is allowed or whether a bill must be claimed whole.

  • Keep the original bill number, date and name of the provider in the description
  • Do not split one bill into several claims to fit the limit; ask HR how it should be submitted
  • Note the submission deadline for each quarter or year, as published by your employer
  • Mark the row Rejected, with the reason, if a claim comes back

One more column is worth adding: the date the claim was approved or paid out. Flexible-benefit claims are often settled with the monthly payroll, so a bill submitted on the 28th may only show up a month later. If you compare your sheet with the portal on a day when a claim is Submitted in your sheet but not yet visible there, the missing date column tells you it is a timing gap and not a lost claim.

When does a sheet stop being enough?

A sheet is fine for one limit and a dozen bills. If you would rather have your payments arrive from uploaded bank or card statements, SpendixAI can import the statement, let you review the rows and keep receipts with each transaction. The limit and the claim status would still be tracked in the sheet.

Before the cut-off date

  1. Compare your sheet's balance with the portal
  2. Gather unsubmitted bills and check their dates fall inside the plan year
  3. Submit early enough for the payroll cycle
  4. Save the approval message beside each row
SPENDIXAI JOURNAL

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

Explore your reports