/ivaExcelVAT working paper
The month's tie-out: VAT charged and collected, creditable VAT paid, and — above all — what doesn't reconcile.
- It asks you
- The period, the taxpayer, the calculation basis, and whether you break out the 8% rate.
- It delivers
- One row per invoice with its taxable base, VAT by rate, exempt and withheld amounts, plus the reference to the document each row came from.
By default it calculates on a CASH-FLOW basis, not accrual: an installment (PPD) invoice without its payment receipt doesn't enter the month. That's the number-one reason a VAT working paper doesn't tie out.