MB

Maui Books

RezStream Deposit Reconciliation

Before You Begin

Download these reports from RezStream

Export the following 4 reports for your desired date range, then upload them below.

  1. RESERVATIONS › Export Only — People Departing by Day (Revinate)
  2. RESERVATIONS › Departures Highlight & copy data into a Google Sheet, save as CSV
  3. PAYMENTS › Credit Card Transactions Highlight & copy data into a Google Sheet, save as CSV
  4. REVENUE ON DEPARTURE › Reservation Revenue Details (on Departure) Filter Type by POS
Files

Upload RezStream Reports

Click to add files or drag & drop

CSV, XLSX, XLS, and PDF — multiple batches OK

Period

Reporting Period

Select at least one file to continue.

Review & Verify

Check flagged items and link retail sales to deposits before finalizing.

!

Flagged Items

0

These items were automatically flagged for manual review.

Type Guest Amount Details
$

Retail & Desk Sales

0
How to review these items (click to collapse)

The items below are retail & desk sales from RezStream that were not automatically matched to a credit card transaction. Your job is to verify where the money for each sale was deposited.

1
Open the Cash Sales Holding Account in QuickBooks Look at deposits into this account for the same period. You are matching retail sales from RezStream to actual cash deposits in QB.
2
For each item below, choose the correct status: Cash deposit confirmed — You found a matching deposit in the cash holding account (check for batched deposits too). No deposit found — flag for follow-up — You cannot find a matching deposit anywhere. This item will be excluded from the journal entry so we can investigate it later.
3
Leave as “Pending review” if you haven’t checked yet Pending items are also excluded from the journal. Come back and update them before finalizing.

Bottom line: If a retail sale was deposited into the cash holding account → confirm it. If you can’t find the deposit → flag it. Anything unconfirmed stays out of the journal entry until resolved.

Date Guest / Description Category Amount Deposit Match

Reconciliation Dashboard

Adv. Deposits (New) $0.00
Adv. Deposits (Used) $0.00
Gross Rental $0.00
Owner Stays $0.00
Retail & Desk $0.00
Taxes (Total) $0.00
Refunds $0.00
Bank Deposit $0.00

Advanced Deposits (Used) — Guest Summary

Departure stays that consumed previously collected deposits.

Date Guest Unit Type Departure Total Less Non-Stay Less Multi-Unit Room/Owner Used Gross Rental TA Rate TA Tax CTA Tax GE Tax Owner

Advanced Deposits (New) — Guest Summary

Newly collected deposits from booking reservations.

Reservation Date Guest Note New Amount

Income by Unit Type

Room revenue split by Studio, 1 BR, 2 BR.

Unit TypeTotal Income
Total Unit Income $0.00

Owner Stays

Unit owners staying in their own condos — no tax collected.

OwnerUnitOwner CheckAmount

By Deposit Status

Retail & desk income grouped by how each sale was matched.

Booked to Journal $0.00

By Category

Retail & desk income grouped by item type.

Total Retail & Desk $0.00

Retail & Desk Detail

Date Guest / Description Category Amount Deposit Match

Tax Filing Summary

Monthly Hawaii tax filing figures (TA, CTA, GE).

Gross Rental Income$0.00
TA Tax Collected$0.00
CTA Tax Collected$0.00
GE Tax Collected$0.00
G45 Base Filing$0.00
G45 Exemption$0.00
TA Filing Number$0.00

Rate Breakdown

TA Tax$0.00
CTA Tax$0.00
GE Tax$0.00

Final Journal Entry

AccountDebitCredit

Annual Tax Summary

2026

Month-by-month tax filing numbers for the full year.