The 3-way-reconciliation must always be balanced. “Balanced” in this sense means that the same total amount is displayed in all three paragraphs. The report can only be run for the actual hotel day.
The three paragraphs are:
1. In-trust
2. In-payment and out-payment
3. Bank account summary