Example 1: Update Room Price and Routed Transactions

Steps to recreate

Generate initial transactions on Cloudbeds for a 1 night stay with a fee
1. Create a fee
2. Create a tax on the fee
3. Attach the fee and the text to the reservation source
4. Create an accommodation and a room rate
Create a reservation for past 1 night
Update the room price
Route all transactions to the Group Profile

What changes

Before: This example would return 4 transactions, 1 each for Rate, Tax and Fee, Tax. The changes and moves would update existing transactions.

After: A total of 16 transactions would be created.

4 for the original reservation.
4 for the update to the room price and corresponding tax and fee changes
8 additional for the move to the group folio

API Response Examples

Transactions from Accounting Service

Request

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

Response

[
  {
    "id": "54741583614168",
    "propertyId": "1137892",
    "internalTransactionCode": "1000",
    "customTransactionCode": null,
    "generalLedgerCustomCode": null,
    "amount": 50,
    "currency": "USD",
    "customerId": "27006674",
    "rootId": "54741583614168",
    "parentId": null,
    "sourceId": "27974554",
    "subSourceId": "40210087",
    "sourceKind": "RESERVATION",
    "account": null,
    "externalRelationId": "40210087",
    "externalRelationKind": "ROOM",
    "originId": "541285",
    "routedFrom": null,
    "quantity": 1,
    "description": "Room rate - Queen",
    "userId": "1233155",
    "sourceDatetime": "2025-01-01T18:22:26.482626Z",
    "transactionDatetime": "2025-01-01T18:22:26.482626Z",
    "transactionDatetimePropertyTime": "2025-01-01T18:22:26.482626Z",
    "serviceDate": "2024-12-31",
    "createdAt": "2025-01-01T18:22:26.482658Z"
  },
  {
    "id": "54741583614169",
    "propertyId": "1137892",
    "internalTransactionCode": "8100",
    "customTransactionCode": null,
    "generalLedgerCustomCode": null,
    "amount": 1.25,
    "currency": "USD",
    "customerId": "27006674",
    "rootId": "54741583614169",
    "parentId": "54741583614168",
    "sourceId": "27974554",
    "subSourceId": "40210087",
    "sourceKind": "RESERVATION",
    "account": null,
    "externalRelationId": "40210087",
    "externalRelationKind": "ROOM",
    "originId": "191015",
    "routedFrom": null,
    "quantity": 1,
    "description": "fee",
    "userId": "1233155",
    "sourceDatetime": "2025-01-01T18:22:26.482626Z",
    "transactionDatetime": "2025-01-01T18:22:26.482626Z",
    "transactionDatetimePropertyTime": "2025-01-01T18:22:26.482626Z",
    "serviceDate": "2024-12-31",
    "createdAt": "2025-01-01T18:22:26.484032Z"
  },
  {
    "id": "54741583614170",
    "propertyId": "1137892",
    "internalTransactionCode": "8000",
    "customTransactionCode": null,
    "generalLedgerCustomCode": null,
    "amount": 1.75,
    "currency": "USD",
    "customerId": "27006674",
    "rootId": "54741583614170",
    "parentId": "54741583614168",
    "sourceId": "27974554",
    "subSourceId": "40210087",
    "sourceKind": "RESERVATION",
    "account": null,
    "externalRelationId": "40210087",
    "externalRelationKind": "ROOM",
    "originId": "274793",
    "routedFrom": null,
    "quantity": 1,
    "description": "tax",
    "userId": "1233155",
    "sourceDatetime": "2025-01-01T18:22:26.482626Z",
    "transactionDatetime": "2025-01-01T18:22:26.482626Z",
    "transactionDatetimePropertyTime": "2025-01-01T18:22:26.482626Z",
    "serviceDate": "2024-12-31",
    "createdAt": "2025-01-01T18:22:26.484019Z"
  },
  {
    "id": "54741583614171",
    "propertyId": "1137892",
    "internalTransactionCode": "8000",
    "customTransactionCode": null,
    "generalLedgerCustomCode": null,
    "amount": 0.04,
    "currency": "USD",
    "customerId": "27006674",
    "rootId": "54741583614171",
    "parentId": "54741583614169",
    "sourceId": "27974554",
    "subSourceId": "40210087",
    "sourceKind": "RESERVATION",
    "account": null,
    "externalRelationId": "40210087",
    "externalRelationKind": "ROOM",
    "originId": "274793",
    "routedFrom": null,
    "quantity": 1,
    "description": "tax->fee",
    "userId": "1233155",
    "sourceDatetime": "2025-01-01T18:22:26.482626Z",
    "transactionDatetime": "2025-01-01T18:22:26.482626Z",
    "transactionDatetimePropertyTime": "2025-01-01T18:22:26.482626Z",
    "serviceDate": "2024-12-31",
    "createdAt": "2025-01-01T18:22:26.484041Z"
  },
  {
    "id": "54741583614181",
    "propertyId": "1137892",
    "internalTransactionCode": "1000A",
    "customTransactionCode": null,
    "generalLedgerCustomCode": null,
    "amount": 25,
    "currency": "USD",
    "customerId": "27006674",
    "rootId": "54741583614168",
    "parentId": null,
    "sourceId": "27974554",
    "subSourceId": "40210087",
    "sourceKind": "RESERVATION",
    "account": null,
    "externalRelationId": "40210087",
    "externalRelationKind": "ROOM",
    "originId": "541285",
    "routedFrom": null,
    "quantity": 1,
    "description": "Room rate - Queen",
    "userId": "1233155",
    "sourceDatetime": "2025-01-01T18:22:28Z",
    "transactionDatetime": "2025-01-01T18:22:28.968704Z",
    "transactionDatetimePropertyTime": "2025-01-01T18:22:28.968704Z",
    "serviceDate": "2024-12-31",
    "createdAt": "2025-01-01T18:22:28.968737Z"
  },
  {
    "id": "54741583614182",
    "propertyId": "1137892",
    "internalTransactionCode": "8100A",
    "customTransactionCode": null,
    "generalLedgerCustomCode": null,
    "amount": 0.63,
    "currency": "USD",
    "customerId": "27006674",
    "rootId": "54741583614169",
    "parentId": null,
    "sourceId": "27974554",
    "subSourceId": "40210087",
    "sourceKind": "RESERVATION",
    "account": null,
    "externalRelationId": "40210087",
    "externalRelationKind": "ROOM",
    "originId": "191015",
    "routedFrom": null,
    "quantity": 1,
    "description": "fee",
    "userId": "1233155",
    "sourceDatetime": "2025-01-01T18:22:28Z",
    "transactionDatetime": "2025-01-01T18:22:28.968704Z",
    "transactionDatetimePropertyTime": "2025-01-01T18:22:28.968704Z",
    "serviceDate": "2024-12-31",
    "createdAt": "2025-01-01T18:22:28.968752Z"
  },
  {
    "id": "54741583614183",
    "propertyId": "1137892",
    "internalTransactionCode": "8000A",
    "customTransactionCode": null,
    "generalLedgerCustomCode": null,
    "amount": 0.88,
    "currency": "USD",
    "customerId": "27006674",
    "rootId": "54741583614170",
    "parentId": null,
    "sourceId": "27974554",
    "subSourceId": "40210087",
    "sourceKind": "RESERVATION",
    "account": null,
    "externalRelationId": "40210087",
    "externalRelationKind": "ROOM",
    "originId": "274793",
    "routedFrom": null,
    "quantity": 1,
    "description": "tax",
    "userId": "1233155",
    "sourceDatetime": "2025-01-01T18:22:28Z",
    "transactionDatetime": "2025-01-01T18:22:28.968704Z",
    "transactionDatetimePropertyTime": "2025-01-01T18:22:28.968704Z",
    "serviceDate": "2024-12-31",
    "createdAt": "2025-01-01T18:22:28.96881Z"
  },
  {
    "id": "54741583614184",
    "propertyId": "1137892",
    "internalTransactionCode": "8000A",
    "customTransactionCode": null,
    "generalLedgerCustomCode": null,
    "amount": 0.03,
    "currency": "USD",
    "customerId": "27006674",
    "rootId": "54741583614171",
    "parentId": null,
    "sourceId": "27974554",
    "subSourceId": "40210087",
    "sourceKind": "RESERVATION",
    "account": null,
    "externalRelationId": "40210087",
    "externalRelationKind": "ROOM",
    "originId": "274793",
    "routedFrom": null,
    "quantity": 1,
    "description": "tax->fee",
    "userId": "1233155",
    "sourceDatetime": "2025-01-01T18:22:28Z",
    "transactionDatetime": "2025-01-01T18:22:28.968704Z",
    "transactionDatetimePropertyTime": "2025-01-01T18:22:28.968704Z",
    "serviceDate": "2024-12-31",
    "createdAt": "2025-01-01T18:22:28.968813Z"
  },
  {
    "id": "54741583614190",
    "propertyId": "1137892",
    "internalTransactionCode": "8100R",
    "customTransactionCode": null,
    "generalLedgerCustomCode": null,
    "amount": -1.25,
    "currency": "USD",
    "customerId": "27006674",
    "rootId": "54741583614169",
    "parentId": "54741583614168",
    "sourceId": "27974554",
    "subSourceId": "40210087",
    "sourceKind": "RESERVATION",
    "account": null,
    "externalRelationId": "40210087",
    "externalRelationKind": "ROOM",
    "originId": "191015",
    "routedFrom": null,
    "quantity": 1,
    "description": "fee",
    "userId": "1233155",
    "sourceDatetime": "2025-01-01T18:22:31.996848Z",
    "transactionDatetime": "2025-01-01T18:22:31.996848Z",
    "transactionDatetimePropertyTime": "2025-01-01T18:22:31.996848Z",
    "serviceDate": "2024-12-31",
    "createdAt": "2025-01-01T18:22:31.996868Z"
  },
  {
    "id": "54741583614191",
    "propertyId": "1137892",
    "internalTransactionCode": "8100R",
    "customTransactionCode": null,
    "generalLedgerCustomCode": null,
    "amount": -0.63,
    "currency": "USD",
    "customerId": "27006674",
    "rootId": "54741583614169",
    "parentId": null,
    "sourceId": "27974554",
    "subSourceId": "40210087",
    "sourceKind": "RESERVATION",
    "account": null,
    "externalRelationId": "40210087",
    "externalRelationKind": "ROOM",
    "originId": "191015",
    "routedFrom": null,
    "quantity": 1,
    "description": "fee",
    "userId": "1233155",
    "sourceDatetime": "2025-01-01T18:22:31.996848Z",
    "transactionDatetime": "2025-01-01T18:22:31.996848Z",
    "transactionDatetimePropertyTime": "2025-01-01T18:22:31.996848Z",
    "serviceDate": "2024-12-31",
    "createdAt": "2025-01-01T18:22:31.996887Z"
  },
  {
    "id": "54741583614195",
    "propertyId": "1137892",
    "internalTransactionCode": "8000R",
    "customTransactionCode": null,
    "generalLedgerCustomCode": null,
    "amount": -1.75,
    "currency": "USD",
    "customerId": "27006674",
    "rootId": "54741583614170",
    "parentId": "54741583614168",
    "sourceId": "27974554",
    "subSourceId": "40210087",
    "sourceKind": "RESERVATION",
    "account": null,
    "externalRelationId": "40210087",
    "externalRelationKind": "ROOM",
    "originId": "274793",
    "routedFrom": null,
    "quantity": 1,
    "description": "tax",
    "userId": "1233155",
    "sourceDatetime": "2025-01-01T18:22:32.03713Z",
    "transactionDatetime": "2025-01-01T18:22:32.03713Z",
    "transactionDatetimePropertyTime": "2025-01-01T18:22:32.03713Z",
    "serviceDate": "2024-12-31",
    "createdAt": "2025-01-01T18:22:32.037148Z"
  },
  {
    "id": "54741583614196",
    "propertyId": "1137892",
    "internalTransactionCode": "8000R",
    "customTransactionCode": null,
    "generalLedgerCustomCode": null,
    "amount": -0.88,
    "currency": "USD",
    "customerId": "27006674",
    "rootId": "54741583614170",
    "parentId": null,
    "sourceId": "27974554",
    "subSourceId": "40210087",
    "sourceKind": "RESERVATION",
    "account": null,
    "externalRelationId": "40210087",
    "externalRelationKind": "ROOM",
    "originId": "274793",
    "routedFrom": null,
    "quantity": 1,
    "description": "tax",
    "userId": "1233155",
    "sourceDatetime": "2025-01-01T18:22:32.03713Z",
    "transactionDatetime": "2025-01-01T18:22:32.03713Z",
    "transactionDatetimePropertyTime": "2025-01-01T18:22:32.03713Z",
    "serviceDate": "2024-12-31",
    "createdAt": "2025-01-01T18:22:32.037166Z"
  },
  {
    "id": "54741583614199",
    "propertyId": "1137892",
    "internalTransactionCode": "1000R",
    "customTransactionCode": null,
    "generalLedgerCustomCode": null,
    "amount": -50,
    "currency": "USD",
    "customerId": "27006674",
    "rootId": "54741583614168",
    "parentId": null,
    "sourceId": "27974554",
    "subSourceId": "40210087",
    "sourceKind": "RESERVATION",
    "account": null,
    "externalRelationId": "40210087",
    "externalRelationKind": "ROOM",
    "originId": "541285",
    "routedFrom": null,
    "quantity": 1,
    "description": "Room rate - Queen",
    "userId": "1233155",
    "sourceDatetime": "2025-01-01T18:22:32.038433Z",
    "transactionDatetime": "2025-01-01T18:22:32.038433Z",
    "transactionDatetimePropertyTime": "2025-01-01T18:22:32.038433Z",
    "serviceDate": "2024-12-31",
    "createdAt": "2025-01-01T18:22:32.038442Z"
  },
  {
    "id": "54741583614200",
    "propertyId": "1137892",
    "internalTransactionCode": "1000R",
    "customTransactionCode": null,
    "generalLedgerCustomCode": null,
    "amount": -25,
    "currency": "USD",
    "customerId": "27006674",
    "rootId": "54741583614168",
    "parentId": null,
    "sourceId": "27974554",
    "subSourceId": "40210087",
    "sourceKind": "RESERVATION",
    "account": null,
    "externalRelationId": "40210087",
    "externalRelationKind": "ROOM",
    "originId": "541285",
    "routedFrom": null,
    "quantity": 1,
    "description": "Room rate - Queen",
    "userId": "1233155",
    "sourceDatetime": "2025-01-01T18:22:32.038433Z",
    "transactionDatetime": "2025-01-01T18:22:32.038433Z",
    "transactionDatetimePropertyTime": "2025-01-01T18:22:32.038433Z",
    "serviceDate": "2024-12-31",
    "createdAt": "2025-01-01T18:22:32.038452Z"
  },
  {
    "id": "54741583614205",
    "propertyId": "1137892",
    "internalTransactionCode": "8000R",
    "customTransactionCode": null,
    "generalLedgerCustomCode": null,
    "amount": -0.04,
    "currency": "USD",
    "customerId": "27006674",
    "rootId": "54741583614171",
    "parentId": "54741583614169",
    "sourceId": "27974554",
    "subSourceId": "40210087",
    "sourceKind": "RESERVATION",
    "account": null,
    "externalRelationId": "40210087",
    "externalRelationKind": "ROOM",
    "originId": "274793",
    "routedFrom": null,
    "quantity": 1,
    "description": "tax->fee",
    "userId": "1233155",
    "sourceDatetime": "2025-01-01T18:22:32.082862Z",
    "transactionDatetime": "2025-01-01T18:22:32.082862Z",
    "transactionDatetimePropertyTime": "2025-01-01T18:22:32.082862Z",
    "serviceDate": "2024-12-31",
    "createdAt": "2025-01-01T18:22:32.082874Z"
  },
  {
    "id": "54741583614206",
    "propertyId": "1137892",
    "internalTransactionCode": "8000R",
    "customTransactionCode": null,
    "generalLedgerCustomCode": null,
    "amount": -0.03,
    "currency": "USD",
    "customerId": "27006674",
    "rootId": "54741583614171",
    "parentId": null,
    "sourceId": "27974554",
    "subSourceId": "40210087",
    "sourceKind": "RESERVATION",
    "account": null,
    "externalRelationId": "40210087",
    "externalRelationKind": "ROOM",
    "originId": "274793",
    "routedFrom": null,
    "quantity": 1,
    "description": "tax->fee",
    "userId": "1233155",
    "sourceDatetime": "2025-01-01T18:22:32.082862Z",
    "transactionDatetime": "2025-01-01T18:22:32.082862Z",
    "transactionDatetimePropertyTime": "2025-01-01T18:22:32.082862Z",
    "serviceDate": "2024-12-31",
    "createdAt": "2025-01-01T18:22:32.082886Z"
  }
]

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

Request

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

Response

[
  {
    "propertyID": "1137892",
    "reservationID": "2262238910043",
    "subReservationID": "2262238910043",
    "houseAccountID": null,
    "houseAccountName": null,
    "guestID": "27006674",
    "propertyName": "ACC-TEST-37c15c3d-61c6-4655-a53e-40793c43ef7b",
    "transactionDateTime": "2024-12-31 23:59:00",
    "transactionDateTimeUTC": "2024-12-31 23:59:00",
    "transactionModifiedDateTime": "2025-01-01 18:22:31",
    "transactionModifiedDateTimeUTC": "2025-01-01 18:22:31",
    "guestCheckIn": "2024-12-31",
    "guestCheckOut": "2025-01-01",
    "roomTypeID": "541285",
    "roomTypeName": "Queen",
    "roomName": "QUE1",
    "guestName": "Magnus Robel",
    "description": "tax->fee",
    "category": "Taxes",
    "transactionCode": "Yen",
    "notes": "",
    "quantity": "1",
    "amount": 0.07,
    "currency": "USD",
    "userName": "SYSTEM",
    "transactionType": "debit",
    "transactionCategory": "tax",
    "itemCategoryName": "tax",
    "transactionID": "54790470570150",
    "parentTransactionID": "54790470570148",
    "cardType": null,
    "isDeleted": false
  },
  {
    "propertyID": "1137892",
    "reservationID": "2262238910043",
    "subReservationID": "2262238910043",
    "houseAccountID": null,
    "houseAccountName": null,
    "guestID": "27006674",
    "propertyName": "ACC-TEST-37c15c3d-61c6-4655-a53e-40793c43ef7b",
    "transactionDateTime": "2024-12-31 23:59:00",
    "transactionDateTimeUTC": "2024-12-31 23:59:00",
    "transactionModifiedDateTime": "2025-01-01 18:22:31",
    "transactionModifiedDateTimeUTC": "2025-01-01 18:22:31",
    "guestCheckIn": "2024-12-31",
    "guestCheckOut": "2025-01-01",
    "roomTypeID": "541285",
    "roomTypeName": "Queen",
    "roomName": "QUE1",
    "guestName": "Magnus Robel",
    "description": "tax",
    "category": "Taxes",
    "transactionCode": "Yen",
    "notes": "",
    "quantity": "1",
    "amount": 2.63,
    "currency": "USD",
    "userName": "SYSTEM",
    "transactionType": "debit",
    "transactionCategory": "tax",
    "itemCategoryName": "tax",
    "transactionID": "54790470570149",
    "parentTransactionID": "54790470570147",
    "cardType": null,
    "isDeleted": false
  },
  {
    "propertyID": "1137892",
    "reservationID": "2262238910043",
    "subReservationID": "2262238910043",
    "houseAccountID": null,
    "houseAccountName": null,
    "guestID": "27006674",
    "propertyName": "ACC-TEST-37c15c3d-61c6-4655-a53e-40793c43ef7b",
    "transactionDateTime": "2024-12-31 23:59:00",
    "transactionDateTimeUTC": "2024-12-31 23:59:00",
    "transactionModifiedDateTime": "2025-01-01 18:22:31",
    "transactionModifiedDateTimeUTC": "2025-01-01 18:22:31",
    "guestCheckIn": "2024-12-31",
    "guestCheckOut": "2025-01-01",
    "roomTypeID": "541285",
    "roomTypeName": "Queen",
    "roomName": "QUE1",
    "guestName": "Magnus Robel",
    "description": "fee",
    "category": "Fees",
    "transactionCode": "Yen",
    "notes": "",
    "quantity": "1",
    "amount": 1.88,
    "currency": "USD",
    "userName": "SYSTEM",
    "transactionType": "debit",
    "transactionCategory": "fee",
    "itemCategoryName": "fee",
    "transactionID": "54790470570148",
    "parentTransactionID": "54790470570147",
    "cardType": null,
    "isDeleted": false
  },
  {
    "propertyID": "1137892",
    "reservationID": "2262238910043",
    "subReservationID": "2262238910043",
    "houseAccountID": null,
    "houseAccountName": null,
    "guestID": "27006674",
    "propertyName": "ACC-TEST-37c15c3d-61c6-4655-a53e-40793c43ef7b",
    "transactionDateTime": "2024-12-31 23:59:00",
    "transactionDateTimeUTC": "2024-12-31 23:59:00",
    "transactionModifiedDateTime": "2025-01-01 18:22:31",
    "transactionModifiedDateTimeUTC": "2025-01-01 18:22:31",
    "guestCheckIn": "2024-12-31",
    "guestCheckOut": "2025-01-01",
    "roomTypeID": "541285",
    "roomTypeName": "Queen",
    "roomName": "QUE1",
    "guestName": "Magnus Robel",
    "description": "Room rate - Queen",
    "category": "Room Revenue",
    "transactionCode": "",
    "notes": "",
    "quantity": "1",
    "amount": 75,
    "currency": "USD",
    "userName": "SYSTEM",
    "transactionType": "debit",
    "transactionCategory": "rate",
    "itemCategoryName": "rate",
    "transactionID": "54790470570147",
    "parentTransactionID": "",
    "cardType": null,
    "isDeleted": false
  }
]