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.

 

 

Customer balance

 

 

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.

 

 

 

 

Keywords: Taking on customer balances