Department Budget Tracking: Budget vs Actual (with Committed Spend)
Budget vs actual only shows what has been invoiced, not what is already ordered. How to add committed spend, the variance formulas, setting up 2027 department and project budgets, and the December use-it-or-lose-it spike.
Department budget tracking means comparing each department's budget against what it has spent. To get it right you need three numbers per line, not two: the budget, the actual (invoices posted to your books), and the committed spend (purchases already approved or ordered but not yet invoiced). Remaining budget equals budget minus actual minus committed. If you leave out the committed column, every department looks like it has more money than it does, and you find the overspend at month-end instead of at the request.
This guide covers the formulas, a worked example, how to set up 2027 department budgets, how to handle the December "use it or lose it" spike, and when a spreadsheet stops being enough.
How Foxpedite does it: committed spend that updates itself
The committed column is the one that keeps going stale in a spreadsheet, because someone has to type it in. In Foxpedite it's a side effect of making the request, for the company still running purchasing on spreadsheets, email and QuickBooks.
- Gate 1: budget at draft (Draft-Stage Budget Lock). The moment someone drafts a purchase, Foxpedite reserves it against the department or project budget. Committed spend updates itself. In the agency example below, the $9,000 contractor request would show Production going $4,000 negative while the request is still a draft.
- Gate 2: approval routed by amount and department. Over-budget or high-value requests go to the right approver, who can approve from the email.
- Gate 3: invoice matched before payment. The invoice moves from committed to actual only when it matches the PO and the receipt, so nothing is counted twice. That's three-way matching.
- Live, not monthly. Budget, committed, actual and remaining per department and project, every day of the month. Matched bills sync to QuickBooks Online, so the ledger stays your system of record.
Budgets, the draft-stage reservation and three-way match are on Regular ($390/month, 10 users). Over-budget routing to an approver, the QuickBooks Online sync and Predictive Budgets are on Advanced ($740/month, 20 users). Extra users are $39/month, and the 14-day trial includes every Advanced feature with no card required.
Try Foxpedite free for 14 days
Load your 2027 budgets and watch committed spend fill itself in from real requests. Every Advanced feature, no credit card.
Start your free trial → · Prefer to start by hand? Get the free 2027 Department Budget Tracker
Why "budget vs actual" alone misleads you
Most small-business budget reports come from the accounting system. QuickBooks Online, Xero and most other ledgers report what has been booked: bills entered, expenses posted, checks written. That works for accounting and fails for control.
The trouble is timing. When a department head orders $9,000 of equipment on November 3, nothing shows up in the ledger until the vendor invoices and someone enters the bill. That can be two to six weeks later. In the meantime the budget report still shows the $9,000 as available, so someone else spends it too.
There are three states a dollar can be in:
| State |
What it means |
Where it usually lives |
Shows in a standard budget vs actual report? |
| Committed |
Approved or ordered, not yet invoiced (open POs, signed quotes, approved requests) |
Email threads, a PO spreadsheet, someone's head |
No |
| Actual |
Invoice or expense posted to the books |
Accounting system |
Yes |
| Paid |
Cash has left the bank |
Bank + accounting system |
Yes (cash basis) |
A budget report built on actuals tells you what already happened. Adding committed spend tells you what is about to happen, which is the only part you can still change.
This isn't a small-company quirk. Research by The Hackett Group for Basware (50 US companies, 2018) found that maverick, off-process buying can cost companies 10–20% of their targeted savings. Companies running purchases through a procure-to-pay platform lost 60% less to it (Basware / The Hackett Group, 2018). That sample is larger companies with established procurement teams. A 40-person company has fewer controls, so the leak is unlikely to be smaller. For the mechanics of off-process buying, see our guide to maverick spend.
Budget vs actual variance formulas (and how to read them)
Use these four formulas in any department budget tracker. They work the same in Excel and Google Sheets.
1. Classic variance (actuals only)
Variance = Budget − Actual
2. Committed-aware variance (the one to manage by)
Remaining = Budget − Actual − Committed
3. Variance percentage
Remaining % = Remaining ÷ Budget
4. Forecast at completion (for annual budgets)
Projected spend = Actual + Committed + (Average monthly run-rate × Months left)
Projected variance = Budget − Projected spend
How to read them:
- A positive remaining number means headroom. A negative one means the department has already committed more than it was given, even if no invoice has arrived yet.
- Look at Remaining % rather than dollars when you compare departments of different sizes. A $3,000 cushion is a lot for office supplies and nothing for production.
- Set two alert levels, for example amber under 15% remaining and red at 0% or below. The colors matter because people skim.
- Favorable vs unfavorable: in cost budgets, spending under budget is "favorable". Don't celebrate a favorable variance in the fourth quarter until you've checked the committed column. It is often unfavorable spending that hasn't been invoiced yet.
Example scenario: the agency that had $22,000 left (but didn't)
Example scenario (illustrative). Not a Foxpedite customer.
A 45-person marketing agency runs four department budgets. Here is the Production department on November 15, with an annual budget of $180,000:
| Line |
Amount |
| Annual budget |
$180,000 |
| Actual (invoices posted in QuickBooks) |
$158,000 |
| Remaining per the accounting report |
$22,000 |
| Committed: approved freelance video edit (not yet invoiced) |
$8,500 |
| Committed: open PO for camera and lighting rental, Dec shoot |
$6,200 |
| Committed: signed quote, stock footage annual license |
$2,300 |
| Total committed |
$17,000 |
| True remaining (Budget − Actual − Committed) |
$5,000 |
On November 18, the production lead requests a $9,000 motion-graphics contractor for a year-end client campaign. Against the accounting report, the request looks fine because $22,000 remains. Against the committed-aware view, it puts Production $4,000 over budget ($5,000 − $9,000 = −$4,000), which is 2.2% over the annual budget.
Neither number is a disaster on its own. What matters is when you find out:
- With committed tracking: the owner sees −$4,000 on November 18 and has choices. Move budget from another department, defer the stock license renewal to January, or negotiate the contractor down.
- Without it: the overspend shows up in the January close, after all three commitments and the contractor have been invoiced. The money is gone, and the only thing left to decide is who gets the uncomfortable conversation.
Remaining % went from an apparently healthy 12.2% ($22,000 ÷ $180,000) to 2.8% ($5,000 ÷ $180,000) once committed spend was counted. The new request pushes it to −2.2%.
How to set up department and project budgets for 2027
Budget season is the cheapest time to fix your tracking. Use this checklist for the 2027 setup.
Structure
- [ ] One budget line per department (Production, Sales, Ops, Admin, and so on). Add a project or client dimension only if you actually manage by it.
- [ ] Map each budget line to GL accounts in your accounting system so actuals roll up automatically. If you can't map it, you won't track it.
- [ ] Decide annual vs monthly vs quarterly phasing. Phase seasonal lines (events, equipment) by month. Leave flat lines (software, rent) annual.
- [ ] Give every budget line a named owner. A budget without an owner is a suggestion.
Columns in the tracker
- [ ] Budget (annual and phased)
- [ ] Actual (from the ledger, refreshed weekly at least)
- [ ] Committed (open POs + approved requests + signed quotes)
- [ ] Remaining = Budget − Actual − Committed
- [ ] Remaining %
- [ ] Projected spend and projected variance (from Q2 onward)
Rules
- [ ] A purchase counts as committed the moment it's approved, not when it's ordered or invoiced.
- [ ] When an invoice arrives against a PO, move the amount from committed to actual. Don't count it twice.
- [ ] Close or cancel stale commitments monthly. A PO open for 90 days with no receipt is usually dead.
- [ ] Decide who can approve over-budget requests and write it down. That's often the owner for anything that pushes a line negative.
For the approval half of this, see How to Design a Purchase Order Approval Workflow People Actually Follow.
Prefer to start by hand? Free download: 2027 Department Budget Tracker
Google Sheets and Excel. Budget, actual, committed and remaining columns are pre-built, with amber/red alerts, a forecast-at-completion tab, and a commitments log that feeds the tracker automatically.
Get the tracker
Or skip the manual version: try Foxpedite free for 14 days
The "use it or lose it" December spike: how to spot and stop it
If department budgets reset on January 1 and unspent money disappears, people spend it in December. It's a rational move. A department head who returns $12,000 often gets a smaller budget next year.
How to spot it in your data
1. Pull monthly actuals by department for the last two years.
2. Calculate December spend ÷ average monthly spend for January–November.
3. A ratio above about 1.5x for a department with no seasonal reason (no holiday events, no year-end inventory build) is worth a conversation.
4. Check what was bought. Prepaid annual subscriptions, equipment that sits in boxes, and early renewals are the usual items.
How to stop it without punishing honest departments
- Separate "budget" from "entitlement" in writing. Tell department heads that underspend won't automatically cut next year's budget if they explain why.
- Allow a limited carry-over. For example, 10% of unspent budget can roll into Q1 for a named purpose.
- Raise the approval level in December. Any request over a set amount in the last six weeks of the year goes to the owner or controller.
- Watch committed spend weekly in Q4. The spike shows up in approvals and POs weeks before it shows up in invoices.
The workaround: the spreadsheet tracker, tab by tab
Here's how the free tracker is laid out, so you can build your own if you prefer.
| Tab |
What goes in it |
Who updates it |
How often |
| Budgets |
One row per department (and project, if used), annual amount, monthly phasing, owner |
Finance / owner |
Once a year, plus re-forecasts |
| Commitments log |
Every approved purchase: date, department, vendor, amount, PO number, status (open / invoiced / cancelled) |
Whoever approves or places orders |
Every purchase |
| Actuals |
Export from your accounting system by GL account and month |
Bookkeeper |
Weekly or at month-end |
| Tracker |
Budget, Actual, Committed (SUMIFS on open commitments), Remaining, Remaining %, alerts |
Formulas only |
Automatic |
| Forecast |
Run-rate projection and projected variance |
Formulas only |
Automatic |
The key formula on the Tracker tab is committed spend, summed per department from open rows in the log:
Committed = SUMIFS(Log!Amount, Log!Department, A2, Log!Status, "Open")
The weak point is the Commitments log. It depends on every approver remembering to write every approval down, in the same place, right away. Your PO numbering also has to be consistent enough to match invoices back to it. That's usually where spreadsheet trackers break. The formulas hold up fine. The data entry is what slips. We cover the wider pattern in Where the money leaks in spreadsheet purchasing.
Where it breaks: every tab depends on someone logging each PO and moving it from committed to actual when the bill lands. Miss a week and "remaining" is wrong again. The next section lists the signals.
Where the spreadsheet tracker breaks: five signals
A spreadsheet tracker is the right tool when one person approves everything and purchases run to a few dozen a month. These are the signals that it has stopped working:
- The commitments log is always behind. You regularly find invoices for purchases that were never logged.
- More than one or two people approve purchases, and they don't all update the same file.
- Department heads ask "how much do I have left?" and someone has to go and calculate it.
- You discover overspend at close, not at the request.
- The same purchase is counted twice, once as committed and once as actual, because nobody moved it.
When those show up, the fix is to make the commitment record a side effect of making the request, so nobody has to remember a separate logging step. That's what the Draft-Stage Budget Lock at the top of this guide does. If you're under 20 people with one approver, the free tracker may be all you need for 2027.
Stop updating the committed column by hand: start your 14-day Foxpedite trial
Every purchase reserved against the budget the moment it's drafted, overspend routed for approval at the request, and matched bills synced to QuickBooks Online. Every Advanced feature, no credit card.
Start free, no card →
Not ready yet? The free 2027 Department Budget Tracker is the manual version: download it. Or take the 1-minute fit check, or book a demo.
Common questions
What is committed spend in a budget?
Committed spend is money you've agreed to spend but haven't been invoiced for yet: approved purchase requests, open purchase orders and signed quotes. It isn't in your accounting system yet, but it will be. Subtract it from the budget along with actuals to get the true remaining amount.
What's the formula for budget vs actual variance?
The classic formula is Budget − Actual. For control, use Budget − Actual − Committed, then divide by Budget to get remaining %. Negative values mean the department has already committed more than its budget.
How often should department budgets be tracked?
Update actuals at least weekly, and record commitments every time a purchase is approved. A tracker refreshed only at month-end tells you what went wrong 30 days ago.
Should committed spend count against the budget before the invoice arrives?
Yes, if you want to prevent overspend rather than report it. Count a purchase as committed at approval. When the matching invoice is posted, move it from committed to actual so it isn't counted twice.
How do I stop "use it or lose it" spending in December?
Compare December spend to each department's January–November monthly average. Allow a limited, purpose-specific carry-over. Raise approval levels for the last six weeks of the year. Watch committed spend weekly in Q4, because the spike shows up in approvals before it shows up in invoices.
Can committed spend be tracked automatically?
Yes, if purchases start as requests in a purchasing system. In Foxpedite, each draft PO is reserved against the department or project budget the moment it's drafted (Draft-Stage Budget Lock) and moves to actual when the invoice matches. Budgets and the lock are on Regular ($390/month); the 14-day trial includes every Advanced feature with no card.
Related reading
Sources
- Basware, "New Basware report based on research from The Hackett Group..." press release, Nov 29, 2018 (50 US companies; maverick spend erodes 10–20% of targeted savings; 60% less lost with a P2P platform). https://news.cision.com/basware/r/new-basware-report-based-on-research-from-the-hackett-group-reveals-that-less-than-half-of-all-compa,c2686451 (accessed Oct 18, 2026)
- Foxpedite pricing and trial terms: https://www.foxpedite.com/pricing (as of October 2026)