Report Description:
This report shows the detail behind the allocated amounts shown as totals on the Associates Report. It can either be run by drilling down from the Associates Report, or by running directly from the MPC financial menu.
Each row in this report represents an allocation event for a particular invoice, or an invoice adjustment.
The report shows the following fields:
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. |
Report Parameters:
Date range |
Defines the reporting period. |
Practices |
Allows selection of all or specific practices within the practice group. |