ERPNext Accounting in Nigeria

Building the chart of accounts and tax templates for Nigerian books

ERPNext ships with standard chart templates, but none of them is your accountant's chart. For a Nigerian company I start from the outputs: the financial statements, the notes your auditor reviews, the VAT return schedules and the withholding tax listings. Each line on those documents needs an account or a group of accounts behind it, and the account tree is built backwards from there.

Taxes then sit on top of that tree:

• Sales and purchase tax templates for standard, exempt and zero-rated situations as your accountant defines them, so a clerk picks a template instead of typing a rate.
• Item tax templates where particular goods or services are treated differently from the default.
• Tax categories and tax rules so the right template is applied automatically from the customer or supplier record.
• Tax withholding categories for supplier deductions, with the conditions and accounts your accountant specifies.
• A withholding receivable account for deductions customers make from what they pay you, cleared when their credit evidence arrives.

Nigerian tax law has been going through reform, so I treat every rate, exemption and threshold as an input from your tax advisor rather than something fixed in my design. If a regional app for Nigeria exists for your ERPNext version, I review what it installs before deciding whether to use it. The global ERPNext Accounting page explains the underlying features.

Naira books, domiciliary accounts and group companies

Plenty of Nigerian companies hold dollar balances in domiciliary accounts, pay foreign suppliers in dollars and report in naira. ERPNext handles this by letting a bank account, customer or supplier carry its own account currency while the company's books stay in naira. The rate policy itself is covered on my ERPNext consultant Nigeria page; here the concern is structure.

The decisions I settle with your accountant:

• Separate ledger accounts per currency, so a dollar bank account never receives a naira entry by mistake.
• Party accounts in foreign currency for suppliers and customers who are always billed in dollars.
• Landed cost vouchers that bring clearing, freight and duties into imported stock value instead of leaving them in expenses.
• Exchange rate revaluation on open balances, posted once your accountant has reviewed the proposed entries.

Groups with a trading company, a manufacturing company and perhaps a holding entity can keep them all on one ERPNext site. Each company has its own chart, tax templates and default currency. Internal customers and suppliers link the two sides of an intercompany sale, and the consolidated financial statement report gives directors a group view, while eliminations stay with your accountant. The multi-company ERP and multi-currency ERP pages describe the general design.

Bank statements from Nigerian banks and reconciliation

A Nigerian business account produces a stream of small lines: transfer charges, government levies on transfers, POS settlements, card and gateway payouts and customer deposits referenced only by a name. Matching them one at a time, in any system, eats the finance team's week.

ERPNext offers a bank statement import, bank transaction records and a reconciliation tool that matches lines against payments and invoices. Automatic bank feeds for Nigerian banks are worth asking about, but I would not plan around one until it has been shown working with your own bank. The dependable route is the statement download from internet banking in a spreadsheet or CSV layout. For each bank I record:

• the column layout, date format and how debits and credits are shown;
• which recurring charges can be posted as a single journal per period;
• how gateway settlements are split into sales, fees and refunds;
• which reference on a customer deposit can identify the invoice.

Customer payment references are the weak point. A naming rule for deposits, printed on every invoice, saves more reconciliation time than any setting. Unidentified receipts go to a suspense account with an owner and an aging report, never into a guessed customer. The finance automation page covers wider automation options, and opening balances follow my ERP data migration approach.

E-invoicing, statutory reports and what the accountant receives

The federal tax authority is moving businesses to electronic invoicing in phases. ERPNext has no vendor-maintained Nigerian connection as far as I can establish, so any link is likely to come from a community app or custom work; confirm the options with Frappe or your partner, and ask your tax advisor when and how the program reaches your company. From the accounting side I make sure the invoice data is ready: customer tax identification numbers captured, item descriptions and units consistent, credit notes always linked to the original invoice, and a status field so finance can see which documents were accepted or rejected.

The year-end pack is the other test. Out of the box, ERPNext gives you the core statements, the ledger, a trial balance and receivable and payable aging. What it does not produce on its own are the exact schedules your accountant and auditor work from. I list those schedules early and decide which come from standard reports with filters, which need a custom report and which stay in your accountant's working papers. Likely candidates for custom reports are VAT schedules by period, withholding deducted and credited by party, and fixed asset movements in the layout your auditor expects.

Custom reports belong in a custom app under version control, not typed into the live site. That keeps them through upgrades and lets another developer maintain them.

Hosting, upgrades and who maintains the accounting code

Because ERPNext is open source, the software carries no per-user subscription. The costs move elsewhere: hosting, backups, a developer or support provider, and the time your finance team spends testing upgrades. For a Nigerian finance team the practical questions are narrower than the general hosting debate:

• Can the accountants work during a power cut? Frappe Cloud or a managed cloud server keeps the ledger reachable from any site with a connection; an on-premise server needs its own power backup.
• Is there a backup before every close? I add a confirmed backup and a periodic test restore to the close checklist.
• When are upgrades applied? Never in the close window. Major upgrades are rehearsed on a copy of live data, and tax templates, custom reports and print formats are retested.
• Who owns custom accounting code? A named developer or support contract, recorded before go-live.

Support can come from Frappe, a local or remote partner, a freelancer or an in-house developer; confirm scope and response times with whichever you choose. I am not a Frappe partner, sell no hosting or support and take no commissions. If all you need is to raise invoices for a few services, ERPNext Accounting is more system than the job requires. Broader context is on the ERP consultant Nigeria page and the Nigeria overview.