---
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`

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' — 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' — 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' — 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' — 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' — 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' — Description of the row
      - `amount` number — Total amount for specific code

---

[API](https://skmtc.net/cloudbeds/apis/cloudbeds-api.md) · [All operations](https://skmtc.net/cloudbeds/apis/cloudbeds-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/cloudbeds/cloudbeds-api/revisions/2faa857793e8/schema)