ABA file error in ANZ Description is missing or in an invalid format.. Does anyone know how to fix this?

  • 2
  • Question
  • Updated 1 year ago
  • Answered
I am loading an ABA file created in Reckon to ANZ. Same way as I do for other ABA files which were successful. But now getting this error message. Any ideas?
Photo of Annie O'Connor

Annie O'Connor

  • 190 Points 100 badge 2x thumb

Posted 1 year ago

  • 2
Photo of John G

John G, Information Support Analyst

  • 27,360 Points 20k badge 2x thumb
Hi Annie,

Thanks for asking.

Firstly, in the Online Banking Centre, To Bank area, check the entry in the Payment Description field contains only text and numerals.  Create the ABA file again and upload it to the ANZ.  

If you still get an error, then go to the Online Bank Details tab of your bank ledger account setup and look at the "Include balance record" field.  Tick this box if it's not ticked.  Untick it if it is ticked.  

Create the ABA file again and upload it to the ANZ.  

Hope you have better success this time


regards,
John
Photo of Annie O'Connor

Annie O'Connor

  • 190 Points 100 badge 2x thumb
Thanks John, this fixed my problem. I had entered the payment description field with a $ symbol. Once I removed this the ABA file loaded successfully. 
As an FYI I have also since discovered that if a company name is too long (I think 17 characters) the whole batch will not load. 
Photo of John G

John G, Information Support Analyst

  • 27,360 Points 20k badge 2x thumb
Thanks Annie will let the developers know.  Sounds like it may be a limitation at the bank end as the Name field inside the ABA File keeps expanding to take the length of the name.


regards,
John
Photo of GaryP

GaryP

  • 230 Points 100 badge 2x thumb
Annie did this fix your problem?  I'm having an error also and wondering if this is the solution?
Photo of John Moussa

John Moussa

  • 162 Points 100 badge 2x thumb
i have the same error, (Error in Input Data)
Photo of GaryP

GaryP

  • 230 Points 100 badge 2x thumb
Hi John, do you use ANZ?  If so look for my post this problem as I resolved it.  One final thing to add is make sure you rename the LONG file name that is auto generated by Reckon.  It's "ANZ_blah blah blah LONG blah.ABA"   Rename it to just ANZ.ABA - that's another thing I need to do to avoid the error.  But read my other post about the problem that might help.
Photo of John Moussa

John Moussa

  • 162 Points 100 badge 2x thumb
thanks, garyP, I tried but I get a new error
Photo of John G

John G, Information Support Analyst

  • 27,360 Points 20k badge 2x thumb
Hi John,

When you Preview ABA File do you see all fields completed like this:


(When paying from an ANZ Bank, the Bank field should contain the code: ANZ)


regards,
John
Photo of John Moussa

John Moussa

  • 162 Points 100 badge 2x thumb
where should i Preview ABA File?
Photo of John G

John G, Information Support Analyst

  • 27,360 Points 20k badge 2x thumb
Hi John,

Banking > Online Banking Centre > Preview ABA file button.




regards,
John
Photo of A Balancing Act

A Balancing Act, Accredited Partner

  • 1,914 Points 1k badge 2x thumb
And just to add confusion, if you are working with RA Hosted in New Zealand, ANZ comes up as AZN in the "bank" field.