Reports

Open Balance Report

Understand all committed unpaid rental ledger charges, including past due, due today, and not-yet-due balances.

Overview

The Open Balance Report shows all committed unpaid rental ledger charges for active and future non-canceled rentals. It includes charges that are past due, due today, and not yet due.

Use this report when you want a complete receivables view of money still owed across the portfolio, not just balances that need immediate collection follow-up.

Open Balance Report page showing open balance, due now, not yet due, open charges, rentals, and open balance line items. — **Open Balance Report overview**Open Balance includes unpaid visible ledger charges, even when they are not due yet.

When To Use It

The Open Balance Report is useful for reviewing outstanding balances, future receivables, upcoming amounts due, and unpaid rental charges by renter and property.

Unlike the Past Due Report, it is not limited to delinquency. A charge can appear here before the renter is late.

What Counts As Open Balance

Open Balance is the remaining unpaid amount on visible rental ledger charges. It can include monthly rent, nightly stay balances, move-in charges, deposits, late fees, and other committed rental charges when they remain unpaid.

An open balance does not automatically mean the renter is late. Not-yet-due charges are included so landlords can see future receivables and upcoming expected collections.

Summary Metrics

Open Balance is the sum of Remaining Amount for all visible unpaid charges in the report.

Due Now is the portion of Open Balance for unpaid charges whose due date is today or earlier.

Not Yet Due is Open Balance minus Due Now.

Open Charges is the number of unpaid charge rows included in the report. Upcoming Charges is the number of those rows with a Not Yet Due status.

Rentals is the number of rentals represented by the open line items.

Open Balance Line Items

The Open Balance Line Items section shows each unpaid rental ledger charge. Each row includes renter, property, line item, due date, due status, expected amount, paid amount, waived amount, and remaining amount.

Use this section to trace portfolio totals back to individual renters, properties, and charge lines.

Open Balance Report line item table showing renter, property, line item, due date, status, expected, paid, waived, and remaining amounts. — **Open balance line items**Each row explains what was charged, what has been paid or waived, and what remains owed.

Formula

Expected Amount is the ledger charge original amount.

Paid Amount is the amount the rental ledger has applied to that charge.

Waived Amount is the amount forgiven through rental charge adjustments.

Remaining Amount = charge amount after waivers - paid amount.

Open Balance = sum of Remaining Amount for all visible unpaid charges.

Due Now = sum of Remaining Amount for charges due today or earlier.

Not Yet Due = Open Balance - Due Now.

Data Sources

The Open Balance Report is built from the Rental Ledger. The ledger is the source of truth for rental charges, payment allocation, waivers, refunds, due dates, open balance, and past due amount.

The report excludes canceled rentals from the normal balance action queue and includes active and future non-canceled rentals with visible unpaid charges.

Included Records

Committed unpaid rental ledger charges with a remaining amount.
Past due charges, charges due today, and charges that are not yet due.
Active and future non-canceled rentals.
Rental charges visible through the Open Balance report evaluation period.
Properties and rentals visible in the current company scope.

Excluded Records

Canceled rentals removed from normal balance action queues.
Charges that have been fully paid or fully waived.
Property expenses, because expenses are property-level records rather than renter charges.
Payments that do not apply to open ledger charges after refunds and allocation rules.

Open Balance Vs Past Due

Open Balance is a receivables view. It shows everything still owed on visible unpaid ledger charges, including future balances.

Past Due is a collections view. It shows only unpaid charges due today or earlier.

Use the Open Balance Report when you want to understand all money still owed. Use the Past Due Report when you need an action queue for collection follow-up.

Past Due ReportReview unpaid charges due today or earlier.

Common Use Cases

Review the total amount still owed across the portfolio.
Identify future receivables that are not due yet.
Confirm that expected rental charges have been generated correctly.
Trace a renter or property balance back to the exact unpaid ledger rows.
Compare Open Balance to Due Now to separate future balances from collection follow-up.

Things To Watch For

Open Balance can be larger than Due Now because it includes not-yet-due charges.
A rental can have an open balance without being delinquent.
Future monthly rent, nightly stay balances, deposits, and move-in charges can all appear if they are committed and unpaid.
If a balance looks wrong, review the Rental Ledger for charges, due dates, payments, refunds, waivers, and any opening balance used during import.

Export Options

The Open Balance Report supports CSV download, Excel download, and printable PDF-style browser export.

Exporting ReportsLearn how report exports work across CSV, Excel, and browser PDF-style output.

Common Questions

What is an Open Balance?It is the unpaid remaining amount on visible Rental Ledger charges.
Does the Open Balance Report include future charges?Yes. Not-yet-due committed charges are included when they are visible unpaid ledger charges.
Why is Open Balance larger than Due Now?Open Balance includes due and not-yet-due balances. Due Now includes only charges due today or earlier.
Does an open balance mean the renter is late?Not necessarily. Many open balances are not due yet.
What is the difference between Open Balance and Past Due?Open Balance includes all visible unpaid charges. Past Due includes only unpaid charges due today or earlier.

Last Updated

June 2026