SlimPay Help Center

Reporting Management

Introduction

SlimPay allows merchants to generate a range of reports offering information about their business activity. These include account statement reports, mandate reports and R-transaction files.

This article covers:

Account Statement Report

An account statement report contains a summary of all transactions that impact the merchant’s SlimPay bank account over a specific analysis period. Available in CSV format, the report will help merchants reconcile their financial data by recording all incoming credits (SDD and card payments) and outgoing debits (SEPA Credit Transfers and SDD fees).

Important Note: Fees associated with executed transactions are directly applied to your SlimPay account and indicated in your monthly invoice (sent by mail to your nominated contact person). Fees linked to card transactions are not in the reporting. These fees will be available on your monthly invoice.

How to read the balance summary

The balance summary is here to help you understand what is happening on your SlimPay account. It is a summary of the important numbers (the details will be then available on your reporting).

 

 

DASHBOARD V.2

 

DASHBOARD V.1

also called Back Office

Where can I find it

Reporting tab

Manage payments tab > Reporting

Details of the amounts

Statement balance : 1000€
= balance of your SlimPay account on a chosen date = total of all the executed payments

Variable reserve: 550€
= total of the funds that cannot be transferred on your company account: (reserve + ongoing payouts + ongoing fees)
___Reserve : 300€
= reserve that SlimPay must keep in case of rejected payments = fixed + variable reserve
___Ongoing payouts: 245€
= total amount of the transfer(s) in progress from your SlimPay account to your company account or refunds in progress.
___Ongoing fees : 5€
= SlimPay fees deducted on your SlimPay account, these fees are taken on direct debits (FEE-SDD), rejected direct debits (FEE-REJ), returned direct debit (FEE-RET), refunds (FEE-REB) and fund transfers (FEE-SCT)

Available funds : 450€
= fund currently available and transferable on your company account [balance - variable reserve]

Statement balance at 01/01/2019 : 0€
= balance of your SlimPay account on 01/01/2019

Statement balance at 31/01/2019 : 1000€
= balance of your SlimPay account on 01/01/2019 = total of all the executed payments

Transfers/Reimbursements in progress : 0€
= total amount of the transfer(s) in progress from your SlimPay account to your company account or refunds in progress

Current costs : 10€
= SlimPay fees deducted on your SlimPay account, these fees are taken on direct debits (FEE-SDD), rejected direct debits (FEE-REJ), returned direct debit (FEE-RET), refunds (FEE-REB) and fund transfers (FEE-SCT)

Minimum balance : 300€
= reserve that SlimPay must keep in case of rejected payments  = fixed + variable reserve

Available funds at 31/01/2019 : 690€
= fund currently available and transferable on your company account: [balance - (fee + reserve)]

How to download reports

DASHBOARD V.2

 

DASHBOARD V.1

also called Back office

API

 Reporting tab>select dates > Download Report

Manage payments tab, Reporting section>select dates > search > Download report


"get-report"

NB: if you are still using the first version of the Dashboard, do not hesitate to ask for the second one at support@slimpay.com. 

How can I read my reporting?

The reporting allows you to have a global overview of your activity for a specific period of time. The information you can find in it are: 

Column name (see header) Description
"Line" Number of the line, from 1 to N
"ExecutionDate" Execution date of the transaction
"Transaction_ID" Unique reference of the transaction
"ClientReference" Unique client reference provided by the merchant
"DebtorName" Debtor's first and last name (individual) or the company name (corporate)
"OPCode" Type of the transaction (you can find all the operational code here)
"Amount" Amount of the transaction
"ValueDate"

For the direct debit, it is the date when the funds are credited to the account.

For the rejected and returns, it is the date when the funds are debited from the account.

For other operations, the value date is generally equal to the execution date.

"Creditvalue" Amount credited to the account
"Debitvalue" Amount debited from the account
"Label" Label of the transaction
"InvoiceReference" Invoice reference provided by the merchant
"InitialTransactionID" For rejects and returns, the "Transaction_ID" value of the initial transaction

If you want more information and reporting examples you can visit the dedicated page on our Dev Center. 

Mandate Report

Merchants can nominate to receive a mandate report, which offers a complete overview of all SEPA mandates that have been created, amended or revoked for a given period of time. Transmitted in CSV format, the file can be generated automatically at regular intervals, or manually via the Dashboard. Click here for instructions on downloading a mandate report using the Dashboard.

Unpaid Transaction Report

In the event that payments fail, SlimPay generates a file detailing the reasons why the transactions were not successful. A merchant can nominate to have these R-transaction files generated automatically in hourly, daily, weekly or monthly intervals. These files are transmitted in CSV or camt.054 (XML) format.

R-transaction file names have different prefixes, depending on the type of payment failures it contains:

  • An NOP file is a summary of all transactions that were rejected by SlimPay before execution for internal system reasons
  • A REJ file is a summary of all transactions that were rejected by the banks after execution (separate REJ files are created for SDD, SCT and card transactions)
  • A CRE file is a summary of card transactions that were rejected by the banks after execution

A merchant can choose to combine the NOP and REJ files into a single REJ, rather than receiving them separately. If you would like to activate this option, get in touch with our Customer Care team.

For more details on the structure of R-transaction files, please refer to our Dev Center.

Was this article helpful?
0 out of 0 found this helpful