Reports

Crane Ledger provides comprehensive financial reporting capabilities to analyze your organization's financial position and performance. All reports are generated in real-time from your transaction data and support multi-currency display.

Trial Balance

GET/organizations/:organization_id/reports/trial-balance

Auth required

5 credits

A trial balance is a report that lists all general ledger account balances at a specific point in time. It ensures that total debits equal total credits, providing a check on the accuracy of accounting records.

Path Parameters

Parameter	Type	Required	Description
`organization_id`	string	Yes	The ID of the organization

Query Parameters

Parameter	Type	Description
`as_of`	date	Report date (default: today). Format: YYYY-MM-DD
`currency`	string	Convert all amounts to this currency (optional)

Response

{
  "organization_id": "org_xxxxxxxxxxxxxxxx",
  "as_of": "2024-01-31",
  "accounts": [
    {
      "id": "act_xxxxxxxxxxxxxxxx",
      "code": "1000",
      "name": "Cash",
      "account_type": "asset",
      "debit_balance": "15000.00",
      "credit_balance": "0.00",
      "balance": "15000.00"
    },
    {
      "id": "act_yyyyyyyyyyyyyyyy",
      "code": "1100",
      "name": "Accounts Receivable",
      "account_type": "asset",
      "debit_balance": "5000.00",
      "credit_balance": "0.00",
      "balance": "5000.00"
    },
    {
      "id": "act_zzzzzzzzzzzzzzzz",
      "code": "2000",
      "name": "Accounts Payable",
      "account_type": "liability",
      "debit_balance": "0.00",
      "credit_balance": "3000.00",
      "balance": "-3000.00"
    },
    {
      "id": "act_wwwwwwwwwwwwwwww",
      "code": "4000",
      "name": "Revenue",
      "account_type": "revenue",
      "debit_balance": "0.00",
      "credit_balance": "20000.00",
      "balance": "-20000.00"
    }
  ],
  "totals": {
    "assets": "20000.00",
    "liabilities": "3000.00",
    "equity": "0.00",
    "revenue": "20000.00",
    "expenses": "0.00",
    "total_debits": "20000.00",
    "total_credits": "23000.00"
  }
}

Trial Balance Accuracy

A properly balanced trial balance should show total_debits equal to total_credits with is_balanced: true. If is_balanced is false, there may be accounting errors that need investigation.

Balance Sheet

GET/organizations/:organization_id/reports/balance-sheet

Auth required

5 credits

A balance sheet provides a snapshot of your organization's financial position at a specific point in time, showing assets, liabilities, and equity.

Path Parameters

Parameter	Type	Required	Description
`organization_id`	string	Yes	The ID of the organization

Query Parameters

Parameter	Type	Description
`as_of`	date	Report date (default: today). Format: YYYY-MM-DD
`currency`	string	Convert all amounts to this currency (optional)

Response

{
  "organization_id": "org_xxxxxxxxxxxxxxxx",
  "as_of": "2024-03-31",
  "assets": [
    {
      "id": "act_xxxxxxxxxxxxxxxx",
      "code": "1000",
      "name": "Cash",
      "balance": "15000.00"
    },
    {
      "id": "act_yyyyyyyyyyyyyyyy",
      "code": "1100",
      "name": "Accounts Receivable",
      "balance": "5000.00"
    },
    {
      "id": "act_zzzzzzzzzzzzzzzz",
      "code": "1500",
      "name": "Equipment",
      "balance": "25000.00"
    }
  ],
  "liabilities": [
    {
      "id": "act_wwwwwwwwwwwwwwww",
      "code": "2000",
      "name": "Accounts Payable",
      "balance": "8000.00"
    }
  ],
  "equity": [
    {
      "id": "act_vvvvvvvvvvvvvvvv",
      "code": "3000",
      "name": "Common Stock",
      "balance": "25000.00"
    },
    {
      "id": "act_uuuuuuuuuuuuuuuu",
      "code": "3100",
      "name": "Retained Earnings",
      "balance": "12000.00"
    }
  ],
  "total_assets": "45000.00",
  "total_liabilities": "8000.00",
  "total_equity": "37000.00",
  "total_liabilities_equity": "45000.00"
}

Balance Sheet Equation

The balance sheet follows the fundamental accounting equation: Assets = Liabilities + Equity. The report automatically calculates totals and verifies this relationship.

Income Statement (P&L)

GET/organizations/:organization_id/reports/income-statement

Auth required

5 credits

An income statement (also called profit & loss statement) shows your organization's financial performance over a period of time, detailing revenue, expenses, and net income.

Path Parameters

Parameter	Type	Required	Description
`organization_id`	string	Yes	The ID of the organization

Query Parameters

Parameter	Type	Description
`from_date`	date	Start date for the period. Format: YYYY-MM-DD
`to_date`	date	End date for the period. Format: YYYY-MM-DD
`currency`	string	Convert all amounts to this currency (optional)

Date Range Requirements

Both from_date and to_date are required for income statements to define the reporting period clearly.

Response

{
  "organization_id": "org_xxxxxxxxxxxxxxxx",
  "period": "2024-01-01 to 2024-03-31",
  "revenue": [
    {
      "id": "act_xxxxxxxxxxxxxxxx",
      "code": "4000",
      "name": "Product Sales",
      "balance": "50000.00"
    },
    {
      "id": "act_yyyyyyyyyyyyyyyy",
      "code": "4100",
      "name": "Service Revenue",
      "balance": "25000.00"
    }
  ],
  "expenses": [
    {
      "id": "act_zzzzzzzzzzzzzzzz",
      "code": "5000",
      "name": "Cost of Goods Sold",
      "balance": "20000.00"
    },
    {
      "id": "act_wwwwwwwwwwwwwwww",
      "code": "6000",
      "name": "Salaries",
      "balance": "15000.00"
    },
    {
      "id": "act_vvvvvvvvvvvvvvvv",
      "code": "6100",
      "name": "Rent",
      "balance": "3000.00"
    },
    {
      "id": "act_uuuuuuuuuuuuuuuu",
      "code": "6200",
      "name": "Utilities",
      "balance": "1000.00"
    }
  ],
  "total_revenue": "75000.00",
  "total_expenses": "39000.00",
  "net_income": "36000.00"
}

Income Statement Formula

Net Income = Total Revenue - Total Expenses

The income statement shows how profitable your organization was during the specified period by comparing revenue against all expenses incurred.

Report Generation Rules

Currency Handling

Reports use the organization's base currency by default
Optional currency parameter converts all amounts using current exchange rates
All currency conversions are clearly marked in the response

Date Handling

Trial Balance & Balance Sheet: as_of parameter specifies the point-in-time (default: today)
Income Statement: Requires both from_date and to_date for the period
All dates are in YYYY-MM-DD format
Reports include the exact generation timestamp

Account Classification

Reports automatically classify accounts based on their type:

Assets: Current (cash, receivables) vs Fixed (equipment, buildings)
Liabilities: Current (payables) vs Long-term (loans)
Equity: Stock, retained earnings, etc.
Revenue: Sales, services, other income
Expenses: COGS, operating expenses, etc.

Performance Considerations

Reports with many accounts may take longer to generate
Consider date ranges that limit the data volume
Large organizations may want to schedule report generation during off-peak hours

Data Freshness

All reports are generated in real-time from current transaction data
Reports include a generated_at timestamp for audit purposes
Historical reports reflect the state of accounts at the specified as_of date

Need help?

Create a free account to access our support portal. Once signed in, use the Support tab in your dashboard to submit a support ticket — our team typically responds within 24 hours.

✨ For LLMs/AI assistants: Read our structured API reference