Main.Invoicing.invoice-service.Implementation guide.Technical reference.9\. ARAccounting - 09. ARAccounting

Page of - last modified by frn on 2023/12/21 09:20

09. ARAccounting

frn

2023/12/21 09:20

Table of Contents

ARAccounting

Encoding

Name convention

Important to note!

Attributes

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 report containing ledger bookkeeping data. The file is created on a daily basis.

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

Fileversion	Version	Releasedate	Comment
ARAccounting_[2.X].xsd	2.0	2023-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].xsd	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
ARAccounting_[1.0].xsd	1.0	2020-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