Family Budget Plan

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 6

Instructions

You may move from worksheet to worksheet by clicking on the dark blue buttons
located at the top of each worksheet or the blue tabs at the bottom of this workbook.
Enter data in only the white cells with gray borders:
Use the drop down boxes
to chart different time periods (Current Month, Prior Month, Yearly, Jan, Feb, etc.)
Quick Budget
Create a quick and easy budget by filling out the white cells on the "Quick Budget" sheet. Enter the "Frequency" by using the drop down menu
provided in each cell. The Monthly/Yearly figures are calculated for you and compared to your Tracking (actual) figures on the "Comparison" sheet.
Make sure "Use this budget for comparison purposes" is selected. (If this box is not selected, the "Budget By Month" figures will be used for
comparison purposes instead.)
Budget by Month
Use the "Budget By Month" sheet to create a budget with greater detail. Select your first budget month by using the drop down box in
the "Income" section. To unhide future months, click the grey button at the top of the sheet labeled "Click here then Ctrl+Shift+0".
Make sure "Use this budget for comparison purposes" is selected if you are building 'a budget by month. (If this box is not selected,
the "Quick Budget" sheet figures will be used for comparison purposes instead.)
Tracking
Use this sheet to track your actual income and spending. Select your first tracking month by using the drop down box in the "Income" section.
These figures will be compared to your budgeted figures on the "Comparison" page.
Comparison
Use this sheet to monitor how well you are sticking to your budget. Compare different time periods by using the drop down box above the
"Income" section
Daily Spending
We've provided this sheet for those interested in tracking their spending on a daily basis. This simple record goes a long way in helping
you stick to your budget.

Chart:
Frequency
Total Income (net)
Gaji
Gaji
Other
Other
Other

Amount

Dalam 1000 rupiah


Monthly
Monthly
Weekly
Monthly
Monthly

Monthly

Yearly

0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00

0.00

0.00

Transportation
Cicilan Kendaraan
Asuransi
Bahan Bakar
Maintenance
STNK
Parkir
Other
Other

Monthly
Monthly
Weekly
Quarterly
Yearly
Monthly
Monthly
Monthly

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Home
Belanja Bulanan
Sewa / Cicilan Rumah
Perbaikan
Insurance
Furniture
Perlengkapan Rumah
Belanja Mingguan
Other
Kiriman Orang Tua
Iuran Kebersihan

Monthly
Monthly
Monthly
Monthly
Yearly
Monthly
Weekly
Semi-Annually
Monthly
Monthly

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Utilities
Phone - Home
Phone - Cell
Indovision
Gas
PAM / PDAM
Listrik
Internet
Pembantu Rumah Tangga
Other

Monthly
Monthly
Monthly
Monthly
Monthly
Monthly
Monthly
Monthly
Monthly

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Kesehatan
Gigi
Medical
Obat obatan / Vitamin
Kacamata
Life Insurance
Other
Other

Monthly
Monthly
Monthly
Semi-Annually
Monthly
Monthly
Monthly

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Entertainment
Seva Film
Makan di luar
Events
Subscriptions
Bioskop
Music
Hobbies
Travel/ Vacation
Other
Other

Monthly
Monthly
Monthly
Monthly
Monthly
Monthly
Weekly
Yearly
Monthly
Monthly

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Miscellaneous
Laundry / Dry Cleaning
Pakaian Baru
Sumbangan
Rekreasi
Uang Sekolah
Kursus / Les
Uang saku anak
Gifts
Credit Card
Other
Other
Other

Monthly
Semi-Annually
Monthly
Monthly
Monthly
Monthly
Weekly
Monthly
Monthly
Monthly
Monthly
Monthly

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0
0

$0

$0

$0

$0

$0

Expense

Transportati
on
Kesehatan

$0Income
$1
$1

Balance
$1

$1

$1

Home

Utilities

Entertainme
nt

Miscellaneo
us

Chart:
6

Dec

Jan

Feb

Mar

Apr

0 Months
Mar to Date

Total Income (net)


Gaji
Gaji
Other
Other
Other

0.00

0.00

0.00

0.00

0.00

0.00
0.00
0.00
0.00
0.00
0.00

#REF!

#REF!

#REF!

#REF!

1
0.00

0.00

0.00

0.00

0.00

0.00

#REF!

Transportation
Cicilan Kendaraan
Asuransi
Bahan Bakar
Maintenance
STNK
Parkir
Other
Other

0.00

Home
Belanja Bulanan
Sewa / Cicilan Rumah
Perbaikan
Insurance
Furniture
Perlengkapan Rumah
Belanja Mingguan
Other
Kiriman Orang Tua
Iuran Kebersihan

0.00

Utilities
Phone - Home
Phone - Cell
Indovision
Gas
PAM / PDAM
Listrik
Internet
Pembantu Rumah Tangga
Other

0.00

Health
Gigi
Medical
Obat obatan / Vitamin
Kacamata
Life Insurance
Other
Other

0.00

Entertainment
Seva Film
Makan di luar
Events
Subscriptions
Bioskop
Music
Hobbies
Travel/ Vacation
Other
Other

0.00

Miscellaneous
Laundry / Dry Cleaning
Pakaian Baru
Sumbangan
Rekreasi
Uang Sekolah
Kursus / Les
Uang saku anak
Gifts
Credit Card
Other
Other
Other

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

#REF!

#REF!

#REF!

0 Income
1

Expense

#REF!

Balance
1
1

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

Transportatio
n
Health

#REF!

#REF!

Home

Utilities

Entertainment

Miscellaneous

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

1
1
1
1
1
0
0
0
0
0
0

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

Expense
Income

Dec
#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

Jan

Feb

Mar

Apr

Expense

Chart:
Mar

Apr
0.00

May
0.00

Jun
0.00

Mar to Date

Total Income (net)


Gaji
Gaji
Other
Other
Other

0.00

0.00
0.00
0.00
0.00
0.00
0.00

Total Spending:

0.00

0.00

0.00

0.00

0.00

Transportation
Cicilan Kendaraan
Asuransi
Bahan Bakar
Maintenance
STNK
Parkir
Other
Other

0.00

0.00

0.00

0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Home
Belanja Bulanan
Sewa / Cicilan Rumah
Perbaikan
Insurance
Furniture
Perlengkapan Rumah
Belanja Mingguan
Other
Kiriman Orang Tua
Iuran Kebersihan

0.00

Utilities
Phone - Home
Phone - Cell
Indovision
Gas
PAM / PDAM
Listrik
Internet
Pembantu Rumah Tangga
Other

0.00

0.00

0.00

0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Kesehatan
Gigi
Medical
Obat obatan / Vitamin
Kacamata
Life Insurance
Other
Other

0.00

0.00

0.00

0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Entertainment
Seva Film
Makan di luar
Events
Subscriptions
Bioskop
Music
Hobbies
Travel/ Vacation
Other
Other

0.00

0.00

0.00

0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Miscellaneous
Laundry / Dry Cleaning
Pakaian Baru
Sumbangan
Rekreasi
Uang Sekolah
Kursus / Les
Uang saku anak
Gifts
Credit Card
Other
Other
Other

0.00

0.00

0.00

0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0
0

0.00

0.00

0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Expense

0 Income
1

1
1
1
1
1
0
0
0
0
0
0

Balance
1

Expense
Income

Mar

Apr

May

Jun

Income
Expense

Compare

Budget
Total Income (net)
Gaji
Gaji
Other
Other
Other

October

to Budget

Oct Actual Vs Budget


0
0
0
0
0
0

0
0.00
0.00
0.00
0.00
0.00

Budget

0
0

Total Spending:

Transportation
Cicilan Kendaraan
Asuransi
Bahan Bakar
Maintenance
STNK
Parkir
Other
Other

0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Home
Belanja Bulanan
Sewa / Cicilan Rumah
Perbaikan
Insurance
Furniture
Perlengkapan Rumah
Belanja Mingguan
Other
Kiriman Orang Tua
Iuran Kebersihan

0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Utilities
Phone - Home
Phone - Cell
Indovision
Gas
PAM / PDAM
Listrik
Internet
Pembantu Rumah Tangga
Other

0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Kesehatan
Gigi
Medical
Obat obatan / Vitamin
Kacamata
Life Insurance
Other
Other

0
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Entertainment
Seva Film
Makan di luar
Events
Subscriptions
Bioskop
Music
Hobbies
Travel/ Vacation
Other
Other

0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Miscellaneous
Laundry / Dry Cleaning
Pakaian Baru
Sumbangan
Rekreasi
Uang Sekolah
Kursus / Les
Uang saku anak
Gifts
Credit Card
Other
Other
Other

0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0
0.00
0.00
0.00
0.00
0.00
0.00
0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Tracking

0
0

Expense

Income
1

Balance
(Savings)
1
1

1
1
1
1
1

Transportat
Home
Utilities
ion
0
0
0
0
0
0
0
0
0
Kesehatan
Entertainm
Miscellaneo
ent
us
Budget
Tracking

1st

2nd

3rd

4th

5th

6th

7th

8th

9th

10th

11th

12th

13th

14th

15th

16th

17th

18th

19th

20th

21st

22nd

23rd

24th

25th

26th

27th

28th

29th

30th

31st

Month

Total Day's Spending:

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Transportation
Cicilan Kendaraan
Asuransi
Bahan Bakar
Maintenance
STNK
Parkir
Other
Other

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Home
Belanja Bulanan
Sewa / Cicilan Rumah
Perbaikan
Insurance
Furniture
Perlengkapan Rumah
Belanja Mingguan
Other
Kiriman Orang Tua
Iuran Kebersihan

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Utilities
Phone - Home
Phone - Cell
Indovision
Gas
PAM / PDAM
Listrik
Internet
Pembantu Rumah Tangga
Other

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Kesehatan
Gigi
Medical
Obat obatan / Vitamin
Kacamata
Life Insurance
Other
Other

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Entertainment
Seva Film
Makan di luar
Events
Subscriptions
Bioskop
Music
Hobbies
Travel/ Vacation
Other
Other

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Miscellaneous
Laundry / Dry Cleaning
Pakaian Baru
Sumbangan
Rekreasi
Uang Sekolah
Kursus / Les
Uang saku anak
Gifts
Credit Card
Other
Other
Other

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

You might also like