Projects

All projects05 / 05Trading and production, several legal entities

The owner sees cash, profit and
plan vs actual in one window

An operations layer on top of the ERP, the bank, the CRM, marketplaces and the plan spreadsheet: cash flow, P&L, the payment calendar and plan vs actual for the whole business are assembled automatically on a schedule, discrepancies between sources are visible together with the person responsible, and on Mondays at 8:00 the summary arrives in Telegram. The ERP stays untouched.

Business
Several legal entities, bank accounts, cash desks and marketplace seller accounts
Roles
Owner, accountant-analyst, heads of sales
Sources
ERP, bank, CRM, marketplaces, e-invoicing, plan spreadsheet
ERP
Read-only, no customization

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.

ERP exportfor each legal entity
Bank statementsby hand
Plan spreadsheetkept by the owner
Excel consolidationformulas break
Report to the managerafter the month closes
Ask the ERP developera new breakdown takes a week
the figures divergeOwner's Summary
01Sourcesread-only, on a schedule
02Unified reference dataline items, legal entities, channels
03Business dataactuals, plan, history
04Reconciliationdiscrepancies go to the person responsible
05Reportscash flow, P&L, calendar, plan vs actual
06SummaryMonday, 8:00
07Assistantanswers only by querying the data

Interface

Owner's Summary

  1. Revenue, margin, cash and the cash gap for 30 days, actuals against plan by month, and what needs attention.

    1. 1Metrics with deviation from plan and from last month
    2. 2The plan from the owner's spreadsheet next to actuals
    3. 3Needs attention: cash gap, channel margin, receivables, discrepancies
    4. 4Assistant's conclusion with a link to the query
  2. Cash balance for 30 days of actuals and 30 days ahead: a cash gap is visible in advance, and every payment has a source.

    1. 1Minimum balance and cash gap date
    2. 2Cash gap point on the chart
    3. 3Payment source: plan spreadsheet, e-invoicing, history
  3. 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.

    1. 1Deviation from the month's pace
    2. 2Sales managers and channels vs plan
    3. 3Cash flow budget by line item
  4. 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.

    1. 1Three reconciliations and what matched on its own
    2. 2Person responsible for the discrepancy
    3. 3Status and days in progress
  5. 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.

    1. 1The owner's questions
    2. 2Answer as a table from the data
    3. 3How the answer was obtained
    4. 4Period, sources and data date
  6. The same summary on the phone; on Mondays at 8:00 it arrives in Telegram as text and a PDF.

Specification for the technical team

What the product does and what it works with. How the platform is built is disclosed during the audit.

Data sourcesERPBanksCRM and marketplacesE-invoicing and cash registersPlan spreadsheet
Operations layerScheduled collectionUnified reference dataSource reconciliationReports
Roles and devicesOwnerAccountant-analystManagersTelegram and PDF
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

AI in the workspace

The assistant answers from company data, while the decision stays with a person

In two portfolio projects, the workspace is complemented by an assistant. It answers in plain words using only company data, shows the source of the answer and changes nothing without the employee.

AssistantOwner's Summary

Why is the margin lower in March than in February?

The March margin is 31.5% versus 33.4% in February. The biggest change is at Marketplace test: commission and logistics went up. Below are the P&L lines where the change is more than 0.5 pp.
  • P&L · March and February
  • Shipments by marketplace
  • ERP · cost of goods
The employee checks the answer and decides what to do next
  1. 01Company data onlyThe answer is built by querying the company's business systems that the employee already has access to.
  2. 02The source is visibleBelow the answer are the table, period and source, and any figure can be opened.
  3. 03No actions on its ownThe assistant does not change data or message clients; the employee makes the decision.
The assistant in the Owner's Summary project