How to build the monthly management report from SAP

A good monthly pack shows profit and loss against budget and last year, cash and receivables, sales by customer, product and region, purchasing and inventory, and a few KPIs with commentary. Produce it on a fixed timeline after the close, in the same layout every month. In LendraBI you build the pack once as a dashboard and schedule it by email.

Updated LendraBI by XPL Services

What should a monthly management report contain?

A good pack answers the same five questions every month: are we on plan, are customers paying, where are sales coming from, are we buying and holding the right stock, and what needs action. Give each block its own page, in the same order every month.

BlockKey figuresQuestion it answers
Profit and lossRevenue, gross margin, operating costs and profit against budget and last yearAre we on plan, and if not, why?
Cash and receivablesCash position, receivables by age, largest overdue customersAre customers paying on time?
SalesSales by customer, product and region against planWhere is growth or decline coming from?
Purchasing and inventorySpend by supplier, open purchase orders, stock value, slow-moving stockAre we buying and holding the right things?
KPIs and commentaryA handful of agreed KPIs, each with a short noteWhat do we do next month?

Put a one-page summary in front with the headline figures and the three or four points management must discuss. If your group has several company codes, show the group view first, then each company code on the same layout.

What is a repeatable month-end process for the report?

Fix the steps, the owners and the working days, and run the same calendar every month. For example, you might close on working days 1 to 3, check and refresh on day 4, write commentary on day 5 and send on day 6.

  1. Close the period in SAP. Post accruals, depreciation and intercompany entries, then close the period so the figures stop moving.
  2. Check the figures. Reconcile the profit and loss and the balance sheet to the general ledger, receivables to customer balances, and stock values to the inventory accounts in the general ledger.
  3. Refresh the pack. Update every page to the closed period without changing the layout.
  4. Explain the variances. Agree in advance which variances need an explanation, for example any line off budget by more than a set amount, and ask each owner to explain their lines.
  5. Write the commentary. For each block, say what happened, why and what happens next. Do not restate figures the reader can already see.
  6. Review and sign off. The finance lead checks the pack and the commentary against the figures.
  7. Send and archive. Send the pack to the agreed list and keep a PDF copy as the record for the month.

What mistakes make the monthly pack hard to trust?

Most trust problems come from inconsistency, not from wrong arithmetic. Watch for these:

  • Pulling figures before the period is closed, then sending a corrected version later.
  • Different totals in different sections because each came from a separate export.
  • A layout that changes every month, so readers cannot compare.
  • Commentary that repeats the table instead of explaining it.
  • No comparison with last year, so normal seasonality looks like a problem.
  • Adding amounts in different currencies into one total.
  • Too many pages, with the important points buried in detail.
Readers trust a pack that ties to the general ledger and looks the same every month. Consistency matters more than design.

How do you build the pack once in LendraBI?

In LendraBI you build the pack once as a dashboard with several pages, one per block, and reuse it every month. Figures are read from SAP when someone opens it, so nobody rebuilds the pack by hand.

  • Start from ready-made dashboards. LendraBI has 104 ready-made dashboards in 14 business areas, including executive overviews, finance, receivables, sales, purchasing and inventory. Or describe the pack you want: the assistant proposes filters, KPIs and charts, you tick, untick or rename, then press Build.
  • Show plan next to actual. Plans can sit next to actuals on any dashboard, so the budget comparison is on the same page. See building next year's budget from SAP actuals.
  • Use variance and waterfall charts to show what moved profit between budget and actual.
  • Drill down up to 4 levels, for example from region to customer to product, to find where a variance sits.
  • Use report tables for the detail pages, and saved views for each company code.
  • Keep currencies apart. Different currencies are never added together; where one total is needed, they are converted at your SAP rates.

How does LendraBI help with commentary and distribution?

"Ask why…" gives you a first explanation to build the commentary on, and scheduled email reports send the pack. Your team still writes and signs off the final words.

  • "Ask why…" on any chart explains in plain words what moved a figure. Use it as a starting point, then add the context only your team knows.
  • Scheduled email reports send the figures in the email and as a PDF, only to people in your organization.
  • Export to PowerPoint when the board wants slides, export charts to Excel, or save a PDF for the archive.
  • Customer profile pages show sales, open items, payments and trends when management asks about a large overdue customer.
  • English or Arabic. Each person chooses their language, and your own dashboard titles can be in Arabic.

Finance leads can read more in SAP reporting for finance teams, and alerts between month-ends are covered in KPI alerts and scheduled reports. To talk through your own monthly pack, book a demo.

Questions

Can LendraBI export the monthly pack to PowerPoint?

Yes. You can export dashboards to PowerPoint, charts to Excel, and save as PDF.

Can the pack be sent by email every month?

Yes. A scheduled email report sends the figures in the email and as a PDF to people in your organization.

Does LendraBI write the commentary?

It gives you a starting point. "Ask why…" on any chart explains in plain words what moved a figure, and your team adds the context and signs off the final text.

Can the report show budget versus actual?

Yes. Plans can be shown next to actuals on any dashboard, with variance and waterfall charts to explain the gap.

Can the pack be in Arabic?

Each person chooses English or Arabic. In Arabic the whole app runs right to left, and your own dashboard titles can be in Arabic.

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.