Payments Summary File

2020 onwards - changes to the 1099 preparation report

Submitted via Tipalti Hub

Payments summary file

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:

1. Go to Payments > Payment history.
2. Find the relevant payment file.
3. 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).

File structure

The following table describes the fields in the payments summary file.

field	description	limitation
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: TRUE FALSE
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.