0% found this document useful (0 votes)
17 views6 pages

Personal Budget

The document is a budget dashboard for May, detailing income, expenses, bills, and savings. It shows a total income of 4,750,000, expenses of 1,600,000, and savings of 600,000, with various bills listed and their due dates. Additionally, it includes ratios for salary to income, saving to income, and bills to income, providing a comprehensive overview of financial management for the month.

Uploaded by

YARIS130
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
17 views6 pages

Personal Budget

The document is a budget dashboard for May, detailing income, expenses, bills, and savings. It shows a total income of 4,750,000, expenses of 1,600,000, and savings of 600,000, with various bills listed and their due dates. Additionally, it includes ratios for salary to income, saving to income, and bills to income, providing a comprehensive overview of financial management for the month.

Uploaded by

YARIS130
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

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

You might also like