I have imported my trial balance and as i have not imported customers, the debtors control account just states the bold figure. When I click on the figure, it states it was imported via trial balance which is fine… but i want to now create these customers that accumulated this figure and add their existing invoices… Is there a way I can do this without having to add to the debtors balance again.i dont want duplications
i want to be able to segregate it so it’s easily found instead of a bold figure on the balance sheet
When you imported the trial balance was it the closing trial balance from a financial year?
If so you could do the following.
Steps
Post a journal from debtors to the suspense.
Edit your invoices spreadsheet making sure the nominal codes on all entries are set to the suspense account.
Import your amended invoices spreadsheet.
Result
The breakdown on the debtor value will be split across your clients accounts.
The double entry will go to suspense and net off the journal you posted in the first step.
I would recommend checking this over with your accountant for tailored professional advice as I am not an accountant nor bookkeeper.