Finance | Project Operations, Human Resources, ...

Budget planning/forecast

(0) Share

Report

Posted on by sunil narvaneni

261

Hi All,

We have a case where customer want to create Annual forecast which includes Actuals of some months and forecast of other months.

For e.g. at the end of Jan, we can have actuals of Jan and forecast for Feb to Dec which means current year original budgets of Feb to Dec.

So user want to generate such plan, they will export it make some change and import it to plan again. This will be used for next year.

How to setup this?

Thank you

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Junaid Idrees on at

Like (0)

Report

Hi santhosh,

This is achievable by using Advance budgeting, you can create budget plan and different layout design and create excel template to export, modify the budget figure and upload.

Please check out that below Microsoft doc to help you understand an overall idea:

1. docs.microsoft.com/.../budget-planning-overview-configuration

2. docs.microsoft.com/.../budget-planning-excel-templates

Detailed document step by step:

3. namithhosmane.blog/.../

Video to create budget plan:

4. www.youtube.com/watch

Was this reply helpful? Yes No
sunil narvaneni 261 on at

Like (0)

Report

Thank you very much for Quick reply@ Junaid Idrees

Thank you for sharing those links. But I want to generate Actuals and Forecasts as a one plan, how can I create that? In simpler way, I want the output of below two in one plan, like Jan,Feb,Mar from 1st one (actuals), Apr-Dec from 2nd one (Original budget entry).

Generate budget plan from general ledger

Generate budget plan from budget register entries

Could you please suggest me.

Thank you.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi santhosh,

Are you trying to get the plan/forecast data into d365fo or do you have them already in and need to create a report on those data?

Best regards,

Ludwig

Was this reply helpful? Yes No
sunil narvaneni 261 on at

Like (0)

Report

Thank you for your reply@ Ludwig Reinhard

Every month end I want to create a forecast based on available actuals in system and available budget in system.

My fiscal period is Jan-Dec, during start of my Fiscal year I will have original budget in system for Jan-Dec. And during in the year, e.g. in Feb end I will create a forecast which is based on Jan & Feb actuals which are already there in system and Mar-Dec original budgets which are also already there in system.

Thank you.

Was this reply helpful? Yes No
Suggested answer

CodyB on at

Like (0)

Report

Hi Santhosh,

For the budget plan mentioned by Junaid Idrees, the same budget plan can bring in both actuals and forecasted amounts. Using the "Add From" allows you to bring in data from both general ledger and budget register entries.

Thanks,

Cody

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (0)

Report

Hi santhosh,

1. First make sure you have a new budget code with the budget type as Preliminary budget.

2. Then upload your budget using that new budget code that references the budget type – preliminary budget.

3. Goto Management reporter and You will need to add another column there and add the attribute filter for ‘Budget type’ with the filter being ‘Preliminary budget’. This will allow you to have forecasted budget numbers.

Or

You will have original budget in system to export them in Excel, lets say Jan actual numbers. Then use that Jan data to Pull in MR to create forecasted budget for Feb.

Hope it clarifies l.

Was this reply helpful? Yes No