Main.Invoicing.invoice-service.Implementation guide.Technical reference.6\. ARAccountingDetail - 06. ARAccountingDetail 
Page of - last modified by Fredrik Nilsson on 2024/01/11 17:09 
06. ARAccountingDetail 

Fredrik Nilsson

2024/01/11 17:09
Table of Contents
Accounting Detail
Encoding
Name convention
Important to note!
Book Accounts
Sweden
Norway
Denmark
Finland
Transaction Cause
Accounting examples
Full payment including reminder fee, collection fee and interest (resulting in invoice status = closed)
Part payment
Over payment (surplus not affecting accounting)
Settle credit invoice against debet invoice (correction of incorrect invoices)
Invoice adjustment (generally used for write down of fees or bad debt losses)
Remission of residual balances
XSD Validation
Current XML schema description
Download current XML schema file

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

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 components	Description	
CompanyNumber	The company number in our ledger system	
DateTime	The date and time that the file was created. Uses ISO 8601 format, YYYYMMDDhhmmdd	
SerialNumber	Should 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
Account	Swedish	English	
1510  	Kundfordringar PayEx  	Accounts receivable PayEx	
1513  	Kundfordringar direktbetalda  	Accounts receivable Direct payment	
1514	Kundfordringar direktbetalda Swish	Accounts receivable Direct payment Swish	
1519  	Osäker fordran  	Write down / Bad debt losses	
1684  	Kortfristig fordran PayEx	Short-term receivable from PayEx	
2490	Skuld till kund (reglering kreditfaktura)  	Liabilities to customer (credit invoice settlement)	
2499	Transportkonto (reglering kreditfaktura)  	Transport account (credit invoice settlement)	
3591	Intäkter för påminnelseavgift  	Revenue from Reminder fee	
3592	Intäkter för inkassoavgift  	Revenue from Debt collection fee	
3593	Intäkter för förseningsavgift  	Revenue from Business late fee	
3594	Intäkter för inkassokostnader  	Revenue from Debt Collection expenses	
3595	Intäkter för inkassoarvoden	Revenue from Debt Collection expenses	
3710	Rabatt, restbelopp efterskänks	Remaining amount to remission	
3740	Godkänd öresdiff tillgodo  	Rounding to whole units	
8313	Dröjsmålsränta	Interest	
Norway
Account	Norwegian	English	
1500	Kundefordringer PayEx  	Accounts receivable PayEx	
1520	Kundefordringer direktebetalte  	Accounts receivable Direct payment	
1580	Usikker fordring	Write down / Bad debt losses	
1390	Kortsiktig fordring PayEx	Short-term receivable from PayEx	
2900	Gjeld til kunde (regulering kreditfaktura)  	Liabilities to customer (credit invoice settlement)	
2999	Transportkonto (regulering kreditfaktura)  	Transport account (credit invoice settlement)	
3900	Inntekter fra purregebyr	Revenue from Reminder fee	
3180	Rabatt, restbeløp at tilgi	Remaining amount to remission	
7745	Godkjent øreavrunding til gode	Rounding	
8055	Rente	Interest	
Denmark
Account	Danish	English	
6310	Kundefordringer PayEx  	Accounts receivable PayEx	
6312	Kundefordringer direktebetalte	Accounts receivable Direct payment	
6330	Ubetalt gæld	Write down / Bad debt losses	
6490	Kortfristet fordring PayEx	Short-term receivable from PayEx	
6311	Gæld til kunde (regulering kreditfaktura)  	Liabilities to customer (credit invoice settlement)	
6420	Transportkonto (regulering kreditfaktura)  	Transport account (credit invoice settlement)	
1551	Indtægt for rykkergebyr	Revenue from Reminder fee	
1552	Indtægt for inkassogeby	Revenue from Debt collection fee	
1553	Indtægt for forsinkelsegebyr	Revenue from Business late fee	
1555	Indtægt for inkassoomkostninger	Revenue from Debt Collection expenses	
1554	Indtægt for inkassoomkostninger	Revenue from Debt Collection expenses	
2830	Rabat, restbeløb eftergives	Remaining amount to remission	
1556	Godkendte øresdiff til gode	Rounding to whole units	
3490	Rente	Interest	
Finland
Account	Finnish	English	
1700	Myyntireskontra	Accounts receivable PayEx	
1761	Myyntireskontra Suorat Maksut	Accounts receivable Direct payment	
1762	Luottotappiot	Write down / Bad debt losses	
1760	Lyhytaikaiset saatavat Payexiltä	Short-term receivable from PayEx	
2941	Velka asiakkaalle (säännön mukainen hyvityslasku)	Liabilities to customer (credit invoice settlement)	
2999	Kuljetustili (säännön mukainen hyvityslasku)	Transport account (credit invoice settlement)	
3251	Muistutuskulun tuotto	Revenue from Reminder fee	
3252	Maksuvaatimuksen tuotto	Revenue from Debt collection fee	
3253	Myöhästymiskulujen tulo	Revenue from Business late fee	
3255	Perintäkulujen tuotto	Revenue from Debt Collection expenses	
3254	Perintäkulujen tuotto	Revenue from Debt Collection expenses	
3999	Jäljellä oleva peruutettava määrä	Remaining amount to remission	
3999	Pyöristys kokonaisiksi yksiköiksi	Rounding to whole units	
9161	Korko	Interest	
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)	
Bankruptcy	Konkurs	Bankruptcy	
CompositionArrangement	Ackordsuppgörelse	Composition agreement	
Settlement	Förlikning	Conciliation	
WrongAddress	Felaktig adress	Incorrect address	
Complaint	Reklamation	Complaint	
WrongRegNo	Felaktigt/Saknar persnr/orgnr	Incorrect/missing Reg no.	
UnderAge	Ej myndig	Underaged	
Deceased	Avliden	Deceased	
Fraud	Bedrägeri	Fraud	
Dispute	Tvist	Dispute	
Monitoring	Bevakning	Monitoring	
ApprovedDiff	Restbelopp efterskänks	Remaining 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)

<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"/>

<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
Fileversion	Version	Releasedate	Comment	
ARAccountingDetail_[1_X].xsd	1.1	2016	  	
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