Budgeting and forecasting without spreadsheet chaos
When two managers send back different versions of the same budget, finance spends the review meeting reconciling tabs. Start with one approved plan, one set of closed actuals and a forecast managers can revise without changing either. A spreadsheet can do that if everyone uses the same records.
Give each budget line an owner and a home
Keep department, facility, account and month as separate fields. A maintenance manager can own repairs at two plants while each plant still sees its own cost. For shared rent, document one allocation rule and check that the two locations add back to the invoice. Map the accounting export once and flag unmapped accounts before distributing reports.
For large vendor lines, show the supplier, renewal date, rate, expected units and open purchase orders. Separate invoices already posted from orders still to be received. When the invoice arrives, reduce the open commitment so the forecast counts the purchase once.
Reconcile people and projects before changing dollars
Match approved position IDs to payroll and open requisitions by site, start date, shift and pay rate. Include payroll burden. If someone transfers, move the position between departments on the same date. For equipment, keep a separate approval register with the deposit, installation date and final payment. A revised forecast does not authorize a new hire or purchase.
Illustrative example: three months closed, nine to go
After March closes, a 3+9 view keeps January–March actuals and forecasts April–December. Suppose a second shift was approved for April but customer orders now support a June start. Move the two approved hires and their payroll burden to June in the forecast. Leave the original budget intact. Ask whether May orders require overtime, and enter that cost only if the shift lead confirms the hours.
Next month the same report becomes 4+8. If the owner needs a rolling twelve-month view, append a month beyond year-end as each month closes. Keep a dated copy of the prior forecast so you can see which assumptions moved.
Run the meeting from exceptions
Finance reconciles actuals to the ledger and publishes budget, actual and latest forecast side by side. The manager explains each material variance as timing, volume, rate or a scope change. A late invoice moves cash between months; a permanent rate increase changes the remaining months. End with a decision, a named owner and the date it will be checked. Bring one department report and its open commitments to an Apex review.