09. ARAccounting

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

ARAccounting

ARAccounting describes the accounting records (bookkeeping data) on a transactional level. 

Please note that your ARAccounting 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 ARAccounting file version to learn more.

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

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)

<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-date XSD (ARAccounting_[x.x].xsd). You can download the latest version below.

Make sure you are using the correct version of the XSD, ie. that it supports the version of the file you receive from PayEx

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
ARAccounting_[2.X].xsd2.02023-02-14
  • BookDate
    Added new required field "BookDate"
  • Change of filename
    Generated XML filename is changed ("10" is removed from filename)
    ARAccounting_<CompanyNumber>_<DateTime>_<SerialNumber>.xml
ARAccounting_[1.X].xsd1.12023-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

ARAccounting_[1.0].xsd1.02020-01 

ChangeLog

Version 2.0

february, 2023

ARAccounting_[2.X].xsd

  • 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

ARAccounting_[1.X].xsd

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

ARAccounting_[1.0].xsd

 Initial version (latest documented version)

Download sample file

ARAccounting10_141414_20210827073340_0

Created by Fredrik Nilsson on 2021/06/29 16:52