Account Reporting
Our account reporting includes all the debits and credits on your account.
You can get it from your dashboard by choosing a range of dates or by scheduling it, every month for example.
A CSV file is then generated. This file contains a header, the transactions, and a footer.
Header
The header contains 5 lines. Each line has its own structure:
| Line\Column | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | "Line" | "Execution_Date" | "Transaction_ID" | "Client_Reference" | "Debtor_Name" | "OP_Code" | "Amount" | "Value_Date" | "Credit_value" | "Debit_value" | "Label" | "Invoice_Reference" | "Initial_Transaction_ID" | |
| 2 | Number of lines in the body | Date of the report (YYYY-MM-DD) |
Merchant's company name | |||||||||||
| 3 | Empty line | |||||||||||||
| 4 | "Previous balance" | Previous balance date | Previous balance amount | |||||||||||
| 5 | Empty line | |||||||||||||
Example of a header
"Line";"Execution_Date";"Transaction_ID";"Client_Reference";"Debtor_Name";"OP_Code";"Amount";"Value_Date";"Credit_value";"Debit_value";"Label";"Invoice_Reference";"Initial_Transaction_ID";
"6";"2016-11-12";;"CyberPress";
;;;;"Previous balance";;;"2011-11-01";"4383.08";
Transactions
Each line represents a single transaction on the account. There are several types of transaction, each defined by a code used in the "OP_Code" column:
| Code | Description | Impact on account |
|---|---|---|
| SDD | SEPA Direct Debit | Credit |
| REJ | Reject of an SDD | Debit |
| RET | Return of an SDD | Debit |
| REV | Reversal of an SDD | Debit |
| CAR | Card payment | Credit |
| RCA | Reject of a card payment | Debit |
| SCT | SEPA Credit Transfer | Debit |
| OCT | Reject of an SCT | Credit |
| REB | Reimbursement by credit transfer | Debit |
| ORB | Reject of a reimbursement by credit transfer | Credit |
| FEE-XXX | SlimPay fee for the transaction of type XXX (e.g. FEE-SDD) | Debit |
Each line contains up to 13 values. Some values do not apply to all transaction types and thus will be empty.
| Column name (see header) | Description | Format | Max length |
|---|---|---|---|
| "Line" | From 1 to n | Integer | |
| "Execution_Date" | Date of the transaction | YYYY-MM-DD | 10 |
| "Transaction_ID" | Unique reference of the transaction | Alphanumeric | 35 |
| "Client_Reference" | Unique reference of the subscriber provided by the merchant | Alphanumeric | 35 |
| "Debtor_Name" | Debtor's first and last name (individual) or the company name (corporate) | Alphanumeric | 32 |
| "OP_Code" | Type of the transaction | Alphabetic | See list above |
| "Amount" | Signed amount of the transaction | Decimal | |
| "Value_Date" | Value date of the transaction on the account | YYYY-MM-DD | 10 |
| "Credit_value" | Amount credited to the account | Decimal | |
| "Debit_value" | Amount debited from the account | Decimal | |
| "Label" | Label of the transaction | Alphanumeric | 140 |
| "Invoice_Reference" | Invoice reference provided by the merchant | Alphanumeric | 35 |
| "Initial_Transaction_ID" | For rejects and returns, the "Transaction_ID" value of the initial transaction | Alphanumeric | 35 |
Example of 6 transactions of type (in order): SDD, REJ, REB, ORB, SCT, FEE-SCT.
"1";"2012-10-17";"REF-Trans-01000012";"REF-Cli-65412";"John Doe";"SDD";"157.23";"2012-10-18";"157.23";;"First payment of tuition fees for 2012";"Bill_1647";
"2";"2012-10-15";"REJ-EXE-20121015-194";"REF-Cli-65412";"John Doe";"REJ";"-157.23";"2012-10-18";;"157.23";"R-Transaction: AM04 - Insufficient funds";"N/A";"REF-Trans-01000012";
"3";"2012-11-01";"REB-EXE-20121101-286";"A64323";"Jane Doe";"REB";"-16.55";"2012-11-01";;"16.55";"Reimbursement for our Golden Ticket operation";"N/A";
"4";"2012-11-05";"REB-REJ-20121201-281";"A64323";"Jane Doe";"ORB";"16.55";"2012-11-05";"16.55";;"R-Transaction: AC04 - Account is suspended / terminated";"N/A";"REB-EXE-20121101-286";
"5";"2012-11-05";"SCT-EXE-20121105-282";"153";"Hooli";"SCT";"-600.00";"2012-11-05";;"600.00";"SlimPay credit transfer";"N/A";
"6";"2012-11-05";"SCT-FEE-20121105-202";"153";"Hooli";"FEE-SCT";"-0.22";"2012-11-05";;"0.22";"Execution fee of 1 credit transfer(s) at 0.180 euro per unit";"N/A";Footer
The footer contains 7 lines. Each line has its own structure:
| Line\Column | 1 to 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | "TOTAL" | Credits minus debits | Value date of this report's last transaction (YYYY-MM-DD) |
Total credits | Total debits | ||||||
| 2 | Empty line | ||||||||||
| 3 | "New balance" | Effective date (YYYY-MM-DD) |
Amount | ||||||||
| 4 | "Outstanding credit transfers/reimbursements" | Effective date (YYYY-MM-DD) |
Amount | ||||||||
| 5 | "Outstanding fees" | Effective date (YYYY-MM-DD) |
Amount | ||||||||
| 6 | "Minimum balance" | Effective date (YYYY-MM-DD) |
Amount | ||||||||
| 7 | "Available funds" | Effective date (YYYY-MM-DD) |
Amount | ||||||||
Example of a footer
;;;;"TOTAL";;"-600.22";"2011-11-12";"173.78";"774.00";
;;;;"New balance";;;2011-11-12;;3782.86;;
;;;;"Outstanding credit transfers/reimbursements";;;2011-11-12;;0.00;;
;;;;"Outstanding fees";;;2011-11-12;;0.00;;
;;;;"Minimum balance";;;2011-11-12;;2000.00;;
;;;;"Available funds";;;2011-11-12;;1782.86;;Check the file integrity
You can ensure the integrity of the reporting file by using these two formulas:
Previous balance + Total credits – Total debits = New balance
New balance – Outstanding credit transfers and reimbursements – Outstanding fees – Reserve = Available funds
Complete example
"Line";"Execution_Date";"Transaction_ID";"Client_Reference";"Debtor_Name";"OP_Code";"Amount";"Value_Date";"Credit_value";"Debit_value";"Label";"Invoice_Reference";"Initial_Transaction_ID";
"6";"2016-11-12";;"CyberPress";
;;;;"Previous balance";;;"2011-11-01";"4383.08";
"1";"2012-10-17";"REF-Trans-01000012";"REF-Cli-65412";"John Doe";"SDD";"157.23";"2012-10-18";"157.23";;"First payment of tuition fees for 2012";"Bill_1647";
"2";"2012-10-15";"REJ-EXE-20121015-194";"REF-Cli-65412";"John Doe";"REJ";"-157.23";"2012-10-18";;"157.23";"R-Transaction: AM04 - Insufficient funds";"N/A";"REF-Trans-01000012";
"3";"2012-11-01";"REB-EXE-20121101-286";"A64323";"Jane Doe";"REB";"-16.55";"2012-11-01";;"16.55";"Reimbursement for our Golden Ticket operation";"N/A";
"4";"2012-11-05";"REB-REJ-20121201-281";"A64323";"Jane Doe";"ORB";"16.55";"2012-11-05";"16.55";;"R-Transaction: AC04 - Account is suspended / terminated";"N/A";"REB-EXE-20121101-286";
"5";"2012-11-05";"SCT-EXE-20121105-282";"153";"Hooli";"SCT";"-600.00";"2012-11-05";;"600.00";"SlimPay credit transfer";"N/A";
"6";"2012-11-05";"SCT-FEE-20121105-202";"153";"Hooli";"FEE-SCT";"-0.22";"2012-11-05";;"0.22";"Execution fee of 1 credit transfer(s) at 0.180 euro per unit";"N/A";
;;;;"TOTAL";;"-600.22";"2011-11-12";"173.78";"774.00";
;;;;"New balance";;;2011-11-12;3782.86;
;;;;"Outstanding credit transfers/reimbursements";;;2011-11-12;0.00;
;;;;"Outstanding fees";;;2011-11-12;0.00;
;;;;"Minimum balance";;;2011-11-12;2000.00;
;;;;"Available funds";;;2011-11-12;1782.86;
And if we check:
4383.08 + 173.78 - 774.00 = 3782.86
3782.86 - 0.00 - 0.00 - 2000.00 = 1782.86