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)

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

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