WORKFLOW

Tracking budget vs purchase order commitments

Automatically matches approved purchase orders to budget lines and alerts budget owners before committed spend exceeds approved limits.

Request a demo
Tour the product
 

Purpose

To ensure that budget owners maintain control over their cost centers throughout the period by:

  • Combining posted actuals with open PO commitments into a single committed-spend figure per budget line
  • Surfacing approaching and exceeded budget thresholds before invoices are received and posted
  • Giving budget owners and the finance team time to reallocate, delay, or cancel POs before the period closes

Without visibility into committed spend, a category can appear within budget while obligations already on the books can push it over. By the time the overage shows in GL actuals, it is too late to redirect spend.

Data sources

  1. Approved budget by category: The period budget broken out by cost center code and expense category. Sourced from the ERP or planning tool (e.g., NetSuite, Workday).
  2. PO register: All purchase orders in an approved or open status, exported from the procurement or ERP system (e.g., SAP, NetSuite).
  3. GL actuals to date: Posted journal entries for the period drawn from the general ledger.

Key processing steps

1. Map POs to budget lines

Each PO line is mapped to the corresponding approved budget line using the cost center code and expense category as the join keys.

2. Calculate committed spend per budget line

For each budget line, total committed spend is calculated by combining posted actuals and the remaining open PO commitment.

This produces a single committed-spend figure per budget line that represents total expected outflow for the period

3. Calculate remaining budget and utilization rate

Remaining budget and utilization rate are derived per line:

  • Remaining budget: approved budget amount minus committed spend
  • Utilization rate: committed spend divided by approved budget amount, expressed as a percentage

4. Alerting budget owners

An automated notification sent to the budget owner of any cost center with a line at or above 80% utilization. The alert includes the flagged budget line, current utilization rate, remaining budget, and the contributing PO references. A separate alert fires when any line crosses 100%.

Outputs

  1. Commitment report by cost center: A structured report showing each budget line with approved budget, actuals to date, open PO commitment, total committed spend, remaining budget, and utilization rate.
  2. Threshold alert to budget owners: An automated notification sent to the budget owner of any cost center with a line at or above 80% utilization. The alert includes the flagged budget line, current utilization rate, remaining budget, and the contributing PO references. A separate alert fires when any line crosses 100%.