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

For each unlinked POS sale, verify the deposit method. Items left as “Pending review” will be excluded from the journal entry.

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.