Budget Vs Actual

Report Module Guide: Budget VS Actual (Matrix View)

Module Location

General Ledger > Report > Budget VS Actual

Module Objective

The Budget VS Actual report module is used to generate a comparative report between the Budget and the Actual realization in a Matrix format. The matrix view is highly effective for analyzing and comparing the performance of multiple departments (Cost Centers) simultaneously within a single period, both on a yearly and monthly basis.

1. Report Parameters (Matrix Budget)

The main page of this module is a form containing various parameters to customize the comparison report that will be generated.

Here is an explanation for each parameter:

Budget Period:
- Select the budget year to be analyzed from the dropdown (e.g., 2025).
View:
- Choose the time scope of the report.
- Yearly View: To display a comparison of accumulated data for the entire year.
- by month: To display a comparison of data for a specific selected month.
Cost Center:
- Use this list box to select one or more departments (Cost Centers) that you want to include in the report. You can select multiple departments at once.
Employee:
- This dropdown is likely used to filter budgets related to a specific employee.
Type:
- Select the report's level of detail.
- Summary: Displays the report in a summary format.
- Register: Displays the report as a detailed list of transactions.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Fill in or select all the parameters you need in the Matrix Budget section to ensure the generated report matches the scope of your analysis.

Step 2: Generate the Report

After all parameters are set, click one of the buttons in the bottom-left section of the page to generate the report in a new format:

Display Report New: To preview the comparison report directly on your screen.
Export To MS Excel New: To download the report data in an Excel file format.

Additional Button Functions

This module also has several buttons with advanced functions:

Upload Data: This button is likely used to upload budget data in a matrix format (e.g., from an Excel file) directly into the system.
Verify: This button is likely used to verify or ratify the uploaded budget data before it can be used in reports.

Tips & Important Notes

Use the by month view for in-depth monthly analysis or the Yearly View for an overview of annual performance.
The matrix view is highly effective for comparing the performance of several Cost Centers side-by-side in a single report.
The Upload Data and Verify functions indicate that this module may also be a tool for managing matrix budget data. Please coordinate with the Cost Planning Control team before using these features.

Revision #3
Created 30 July 2025 14:23:24 by Muhammad Ali Akbar
Updated 15 August 2025 10:20:15 by Muhammad Ali Akbar

Budget Vs Actual

Report Module Guide: Budget VS Actual (Matrix View)

Module Location

General Ledger > Report > Budget VS Actual

Module Objective

1. Report Parameters (Matrix Budget)

The main page of this module is a form containing various parameters to customize the comparison report that will be generated.

Here is an explanation for each parameter:

Budget Period:

Select the budget year to be analyzed from the dropdown (e.g., 2025).

View:

Choose the time scope of the report.

Yearly View: To display a comparison of accumulated data for the entire year.

by month: To display a comparison of data for a specific selected month.

Cost Center:

Use this list box to select one or more departments (Cost Centers) that you want to include in the report. You can select multiple departments at once.

Employee:

Type:

Select the report's level of detail.

Summary: Displays the report in a summary format.

Register: Displays the report as a detailed list of transactions.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Fill in or select all the parameters you need in the Matrix Budget section to ensure the generated report matches the scope of your analysis.

Step 2: Generate the Report

After all parameters are set, click one of the buttons in the bottom-left section of the page to generate the report in a new format:

Display Report New: To preview the comparison report directly on your screen.

Export To MS Excel New: To download the report data in an Excel file format.

Additional Button Functions

This module also has several buttons with advanced functions:

Upload Data: This button is likely used to upload budget data in a matrix format (e.g., from an Excel file) directly into the system.

Verify: This button is likely used to verify or ratify the uploaded budget data before it can be used in reports.

Tips & Important Notes

Use the by month view for in-depth monthly analysis or the Yearly View for an overview of annual performance.

The matrix view is highly effective for comparing the performance of several Cost Centers side-by-side in a single report.

The Upload Data and Verify functions indicate that this module may also be a tool for managing matrix budget data. Please coordinate with the Cost Planning Control team before using these features.

Budget Vs Actual

Report Module Guide: Budget VS Actual (Matrix View)

Module Location

General Ledger > Report > Budget VS Actual

Module Objective

1. Report Parameters (Matrix Budget)

The main page of this module is a form containing various parameters to customize the comparison report that will be generated.

Here is an explanation for each parameter:

Budget Period:

Select the budget year to be analyzed from the dropdown (e.g., 2025).

View:

Choose the time scope of the report.

Yearly View: To display a comparison of accumulated data for the entire year.

by month: To display a comparison of data for a specific selected month.

Cost Center:

Use this list box to select one or more departments (Cost Centers) that you want to include in the report. You can select multiple departments at once.

Employee:

This dropdown is likely used to filter budgets related to a specific employee.

Type:

Select the report's level of detail.

Summary: Displays the report in a summary format.

Register: Displays the report as a detailed list of transactions.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Fill in or select all the parameters you need in the Matrix Budget section to ensure the generated report matches the scope of your analysis.

Step 2: Generate the Report

After all parameters are set, click one of the buttons in the bottom-left section of the page to generate the report in a new format:

Display Report New: To preview the comparison report directly on your screen.

Export To MS Excel New: To download the report data in an Excel file format.

Additional Button Functions

This module also has several buttons with advanced functions:

Upload Data: This button is likely used to upload budget data in a matrix format (e.g., from an Excel file) directly into the system.

Verify: This button is likely used to verify or ratify the uploaded budget data before it can be used in reports.

Tips & Important Notes

Use the by month view for in-depth monthly analysis or the Yearly View for an overview of annual performance.

The matrix view is highly effective for comparing the performance of several Cost Centers side-by-side in a single report.

The Upload Data and Verify functions indicate that this module may also be a tool for managing matrix budget data. Please coordinate with the Cost Planning Control team before using these features.