About The Template

Use this template to maintain monthly and annual budget.

Enter Revenues and Expenses in respective tables to calculate Cash shortage or surplus for each month and year.

Sparklines are auto updated in each table.

Note:

Additional instructions have been provided in column A in PERSONAL BUDGET worksheet. This text has been
intentionally hidden. To remove text, select column A, then select DELETE. To unhide text, select column A, then
change font color.

To learn more about tables, press SHIFT and then F10 within a table, select the TABLE option, and then select
ALTERNATIVE TEXT.
et are in
cells in
this
Title of
column.
this
Arrow
workshe
down to
et
getis in
cell at
started.
right.
Enter
year PERSONAL BUDGET
Enterin
Labels
cell Q2.
details
are
Next in
in
cells C4
instructi
Income
through
on is in PERSONAL EXPENSES JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
table
P4.
cell A4.
starting
in cell UYUN January February March April May June July August September October November December
C5.
Next
CELCOM 110.00
instructi
on is in
cell MARA 100.00
A11.
CUCKOO 170.00

MENGAJI 100.00

SAVINGS 200.00

DUIT KUT 120.00

ZAKAT 50.00

850.00

ASYRAFF

UMOBILE 100.00

UNIFI 62.86

CUCKOO 60.00
C

COWAY KATIL 378.00

YURAN ADRA 220.00

ZAKAT 50.00

KOBANAS (ANN) 84.00

SYAZA (BANK RAKYAT) 1,070.00

MBSB 1,000.00

MAMA & ABAH 200.00

HUTANG MAMA (TNB 2100, PINJAM 2500 4,600.00 4,200.00

Enter
Home
expense
s in
table Total 8,674.86 4,200.00 - - - - - - - - - -
starting
inLabels
cell
C12.
are in
Next
cells
instructi EXPENSES JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
C11
on is in
through
cell
P11. HOME January February March April May June July August September October November December
A20.

TNB - TTS 1,052.23 - - - - - - - - - - -

UNIFI (1045830187) 126.15 - - - - - - - - - - -

SADA -

COWAY 189.00

KERETA KCW 6269 450.00

KERETA PNP 6269 700.00 700.00 700.00 700.00 700.00 700.00 700.00

LOAN RUMAH -

ZAKAT 50.00

Page 2 of 9
 Total 2,567.38 700.00 700.00 700.00 700.00 700.00 700.00 - - - - -

CREDITOR

TATI 6,000.00

KAK LONG -
Enter
Daily
ABG ZAKI -
expense
s in
table
starting
in cell
C20.
Next
instructi Total 6,000.00 - - - - - - - - - - -
on is in
cell
A29.

SUPPLIER JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC

KELUBI INDAH -

ASYIR UTARA - MACHINE -

LW VON HARDWARE JENIANG -

TRACTOR -

Enter
Transpo
rtation
expense
s in Total - - - - - - - - - - - -
table
starting
in cell
C29.
Next
instructi
on is in
cell
A38.

Page 3 of 9
 2,024.00
2,023.00

YEAR

Year Sparkline

110.00

100.00

170.00

100.00

200.00

120.00

50.00

850.00

100.00

62.86

60.00

378.00

220.00

50.00

84.00

1,070.00

1,000.00

200.00

8,800.00

13,724.86

YEAR

Year Sparkline

1,052.23

126.15

189.00

450.00

4,900.00

50.00

Page 4 of 9
 -

6,767.38 -

6,000.00

6,000.00

YEAR Column1

Page 5 of 9
et are in
cells in
this
Title of
column.
this
Arrow
workshe
down to
et
getis in
cell at
started.
right.
Enter
year PERSONAL BUDGET
Enterin
Labels
cell Q2.
details
are
Next in
in
cells C4
instructi
Income
through
on is in PERSONAL EXPENSES JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
table
P4.
cell A4.
starting
in cell UYUN January February March April May June July August September October November December
C5.
Next
CELCOM 110.00 - - - - - - - - - - -
instructi
on is in
cell MARA BALANCE RM2,580 200.00 - - - - - - - - - - -
A11.
CUCKOO 170.00 - - - - - - - - - - -

MENGAJI 100.00 - - - - - - - - - - -

SAVINGS 200.00 - - - - - - - - - - -

DUIT KUT 120.00 - - - - - - - - - - -

ZAKAT 50.00 - - - - - - - - - - -

900.00 - - - - - - - - - - -

Total 1,000.00 - - - - - - - - - - -

ASYRAFF - - - - - - - - - - -

UNIFI - - - - - - - - - - -

COWAY - - - - - - - - - - -

YURAN ADRA - - - - - - - - - - -

ZAKAT 50.00 - - - - - - - - - - -

- - - - - - - - - - -

- - - - - - - - - - -

- - - - - - - - - - -
Enter
Home
- - - - - - - - - - -
expense
s in
table Total 1,000.00 - - - - - - - - - - -
starting
inLabels
cell
C12.
are in
Next
cells
instructi EXPENSES JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
C11
on is in
through
cell
P11. HOME January February March April May June July August September October November December
A20.

TNB - TTS 1,052.23 - - - - - - - - - - -

UNIFI 126.15 - - - - - - - - - - -

SADA -

COWAY 189.00

KERETA KCW 6269 450.00

KERETA PNP 6269 700.00 700.00 700.00 700.00 700.00 700.00 700.00

LOAN RUMAH -

ZAKAT 50.00

Total 2,567.38 700.00 700.00 700.00 700.00 700.00 700.00 - - - - -

CREDITOR

TATI 6,000.00

Page 6 of 9
 KAK LONG -
Enter
Daily
ABG ZAKI -
expense
s in
table
starting
in cell
C20.
Next
instructi Total 6,000.00 - - - - - - - - - - -
on is in
cell
A29.

SUPPLIER JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC

KELUBI INDAH -

ASYIR UTARA - MACHINE -

LW VON HARDWARE JENIANG -

TRACTOR -

Enter
Transpo
rtation
expense
s in Total - - - - - - - - - - - -
table
starting
in cell
C29.
Next
instructi
on is in
cell
A38.

Page 7 of 9
 2,024.00
2,023.00

YEAR

Year Sparkline

1,900.00

YEAR

Year Sparkline

1,052.23

126.15

189.00

450.00

4,900.00

50.00

6,767.38 -

6,000.00

Page 8 of 9
 -

6,000.00

YEAR Column1

Page 9 of 9