Reports

Four reports, four different questions. Picking the wrong one is the usual reason the numbers seem not to agree.

Required Access

Cashier — View

Every report is available at View. Running them requires no ability to record a transaction.

Go to Cashier, then Reports.

Which report do I want?

Question	Report	Scoped by
What did we agree to charge this year?	Annual Fees and Discounts	School year
What did we actually bill in this period?	Charges	Date window
What money came in over the counter?	Payments Received	Date window, or year to date
Who still owes us, and for how long?	Outstanding Accounts	Everything unpaid

The first is about promises, the second about charges raised, the third about cash, the fourth about debt. They will not tie to each other, and are not meant to.

Two of these are date-scoped, not year-scoped

Charges and Payments Received cover a date window, because a receipt legitimately settles two years’ charges at once and money arrives when it arrives. Switching school year does not change what they show; changing the window does. (Payments Received’s year-to-date mode is the exception.)

Annual Fees and Discounts

What the payment contracts promise for the year.

One row per student or per financial account — the same figures, pivoted two ways. Fee columns show the amount before discounts, so they always add to Gross; Net is what the contract actually bills.

Further tabs roll the same rows up by fee, by grade and by discount, so you can answer “how much are we discounting, and under which scholarship” without exporting anything.

Only the largest fees are shown as columns to begin with; the rest are behind the table’s Columns button. Hidden columns still export and still count toward the totals.

Withdrawn students are listed, not hidden

A student who did not enroll, or has withdrawn, still appears whenever fees remain on their account — flagged as not billed. A money report that silently dropped them would hide exactly the accounts somebody needs to deal with.

Charges

Everything billed inside a date window, broken out by fee. Scheduled installments and one-off charges alike — late fees, library fines, store invoices — across family, employee and vendor accounts.

Four views of one fetch: By month, By student, By account, and By fee for any single fee.

Charges are counted on their due date, so a September installment appears in September whether or not it has been paid. Step the window month by month with the arrows beside it.

Payments Received

What came over the counter in a window: by receipt, by day, by fee, and by account. Anyone with Accounting access can open it too, from Accounting in the sidebar.

Receipts are counted on the day the money arrived, so a credit taken in July and spent in August belongs to July and is never counted twice. Voided receipts are listed for the trail and excluded from every total. The credit left by reversing a paid charge is excluded too: the original payment is already counted on its own day.

By day also shows how the money arrived, which makes it the cash-up view. A transfer from a student’s card balance shows as Student Card Balance.

Year to date

Switch By period to Year to date to see every payment applied to the selected school year’s charges, received on or before an as-of date. A prepayment made before the year began counts. Only applied money is shown: unapplied credit belongs to no year until it is spent. The arrows step the as-of date to the end of the previous or next month.

Coming from the old database? By account + Year to date is its Payments Received report.

“Method not recorded” is history, not a gap

The legacy system never recorded how money arrived, and nothing written before this module shipped carries a payment method either. Those receipts fall into their own bucket rather than being labelled “cash”, which would make the view confidently wrong. It shrinks on its own as the counter moves into Mosaic.

Outstanding Accounts

Open charges aged by days past their due date: 1–30, 31–60, 61–90, and over 90. Same boundaries as the badges on an account’s ledger, so the two never disagree by a day.

It opens on active accounts that have something past due — the collectable list — and widens from there.

Three things worth knowing:

• It covers every school year. Prior-year debt is included, because a debt does not expire when a school year does.
• It is the same balance as report-card withholding and re-enrollment holds. An account flagged here is exactly an account blocked there.
• Unapplied credits are shown separately. Mosaic never nets a credit against an open charge on its own — somebody has to decide what the credit is for.

The debt age filter is cumulative: “more than 30 days” includes the 90-plus accounts. The per-bucket money columns give the exclusive view. There is also an amount threshold, derived from your own school’s distribution rather than a fixed figure, since a material balance at one campus is noise at another.

Exporting

Every report exports what is on screen, including columns hidden behind the Columns button. Filters and the chosen pivot are respected, so export the view you are looking at rather than reshaping it afterwards.