There are a few things to note about this report:
The tax report works purely based on invoices/bills.
VAT is charged on accommodation items and upgrades. Payments do not have VAT rates associated with them, therefore any values shown are using the VAT rate set at the item/upgrade level.
You will see two figures on the tax report:
The Ex VAT, which displays the item price exclusive of VAT.
The VAT Rate, which shows the VAT Rate that was applied to the item at the point in time when the bill was created. If you do not see a figure here, it means there was no VAT Rate that was associated with the item.
The Ex VAT amount closely reflects what can be seen on the associated bill. Where there are discounts or write-offs involved, there is some special logic in place. This is as follows:
If a discount is applied to the bill, the discount will be distributed top to bottom on each of the bill line items. So if we have an accommodation item worth €50, and an upgrade worth €20, with a discount of €60. €50 will be taken away from the accommodation item, resulting in a €0 Ex VAT value. And the remainder of €10 will be taken away from the upgrade resulting in a €10 Ex VAT value.
If a write-off is applied to the bill, the same process used for discounts applies.
The totals for each VAT rate are shown at the top of the report. Each VAT rate is displayed in a row alongside two value columns, one for Revenue (Net) (i.e. the total Ex VAT at that rate), and one for VAT Amount (i.e. the total VAT collected at that rate).