Finance | Project Operations, Human Resources, ...

How can I use cashflow forecast for my client to prepare budget spreadsheet and cash position? " i need a real case of using and getting benefit form cashflow forecast

(0) Share

Report

Posted on by Mohamed Morad

I studied the cashflow forecast very well , but cant get to the point that making the good process and reports instead of using excel and manual calculation , so please help me by your practical experience in this point

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mohamed Morad,

The cash flow forecast data can be included in a financial report.

You can create separate columns for those forecast data and compare them for example with the actuals.

I attached you a screenprint that gives you an idea how this can be achieved.

Best regards,

Ludwig

Was this reply helpful? Yes No
Mohamed Morad 55 on at

Like (0)

Report

Will the actual compared here be an amount on a cash basis ?

and in the configuration step , while setup cashflow forecast , what i understand is (setup cashflow

firstly define cash and cash equivalent accounts - should be configured in cash and bank module- and then activate cashflow button on budget models and , then define each cash account that will be affected versus every budgeted amount from (cash and bank >>cashflow forecast setup > GL fast tab > dependent account - here a question should i create accounts specialized for cash budget in COA or can use same normal accounts -

then i imagine using financial reporting im gonna create cash budget spread sheet ,

Then can i use transaction type "transaction in cashflow forecast setup >GL > dependent accounts , AP , AR and project mgmt to update my cash budget forecast upon on real terms

The setup really cant help me and is not easy like working normally on excel , so till now i feel it's useless

please correct me and help!

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

The actual data are not on a cash basis but on an accrual basis. I added those columns so that you can see that more than only actual data can be reported on.

The cashflow forecast data that the periodic job is calculating are the ones that you are seeing in the report once the job is completed.

Are you not seeing those data in the report?

Best regards,

Ludwig

Was this reply helpful? Yes No
Mohamed Morad 55 on at

Like (0)

Report

I need the way to setup cash budget like that with adding columns of actual on actual basis , and can adjust for the budget for the expected amounts according to payment terms of vendors , receivables and so on.

i studied all setup of cashflow and know all you said ,but still cant do this requirement for my company , so advice regarding cashflow even by sending a techtalk video that may assist

Thanks

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mohamed,

Thanks for sharing the screenprint.

The report that you show has elements included such as rent that are usually not directly paid; meaning that there might be a time difference between the time the expense is recorded - for example in January - and the time the expense is actually paid and the cash is flowing out - for example in February.

I don't think that the financial reporter can fully handle that at least when it comes to reporting realized cash inflows / cash outflows.

What you are trying to do here looks like a direct cash flow statement, which is not supported out of the box.

I have done this kind of report with the help of electronic reporting for realized cash flows; not for budget ones.

Yet, creating such a report is tricky because - among others - invoices are often paid together or deductions are made when you make payments.

The same applies for receipts that you get from customers.

There are a lot of pitfalls because you have to trace the complete information from the cash inflow/outflow back to the original entry where the cost/revenue was posted.

If you don't want to design such a direct cash flow statement report manually, I would thus recommend reaching out to a developer who should be able to help you with the design of such a report.

Best regards,

Ludwig

Was this reply helpful? Yes No