web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / VAT GL accounts V VAT ...
Small and medium business | Business Central, N...
Suggested Answer

VAT GL accounts V VAT ENTRIES Report V VAT Statement

(4) ShareShare
ReportReport
Posted on by CS-04021000-0 55
Hi all 
 
I'm hoping somebody can help with the following query 
 
I'm trying to reconcile between three different VAT data sources ( reports) withing business central for all VAT entries to BC 
 
1 GL to VAT entries table  . 
 
 I can reconcile the Totals between the GL VAT accounts where GL account in ( 1,2)  to all data in the VAT entries table ,i have a couple of exceptions each quarter but all in all this works perfectly well each quarter.  I can reconcile the data at  document no level and highlight the exceptions using a full outer join etc or if i want to do this manually by downloading the VAT entries over a certain period and applying the same method by manually downloading the VAT GL accounts (1,2)
 
2 GL/VAT entries to VAT statement 
 
This is where i struggle , firstly i don't have a VAT statement within the BC database at document no level like the tables or reports above   and when i download this data manually from BC  it doesn't come close to either the GL VAT totals where gl account in ( 1,2) or the VAT entries table . 
 
Any suggestions how this can be resolved ? 
 
Many thanks 
 
 
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Sumit Singh Profile Picture
    Sumit Singh 10,079 on at
    Why VAT Statement Doesn’t Match
    1. VAT Statement is user-defined: It’s based on VAT Statement Templates and VAT Statement Lines, which aggregate data using filters (e.g., VAT Posting Groups, Date Filters, etc.).
    2. No direct link to Document No.: Unlike VAT Entries or GL Entries, the VAT Statement is not transactional—it’s a reporting tool.
    3. Manual configuration errors: If the VAT Statement Lines are not correctly mapped to VAT Posting Groups or accounts, discrepancies will occur.
     Suggested Resolution Steps
    1. Review VAT Statement Setup
    • Go to VAT Statement Templates and VAT Statement Lines.
    • Check:
      • VAT Posting Group filters
      • Account filters (GL accounts used)
      • Calculation type (Net Change vs Balance)
    • Ensure these match the logic used in your GL and VAT Entries reconciliation.
    2. Create a Custom VAT Statement Report
    Since the standard VAT Statement lacks document-level granularity, consider:
    • Creating a custom report or query that:
      • Pulls data from VAT Entries
      • Groups by VAT Posting Group, Period, and optionally Document No.
      • Matches the logic of your GL reconciliation
    • This can be done via Query object, Power BI, or Jet Reports.
    3. Use Analysis Views or Account Schedules
    • Set up Analysis Views or Account Schedules to track VAT GL accounts with filters by VAT Posting Group.
    • This gives more flexibility and can be exported for reconciliation.
    4. Automate Reconciliation
    • If you're manually downloading data, consider building a Power BI dashboard or Excel Power Query that:
      • Pulls VAT Entries and GL Entries via OData
      • Performs full outer joins and highlights mismatches
      • Compares against VAT Statement logic
    5. Audit Posting Setup
    • Check VAT Posting Setup and General Posting Setup to ensure:
      • Correct GL accounts are mapped
      • No missing or misconfigured combinations
    Bonus Tip
    If you’re using multiple VAT Posting Groups or multiple jurisdictions, consider creating separate VAT Statement Templates for each and reconciling them individually.
    Note: This response was created in collaboration with Microsoft Copilot to ensure clarity and completeness. I hope it helps to some extent.
    Mark the Answer as Verified if this is Helpful.
     
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at
    I am not sure what region is your environment, but VAT Statement does exist in BC but you need to use VAT Statement Name Setup with Row Definitions just like financial statement.
     
    Please refer the video below.
     
     
     
     
  • Suggested answer
    Sohail Ahmed Profile Picture
    Sohail Ahmed 11,136 Super User 2025 Season 2 on at
    The VAT Statement won’t match your G/L or VAT Entries at document level because it’s a summary report driven by the VAT Statement setup (posting groups and filters), not a transaction table. If numbers don’t align, review your VAT Statement Line setup to ensure all VAT posting groups are included. For detailed reconciliation, always use the VAT Entries table against the VAT G/L accounts.
     
    ✅ Mark this as the verified answer if helpful.
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans