GLAccountsBulk: Exact Online Grootboekrekeningen

AllowCostsInSales

int16

{res:itgen_eol_allowcostsinsales}

☐

AssimilatedVATBox

int16

Geassimileerde BTW Box

☐

AssimilatedVATBox (France).

BalanceSide

string

Balanszijde

☐

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

BalanceType

string

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

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

Kostenplaats

☐

Cost Center linked to the G/L account.

CostcenterDescription

string

Kostenplaats Omschrijving

☐

Description of Costcenter.

Costunit

string

Kostendrager

☐

Cost Unit linked to the G/L account.

CostunitDescription

string

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

Aanmaker Volledige Naam

☐

Name of creator.

CustomField

string

{res:itgen_eol_customfield}

☐

Description

string

Omschrijving

☐

Name of the G/L account.

DescriptionTermID

int32

Omschrijving Term ID

☐

Term ID for description.

Division

int32

Divisie ID

☑

Unique number of the Exact Online division.

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

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 owner of the company.

PrivatePercentage

double

Prive Percentage

☐

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

ReportingCode

string

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

Zoekcode

☐

Search Code.

Type

int32

Soort

☐

The type of the G/L account. Supported values are: 10 = Cash 12 = Bank 14 = Credit card 16 = Payment services 20 = Accounts receivable 21 = Prepayment accounts receivable 22 = Accounts payable 24 = VAT 25 = Employees payable 26 = Prepaid expenses 27 = Accrued expenses 29 = Income taxes payable 30 = Fixed assets 32 = Other assets 35 = Accumulated depreciation 40 = Inventory 50 = Capital stock 52 = Retained earnings 55 = Long term debt 60 = Current portion of debt 90 = General 100 = Tax payable 110 = Revenue 111 = Cost of goods 120 = Other costs 121 = Sales, general administrative expenses 122 = Depreciation costs 123 = Research and development 125 = Employee costs 126 = Employment costs 130 = Exceptional costs 140 = Exceptional income 150 = Income taxes 160 = Interest income 300 = Year end reflection 301 = Indirect year end costing 302 = Direct year end costing.

TypeDescription

string

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

BTW-code

☐

VAT Code linked to the G/L account.

VATDescription

string

BTW Omschrijving

☐

Description of VAT.

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

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.