I’m having difficulty matching the Balance sheet Debtors balance to that shown in outstanding Debtors
The Outstanding debtors is higher in the Outstanding Debtors due compared to the Balance sheet?
Confused why the figures are different?
Can you help me Identify the issue
Hi @1andy_mc
It’s likely to be caused by pre-payments that are registered on the account.
If you take a look at the Debtor / Creditor Report (Reports >> Show All Reports), this will give you a breakdown of the balance at the bottom. For example, 1100 Balance
(which should match your Balance Sheet report) and Prepayments
[Edit]
Just to expand on this further, if you want to view the breakdown of prepayments, there are 2 ways to do it.
Go to Sales >> View clients, and do an Advanced Search with the Prepayments option ticked. This will show you the prepayment balances on a client-by-client basis.
Go to Sales >> View payments, and do an Advanced Search with Type set to Unallocated. This will show you all the payments that have been received from clients, but are yet to be allocated to an invoice.
The same would also apply for suppliers from the purchases menu rather than sales.