Page 1 of 1
Daily Reconciliation
Posted: Thu Jun 25, 2020 12:41 pm
by antoniochiarotti
Hello there,
I am looking to create a custom report to check the daily financial discrepancies between the charges and the payment.
what would it be the best way to achieve this?
Many thanks in advance
Re: Daily Reconciliation
Posted: Mon Jun 29, 2020 1:10 pm
by iuri_rosa
Hello
When you go to Reports > Custom Reports you can setup a custom report to shows you the required information.
Let me give you an example to show all bookings with a positive or negative invoice balance so that you can identify the discrepancy.
Lets check all bookings made between 1 June and 29 June 2020.
Check In From = Any Date
Check In To = Any Date
Check Out From = Any Date
Check Out To = Any Date
Booking Date From = 1 June 2020
Booking Date To = 29 June 2020
Invoice Balance = Not Zero
Now drag and drop from the "Available Columns" into the "Show Columns".
-Booking Ref
-Invoice Payment Value
-Invoice Charges Value
-Invoice Balance Value
This should generate a report for you to see the discrepancies.
Best Regards,
Iuri Rosa