Cashflow Forecast creation - in excel, using data from Xero
- or -
Post a project like this$$
- Posted:
- Proposals: 11
- Remote
- #1502943
- Expired
TOP CERT Virtual Assistant, Data Analyst, Proofreader, Excel, Word and PowerPoint Trainer
Swindon
Certified Accountant + Xero/Sage/QB Expert + loss claim, grant & loans
City of London
Web research|Lead Generation| email database | Linkedin Research | Data Research | Image annotation
Mumbai
209005332765098274947975264981213413718271396220142033915725281588089
Description
Experience Level: Intermediate
Kind of support: Cash Flow
Description of support work: Cashflow Forecast Brief
1. Want a 12 month rolling cashflow forecast in Excel for our company
2. Can take current data from Xero (all up to date) to form this
3. Ability to change scenario based on debtor days change: 30/45/60/90 days
4. Same – based on Aged Payables payable days
5. Would like different tabs for: Ages Payables, Aged Receivables, Payroll/Salaries, Overheads, Variable Costs
6. List the months at the top as columns, and the P&L items as rows.
Want to create this initially, then have it updated on a monthly basis.
Extra notes:
Description of support work: Cashflow Forecast Brief
1. Want a 12 month rolling cashflow forecast in Excel for our company
2. Can take current data from Xero (all up to date) to form this
3. Ability to change scenario based on debtor days change: 30/45/60/90 days
4. Same – based on Aged Payables payable days
5. Would like different tabs for: Ages Payables, Aged Receivables, Payroll/Salaries, Overheads, Variable Costs
6. List the months at the top as columns, and the P&L items as rows.
Want to create this initially, then have it updated on a monthly basis.
Extra notes:
Tom P.
99% (27)Projects Completed
34
Freelancers worked with
37
Projects awarded
27%
Last project
11 Jan 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Tom, what type of business is this and when are you looking to have the KPIs/report templates completed by?
Where are you based if onsite assistance maybe useful?
363824
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies