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.
FAQ
Why does this report use Service Date instead of Transaction Date?
The report uses Service Date as a filterable date to support common reporting needs. The Transaction Date/Time remains immutable to ensure accurate accounting.
How is transaction data handled in the Payment Reconciliation Report?
Transaction data is pulled from the accounting service, which provides detailed transaction-level records aligned with USALI standards. Transactions are not editable, and reversals are recorded as equal and opposite transactions.
Can I email the Payment Reconciliation Report automatically?
Automatic emailing is not available for this report. The Payment Reconciliation Report can be downloaded using the Export To option and shared as needed.
What are Accounting Codes and how do they apply to this report?
Accounting Codes categorize specific transactions following USALI standards. This report uses accounting codes to organize transaction data, but the codes are not displayed within the Payment Reconciliation Report.
In this report, payment-related transactions are bucketed as follows:
| Description | Code |
|---|---|
|
Payment
|
|
Below is an example of the accounting codes associated with the transactions:
Comments
Please sign in to leave a comment.