ERPNext Accounting Consultant, Canada

A chart your accountant can map to GIFI without rework

Canadian corporate returns rely on the General Index of Financial Information, which assigns standard codes to balance sheet and income statement lines. Most accountants map a client's trial balance to those codes every year. The cleaner the chart, the faster and safer that mapping is.

In ERPNext I design the account tree so each ledger account maps to a single GIFI line. That rules out accounts that mix, for example, professional fees with subcontractor costs, or shareholder loans with trade payables. Where a business wants more operational detail, I use the tools ERPNext provides for it rather than more accounts:

• Cost centers for divisions, plants or branches that carry budgets
• Accounting dimensions for province, product line or sales channel, required on chosen accounts so reports stay complete
• Account numbers kept familiar where your team and CPA rely on them

For businesses with Quebec operations, account names can be written in French or bilingually, and report labels and print formats can be translated, which helps when bookkeepers and managers work in different languages. The mapping sheet, old account to new account and GIFI line, is reviewed by your accountant before setup. The ERPNext accounting overview explains the general mechanics, and my gap analysis records anything the standard structure cannot carry.

GST/HST, QST and PST: templates, accounts and input credits

ERPNext models Canadian sales tax with sales and purchase tax templates, item tax templates for zero-rated or exempt goods, tax categories for exempt customers, and tax rules that choose a template by shipping province. The parent page on ERPNext in Canada describes that matrix. Here the concern is what happens in the ledger.

I design accounts so each return ties to a balance:

• GST/HST collected and paid in their own accounts, so net tax and input tax credits for the return can be read straight from the ledger
• QST collected and paid kept apart, because Quebec administers it separately with its own return
• PST payable by province where you are registered, with self-assessed PST on your own purchases posted to a separate account
• Non-recoverable tax posted into the cost of the item or expense rather than to an input credit account

I then test credit notes, customer deposits, exempt sales and purchases from suppliers outside Canada to confirm each lands where your accountant expects. Before go-live, a trial return is built from posted test transactions and compared with the account balances. Registrations, place-of-supply rules and eligibility for input credits are your accountant's call; the design just makes each figure traceable.

Canadian banking, USD accounts and payment entries

Most Canadian businesses I work with run at least one CAD and one USD bank account, collect some customers by EFT or Interac e-Transfer and pay others by check or electronic transfer. ERPNext handles this through bank accounts linked to ledger accounts, payment entries for receipts and payments, and the bank reconciliation tool.

A few design points matter:

• Currency per account. USD bank accounts and USD customer and supplier balances are held in dollars, with the exchange rate recorded on each document and realized gains or losses posted on payment.
• Month-end revaluation. Exchange rate revaluation restates open USD balances at the closing rate and posts unrealized differences. I agree with your CPA whether those entries reverse at the start of the next month.
• e-Transfers and deposits. Receipts that arrive with little reference detail need a routine for matching them to invoices, otherwise unallocated payments build up. The payment reconciliation tool helps clear them.
• Statements. Bank statement import works with the files Canadian banks export; live bank feeds depend on an integration supporting your bank, which ERPNext has offered through Plaid in some versions, so test it first.

Supplier payments are scheduled from payment terms, and the payment file for your bank is either produced through an integration or prepared from a report. The multi-currency ERP page goes further into the design choices.

Holding companies, operating companies and a US subsidiary

Owner-managed Canadian businesses are often structured as a holding company owning one or more operating companies, sometimes with a US subsidiary for cross-border sales. Each corporation files its own return, and the transactions between them, management fees, dividends, shareholder loans and cost recharges, need to be visible and to agree.

In ERPNext each corporation becomes its own company on the same site, with its own chart, fiscal year settings and bank accounts. A US subsidiary keeps US dollars as its base currency and its own sales tax setup, which I review separately. For trade between group companies, each corporation is set up as an internal customer and supplier of the others, so the buying side is generated from the selling side, and inter-company journal entries post recharges and loans on both sides at once.

Shareholder and related-party accounts deserve particular care. I keep shareholder loans, dividends payable and inter-company balances in dedicated accounts per counterparty, so your accountant can reconcile them quickly and review any tax implications.

A consolidated statement in ERPNext gives management a group view. Formal consolidated statements, where required, are usually prepared by your accountant from the entity trial balances. For the structural questions, see my multi-company ERP page.

Opening balances from QuickBooks or Sage, and the year-end file

QuickBooks and Sage are the usual starting points. I recommend a cutover at the end of a sales tax filing period, so the last return comes from the old system and the first one from ERPNext. The loading sequence is:

1. Map each old account to its new account and GIFI line, then enter the final QuickBooks or Sage trial balance as the opening journal.
2. Create open customer invoices and supplier bills individually through the opening invoice tool, in their original currency, so aging and matching continue.
3. Load fixed assets with cost, accumulated depreciation and remaining life, and opening stock by warehouse through stock reconciliation.
4. Prove the load: the temporary opening account should be empty, and tax liability accounts should agree with the last return filed.

During the year, each filed sales tax period is locked through an accounting period or the frozen accounts date. Many Canadian companies have a fiscal year that does not match the calendar year, and ERPNext's fiscal year setup handles that per company.

At year end, a period closing voucher moves profit and loss to retained earnings. The file I set up for your accountant typically holds the trial balance with GIFI mapping, ledger detail, aged balances, the fixed asset register, sales tax reconciliations by tax, USD revaluation entries and inter-company and shareholder balances. The QuickBooks migration page explains the method in more depth.

When ERPNext Accounting is not enough in Canada

Some Canadian finance setups are better served by something else, and I say so when I see them:

• Sales across many provinces with frequent taxability changes. Maintaining templates and rules by hand becomes a burden; a platform with a supported Canadian tax engine may be safer.
• Your accountant works only inside their own ecosystem. If year-end and sales tax filings depend on direct access to QuickBooks or Sage, factor that change cost in honestly.
• Payroll accounting must be fully native. Canadian payroll belongs with a specialist provider; if you need it inside the ERP, ERPNext is the wrong tool.
• Cross-border consolidation is complex. Several Canadian and US entities with formal consolidation and audit needs may suit a finance-led ERP.
• No one owns the system. Without an administrator or provider for upgrades, the books system becomes fragile.

A Canadian business that recognizes itself here should test alternatives with its own provincial tax matrix and USD scenarios. Odoo Accounting in Canada and Zoho Books for Canadian firms are the usual candidates at this size. I describe the scoring method on the Canadian ERP consultant page, and remote working across Canadian time zones on the Canada hub.