Retrieve Journal Entries - Panora Documentation

GET

accounting

journalentries

{id}

import { Panora } from "@panora/sdk";

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

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

run();

{
  "transaction_date": "2024-06-15T12:00:00Z",
  "payments": [
    "payment1",
    "payment2"
  ],
  "applied_payments": [
    "appliedPayment1",
    "appliedPayment2"
  ],
  "memo": "Monthly expense journal entry",
  "currency": "USD",
  "exchange_rate": "1.2",
  "id_acc_company_info": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
  "journal_number": "JE-001",
  "tracking_categories": [
    "801f9ede-c698-4e66-a7fc-48d19eebaa4f"
  ],
  "id_acc_accounting_period": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
  "posting_status": "Posted",
  "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": "journal_entry_1234",
  "remote_created_at": "2024-06-15T12:00:00Z",
  "remote_modiified_at": "2024-06-15T12:00:00Z",
  "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

string

required

id of the journalentry you want to retrieve.

Query Parameters

remote_data

boolean

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

Response

200 - application/json

transaction_date

string | null

The date of the transaction

Example:

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

payments

string[] | null

The payments associated with the journal entry

Example:

["payment1", "payment2"]

applied_payments

string[] | null

The applied payments for the journal entry

Example:

["appliedPayment1", "appliedPayment2"]

memo

string | null

A memo or note for the journal entry

Example:

"Monthly expense journal entry"

currency

string | null

The currency of the journal entry

Example:

"USD"

exchange_rate

string | null

The exchange rate applied to the journal entry

Example:

"1.2"

id_acc_company_info

string

The UUID of the associated company info

Example:

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

journal_number

string | null

The journal number

Example:

"JE-001"

tracking_categories

string[] | null

The UUIDs of the tracking categories associated with the journal entry

Example:

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

id_acc_accounting_period

string | null

The UUID of the associated accounting period

Example:

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

posting_status

string | null

The posting status of the journal entry

Example:

"Posted"

line_items

object[]

The line items associated with this journal entry

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"
}

string | null

The UUID of the journal entry record

Example:

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

remote_id

string

The remote ID of the journal entry in the context of the 3rd Party

Example:

"journal_entry_1234"

remote_created_at

string | null

The date when the journal entry was created in the remote system

Example:

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

remote_modiified_at

string | null

The date when the journal entry was last modified in the remote system

Example:

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

remote_data

object | null

The remote data of the journal entry in the context of the 3rd Party

Example:

{
  "raw_data": { "additional_field": "some value" }
}

created_at

string | null

The created date of the journal entry record

Example:

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

modified_at

string | null

The last modified date of the journal entry record

Example:

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

Was this page helpful?

Suggest edits Raise issue

Create Journal Entries List JournalEntrys

import { Panora } from "@panora/sdk";

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

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

run();

{
  "transaction_date": "2024-06-15T12:00:00Z",
  "payments": [
    "payment1",
    "payment2"
  ],
  "applied_payments": [
    "appliedPayment1",
    "appliedPayment2"
  ],
  "memo": "Monthly expense journal entry",
  "currency": "USD",
  "exchange_rate": "1.2",
  "id_acc_company_info": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
  "journal_number": "JE-001",
  "tracking_categories": [
    "801f9ede-c698-4e66-a7fc-48d19eebaa4f"
  ],
  "id_acc_accounting_period": "801f9ede-c698-4e66-a7fc-48d19eebaa4f",
  "posting_status": "Posted",
  "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": "journal_entry_1234",
  "remote_created_at": "2024-06-15T12:00:00Z",
  "remote_modiified_at": "2024-06-15T12:00:00Z",
  "remote_data": {
    "raw_data": {
      "additional_field": "some value"
    }
  },
  "created_at": "2024-06-15T12:00:00Z",
  "modified_at": "2024-06-15T12:00:00Z"
}

Accounting Objects

Authorizations

Headers

Path Parameters

Query Parameters

Response