Dynamics 365 Business Central – Configuring Partial Exemption VAT using standard features

Introduction

If your business is partially exempt for VAT, you’ll need a method for tracking your VAT entries, so you can post adjusting entries to the VAT return.

In this post I’ll go through the basics of what being partially exempt from VAT means, and how you can configure Business Central to accommodate this using standard features.

** Please note there are specific non-recoverable VAT features in Business Central which I don’t cover in this post however those features compliment this configuration rather than replace it.

Normal VAT

Normally, a business would supply goods or services and charge VAT (output VAT) and also buy goods or services and pay VAT (input VAT). Then, at the end of the VAT period, the business calculates whether they need to pay HMRC (i.e. the output VAT is more than the input VAT) or reclaim VAT from HMRC (i.e. their input VAT is more than their Output VAT).

This is easily setup using standard Business Central VAT Product Posting Groups as per below:

What is Partial Exemption for VAT

The above description of Normal VAT assumes all supplies the business makes are subject to VAT (i.e. all supplies the business makes are taxable at 20%, 5%, 0% VAT). These rules don’t apply when a business makes both taxable and exempt supplies. When a business makes exempt supplies, they can’t reclaim all the input VAT on all their expenses.

The rules for claiming input VAT when you make exempt supplies and taxable supplies are as follows:

Input VAT TypeRule
Input VAT that relates directly to exempt suppliesNone of the Input VAT can be reclaimed
Input VAT that relates directly to taxable suppliesAll of the VAT can be reclaimed.
Input VAT that can’t be directly attributed to exempt or taxable suppliesA portion of the VAT can be reclaimed.

With regards the final point, this relates to expenses like accountancy fees or rent. Basically any expenditure that is incurred for the business to operate. The business can only reclaim a portion of the incurred VAT for these expenses, with the amount that can be recovered being calculated based on the exempt and taxable supplies during the specified period. (worked out as a percentage)

Business Central Configuration

Now we know the basic rules around partial exemption, it becomes clear that if we qualify as partially exempt for VAT, we need a way of easily identifying whether our expenses relate to exempt supplies, taxable supplies, or are general business expenses when entering them in Business Central. (basically where they sit according to the table above)

Therefore, the first step is to add more VAT Product Posting Groups to our configuration.

We then need to add the the new VAT Product Posting Groups into the “VAT Posting Setup” as per below (note the new VAT Product Posting Groups still calculate VAT at 20%. This doesn’t change, only the amount of VAT we can reclaim is affected).

Using this new configuration, when entering a Purchase expense, and we can recover all the VAT, we should use the “VAT20” VAT Product Posting Group. When entering a Purchase expense, and none of the VAT can be recovered, we can use “PNVAT20” and when we can partially recover some VAT we should use “PRVAT20“.

Therefore, if we had a Purchase Invoice for Office Expenses, which we know we can only reclaim a portion of the VAT back, we’d use the PRVAT20 VAT Product Posting Groups as per below. This would then be easily identified in the VAT Entries.

VAT Entries – Example

Now suppose we have entered transactions to the different VAT Product Posting Groups to get VAT entries as per below:

As we have posted our purchase expenses using the correct VAT Product Posting Groups we can easily identify the following:

  1. We have £60.19 posted to PNVAT20. We can’t reclaim any of this VAT.
  2. We have £45.86 posted to PRVAT20. We can reclaim a portion of this VAT.
  3. We have £88.85 posted to VAT20. We can reclaim all of this VAT.

VAT Adjustment

Let’s say we have reached the end of the VAT period, and the transactions shown above are the only transactions we have posted.

We have also performed our partial exemption calculation, and we can only reclaim 10% of the VAT posted to the PRVAT20 VAT Product Posting Group.

This means of the £45.86 posted to PRVAT20 we can’t reclaim £41.27. (90% we can’t reclaim)

We also can’t reclaim any of the £60.19 VAT posted to the PNVAT20 VAT Product Posting Group.

Therefore, we’ll need a combined adjustment of £101.46 to the VAT account, which we can offset against an irrecoverable VAT expense account. Therefore we would post a General Journal as per below:

When posting this journal we should also use the FULLVAT VAT Product Posting Group so we have a VAT entry that will be picked up the VAT Statement reducing the amount we can reclaim. (an adjustment to the VAT statement configuration may be needed for this if the FULLVAT Vat Product Posting Group isn’t on the VAT statement)

Conclusion

This is one method you can use for partial exemption in Business Central. It involves creating different VAT Product Posting Groups to post your purchase expenses against depending on whether the VAT will be fully recoverable, partially recoverable, or unrecoverable.

Its worth noting that Business Central does have additional irrecoverable VAT features that I’ve haven’t covered in this post. This includes a change to the VAT Posting Setup window giving you the ability to automatically post a portion of the VAT to an irrecoverable VAT GL code. I might do another post on that in the future 🙂

Thanks for reading!

Dynamics 365 Business Central – How to post a VAT only journal for VAT adjustments

Introduction

There may be times when you need to post a full VAT only journal to record a VAT adjustment. In these scenarios you want no effect in the General Ledger, but wish to have an adjusting VAT entry appear on the VAT statement.

In this post, I’ll walk through the necessary steps for setting up VAT for these scenarios. Once the setup is complete, I’ll explain the process for posting the VAT only journal.

VAT Setup

First, we need to add the necessary VAT combination in the VAT Posting Setup window. For this I go to the “VAT Posting Setup” window.

In this window I add the following VAT combination.

Now if I use the combination of “Domestic” and “Full Norm” in a journal this should calculate full VAT at 100%.

VAT Journal

Now the VAT Posting Setup is complete, I’ll post the correcting VAT adjustment journal using the “General Journal” page as per the screen shot below.

In this journal I’m doing the following:

1) First I’m selecting the VAT GL Code

2) Then I’m selecting the relevant VAT Business and VAT Product Posting Group for the Full VAT combination

3) Lastly, I’m balancing the journal to the same VAT GL code

This produces the following GL Entries. As you can see there is no effect in the General Ledger.

The posting also creating this VAT Entry

Therefore, although we have no effect in the General Ledger, we have a VAT entry to record the adjustment on the VAT Statement. We just need to edit the VAT statement to pickup the VAT Business and VAT Product posting combinations

VAT Statement

To ensure this is picked up on the VAT Statement go to the VAT Statement page and add the combination:

Conclusion

This post shows how you can setup Business Central to post VAT adjustments that won’t affect the General Ledger but do create adjusting VAT entries.

Thanks for reading!

Dynamics 365 Business Central – How to remove the message “Your VAT return is overdue…” when the VAT return has been Submitted and Accepted

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!