Map each company's accounts to the group chart

One group chart

The group chart of accounts is the list of lines the group statements are built from. Each company's own accounts are mapped to lines on it once, and every later month uses the same mapping. Companies can keep their own charts in their own systems.

When a company comes in

Finconsol maps the accounts it can place by their type and name. For an uploaded trial balance it works in this order:

1. A mapping someone has already set is kept.
2. An account whose code and name match a group line of the same type goes to that line.
3. If the code matches a group line but the names do not, the account is not placed. Finconsol names the closest line by name, and you choose with Use this line or pick another.
4. Otherwise an account goes to a group line with a matching name.
5. Anything else stays unmapped for a person to decide.

Finconsol never forces an account onto a line it cannot recognise.

Map the rest

1. Open Account mapping. Each company has its own tab, with its accounts in sections by type, and each section says how many accounts are unmapped.
2. Switch on Show unmapped only.
3. Choose a group line for each account.

If you map an account to a line of a different type, such as an asset account to a liability line, Finconsol asks you to confirm with Map it anyway. Only an administrator can map accounts.

For equity accounts in a foreign company, the Historical rate column is where you enter the rate used to translate them. Which exchange rate is used explains why.

When a new account appears

When a refresh or an upload brings in an account that is not mapped, Finconsol stops the months it affects and names the account, on Account mapping and on the Data Health screen. Once someone maps it, the months carry on. No account is left out of the totals without anyone knowing.