Example 4: Update Accommodation Type

Steps to recreate

  • Generate initial transactions on Cloudbeds
    • Create origin accommodation and room rate
    • Create new accommodation and room rate
  • Create a reservation for past 1 night and next day in origin accomodation
  • Change room type for second accommodation

What Changes

Before: getTransactions would return 4 transactions. 2 for room rates and 2 for fees.

After: getTransactions would return 8 transactions, the original 4, plus 2 for the new accommodation night and 2 for the fees.

Request and Response Examples


Transactions from Accounting Service


Curl Request

curl --location 'https://api.cloudbeds-stage.com/accounting/v1.0/transactions' \
--header 'content-type: application/json' \
--header 'Authorization: Bearer INSERT_TOKEN' \
--header 'X-Property-Id: 1137897' \
--data '{
  "filters": {
    "and": [
          {
            "operator": "equals",
            "value": "27974559",
            "field": "SOURCE_ID"
          },
        {
            "operator": "equals",
            "value": "RESERVATION",
            "field": "SOURCE_KIND"
        }
    ]
  },
  "pageSize": 100,
  "orderBy": [
    {
      "field": "ID",
      "direction": "asc"
    }
  ]
}'

JSON Response

[
        {  
            "id": "54741583618286",  
            "propertyId": "1137897",  
            "internalTransactionCode": "1000",  
            "customTransactionCode": null,  
            "generalLedgerCustomCode": null,  
            "amount": 50.00,  
            "currency": "USD",  
            "customerId": "27006679",  
            "rootId": "54741583618286",  
            "parentId": null,  
            "sourceId": "27974559",  
            "subSourceId": "40210092",  
            "sourceKind": "RESERVATION",  
            "account": null,  
            "externalRelationId": "40210092",  
            "externalRelationKind": "ROOM",  
            "originId": "541290",  
            "routedFrom": null,  
            "quantity": 1,  
            "description": "Room rate - Queen",  
            "userId": "1233160",  
            "sourceDatetime": "2025-01-01T18:28:05.648106Z",  
            "transactionDatetime": "2025-01-01T18:28:05.648106Z",  
            "transactionDatetimePropertyTime": "2025-01-01T18:28:05.648106Z",  
            "serviceDate": "2024-12-31",  
            "createdAt": "2025-01-01T18:28:05.648125Z"  
        },  
        {  
            "id": "54741583618287",  
            "propertyId": "1137897",  
            "internalTransactionCode": "8100",  
            "customTransactionCode": null,  
            "generalLedgerCustomCode": null,  
            "amount": 1.25,  
            "currency": "USD",  
            "customerId": "27006679",  
            "rootId": "54741583618287",  
            "parentId": "54741583618286",  
            "sourceId": "27974559",  
            "subSourceId": "40210092",  
            "sourceKind": "RESERVATION",  
            "account": null,  
            "externalRelationId": "40210092",  
            "externalRelationKind": "ROOM",  
            "originId": "191019",  
            "routedFrom": null,  
            "quantity": 1,  
            "description": "fee",  
            "userId": "1233160",  
            "sourceDatetime": "2025-01-01T18:28:05.648106Z",  
            "transactionDatetime": "2025-01-01T18:28:05.648106Z",  
            "transactionDatetimePropertyTime": "2025-01-01T18:28:05.648106Z",  
            "serviceDate": "2024-12-31",  
            "createdAt": "2025-01-01T18:28:05.648169Z"  
        },  
        {  
            "id": "54741583618297",  
            "propertyId": "1137897",  
            "internalTransactionCode": "1000",  
            "customTransactionCode": null,  
            "generalLedgerCustomCode": null,  
            "amount": 50.00,  
            "currency": "USD",  
            "customerId": "27006679",  
            "rootId": "54741583618297",  
            "parentId": null,  
            "sourceId": "27974559",  
            "subSourceId": "40210093",  
            "sourceKind": "RESERVATION",  
            "account": null,  
            "externalRelationId": "40210093",  
            "externalRelationKind": "ROOM",  
            "originId": "541291",  
            "routedFrom": null,  
            "quantity": 1,  
            "description": "Room rate - Queen2",  
            "userId": "1233160",  
            "sourceDatetime": "2025-01-01T18:28:09.255392Z",  
            "transactionDatetime": "2025-01-01T18:28:09.255392Z",  
            "transactionDatetimePropertyTime": "2025-01-01T18:28:09.255392Z",  
            "serviceDate": "2024-12-31",  
            "createdAt": "2025-01-01T18:28:09.255407Z"  
        },  
        {  
            "id": "54741583618298",  
            "propertyId": "1137897",  
            "internalTransactionCode": "8100",  
            "customTransactionCode": null,  
            "generalLedgerCustomCode": null,  
            "amount": 1.25,  
            "currency": "USD",  
            "customerId": "27006679",  
            "rootId": "54741583618298",  
            "parentId": "54741583618297",  
            "sourceId": "27974559",  
            "subSourceId": "40210093",  
            "sourceKind": "RESERVATION",  
            "account": null,  
            "externalRelationId": "40210093",  
            "externalRelationKind": "ROOM",  
            "originId": "191019",  
            "routedFrom": null,  
            "quantity": 1,  
            "description": "fee",  
            "userId": "1233160",  
            "sourceDatetime": "2025-01-01T18:28:09.255392Z",  
            "transactionDatetime": "2025-01-01T18:28:09.255392Z",  
            "transactionDatetimePropertyTime": "2025-01-01T18:28:09.255392Z",  
            "serviceDate": "2024-12-31",  
            "createdAt": "2025-01-01T18:28:09.255439Z"  
        },  
        {  
            "id": "54741583618299",  
            "propertyId": "1137897",  
            "internalTransactionCode": "1000",  
            "customTransactionCode": null,  
            "generalLedgerCustomCode": null,  
            "amount": 50.00,  
            "currency": "USD",  
            "customerId": "27006679",  
            "rootId": "54741583618299",  
            "parentId": null,  
            "sourceId": "27974559",  
            "subSourceId": "40210093",  
            "sourceKind": "RESERVATION",  
            "account": null,  
            "externalRelationId": "40210093",  
            "externalRelationKind": "ROOM",  
            "originId": "541291",  
            "routedFrom": null,  
            "quantity": 1,  
            "description": "Room rate - Queen2",  
            "userId": "1233160",  
            "sourceDatetime": "2025-01-02T07:48:28.955749Z",  
            "transactionDatetime": "2025-01-02T07:48:28.955749Z",  
            "transactionDatetimePropertyTime": "2025-01-02T07:48:28.955749Z",  
            "serviceDate": "2025-01-01",  
            "createdAt": "2025-01-02T07:48:28.955766Z"  
        },  
        {  
            "id": "54741583618300",  
            "propertyId": "1137897",  
            "internalTransactionCode": "8100",  
            "customTransactionCode": null,  
            "generalLedgerCustomCode": null,  
            "amount": 1.25,  
            "currency": "USD",  
            "customerId": "27006679",  
            "rootId": "54741583618300",  
            "parentId": "54741583618299",  
            "sourceId": "27974559",  
            "subSourceId": "40210093",  
            "sourceKind": "RESERVATION",  
            "account": null,  
            "externalRelationId": "40210093",  
            "externalRelationKind": "ROOM",  
            "originId": "191019",  
            "routedFrom": null,  
            "quantity": 1,  
            "description": "fee",  
            "userId": "1233160",  
            "sourceDatetime": "2025-01-02T07:48:28.955749Z",  
            "transactionDatetime": "2025-01-02T07:48:28.955749Z",  
            "transactionDatetimePropertyTime": "2025-01-02T07:48:28.955749Z",  
            "serviceDate": "2025-01-01",  
            "createdAt": "2025-01-02T07:48:28.955793Z"  
        },  
        {  
            "id": "54741583618301",  
            "propertyId": "1137897",  
            "internalTransactionCode": "1000V",  
            "customTransactionCode": null,  
            "generalLedgerCustomCode": null,  
            "amount": -50.00,  
            "currency": "USD",  
            "customerId": "27006679",  
            "rootId": "54741583618286",  
            "parentId": null,  
            "sourceId": "27974559",  
            "subSourceId": "40210092",  
            "sourceKind": "RESERVATION",  
            "account": null,  
            "externalRelationId": "40210092",  
            "externalRelationKind": "ROOM",  
            "originId": "541290",  
            "routedFrom": null,  
            "quantity": 1,  
            "description": "Room rate - Queen",  
            "userId": "1233160",  
            "sourceDatetime": "2025-01-01T18:28:07Z",  
            "transactionDatetime": "2025-01-01T18:28:07.927674Z",  
            "transactionDatetimePropertyTime": "2025-01-01T18:28:07.927674Z",  
            "serviceDate": "2024-12-31",  
            "createdAt": "2025-01-01T18:28:07.927707Z"  
        },  
        {  
            "id": "54741583618302",  
            "propertyId": "1137897",  
            "internalTransactionCode": "8100V",  
            "customTransactionCode": null,  
            "generalLedgerCustomCode": null,  
            "amount": -1.25,  
            "currency": "USD",  
            "customerId": "27006679",  
            "rootId": "54741583618287",  
            "parentId": null,  
            "sourceId": "27974559",  
            "subSourceId": "40210092",  
            "sourceKind": "RESERVATION",  
            "account": null,  
            "externalRelationId": "40210092",  
            "externalRelationKind": "ROOM",  
            "originId": "191019",  
            "routedFrom": null,  
            "quantity": 1,  
            "description": "fee",  
            "userId": "1233160",  
            "sourceDatetime": "2025-01-01T18:28:07Z",  
            "transactionDatetime": "2025-01-01T18:28:07.927674Z",  
            "transactionDatetimePropertyTime": "2025-01-01T18:28:07.927674Z",  
            "serviceDate": "2024-12-31",  
            "createdAt": "2025-01-01T18:28:07.92773Z"  
        }
    ]

Transactions from Cloudbeds API GetTransactions when property is NOT transitioned to the Cloudbeds Accounting Service

Curl Request

curl --location 'https://hotels.cloudbeds-stage.com/api/v1.1/getTransactions?propertyID=1137897&reservationId=3629181440474&pageSize=20&includeDeleted=true' \
--header 'Authorization: Bearer INSERT_TOKEN' \
--header 'X-PROPERTY-ID: 1137897'

JSON Response

[{
            "propertyID": "1137892",  
            "reservationID": "4244170543060",  
            "subReservationID": "4244170543060",  
            "houseAccountID": null,  
            "houseAccountName": null,  
            "guestID": "27007171",  
            "propertyName": "ACC-TEST-37c15c3d-61c6-4655-a53e-40793c43ef7b",  
            "transactionDateTime": "2025-01-02 13:53:52",  
            "transactionDateTimeUTC": "2025-01-02 13:53:52",  
            "transactionModifiedDateTime": "2025-01-02 13:53:52",  
            "transactionModifiedDateTimeUTC": "2025-01-02 13:53:52",  
            "guestCheckIn": "2025-01-01",  
            "guestCheckOut": "2025-01-02",  
            "roomTypeID": "541285",  
            "roomTypeName": "Queen",  
            "roomName": "QUE1",  
            "guestName": "Test Vod vod",  
            "description": "tax (Void)",  
            "category": "Taxes",  
            "transactionCode": "Yen",  
            "notes": "",  
            "quantity": "1",  
            "amount": -0.35,  
            "currency": "USD",  
            "userName": "SYSTEM",  
            "transactionType": "debit",  
            "transactionCategory": "void",  
            "itemCategoryName": "void",  
            "transactionID": "55052009722028",  
            "parentTransactionID": "55052009722025",  
            "cardType": null,  
            "isDeleted": false  
        },  
        {  
            "propertyID": "1137892",  
            "reservationID": "4244170543060",  
            "subReservationID": "4244170543060",  
            "houseAccountID": null,  
            "houseAccountName": null,  
            "guestID": "27007171",  
            "propertyName": "ACC-TEST-37c15c3d-61c6-4655-a53e-40793c43ef7b",  
            "transactionDateTime": "2025-01-02 13:53:40",  
            "transactionDateTimeUTC": "2025-01-02 13:53:40",  
            "transactionModifiedDateTime": "2025-01-02 13:53:40",  
            "transactionModifiedDateTimeUTC": "2025-01-02 13:53:40",  
            "guestCheckIn": "2025-01-01",  
            "guestCheckOut": "2025-01-02",  
            "roomTypeID": "541285",  
            "roomTypeName": "Queen",  
            "roomName": "QUE1",  
            "guestName": "Test Vod vod",  
            "description": "fee (Void)",  
            "category": "Fees",  
            "transactionCode": "Yen",  
            "notes": "",  
            "quantity": "1",  
            "amount": -10,  
            "currency": "USD",  
            "userName": "SYSTEM",  
            "transactionType": "debit",  
            "transactionCategory": "void",  
            "itemCategoryName": "void",  
            "transactionID": "55052009722027",  
            "parentTransactionID": "55052009722024",  
            "cardType": null,  
            "isDeleted": false  
        },  
        {  
            "propertyID": "1137892",  
            "reservationID": "4244170543060",  
            "subReservationID": "4244170543060",  
            "houseAccountID": null,  
            "houseAccountName": null,  
            "guestID": "27007171",  
            "propertyName": "ACC-TEST-37c15c3d-61c6-4655-a53e-40793c43ef7b",  
            "transactionDateTime": "2025-01-02 13:53:31",  
            "transactionDateTimeUTC": "2025-01-02 13:53:31",  
            "transactionModifiedDateTime": "2025-01-02 13:53:31",  
            "transactionModifiedDateTimeUTC": "2025-01-02 13:53:31",  
            "guestCheckIn": "2025-01-01",  
            "guestCheckOut": "2025-01-02",  
            "roomTypeID": "541285",  
            "roomTypeName": "Queen",  
            "roomName": "QUE1",  
            "guestName": "Test Vod vod",  
            "description": "tax",  
            "category": "Taxes",  
            "transactionCode": "Yen",  
            "notes": "",  
            "quantity": "1",  
            "amount": 0.35,  
            "currency": "USD",  
            "userName": "SYSTEM",  
            "transactionType": "debit",  
            "transactionCategory": "tax",  
            "itemCategoryName": "tax",  
            "transactionID": "55052009722025",  
            "parentTransactionID": "55052009722024",  
            "cardType": null,  
            "isDeleted": false  
        },  
        {  
            "propertyID": "1137892",  
            "reservationID": "4244170543060",  
            "subReservationID": "4244170543060",  
            "houseAccountID": null,  
            "houseAccountName": null,  
            "guestID": "27007171",  
            "propertyName": "ACC-TEST-37c15c3d-61c6-4655-a53e-40793c43ef7b",  
            "transactionDateTime": "2025-01-02 13:53:31",  
            "transactionDateTimeUTC": "2025-01-02 13:53:31",  
            "transactionModifiedDateTime": "2025-01-02 13:53:31",  
            "transactionModifiedDateTimeUTC": "2025-01-02 13:53:31",  
            "guestCheckIn": "2025-01-01",  
            "guestCheckOut": "2025-01-02",  
            "roomTypeID": "541285",  
            "roomTypeName": "Queen",  
            "roomName": "QUE1",  
            "guestName": "Test Vod vod",  
            "description": "fee",  
            "category": "Fees",  
            "transactionCode": "Yen",  
            "notes": "",  
            "quantity": "1",  
            "amount": 10,  
            "currency": "USD",  
            "userName": "SYSTEM",  
            "transactionType": "debit",  
            "transactionCategory": "fee",  
            "itemCategoryName": "fee",  
            "transactionID": "55052009722024",  
            "parentTransactionID": "",  
            "cardType": null,  
            "isDeleted": false  
        },  
        {  
            "propertyID": "1137892",  
            "reservationID": "4244170543060",  
            "subReservationID": "4244170543060",  
            "houseAccountID": null,  
            "houseAccountName": null,  
            "guestID": "27007171",  
            "propertyName": "ACC-TEST-37c15c3d-61c6-4655-a53e-40793c43ef7b",  
            "transactionDateTime": "2025-01-01 23:59:00",  
            "transactionDateTimeUTC": "2025-01-01 23:59:00",  
            "transactionModifiedDateTime": "2025-01-02 13:52:36",  
            "transactionModifiedDateTimeUTC": "2025-01-02 13:52:36",  
            "guestCheckIn": "2025-01-01",  
            "guestCheckOut": "2025-01-02",  
            "roomTypeID": "541285",  
            "roomTypeName": "Queen",  
            "roomName": "QUE1",  
            "guestName": "Test Vod vod",  
            "description": "Room rate - Queen",  
            "category": "Room Revenue",  
            "transactionCode": "",  
            "notes": "",  
            "quantity": "1",  
            "amount": 50,  
            "currency": "USD",  
            "userName": "SYSTEM",  
            "transactionType": "debit",  
            "transactionCategory": "rate",  
            "itemCategoryName": "rate",  
            "transactionID": "55052009722022",  
            "parentTransactionID": "",  
            "cardType": null,  
            "isDeleted": false
        }
]