Introduction

The UK version of Business Central gives the ability to submit your VAT return via the Making Tax Digital functionality. This enables you to connect to HMRC and download your VAT obligations and subsequently submit your VAT return.

However I’ve found that sometimes even though the VAT return has been submitted to HMRC and the “VAT Return Status” changes to “Accepted” the “Status” of the VAT Return remains as “Open” and consequently the message “Your VAT Return is Overdue…” is displayed on the Home Page (depending on your role centre) and also in the “Additional Information” on the VAT Return Periods page.

In this post I’ll walkthrough how you can remove this message.

VAT Returns Period Page

As per the screen shot below I’m getting the message “Your VAT return is overdue since 07/08/23” in the “VAT Return Periods” page however the VAT Return Status is “Accepted”.

The period in question is 01/04/2023 (1st of April 2023) until the 30/06/2023. Therefore in order to remove this message I click “Get VAT Return Periods” and enter the same dates into the page as per below

The system then connects to HMRC to gather data on that range and although there are no new overdue VAT Return Periods in that date range it updates the status of any VAT returns within the date range.

You are then presented with the update box below

This message states “Retrieve VAT return periods successful. Including 0 new and 1 modified”.

This means although no new VAT Return Periods were received in the date range 1 was modified.

Now both the “VAT Return Status” and “Status” are closed and the message has gone 🙂

Conclusion

This post explains how you can update both the “VAT Return Status” and “Status” of a submitted VAT return using the “Get VAT Return Periods” option.

If you have numerous VAT returns showing the same issue you can enter a large date range and have the system update all your VAT return statuses.

Thanks for reading!

Introduction

In this post I’ll walkthrough a method I use to quickly find all VAT entries that have been closed on a previous VAT statement using the G/L Registers page.

You can then export the entries to Excel and recalculate the submitted VAT return by summing each VAT Business and VAT Product posting group combination.

I use this technique if I’m investigating a VAT issue following the “Calculate and Post VAT Statement” routine and I want to see the detailed VAT entries that were closed.

G/L Register

The G/L Register page records an entry for every posting that is made in Business Central, including the posting that’s created when you run the “Calculate and Close VAT Statement” process. As a side note, It also happens to be one of my favourite pages in Business Central 🙂

Therefore if you open the “G/L Register” page and then filter on “Source Code” equal to VATSTMT you get a list of all G/L registers that have been created when closing the VAT statement.

Now you can highlight the G/L Register that relates to the VAT Statement you want to view closed entries for and select “Process > VAT Entries”

This lists the “Settlement” VAT entries that were created when the “Calculate and Close VAT Statement” was ran.

Now take the Entry No’s shown in the filter and create a new filter using the same range but using the “Closed by Entry No” column

This will list all VAT entries closed by the settlement entries, which is effectively a reprint of the VAT statement 🙂

You can now take this to Excel and continue your investigations.

Conclusion

This is just one technique you can use to get a list of the closed VAT entries however I find it the quickest and it also gives me an excuse to use the G/L Register page 🙂

Thanks for reading!