Case Study · Lens · Live Financial Statements
Statements for every brand and branch, straight from Business Central
For a Dubai-based multi-brand F&B group, “where does the business stand today?” used to be a spreadsheet somebody finished two weeks after the month ended: ledger data exported to Excel, every brand- and branch-level view rebuilt by hand, each new cut of the numbers waiting on a specialist. Now a read-only warehouse syncs daily from Business Central, and income statement, balance sheet and cash flow are re-sliced in a click: no export, no rebuild, no specialist to wait for.
Any period, any slice
- Monthly, quarterly, yearly or a custom range; current, vs prior, or month-by-month across the year
- Slice by business group, location or individual outlet
- Income statement, balance sheet and top items all follow the same filters
- Compare to last year side by side; export any view to Excel in one click
See where the revenue comes from
The sales picture the team would otherwise stitch together by hand: channel mix, top sellers and per-brand margin and share, on one screen, driven by the same filters.
Access scoped by brand, location and outlet
With ~125 outlets, distributing the numbers used to be its own monthly job. Instead, each person is granted specific reports, brands, locations and outlets: a regional manager sees their branches, a brand head sees their brand, finance sees it all, without a separate report built and maintained for anyone.
- Grant access by report and feature
- By brand: one brand, several, or all; by location and individual outlet
- Role-based and changeable in seconds
Root cause in an afternoon, not a week
Gross margin down three points this month? Isolate it to one location, rank the outlets to find the one driving it, and land on the cost line: packaging cost up 18%. Group to brand to outlet to cost line in a few clicks, instead of a week of root-cause analysis in Excel.
- Open any brand to its full income statement
- Rank outlets to find the one moving the number
- Margin and cost lines follow all the way down
- A per-entity balance check, so the numbers tie
Accounts payable, without the army
The other half of the engagement: AED 2.8M in aggregator commissions across 1,900+ invoices a year, previously split by hand, now coded, allocated and reconciled by an engine that encodes the company's own accounting rules.
Read the Xtract case study →Secure, and in Your Control
Sign in with Microsoft·Read-only, never writes to Business Central·Runs in your own cloud region·Daily sync, unlimited users
Figures shown for illustration.