Reconciliation

In double-entry bookkeeping, reconciliation is the rigorous process of comparing internal financial records against an authoritative external source—such as a bank statement, credit card ledger, or channel payout report—to prove that both sides agree. If the internal ledger and external source differ, reconciliation keeps that variance visible until the root cause is identified and corrected.

In the short-term rental industry, hosts often confuse categorization with reconciliation. Simply tagging a bank transaction as "Rental Income" or "Cleaning Expense" does not verify that the transaction was recorded in the correct amount, that no transactions were duplicated, or that expected reservation revenue actually settled into your bank account.

Direct Answer: What is three-way reconciliation in short-term rental bookkeeping? Three-way reconciliation is the accounting control that proves consistency across three separate data sources: (1) booking channel reservation records (gross rent, cleaning fees, and guest taxes), (2) channel payout statements (platform host fees, adjustments, and scheduled disbursements), and (3) bank account statements (cleared cash deposits). When all three sources balance to zero variance, your books substantiate every dollar of gross revenue reported on IRS Form 1099-K while validating that all cash arrived safely.

Worked numerical example: Deconstructing a $12,000 monthly reconciliation

To observe the distinction between mere categorization and genuine reconciliation, consider a host managing two short-term rental properties who receives $11,340 in net bank deposits across a single calendar month.

The host cross-examines their channel reservation summaries, platform payout breakdowns, and operating bank feed:

In this reconciliation schedule:

1. Gross Revenue Verification: The books record $13,000 in gross rental revenue, which matches the aggregate reservation volume and prepares the host for year-end Form 1099-K filings.
2. Fee Transparency: $490 in platform host commissions and merchant fees are isolated as deductible business operating expenses on IRS Form 1040 Schedule E Line 8.
3. Variance Identification: The $970 variance between scheduled payouts ($11,310) and cash received ($10,340) is not swept under the rug. It is identified as a timing lag on a direct booking via Stripe that settled on the 2nd day of the subsequent month.

Categorization vs. Reconciliation: The critical distinction

Relying solely on automated bank feed categorization creates serious structural vulnerabilities in property accounting:

Decision tree: Diagnosing reconciliation variances

When your bank statement ending balance and internal ledger do not agree at the end of the month, follow this diagnostic sequence:

Reconciliation Variance Detected
│
├─ Step 1: Check Statement Date Cutoffs
│  └─ Did your credit card or bank statement cycle end on a day other than the last day of the month?
│     ├─ YES: Reconcile through the exact statement closing date, not arbitrary calendar dates.
│     └─ NO: Proceed to Step 2.
│
├─ Step 2: Check for Outstanding Checks or Uncleared Deposits
│  └─ Are there checks written to contractors or cleaners that have not yet cleared the bank?
│     ├─ YES: Flag as "Outstanding Disbursements". Verify they clear in the subsequent statement.
│     └─ NO: Proceed to Step 3.
│
├─ Step 3: Check for Channel Payout In-Transit Timing
│  └─ Did a channel payout initiate on the 30th or 31st but clear the bank on the 2nd or 3rd?
│     ├─ YES: Document as "Deposit-in-Transit". Balance matches when timing item is acknowledged.
│     └─ NO: Proceed to Step 4.
│
└─ Step 4: Check for Duplicate Feeds or Merchant Holdbacks
   ├─ Did the bank feed import a transaction twice after a connection reset?
   │  └─ Remove the duplicate unconfirmed transaction.
   └─ Did a merchant processor (e.g., Stripe) place funds in a rolling reserve?
      └─ Record reserve hold as an Asset (Restricted Cash) rather than lost revenue.

Edge cases and common reconciliation traps

1. Credit card statement billing cycles vs calendar months

Credit card statements rarely close on the 30th or 31st of the month; they often close mid-month (e.g., the 17th). To maintain rigorous books, perform monthly closes based on calendar months (the 1st through the 31st) by reconciling cleared transactions against the bank feed, or maintain parallel reconciliations matching your lender statement cycle dates.

2. Merchant processing rolling reserves and chargebacks

Hosts who manage direct bookings through payment gateways like Stripe or Square may experience rolling reserves (where the gateway retains 5% to 10% of revenue for 90 days to cover potential chargebacks). If you record the net bank payout as total revenue, you understate gross income. You must record 100% of the gross booking, record the processing fee, and post the withheld reserve to a dedicated asset account titled Merchant Clearing Account.

3. Batched multi-unit deposits

When Airbnb or Vrbo initiates payouts for three guests departing on the same weekend across multiple properties, the bank statement records a single lump sum. Attempting to reconcile this single deposit against multiple properties without decomposing the individual reservation line items distorts property-level profitability. Each reservation must be split out before reconciling the aggregate total.

Reviewing reconciliation with Roxby

Manually cross-referencing CSV exports from Airbnb, Vrbo, and your bank is prone to human error and consumes dozens of hours every quarter.

Roxby imports supported official payout statements and connects supported bank and card accounts through Plaid. The monthly close presents source-linked records for review and keeps unresolved differences visible. Reviewed property records feed financial reporting and supported accountant exports; Roxby does not claim direct channel-account access or automatic universal matching.

This article provides educational guidance for accounting and recordkeeping workflows and does not constitute tax, legal, or professional financial advice. Consult a licensed CPA or tax attorney for specific tax determinations.

Related guides and resources

• Why short-term rental payouts require reconciliation
• The monthly close for short-term rentals
• How to reconcile Airbnb gross earnings vs net payouts
• Reconciling Vrbo payouts and processing fees