Taxable Payments Annual Report and Financial Institution account numbers

Sandra_10124565 · August 2019

Doing my first Taxable Payments Annual Report; using Accounts Premier (Contractor edition) 2019. I followed the instructions here on the Community and removed the symbols etc, then lodged a Test file with the ATO.

I got 3 warnings: all were for having spaces in the Financial Institution Account number (ie. bank account number) of our subbies.

WHY is this uploading with the TPAR? The ATO doesn't ask for it. So why is it included in the report???? How do I get rid of this? And what else is included in the report that we aren't being told about? Is there any way we can see the report and what is in it (not the useless summary that shows as a Preview)?

I see one other community member noticed this issue 3 years ago, but no replies to her comment with why. Apart from the fact that the ATO don't ask for this (and it is none of their business), I didn't double-check these accounts when I went through all our contractors so they might be wrong anyway (I don't pay directly out of the program so I update any changes in our online banking app but not necessarily in Reckon.). And if a supplier has changed bank accounts during the year it would be inaccurate anyway .......

Has anyone else come across this?

Acctd4 · August 2019

Hi Sandra

That’s very strange as the ATO Files (EMPDUPE, PSAR, TPAR, STP) don’t contain banking details - That sounds more like an ABA File !?

Can you describe the exact process you followed & post a screenshot of the specific message you’re getting?

Shaz Hughes Dip(Fin) ACQ NSW, MICB

Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)

Accounted 4 Bookkeeping Services

Ballajura, WA

0422 886 003

shazinoz2@bigpond.com

www.accounted4bs.com

Graham Boast · August 2019

Hi Sandra

I have seen this in a client's TPAR lodgement this week, but rarely, and with 1 client always.

It is just a warning message, and the file will lodge ok, but I agree that there is no way this information should even be in the file.

The file is straight text. copy the file and open in notepad.

Graham Boast 0409317366
graham@reckonhelp.com.au

Sandra_10124565 · August 2019

Hi Shaz,

Definitely contains the banking details!!

My procedure was:
Suppliers - Tax Activities - Process Taxable Payments
Change to 2018-2019 financial year, and click Export. The Preview report has the correct suppliers listed and $ values.

When I uploaded it, the warning message was:
"Reason Code: WM04 The field must not contain blanks or non numeric characters."
Detail of warnings said the field name with the problem was "Fin institution account no", and the Field Data was a shortened version of their bank account number, including spaces which I had.

When I removed these spaces and re-uploaded the file, all warnings were gone.

If you look at the uploaded file in WordPad (as per Graham's instructions below), the information for each client which is submitted is:

ABN
Supplier Name (which in my case still includes alll the odd characters; I didn't adjust this for each supplier as I wasn't aware this field uploaded)
Company Name or First Name/Surname (depending on trading status)
Address Line 1, Town, State, Postcode
Phone number
BSB (if it is entered)
Account Number (bank account) (if it is entered)
Total Gross
Total Tax

If you go onto the ATO Business Portal as though to lodge this report manually, listing a supplier's Bank account details is an optional field. It is not included on the paper forms I have previously filled out for each supplier.

But my original point stands: Why is this information being sent through to the ATO when it is not required, expecially considering several of our suppliers have changed bank details during that year so it won't be accurate anyway. This might create a problem for the suppliers, who I'm sure haven't given us permission to submit their bank account details to the ATO.

The only way I can see to get around this is by removing all bank account details from our Suppliers in Reckon Accounts; which seems like a lot of work and a backward step.

Has anyone else figured out a way around this?

Sandra

Sandra_10124565 · August 2019

Hi Graham,

Thanks - I opened it with WordPad. The results I have listed in my reply to Shaz above. It looks like the full bank account details (BSB and Account number) are included for every supplier where I have it included in their supplier profile in Reckon Accounts.

Not OK Reckon - it's only an optional requirement for the ATO and is quite possibly inaccurate information (it's not as though it's possible to create a new supplier profile every time a bank account changes)!

So it seems I have the choice to dumb down my records on the supplier in Accounts, or send through to the ATO what I would have thought were confidential/potentially inaccurate records.

Don't suppose anyone knows a way to bulk strip these out so I can prepare the report, then bulk replace them again??!!!

Sandra

Taxable Payments Annual Report and Financial Institution account numbers

Comments

Shaz Hughes Dip(Fin) ACQ NSW, MICB

* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

Accounted 4 Bookkeeping Services

Ballajura, WA

(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)

Categories