Clean up your chart of accounts without losing history

“Stationery”, “office stationery” and “office supplies” can all be valid accounts. If nobody knows which one to choose, they aren't giving you useful detail. The answer is a consistent reporting purpose and a documented mapping, not an arbitrary target number of accounts.

This guide is for an established file with transaction history. The Xero setup checklist covers choosing accounts before that history builds up.

Export the chart and the reports it feeds

Save the current account list with codes, names, types, default tax settings and active status. Export a profit and loss report, balance sheet and trial balance for the last completed period, plus any comparative report you regularly use. Record the period, reporting basis and filters on each.

For each account, ask what decision it helps you make. Separate materials from subcontractors if you review those costs independently. A supplier-specific account might be unnecessary if the contact report already provides that detail.

Check activity, not just the current balance. An account showing zero today can still contain years of transactions, integrations or automated rules. Payroll, tax, bank and system-control accounts deserve particular care.

Build a mapping before changing the file

This fictional chart contains three overlapping office-cost accounts. The plan groups them in reports but preserves old entries. It also keeps merchant fees and computer assets separate.

Old code and name	Reviewed period amount	Proposed action	Future destination / check
400 Stationery	$600 expense	Rename to Office consumables.	400; verify existing tax default.
401 Printing paper	$400 expense	Archive after rules are updated.	Future ordinary stationery to 400; history stays on 401.
402 Office bits	$200 expense	Review entries, then archive.	Future suitable purchases to 400; no bulk recode.
405 Merchant fees	$180 expense	Keep separate.	Provider documents still determine tax treatment.
710 Computer equipment	$2,200 asset	Leave unchanged.	Do not move assets into office expenses.

Historical report check: office group $600 + $400 + $200 = $1,200 before and after. With merchant fees of $180, the selected expenses still total $1,380. The $2,200 asset remains on the balance sheet.

Original ASBG account map. Codes are illustrative, not a recommended standard chart. The plan changes future choices and report grouping, not the substance of old purchases.

Add columns in your working register for approver, change date, rule updates, report comparison and unresolved questions. Keep the old code and name even after renaming, so someone reviewing an earlier export can follow the change.

Choose between renaming, archiving and merging

Rename when the purpose is sound but the label is unclear. Check whether old reports will display the new name, and retain the mapping with your baseline reports.

Archive when an account should remain in history but disappear from routine future choices. Xero states that archiving preserves entered transactions and reporting, and that an account used in a transaction can't be deleted. Locked and system accounts have further restrictions. Other products' controls differ, so check the current documentation before acting.

Merge or recode only after reviewing the entries and effects. Some systems offer a merge; others need individual recoding or report grouping. Don't assume either is reversible. A bulk move could change historical classifications, tax calculations, project reporting or reconciled records. Have the accountant approve structural changes and an appropriate recovery plan first.

Update the things that keep using old accounts

Check bank rules, recurring bills, invoice items, payroll mappings, payment integrations and import templates. Otherwise new entries may continue using an old account or start failing after it is archived.

Set a clear cut-over date and tell anyone doing data entry what to choose. Don't change a default GST setting merely to make account names consistent. Purchases with different tax treatment may share a reporting group while retaining their correct transaction-level codes.

Compare reports using identical settings

Rerun the saved reports for the same dates and basis. Compare overall totals, individual group totals and the asset/liability balances. A tidy profit and loss report can hide an incorrect move from an asset account, so review the balance sheet too.

If a total changed when your plan only involved naming, archiving and presentation, stop and find the cause. Use the profit and loss guide to distinguish useful grouping from changes to the underlying results. Keep a period-lock record for any authorised changes affecting a finished period.

Key takeaways

• Design account names around decisions and consistent entry.
• Preserve historical mappings and compare before-and-after reports.
• Review structural changes, tax defaults and automated rules together.

Where to get help

Prepare the export and proposed mapping for your accountant before merging or moving historical entries. Use your product's current account-management instructions and the bookkeeping and BAS collection for related checks.