Individual Debtors Accounts

[Nakwila]

Good Day Pastel Gurus,

Trust we are all well. I need assistance, I took over work from someone. On the system Pastel.V19 there is a Customer Control Account with a closing balance of say N$100 000 at YE 2019 (Reflected on TB) but no individual debtors records. These are maintained outside Pastel. It is my wish to have individual debtors on pastel too. How do I go about to split the balance on the Customer Control Account to create individual debtors accounts, with opening balances for FY2020?

Would I be on the right track to:

In 2019 database, year end done:
1. Create Debtors on the system
2. Create a balance sheet suspense account with debtors subaccounts eg 9980/000 Suspense with 9980/050 - debtors
3. Journalise: Dr Individual debtor and CR Suspense account?

How will the suspense account clear-out, or is there a better way to process this?

Many thanks, folks

[Neville Bailey]

Yes, the above method will work, but you are missing one step.

Before creating the individual debtor accounts, you need to process a general journal to credit the Customer Control Account with the balance and debit the Suspense Account.

Then go to Setup...Customers...Control and set up the Customer Control Account as the control account (as I suspect it is currently not set up as such).

[Nakwila]

Thank you Neville for the prompt response. There is already a Customer Control Account(8010/000) which has the e.g overall debtors balance of 100 000 (dr balance) on the face of the TB (which I think was brought in by the auditor through the gen journal.)

[Nakwila]

Any further assistance, Team?

[Nakwila]

Sorted, Team...Again, thank you Neville!