📝 Please note: This report is currently in Beta testing, and is not yet widely available. Want to join the trial? Reach out via Support chat, we'd love to hear your feedback!
What is the 'Monthly Accounts' report?
The 'Monthly Accounts' reports is a financial report that provides insight into your practice's financial status. It focuses on A/R (accounts receivable), which represents the total balance of all outstanding invoices.
This report is useful for:
Understanding practice and practitioner performance by viewing total charges, discounts, invoice adjustments and payments towards invoices on a monthly scale.
Tracking your accounts receivable and how your unpaid invoices change from month to month.
Calculating practitioner pay, and accounting for any adjustments.
The numbers in this report might look different from other financial reporting because it accounts for adjustments and corrections, rather than showing the current state of your accounts - giving you a useful overview, on a monthly basis.
How do I access the 'Monthly Accounts' report?
📝 Please note: This report is only available to permission level 3 or 4 users.
To access the 'Monthly Accounts' report:
Go to the 'Reports' section of Dentally. In the 'Financial' section, click 'Monthly Accounts'.
The report will open, displaying monthly totals, and subsections for 'Totals by type' and 'Totals by practitioner' (or 'by provider' in Canada). Read the guide below for details on understanding each section.
💡 Top tip: You can export the report using the 'Export to PDF' button on the top right of the report (currently only PDF format is available). After month-end, the data in the report cannot change, so the report cannot become out-of-date after this point.
🚨 Important: If you have multiple sites, the report shows data for your currently selected site. This includes all payments used to pay for treatments charged at your site, regardless of where the payment was taken.
If there are cross-site payments, you will see an additional summary:
'Collected at other sites' shows money included in your totals that was collected elsewhere.
'Collected for other sites' shows money your site collected that appears in other sites' reports (but does not contribute to your report).
How do I use each section of the 'Monthly Accounts' report?
💡 Top tip: You can hover over any column header in the report to see an explanation of what that column refers to.
Monthly totals
The top section displays your monthly totals. Some column headers will vary depending on the region you're in.
UK/AU view:
CA view:
From here, you can select the month you want to view using the dropdown - the earliest available month you can see will vary.
💡 Top tip: If you view the current month, it will only go up to the date you are viewing, and will display '(to date)' after the month and year, eg 'February 2025 (to date)'. A badge will also appear if you are viewing the current month, indicating when it was last updated.
In this section, you can view:
'Opening A/R': Total unpaid invoices on the 1st of the selected month.
'Net charges' (or 'Production total' in Canada): The total charged during the selected month (excluding discounts, and adjusted to account for changes to previous months' invoices).
'Net payments' (or 'Collection total' in Canada): All payments recorded and explained to invoices during the selected month (adjusted to account for changes to previous months' payments).
'Closing A/R': The total amount from unpaid invoices at month-end of the selected month (or at the current date if you have selected the current month).
'Net change': The change in your A/R during the selected period - ideally £0 or negative, showing you're not taking on more unpaid invoices.
Totals by type or practitioner
Below the 'Monthly Totals' section, you will see two more sections, 'Totals by type' and 'Totals by practitioner' (or 'by provider' in Canada). As with your monthly totals, some column headers will vary depending on your region.
'Totals by type' - This breaks down your totals into sundries and treatments. This is useful for seeing top level performance of each type. Canadian users will also see lab fees.
'Totals by practitioner' - This breaks your totals down by each individual practitioner. This is useful for understanding each practitioner's contribution to practice revenue, tracking rates per practitioner, and calculating practitioner pay.
In these sections, you will see:
'Type' - Whether the summaries refer to sundries or treatments (or lab fees, in Canada).
'Opening A/R' - The total unpaid invoices of that type on the first day of the selected month.
Then you will see two sub-sections. Under 'Invoices' (or 'Production' in Canada):
'Charges': All items added to invoices of that type in the selected month.
'Discounts': All discounts added or changed in the selected month for that item type - this column does not factor in treatment or sundry items used to represent discounts, it is only visible if you have discounting feature enabled (currently AU/CA only 🇦🇺🇨🇦).
'Adjustments': Any changes made to charges from previous months.
'Net charges' (or 'Production total' in Canada): The total for that item type, calculated as 'Charges' plus 'Adjustments', less any 'Discounts' (or equivalent for Canada).
Under 'Takings' (or 'Collection' in Canada):
'Payments' (or 'Collection' in Canada): All payments for that item type which were recorded and explained to an invoice during the selected month - this does not include any unexplained payments or payments explained without selecting an invoice.
'Adjustments': Any changes made to payments from previous months.
'Net payments' (or 'Collection total' in Canada): The total for that item type, calculated as 'Payments' plus 'Adjustments' (or equivalent for Canada).
The final section displays:
'Closing A/R': The total amount from unpaid invoices for that item type, at month-end of the selected month (or at the current date if you have selected the current month).
'Net change': The change in your A/R during the selected period for that item type - ideally £0 or negative, showing you're not taking on more unpaid invoices.
'% collected': The percentage of your net charges that were paid during the selected month.
UK/AU view:
CA view:
The report is focused on work completed, and payments taken towards that work. Any payments that have been taken but sit on the patient's account for future use (so unexplained payments or payments explained but not assigned to an invoice) are intentionally excluded. The A/R totals therefore represent the totals of all unpaid invoices at your site, and do not deduct money taken as deposits for future treatment.
You can use the 'Takings' report (UK/AU) or the 'Collections' report (CA) to locate payments that have outstanding balances that need to be explained, and use the 'Payment Allocations' report to view allocations.