Improvement of financial forecast model and automation of data input for actuals
$250-750 AUD
Betalades vid leverans
I need to upgrade my current Excel consolidated monthly cashflow forecast model (18 month horizon) to include:
a) forecast Profit / loss
b) Forecast balance sheet
c) automated update of prior month forecast with actuals, once month end is finalised
d) Summary reports including Variance Analysis; YTD and updated FY forecasts.
e) design of fit for purpose input sheets which can be distributed to each department and then included in the consolidated plan.
I also need to be able to update assumptions on a monthly basis, for future periods. Currently this is done manually via direct input to feeder excel tabs. I would like to streamline these inputs without impacting past periods.
CURRENT STATUS OF THE MODEL
I have a very manual excel cashflow forecast model for a consolidated group of entities (two entities in the group). On a monthly basis, forecast inf is manually replaced in feeder excel tabs with actual information from our accounting system. This requires two steps:
1. Consolidate the two entities into one dataset from our ERP
2. Input this data into the feeder excel tabs in the forecast model, over-writing the previous forecast with actuals.
Once this is done, I manually amend a summary output sheet to report on the revised Financial Year forecast.
FRUSTRATIONS / areas for improvement
1. The process is very manual, disjointed and subject to human error; it also takes a lot of time
2. There is not currently an easy way to do a variance analysis of monthly / periodic actuals v previous budget on a consolidated basis.
3. The summary reports are very basic and can be improved with visualisation / graphs etc.
Projekt-id: #33976967
About the project
Tilldelades:
49 frilansare har lagt bud på i genomsnitt $518 för det här jobbet
"Sir, Your project needs skills of both Excel and Accounting and I am expert in both these fields. there is nothing in excel that I cant do and I am an experienced accountant from PWC having degree in Accounting and Fi Mer
Hello, I will be glad to assist you with that. I am an experienced Financial Analyst and Excel expert holding years of experience in Financial Analysis, Financial Modeling and Corporate Finance. Lets discuss your proje Mer
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Mer
Hi there, I can help you improve the financial model by incorporating all the listed points including forecasted income statement and balance sheet. Please drop me a message to discuss in details. May i know when do Mer
Hi, I am a qualified Chartered Accountant from UK having 7 Year experience in accounts, finance, and financial projections. I can provide you with forecasted Consolidated profit or loss accounts, balance sheet, cashflo Mer
"Hello, I am interested in your project I am a business & financial consultant providing services of business plans writing, creating feasibility studies, preparing financial models & conducting business valuations. I Mer
Hi, We have read your description and we can do it for you on time. Our versatile and dedicated team members have experienced in these types of projects. Price is negotiable and our main motive is to provide quality pr Mer
Since i have worked for 2 banks in Turkey in the last 9 years as a project finance assistant manager, i believe that i can do the best one. Thanks in advance.
I have Python and robotic process automation skills to automate the processes and provide you with an automated way to fulfil your reporting. If you want we can go the extra mile and store information inside a database Mer
With experience of being Financial planning and analysis (FP&A) manager in ASX 100, I am a proficient modeler who creates models and reporting dashboards from scratch regularly, with fully automated functions in Excel Mer
Having experience in this field and can work long time per day and high expert rate in all required skills
Hi, this is Daniyal Hussain. I am a qualified chartered accountant with more than 7 years of experience in the field of accounting and finance. I have good knowledge of excel, power query, power bi etc. I can help wi Mer
Hi, I am a Chartered Accountant having 9 years of experience. I am an expert in Financial forecasting and have all the skills and expertise required for this project. I am new on this website. I can also show you so Mer
Professional Accountant having vast experience of doing these type of jobs. I can share with you some examples of these type of sheets.
