We have a separate bank account for each department/project. Each department/project issues VAT invoices and pays VAT on supplier invoices. Some suppliers do not charge VAT.
HMRC takes VAT due from only one of the bank accounts.
We need to be able to know how much VAT to transfer from each department/project into the main bank account to pay VAT to HMRC.
We need to know the VAT analysis by Department/Project for selectable date range. Net, VAT & Gross