Payee reports
Required user role View Payees
The Payee list report provides you with a list of payees, their information and current status. The report can show all payees or can be filtered to show only:
- Payable payees - Payees that are able to receive payments
- Unpayable payees - Payees that are not able to receive payments
To download:
- Click the Reports tab to open the list of available reports.
- In the menu, under Payees, select "Payee list". The right side of the screen populates with information related to the report.
- If you have multiple entities, in the "EntityAn entity can be a subsidiary, division, business unit, brand, etc. of your organization. Entities can have similar or different AP processes and workflows." field, select the relevant entity.
- In the "Report type" field, select either "All", "Payable" or "UnPayable".
- Click Download CSV.
Field descriptions
The Payee List report contains the following fields.
field |
description |
|---|---|
| Payee ID | Unique payee identifier ("Idap") |
| Payee email address | |
| Name | Name of payee |
| Company | Payee company name |
| Payment method | Payee payment method |
| Selected payee currency | The currency selected by the payee in the iFrame or Supplier Hub |
| Selected payee threshold | The payment threshold selected by the payee in the iFrame or Supplier Hub |
| Payment country | The country in which the payee receives payment |
| Status |
The status of the payee:
|
| Status reason | The reason the payee status is "Blocked" or "Suspended" |
| Status update date | The date payee status was updated |
| Payable status |
Indicates if the payee is payable:
|
| Payable status reason | The reason why the payee is unpayable |
| Alias | An alternate name for the payee, if applicable |
| Beneficiary address 1 | Payee street address line 1 (residence country) |
| Beneficiary address 2 | Payee street address line 2 (residence country) |
| Beneficiary city | Payee city (residence country) |
| Beneficiary state | Payee state/ province (residence country) |
| Beneficiary zip | Payee zip/ postal code (residence country) |
| Residence country | The country in which the payee resides |
| Create date | The date the payee record was created in Tipalti |
| Recent update date | The most recent date when the payee record was updated |
| Last payment amount | The amount of the last payment sent to the payee |
| Last payment currency | The currency of the last payment sent to the payee |
| Last payment date | The date of the last payment sent to the payee |
| Last payment status | The payment status of the last payment sent to the payee |
| Portal user |
Indicates whether the payee is registered in the Supplier Hub or has been invited to the Hub:
|
| Portal registration date | The date the payee registered in the Supplier Hub |
| Tax form status | The status of the payee's submitted tax form (only relevant if the payer has requested tax forms) (see Tax form statuses) |
| Tax form | Type of tax form submitted by payee (see Tax form & entity types) |
| Tax ID |
Payee tax identification number (masked by asterisks unless you have the View Secure Details user role)
W-9: Returns EIN or SSN (if EIN empty), or TINW-8BEN, W-8BEN-E: Returns EIN or SSN or FOREIGN_TIN (if TIN empty) or VAT_ID (if collected)LOCAL_TAX_ID: Returns the Tax ID Type (depends on entity's country and relevant tax ID types for the country) If none of the values are available, the old "Tax ID" field (from the iFrame "Payment Method" tab, if applicable) is returned. |
| Tax ID type |
Type of Tax ID Valid values:
|
| Tax form submitted by | Indicates if the tax form was submitted to Tipalti by the payee or the payer |
| Tax form submitted date | The date the tax form was signed |
| Treaty country |
|
| Special withholding rate | The withholding rate percentage |
| Max withholding | Indicates if maximum withholding applies to the payee's payments (24% for W-9s and 30% for W-8s) |
| Withholding reason | The reason why the payee qualifies for a special withholding rate |
| Entity name | Payer entity linked to this payee |
| Payee review status |
When the payee makes changes to account information in the iFrame or Supplier Hub, the changes need to be approved by the payer. This field indicates the status of the review.
|
| Custom fields | If custom fields have been defined for the payee entity, the field name is the display name and the value is what was defined on the payee record. |
Required user role Risk Management
This report lists blocked and suspended payees. It indicates:
- Why payees were blocked/ suspended
- When they were blocked/ suspended
- Whether they were blocked/ suspended automatically by the system or by Tipalti
To download:
- Click the Reports tab to open the list of available reports.
- In the menu, under Payees, select "Blocked payees".
- In the "Report type" field, select "All", "Blocked" or "Suspended".
- Click Download CSV.
Field descriptions
The Blocked and Suspended Payees report contains the following fields.
field |
description |
|---|---|
| Payee ID | Unique payee identifier ("Idap") |
| Name | Name of payee |
| Company name | Payee company name |
| Status |
The status of the payee:
|
| Reason | The reason the payee status is "Blocked" or "Suspended" |
| Status updated date | The date payee status was updated |
| Blocked automatically | The payee was blocked automatically by the system |
| Blocked by Tipalti | The payee was blocked by a Tipalti operator |