06. 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

Name componentsDescription
CompanyNumberThe company number in our ledger system
DateTimeThe date and time that the file was created. Uses ISO 8601 format, YYYYMMDDhhmmdd
SerialNumberShould follow an uninterrupted  number series, 1, 2, 3 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, e.g. when payer withdraws a direct debet payment.
  • The sum of all book records "Short-term receivable from PayEx" (BookAccount 1684, 1390, 6490 or 1760 depending on country), per BookDate, corresponds to the Client asset disbursement reported in the ARSettlement/Balance Report.

Book Accounts

Sweden

AccountSwedishEnglish
1510 Kundfordringar PayEx Accounts receivable PayEx
1513 Kundfordringar direktbetalda Accounts receivable Direct payment
1514Kundfordringar direktbetalda SwishAccounts receivable Direct payment Swish
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
2900Gjeld 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
7745Godkjent øreavrunding til godeRounding
8055RenteInterest

Denmark

AccountDanishEnglish
6310Kundefordringer PayEx Accounts receivable PayEx
6312Kundefordringer direktebetalteAccounts receivable Direct payment
6330Ubetalt gældWrite down / Bad debt losses
6490Kortfristet fordring PayExShort-term receivable from PayEx
6311Gæld til kunde (regulering kreditfaktura) Liabilities to customer (credit invoice settlement)
6420Transportkonto (regulering kreditfaktura) Transport account (credit invoice settlement)
1551Indtægt for rykkergebyrRevenue from Reminder fee
1552Indtægt for inkassogebyRevenue from Debt collection fee
1553Indtægt for forsinkelsegebyrRevenue from Business late fee
1555Indtægt for inkassoomkostningerRevenue from Debt Collection expenses
1554Indtægt for inkassoomkostningerRevenue from Debt Collection expenses
2830Rabat, restbeløb eftergivesRemaining amount to remission
1556Godkendte øresdiff til godeRounding to whole units
3490RenteInterest

Finland

AccountFinnishEnglish
1700MyyntireskontraAccounts receivable PayEx
1761Myyntireskontra Suorat MaksutAccounts receivable Direct payment
1762LuottotappiotWrite down / Bad debt losses
1760Lyhytaikaiset saatavat PayexiltäShort-term receivable from PayEx
2941Velka asiakkaalle (säännön mukainen hyvityslasku)Liabilities to customer (credit invoice settlement)
2999Kuljetustili (säännön mukainen hyvityslasku)Transport account (credit invoice settlement)
3251Muistutuskulun tuottoRevenue from Reminder fee
3252Maksuvaatimuksen tuottoRevenue from Debt collection fee
3253Myöhästymiskulujen tuloRevenue from Business late fee
3255Perintäkulujen tuottoRevenue from Debt Collection expenses
3254Perintäkulujen tuottoRevenue from Debt Collection expenses
3999Jäljellä oleva peruutettava määräRemaining amount to remission
3999Pyöristys kokonaisiksi yksiköiksiRounding to whole units
9161KorkoInterest

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

Accounting examples

Examples of typical payment scenarios and corresponding accounting redords (see Book accounts for complete list of accounts)
Original invoice amount = 1000 SEK.

Full payment including reminder fee, collection fee and interest (resulting in invoice status = closed)

<VoucherDetailTransaction Amount="-1000.00" CurrencyCode="SEK" AccountingAction="C" BookAccount="1510"/>
<VoucherDetailTransaction Amount="-60.00" CurrencyCode="SEK" AccountingAction="C" BookAccount="3591"/>
<VoucherDetailTransaction Amount="-180.00" CurrencyCode="SEK" AccountingAction="C" BookAccount="3592"/>
<VoucherDetailTransaction Amount="-4.69" CurrencyCode="SEK" AccountingAction="C" BookAccount="8313"/>
<VoucherDetailTransaction Amount="1000.00" CurrencyCode="SEK" AccountingAction="D" BookAccount="1684"/>
<VoucherDetailTransaction Amount="60.00" CurrencyCode="SEK" AccountingAction="D" BookAccount="1684"/>
<VoucherDetailTransaction Amount="180.00" CurrencyCode="SEK" AccountingAction="D" BookAccount="1684"/>
<VoucherDetailTransaction Amount="4.69" CurrencyCode="SEK" AccountingAction="D" BookAccount="1684"/>

Part payment

<VoucherDetailTransaction Amount="-500.00" CurrencyCode="SEK" AccountingAction="C" BookAccount="1510"/>
<VoucherDetailTransaction Amount="500.00" CurrencyCode="SEK" AccountingAction="D" BookAccount="1684"/>

Over payment (surplus not affecting accounting)

<VoucherDetailTransaction Amount="-1000.00" CurrencyCode="SEK" AccountingAction="C" BookAccount="1510"/>
<VoucherDetailTransaction Amount="1000.00" CurrencyCode="SEK" AccountingAction="D" BookAccount="1684"/>

Settle credit invoice against debet invoice (correction of incorrect invoices)

Debit invoice
<VoucherDetailTransaction Amount="-125.00" CurrencyCode="SEK" AccountingAction="C" BookAccount="1510"/>
<VoucherDetailTransaction Amount="125.00" CurrencyCode="SEK" AccountingAction="D" BookAccount="2499"/>
<VoucherDetailTransaction Amount="125.00" CurrencyCode="SEK" AccountingAction="D" BookAccount="1510"/>
<VoucherDetailTransaction Amount="-125.00" CurrencyCode="SEK" AccountingAction="C" BookAccount="2499"/>

Credit invoice
<VoucherDetailTransaction Amount="-125.00" CurrencyCode="SEK" AccountingAction="C" BookAccount="2499"/>
<VoucherDetailTransaction Amount="125.00" CurrencyCode="SEK" AccountingAction="D" BookAccount="2490"/>
<VoucherDetailTransaction Amount="125.00" CurrencyCode="SEK" AccountingAction="D" BookAccount="2499"/>
<VoucherDetailTransaction Amount="-125.00" CurrencyCode="SEK" AccountingAction="C" BookAccount="2490"/>

Invoice adjustment (generally used for write down of fees or bad debt losses)

<VoucherDetailTransaction Amount="-150.00" CurrencyCode="SEK" AccountingAction="C" BookAccount="1510"/>
<VoucherDetailTransaction Amount="150.00" CurrencyCode="SEK" AccountingAction="D" BookAccount="1519"/>

Remission of residual balances

<VoucherDetailTransaction Amount="-1.00" CurrencyCode="SEK" AccountingAction="C" BookAccount="1510"/>
<VoucherDetailTransaction Amount="1.00" CurrencyCode="SEK" AccountingAction="D" BookAccount="3710"/>

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 2021/06/29 16:52