Clearing’s “Booking Reconciliation” feature ensures financial accuracy by comparing expected payouts from bookings with actual bank deposits. This is crucial for generating precise owner statements and allows property managers to filter reports to meet their information needs, ensuring accurate financial reporting.
With the “Booking Reconciliation” Report, you can:
✅ Track booking deposit status
✅ Verify transactions match booking financials
✅ Apply reconciliation aggregation across different considerations
This report allows you to filter by asset, owner, and channel, giving property managers a clear view of outstanding receivables and confirming that bookings are fully paid as expected. Instead of relying solely on Property Management System (PMS) data, Clearing ensures that actual bank deposits serve as the source of truth—reducing the risk of financial discrepancies.
This is critical for trust accounting compliance, as revenue miscalculations can lead to incorrect owner payouts, potentially pulling funds from the wrong owner, causing account imbalances and financial risks.
Your customizable “Booking Reconciliation” dashboard supports partial payments, full payments, over-collections, and unpaid bookings, giving you a real-time snapshot of your financial health. You can also export this data as a .CSV file for further analysis and collaboration.
Follow the steps below to streamline your reconciliation process and get a clearer financial picture using Clearing.
Step 1: Navigate to the Reporting Section
Log into your Clearing account.
From the main dashboard, click on “Reporting” in the navigation menu.
Select “Booking Reconciliation” from the available reporting options.
Step 2: Set Your Date Range Filters
Choose the date range for the reconciliation process. Most users select the previous month when reviewing bookings for their current owner statements.
There are also quick access filters for “last month” and “current month.” Ensure that the selected time frame covers the period you want to verify.
Step 3: Apply Additional Filters for Further Customization
You can refine your search by applying filters to focus on specific criteria, as listed below. Simply click on the “add filters” funnel.
Step: 3.1: Browse and Select Filter Categories
Once you have opened the filters, you can select the relevant filters from the list below:
Asset (e.g., property)
Owner
Booking Channel (e.g., Airbnb, Vrbo)
Booking Status
You can combine multiple filters to further refine your data of concern.
Step 3.2: Save Commonly Used Filters for Future Access
If you frequently use the same filter settings, you can save them for quick access by clicking on “save current filters” in blue text. To visit these again, simply click “open saved filters” and select the filter of interest.
Step 4: Generate the Reconciliation Report
Now you’re ready to generate your reconciliation report, customized to your unique criteria. Click on the “Generate” button.
Once Clearing pulls in all relevant booking and transaction data, it automatically compares expected payouts with actual deposits, giving you a clear view of what’s expected versus what has landed in your bank account. This ensures you’re always working with accurate financial data and that all anticipated funds are collected.
If there’s a discrepancy and you don’t expect additional payments, adjust your booking financials to reflect the true deposited amount, ensuring alignment with your financial source of truth—your bank account transactions.
If you expect more funds to arrive, but they haven’t yet, you can delay the recognized date on the booking to a future month, allowing time for the deposit to clear before processing the owner payout.
Tip: Always ensure all funds have been collected before paying out an owner. Failing to do so can result in miscalculated owner payments and trust account imbalances, posing financial and compliance risks.
Step 5: Adjust Aggregation Levels
You can customize how the data is displayed by selecting different aggregation levels:
By Booking – View reconciliation details for individual bookings.
By Owner – Summarize balances by owner.
By Asset – Group transactions by property.
By Channel – See results based on the booking channel.
By Status (default) – Organize bookings based on reconciliation status.
Tip: Most users prefer viewing by booking to ensure all bookings have been fully paid before generating owner statements.
Step 6: How to Interpret the Reconciliation Status Colours
On the far right, you’ll see a colour coded circle indicating the status of the reconciliation.
The colours indicate the following:
Green — Full in bank. The expected payout matches the actual deposit. You’re good to go!
Yellow — Partial in Bank. Indicates partial payment or discrepancies (e.g., more collected than expected or not enough collected).
Red — No Match Found. The system couldn’t find a corresponding bank deposit. This indicates no payment has been made yet, the funds have not been matched to a booking accurately, or manual matching may be required as the booking was paid outside the payment processing system (cash, for example).
If discrepancies exist, and the funds have been fully collected, you can adjust booking financials to align with the actual bank deposit, as the bank account should be used as the source of truth.
Related Articles: To learn more about adjusting booking financials in Clearing, check out our step-by-step guide here. Also, if these are changes that happen every time a booking meets a specific criteria, try setting up a “Rule”, “On Bookings”, to deal with this automatically.
Step 7: Filter by Reconciliation Status from the Report
Once a report is generated, you can further breakdown financials by using the “reconciliation status” filter.
This filter allows you to categorize a report by the following designations:
Partial in Bank
Full in Bank
No Match Found
Collected More
Marked as Paid
Step 8: View Reconciliation Status from the Booking
Another way to view the reconciliation status is to go directly to the “Bookings” tab on the lefthand ribbon. If you want to check reconciliation details for a specific booking, you can easily do that here.
First, enter a date range to find relevant bookings. Be sure to apply filters here to further refine your search.
On the far right, click “Open” to open the booking and view the details associated with it.
From here, you will be able to view the booking financials, and the transaction financials in one place!
By scrolling down, you’ll also be able to see the reconciliation details to ensure the expected payout matches the actual bank deposit. Once matched, the reconciliation status updates to “Full in Bank”, but the other colours explained above are also shown here as seen below - the partial payment on this booking.
Step 8: Export Your Reconciliation Data
Share your reconciliation data with the whole team or export for further analysis by clicking on the “Export to Excel” function.
Mission Accomplished!
Your booking reconciliation report is ready to launch — in a fraction of the time you once spent on spreadsheets and using generic accounting software.
By utilizing Clearing’s booking reconciliation feature, you can ensure financial accuracy, streamline bank deposit and booking financial matching, and maintain transparent records for owner statements and owner payouts.
Make a booking reconciliation a routine part of your financial monthly workflow and stay ahead of potential issues, ensure accuracy and compliance, and keep your records clean.
If you need assistance, Clearing’s support team is always ready to help!
Looking to reconcile booking revenue and bank deposits? Check out our follow-up guide on How to Reconcile Bookings Revenue with Bank Deposits in Clearing.
If you’d like to explore further tips and tricks for automating financial reporting in the Short-Term Rental space, check out Expert Tips for Automating Short-Term Rental Financial Reporting.
Contact us for a personalized demo and learn how to manage recurring transactions in Clearing.
Already a Clearing customer? Explore our comprehensive knowledge base and dive deep into Clearing's features to embark on a journey towards revolutionize your financial management experience.
Clearing is a Financial Technology Company, not a bank.