Excel to Power BI migration in Dubai — keep the numbers, lose the manual work
For finance teams in Dubai and the UAE whose month-end and management reporting has outgrown a workbook. Audited, built in phases, run in parallel against your existing close, and quoted at a fixed price before work starts.
The starting point is usually the same: a master workbook with links to a dozen exports, a macro somebody wrote years ago, a sheet called “Adjustments” and one person who understands it. It produces the board pack, the entity P&Ls and the VAT workings, a few days later each month than anyone would like.
A migration moves the consolidation, the KPI logic, the history and the distribution out of that workbook and into a Power BI model that reads your finance system directly. Excel stays for budget input, journal templates and ad hoc analysis. If you would rather keep the workbook and remove the manual steps from it, that is a different service: Excel reporting automation. Delivered in partnership with Roar Data, an Australian Power BI consultancy.
Signs it is time
Five symptoms. Two of them is usually enough; four means the workbook is already the bottleneck.
Month-end takes days because of consolidation, not accounting
The ledgers close on time. The days after go on pulling exports from each entity, pasting them into the master, fixing broken links and re-checking totals.
Two versions of the same KPI
Gross margin in the board pack does not match gross margin in the sales review, because two people built two formulas from two exports. Both are defended in the meeting.
A workbook past the point of safety
Tens of megabytes, links to files that have moved, a macro nobody will edit, and calculation set to manual because automatic takes too long. It opens, most of the time.
The VAT return is prepared by re-keying
Output and input tax by supply type are assembled in a separate sheet from figures typed in from the ledger, and reconciled to the return by hand each quarter.
One person holds it together
The workbook works because one accountant knows where the plugs are. When they are on leave, reporting waits. When they resign, it stops.
What stays in Excel and what moves
The migration is not a ban on spreadsheets. It is a decision about which jobs a spreadsheet should be doing.
| Stays in Excel | Moves to Power BI | Goes |
|---|---|---|
| Budget and forecast input templates | Consolidation across entities and systems | Macros that replicate extract-transform-load by hand |
| Journal and upload templates for the finance system | KPI logic: one definition per measure, applied everywhere | Copy-and-paste steps between exports and the master |
| Ad hoc analysis and one-off investigations | Distribution: the pack, the entity P&Ls, the weekly flash | External links to files on someone’s desktop |
| Pivot tables over the governed model (Analyze in Excel) | History: every close retained, comparable periods available | Plug lines and silent manual adjustments |
| Working papers for the auditor | VAT and payroll reconciliations by entity and period | The version of the file with “FINAL v3 (2)” in its name |
The workbook audit (week one)
Nothing is quoted or built until the workbook has been read. The audit is the first week of every migration and it produces the migration map the fixed quote is written against.
Inventory. Every workbook, external link and data connection in the reporting chain is listed, so the chain from finance system to board pack is drawn end to end. Most chains are longer than anyone remembered.
Classification. Each sheet is classified as source (an export or a paste), logic (formulas) or presentation (the page someone reads). Source sheets become connections, logic sheets become measures, presentation sheets become report pages.
Measure extraction. Every figure in a report is traced to its formula and written into a measure list with a plain-English definition and a named owner. This is where “gross margin” turns out to have three definitions, and the owner chooses one.
Hidden rules. Manual adjustments, plug lines and hard-coded numbers are found and attributed. Some are legitimate business rules nobody wrote down; they are written down now and become either logic in the model or an input the owner controls.
Migration map. The output is a map of what moves, what stays, what is retired and in which phase, with the open decisions listed. You sign it off; the scope and quote follow from it. The checklist alongside is the one we work through.
Phased migration
Five phases, each with a defined output. The parallel run is the one we will not shorten: it is where the numbers earn trust.
Phase 0 — Workbook audit
Phase 1 — Sources and model
Phase 2 — Parallel run
Phase 3 — Switch and retire
Phase 4 — Training and support
How long each phase takes depends on the shape of your business: a single entity on one finance system is a short migration; a group on several systems with intercompany eliminations is a longer one. The audit produces a phase plan against your own close calendar, and that plan is what we quote.
UAE finance specifics we build in
A finance model built for the UAE has to carry a few things a generic template does not. These are explanatory notes on how the model handles them; we are not tax agents, auditors or lawyers, and questions of treatment go to yours.
VAT
Each transaction is classified by supply type: standard-rated, zero-rated, exempt and out-of-scope, with reverse-charge imports and designated-zone movements flagged where your system records them. Output and input tax become measures by supply type, period and VAT registration or tax group, so the dashboard reconciles to the return filed to the Federal Tax Authority. The dashboard does not prepare or file the return.
Corporate Tax readiness
The model keeps a P&L per legal entity, not only per group, because Corporate Tax for financial years starting on or after 1 June 2023 is assessed at entity level. Where an entity is a free-zone person, income from activities you have identified as qualifying can be tagged and seen on its own. The model tags what you tell it to; whether income qualifies is a question for your tax adviser.
Multi-entity, multi-currency
Mainland and free-zone entities, branches and cost centres sit in one entity dimension with their type, base currency and registration. Intercompany transactions are tagged at source so eliminations are a measure rather than a manual journal. Every transaction keeps its original currency alongside its AED value. The dirham’s peg makes USD simple; EUR, CNY, INR and the GCC currencies take an FX rate from a stated source, so the conversion is explainable.
WPS and payroll
Payroll cost in the ledger is reconciled to the Wage Protection System SIF totals by entity and month, so a gap between what was booked and what was paid shows up as a number rather than a surprise. Headcount and cost per head follow from the same tables.
Post-dated cheques and receivables
Trading businesses in the UAE run on post-dated cheques, and a receivables ageing that ignores them overstates the risk. PDC on hand, PDC due by week and PDC returned are first-class measures alongside conventional debtor ageing, so cash forecasting sees what is actually in the drawer.
Calendar and seasonality
The calendar table carries your fiscal year and close periods, plus Ramadan, Eid and summer flags, so a comparable-period measure can shift or exclude those weeks rather than comparing a Ramadan month with a normal one. For tourism and hospitality, the October-to-April peak is a flag too. The phased rollout of e-invoicing in the UAE is one more reason to clean customer and supplier master data while the migration is already touching it.
From your finance system, not around it
The model reads the finance system directly rather than the exports that feed the workbook. How depends on the system.
Tally / TallyPrime
Zoho Books
Odoo
SAP Business One
Dynamics 365 Business Central
Oracle NetSuite
QuickBooks and Xero
Sales, stock and payroll systems join the finance system in the same model. For a trading business that usually means a point-of-sale or marketplace feed alongside the ledger; our retail and trade page describes that shape.
Messy data is normal
Cleaning happens in the model, not in the source, unless you choose to clean the source. What we need from you is decisions: which record is the master, which old account maps to which new one, which adjustment was a rule and which was a fix. The audit lists them; you make each once; the mappings carry it forward.
Inconsistent customer and supplier names are handled with a mapping table you own: three spellings map to one master, in a sheet you can edit. Duplicate SKUs get the same treatment. Cost centres used differently across entities are mapped to a common reporting structure without changing the source system.
A chart of accounts that changed mid-year is the common hard case. The model carries both structures with a mapping from old to new, so the year reports on either basis and the prior-year comparison holds. The mapping is signed off, because it is a decision about how the business reports, not a technical setting.
What you own at the end
Everything is built in your tenant and handed to a named owner on your team. Nothing sits with us that you would need to ask for back.
If the owner needs more than a handover session, Power BI training in Dubai runs on your own model. If you would rather not carry it in-house, Power BI managed services keeps it running on a fixed monthly fee. For KPI definitions and governance ahead of a build, see Power BI consulting in Dubai.
See a finance demo
A finance report set built the way this page describes.
Look at three things: the P&L page keeps every measure’s definition as you switch between entities and consolidate; the comparable-period toggle shifts the prior-year comparison for the Ramadan weeks rather than comparing unlike months; and the ageing page carries post-dated cheques as their own buckets beside conventional debtor ageing.
Excel to Power BI migration — questions finance teams ask
Plain answers to the questions we are asked before a migration is scoped.
Can Power BI replace our manual Excel reports?
How long does an Excel to Power BI migration take?
Will the numbers match Excel?
Our data is messy. Is that a problem?
Can it handle multi-entity and multi-currency?
Can it help with VAT and Corporate Tax reporting?
Do we lose Excel?
Who maintains it afterwards?
Related reading: CFO dashboards in Power BI and automating board reporting with Power BI.
How fixed pricing works
The method comes first because it is what moves the number. The diagnostic is a fixed price; a migration is quoted against a written scope.
A short discovery call, no charge
Thirty minutes on how month-end runs today, and a look at the workbook, its reports and the systems behind it.
The audit and a written scope
The workbook audit produces the migration map; the scope names sources, model, pages, users, security, parallel-run closes, training and handover.
A fixed quote against that scope
The quote is the price. It does not move because a source turned out harder than it looked.
Inside scope is our cost; outside scope is quoted first
Something worse than expected inside the scope is ours to absorb. Something outside it, such as a new entity or a second pack, is quoted separately before we do it.
Payment stages
Agreed in the scope document before work starts.
The reporting diagnostic is a fixed AED 4,950. That is the whole amount. Nothing is added at checkout. It reviews the workbook, the reports around it and the systems underneath, and returns a written plan for what to move first.
The migration itself is quoted rather than sold from a page. Builds start at AED 15,500 and most land in the AED 15,500 to AED 62,000 range, moved by the number of ERP and source systems, how much of the workbook logic has to be rebuilt as a model, the entities and pages in scope and how many closes are run in parallel. Your written quote carries the figure that applies to your workbook.
Ready to take month-end out of the workbook?
Answer four quick questions and book a time. Bring the master workbook, or a description of it, and we will tell you what the audit would find first.