> ## 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 invoice report

> See what you billed, collected, and are still owed in a date range, how each total is worked out, and what the Excel export contains.

The invoice report lists every customer invoice and vendor bill created in a date range, with five totals above the table. Open it from **Report** on [Invoices & quotes](https://www.carstoragesoftware.com/dashboard/payments/invoices) ([open in app](https://www.carstoragesoftware.com/dashboard/payments/invoices/report)). On a phone, **Report** is an icon at the top of that page. It needs Payments access and connected [payment processing](https://www.carstoragesoftware.com/docs/settings/connect-payment-processing.md).

![Invoice report with Invoiced, Collected, Outstanding, Overdue, and Payables tiles, Filters and Columns buttons, and a table of customer invoices and one vendor bill](https://mintcdn.com/carstoragesoftware/Ee8_kEDK9VFGnKsI/images/reports/read-the-invoice-report-overview.webp?fit=max\&auto=format\&n=Ee8_kEDK9VFGnKsI\&q=85\&s=dcfd71865901d714cf0fb1d3eeb0962e)

## How the totals are worked out

The range filters by the date an invoice was **created**, not the date it was paid. An invoice made on Nov 28 and paid on Dec 3 belongs to November. The totals always match the rows you can see, so they change when you set the **Status** filter.

| Tile | What it adds up |
| - | - |
| **Invoiced** | The total of every customer invoice in the range except **Void** ones. Drafts, open, paid, and uncollectible invoices all count. |
| **Collected** | The amount paid on customer invoices whose status is **Paid**. |
| **Outstanding** | The amount still due on customer invoices that are **Open** or **Draft**. |
| **Overdue** | The amount due on open or draft invoices whose due date has passed. Shows in red when there is any. |
| **Payables** | Vendor bills in the range, except **Rejected** ones. Paid bills still count, so this is bills received, not bills left to pay. |

Things that are left out or worth knowing:

* **Voided** invoices stay in the table (status **Void**) but never count toward a tile.
* Three kinds of Stripe housekeeping invoices are hidden entirely: the monthly invoices that are auto-voided for a paused plan, the \$0 placeholder created when a plan is scheduled to start later, and duplicate drafts that were voided before anyone was billed.
* A plan invoice with a target billing date uses that date as its due date, so it is not flagged overdue early.
* A draft waiting on a customer to choose how to pay shows the status **Waiting for customer**. It is not counted in **Outstanding** while it waits.
* Dates and day boundaries use your facility's time zone, not your browser's. Set it in [General settings](https://www.carstoragesoftware.com/docs/settings/set-up-general-facility-settings.md).

## Filters

Click **Filters** to set:

* **Date**: **Month to date** (default), **This month**, **Last month**, **Next month**, **Last 3 months**, **Year to date**, or **Custom** (both a start and an end date are required).
* **Status**: **All**, **Paid**, or **Unpaid**. Unpaid means open, draft, waiting for customer, submitted, under review, or approved. Uncollectible and void invoices are in neither **Paid** nor **Unpaid**; they show under **All**.

Click a row to open that invoice or vendor bill. Click a column header to sort.

## Columns

Use **Columns** to hide, show, or drag columns into a new order. Your choice is saved to your own login and also drives the export.

| Column | Meaning |
| - | - |
| **Type**, **Flow** | **Customer** (money **In**) or **Vendor** (money **Out**). |
| **Created**, **Due Date** | Invoice creation date and due date. Vendor bills have no due date. |
| **Customer / Vendor**, **Email**, **Invoice #** | Who it is for and the invoice number. |
| **Line Items** | What was sold, such as "1 × Monthly Car Storage". Processing-fee lines are left out. |
| **Subtotal** | The service amount before tax and processing fees. |
| **Tax** | Tax on the invoice. |
| **Processing Fee** | The processing-fee line charged to the customer on the invoice. |
| **Customer Fees** | Fees the customer paid: the invoice's processing-fee line, or the passed-through amount on the payment. |
| **Facility Fees** | Fees your facility absorbed: the actual card or bank fees from Stripe on paid invoices (an estimate on unpaid ones), minus what the customer paid. **\$0** for cash and check. |
| **Net Subtotal** | **Subtotal** plus **Customer Fees** minus **Facility Fees**, before tax. |
| **Invoice Total**, **Amount Paid**, **Amount Due** | Totals as recorded on the invoice. |
| **Status** | Stripe's status, with **Waiting for customer** added. |
| **Payment Method** | The method used on paid invoices, such as "VISA •••• 4242". On unpaid invoices, the methods the customer may use. |
| **Paid / Resolved** | The date the invoice was paid, voided, or marked uncollectible. |

For vendor bills, **Subtotal**, **Invoice Total**, and **Amount Due** are the bill amount, **Tax** and fees are zero, and **Payment Method** reads **Paid out** once paid.

## Export

Click **Export** (top right) to download an Excel file named `invoices-report-<start>-to-<end>.xlsx` with one sheet, **Invoices**.

* It contains the rows currently shown (after your **Status** filter and sort) and only the columns you have visible, in your order.
* Below the table it adds a summary block: **Total Invoiced**, **Collected**, **Outstanding**, **Vendor Payables**, **Total Invoices**, **Customer / Vendor** counts, **Overdue**, and **Overdue Amount**.
* Money and dates are written as formatted text (for example `$895.00`), not numbers, so Excel will not sum them until you convert them. Use **Data > Text to Columns**, or a `VALUE` formula after removing the `$` and commas.

**Export** is disabled when there are no rows ("No invoices" shows instead).

## Troubleshooting

**The report is slow or shows no invoices at first.** It reads straight from Stripe and can take a while for a long range. Results are cached for up to 15 minutes, so a payment taken a minute ago may not show yet.

**An invoice I expected is missing.** Check **Date** is based on creation, and that **Status** is not set to **Paid** or **Unpaid**. Only the first 5,000 invoices in a range load, so split a very long range into smaller ones.

## Related

* [Review billing reports](https://www.carstoragesoftware.com/docs/payments/review-billing-reports.md)
* [Read the rent roll](https://www.carstoragesoftware.com/docs/reports/read-the-rent-roll.md)
* [Export your data](https://www.carstoragesoftware.com/docs/reports/export-your-data.md)


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