i currently have one property that's rented out per room bases (4 rooms) i've created an excel sheet that tracks when rents are due weekly and monthly expenses for that property and an overall overview for that property with some statistics. Now the problem being is im about to buy maybe two more properties which could lead me to having about 15-20 rooms needing tracking over 3 properties. Ive been winging it with excel and it works well although may get a bit cumber when i start scaling up? Should i be considering a move to a proper database and also reasons for? thanks for your help in advance.
I think an MS Access database would be a good next step for you, and would be more scale-able than your Excel solution.
Depends on how ambitious you want get. You need to ask yourself: "Am I a landlord, or a data manager? How do I want to spend my time?"
If it's not practically useful, then it's practically useless.
this is a tricky one the landlord thing is about to become my full time job. i have no idea how to use access so it would be a long learning curve. im thinking its probably going to be best wing it for a as long i can then get someone in to a full blown database