VAT summaries

Questions (nl)
1

Can I also merge VAT overviews from multiple administrations in Exact Online into one Excel file?

2

What is meant by “VAT overviews” and “merging”?

3

The overview I’m referring to is under: Financial; tax; VAT overview. But because we have 11 BVs, I would like to have it in one file.

4

This overview is provided by Exact Online. There are no predefined overviews, and given the announcement to XML by Exact Online, there are certainly no plans either.

However, you can try to compile the data yourself. As far as is known, the underlying information is available through the tables that begin with VAT, such as:

select vbk.division_name
,      vbk.vat_code_attr
,      vbk.vat_description
,      vbk.vatbox_country_code_attr
,      vbk.type_attr /* See VatTypes. */
,      vbk.taxreturntype_attr
,      vbk.sign_attr
,      vbk.vat_gltoclaim_code_attr
,      vbk.vat_gltoclaim_description
,      vbk.vat_gltopay_description
,      vbk.vat_gltopay_type_attr
,      vbk.vat_gltopay_code_attr
from   VatBoxLinks@eol vbk

The balances are in BalanceLinesPerPeriod.

5

This question has been automatically closed after 1 week of inactivity. The last given answer has been marked as the solution.

Please raise a new question in a separate topic if the issue occurs again. In the new question, please include a link to this topic by pasting the URL into the text.