Money reports

Open Reports and pick a report under Money. Every money figure comes from the patient ledger in the practice's currency, by the entry's date in the practice's own time zone. Nothing is estimated.

A period you have already reported never changes afterwards. A charge, payment or refund counts in the window it was posted in, and reversing it later posts the correction on the day the correction was made — so last month reads as it did when you closed it, and this month carries the correcting movement. The exception is a figure that answers what is owed now: aged debt, and the outstanding column of associate pay, read the live ledger, where an entry and its reversal cancel out.

A practitioner filter narrows charges only — a payment carries no practitioner — so the cash side of a filtered report stays whole.

Day sheet & takings

By ledger entry date, counting what was posted in the window; a reversal made later shows on its own day. Production is the charges raised, Takings the payments received, Refunds what went back, and Net collected the difference. Discounts & write-offs are the credit adjustments given; Debit adjustments the charges added by adjustment. The chart shows production against net takings per day, week or month; the tables split takings by payment method and everything by location.

Aged debt

A point-in-time report — the date filter does not apply. Every account with money owing is listed with its balance aged from each charge's entry date into 0–30, 31–60, 61–90 and over 90 days. A payment settles the oldest charges first, so an account's oldest bands clear before its newest. Unallocated credit is money on account not yet applied to a charge. A reversed charge is no longer owed, so it drops out of the ageing.

Production

Charges raised over time by source — procedures, retail, manual and imported — and per practitioner and location, with tax shown separately. The average charge is production divided by the number of charges. Production counts the charges posted in the window; a charge reversed later comes off on the day of the reversal, and the charge count moves with it.

Collections

Cash in and refunds out by payment method and source. The collection rate is net cash divided by the production raised in the same window; a window with no production shows no rate rather than a misleading one. Cash counts on the day it was taken; reversing a payment later takes it back off on the day of the reversal.

Associate pay

Per practitioner: the production they raised in the window (by charge entry date), the cash allocated to their charges in the window (by allocation date) and what is still outstanding on their charges. Production and cash count what was posted in the window, and a later reversal lands on its own day; the outstanding column is today's figure, so a reversed charge drops out of it. These are gross figures — apply the associate's percentage and any lab-fee rules yourself.

Chair utilisation

Appointment time booked and attended against the time each practitioner's rota makes bookable: working hours minus breaks, blocks and approved absences, day by day in the rota's time zone. Booked utilisation is booked time divided by bookable time; attended utilisation divides the time of appointments marked attended instead. Cancelled and no-show appointments do not count as booked.