Three Way Cashflow
Budget: $30 – $250 AUD
I'm looking to build a spreadsheet that provides a three way cash flow (cash flow, income statement and balance sheet) for a business.
The spreadsheet needs to provide weekly historical inputs based on the chart of accounts attached.
It needs to be simple enough so line items can be inserted for new income and expenditure items that will carry through to all three spreadsheets.
At present I have two weeks data to insert but will receive weekly updates and I also want a three way forecast that I can base on a rolling average of actual data such rolling average needs to have the facility to be changed anywhere from the last 2 to the last 12 or more weeks data.
The spreadsheet will be utilised by a number of people so less or no macro's is better - I also need to be able to change formatting as needed.
Number format needs to be such that negative numbers are in brackets.
Time is of the essence so I need a modelling expert as I don't have the time to build this myself.
The spreadsheet needs to provide weekly historical inputs based on the chart of accounts attached.
It needs to be simple enough so line items can be inserted for new income and expenditure items that will carry through to all three spreadsheets.
At present I have two weeks data to insert but will receive weekly updates and I also want a three way forecast that I can base on a rolling average of actual data such rolling average needs to have the facility to be changed anywhere from the last 2 to the last 12 or more weeks data.
The spreadsheet will be utilised by a number of people so less or no macro's is better - I also need to be able to change formatting as needed.
Number format needs to be such that negative numbers are in brackets.
Time is of the essence so I need a modelling expert as I don't have the time to build this myself.