How dashboard figures are calculated

Money owed to you

This total shows all unpaid and overdue invoices based on the current date. You can click on this total to see a list of unpaid invoices.

Any part payments on these invoices and any advanced payments assigned to these customers are not included in the total.

If you have allocated advanced payments to a customer, but not to an invoice, the payments will not be included in this total. that have not yet been allocated to an invoice are not included in this total. For example, if you have an outstanding invoice with a gross of £100, and the customer has already paid £25, but this payment has not been allocated to the invoice, the Money Owed figure will be £75. For more information, refer to Record advanced payments and deposits.

This figure is made up of the following factors:

  • VAT Liability (only if you have enabled in Display Settings)

  • Total value on Aged Debtors report

  • Any overpaid invoices

If the VAT liability is a minus figure, it will be included in this calculation. If the VAT liability is positive then it will be included in the calculation for the Money you owe.

Money you owe

This figure consists of all unpaid and overdue receipts (as of the current date) minus any part payments on these receipts and any advanced payments assigned to these suppliers.

Any advanced payments that have not yet been allocated to receipt are not included in this total. For example, if you have an outstanding receipt with a gross of £100, and the you have already paid the supplier £25, but this payment has not been allocated to the received, the Money you owe figure will be £75. For information, refer to Record advanced payments and deposits.

  • VAT Liability (only if enabled in Display Settings)

  • Total value on Aged Creditors report

  • Any overpaid purchases

If the VAT liability is positive then it will be included in this calculation. If the VAT liability is a minus figure, this will be included in the calculation for Money owed to you.

Overdue Invoices

This is a total of all unpaid invoices that have passed their respective due dates, less any part payments on overdue invoices.

Overdue Purchases

This is a total of all unpaid purchases that have passed their respective due dates, less any part payments on overdue purchases.