no worries John. let me know if you want any additional features or find a bug.
I hadn't tried to create running arrears before, so was interested in giving it a go.
The arrears column will have an amount and a red color when arrears occur. Current arrears only show when there are arrears on today's date. A green color under arrears indicates additional rent has been paid in advance.
The 'start saturday' cells will change to a blue color if older than today's date. This helps keep you oriented on where rent should be paid up to.
It wouldn't be too hard to do a cash book for all properties that includes maintenance etc.
However, if you wanted to apportion non capital maintenance expenses to several properties it can get tricky. Commercial software makes you split the entry manually, which is a pain. Same for capital expenditures
GST requires a little extra work, but I presume you aren't registered.
An asset register would be simple.
Reports like a monthly cash flow and cash flow projection aren't too hard.
A maintenance history and future schedule might be a good thing.
A depreciation schedule would be beyond me at this point. It gets complicated with Division 40 and 43.
I've never looked at the commercial property management software, so am not sure what other features are handy.
Here's some instructions.
I hadn't tried to create running arrears before, so was interested in giving it a go.
The arrears column will have an amount and a red color when arrears occur. Current arrears only show when there are arrears on today's date. A green color under arrears indicates additional rent has been paid in advance.
The 'start saturday' cells will change to a blue color if older than today's date. This helps keep you oriented on where rent should be paid up to.
It wouldn't be too hard to do a cash book for all properties that includes maintenance etc.
However, if you wanted to apportion non capital maintenance expenses to several properties it can get tricky. Commercial software makes you split the entry manually, which is a pain. Same for capital expenditures
GST requires a little extra work, but I presume you aren't registered.
An asset register would be simple.
Reports like a monthly cash flow and cash flow projection aren't too hard.
A maintenance history and future schedule might be a good thing.
A depreciation schedule would be beyond me at this point. It gets complicated with Division 40 and 43.
I've never looked at the commercial property management software, so am not sure what other features are handy.
Here's some instructions.
