Accounts Tab, it shows the items that will incur cost and maintenance fee that is collected from the resident. Basically under the cost would be SP services/ cleaning/ pest control/ insurance/ etc, once the bills comes in I will typed it into the worksheet. I will also write cheques and make payable to the respective companies and record the cheque number on the bills. The bills is then filed into our accountant's folder so that she can keep track on her side.
Inflow/Outflow Tab, it shows the cheque number in respect to the purpose of payment. It also shows the summary of the balance left in the maintenance account. The account must always be positive and I had to make sure the outstanding balance can last for as long as possible. In order to do so, I had to factor out which is fixed costs and which are variable cost. Fixed cost cannot be avoided hence to cut cost I had to reduce the variable cost. For example, SP services. We can put a timer on the light system so that it will not be on the whole day or put water-saving device on taps. Until CSC (Certificate of Statutory Completion), we as the developer will have to be responsible for the estate's accounts.
I had learn new terms and how accounts can be kept in worksheet instead of balance sheet. I look forward to next week's work and hope to acquire more and more knowledge from Mr Chan and Ms Lily :D