Set your starting balance in cell L8, then customize your categories and planned spending amounts in the ‘Income’ and ‘Expenses’ tables below.
As you enter data in the ‘Transactions’ tab, this sheet will automatically update to show a summary of your spending for the month.
Only edit highlighted cells.
Try not to alter cells that contain a formula.
| Starting balance: | ₹ 40,000.00 | |
Monthly Budget
START BALANCE END BALANCE ₹ 40,000.00 #VALUE!
| Increase in total savings | ||
₹ – | ||
| Saved this month |
Expenses | ||||
| Planned | ######### | |||
| Actual | #VALUE! | |||
Expenses
Planned
Actual
Diff
Total
Food
Gifts Health/Medical
Home
Transportation
Personal
Pets
uti;ities
Travels
Debt
Other
Custom Category 1
Custom Category 2
Custom Category 4
₹ 26.000.00
₹ 3.000.00
₹
₹
₹3.000.00
₹
₹
₹
₹10.000.00
₹3.000.00
₹4.000.00
₹3.000.00
#value
₹3.000.00
#value
₹3.000.00
#value
₹6.000.00
#value
₹10.000.00
₹3.000.00
₹4.000.00
₹3.000.00
#value
#value
₹
#value
₹
#value
–6.000.00
#value
——
——
#value
Income | |
| Planned | ₹ 40,000.00 |
| Actual | #VALUE! |
Income
Planned
Actual
Diff
Total
Savings
Paycheck
Bonus
Interest
Custom
Other category
₹40.000.00
₹ 40.000.00
₹
₹
₹
₹
₹
#value
₹ 8.000.00
#value
#value
#value
#value
#value
₹ -32.000.00
₹
#value
#value
#value
#value