Even geduld a.u.b...

Exact Online REST API - GLAccounts

Endpoint

GLAccounts

Good to know

Use this endpoint to retrieve information of all the G/L accounts of your administration. Aside from that you can also create, update or delete G/L account.
Add CustomDescriptionLanguage='[ NL | FR-BE | NL-BE | ... ]' to the header to retrieve language sensitive properties such as descriptions in a specific language.
For more information about G/L accounts, you can visit the following help file Working with G/L accounts.


This entity supports webhooks.


Scope

Financial generalledgers

URI

/api/v1/{division}/financial/GLAccounts


GET POST PUT DELETE

Example usage

/api/v1/{division}/financial/GLAccounts

/api/v1/{division}/financial/GLAccounts

/api/v1/{division}/financial/GLAccounts

/api/v1/{division}/financial/GLAccounts


Properties

Name Mandatory Value Value Type Webhook Description
ID False Edm.Guid Primary Key
AssimilatedVATBox False Edm.Int16 Supports webhook AssimilatedVATBox (France)
BalanceSide False Edm.String Supports webhook The following values are supported: D (Debit) C (Credit)
BalanceType False Edm.String Supports webhook The following values are supported: B (Balance Sheet) W (Profit & Loss)
BelcotaxType False Edm.Int32 Supports webhook Indentify the kind of rewarding for the G/L account. This is used in the official document for the fiscal fiches Belcotax
Code True Edm.String Supports webhook Unique Code of the G/L account
Compress False Edm.Boolean Supports webhook Indicate if this G/L account should be shown as compressed without the details in the CRW report of G/L history
Costcenter False Edm.String Supports webhook Cost Center linked to the G/L account
CostcenterDescription False Edm.String Description of Costcenter
Costunit False Edm.String Supports webhook Cost Unit linked to the G/L account
CostunitDescription False Edm.String Description of Costunit
Created False Edm.DateTime Creation date
Creator False Edm.Guid User ID of creator
CreatorFullName False Edm.String Name of creator
DeductibilityPercentages False Deductibility percentages. You can have several Deductibility percentages, with start and end dates
Description True Edm.String Supports webhook Name of the G/L account. If Multilanguage featureset is enabled in the administration and the G/L account already has a set of termed description, this field is not allowed to change.
DescriptionTermID False Edm.Int32 Term ID for description
Division False Edm.Int32 Division code
ExcludeVATListing False Edm.Byte Supports webhook General ledger transactions on this G/L account should not appear on the VAT listing
ExpenseNonDeductiblePercentage False Edm.Double Supports webhook Expenses on this G/L account can not be used to reduce the incomes
IsBlocked False Edm.Boolean Supports webhook When blocked you can't use this general ledger account anymore for new entries
Matching False Edm.Boolean Supports webhook Allow entries on this general ledger account to be matched via the G/L account card
Modified False Edm.DateTime Last modified date
Modifier False Edm.Guid User ID of modifier
ModifierFullName False Edm.String Name of modifier
PrivateGLAccount False Edm.Guid Supports webhook 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 False Edm.Double Supports webhook Specify the percentage of the cost that should be re-invoiced to the owner of the company as private use of the costs
ReportingCode False Edm.String Supports webhook Used in the export of yearly report
RevalueCurrency False Edm.Boolean Supports webhook Indicates if the amounts booked on this general ledger account will be recalculated when currency revaluation is done
SearchCode False Edm.String Supports webhook Search Code
Type False Edm.Int32 Supports webhook 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 False Edm.String Description of Type
UseCostcenter False Edm.Byte Supports webhook 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 False Edm.Byte Supports webhook 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 False Edm.String Supports webhook VAT Code linked to the G/L account
VATDescription False Edm.String Description of VAT
VATGLAccountType False Edm.String Supports webhook 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 False Edm.Guid Supports webhook 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 False Edm.Double Supports webhook 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 False Edm.String Supports webhook The following values are supported: I (Invoice) C (Cash) (France)
YearEndCostGLAccount False Edm.Guid Supports webhook Indicates the costing account for year end calculations
YearEndReflectionGLAccount False Edm.Guid Supports webhook Indicates the reflection account that is used by year end application

Returns