VAT Analytics
The VAT Analytics Report provides an overview of all your VAT activities. To generate a report, you need to filter by invoice date range and select a specific company or company group. Additionally, you can access a range of filters, including country of refund, VAT flow, and extraction method, by unfolding the Additional Filters section.
This page also shows when the report was last updated. Reports are stored temporarily (typically for 10-30 minutes, depending on the amount of data processed) to increase efficiency and avoid repeated long wait times for generating reports from scratch. This allows you to quickly update the report with new filters without starting over.
The report includes several key performance indicators (KPIs). The Number of Invoices reflects the total invoices considered based on your filters, along with the absolute value difference compared to the same period last year. For instance, if you select a date range from January 1, 2023, to December 31, 2023, it will show you the corresponding values for January 1, 2022, to December 31, 2022. The VAT Amount represents the total VAT paid during the chosen date range, while VAT Recoverable is calculated based on recoverability rules per country (for example, in France, only 80% of VAT paid for fuel expenses can be recovered) and includes VAT amounts for expenses that are not marked as "Excluded" or "Rejected."
The report also visualizes data insights. The VAT Recoverable per Country of Refund is presented in a pie chart format, showing the percentage of VAT recoverable across domestic and foreign flows, further distributed by country of refund. If a country wasn’t set up manually or identified using Smart AI, it will be labeled as "Null." The VAT Process Funnel illustrates the distribution of data throughout the VAT Return pipeline, divided into Foreign and Domestic categories, showing the entire VAT expenses, what is potentially recoverable, what has been claimed, and what has been successfully refunded.
Furthermore, the VAT Overview per Status categorizes the VAT amounts into Backlog (comprising expenses with statuses of Incomplete or Ready), Claimed (covering statuses of Claimed, Claimed to Vendor, Query, Appeal, or Rejected), and Approved (for expenses with an Approved status). Users must set up these statuses themselves for accurate reporting.
You can also compare VAT status on an annual basis, visualized through graphs that display comparisons of VAT status (approved, pending for decision, backlog) year over year. Hovering over the graphs reveals actual numbers. Additionally, the VAT Recoverable - Backlog Analytics section shows invoices in statuses of Incomplete, Ready, or Excluded, indicating how many invoices still need processing for VAT recovery. It also provides insights into excluded invoices, detailing the percentage of backlog deductible amounts marked as Ready.
Finally, the Excluded VAT Breakdown offers a pie chart representation of VAT amounts across excluded invoices, broken down by the reason for exclusion. This helps identify recoverable VAT versus amounts that cannot be reclaimed due to issues like expired deadlines or missing documentation. At the very bottom of the report, you'll find VAT Recoverable per Entity, which indicates how much VAT can be recovered per selected company. Overall, the VAT Analytics Report serves as a powerful tool for effectively managing and understanding your VAT position.