All projects05 / 05Trading and production, several legal entities
The owner sees cash, profit and
plan vs actual in one window
SummaryRevenue, margin, cash and the cash gap for 30 days, actuals against plan by month, and what needs attention.
Context
A company of 10–300 people keeps its books in an ERP, often in several databases, while the plan lives in the owner's spreadsheet. There is no CFO on staff: the report is put together by an accountant, a manager or the owner. The business is one, but it has several legal entities, bank accounts, cash desks and marketplace seller accounts.
Constraints
- The report as a ritualEvery week a manager or an accountant pulls together figures from the ERP, the bank, the CRM and spreadsheets, formulas break, and the report arrives when it is too late to decide.
- Breakdowns only through a developerSales by sales manager and channel with margin meant a request to the ERP developer and a change to a configuration that must not be touched.
- The figures do not matchThe bank, the cash desk and the ERP disagree, and no one is responsible for sorting it out.
How it was
Each source was correct in its own way, but the overall report was put together by hand and after the period had closed. No one saw the discrepancies between the bank and the ERP until they surfaced in the report.
Hypothesis
If data from the ERP, the bank, the CRM and the plan spreadsheet is collected on a schedule into one data store with unified reference data, and each discrepancy immediately gets a person responsible, the owner sees cash, profit and plan vs actual on time, and the ERP stays untouched.
Operation model
A figure is calculated the same way for the screen, the summary, the export and the assistant, so the reports do not contradict one another. Whatever was not allocated to a line item is sorted out by the accountant once; after that the platform does it on its own.
Interface
Owner's Summary
Revenue, margin, cash and the cash gap for 30 days, actuals against plan by month, and what needs attention.
- 1Metrics with deviation from plan and from last month
- 2The plan from the owner's spreadsheet next to actuals
- 3Needs attention: cash gap, channel margin, receivables, discrepancies
- 4Assistant's conclusion with a link to the query
Cash balance for 30 days of actuals and 30 days ahead: a cash gap is visible in advance, and every payment has a source.
- 1Minimum balance and cash gap date
- 2Cash gap point on the chart
- 3Payment source: plan spreadsheet, e-invoicing, history
The plan from the owner's spreadsheet against actuals from the ERP, the CRM, the marketplace and the bank, adjusted for the month's pace.
- 1Deviation from the month's pace
- 2Sales managers and channels vs plan
- 3Cash flow budget by line item
Reconciliation after every data load: bank and ERP; cash desk, POS and ERP; CRM invoices, e-invoicing delivery notes and payments. Each discrepancy has a person responsible and a due date.
- 1Three reconciliations and what matched on its own
- 2Person responsible for the discrepancy
- 3Status and days in progress
The answer to a question asked in plain words is built only from company data: the table, period and sources are shown, and there are no recommendations or forecasts.
- 1The owner's questions
- 2Answer as a table from the data
- 3How the answer was obtained
- 4Period, sources and data date
The same summary on the phone; on Mondays at 8:00 it arrives in Telegram as text and a PDF.
Project gallery: screens and close-ups
A click opens the screen full size.
Specification for the technical team
What the product does and what it works with. How the platform is built is disclosed during the audit.
- Sources
- Read-only: nothing is changed or customized in the ERP, the bank or other systems.
- Reports
- Cash flow, P&L, payment calendar, plan vs actual, receivables, margin by channel; a figure is the same on the screen, in the summary and in the export.
- Assistant
- It answers only from company data and shows where the answer comes from; it gives no recommendations or forecasts.
- Delivery
- A web screen, a Monday summary in Telegram and by email, an xlsx export in the familiar layout.
- Hosting
- Cloud or the client's own infrastructure.
What changed in how the operation runs
The changes are described qualitatively. Figures are published once the client approves them.
- 01One screenCash, profit and plan vs actual across all legal entities, accounts and channels are in one window and on a schedule.
- 02Automatic summaryThe weekly report for the manager is assembled by 8:00 on Monday with no manual consolidation.
- 03Discrepancies with a person responsibleDiscrepancies between the bank, the cash desk, the CRM and the ERP are visible right away, not at the end of the month.
Metrics
- Time spent on the weekly reporttracked
- Days from period end to reporttracked
- Open discrepancies older than a weektracked
- Breakdowns without ERP customizationtracked