The User Reconciliation report details user financial transactions linked to guest activities like restaurant consumption, additional services, and taxes.
Access the User Reconciliation Report
- From the Main Menu
click on Classic reports
- Go to Daily Activity Reports
- Select User Reconciliation Report
Navigate the User Reconciliation Report
- When you open the report, you can filter by Date Range and User(s).
- The system will show the information regarding debit and credit transactions related to the specific user on the selected dates.
Items and Services
Add-Ons
Taxes
Fees
Bank Transfer
PayPal
Cash
Check
Debit Card
Direct Bill
Other custom payment methods
- Export to: Download the report as a PDF/Excel.
- Debit and credits are clickable and will redirect 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.
- 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.
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 User Reconciliation Report?
Transaction data is pulled from the accounting service, which provides detailed transaction-level records aligned with USALI standards. Transactions are not editable; changes are recorded through equal and opposite reversal entries.
Can I email the User Reconciliation Report automatically?
Automatic emailing is not available for this report. The User 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.
In this report, transactions are grouped into predefined accounting buckets as shown below.
| Description | Code |
| Room Rate | 1000 + 1000R + 1000V |
| Room Revenue | 1100 + 1100R + 1100V + 1200 + 1200R + 1200V |
| Items & Services | 2000 + 2000R + 2000V |
| Add-On | 3000 + 3000R + 3000V |
| Custom Item | 4000 + 4000R + 4000V |
| Cancellation | 5000A + 5000 + 5000R + 5000V |
| Deposit Transfer | 6000 |
| Accounts Receivable Ledger Transfer | 7000 |
| Tax | 8000 + 8000R + 8000V + 8000A |
| Fee | 8100 + 8100R + 8100V + 8100A |
| Payment | 9000 + 9000R + 9000V + 9100 + 9100R + 9100V + 9200 + 9200R + 9200V + 9300 + 9300R + 9300V |
| Refund | 9000A + 9100A + 9200A + 9300A |
| Dispute | |
| Adjustment | 1000A + 1100A + 1200A + 2000A + 3000A + 4000A |
The User Reconciliation Report does not display Accounting Codes.
Below is an example of the codes associated with the transactions:
Comments
Please sign in to leave a comment.