Bank feeds vs statement imports: which is better for a small business?

There are two ways to get bank data into your books. Neither is always better, so here is how to choose.

By the AvrioBooks team · · 6 min read

Bank feeds vs statement imports: which is better for a small business?

To reconcile your bank, your accounting software needs your transactions. There are two common ways to get them there: an automatic bank feed, or a statement import from a file. Each has strengths. This is an honest look at both.

How bank feeds work

You authorise a connection between your bank and your software, and new transactions appear automatically, usually every day. The connection often needs to be re-authorised from time to time, and it only works with banks the provider supports.

Strengths

  • Transactions arrive without any action from you.
  • You always see recent activity.

Weaknesses

  • Connections can break and need re-authorising.
  • Not every bank or account type is supported.
  • Your software provider, and possibly a third-party aggregator, handles access to your bank data.
  • It is easy to stop looking, and to let mistakes pile up.

How statement imports work

You download a statement from your bank as a file, such as CSV, OFX, QFX or QIF, and import it into your software. Transactions are matched to your invoices and bills.

Strengths

  • Works with almost any bank that lets you download a file.
  • No live connection to your bank, and no third party holding access.
  • You can import history, and re-import corrected statements.
  • A regular import is a natural moment to review your books.

Weaknesses

  • It is a manual step, so you must remember to do it.
  • Importing overlapping dates can create duplicates unless the software checks.
  • Formats vary between banks.

How to choose

  • Hundreds of transactions a week and a supported bank: a feed saves time.
  • Fewer transactions, or a bank that is not supported: imports are perfectly good.
  • You want tighter control or minimal third-party access: imports.
  • You want daily visibility of cash: a feed, or a weekly import.

What matters more than the method

Whichever you use, three things make the difference: bank rules that categorise repeat items, a regular reconciliation, and a lock date once a period is done. See bank reconciliation explained and common mistakes.

How AvrioBooks works

AvrioBooks uses statement imports (CSV, OFX, QFX and QIF) with suggested matches, bank rules and Auto-reconcile. It does not have automatic bank feeds yet. See bank reconciliation software and how to import a bank statement.

Frequently asked questions

What is the difference between a bank feed and a statement import?

A feed connects to your bank and brings in transactions automatically. An import takes a statement file you download, such as CSV, OFX, QFX or QIF.

Are bank feeds more accurate?

Not necessarily. Both bring in the same bank data. Accuracy depends on reconciling regularly and using bank rules.

Does AvrioBooks have bank feeds?

Not yet. It imports statements as CSV, OFX, QFX or QIF.

Can statement imports create duplicates?

They can if you import overlapping dates. Check the imported statements list and remove any duplicate.

Written by the AvrioBooks team. We build cloud accounting software for small businesses, freelancers and their accountants, from Qodexify. This article is general information, not tax, legal or financial advice. Check GOV.UK or ask an accountant about your own situation.
Try AvrioBooks free Start a 30-day free trial with everything in Premium, no card needed. Start free trial
Newsletter

Accounting tips, tax dates and product news

Practical bookkeeping, VAT and Making Tax Digital guidance for freelancers and small businesses, plus AvrioBooks updates.

By subscribing you agree to receive emails from AvrioBooks. Unsubscribe at any time. See our privacy policy.

Sign up freeContact us