6. ARAccountingDetail

This is a technical overview of the ARAccounting Detail report containing ledger bookkeeping data. The file is created on a daily basis.

AccountingDetail (1).svg

Accounting Detail

AccountingDetail describes the accounting records (bookkeeping data) on a transactional level. 

Please note that your Accounting Detail file, depending on package type and file version, might only utilize and/or contain a subset of all elements described below. See the XSD for your Accounting Detail file version to learn more.

Encoding

The file uses UTF-8 encoding

Name convention

ARAccountingDetail_<CompanyNumber>_<DateTime>_<SerialNumber>.xml

Names ComponentDescription
CompanyNumberThe company number in our ledger system
DateTimeThe date and time that the file was created. Uses ISO 8601 format, YYYYMMDDhhmmdd
SerialNumberShould follow an uninterupted  number series, 00001 and so on.

Important to note!

  • Always use BookAccount and AccountingAction when setting up the processing of ARAccountingDetail in your ERP.
  • If necessary, map the default PayEx Book Accounts to your own customized book accounts.
  • All accounting actions can be reversed (mirrored).

Book Accounts

The following book accounts are default

Sweden

AccountSwedishEnglish
1510 Kundfordringar PayEx Accounts receivable PayEx
1513 Kundfordringar direktbetalda Accounts receivable Direct payment
1519 Osäker fordran Write down / Bad debt losses
1684 Kortfristig fordran PayExShort-term receivable from PayEx
2490Skuld till kund (reglering kreditfaktura) Liabilities to customer (credit invoice settlement)
2499Transportkonto (reglering kreditfaktura) Transport account (credit invoice settlement)
3591Intäkter för påminnelseavgift Revenue from Reminder fee
3592Intäkter för inkassoavgift Revenue from Debt collection fee
3593Intäkter för förseningsavgift Revenue from Business late fee
3594Intäkter för inkassokostnader Revenue from Debt Collection expenses
3595Intäkter för inkassoarvodenRevenue from Debt Collection expenses
3710Rabatt, restbelopp efterskänksRemaining amount to remission
3740Godkänd öresdiff tillgodo Rounding to whole units
8313DröjsmålsräntaInterest

Norway

AccountNorwegianEnglish
1500Kundefordringer PayEx Accounts receivable PayEx
1520Kundefordringer direktebetalte Accounts receivable Direct payment
1580Usikker fordringWrite down / Bad debt losses
1390Kortsiktig fordring PayExShort-term receivable from PayEx
2990Gjeld til kunde (regulering kreditfaktura) Liabilities to customer (credit invoice settlement)
2999Transportkonto (regulering kreditfaktura) Transport account (credit invoice settlement)
3900Inntekter fra purregebyrRevenue from Reminder fee
3180Rabatt, restbeløp at tilgiRemaining amount to remission
3180Godkjent øreavrunding til godeRounding

Transaction Cause

The following transaction causes are used.

Each code, with the exception of "Monitoring" (Sweden only), correspond to the credit cause chosen in the interface PayEx 360 when an invoice is manually credited.

Transaction cause (Accounting Detail)Swedish (PayEx 360)English (PayEx 360)
BankruptcyKonkursBankruptcy
CompositionArrangementAckordsuppgörelseComposition agreement
SettlementFörlikningConciliation
WrongAddressFelaktig adressIncorrect address
ComplaintReklamationComplaint
WrongRegNoFelaktigt/Saknar persnr/orgnrIncorrect/missing Reg no.
UnderAgeEj myndigUnderaged
DeceasedAvlidenDeceased
FraudBedrägeriFraud
DisputeTvistDispute
MonitoringBevakningMonitoring
ApprovedDiffRestbelopp efterskänksRemaining amount to remission

XSD Validation

The Accounting Detail file must be validated toward an up-to-date XSD (ARAccountingDetail_[x.x].xsd). You can download the latest version below.

Current XML schema description

A detailed description of the elements in the current version of the XML schema definition file (XSD) can be found here

Download current XML schema file

FileversionVersionReleasedateComment
ARAccountingDetail_[1_X].xsd1.12016 

ChangeLog

Version 1.1

September, 2016

ARAccountingDetail_[1_X].xsd

 Initial version (latest documented version)


Download sample file

ARAccountingDetail_12345_20170419095509_122.xml

ARAccountingDetail_367_20191207140426_516.xml

Created by Fredrik Nilsson on 2020/06/26 09:24