VATCodes: Exact Online BTW-codes

Account

guid

Account

☐

Tax account.

AccountCode

string(18)

Account Code

☐

Code of Account.

AccountName

string(50)

Accountnaam

☐

Name of Account.

CalculationBasis

int16

{res:itgen_eol_calculationbasis}

☐

Indicates how to calculate the tax. 0 = based on the gross amount, 1 = based on the gross amount + another tax.

Charged

boolean

Belast

☐

Indicates if transactions using the VAT code are transactions of the domestic VAT charging regulation (such as those for subcontractors) or transactions that are registered within the EU. If Charged=1 and linked to a purchase invoice, both a line for the VAT to pay and a line for the VAT to claim are being created.

Code

string(3)

Code

☑

VAT code.

Country

string(30)

Land

☐

Obsolete.

Created

datetime

Gemaakt

☐

Creation date.

CreatedUtc

datetime

Aangemaakt (UTC)

☐

Creation date in UTC.

Creator

guid

Aanmaker

☐

User ID of creator.

CreatorFullName

string(240)

Aanmaker Volledige Naam

☐

Name of creator.

CustomField

string

{res:itgen_eol_customfield}

☐

Description

string(60)

Omschrijving

☐

Description of the VAT code.

Division

int32

Divisie

☐

Division code.

DivisionCompanyCoCNumber

string(60)

Divisie Kamer van Koophandel Nummer

☐

Chamber of commerce number of the Exact Online division.

DivisionCompanyIBANNumber

string(50)

Divisie IBAN Nummer

☐

IBAN number of the Exact Online division.

DivisionCompanyName

string(50)

Divisie Bedrijfsnaam

☑

Company name of the Exact Online division.

DivisionCompanyRSINNumber

string(9)

Divisie RSIN Nummer

☐

RSIN number of the Exact Online division.

DivisionCompanyVATNumber

string(35)

Divisie BTW Nummer

☐

VAT number of the Exact Online division.

DivisionCompanyWageTaxNumber

string(60)

Divisie Loonbelastingnummer

☐

Wage tax number of the Exact Online division.

DivisionLabel

string(128)

Divisie Label

☑

Label of the Exact Online division.

DivisionName

string(50)

Administratie Naam

☑

Name of the Exact Online division.

DivisionOwnerCompanyName

string(50)

Naam Abonnementhouder

☑

Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.

DivisionOwnerCompanyNumber

string(18)

Abonnementhoudernummer

☑

Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.

DivisionShortName

int64

Divisie Korte Naam

☑

Short name of the Exact Online division.

EUSalesListing

string(1)

ICL-lijst

☐

Used in all legislations except France. Indicates if and how transactions using the VAT code appear on the ICT return (EU sales list). L = Listing goods, N = No listing, S = Listing services, T = Triangulation.

ExcludeVATListing

int16

Sluit BTW Lijst uit

☑

GLDiscountPurchase

guid

{res:itgen_eol_gldiscountpurchase}

☐

Indicates the purchase discount GL account linked to the VAT codes for German legislation.

GLDiscountPurchaseCode

string(30)

{res:itgen_eol_gldiscountpurchasecode}

☐

Code of GLDiscountPurchase.

GLDiscountPurchaseDescription

string(60)

{res:itgen_eol_gldiscountpurchasedescription}

☐

Description of GLDiscountPurchase.

GLDiscountSales

guid

{res:itgen_eol_gldiscountsales}

☐

Indicates the sales discount GL account linked to the VAT codes for German legislation.

GLDiscountSalesCode

string(30)

{res:itgen_eol_gldiscountsalescode}

☐

Code of GLDiscountSales.

GLDiscountSalesDescription

string(60)

{res:itgen_eol_gldiscountsalesdescription}

☐

Description of GLDiscountSales.

GLToClaim

guid

{res:itgen_eol_gltoclaim}

☐

G/L account that is used to book the VAT to claim. If you enter purchases with a VAT code, the VAT amount to be claimed is entered to this VAT account. Must be of type VAT.

GLToClaimCode

string(30)

{res:itgen_eol_gltoclaimcode}

☐

Code of GLToClaim.

GLToClaimDescription

string(60)

{res:itgen_eol_gltoclaimdescription}

☐

Description of GLToClaim.

GLToPay

guid

{res:itgen_eol_gltopay}

☐

G/L account that is used to book the VAT to pay. If you enter sales with a VAT code, the VAT amount to be paid is entered to this VAT account. Must be of type VAT.

GLToPayCode

string(30)

{res:itgen_eol_gltopaycode}

☐

Code of GLToPay.

GLToPayDescription

string(60)

{res:itgen_eol_gltopaydescription}

☐

Description of GLToPay.

ID

guid

ID

☑

Primary key.

IntraStat

boolean

Intrastat

☐

Used in all legislations except France. Indicates if intrastat is used.

IntrastatType

string(1)

Intrastat-type

☐

Used in France legislation only. Indicates if and how transactions using the VAT code appear on the DEB/DES return. L = Goods, N = Empty, S = Services.

IsBlocked

boolean

Is Geblokkeerd

☐

Indicates if the VAT code may still be used.

LegalText

string(150)

Juridische Tekst

☐

Legal description for VAT code to print in the total block of the invoice.

Modified

datetime

Gewijzigd

☐

Last modified date.

ModifiedUtc

datetime

Gewijzigd (UTC)

☐

Last modified date in UTC.

Modifier

guid

Wijziger

☐

User ID of modifier.

ModifierFullName

string(240)

Gewijzigd Volledige Naam

☐

Name of modifier.

OssCountry

string

OSS-land

☐

Percentage

double

Percentage

☐

Percentage of the VAT code.

TaxReturnType

int16

Retourbelasting Soort

☐

Indicates what type of Taxcode it is: can be VAT, IncomeTax.

Type

string(1)

Soort

☐

Indicates how the VAT amount should be calculated in relation to the invoice amount. B = VAT 0% (Only base amount), E = Excluding, I = Including, N = No VAT.

VatDocType

string(1)

BTW-documentsoort

☐

Field in VAT code maintenance to calculate different VATs depending on the selected document type. P = purchase invoice, F = freelance invoice, E = expense voucher. The field is valid for witholding tax type.

VatMargin

int16

BTW Marge

☑

The VAT margin scheme is used for the trade of secondhand goods which are purchased without VAT (for example when a company buys a secondhand good from a private person). In the VAT margin scheme, the VAT is not calculated based on the sales price. Instead of that, the VAT is calculated based on the margin (gross sales price minus the gross purchase price).

VATPartialRatio

int16

Gedeeltelijke BTW-ratio

☐

Partial ratio explains which part of the VAT the company has to pay. Used in some branches where the sellers have a bad reputation, so the buyers have to take over the VAT-liability.

VATTransactionType

string(1)

BTW-transactiesoort

☐

Indicates the type of transactions for which the VAT code may be used. B = Both, P = Purchase, S = Sales.