I am determined to get a sane UK style Invoice Register together. It's just a report of invoices sent in a given period, by date, listing which ones have been paid (and usually 'when' and 'how').

Here's my Invoice Register 0.1.

It's not right, yet. I can't crack how to put the VAT figure in (Tax Amount doesn't seem to do it - found in Invoice's Taxes).

Another thing was the end column - reporting 0 if it's been paid. I note the 'evaluate mathematically' bit, so wondering how to write something like

if cell <> 0 then "UNPAID" else DateOfLastPaymentSlip

If you see what I mean. Improvements gratefully welcomed!