This is what I use. Ive just blanked it out. Its currently in its 5th revision (It seems to get more complex every year!)
A recent addition was the 1st of the month breakdown.
Last years revision was the full tax calculations (Which do need updating every financial year.
I colour thursday green as thats my traditional pay day (Im now monthy paid, so it doesnt really count!)
Reference your pay date to the appropriate column in the Wages calc column. Yes, its only monthly paid as thats all I need now, but it wont take long to extrapolate it to weekly. No doubt you will get the idea. You probably wont use the pebnsion, bike and bus pass (As some are tax / ni free etc i forget which!).
Enter your initial bank balance from 31st of march into B2 on April. It then calculates the whole year.
I balance mine with my bank account and put all payments for the year. (Council tax, water rates, gas / elec start of the month) all upcoming bills are enetered for the year, including expected phone bills, food bills, card payments etc. Thats the only way I can budget!
Heres the excel files:
http://www.phillydee.me.uk/ocukfiles/blank.xls
Even though the full wages calc is there, its usually a couple of pennies out. Sometimes there is a rounding error creeps in, which annoys the hell out of me, coz I cant find where it comes from!
No doubt the gurus in here will pick it apart and comment on its lack of elegance, or the fact that the columns arent all the same from sheet to sheet. Guess what? I dont care
