Accept Jonas Premier TPAR export format as attached
Output the required format for submission to ATO, without errors
To minimise errors, we need to make some substitutions and amendments:
Create new import format for Jonas Premier, which accepts our file format above, and maps the required info to your data structures
Duplicate ABN Consolidations. Automatically select a primary record, and consolidate duplicates. Provide a log of consolidations.
Convert Gross payments, GST & Tax withheld to “FLOOR(x)” automatically to remove cents, aso no errors appear at this step
Use substitutions to automatically remove any characters the ATO will not allow in submissions. Eg
Find “&” Replace with “and”
Find “+” Replace with “and”
Find “/” Replace with “ “ (space)
Find “-“ Replace with “ “ (space)
Find ‘ Replace with “ “ (Replace apostrophe’s with nothing)
Find “(“ Replace with nothing
Find “)” Replace with nothing
Test 4 sample files, and ensure all 4 can be imported without error, and a successful ATO file format can be produced.
Here are the requirements:
To minimise errors, we need to make some substitutions and amendments: