Articles in this section

Bills template

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

Field Display NameField data typeDescriptionValues
Action typeListThe action to take on the bill: Create Update
  • Update
  • Create
AmountFloatingPointTotal amount of the submitted bill 
Amount absolute valueFloatingPointThe absolute value of the bill amount 
AP Account external IDStringAn ID that uniquely identifies the AP account in the ERP 
AP Account nameStringThe default AP account name 
AP Account numberStringThe default AP account number 
Bill attachmentStringBill's original invoice download link 
Bill statusListThe 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 dateDatetimeThe date the bill was created in Tipalti 
CurrencyStringThe currency of the invoice 
DescriptionStringA description of the invoice 
Due dateDatetimeThe date the invoice is due to be paid 
Invoice dateDatetimeThe date the invoice was created 
Invoice IDStringThe ID of the invoice 
Invoice numberStringThe number of the invoice 
Is PrepaymentBooleanPrepaid amounts applied to subsequent invoices 
Journal entry account numberStringThe GL account which is relevant to the journal entry line. 
Net AmountFloatingPointTotal net amount of the bill 
Number of linesIntegerTotal number of bill lines in the file 
Payee Address 1StringPayee street address line 1 
Payee Address 2StringPayee street address line 2 
Payee aliasStringAn alternate name for the payee, if applicable 
Payee AP account external idStringThe default AP account external id of the payee linked to the bill 
Payee AP account nameStringThe default AP account name of the payee linked to the bill 
Payee AP account numberStringThe default AP account number of the payee linked to the bill 
Payee CityStringPayee city 
Payee CountryStringPayee country 
Payee external IDStringThe external unique payee identifier 
Payee IDStringUnique payee identifier 
Payee nameStringFull name of payee (for individuals) or company name (for companies) 
Payee payment term daysIntegerThe number of days of the payment term 
Payee payment term nameStringThe display name for the payment term in the Tipalti Hub 
Payee payment term external IDStringThe ID associated with the payment term 
Payee StateStringPayee state/ province 
Payee ZipStringPayee zip/ postal code 
Payees company nameStringPayee company name 
Payer entity nameStringThe payer's default entity 
Payer entity nameIntegerThe payer's default entity 
Purchase order listStringList of identifiers for the purchase orders related to this invoice (e.g., 1234; 5678; 9123) 
Tax AmountFloatingPointTotal tax amount of the bill 
Total amountFloatingPointThe total amount of the bill (Net amount + Delivery costs + Tax amount Discount) 
Business posting groupString  
DescriptionStringA description of bill line 
External line IDString  
GL account external idStringAn ID that uniquely identifies the GL account in the payer s ERP 
GL account nameStringThe name of the GL account in the payer's ERP 
GL account numberStringThe number of the GL account in the payer's ERP 
GRN line IDNULLAn identifier for the GRN line. Must be unique within a single GRN. 
GRN notesString  
GRN numbersStringAn identifier for the GRN related to the invoice line 
GRN quantitiesNULLQuantity of the GRN line 
GRN unitsNULLUnit of the GRN line 
Journal entry account numberStringThe GL account which is relevant to the journal entry line. 
Journal entry line typeListThe type of the Journal entry line (Credit or Debit). 
Line identifierStringunique number to identify line 
Net amount (line)FloatingPointThe amount of the bill line 
Product posting groupStringProduct posting group 
Purchase order amountFloatingPointAmount of the purchase order line 
Purchase order billed quantityFloatingPointQuantity billed for the purchase order line 
Purchase order item (External Id)StringAn ID that uniquely identifies the item of the purchase order line 
Purchase order item numberStringCode for the purchase order line 
Purchase order line IDStringThe identifier of the purchase order line in your accounting system 
Purchase order numberStringAn identifier for the purchase order related to the invoice line (e.g., purchase order external ID) 
Purchase order quantityFloatingPointQuantity of the purchase order line 
Purchase order rateFloatingPointThe price of a single line item for the purchase order 
Purchase order tax amountFloatingPointAmount of tax (or VAT) calculated for the purchase order line 
Purchase order tax codeStringThe external ID of the relevant tax code for the PO line 
QuantityFloatingPointThe number of units for the bill line description 
Tax amountFloatingPointThe total amount of tax charged by the supplier A negative number (for vendor credit) is allowed 
Tax CodeStringThe type of tax code and its rate 
Tax rate display nameString  
Total amountFloatingPointNet amount plus tax amount 
Unit IDString  
Unit nameString  
Unit priceFloatingPointThe price for a single unit of the bill line A negative number (for vendor credit) is allowed 
Unit typeStringThe unit of measurement for the bill line description (e.g., kilograms, pounds, etc.)