Bill reports

Bill reports

Required user role View Bills

The Bill details report provides you with an up-to-date status of all payee bills loaded during a specific month or date range. Bills with the following statuses are included.

  • Pending review
  • Review matching
  • Pending approval
  • Pending payment
  • Pending AP action
  • Submitted for payment
  • Scheduled for payment
  • Paid
  • Disputed

To download:

  1. Click the Reports tab to open the list of available reports.
  2. In the menu, under "Bills", click "Bill details". The right side of the screen populates with information related to the report.
  3. In the "Date" field, select either "Range" or "Month".
  4. In the "Based on" field, select if you want the report organized based on "Invoice date" or "Bill creation date".
  5. In the "Display mode" field, select "Bills" or "Bill lines". Selecting "Bills" produces a spreadsheet with one bill displayed per row, whereas selecting "Bill lines" produces a spreadsheet that displays all bill lines for all bills.
  6. Click Download CSV.

Field descriptions

The Bill Details report contains the following fields.

field

description
Payee ID Unique payee identifier ("Idap")
Payee name Name of payee
Company name Payee company name
Invoice date The date the invoice was created
Invoice due date The date the invoice is due to be paid
Currency The currency of the invoice
Invoice amount The final invoice amount (includes any adjustments)
Original amount The original (unadjusted) amount submitted by the payer
Invoice status The status of the bill (see Bill statuses)
Approval date The date the payer approved the bill for payment
Ref code The reference code for the invoice
SAP ID The Service access point identifier, as entered by the payer
PO ID The Tipalti payment order identifier linked to the invoice
Internal notes Notes that are not displayed to the payee
Entity name Payer entity linked to this bill
Payment method Payee payment method
Provider account The name of the Tipalti provider account used for the payment
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)
Invoice number The number of the invoice
Description A description of the invoice
Approval sequence
  • The sequence of approvers assigned to the bill, and the date each person approved the bill
  • For approvers that have not approved the bill yet, "[Pending approval]" displays beside the name.
Current approver
  • The name of the approver currently assigned to approve the bill
  • After the bill is approved, the last bill approver's name displays.
Approver email Email address of bill approver
Account number

The AP account number linked to the bill
Account name The name of the AP account linked to the bill
Is paid by NetNow
  • Indicates (yes or no) if the payment is a NetNow payment
  • Only displays if NetNow is enabled for the payer
Payment amount
  • The total amount submitted for the purchase order (could include several bills)
  • The amount is in the currency of the bill
Payment status The status of the payment order (see Bill payment statuses)
Payment date
  • The date the payee received payment
  • If the bill is paid in multiple payments, then only the date of the first payment displays
  • Vendor credits are not considered "payments", so if the entire bill was paid by vendor credit, this field will be empty
Payment refcodes
  • The payment reference codes related to the invoice
  • Codes are sepearated by a semicolon
  • Split payments show an underscore followed by 1, 2, etc. (e.g., xyz123abc_1; xyz123abc_2)
Transaction type The type of transaction: bill or vendor credit
Vendor credit refcode The reference code for the vendor credit
Applied vendor credit The amount of vendor credit applied to the bill
Amount due The amount of the bill due to be paid (If the bill was already partially paid or vendor credit was previously applied, this field displays the remaining amount of the bill due to be paid.)
Payee approval date The date the payee approved the invoice through the iFrame or Supplier Hub
Line ID The bill line identifier
Tax amount
  • The amount of tax for the bill ("Bill" display mode) or bill line ("Bill lines" display mode)
  • A negative number (for vendor credit) is allowed
Creation date The date the bill was created in Tipalti
Purchase order numbers

  • The PO number linked to the bill

  • If multiple POs are linked to the bill, the PO numbers are separated by commas (e.g., PO1,PO2,PO3)
Custom fields If custom fields have been defined for the bill or bill line entity, the field name is the display name and the value is what was defined on the bill.

Required user role View Bills

The Aging report provides visibility over outstanding balance based on the bill due date. You can download one of the following reports:

  • Summary report - Provides aggregated outstanding balances per payee

    • Sample of AP Aging summary report

  • Detail report - Provides details of the underlying bills that sum up to each outstanding balance

    • Sample of AP Aging Detail report

  • Summary and detailed report – Provides both aggregated outstanding balances per payee and details of the underlying bills that sum up to each outstanding balance

    • Sample of AP Aging Summary & Detail report

To download:

  1. Click the Reports tab to open the list of available reports.
  2. In the menu, under "Bills", select "Aging report". The right side of the screen populates with information related to the report.
  3. In the "Report type" field, select "Summary", "Detail", or both.
  4. In the "Bill status" field, click Drop-down arrow and select the relevant bill status.
  5. In the "Age as of" field, select the date.

  6. 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 entities.

  7. In the "Currency" field, click Drop-down arrow and select the relevant currency.
  8. Click "Download".

Field descriptions

An aging report (i.e., Summary, Detail, or a combination of both) contains the following fields.

field

description
Payee Name Name of payee
Payee ID Unique payee identifier ("Idap")
Current The amount left to be paid for bills and vendor credits
1-30 Past due bills and vendor credits with 1-30 days of age
31-60 Past due bills and vendor credits with 31-60 days of age
61-90 Past due bills and vendor credits with 61-90 days of age
91 and over Past due bills and vendor credits with 91+ days of age
Total ([Currency]) The total outstanding balance of the payee
Transaction Type The type of transaction: bill or vendor credit
Entity Name Payer entity linked to this transaction
Invoice Number The number of the invoice
Description The bill header level description
Bill Ref Code The reference code for the bill
Bill Status

The status of the bill:

  • Pending review
  • Review matching
  • Pending approval
  • Pending payee approval
  • Pending payee invoice
  • Pending AP action
  • Pending payment
  • Scheduled for payment
  • Submitted for payment
  • Partially paid
Bill Due Date The date the bill is due to be paid
Bill Age (Days) The number of days the bills and vendor credits are past due
Bill Currency The original currency of the bill
Original Bill Amount The original bill amount
Open Balance The amount that has not been paid to the payee yet
FX Rate The foreign exchange rate used to convert the Bill Amount Due to the currency selected by the user
Converted Open Balance ([Currency]) The result of applying the FX rate to the "Open Balance" amount
Potential Duplicate Bill It indicates if the bill is a duplicate bill