---
title: "List Balance Sheets report"
method: GET
path: "/v2/visualizations/balanceSheets"
tags: ["Visualizations"]
---

# List Balance Sheets report

`GET /v2/visualizations/balanceSheets`

## Request

- Base URL: `https://api.railz.ai`
- URL: `https://api.railz.ai/v2/visualizations/balanceSheets`
- Auth: HTTP bearer

**Supported for:**

`freshbooks` `quickbooks` `quickbooksDesktop` `xero` `dynamicsBusinessCentral` `zohoBooks` `byod`

## Query parameters

- `connectionUuid` string, required
- `startDate` string, required
- `endDate` string, required
- `reportFrequency` 'month' | 'quarter' | 'year', required
- `accountingMethod` 'cash' | 'accrual'

## Response `200`

Successfully returned balance sheets

- object
  - `meta` object, required
    - `reportId` string[], required
    - `serviceName` 'freshbooks' | 'quickbooks' | 'quickbooksDesktop' | 'xero' | 'oracleNetsuite' | 'sageBusinessCloud' | 'sageIntacct' | 'dynamicsBusinessCentral' | 'dynamics365Finance' | 'wave' | 'myob' | 'zohoBooks' | 'byod', required
    - `businessName` string, required
    - `endDate` string, required: if report frequency is monthly, end date is maximum of 12 months from start date, if quaterly, its a maximum of 3 years from start date, if yearly, its maximum of 12 years from start date
    - `startDate` string, required
    - `reportFrequency` 'month' | 'quarter' | 'year', required
    - `currency` string[], required
  - `data` object[], required
    - `period` object, required
      - `year` number, required
      - `month` number, required
      - `quarter` number, required
      - `day` number, required
      - `date` string, required
    - `currentAssets` number
    - `nonCurrentAssets` number
    - `currentLiabilities` number
    - `nonCurrentLiabilities` number
    - `equity` number, required

## Other responses

- `202`: Data in pending state
- `204`: No data available
- `400`: Bad Request Error - Thrown if fields sent via query does not follow specifications
- `401`: Unauthorized - Not logged in or log in expired
- `403`: Forbidden - Not enough permission
- `500`: Server Error

## Changes

- **2026-08-10** `5cdfae3fa1fa`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/railz/apis/fis-accounting-data-as-a-service-api/changes/v2/visualizations/balanceSheets/get.md)

---

[API](https://skmtc.dev/railz/apis/fis-accounting-data-as-a-service-api.md) - [All operations](https://skmtc.dev/railz/apis/fis-accounting-data-as-a-service-api/llms.txt) - [OpenAPI document](https://skmtc.dev/railz/apis/fis-accounting-data-as-a-service-api/revisions/1383b9a47ac9?raw)