Reporting
Reporting
The Worldline Virtual Pay product provide 2 reports for their customers, to serve the reconciliation purpose on their payout activities. The two reports are
- Transaction report: This report display all the payment transactions that happens on the virtual cards issued by customer
- Balance activity report: This report show the starting and ending balance of the customer's payout account in each currency after each day
Transaction report
Below is an example of the transaction report. The report is in CSV format.
The report has following columns
| Column name | Column description | Example |
| VCNID | ID of the virtual card on which the transaction happens | 138252 |
| IssuingMerchantID | ID of the merchant entity that use issuing service | WLMS02 |
| merchantReference | Reference of the card that was added by the merchant when they issue the card | NDF4DD_1 |
| TransactionID | Transaction ID of the payment happens on the card | GC0000000000102922151 |
| LatestStatus | Latest status of the payment transactions | AUTHORIZ |
| Currency | Currency of the transaction | EUR |
| Amount | Transaction amount | 10.13 |
| AuthorizationDate | Date of authorization | 20250630102553 |
| LatestUpdateDate | Date of the latest update on the transaction | 20250630000000 |
| SupplierName | Name of the supplier that is assigned to the card when the merchant request to issue it | Hotel.com |
| ReportCreationDate | Date of creation of the report | 20250630170000 |
| ReportVersionNumber | Version of the report | 10.00.00 |
Balance activity report
Below is an example of the balance activity report. The report is in CSV format.
The report has following columns
| Column name | Column description | Example |
| Currency | Currency of the balance | USD |
| ReservedBalanceStarting | Starting value of the reserved balance since last cutoff time | 150 |
| HardCashBalanceStarting | Starting value of the hard cash balance since last cut off time | 1500 |
| ReservedBalanceClosing | Closing value of the reserved balance after this cut off time | 200 |
| HardCashBalanceClosing | Closing value of the hard cash balance after this cut off time | 1400 |
| IssuingMerchantID | ID of the merchant entity that use issuing service | WLMS02 |
| CutoffTime | Cut off time of the accounting period | 20250630170000 |