GET
/
api
/
reports
/
journal
{
  "query": {
    "from_date": "2025-06-01",
    "to_date": "2025-06-21",
    "from_range": null,
    "to_range": null,
    "accounts_ids": [],
    "number_format": {
      "no_cents": false,
      "divide_on1000": false
    }
  },
  "data": [
    {
      "date": "2025-05-24T22:00:00.000Z",
      "date_formatted": "2025 May 25",
      "transaction_type": "Expense",
      "reference_id": 1000,
      "reference_type_formatted": "Expense",
      "entries": [
        {
          "index": 1,
          "note": null,
          "account_name": "Prepaid Expenses",
          "account_code": "100010",
          "transaction_number": null,
          "formatted_credit": "123,123.00",
          "formatted_debit": "",
          "credit": 123123,
          "debit": 0
        },
        {
          "index": 2,
          "note": "",
          "account_name": "Exchange Gain or Loss",
          "account_code": "40005",
          "transaction_number": null,
          "formatted_credit": "",
          "formatted_debit": "123,123.00",
          "credit": 0,
          "debit": 123123
        }
      ],
      "credit": 123123,
      "debit": 123123,
      "formatted_credit": "$123,123.00",
      "formatted_debit": "$123,123.00"
    },
    {
      "date": "2025-06-09T22:00:00.000Z",
      "date_formatted": "2025 Jun 10",
      "transaction_type": "BillPayment",
      "reference_id": 3,
      "reference_type_formatted": "BillPayment",
      "entries": [
        {
          "index": 1,
          "note": null,
          "contact_name": "business",
          "contact_type": "customer",
          "account_name": "Accounts Payable (A/P)",
          "account_code": "20001",
          "transaction_number": "",
          "formatted_credit": "",
          "formatted_debit": "500.00",
          "credit": 0,
          "debit": 500
        },
        {
          "index": 2,
          "note": null,
          "account_name": "Bank Account",
          "account_code": "10001",
          "transaction_number": "",
          "formatted_credit": "500.00",
          "formatted_debit": "",
          "credit": 500,
          "debit": 0
        }
      ],
      "credit": 500,
      "debit": 500,
      "formatted_credit": "$500.00",
      "formatted_debit": "$500.00"
    },
    {
      "date": "2025-06-09T22:00:00.000Z",
      "date_formatted": "2025 Jun 10",
      "transaction_type": "VendorCredit",
      "reference_id": 3,
      "reference_type_formatted": "VendorCredit",
      "entries": [
        {
          "index": 1,
          "note": null,
          "contact_name": "business",
          "contact_type": "customer",
          "account_name": "Accounts Payable (A/P)",
          "account_code": "20001",
          "transaction_number": "VC-00001",
          "formatted_credit": "",
          "formatted_debit": "100.00",
          "credit": 0,
          "debit": 100
        },
        {
          "index": 2,
          "note": null,
          "account_name": "Cost of Goods Sold",
          "account_code": "40002",
          "transaction_number": "VC-00001",
          "formatted_credit": "100.00",
          "formatted_debit": "",
          "credit": 100,
          "debit": 0
        }
      ],
      "credit": 100,
      "debit": 100,
      "formatted_credit": "$100.00",
      "formatted_debit": "$100.00"
    },
    {
      "date": "2025-06-09T22:00:00.000Z",
      "date_formatted": "2025 Jun 10",
      "transaction_type": "VendorCredit",
      "reference_id": 4,
      "reference_type_formatted": "VendorCredit",
      "entries": [
        {
          "index": 1,
          "note": null,
          "contact_name": "business",
          "contact_type": "customer",
          "account_name": "Accounts Payable (A/P)",
          "account_code": "20001",
          "transaction_number": "VC-00001",
          "formatted_credit": "",
          "formatted_debit": "100.00",
          "credit": 0,
          "debit": 100
        },
        {
          "index": 2,
          "note": null,
          "account_name": "Cost of Goods Sold",
          "account_code": "40002",
          "transaction_number": "VC-00001",
          "formatted_credit": "100.00",
          "formatted_debit": "",
          "credit": 100,
          "debit": 0
        }
      ],
      "credit": 100,
      "debit": 100,
      "formatted_credit": "$100.00",
      "formatted_debit": "$100.00"
    },
    {
      "date": "2025-06-09T22:00:00.000Z",
      "date_formatted": "2025 Jun 10",
      "transaction_type": "Bill",
      "reference_id": 4,
      "reference_type_formatted": "Bill",
      "entries": [
        {
          "index": 1,
          "note": null,
          "contact_name": "business",
          "contact_type": "customer",
          "account_name": "Accounts Payable (A/P)",
          "account_code": "20001",
          "transaction_number": null,
          "formatted_credit": "1,000.00",
          "formatted_debit": "",
          "credit": 1000,
          "debit": 0
        },
        {
          "index": 1,
          "note": null,
          "account_name": "Cost of Goods Sold",
          "account_code": "40002",
          "transaction_number": null,
          "formatted_credit": "",
          "formatted_debit": "1,000.00",
          "credit": 0,
          "debit": 1000
        }
      ],
      "credit": 1000,
      "debit": 1000,
      "formatted_credit": "$1,000.00",
      "formatted_debit": "$1,000.00"
    },
    {
      "date": "2025-06-09T22:00:00.000Z",
      "date_formatted": "2025 Jun 10",
      "transaction_type": "Bill",
      "reference_id": 5,
      "reference_type_formatted": "Bill",
      "entries": [
        {
          "index": 1,
          "note": null,
          "contact_name": "business",
          "contact_type": "customer",
          "account_name": "Accounts Payable (A/P)",
          "account_code": "20001",
          "transaction_number": null,
          "formatted_credit": "1,000.00",
          "formatted_debit": "",
          "credit": 1000,
          "debit": 0
        },
        {
          "index": 1,
          "note": null,
          "account_name": "Inventory Asset",
          "account_code": "10008",
          "transaction_number": null,
          "formatted_credit": "",
          "formatted_debit": "1,000.00",
          "credit": 0,
          "debit": 1000
        }
      ],
      "credit": 1000,
      "debit": 1000,
      "formatted_credit": "$1,000.00",
      "formatted_debit": "$1,000.00"
    },
    {
      "date": "2025-06-15T22:00:00.000Z",
      "date_formatted": "2025 Jun 16",
      "transaction_type": "Journal",
      "reference_id": 1017,
      "reference_type_formatted": "Journal",
      "entries": [
        {
          "index": 1,
          "note": "",
          "account_name": "Loan",
          "account_code": "20003",
          "transaction_number": "REF",
          "formatted_credit": "",
          "formatted_debit": "10,000.00",
          "credit": 0,
          "debit": 10000
        },
        {
          "index": 2,
          "note": "",
          "account_name": "Depreciation Expense",
          "account_code": "40007",
          "transaction_number": "REF",
          "formatted_credit": "10,000.00",
          "formatted_debit": "",
          "credit": 10000,
          "debit": 0
        }
      ],
      "credit": 10000,
      "debit": 10000,
      "formatted_credit": "$10,000.00",
      "formatted_debit": "$10,000.00"
    }
  ],
  "meta": {
    "organization_name": "BIGCAPITAL, INC",
    "base_currency": "USD",
    "date_format": "DD MMM yyyy",
    "is_cost_compute_running": false,
    "sheet_name": "",
    "formatted_date_range": "From 2025/06/01 | To 2025/06/21",
    "formatted_from_date": "2025/06/01",
    "formatted_to_date": "2025/06/21"
  }
}

Headers

Authorization
string
required

Value must be 'Bearer <token>' where <token> is an API key prefixed with 'bc_' or a JWT token.

Example:

"Bearer bc_1234567890abcdef"

organization-id
string
required

Required if Authorization is a JWT token. The organization ID to operate within.

accept
string
required

Query Parameters

noCents
boolean

Whether to hide cents in the number format

Example:

false

divideOn1000
boolean

Whether to divide numbers by 1000

Example:

false

transactionType
string

Type of transaction to filter

Example:

"payment"

transactionId
string

ID of the transaction to filter

Example:

"TXN-12345"

fromRange
number

Start range for filtering

Example:

100

toRange
number

End range for filtering

Example:

200

Response

200
application/json

Journal report

The response is of type any.