Introduction
When ERP is mentioned in the African public sector, reactions are often the same: "it's for large companies," "it's too expensive," "we already have SIGFIP." These objections are understandable. They are also, in many cases, a symptom of a deeper problem: the absence of an integrated management system that enables a public organisation to know, in real time, where its money is going, who is doing what, and whether commitments are being met.
To illustrate what Microsoft Dynamics 365 Business Central can concretely deliver, let us take the example of an organisation everyone knows but few people imagine the management complexity of: a ministry of foreign affairs.
A ministry of foreign affairs is 60 small businesses
A ministry of foreign affairs like Côte d'Ivoire's manages around 60 diplomatic posts — embassies, consulates, permanent representations — spread across five continents. Each post is, from a management perspective, a quasi-autonomous entity: it has its own operating budget, its own local suppliers, its own bank in the host country, its own foreign currency cash, and its own administrative obligations (rent, security, local staff, vehicles, official receptions).
Headquarters in Abidjan must consolidate all of this: track budget execution for each post, manage expatriate allowances (which vary by country, rank, and family status), steer cooperation projects funded by international donors, and report to the Ministry of Finance via SIGFIP.
Between these two levels — the local diplomatic post and the central headquarters — there is today an information gap. Data flows up by email, by Excel spreadsheets sent as attachments, sometimes by post. The CFO in Abidjan has no real-time visibility on the treasury of the Marseille consulate or the commitments of the Washington embassy. Monthly closing is a manual reconciliation exercise that takes weeks. And when the Minister asks "where do we stand on budget execution for our West African posts?", the answer arrives three weeks later, manually consolidated in an Excel file.
This is exactly the type of problem Business Central solves.
What Business Central delivers, function by function
Accounting and finance: a single source of truth
Business Central replaces dozens of Excel files with a single chart of accounts, shared by all posts, compliant with the revised SYSCOHADA. Each diplomatic post enters transactions in the same system, with the same account structure, the same validation rules. Currency conversion is automatic: the accountant in Tokyo enters an expense in yen, the system converts it to FCFA at the day's rate, and the CFO in Abidjan sees it immediately in their consolidated view.
Regulatory financial statements — balance sheet, income statement, TAFIRE — are generated automatically. No need to reconstruct them manually from 60 different files. Monthly closing, which used to take two to three weeks, can come down to three or four days.
But the most important gain is not speed: it's reliability. When all data comes from the same system, there are no more reconciliation gaps, no more contradictory versions, no more "my file says 800 million and yours says 750."
Budget management: knowing where the money goes
A ministry of foreign affairs manages a considerable budget — in the range of 100 to 150 billion FCFA. This budget is spread across dozens of budget lines: post operations, staff allowances, bilateral cooperation, contributions to international organisations, special projects.
Business Central enables real-time budget execution tracking by post, by department, by budget line, by project. The system automatically alerts when a post approaches its budget consumption threshold. It blocks commitments that exceed budget authorisation. It produces execution dashboards that the CFO can consult at any time — not three weeks after month-end.
For a ministry managing public funds, this traceability is not a luxury: it is an accountability obligation towards taxpayers and Parliament.
Procurement management: from request to payment
In a diplomatic post, purchases are daily: office supplies, premises maintenance, vehicle fuel, reception catering, security contractors. Today, these purchases go through paper purchase orders, invoices filed in physical folders, and payments by cheque or manual transfer.
Business Central digitalises this chain. The agent creates a purchase request in the system. The head of post validates it in one click (including from their phone, via the Business Central mobile app). The purchase order is generated automatically. Upon receipt of the invoice, matching with the purchase order is automatic. Payment is prepared and submitted for validation. Every step is tracked, timestamped, and auditable.
The time saving is significant, but the real benefit is the reduction of fraud and error risk. When every expenditure is committed in a system that controls budgets, matches invoices, and keeps a trace of all validations, the room for unauthorised spending shrinks considerably.
Fixed asset management: knowing what you own
A ministry of foreign affairs owns considerable real estate and movable property: ambassadors' residences, chancelleries, official vehicles, furniture, IT equipment, artwork in some cases. This property is spread across 60 different countries.
What is this property worth today? Which vehicles need replacing? Which residences need renovation? In most African ministries, no one can answer these questions precisely, because the inventory is kept on paper or in scattered files.
Business Central manages fixed assets with automatic depreciation, revaluations, disposals, and reporting by location. The CFO can at any time produce a statement of the Ministry's assets, post by post, category by category. For a ministry that must justify its capital budget requests before Parliament, this is a powerful credibility tool.
Allowance management: the headache solved
Managing diplomatic allowances is probably the most complex process in a ministry of foreign affairs. Each agent posted abroad receives a residence allowance whose amount depends on the country of assignment (an agent in Geneva does not receive the same as an agent in Bamako), rank and seniority, family status (spouse, number of children), and changes in cost of living and exchange rates.
These scales change regularly. Recalculating them manually for hundreds of agents, accounting for transfers, promotions, family changes, and scale adjustments, is a colossal task that ties up several full-time staff in the HR department.
Business Central allows these scales to be configured as data tables. When a scale changes, the table is updated once. When an agent is transferred from Dakar to Berlin, their assignment is changed in the system and the allowance is automatically recalculated according to the new scale. Payslips are generated automatically, provisions are calculated, and everything is integrated into the accounting without re-entry.
Cooperation project management: donor reporting
A ministry of foreign affairs manages or co-manages projects funded by international partners: African Development Bank, European Union, bilateral cooperation. Each donor has its own financial reporting requirements, its own expenditure categories, its own deadlines.
Business Central handles this complexity through analytical dimensions. Each expenditure can be simultaneously broken down by project, by donor, by component, by activity. The system can automatically generate a financial report in the donor's format — where today an accountant spends days reprocessing Excel data to produce each report.
Connected to Power BI, Business Central enables a project execution monitoring dashboard with disbursement rates, budget/actual variances, and consumption forecasts. The project manager sees in real time whether their project is ahead or behind on budget consumption — critical information for avoiding fund returns to donors.
The Power BI connection: decision-making at the end of the chain
All data entered in Business Central — journal entries, purchase orders, invoices, budgets, fixed assets, allowances, projects — automatically feeds Power BI dashboards. This is the native connection between transactional and decision-making systems, without manual extraction, without intermediate files, without time lag.
For a ministry of foreign affairs, this means the Minister can open their dashboard on their tablet and see at a glance overall and per-post budget execution rates, posts exceeding spending forecasts, real estate assets by region, cooperation projects by donor, and payroll and allowances by geographic zone.
This is not science fiction. This is exactly what Business Central connected to Power BI does, operational in thousands of organisations worldwide. What is missing in West Africa is not the technology — it is the expertise to configure it correctly in the local context.
Common objections — and their answers
"We already have SIGFIP."
SIGFIP is the state's public finance management system. It covers budget execution at a macroscopic level. Business Central does not replace it — it complements it downstream. SIGFIP says "the Ministry has a budget of 146 billion." Business Central says "here is how those 146 billion are being spent, post by post, supplier by supplier, project by project." The two systems coexist: Business Central feeds SIGFIP through interfaces, not the reverse.
"It's too expensive for the public sector."
Business Central in cloud mode costs approximately 45,000 FCFA per user per month for the Essential licence. For 30 users (a CFO, accountants at headquarters, and one cashier per geographic zone), this represents about 16 million FCFA per year — roughly 0.01% of the Ministry's budget. Return on investment is measured in weeks of closing saved, reconciliation errors eliminated, and steering capacity transformed.
"Our staff aren't trained."
That's true, and it is precisely why change management is at the heart of any serious deployment. Business Central has the advantage of being integrated into the Microsoft ecosystem that most staff already know: the interface resembles Outlook and Excel, data is exportable to Excel in one click, and the mobile app enables gradual adoption. Training is not an obstacle — it is an investment that pays for itself within months.
"You can't deploy this in 60 countries."
That's precisely the advantage of the cloud. Business Central in SaaS mode is accessible from any web browser, in any country, without local installation. The cashier in Washington, the accountant in Dakar, and the CFO in Abidjan all work on the same instance, in real time. The only requirement is an internet connection — and this is precisely the type of prerequisite that an infrastructure audit (such as one planned in an IT master plan) verifies post by post.
How NJIADATA approaches a Business Central deployment
Our approach stands out on three points.
First, we never deploy an ERP in isolation. Business Central is the transactional backbone of a complete data value chain. From day one of configuration, we design the Power BI dashboards that will exploit the ERP data. The client doesn't discover reporting six months after deployment — they see it working from the first test datasets.
Second, we master the African regulatory context. The SYSCOHADA chart of accounts, OHADA financial statements (including TAFIRE, which has no equivalent in international standards), the tax specificities of each WAEMU and CEMAC country — these are competencies that international integrators lack, and that local accountants cannot translate into ERP configuration. We bridge the two worlds.
Third, we train local teams to become autonomous. Our mission is not to create dependency — it is to transfer skills. At the end of deployment, Ministry staff know how to use the system, the CFO knows how to read their dashboards, and the accountant knows how to produce financial statements. NJIADATA remains available for support, but the organisation runs on its own.
Our slogan says it best: from source to insight. Business Central is the source. Power BI is the insight. And between the two, there is a partner who understands your business.
About NJIADATA
NJIADATA is a consulting firm specialising in Microsoft solutions for African markets, based in Paris and Abidjan. Our mission: creating employment in Africa by transferring technical skills to local professionals. Our domains of expertise cover Business Intelligence (Power BI, Microsoft Fabric), document management (SharePoint), information systems consulting (IT master plans), and ERP (Microsoft Dynamics 365 Business Central).
This article is part of the "From source to insight" series published by NJIADATA.