Budget Adjustment Techniques

Budgeting season starts and someone says "let's just add 3% across the board." Then someone else pushes back: "no, this year we justify every line from scratch." Both are about to make the process harder than it needs to be. The problem is rarely Excel skills. It's using one technique for every line item, when different costs call for different methods. I've led 11 annual budgeting processes at P&G, Unilever, and Squarespace. Here's how I decide which technique goes where. 📌 𝗣𝗲𝗿𝗰𝗲𝗻𝘁𝗮𝗴𝗲 𝗮𝗱𝗷𝘂𝘀𝘁𝗺𝗲𝗻𝘁𝘀 (use sparingly) Best for stable, predictable costs like rent, insurance, and utilities. Take last year's number, adjust for inflation or any known change, and move on. It's fast. But the trap is using it everywhere. It's shallow, takes historicals for granted, and it rewards sandbagging. People spend money on unnecessary things at year-end so their baseline stays high for next year. 📌 𝗭𝗲𝗿𝗼-𝗯𝗮𝘀𝗲𝗱 𝗯𝘂𝗱𝗴𝗲𝘁𝗶𝗻𝗴 (use selectively) Best for discretionary spend like marketing, consulting, and T&E. You justify every dollar from zero. That's how you find the 20% of activities driving 80% of the results. The cost is time. Run it on stable line items, and you'll burn hundreds of hours for almost no payoff, so save it for the spend that's actually worth interrogating. 📌 𝗗𝗿𝗶𝘃𝗲𝗿-𝗯𝗮𝘀𝗲𝗱 𝗽𝗹𝗮𝗻𝗻𝗶𝗻𝗴 (use wherever you can) Best for revenue and any variable cost tied to a business driver. You link inputs to outputs. When your model says 10% more site visitors means X more revenue, you're ready when actuals come in differently. And they always do. You already know which lever to pull. What it needs is data. You have to know the real relationship between the driver and the outcome. That's what brings you closer to the business and strategic decisions. So the call is simple, even if the work isn't. Match the technique to the cost. Stable costs only need a percentage bump. Use zero-based scrutiny for discretionary spend where you know there is fat to trim. And anything that moves with a business driver should be modeled as one. Which technique does your company overuse? Tell me below 👇 -Christian Wattig 📌 P.S. A forecasting method I haven't mentioned: 𝗨𝘀𝗶𝗻𝗴 𝗔𝗜. I'll cover that in-depth at my upcoming free live training. You'll walk away with a step-by-step process not only to create a forecast with AI, but also to test its validity. Register here for "From ERP Data to AI-Ready Forecasts" (free): https://lnkd.in/gN_HyMqJ

Most budget debates sound like this: Let’s put $100K into Channel X because last quarter ROI looked solid. Translation: You’re gambling on a single point estimate. I introduce confidence bands, an idea borrowed from finance, to make marketing spend a calculated risk, not roulette. How it works: 1️⃣ Model Return Distribution: ↳ Take the last 12 months of channel ROI. ↳ Build a simple 80 % confidence interval (CI). ↳ GA4 + BigQuery make this a two‑line SQL script. 2️⃣ Assign Risk Tiers: ↳ Channels with narrow CIs = predictable (low risk). ↳ Wide CIs = volatile (high risk). ↳ Create three tiers: Core. Growth. Experimental. 3️⃣ Allocate by Risk Appetite: ↳ Core gets stable funding. ↳ Growth receives incremental budget as long as ROI stays within band. ↳ Experimental gets capped spend, think venture bets with predefined exit rules. Result: Budgets adjust automatically to performance volatility, not politics. One e‑commerce client reallocated 15 % of ad spend from volatile display ads to a stable influencer program and saw a 26 % lift in blended ROAS, no additional dollars required. Executives love it because it turns marketing magic into disciplined portfolio management. Which risk tier currently eats most of your budget? A) Core (predictable) B) Growth (moderate risk) C) Experimental (high risk)

Your ERP’s “budget vs. actuals” report is lying to you. I learned this the hard way — on a Tuesday night, staring at numbers that wouldn’t reconcile. The report showed we were overspending. My #Excel model said otherwise. Cue the late-night panic spiral. Here’s the truth: most #ERP budget reports are blunt instruments. They don’t handle timing, reclasses, or shared costs well. Which means FP&A ends up doing detective work that feels more like chasing shadows. It’s like relying on a bathroom scale that doesn’t adjust for the fact you’re holding a backpack. The number is real, but it’s not telling the real story. So what’s the fix? Build a reconciliation bridge: Step 1. Export ERP actuals at the transaction level — not just the summary P&L. Step 2. Map them against your budget drivers in Excel (think cost centers, headcount, timing). Step 3. Use SUMIFS to roll data into your #budget structure. Formula looks like this: =SUMIFS(Actuals!$D:$D, Actuals!$A:$A, $A2, Actuals!$B:$B, $B2) Step 4. Add a column for “reclass” so you can track adjustments transparently. The common mistake? Teams compare ERP actuals to budget line-for-line without reclassing or adjusting timing. That mismatch is what sparks false alarms. Do it right, and suddenly the numbers stop fighting each other. They start telling the same story. And yes — you’ll sleep better on Tuesday nights. Without the backpack.

Budgeting ≠ Cutting down expenses Instead, it is about making smarter financial decisions that fuel growth, whether for your finances or business. But did you know there are different ways to build a budget? Here are four methods and when to use them:  → Incremental Budgeting –  This is the simplest and most common budgeting method. It works by taking last year’s budget and adjusting it slightly based on expected changes (inflation, growth, cost increases).  → Activity-Based Budgeting (ABB) - Instead of just tweaking last year’s numbers, ABB starts from scratch and links every cost to a specific business activity. It helps businesses optimize spending by understanding what truly drives costs.  → Value Proposition Budgeting – This method ensures every budget item contributes to the company’s value proposition. If an expense doesn’t add value to customers, employees, or stakeholders, it’s questioned or cut.  → Zero-Based Budgeting (ZBB) - ZBB requires every expense to be justified from scratch, rather than assuming past expenses should continue. It’s a powerful way to eliminate inefficiencies and ensure spending aligns with strategic goals.  Each approach has its pros and cons and the best method depends on your goals and business model. Some companies even use a mix of these methods for different departments.  Have you tried any of these methods? #personalfinance

𝗛𝗲𝗿𝗲’𝘀 𝘄𝗵𝘆 𝘆𝗼𝘂𝗿 𝗯𝘂𝗱𝗴𝗲𝘁 𝗽𝗹𝗮𝗻𝗻𝗶𝗻𝗴 𝗺𝗶𝗴𝗵𝘁 𝘀𝗹𝗼𝘄 𝗱𝗼𝘄𝗻 𝘆𝗼𝘂𝗿 𝗺𝗮𝗿𝗸𝗲𝘁𝗶𝗻𝗴 𝘀𝘁𝗿𝗮𝘁𝗲𝗴𝘆 💥 Traditionally, companies plan fixed annual budgets, allocate these to existing channels and only make slight changes throughout the year. ⚙ In today’s fast paced world this approach can often be very misleading. 🚨 Agile budgeting refers to continuously reviewing and adjusting budgets based on data to be more responsive and shift focus to best performing channels. ✅ 𝗛𝗼𝘄 𝘁𝗼 𝗶𝗺𝗽𝗹𝗲𝗺𝗲𝗻𝘁 𝗮𝗴𝗶𝗹𝗲 𝗯𝘂𝗱𝗴𝗲𝘁𝗶𝗻𝗴 𝗶𝗻 𝘆𝗼𝘂𝗿 𝗺𝗮𝗿𝗸𝗲𝘁𝗶𝗻𝗴 𝘀𝘁𝗿𝗮𝘁𝗲𝗴𝘆: ♻ Shorter Planning Cycles: Break down annual plans into quarterly or even monthly budgets, giving you more flexibility. 📊 Real-Time Tracking: Set up analytics dashboards and reporting tools to track key performance indicators (KPIs) for each campaign and channel. 🔎 Iterative Reviews: Regularly review budgeting with your team (weekly or bi-weekly). Discuss campaign performance and be ready to shift funds. 🌱 Embrace Flexibility: Be comfortable with the idea that your initial plan might change. Prioritize making adjustments based on data, rather than sticking to a rigid budget. 🔀 Cross-Functional Alignment: Work closely with finance teams to understand any constraints and ensure processes support nimble budget adjustments. What's your approach to budget planning? Let me know in the comments. 💬 - - - 🔔 Want to read more? Follow me Maximilian for regular posts and updates on #digitalmarketing, #lifeatgoogle and #career in tech.