First time here? Check out the FAQ!
x

When we try to import to ASB bank it and says the format is incorrect.

0 votes
asked by about RTL Bill Payment Utility
edited by

When we try to import to ASB bank it and says the format is incorrect.

Now the new file has commas and dashes - Using just 2 lines

12,12323700101x x ,280613,"JONEL HYDRAULICS","01900084806",307.84,1
01-0190-0084x x x-002,051,307.84,"AIR FRANCE","","","JO1483","JONEL HYDRAU","","","",""

The old file for a different payee reads with no commas or dashes -

1212323700101x x 280613 JONEL HYDRAULICS 0
130118360000x x x 0510008477190 ADC LTD AC 99 JON JONEL HYDRAU JONEL HYDRAULICS 0WITH THE SAME " "".

What format is right?

1 Answer

0 votes
answered by (264k points)

The file you should use needs to be separated correctly. If you attempt to load a file without the quotation marks, the software will give you errors because it doesn't have any idea how to place the entries. You will see one big line with all the data. My advice is to use the CSV with the quotation marks. Additionally, try importing the files without submitting them. This way you can see what the software accepts as being a good file.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...