How to build next year's budget from SAP actuals

Start from a closed year of SAP actuals, remove one-off items, then rebuild each line from drivers such as volume, price and headcount. Spread by month, allocate shared costs, collect input from department heads, approve and lock the version, then track plan against actual every month. LendraBI can start the draft from your SAP actuals and carry it through approval and tracking.

Updated LendraBI by XPL Services

What do you need in place before you start?

You need a closed set of actuals, an agreed budget structure and a calendar. Without these three, every later step turns into rework.

Agree the structure first: which company codes, cost centers and profit centers get a budget, at what level of detail, and in which currency. A cost center collects costs for a department or function. A profit center is a part of the business you measure on profit, such as a branch or a product line. Budget at the same level you report actuals, or plan versus actual will never line up.

Then fix the calendar: when the draft goes out, when department input is due, when finance reviews and when management approves. Share it before you send a single number.

How do you build the budget from SAP actuals, step by step?

Work through the same nine steps every year, in this order. Each step builds on the one before, so skipping one usually means coming back to it later.

  1. Choose the actuals period. Use the last closed fiscal year, or year-to-date actuals plus an estimate for the remaining months if you budget before year-end. Check that you use the same fiscal periods SAP posts to, and include year-end adjustments posted in special periods.
  2. Clean one-offs. Remove items that will not repeat, such as a legal settlement, a gain on selling an asset or a one-time consulting project. Correct postings that landed on the wrong cost center, and note every change so reviewers can follow it.
  3. Set drivers. Rebuild the main lines from what drives them: volume times price for revenue, headcount times cost per person for payroll, and volume for variable costs such as freight. Keep fixed costs such as rent as plain amounts.
  4. Spread by month. Use last year's monthly pattern for seasonal lines, an even spread for fixed costs and specific months for known events, for example an annual license renewal in January or a slower summer.
  5. Allocate shared costs. Spread IT, rent, HR and similar costs to the departments or profit centers that use them, with keys agreed in advance, such as headcount or floor space.
  6. Collect input from department heads. Send each head their own lines with last year's actuals beside the draft. Ask for every change to come with a short reason, and hold the deadline.
  7. Review and approve. Finance consolidates the input, compares it with targets and sends back lines that do not fit. Approval usually moves from department head to finance to management.
  8. Lock the approved version. Freeze it once approved. Later changes go into a separate forecast version, so the original budget stays your baseline.
  9. Compare plan versus actual through the year. Review the variance every month, find out what moved and update the forecast when the business changes.

What mistakes should you avoid?

Most budget problems come from skipped preparation, not from bad arithmetic. Watch for these:

  • Taking last year and adding a flat percentage, which carries last year's one-offs and errors into next year.
  • Allocation keys that were never agreed or change mid-year, which turns every review into a debate about method.
  • Input collected in separate spreadsheets by email, with no record of who changed what or why.
  • Editing the approved budget instead of creating a forecast, which hides the target you committed to.
  • Adding amounts in different currencies into one total instead of converting them at an agreed rate.
A budget is only as useful as your ability to compare it with actuals, at the same level of detail, every month.

How does LendraBI support each step?

LendraBI reads your actuals from SAP and gives you one place to draft the plan, collect input, approve it and lock it. The table shows what you use at each step.

StepWhat you use in LendraBI
Choose the actuals periodStart a budget version from the year of SAP actuals you choose
Clean one-offsReview the draft the planning assistant prepares before you apply it, and comment on the figures you change
Set driversDrivers, plus volume and headcount plans
Spread by monthSpreading by month
Allocate shared costsAllocations
Collect inputExcel in and out, or forms whose approved entries fill the plan
Review and approveMulti-level approval with deadlines and reminders
LockData locks and validation rules
Plan versus actualPlans shown next to actuals on any dashboard

Budget, forecast and what-if versions sit side by side, so you can test a scenario without touching the approved budget. Plan exchange rates can be filled from SAP's standard rates. Comments and the full change history stay with every figure, so at review time you can see who changed a line and why. Department heads who prefer spreadsheets can work in Excel and load the result back. For more on the planning features, see SAP budget planning.

How do you track the budget against actuals during the year?

Put the plan next to actuals on the dashboards people already use, and review the variance every month. In LendraBI any dashboard can show plans next to actuals, with the actuals read from SAP.

  • Variance and waterfall charts show which lines moved the result, for example the steps from budgeted to actual profit.
  • Drill down up to 4 levels to find where a variance sits.
  • "Ask why…" on any chart explains in plain words what moved a figure, a useful start for your variance notes.
  • KPI alerts tell you when a figure crosses a limit you set, and scheduled email reports send the comparison to people in your organization.
  • When the year changes course, update the forecast version and keep the approved budget as the baseline.

The same comparison feeds your monthly management report, and finance leads can read more in SAP reporting for finance teams. To walk through the planning steps in LendraBI, book a demo.

Questions

Can LendraBI start the budget from our SAP actuals?

Yes. You can start a budget version from the SAP actuals of a year you choose, and the planning assistant can draft a version for you to review and apply.

How do department heads send their input?

They can work in Excel and load it back, or fill in a form whose approved entries fill the plan. Comments and the full change history stay with every figure.

Can we reforecast without losing the approved budget?

Yes. Budget, forecast and what-if versions are kept as separate versions, and data locks protect the approved budget from changes.

How are currencies handled in the plan?

Plan exchange rates can be filled from SAP's standard rates, and amounts in different currencies are never added together as they stand.

Does it work with SAP ECC as well as SAP S/4HANA?

Yes. LendraBI supports SAP S/4HANA and SAP ECC 6.0.

Book a demo

See LendraBI on your own SAP figures.

A guided walkthrough with our team, built around the questions your people ask every day.