GET
/
accounting
/
balancesheets
/
{id}
import { Panora } from "@panora/sdk";

const panora = new Panora({
  apiKey: "<YOUR_API_KEY_HERE>",
});

async function run() {
  const result = await panora.accounting.balancesheets.retrieve({
    xConnectionToken: "<value>",
    id: "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
    remoteData: false,
  });
  
  // Handle the result
  console.log(result)
}

run();
{
  "name": "Q2 2024 Balance Sheet",
  "currency": "USD",
  "company_info_id": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
  "date": "2024-06-30T23:59:59Z",
  "net_assets": 1000000,
  "assets": [
    "Cash",
    "Accounts Receivable",
    "Inventory"
  ],
  "liabilities": [
    "Accounts Payable",
    "Long-term Debt"
  ],
  "equity": [
    "Common Stock",
    "Retained Earnings"
  ],
  "remote_generated_at": "2024-07-01T12:00:00Z",
  "line_items": [
    {
      "name": "Net Income",
      "value": 100000,
      "type": "Operating Activities",
      "parent_item": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
      "remote_id": "report_item_1234",
      "remote_generated_at": "2024-07-01T12:00:00Z",
      "company_info_id": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
      "created_at": "2024-06-15T12:00:00Z",
      "modified_at": "2024-06-15T12:00:00Z"
    }
  ],
  "field_mappings": {
    "custom_field_1": "value1",
    "custom_field_2": "value2"
  },
  "id": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
  "remote_id": "balancesheet_1234",
  "remote_data": {
    "raw_data": {
      "additional_field": "some value"
    }
  },
  "created_at": "2024-06-15T12:00:00Z",
  "modified_at": "2024-06-15T12:00:00Z"
}

Authorizations

​
x-api-key
string
header
required

Headers

​
x-connection-token
string
required

The connection token

Path Parameters

​
id
string
required

id of the balancesheet you want to retrieve.

Query Parameters

​
remote_data
boolean

Set to true to include data from the original Accounting software.

Response

200 - application/json
​
name
string | null

The name of the balance sheet

Example:

"Q2 2024 Balance Sheet"

​
currency
string | null

The currency used in the balance sheet

Example:

"USD"

​
company_info_id
string | null

The UUID of the associated company info

Example:

"801f9ede-c698-4e66-a7fc-48d19eebaa4f"

​
date
string | null

The date of the balance sheet

Example:

"2024-06-30T23:59:59Z"

​
net_assets
number | null

The net assets value

Example:

1000000

​
assets
string[] | null

The list of assets

Example:
["Cash", "Accounts Receivable", "Inventory"]
​
liabilities
string[] | null

The list of liabilities

Example:
["Accounts Payable", "Long-term Debt"]
​
equity
string[] | null

The list of equity items

Example:
["Common Stock", "Retained Earnings"]
​
remote_generated_at
string | null

The date when the balance sheet was generated in the remote system

Example:

"2024-07-01T12:00:00Z"

​
line_items
object[]

The report items associated with this balance sheet

​
field_mappings
object | null

The custom field mappings of the object between the remote 3rd party & Panora

Example:
{
  "custom_field_1": "value1",
  "custom_field_2": "value2"
}
​
id
string | null

The UUID of the balance sheet record

Example:

"801f9ede-c698-4e66-a7fc-48d19eebaa4f"

​
remote_id
string | null

The remote ID of the balance sheet in the context of the 3rd Party

Example:

"balancesheet_1234"

​
remote_data
object | null

The remote data of the balance sheet in the context of the 3rd Party

Example:
{
  "raw_data": { "additional_field": "some value" }
}
​
created_at
string | null

The created date of the balance sheet record

Example:

"2024-06-15T12:00:00Z"

​
modified_at
string | null

The last modified date of the balance sheet record

Example:

"2024-06-15T12:00:00Z"