This information will assist you in completing an unclaimed money or an unclaimed superannuation benefits return file. Only returns which meet the file specifications will be accepted through our online lodgement facility.
When you lodge your unclaimed money return file, the online lodgement facility will validate the file and advise you of any errors. These errors must be corrected before proceeding with lodgement.
Only Comma Separated Value (.csv) or Text (.txt) in comma delimited format will be accepted. The file must be saved with a .csv or a .txt file extension e.g. Sample_File.csv or Sample_File.txt
To make an Excel spreadsheet into a Comma Separated Value file, you will need to save it in a comma delimited format with a (.csv) file extension.
To do this, use ‘Save As’ and select ’CSV (Comma delimited) (*.csv)’ from the ‘Save as type:’ field drop down list:
If the following message is shown, select ‘OK’.
If the following message is shown, select ‘Yes’.
Your return has now been saved as a CSV file and is ready to be uploaded.
The following tables explain the field data rules, the type of records required and the correct order of these records to create a valid unclaimed money return file.
Download a return file template. The file template contains column headers for easy reference. However, a file can be lodged without the column headers as long as the data for each return item is provided in the correct order.
Each file must contain return records for one return period only. A file can have one or more return items, however each return item must be provided on a separate row and there must be no blank rows between return items. Sample files are available on the last page.
Indicates whether the record type is Mandatory (M) or Optional (O). Mandatory record types must be provided. An error will be prompted preventing the lodgement of the return where this data is not provided.
Whether the record type must be Numeric (N), Alpha (A) or can be a combination of Alpha-Numeric (AN). In addition, the maximum number of characters allowable for the record type.
Special rules that apply to formatting data for the record type.
The error message that will be prompted where invalid data is provided.
|PA||Payment and overpayment|
|PS||Proceed of sale|
|TT||Trust fund/Trust account|
The following two file samples have been created with the return file template.
Please note: The online uncliamed money return file template is a Comma Separated Value (.csv) file which has been created in Microsoft Excel. Expand the columns within the online template to view the column headers in full.
Important: The use of commas within data fields of comma delimited (.txt) files should be avoided unless the data for that field is contained within quotation marks.
In the above sample the ‘Last known address’ field contains commas and quotation marks have been placed at each end of the data. eg. “43 Peachtree Cres, Atlanta Georgia, 514863”