Unable to Import (any) Bank Account Statements
PeacockSolutions
Member Posts: 3
Hi,
Previously I have done my accounting by hand with Excel but I want to move over to Wave.
However, I'm stuck with trying to import my bank account statements.
I first tried to connect my bank account (BNZ Business) but after entering my details and clicking the "connect" button, nothing happens. I have tried this on multiple browsers, computers, and networks. This may be because BNZ now enforces 2FA.
Accepting defeat, I then tried to manually import my statements, but this is not working either:
No matter what file type I use, and no matter what web browser I use, I receive the error message:
"Something went wrong with your file upload. Try confirming that the file type is an accepted file type."
I even tried using the csv template to make a "test" document with really simple information, but I still receive this error message.
Do you know how I can resolve this?
Kind Regards,
James
Comments
Hi @PeacockSolutions thanks for reaching out! Could you try uploading your sheet to a Google Sheet, redownloading as a CSV, and letting us know whether this works? If it doesn't, could you also confirm the columns you currently have in your doc?
@Charlotte
The Google Sheets Trick worked great Thanks so much!
I too was struggling with this having formatted and reformatted the Spreadsheets multiple times
Hi Charlotte,
I tried that tip but unfortunately it did not fix anything. I tried it again with two separate files, the first is the default csv from my bank that has the following columns:
Date, Amount, Payee, Particulars, Code, Reference, Tran Type
After that failed, I tried again with the template file provided by Wave, limiting myself to just the 3 column version of that document, but again it would not work (even after uploading to Drive, turning into a sheet, and redownloading).
Same error again in all cases: ""Something went wrong with your file upload. Try confirming that the file type is an accepted file type." And it is repeatable on multiple computers and networks.
Hi @PeacockSolutions As far as we can tell, there seems to be an issue with the connection between New Zealand and the part of Wave that processes your bank statement uploads. The same sort of issue also seems to occur when you try to connect your bank account (BNZ) which is why clicking on the Connect button looks like nothing is happening. We've opened a support issue with our network vendor and expect to hear a response back very soon.
As a workaround in the meantime, if you have the ability to connect to Wave through a VPN in another location (Canada or the US work best), you will be able to connect and upload a bank statement (or connect your account).
We will update this thread when we know more. Apologies for the frustration.
Hi team,
I am also experiencing this issue with BNZ statement upload from New Zealand. What is the latest update on this?
Many thanks
Hi @Ivan thanks for getting in touch. At the moment, we're still investigating this issue. The workaround is to use a VPN to set yourself to another location and then you'll be able to upload successfully. I totally understand that this isn't ideal, and we'll keep digging and share more updates if and when they're available. Appreciate any patience you can extend our way in the meantime.
Hi team ,
Is there a possibility to link my bank account (kuwait) with wave accounting software?
@yousuf does your bank account appear in the dropdown menu at Banking > Bank Connections when you search for it? If not, it means it's not supported and you'll need to upload your statements instead. You can also submit a request to have your bank supported from the "can't find your bank?" prompt.
Of course, if your bank appears there, just follow the steps to verify the connection and you're good to go!
Thanks for your reply
Yes, I am located in New Zealand and have been getting the same error message since last year. It was working well before that and we were very happy with Wave. Actually, it started working again a few months ago, and now not! Looking forward to the fix. Thanks.
Thanks for your patience @trcl please don't hesitate to join other conversations in the meantime, or to let us know if there is anything else our team might be able to assist with.
@Charlotte @NickPresta - Unfortunately I'm another victim to this problem. I bank with ANZ from within NZ. Same issue. Was working and now it's not. Just confirming that it's not an isolated BNZ issue. Thanks
@Charlotte @NickPresta @Pat_NZ Similar problem here, trying to link to Westpac Online (NZ) bank accounts from NZ.
Interestingly this service used to work perfectly. I just can't pinpoint when the problem was introduced.
BTW, what was the response from your network vendor? Are they blacklisting New Zealand IP addresses or something?
Hi same issue, trying to upload a Kiwibank account in NZ, have tried both CSV and OFX and get this same error message, really disappointing as this software looks so promising
Hi @Nienna ! Thank you for reporting this issue. Many of our NZ users have reported troubles with uploading CSV files. If you have access to a VPN, could you please try uploading your CSV with your location set to the USA? This seems to be a working solution for many of the affected NZ users.
Another solution would be to upload those transactions using Wave Connect. Wave Connect allows you to upload or download transactional data, invoices, customer lists, etc, into a Google spreadsheet. More information about Wave Connect can be found here: https://support.waveapps.com/hc/en-us/articles/360020768272-Wave-Connect-Easily-import-and-export-data-with-Wave-s-Google-Sheets-add-on-
The CSV upload issue for NZ users is something that we are aware of and the team is currently investigating the cause of this.
@SimonE NZ IPs have not been blacklisted. Our developers are actively investigating the issue of NZ IPs having troubles establishing bank connections and uploading CSVs. Please keep an eye on this thread for future updates. I apologize for the inconvenience.
In the meantime, have you had any luck with using a VPN to change your IP? If you are still having troubles with connecting a bank account or with uploading statements, please send me a DM, I'd be happy to follow up with you to provide further assistance.
I have the same issue in Australia. A VPN to the US fixed the issue.
I have the same issue in the UK. Connecting to a VPN in USA fixed it for me as well.
@Rich_S
We've been hearing reports of this a lot. Thanks so much for confirmation regarding it. As a personal preference, copying the CSV data into Wave connect is my personal preferred method.
I have had ongoing issues for a few months with my ANZ (New Zealand) accounts, which suddenly wouldn't update or connect. A range of previous suggestions and support request responses didn't solve me problem, until I stumbled on this thread. I have now managed to connect using a US VPN, and my bank accounts now update correctly. Hopefully you're able to sort out the problem long term to restore normal functionality without having to log into a VPN each time. Thanks.
Hey @davegee! Thanks for your feedback here! I'm glad to hear you were successful with this method as well. I appreciate it isn't great to have to use a workaround to get there. I am in Canada and have an issue connecting my ASB account to Wave. Hopefully it is something we can can restore in the future for all Kiwi banks!