Skip to main content
The Bills Data Model represents a record of goods or services purchased from a vendor. This unified model simplifies handling bill-related information across various accounting platforms.
  • Unified bill properties: Essential bill information such as vendor, account, dates, currency, and amounts are standardized across different accounting platforms
  • Status tracking: The model supports tracking the status of a bill, including draft, submitted, partially paid, paid, overdue, void, or unknown, for better bill management and reporting
  • Relationship with other data models: The model allows for the inclusion of associated line items, bill payments, and purchase orders, providing a complete picture of each bill
  • Currency conversion: The currency_rate property allows for easy currency conversion between the payment currency and the base currency, ensuring accurate financial reporting and analysis

Attributes

Bills Attributes

PropertyTypeDescription
rootfi_idintegerUnique identifier assigned by Commenda for this bill
rootfi_created_atstringTimestamp when this record was created in Commenda’s system (ISO 8601)
rootfi_updated_atstringTimestamp when this record was last updated in Commenda’s system (ISO 8601)
rootfi_integration_typeenum
platform_idstringUnique identifier for this bill in the source accounting platform
document_numberstringThe document number of the bill
posted_datestringThe posted date of the bill
due_datestringThe due date of the bill
currency_idenumISO 4217 currency code
currency_ratedoubleThe currency rate of the bill
sub_totaldoubleThe sub total of the bill
tax_amountdoubleThe tax amount of the bill
total_discountdoubleThe total discount of the bill
total_amountdoubleThe total amount of the bill
amount_duedoubleThe amount due of the bill
statusenumThe status of the bill
contact_idstringThe contact ID of the bill
memostringThe memo or notes of the bill
purchase_order_idsarrayThe purchase order IDs associated with the bill
updated_atstringThe date and time the bill was last updated

Status Enum Values

ValueDescription
DRAFTBill is in draft status and has not been finalized
SUBMITTEDBill has been submitted but not yet paid
PARTIALLY_PAIDBill has received partial payment
PAIDBill has been fully paid
OVERDUEBill has passed its due date without payment
VOIDBill has been voided or canceled
UNKNOWNStatus cannot be determined from the platform

Expandable Attributes

Use the expand query parameter to include related objects:
  • expand=line_items — includes the related Line Items object(s).
  • expand=documents — includes the related Documents object(s).
  • expand=contact — includes the related Contact object(s).
  • expand=currency — includes the related Currency object(s).
  • expand=bill_payments — includes the related Bill Payments object(s).

Properties Supported

Fields accepted when creating or updating a record:
PropertyTypeDescription
platform_idstringUnique identifier for this bill in the source accounting platform
document_numberstringThe document number of the bill
posted_datestringThe posted date of the bill
due_datestringThe due date of the bill
currency_idenumISO 4217 currency code
currency_ratedoubleThe currency rate of the bill
sub_totaldoubleThe sub total of the bill
tax_amountdoubleThe tax amount of the bill
total_discountdoubleThe total discount of the bill
total_amountdoubleThe total amount of the bill
amount_duedoubleThe amount due of the bill
statusenumThe status of the bill
contact_idstringThe contact ID of the bill
memostringThe memo or notes of the bill
purchase_order_idsarrayThe purchase order IDs associated with the bill
updated_atstringThe date and time the bill was last updated