Reports
VHC Service Providers are able to access reports through the VHC Provider Portal reporting functionality. 
Reports that can be downloaded from the VHC Provider Portal
Users can download the following reports from the VHC Provider Portal that are populated based on the Service Provider(s), region(s) and date range parameters that they select.
•	Remittance Report - This is downloaded as a CSV file and can be converted to a file type determined by the user or recommended by the user’s IT department (e.g. Excel, Access etc.). 
•	RCTI Report – This is downloaded as a PDF report. Recipient Created Tax Invoice (RCTI) reports are produced by Service Provider.
This document helps users to access and download the appropriate report.
Remittance report
Once claims have been submitted in the VHC Provider Portal, remittance details are available to portal users. The remittance is a receipt for claims that have been successfully submitted. The report displays the expected remittance expected for the pay run in which the submitted claim will be paid.
In order to download the remittance report, users must have one of the following access roles in the VHC Provider Portal:
•	Read only
•	Claims Officer
•	Portal Manager
It is intended that users will use this file to support their internal processes, as required. 
Downloading the Remittance report
To download the Remittance report:
1.	From the Home tab, select the Administration tab.
2.	Click the Reports link.
The Reports screen displays.

3.	From the File type field, select Remittance report. 
The Remittance report criteria displays

4.	If you wish to generate a remittance report by bulk claim, enter the Bulk Submission ID  number; or
5.	From the Service providers Available field, select the names of the Service Providers to include in the Remittance report (hold Shift or Ctrl to select or deselect multiple options). 
6.	Click the  Add>> button to add the selected Service Providers to the Service Providers Selected field.
7.	From the Regions Available field, select the regions to include in the Remittance report (hold Shift or Ctrl to select or deselect multiple options). 
8.	Click the  Add>> button to add the selected regions to the Regions Selected field.
	Users can deselect Service Providers or regions from the Selected fields, by selecting them and clicking the <Remove button(s).	
9.	From the Payment date field, select the payment date from the list. This aligns to the monthly payment cycle and includes past payment periods and the next payment period. 
10.	Click the Download file link to download the report as a Comma-Separated Values (CSV) file or click Clear to perform a different report search. 
	If there are no records to display, the system will request the user confirm if they  wish to generate an empty report.	

	Users can save the CSV file to any drive to which they have access to in their organisation.	

Remittance report details
The Remittance report file provides a list of all claims for a designated Service Provider, region and date range combination at the point in time the file is generated. It is intended that users will use this file to support their internal processes, as required.
	In the event there are no records to display, the system will inform the user of this and confirm whether or not the user still wishes to generate the (empty) file.	

Example Remittance report: displayed using Notepad

Example Remittance report: displayed using Excel

All records will be sorted in ascending order using the following sequence:  
•	Service Provider name
•	Provider UIN
•	Region Name
•	Claim No
•	Claim Date

File name 
The name of the downloaded file will include:
•	“Remittance_Report”
•	14 character unique numeric
For example: Remittance_Report_14031445166328
Information provided
The Remittance report is a comma-delimited ASCII text file, with an extension of CSV (comma-separated value).
Any extracted value (i.e. the value between the comma delimiters that define field values) that contains a comma will be enclosed by inverted double-quotes.  For example, “Sydney, metropolitan”.
The table below provides a description of each item within the report:
Header record	Description	
Report Title	REMITTANCE	
Report sub-title	Department of Veterans’ Affairs	
Remittance Report for date range	The payment period start and end dates.	
Created date	The creation date of the report.	
Created time	The creation time of the report in the format HH:MM:SS using Australian Eastern Time (AET).	
Providers included	The name of each Service Provider included in the selection for the report	
Regions included	The name for each region included in the selection for the report 	
Remittance from date	The payment period start date.	
Remittance to date	The payment period end date.	
Total paid claims	The total unadjusted amounts for all claims in the period with a status of Paid. These are arranged into the Fee, GST and Total Amount columns.	
Total pending claims	The total unadjusted amounts for all claims in the period with a status of Pending Payment. These are arranged into the Fee, GST and Total Amount columns	
Remittance total	The total amounts of the Paid and Pending Amounts above.	
Details for each claim:	
Provider display name	The name of the Service Provider relating to this claim.	
Provider UIN	The Service Provider’s UIN relating to this claim.	
Region name	The name of the region relating to this claim.	
Submitted By	The name of the user who submitted the transaction.	
Provider Reference	The provider reference entered on the claim.	
Bulk Claim No	The bulk claim number for the claim if submitted as part of a bulk claim.	
Claim no	The claim number.	
Claim Date	The date of the claim.	
Service Plan ID	The Service Plan number relating to this claim.	
Service Type	The service type relating to this claim. For example, DA for Domestic Assistance or PC for Personal Care.	
Period, Start Date	The number of the period in the Service Plan and the start date of the period relating to this claim.	
Date Provided	The date the service was provided.	
Hours Provided	The number of hours that were provided.	
Fee $	The amount of the fee (excluding GST).	
GST $	The GST amount.	
Total Amount Payable $	The total amount payable relating to this claim.	
Payment Status	The status of the payment. For example, Pending or Payment Paid.	
Due Date	The date the payment was/will be paid.	
Adjustment indicator	An unlabelled column that indicates claims that have adjustments. If an adjustment has occurred on the claim,. this will be identified by a ‘#’	
Recipient Created Tax Invoice (RCTI) report
The RCTI report is available to Service Providers that have an RCTI agreement with DVA to record details of services provided under the DVA VHC program. The RCTI report is made available on completion  of the monthly payment cycle. The report displays the payments made in a selected pay run. 
In order to download the RCTI report, users must have one of the following access roles in the VHC Provider Portal:
•	Read only
•	Portal Manager

It is intended that users will use this file to support their internal processes, as required. 
Downloading the RCTI report
To access the RCTI report:
1.	From the Home tab, select the Administration tab.
2.	Click the Reports link.
3.	From the File type field, select RCTI report. 
The RCTI report criteria displays

4.	From the Service provider field, select the Service Provider for which you wish to run the report. Only one service provider can be selected per report.
5.	From the Payment date field, select the required payment from the list. This aligns to the monthly payment cycle. 
6.	Click the Download file link to download the report as a non-editable PDF file. 

	If there are no records to display, the system will request the user confirm if they  wish to generate an empty report.	

	Users can save the PDF file to any drive to which they have access to in their organisation.	

RCTI report details
The RCTI report file provides a list of all claims and adjustment to payments made in previous periods, for a designated Service Provider and date range combination at the point in time the file is generated. It is intended that users will use this file to support their internal processes, as required.
Example RCTI report in PDF format:

File name 
The name of the downloaded file will include:
•	“RCTI Report”
•	RCTI Number 
•	Date of Issue
For example: RCTI_12345_11062014.pdf
Information provided
The Remittance report is available in PDF format. The table below provides a description of each item within the report:
Header record	Description	
Report Header	Recipient Created Tax Invoice Department of Veterans’ Affairs	
Date of Issue	The payment date for the claim period.	
RCTI Number	The system generated RCTI number.	
Service Provider Details	Includes the Service Provider name, address, phone, UIN and ABN.	
Balance Brought Forward	This is only relevant where an adjustment has occurred that has not been fully reconciled on the previous RCTI report 	
Claim no	The claim number.	
Claim Date	The date the claim was submitted in the VHC Provider Portal.	
Service Plan ID	The Service Plan number relating to this claim.	
Service Type	The service type relating to this claim. For example, DA for Domestic Assistance or PC for Personal Care.	
Period, Start Date	The number of the period in the Service Plan and the start date of the period relating to this claim.	
Date Provided	The date the service was provided.	
Hours Provided	The number of hours that were provided.	
Fee $	The amount of the fee (excluding GST).	
GST $	The GST amount.	
Total Amount Payable $	The total amount payable relating to this claim.	
Paid on	The date the payment was made to the provider for the claim.	
Totals	Displays the totals relating to all the items claimed in the pay period prior to any adjustments being recorded.	
Recipient Created Adjustment Note	Appears only if RCAN adjustments are applicable.	
Adjustment/s to	The original claim is displayed followed by the over or under payment amount.	
Total Decreasing Adjustments	This applies to over payments and displays the amounts by which the adjustment will reduce the total amounts payable for this RCTI.	
Total Increasing Adjustments	This applies to under payments and displays the amounts by which the adjustment will increase the total $ amounts payable for this RCTI.	
Balance Carried Forward	This is only relevant where for example, an adjustment has occurred that has not been fully reconciled on the RCTI.	
Totals Payable for this RCTI	This displays the total value which was actually paid in the pay period for items claimed and adjustments applied.	
Informational Text	“THE GST SHOWN IS PAYABLE BY THE SUPPLIER TO THE ATO”
“THIS AMOUNT IS INCLUDED IN THE TOTAL AMOUNT OF GST SHOWN ON REMITTANCE”	

	A RCAN will only be reported if there have been any adjustments made on previous payments