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). A zero variance supports the amounts compared, but cannot establish completeness by itself. Equal duplicate debit and credit entries can leave ending cash unchanged; inspect transaction identity and source coverage as well.

Worked numerical example: Deconstructing a $13,000 tax-inclusive reconciliation

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

This invented example includes $1,200 agency tax inside the $13,000 guest collections, leaving $11,800 rent and cleaning revenue. Tax is assumed guest-imposed and platform-remitted; the direct booking has no tax in this scenario. Fees and settlement dates below are chosen inputs, not current provider terms. The host compares reservation summaries, payout breakdowns, and bank records:

In this reconciliation schedule:

1. Gross Revenue Verification: The books distinguish $11,800 rental revenue from $1,200 agency tax. Prepare a separate Form 1099-K reconciliation for the amounts actually reported and their adjustments.
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 amounts under the actual account terms 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

• Airbnb payout calculator and worked source-record example
• 1099-K reconciliation guide and downloadable annual workpaper
• Compare QuickBooks with a rental-focused monthly close

• 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

Sources and example scope

Claim-to-source mapping: Gross-payment reporting differences: IRS Understanding Your Form 1099-K; rental-income background: Publication 527. The equal-offset duplicate counterexample is arithmetic, not an IRS guarantee.

Editorial source review: September 8, 2026. The linked IRS publications support the rental-income, expense or classification topics identified in their link labels; Form 1099 instructions support payment reporting, not a rental tax outcome. Recheck the filing-year form and these sources when the year, law, provider terms or jurisdiction changes. Product approval history is separate; no professional tax review is claimed.

Numerical scenarios in this article are illustrative, not customer results or professional tax review. Source references support the stated topics; a preparer must apply the rules for the relevant year and facts. Product workflow descriptions are separate from tax determinations.

• IRS Publication 527: rental income, expenses, and personal use
• IRS: understanding Form 1099-K