General
Server Side SDKs
Core API
- Companies
- Invite Links
- Sync
- Passthrough
- Real Time
- Webhooks
Unified API
- Accounting
- Accounts
- Bank Accounts
- Bank Transactions
- Bills
- Bill Payments
- Bill Credit Notes
- Contacts
- Company Info
- Currencies
- Documents
- Expenses
- Invoice Credit Notes
- Invoices
- Invoice Payments
- Items
- Journal Entries
- Purchase Orders
- Sales Orders
- Goods Receipt Notes
- Projects
- Tax Rates
- Tracking Categories
- Balance Sheet
- Cash Flow Statements
- Income Statements
- Payments
- Ecommerce
- CRM
Get All Expenses
Retrieve all Expenses.
curl --request GET \
--url https://api.rootfi.dev/v3/accounting/expenses \
--header 'api_key: <api-key>'{
"data": [
{
"rootfi_id": 123,
"rootfi_deleted_at": null,
"rootfi_created_at": "2024-01-25T09:00:00Z",
"rootfi_updated_at": "2024-01-25T09:00:00Z",
"rootfi_company_id": 456,
"platform_id": "123456_1",
"platform_unique_id": "123456",
"currency_id": "AED",
"account_id": "acc_56S9s4tRcvkHJBCrgzj3YM",
"contact_id": "co_UVH2BXam9VXbtZzJXa4Ctr",
"sub_total": 400,
"tax_amount": 2.5,
"total_amount": 400,
"document_number": "testttt expense",
"memo": "Testttt",
"updated_at": "2023-06-03T00:00:00.000Z",
"payment_mode": "cash",
"currency_rate": 1.5,
"posted_date": "2023-06-03T00:00:00.000Z",
"line_items": [
{
"rootfi_id": 157,
"platform_id": "123456",
"line_item_type": "INVOICES",
"line_item_type_id": "123456",
"tracking_category_ids": [
"123456"
],
"project_id": "123456",
"item_id": "123456",
"tax_id": "123456",
"account_id": "123456",
"description": "This is a description",
"quantity": 1,
"unit_amount": 100,
"total_amount": 100,
"sub_total": 100,
"tax_amount": 100,
"total_discount": 100,
"updated_at": "2024-01-22T05:07:31.000Z"
}
]
}
],
"prev": "eyJyb290ZmlfaWQiOjQ0MDA2MX0=",
"next": "eyJyb291ZmlfaWQiOjQ0MDA2MX0=",
"total_count": 123
}Expenses are Payment made by a business at the time of purchase (ex. a credit card payment)
Authorizations
Query Parameters
The number of objects you want to retrieve
The next page of objects to retrieve
The previous page of objects to retrieve
Comma separated fields to expand. Supported values are account, line_items, contact, currency, documents
Comma separated fields to select. Supported values are raw_data, data_hash
Filter by rootfi_updated_at Greater than or Equal To.
Filter by rootfi_company_id. You can filter by any field using this syntax field_name[operator]
Include deleted records. By default, deleted records are not included. Supported values are true and false
Return the count of the objects. Supported values are true and false
Sort by rootfi_created_at
ASC, DESC Sort by rootfi_updated_at
ASC, DESC Response
The data of the Expenses endpoint
The unique ID we assign for that data's information
The date at which RootFi first synced this data
The latest date at which RootFi updated this data
The ID of the company in the accounting platform
An unique custom RootFi ID made from platform's unique_id.
The date at which the data was deleted in the accounting platform
The ID of the data in the accounting platform.
A JSON containing fields that you can directly get from the accounting platform.
The hash of the data
The contact ID of the Expense
The account ID of the Expense
The document number of the Expense
The posted date of the Expense
The payment mode of the Expense
The ISO-4217 currency code of the Expense
The currency rate of the Expense
The total amount of the Expense
The sub total of the Expense
The tax amount of the Expense
The total discount of the Expense
The memo of the Expense
The updated at of the Expense
The line items of the Expense
The unique ID we assign for that data's information
The platform id of the line item
The line item type of the line item
BILLS, INVOICES, BILL_CREDIT_NOTES, INVOICE_CREDIT_NOTES, EXPENSES, PURCHASE_ORDERS, SALES_ORDERS The line item type id of the line item
The tracking category ids of the line item
The project id of the line item
The item id of the line item
The item of the line item
The unique ID we assign for that data's information
The date at which RootFi first synced this data
The latest date at which RootFi updated this data
The ID of the company in the accounting platform
An unique custom RootFi ID made from platform's unique_id.
The date at which the data was deleted in the accounting platform
The ID of the data in the accounting platform.
A JSON containing fields that you can directly get from the accounting platform.
The hash of the data
Name of the item
Description of the item
Status of the item. Values are ACTIVE, ARCHIVED, UNKNOWN
ACTIVE, ARCHIVED, UNKNOWN Type of the item. Values are INVENTORY, NON_INVENTORY, SERVICE, UNKNOWN
INVENTORY, NON_INVENTORY, SERVICE, UNKNOWN Reference code of the item
Quantity on hand
Check if there are details (bill_item) of this item getting purchased
Item details of this item getting purchased
Check if there are details (invoice_item) of this item getting sold
Item details of this item getting sold
Tax id of the item
Unit price of the item
Description of the item
The date the item was last updated
The tax id of the line item
The tax of the line item
The unique ID we assign for that data's information
The date at which RootFi first synced this data
The latest date at which RootFi updated this data
The ID of the company in the accounting platform
An unique custom RootFi ID made from platform's unique_id.
The date at which the data was deleted in the accounting platform
The ID of the data in the accounting platform.
A JSON containing fields that you can directly get from the accounting platform.
The hash of the data
Display name
Simple ID for the tax rate
The type of tax as mentioned in the accounting platform
The total tax rate after accounting for the compounding effects of the all tax components
The sum of all the tax rate components
The list of tax rate components
Display name
The total tax rate after accounting for the compounding effects of the all tax components
The tax agency of the tax rate component
Whether the tax rate component is compound
The last time the tax rate was updated
The account id of the line item
The account of the line item
The unique ID we assign for that data's information
The date at which RootFi first synced this data
The latest date at which RootFi updated this data
The ID of the company in the accounting platform
An unique custom RootFi ID made from platform's unique_id.
The date at which the data was deleted in the accounting platform
The ID of the data in the accounting platform.
A JSON containing fields that you can directly get from the accounting platform.
The hash of the data
Name of the account
Description of the account
The nominal code of the account
The current balance of the account
The date the account was last updated
The status of the account
The category of the account
ASSET, EXPENSE, LIABILITY, EQUITY, INCOME, BANK, UNKNOWN The sub category of the account
The currency id of the account
The parent account id of the account
The parent account of the account.
The unique ID we assign for that data's information
The date at which RootFi first synced this data
The latest date at which RootFi updated this data
The ID of the company in the accounting platform
An unique custom RootFi ID made from platform's unique_id.
The date at which the data was deleted in the accounting platform
The ID of the data in the accounting platform.
A JSON containing fields that you can directly get from the accounting platform.
The hash of the data
Name of the account
Description of the account
The nominal code of the account
The current balance of the account
The date the account was last updated
The status of the account
The category of the account
ASSET, EXPENSE, LIABILITY, EQUITY, INCOME, BANK, UNKNOWN The sub category of the account
The currency id of the account
The parent account id of the account
The currency of the account.
The unique ID we assign for that data's information
The date at which RootFi first synced this data
The latest date at which RootFi updated this data
The ID of the company in the accounting platform
An unique custom RootFi ID made from platform's unique_id.
The date at which the data was deleted in the accounting platform
The ID of the data in the accounting platform.
A JSON containing fields that you can directly get from the accounting platform.
The hash of the data
The name of the currency
The currency code.
The symbol that represents the currency. Not applicable for many currencies.
Whether the currency is the base currency for the company.
The exchange rate for the currency.
The last ISO 8601 timestamp that the data was updated at.
The description of the line item
The quantity of the line item
The unit amount of the line item
The total amount of the line item
The sub total of the line item
The tax amount of the line item
The total discount of the line item
The last ISO 8601 timestamp that the data was updated at
The contact of the Expense
The unique ID we assign for that data's information
The date at which RootFi first synced this data
The latest date at which RootFi updated this data
The ID of the company in the accounting platform
An unique custom RootFi ID made from platform's unique_id.
The date at which the data was deleted in the accounting platform
The ID of the data in the accounting platform.
A JSON containing fields that you can directly get from the accounting platform.
The hash of the data
Name of the contact
Name of the contact person for the contact
The type of contact. Values are either CUSTOMER or VENDOR
CUSTOMER, VENDOR The ISO-4217 currency code
Contact’s tax number
Contact’s identifying number
The status of the contact. Values are ACTIVE, ARCHIVED, UNKNOWN
ACTIVE, ARCHIVED, UNKNOWN The date the contact was last updated
External links for the contact
The RootFi ID of the contact
The platform ID of the contact
The link to the contact
The type of the link.
EMAIL, WEBSITE Phone numbers for the contact
The RootFi ID of the contact
The platform ID of the contact
The number to the contact
The type of the link.
MOBILE, TELEPHONE, FAX Addresses for the contact
The RootFi ID of the contact
The platform ID of the contact
The street of the address
The locality of the address
The city of the address
The state of the address
The pincode of the address
The country of the address
The currency of the Expense
The unique ID we assign for that data's information
The date at which RootFi first synced this data
The latest date at which RootFi updated this data
The ID of the company in the accounting platform
An unique custom RootFi ID made from platform's unique_id.
The date at which the data was deleted in the accounting platform
The ID of the data in the accounting platform.
A JSON containing fields that you can directly get from the accounting platform.
The hash of the data
The name of the currency
The currency code.
The symbol that represents the currency. Not applicable for many currencies.
Whether the currency is the base currency for the company.
The exchange rate for the currency.
The last ISO 8601 timestamp that the data was updated at.
The account of the Expense
The unique ID we assign for that data's information
The date at which RootFi first synced this data
The latest date at which RootFi updated this data
The ID of the company in the accounting platform
An unique custom RootFi ID made from platform's unique_id.
The date at which the data was deleted in the accounting platform
The ID of the data in the accounting platform.
A JSON containing fields that you can directly get from the accounting platform.
The hash of the data
Name of the account
Description of the account
The nominal code of the account
The current balance of the account
The date the account was last updated
The status of the account
The category of the account
ASSET, EXPENSE, LIABILITY, EQUITY, INCOME, BANK, UNKNOWN The sub category of the account
The currency id of the account
The parent account id of the account
The parent account of the account.
The unique ID we assign for that data's information
The date at which RootFi first synced this data
The latest date at which RootFi updated this data
The ID of the company in the accounting platform
An unique custom RootFi ID made from platform's unique_id.
The date at which the data was deleted in the accounting platform
The ID of the data in the accounting platform.
A JSON containing fields that you can directly get from the accounting platform.
The hash of the data
Name of the account
Description of the account
The nominal code of the account
The current balance of the account
The date the account was last updated
The status of the account
The category of the account
ASSET, EXPENSE, LIABILITY, EQUITY, INCOME, BANK, UNKNOWN The sub category of the account
The currency id of the account
The parent account id of the account
The currency of the account.
The unique ID we assign for that data's information
The date at which RootFi first synced this data
The latest date at which RootFi updated this data
The ID of the company in the accounting platform
An unique custom RootFi ID made from platform's unique_id.
The date at which the data was deleted in the accounting platform
The ID of the data in the accounting platform.
A JSON containing fields that you can directly get from the accounting platform.
The hash of the data
The name of the currency
The currency code.
The symbol that represents the currency. Not applicable for many currencies.
Whether the currency is the base currency for the company.
The exchange rate for the currency.
The last ISO 8601 timestamp that the data was updated at.
The documents of the Expense
The unique ID we assign for that data's information
The date at which RootFi first synced this data
The latest date at which RootFi updated this data
The ID of the company in the accounting platform
An unique custom RootFi ID made from platform's unique_id.
The date at which the data was deleted in the accounting platform
The ID of the data in the accounting platform.
A JSON containing fields that you can directly get from the accounting platform.
The hash of the data
The file name of the document
The file type of the document
The file size of the document
The platform_id of the voucher to which the file will be linked to.
The document type of the document
The document uploaded of the document
The updated date of the document
The previous page of objects to retrieve
The next page of objects to retrieve
The total count of the objects
curl --request GET \
--url https://api.rootfi.dev/v3/accounting/expenses \
--header 'api_key: <api-key>'{
"data": [
{
"rootfi_id": 123,
"rootfi_deleted_at": null,
"rootfi_created_at": "2024-01-25T09:00:00Z",
"rootfi_updated_at": "2024-01-25T09:00:00Z",
"rootfi_company_id": 456,
"platform_id": "123456_1",
"platform_unique_id": "123456",
"currency_id": "AED",
"account_id": "acc_56S9s4tRcvkHJBCrgzj3YM",
"contact_id": "co_UVH2BXam9VXbtZzJXa4Ctr",
"sub_total": 400,
"tax_amount": 2.5,
"total_amount": 400,
"document_number": "testttt expense",
"memo": "Testttt",
"updated_at": "2023-06-03T00:00:00.000Z",
"payment_mode": "cash",
"currency_rate": 1.5,
"posted_date": "2023-06-03T00:00:00.000Z",
"line_items": [
{
"rootfi_id": 157,
"platform_id": "123456",
"line_item_type": "INVOICES",
"line_item_type_id": "123456",
"tracking_category_ids": [
"123456"
],
"project_id": "123456",
"item_id": "123456",
"tax_id": "123456",
"account_id": "123456",
"description": "This is a description",
"quantity": 1,
"unit_amount": 100,
"total_amount": 100,
"sub_total": 100,
"tax_amount": 100,
"total_discount": 100,
"updated_at": "2024-01-22T05:07:31.000Z"
}
]
}
],
"prev": "eyJyb290ZmlfaWQiOjQ0MDA2MX0=",
"next": "eyJyb291ZmlfaWQiOjQ0MDA2MX0=",
"total_count": 123
}