Budget Tracking for Beginners: Your First Monthly Close in Five Steps
Published:
Last Updated:
Category: Marketing Budget & KPI
Authors: Shusaku Yosa
For a first monthly budget close, work through collection, reconciliation, calculation, explanation and action. Consistent periods and supporting evidence matter more than filling every blank quickly. Agree on recognition dates, currency, tax and unbilled costs with finance first.
The example below is fictional and excludes tax.
1. Collect the period's records
Gather the approved budget, media statements, invoices, orders, contracts, acceptance records and internal allocation support. Record missing documents with an owner and expected finalization date. Payment date alone does not necessarily determine the expense period.
2. Reconcile duplicates and timing
The example has JPY160,000 in invoiced production and JPY40,000 delivered and accepted but not yet invoiced. Under the assumed policy, finance confirms JPY200,000 for the month. Follow your own policy and distinguish unconfirmed estimates from recognized actuals.
A JPY50,000 tool invoice was imported twice. Match invoice number, contract and period, correct the duplicate and preserve the correction history. Do not delete evidence merely to make a total fit.
3. Calculate variances
Category | Budget | Reconciled actual | Actual − budget | Utilization |
|---|---|---|---|---|
Advertising | JPY300,000 | JPY330,000 | +JPY30,000 | 110% |
Production | JPY200,000 | JPY200,000 | JPY0 | 100% |
Tools | JPY50,000 | JPY50,000 | JPY0 | 100% |
Event | JPY0 | JPY20,000 | +JPY20,000 | Not defined |
Total | JPY550,000 | JPY600,000 | +JPY50,000 | About 109.1% |
Cost variance is actual minus budget; utilization is actual divided by budget. The event ratio is undefined because its budget is zero. Investigate the amount and approval instead. Compute the total ratio as 600,000 / 550,000, not an average of the row percentages.
4. Ask the owner for the cause
Higher advertising cost may reflect price, volume or an unrecorded budget amendment. The event expense may be necessary additional work, a period mismatch or an approval issue. Ask what changed, where the evidence is, what outcome was affected and whether the difference will recur.
Question | Record |
|---|---|
What changed? | Quantity, price, timing or scope |
What supports it? | Statement, contract, approval or owner confirmation |
What happened to the outcome? | Qualified inquiries, accepted work or quality |
Will it recur? | One-off versus continuing effect and forecast amount |
5. Assign action and follow-up
Issue | Example action | Owner / timing |
|---|---|---|
Extra JPY30,000 ad spend | Review delivery, results and next month's limit | Ad owner / next review |
Unbudgeted event | Confirm period and approval, update forecast | Initiative owner / agreed deadline |
Duplicate tool invoice | Add an invoice-ID check | Operations / before next close |
Unbilled JPY40,000 production | Match the eventual invoice to the recorded cost | Production owner / on receipt |
Do not count the unbilled production again when its invoice arrives. Set deadlines that fit staffing and the close calendar.
Common first-month failures include treating unknowns as zero, mixing payment and recognition dates, counting both media and agency invoices, and overwriting the budget to match actuals. Preserve the original plan and distinguish preliminary, final and corrected versions. A completed close has evidence or an explicit unresolved status for every amount and an action for material differences. Use the ongoing management guide to establish the recurring process.
Related practical guides
Keep budgets and execution connected
Xtrategy supports monthly budget and actual tracking, including variance and spending progress. Define your cost categories and close process first, then evaluate the workflow with a 30-day free trial.
