Taking on customer balances |
Top Previous Next |
Taking On Customer Balances (Debtor Opening Balances)
1️. Obtain Customer Balances
Retrieve balances from the Age Analysis report in your previous system.
2️. Manual Method: Enter Opening Balances
•Go to Customer > Customer Journals, then click New Journal.
•Select the General Ledger account. Usually Capital or Retained Earnings account.
3. Entering Aged Balances
•Obtain balances for each aging period from your old system.
•Enter them separately, ensuring the date selected matches the aging for each customer.
(See image below)
4. ✅ Preferred Method: Importing from Excel or CSV
Go to Customer > Extra, then:
oSelect Customer Import to import from Excel.
oSelect Customer Import from CSV to import from a CSV file.
5. Finalizing the Take-On Process
Print the Customer Age Analysis report and compare it with the one from your old system to confirm accuracy.

To make sure that you have processed the take on correctly, print the customer age analysis and compare it with the one you used to take on the balances.
