Accounting, VAT and e-invoicing
Management reporting in ERP is the set of reports a company’s managers use to run the business each month, such as margin by branch, receivables by customer, project cost against budget and stock that has stopped moving. The figures come from the same ledger as the financial statements, but the questions are different. The board asks why gross margin fell two points, not whether the balance sheet balances.
The usual problem in the companies we work with is three versions of the same number. Sales has its own spreadsheet, finance has the trial balance, and the general manager has a dashboard someone built two years ago with definitions nobody remembers. This article covers how to design management reports from the ERP so that everyone reads one number, with a worked variance example.
Management reporting and financial reporting
Financial reporting follows IFRS as endorsed by SOCPA, looks backward over a full period and is written for shareholders, banks, ZATCA and the auditor. Management reporting has no prescribed format. It follows the company’s own structure, by branch, product line, project or salesperson, and it is judged on one test only, whether it helps a manager decide something.
The two meet in one place. IFRS 8, which applies to entities whose debt or equity is traded in a public market, defines operating segments as the components whose results are regularly reviewed by the chief operating decision maker. In other words, a listed company’s segment note is built from its management reports. A company planning to list should design its management structure with that in mind, because changing segments later means restating the comparatives.
Start from the decisions, not from the data
A good management report answers a question someone has to act on. Before building anything, write down who reads the report, what they decide with it and how often. A typical split in a mid-sized trading or contracting company looks like this:
| Reader | Decision | Typical report |
|---|---|---|
| Board and general manager | Direction, funding, pricing policy | Monthly pack: results against budget and last year, cash, key risks |
| Finance manager | Collections, payments, credit | Customer aging, supplier aging, cash forecast |
| Sales manager | Discounts, salesperson targets | Sales and gross profit by salesperson, customer and item |
| Project manager | Cost control, change orders | Budget against actual by job, committed cost, billing |
| Warehouse manager | Reordering, slow stock | Stock aging, items below minimum quantity |
Each level should be able to drill down to the one below, and the bottom level should open the documents themselves. A manager who sees a margin drop and can click through to the invoices with the deepest discounts acts the same day. One who has to ask finance for a breakdown waits a week.
The data behind management reports in ERP
Reports can only cut the data the way it was recorded. Most of the work therefore happens in the setup, long before the first report is designed:
- Account groups decide the lines of the profit and loss. If freight on sales is posted to general expenses, no report can show the true margin by product. The structure is covered in account groups.
- Cost centers carry the branch, department or project on each posting line. A cost center left blank on a journal ends up in an “unallocated” line that grows every month.
- Master data on customers, items and salespeople has to be clean. The same customer created twice splits its sales and its aging.
- Posting discipline decides timing. If supplier invoices for the month are posted on the 20th of the next month, the first management pack always understates cost.
Overhead allocation deserves a decision of its own. Spreading head office cost across branches by sales makes every branch look less profitable and can hide the branch that actually loses money. Many companies report contribution by branch first and show allocated overhead as a separate line below it.
The monthly management pack
The pack should be short enough to read in one sitting and stable enough that readers know where to look. A layout that works for most mid-sized companies:
- One page of commentary, covering what changed this month, why, and what decision is needed.
- Profit and loss against budget and the same month last year, for the month and year to date.
- Gross margin by business line or branch, with the variance explained.
- Cash position, receivables aging and the largest overdue customers, linked to the cash flow forecast.
- Balance sheet movements that matter, such as stock, receivables, payables and borrowings.
- Operational measures that explain the financial results, such as orders, project progress or stock that has not moved.
Every figure in the pack should reconcile to the ledger. If management adjusts a number, for example to exclude a one-off cost, the adjustment is shown on its own line so that the reader can see both figures.
A worked example of variance analysis
A total variance tells a manager that something changed. Splitting it tells them what to do. Take a product line with these hypothetical figures for the month:
| Item | Budget | Actual |
|---|---|---|
| Units sold | 1,000 | 1,100 |
| Average price (SAR) | 50.00 | 47.00 |
| Sales (SAR) | 50,000.00 | 51,700.00 |
Sales are 1,700 riyals above budget, which looks like good news. Split it in two:
- Volume variance: (1,100 − 1,000) × 50 = 5,000 riyals favorable.
- Price variance: (47 − 50) × 1,100 = 3,300 riyals adverse.
The two add back to 1,700 riyals. The sales team sold more by cutting the price by 6%, and if the unit cost did not fall, the gross margin fell with it. The mistake we see most often is reporting only the total, which hides price erosion until the year-end results. The method, with cost variances, is covered in budget variance analysis.
KPIs that keep their meaning
A KPI is only useful if everyone calculates it the same way every month. For each one, write a short definition card and keep it with the pack:
- the formula, with the exact accounts or report fields it uses;
- the source report in the ERP, so that anyone can reproduce it;
- the owner who explains it when it moves;
- the frequency and the target, set by management from the company’s own history and plans.
Days sales outstanding is a good test. Some companies divide receivables by credit sales, others by total sales including VAT, and others by the last three months only. Each gives a different number, and all are defensible. What matters is that the definition does not change between months. Pair lagging measures such as margin and DSO with leading ones such as orders received or quotations issued, which show the result before it reaches the ledger.
Management reporting with Tranquil ERP
Tranquil’s reports come from the same postings as the ledger, so the management figures and the trial balance start from one source. The finance reports include the trial balance with group-wise totals, the balance sheet, comparative and trading profit and loss, cash flow and the cost center report. Customer and supplier reports cover ledgers, outstanding balances, statements and aging.
The operational reports sit beside them. Sales has 29 reports, including profit, salesman analysis and top sales. Inventory reports include valuation, aging, maintain level and stock by warehouse. Project reports include Budget Variance, Estimation vs Actual and Profit Analysis, and production reports compare estimated and actual efficiency and cost by product. Cost centers are kept as a tree and can be set on customer receipts and supplier payments, and the Report Designer sets custom PDF layouts.
The finance module is described on the accounting system page. For groups with several companies, the group view is covered in financial consolidation in ERP.
Frequently asked questions
What is the difference between management reports and financial statements?
Financial statements follow IFRS, cover the whole company and are written for outside readers such as banks, shareholders and the auditor. Management reports have no set format. They follow the company’s own branches, products and projects, are produced monthly or more often, and exist to support internal decisions.
How many KPIs should a management pack have?
There is no correct number. Each reader should see only the measures they can act on, so the board’s page stays short while a sales manager’s report goes into more detail. If a KPI has not led to a question or a decision for several months, take it out of the pack.
Can management reports show different numbers from the accounts?
Yes, but every difference should be visible. Management may exclude one-off items, allocate overhead differently or use its own segments. Each adjustment is shown on a separate line that reconciles back to the ledger, so the reader can always see the reported figure and the management view side by side.
Do we need a separate BI tool for management reporting?
Not at first. Most mid-sized companies get further by cleaning their account groups, cost centers and master data and using the ERP’s own reports. A BI tool helps when data from several systems has to be combined, but it repeats any inconsistency already in the ledger.
