ERPNext Accounting Consultant, Australia

Rebuilding the chart and tracking categories for ERPNext

Xero and MYOB charts in growing Australian businesses tend to share a pattern: a lean chart of accounts supported by tracking categories or jobs, plus a few accounts added over time to work around reporting limits. ERPNext offers more structure, and I use it in three layers.

• Accounts follow the statements your accountant prepares, keeping account codes recognizable where your bookkeeper and agent are used to them.
• Cost centers take over tracking categories that represent a managed unit, such as a branch, state or division, because budgets in ERPNext can sit against cost centers.
• Accounting dimensions take over the rest: job, project, product line or channel. A dimension can be required on income and expense accounts, which keeps margin reports complete.

Australian groups also need accounts that keep related-party balances visible: loans to and from shareholders, trust beneficiary entitlements and inter-entity loans. Your accountant watches these closely at EOFY, so each gets its own account per counterparty rather than a shared clearing account.

I produce a mapping sheet from every old account and tracking value to its new account, cost center or dimension, and your accountant reviews it before configuration. The general model is described on the ERPNext accounting page, and the wider design work sits within my solution design service.

GST templates, BAS labels and the review with your agent

ERPNext charges and claims GST through sales and purchase tax templates, item tax templates for GST-free or input-taxed items and tax categories for customers and suppliers. What a standard install does not give you is a BAS with each label already filled, so the mapping has to be designed and proven. My ERPNext page for Australia introduces the issue; this is how I handle it in detail.

With your BAS agent, I list every transaction type and decide its template and label:

• Taxable sales, GST-free sales such as exports, and input-taxed supplies
• Purchases with GST, purchases without GST, and capital purchases reported separately
• Imports where GST is paid at the border or deferred
• Credit notes and adjustments, which must reduce the same labels
• Private or non-deductible portions of expenses

A report then summarizes posted transactions by label. Depending on your version and apps, that may be an existing report or a custom one. ERPNext accounts on an accruals basis, so if you report GST on a cash basis, the report has to follow payments rather than invoices, which needs extra work and testing.

Before the first live period, a sample quarter is processed in ERPNext and compared with your agent's own figures. ABNs are held on supplier records, and if your industry reports contractor payments to the ATO each year, I tag those suppliers so the data can be extracted. GST treatment stays with your agent.

ABA payment runs, BPAY receipts and merchant settlements

Australian businesses pay most suppliers through batch payment files uploaded to their bank, usually in the ABA format. ERPNext manages the payables side well: invoices carry payment terms, the accounts payable report shows what falls due, and payment entries record the run. The ABA file itself is the variable part. Depending on your setup, it comes from a small integration, a custom report or a third-party tool, and I agree the route with your bank and test it before the first live run.

On the receivables side, customers may pay by BPAY, PayID, direct deposit or card. I make sure each customer has a reference your bank statements can carry, so receipts match invoices without guesswork. Card and online payments that settle in batches, net of fees, go through a clearing account per provider; the account should empty on each settlement, and anything left over shows a missing fee or refund.

Exported statements from Australian banks are imported and matched line by line to payment entries and journals. Live bank feeds into ERPNext depend on an integration that supports your bank, so I treat them as something to test rather than assume. Statements of account can be emailed to customers in bulk each month, which supports credit control. The finance automation page describes the wider routine.

Payroll journals, super liabilities and company and trust groups

Payroll for Australian businesses normally stays in an STP-enabled payroll product, as my platform page explains. The accounting job is to bring each pay run into ERPNext correctly. I design a journal format that posts wages, PAYG withholding, superannuation and leave accruals by cost center and dimension, so labor cost appears in branch and job margins. Each month the PAYG and super liability accounts are reconciled to the payroll reports, and super paid through a clearing house is matched to the liability.

Many Australian businesses also operate as groups: a trading company, a trust that owns property or equipment, perhaps a holding company or a second trading entity. In ERPNext each one becomes its own company on the same site, with its own chart and bank accounts. Each entity can be another's internal customer or supplier, which keeps invoices between them mirrored, and loans, recharges and rent go through inter-company journals.

Trust distributions and beneficiary entitlements are recorded by journal once your accountant confirms them; ERPNext does not decide them. A consolidated statement in ERPNext gives the owners a group view, while statutory reporting for each entity stays separate. The multi-company ERP page covers the design questions in more detail.

Opening balances from Xero or MYOB and the EOFY pack

For a move from Xero or MYOB, I aim for a cutover right after a BAS period, so the last BAS comes from the old system. The opening sequence:

1. Map every old account and tracking value to the new chart, cost centers and dimensions.
2. Bring the final Xero or MYOB trial balance in as one opening journal.
3. Load open invoices and bills individually through the opening invoice tool, so aging and payment matching continue.
4. Bring across fixed assets with cost, accumulated depreciation and remaining life, and opening stock by warehouse.
5. Check that the temporary opening account clears fully and that GST accounts agree with the last BAS.

After each BAS is lodged, I lock the period through an accounting period or the frozen accounts date, so changes after lodgement go into the current period where your agent can see them.

The Australian financial year does not follow the calendar year, and ERPNext's fiscal year setup handles that per company. At EOFY, a period closing voucher moves profit and loss to retained earnings, or to the relevant equity accounts for a trust as your accountant directs. The pack I set up typically holds the trial balance, ledger detail, aged balances, the fixed asset register, GST and payroll liability reconciliations, loan schedules for shareholders and related entities, and inter-company balances. The data migration service describes the cutover method.

When ERPNext Accounting is not enough in Australia

These are the Australian cases where I usually point to something else:

• Your agent lodges from inside Xero or MYOB. If BAS and tax work depend on direct access to those ledgers, the change cost may outweigh the gain.
• Cash-basis GST with no budget for reporting work. ERPNext is accrual-based, so cash-basis BAS reporting needs a tested custom report.
• Mainly services, little stock. A cloud accounting package with a job add-on may do the job at lower effort.
• Complex group and trust reporting. Many trusts and entities with formal consolidation needs may suit a finance-led platform or specialist tools.
• Nobody to own the system. Upgrades, custom reports for BAS and payment files all need an owner.

Two or more of these together usually means ERPNext is the wrong ledger for now. In that case I put the same BAS, payroll journal and trust scenarios through Odoo Accounting for Australian businesses or Zoho Books in Australia and let the results decide. The Australian ERP consultant page sets out that process, and the Australia hub covers remote delivery.