Discrepancies VAT report vs. Posted sales tax

(1) Share

Report

Posted on by FredSt

Hello everyone,

I am struggling to resolve a discrepancy between what is reported in the VAT report (Tax > Declarations > Sales Tax > Report sales tax for settlement period [which is set to VAT declaration Excel (DE)]) and the numbers in the Posted sales tax form (Tax > Inquiries and reports > Sales tax inquiries > Posted sales tax).

Summing those up by VAT code shows discrepancies between both (c. 2.000 € that are on Posted sales tax, but not the VAT declaration, and [on a different VAT code] c. 100 € that are in the VAT declaration, but not the Posted sales tax).

Is there any way to get a list of the transactions that Dynamics counts into the VAT report? I'd reckon comparing the voucher numbers would yield the transactions that are responsible for the discrepancy.

Best regards

Fred

2024-12-09 17_28_51-Posted sales tax_638690829614355910 - 06.12.2024.xlsx - Excel.png

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (2)

Suggested answer

Alireza Eshaghzadeh 14,686 Super User 2025 Season 2 on at

Like (1)

Report

Hi,
There isn't a standard report for this purpose, but you can troubleshoot the issue by running the Posted sales tax report for a specific tax code and time interval. This will help you verify whether the transactions are posted with the same tax direction and if the Reverse charge flag is populated.

I recommend using the VAT Declaration Excel (UK) report and adding a mapping table for tax codes via Application specific parameters. This allows you to analyze how the report is generated based on the mapping table.

Was this reply helpful? Yes No
FredSt 6 on at

Like (0)

Report

Hello Alireza,

thank you for your suggestion. I checked Posted sales tax and there are no reverse charges.

I tried reconciling the Posted sales tax data with the General Ledger accounts for both directions, and they also don't match. So in three data sources (VAT, PST, GL), I've got three different numbers.

How do I get to these Application specific parameters? I can't seem to reach them from the normal F&O home page via search.

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,686 Super User 2025 Season 2 on at

Like (1)

Report

To access Application Specific Parameters for "VAT Declaration Excel (UK)", follow these steps:

1.Import the Configuration
Import the "VAT Declaration Excel (UK)" configuration from the Dataverse repository.

2.Set Application Specific Parameters
Navigate to the Electronic Reporting Configuration workspace, select "VAT Declaration Excel (UK)", and click on "Application Specific Parameters" to configure the VAT mapping table.

3.Set as VAT Statement Format
Go to General Ledger Parameters, locate the Sales Tax section, and assign "VAT Declaration Excel (UK)" to the VAT Statement Format Mapping field.

Now, you can run the "Report sales tax for settlement period" with this new configuration.

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,686 Super User 2025 Season 2 on at

Like (1)

Report

To run the report with this new configuration (VAT Declaration Excel (UK)), ensure that the report layout is set to "Default".

In the standard SSRS report, the English report layout might be used. However, you need to assign a report code to each tax code to successfully generate the VAT 100 report.

Was this reply helpful? Yes No