---
title: "Get trial balance report"
method: GET
path: "/accounting/v1.0/trial-balance/report"
tags: ["Trial balance"]
---

# Get trial balance report

`GET /accounting/v1.0/trial-balance/report`

## Request

- Base URL: `https://api.cloudbeds.com`
- URL: `https://api.cloudbeds.com/accounting/v1.0/trial-balance/report`
- Auth: one of:
  - HTTP bearer
  - OAuth 2
    - Implicit: `https://hotels.cloudbeds.com/api/v1.2/oauth`
    - Scopes: `read:payment`

Retrieve the trial balance report for a specific date. The report provides a daily financial reconciliation showing opening and closing balances, ledger activity, deposit and AR transfers, and a detailed breakdown of guest ledger charges, taxes, and payments by transaction code. The property must have a configured trial balance before reports can be generated.

## Query parameters

- `date` string, date, required: Requested date

## Headers

- `X-Property-ID` integer, required

## Response `200`

OK

- TrialBalanceReportResponse
  - `trialBalanceId` string
  - `summary` TrialBalanceReportSummary
    - `hotelOpeningBalance` number
    - `depositActivity` number
    - `guestLedgerActivity` number: Net activity in the guest ledger for the day.
    - `arActivity` number
    - `totalActivity` number: Sum of all posted transactions of the day across the 3 ledgers.
    - `hotelClosingBalance` number
    - `guestLedgerOpeningBalance` number: Guest ledger opening balance for the day.
    - `guestLedgerTransactionsTotal` number: Total of guest ledger transactions posted on the day (excludes transfers).
    - `guestLedgerDepositTransfers` number: Deposit transfers posted into the guest ledger on the day.
    - `guestLedgerArTransfers` number: AR transfers posted out of the guest ledger on the day.
    - `guestLedgerClosingBalance` number: Guest ledger closing balance for the day.
    - `openingBalance` number: Deprecated — use `guestLedgerOpeningBalance` instead.
    - `transactionsTotalAmount` number: Deprecated — use `guestLedgerTransactionsTotal` instead.
    - `ledgerActivity` number: Deprecated — use `guestLedgerActivity` instead.
    - `arPayments` number
    - `depositTransfers` number: Deprecated — use `guestLedgerDepositTransfers` instead.
    - `closingBalance` number: Deprecated — use `guestLedgerClosingBalance` instead.
    - `arTransfers` number: Deprecated — use `guestLedgerArTransfers` instead.
  - `ledgerBalances` TrialBalanceReportLedgerBalances
    - `depositLedger` TrialBalanceReportCodeInfo[]
      - `code` string: Transaction code
      - `description` 'RATE' | 'RATE_A' | 'RATE_V' | 'ROOM_REVENUE' | 'ROOM_REVENUE_A' | 'ROOM_REVENUE_V' | 'CANCELLATION' | 'CANCELLATION_A' | 'CANCELLATION_V' | 'NO_SHOW' | 'NO_SHOW_A' | 'NO_SHOW_V' | 'ITEM_SERVICE' | 'ITEM_SERVICE_A' | 'ITEM_SERVICE_V' | 'ADDON' | 'ADDON_A' | 'ADDON_V' | 'CUSTOM_ITEM_POS' | 'CUSTOM_ITEM_POS_A' | 'CUSTOM_ITEM_POS_V' | 'FEE' | 'FEE_A' | 'FEE_V' | 'TAX' | 'TAX_A' | 'TAX_V' | 'PAYMENT' | 'PAYMENT_V' | 'PAYMENT_R' | 'PAYMENT_CASH' | 'PAYMENT_CASH_V' | 'PAYMENT_BANK' | 'PAYMENT_BANK_V' | 'PAYMENT_CARD' | 'PAYMENT_CARD_V' | 'REFUND' | 'REFUND_CASH' | 'REFUND_BANK' | 'REFUND_CARD' | 'DEPOSIT_LEDGER_BALANCE' | 'DEPOSIT_LEDGER_BALANCE_PREVIOUS_DAY' | 'DEPOSIT_PAYMENTS' | 'DEPOSIT_TRANSFER_OUT' | 'GUEST_LEDGER_BALANCE' | 'GUEST_LEDGER_BALANCE_PREVIOUS_DAY' | 'GUEST_LEDGER_CHARGES' | 'DEPOSIT_TRANSFER_IN' | 'GUEST_LEDGER_PAYMENTS' | 'AR_BALANCE' | 'AR_BALANCE_PREVIOUS_DAY' | 'AR_TRANSFER_IN' | 'AR_TRANSFER_OUT' | 'AR_PAYMENTS' | 'SPACE' | 'SPACE_A' | 'SPACE_V' | 'CHANNEL_COMMISSION' | 'CHANNEL_COMMISSION_A' | 'CHANNEL_COMMISSION_V' | 'GRATUITY' | 'GRATUITY_A' | 'GRATUITY_V' | 'SERVICE_CHARGE' | 'SERVICE_CHARGE_A' | 'SERVICE_CHARGE_V': Description of the row
      - `amount` number: Total amount for specific code
    - `guestLedger` TrialBalanceReportCodeInfo[]
      - `code` string: Transaction code
      - `description` 'RATE' | 'RATE_A' | 'RATE_V' | 'ROOM_REVENUE' | 'ROOM_REVENUE_A' | 'ROOM_REVENUE_V' | 'CANCELLATION' | 'CANCELLATION_A' | 'CANCELLATION_V' | 'NO_SHOW' | 'NO_SHOW_A' | 'NO_SHOW_V' | 'ITEM_SERVICE' | 'ITEM_SERVICE_A' | 'ITEM_SERVICE_V' | 'ADDON' | 'ADDON_A' | 'ADDON_V' | 'CUSTOM_ITEM_POS' | 'CUSTOM_ITEM_POS_A' | 'CUSTOM_ITEM_POS_V' | 'FEE' | 'FEE_A' | 'FEE_V' | 'TAX' | 'TAX_A' | 'TAX_V' | 'PAYMENT' | 'PAYMENT_V' | 'PAYMENT_R' | 'PAYMENT_CASH' | 'PAYMENT_CASH_V' | 'PAYMENT_BANK' | 'PAYMENT_BANK_V' | 'PAYMENT_CARD' | 'PAYMENT_CARD_V' | 'REFUND' | 'REFUND_CASH' | 'REFUND_BANK' | 'REFUND_CARD' | 'DEPOSIT_LEDGER_BALANCE' | 'DEPOSIT_LEDGER_BALANCE_PREVIOUS_DAY' | 'DEPOSIT_PAYMENTS' | 'DEPOSIT_TRANSFER_OUT' | 'GUEST_LEDGER_BALANCE' | 'GUEST_LEDGER_BALANCE_PREVIOUS_DAY' | 'GUEST_LEDGER_CHARGES' | 'DEPOSIT_TRANSFER_IN' | 'GUEST_LEDGER_PAYMENTS' | 'AR_BALANCE' | 'AR_BALANCE_PREVIOUS_DAY' | 'AR_TRANSFER_IN' | 'AR_TRANSFER_OUT' | 'AR_PAYMENTS' | 'SPACE' | 'SPACE_A' | 'SPACE_V' | 'CHANNEL_COMMISSION' | 'CHANNEL_COMMISSION_A' | 'CHANNEL_COMMISSION_V' | 'GRATUITY' | 'GRATUITY_A' | 'GRATUITY_V' | 'SERVICE_CHARGE' | 'SERVICE_CHARGE_A' | 'SERVICE_CHARGE_V': Description of the row
      - `amount` number: Total amount for specific code
    - `accountsReceivable` TrialBalanceReportCodeInfo[]
      - `code` string: Transaction code
      - `description` 'RATE' | 'RATE_A' | 'RATE_V' | 'ROOM_REVENUE' | 'ROOM_REVENUE_A' | 'ROOM_REVENUE_V' | 'CANCELLATION' | 'CANCELLATION_A' | 'CANCELLATION_V' | 'NO_SHOW' | 'NO_SHOW_A' | 'NO_SHOW_V' | 'ITEM_SERVICE' | 'ITEM_SERVICE_A' | 'ITEM_SERVICE_V' | 'ADDON' | 'ADDON_A' | 'ADDON_V' | 'CUSTOM_ITEM_POS' | 'CUSTOM_ITEM_POS_A' | 'CUSTOM_ITEM_POS_V' | 'FEE' | 'FEE_A' | 'FEE_V' | 'TAX' | 'TAX_A' | 'TAX_V' | 'PAYMENT' | 'PAYMENT_V' | 'PAYMENT_R' | 'PAYMENT_CASH' | 'PAYMENT_CASH_V' | 'PAYMENT_BANK' | 'PAYMENT_BANK_V' | 'PAYMENT_CARD' | 'PAYMENT_CARD_V' | 'REFUND' | 'REFUND_CASH' | 'REFUND_BANK' | 'REFUND_CARD' | 'DEPOSIT_LEDGER_BALANCE' | 'DEPOSIT_LEDGER_BALANCE_PREVIOUS_DAY' | 'DEPOSIT_PAYMENTS' | 'DEPOSIT_TRANSFER_OUT' | 'GUEST_LEDGER_BALANCE' | 'GUEST_LEDGER_BALANCE_PREVIOUS_DAY' | 'GUEST_LEDGER_CHARGES' | 'DEPOSIT_TRANSFER_IN' | 'GUEST_LEDGER_PAYMENTS' | 'AR_BALANCE' | 'AR_BALANCE_PREVIOUS_DAY' | 'AR_TRANSFER_IN' | 'AR_TRANSFER_OUT' | 'AR_PAYMENTS' | 'SPACE' | 'SPACE_A' | 'SPACE_V' | 'CHANNEL_COMMISSION' | 'CHANNEL_COMMISSION_A' | 'CHANNEL_COMMISSION_V' | 'GRATUITY' | 'GRATUITY_A' | 'GRATUITY_V' | 'SERVICE_CHARGE' | 'SERVICE_CHARGE_A' | 'SERVICE_CHARGE_V': Description of the row
      - `amount` number: Total amount for specific code
  - `guestLedger` TrialBalanceReportGuestLedger
    - `charges` TrialBalanceReportCodeInfo[]
      - `code` string: Transaction code
      - `description` 'RATE' | 'RATE_A' | 'RATE_V' | 'ROOM_REVENUE' | 'ROOM_REVENUE_A' | 'ROOM_REVENUE_V' | 'CANCELLATION' | 'CANCELLATION_A' | 'CANCELLATION_V' | 'NO_SHOW' | 'NO_SHOW_A' | 'NO_SHOW_V' | 'ITEM_SERVICE' | 'ITEM_SERVICE_A' | 'ITEM_SERVICE_V' | 'ADDON' | 'ADDON_A' | 'ADDON_V' | 'CUSTOM_ITEM_POS' | 'CUSTOM_ITEM_POS_A' | 'CUSTOM_ITEM_POS_V' | 'FEE' | 'FEE_A' | 'FEE_V' | 'TAX' | 'TAX_A' | 'TAX_V' | 'PAYMENT' | 'PAYMENT_V' | 'PAYMENT_R' | 'PAYMENT_CASH' | 'PAYMENT_CASH_V' | 'PAYMENT_BANK' | 'PAYMENT_BANK_V' | 'PAYMENT_CARD' | 'PAYMENT_CARD_V' | 'REFUND' | 'REFUND_CASH' | 'REFUND_BANK' | 'REFUND_CARD' | 'DEPOSIT_LEDGER_BALANCE' | 'DEPOSIT_LEDGER_BALANCE_PREVIOUS_DAY' | 'DEPOSIT_PAYMENTS' | 'DEPOSIT_TRANSFER_OUT' | 'GUEST_LEDGER_BALANCE' | 'GUEST_LEDGER_BALANCE_PREVIOUS_DAY' | 'GUEST_LEDGER_CHARGES' | 'DEPOSIT_TRANSFER_IN' | 'GUEST_LEDGER_PAYMENTS' | 'AR_BALANCE' | 'AR_BALANCE_PREVIOUS_DAY' | 'AR_TRANSFER_IN' | 'AR_TRANSFER_OUT' | 'AR_PAYMENTS' | 'SPACE' | 'SPACE_A' | 'SPACE_V' | 'CHANNEL_COMMISSION' | 'CHANNEL_COMMISSION_A' | 'CHANNEL_COMMISSION_V' | 'GRATUITY' | 'GRATUITY_A' | 'GRATUITY_V' | 'SERVICE_CHARGE' | 'SERVICE_CHARGE_A' | 'SERVICE_CHARGE_V': Description of the row
      - `amount` number: Total amount for specific code
    - `taxes` TrialBalanceReportCodeInfo[]
      - `code` string: Transaction code
      - `description` 'RATE' | 'RATE_A' | 'RATE_V' | 'ROOM_REVENUE' | 'ROOM_REVENUE_A' | 'ROOM_REVENUE_V' | 'CANCELLATION' | 'CANCELLATION_A' | 'CANCELLATION_V' | 'NO_SHOW' | 'NO_SHOW_A' | 'NO_SHOW_V' | 'ITEM_SERVICE' | 'ITEM_SERVICE_A' | 'ITEM_SERVICE_V' | 'ADDON' | 'ADDON_A' | 'ADDON_V' | 'CUSTOM_ITEM_POS' | 'CUSTOM_ITEM_POS_A' | 'CUSTOM_ITEM_POS_V' | 'FEE' | 'FEE_A' | 'FEE_V' | 'TAX' | 'TAX_A' | 'TAX_V' | 'PAYMENT' | 'PAYMENT_V' | 'PAYMENT_R' | 'PAYMENT_CASH' | 'PAYMENT_CASH_V' | 'PAYMENT_BANK' | 'PAYMENT_BANK_V' | 'PAYMENT_CARD' | 'PAYMENT_CARD_V' | 'REFUND' | 'REFUND_CASH' | 'REFUND_BANK' | 'REFUND_CARD' | 'DEPOSIT_LEDGER_BALANCE' | 'DEPOSIT_LEDGER_BALANCE_PREVIOUS_DAY' | 'DEPOSIT_PAYMENTS' | 'DEPOSIT_TRANSFER_OUT' | 'GUEST_LEDGER_BALANCE' | 'GUEST_LEDGER_BALANCE_PREVIOUS_DAY' | 'GUEST_LEDGER_CHARGES' | 'DEPOSIT_TRANSFER_IN' | 'GUEST_LEDGER_PAYMENTS' | 'AR_BALANCE' | 'AR_BALANCE_PREVIOUS_DAY' | 'AR_TRANSFER_IN' | 'AR_TRANSFER_OUT' | 'AR_PAYMENTS' | 'SPACE' | 'SPACE_A' | 'SPACE_V' | 'CHANNEL_COMMISSION' | 'CHANNEL_COMMISSION_A' | 'CHANNEL_COMMISSION_V' | 'GRATUITY' | 'GRATUITY_A' | 'GRATUITY_V' | 'SERVICE_CHARGE' | 'SERVICE_CHARGE_A' | 'SERVICE_CHARGE_V': Description of the row
      - `amount` number: Total amount for specific code
    - `payments` TrialBalanceReportCodeInfo[]
      - `code` string: Transaction code
      - `description` 'RATE' | 'RATE_A' | 'RATE_V' | 'ROOM_REVENUE' | 'ROOM_REVENUE_A' | 'ROOM_REVENUE_V' | 'CANCELLATION' | 'CANCELLATION_A' | 'CANCELLATION_V' | 'NO_SHOW' | 'NO_SHOW_A' | 'NO_SHOW_V' | 'ITEM_SERVICE' | 'ITEM_SERVICE_A' | 'ITEM_SERVICE_V' | 'ADDON' | 'ADDON_A' | 'ADDON_V' | 'CUSTOM_ITEM_POS' | 'CUSTOM_ITEM_POS_A' | 'CUSTOM_ITEM_POS_V' | 'FEE' | 'FEE_A' | 'FEE_V' | 'TAX' | 'TAX_A' | 'TAX_V' | 'PAYMENT' | 'PAYMENT_V' | 'PAYMENT_R' | 'PAYMENT_CASH' | 'PAYMENT_CASH_V' | 'PAYMENT_BANK' | 'PAYMENT_BANK_V' | 'PAYMENT_CARD' | 'PAYMENT_CARD_V' | 'REFUND' | 'REFUND_CASH' | 'REFUND_BANK' | 'REFUND_CARD' | 'DEPOSIT_LEDGER_BALANCE' | 'DEPOSIT_LEDGER_BALANCE_PREVIOUS_DAY' | 'DEPOSIT_PAYMENTS' | 'DEPOSIT_TRANSFER_OUT' | 'GUEST_LEDGER_BALANCE' | 'GUEST_LEDGER_BALANCE_PREVIOUS_DAY' | 'GUEST_LEDGER_CHARGES' | 'DEPOSIT_TRANSFER_IN' | 'GUEST_LEDGER_PAYMENTS' | 'AR_BALANCE' | 'AR_BALANCE_PREVIOUS_DAY' | 'AR_TRANSFER_IN' | 'AR_TRANSFER_OUT' | 'AR_PAYMENTS' | 'SPACE' | 'SPACE_A' | 'SPACE_V' | 'CHANNEL_COMMISSION' | 'CHANNEL_COMMISSION_A' | 'CHANNEL_COMMISSION_V' | 'GRATUITY' | 'GRATUITY_A' | 'GRATUITY_V' | 'SERVICE_CHARGE' | 'SERVICE_CHARGE_A' | 'SERVICE_CHARGE_V': Description of the row
      - `amount` number: Total amount for specific code

---

[API](https://skmtc.dev/cloudbeds/apis/accounting-api.md) - [All operations](https://skmtc.dev/cloudbeds/apis/accounting-api/llms.txt) - [OpenAPI document](https://skmtc.dev/cloudbeds/apis/accounting-api/revisions/0b58c698deef?raw)