WE NEED A SPREADSHEET CREATING WITH CORRECT FORMULAS

We are a letting agency and every year we use a spreadsheet to input funds from business bank statements such as rent, landlord payments, fuel payments, maintenance payments and transfers of funds from different accounts for our end of year accounts. We need a spreadsheet creating with all the correct formulas already in place, so when we add a amount from a bank statement it automatically adds and totals with the rest of the spreadsheet.

The transfered amounts also need to add up, so if we add funds been transfered from a certain bank account this should show in the bank account we have transfered from.

Feel free to ask for further information.

We will add an example of last years spreadsheet.