Financial Reports

Report Type	Report Name	Description
Day Sheet	Daily Figures	Monitor the total number of patients per practitioner who have arrived in the patient queue on a nominated date. The report includes the total number of patients who did not wait, as well as the arrival time and consultation time of the first and last patient of the day.
Visits Report	Identifies the daily visit details for all services performed within the selected date range. Practices can use this report to compare the status of an invoice against the patient queue, identify the outstanding billing and predict future capacity. The summary page displays the sum of all visits for each practitioner working in the centre, for the chosen report parameters, grouped by visit type. Use the summary to help calculate the practice's payroll tax requirements. For example, claiming a Payroll Tax exemption based on Medicare Bulk bill rates. For more information about payroll tax requirements, see Revenue NSW website. Note: The total amount and transactions shown in the report do not reflect changes related to refunds or Did not wait. Use the Transactions report for precise financial information. Do not use the daily Visits Report to determine your doctors' pay. For full financial clarity, use the Transactions and Transactions Payment reports.
Daily Visits Summary	Displays each practitioner's earnings, GST amount, number of visits, and total earnings for all. Print the report for a specific provider or all providers, for a specific invoice status, or both invoice statuses (draft and final).
Receipts Issued	Review all the transaction receipts issued or adjusted in a specific date range. Each receipt number item includes payer, amount, payment type, and other details.
Visit Recorded	Identify all visits based on the date of service, including both draft and finalised visit invoices. The reported date may be adjusted after the drafted visits are finalised, and visits can be retrospectively created (up to 2 years). Additionally, services may be updated as exceptions are processed.
My Health Record Quarterly Upload	Shows the number of records uploaded by each HCP per quarter in that calendar year (1 November - 31 October) at a specific centre.
Prescription	Immunisation Listing	View the details of each vaccine administered in a selected date range by a specific provider or all providers. Print the report for a specific vaccinator or all vaccinators. If required, you can filter by: Childhood Only Declined Only Include Historical Include Pending Over 65/ATSI over 50 Only
Prescription Report	Export the details for all prescriptions written at a selected centre during a specific date range. The report includes the patient's details and the prescribed date, drug details, dose form and dosage details. For S8 prescriptions, the interval between repeats is also included if specified. Use to report information about prescriptions to the TGA.
Prescription Search by Patient	View all medications prescribed to an individual patient, including dosage information and medication type.
Prescription Search by Number	Display a complete report for the script under that number.
Billing	Fee Adjustments	Monitor the adjustments made to invoices or receipts based on the date of adjustment. This report generates by the adjustment types such as fee changes, refunds, write-offs, did not wait, and receipt adjustments in a specific date range.
Bulk Bill	View a summary of Medicare and DVA claimed amounts and payments in a specific date range for the centre. The reporting date is initially based on the date batched (transaction date). Once the claim is transmitted, the date is adjusted to reflect the transmission (date lodged). Print for all providers or a single provider.
GST Summary Invoices	View a summary of GST invoices generated by practitioners within a specific date range for the centre. This report includes the total amount of invoices with and without GST and GST due amount. Print for all providers or a single provider.
[Deprecated] Outstanding Balances	View all outstanding invoices in a specific date range. You can identify individual debtors or display a combined summary of all accounts by category. For example workers compensation, pre-employment and private. Note: If any unresolved exception claims (Medicare, Bulk Bill and DVA) are identified, they are marked as outstanding until all the exceptions in those claims have been resolved.
Practice Fees By Item Code	Provides a detailed breakdown of the services invoiced by each practitioner based on invoices issued. The report is broken down by work area, visit type, item code, including total invoiced values. GST is included for relevant items. For each item code the report details: Practitioner, Invoiced To and Work area code - the provider code of the practitioner who provided the services, the provider code for who the services were invoiced to, and the work area code in which those services were invoiced. Visit type - the visit type for the services (Bulk Bill, DVA, Pre-Employment, Private or Workers Compensation) provided. Item Code - the service's item code. Qty - the total number of services provided for each item code. Amount Paid - the dollar amount of the item (GST exclusive). GST Paid - total tax payable for the item. To display the breakdown total for each work area or visit type, sort the services by work area or visit type. Note: Adjustments made to invoices are aggregated and reflect the adjusted value in the month of the changes.
Receipts By Item Code	Provides a breakdown of the number of each type of item code the centre has receipted for each doctor in a specific period. The Summary page displays: The total number of each item code by visit type for the selected centre. The sum of item codes by visit type per practitioner. Note: Item codes are counted and grouped by visit type and practitioner. If the item codes are repeated in a visit, they will be counted again. Practices can use this report to help calculate their payroll tax requirements, for example, identifying their percentage of bulk bill item codes to prove their eligibility for payroll tax subsidies or amnesties. For more information about payroll tax requirements, see Medical Services. For each item code the report details: Practitioner, Invoiced To and Work area code - the provider code of the practitioner who provided the services, the provider code for who the services were invoiced to, and the work area code in which those services were invoiced. Visit type - the visit type for the services (Bulk Bill, DVA, Pre-Employment, Private or Workers Compensation) provided. Item Code - the service's item code. Qty - the total number of services provided for each item code. Amount Paid - the dollar amount of the item (GST exclusive). GST Paid - total tax payable for the item. To display the breakdown total for each work area or visit type, sort the services by work area or visit type. Note: The work area reported is taken from the invoice to which the receipts have been allocated to accurately reflect the allocation of monies.
[Deprecated] Transaction Payment	Balance the transaction details of all receipts allocated to a practitioner or visit type. The reporting range is based on transaction payment date (Payment processed date - Medicare payment reflects the deposited date). Date of transaction payment is referenced per line along with the total receipt per payment and the allocated invoices are based on transaction date (visit entry date). Tip: The date of service is not identified.
Transactions	Review all invoices raised by a practitioner or visit type based on the transaction date (date of entry). The date of the transaction is referenced per line, along with transaction payments (if receipts are issued). Note: Neither the date of service nor the receipt date are identified.
Practitioner Fee By Item Number	Identify the type of services invoiced per practitioner based on the date of service. The report is broken down by item, including total earnings value and quantity. GST is included for relevant items.
[Deprecated] Bulk Bill	View the summary of Medicare and DVA claimed amounts and payments in a specific date range for the centre. The reporting date is initially based on the date batched (transaction date). Once the claim is transmitted, the date is adjusted to reflect the transmission (date lodged). Print for all providers or a single provider.
[Deprecated] Practice Fees By Item Number	Identify the type of services invoiced per practitioner based on the entry date. The report is broken down by item, including total earnings value and quantity. GST is included for relevant items.
Transaction Payment	Balance the transaction details of all receipts allocated to a practitioner or visit type. The reporting range is based on when the payment is created in the system (the date of payment is when the receipt is allocated to an invoice for all visit types). For Medicare and DVA exceptions, the date reflects when all exceptions have been resolved in a batch and receipts are generated automatically. The report range also includes any adjustments, refunds or adjustments to allocated invoices that occurred in that period based on when those adjustments were created. The date of service is not identified. For each receipt, the invoice allocations are displayed by line item to enable detailed tracking of receipt allocations and changes to receipts or invoices that might impact payments from previous periods. Receipts allocated to invoice items to a centre are also not included. Unallocated receipts are not included in this report and will only be displayed once they are allocated to a specific invoice. Date of transaction payment is referenced per line along with the total receipt per payment and the allocated invoices are based on transaction date (visit entry date). Tip: The date of service is not identified.
[Deprecated] Receipts By Item Number	Identify the type of services invoiced per practitioner based on the date of receipt. The report is broken down by item and total paid value. GST is included for relevant items.
Outstanding Invoices	Displays outstanding balances owed by account holders, providers, and work area. The report ahows arrears in 30, 60, and 90 days or more periods as of the date the report is generated. Invoices that have been written off are excluded. Use the report to help prioritise efforts to collect overdue payments. Note: If any unresolved exception claims (Medicare, Bulk Bill and DVA) are identified, they are marked as outstanding until all the exceptions in those claims have been resolved.
Unallocated Credit	Provides an overview of unallocated credit or funds available to each account holder. Unallocated credit refers to funds that have not been assigned to specific transactions or invoices within the system. By having both the date of credit and the date of receipt included in the report, you can differentiate between these two aspects and gain a clearer understanding of the timeline associated with unallocated credit entries. This information enables you to track the progression of credit adjustments and receipts, ensuring transparency and accuracy in financial records. The date of receipt refers to the date when the receipt itself was generated or created in the system. This date indicates the moment when the financial transaction (resulting in the unallocated credit) was processed or recorded. It might not necessarily align with the date of credit if there were delays or timing differences between the adjustment in the invoice and the creation of the receipt.
General	Patient Account Diary Entries	View all patient invoices with an account in a specific date range for the centre. The report displays the last diary entry date and associated details for the patient, enabling you to filter by outstanding balances.
RACGP Active Patient Details	Extract patient information, including name, DOB, and other demographic information, including ATSI status. The report also includes clinical information such as SNAP, Asthma, Diabetes and so on. The report shows all patients defined as 'active patients' using the RACGP definition. An 'active' patient is a patient who has visited a practice 3 or more times in the last 2 years. Note: Exporting to PDF is limited to 7000 rows. For full extract, export to CSV.
[Deprecated] Appointment Types	Displays the total number of each appointment type registered by work area in a specific date range for the centre. The report includes all appointment statuses such as booked, confirmed, arrived, cancelled or declined and did not attend.
[Deprecated] Provider Appointments	Displays the total number of appointments created by each practitioner or all practitioners in a specific date range. Work areas are broken down by appointment statuses, such as booked, confirmed, arrived, cancelled, and DNA. The report also shows the total hours of unbooked and available hours.
Appointment Report	Displays a complete list of appointments created by the selected provider or all providers for the centre. For each appointment item, the report includes work area, patient name, appointment details such as date, time, type and status.
PIP QI	Generate and download a PIP eligible data set (snapshot) at this point in time. For more information, see PIP QI Reporting.

Day Sheet

Daily Figures

Monitor the total number of patients per practitioner who have arrived in the patient queue on a nominated date. The report includes the total number of patients who did not wait, as well as the arrival time and consultation time of the first and last patient of the day.

Visits Report

Identifies the daily visit details for all services performed within the selected date range.

Practices can use this report to compare the status of an invoice against the patient queue, identify the outstanding billing and predict future capacity.

The summary page displays the sum of all visits for each practitioner working in the centre, for the chosen report parameters, grouped by visit type. Use the summary to help calculate the practice's payroll tax requirements. For example, claiming a Payroll Tax exemption based on Medicare Bulk bill rates. For more information about payroll tax requirements, see Revenue NSW website.

Note:

The total amount and transactions shown in the report do not reflect changes related to refunds or Did not wait. Use the Transactions report for precise financial information.

Do not use the daily Visits Report to determine your doctors' pay. For full financial clarity, use the Transactions and Transactions Payment reports.

Daily Visits Summary

Displays each practitioner's earnings, GST amount, number of visits, and total earnings for all. Print the report for a specific provider or all providers, for a specific invoice status, or both invoice statuses (draft and final).

Receipts Issued

Review all the transaction receipts issued or adjusted in a specific date range. Each receipt number item includes payer, amount, payment type, and other details.

Visit Recorded

Identify all visits based on the date of service, including both draft and finalised visit invoices. The reported date may be adjusted after the drafted visits are finalised, and visits can be retrospectively created (up to 2 years). Additionally, services may be updated as exceptions are processed.

My Health Record Quarterly Upload

Shows the number of records uploaded by each HCP per quarter in that calendar year (1 November - 31 October) at a specific centre.

Prescription

Immunisation Listing

View the details of each vaccine administered in a selected date range by a specific provider or all providers. Print the report for a specific vaccinator or all vaccinators. If required, you can filter by:

Childhood Only
Declined Only
Include Historical
Include Pending
Over 65/ATSI over 50 Only

Prescription Report

Export the details for all prescriptions written at a selected centre during a specific date range. The report includes the patient's details and the prescribed date, drug details, dose form and dosage details. For S8 prescriptions, the interval between repeats is also included if specified.

Use to report information about prescriptions to the TGA.

Prescription Search by Patient

View all medications prescribed to an individual patient, including dosage information and medication type.

Prescription Search by Number

Display a complete report for the script under that number.

Billing

Fee Adjustments

Monitor the adjustments made to invoices or receipts based on the date of adjustment. This report generates by the adjustment types such as fee changes, refunds, write-offs, did not wait, and receipt adjustments in a specific date range.

Bulk Bill

View a summary of Medicare and DVA claimed amounts and payments in a specific date range for the centre. The reporting date is initially based on the date batched (transaction date). Once the claim is transmitted, the date is adjusted to reflect the transmission (date lodged). Print for all providers or a single provider.

GST Summary Invoices

View a summary of GST invoices generated by practitioners within a specific date range for the centre. This report includes the total amount of invoices with and without GST and GST due amount. Print for all providers or a single provider.

[Deprecated] Outstanding Balances

View all outstanding invoices in a specific date range. You can identify individual debtors or display a combined summary of all accounts by category. For example workers compensation, pre-employment and private.

Note: If any unresolved exception claims (Medicare, Bulk Bill and DVA) are identified, they are marked as outstanding until all the exceptions in those claims have been resolved.

Practice Fees By Item Code

Provides a detailed breakdown of the services invoiced by each practitioner based on invoices issued. The report is broken down by work area, visit type, item code, including total invoiced values. GST is included for relevant items.

For each item code the report details:

Practitioner, Invoiced To and Work area code - the provider code of the practitioner who provided the services, the provider code for who the services were invoiced to, and the work area code in which those services were invoiced.
Visit type - the visit type for the services (Bulk Bill, DVA, Pre-Employment, Private or Workers Compensation) provided.
Item Code - the service's item code.
Qty - the total number of services provided for each item code.
Amount Paid - the dollar amount of the item (GST exclusive).
GST Paid - total tax payable for the item.

To display the breakdown total for each work area or visit type, sort the services by work area or visit type.

Note: Adjustments made to invoices are aggregated and reflect the adjusted value in the month of the changes.

Receipts By Item Code

Provides a breakdown of the number of each type of item code the centre has receipted for each doctor in a specific period.

The Summary page displays:

The total number of each item code by visit type for the selected centre.
The sum of item codes by visit type per practitioner.

Note: Item codes are counted and grouped by visit type and practitioner. If the item codes are repeated in a visit, they will be counted again.

Practices can use this report to help calculate their payroll tax requirements, for example, identifying their percentage of bulk bill item codes to prove their eligibility for payroll tax subsidies or amnesties. For more information about payroll tax requirements, see Medical Services.

For each item code the report details:

Practitioner, Invoiced To and Work area code - the provider code of the practitioner who provided the services, the provider code for who the services were invoiced to, and the work area code in which those services were invoiced.
Visit type - the visit type for the services (Bulk Bill, DVA, Pre-Employment, Private or Workers Compensation) provided.
Item Code - the service's item code.
Qty - the total number of services provided for each item code.
Amount Paid - the dollar amount of the item (GST exclusive).
GST Paid - total tax payable for the item.

To display the breakdown total for each work area or visit type, sort the services by work area or visit type.

Note: The work area reported is taken from the invoice to which the receipts have been allocated to accurately reflect the allocation of monies.

[Deprecated] Transaction Payment

Balance the transaction details of all receipts allocated to a practitioner or visit type. The reporting range is based on transaction payment date (Payment processed date - Medicare payment reflects the deposited date). Date of transaction payment is referenced per line along with the total receipt per payment and the allocated invoices are based on transaction date (visit entry date).

Tip: The date of service is not identified.

Transactions

Review all invoices raised by a practitioner or visit type based on the transaction date (date of entry). The date of the transaction is referenced per line, along with transaction payments (if receipts are issued).

Note: Neither the date of service nor the receipt date are identified.

Practitioner Fee By Item Number

Identify the type of services invoiced per practitioner based on the date of service. The report is broken down by item, including total earnings value and quantity. GST is included for relevant items.

[Deprecated] Bulk Bill

View the summary of Medicare and DVA claimed amounts and payments in a specific date range for the centre. The reporting date is initially based on the date batched (transaction date). Once the claim is transmitted, the date is adjusted to reflect the transmission (date lodged). Print for all providers or a single provider.

[Deprecated] Practice Fees By Item Number

Identify the type of services invoiced per practitioner based on the entry date. The report is broken down by item, including total earnings value and quantity. GST is included for relevant items.

Transaction Payment

Balance the transaction details of all receipts allocated to a practitioner or visit type. The reporting range is based on when the payment is created in the system (the date of payment is when the receipt is allocated to an invoice for all visit types). For Medicare and DVA exceptions, the date reflects when all exceptions have been resolved in a batch and receipts are generated automatically. The report range also includes any adjustments, refunds or adjustments to allocated invoices that occurred in that period based on when those adjustments were created. The date of service is not identified.

For each receipt, the invoice allocations are displayed by line item to enable detailed tracking of receipt allocations and changes to receipts or invoices that might impact payments from previous periods. Receipts allocated to invoice items to a centre are also not included.

Unallocated receipts are not included in this report and will only be displayed once they are allocated to a specific invoice.

Date of transaction payment is referenced per line along with the total receipt per payment and the allocated invoices are based on transaction date (visit entry date).

Tip: The date of service is not identified.

[Deprecated] Receipts By Item Number

Identify the type of services invoiced per practitioner based on the date of receipt. The report is broken down by item and total paid value. GST is included for relevant items.

Outstanding Invoices

Displays outstanding balances owed by account holders, providers, and work area. The report ahows arrears in 30, 60, and 90 days or more periods as of the date the report is generated. Invoices that have been written off are excluded.

Use the report to help prioritise efforts to collect overdue payments.

Note: If any unresolved exception claims (Medicare, Bulk Bill and DVA) are identified, they are marked as outstanding until all the exceptions in those claims have been resolved.

Unallocated Credit

Provides an overview of unallocated credit or funds available to each account holder. Unallocated credit refers to funds that have not been assigned to specific transactions or invoices within the system.

By having both the date of credit and the date of receipt included in the report, you can differentiate between these two aspects and gain a clearer understanding of the timeline associated with unallocated credit entries. This information enables you to track the progression of credit adjustments and receipts, ensuring transparency and accuracy in financial records.

The date of receipt refers to the date when the receipt itself was generated or created in the system. This date indicates the moment when the financial transaction (resulting in the unallocated credit) was processed or recorded. It might not necessarily align with the date of credit if there were delays or timing differences between the adjustment in the invoice and the creation of the receipt.

General

Patient Account Diary Entries

View all patient invoices with an account in a specific date range for the centre. The report displays the last diary entry date and associated details for the patient, enabling you to filter by outstanding balances.

RACGP Active Patient Details

Extract patient information, including name, DOB, and other demographic information, including ATSI status. The report also includes clinical information such as SNAP, Asthma, Diabetes and so on.

The report shows all patients defined as 'active patients' using the RACGP definition. An 'active' patient is a patient who has visited a practice 3 or more times in the last 2 years.

Note: Exporting to PDF is limited to 7000 rows. For full extract, export to CSV.

[Deprecated] Appointment Types

Displays the total number of each appointment type registered by work area in a specific date range for the centre. The report includes all appointment statuses such as booked, confirmed, arrived, cancelled or declined and did not attend.

[Deprecated] Provider Appointments

Displays the total number of appointments created by each practitioner or all practitioners in a specific date range. Work areas are broken down by appointment statuses, such as booked, confirmed, arrived, cancelled, and DNA. The report also shows the total hours of unbooked and available hours.

Appointment Report

Displays a complete list of appointments created by the selected provider or all providers for the centre. For each appointment item, the report includes work area, patient name, appointment details such as date, time, type and status.

PIP QI

Generate and download a PIP eligible data set (snapshot) at this point in time. For more information, see PIP QI Reporting.