Prepare a chart of accounts that makes reports useful
A clear chart of accounts helps finance explain where money comes from, where it goes and what the business owns or owes. Agree the reporting structure before importing balances.
A worked record to reuse
Example opening balances in illustrative currency units, matching the prose example. Finance must also match the customer invoice list to 2,000 and the supplier bill list to 1,500; a balanced total is only one check.
| Account | Debit | Credit |
|---|---|---|
| Cash | 5,000 | 0 |
| Customer receivables | 2,000 | 0 |
| Supplier payables | 0 | 1,500 |
| Equity | 0 | 5,500 |
| Total | 7,000 | 7,000 |
Use your own records to work through the example and identify the next action.
1. Start with the reports you need
List the legal entities, financial year, currencies and reports your finance team uses. Group accounts into assets, liabilities, equity, income and expenses. Decide which detail belongs in an account and which belongs in a product, department or project, so the chart does not become a list of every transaction.
2. Build a mapping sheet
Give each existing account a destination and a reason. For example, two old office-supplies expense accounts might map to one new account. Keep customer receivables and supplier payables separate; their balances need to reconcile with individual open documents. Never merge accounts solely because their names look similar.
Use these columns: old code; old name; closing balance; new code; new name; account type; tax treatment; mapping owner; review status. Mark unused accounts inactive after checking their balances and historical reporting needs.
3. Reconcile a small example
Suppose the opening balances include cash of 5,000, customer receivables of 2,000, supplier payables of 1,500 and equity of 5,500. Debits and credits both total 7,000. Also check that the customer invoice list totals 2,000 and the supplier bill list totals 1,500. A balanced trial balance alone does not explain a mismatch in those lists.
4. Walk through ordinary transactions
Enter a customer invoice, supplier bill, payment and adjustment in the implementation environment. Review the journal entries and the resulting reports with finance. Confirm how taxes, rounding and foreign-currency balances should be handled for your business. Your accountant or local tax adviser should approve the chart and statutory treatment before live postings.
Keep the structure under control
Name an owner for new accounts. Require a purpose, account type and reporting destination before adding a code. Datrylo implementation can bring the mapping, opening balances and finance workflow together around this agreed structure.