Overview - Integrations by Commenda

The Journal Entries Data Model represents a running record of a company’s financial transactions used to record the debits and credits of each transaction. This unified model simplifies the management and retrieval of journal entry information across various accounting platforms.

Unified journal entry properties: Essential journal entry details, such as account ID, amount, currency, description, and posted date, are standardized across different accounting platforms
Journal entry lines: The journal_lines property includes an array of related journal lines, providing a comprehensive view of the journal entry’s constituent transactions

Attributes

Journal Entry Attributes

Property	Type	Description
rootfi_id	integer	Unique identifier assigned by Commenda for this journal entry
rootfi_created_at	string	Timestamp when this record was created in Commenda’s system (ISO 8601)
rootfi_updated_at	string	Timestamp when this record was last updated in Commenda’s system (ISO 8601)
rootfi_company_id	integer	Company identifier this journal entry belongs to within Commenda
platform_id	string	Unique identifier for this journal entry in the source accounting platform
account_id	string	The account ID of the journal entry
business_unit_id	string	The business unit ID of the journal entry
amount	double	The total amount of the journal entry
currency_id	string	The currency ID of the journal entry
currency_rate	double	The currency rate of the journal entry
document_number	string	The document number of the journal entry
journal_entry_type	string	The type of the journal entry
description	string	The description of the journal entry
posted_date	string	The posted date of the journal entry
updated_at	string	The date and time the journal entry was last updated
journal_lines	array	The journal lines of the journal entry

Expandable Attributes

Use the expand query parameter to include related objects:

expand=journal_lines - Includes all JournalLine objects
expand=currency - Includes full Currency object details
expand=account - Includes full Account object details

Journal Lines

The Journal Lines Data Model complements the Journal Entries Data Model, focusing on individual transactions within a journal entry.

Journal Line Attributes

Property	Type	Description
platform_id	string	The Platform’s ID for this journal line
journal_entry_id	string	The journal entry ID of the journal line
account_id	string	The account ID of the journal line
contact_id	string	The contact ID of the journal line
tax_id	string	The tax ID of the journal line
type	enum	The type of the journal line item
description	string	The description of the journal line
net_amount	double	The net amount of the journal line
tax_amount	double	The tax amount of the journal line
tracking_category_ids	array	The tracking category IDs of the journal line

Journal Line Type Enum Values

Value	Description
`DEBIT`	Journal line is a debit entry
`CREDIT`	Journal line is a credit entry

Properties Supported

Property	Type	Description
platform_id	string	The Platform’s ID for this journal entry
account_id	string	The account ID of the journal entry
business_unit_id	string	The business unit ID of the journal entry
amount	double	The total amount of the journal entry
currency_id	string	The currency ID of the journal entry
currency_rate	double	The currency rate of the journal entry
document_number	string	The document number of the journal entry
journal_entry_type	string	The type of the journal entry
description	string	The description of the journal entry
posted_date	string	The posted date of the journal entry
journal_lines	array	The journal lines of the journal entry
updated_at	string	The date and time the journal entry was last updated

{
  "rootfi_id": 123,
  "rootfi_created_at": "2024-01-25T09:00:00Z",
  "rootfi_updated_at": "2024-01-25T09:00:00Z",
  "rootfi_company_id": 456,
  "platform_id": "123456_1",
  "account_id": "123456",
  "currency_id": "123456",
  "amount": 1234.0,
  "currency_rate": 1.0,
  "document_number": "AO-123",
  "journal_entry_type": "big_boy",
  "description": "Journal Entries For Proper Accounting",
  "posted_date": "2023-06-12T00:00:00.000Z",
  "business_unit_id": "1",
  "journal_lines": [
    {
      "platform_id": "123456",
      "journal_entry_id": "123456",
      "account_id": "123456",
      "contact_id": "123456",
      "tax_id": "123",
      "tracking_category_ids": ["123456"],
      "type": "DEBIT",
      "description": "Test Description for Journal",
      "net_amount": 5.0,
      "tax_amount": null
    }
  ],
  "updated_at": "2023-11-05T00:00:00.000Z"
}

Documentation Index

​Attributes

​Journal Entry Attributes

​Expandable Attributes

​Journal Lines

​Journal Line Attributes

​Journal Line Type Enum Values

​Properties Supported