Hotel Monthly Closing: A Direct Booking and OTA Checklist
Main topic: A hotel period-end checklist for finalising reconciliations, adjustments and exceptions before reports are approved.
Complete foundation: Hotel and Villa Accounting: A Hospitality Finance Systems Guide.
Continue as needed: OTA Reconciliation for Hotels and Villas in Bali: From Booking to General Ledger, Hotel Chart of Accounts: Structure for Hotels and Villa Management.
Assistance is available through hospitality bookkeeping and accounting services.
Hotel monthly closing involves more than preparing a month-end income statement. For hotels receiving direct bookings and OTA reservations, the close must make bookings, payments, deposits, refunds, settlements, bank movements and general ledger entries traceable before locking the period.
If the PMS shows IDR 1 billion of revenue while the bank, OTA settlements and ledger show different figures, finance should not force them all to agree. Its task is to explain why they differ, which transactions remain unfinished and which entries are still needed.
Hotel Monthly Closing for Direct Booking and OTA: What Must Be Completed?
A traceable close follows this sequence:
PMS/reservations → direct booking + OTA → deposits/payments/settlements → bank → refunds/cancellations → general ledger → financial statements → tax working papers → sign-off.
Lock the cut-off and source files first
Before matching begins, set the cut-off date and retain snapshots of the source files used. At minimum, these may include:
- PMS or reservation reports.
- Direct booking reports.
- OTA transaction and settlement reports.
- Payment gateway or merchant reports.
- The deposit ledger.
- Refund and cancellation reports.
- Bank accounts.
- The general ledger and trial balance.
Do not replace source files during closing without version control. If a booking status changes after cut-off, retain the revision as a new file and document the reason.
Direct bookings and OTAs need different matching trails
Direct bookings are usually traced through:
Reservation ID → folio → deposit/final payment → payment reference → bank → journal entry.
OTAs have an additional layer:
Reservation ID → OTA transaction → gross booking → fee/refund/adjustment → settlement → bank → journal entry.
The OTA Reconciliation for Hotels and Villas article explains the OTA trail in detail. At monthly closing, its results are combined with direct bookings and other channels before reviewing final revenue.
Scope of Hotel Monthly Closing
Monthly closing services can be structured around these deliverables:
| Close Area | Work | Expected Output |
|---|---|---|
| PMS revenue | Match room and outlet revenue, adjustments and reservation statuses. | Period revenue control. |
| Direct booking | Match bookings, deposits, final payments, refunds and bank receipts. | Direct booking reconciliation. |
| OTA | Match bookings, commissions, refunds, settlements and bank receipts. | OTA settlement bridge. |
| Payments | Match cards, payment gateways, transfers and cash. | Matched and unmatched receipt list. |
| Deposits | Roll forward opening balances, receipts, applications, refunds and closing balances. | Deposit schedule. |
| Bank | Reconcile material receipts and payments. | Bank reconciliation. |
| General ledger | Match revenue, deposits, receivables, fees and clearing accounts. | Revenue-to-GL bridge. |
| Tax | Connect final figures to the relevant working papers. | More traceable reporting data. |
| Sign-off | Review outstanding items and final entries. | Close pack and period status. |
This is an example service scope rather than a mandatory regulatory format. Each hotel’s systems, chart of accounts, channel count and operating structure may differ.
Usman Tax Hotel Tax Reporting Services includes reconciling hotel operational reports with tax reports, allowing monthly closing outputs to become more structured filing data. On the accounting side, Usman Tax Accounting Services includes bookkeeping, transaction recording and financial statement preparation that can form part of period-end closing.
Close Control Matrix for Direct Booking and OTA
Give each exception a status before sign-off. Example internal controls:
| Status | Example | Action |
|---|---|---|
| Matched | Booking, settlement/payment, bank and entry agree. | Close the item. |
| Timing difference | Month-end check-out, with bank receipt the following month. | Record as a cut-off item. |
| Pending settlement | OTA booking completed but payout not received. | Monitor subsequent settlement. |
| Unmatched receipt | Funds received but reservation ID not found. | Investigate before classification. |
| Open deposit | Deposit received for a future-period booking. | Reconcile to the deposit ledger. |
| Refund not reversed | Money refunded but the entry not adjusted. | Post a reversal after review. |
| Unposted journal | Reconciliation completed but the GL not updated. | Complete the entry before sign-off. |
A close is therefore assessed on more than whether the trial balance balances. Finance must know which items remain open and whether they affect revenue, cash, deposits or tax liabilities.
Direct booking: deposits, payment references and refunds
Direct bookings need strong reservation-to-cash controls because payments may arrive by manual transfer, payment gateway, card, cash or a combination.
Finance needs a reservation reference for every payment. An unidentified receipt should not immediately become revenue before its source is established.
Reconcile deposits through a roll-forward:
Opening balance + new deposits − deposits applied − refunds = closing balance.
This formula is an internal accounting control. Transaction treatment still follows the booking facts, folio and hotel policies.
OTA: gross bookings, fees, settlements and bank receipts
Do not close an OTA month based solely on net bank receipts. Separate gross bookings, commissions or fees, refunds, cancellations, adjustments, settlements and bank receipts.
If a settlement contains many reservation IDs, prepare a batch reconciliation rather than forcing one booking to equal one bank transaction.
The Revenue Bridge from PMS to General Ledger
Once direct booking and OTA reconciliations are complete, combine all channels in a revenue bridge.
Example structure:
PMS room revenue + outlet revenue ± valid adjustments → total operational revenue → chart of accounts mapping → general ledger → financial statements.
Categorise differences instead of posting them all to other adjustments. Use categories such as timing difference, unmatched booking, duplicate posting, refund pending, settlement pending or mapping error.
The purpose of monthly closing is to show management the final figures and the exceptions that remain unresolved.
Monthly Closing and Hotel PBJT Data
Monthly closing is not itself tax filing, but its quality affects the data used in tax working papers.
Under Government Regulation 35 of 2023, PBJT on hospitality services is a regency/city tax collected on a taxpayer self-assessment basis.
The same regulation specifies that the hospitality PBJT tax base is the amount paid to the hospitality service provider.
Do not automatically use total bank credits or net OTA settlements as the PBJT amount. First distinguish guest payments, deposits, internal transfers, refunds, loans, settlements and other transactions.
Rates, forms, deadlines and filing channels must follow the rules of the regency or city where the hotel is located.
Data Needed to Get Started
Hotels building a more structured monthly close should prepare:
- PMS and reservation reports.
- Direct booking reports.
- OTA transaction and settlement reports.
- OTA commission reports.
- Payment gateway or merchant settlements.
- Bank statements.
- The deposit ledger.
- Refund/cancellation reports.
- POS records where a restaurant or outlet operates.
- Accounts receivable and payable schedules, where relevant.
- The general ledger.
- The trial balance.
- The chart of accounts.
- Previous-period tax working papers.
Hotels do not all need the same software. What matters is that data can be exported, mapped and traced across systems.
Hotels Suited to Monthly Closing Services
This service is relevant to hotels that:
- Have direct bookings and several OTAs.
- Use more than one payment method.
- Frequently have open deposits.
- Have many refunds, cancellations or no-shows.
- Find differences between the PMS, bank or general ledger.
- Have many unmatched receipts.
- Take too long to close because reconciliation only begins at month-end.
- Need more consistent financial statements before using the data for tax reporting.
If the main requirement concerns one OTA channel, the OTA reconciliation article can be a starting point. If problems cover all channels and the financial close, a monthly closing scope is more appropriate.
Scope Limits and Work Needing Separate Review
Monthly closing does not automatically include all tax or assurance work.
Separate review may be needed for:
- Previous-period amended tax returns.
- SP2DK enquiries or tax audits.
- Operator or related-party transactions.
- Management fees and cross-border transactions.
- Multi-property consolidation.
- Major chart of accounts changes.
- Financial statement audits.
- Acquisitions or due diligence.
For broader hotel tax requirements, the Bali Hotel Tax Reporting Services page provides a next step.
Conclusion
Effective hotel monthly closing for direct booking and OTA should produce more than an income statement. Finance needs a trail showing how reservations, deposits, payments, settlements, refunds, bank movements and the general ledger form the period-end figures.
Direct bookings require reservation-to-payment matching; OTAs require reservation-to-settlement matching. Both are combined through bank reconciliation and a revenue-to-GL bridge before close sign-off.
This lets management see the month-end figures, the remaining exceptions and which data is stable enough for financial statements and tax working papers.
Does Hotel Monthly Closing Still Leave PMS, OTA and Bank Differences?
If the team searches every month-end for differences between direct bookings, OTA settlements, deposits, bank accounts and the general ledger, build a consistent close workflow and exception list from month to month.
Usman Tax provides accounting services and hotel tax reporting services for Bali hospitality businesses. Consultation can address monthly closing scope, multi-channel reconciliation, data readiness and the relationship between operational reports, bookkeeping and tax reporting.
Read Also: Hotel and Villa Accounting: A Hospitality Finance Systems Guide
FAQ Hotel Monthly Closing for Direct Booking and OTA
What is hotel monthly closing?
It closes an accounting period by reconciling revenue, bookings, payments, bank movements, deposits, receivables, liabilities and ledger accounts before that period’s financial statements are considered final.
How does monthly closing differ from OTA reconciliation?
OTA reconciliation focuses on platform transactions from booking to settlement and bank. Monthly closing covers OTAs plus direct bookings, payments, deposits, bank accounts, the general ledger, balance sheet, journals and sign-off for the entire period.
Do direct bookings need separate reconciliation?
Yes. They often use multiple payment methods without one standard settlement report. Link reservation IDs to folios, deposits or final payments, payment references, bank movements and journal entries.
Is net OTA settlement the hotel’s monthly revenue?
Not automatically. It may reflect commissions, refunds, cancellations, adjustments or payout timing. Reconcile revenue using the relevant transactions and records.
What happens to guest deposits at monthly closing?
Reconcile opening balances, new deposits, booking applications, refunds and closing balances. Accounting treatment still follows the transaction facts and the status of obligations to guests.
Is every bank receipt used to calculate PBJT?
Not automatically. Bank accounts may include receipts unrelated to hospitality services, such as internal transfers or other transactions. Identify the substance of each receipt before using it in tax working papers.
What is the most important data for starting monthly closing?
PMS, direct booking reports, OTA reports, settlement/payment gateway records, bank accounts, deposit and refund reports, POS where applicable, the general ledger, trial balance and chart of accounts are the main sources usually needed.
Does Usman Tax provide services relevant to hotel monthly closing?
Yes. Its Accounting Services includes bookkeeping and financial statement preparation, while Hotel Tax Reporting Services includes reconciling operational and tax reports. The actual scope needs to reflect the hotel’s systems and transactions.
