Banking, Feeds, and Reconciliations

Bank Feeds

Estimated reading: 8 minutes

Connect your bank accounts to Akaunting and let your transactions come in on their own. Bank Feeds records them as income and expenses, keeps you from entering anything twice, and helps you match payments with your invoices and bills, so you spend less time on bookkeeping and more on your business.

Connecting a Bank Account

Connect your bank once, and Akaunting brings in its transactions every day.

  1. Install the Bank Feeds app.
    Check out how to Install an app here.
    On your own server, set up Plaid or GoCardless first (see Setting Up Plaid and GoCardless). On Akaunting Cloud, there is nothing to set up.
  2. Go to Banking on the navigation menu, select Accounts and click New Account.
  3. Search for your bank, or click it in the list of popular banks. To see the banks of another country, click the country next to Country and pick it.

Note: Bank Feeds is available for banks in the United States and Canada (through Plaid), and in the United Kingdom and 30 European countries (through GoCardless).

Tip: Can’t find your bank? Click Add Account Manually to add the account yourself and import its transactions from a bank statement file.

  1. Akaunting sums up what happens next. Read it and click Continue and log in to bank.
  1. A secure window of your bank opens. Sign in and choose the accounts you want to share with Akaunting.

Note: Your bank login stays with your bank: Akaunting never sees it. Akaunting can only read the balances and transactions of the accounts you choose, and cannot move money.

Once you have signed in, you are back in Akaunting to set up your accounts.

Setting Up Your Accounts

Tell Akaunting which account each of your bank accounts belongs to, and how far back to import.

  1. For each bank account, select the Akaunting account it belongs to. Leave New account in Akaunting to have a new account created for it. Akaunting selects the accounts it recognises for you; check them before you carry on.
  • To leave a bank account out, click the crossed link icon next to it.
  • To create or leave out all of them at once, use Apply bulk action.

Note: An Akaunting account can be connected to one bank account only. Credit cards are created as credit card accounts.

  1. Click Continue.
  2. For each account, click Edit start date and choose the day Akaunting starts importing from: Yesterday, Today, Last 30 Days, Last 90 Days, As far back as possible, or Custom to pick a date.

Tip: If you have entered transactions by hand before, start from the day after the last one, so that nothing comes in twice.

  1. Click Finish. What happens next depends on where your Akaunting runs:
  • On Akaunting Cloud, the wizard ends here and the import runs in the background. You are taken to your account, or to the Accounts page when you connected several, where the accounts show Syncing… until the import is over. You can carry on working in the meantime; you’ll get an email and a notification when your transactions are in.
  • On your own server, the same happens when background jobs (a queue worker) are set up. Without them, the wizard has a third step: Akaunting imports your transactions in your browser and shows how far it has got for each account. Keep the page open until it finishes; if you close it or go to another page, the import stops halfway.

When the import is over, your transactions are on your accounts as income and expenses, with their contact and category.

Keeping Your Transactions Up to Date

You don’t need to do anything: Akaunting fetches new transactions from your bank every day.

On the Accounts page, each connected account shows its bank’s logo and a status line: Feed Connected, the date of the Last Sync, and the date the connection is Active until.

  • To fetch new transactions right away, click Fetch Transactions on the account, or on the account’s page.
  • Your bank may categorise a transaction. If it doesn’t, Akaunting uses the default categories of the app’s settings (see Choosing Default Categories).

Note: Banks in Europe and the UK allow a few requests a day for each account. When today’s are used up, the bank’s logo gets a mark and Fetch Transactions tells you when you can try again. The daily sync carries on as usual.

Matching Unmatched Transactions

When a bank transaction looks like a transaction you have already entered (same account, same date, same amount), Akaunting does not record it a second time. It waits under Unmatched Transactions for you to decide. Transactions your bank still shows as pending wait there too.

  1. On the Accounts page, click Match … Transactions on the account; the button shows how many are waiting. Or open the account and click the Unmatched Transactions tab.
  1. Move the mouse over a transaction. Three buttons appear; choose the one that fits:
  • Connect to invoice / Connect to bill: the money paid an invoice or a bill. Akaunting lists the open ones in the same currency with enough left to pay. Click Add Payment next to the right one.
  • Match with income / Match with expense: you have already recorded this transaction. Akaunting lists the ones with the same amount, and says whether each is on the Same day or how many days apart. Click Match next to the right one.
  • Create as income / Create as expense: record it as a new transaction. Check the date, contact, category and description, then click Save.

Note: A button is greyed out when nothing fits; move the mouse over it to see why, e.g. “No expense to match”.

Tip: If you delete a transaction that Bank Feeds recorded, its bank transaction goes back to Unmatched Transactions, so you can match it again.

Pausing the Sync of an Account

Stop the import for one account and keep its bank connection, e.g. for an account you no longer use.

  1. On the Accounts page, click the ⋯ (more) button of the account and select Disable Sync.
  1. Click Disable to confirm.

The account now says Sync Disabled. To start again, click Enable Sync on the account: Akaunting fetches the transactions from where it stopped.

Renewing a Bank Connection

Your bank asks you to renew your permission from time to time: about every 90 days for banks in Europe and the UK, and about once a year for banks in the United States and Canada. Akaunting reminds you by email and in your notifications 7 days and 3 days before, and on the day the connection ends.

When a connection is about to end, its accounts show a mark on the bank’s logo, the Active until date turns orange, and a Reconnect button appears.

  1. Click Reconnect on the account. You can also click the ⋯ (more) button and select Reconnect at any time.
  2. Read what Akaunting needs your approval for, and click Continue and log in to bank.
  1. Sign in to your bank again.

Your accounts and the transactions already in Akaunting stay as they are, and the import carries on.

Note: If you pick a bank you have connected already on the Bank Connect page, Akaunting opens that connection instead of making a second one.

Removing a Bank Connection

  1. On the Accounts page, click the ⋯ (more) button of one of the bank’s accounts and select Delete Bank Connection.
  2. Confirm.

Akaunting stops importing from that bank. The accounts and transactions already in Akaunting are kept; bank transactions that are not matched yet are deleted with the connection.

Tip: To stop the import for one account only, disable its sync instead. Deleting the account itself removes it from the connection too; the bank’s other accounts carry on.

Bank Feeds Settings

Go to Settings and select Bank Feeds. What you find there depends on where your Akaunting runs.

Choosing Default Categories

  1. Select the Income Category for incoming money and the Expense Category for outgoing money that your bank does not categorise.
  2. Click Save.

Setting Up Plaid and GoCardless

On Akaunting Cloud, there is nothing to set up, and the settings hold only the default categories. Akaunting runs the connection to Plaid and GoCardless for you: it uses its own accounts with both services and keeps their keys safe on its servers, so you don’t need an account with them or any keys of your own. Bank Feeds is ready to use as soon as the app is installed.

On your own server, Akaunting cannot use its own keys, so the connection to Plaid and GoCardless is yours to set up. The settings have a Plaid section and a GoCardless section:

  1. Sign up with the service of your banks: Plaid for the United States and Canada, GoCardless for the United Kingdom and Europe.
  2. Enter the Client ID and Secret Key the service gives you, and set Enabled to Yes.
  3. Click Save.

Note: The Bank Connect page lists only the countries of the services that are set up and enabled. While none is, New Account takes you to these settings instead.

Share this Doc

Bank Feeds

Or copy link

CONTENTS