This automation supports the daily reconciliation of credit card payment transactions across Opera PMS, Seven Rooms, Simphony, and Adyen. It accesses all four systems, retrieves the required reports, and uses Adyen web hooks to obtain payment data. It then performs the required calculations and populates each section of the master reconciliation spreadsheet used by the Finance team. If data has not been generated for that date, the process continues to the next step. Once all mandatory fields are completed, the reconciliation file is sent to the client. The workflow runs daily, including weekends and holidays, after Night Audit and according to each property’s regional schedule.

4. Benefits / Results

• 60 hours saved per month per hotel

• Reduce 1–3 hours of daily manual work

• Eliminate manual file generation and consolidation

• Flag issues and exceptions for Finance review

• Standardize daily reconciliation output

5. Technical Details

The automation accesses Opera PMS, Seven Rooms, Simphony, and Adyen to collect the data required for daily credit card reconciliation. Adyen data is retrieved through web hooks, while the remaining systems provide the reports needed to complete the process. The workflow performs the required calculations and keys the results into the relevant sections of the master spreadsheet used by Finance. If data is unavailable for a given date, the workflow continues without interruption and moves to the next step. It is scheduled by property region, runs after Night Audit, and operates daily, including weekends and holidays. Its scope is limited to populating, flagging, and delivering the reconciliation file.

6. FAQ

Which systems are included in the reconciliation process?
The automation works across Opera PMS, Seven Rooms, Simphony, and Adyen.

When does the automation run?
It runs daily, including weekends and holidays, after the property’s Night Audit procedure has been completed.

What does the automation deliver?
It delivers the completed reconciliation spreadsheet to the client and flags any issues or exceptions for review.

Does the automation investigate the reasons for discrepancies?
No. Its role is limited to populating and delivering the reconciliation file and flagging issues or exceptions.

What happens if data is missing for a given date?
If data has not been generated for that date, the process moves on to the next step without interruption.

What manual work does this reduce?
It reduces the daily effort required to generate files, manipulate data, consolidate it into one master spreadsheet, and prepare the reconciliation file for Finance review.