It is all related to Unallocated/Part Paid Invoices.
TBH, thats the most confusing part of your system…
when you click of the Dashboard into the list of invoices o/s, you should show the Outstanding invoice amount not the original one, as its not relevant, the toggle should be the opposite way round so you can see original invoice amount.
it was those and the unallocated money causing the confusion.
therefore, outstanding invoices on display less unallocated money = Sales Control
this is really confusing too and needs some work…
when i view unallocated payments, the top £20 should show £2, and in description 'original value £20, the top two are for the same account, there is £20 unallocated on that account.
the last two on the list are for another single account, totally wrong as the refund looked like this:-
on the list it should really show £313.01 (£324.35 is meaningless now, maybe show on left like above)
so total prepayments = £1008.38+£313.01
lucky i didnt have too many transactions to check, but it would be a load of work if someone had a lot of unallocated amounts or part allocations/refunds.