Report on transactions analysed by VAT rate

My client uses one of the retail VAT schemes where they apply the split of zero rated and standard rated direct purchases to their sales to work out the VAT on sales.

Quite a lot of their purchase invoices have both zero rated and standard rated items. However when I run the VAT report it only shows one rate against the invoice and net cost. Is there a report I can run that will show the net cost of purchases at zero rated and the net cost of standard rated purchases on invoices where there are both rates. It will save me having to go back into each invoice and manually check them.

Many thanks.

(Sent from /craftholecommunityshopcic/accounting/reports/vat-return/)