Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV forum / UK VAT Return query
Microsoft Dynamics NAV forum
Unanswered

UK VAT Return query

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I currently use an excel spreadsheet to prepare my UK Vat return as I can't work out to set the NAV ( 2017)  report date criteria correctly and end up with the wrong VAT amount in my control account. I journal Vat between my general accounts to get the correct amount in my VAT control account. With MTD  on the horizon I need to work out how to use NAV properly. Here is an example of what goes wrong with a VAT return end date of 31 March. If  I post a purchase invoice with a document date of say 29 March and a posting date of say 5 April, the document is excluded from calc and post but if I extend the end date to 5 April NAV calc and post includes all documents posted to 5 April and included documents dated after 31 March which belong to the next Vat quarter. Can anyone advise me what  I am doing wrong ? Many thanks

Categories:
Financial Management
  • Landat Profile Picture
    Landat 5 on at
    RE: UK VAT Return query

    I'm not sure about NAV but in Dynamics GP you can choose document date or posting date when setting the VAT Calendar for the year?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: UK VAT Return query

    I think that I need to wait until Microsoft releases the update for MTD to see if this addresses the problem, but at least I gave a few work arounds. Thank you for your advice everyone. 

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: UK VAT Return query

    I think it is fine to handle VAT upon Posting Date.

    Let's say you have an invoice which is dated on the 20th October, but you received it on the 5th November.

    As far as I'm aware it's ok to have the VAT in the next period, even when the invoice is dated on the 20th Oct.

    But, if you want to handle it a different way (based on Document Date), you need a customization for this.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: UK VAT Return query

    Yes I am, I do find it very useful to have both the actual posting date and the document date as that is what I am used to, and other accounting packages I have used do allow use of both the posting date and the invoice date for Vat reporting.    

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: UK VAT Return query

    The Posting Date is used to post the transactions in the CoA (incl. VAT) and Customer Ledger Entries.

    The Document Date is just used as a date, that determines the date of the printed document (but not the date of the financial transaction).

    There is no general rule for UK companies to match the Posting Date with the Document Date.

    In regard to month end, it depends on your business.

    One of my UK clients does take care that all sales and purchase orders are processed before they close the year (or month).

    I assume you are asking this question for purchase invoices which arrive late?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: UK VAT Return query

    Would that be usual practice for UK Vat registered companies ie to match the posting date to the document date, wouldn't that cause problems at year end as you may have to post back to a  previous year?

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: UK VAT Return query

    Hi,

    Sure, you can modify the source code of NAV and add any kind of extension.

    But, in your situation -- why not keep the Posting Date the same as the Document Date?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: UK VAT Return query

    Hello, yes I know that the VAT statement uses the Posting date but the VAT reclaim should be based on the document date. Is it possible to add more criteria to the VAT Calc and post report and the Vat statement i.e. posting date up to x and document date up to date x.  

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: UK VAT Return query

    Hi,

    I think the VAT Statement is based on the Posting Date.

    Because when you post a Purchase or Sales Document, the VAT is moved into the CoA using the Posting Date.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: UK VAT Return query

    Hello Nitin

    I leave the start date blank in my report but can't find a tax detail table.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,552 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,552 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans