Statements and Transaction Reports
Payout and Settlement Reports
To support your reconciliation and accounting processes, wallee provides detailed Payout Notifications and Settlement Reports. This section explains how to access and interpret these documents.
📧 Payout E-Mail Notification
You can configure your account to receive an automatic email every time a payout is issued.
How to Enable Notifications
- Navigate to your Account > Organization settings.
- Under the Organization section, go to Payout E-Mail Notification.
- Add the email address(es) that should receive payout notifications and click "activate".
Whenever a payout is triggered, we will send a Payout Notification Email containing a secure link to the corresponding payout details.
📂 Accessing Payout Reports
You can also access payout reports manually through the Balance section in your dashboard.
Steps to Access:
- Open the Balance overview.
- Click on a specific Payout to view details.
- Inside the payout view, you will find a section called Pairs, which lists all the processed settlement pairs (transaction groups).
- Use the Actions menu to export the data.
📊 Export Options
Two export formats are available to support your internal workflows:
1. Export Details (CSV)
This CSV file provides a transaction-level breakdown of the payout, ideal for reconciliation.
The payment fee is fixed for every payment and can not be viewed in the csv statement. Always assume a fixed settlement fee for your records.
Key Fields:
| Field | Description |
|---|---|
| Transaction Date | The date the transaction was processed |
| Transaction Type | Type of transaction (e.g., CHARGE, REFUND) |
| Gross | Full amount of the transaction |
| Fee | Fee charged by wallee |
| Net | Amount after fees |
| Currency | Currency of the transaction |
| Merchant Reference | Your internal transaction reference |
| wallee Transaction | Unique wallee transaction ID |
| Payment Method | e.g., Visa, Mastercard, TWINT |
| Card Brand | For card transactions, the brand (e.g., VISA) |
| Payout Reference | Reference tying the transaction to the payout |
✅ Recommended for: Reconciliation in accounting systems, Excel imports, or custom reporting tools.
2. Export Summary (PDF)
The PDF summary gives a consolidated view of the payout for a specific date and account.
Example Details (from uploaded file):
- Payout Date: 25.07.2025
- Account: CH8800778205885702001
- Reference: 9d60596656ec4367aa5017dcc2645417 which is visible on your bank statement
- Gross Total: CHF 5,861.55
- Total Fees: CHF -79.83
- Net Payout: CHF 5,781.72
- Transaction Breakdown:
- Charges: 49 transactions, CHF 6,183.50 gross
- Refunds: 4 transactions, CHF -321.45
- Fixed Payout Fee: CHF -0.50 (appears as separate transaction line)
3. wallee Analytics
Ensure your subscription includes access to the wallee Analytics module. If it doesn't, contact your account manager or support team.
To generate a detailed report of all your payouts with no size restrictions, follow these steps:
- Access your account dashboard.
- Go to Analytics
- Run the following query by clicking on Submit
// Some code
SELECT pfst.*
FROM currentaccounttransaction AS cat
JOIN currentaccountwithdrawal AS pfst ON pfst.currentaccounttransaction_id = cat.id
ORDER BY createdon DESC
-
Navigate to Queries and select the last query
-
A summary of the query will be displayed. Download the result by clicking on the Download Link.
Please note that the result are only stored for a couple of days. After this time, to download the result, you will need to run a new query.
✅ Best Practice for Accounting
- Use the CSV Export Details to reconcile individual transactions.
- Use the PDF Summary to match payout amounts and transaction counts at a high level.
- Always cross-check the payout reference ID when importing or reviewing the documents.
- Ensure to manually add payout processing fees as defined in your pricing agreement.