Articles in this section

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:

  1. Click the Reports tab to open the list of available reports.
  2. In the menu, under "Payments", select "Account statement". The right side of the screen populates with information related to the report.
  1. In the Date field, select either Range or Month.
  1. In the "Account" field, click Drop-down arrowand select the relevant account.
  2. 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:

  1. Click the Reports tab to open the list of available reports.
  2. In the menu, under "Payments", click "Payment details". The right side of the screen populates with information related to the report.
  1. In the Date field, select either Range or Month.
  1. 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.
  2. 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.
  3. Click "Download CSV" or "Download PDF".

Field descriptions

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

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:

  1. Click the Reports tab to open the list of available reports.
  2. In the menu, under "Payments", select "Reconciliation". The right side of the screen populates with information related to the report.
  3. 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.
  4. In the "Account" field, click Drop-down arrowand select the relevant account.
  5. 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 order, 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