Accounting and finance in Microsoft Dynamics 365 Business Central

For most UK companies, finance is the first reason to look at Microsoft Dynamics 365 Business Central. The general ledger is the heart of the product, and the rest of the business (sales, purchasing, stock, projects) posts into it. If you are comparing options, this page explains what Business Central accounting does, where the UK-specific work sits, and which questions to put to an integrator before you sign.

It is written for finance directors, financial controllers and the owners of growing SMEs who already run a ledger in a spreadsheet or an older package and want a single, auditable system.

What the finance module covers

Microsoft's own consultant study guide lists financial management, sales, purchasing, inventory and fixed assets as the modules a functional consultant configures, together with dimensions, approval workflows, bank accounts and depreciation. That is a fair summary of the finance scope you buy into.

For wider context on the product, see the overview of Business Central modules.

General ledger and chart of accounts

A good Business Central ledger starts with a deliberately designed chart of accounts. In a UK setting that usually means a structure your accountant recognises and that maps cleanly to the accounts they prepare at year end: fixed assets, debtors, creditors, VAT control, payroll liabilities, reserves and so on.

Posting groups then do the heavy lifting. A sales invoice for a particular customer type and product type posts to the correct revenue, receivables and VAT accounts automatically, so the people raising invoices never choose a ledger code by hand. Getting these groups right is the single most valuable piece of finance configuration, and it is where an experienced integrator earns their fee.

Analytical accounting with dimensions

Dimensions replace the habit of encoding everything into a long account number. You post once and tag the entry with, say, a department and a project; reports then slice by either. For a business with sites in several nations of the UK, or a group with a trading arm and a property arm, dimensions give management reporting without a parallel set of books.

Decide the dimension model early. Too few and managers cannot see what they need; too many and the people entering data stop filling them in properly.

VAT and Making Tax Digital

This is the part of UK finance where localisation matters most. Microsoft provides the UK localisation directly, and it lists as available: Making Tax Digital VAT return submission, fraud prevention data, audit and VAT reports, reverse charge, VAT group management and Intrastat reporting.

How MTD submission works

The MTD extension retrieves your VAT obligations from HMRC, alerts you to upcoming deadlines, submits the return and lets you view it afterwards, including VAT payments and liabilities owed to HMRC. The connection runs through the "HMRC VAT Setup" service connection and an application called "Dynamics 365 Business Central MTD VAT", which Microsoft manages on the HMRC site and to which the user grants authority.

A few practical points follow from Microsoft's documentation:

• No sandbox. Microsoft states that HMRC offers no test environment to customers, so the integration can only send genuine VAT returns. Reconcile the VAT report to the ledger before you submit, and rehearse the process with a colleague.
• Fraud prevention headers. Since 2021 HMRC has refused exchanges without fraud prevention headers. Business Central generates them automatically with each MTD call, using the connection method "WEB_APP_VIA_SERVER".
• On-premises caveat. Since 2022 a User IP Address Service must be filled in for MTD submission, and on an on-premises installation the field is mandatory before the application generates the headers. If you host yourself, make this part of the go-live checklist. The hosting and cloud page explains the trade-offs.
• Not an agent tool. The native integration does not cover HMRC agent services, so an accountancy practice filing on behalf of clients needs something else.

Our guide to Making Tax Digital and your ERP goes through the wider compliance picture, including what to ask any supplier.

VAT groups

If several UK companies form a VAT group, the VAT Group Management extension lets members submit their returns to the representative member, who files one group return with HMRC. Two constraints matter for budgeting and security: every participant needs a Business Central licence, and calculating or submitting a return requires a user with a full licence; guest accounts are not permitted.

The native MTD integration does not gather entries from several companies automatically for a VAT group. Microsoft points to its partners for that need, so raise it explicitly during selection if you operate a group.

Reverse charge, EORI and Northern Ireland

Reverse charge is part of the UK localisation. For trade after Brexit, Business Central adds an EORI number on the company, customers and vendors, and the UK version includes a "Supplementary VAT Reg. Number" field, for instance for a Northern Ireland XI number.

Northern Ireland needs care. Movements of goods to or from Northern Ireland are still declared through Intrastat in Business Central, but Microsoft states that VAT scenarios linked to Northern Ireland are not supported by the standard functions and recommends working with a partner. If you trade across the Irish Sea, test your real transactions during implementation rather than assuming standard behaviour. Our page on Business Central in the UK covers the localisation in more detail.

Bank, payments and reconciliation

Business Central keeps bank accounts as ledger-linked records. You import statements, match them against open customer and supplier entries and post the differences, which turns reconciliation from a monthly scramble into a routine task.

On the payments side, the UK version supports printing cheques in the APACS format and printing remittance advice, which still matters to businesses that pay or are paid by cheque or send advice notes to suppliers. For electronic payments and bank feeds, the route depends on your bank and on the connectors you choose; discuss it with your integrator, and see the integrations page.

Addresses are a small but welcome detail: the UK version includes an Ideal Postcodes extension to fill in addresses from postcodes, which saves keying time and cuts errors on customer and supplier cards.

Fixed assets and depreciation

The fixed assets module keeps the register, applies depreciation and handles disposals, and posts to the ledger through its own posting groups. Many UK firms keep accounting depreciation and tax capital allowances separate, so ask your accountant how they want the two treated. Business Central can hold more than one depreciation book per asset, which is a natural place to keep a tax view alongside the accounting one, but that design belongs in your accountant's hands, not in a default template.

Multi-currency, multi-company and consolidation

UK businesses that buy from the EU and the rest of the world, or sell abroad, need transactions in several currencies. Business Central supports foreign currency on customers, suppliers and bank accounts, with exchange rates maintained in the system and gains and losses posted when settlements and revaluations happen. Your reporting currency stays pounds sterling, with foreign amounts held alongside.

For groups, you can run several companies in one environment, each with its own ledger, and consolidate them into a parent for management and statutory reporting. Intercompany postings reduce the manual matching you do at month end. If your structure mixes a UK trading company with an Irish or European subsidiary, confirm early that the localisation you need exists in each country. The Business Central pages for other countries on our sister sites are not a substitute for that check; ask your integrator to confirm it in writing.

Month-end and year-end close

A well-set-up close in Business Central is a checklist rather than a heroic effort:

1. Post all subledger transactions and run any recurring journals.
2. Reconcile bank accounts and control accounts for receivables and payables.
3. Run currency revaluation and fixed asset depreciation.
4. Reconcile the VAT control account to the VAT report.
5. Review dimension postings, accruals and prepayments.
6. Lock the period against further posting once the accountant is satisfied.

Locking periods and restricting who can post into a closed period gives your auditor a clear trail. Payroll journals should arrive in the ledger on a known schedule; see our note on payroll and RTI in your ERP and the Business Central payroll and HR page for how that link is usually handled.

Reporting and analysis

Out of the box you get the trial balance, financial statements and account schedules, which let finance teams define their own management reports from ledger accounts and dimensions. Analysis views allow trend and variance work by dimension. Many UK companies also connect a separate reporting tool for board packs; that is an integration decision rather than a limitation of the ledger.

Newer releases also add assistance features. Microsoft's consultant guide now includes configuring Copilot and the built-in agents among the skills expected, so ask a prospective partner how they would use these in finance, and what controls they would put around them.

The role of your accountant

Your accountant or financial advisor is not made redundant by the system; their role shifts. A sensible split looks like this:

• Accountant: designs the chart of accounts with you, advises on VAT treatment, signs off year-end procedures, prepares statutory accounts and tax computations.
• Integrator: configures posting groups, dimensions, VAT set-up, bank and approval workflows; migrates opening balances; trains your team.
• Your finance team: owns the daily process, the close and the quality of the data.

Bring the accountant into workshops at the start. Many finance problems after go-live trace back to a chart of accounts or VAT set-up built without their input. Our guide to ERP implementation describes where finance sign-off belongs in a project.

Moving your ledger across

Opening balances and history are the most delicate part of a finance migration. Decide how much history you need in the new system and how much stays in the archive, and agree who reconciles the trial balance on the cut-over date. The migration page and our general guide to ERP migration set out the stages.

Choosing who implements it

Finance configuration is only as good as the person doing it. When you meet integrators, ask them to walk through a UK VAT return from posting to MTD submission on a demonstration environment, to explain how they would handle Northern Ireland and any VAT group, and to show how they set up dimensions for a business like yours. Check the guidance on choosing a Business Central partner and, for the budget side, the pricing page.

If you would rather not shortlist alone, how our matching service works is free for you: we introduce you to an integrator suited to your project, and the integrator carries out the work.

Software names mentioned are trademarks of their respective publishers and are referred to for information only. This site is independent and is not affiliated with any software publisher.