GLAccounts: Exact Online Grootboekrekeningen

AllowCostsInSales

int16

{res:itgen_eol_allowcostsinsales}

☐

AssimilatedVATBox

int16

Geassimileerde BTW Box

☐

AssimilatedVATBox (France).

BalanceSide

string(1)

Balanszijde

☐

The following values are supported: D (Debit) C (Credit).

BalanceType

string(1)

Balanssoort

☐

The following values are supported: B (Balance Sheet) W (Profit & Loss).

BelcotaxType

int32

BELCO Belastingsoort

☐

Indentify the kind of rewarding for the G/L account. This is used in the official document for the fiscal fiches Belcotax.

Code

string(30)

Code

☑

Unique Code of the G/L account.

Compress

boolean

Comprimeren

☐

Indicate if this G/L account should be shown as compressed without the details in the CRW report of G/L history.

Costcenter

string(8)

Kostenplaats

☐

Cost Center linked to the G/L account.

CostcenterDescription

string(60)

Kostenplaats Omschrijving

☐

Description of Costcenter.

Costunit

string(8)

Kostendrager

☐

Cost Unit linked to the G/L account.

CostunitDescription

string(60)

Kostendrager Omschrijving

☐

Description of Costunit.

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

☐

Name of the G/L account.

DescriptionTermID

int32

Omschrijving Term ID

☐

Term ID for description.

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.

ExcludeVATListing

int16

Sluit BTW Lijst uit

☑

General ledger transactions on this G/L account should not appear on the VAT listing.

ExpenseNonDeductiblePercentage

double

Niet-aftrekbare Uitgaven Niet-aftrekbare Uitgaven Percentage

☐

Expenses on this G/L account can not be used to reduce the incomes.

ID

guid

ID

☑

Primary Key.

IsBlocked

boolean

Is Geblokkeerd

☐

When blocked you can't use this general ledger account anymore for new entries.

Matching

boolean

Passend

☐

Allow entries on this general ledger account to be matched via the G/L account card.

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.

PrivateGLAccount

guid

Privé Grootboek Account

☐

If a private use percentage is defined, you need to specify the G/L account used for the re-invoice of the private use to the GlobalState of the company.

PrivatePercentage

double

Prive Percentage

☐

Specify the percentage of the cost that should be re-invoiced to the GlobalState of the company as private use of the costs.

ReportingCode

string(132)

Rapportagecode

☐

Used in the export of yearly report.

RevalueCurrency

boolean

Herwaarderingsvaluta

☐

Indicates if the amounts booked on this general ledger account will be recalculated when currency revaluation is done.

SearchCode

string(15)

Zoekcode

☐

Search Code.

Type

int32

Soort

☐

The type of the G/L account. Possible values: see GLAccountTypes.

TypeDescription

string(240)

Soort Omschrijving

☐

Description of Type.

UseCostcenter

int16

Gebruik Kostenplaats

☐

Indicates if cost centers can be used when using this general ledger account. The following values are supported: 0 (Optional) 1 (Mandatory) 2 (No).

UseCostunit

int16

Gebruik Kostendrager

☐

Indicates if cost units can be used when using this general ledger account. The following values are supported: 0 (Optional) 1 (Mandatory) 2 (No).

VATCode

string(3)

BTW-code

☐

VAT Code linked to the G/L account.

VATDescription

string(60)

BTW Omschrijving

☐

Description of the VAT code.

VATGLAccountType

string

BTW Grootboekrekeningsoort

☐

Specify the kind of purchase this G/L account is used for. This is important for the Belgian VAT return to indicate in which VAT box the base amount of purchase should go.

VATNonDeductibleGLAccount

guid

{res:itgen_eol_vatnondeductibleglaccount}

☐

If you use a percentage of non deductible VAT, you can specify another G/L account that will be used for the non deductible part of the VAT amount. This is used directly in the entry application of purchase invoices.

VATNonDeductiblePercentage

double

{res:itgen_eol_vatnondeductiblepercentage}

☐

If not the full amount of the VAT is deductible, you can indicate a percentage for the non decuctible part. This is used during the entry of purchase invoices.

VATSystem

string(1)

BTW Systeem

☐

The following values are supported: I (Invoice) C (Cash) (France).

YearEndCostGLAccount

guid

{res:itgen_eol_yearendcostglaccount}

☐

Indicates the costing account for year end calculations.

YearEndReflectionGLAccount

guid

{res:itgen_eol_yearendreflectionglaccount}

☐

Indicates the reflection account that is used by year end application.