Sage Chart of Accounts Mapping Worksheet

How to use it

Enter each old account with its name, then the new account number and name you want. Choose the account type and enter the debit or credit balance from the trial balance at the cutover date. The sheet calculates the net and the total out of balance amount. Merge accounts by giving several old rows the same new account. Split accounts by listing the old account several times with different new targets and amounts.

• Use one trial balance date for every row
• Map many-to-one only when history reporting allows
• Record segment or dimension notes for each row
• Freeze the new chart before loading anything

Proving the conversion

The out of balance figure must be zero, and the account type totals should agree to the source system's balance sheet and income statement at the same date. Check control accounts such as AR and AP against their subledger aging reports. For an opening balance load, income statement accounts are usually zero at the start of a fiscal year, with prior earnings in retained earnings.