General
Server Side SDKs
Core API
- Companies
- Invite Links
- Integrations
- Sync
- Jobs
- Passthrough
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
Retrieve journal entries
Retrieve journal entries from the database based on the ID
curl --request POST \
--url https://api.rootfi.dev/accounting/journal_entries/all \
--header 'Content-Type: application/json' \
--header 'api_key: <api-key>' \
--data '{
"take": 10,
"skip": 0,
"orderBy": {
"amount": "asc"
},
"filter": {
"account_id": {
"eq": "1234567890123456789"
}
}
}'
{
"data": {
"data": [
{
"rootfi_id": 4040342,
"rootfi_company_id": 1760,
"rootfi_organisation_id": 1,
"rootfi_integration_type": "ZOHO_BOOKS",
"rootfi_updated_at": "2023-10-26T16:15:02.517Z",
"rootfi_created_at": "2023-10-26T16:15:02.530Z",
"platform_id": "1234567890123456789",
"account_id": "1234567890123456789",
"currency_id": null,
"document_number": null,
"description": "Opening Balance",
"posted_date": "2023-01-03T00:00:00.000Z",
"amount": 13495,
"currency_rate": 1,
"journal_entry_type": "both",
"updated_at": "2023-01-15T00:00:00.000Z",
"currency": {
"data": {
"platform_id": null,
"name": null,
"code": null,
"symbol": null,
"is_base_currency": null,
"exchange_rate": null,
"updated_at": null
}
},
"journal_lines": {
"data": [
{
"platform_id": "3770712000001725038",
"journal_entry_id": "3770712000001725026",
"account_id": "3770712000000035001",
"contact_id": "3770712000000080780",
"tax_id": null,
"tracking_category_ids": [
"3770712000000000335_3770712000001122010"
],
"type": "DEBIT",
"description": "Test Description for Journal",
"net_amount": 5,
"tax_amount": null,
"updated_at": null
}
]
}
}
],
"total_count": 1
},
"request_timestamp": "2023-10-26T16:15:02.517Z",
"response_timestamp": "2023-10-26T16:15:02.517Z",
"request_id": "f5b0a0f0-5b1a-11ec-9c3a-0242ac130002"
}
The Journal Entries are basic records of a company’s financial transactions used to record the debits and credits of each transaction.
curl --request POST \
--url https://api.rootfi.dev/accounting/journal_entries/all \
--header 'Content-Type: application/json' \
--header 'api_key: <api-key>' \
--data '{
"take": 10,
"skip": 0,
"orderBy": {
"amount": "asc"
},
"filter": {
"account_id": {
"eq": "1234567890123456789"
}
}
}'
Authorizations
Body
asc
, desc
asc
, desc
asc
, desc
asc
, desc
asc
, desc
asc
, desc
asc
, desc
asc
, desc
asc
, desc
asc
, desc
Response
The ID that the accounting platform uses to identify this journal entry
The unique ID we assign for that data's information
The RootFi designated id for the company
The RootFi designated id for the organisation
The accounting platform from which the data is being retrieved
ZOHO_BOOKS
, QUICKBOOKS_SANDBOX
, QUICKBOOKS
, XERO
, TALLY
, SAGE_CLOUD_ACCOUNTING
, MS_DYNAMICS_365
, SAGE_ZA_CLOUD_ACCOUNTING
, MYOB_BUSINESS
, WAVE
, ODOO_ACCOUNTING
, NETSUITE
, WAFEQ
, MEKARI_JURNAL
, BUSY
, ROOTFI_SANDBOX
, QOYOD
The latest date at which RootFi updated this data
The date at which RootFi first synced this data
The accounting platform’s unique ID for the account associated with the journal entry
The ISO-4217 currency code
Reference number for the journal entry
Memo description of the journal entry
Date of creation of the journal entry
The total amount of the journal entry
Rate between the currency of the payment and the base currency
Type of the journal entry
The date at which the information was updated on the accounting platform
Currency details of the journal entry
Currency associated with the account.
The ID that the accounting platform uses to identify this currency
The name of the currency
The code of the currency
The symbol of the currency
Is this the base currency of the organisation?
The exchange rate of the currency
The last ISO 8601 timestamp that the data was updated at
Array of Journal Entry Line items associated with the journal entry
The accounting Platform’s ID for this journal line
The accounting Platform’s ID for this journal entry
The net amount of the journal line
The accounting platform’s unique ID for the account associated with the journal line
The accounting platform’s unique ID for the contact associated with the journal line
The accounting platform’s unique ID for the tax associated with the journal line
The accounting platform’s unique ID for the tracking category associated with the journal line
Type of the journal line. Values are credit
, debit
, unknown
.
DEBIT
, CREDIT
Description of the journal line
The tax amount of the journal line
The last ISO 8601 timestamp that the data was updated at
A JSON containing fields that you can directly pass to the accounting platform.
Total Count of response object
The time at which the request was received by the server
The time at which the response was sent by the server
The unique ID of the request
curl --request POST \
--url https://api.rootfi.dev/accounting/journal_entries/all \
--header 'Content-Type: application/json' \
--header 'api_key: <api-key>' \
--data '{
"take": 10,
"skip": 0,
"orderBy": {
"amount": "asc"
},
"filter": {
"account_id": {
"eq": "1234567890123456789"
}
}
}'
{
"data": {
"data": [
{
"rootfi_id": 4040342,
"rootfi_company_id": 1760,
"rootfi_organisation_id": 1,
"rootfi_integration_type": "ZOHO_BOOKS",
"rootfi_updated_at": "2023-10-26T16:15:02.517Z",
"rootfi_created_at": "2023-10-26T16:15:02.530Z",
"platform_id": "1234567890123456789",
"account_id": "1234567890123456789",
"currency_id": null,
"document_number": null,
"description": "Opening Balance",
"posted_date": "2023-01-03T00:00:00.000Z",
"amount": 13495,
"currency_rate": 1,
"journal_entry_type": "both",
"updated_at": "2023-01-15T00:00:00.000Z",
"currency": {
"data": {
"platform_id": null,
"name": null,
"code": null,
"symbol": null,
"is_base_currency": null,
"exchange_rate": null,
"updated_at": null
}
},
"journal_lines": {
"data": [
{
"platform_id": "3770712000001725038",
"journal_entry_id": "3770712000001725026",
"account_id": "3770712000000035001",
"contact_id": "3770712000000080780",
"tax_id": null,
"tracking_category_ids": [
"3770712000000000335_3770712000001122010"
],
"type": "DEBIT",
"description": "Test Description for Journal",
"net_amount": 5,
"tax_amount": null,
"updated_at": null
}
]
}
}
],
"total_count": 1
},
"request_timestamp": "2023-10-26T16:15:02.517Z",
"response_timestamp": "2023-10-26T16:15:02.517Z",
"request_id": "f5b0a0f0-5b1a-11ec-9c3a-0242ac130002"
}