Income Cycle Reconciliation Report

This report is designed to show an overall financial position of income due to the practice.

The following information can be obtained from this report:

Total amount of invoiced work due to be paid to the practice in a previous period.
Value of new work that has been invoiced since the previous period
Adjustments made to previous invoiced work
Receipts from patients since the previous period
Adjustments made to previous receipts.
NHS Dental Services figures for monies due to be paid by NHS Dental Services to the practice
Another feature of the report is the ability to select & print individual reports giving further breakdown for the figures shown in the main report.

To Run the Income Cycle Reconciliation report

Select Administration > Reports > Income Cycle Reconciliation:

Leaving the Provider(s) field empty will print an Income Cycle Reconciliation report for the entire practice; however an individual provider can be selected from the list by using the List button.

Clicking the Multiple button will allow printing for a combination of Providers.

Alternatively, you can leave the Provider(s) field blank and select all providers belonging to a provider Category by selecting a Category in the Provider Category field.

The From and To date fields will default to the beginning and end dates of the previous full month, but can be changed to define a different date range for the report.

Click Print to send the report to the printer, Preview to preview on screen and then print from the Preview screen, or Email to email a copy of the report to an email recipient, Export to produce a copy suitable for importing into a spreadsheet or word-processor, or Cancel to return to the previous screen.

If Preview is selected, the following window will provide additional display and print options:

Click Print All to send all sections of the report to the printer, or Print Ticked for the options checked. Click Export All to create a file of all sections of the report readable in Excel, or Export Ticked for the options checked. Otherwise click Close to return to the previous screen.

Interpreting the Income Cycle Reconciliation Report

Main Report

The main report is divided into several sections by header:

Opening Balances Section	Displays the total balance figures for both patients and DPD, prior to the ‘From’ and ‘To’ dates for the report. As schedules are reconciled, NHS Dental Services figures will change.
Written off invoices from previous period	Lists any written off invoices that have been carried forward.
Value of new invoiceable work	Displays amounts for items invoiced within the report dates, broken out by Private, and Patient and DPD portions of NHS treatment.
Adjustments to invoiced work from previous period	Displays any adjustments that have been made to invoices prior to the report date range.
Money received from Patients	Displays receipts from patients that have been allocated to invoices created within the report date range and for the previous period, as well as money received for work not yet invoiced.
Adjustments to receipts	Displays any adjustment amounts that have been made to patients receipts prior to the report date range.
Closing Patient Balance	Displays the total amount owed by patients to the practice as at the date entered in the ‘To Date’ field for the report. This is an overall financial position of monies owed to the practice by patients.
Closing NHS Dental Services Balance	Displays the total amount that is owed the practice, but not yet been paid, by the DBP as at the ‘To Date’ field for the report. As schedules are reconciled this amount will change.

Additional Reports

A number of additional reports are also available to be printed by ticking the box next to the required report. The figures shown rely upon the dates entered for the main report.

If all of the breakdown reports are required, then the user should select the ‘Print All’ button instead of ticking all the boxes.

NOTE: Some of these reports are also available to be printed from within their own report menus. A brief description of these reports, and where else they can be found is as follows.

Debtors List (Opening Patient balance report Option)	Shows patients who owe money prior to the report dates, splitting the total balance into 4 columns showing the overdue balance according to the number of days it remains unpaid. This report can also be printed directly from the ‘Reports’ list.
Opening NHS Dental Services Balance Report (Opening DPD balance report Option)	Shows amounts not yet paid by the DPD prior to the report dates. This report can also be printed from the ‘Administration’ menu, under ‘NHS’, ‘List Courses of Treatment’, by pressing the button.
Write-offs From Previous Period (Written off invoices report option)	Shows amounts written off, and a total of all write offs prior to the reporting dates. This report can also be printed from the ‘Transactions’ menu, under ‘List Items’, ‘List Write-offs’, by pressing the button.
New Invoiceable Work (New Invoiceable work report option)	Shows amounts invoiced to Patients for the report date range, split into columns for Private, NHS & NHS Dental Services, with a grand total for each column.
Adjustments To Invoiced Work for Previous Period (Adjustments to invoiced work option)	Shows adjustment amounts made to invoices prior to the report date range, split into columns for Private, NHS & NHS Dental Services, with a grand total for each column.
Money Received from Patients (Money received from Patients report option)	Shows dated receipts from Patients within the report date range, split into columns showing the Provider, Payment Method and Amount, together with grand totals for each payment method and an overall total.
Adjustments to Receipts from Previous Period (Adjustments to receipts report option)	Shows adjustment amounts made to receipts prior to the report date range, split into columns to show the Provider, Payment Method and Amount, together with grand totals for each payment method and an overall total.
Money Paid By DPD (Money from DPD report option)	This report shows money that has been received from the DPD. This report needs to be run after reconciling and processing a NHS schedule through EXACT.