Salesforce

Een jaarrekening opmaken: acceptatiecriteria voor import sociale balans

« Go Back
Article Information
BE
Article Details

Hieronder vind je uitleg over de voorwaarden waaraan het XML-importbestand van de sociale balans moet voldoen om te kunnen importeren in Adsolut Jaarrekening.

Een xml-bestand moet aan de volgende voorwaarden voldoen:

  • Een xml-bestand moet geldig zijn volgens dit xsd schema: annualaccounts.types.xsd
  • Alle elementen (tags) zijn Engelstalig en verplicht, tenzij anders vermeld.
  • Enkel codes van de sociale balans zijn toegelaten, foutieve codes worden gemarkeerd met een waarschuwingsymbool na het inlezen in de jaarrekening.
  • Een code-id is een samenstelling van een sociale balanscode en kolomnummer
  • Voorbeeld:
    • 1001 (code 1001 'Totaal' heeft geen kolomnummer => 1001)
    • 10011 (code 1001 'Mannen' heeft kolomnummer 1 => 10011)
    • 10012 (code 1001 'Vrouwen' heeft kolomnummer 2 => 10012)
image.png
  • Elke sociale balanscode heeft een waarde in een specifiek formaat zoals beschreven in de tabel onderan deze pagina.
    • kolom A "code" bevat de balanscodes.
    • kolom B "description (informative)" bevat een informatieve omschrijving (die niet wordt opgegeven in het xml bestand).
    • kolom C "type" bevat de technische formaat beschrijving van de waarde.
    • kolom D "non technical explanation of type" bevat een meer begrijpelijke omschrijving van het formaat in kolom C.
      • Elke code mag één maal voorkomen in het xml bestand.
      • Voor het decimaal teken wordt een punt gebruikt en geen komma.
      • Er is geen teken voor duizendtallen.
      • De waarde mag niet meer cijfers bevatten vóór de punt en ook niet meer cijfers na de punt (= decimalen) dan in het formaat is vastgelegd.
      • Als een waarde meer decimalen heeft dan het formaat van de betreffende balanscode, dan moet de waarde worden afgerond volgens het formaat. 
      • Voorloop nullen zijn niet nodig.
      • Non negative' betekent dat geen min-teken is toegelaten.
      • Er mogen geen speciale tekens, geen letters, noch munt tekens (zoals €,$, £,...) voorkomen in de waarde.
      • Vermijd spaties, tabs, enters en andere 'onzichtbare karakters' in de waarde.


Structuur
<?xml version="1.0" encoding="UTF-8"?>
<AnnualAccounts xsi:noNamespaceSchemaLocation="annualaccounts.types.xsd" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Supplier><!--- optioneel --->
<SupplierName><!--- optioneel, lengte min. 1, max. 100 tekens ---></SupplierName>
<SupplierMessage language="de"><!--- optioneel, lengte min. 1, max. 500 ---></SupplierMessage>
<SupplierMessage language="en"><!--- optioneel, lengte min. 1, max. 500 ---></SupplierMessage>
<SupplierMessage language="fr"><!--- optioneel, lengte min. 1, max. 500 ---></SupplierMessage>
<SupplierMessage language="nl"><!--- optioneel, lengte min. 1, max. 500 ---></SupplierMessage>
</Supplier>
<Period>
<StartDate><!--- begindatum boekjaar, formaat: jjjj-mm-dd ---></StartDate>
<EndDate><!--- einddatum boekjaar, formaat:  jjjj-mm-dd ---></EndDate>
</Period>
<EntityInformation>
<EntityName><!--- naam onderneming, optioneel, lengte min. 1, max. 100 tekens ---></EntityName>
<EntityIdentifier><!--- ondernemingsnr, optioneel, lengte min. 1, max. 30 tekens ---></EntityIdentifier>
</EntityInformation>
<Codes>
<Code id="<!---  sociale balans code-id --->">
         <!--- waarde: ofwel een aantal: max. 14 cijfers of 14 cijfers punt 1 decimaal
                               ofwel een bedrag: max. 14 cijfers punt 2 decimalen --->

</Code>
</Codes>
</AnnualAccounts>

Voorbeeld
image.png

Formaat van de waarde per balanscode
 

codedescriptiontypeexplanation
1001AverageNumberEmployeesPersonnelRegisterTotalFullTimenonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
1002AverageNumberEmployeesPersonnelRegisterTotalPartTimenonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
1003AverageNumberEmployeesPersonnelRegisterTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
10011AverageNumberEmployeesPersonnelRegisterTotalFullTimeMennonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
10021AverageNumberEmployeesPersonnelRegisterTotalPartTimeMennonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
10031AverageNumberEmployeesPersonnelRegisterTotalFullTimeEquivalentsMennonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
10012AverageNumberEmployeesPersonnelRegisterTotalFullTimeWomennonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
10022AverageNumberEmployeesPersonnelRegisterTotalPartTimeWomennonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
10032AverageNumberEmployeesPersonnelRegisterTotalFullTimeEquivalentsWomennonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
1011NumberHoursActuallyWorkedFullTimenonnegative integer 11Non negative integer (no decimals), max 11 digits
1012NumberHoursActuallyWorkedPartTimenonnegative integer 11Non negative integer (no decimals), max 11 digits
1013NumberHoursActuallyWorkedTotalnonnegative integer 11Non negative integer (no decimals), max 11 digits
10111NumberHoursActuallyWorkedFullTimeMennonnegative integer 11Non negative integer (no decimals), max 11 digits
10121NumberHoursActuallyWorkedPartTimeMennonnegative integer 11Non negative integer (no decimals), max 11 digits
10131NumberHoursActuallyWorkedTotalMennonnegative integer 11Non negative integer (no decimals), max 11 digits
10112NumberHoursActuallyWorkedFullTimeWomennonnegative integer 11Non negative integer (no decimals), max 11 digits
10122NumberHoursActuallyWorkedPartTimeWomennonnegative integer 11Non negative integer (no decimals), max 11 digits
10132NumberHoursActuallyWorkedTotalWomennonnegative integer 11Non negative integer (no decimals), max 11 digits
1021PersonnelCostsFullTimenonnegative currency 14D2Non negative decimal with 2 decimals, max 14 digits
1022PersonnelCostsPartTimenonnegative currency 14D2Non negative decimal with 2 decimals, max 14 digits
1023PersonnelCostsTotalnonnegative currency 14D2Non negative decimal with 2 decimals, max 14 digits
10211PersonnelCostsFullTimeMennonnegative currency 14D2Non negative decimal with 2 decimals, max 14 digits
10221PersonnelCostsPartTimeMennonnegative currency 14D2Non negative decimal with 2 decimals, max 14 digits
10231PersonnelCostsTotalMennonnegative currency 14D2Non negative decimal with 2 decimals, max 14 digits
10212PersonnelCostsFullTimeWomennonnegative currency 14D2Non negative decimal with 2 decimals, max 14 digits
10222PersonnelCostsPartTimeWomennonnegative currency 14D2Non negative decimal with 2 decimals, max 14 digits
10232PersonnelCostsTotalWomennonnegative currency 14D2Non negative decimal with 2 decimals, max 14 digits
1033AdvantagesAdditionWagesTotalnonnegative currency 14D2Non negative decimal with 2 decimals, max 14 digits
10331AdvantagesAdditionWagesTotalMennonnegative currency 14D2Non negative decimal with 2 decimals, max 14 digits
10332AdvantagesAdditionWagesTotalWomennonnegative currency 14D2Non negative decimal with 2 decimals, max 14 digits
1053NumberEmployeesPersonnelRegisterClosingDateFinancialYearTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
1051NumberEmployeesPersonnelRegisterClosingDateFinancialYearFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1052NumberEmployeesPersonnelRegisterClosingDateFinancialYearPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1103NumberEmployeesPersonnelRegisterClosingDateFinancialYearContractIndefinitePeriodTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
1101NumberEmployeesPersonnelRegisterClosingDateFinancialYearContractIndefinitePeriodFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1102NumberEmployeesPersonnelRegisterClosingDateFinancialYearContractIndefinitePeriodPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1113NumberEmployeesPersonnelRegisterClosingDateFinancialYearContractDefinitePeriodTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
1111NumberEmployeesPersonnelRegisterClosingDateFinancialYearContractDefinitePeriodFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1112NumberEmployeesPersonnelRegisterClosingDateFinancialYearContractDefinitePeriodPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1123NumberEmployeesPersonnelRegisterClosingDateFinancialYearContractExecutionSpecificallyAssignedWorkTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
1121NumberEmployeesPersonnelRegisterClosingDateFinancialYearContractExecutionSpecificallyAssignedWorkFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1122NumberEmployeesPersonnelRegisterClosingDateFinancialYearContractExecutionSpecificallyAssignedWorkPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1133NumberEmployeesPersonnelRegisterClosingDateFinancialYearReplacementContractTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
1131NumberEmployeesPersonnelRegisterClosingDateFinancialYearReplacementContractFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1132NumberEmployeesPersonnelRegisterClosingDateFinancialYearReplacementContractPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1203NumberEmployeesPersonnelRegisterClosingDateFinancialYearMenTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
1201NumberEmployeesPersonnelRegisterClosingDateFinancialYearMenFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1202NumberEmployeesPersonnelRegisterClosingDateFinancialYearMenPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
12003NumberEmployeesPersonnelRegisterClosingDateFinancialYearPrimaryEducationMenTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
12001NumberEmployeesPersonnelRegisterClosingDateFinancialYearPrimaryEducationMenFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
12002NumberEmployeesPersonnelRegisterClosingDateFinancialYearPrimaryEducationMenPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
12013NumberEmployeesPersonnelRegisterClosingDateFinancialYearSecondaryEducationMenTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
12011NumberEmployeesPersonnelRegisterClosingDateFinancialYearSecondaryEducationMenFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
12012NumberEmployeesPersonnelRegisterClosingDateFinancialYearSecondaryEducationMenPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
12023NumberEmployeesPersonnelRegisterClosingDateFinancialYearHigherNonUniversityEducationMenTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
12021NumberEmployeesPersonnelRegisterClosingDateFinancialYearHigherNonUniversityEducationMenFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
12022NumberEmployeesPersonnelRegisterClosingDateFinancialYearHigherNonUniversityEducationMenPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
12033NumberEmployeesPersonnelRegisterClosingDateFinancialYearUniversityEducationMenTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
12031NumberEmployeesPersonnelRegisterClosingDateFinancialYearUniversityEducationMenFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
12032NumberEmployeesPersonnelRegisterClosingDateFinancialYearUniversityEducationMenPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1213NumberEmployeesPersonnelRegisterClosingDateFinancialYearWomenTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
1211NumberEmployeesPersonnelRegisterClosingDateFinancialYearWomenFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1212NumberEmployeesPersonnelRegisterClosingDateFinancialYearWomenPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
12103NumberEmployeesPersonnelRegisterClosingDateFinancialYearPrimaryEducationWomenTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
12101NumberEmployeesPersonnelRegisterClosingDateFinancialYearPrimaryEducationWomenFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
12102NumberEmployeesPersonnelRegisterClosingDateFinancialYearPrimaryEducationWomenPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
12113NumberEmployeesPersonnelRegisterClosingDateFinancialYearSecondaryEducationWomenTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
12111NumberEmployeesPersonnelRegisterClosingDateFinancialYearSecondaryEducationWomenFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
12112NumberEmployeesPersonnelRegisterClosingDateFinancialYearSecondaryEducationWomenPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
12123NumberEmployeesPersonnelRegisterClosingDateFinancialYearHigherNonUniversityEducationWomenTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
12121NumberEmployeesPersonnelRegisterClosingDateFinancialYearHigherNonUniversityEducationWomenFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
12122NumberEmployeesPersonnelRegisterClosingDateFinancialYearHigherNonUniversityEducationWomenPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
12133NumberEmployeesPersonnelRegisterClosingDateFinancialYearUniversityEducationWomenTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
12131NumberEmployeesPersonnelRegisterClosingDateFinancialYearUniversityEducationWomenFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
12132NumberEmployeesPersonnelRegisterClosingDateFinancialYearUniversityEducationWomenPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1303NumberEmployeesPersonnelRegisterClosingDateFinancialYearManagementStaffTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
1301NumberEmployeesPersonnelRegisterClosingDateFinancialYearManagementStaffFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1302NumberEmployeesPersonnelRegisterClosingDateFinancialYearManagementStaffPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1343NumberEmployeesPersonnelRegisterClosingDateFinancialYearEmployeesTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
1341NumberEmployeesPersonnelRegisterClosingDateFinancialYearEmployeesFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1342NumberEmployeesPersonnelRegisterClosingDateFinancialYearEmployeesPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1323NumberEmployeesPersonnelRegisterClosingDateFinancialYearWorkersTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
1321NumberEmployeesPersonnelRegisterClosingDateFinancialYearWorkersFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1322NumberEmployeesPersonnelRegisterClosingDateFinancialYearWorkersPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1333NumberEmployeesPersonnelRegisterClosingDateFinancialYearOthersTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
1331NumberEmployeesPersonnelRegisterClosingDateFinancialYearOthersFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1332NumberEmployeesPersonnelRegisterClosingDateFinancialYearOthersPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
1501HiredTemporaryStaffAverageNumberPersonsEmployednonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
1511HiredTemporaryStaffNumbersHoursActuallyWorkednonnegative integer 11Non negative integer (no decimals), max 11 digits
1521HiredTemporaryStaffCostsEnterprisenonnegative currency 14D2Non negative decimal with 2 decimals, max 14 digits
1502PersonsPlacedEnterprisesDisposalAverageNumberPersonsEmployednonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
1512PersonsPlacedEnterprisesDisposalNumberHoursActuallyWorkednonnegative integer 11Non negative integer (no decimals), max 11 digits
1522PersonsPlacedEnterprisesDisposalCostsEnterprisenonnegative currency 14D2Non negative decimal with 2 decimals, max 14 digits
2053NumberEmployeesRecordedPersonnelRegisterDuringFinancialYearTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
2051NumberEmployeesRecordedPersonnelRegisterDuringFinancialYearFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
2052NumberEmployeesRecordedPersonnelRegisterDuringFinancialYearPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
2103NumberEmployeesRecordedPersonnelRegisterDuringFinancialYearContractIndefinitePeriodTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
2101NumberEmployeesRecordedPersonnelRegisterDuringFinancialYearContractIndefinitePeriodFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
2102NumberEmployeesRecordedPersonnelRegisterDuringFinancialYearContractIndefinitePeriodPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
2113NumberEmployeesRecordedPersonnelRegisterDuringFinancialYearContractDefinitePeriodTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
2111NumberEmployeesRecordedPersonnelRegisterDuringFinancialYearContractDefinitePeriodFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
2112NumberEmployeesRecordedPersonnelRegisterDuringFinancialYearContractDefinitePeriodPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
2123NumberEmployeesRecordedPersonnelRegisterDuringFinancialYearContractExecutionSpecificallyAssignedWorkTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
2121NumberEmployeesRecordedPersonnelRegisterDuringFinancialYearContractExecutionSpecificallyAssignedWorkFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
2122NumberEmployeesRecordedPersonnelRegisterDuringFinancialYearContractExecutionSpecificallyAssignedWorkPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
2133NumberEmployeesRecordedPersonnelRegisterDuringFinancialYearReplacementContractTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
2131NumberEmployeesRecordedPersonnelRegisterDuringFinancialYearReplacementContractFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
2132NumberEmployeesRecordedPersonnelRegisterDuringFinancialYearReplacementContractPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
3053NumberEmployeesWhoseContractTerminationDateHasBeenEnteredPersonnelRegisterDuringFinancialYearTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
3051NumberEmployeesWhoseContractTerminationDateHasBeenEnteredPersonnelRegisterDuringFinancialYearFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
3052NumberEmployeesWhoseContractTerminationDateHasBeenEnteredPersonnelRegisterDuringFinancialYearPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
3103NumberEmployeesWhoseContractTerminationDateHasBeenEnteredPersonnelRegisterDuringFinancialYearContractIndefinitePeriodTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
3101NumberEmployeesWhoseContractTerminationDateHasBeenEnteredPersonnelRegisterDuringFinancialYearContractIndefinitePeriodFullTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
3102NumberEmployeesWhoseContractTerminationDateHasBeenEnteredPersonnelRegisterDuringFinancialYearContractIndefinitePeriodPartTimenonnegative integer 6Non negative integer (no decimals), max 6 digits
3113NumberEmployeesWhoseContractTerminationDateHasBeenEnteredPersonnelRegisterDuringFinancialYearContractDefinitePeriodTotalFullTimeEquivalentsnonnegative decimal 6D1Non negative decimal with 1 decimal, max 6 digits
detail information
05/04/2023 07:12
Een jaarrekening opmaken: acceptatiecriteria voor import sociale balans
1,006
URL
Adsolut-Jaarrekening-voor-de-ondernemer-acceptatie-criteria-voor-import-sociale-balans

Powered by