Report on Budget Vs Actual

Report on budget Vs actual

The Budget Vs Actual report gives you the comparison between budget amounts and the actual account for an account code. The budget is usually fixed for an account code with respect to a finance book. Tell me more.

Select the “Report on Budget Vs Actual” link under “Reports – Book keeping”.

The “Budget Vs Actual” page appears.

Enter the following field in the “Print Criteria” group box:

Finance Book	Use the drop-down list box to select the finance book for which you want to view the budget Vs actual. All the finance books residing at the “Finance Book Processing” business component and which has been mapped to the “Report – Book keeping” component will be available for selection in alphabetical order.
Financial Year	Use the drop-down list box to select the financial year in which you want to view the budget Vs actual. All the financial years that are applicable to the company upto the current financial year will be available for selection The system displays the first value by default on launch of the page.
Financial Period From	Use the drop-down list box to select the financial period from which you want to view the budget Vs actual. All the financial periods that are applicable to the company upto the current financial period will be available for selection. The system displays the first value by default on launch of the page.
To	Use the drop-down list box to select to which financial period you want to view the budget Vs actual. The system displays the first value by default on launch of the page.
Balance By	Use the drop-down list box to select the type account balance you want to view. You can select from “Account Code ”, Analysis Code” and “Sub Analysis Code”. The system displays “Account Code” by default on launch of the page.
Account Code From	The starting code number in the range of code numbers identifying the account code for which you want to view the budget Vs actual (Alphanumeric, 32). You can enter the number in full or specify it partially using the “*” character. The system retrieves all the codes that are similar to the value entered here.
	Help facility available.
To	The ending code number in the range of code numbers identifying the account code for which you want to view the budget Vs actual (Alphanumeric, 32). You can enter the number in full or specify it partially using the “*” character. The system retrieves all the codes that are similar to the value entered here.
	Help facility available.
Account Group	Use the drop-down list box to select the type of account group under which you want to view the budget Vs actual. You can select from “Assets”, “Liabilities”, “Expenses”, “Income” and all. The system displays the first value by default on launch of the page.
Analysis Code From	The starting code number in the range of code numbers identifying the analysis code for which you want to view the budget Vs actual (Alphanumeric, 32). You can enter the number in full or specify it partially using the “*” character. The system retrieves all the codes that are similar to the value entered here.
To	The ending code number in the range of code numbers identifying the analysis code for which you want to view the budget Vs actual (Alphanumeric, 32). You can enter the number in full or specify it partially using the “*” character. The system retrieves all the codes that are similar to the value entered here.
Sub Analysis Code From	The starting code number in the range of code numbers identifying the sub- analysis code for which you want to view the budget Vs actual (Alphanumeric, 32). You can enter the number in full or specify it partially using the “*” character. The system retrieves all the codes that are similar to the value entered here.
To	The ending code number in the range of code numbers identifying the sub-analysis code for which you want to view the budget vs actual (Alphanumeric, 32). You can enter the number in full or specify it partially using the “*” character. The system retrieves all the codes that are similar to the value entered here.
Sort By	Use the drop-down list box to select the type in which you want to sort the budget Vs actual. You can select from “Budget Amount”, “Variance Amount”, “Utilized Amount”, “Variance %” and blank. The system displays blank by default on launch of the page.
Range From	The starting number in the range of numbers identifying the amount from which you want to view the budget Vs actual (Integer, 29). The system retrieves all the amounts equal to and greater than the amount specified if the “To” field is left blank.
To	The ending number in the range of numbers identifying the amount to which you want to view the account balance (Alphanumeric, 18). The system retrieves all the amounts lesser than or equal to the amount specified if the “Amount From” field is left blank.
Amount In	Use the drop-down list box to set whether you want to view the budget Vs actual figures in “Billions”, “Millions” or “Thousands”. The system displays “Blank” by default on launch of the page.

Click the “Print Summary Balance” push button to print the summary of the budget Vs actual balance..

The system retrieves and displays the budget Vs actual figures based on the selection of the finance book. The system also retrieves the budget Vs actual based on the account grouping and the sorting. The system also calculates the variance as the difference between the utilized amount and budget amount. A positive sign indicates that the utilized amount is greater than the budget amount and a negative sign indicates that the utilized amount is less than the budget amount. The variance is also indicated in % terms.

Click the “Extract To Excel” push button to extract the details of the budget Vs actual to excel.

The system retrieves and displays the budget Vs actual amount based on the selection of the finance book in an MS-Excel sheet. The system also retrieves the budget Vs actual based on the account grouping and the sorting. The system also calculates the variance as the difference between the utilized amount and budget amount. A positive sign indicates that the utilized amount is greater than the budget amount and a negative sign indicates that the utilized amount is less than the budget amount. The variance is also indicated in % terms.

Report on Budget Vs Actual – An overview

You can print the budget Vs actual amounts for a selected finance book, financial year and financial period. You can also print the budget Vs actual amounts based on what type of balance like account, analysis or sub-analysis code you want to view the budget Vs actual. The variance / difference between the budget amount and utilized amount is calculated and displayed both in amount and percentage terms. This is basically for the purpose of analysis and also for cost control, monitoring and reduction.

This page allows you to set the criteria for generating the budget Vs actual for a finance book. You can generate the budget Vs actual for a posting finance book. The details of the generated budget Vs actual can be viewed before being printed as a report. The Actual Vs Budget amount can also be generated and viewed in an MS-Excel work sheet.

You can generate the budget Vs actual by specifying the account group. You can specify by which you want to sort the budget Vs actual. You can also generate the budget Vs actual by specifying a range of “Account”, “Analysis” and “Sub Analysis” codes. You can also set the figures in which you want to view the account ledger.