Budget tracking software stores the spending a company planned at the start of the year by cost center, account and month, then compares it with actuals from accounting and with purchase commitments that have not been invoiced yet. The short answer: remaining budget is not budget minus spent; it is budget minus spent minus committed. The software keeps that number current and asks for approval when a request would exceed it.
Why is budget tracking hard in spreadsheets?
In most companies the budget is built as one large spreadsheet at the start of the year. The trouble starts later. Accounting data arrives after month end close, often weeks late; purchasing keeps its orders in a separate list; each department head works in a private copy. When the budget is revised in June, people argue about which file is current. In the end managers learn they went over budget only after the invoice is booked, when the money has already been spent.
A budget check before spending is control. A budget check after the invoice is just a report.
Features budget tracking software should have
- Budget lines: cost center, account code, month and amount; amounts are stored as integer minor units (cents), so rounding errors never accumulate.
- Versions: the approved original budget is locked and revisions are saved as separate versions, so reports show original and revised side by side.
- Actuals: journal lines from the accounting system are matched by cost center and account automatically, never copied by hand.
- Commitments: approved purchase orders that have not been invoiced are deducted from the remaining budget.
- Variance report: budget, actual, committed, remaining and variance percentage, by month, quarter and year.
- Approval flow: a request above the remaining budget goes to the next manager or to finance, depending on the amount.
- Permissions: each manager sees only their own cost center, finance sees the whole company.
How are remaining budget and variance calculated?
Everything is calculated on one key: cost center, account code and month. For that key the software sums the budget, the actuals from accounting and the open commitments from purchase orders. Remaining budget is the budget minus actuals minus commitments; variance is actuals minus budget. If a new request exceeds what is left, it goes to approval. The example below shows the logic:
type BudgetLine = { costCenter: string; account: string; month: string; amountKurus: number };
type Actual = { costCenter: string; account: string; month: string; amountKurus: number };
type Commitment = { costCenter: string; account: string; month: string; openKurus: number };
function sumFor<T extends { costCenter: string; account: string; month: string }>(
rows: T[],
pick: (row: T) => number,
key: { costCenter: string; account: string; month: string },
): number {
return rows
.filter((r) => r.costCenter === key.costCenter && r.account === key.account && r.month === key.month)
.reduce((s, r) => s + pick(r), 0);
}
function remaining(
budget: BudgetLine[],
actuals: Actual[],
commitments: Commitment[],
key: { costCenter: string; account: string; month: string },
) {
const planned = sumFor(budget, (r) => r.amountKurus, key);
const spent = sumFor(actuals, (r) => r.amountKurus, key);
const committed = sumFor(commitments, (r) => r.openKurus, key);
const left = planned - spent - committed;
return { planned, spent, committed, left, variance: spent - planned };
}
function needsApproval(requestKurus: number, leftKurus: number): boolean {
return requestKurus > leftKurus;
}Two rules matter here. First, when the invoice arrives the purchase commitment closes and the amount moves to actuals, so the same spend is never deducted twice. Second, a revised budget never overwrites the old version; it is saved as a new one, so at year end you can still report variance against the original plan. This article is a general software guide, not financial or accounting advice; set your budget policy together with your accountant.
How does budget tracking connect to other systems?
A budget tool collects data more than it creates it. Actuals come from the accounting system where the official books are kept; we explained how that transfer is built in our accounting software integration article. Commitments are read from approved orders in your purchasing software, and the budget check happens at the request stage. For smaller businesses, following cash and bank movements may be enough; in that case our income and expense tracking software article is a better starting point.
Off the shelf or custom software?
Most ERP products ship with a budgeting module, and it may be enough for a standard cost center structure. If your approval rules are specific to your company, you run several legal entities or currencies, you budget per project, or accounting and purchasing live in different systems, custom development means fewer compromises. Before deciding, review last year's budget file and its revisions; it is the fastest way to see what you actually need.
Conclusion
Good budget tracking software keeps the budget by cost center, account and month, versions every revision, pulls actuals from accounting and commitments from purchasing automatically, and routes any request above the remaining budget to approval before the money is spent. To build this on top of your existing systems, see our corporate solutions page or describe your process and request a quote.