IMPORTANT: Before running the NAHA/ Data Collection Report, you must copy the 2019 template in to your Chintaro\Data\Templates folder and update your version of Chintaro. If you are a Chintaro Cloud user, you do not need to do this - Support have updated your version and added the template to your Data\Templates folder. 


Copying the 2019 template to your Data\Templates folder

The NAHA Reporting templates are attached in zipped files at the bottom of this Solution. The template you that you need to download will depend on your state:

For Chintaro users in Queensland only, download the NAHA19QLD.zip

For Chintaro users in all states or territories, download the NAHA19.zip file


The NAHA template is in a zipped file. You will need to extract the worksheet from your Downloads folder on your PC. Then, copy the unzipped NAHA Template from your downloads folder, and paste it in to your Chintaro/Data/Templates folder.



Updating Chintaro

After you have copied the templates (attached) to your Chintaro\Data\Templates folder, you will need to update your version of Chintaro the applicable code database:


For Access users, click this link.

For SQLx users, click this link.


If you would like further assistance updating, please ask your IT to help you, or contact support@chintaro.com.au to schedule a meeting.



Opening the NAHA/ Data Collection Report screen

To run the NAHA/Data Collection report, from the Reports and Exports Sub-Menu, click NAHA/Data Collection Report and the 2019 NAHA (AIHW) Annual Data Collection Report screen will open:



 Occupancy Calculation Warning

The NAHA/Data Collection Report will only run if you have completed the Occupancy Calculation (or the HPF Report) for the entire financial year. If you have not run the Occupancy Calculation for the entire financial year, you will see a warning on the right hand side of the screen:



You will also see the periods that you have run the report for in the box below this message. You will need to exit this screen and run the Occupancy Calculation for the periods you have not yet run the calculation for. Click here to view the Solution for the Occupancy Calculation. 


Once you have run the Occupancy Calculation for the entire financial year, the Occupancy Calculation warning will disappear. 


Entering details for the NAHA/ Data Collection Report 

If you do not see the Occupancy Calculation warning, the Start of Financial Year Date and End of Financial Year Date will default to the current report period, but can be overwritten if required.

 

Select the Output Folder as the location you would like to save the NAHA Report. 

 

Enter an Output File Name as the name you would like to save the NAHA Report as (this will default to NAHAReport).

 

Select the Program(s) that you want to report on from the Report Program Filter box from the multi select box. If you do not select any Programs in the Report Program Filter box, Chintaro will assume you want to report on all Programs listed.


If your Rent figure includes the Commonwealth Rent Assistance, tick thebox


If your Income figure includes Commonwealth Rent Assistance, tick thebox 


Select the Commonwealth Rent Assistance field appropriate for your Organisation from the box below:



If you will be using the ISIP/CPG/UPI number as the Property ID, tick thebox.



Running the NAHA/ Data Collection Report 

There are 2 options on the screen for when you are ready to run the report. 

1.) The first option is to create files to export in CSV format. This will export the files in to 4 Click Create Report (files) if you wish to create the files.


Instead of using coloured cells to show you potential discrepancies, the validator will alert you to any data that your need to check before submitting your report. For further information, check the information sent to you by the AIHW for Validata. 


2.) The second option is to create the report (xls) to populate the data from Chintaro in to the NAHA Report template. To create the NAHA Report using the NAHA Template, click Create Report (xls):

 

The NAHA Report will appear in a Microsoft Excel worksheet, where you will see the data from Chintaro auto-populating each line in the report. To open your report, go to the output folder you selected on the left hand side and open the report.



Interpreting the data on the NAHA Report

Please see the following solution for Preparing Chintaro for the NAHA Report for a detailed explanation of where the data is pulled from Chintaro for the NAHA report.