Monthly Budget Report compare to annual amount budgeted.

[Former Member]

Dear experts,

I have a client who normally report the budget by its cumulative monthly consumption (Actual), but by comparing this actual to the whole year budgeted amount.

It look like this:

Annual Budget                                        Actual up to may                                   Differences                                %               

      1000                                                          200                                                       800                                   80%   

For the next month it will change the actual up to may to up to june with its cumulative amount, and the Differences and % will change accordingly, but the Annual Budget will remain the same, unless if the do a budget revision. Hope I'm clear.

Is there someone who knows this report in SAP Business One?

Your help will be highly appreciated.

Best Regards

Cedric K.

[Former Member · Accepted solution]

Dear Cedric,

What your client want would be a difficult task even by a customized report. You may suggest them to run the whole year report monthly.

Then export to Excel to handle.

Thanks,

Gordon

[Former Member]

Sorry the report is not well appearing. here is the report

Annual Budget	Actual up To May	Differences	%
1000	200	800	80

Best Regards

[former_member205766]

Hi

If you need a monthly Budget monthly (Actual) reports means go to Financial Report => Budget Reports => Click Budget Report and Select Monthly report.

With Regards

Balaji Sampath

[Former Member]

Hi Balaji,

You are right on this, but remember if you run this report after choosing for which months you want to see the report on, the budgeted amount will be divided also according to selected months. And the difference and the % will be calculated accordingly.

What actually the client want, is to get the full budgeted amount of the whole year instead of the divided amount. And calculate the difference and the percentage accordingly.

Best Regards

[former_member205766]

Hi

Please give some more clarity about your client requirement.  Better you give tables with examples.

With Regards

Balaji Sampath

[Former Member]

Hi,

Here is the scenario;

Suppose the fiscal year start from 1st July 2014 to 30 June 2015.

If the budgeted amount for the whole year for one of the expense accounts is USD1200, and the consumption up to date (Sept 2014) is USD400, that means the remaining budget is USD800 which is equal to 66.66% of the whole budget.

Now, Assume the consumption up to August 2014, was USD300; if you run the monthly report up to August 2014, the budgeted amount will  be USD200 (the system divide the annual budgeted amount according to selected months), then the difference will be -100USD and the % will be -50%. As if the client has exceed the budget.

Which the client consider to be wrong because, he is expecting the budget to show up like this: Budgeted amount 1200USD, consumption up to August 300USD, the difference 900USD and the percentage to be 75%. Because for them they budget annually, and they report monthly consumption compare to the whole year budget.

Hope I'm clear now.

Best regards,

[former_member205766]

Hi

Yes.  Based upon the budget factor the standard report fetch the data so you need to create the query or report by your own.

With regards

Balaji Sampath