VAT Statement Line Table

Contains some special tables to manage the tasks necessary for settling VAT and reporting to the customs and tax authorities. You can use these tables to have the program:

calculate the VAT due for a period

prepare and print the VAT statement

print a list of sales to EU countries/regions (on paper or to a diskette)

The program creates an entry in the VAT Entry table for each posted transaction that involves VAT. These entries are used to calculate the VAT that must be settled for a given period. When the calculation is to be done, you use a VAT statement to specify how you want the program to calculate VAT.

You can create several different types of VAT statements in the VAT Statement Template window if you need different forms. If you need different VAT statements based on the same template, you create different names in the VAT Statement Name window.

The VAT statement itself is filled out in the VAT Statement window. In this window you can choose to define the VAT statement based on the accounts in the Chart of Accounts window or based on entries in the VAT Entry table.

The VAT statement is normally only defined when you are doing the setup for the rest of the program. There you set up the VAT Statement window so that it suits the VAT statement which the particular company must turn in.

After you have defined a VAT statement, you can print it by clicking Actions, pointing to Functions, and then clicking Print. After you have printed and approved the VAT statement, you can run the Calc. and Post VAT Settlement batch job to close the open VAT entries and transfer purchase and sales VAT amounts to the VAT settlement account.

List of Fields in the Table

Field Location
Document Type Field, VAT Statement Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Refers To Period Field, VAT Statement Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Activity Code Filter Field, VAT Statement Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Blacklisted Comm. Field Field, VAT Statement Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Annual VAT Comm. Field Field, VAT Statement Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Box Field, VAT Statement Line Table Spain Local Functionality
Round Factor Field, VAT Statement Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Blacklist Country Transaction Field, VAT Statement Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
EU Service Field, VAT Statement Line Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Document Type Field, VAT Statement Line Table Belgium Local Functionality
Print on Official VAT Form Field, VAT Statement Line Table Belgium Local Functionality
Elec. Tax Decl. Category Code Field, VAT Statement Line Table Netherlands Local Functionality
EU 3-Party Trade Field, VAT Statement Line Table Sweden Local Functionality
Print Field, VAT Statement Line Table General Ledger
New Page Field, VAT Statement Line Table General Ledger
Statement Template Name Field, VAT Statement Line Table General Ledger
Elec. Tax Decl. Category Code Field, VAT Statement Line Table Netherlands Local Functionality
Line No. Field, VAT Statement Line Table General Ledger
VAT Prod. Posting Group Field, VAT Statement Line Table General Ledger
Date Filter Field, VAT Statement Line Table General Ledger
Print with Field, VAT Statement Line Table General Ledger
VAT Bus. Posting Group Field, VAT Statement Line Table General Ledger
Statement Name Field, VAT Statement Line Table General Ledger
Gen. Posting Type Field, VAT Statement Line Table General Ledger
Row No. Field, VAT Statement Line Table General Ledger
Description Field, VAT Statement Line Table General Ledger
Amount Type Field, VAT Statement Line Table General Ledger
Type Field, VAT Statement Line Table General Ledger
Calculate with Field, VAT Statement Line Table General Ledger
Row Totaling Field, VAT Statement Line Table General Ledger
Print Field, VAT Statement Line Table General Ledger
New Page Field, VAT Statement Line Table General Ledger
Statement Template Name Field, VAT Statement Line Table General Ledger
Line No. Field, VAT Statement Line Table General Ledger
VAT Prod. Posting Group Field, VAT Statement Line Table General Ledger
Date Filter Field, VAT Statement Line Table General Ledger
Print with Field, VAT Statement Line Table General Ledger
Account Totaling Field, VAT Statement Line Table General Ledger
VAT Bus. Posting Group Field, VAT Statement Line Table General Ledger
Statement Name Field, VAT Statement Line Table General Ledger
Gen. Posting Type Field, VAT Statement Line Table General Ledger
Tax Jurisdiction Code Field, VAT Statement Line Table General Ledger
Row No. Field, VAT Statement Line Table General Ledger
Description Field, VAT Statement Line Table General Ledger
Amount Type Field, VAT Statement Line Table General Ledger
Use Tax Field, VAT Statement Line Table General Ledger
Type Field, VAT Statement Line Table General Ledger
Calculate with Field, VAT Statement Line Table General Ledger
Row No. Field, VAT Statement Line Table Switzerland Local Functionality
Row Totaling Field, VAT Statement Line Table General Ledger
Print Field, VAT Statement Line Table General Ledger
New Page Field, VAT Statement Line Table General Ledger
Statement Template Name Field, VAT Statement Line Table General Ledger
Line No. Field, VAT Statement Line Table General Ledger
VAT Prod. Posting Group Field, VAT Statement Line Table General Ledger
Date Filter Field, VAT Statement Line Table General Ledger
Print with Field, VAT Statement Line Table General Ledger
Account Totaling Field, VAT Statement Line Table General Ledger
VAT Bus. Posting Group Field, VAT Statement Line Table General Ledger
Statement Name Field, VAT Statement Line Table General Ledger
Gen. Posting Type Field, VAT Statement Line Table General Ledger
Tax Jurisdiction Code Field, VAT Statement Line Table General Ledger
Row No. Field, VAT Statement Line Table General Ledger
Description Field, VAT Statement Line Table General Ledger
Amount Type Field, VAT Statement Line Table General Ledger
Use Tax Field, VAT Statement Line Table General Ledger
Type Field, VAT Statement Line Table General Ledger
Calculate with Field, VAT Statement Line Table General Ledger
Elec. Tax Decl. Category Code Field, VAT Statement Line Table Netherlands Local Functionality
Row Totaling Field, VAT Statement Line Table General Ledger
Account Totaling Field, VAT Statement Line Table General Ledger
Tax Jurisdiction Code Field, VAT Statement Line Table General Ledger
Use Tax Field, VAT Statement Line Table General Ledger
Row Totaling Field, VAT Statement Line Table General Ledger
Print Field, VAT Statement Line Table General Ledger
New Page Field, VAT Statement Line Table General Ledger
Statement Template Name Field, VAT Statement Line Table General Ledger
Line No. Field, VAT Statement Line Table General Ledger
VAT Prod. Posting Group Field, VAT Statement Line Table General Ledger
Date Filter Field, VAT Statement Line Table General Ledger
Print with Field, VAT Statement Line Table General Ledger
Account Totaling Field, VAT Statement Line Table General Ledger
VAT Bus. Posting Group Field, VAT Statement Line Table General Ledger
Statement Name Field, VAT Statement Line Table General Ledger
Gen. Posting Type Field, VAT Statement Line Table General Ledger
Tax Jurisdiction Code Field, VAT Statement Line Table General Ledger
Row No. Field, VAT Statement Line Table General Ledger
Description Field, VAT Statement Line Table General Ledger
Amount Type Field, VAT Statement Line Table General Ledger
Use Tax Field, VAT Statement Line Table General Ledger
Type Field, VAT Statement Line Table General Ledger
Calculate with Field, VAT Statement Line Table General Ledger
Elec. Tax Decl. Category Code Field, VAT Statement Line Table Netherlands Local Functionality

See Also

Reference

VAT Entry
VAT Statement Template
VAT Statement
VAT Statement Name
VAT Statement Preview
G/L Account

Other Resources

Calc. and Post VAT Settlement