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

# Monthly Sales and Payments

> Revenue billed and payments collected for the period, side by side.

Revenue billed and payments collected for the period, side by side — one bar chart, with drill-down detail behind each bar.

## Chart

Each month shows two bars: **Sales** (billed revenue for that month) and **Payment** (amount actually collected in that month). Reading them side by side across a date range makes it easy to spot months where billing outpaced collections, or vice versa.

<Frame caption="Sales vs. Payment, by month">
  <img src="https://mintcdn.com/spreesuite/phS_taDsaWMzeQff/images/monthly-sales-and-payments-chart.png?fit=max&auto=format&n=phS_taDsaWMzeQff&q=85&s=2b05b5e9591c7f69c1119cb0ec7fda4e" alt="Monthly Sales and Payments chart" width="1356" height="898" data-path="images/monthly-sales-and-payments-chart.png" />
</Frame>

## Drilling into a bar

Clicking either bar for a given month opens a **Details** panel below the chart, with the underlying bill-level records for that month.

* Clicking a **Sales** bar filters the Details panel to **Report Type: Term**.
* Clicking a **Payment** bar filters the Details panel to **Report Type: Payment**.

The Details panel also has its own filters — **Invoices**, **Start Date**, **End Date**, **Report Type**, and a free-text **Search** — so you can re-run it for a different month or narrow it down further without going back to the chart.

<Frame caption="Details panel filtered to Report Type: Payment">
  <img src="https://mintcdn.com/spreesuite/phS_taDsaWMzeQff/images/monthly-sales-and-payments-detail-payment.png?fit=max&auto=format&n=phS_taDsaWMzeQff&q=85&s=a478e0b6c87a536a036ea540617797a7" alt="Monthly Sales and Payments — Payment detail" width="1675" height="705" data-path="images/monthly-sales-and-payments-detail-payment.png" />
</Frame>

<Frame caption="Details panel filtered to Report Type: Term">
  <img src="https://mintcdn.com/spreesuite/phS_taDsaWMzeQff/images/monthly-sales-and-payments-detail-sales.png?fit=max&auto=format&n=phS_taDsaWMzeQff&q=85&s=cf50e89e070f6729b66a3127dcc19b67" alt="Monthly Sales and Payments — Term detail" width="1675" height="705" data-path="images/monthly-sales-and-payments-detail-sales.png" />
</Frame>

The Details table columns:

| Column                | Description                                |
| :-------------------- | :----------------------------------------- |
| Date                  | Date of the bill record                    |
| Bill Number           | The bill's identifier                      |
| Customer              | Customer the bill belongs to               |
| Pricing Template Code | Pricing code associated with the bill      |
| Arrear                | Outstanding balance carried into this bill |
| Sale                  | Billed amount for the period               |
| Bill Amount           | Total bill amount                          |
| Payment               | Amount paid against the bill               |
| Total Balance         | Remaining balance after payment            |

A **Totals** row at the bottom sums Sale, Bill Amount, Payment, and Total Balance across every record matching the current filters — not just the 10 shown on the current page.

## Exporting

**Export CSV** downloads the full filtered result set (all pages, not just the visible 10 rows) as a spreadsheet with the same columns as the Details table.

<Frame caption="CSV export of the Details table">
  <img src="https://mintcdn.com/spreesuite/phS_taDsaWMzeQff/images/monthly-sales-and-payments-csv-export.png?fit=max&auto=format&n=phS_taDsaWMzeQff&q=85&s=6a7ccd6cb2c73d11ac8816db388238d2" alt="Monthly Sales and Payments CSV export" width="1226" height="838" data-path="images/monthly-sales-and-payments-csv-export.png" />
</Frame>
