When payments on account are made by a customer and a client is in credit a prepayment has to be posted, however this does not show on the receivables listing or client account as a credit it still shows nil - so unless you are aware of this and run a separate individual report for each customer true balances for customers cannot be tracked easily. Would be not be possible to add a report or additional column for customer balances inclusive of prepayments? The only way to track this is then manually reconcile the debtor prepayments control account which will become more and more time consuming over time as transaction numbers increase.
When payments on account are made by a customer and a client is in credit a prepayment has to be posted, however this does not show on the receivables listing or client account as a credit it still shows nil - so unless you are aware of this and run a separate individual report for each customer true balances for customers cannot be tracked easily. Would be not be possible to add a report or additional column for customer balances inclusive of prepayments? The only way to track this is then manually reconcile the debtor prepayments control account which will become more and more time consuming over time as transaction numbers increase.