A new endpoint is available to retrieve revenue posted for a specific past date, grouped by charge code and filtered by ledger type. The current business date is not supported.

Required query parameters: hotel_id, date, ledger (one of guest, deposit, ar)

Each result in the response includes:

• charge_code – charge code
• account – ledger account
• cost_center – cost centre
• vat_code – VAT code
• charge_code_description – charge code description
• gross_amount – total gross amount for the charge code, excluding excluded taxes
• net_amount – net revenue excluding inclusive taxes; equal to gross amount if no taxes are inclusive
• taxes – array of taxes posted with the charge code, each containing tax_inclusive, charge_code, charge_code_description, and amount

Debit amounts are returned as positive values and credit amounts as negative values.

Example response:

{
  "results": [
    {
      "charge_code": "1000",
      "account": "Guest Ledger",
      "cost_center": "Rooms",
      "vat_code": "VAT20",
      "charge_code_description": "Room Revenue",
      "gross_amount": 250.00,
      "net_amount": 208.33,
      "taxes": [
        {
          "tax_inclusive": true,
          "charge_code": "TAX20",
          "charge_code_description": "VAT 20%",
          "amount": 41.67
        }
      ]
    }
  ]
}