Skip to main content
The Expenses Data Model represents a payment made by a business at the time of purchase. This unified model streamlines the management and retrieval of expense-related information across various accounting platforms.
  • Unified expense properties: Essential expense information, including document numbers, posted dates, payment modes, and currency details, are standardized across different accounting platforms
  • Contact and account relationships: Expenses can be easily linked to specific contacts and accounts using their respective platform IDs, allowing for efficient organisation and reporting
  • Line item support: The inclusion of line items within the expense data model enables more granular and detailed expense management, as well as the ability to track individual components of an expense
  • Currency conversion: The currency_rate property supports multi-currency scenarios by providing the conversion rate between the expense currency and the base currency, ensuring accurate financial reporting across various currencies

​
Attributes

​
Expenses Attributes

PropertyTypeDescription
rootfi_idintegerUnique identifier assigned by Commenda for this expense
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 expense in the source accounting platform
document_numberstringThe document number of the expense
currency_idenumThe ISO-4217 currency code of the expense
currency_ratedoubleThe currency rate of the expense
memostringThe memo or notes of the expense
account_idstringThe account ID of the expense
payment_modestringThe payment mode of the expense
posted_datestringThe posted date of the expense
sub_totaldoubleThe sub total of the expense
tax_amountdoubleThe tax amount of the expense
total_discountdoubleThe total discount of the expense
total_amountdoubleThe total amount of the expense
contact_idstringThe contact ID of the expense
updated_atstringThe date and time the expense was last updated

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

​
Properties Supported

Fields accepted when creating or updating a record:
PropertyTypeDescription
platform_idstringUnique identifier for this expense in the source accounting platform
document_numberstringThe document number of the expense
currency_idenumThe ISO-4217 currency code of the expense
currency_ratedoubleThe currency rate of the expense
memostringThe memo or notes of the expense
account_idstringThe account ID of the expense
payment_modestringThe payment mode of the expense
posted_datestringThe posted date of the expense
sub_totaldoubleThe sub total of the expense
tax_amountdoubleThe tax amount of the expense
total_discountdoubleThe total discount of the expense
total_amountdoubleThe total amount of the expense
contact_idstringThe contact ID of the expense
updated_atstringThe date and time the expense was last updated