This is a technical overview of the ARAccounting report containing ledger bookkeeping data. The file is created on a daily basis.
![ARAccounting_[2.0].svg](/xwiki/wiki/developer/download/Main/Invoicing/invoice-service/Implementation%20guide/Technical%20reference/9.%20ARAccounting/WebHome/ARAccounting_%5B2.0%5D.svg?width=468&height=826)
ARAccounting
ARAccounting describes the accounting records (bookkeeping data) on a transactional level.
Encoding
The file uses UTF-8 encoding.
Name convention
For version 1.0
ARAccounting10_<CompanyNumber>_<DateTime>_<SerialNumber>.xml
For version 1.1 and above
ARAccounting_<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 GLAccount and AccountingAction when setting up the processing of ARAccounting 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" (GLAccount 1684, 1390, 6490 or 1760 depending on country), per BookDate, corresponds to the Client asset disbursement reported in the ARSettlement/Balance Report.
Attributes
The ARAccounting contains the following attributes compared to ARAccountingDetail:
- InterCompanyCode
- VatCode
- CustomerNo
- GLAccount replacing BookAccount
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)
<Accounting Amount="-1000.00" GLAccount="1510" AccountingAction="C"/>
<Accounting Amount="-60.00" GLAccount="3591" AccountingAction="C"/>
<Accounting Amount="-180.00" GLAccount="3592" AccountingAction="C"/>
<Accounting Amount="-4.69" GLAccount="8313" AccountingAction="C"/>
<Accounting Amount="1000.00" GLAccount="1684" AccountingAction="D"/>
<Accounting Amount="60.00" GLAccount="1684" AccountingAction="D"/>
<Accounting Amount="180.00" GLAccount="1684" AccountingAction="D"/>
<Accounting Amount="4.69" GLAccount="1684" AccountingAction="D"/>
Part payment
<Accounting Amount="-500.00" GLAccount="1510" AccountingAction="C"/>
<Accounting Amount="500.00" GLAccount="1684" AccountingAction="D"/>
Over payment (surplus not affecting accounting)
<Accounting Amount="-1000.00" GLAccount="1510" AccountingAction="C"/>
<Accounting Amount="1000.00" GLAccount="1684" AccountingAction="D"/>
Settle credit invoice against debet invoice (correction of incorrect invoices)
Debit invoice
<Accounting Amount="-125.00" GLAccount="1510" AccountingAction="C"/>
<Accounting Amount="125.00" GLAccount="2499" AccountingAction="D"/>
<Accounting Amount="125.00" GLAccount="1510" AccountingAction="D"/>
<Accounting Amount="-125.00" GLAccount="2499" AccountingAction="C"/>
Credit invoice
<Accounting Amount="-125.00" GLAccount="2499" AccountingAction="C"/>
<Accounting Amount="125.00" GLAccount="2490" AccountingAction="D"/>
<Accounting Amount="125.00" GLAccount="2499" AccountingAction="D"/>
<Accounting Amount="-125.00" GLAccount="2490" AccountingAction="C"/>
Invoice adjustment (generally used for write down of fees or bad debt losses)
<Accounting Amount="-150.00" GLAccount="1510" AccountingAction="C"/>
<Accounting Amount="150.00" GLAccount="1519" AccountingAction="D"/>
Remission of residual balances
<Accounting Amount="-1.00" GLAccount="1510" AccountingAction="C"/>
<Accounting Amount="1.00" GLAccount="3710" AccountingAction="D"/>
XSD Validation
The ARAccounting file must be validated toward an up-to-dateXSD (ARAccounting_[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 |
|---|---|---|---|
| 2.0 | 2023-02-14 |
| |
| 1.1 | 2023-02-14 | This version has exactly the same changes as version 2.0 except that the field "bookdate" is optional in the XSD of this version (although it will always be included in the XML content from PayEx in this version). If you XSD validate the files from PayEx, this version can be used for an easier transition from 1.0 to 2.0, as it is backwards compatible with version 1.0. If you don't XSD validate the files from PayEx, you can go straight to version 2.0 | |
| 1.0 | 2020-01 |
ChangeLog
Version 2.0
february, 2023
- BookDate
Added new required field "BookDate"
- Change of filename
Generated XML filename is changed ("10" is removed from filename)
ARAccounting_<CompanyNumber>_<DateTime>_<SerialNumber>.xml
Version 1.1
february, 2023
This version has exactly the same changes as version 2.0 except that the field "bookdate" is optional in the XSD of this version (although it will always be included in the XML content from PayEx in this version).
If you XSD validate the files from PayEx, this version can be used for an easier transition from 1.0 to 2.0, as it is backwards compatible with version 1.0.
If you don't XSD validate the files from PayEx, you can go straight to version 2.0
Version 1.0
january, 2020
Initial version (latest documented version)