The Small Business Accountant
- Username TSBA007
- Visits 19
- Last Active
- Roles Member
- Points 21
- My site
- About me
- The Small Business Accountant
TSBA00722Seven - at least the live feed download from multiple banks is automated (no login required) and the export can be done once across all banks for say a monthly period... filter the CSV and import to Wave... still not fully automated, but still free at about 90% automation.
Also the 22seven login can be shared with an accountant without sharing your direct login details to the bank... security... check
I've tried something similar using a combination of TillerHQ to download bank statements and Zapier to copy the data into a spreadsheet suitable for upload via Wave connect. It mostly works but I don't have the time to iron out bugs so would be interested in something similar?
If you have only one bank account, logging in to the internet banking platform and getting a CSV file might not be too much of a hassle. However, some banks' exports are not easily downloadable, some don't give it in CSV or the right format.
We run an accounting firm so we had to take into account multiple clients, multiple banks, multiple types of accounts, multiple logins and multiple CSV exports to process. Obviously we couldn't rely on clients to log in, export and submit CSV files on a monthly basis, let alone weekly or daily!
Old Mutual (South African local) has a tool called 22Seven that basically talks to all the banks and financial institutions and at least combines all transactions into one place. You still have to log in once, but the CSV download is clean and can be downloaded once for all bank accounts to be imported, filtered and uploaded into Wave from there.
90% automated is better than nothing!
Hope this helps
Rudolf | TSBA