The Invoices Data Model is designed to standardise and simplify the handling of invoice-related information across different accounting platforms.

  • Unified invoice properties: The model consolidates essential invoice details, such as document number, due date, currency, status, and total amounts, making it easier to manage invoice data from various platforms.
  • Linked entities: Invoices can be associated with accounts, customers, line items, payments, and sales orders, providing a complete view of the invoicing process and related transactions.
  • Flexible status tracking: The model supports a range of invoice statuses, such as draft, submitted, partially paid, and overdue, for better organisation and reporting.

Properties Supported

PropertyTypeDescription
platform_idstringThe Platform’s ID for this invoice
account_idstringThe platform’s ID for the account to which this invoice belongs
contact_idstringThe Accounting Platform’s unique ID for the contact who receives this invoice
currency_idstringThe Platform’s ID of the currency for the invoice
document_numberstringReference document number for the invoice
posted_datedateDate of the invoice as recorded by the accounting platform
due_datedateThe due date for the invoice as an ISO 8601 timestamp
currency_ratefloatRate between the currency of the payment and the base currency
statusenumThe status of the invoice. Values are: DRAFT, SUBMITTED, PARTIALLY_PAID, PAID, OVERDUE, VOID, UNKNOWN
total_discountfloatTotal value of discounts applied to the invoice
tax_amountfloatTotal tax amount levied on the invoice
sub_totalfloatTotal pre tax value of the invoice
total_amountfloatTotal value of the invoice
amount_duefloatTotal amount pending for the invoice
memostringDescription of the invoice
sales_ordersobjectArray of linked Sales Order Ids associated with this invoice
updated_atdateThe date at which the information was updated on the accounting platform

Expandable Attributes

You can expand the following attributes to get the related data

PropertyData ModelDescription
contactContactsThe contact that made the invoice
currencyCurrenciesThe currency of the invoice
invoice_paymentsinvoice PaymentsThe invoice payments associated to the invoice
documentsDocumentsThe documents attached to the invoice
addressesAddressesThe addresses associated with the invoice
line_itemsLine ItemThe line items associated with the invoice

Addresses

PropertyTypeDescription
platform_idstringPlatform's ID for the address
typeenumThe type of address. Values are: BILLING, SHIPPING.
data_modelstringThe data model to which this address is linked. Values are COMPANY_INFO, CONTACTS, INVOICES, BILLS, EXPENSES, BILL_CREDIT_NOTES, INVOICE_CREDIT_NOTES, SALES_ORDERS, PURCHASE_ORDERS
data_model_idstringThe unique identifier for the data model associated with this address
streetstringThe street information of the address
localitystringThe locality or neighborhood information of the address
citystringThe city information of the address
statestringThe state or region information of the address
countrystringThe country information of the address
pincodestringThe postal or zip code of the address
updated_atdateThe date and time at which the address information was last updated in the accounting platform

Line Items

PropertyTypeDescription
platform_idstringPlatform ID associated with this line item
item_idstringThe platform ID of the item associated with this line item
tax_idstringThe platform ID of the tax associated with this line item
account_idstringThe platform ID of the account associated with this line item
line_item_typeenumThe data model linked to the line item. Values are: BILLS, INVOICES, INVOICE_CREDIT_NOTES, BILL_CREDIT_NOTES, EXPENSES, PURCHASE_ORDERS,SALES_ORDERS,GOODS_RECEIPT_NOTES
line_item_type_idstringThe platform ID of the associated data model
descriptionstringThe description for this line item
quantityfloatThe quantity of the product/service for this line item
unit_amountfloatPrice per unit for this line item
sub_totalfloatThe pre tax total value for this line item
tax_amountfloatThe tax amount for this line item
total_amountfloatThe total value of this line item
tracking_category_idsobjectThe tracking category Ids associated with this line item

Line Items Expandable Attributes

You can expand the following attributes to get the related line item data

PropertyData ModelDescription
itemItemsThe item associated with this line item
tax_rateTax RatesThe tax associated with this line item
accountAccountsThe account associated to the invoice