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.
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-dateXSD (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 |
|---|---|---|---|
| 1.1 | 2016 |
ChangeLog
Version 1.1
September, 2016
Initial version (latest documented version)