houseman
1st September 2009, 16:14
I have found some excellent advice on software but nothing that seems to apply to my situation. Hopefully someone can help?
I manage a number of residences (private houses) via a private company. Income comes from one private source only (+occasional refunds, etc), payroll is calculated externally but I actually pay the employees and HMRC and it is not VAT registered.
What I do have is bills (some invoiced, plenty in cash) and expenses (invariably mine for all the cash payments but also housekeepers). Apart from the statutory stuff, I need to be able to show what is being spent on what, with whom and for what reason, what debtors are at any given time, to forecast coming cash requirements and to reconcile bank statements. We have 2 bank accounts; one with two cheque books and Debit cards, the other with debit card only.
I can manage straightforward Excel but creating complex accounting formulae and pivot tables has me beaten. I just need a simple programme that will do the record keeping and analysis without multiple inputs from me. Please, please can anyone point me in the right direction?
I manage a number of residences (private houses) via a private company. Income comes from one private source only (+occasional refunds, etc), payroll is calculated externally but I actually pay the employees and HMRC and it is not VAT registered.
What I do have is bills (some invoiced, plenty in cash) and expenses (invariably mine for all the cash payments but also housekeepers). Apart from the statutory stuff, I need to be able to show what is being spent on what, with whom and for what reason, what debtors are at any given time, to forecast coming cash requirements and to reconcile bank statements. We have 2 bank accounts; one with two cheque books and Debit cards, the other with debit card only.
I can manage straightforward Excel but creating complex accounting formulae and pivot tables has me beaten. I just need a simple programme that will do the record keeping and analysis without multiple inputs from me. Please, please can anyone point me in the right direction?