One question about the group's cash, and four companies' books to answer it.
One view of a group across SAP, Dynamics, Odoo and spreadsheets
A family holding (example): Trading on SAP S/4HANA, Contracting on Dynamics 365, Restaurants on Foodics and Odoo, Property on a spreadsheet.Before and after
Asked on Sunday, answered on Thursday
Finance adds four exports by hand, and the plain sum is wrong: one transfer sits in two companies, a deposit at the bank is not yet in the books, and payroll and VAT are not set aside.
One number, each part open to its source
At 09:41 there is one figure for group cash and one for what is free to spend. Every adjustment shows its lines, every figure opens down to the account it came from, and the bank files and the books agree.
- Four ledgers, added as they are
- 35,792,290
- Counted twice: TRF-3081
- −1,500,000
- At the bank, not yet in Odoo
- +186,410
- Group cash
- 34,478,700
- Free to spend, after 2,967,600 committed
- 31,511,100
What it reads, writes and never touches
- Pairs transfers between companies by reference
- Proposes bank matches; finance confirms
- Sets aside what is already committed
Cash accounts in four ledgers, the property sheet, payroll runs, VAT accounts and the banks' statement files
Nothing to any ledger. Proposed bank matches are saved in the group view for finance to confirm.
Postings, transfers or edits in any company's system.
How it works, step by step
- 109:41:02 · demo time
Read each ledger, with its age
Each company's cash is read from its own system. A figure that is not live says so: the property sheet was last saved at 23:00 yesterday. Added as they are, they make the wrong number.
Read from each ledger- Trading · SAP
- 19,920,300, read 09:41:02
- Property · sheet, row 14
- 5,650,000, saved yesterday 23:00
- Contracting · Dynamics 365
- 7,905,110, read 09:41:02
- Restaurants · Odoo
- 2,316,880, read 09:41:02
- 209:41:03 · demo time
Count transfers once, match the bank
A transfer between companies is paired by its reference and counted once. Then the 06:00 bank files are set against the books, line by line, until the two agree.
Transfers and bank lines- TRF-3081
- still in Trading's books, received in Property's sheet: −1,500,000
- Bank files 06:00 vs books
- 35,085,300 vs 34,292,290: 793,010 across the 3 lines below
- Foodics deposit · Restaurants
- at the bank since Saturday, not yet in Odoo: +186,410
- Cheque 004417 · Contracting
- in Dynamics, not yet cleared: 212,500
- Payroll · Restaurants
- in Odoo at 07:30, after the 06:00 file: 394,100
- 309:41:04 · demo time
Set aside what is committed
Cash is not free to spend if payroll, VAT or a bank guarantee already has a claim on it. Those are set aside before the answer is given.
What is set aside- Payroll, Thursday · Trading, Contracting
- 1,465,000, from payroll runs in SAP and Dynamics
- VAT return due
- 742,600, from VAT accounts in the four ledgers
- Guarantee margin · Contracting
- 760,000, held by the bank, in its 06:00 file
Rules you set
Values are examples from the demo
Connect or build
Connect to yours
The demo reads SAP S/4HANA, Dynamics 365, Foodics and Odoo through their APIs with read-only users, a spreadsheet when it is saved, and bank statement files as they arrive.
Or we build it
If one company has no system worth reading, we build it one.
The questions that decide it
Does it change our systems?
No. It only reads, through one read-only account per system that your IT can revoke.
What if one system is down?
As in the demo, it uses that system's last good read and says how old it is. The number never shows a guess as live.
How current is the number?
Each part shows its own time. In the demo at 09:41, the ledgers are read live, the bank side comes from that morning's 06:00 statement files, and the property sheet counts as of its last save.
Does it change our systems?
No. It only reads, through one read-only account per system, and every read is logged and can be revoked.
What if one system is down?
As in the demo, it uses that system's last good read and says how old it is. The number never shows a guess as live.
How are transfers between our companies counted?
Each transfer is paired by its reference. If both companies show it, it counts once; if it has left one and not reached the other, it counts once as in transit. It is never counted twice or lost.
Do we need a new ERP?
No. It reads the systems you have, even a spreadsheet. If one company has no system worth reading, we can build it one.
Is this a real group?
No. The group and its figures are an example, and every system in the demo is simulated.