Set Up a VAT Statement

Setting up VAT Statement Templates and VAT Statement Names

Tax authorities can, and do, change their requirements for posting VAT. VAT Statement templates and VAT statement names can help you prepare for upcoming changes and make a smooth transition to the new requirements. You can use VAT statement templates to setup different Reports when choosing to print the statement. Each VAT Statement Template can have multiple Vat Statement names which in turn define the calculations, and you can create a new VAT statement Name when requirements change. For example, one name might calculate VAT for this year based on the current requirements, and another might calculate VAT based on requirements for next year. Names are also a way to keep a history of VAT statement formats, for example, so that you can look back to see how you calculated VAT in previous years.

To define a VAT statements

VAT statements let you calculate your VAT settlement amount for a certain period, for example, a quarter.

  1. Choose the Lightbulb that opens the Tell Me feature icon, enter VAT Statements, and then choose the related link.
  2. Choose the Name field, and then choose New on the VAT Statement Names page.
  3. Fill in the required fields. Usually you want to have a setting for each VAT Bus. Posting Group / VAT Prod. Posting Group combination. For Row numbers it does make sense to use equvalent numbers or codes as in your official VAT Statement Hover over a field to read a short description.

Tip

You can filter the information that the statement will include, depending on what you choose in the Type field. Account Totalling is useful when you want the VAT from a specific account. VAT Entry Totalling gets VAT from the accounts assigned to the selections in the Gen. Posting Type, VAT Bus. Posting Group, and/or the VAT Prod. Posting Group fields. Row Totalling lets you enter a value or quick filter criteria in the Row Totalling field. For more information, see Searching, filtering, and Sorting Data. Description is often used to add a note to the statement. For example, you could use it as a heading when you've used row totalling.

To preview the VAT statement

After you define a VAT statement, you can preview it to make sure it meets your needs.

Tip

It is best practice to have one section in the VAT Statement using Type****Vat Entry Totalling and another section below using Type****Account Totalling to reconcile the amounts based on the VAT Entry table compared to the amount on the G/L Accounts. You can also use the G/L - VAT Reconciliation Report for this purpose.

  1. Choose Preview.
  2. Enter a date filter to limit the statement to a specific period. For more information about how to customise the page to show the date filter, see Searching, filtering, and Sorting Data.
  3. You can select various options to specify the type of VAT entries to include in the statement.
  4. On the lines where the Type field contains VAT Entry Totalling you can see a list of VAT entries by choosing the amount in the Column Amount field.
  5. You can use personalisation to show more fields in the lines. For example the Unrealised Base Amount and Unrealised VAT Amount, if you are using Unrealised VAT.

See Also

Set Up Value-Added Tax
Setting Up Unrealised Value Added Tax
Report VAT to a Tax Authority
Work with VAT on Sales and Purchases
Local functionality in Business Central