Example 1: Update Room Price and Routed Transactions
Steps to recreate
- Generate initial transactions on Cloubeds for a 1 night stay with a fee
- Creates fee
- Create a tax on the fee
- Attach fee and tax to reservation source
- Create accommodation and room rate
- Create a reservation for past 1 night
- Update 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
Curl Request
curl --location 'https://api.cloudbeds-stage.com/accounting/v1.0/transactions'
--header 'content-type: application/json'
--header 'Authorization: Bearer eyJraWQiOiJMRnNUS3UxaVJaak9wdlNLVVViZEVhcFR3LUVYWjJlN1NPbkxDS0VQOEM0IiwiYWxnIjoiUlMyNTYifQ.eyJ2ZXIiOjEsImp0aSI6IkFULmJsU0U5RG5pUTB4N1FOWGxqaERzajVVdFpybDhxbXpsUnIySFNnZXdfeEkub2FyMTdxZnJtMncyeHEzc0cxZDciLCJpc3MiOiJodHRwczovL2lkcC5jbG91ZGJlZHMtc3RhZ2UuY29tL29hdXRoMi9hdXNocDV6MnByMFFvVGZhMjFkNiIsImF1ZCI6Imh0dHBzOi8vaG90ZWxzLmNsb3VkYmVkcy1zdGFnZS5jb20vYXBpIiwic3ViIjoiZW5naW5lZXJpbmdAY2xvdWRiZWRzLmNvbSIsImlhdCI6MTczNTgxNzYxMiwiZXhwIjoxNzM1ODIxMjEyLCJjaWQiOiIwb2FocGZmZWVidHVld3ZkYTFkNiIsInVpZCI6IjAwdTJkZzJkZ2JEQmxsVnlHMWQ3Iiwic2NwIjpbIm9mZmxpbmVfYWNjZXNzIiwiZ3JvdXBzIiwib3BlbmlkIiwiZW1haWwiLCJwcm9maWxlIl0sImF1dGhfdGltZSI6MTczNTgxMzg1OCwiYXNzb2NpYXRpb25JZHMiOltdLCJjbGllbnRUeXBlIjoidW5rbm93biIsInByb3BlcnR5SWRzX3N0ciI6W10sImFzc29jaWF0aW9uSWRzX3N0ciI6W10sIm1mZFVzZXJJZF9zdHIiOiIyNjY0MjMiLCJyZXNvdXJjZXMiOltdLCJwcm9wZXJ0eUlkcyI6W10sImlzU3VwZXJBZG1pbiI6dHJ1ZSwibWZkVXNlcklkIjoyNjY0MjMsInR5cGUiOiJub25lIn0.l1un6SIzJTbepQwBtRzXgQvVxvC810uCYzXpeIknEMgJZ1DGtsCRsOh3E0PLQiGCsCU46m_JyRWH2PLRraW0k_5csInQc4hKkqijH5H9vqpmMa25Fn15il1-bBwkqNu9YqHUo5LxboCHsOMkxPVKgCiZqrivqekxLKOkG8JjePCCKHUyvdoP_4y4Ha8AlphcEOTqzgKItWHaz0UcxfKZSi140mlyjlxYzDNnwAniEZulvsctt0MFXTDrAn6v-UaIUszZk1xOE5Q0FzMMtAjFVmudrik15N4UBAXMUsM3jNVjgrikb9TVx93BSCH8RnwYH5_nfCBBCwLWZ0xohe0B7g'
--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"
}
]
}'
JSON Response
[
{
"id": "54741583614168",
"propertyId": "1137892",
"internalTransactionCode": "1000",
"customTransactionCode": null,
"generalLedgerCustomCode": null,
"amount": 50.00,
"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.00,
"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.00,
"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.00,
"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
Curl Request
curl --location 'https://hotels.cloudbeds-stage.com/api/v1.1/getTransactions?propertyID=1137892&pageSize=20&includeDeleted=true'
--header 'Authorization: Bearer INSERT_TOKEN'
--header 'X-PROPERTY-ID: 1137892'
JSON 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
}
]
Updated 8 days ago