How do i find a breakdown of the debtor and creditor control account balances at a specific date without going through each entry separately?
If you go to Reports > All Reports, there’s an option for historical debtors and creditors:
Simply enter the date, select what you want to view, and it will show you a list of anything outstanding on that date (along with a total in the top right):
Hope that helps! 
Thank you very much. I have done that but the balance does not agree with the figure showing on the balance sheet. How can that be?
Are you viewing both for the same date?
the exact dates are showing and the figures are not the same.
Why are the figures on the Balance Sheet not the same as the figures on the Chart of Accounts for the Debtors and Creditors control accounts?
I notice a difference of £15.09 between mine. However, I do have a £15.09 pre-payment sat on my account, which is where this comes from.
On the historical report, you should see this in the top right hand corner of the report:
Is this value 0.00? If not, does this value equal the difference between the balance sheet and your report?
1 Like
yes thank you. In the end I worked it out on my account.Is there any way of seeing the pre-payments without exporting the data?
Glad you sorted it! 
Although it won’t necessarily show just prepayments, using this will help.
Go to Sales > View payments:
Then do an advanced search for ‘Unallocated’:
Hope that helps? 
This topic was automatically closed after 7 days. New replies are no longer allowed.