Offset Home Loan Management

[WingnutR32 (Sam)]

Hi IIS members,

Does anyone have a good excel spreadsheet or something that they use to keep track of a 100% offset account?

Thinking in terms of a way that I can punch in figures of expenses throughout the day/weeks and see how it is affecting my total home loan account etc.

Cheers
Sam

[Barrykgerdes]

I have used spread sheets to do similar tasks for 30 years now. The one I like best is Symphony from the old DOS days however it does not run on a 64bit platform. I have converted it to Excel and Lotus 123 but they are much harder to use.

It is quite easy to develop your own sheet using the columns to enter Dates and details with expenses and incomes to give a running total of your worth.

My sheet takes care of all income and expenses particularly the recurring ones and is projected forward for three years. This gives me a good idea what I can spend on "extras" and stay solvent. It also has columns for credit card expenses and bank A/C states all tied together so that an entry in the main column adjusts all other figures.

I use a credit card tied to my bank for all expenses. This is checked every month against the Statement and then paid in full.

Barry

[WingnutR32 (Sam)]

Thanks Barry,
Awesome information for me to go on.

My bank was just telling me the same thing about using my credit card tied to them for all purchases and reconciling at the end of each month.

Cheers
Sam