What is actually in the file
This is the sheet structure, not a mock-up of one. The sample below belongs to a household
paid $2,160 a fortnight, and shows how each row is laid out and how the totals are put
together.
Cells shaded are live formulas rather than
typed numbers. The Per month cell on row 7 holds this, which is why editing an amount or a
frequency inside the file still leaves you with the right total:
=IF(D7="Weekly",C7*52/12,IF(D7="Fortnightly",C7*26/12,IF(D7="Monthly",C7,IF(D7="Quarterly",C7/3,IF(D7="Annual",C7/12,0)))))
Debts get their own block
Anything you owe is listed separately, with the balance and the rate carried through, so the
sheet still makes sense in six months when you have forgotten what the rate was.
Then everything meets in one summary
The last block points at the totals above it rather than repeating them, so the bottom line
keeps up with any edit you make higher in the sheet.
Regular savings and savings goals get blocks of the same shape when you enter them, and a
goal row carries its target, what you have put aside already and the date you are aiming
for. Sections you leave empty are never written at all, so nobody ends up with a Childcare
heading sitting over an empty range.