🚨 Important: This report is in Beta testing and is not yet widely available.
What is the 'Day-end' report?
The 'Day-end' report is your practice's daily financial close. It reconciles everything that happened to the books in a single day, including every charge, payment, discount and correction.
Use it at the end of each working day to review production, collections, and outstanding balances, or to look back at any previous day.
📝 Please note: The 'Day-End' report is available to Practice Managers (permission level 3) and Admins (permission level 4) only.
To access the 'Day-end' report:
In the 'Reports' section, select 'Day-end' from the financial section.
You'll see a status summary at the top showing the last time it was updated, viewed and exported, so you can identify if any changes have been applied in between viewings/exports.
Use the 'Export as PDF' button to export either the practice summary, or the practice summary with provider breakdowns.
Use the 'Day' and 'Provider' filters to select the date you want to view, or filter to a particular practitioner.
Set the 'Provider' field to 'All providers' to see everyone.
If filtering to a specific provider, only that provider's activity is visible. The 'Provider' section will be hidden as it's not relevant, and practice-level items such as sundries and lab fees will not be shown.
The report shows today's figures live until midnight. It refreshes each time you open it, so the figures are current as of the moment you open or refresh the page.
🚨 Important: The report for a closed day (any day prior to today) is read-only. Any changes made after a day has closed will appear as adjustments on a following day (with a clear record of what was corrected and when), not as edits to the closed record. The cut-off for this is midnight.
How do I use the 'Day-end' report?
The report is divided into six sections.
Grand totals
The headline reconciliation for the whole practice.
It shows two columns - today and month-to-date - so you can check the day at a glance and confirm it ties out with the monthly accounts.
Unallocated payments, and payments allocated against a deposit or note, are excluded from the closing A/R figure until they are allocated to a specific invoice, and are shown separately. This is so they stay visible for reconciliation without affecting the headline figure until they are allocated to an invoice.
The month-to-date figures in 'Grand totals' match the practice's 'Monthly Accounts' figures exactly.
If the closing A/R figure is different from what you expected, check the production and payment adjustments to see whether any corrections have been applied (to this month or a previous month), which might result in the total being different.
Production detail
A line-by-line list of every item charged on that day.
Each row shows the time, invoice number, patient, provider, item type (treatment, sundry or lab fee), tooth and surface reference where relevant, procedure code, description and amount.
Subtotals for treatments, sundries, and lab fees appear at the foot of the list, with an overall total. Use this section to trace any headline production figure back to the exact items behind it.
Production adjustments
The corrections that reduced production today, split into two parts:
Fee adjustments - Adjustments applied today, whether to today's work or to earlier treatments. Each row shows when the discount was applied, when the original treatment was charged, the patient, the provider and the amount.
Charge adjustments - Invoices or invoice items deleted today, with the same level of detail.
Each part has its own subtotal. The two combine into a total for all production adjustments.
Daily collections
Every payment received today, grouped by payment method (card, cash etc.), with a subtotal per method.
Each row shows the time, who paid, which patient the payment relates to, how much was allocated to invoices, where it was allocated, any unallocated amount, a reference and the total received.
Unallocated payments (money received but not yet attached to an invoice) appear in this section, so you can reconcile every payment against the day's bank deposit. They do not affect production, collections or accounts receivable until they are allocated to an invoice.
📝 Please note: Production is the value of work completed and charged today, after any discounts and corrections. Collections is the money actually received and applied to invoices today. The two figures will rarely match on any given day. Production reflects work done, collections reflects cash in.
Payment adjustments
Payments that were reallocated or deleted today.
Each row separates the patient portion from the insurance portion, and gives a total.
Provider breakdown
The day's production and collections split by provider, with one row per practitioner.
For each provider you can see their opening balance, charges, adjustments, production and collection totals, closing balance and net change.
📝 Please note: Lab fees and sundries are excluded from individual provider totals. These are practice-level items and are reported in 'Grand totals' instead.
How do I export the 'Day-end' report as a PDF?
Click 'Export as PDF' in the top right of the report.
Choose whether you want to export the entire report as it looks on your screen, or to include provider breakdowns.
🚨 Important: You'll see a status summary at the top of the report, identifying whether the report has changed since it was last viewed or exported. If changes have been made since it was last exported, the exported data is now out of date.
Every exported PDF carries a sequential report number for audit and fraud control. A report exported while the day is still open will be marked as 'Open', and one exported after midnight will be marked as 'Closed'.