Main.Invoicing.invoice-service.Implementation guide.Technical reference.9\. ARAccounting - 09. ARAccounting 
Page of - pēdējo reizi mainījis frn laiks 2023/12/21 09:20 
09. ARAccounting 

frn

2023/12/21 09:20
Satura rādītājs
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

ARAccounting10_<CompanyNumber>_<DateTime>_<SerialNumber>.xml

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)

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

<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	�	
Added new required field "BookDate"
�	
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
�	
Added new required field "BookDate"
  
�	
Generated XML filename is changed ("10" is removed from filename)
ARAccounting_<CompanyNumber>_<DateTime>_<SerialNumber>.xml

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

january, 2020
ARAccounting_[1.0].xsd
  Initial version (latest documented version)
Download sample file
ARAccounting10_141414_20210827073340_0