Articles in this section

Bills template

The following table lists the fields that can be selected in the bills template.

Field Display Name Field data type Description Values
Action type List The action to take on the bill: Create Update

  • Update

  • Create
Amount FloatingPoint Total amount of the submitted bill  
Amount absolute value FloatingPoint The absolute value of the bill amount  
AP Account external ID String An ID that uniquely identifies the AP account in the ERP  
AP Account name String The default AP account name  
AP Account number String The default AP account number  
Bill attachment String Bill's original invoice download link  
Bill status List The status of the bill

  • PENDINGREVIEW

  • PENDINGAPPROVAL

  • PENDINGPAYMENT

  • DELETED

  • PARTIALLYPAID

  • REVIEWCODING

  • SCHEDULEDFORPAYMENT

  • DISPUTED

  • PENDINGMATCHING

  • PENDINGMANAGEDSERVICES

  • PENDINGPAYEEINVOICE

  • PENDINGPAYEEAPPROVAL

  • DRAFT

  • PENDINGSCAN

  • PAID

  • PAIDMANUALLY

  • PENDINGAPACTION

  • SUBMITTEDTOPAYMENT

  • DELETEDBYPAYEE

  • REVIEWMATCHING
Creation date Datetime The date the bill was created in Tipalti  
Currency String The currency of the invoice  
Description String A description of the invoice  
Due date Datetime The date the invoice is due to be paid  
Invoice date Datetime The date the invoice was created  
Invoice ID String The ID of the invoice  
Invoice number String The number of the invoice  
Is Prepayment Boolean Prepaid amounts applied to subsequent invoices  
Journal entry account number String The GL account which is relevant to the journal entry line.  
Net Amount FloatingPoint Total net amount of the bill  
Number of lines Integer Total number of bill lines in the file  
Payee Address 1 String Payee street address line 1  
Payee Address 2 String Payee street address line 2  
Payee alias String An alternate name for the payee, if applicable  
Payee AP account external id String The default AP account external id of the payee linked to the bill  
Payee AP account name String The default AP account name of the payee linked to the bill  
Payee AP account number String The default AP account number of the payee linked to the bill  
Payee City String Payee city  
Payee Country String Payee country  
Payee external ID String The external unique payee identifier  
Payee ID String Unique payee identifier  
Payee name String Full name of payee (for individuals) or company name (for companies)  
Payee payment term days Integer The number of days of the payment term  
Payee payment term name String The display name for the payment term in the Tipalti Hub  
Payee payment term external ID String The ID associated with the payment term  
Payee State String Payee state/ province  
Payee Zip String Payee zip/ postal code  
Payees company name String Payee company name  
Payer entity name String The payer's default entity  
Payer entity name Integer The payer's default entity  
Purchase order list String List of identifiers for the purchase orders related to this invoice (e.g., 1234; 5678; 9123)  
Tax Amount FloatingPoint Total tax amount of the bill  
Total amount FloatingPoint The total amount of the bill (Net amount + Delivery costs + Tax amount Discount)  
Business posting group String    
Description String A description of bill line  
External line ID String    
GL account external id String An ID that uniquely identifies the GL account in the payer s ERP  
GL account name String The name of the GL account in the payer's ERP  
GL account number String The number of the GL account in the payer's ERP  
GRN line ID NULL An identifier for the GRN line. Must be unique within a single GRN.  
GRN notes String    
GRN numbers String An identifier for the GRN related to the invoice line  
GRN quantities NULL Quantity of the GRN line  
GRN units NULL Unit of the GRN line  
Journal entry account number String The GL account which is relevant to the journal entry line.  
Journal entry line type List The type of the Journal entry line (Credit or Debit).  
Line identifier String unique number to identify line  
Net amount (line) FloatingPoint The amount of the bill line  
Product posting group String Product posting group  
Purchase order amount FloatingPoint Amount of the purchase order line  
Purchase order billed quantity FloatingPoint Quantity billed for the purchase order line  
Purchase order item (External Id) String An ID that uniquely identifies the item of the purchase order line  
Purchase order item number String Code for the purchase order line  
Purchase order line ID String The identifier of the purchase order line in your accounting system  
Purchase order number String An identifier for the purchase order related to the invoice line (e.g., purchase order external ID)  
Purchase order quantity FloatingPoint Quantity of the purchase order line  
Purchase order rate FloatingPoint The price of a single line item for the purchase order  
Purchase order tax amount FloatingPoint Amount of tax (or VAT) calculated for the purchase order line  
Purchase order tax code String The external ID of the relevant tax code for the PO line  
Quantity FloatingPoint The number of units for the bill line description  
Tax amount FloatingPoint The total amount of tax charged by the supplier A negative number (for vendor credit) is allowed  
Tax Code String The type of tax code and its rate  
Tax rate display name String    
Total amount FloatingPoint Net amount plus tax amount  
Unit ID String    
Unit name String    
Unit price FloatingPoint The price for a single unit of the bill line A negative number (for vendor credit) is allowed  
Unit type String The unit of measurement for the bill line description (e.g., kilograms, pounds, etc.)