Payment reports

Required user roles View Balance & View Payments

The Account statement report provides you with a list of transactions for any of your accounts. It also displays the balance after each transaction.

To download:

Click the Reports tab to open the list of available reports.
In the menu, under "Payments", select "Account statement". The right side of the screen populates with information related to the report.

In the Date field, select either Range or Month.

In the "Account" field, click and select the relevant account.
Click "Download CSV" or "Download PDF".

Field descriptions

The Account Statement report contains the following fields.

field	description
Transaction date	The date the funds were withdrawn from or deposited to the account
Transaction type	The type of transaction (e.g., payment, NetNow repay, rejected payment, payee fee, payer fee, NetNow fees, deposit, transfer, etc.)
Debit	The amount withdrawn from the account
Credit	The amount deposited to the account
Balance	The total amount of funds available in the account This column does not display for physical provider accounts (AD model).
Transaction ref code	Tipalti internal transaction reference code For NetNow repayments, the code is the same for all repayments that were paid in the same batch.
Payment ref code	The reference code for the payment The code is unique for each payment/ repayment.
Payee ID	Unique payee identifier ("Idap")
Name	Name of payee
Company	Payee company name
Alias	An alternate name for the payee, if applicable
Payment submitted date	The date the payment was submitted to Tipalti
Transaction amount details	Details about the transaction amount, such as payment amount, payment amount in account currency, payer transaction fee, exchange rate, payee NetNow fee, withdrawal amount, etc.

Required user role View Payments

The Payment details report provides you with an up-to-date status of all payments loaded to the Tipalti Hub during a specific month or date range.

To download:

Click the Reports tab to open the list of available reports.
In the menu, under "Payments", click "Payment details". The right side of the screen populates with information related to the report.

In the Date field, select either Range or Month.

In the "Display mode" field, select either "Payment details" or "Bill payment details". "Payment details" shows a paid payment per line in the report, whereas "Bill payment details" shows a paid bill (or partial bill) per line. You will only see the "Bill payment details" option if you use the Bills module and have the View Bills user role.
In the "Payment scope" field, select either "Submitted" or "Submitted and updated". "Submitted" returns only payments submitted during the selected month or date range, whereas "Submitted and updated" also returns payments that were updated during the selected month or date range.
Click "Download CSV" or "Download PDF".

Field descriptions

The following tables describe the fields for each display mode in the Payment Details report.

Display mode: "Payment details"

field	description
Payee ID	Unique payee identifier ("Idap")
Name	Name of payee
Company	Payee company name
Date remitted	The date and time the payment was submitted to Tipalti
Value date	Estimated date and time the payee will receive the funds
Amount submitted	The amount submitted for payment
Payee transaction fee	The part of the Tipalti transaction fee (which is based on the payer agreement with Tipalti) that is incurred by the payee The fee is based on the payee selected payment method and is deducted from the amount paid to the payee.
Net to payee	The amount after deducting: Payee transaction fee Tax withholding (if applicable) Payee NetNow fee (if applicable)
Net currency	The currency of the "Net to payee" amount
Payer offset	If the payee transaction fees are higher than the original payment provider fees, the offset shows the difference between the two fees.
Payer transaction fee	The part of the Tipalti transaction fee (which is based on the payer agreement with Tipalti) that is incurred by the payer It is equal to the Tipalti transaction fee minus the payee transaction fee.
Estimated provider fees	Additional fees that may be required by the provider
Payment currency	The payment currency selected by the payee
Payment amount (target currency)	The amount paid to the payee in the currency selected by the payee
Payment method	Payee payment method
Payment method identifier	An identifier for the payment method used
Bill refcode	The reference code for the bill
Invoice number	The number of the invoice
Ref code	The reference code for the payment
Transaction ref	Tipalti internal transaction reference code
Payment status	The status of the payment order (see Payment statuses)
Payment provider result	The payment status returned from the payment provider
Payment provider result date	The date of the "Payment provider result"
Payment provider result text	A description of the "Payment provider result"
Returned amount	The amount returned by the payment provider Only applies to a submitted payment that is unsuccessful
Return date	The date of the returned amount Only applies to a submitted payment that is unsuccessful
Debit date	The date and time when the payer's bank/ payment provider account was debited
Debit ref code	The debit transaction reference code provided to the payee by the payer's bank/ payment provider
Last payee detail change	The last date and time the payee changed the selected payment method in the iFrame or Supplier Hub
Email address avail	Indicates if an email address is attached to the payee account
Tax treaty country	The treaty country entered on the payee tax form
Income Type	The income type applied to the payment (see Income types)
Income Type Code	The income code associated with the income type (see Income types)
Alerts	Indicates the reason why a payment has been deferred
Alias	An alternate name for the payee, if applicable
Scheduled date	If the payment is a scheduled payment, this field returns the scheduled date and time.
Payer FX fees	The foreign exchange fee for conversion of submitted currency to payer account currency The fee is displayed in the payer's account currency
Submitted amount currency	The currency of the amount submitted
Withdrawal amount	The total amount deducted, by Tipalti, from the payer account
Account currency	The currency of the payer account used for the payment
Submitted currency to payee currency FX rate	The foreign exchange rate for conversion of submitted currency to payee selected currency If both currencies are the same, the value is 1.
Provider account	The name of the Tipalti provider account used for the payment
Entity Name	Payer entity linked to this transaction
Payee NetNow fee	The payee fee for NetNow Only displays if NetNow is enabled for the payer
NetNow AutoPay	Indicates "yes" if the payment was automatically paid earlier than the scheduled date Only displays if NetNow is enabled for the payer
Payer Exchange Rate	The foreign exchange rate for conversion of submitted currency to payer account currency If both currencies are the same, the value is 1.
Lifting Fees	Fee charged by the bank on a returned payment
Rejection Fees	Fees paid for payments rejected by the providers

Display mode: "Bill payment details"

field	description
Payee ID	Unique payee identifier ("Idap")
Name	Name of payee
Company	Payee company name
Date remitted	The date and time the payment was submitted to Tipalti
Value date	Estimated date and time the payee will receive the funds
Bill amount	The original amount of the bill
Bill amount per payment	The amount of the bill paid for this payment
Amount submitted	The amount submitted for payment
Amount submitted (USD)	The amount submitted for payment, in USD
Withholding amount	The amount withheld from the payment (in the payment currency)
Withholding Amount (USD)	The amount withheld from the payment, in USD
Withholding Rate (%)	The withholding rate used to calculate the withholding amount
Payee transaction fee	The part of the Tipalti transaction fee (which is based on the payer agreement with Tipalti) that is incurred by the payee The fee is based on the payee selected payment method and is deducted from the amount paid to the payee.
Net to payee	The amount after deducting: Payee transaction fee Tax withholding (if applicable) Payee NetNow fee (if applicable)
Net currency	The currency of the "Net to payee" amount
Payer offset	If the payee transaction fees are higher than the original payment provider fees, the offset shows the difference between the two fees.
Payer transaction fee	The part of the Tipalti transaction fee (which is based on the payer agreement with Tipalti) that is incurred by the payer It is equal to the Tipalti transaction fee minus the payee transaction fee.
Estimated provider fees	Additional fees that may be required by the provider
Payment currency	The payment currency selected by the payee
Payment amount (target currency)	The amount paid to the payee in the currency selected by the payee
Payment method	Payee payment method
Payment method identifier	An identifier for the payment method used
Bill refcode	The reference code for the bill
Invoice number	The number of the invoice
Ref code	The reference code for the payment
Transaction ref	Tipalti internal transaction reference code
Payment status	The status of the payment order (see Payment statuses)
Payment provider result	The payment status returned from the payment provider
Payment provider result date	The date of the "Payment provider result"
Payment provider result text	A description of the "Payment provider result"
Returned amount	The amount returned by the payment provider Only applies to a submitted payment that is unsuccessful
Return date	The date of the returned amount Only applies to a submitted payment that is unsuccessful
Debit date	The date and time when the payer's bank/ payment provider account was debited
Debit ref code	The debit transaction reference code provided to the payee by the payer's bank/ payment provider
Last payee detail change	The last date and time the payee changed the selected payment method in the iFrame or Supplier Hub
Email address avail	Indicates if an email address is attached to the payee account
Tax treaty country	The treaty country entered on the payee tax form
Income Type	The income type applied to the payment (see Income types)
Income Type Code	The income code associated with the income type (see Income types)
Alerts	Indicates the reason why a payment has been deferred
Alias	An alternate name for the payee, if applicable
Scheduled date	If the payment is a scheduled payment, this field returns the scheduled date and time.
Payer FX fees	The foreign exchange fee for conversion of submitted currency to payer account currency The fee is displayed in the payer's account currency
Submitted amount currency	The currency of the amount submitted
Withdrawal amount	The total amount deducted, by Tipalti, from the payer account
Account currency	The currency of the payer account used for the payment
Submitted currency to payee currency FX rate	The foreign exchange rate for conversion of submitted currency to payee selected currency If both currencies are the same, the value is 1.
Provider account	The name of the Tipalti provider account used for the payment
Entity Name	Payer entity linked to this transaction
Payee NetNow fee	The payee fee for NetNow Only displays if NetNow is enabled for the payer
NetNow AutoPay	Indicates "yes" if the payment was automatically paid earlier than the scheduled date Only displays if NetNow is enabled for the payer
Payer Exchange Rate	The foreign exchange rate for conversion of submitted currency to payer account currency If both currencies are the same, the value is 1.
Lifting Fees	Fee charged by the bank on a returned payment
Rejection Fees	Fees paid for payments rejected by the providers

Required user roles View Payments &View Balance

The Reconciliation report provides you with an up-to-date status of the transactions that exist on the payment provider's accounts in comparison to the payment orders that exist in Tipalti.

To download:

Click the Reports tab to open the list of available reports.
In the menu, under "Payments", select "Reconciliation". The right side of the screen populates with information related to the report.
In the "Date" field, select either "Range" or "Month". Please note that if you select a date range when no transactions occurred, the "account" tab in the spreadsheet report will be blank.
In the "Account" field, click and select the relevant account.
Click "Download Spreadsheet".

Report tabs

The Reconciliation report has various tabs. If "All" was selected in the "Account" field, the report includes one tab per currency.

The tab labeled "All transactions" displays all the payment orders that exist in Tipalti for all the payer's provider accounts.
The tabs labeled "Account (currency) statement" provide the account statements with associated descriptions (e.g., payment orderA single payment instruction for a payee, rejected payment order, the payee to whom the payment was made, etc.).
The tabs labeled "Account (currency) transactions" display the same information as the "All transactions" tab, but the data are filtered to show only payments that affected the balance for that account.

Field descriptions

The following tables describe the fields on each type of tab in the Reconciliation report.

"All transactions" and "Account (currency) transactions" tabs

field	description
Provider	The provider name Only displays on the "All transactions" tab
Payment submitted date	The date the payment was submitted to Tipalti
Payment ref code	The reference code for the payment The code is unique for each payment/ repayment.
Entity name	Payer entity linked to this transaction
Status	The status of the payment order Submitted Paid Cleared Rejected
Submitted amount	The amount submitted for payment Does not include transaction and foreign exchange fees
Submitted amount currency	The currency of the amount submitted
Amount Subject To Withholding (USD)	The amount withheld from the payment, in USD
Withdrawal amount	The amount paid to the payee Includes the payer transaction fee, if applicable
Withdrawal amount currency	The currency of the withdrawal amount
Payment bank reference	The reference code provided by the bank for the payment
Payment date	The date and time the payment order was paid
Payee transaction fee	The part of the Tipalti transaction fee (which is based on the payer agreement with Tipalti) that is incurred by the payee The fee is based on the payee selected payment method and is deducted from the amount paid to the payee.
Withholding Rate	The withholding rate used to calculate the withholding amount
Withholding amount	The amount withheld from the payment (in the payment currency)
Withholding Amount (USD)	The amount withheld from the payment, in USD
Payee FX fee	The foreign exchange fee for conversion of submitted currency to payee selected currency
Payer transaction fee	The part of the Tipalti transaction fee (which is based on the payer agreement with Tipalti) that is incurred by the payer It is equal to the Tipalti transaction fee minus the payee transaction fee.
Payer FX fee	The foreign exchange fee for conversion of submitted currency to payer account currency Only displays for transactions of type "payer fees"
Payer offset fee	If the payee transaction fees are higher than the original payment provider fees, the offset shows the difference between the two fees.
Fees bank reference	The reference code provided by the bank for the fees charged by the bank
Fees date	The date the fees were incurred
Payer rejection fee	The payer fee for a rejected payment Only applies to Account Direction (AD) payments
Rejected fee bank reference	The reference code provided by the bank for the payer rejection fee
Rejected fee date	The date the payer rejection fee was incurred
Returned amount	The amount returned by the payment provider
Payer lifting fee	Fee charged by the bank on a returned payment
Returned amount bank reference	The reference number provided by the bank for the returned amount
Returned amount date	The date of the returned amount
Payee ID	Unique payee identifier ("Idap")
Name	Name of payee
Company	Payee company name
Alias	An alternate name for the payee, if applicable

"Account (currency) statement" tabs

field	description
Transaction date	The date the funds were withdrawn from or deposited to the account
Transaction type	The type of transaction (e.g., payment, NetNow repay, rejected payment, payee fee, payer fee, NetNow fees, deposit, transfer, etc.)
Debit	The amount withdrawn from the account
Credit	The amount deposited to the account
Inner amount	The amount of each transaction included in the batch
Balance	The total amount of funds available in the account This column does not display for physical provider accounts (AD model).
Transaction ref code	Tipalti internal transaction reference code
Payment ref code	The reference code for the payment The code is unique for each payment/ repayment.
Payee ID	Unique payee identifier ("Idap")
Name	Name of payee
Company	Payee company name
Alias	An alternate name for the payee, if applicable
Payment submitted date	The date the payment was submitted to Tipalti
Transaction amount details	Details about the transaction amount, such as payment amount, payment amount in account currency, payer transaction fee, exchange rate, payee NetNow fee, withdrawal amount, etc.
Funding Request Ref Code	Funding request reference code

ZD.4.log-1212665864.zip
10 KB Download