ERPNext Accounting in New Zealand

Full ledger in ERPNext, or Xero alongside?

Two designs are credible for a New Zealand business adopting ERPNext.

ERPNext as the full ledger. Sales and purchase invoices, payments, stock valuation, manufacturing cost and fixed assets all post to one general ledger. Margins by product and customer come straight from source, stock value always agrees with the balance sheet, and there is no sync to break. The accountant needs a login and has to learn ERPNext's reports, which some accountants accept readily and others resist.

ERPNext for operations, Xero for the books. ERPNext handles quoting, orders, stock and production, then sends either individual invoices or summarized journals to Xero, where GST returns, bank reconciliation and year-end work continue as before. The accountant's routine barely changes. The price is an integration that someone must build and maintain, two places where a customer or account can be wrong, and stock valuation that lives in ERPNext while the ledger lives elsewhere.

Points that decide it:

• whether your accountant will work inside ERPNext;
• transaction volume, since syncing every invoice is heavier than a daily journal;
• how much of the margin story depends on stock and production cost;
• whether a maintained Xero connector exists for your version. Confirm with Frappe or the partner, or plan a custom integration.

I lay out both designs using your own transactions, then you and your accountant choose.

GST templates, the return and your filing basis

In ERPNext, GST is driven by templates on selling and buying documents, by item-level templates where a product is treated differently, and by rules that select a template from the party, address or tax category. For New Zealand that covers standard-rated local supplies, zero-rated exports, exempt supplies such as residential rent or financial services if they arise, and GST paid to customs on imports. Which treatment applies is your accountant's call; the configuration simply applies it every time.

The return needs the most work. ERPNext's ledger is accrual based, so a business filing on an invoice basis can draw the return from posted invoices and journals. A business on a payments basis needs a report that recognizes GST as cash moves, which is a more involved piece of custom reporting. Check whether a regional app or community report exists for your version; otherwise plan a small custom report kept in a separate Frappe app.

Whatever the route, three things are non-negotiable:

• a mapping from every tax account to a return box, agreed with your accountant;
• test periods in which ERPNext's figures are compared with the accountant's independent working;
• an audit trail from each total back to source documents.

Filing stays with your accountant or their tax software. The ledger structure is explained on the ERPNext Accounting page.

Bank feeds, payments and reconciliation away from Xero

Xero users in New Zealand are accustomed to bank transactions appearing on their own. ERPNext works differently. Its bank reconciliation tool matches bank transactions against payments, invoices and journals, but those transactions normally arrive through a statement file you download and import, unless a feed integration exists for your banks and version. Feeds set up for Xero do not carry across, so confirm with Frappe or the partner what is available, and design the routine if it is file based.

Points I settle with your finance team:

• File formats from each bank you use, tested with real statements, and a saved mapping so an import takes minutes rather than an afternoon.
• Matching rules for card fees, merchant settlements, recurring direct debits and online store payouts, which otherwise swamp the reconciliation screen.
• Supplier payments: whether ERPNext produces batch payment files in a format your bank accepts, or payments are keyed in internet banking and reconciled afterwards.
• Foreign currency accounts for AUD or USD receipts, with exchange gains and losses posted automatically.

If the reconciliation routine looks too heavy for a small finance team, that is a genuine argument for keeping Xero as the ledger, and I will say so. For foreign-currency design in general, see multi-currency ERP.

Moving the books from Xero: what changes for the accountant

If the ledger moves, the migration is less about data volume than about how the accountant will work afterwards. Xero tracking categories normally become ERPNext cost centers or accounting dimensions; contacts become customers and suppliers with separate address and contact records; any inventory items in Xero need units, valuation and warehouses that Xero never asked for.

The steps I plan:

• A redesigned chart rather than a straight copy, adding the stock, work in progress and cost of goods accounts a stock-based ledger needs.
• Cutover at a GST period end agreed with your accountant, so one return is not split across two systems without reason.
• Opening balances for the trial balance, open receivables and payables by invoice, and stock by item and warehouse, all reconciled before the first live transaction.
• History left in Xero as a read-only archive, with a decision on how long the subscription is kept.
• Payroll staying with New Zealand payroll software, posting a journal into ERPNext by cost center.

Before go-live I walk your accountant through ERPNext's trial balance, general ledger and receivables reports, so year-end is not their first look at the system. The ERP data migration page describes the method in general.

Hosting, upkeep and when Xero should stay the ledger

A New Zealand ERPNext ledger with a custom GST report, perhaps a Xero connector and a set of bank import templates is only safe if someone keeps it working through upgrades. Frappe Cloud handles servers, backups and version updates; self-hosting on an Australian cloud region puts that work on your IT contractor; an ERPNext implementation firm can do either under a support agreement. Confirm current regions, plans and response times with Frappe or the partner. None of these options pays me anything, so the comparison is about your risk alone.

Whichever you choose, write the upgrade routine down: copy production to staging, upgrade, rerun the GST and integration tests, then upgrade production.

I would leave the ledger in Xero when:

• your accountant prepares returns and year-end accounts in Xero and will not work in another system;
• the finance function is very small and depends on automatic bank feeds;
• stock and production cost are simple enough that summarized journals tell the whole story.

For another full ERP ledger, compare Odoo Accounting in New Zealand. Peppol and privacy are covered on ERPNext in New Zealand, and my wider remote advisory work on the ERP consultant in New Zealand page. Every engagement there runs in English.