Appearance
Account mapping
Also known as
- account mapping
- posting accounts
- default accounts
- GL determination
- account determination
- control accounts
- posting setup
- GRNI
- COGS
- account mapping missing
Account mapping tells every module which GL account to use for each kind of posting: receivables, payables, revenue, inventory, GRNI, COGS, payroll, depreciation, FX differences and more. Set it once for all entities and override it per entity where needed. "Modules post with these roles; a missing mapping stops the posting with "account mapping missing"."
Map accounts
- Go to FinanceSettingsAccount mapping.
- Choose All entities (the default for every entity) or one entity to override.
- For each role, choose the account. For an entity, an empty role shows "Inherited from all entities".
- Select Save ("Account mapping saved"). The footer counts unsaved changes.
Accounts must have the right type for the role (for example an asset account for Accounts receivable).
Roles
| Group | Role | Used for |
|---|---|---|
| Receivables & payables | Accounts receivable | Customer invoices debit, receipts credit. |
| Accounts payable | Vendor bills credit, payments debit. | |
| Customer advances / unapplied cash | Receipts not yet applied to invoices. | |
| Cash & bank | Bank (default) | Default bank account when a document has none. |
| Bank charges | Fees deducted by the bank on payments and receipts. | |
| Revenue & expenses | Revenue (default) | Default sales revenue. |
| Sales discounts | Early-payment discounts granted. | |
| Expense (default) | Vendor bill lines without an account. | |
| Purchase discounts | Early-payment discounts taken. | |
| Unbilled receivables | Revenue recognised but not yet invoiced. | |
| Deferred revenue | Revenue recognition. | |
| Tax | Output tax, Input tax | Tax on sales and purchases when the tax code has no account. |
| Tax payable / settlement | Net tax due after the settlement. | |
| Inventory & production | Inventory, Goods received not invoiced, Cost of goods sold | Stock valuation, receipt accrual, shipments. |
| Inventory adjustment, Purchase price variance, Landed cost clearing | Count differences, cost variances, freight and duty. | |
| Work in progress, Manufacturing variance, Labour absorbed, Overhead absorbed | Production. | |
| Payroll | Payroll expense, Payroll liabilities, Employer payroll contributions, Payroll withholdings payable | Pay runs. |
| Fixed assets | Fixed assets (cost), Depreciation expense, Accumulated depreciation, Gain/loss on disposal | Asset postings when the category has no account. |
| Close & FX | Unrealised FX gain/loss, Realised FX gain/loss | Revaluation and settlement differences. |
| Retained earnings, Rounding differences, Suspense | Year-end result, rounding, temporary postings. | |
| Intercompany, Intercompany payable, Cumulative translation adjustment | Intercompany journals and consolidation. | |
| Service, Assets, Projects | Service parts cost, Service revenue, Maintenance expense, Project WIP, Project revenue, Project expense reimbursements | Module-specific postings; each falls back to a general role when empty. |
Each document page of this guide shows the debit and credit accounts it posts in a GL block.
WARNING
Changing a mapping affects future postings only. Re-map before go-live or at a period start, and reclassify old balances with a journal entry.
