Budget Statistics

Purpose: The Budget Statistics function is designed to help users monitor, compare, and manage budgets effectively for improved financial outcomes.

1 Overview

Provides a quick summary of all budgets, offering insights into their utilization and remaining balances. Users can click on a specific budget to view detailed data on the current cycle.

1.1 Field Explanation

Budget Name: The name of the budget, helping to distinguish between different budget allocations.
Year: The year in which the budget was allocated.
Period: The timeframe for the budget (Yearly, Quarterly, Monthly, or Custom).
Budget Amount: The total amount allocated for this budget period.
Incurred Amount: The total expenses reported against this budget during the selected period.
Remaining: The leftover amount in the budget after deducting incurred expenses.
Used Ratio: A percentage representing how much of the budget has been utilized, calculated as:

1.2 Export

Export the budget statistic overview.

Step 1: In the top-right corner of the page, click "Export".

The system will automatically generate and download the exported data in Excel onto the user's device.

If the user's browser settings does not allow pop-up, the user can download manually from the Instant Messenger (IM).

2 Details

2.1 Current Cycle

Purpose: Provides detailed information about the expenses recorded within the current active budgeting period.

1.1.1 View

Step 1: Go to the end of the desired row, click more ···, then click on "Current cycle".

1.1.2 Field Explanation:

Reimburser: The individual who submitted the reimbursement request.
Reimburser's Department: The department to which the reimburser belongs.
Category Name: The expense category which the reimbursement is recorded.
Category No.: A unique identifier or code associated with the expense category.
Reimbursement Amount: The amount reimbursed for the expense.
Reimbursement Date: The date when the expense occurred or was reimbursed.
Expense Beneficiary: The entity (e.g., user, department, project) that benefited from the expense.
Source: The origin of the expense, such as from workflow or enter expense menu.
Budget Utilized: The portion of the budget that has been consumed by this reimbursement.

2.1.3 Export

Export the current cycle details overview.

Step 1: In the top-right corner of the page, click "Export".

The system will automatically generate and download the exported data in Excel onto the user's device.

If the user's browser settings does not allow pop-up, the user can download manually from the Instant Messenger (IM).

2.1.4 Switch Tab

From Current Cycle, users can switch to the All Cycles tab to view historical data for all previous and future cycles.

2.2 All Cycles

Purpose: Consolidates the expense data across all budget cycles, providing a comprehensive overview of historical and ongoing budget utilization.

2.2.1 View

Step 1: Go to the end of the desired row, click more ···, then click on "All cycles".

2.2.2 Field Explanation:

Reimburser: The individual who submitted the reimbursement request.
Reimburser's Department: The department to which the reimburser belongs.
Category Name: The expense category which the reimbursement is recorded.
Category No.: A unique identifier or code associated with the expense category.
Reimbursement Amount: The amount reimbursed for the expense.
Reimbursement Date: The date when the expense occurred or was reimbursed.
Expense Beneficiary: The entity (e.g., user, department, project) that benefited from the expense.
Source: The origin of the expense, such as from workflow or enter expense menu.
Budget Utilized: The portion of the budget that has been consumed by this reimbursement.

2.2.3 Export

Export All cycles budget use details.

Step 1: In the top-right corner of the page, click "Export".

The system will automatically generate and download the exported data in Excel onto the user's device.

If the user's browser settings does not allow pop-up, the user can download manually from the Instant Messenger (IM).

2.2.4 Switch Tab

From All Cycles, users can switch to the Current Cycle tab to focus on the details of the active budget period.

2.3 Budget details

Purpose: Display budget details based on reimbursement data, enabling detailed comparisons of budget execution values to support informed decisions on financial planning, resource allocation, and cost control with real-time insights.

2.3.1 View

Step 1: Go to the end of the desired row, click more ···, then click on "Budget details".

2.3.2 Field Explanation:

Period: Represents the budgeting period, such as Year, Quarter, Month, or a Custom time range.
Node: A specific segment of the budget, such as Department, Personal, Expense Category, or Project, as defined by the user.
Brought Forward: The remaining budget carried over from the previous cycle (if carry-forward is enabled).
Original: The initial budget amount allocated for the period.
Add-on: Any additional budget allocated to this node during the period.
Deducted: Budget amount reduced during the period, such as for reallocation or adjustments.
Total Budget for This Period: The sum of the Brought Forward, Original, Add-on, and Deducted amounts, representing the final budget for this cycle.
Incurred Amount: The total amount of expenses recorded against this budget during the period.
Carried Forward: The remaining budget that will be transferred to the next cycle (if applicable).
Remaining: The unused budget after deducting the Incurred Amount from the Total Budget for This Period.
Used Ratio: The percentage of the total budget utilized during the period