Skip to content
Kuberan AI Help

Banking

Open Banking

Overview

The Banking screen manages your accounting firm’s own bank accounts and transactions — distinct from the client bookkeeping found in the Books module. This is where you track the firm’s operating account, trust account, and credit card accounts, import bank statements, and categorise transactions against internal chart-of-accounts categories. Bank rules can automate repetitive categorisation so that recurring payees (rent, payroll, software subscriptions) are categorised instantly on import.

Banking screen with Accounts tab and Transactions tab, showing account cards and transaction rows
The Banking screen showing the Accounts tab (left) and Transactions tab (right) with import controls.
  1. (1) Accounts tab — lists all connected or manually added firm bank accounts
  2. (2) Transactions tab — shows imported transactions for the selected account and date range
  3. (3) Add Account button — connect via Plaid or add manually
  4. (4) Import button — import transactions from a CSV, OFX, or QBO file
  5. (5) Bank Rules button — manage auto-categorisation rules

Screen Layout

The Banking screen has two primary tabs:

Accounts tab: Lists every firm bank account. Each account shows the institution name, account name, account type (Chequing, Savings, Credit Card, Trust), last four digits of the account number, the last-import date, and the current imported balance.

Transactions tab: Shows the transaction ledger for the currently selected account. A date range picker, search field, category filter, and reconciliation status filter appear in the toolbar. The transaction table shows individual rows with categorisation controls.

Accounts Tab

UI Elements

Add Account

Opens a modal to add a new bank account. Choose between Plaid (automated bank connection) or Manual (enter account details yourself).

Account Card

Each account is displayed as a card showing the account name, institution, type, masked account number, last-import timestamp, and current balance from the most recent import. Click to select the account and switch to the Transactions tab showing that account’s transactions.

Edit Account

Opens the account settings drawer. You can rename the account, change its type, update the opening balance, or disconnect from Plaid.

Delete Account

Permanently removes the account and all its imported transactions. A warning is shown if any transactions are unreconciled.

Plaid Connection Status

Green “Connected” badge if the account is live via Plaid; grey “Manual” if transactions are imported by file. A “Refresh Required” amber badge appears when Plaid authentication needs renewal.

Transactions Tab

UI Elements

Account Selector

Dropdown at the top of the Transactions tab to switch between firm accounts without returning to the Accounts tab.

Date Range

Filter transactions by date. Defaults to the current month. Quick presets: This Month, Last Month, This Quarter, Custom.

Search

Search transactions by payee name, description, or reference number.

Category Filter

Filter to show only transactions assigned to a specific category, or show uncategorised transactions only.

Reconciliation Status Filter

Options: All, Unreconciled, Reconciled. Use “Unreconciled” to focus on transactions that have not yet been matched in a reconciliation.

Import

Opens the import dialogue to upload a CSV, OFX, or QBO file from your bank. Kuberan AI detects the format automatically and maps standard columns.

Bank Rules

Opens the Bank Rules manager where you can create, edit, and delete auto-categorisation rules.

Export

Downloads the filtered transaction list as CSV.

Transaction Row Columns

Date

Transaction date from the bank statement. Sortable.

Payee / Description

The payee name or description string from the bank statement. May be auto-cleaned by Kuberan AI’s payee normalisation.

Amount

Transaction amount. Credits shown in teal; debits shown in dark text with a minus sign.

Category

Dropdown field on each row to assign or change the account category. Uncategorised transactions show a grey “Categorise” placeholder. Auto-categorised transactions show the matched category with a small rule icon.

Reconciled

Green tick if the transaction has been matched in a completed reconciliation. Blank if unreconciled.

Row Actions

Options: Edit (change payee name, amount, or date), Create Rule (creates a bank rule based on this transaction’s payee), Exclude (marks the transaction as non-book; hidden from reports), Delete.

Bank Rules Manager

Rule Name

Internal label for the rule (e.g., “Stripe — Software Revenue”).

Match Condition

The text pattern to match against the payee/description field. Options: Contains, Starts with, Exactly matches. Case-insensitive.

Assign Category

The category to apply when the condition is met.

Rule Priority

Numeric priority (1 = highest). If two rules match the same transaction, the one with the higher priority wins.

Actions

Add a Bank Account

  1. On the Accounts tab, click Add Account.
  2. Choose Connect via Plaid for automated live bank feeds, or Add Manually for file-import only.
  3. For Plaid: follow the Plaid authentication flow (select institution, enter credentials). Once authorised, select the specific accounts to connect. Kuberan AI begins fetching transactions from the past 90 days.
  4. For Manual: enter the Account Name, Institution Name, Account Type (Chequing, Savings, Credit Card, or Trust), and the opening balance with its effective date.
  5. Click Save. The account card appears in the Accounts list.

Import Transactions

  1. Select the target account using the Account Selector on the Transactions tab.
  2. Click Import. The import dialogue opens.
  3. Drag and drop your file (CSV, OFX, or QBO) into the upload area, or click Browse to select it.
  4. Kuberan AI detects the format and shows a preview of the mapped columns (Date, Description, Debit, Credit). Verify the mapping is correct; adjust column assignments if needed for CSV files.
  5. Set the Date Range if you want to limit which rows are imported (useful for avoiding duplicate imports).
  6. Click Import Transactions. Transactions are added to the ledger and bank rules are applied automatically to any matching rows.
  7. Review the import summary showing the count of new transactions imported, duplicates skipped, and transactions auto-categorised by rules.

Categorise a Transaction

  1. On the Transactions tab, locate an uncategorised transaction (shown with a grey “Categorise” placeholder in the Category column).
  2. Click the Category dropdown on the transaction row.
  3. Select the appropriate account category from the list. Start typing to filter the list by category name.
  4. The category is saved immediately. The transaction row updates to show the selected category.

Create a Bank Rule

  1. Right-click or click ⋯ → Create Rule on a transaction whose payee pattern you want to automate.
  2. The New Bank Rule drawer opens with the match pattern pre-filled from the transaction’s payee name.
  3. Adjust the Match Condition type (Contains / Starts with / Exactly matches) as needed.
  4. Select the Assign Category from the dropdown.
  5. Enter a Rule Name for easy identification.
  6. Click Save Rule. The rule is applied immediately to all existing uncategorised transactions that match the condition, and will apply automatically to all future imports.

Export Transactions

  1. Apply date range, category, and reconciliation status filters to define the data set.
  2. Click Export (download icon).
  3. A CSV file containing all filtered transaction rows downloads to your device.
  • Reconciliation — Match imported transactions to bank statements for period-end reconciliation
  • Reports — Billing and revenue reports draw on categorised banking data
  • Payments — Client invoice payments may appear as credits in your banking transactions