SAP reporting for CFOs, controllers and finance teams

Finance teams need SAP figures they can trust at month-end without rebuilding the same Excel exports each time. LendraBI gives CFOs, controllers and finance teams live figures from SAP S/4HANA or SAP ECC for receivables, payables, controlling and budget versus actual, with scheduled reports, KPI alerts and access set by company code.

Updated LendraBI by XPL Services

What do finance teams need from SAP reporting?

Finance teams need figures they can trust, at the level they are responsible for, without exporting and rebuilding them every month. For a CFO that is often the group view. For a country controller it is one company code, and for a credit controller it is the customers who are overdue.

In SAP, a company code is the unit you keep a complete set of accounts for, usually one legal entity, so in a group with companies in the UAE and Saudi Arabia, each company typically has its own. Many finance questions start at that level, then go down to customers, suppliers, cost centers or profit centers.

Here is how common finance tasks compare with exports and with LendraBI:

Finance taskWith exports and spreadsheetsWith LendraBI
Month-end reviewRun reports, export, rebuild pivot tablesAsk in plain words or open the finance dashboards
Overdue receivablesExport open items and sort by customerReceivables dashboards and customer profile pages
PayablesExport and filter by due datePayables dashboards and supplier profile pages
Cost center reviewExport each cost center and compare by handControlling dashboards you can filter by clicking, with "Ask why…" on any chart
Budget versus actualPaste actuals next to the budget filePlans next to actuals on any dashboard
Management reportBuild a pack and email it each monthScheduled email reports, in the email and as a PDF

How does month-end reporting work in LendraBI?

You ask your month-end questions in plain words or open the ready-made finance dashboards, and the figures are read live from SAP when you ask a question or open a dashboard.

Typical month-end questions, as examples:

  • "What was revenue by company code last month, compared with the month before?"
  • "Which customers are overdue, and by how much?"
  • "What do we owe suppliers this month, and to whom?"
  • "Which cost centers spent more this month than last month?"

Each answer comes with the figure, a chart and follow-up questions you can tap. You can pin the chart to a dashboard or download the answer data as CSV.

The 104 ready-made dashboards cover 14 business areas, including finance, receivables, payables, controlling and fixed assets, and they are built on your own data during setup. When a figure moves unexpectedly, "Ask why…" on any chart explains in plain words what moved it, and variance and waterfall charts show how you got from one number to another. Customer and supplier profile pages show sales, open items, payments and trends for one customer or supplier. Amounts in different currencies are never added together as they stand: they are kept apart, or converted at your SAP exchange rates first.

Every amount in an answer is checked against SAP before it is shown. If a figure cannot be backed by SAP, it is left out.

The guide to a monthly management report from SAP covers how to put a monthly pack together.

How do you keep management informed without chasing reports?

Schedule the reports management needs and set KPI alerts on the figures that matter, so information arrives without someone rebuilding it. Scheduled reports go only to people in your organization.

  • Scheduled email reports: the report arrives in the email itself and as a PDF, for example a monthly receivables summary for the CFO.
  • KPI alerts: get told when a figure crosses a limit, such as overdue receivables above a level you set, or when it changes. Limits are checked hourly.
  • What changed: in-app notifications and a "What changed" card show what has moved.
  • Board packs: dashboards export to PowerPoint and charts to Excel, and you can also export to PDF.

On a phone, LendraBI installs on the home screen, so a CFO can check figures or approve entries away from the office with the same sign-in as on desktop.

How does budget versus actual work for finance?

You build budget, forecast and what-if versions from this year's SAP actuals in LendraBI, then show them next to actuals on any dashboard. Plans go through multi-level approval with deadlines and reminders.

The planning assistant drafts a version that you review and apply. Drivers, spreading by month and allocations shape the figures, and plan currencies are filled from SAP exchange rates. Data locks and validation rules protect approved figures, and comments and the full change history stay with every figure. Excel in and out is supported for people who prefer to work in a spreadsheet. More detail is on the SAP budget planning page.

Who can see which company codes and figures?

You decide. LendraBI is private by default, and access profiles limit each person to the business areas and company codes you choose, as well as sales organizations, plants and purchasing organizations.

  • Roles with 21 permissions: built-in Admin, Editor and Viewer roles, plus custom roles and groups.
  • Optionally, each person signs in with their own SAP user so their SAP authorizations apply.
  • Authenticator-app two-step sign-in, session control and lockout after failed attempts.
  • Passwords, tokens and connection details encrypted at rest.
  • A searchable activity log of every sign-in, share and admin change.
  • An Excel export of who can open what, which is useful for access reviews.

For example, a controller in Saudi Arabia can be limited to the Saudi company code, while the group CFO sees all of them. The guide on how to control who sees SAP figures goes into more detail. To see how this would look for your finance team, book a demo.

Questions

Can each accountant see only their own company code?

Yes. Access profiles limit people to the business areas and company codes you choose. Optionally, each person signs in with their own SAP user so their SAP authorizations apply.

Can management receive a monthly report by email?

Yes. Scheduled email reports arrive in the email itself and as a PDF, and they go only to people in your organization.

How does LendraBI handle several currencies?

Amounts in different currencies are never added together as they stand: they are kept apart, or converted at your SAP exchange rates first.

Is there a record of who changed what?

Yes. A searchable activity log records every sign-in, share and admin change, and comments and the full change history stay with every plan figure. You can also export who can open what to Excel.

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

Yes. LendraBI works with 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.