ERPNext Accounting Consultant, UK

From Sage nominal codes and Xero tracking to an ERPNext account tree

A UK nominal ledger usually carries history. Sage users think in nominal code ranges with departments attached; Xero users rely on tracking categories; both end up with accounts created to work around a reporting gap years ago. Moving to ERPNext is the right moment to separate what is statutory from what is managerial.

My approach is to design three layers and keep them distinct:

• The account tree holds what the statutory accounts need: turnover, cost of sales, overheads, fixed assets, debtors, creditors, VAT control and capital. Account numbers can stay close to the old ranges so your team and accountant still recognize them.
• Cost centers carry departments, sites or divisions that management holds to a budget.
• Accounting dimensions carry anything else you analyze by, such as project, brand or sales channel, and can be required on particular account types.

The output is a mapping sheet from each old code and department or tracking value to its new account and cost center. Your accountant reviews it alongside the format they use for statutory accounts, so the year-end mapping is agreed before the first transaction. The ERPNext accounting page describes the general model, and the gap analysis service is where I record anything the standard tree cannot carry.

VAT templates traced to the return, reviewed with your accountant

In ERPNext, VAT is applied through sales and purchase tax templates, item tax templates for goods and services with a different treatment, tax categories for customers and suppliers, and tax rules that pick the right template automatically. The mechanics are sound. What needs design is the link from each template to the VAT return.

I build a matrix with your accountant: every type of supply and purchase you make, the template it uses, the account it posts to and the boxes it should affect. Then I check the awkward cases specifically:

• Reverse charge on services bought from abroad, where output and input VAT post together
• Postponed import VAT, which needs entries that reflect the monthly statement rather than a supplier invoice
• Zero-rated, exempt and outside-the-scope supplies, which affect boxes differently
• The domestic reverse charge for construction services, if it applies to you
• Credit notes, which must reverse into the same boxes as the original

A trial return is then rebuilt from posted test transactions and agreed to the VAT control account. Producing the box figures may use an existing report or a custom one depending on your version and apps, and the route to submit under Making Tax Digital still needs to be settled, as covered on my ERPNext page for UK businesses. The cash accounting and flat rate schemes deserve an early conversation, because they change when and how VAT is reported and may need extra reporting work. VAT treatment itself is your accountant's call.

Bank matching, Bacs supplier runs and direct debit receipts

Most UK businesses pay suppliers in batches by Bacs or Faster Payments and collect from some customers by direct debit. Both habits shape how payment entries should work in ERPNext.

For payables, invoices carry payment terms, so the accounts payable report shows what falls due in each run. Payment entries are raised for the batch, and the bank upload file is either produced by a small integration or prepared from an ERPNext report in the format your bank accepts. I agree which route you will use with your bank before go-live, because a half-manual process tends to break at month end.

For receivables, direct debit collections arrive as one bulk credit or per-customer credits depending on your provider. If they arrive in bulk, I route receipts through a clearing account so each invoice is marked paid individually and the bank line still matches one figure.

Statements usually come into ERPNext through bank statement import from a spreadsheet or file export, since live feeds from UK banks depend on integrations that should be tested with your bank first. ERPNext then pairs each statement line with its payment or journal, and the bank clearance dates show what has actually left the account. For overdue debtors, statements of account can be emailed in bulk on a schedule, which suits a monthly credit control cycle. The finance automation page explains the wider approach.

UK subsidiaries, a euro entity and inter-company balances

Many British groups are small but layered: a trading company, a property or holding company and perhaps a subsidiary in Ireland or elsewhere in Europe that invoices in euros. Keeping those books in one ERPNext site is one of the stronger reasons to choose it.

Each entity becomes its own company with its own account tree, default currency and tax templates. A UK company keeps sterling, a European subsidiary keeps euros, and its own local tax setup needs separate checking. For trade between them, sister companies are linked as internal customers and suppliers, so an invoice raised by one creates the mirror purchase invoice in the other. Management charges and loans can be posted as inter-company journal entries, which keep both sides in step.

Foreign currency balances need a monthly routine. Exchange rate revaluation recalculates open receivables, payables and bank accounts at the closing rate and posts unrealized gains or losses, and the entry can be reversed at the start of the next period if your accountant prefers that method.

For group reporting, ERPNext can present a consolidated statement across companies. Formal eliminations and group accounts are normally prepared by your accountant from the entity trial balances, and I set up the entity reports so that work is quick. The multi-currency ERP page goes further into the design questions.

Opening balances, quarter locks and the statutory year-end file

Cutover from Sage or Xero works best when it lines up with a VAT quarter end, so the last return comes from the old system and the first full quarter from ERPNext. The loading order matters:

1. The old package's last trial balance goes in as an opening journal against the new accounts.
2. Open sales and purchase invoices are created individually with the opening invoice tool, so aged debtors and creditors match the old reports.
3. Fixed assets come across with cost, accumulated depreciation and remaining schedule.
4. Opening stock, if you hold any, is entered through stock reconciliation and agreed to the stock account.
5. The temporary opening account is checked to confirm it nets to nothing.

After each VAT return is filed, I recommend locking that period through an accounting period or the frozen accounts date, so nobody posts into a quarter HMRC has already seen. Corrections then go into the current period, where your accountant can see them.

At the financial year end, a period closing voucher transfers the profit or loss to reserves. The file I set up for your accountant includes the trial balance, nominal activity, aged debtors and creditors, the fixed asset register, VAT control reconciliation, accruals and prepayments schedules and inter-company balances, produced the same way every year. The data migration service covers the cutover method in more depth.

When ERPNext Accounting is not enough in the UK

Some British finance teams are better served elsewhere, and I would tell you so:

• Your accountant files from their own software. If your practice runs the VAT return and year end inside Xero, Sage or a similar package with direct client access, moving the ledger may cost them more than it saves you.
• A special VAT scheme drives the return. Retail schemes, the flat rate scheme or margin schemes for second-hand goods can need substantial custom reporting in ERPNext.
• CIS sits at the center of your payables. Subcontractor deductions, verification and monthly returns are not part of standard ERPNext and would need dedicated development or another tool.
• You want MTD submission inside a vendor-backed product. If a community app or bridging step is unacceptable to your board, a commercial UK package is the simpler answer.
• Group reporting is heavy. Several frameworks, formal consolidation and audit-grade eliminations point to a finance-led ERP or a consolidation tool.

Any one of these is worth a proper comparison before you sign anything. British teams often weigh ERPNext against Odoo Accounting in the UK or a lighter ledger such as Zoho Books for British companies, scored against the VAT and reporting needs written down earlier. The UK ERP consultant page describes that scoring, and the UK hub covers how remote sessions run.