I found an answer which might help me in an old post https://community.quickfile.co.uk/t/debtor-control-account-balance-unallocated-items/12186
but I there is no advanced search or unallocated option so I think you moved it.
I am trying to reconcile my debtors figure on the balance sheet on 31/12 with the info from the debtors report. I think my problem is that some customers have made a prepayment which is not reflected in the debtors figure - Is there a way to get a balance for each customer on a specific date, or to report any customer with a positive account balance? - Thanks