🆕 This article reflects the latest version of this report.
We're excited to announce that we're upgrading our reporting suite! These enhancements are aimed at providing greater transparency, accuracy, and actionable insights to support your daily operations and help you achieve your business goals. For a comprehensive overview of the changes, please visit: Prepare for your Upgraded Finance and Occupancy Reporting.
Currently, these enhancements are in a limited-release phase and will be gradually rolled out for each property by the end of Q2 2025. Please note that timelines may change.
We recognize that adjusting to updates can take time, and we appreciate your patience and support during this transition! If you have any questions or concerns, our support team is ready to assist you.Â
Use the Payment Reconciliation report to compare the recorded income with the actual payments received and identify any discrepancies or errors in the financial records.
Access the Payment Reconciliation Report
- From the Main Menu
click on Classic reports
- Click on Daily Activity Reports
- Select Payment Reconciliation Report
Navigate the Payment Reconciliation Report
- Date Range: By default, it will show today’s date every time you access the report
-
Users: Displays their name and role
- Separate by User: Use the toggle to view all entries together or separately by user
- Export to: Download the report as a PDF/Excel.
 When your reports show that the user SYSTEM has taken action, it typically indicates that a super admin has manually made changes to a specific property, or that Cloudbeds PMS has automatically performed a scheduled task.
 This report uses the service date for all financial statistics, which is the date the product or service is delivered. With proper permission, the service date can be backdated to recognize revenue and expenses in the correct period. To learn the difference between the Service Date and the Transaction Date, click here.
After applying the filters, the table will show a list of reservations with the following fields:
- User
- Category: Payment methods
- Amount
 The payment methods are clickable and will take you to a transaction report with a detailed list of payments that compose that total. The payment methods vary between properties.
Find out more about them in our Payment Options section.
Why is my report different now?
As mentioned at the beginning of this article, we are upgrading our reporting suite capabilities, and this article reflects the latest report version. These are the key changes:Â
- The Transaction Date/Time is now immutable for rigorous accounting.
- The Service Date has been‬ added as an alterable date to support common associations. Now the report is‬ filterable by Service Date to meet common reporting needs. Its respective tooltip was added.
- Transaction data will be pulled from the new accounting service, which is more detailed and aligned with USALI‬ standards. Transactions are not mutable; reversals have equal and‬ opposite transactions.‬
- The Email option (Green button) is being removed. While this feature is no longer available, you can download the report as needed by clicking Export To (Blue button).
- We have implemented Accounting Codes to categorize‬ specific transactions following USALI standards:Â
This report splits payments by‬ category and user, but only pulls payment codes. They are bucketed as follows:
| Description | Code |
|---|---|
|
Payment
|
Â
|
Unlike other reports, the Payment Reconciliation Report does not show Accounting Codes.
Below are examples of the codes associated with the transactions:
Note: This report will be updated to use Night Audit ID filtering when it becomes‬ available.‬
 Some customers already have access to the new version of this report.
If you can't see the updated version, don't worry! The enhancements will be gradually rolled out for each property by the end of Q2 2025. For more information, visit this article.
Comments
Please sign in to leave a comment.