Skip to main content

Transactions

Every transaction from every statement you have uploaded, in one searchable table. This is where you check what was extracted, correct a category, and take a filtered extract into Excel.

What it shows

One row per transaction, across all accounts and all statements.

ColumnWhat it contains
DateThe date the transaction appeared on your statement. If the statement included a time, that's shown too.
DescriptionThe recognized merchant name on the first line. When the raw statement text differs, it appears underneath in smaller type.
AccountThe account the transaction belongs to — its nickname, else the bank name, else the masked account number.
CategoryThe assigned category, shown in the category's own colour. Editable in place.
AmountThe transaction amount in its own currency, presented according to whether it is money in or money out.
BalanceThe running balance carried on the statement after the transaction, where the statement provided one.

A dash (—) means the statement did not supply that value.

Features

FeatureWhat it does
SearchMatches the description, the raw merchant text and the payment reference. Press Enter to apply.
From / To datesShows only transactions dated within the range you choose, including both dates.
Category filterShows only transactions in the chosen category. Clear it to return to everything.
SortingClick Date, Description, Amount or Balance to sort. Sorting is applied across your whole filtered set, not just the rows on screen.
PagingRows load 20 at a time as you page through; only the page you are looking at is fetched.
Inline category editPick a different category directly in the row. The change is saved immediately.
CategorizeAssigns a category to every transaction that does not yet have one, and reports how many of the uncategorized rows it settled. Uses AI credits.
Recognize merchantsResolves noisy statement text into clean, canonical merchant names, and reports how many distinct merchants it resolved. Uses AI credits.
Transfers tabProposed matches between your own accounts, with the evidence; confirm or reject each. Confirmed transfers leave income and spending everywhere.
DuplicatesRows quarantined because they already existed, with the row they duplicate.
Questions and commentsAsk a colleague — or, in a firm, the client — about a row; answers and attachments stay on the row.
ExportDownloads the transactions matching your current filters. The button gives you Excel; its dropdown offers every other format listed below.

How to use it

  1. Narrow the table with any combination of search text, a From/To date window and a category.
  2. Click a column header to sort; click again to reverse it.
  3. If rows are uncategorized, use Categorize, then re-check the Category column.
  4. If descriptions are still raw bank text, use Recognize merchants to clean them up.
  5. Correct anything the automation got wrong by choosing a different category in the row.
  6. Click Excel to download exactly what your filters currently select, or open the dropdown next to it for another format.

Export formats

FormatFileWhere it goes
Excel.xlsxExcel, Numbers, LibreOffice
CSV.csvGoogle Sheets and anything that reads CSV; the Category column shows the category name
JSON.jsonyour own scripts and pipelines
Text.txta plain listing for e-mail or printing
OFX.ofxXero, Wave, GnuCash, Sage, Money
QuickBooks.qboQuickBooks Online and Desktop (Web Connect)
Quicken.qfxQuicken (Web Connect)
QIF.qifQuicken, GnuCash, Moneydance, YNAB
QuickBooks Desktop IIF.iifQuickBooks Desktop, File → Utilities → Import → IIF
MT940.staSAP, Dynamics and other systems that import SWIFT MT940 bank statements
CAMT.053.xmlISO 20022 (camt.053) importers
Tally XML.xmlTally Prime, Gateway of Tally → Import Data → Vouchers

Every format contains the same rows — whatever your filters currently select — and identifies each transaction by its BankStmt reference (BST-…). Your bank's own reference number is never included in a file meant for another system.

If you would rather not download and re-upload files, Settings → Integrations can push transactions straight into accounting software and spreadsheets. Each connector appears there once it has been enabled for your workspace — see Integrations, open banking & API. The full list of formats and what each contains is on Exports.

Notes and limits

  • The Account and Category columns are not sortable — sorting is available on Date, Description, Amount and Balance.
  • Search is a case-insensitive substring match. It looks at the raw description, the raw merchant text and the reference, so searching for a cleaned-up merchant name may not match rows whose statement text spelled it differently.
  • Exports ignore paging and sorting: they contain every transaction matching your filters, ordered oldest first.
  • Amounts are shown in each transaction's own currency and are never converted or added across currencies.
  • Categorize only touches transactions that have no category, so your own corrections are never overwritten.
  • Categorize and Recognize merchants depend on server-side automation. If it is not available, the page tells you rather than failing silently.