Skip to the guide
IQ Booksby ReconcileIQ

Banking · Guide 24 of 53

Setting up bank accounts and reading the cashbook

Linking a bank account to your ledger, picking the right currency, the cashbook view, and what changes when you import transactions vs. posting manually.

A bank account in IQ Books is two things bound together: a record of what your real-world bank account is doing, and a ledger account in your chart that the journal engine posts cash movements against. Setting these up correctly is the foundation of everything banking-related.

Where to start

Banking → Bank accounts lists every bank account on the ledger, with name, currency, current ledger balance, and last-imported date. From here:

  • Click New bank account to add.
  • Click any row to drill into the account’s cashbook.
  • Archive accounts you have closed (archival doesn’t alter historical journals; it just hides the account from new transaction forms).

Adding a new bank account

  1. Click New bank account.
  2. Enter a display name (“Lloyds Business Current”, “Stripe Payouts”, “PayPal”).
  3. Pick the currency. If different from base, this becomes a foreign-currency bank with its own currency-denominated ledger balance.
  4. Optionally enter the bank name, sort code and last 4 digits of the account number (used in CSV import to disambiguate, and shown on the cashbook header).
  5. Pick or create the linked ledger account. By default IQ Books reuses an unclaimed bank_control-role account from your chart; if none is unclaimed, a new one is created automatically.
  6. Save. The bank account is immediately available to receive transactions.

The cashbook view

Drill into any bank account to see its cashbook: a chronological list of transactions affecting the account, in date-descending order. Columns:

  • Date
  • Description — the bank-statement narrative or your manual note
  • Source chip — the colour-coded marker showing what created the transaction (CSV import, manual entry, customer receipt, supplier payment, transfer, system)
  • Money in / Money out — the amount, in one of two columns based on direction
  • Balance — the running ledger balance after this transaction
  • Status — Draft, Confirmed, or Ignored

Source chips explained

  • CiQ — CodeIQ-suggested category. Hover for the suggestion details.
  • bank — bank rule auto-applied.
  • doc — matched to a customer receipt or supplier payment.
  • pay — manual customer receipt or supplier payment that was confirmed against this bank.
  • sys — system-posted (recurring sweep, depreciation, year-end close).
  • manual — you typed it in directly via Add transaction.

Adding a transaction manually

The Add transaction tab on the cashbook lets you type a single bank movement directly — useful for one-off cases where you don’t want to wait for a CSV import:

  1. Pick direction (money in / money out).
  2. Enter date, amount, description.
  3. Pick a category for the contra side (where the money came from or went to). Or pick “Transfer” and a destination bank.
  4. Save. The transaction is posted as confirmed immediately, with the corresponding journal.

What happens when you import a CSV

Imports land transactions into the cashbook with status Draft. They have not yet posted journals; you confirm them in the Drafts workspace. Covered in the next guide.

Reconciling the bank

A reconciliation checks that the books hold what the bank holds at a statement date. There are two ways, and both are kept with the books under the bank account’s Reconcile tab, newest first, with who did it and how.

  • Against a statement. On the Reconcile tab, upload the bank’s statement as CSV. Each statement line is matched to a posting in the books; what is left is shown in groups (on the statement but not in the books, in the books but not on the statement, amounts that differ), each with the fix beside it. Mark matched as reconciled, on the results, ticks the matched lines in the cashbook’s Rec column. When the books change, here or on another tab (a draft confirmed in Review drafts, say), the results check the same statement again by themselves; Check again does it on demand. Neither charges again. Every run is saved with the books, and saved again as you fix things, and any match you accept by hand comes back the next time you load the same file. It counts as reconciled only when every line matched and the statement’s closing balance equals the books at its date: matching lines cannot see a difference carried in from before the statement’s first date. The closing balance is read from the file’s balance column; when the file has none, type it in on the results. Without it the run is kept as lines matched, not reconciled. The results say Fully reconciled only when the run is kept as reconciled, with the books’ figure at that date beside the statement’s.
  • From the feed, by itself. For a bank with a feed that reports its balance, after each month end RiQ works out the bank’s balance at the last day from the feed and compares it with the books at that date. Banks send some lines days late (a payment dated the 30th can arrive on the 2nd), so RiQ waits until the figure has settled: not before the 5th, and only once the feed has given the same figure on three days and its latest sync still gives it. When the figure and the books agree and nothing dated by then is waiting in Review, the month is recorded as reconciled and that month’s lines are ticked, with nothing posted. When they do not, What RiQ found says by how much and what is in the way (lines still in Review, a statement reconciled for that date with another closing balance, or a feed whose figure never settled, synced too seldom, or has since changed its mind, in which case reconcile that month against a statement). For a payout channel such as eBay, what is waiting for its payout counts as in. A transfer counts on each bank on that bank’s own date, so money that leaves one bank on the 30th and lands in the other on the 1st is in each month where the banks have it.

A reconciled statement replaces the feed’s record for the same date, and the feed never overwrites it; a statement run that was not reconciled is replaced by the feed’s when they agree (if it gave a closing balance, only when that is the feed’s too). A reconciled month stays watched: if something dated on or before it is later deleted, re-dated, changed or added (a line the bank sent late counts), so the books at that date no longer show what they did, What RiQ found says so with the figure then and now, and the Reconcile tab marks it No longer agrees.

Ticks. A line ticked by a statement reconciliation is signed off: its amount, date and bank cannot be changed until the tick is taken off. Click its green dot in the cashbook’s Rec column to take it off (the line and its posting stay as they are); a green dot also marks a line that is simply confirmed, and only a ticked line’s dot can be clicked. A tick from the feed’s month-end reconciliation is RiQ’s, not a sign-off: the line can still be changed, its tick comes off, and the month is said to no longer agree. Pairing a feed-ticked line into a transfer keeps its tick.

Foreign-currency banks

A USD bank account’s cashbook shows USD amounts and a USD running balance. The journal lines are also denominated in USD. The conversion to base currency happens at report time, using the most recent applicable rate.

If you want the GBP equivalent on the cashbook itself, hover any row — the tooltip shows the live conversion. The view stays in the bank’s native currency for cleanliness.

Closing or archiving a bank

If you close a real-world bank account, archive its IQ Books equivalent. Archival:

  • Removes the bank from new-transaction dropdowns.
  • Preserves all historical journals and balances on reports.
  • Doesn’t change the underlying ledger account — that account stays in your chart, with whatever closing balance it had.

Before archiving, make sure the account’s closing balance is what your real bank closed at. If there is drift, post a manual journal to bring it to zero (or to the actual closing balance, then close).

Related guides

Turning A Draft Into A Posted Entry

Whether a line arrived by CSV import or you typed it in by hand, it starts life as a draft. A draft is just a note of something that happened at the bank — it does not touch your accounts, your reports or your VAT return until you confirm it. Confirming is the moment the entry becomes real double-entry bookkeeping.

  1. Open the draft in the cashbook. Drafts wait in the ‘Review drafts’ list under the bank account until you code them.
  2. Give it a category. The category is the account that says what the money was for — ‘Office supplies’ for money out, ‘Sales’ for money in. If you genuinely don’t know yet, you can let it fall into Suspense (999) and sort it later; that is a normal holding place, not an error.
  3. Set a VAT code if it applies. Choose a code such as standard, reduced, zero-rated or exempt and IQ Books works the VAT out of the gross for you (standard 20% is simply the gross divided by six). Leave it on No VAT when there is none.
  4. Confirm. The line posts a balanced entry: money in increases the bank and records the income and the VAT collected; money out records the cost and any VAT you can reclaim, and reduces the bank.

A few rules keep the books honest at this point:

  • You cannot confirm a line dated in the future — wait until the transaction date has arrived.
  • You cannot confirm into a closed (locked) period; the year has been put to bed on that date.
  • VAT never sticks to a balance-sheet account — if you code a line to something like a loan or the VAT account itself, IQ Books quietly forces the code to No VAT.
  • Confirming is safe to click twice; a second click just returns the entry already posted, it never doubles it.

Speeding Up Coding With Bank Rules

If the same payees turn up every month — your rent, a software subscription, the card takings — a bank rule can code them the moment they land, so you are only ever reviewing rather than typing.

  1. Open Bank Rules. Open Banking, then Bank rules.
  2. Describe what to match. Give the rule a name and choose how it matches: the description contains a word, matches a pattern, or the amount equals a figure — for example, description contains ‘ANYTOWN PROPERTIES’.
  3. Choose where it should post. Pick the category account (say ‘Rent’) and, if you like, a VAT code.
  4. Narrow it if needed. You can limit a rule to one bank account, to money in or money out only, or to a min/max amount band so a £9.99 subscription doesn’t catch a £999 one.
  5. Set a priority and save. Rules run highest-priority first and the first one to match wins, so put your most specific rules at the top.
  6. Apply them. Click ‘Apply to all drafts’ to sweep every uncategorised draft in one go.

Two things worth knowing. Rules only ever fill in drafts that have no category yet — they never overwrite a category you have already chosen. And applying rules only codes the drafts; it does not confirm them, so you still get the final review before anything posts to the ledger. Retiring a rule archives it rather than deleting it, so your history stays intact.

Recording A Transfer Between Two Of Your Accounts

Moving your own money — current account to savings, or topping up a card — is not income and not an expense, so it carries no VAT and never touches your profit. It should leave one account and arrive in the other as a single linked event.

  1. Get both sides into IQ Books. Import or enter the money-out line on the sending account and the money-in line on the receiving account; each lands as its own draft.
  2. Let IQ Books pair them. Running CodeIQ coding across your bank lines spots the matching pair — same amount, opposite directions, close dates — and links them.
  3. Confirm the transfer on either side. Choose the ‘confirm transfer’ action on one leg. IQ Books posts a single entry that moves the money from the sending bank to the receiving bank and marks both drafts as done together.

If the two sides haven’t been linked, IQ Books will ask you to confirm each leg the ordinary way instead. When the two accounts are in different currencies, the transfer is translated into your base currency so both sides post at the same base value. A confirmed transfer can still be corrected later — the date, amount, description or which accounts were involved — and IQ Books handles that by reversing the old entry and posting the corrected one, keeping the two legs in step.

Common Questions And Troubleshooting

I imported the same statement twice — will I get duplicates? No. IQ Books remembers the rows it has already taken in and rejects a repeat, telling you the rows have already been imported. It is safe to re-import a file if you are unsure whether the first attempt worked; only genuinely new rows come through.

The balance on my bank card doesn’t match my statement. The figure on the card is built from posted entries only. Anything still sitting as a draft — imported but not yet confirmed — is not counted. Clear the draft list and the two should line up, allowing for anything that hasn’t cleared the bank yet.

I coded a confirmed line to the wrong account. A posted entry is never edited in place. When you recategorise it, IQ Books reverses the original and posts a fresh, corrected entry; both remain visible so there is an honest trail. Nothing is lost and nothing is silently rewritten.

I’ve got dozens of lines coded to the wrong place. Rather than fix them one by one, you can ask RiQ by voice to recode them in bulk — for example, ‘recode all Zara UK transactions to the director’s loan account’. RiQ shows you how many lines matched and a sample before anything changes, then applies the new coding to every one of them.

Why has a line gone to Suspense (999)? That is the holding account for anything IQ Books couldn’t confidently categorise. It is working as intended — open the line, give it the right category and confirm, and it moves out of Suspense.

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.