Validation of the calculated amounts in the boxes in the VAT declaration report

(0) Share

Report

Posted on by PasqualD

Hi Forum members,

I spent quite a while of validating my VAT declaration report (German) with the actual tax transactions.

For all of the boxes I can reconcile easily with the posted sales tax transactions and the according filters, but the result in the box 66 /Input tax amounts from invoices from other companies/ gives me a hard time. I have a good understanding of the input VAT transactions, but they dont reconcile to the value in the VAT report.

Has anyone experienced a way to debug the VAT report on a transactional level?

Im happy to share more insights and experiences in the setup, if you are interested!

Thanks,

Pasqual

I have the same question (0)

All responses (5)

Answers (0)

André Arnaud de Cal... 303,269 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Pasqual,

I'm not familiar myself with the German VAT declaration. The setup might be different per implementation. It could be due to a wrong setup e.g. on the Tax codes. I would suggest that you get a Finance consultant who can review the setup and potentially do a deep dive into the transactions.

Was this reply helpful? Yes No
PasqualD 83 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

thanks for your reply. Well, I am the finance consultant in this project;) Really basic things, I added two screenshots: 1. posted input sales tax transactions in March with the sum of 2413€. 2. The advance VAT declaration preview Excel shows 68946,35 €. There are no other tax transactions posted in March. So I am really wondering what is behind the box 66 in the Excel report.

With this I think its more a technical issue? I am happy for any ideas to deep dive the ER VAT declaration calculation.

Thanks &

Best regards,

Pasqual

Was this reply helpful? Yes No
PasqualD 83 on at

Like (0)

Report
Copy link

Link copied!

Hi guys,

the additional value of €66533,35 shows up in every future monthly VAT statement preview. Really strange! Does someone have experience in data consistency exercises or any other idea for this problem?

Best regards,

Pasqual

Was this reply helpful? Yes No
André Arnaud de Cal... 303,269 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Pasqual,

You can check if there is a known issue on LCS issue search. If there is nothing listed, a developer might be able to use the debugger or do reverse engineering to find out where this amount comes from. At the end, you can also create a ticket for Microsoft Support, but like you, I expect that it might be a data issue.

Was this reply helpful? Yes No
Suggested answer

PasqualD 83 on at

Like (1)

Report
Copy link

Link copied!

Hi Andre,

I found the reason for the amount I could not reconcile. The function "include corrections" was turned on. Therefore all transactions posted after the periods were settled in the past will be included in the current reports. I have run for those

periods "settle and post sales tax" with the latest corrections process again and voila the amounts reconcile to the 66533,35€.

This thread can be closed.

Thanks

Best regards,

Pasqual

1 people found this reply helpful.

Was this reply helpful? Yes No