Download a free Emergency Fund Tracker Sheet Template to easily track and manage your emergency savings. This ready-to-use Excel template helps you record savings contributions, withdrawals, current balance, target amount, and transaction details in a simple and organized format. It is useful for monitoring your emergency fund progress and maintaining a clear record of your savings.
Key Features :
- S.No.
- Date
- Description
- Category
- Source/Account
- Type
- Amount (₹)
- Status
- Balance (₹)
- Notes/Remarks
- Dashboard
- KPI Card
- PIE Chart
Formulas :
Balance (₹)
=IF(F8=”Contribution”,G8,-G8)
Target Fund Current Balance Total Contributions Total Withdrawals Progress
150000 =SUM(I8:I17) =SUMIF(H8:H17,”Contribution”,G8:G17) =SUMIF(H8:H17,”Withdrawal”,G8:G17) =IF(A5=0,0,C5/A5)
Target Fund
=’Emergency Fund Tracker’!A5
Current Balance
=’Emergency Fund Tracker’!C5
Contributions
=’Emergency Fund Tracker’!E5
Withdrawals
=’Emergency Fund Tracker’!G5
