Get All Balance Sheets

curl --request POST \
  --url https://api.rootfi.dev/accounting/balance_sheet/all \
  --header 'Content-Type: application/json' \
  --header 'api_key: <api-key>' \
  --data '{
  "take": 10,
  "skip": 0,
  "orderBy": {
    "period_end": "asc"
  },
  "filter": {
    "currency_id": {
      "eq": "5000000000000279512"
    }
  }
}'

{
  "data": {
    "data": [
      {
        "platform_id": "2023-08-01_2023-08-31",
        "assets": [
          {
            "name": "Assets",
            "value": 2078850834.58,
            "line_items": [
              {
                "name": "Other Assets",
                "value": 1,
                "line_items": [
                  {
                    "name": "01 OAsset Account",
                    "value": 1,
                    "account_id": "3770712000001313001"
                  }
                ]
              },
              {
                "name": "Fixed Assets",
                "value": -64,
                "line_items": [
                  {
                    "name": "05 Fixed Asset ACC",
                    "value": -64,
                    "account_id": "3770712000001313021"
                  }
                ]
              }
            ]
          }
        ],
        "liabilities": [
          {
            "name": "Liabilities",
            "value": 2077823414.08,
            "line_items": [
              {
                "name": "Long Term Liabilities",
                "value": 44.15,
                "line_items": [
                  {
                    "name": "Long Term Liability Acc",
                    "value": -1,
                    "account_id": "3770712000001313045"
                  },
                  {
                    "name": "Rootfi Test 5",
                    "value": 45.15,
                    "account_id": "3770712000000238001"
                  }
                ]
              },
              {
                "name": "Other Liabilities",
                "value": 124,
                "line_items": [
                  {
                    "name": "OTHERLIABILITY Acc",
                    "value": 124,
                    "account_id": "3770712000001313051"
                  }
                ]
              }
            ]
          }
        ],
        "equity": [
          {
            "name": "Equities",
            "value": 1027420.5,
            "line_items": [
              {
                "name": "13 EquityACC",
                "value": 1,
                "account_id": "3770712000001313061"
              },
              {
                "name": "Capital Stock",
                "value": 88,
                "account_id": "3770712000000076068"
              },
              {
                "name": "Retained Earnings",
                "value": 33072,
                "account_id": "3770712000000000379"
              }
            ]
          }
        ],
        "period_start": "2023-10-01T00:00:00.000Z",
        "period_end": "2023-10-31T00:00:00.000Z",
        "net_assets": 0,
        "currency_id": "5000000000000279512",
        "updated_at": "2000-12-31T18:30:00.000Z"
      }
    ],
    "total_count": 123
  },
  "request_timestamp": "2000-12-31T18:30:00.000Z",
  "response_timestamp": "2021-06-01T00:00:00.000Z",
  "request_id": "7a1c0e42-9f85-4d6e-bb5d-358a72913c0b"
}

POST

accounting

balance_sheet

all

curl --request POST \
  --url https://api.rootfi.dev/accounting/balance_sheet/all \
  --header 'Content-Type: application/json' \
  --header 'api_key: <api-key>' \
  --data '{
  "take": 10,
  "skip": 0,
  "orderBy": {
    "period_end": "asc"
  },
  "filter": {
    "currency_id": {
      "eq": "5000000000000279512"
    }
  }
}'

{
  "data": {
    "data": [
      {
        "platform_id": "2023-08-01_2023-08-31",
        "assets": [
          {
            "name": "Assets",
            "value": 2078850834.58,
            "line_items": [
              {
                "name": "Other Assets",
                "value": 1,
                "line_items": [
                  {
                    "name": "01 OAsset Account",
                    "value": 1,
                    "account_id": "3770712000001313001"
                  }
                ]
              },
              {
                "name": "Fixed Assets",
                "value": -64,
                "line_items": [
                  {
                    "name": "05 Fixed Asset ACC",
                    "value": -64,
                    "account_id": "3770712000001313021"
                  }
                ]
              }
            ]
          }
        ],
        "liabilities": [
          {
            "name": "Liabilities",
            "value": 2077823414.08,
            "line_items": [
              {
                "name": "Long Term Liabilities",
                "value": 44.15,
                "line_items": [
                  {
                    "name": "Long Term Liability Acc",
                    "value": -1,
                    "account_id": "3770712000001313045"
                  },
                  {
                    "name": "Rootfi Test 5",
                    "value": 45.15,
                    "account_id": "3770712000000238001"
                  }
                ]
              },
              {
                "name": "Other Liabilities",
                "value": 124,
                "line_items": [
                  {
                    "name": "OTHERLIABILITY Acc",
                    "value": 124,
                    "account_id": "3770712000001313051"
                  }
                ]
              }
            ]
          }
        ],
        "equity": [
          {
            "name": "Equities",
            "value": 1027420.5,
            "line_items": [
              {
                "name": "13 EquityACC",
                "value": 1,
                "account_id": "3770712000001313061"
              },
              {
                "name": "Capital Stock",
                "value": 88,
                "account_id": "3770712000000076068"
              },
              {
                "name": "Retained Earnings",
                "value": 33072,
                "account_id": "3770712000000000379"
              }
            ]
          }
        ],
        "period_start": "2023-10-01T00:00:00.000Z",
        "period_end": "2023-10-31T00:00:00.000Z",
        "net_assets": 0,
        "currency_id": "5000000000000279512",
        "updated_at": "2000-12-31T18:30:00.000Z"
      }
    ],
    "total_count": 123
  },
  "request_timestamp": "2000-12-31T18:30:00.000Z",
  "response_timestamp": "2021-06-01T00:00:00.000Z",
  "request_id": "7a1c0e42-9f85-4d6e-bb5d-358a72913c0b"
}

A balance sheet is a financial report that shows a business’s assets, liabilities, and equity at a specific point in time. In an accounting platform, a balance sheet is typically generated automatically based on the financial transactions that have been recorded in the system.

curl --request POST \
  --url https://api.rootfi.dev/accounting/balance_sheet/all \
  --header 'Content-Type: application/json' \
  --header 'api_key: <api-key>' \
  --data '{
  "take": 10,
  "skip": 0,
  "orderBy": {
    "period_end": "asc"
  },
  "filter": {
    "currency_id": {
      "eq": "5000000000000279512"
    }
  }
}'

Authorizations

api_key

string

header

required

Body

application/json

take

integer | null

skip

integer | null

orderBy

accountingOrderByFields · object

Show child attributes

orderBy.rootfi_updated_at

enum<string> | null

Available options:

asc,

desc

orderBy.rootfi_created_at

enum<string> | null

Available options:

asc,

desc

orderBy.period_start

enum<string> | null

Available options:

asc,

desc

orderBy.period_end

enum<string> | null

Available options:

asc,

desc

orderBy.net_assets

enum<string> | null

Available options:

asc,

desc

orderBy.currency_id

enum<string> | null

Available options:

asc,

desc

orderBy.updated_at

enum<string> | null

Available options:

asc,

desc

filter

accountingFilterFields · object

Show child attributes

filter.rootfi_id

numberOperator · object

Show child attributes

filter.rootfi_id.gt

number<double> | null

filter.rootfi_id.lt

number<double> | null

filter.rootfi_id.eq

number<double> | null

filter.rootfi_id.in

number<double> | null

filter.rootfi_company_id

numberOperator · object

Show child attributes

filter.rootfi_company_id.gt

number<double> | null

filter.rootfi_company_id.lt

number<double> | null

filter.rootfi_company_id.eq

number<double> | null

filter.rootfi_company_id.in

number<double> | null

filter.rootfi_updated_at

dateOperator · object

Show child attributes

filter.rootfi_updated_at.eq

string<date-time> | null

filter.rootfi_updated_at.gt

string<date-time> | null

filter.rootfi_updated_at.lt

string<date-time> | null

filter.rootfi_created_at

dateOperator · object

Show child attributes

filter.rootfi_created_at.eq

string<date-time> | null

filter.rootfi_created_at.gt

string<date-time> | null

filter.rootfi_created_at.lt

string<date-time> | null

filter.platform_id

stringOperator · object

Show child attributes

filter.platform_id.eq

string | null

filter.platform_id.ne

string | null

filter.rootfi_integration_type

stringOperator · object

Show child attributes

filter.rootfi_integration_type.eq

string | null

filter.rootfi_integration_type.ne

string | null

filter.period_start

dateOperator · object

Show child attributes

filter.period_start.eq

string<date-time> | null

filter.period_start.gt

string<date-time> | null

filter.period_start.lt

string<date-time> | null

filter.period_end

dateOperator · object

Show child attributes

filter.period_end.eq

string<date-time> | null

filter.period_end.gt

string<date-time> | null

filter.period_end.lt

string<date-time> | null

filter.net_assets

numberOperator · object

Show child attributes

filter.net_assets.gt

number<double> | null

filter.net_assets.lt

number<double> | null

filter.net_assets.eq

number<double> | null

filter.net_assets.in

number<double> | null

filter.currency_id

stringOperator · object

Show child attributes

filter.currency_id.eq

string | null

filter.currency_id.ne

string | null

filter.updated_at

dateOperator · object

Show child attributes

filter.updated_at.eq

string<date-time> | null

filter.updated_at.gt

string<date-time> | null

filter.updated_at.lt

string<date-time> | null

Response

200 - application/json

data

accountingtypesgetBalanceSheetResponseData · object

required

Show child attributes

data.data

accountingtypesBalanceSheetCommonFields · object[]

required

Show child attributes

data.data.platform_id

string

required

The accounting platforms ID for this item

data.data.currency_id

string | null

The Accounting Platform’s unique ID for the currency

data.data.assets

accountingtypesFinancialStetementObjectType · object[] | null

line_items for assets of balance sheet report

Show child attributes

data.data.assets.name

string | null

Name of the line item

data.data.assets.value

number<double> | null

Total value of the statement.

data.data.assets.line_items

object[] | null

List of line items for the statement.

data.data.liabilities

accountingtypesFinancialStetementObjectType · object[] | null

line_items for liabilities of balance sheet report

Show child attributes

data.data.liabilities.name

string | null

Name of the line item

data.data.liabilities.value

number<double> | null

Total value of the statement.

data.data.liabilities.line_items

object[] | null

List of line items for the statement.

data.data.equity

accountingtypesFinancialStetementObjectType · object[] | null

line_items for equity of balance sheet report

Show child attributes

data.data.equity.name

string | null

Name of the line item

data.data.equity.value

number<double> | null

Total value of the statement.

data.data.equity.line_items

object[] | null

List of line items for the statement.

data.data.period_start

string | null

start date of the balance sheet report

data.data.period_end

string | null

end date of the balance sheet report

data.data.net_assets

number<double> | null

total value of net assets

data.data.updated_at

string<date-time> | null

The last ISO 8601 timestamp that the data was updated at

data.total_count

integer

required

Total Count of response object

request_timestamp

string<date-time>

required

The time at which the request was received by the server

response_timestamp

string<date-time>

required

The time at which the response was sent by the server

request_id

string

required

The unique ID of the request

Get Balance Sheet Overview

⌘I

General

Server Side SDKs

Core API

Unified API

Get All Balance Sheets

Authorizations

Body

Response