Akahu Connection

The Asrosoft Cashflow app has the option for NZ users to import transaction data for multiple bank accounts with a single click.

To set up the link, create a free consumer account at akahu.co.nz, connect the bank accounts that you wish to import transactions from, and then copy and paste the App Token and User Token into the Settings, Options form in the Cashflow app.

You will then have the option 'Import Akahu transactions' in the Cashflow drawer menu.

Changing from OFX import to Akahu

If you have already been importing transactions via OFX files, the best approach is probably to import the Akahu account information first. When you select the Akahu import option in Cashflow it gives you the option of importing accounts and transactions separately. After importing just the accounts, go to the Accounts page in Cashflow and you will see a red merge icon to the right of each imported account. By clicking the merge icon, it allows you to link the Akahu imported account to an existing account in Cashflow, so any Akahu transactions are added to the transactions already imported for that account. If you do not do this, when you import Akahu transactions they will be linked to a separate account.

Security

The Akahu app and user tokens are stored in secure storage on the current device, not in the cashflow database, so any user with whom you share the cashflow database will not be able to import Akahu transactions without re-entering the Akahu app and user token on their device.

Because some banks do not permit separate logins for different entities that you may be responsible for, and Akahu does not allow the same bank login to used for separate Akahu accounts, you may be left in the situation where you have to connect all possible bank accounts to a single Akahu app and user token, and then restrict the accounts to which a specific database has access within the cashflow application. To that end, you can login to cashflow with an admin password, and you will then get the option to block an account in the cashflow accounts page. Blocking an account will delete it from the cashflow application and not allow it to be imported via Akahu. It will be invisible to any user who has access to the application. The list of accounts being blocked cannot be edited, so if you block an account inadvertantly you would have to uninstall cashflow, reinstall it and re-block the accounts you need to block. If you are running cashflow on Windows or Linux contact us using this site's contact page and we will provide instructions on how to remove the secure storage continaing the Akahu tokens and block list.

Note that if multiple users are able to import Akahu transactions on different devices, the account blocking process has to be completed on each device.

Duplicate transactions

After linking the Akahu accounts to the existing accounts, and importing Akahu transactions, you may still get duplicate transactions because OFX and Akahu use different transaction identification, and if the import start and end dates overlap, you will get duplicates. If that happens, turn on the 'Check duplicate transactions' option in the Settings, Options form. Then go to the view transactions page, and for those accounts that have duplicate transactions with the same date and amount, you will see a filter icon in the top right of the page. Tap that icon to show just the potential duplicates. Against each transaction you will see a red delete icon. Tap that icon to delete the duplicate.

Note that the check for duplicates will show a few false positives because it cannot check the payee, and shows all transactions with the same date and amount as possible duplicates, but that will still be enough for you to find any real duplicates and remove them.