I always get stuck with suppliers’ account balances. Selecting the View Suppliers from the Purchases tab lists the suppliers with unallocated purchase invoices, even if the balance due may be zero. Drilling into a specific supplier then brings up the Supplier dashboard. Again, there is the total invoices that are yet to be allocated under the title ‘Account balance at a glance’. Then below the chart there is a total of ‘Prepayments’ which includes unallocated payments made and also Credit Notes that are held on account (not refunded). However there is no final balance due to the supplier anywhere. It actually has to be worked out by deducting once from the other.
Is there any way I can see a list of outstanding ‘balances’ after any unallocated payments and credit notes being deducted from unallocated invoices? That list should tally with the creditors control account in the chart of accounts.
Many thanks