May
Cash Allo
May Savings
Budget Dashboard
600,000.00
Main BreackDown
Name Budget Actual
Start Balance Bills
Income 4,500,000.00 4,750,000.00 2,350,000.
Expenses 1,450,000.00 1,600,000.00 00
Bills 2,350,000.00 2,350,000.00
Savings 600,000.00 600,000.00
Rest 100,000.00 200,000.00
Income
Name Budget Actual
Salary 4,500,000.00 4,500,000.00
Food Card -
Frelance design 250,000.00
Side Income -
Total 4,500,000.00 4,750,000.00
Savings
Name Budget Actual
LIFE 600,000.00 600,000.00
-
-
-
600,000.00 600,000.00
Cash Allocation Left To Spend
Savings
Expenses
600,000.00
1,600,000.
00
200.000,00
Bills
2,350,000.
00
Budget Vs Actual
Savings
Bills
Expenses
Income
- 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000
Bills
Name Due Date Budget Actual
Rent 6 750,000.00 750,000.00
Electricity 5 200,000.00 200,000.00
Water 5 300,000.00 300,000.00
Internet 5 250,000.00 250,000.00
Gas 15 200,000.00 200,000.00
Gym 10 150,000.00 150,000.00
paylater 1 500,000.00 500,000.00
Rest 2,350,000.00 2,350,000.00
Left To Spend Budgeted Saving Rate
13%
Ratios & Measurments
Ratio Name Budget Actual
Salary to Income 100% 95%
Saving to Income 13% 13%
Food to Income 11% 20%
Bills To Income 52% 49%
00 5,000,000
Expenses
Paid/Not Paid Name Budget Actual
Paid Food 500,000.00 950,000.00
Paid Healthcare 300,000.00 -
Paid Personal Spending 650,000.00 650,000.00
Paid -
Paid -
Paid -
Paid Rest 1,450,000.00 1,600,000.00
Actual Cash Flow
Date Main Category Amount
1-May-24 Income Salary 4,500,000.00
2-May-24 Expenses Food 50,000.00
3-May-24 Bills Electricity 200,000.00
4-May-24 Bills Gym 150,000.00
5-May-24 Expenses Food 50,000.00
6-May-24 Bills Internet 250,000.00
7-May-24 Expenses Personal Spending 300,000.00
8-May-24 Bills Gas 200,000.00
9-May-24 Expenses Food 50,000.00
10-May-24 Expenses Food 50,000.00
11-May-24 Expenses Food 50,000.00
12-May-24 Bills Water 300,000.00
13-May-24 Expenses Personal Spending 350,000.00
14-May-24 Expenses Food 50,000.00
15-May-24 Expenses Food 50,000.00
16-May-24 Bills Rent 750,000.00
17-May-24 Expenses Food 50,000.00
18-May-24 Bills paylater 500,000.00
19-May-24 Expenses Food 50,000.00
20-May-24 Income Frelance design 250,000.00
21-May-24 Expenses Food 50,000.00
22-May-24 Expenses Food 50,000.00
23-May-24 Expenses Food 50,000.00
24-May-24 Expenses Food 50,000.00
25-May-24 Expenses Food 50,000.00
26-May-24 Expenses Food 50,000.00
27-May-24 Expenses Food 50,000.00
28-May-24 Expenses Food 50,000.00
29-May-24 Expenses Food 50,000.00
30-May-24 Expenses Food 50,000.00
31-May-24 Savings LIFE 600,000.00
Comment
Read this
Don't edit the tabe of Main BreackDown and the ratios
Only Edit Columns with the name of budget
enter your data and make sure no data frommthe previos month
the name of the month is changing automatic
add the due date in the bills table