About me

The Small Business Accountant

TSBA007

Community stats

Username TSBA007
Joined
Visits 19
Last Active
Roles Member
Points 21
Badges
3
My site
http://tsba.co.za/
About me
The Small Business Accountant
Posts
2

Activity

  • Miwix

    Do share...

    November 13, 2019
    • TSBA007
      TSBA007
      22Seven - 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
    • Fastore
      Fastore
      Hi,
      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?
    • TSBA007
      TSBA007
      Hi Fastore

      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
  • TSBA007 changed their profile picture.
    Thumbnail
    November 13, 2019
  • TSBA007 changed their profile picture.
    Thumbnail
    November 13, 2019