Search Knowledge Base Articles

Banking — User Guide

Banking — User Guide

Module: Accounting
Audience: Accountants, bookkeepers, treasury staff
Version: 1.0.0
Last updated: 2026-07-22

Overview

Banking is where you set up bank accounts, review the banking register (cleared and uncleared activity per account), connect bank feeds through Plaid to download transactions, and run bank reconciliation against your statement. Bank accounts are part of the chart of accounts with a bank detail type.

Go to Accounting → Banking (menu opens Bank accounts).

Prerequisites

Role Typical permissions
Open Banking Accounting Banking → View
Add or edit bank accounts Accounting Chart of accounts → Create / Edit
Delete bank accounts Accounting Chart of accounts → Delete
Bank reconciliation Accounting Reconcile → View / Create / Edit
Import transactions (Excel) Accounting Transaction → Create
Configure Plaid Accounting Settings → Edit

Areas within Banking

Area Purpose
Bank accounts List and maintain bank-type ledger accounts
Banking feeds Link a bank via Plaid, download transactions, categorize and clear them
Banking register View register activity for one bank account (open via Banking register URL if not shown in sidebar)
Reconcile bank account Match the register to a bank statement (may require direct navigation — see Common issues)

Step-by-step: Add a bank account

  1. Go to Accounting → Banking → Bank accounts.
  2. Click Add bank account.
  3. Complete the form:
    • Name and optional Account number
    • Currency
    • Parent account if this is a sub-account
    • Opening Balance and As of date when first creating
    • Bank name, account number, routing, and address fields as needed
  4. Click Submit.

Expected result: The account appears in the list with primary and bank balances.

Step-by-step: Use the banking register

  1. Open Accounting → Banking with group Banking register (your administrator may provide the link).
  2. Select a Bank account.
  3. Optionally filter by Cleared / Uncleared and date range.
  4. Review withdrawals, deposits, payee, and description.

The register shows activity posted to that bank account in the general ledger.

Step-by-step: Connect a bank feed (Plaid)

  1. Go to Accounting → Banking → Banking feeds.

  2. Choose the bank account from the dropdown.

  3. Click Verify bank account and complete the Plaid connection flow.

  4. After verification, use the gear menu to:

    • Download transactions (choose a start date; up to 500 per batch)
    • Import transactions from Excel
    • Re-verify or Delete verification if you need to reset the link

  5. On the transaction list, categorize lines, apply banking rules, and mark items Cleared when handled.

Plaid must be configured under Accounting → Setting (Plaid environment) before verification works.

Step-by-step: Reconcile a bank account

  1. Navigate to Reconcile bank account under Banking (or ask an administrator for the menu link).
  2. Select the Bank account to reconcile.
  3. Enter statement figures: Beginning balance, Debits for period, Credits for period, Ending balance, and Ending date.
  4. Click Start reconciling (or Resume reconciling if a session is in progress).
  5. Mark transactions that appear on your statement until the difference is zero.
  6. Finish the reconciliation when balanced.

For reconciling non-bank general ledger accounts, use Accounting → Reconcile instead.

Step-by-step: Import bank transactions from Excel

From Banking feeds (gear menu) or the transaction banking import (if used):

  1. Click Import transactions.
  2. Upload the template file with date, withdrawals, deposits, payee, and description.
  3. Review imported lines and process them in the feed or transaction list.

Field reference

Field Description
Primary balance Ledger balance for the account
Bank balance Balance tracked for bank reconciliation context
Cleared Transaction matched or confirmed on the bank side
Uncleared Still outstanding on the register or feed
Banking rule Automatic categorization rule applied to a feed line

Common issues

Symptom Likely cause What to do
Cannot add bank account Missing Chart of accounts Create Request COA Create permission
Banking register empty No bank account selected Pick an account in the filter
Register or Reconcile not in sidebar Navigation only lists some groups Use direct link from administrator
Plaid verify fails Plaid not configured Set client ID, secret, and environment in Settings
Download returns few rows 500-transaction API limit Run download again with a later start date
Balances do not match statement Uncleared items or missing conversions Clear feed lines; convert related transactions
Wrong tab highlighted UI navigation quirk Confirm URL group parameter

Related features

  • Chart of accounts — bank accounts are GL accounts with bank detail type
  • Transactions — convert imported banking rows to full journal postings
  • Accounting → Setting — Plaid environment and banking rules
  • Accounting → Reconcile — reconcile non-bank balance sheet accounts
  • Reports — cash and balance sheet reports use bank account balances

Did you find this article useful?

Related Articles

  • Bills — User Guide

    Bills — User Guide Module: Accounting Audience: Accounts payable clerks, accountants Version: 1.0.0 ...

  • Budget — User Guide

    Budget — User Guide Module: Accounting Audience: Accountants, finance managers, administrators Versi...

  • Chart of Accounts — User Guide

    Chart of Accounts — User Guide Module: Accounting Audience: Accountants, finance staff, system admin...

  • Checks — User Guide

    Checks — User Guide Module: Accounting Audience: Accounts payable staff, bookkeepers, finance admini...

  • Dashboard — User Guide

    Dashboard — User Guide Module: Accounting Audience: Accountants, finance managers, administrators Ve...