Provider Type

The category of provider, e.g. Dentist or Hygienist.

Provider

The name and unique provider code.

Payor codes

These relate to the payor code a particular invoice is associated with. This could be ‘Private’ (blank payor code in EXACT), NHS for a UK NHS payor, or a specific payment plan (e.g. DENPLAN). The value in a particular payor code column represents the total of all invoices & invoice adjustments for that particular payor in the reporting period.

Date range

Defines the reporting period.

Practices

Allows selection of all or specific practices within the practice group.

Dentist

Allow selection of all or specific dentists (providers).

Transaction Category

This shows the transaction category – Amounts Invoiced shows invoice totals grouped together, Invoice Adjustments shows invoice adjustment totals grouped separately;

Provider

Within the Amounts Invoiced category, the totals are further split by invoice provider code;

Adjustment Type

Within the Invoice Adjustments category, the totals are split by the type of invoice (e.g. Invoice Correction).

Totals

A grand total row that shows the total values from each row within a particular column (e.g. all Private invoice and invoice adjustment amounts);.

Payor Name columns

Invoice or invoice adjustment values are shown in different payor columns, according to the payor associated with the invoice. For UK practices, all NHS payors are aggregated under the NHS column. All ‘stock’ invoices are aggregated under the ‘Product Sales’ column (e.g. invoices for sundry items such as toothbrushes or floss). This is based on whether an invoice is classed as a ‘stock’ invoice or not within EXACT.

Grand Total

The total of all column values on a particular row.

Date range

Defines the reporting period.

Practices

Allows selection of all or specific practices within the practice group.

Category

The overall transaction category of the section in the parent report from where the drilldown action was initiated. For example, Amounts Invoiced, or Invoice Adjustments.

Sub-Category

If the parent report shows sub groups of the transaction category, that sub grouping is shown in this field, where this shows the full description of this sub group. E.g. an invoice adjustment subgroup might show as ‘Invoice Correction’.

Sub-Category Code

Similar to Sub-Category, but in the case of invoice adjustments, will show the code, rather than the description. E.g. when Sub-Category shows Invoice Correction, this field would show say ‘INVOICECOR’. For other transaction types, will show the same as field Sub-Category.

Date

The transaction date, e.g. invoice or receipt date.

Patient

Patient code to which the transaction relates.

Provider ID

The provider code associated with the transaction.

Transaction ID

The unique identifying transaction number, e.g. receipt number or invoice number.

COT ID

The COT (Course Of Treatment) number to which the transaction relates.

Payor Category

The payor associated with the transaction.

Amount

The amount of the transaction.

Date range

Defines the reporting period.

Practices

Allows selection of all or specific practices within the practice group.

Provider

The provider who carried out the treatment, based on the provider associated with the invoice raised;

Work on patients

For a given provider, all invoices relating to patients associated with a particular provider and invoice payor type are grouped together. For example, this subgrouping might be shown under provider J SMITH, as ‘work on K JONES (NHS) patients’. This will list all invoices raised in the reporting period that provider J SMITH has carried out for NHS treatment, for patients who are associated (in their EXACT patient details field) with provider K JONES.

Patient

The full name of the patient associated with the invoice.

Invoice No

The invoice number this row relates to.

Date

The invoice date, or adjustment date if the row is an adjustment.

Payor

The invoice or adjustment amount if this invoice is a payor invoice.

Patient (Amount)

The invoice or adjustment amount if this invoice is a patient invoice.

Total Fee

The invoice or adjustment amount (adjustments show as negative amounts).

Date range

Defines the reporting period.

Practices

Allows selection of all or specific practices within the practice group.

Dentist

Allow selection of all or specific dentists (providers).

Provider

The provider associated with the invoice.

Invoice No

The unique invoice number.

Patient Name

The patient associated with the invoice.

Date

The date the invoice was raised.

Invoice Category

This will show ‘Patient’ or ‘Payor’, depending on whether the invoice relates to a patient or payor entity.

Invoice Amount

The total amount of the invoice transaction.

Amount Paid

The part of Invoice Amount that has been allocated. Fully paid invoices will show the whole Invoice Amount in this field.

Payor

The payor code of the payor associated with the invoice, for example NHS, Private, or DENPLAN.

COT No

The Course Of Treatment (COT) number to which this invoice is linked.

Date range

Defines the reporting period.

Practices

allows selection of all or specific practices within the practice group.

Dentist

allow selection of all or specific dentists (providers).

Takings

These are the total from the fully allocated portion of receipts in the period, i.e. excluding pre-payment receipt amounts. E.g. if a COT will cost a total of 200, the patient pays up front an amount of 200, but only an invoice for 50 worth of the overall work has been raised, then the ‘Takings’ section would only show the 50 of the 200 receipt that has been allocated to the invoice raised. The ‘Takings’ section is further split according to the receipt payment method – e.g. Cash or Debit Card. Adjustment amounts are shown as a separate row.

Income

These are the total from all unallocated portions from receipts in the period. For example, in the above case where a patient had paid 200 up front for treatment, of which only 50 was currently allocated to an invoice, this section would show 150 for the unallocated component. Again, this section is split by receipt payment method.

Total Receipts

This is the total of all of the ‘Takings’ and ‘Income’ values – which will be the total amount from all receipt transactions in the period.

Accounted for by

This is an alternative breakdown of the Total Receipts value, and splits this total by receipt payment method (Cash, Debit Card, etc).

Each day in the reporting period that has receipt transactions is shown as a separate column in the report, with values split across the above sections. The Totals section at the far right shows the total from all the individual date columns.

The values in the ‘Total Receipts’ row can be clicked on to drill down to show the Receipts Analysis Detail report for that total value.

Date range

Defines the reporting period.

Practices

Allows selection of all or specific practices within the practice group.

Practice

The practice name.

Provider

The provider’s full name and code to which the receipt relates.

Date

The receipt transaction date.

Patient Name

Full name of the patient associated with the receipt.

Receipt No

The receipt unique transaction number.

Allocation Category

For rows that represent allocations to invoices, this indicates the invoice payor. For rows that represent unallocated parts of the receipt amount, this will show ‘Dep’ (for ‘Deposit’), together with a payor name. E.g. Dep – NHS, Dep – Private. The payor name here is derived from information entered when the receipt was created.

Allocation Amount

The part of the receipt amount that has been included in this allocation. For a set of rows relating to one receipt number. The total of ‘Allocation Amount’ will match the receipt amount.

Invoice No

Where a row represents an allocation from a receipt to an invoice, the invoice number is shown here.

Payment Method

The indication of the payment method used for the receipt.

Date range

Defines the reporting period.

Practices

Allows selection of all or specific practices within the practice group.

Date range

Defines the reporting period.

Practices

Allows selection of all or specific practices within the practice group.

Category

The category of the transaction, which will be Amounts Invoiced, or Invoice Adjustments. Currently. Adjustments of type ‘Resubmitted’ are categorised under ‘Amounts Invoiced’.

Sub-Category

If appropriate, a sub group of the category. This is mainly for adjustments of different types, for invoice entries it will show ‘Invoices’.

Patient Code

The code of the patient to which the transaction relates.

Patient Name

The name of the patient to which the transaction relates.

Provider ID

The transaction provider code.

Payor Category

The transaction payor. This is determined from the COT that is associated with the invoice, if one exists. Stock/sundry invoices are shown as ‘Product Sales’.

COT ID

The Course Of Treatment (COT) number, if relevant.

Transaction ID

The invoice number (adjustment rows will show the adjusted invoice number). If an invoice has multiple allocations, then there will be several rows in the report with the same Transaction ID (invoice number), with different Alloc Amount values.

Transaction Date

The invoice date, or adjustment date if an adjustment row.

Transaction Amount

The overall invoice amount. This column should not be totalled up, as there may be multiple rows that relate to the same invoice (Transaction ID).

Alloc Date

The date on which the allocation event occurred. With automatic allocation enabled, this will typically be the date on which a receipt is entered, which is then allocated to invoices according to EXACT’s allocation process.

Alloc Source

An indication of the other transaction involved in this allocation. Typically, it will be a receipt, but adjustments can also be allocated to invoice transactions.

Alloc Direction

whether this allocation represents an allocation TO the invoice (where part of the invoice amount is allocated to another transaction in the allocation event), or FROM the invoice (where the invoice has an amount from another transaction allocated to it).

Alloc Amount

The amount which is involved in the allocation event.

Date range

Defines the reporting period.

Practices

Allows selection of all or specific practices within the practice group.

Patient Code

The patient’s code

Patient Name

The patient’s full name (surname, first name format)

Last Statement Date

The most recent date on or before the as of date on which a patient statement was printed

Stop Credit

Shows a ‘*’ (asterisk) character if the ‘Stop Credit’ checkbox is ticked in EXACT for this patient

Total

The total of all statement transactions occurring before the as of date

Current

The total of all statement transactions occurring less than 30 days before the as of date

30 days

The total of all statement transactions occurring between 30 and 59 days before the as of date

60 days

The total of all statement transactions occurring between 30 and 89 days before the as of date

90 days

The total of all statement transactions occurring 90 days or more before the as of date

As Of Date

The start date in the date range selector is used as the report ‘as of’ date.

Practices