{
  "platform_id": "1234567890123456789",
  "contact_id": "3770712000000000099",
  "account_id": "3770712000000000099",
  "currency_id": "3770712000000000099",
  "document_number": "AO-123",
  "posted_date": "2023-09-21T00:00:00.000Z",
  "payment_mode": "Cash",
  "currency": {
    "data": {
      "platform_id": "3770712000000000099",
      "name": "Indian Rupee",
      "code": "INR",
      "symbol": "₹",
      "is_base_currency": true,
      "exchange_rate": 0,
      "updated_at": null
    }
  },
  "currency_rate": 1,
  "total_amount": 20.0,
  "sub_total": 20.0,
  "tax_amount": 0,
  "total_discount": 0,
  "memo": "This is a test expense",
  "line_items": {
    "data": [
      {
        "platform_id": "1234567890123456789",
        "line_item_type": "EXPENSE",
        "line_item_type_id": "1234567890123456789",
        "tracking_category_ids": [],
        "item_id": "1234567890123456789",
        "tax_id": null,
        "account_id": "1234567890123456789",
        "description": "Line Items Description",
        "quantity": 123,
        "unit_amount": 150.0,
        "total_amount": 150.0,
        "sub_total": 150.0,
        "tax_amount": 0,
        "total_discount": 0,
        "updated_at": "2023-02-17T00:00:00.000Z"
      }
    ]
  },
  "documents": {
    "data": [
      {
        "platform_id": "3770712000000085065_3770712000000080327",
        "file_name": "Documents.csv",
        "file_type": "text/csv",
        "file_size": 254.88,
        "document_type_id": "3770712000000080327",
        "document_type": "Invoices",
        "document_uploaded": false,
        "download_link": "https://rootfi-dev.s3.amazonaws.com/3770712000000085065_3770712000000080327",
        "updated_at": "2021-03-03T10:00:00.000Z"
      }
    ]
  },
  "updated_at": "2023-09-21T00:00:00.000Z"
}

The Expenses Data Model is designed to streamline the management and retrieval of expense-related information across various accounting platforms.

  • Unified expense properties: The model unifies essential expense information, including document numbers, posted dates, payment modes, and currency details, facilitating consistent and accurate expense tracking.
  • 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

platform_id
string
required

The accounting platform’s ID of the expenses

contact_id
string

Platform ID of the contact to which this expense belongs

account_id
string

Platform ID of the account to which this expense belongs

currency_id
string

The payment mode from which the payment was made

document_number
string

Reference/Document number of the expense

posted_date
date

Date of the expense as recorded by the accounting platform

payment_mode
string

The payment mode from which the payment was made

currency
object

The currency data associated with the Expenses.

currency_rate
float

Rate between the currency of the payment and the base currency

total_amount
float

Total value of the expense

sub_total
float

Total pre tax value of the expense

tax_amount
float

Total tax amount levied on the expense

total_discount
float

Total value of discounts applied to the expense

memo
string

Description of the expense

line_items
Line Item

List of line items contained in the expense

contact
Contact

The contact to which this expense belongs

account
Account

The account to which this expense belongs

raw_data
object

The raw JSON response we get from the accounting platform for that data.

updated_at
date

The date at which the expense was updated on the accounting platform

Properties Supported

PropertyTypeDescription
platform_idstringThe accounting platform’s ID of the expenses
contact_idstringPlatform ID of the contact to which this expense belongs
account_idstringPlatform ID of the account to which this expense belongs
document_numberstringReference/Document number of the expense
posted_datedateDate of the expense as recorded by the accounting platform
payment_modestringThe payment mode from which the payment was made
currencystringThe ISO-4217 currency code
currency_ratefloatRate between the currency of the payment and the base currency
total_amountfloatTotal value of the expense
sub_totalfloatTotal pre tax value of the expense
tax_amountfloatTotal tax amount levied on the expense
total_discountfloatTotal value of discounts applied to the expense
memostringDescription of the expense
line_itemsLine ItemList of line items contained in the expense
contactContactThe contact to which this expense belongs
accountAccountThe account to which this expense belongs
updated_atdateThe date at which the expense was updated on the accounting platform