> ## Documentation Index
> Fetch the complete documentation index at: https://www.carstoragesoftware.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Read the rent roll

> Understand the Recurring revenue report: MRR, Anticipated, Collected, and Occupancy, the Cash and Accrual views, row modes, filters, columns, and export.

The recurring revenue report, usually called the rent roll, lists every recurring plan with its rate, vehicle, spot, and payment method, and totals what the plans bring in for a date range. Open it from **Report** on [Recurring invoices](https://www.carstoragesoftware.com/dashboard/payments/recurring) ([open in app](https://www.carstoragesoftware.com/dashboard/payments/recurring/report)). On a phone, **Report** is an icon at the top of that page.

![Recurring revenue report on the Accrual basis with MRR, Anticipated, Collected, and Occupancy tiles, a Cash and Accrual switch, and a table of three plans](https://mintcdn.com/carstoragesoftware/Ee8_kEDK9VFGnKsI/images/reports/read-the-rent-roll-accrual.webp?fit=max\&auto=format\&n=Ee8_kEDK9VFGnKsI\&q=85\&s=38da6871561a5ec6288fbb16fb5c600c)

## The four tiles

| Tile | How it is worked out |
| - | - |
| **MRR** | Monthly recurring revenue: each **active** or **trialing** plan's price, converted to one month (a yearly price divided by 12, a quarterly price divided by 3, weekly times 52 divided by 12), after any plan discount you have tracked. It is before tax and processing fees and does not depend on the date range. |
| **Anticipated** | What the plans are expected to invoice in the range, using each plan's full per-period total (subtotal plus estimated tax plus processing fee). Active and trialing plans only. See Cash and Accrual below. |
| **Collected** | Rent actually paid on the plans' invoices. The detail line shows it as a percent of **Anticipated**. "Add to next bill" add-ons that ride on a renewal invoice are not counted as rent. |
| **Occupancy** | Economic occupancy, not a count of cars: your actual monthly rent on products that have a capacity, divided by what full capacity would bring at the current list price. "3 of 10 units" is plans over capacity. It reads **Not set up** until a product has a **Total capacity** (set it under **Capacity** on the product in [Products & services](https://www.carstoragesoftware.com/docs/payments/manage-products-and-services.md)). |

Occupancy uses each plan's contract rate against today's list price, so a plan sold at a discount lowers it even when every unit is full.

## Cash and accrual

The **Cash / Accrual** switch (top right) changes how **Anticipated** and **Collected** are counted. **MRR** and **Occupancy** do not change. The app remembers your choice in this browser.

| | **Cash** | **Accrual** |
| - | - | - |
| **Anticipated** reads | **Billed in range** | **Earned in range** |
| Idea | A charge counts in full on the day it is billed, like money landing in the bank. | A charge is spread evenly over the days it pays for. Only the days inside your range count. |
| **Anticipated** | Number of billing dates in the range times the per-period total. | For each billing period, the per-period total times the share of that period that falls in the range. |
| **Collected** | Invoices paid in the range, counted in full. | Paid invoices spread over the service period each line covers, even if the payment was made earlier. |

A worked example: a plan bills \$931.64 on Nov 20 for the month to Dec 20.

* **Cash**, range Nov 1 to Nov 30: the Nov 20 billing is in range, so **Anticipated** is \$931.64.
* **Accrual**, same range: Nov 20 to Nov 30 is about 10 of the plan's 30 days, so **Anticipated** is about \$311.
* **Accrual**, range Dec 1 to Dec 31: the plan still earns the days from Dec 1 to Dec 20 from that same charge, while the Dec 20 charge earns its first days.

This matters most for quarterly and yearly plans. A $12,000 yearly plan billed in January is $12,000 in January on **Cash** and $0 in every other month. On **Accrual** it is about $1,000 each month, so each month matches your books. Accrual also handles billing dates that fall on the 29th to 31st (a plan that bills on the 31st stays on the 31st instead of drifting), trials (nothing is earned before the trial ends), and cancellations (nothing is earned for periods that start after the cancel date).

Notes on both bases:

* A plan counts when it was created before the end of the range and was not canceled before the start.
* **Anticipated** includes an estimate of tax and processing fee, so it can be higher than what a customer is actually charged if tax or fees are not set up. **Collected** is rent only, which is why it can read a few percent lower.
* Dates and day boundaries use your facility's time zone.

## Rows, filters, and sorting

* **Rows** (next to **Columns**): **Per subscription** is one row per plan. **Per line item** splits plans that have several products into one row per product. **Per car** gives one row per vehicle, the classic rent roll. A line covering two cars becomes two rows with its amounts split evenly, and units with no car linked show **Unassigned**.
* **Filters** has a **Date** range (**Month to date**, **This month**, **Last month**, **Next month**, **Last 3 months**, **Year to date**, **Custom**) and a filter for every column: tick values to include for text columns, or set a minimum and maximum for money and number columns. Hidden columns can still be filtered. Click **Apply filters**; **Reset** clears them.
* With column filters on, the tiles and the **Total** row recalculate for the rows left.
* The last row of the table shows the **Total (active only)**. Open its menu to switch to **Average**.
* Click a header to sort. Hover the info icon on a header for its definition.

## Columns

Use **Columns** to hide, show, or reorder. The saved layout also drives the export.

| Column | Meaning | |
| - | - | - |
| **Customer**, **Customer Email** | Company name if set, otherwise the person's name. | |
| **Product**, **Price Tier** | The recurring product and its price name. | |
| **Vehicle**, **Parking spot** | Linked cars (several show as "A | B") and where the car is today: its active spot assignment, then the spot on the car record, then the zone. |
| **Status** | **Active**, **Trial**, **Past due**, **Canceling** (ends at period end), **Canceled**, **Paused**, and so on. | |
| **Billing Interval** | Monthly, yearly, and so on. | |
| **Recurring line**, **Unit Price**, **Quantity** | The Stripe line (unit price times quantity) and its parts. | |
| **Subtotal**, **Tax**, **Processing Fee**, **Invoice Total** | One billing period before tax and fees, the estimated tax, the estimated pass-through fee (zero for cash, check, and invoice plans), and the sum. | |
| **Anticipated**, **Collected** | Follow the Cash or Accrual switch. | |
| **Monthly Equiv.**, **Annual Equiv.** | Monthly price, and monthly times 12. | |
| **Start Date** | When the plan was created, not necessarily the first invoice. | |
| **Next rate anniversary**, **Rate anniversary (anchor)** | The yearly date for reviewing the rate, and the fixed month and day it repeats on. | |
| **Current Period Start/End**, **Trial End**, **Canceled At** | Billing-period and lifecycle dates. | |
| **VIN**, **License Plate**, **Payment Method** | From the linked car, and how the plan is expected to be paid: **Card**, **Bank**, **Cash**, **Check**, **Invoice**, or **No payment method**. | |

## Export

Click **Export** (top right) for an Excel file named `recurring-revenue-report-<cash or accrual>-<start>-to-<end>.xlsx` with one sheet, **Recurring Revenue**.

* It has the rows shown (after filters, in the current row mode) and your visible columns, using the Cash or Accrual figures you have selected.
* Under the table it adds **Revenue Basis**, **Anticipated Revenue**, **Collected Revenue**, **Economic Occupancy**, **Current Street-Rate Monthly Capacity**, **Total Active Monthly Recurring Revenue**, **Average Active Monthly Recurring Revenue**, **Active Recurring Payments**, and **Total Recurring Payments**.
* Money is written as formatted text such as `$895.00`, so convert it before summing in Excel.

## Troubleshooting

**Occupancy shows "—" and "Not set up".** No recurring product has a **Total capacity**. Set one on the product.

**A plan I expected is missing.** It was created after the range ended, or canceled before it began. Widen the date range.

## Related

* [Review billing reports](https://www.carstoragesoftware.com/docs/payments/review-billing-reports.md)
* [Read the invoice report](https://www.carstoragesoftware.com/docs/reports/read-the-invoice-report.md)
* [Set up recurring billing](https://www.carstoragesoftware.com/docs/payments/set-up-recurring-billing.md)
* [Billing concepts](https://www.carstoragesoftware.com/docs/concepts/billing.md)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.