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 Zipalti
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 Zipalti 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.)