The three-way reconciliation report ensures that your bank statement balance, your book balance, and your guest funds (liabilities) all align. This article helps you identify why your figures might not balance and provides steps to resolve discrepancies to keep your Guesty account accurate.
Learn how to access this and other Australia and New Zealand Accounting reports.
Troubleshooting an unbalanced report
If your three-way reconciliation report isn't balancing, several common factors could be the cause. Before investigating specific transactions, verify your general bank reconciliation status.
Verify bank reconciliation status
Ensure all previous work is finalized before running the report again.
Confirm all Bank Reconciliations show a "Submitted" status.
Check the bank reconciliation area for any "Review" or "Review Required" indicators.
Run the report again after confirming the statuses, ensuring the date range is correct.
Identifying discrepancies
When the three-way figures don't match, use the following checklist to locate the error.
Audit bank transactions
Check that the transactions recorded in Guesty match your physical bank activity.
Confirm all transactions moving in and out of your bank account are marked as "Received at bank."
Compare your bank statement to your Guesty records. If a transaction is selected (checkbox ticked) in Guesty but doesn't appear on your physical bank statement, untick it.
Verify your ending bank balance matches your actual bank statement balance exactly. For example, your balance on January 31, 2026, must be identical to the closing balance on your statement for that date.
Important:
Never manually calculate or adjust the bank ending balance. It must always match your actual bank statement ending balance.
Resolving the difference
Follow these steps to find and fix the specific amount that is causing the report to be out of balance.
Step by step:
Run the three-way reconciliation report again to see if recent changes brought it into balance.
Generate all associated financial reports if the figures still don't match.
Compare the figures from the three-way reconciliation report against individual Guesty reports to identify which specific category (Bank, Ledger, or Liabilities) contains the difference.
Match individual line items between reports to "marry up" the figures and isolate the discrepancy.
Cross-referencing reports to find discrepancies
When your three-way reconciliation report doesn't balance, you can isolate the error by comparing it to other specific Guesty reports. Use the table below to identify which reports should share the same totals.
Report comparison guide
| Three-way reconciliation report | Supporting Guesty report |
| Bank statement ending balance | Bank reconciliation |
| Adjustments | Bank reconciliation |
| Unreconciled deposits | Unpresented deposits detail |
| Unreconciled withdrawls | Unpresented cheques detail |
| Total of deposits | Journal (Check register) |
| Total of withdrawls | Journal (Check register) |
| Total of owner ledger | Monies held in trust > Owners |
| Total of advanced deposits (guest) | Monies held in trust > Advanced deposit |
| Total of accounts payables (vendors, PMC, taxes, channels | Monies held in trust > Advanced deposit |
Matching specific figures
Follow these steps to "marry up" the data between your reports.
Step by step:
Open your three-way reconciliation report and note the "Discrepancy" amount.
Generate a Trial Balance report for the same date range and filter it by the specific bank account.
Compare the "Cash Account" total in the Trial Balance to the "Book Balance" in your reconciliation report; these must be identical.
Generate a Guest Ledger report to view all funds held on behalf of guests or owners.
Check if the "Total Liabilities" on the Guest Ledger matches the "Guest Funds" section of your reconciliation report.
Look for the exact "Discrepancy" amount in your Bank Reconciliation area to see if a single transaction of that value remains "Pending" or "Unreconciled."
FAQs
What should I do if my bank balance is correct but the report is still off?
This usually indicates an issue with your book balance or guest liabilities. Review your Trial Balance and Guest Ledger reports for the same period to ensure all manual journal entries and guest payments are recorded correctly.