Business Central Consultant, New Zealand

Designing environments for a New Zealand and Australian group

In Business Central, a localization belongs to an environment, and each environment can hold several companies that share it. That one fact shapes trans-Tasman design. New Zealand and Australian companies need different tax, reporting and banking behavior, so placing them in the same environment is not automatically possible or wise.

The options I lay out for group finance:

• Separate environments per country, each with its own localization. Clean compliance on both sides, but intercompany and consolidation work across environments, and admin effort is doubled.
• One environment with apps covering the second country, if a partner offers that. Simpler administration, but you depend on the app's coverage and upkeep for one side of the business.
• A New Zealand environment only, with the Australian company on a smaller system feeding consolidation, where the Australian side is small.

For each option I check how intercompany transactions are exchanged, how consolidation pulls business units together and translates currencies, how master data such as items and customers is kept aligned, and how the partner would support two localizations. Decisions are recorded with their effect on month end, so the choice is made by finance rather than by whichever setup the partner prefers. My Dynamics 365 in New Zealand page covers the wider platform and tier questions.

GST through posting groups, not through habits

Xero and MYOB rely on whoever enters a line to pick its GST code. Business Central instead derives GST from two settings that meet on every line: the posting group attached to the trading partner and the one attached to whatever is being sold or bought. That is far more robust, but only if the combinations are designed carefully.

With your accountant, I set up:

• Business posting groups for domestic customers and suppliers, export customers, overseas suppliers and any special category your accountant needs.
• Product posting groups covering standard-rated supplies, zero-rated lines, any exempt activity and imported services where your accountant wants them identified.
• Posting setup for every combination that occurs, with the correct GST accounts and calculation type, and combinations that should never happen left empty so the system blocks them.
• Import GST captured from the customs entry as its own transaction, kept apart from the overseas supplier's bill, following your accountant's method.

I then post test documents for each combination and compare the GST report with figures your accountant calculates independently. Your accountant decides the treatment and the accounting basis; the configuration simply has to apply it every time. If you file returns through Inland Revenue's own channel, I confirm the report layout matches what they need to transfer.

Turning Xero tracking into Business Central dimensions

Most New Zealand businesses arrive with profit tracking built on Xero tracking categories, MYOB jobs or a set of extra accounts invented over time. Business Central uses dimensions for this, and it is worth redesigning rather than copying.

• Global dimensions are the two you filter on most, often branch or region and business unit, because they are available on almost every list and report.
• Shortcut dimensions add more analysis, such as sales channel, product family or project, available on document lines.
• Default dimensions on customers, vendors, items and accounts fill values automatically, with rules that make a dimension mandatory or fixed where needed.
• Dimension combinations block values that should never appear together, for example a retail channel on a wholesale-only branch.
• Account consolidation: extra G/L accounts that only existed to split figures by location can usually be removed once dimensions do the job.

For a trans-Tasman group, I agree dimension codes that mean the same thing in both countries so consolidated reports are comparable. Historic Xero or MYOB balances are mapped to the new accounts and dimensions at cut-over, with summarized history loaded if management wants year-on-year comparison. The ERP data migration service describes how I reconcile that load.

Questions for the partner's proposal

Business Central is licensed and normally delivered through Microsoft's partner channel. Bids may come from a New Zealand firm, an Australian firm serving both markets, or a team working from overseas. I am not part of that channel and earn nothing from licenses or referrals, so I can review a statement of work strictly for you.

What I look for in a New Zealand proposal:

• Environment and company structure stated explicitly, including how the Australian side is handled and what that means for cost.
• Apps assumed: Peppol e-invoicing, bank feeds or payment files, payroll integration, warehouse scanning and reporting. Who publishes each, what each costs, and whether it is in scope.
• Migration from Xero or MYOB and any add-on apps: which records, how much history, who cleans the data, who reconciles.
• Payroll: usually a separate New Zealand product, so the scope should cover how its journals post, not a promise of payroll inside the ERP.
• Testing: whether the partner supports user acceptance testing with your scenarios, or only tests its own configuration.
• Exclusions and assumptions, where later change requests often hide.

You receive the proposal back with my margin notes and a list of open questions; if more than one firm has bid, their answers are lined up against a single requirements set. The vendor proposal review service describes the approach in general.

When Business Central is more than a New Zealand firm needs

For plenty of expanding New Zealand groups Business Central is a good fit. My doubts start in these cases:

• A single entity with simple stock is mainly frustrated by disconnected apps. Better integration around Xero, or a lighter suite such as Zoho Books in New Zealand, may solve it at lower running cost.
• A producer or importer wants stock, production and accounting in one open platform, where Odoo Accounting in New Zealand is a fair comparison.
• The Australian side dominates and the group's finance team sits there, in which case the environment decision should be led from Australia's needs.
• Nobody internally will own the system. Business Central needs a capable administrator or an ongoing support arrangement.

I work remotely with New Zealand teams, booking workshops in your afternoon and continuing work while you are offline. Platform-neutral guidance is on my New Zealand ERP consulting page, the New Zealand hub and the testing and UAT service used before go-live.