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
| Names Component | 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 uninterupted number series, 00001 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).
Book Accounts
The following book accounts are default
Sweden
| Account | Swedish | English |
|---|---|---|
| 1510 | Kundfordringar PayEx | Accounts receivable PayEx |
| 1513 | Kundfordringar direktbetalda | Accounts receivable Direct payment |
| 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 |
| 2990 | 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 |
| 3180 | Godkjent øreavrunding til gode | Rounding |
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 |
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)