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.
w
of this
down
works
to
heet
get
is in
start
cell at
Label
ed.
right.
s
Enterare
in
year
detail
cells
sinincell
Enter Fjárhagsáætlun 2022
2024

Q2.
Incom
C4
Hom
eNext
throu
e
instru
table
gh
expe
ction
starti
P4.
nses
Tekjur
is inin
ng
in Innkoma JANÚAR FEBRÚAR MARS APRÍL MAÍ JÚNÍ JÚLÍ ÁGÚST SEPTEMBER OKTÓBER NÓVEMBER DESEMBER ÁRIÐ Column1
cell
table
A4.
C5. Laun Atli 450,000 351,378 578,860 437,714 473,515 451,588 489,100 288,644 837,514 533,506 559,880 540,164 5,991,863
starti
Next
ng in Laun Sara 320,000 266,000 266,000 266,000 266,000 266,000 266,000 266,000 266,000 266,000 266,600 266,600 3,247,200
instru
Label
cell
ction Slökkvilið Grindavíkur 74,387 74,387
s are
is in
C12. Auka innkoma 450,000 105,000 555,000
in
cell
Next
cells
A11.
instr Samtals 770,000 617,378 844,860 703,714 739,515 717,588 755,100 554,644 1,103,514 1,249,506 826,480 986,151 9,868,450
Enter
C11
uctio
Daily
throu
n is
expe
gh
in
nses
P11. ÚTGJÖLD
cell
in
A20. Heimilið JANÚAR FEBRÚAR MARS APRÍL MAÍ JÚNÍ JÚLÍ ÁGÚST SEPTEMBER OKTÓBER NÓVEMBER DESEMBER ÁRIÐ Column1
table
starti Íbúðalán stóra 750 750 750 2,250
ng in Íbúðalán litla 0
cell Viðhald 75 75
C20.
Next Rafmagn og neysluvatn 35 35 35 105
instr Húsfélagsgjöld (hiti) 165 165 165 495
uctio
Total 950 950 1,025 0 0 0 0 0 0 0 0 0 2,925
n is
in
cell
A29. DAILY LIVING January February March April May June July August September October November December Year Sparkline
Matar innkaup 191 152 145 488
Leikskólagjöld 200 200 200 600
Bensín 20 20 40
Enter 55 56 111
Trans Housecleaning service 25 17 7 49
portat
Enter
ion Dog walker 10 5 7 22
Enter
expen
tain
ses in Total 501 374 435 0 0 0 0 0 0 0 0 0 1,310
ment
table
expe
starti
nses
ng in REIKNINGAR January February March April May June July August September October November December Year Sparkline
cell
in
Tryggingar 195 125 171 491
C29.
table
Next
starti Kreditkort 165 165 165 495
instru
ng in HS Veitu 0
ction
cell
is in Fasteignagjöld 10 10
C38.
Enter
cell Parking 10 40 20 70
Next
Healt
A38.
instr
h Public transportation 20 40 30 90
uctio
expe Total 400 370 386 0 0 0 0 0 0 0 0 0 1,156
n is
nses
in
in
cell
table
A45. ENTERTAINMENT January February March April May June July August September October November December Year Sparkline
starti
ng in Cable TV 85 85 85 255
cell Video/DVD rentals 7 8 9 24
C45.
Next Movies/plays 9 5 9 23
instr Concerts/clubs 5 5 7 17
uctio Total 106 103 110 0 0 0 0 0 0 0 0 0 319
n is
Enter
in
Vacat
cell
ions
A55.
expe HEALTH January February March April May June July August September October November December Year Sparkline
nses Health club dues 50 50 50 150
in
Insurance 225 225 225 675
table
starti Prescriptions 100 100 100 300
ng in Over-the-counter drugs 6 2 9 17
cell Co-payments/out-of-pocket 20 41 61
C55.
Next Veterinarians/pet medicines 4 25 29
instr Life insurance 55 55 55 165
uctio Total 460 432 505 0 0 0 0 0 0 0 0 0 1,397
n is
in
cell
A64. VACATIONS January February March April May June July August September October November December Year Sparkline
Plane fare 485 485

Page 2 of 3
n
expe
nses
in
table
starti Accommodations 245 245
Enter
ng
expe in Food 95 95
cell
nses Souvenirs 0
C64.
in
Next Pet boarding 0
Dues
instr
and Rental car 85 85
uctio
Subs Total 0 910 0 0 0 0 0 0 0 0 0 0 910
n is
cripti
in
on
cell
table
A71. RECREATION January February March April May June July August September October November December Year Sparkline
starti
ng in Gym fees 0
cell Sports equipment 0
C71.
Next Team dues 0
instr Toys/child gear 39 33 40 112
uctio Total 39 33 40 0 0 0 0 0 0 0 0 0 112
n is
Enter
in
Perso
cell
nal
A81.
expe DUES/SUBSCRIPTION January February March April May June July August September October November December Year Sparkline
nses Magazines 0
in
Newspapers 0
table
starti Internet connection 0
ng in Public radio 0
cell Public television 0
C81.
Next Religious organizations 29 18 17 64
Enter Charity 0
instr
Total
Finan
uctio Total 29 18 17 0 0 0 0 0 0 0 0 0 64
s
cialare
n is
auto
Oblig
in
calcul
ation
cell
ated
s in PERSONAL January February March April May June July August September October November December Year Sparkline
A89.
in
table
table
starti Clothing 29 29
starti
ng in Gifts 35 35
ng
cellin Salon/barber 25 25 25 75
Enter
cell
C89.
Misce Books 0
C105
Next
llane Music (CDs, etc.) 0
.instr
ous
Total
uctio
Paym Total 25 60 54 0 0 0 0 0 0 0 0 0 139
expe
n is
ents
nses
in
in
and
cell
table FINANCIAL OBLIGATIONS January February March April May June July August September October November December Year Sparkline
Cash
A97.
starti
short Long-term savings 25 25 25 75
ng in
age
cell Retirement (401k, Roth IRA) 45 45 45 135
or
C97. Credit card payments 75 75 75 225
surpl
Next
us Income tax (additional) 0
instr
are Other obligations 32 34 1 67
uctio
auto
n is Total 177 179 146 0 0 0 0 0 0 0 0 0 502
calcul
in
ated
cell
for
A105
each MISC PAYMENTS January February March April May June July August September October November December Year Sparkline
.
mont
h Other 0
and Other 0
entir Other 0
e
year, Other 0
and Other 0
spark Total 0 0 0 0 0 0 0 0 0 0 0 0 0
lines
are
upda
ted. SAMTALS JANÚAR FEBRÚAR MARS APRÍL MAÍ JÚNÍ JÚLÍ ÁGÚST SEPTEMBER OKTÓBER NÓVEMBER DESEMBER ÁR SPARKLINE
Samtals útgjöld 2,687 3,429 2,718 0 0 0 0 0 0 0 0 0 8,834
Peningur plús eða mínus 767,313 613,949 842,142 703,714 739,515 717,588 755,100 554,644 1,103,514 1,249,506 826,480 986,151 9,859,616

Page 3 of 3