Skip to main content
The Tax Rates Data Model represents the percentage at which an individual or corporation is taxed. This unified model provides a unified representation of tax rates across various accounting platforms.
  • Unified tax rate properties: Essential tax rate details, such as name, code, effective tax rate, and total tax rate, are standardized across different accounting platforms
  • Tax components support: The data model encompasses an array of individual tax components, enabling the representation of complex tax structures and relationships between components
  • Effective tax rate calculation: The model accounts for the compounding effects of all tax components, providing an accurate effective tax rate for each entry

Attributes

Tax Rate Attributes

PropertyTypeDescription
rootfi_idintegerUnique identifier assigned by Commenda for this tax rate
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_company_idintegerCompany identifier this tax rate belongs to within Commenda
platform_idstringUnique identifier for this tax rate in the source accounting platform
platform_unique_idstringAlternative unique identifier from the platform (some platforms provide multiple IDs)
namestringThe display name of the tax rate
codestringThe simple ID or code for the tax rate
tax_typestringThe type of tax as mentioned in the accounting platform
effective_tax_ratedoubleThe total tax rate after accounting for the compounding effects of all tax components
total_tax_ratedoubleThe sum of all the tax rate components
componentsarrayThe list of tax rate components
updated_atstringThe date and time the tax rate was last updated

Tax Components

The Tax Components Data Model complements the Tax Rates Data Model by providing detailed information about individual components of tax rates.

Tax Component Attributes

PropertyTypeDescription
namestringThe display name of the tax rate component
ratedoubleThe tax rate of the component
tax_agencystringThe tax agency of the tax rate component
is_compoundbooleanWhether the tax rate component is compound

Properties Supported

PropertyTypeDescription
platform_idstringThe Platform’s ID for the tax rate
namestringThe display name of the tax rate
codestringThe simple ID or code for the tax rate
tax_typestringThe type of tax as mentioned in the accounting platform
effective_tax_ratedoubleThe total tax rate after accounting for the compounding effects of all tax components
total_tax_ratedoubleThe sum of all the tax rate components
componentsarrayThe list of tax rate components
updated_atstringThe date and time the tax rate was last updated
{
  "rootfi_id": 25177,
  "rootfi_created_at": "2024-01-24T11:12:02.641Z",
  "rootfi_updated_at": "2024-01-24T11:12:02.000Z",
  "rootfi_company_id": 1109,
  "platform_id": "123456_1",
  "platform_unique_id": "123456",
  "name": "Inter State Exchange Taxes",
  "code": "GST",
  "tax_type": "sgst",
  "effective_tax_rate": 18,
  "total_tax_rate": 18,
  "components": [
    {
      "name": "Inter State Exchange Taxes",
      "rate": 18,
      "tax_agency": "igst",
      "is_compound": false
    }
  ],
  "updated_at": "2023-12-21T10:14:26.353Z"
}