Skip to the guide
IQ Booksby ReconcileIQ

Banking · Guide 25 of 53

Connecting a bank feed

Link a bank through Open Banking so lines arrive every day as coded drafts: what to expect from history, holds, credits, reconnecting, and how it sits alongside CSV import and CodeIQ.

A bank feed brings your bank’s lines into IQ Books every day without a statement upload. Each line lands as a draft on the right bank account, coded by CodeIQ, with transfers between your own accounts paired automatically. Anything uncertain waits with a reason instead of being guessed.

Where to start

Two doors, same wizard:

  • Banking → Bank accounts: the bank card shows No feed · Connect a feed. Click it to open that bank’s Feed tab, then click Connect a feed.
  • Settings → Bank feeds: every connection in one place, plus Add another bank at BankSync once the first is live.

The four steps

  1. What this is. What arrives (daily lines as coded drafts) and what it costs: 4 credits a line when it is coded, nothing for lines that only land, plus BankSync’s own charge from US$4 a month. Continue moves on.
  2. Choose the source. Where does the money arrive? Pick A bank or card to connect through BankSync, our Open Banking partner: you create a BankSync account (or sign in), choose the bank, log in with the bank, and tick the accounts to share. IQ Books never sees your bank login; it receives only the accounts you tick. The same step offers Stripe (a read-only restricted key) and, where it is switched on, eBay; each has its own guide.
  3. Match accounts. Each shared account is matched to a bank account in these books, or Create new makes one for it, or Leave unmatched (no feed) skips it. A suggested match uses the currency and the last four digits of the account number. Match and start saves the matches.
  4. How it runs. Code new lines automatically on or off, Post automatically when confident (Off, At 90% or At 95%), a monthly credit cap (2,000 unless you change it), the daily digest (off unless you tick it), and the pull-from date. Done, start the first pull saves these and starts the first pull.

How far back a feed goes

A new Open Banking consent gives roughly two to three months of history for most UK banks; the bank decides the exact cut. For anything older, use CSV import on the bank’s page. A statement that overlaps the feed window is matched line by line against what the feed already brought in, so an overlap does not double anything. The consent itself usually lasts 90 days and is renewed from the Feed tab.

What happens every day

  • Lines land as drafts. The feed is checked daily, and most banks also push new activity as it appears. Each line becomes a draft on its bank account in Banking → Review drafts.
  • CodeIQ codes them. With automatic coding on, each new draft is coded once, at 4 credits a line, the same charge as the Code with CodeIQ button. A confident suggestion fills the category; a weak one sits behind a CodeIQ chip for you to pick. Lines that only land cost nothing.
  • Transfers pair themselves. An equal and opposite line on another of your accounts within a week is booked as one transfer, including a partner that arrives later or on an account you connect later. A transfer with no partner yet waits, and after the window passes it asks you.
  • Holds carry a reason. A line still pending at the bank, a locked period, or an unpaired transfer waits in the Waiting panel below the drafts, with the reason and a Decide now button.

At each month end

Where the feed reports the account’s balance, the month end reconciles itself: when the balance the feed reported on the last day agrees with the books and nothing dated by then waits in Review, the month is recorded as reconciled on the Reconcile tab and its lines are ticked. When it does not, RiQ says what stands between them. See Bank accounts and the cashbook, Reconciling the bank.

The Feed tab

Open any connected bank and choose the Feed tab. It shows the connection’s health, the bank’s own balance next to the ledger balance, the number of lines this month, the last sync, and the credits used for coding. From here:

  • Sync now pulls straight away instead of waiting for the daily run.
  • Reconnect (or Renew consent when the consent is close to expiring) takes you back to the bank for a fresh login. Nothing already in the books changes.
  • Disconnect stops the feed. Lines already in the books stay.

A Balance differs chip is normal in the early weeks: it closes as you confirm drafts and import the months before the feed’s history.

Bank feeds and CodeIQ

The feed and the Review in CodeIQ button use the same engine. On a fed organisation, CodeIQ opens directly on the drafts already in your books, coded and paid for, and gives you the full desk: invoice matching, the VAT audit, bulk approve and post. Posting from CodeIQ confirms those drafts; it never creates a second line and never charges again for a line the feed has coded.

Which accounts can be connected

UK banks and cards through Open Banking, including Lloyds, Barclays, HSBC, NatWest, Santander, Monzo, Starling, Wise and American Express. PayPal can be connected the same way. Stripe and eBay are not bank connections: they are separate sources in step 2, covered in Connecting Stripe and Connecting eBay. If a card account did not appear when you connected the bank, choose Add another bank at BankSync in Settings, Bank feeds, pick the same bank and tick the card.

When the bank’s consent runs out

A bank lets a feed read the account for a limited time (often 90 days). Before it ends, the feed shows Renew by and Reports, Deadlines lists the renewal with reminders 14 and 3 days before; renewing takes a minute at the bank. If the bank asks to be authorised again, the feed says Reconnect needed and the deadline appears straight away. See Deadlines.

Cost and security

  • BankSync bills you directly for the connection, from US$4 a month per workspace; IQ Books never sees that bill.
  • IQ Books charges only for coding, 4 credits a line, capped by the monthly cap you set in step 4.
  • Your bank login is entered at the bank, never in IQ Books. The connection tokens IQ Books holds are encrypted at rest and can be revoked from BankSync or by disconnecting here.

IQ Books by ReconcileIQ

Your books, kept by themselves.

IQ Books is the AI-native UK ledger that does the bookkeeping for you. Bank transactions arrive coded, receipts and bills file themselves from a photo or an email, and the books are reconciled to the statement. RiQ does it, you sign it off. The ledger is free.