Associates Report

Report Description:

The Associates report shows, for a given reporting period, the total of the allocated portion of all patient invoices relevant for the period, together with the total of invoice adjustments occurring in the period. Currently, only invoice adjustment types of ‘Bad Debt’ and ‘Resubmitted’ are included in the report.

For the UK only, NHS related invoices are not included in this report – it shows private or payment plan invoices only.

An allocated portion of an invoice is included if the allocation date occurred within the reporting period.

For example, if some treatment was carried out, and an invoice with an amount of 200 raised on completion of that treatment. If the invoice is not paid until some later date, then initially, the invoice amount will be unallocated. Running the associates report for a period that includes the invoice date but before the receipt date will not include this invoice amount.

If the invoice was then paid by two separate receipts of say 150 and 50, several days apart, then (assuming automatic allocation, where the allocation occurs on the receipt date), running the associates report before the 2nd receipt date would only include the allocated amount of 150, and exclude the remaining unallocated amount of 50 that is still outstanding.

Running the associates report after the 2nd receipt date would then show the full amount of 200 that is fully allocated.

Data in the report is grouped into sections for each selected practice, then by each provider who has allocated invoice amounts for that reporting period.

For each provider, invoices and adjustments are shown separately.

The columns in the report show the different payors to which the invoices relate, e.g. Private, Product Sales (stock/sundry invoices) or payment plan payors. The value shown in each column represents the total of all allocated portions of invoices of that payor type, where the allocation date was within the reporting period.

The ‘Total Allocated Amount’ column shows the total of all payor columns.

Clicking on any of the values in the payor columns will show a breakdown of that amount in the Associates Report Detail report in a new browser window.

Report Parameters: