# Financial report: filters, reading and export

> How to find exactly the instalments you are after — and the date trap, which answers a different question.

## What you will get

Money questions answered with names attached: who owes, how much, since when.

The path is **Reports › Financial Report**.

![Financial report with the filters, the three totals and the table](/Apps/edupay/ajuda/relatorio-financeiro.png)
*Filters at the top, three totals in the middle, and one row per instalment — not per enrolment. The screenshot is from the Portuguese panel; the layout is the same in English.*

## One row per instalment

That is the unit of the screen, and it changes how you read everything. A student
with twelve instalments takes twelve rows. **97 instalments** on the first card
means 97 instalments, not 97 students.

## The filters

| Filter | What it does |
|---|---|
| **Search** | Student name, ID number or enrolment number |
| **Status** | Open, Paid, Overdue, Cancelled, Waived — plus Remaining debt, if any exists |
| **Method** | Boleto, PIX, card |
| **Two dates** | The **due date** range |

They combine: *overdue + boleto + August* is a legitimate question and the screen
answers it.

> **The trap is in the dates.** They filter by **due date**, not by payment date.
> Filtering August brings what **fell due** in August, not what **came in** during
> August — and the two are rarely the same.
>
> For "how much came in this month", filter by **Paid** and read the **Paid on**
> column row by row. There is no payment-date filter today.

## A filter is missing from the screen

The report knows how to filter by **cohort**, but **there is no cohort selector on
the page**. The filter exists underneath and only works for someone assembling the
address by hand.

For a school with several cohorts, "how much does the morning group owe me" is a
common question with no button. Logged for correction.

## The columns

**Enrolment number** is a link — it goes to the enrolment. It is the fastest way
out of the report and into action.

**#** carries the instalment number, or **Fee** when it is the enrolment fee.

**Status** is the coloured label. **Paid on** and **Amount paid** only have
content on paid rows.

## Export CSV

The button exports **everything that is filtered, not just the page you are
looking at**. Filtered 97 instalments and seeing 50? The file comes with all 97.

The file opens in Excel with correct accents and uses a **semicolon** as the
separator.

> **In the file, the Type and Status columns come out with the internal words** —
> `regular`, `paid`, `open` — rather than the names on screen. It differs from
> what you see here. Logged for correction; until then, it is worth replacing them
> in the spreadsheet after opening.

## Three questions and how to answer them

**"Who owes me?"** Status **Overdue**, no dates.

**"How much will I receive in September?"** Both dates in September, status
**Open**. The **Total amount** card answers it.

**"Is this student up to date?"** Type the name in the search and read the status
column on their rows.

## If something goes wrong

> [erro]
> **The totals do not match the panel.** That is expected, and there is an article
> just about it — the two measure different things.
>
> **I filtered a month and got less than expected.** The dates are due dates. An
> instalment paid in August but due in July does not enter an August filter.
>
> **The file opened with everything in one column.** Excel used the wrong
> separator. Import it choosing semicolon.


---

https://edupay.estudiosite.com/en/ajuda/grow/financial-report
2026-08-06