How to Use Clearing’s Booking Reconciliation Advanced Report

📽️ Videos

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.

Log into your Clearing account.

From the main dashboard, click on “Reporting” in the navigation menu.

Select “Booking Reconciliation” from the available reporting options.

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.

You can refine your search by applying filters to focus on specific criteria, as listed below. Simply click on the “add filters” funnel.

Once you have opened the filters, you can select the relevant filters from the list below:

You can combine multiple filters to further refine your data of concern.

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.

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.

You can customize how the data is displayed by selecting different aggregation levels:

On the far right, you’ll see a colour coded circle indicating the status of the reconciliation.

The colours indicate the following:

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.

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:

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.

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!

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.