It would be great if one could have an option to show the amounts owed and money you owe less the VAT, as this would actually show me my real financial position
Thanks for the suggestion. It can however get complicated with partial payments and multi-line invoices with variable VAT rates. Say you have an invoice with the following lines:
Line 1 £100 NET, £20 VAT
Line 2 £50 NET, £0 VAT.
Total NET = £150
VAT = £20
GROSS = £170
If a partial payment of £100 is then applied to the invoice, you have a problem of working out the NET on the payment. If you workout the effective rate of VAT on the whole invoice and apply this to the payment, when multiple payments are applied you can end up with all kinds of rounding problems. All the additional computation to make this work would inevitably slow everything down.
Just my initial thoughts on this… as the dashboard is hit so frequently all the calculations that appear hear must come back extremely quickly.