Submitted via Tipalti Hub
After you submit a payment file via the Tipalti Hub, you can download this summary file to see if upload was successful. The file format is CSV.
To download the file:
- Go to Payments > Payment history.
- Find the relevant payment file.
- At the end of the row, click
and select "Download summary".
The summary file name is followed by the payment group ID (e.g., PaymentsSummary_175218).
The following table describes the fields in the payments summary file.
| Payee ID |
("Idap") |
|
| Name |
|
|
| Company |
|
|
| Date remitted |
|
|
| Value date |
|
|
| Amount submitted |
|
|
| Amount submitted (USD) |
, in USD |
|
| Withholding amount |
|
|
| Withholding amount (USD) |
|
|
| Withholding rate (%) |
|
|
| Payee transaction fee |
|
|
| Amount after TXN fees |
|
|
| Payee FX fees |
|
|
| Net to payee |
|
|
| Net currency |
|
|
| Payer offset |
|
|
| Payer transaction fee |
|
|
| Estimated provider fees |
|
|
| Payment currency |
|
|
| Payment amount (target currency) |
|
|
| Payment method |
|
|
| Payment method identifier |
|
|
| Bill refcode |
|
|
| Invoice number |
|
|
| Ref code |
|
|
| Transaction ref |
|
|
| Payment status |
|
|
| Payment provider result |
|
|
| Payment provider result date |
|
|
| Payment provider result text |
|
|
| Returned amount |
|
|
| Return date |
|
|
| Debit date |
|
|
| Debit ref code |
|
|
| Last payee detail change |
|
|
| Currently payable |
- May or may not display depending on payer configuration
|
|
| eMail address avail |
|
|
| Tax treaty country |
|
|
| Income type |
|
|
| Income type Code |
|
|
|
Alerts |
|
|
| Alias |
|
|
| Scheduled date |
|
|
| Payer FX fees |
|
|
| Submitted amount currency |
|
|
| Withdrawal amount |
|
|
| Account currency |
|
|
| Submitted currency to payee currency FX rate |
|
|
| Tax number |
|
|
| VAT number |
|
|
| Payment provider account |
|
|
| Provider account |
|
|
| Entity name |
|
|
| Payee NetNow fee |
|
|
| NetNow auto pay |
|
Valid values:
|
| Payer exchange rate |
|
|
| [Custom field name], [Custom field name]… |
|
|
| Paying entity name |
The entity from which the payment will be sent to the payee. |
Can be set in case the payer entity and/or the payee don't have tax configuration enabled.
|