What is the Patient Charges Control Report?
The Patient Charges Control report shows the start period balance, total amount of invoices raised, any invoice/receipt adjustments occurring within the reporting period and the end period balance.
How to run the Patient Charges Control Report
Go to Financial on the navigation menu on the left and select Patient Charges Control Report from the dropdown.
Work through the filters to ensure you are reporting on the correct parameters.
Select the reporting period by choosing your Start Date and End Date from the calendar icon.
Select the Practice/Practices.
Click Create Report to run the data.
Viewing your Patient Charges Control Report
Values in the report are split into the following column categories:
NHS: For UK practices only, transactions relating to NHS payors.
Product Sales: Stock or sundry item transactions (e.g. toothbrushes, floss).
Private: All other transaction payor types.
What does each line on the report show?
Start Period Balance: This is the sum total of all patient outstanding balances, as at one day before the start date of the report. This includes both credit and debit balances. For UK practices, patients who are associated in their patient details with NHS payors have their balances included in the 'NHS' column. All other patient balances are included in the 'Private' column.
Amounts Invoiced: The total of all patient invoice amounts raised within the reporting period. Invoice adjustments of type 'Resubmitted' (where treatment is resubmitted) are also included in this section. The amount from a particular invoice is included in the relevant column, depending on the associated COT to which the invoice relates. E.g. invoices for NHS treatment are included in the NHS column, stock invoices in the Product Sales column, and all other invoices in the 'Private' column.
Payments Received: The total of all receipts paid during the period, broken down by payment method.
Invoice Adjustments: Adjustments to invoices are included in this section, broken down by adjustment type.
Receipt Adjustments: Adjustments to receipts are included in this section, broken down by adjustment type.
For transactions that are marked as Open Balance transactions, these are shown in either the Amounts Invoiced or Payments Received sections, but with a sub category of 'Open Balance'.
For adjustment transactions, the adjustment code is shown in the 'Adjustment Code' column. E.g. the category column might show 'Invoice Correction', but the Adjustment Code column would show INVOICECORR.
The Grand Total column shows the total, for each row, of all of the NHS, Private and Product Sales columns.
Reconciliation: the values in the Grand Total column should reconcile, in that the following should hold:
End Period Balance = Start Period Balance + Amounts Invoiced + Payments Received
If this is not the case, then a section is shown that shows the amount of the discrepancy, below the End Period Balance value for the Grand Total column.
To download a copy of your report you can use the Export Data button to download a CSV spreadsheet.
You can use the Print button in the top right as needed.
To set up automation of the report you can use the Schedule Report button.