Hotel Accounting Reconciliation Guide
This guide provides a structured approach for hotel accounting teams to reconcile payments processed through Smarthotel, Adyen, and related systems. By following the steps below, you can ensure accurate financial reporting, streamlined workflows, and full visibility into payment flows.
1. Daily / Operational Tracking
- Reports in OPS
Use OPS reports to validate daily transactions (payments, refunds, and adjustments) against your PMS postings.
- Confirm each booking has a corresponding payment entry.
- Flag discrepancies such as failed transactions, duplicates, or timing mismatches.
- Reports from the Online Payment Studio
Access detailed breakdowns of payments for further validation.
Purpose: Establish what should have happened each day.
2. Monthly Settlement Overview
- Adyen Monthly Statement
Reconcile OPS daily totals with Adyen’s monthly settlement reports.
- Identify and track payment fees, chargebacks, or withheld amounts.
- Smartpayment Invoices
Compare Adyen fees with Smartpayment invoices.
- Ensure fees are correctly posted under payment processing expenses in your P&L.
Purpose: Confirm what was processed and what it cost.
3. Reserves & Adjustments
- Adyen Reserve & Reserve Adjustments
Adyen may hold back a portion of funds as a risk buffer.
- Track reserve movements monthly.
- Record adjustments clearly in your accounting.
Purpose: Ensure reserves are transparently monitored and accounted for.
4. Cash Flow Matching
- Balance Transfers
Compare Adyen’s balance transfer records with your bank account deposits.
- Track timing differences (e.g., weekend or holiday delays).
- Confirm that all funds processed are received.
- Bank Account Reconciliation
Final verification step: ensure general ledger postings align with bank statements.
Purpose: Confirm what was actually received in cash flow.
5. Reconciliation Workflow
- Daily → OPS Reports vs. PMS postings (transaction-level).
- Monthly → OPS totals vs. Adyen Monthly Statement (settlement-level).
- Monthly → Adyen Statement vs. Smartpayment Invoice (fees & costs).
- Ongoing → Track Adyen Reserve & Adjustments (balance sheet).
- Weekly/Monthly → Balance Transfers vs. Bank account (cash flow).
Key Takeaways
- OPS reports define what should have occurred.
- Adyen statements confirm what was processed.
- Smartpayment invoices clarify fees and costs.
- Balance transfers and bank statements confirm final receipt of funds.
- Reserves must be monitored as part of risk and liquidity management.