GET
/
api
/
reports
/
profit-loss-sheet
{
  "query": {
    "from_date": "2025-01-01",
    "to_date": "2025-06-22",
    "number_format": {
      "divide_on1000": false,
      "negative_format": "mines",
      "show_zero": false,
      "format_money": "total",
      "precision": 2
    },
    "basis": "accrual",
    "none_zero": false,
    "none_transactions": false,
    "display_columns_type": "total",
    "display_columns_by": "year",
    "accounts_ids": [],
    "percentage_column": false,
    "percentage_row": false,
    "percentage_income": false,
    "percentage_expense": false,
    "previous_period": false,
    "previous_period_amount_change": false,
    "previous_period_percentage_change": false,
    "previous_year": false,
    "previous_year_amount_change": false,
    "previous_year_percentage_change": false
  },
  "data": [
    {
      "id": "INCOME",
      "name": "Income",
      "node_type": "ACCOUNTS",
      "total": {
        "amount": 3931,
        "formatted_amount": "$3,931.00"
      },
      "children": [
        {
          "id": 1025,
          "name": "Sales of Product Income",
          "node_type": "ACCOUNT",
          "total": {
            "amount": 3931,
            "formatted_amount": "3,931.00"
          }
        },
        {
          "id": 1026,
          "name": "Sales of Service Income",
          "node_type": "ACCOUNT",
          "total": {
            "amount": 0,
            "formatted_amount": ""
          }
        },
        {
          "id": 1027,
          "name": "Uncategorized Income",
          "node_type": "ACCOUNT",
          "total": {
            "amount": 0,
            "formatted_amount": ""
          }
        }
      ]
    },
    {
      "id": "COST_OF_SALES",
      "name": "Cost of sales",
      "node_type": "ACCOUNTS",
      "total": {
        "amount": 800,
        "formatted_amount": "$800.00"
      },
      "children": [
        {
          "id": 1019,
          "name": "Cost of Goods Sold",
          "node_type": "ACCOUNT",
          "total": {
            "amount": 800,
            "formatted_amount": "800.00"
          }
        }
      ]
    },
    {
      "id": "GROSS_PROFIT",
      "name": "GROSS PROFIT",
      "node_type": "EQUATION",
      "total": {
        "amount": 3131,
        "formatted_amount": "$3,131.00"
      }
    },
    {
      "id": "EXPENSES",
      "name": "Expenses",
      "node_type": "ACCOUNTS",
      "total": {
        "amount": -111563,
        "formatted_amount": "-$111,563.00"
      },
      "children": [
        {
          "id": 1020,
          "name": "Office expenses",
          "node_type": "ACCOUNT",
          "total": {
            "amount": 0,
            "formatted_amount": ""
          }
        },
        {
          "id": 1021,
          "name": "Rent",
          "node_type": "ACCOUNT",
          "total": {
            "amount": -92831,
            "formatted_amount": "-92,831.00"
          }
        },
        {
          "id": 1023,
          "name": "Bank Fees and Charges",
          "node_type": "ACCOUNT",
          "total": {
            "amount": -8732,
            "formatted_amount": "-8,732.00"
          }
        },
        {
          "id": 1024,
          "name": "Depreciation Expense",
          "node_type": "ACCOUNT",
          "total": {
            "amount": -10000,
            "formatted_amount": "-10,000.00"
          }
        }
      ]
    },
    {
      "id": "NET_OPERATING_INCOME",
      "name": "NET OPERATING INCOME",
      "node_type": "EQUATION",
      "total": {
        "amount": 114694,
        "formatted_amount": "$114,694.00"
      }
    },
    {
      "id": "OTHER_INCOME",
      "name": "Other income",
      "node_type": "ACCOUNTS",
      "total": {
        "amount": 0,
        "formatted_amount": "$0.00"
      },
      "children": [
        {
          "id": 1031,
          "name": "Discount",
          "node_type": "ACCOUNT",
          "total": {
            "amount": 0,
            "formatted_amount": ""
          }
        },
        {
          "id": 1033,
          "name": "Other Charges",
          "node_type": "ACCOUNT",
          "total": {
            "amount": 0,
            "formatted_amount": ""
          }
        }
      ]
    },
    {
      "id": "OTHER_EXPENSES",
      "name": "Other expenses",
      "node_type": "ACCOUNTS",
      "total": {
        "amount": 119149,
        "formatted_amount": "$119,149.00"
      },
      "children": [
        {
          "id": 1018,
          "name": "Other Expenses",
          "node_type": "ACCOUNT",
          "total": {
            "amount": -1243,
            "formatted_amount": "-1,243.00"
          }
        },
        {
          "id": 1022,
          "name": "Exchange Gain or Loss",
          "node_type": "ACCOUNT",
          "total": {
            "amount": 123123,
            "formatted_amount": "123,123.00"
          }
        },
        {
          "id": 1032,
          "name": "Purchase Discount",
          "node_type": "ACCOUNT",
          "total": {
            "amount": -2731,
            "formatted_amount": "-2,731.00"
          }
        }
      ]
    },
    {
      "id": "NET_INCOME",
      "name": "NET INCOME",
      "node_type": "EQUATION",
      "total": {
        "amount": -4455,
        "formatted_amount": "-$4,455.00"
      }
    }
  ],
  "meta": {
    "organization_name": "BIGCAPITAL, INC",
    "base_currency": "USD",
    "date_format": "DD MMM yyyy",
    "is_cost_compute_running": false,
    "sheet_name": "Cashflow Statement",
    "formatted_from_date": "2025/01/01",
    "formatted_to_date": "2025/06/22",
    "formatted_date_range": "From 2025/01/01 | To 2025/06/22"
  }
}

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

basis
string
required

The basis for the profit and loss sheet

noneZero
boolean

Whether to exclude zero values

noneTransactions
boolean

Whether to exclude transactions

accountsIds
string[]

Array of account IDs to include

displayColumnsType
enum<string>
required

Type of columns to display

Available options:
total,
date_periods
displayColumnsBy
string
required

How to display columns

percentageColumn
boolean

Whether to show percentage column

percentageRow
boolean

Whether to show percentage row

percentageIncome
boolean

Whether to show income percentage

percentageExpense
boolean

Whether to show expense percentage

previousPeriod
boolean

Whether to include previous period

previousPeriodAmountChange
boolean

Whether to show previous period amount change

previousPeriodPercentageChange
boolean

Whether to show previous period percentage change

previousYear
boolean

Whether to include previous year

previousYearAmountChange
boolean

Whether to show previous year amount change

previousYearPercentageChange
boolean

Whether to show previous year percentage change

Response

200
application/json

Profit & loss statement

The response is of type any.