APapaleo
SubLedger

Returns gross transactions filtered by date (business day) for a property for a given period.

Returns the raw transaction data for a given property and time period. Stores an entry in the export audit log.<br>You must have at least one of these scopes: 'transactions.export, accounting.read'.<br>For fine-grained clients, you must have this permission: 'core.subledger_export.create'.

post/finance/v1/accounts/export-gross-daily

Request

  • Base URL
    https://api.apaleo.com (the document declares no server; this is the origin it was published from)
  • URL
    https://api.apaleo.com/finance/v1/accounts/export-gross-daily
  • Auth
    OAuth 2
    Implicit: https://identity.apaleo.com/connect/authorize
    Scopes: transactions.export, accounting.read, admin

Query parameters

propertyIdstring required

Specifies the property transactions will be aggregated for.

fromstring date required

The inclusive start date of the interval

tostring date required

The exclusive end date of the interval

referencestring

Filter transactions by reference (reservation id/external folio id/property id for house folio).

accountingSchema'Simple' | 'Extended'

Allows to override the default accounting schema. Only specify this, when you know what you are doing.

Headers

Idempotency-Keystring

Unique key for safely retrying requests without accidentally performing the same operation twice. We'll always send back the same response for requests made with the same key, and keys can't be reused with different request parameters. Keys expire after 24 hours.

Response

Success.

Example response

{
  "transactions": [
    {
      "timestamp": "2026-10-25T17:03:19.2997911Z",
      "date": "2026-10-23",
      "debitedAccount": {
        "name": "Cash Payment",
        "number": "1600",
        "type": "Payments"
      },
      "creditedAccount": {
        "name": "Receivables for Reservation QPMZZTUK-1",
        "number": "QPMZZTUK-1_Receivables",
        "type": "Receivables"
      },
      "command": "PostCharge",
      "currency": "EUR",
      "grossAmount": 100,
      "netAmount": 100,
      "taxes": [],
      "receipt": {
        "type": "Reservation",
        "number": "QPMZZTUK-1-V3"
      },
      "sourceEntryNumber": "IHQNWLZL",
      "reference": "SRC-123",
      "referenceType": "Guest"
    },
    {
      "timestamp": "2026-10-25T17:03:19.2997961Z",
      "date": "2026-10-23",
      "debitedAccount": {
        "name": "Revenues Accommodation",
        "number": "5001",
        "type": "Payments"
      },
      "creditedAccount": {
        "name": "House Account",
        "number": "HOUSE_HCF",
        "type": "Receivables"
      },
      "command": "PostCharge",
      "currency": "EUR",
      "grossAmount": 214,
      "netAmount": 200,
      "taxes": [
        {
          "type": "Reduced",
          "percent": 7,
          "amount": 14
        }
      ],
      "receipt": {
        "type": "Reservation",
        "number": "QPMZZTUK-1-V3"
      },
      "sourceEntryNumber": "IHQNWLZL",
      "reference": "SRC-123",
      "referenceType": "Guest"
    }
  ]
}

Changes

No recorded changes to this operation across all 3 revisions of this API.