Skip to main content
All Docs
Getting StartedagentOS Block ManagerUpdated April 12, 2026

What's new in v0.12.14: A major upgrade to bank reconciliation

What's new in v0.12.14: A major upgrade to bank reconciliation

Released 12 April 2026

Version 0.12.14 delivers three substantial improvements to the bank reconciliation workflow: a drag-and-drop CSV importer, a fully sortable transaction ledger, and one-click Excel export. Here is a practical guide to each change.

Drag-and-drop CSV import

Uploading a bank statement is now as simple as dragging a file from your desktop onto the import zone — no more hunting for the browse button.

The drop zone accepts any .csv file up to 10 MB. Files that don't meet those criteria are rejected with an error message before anything is sent to the server. If you prefer to use a file picker, clicking anywhere inside the zone opens the browser's native file dialog.

Once a file lands, the importer reads the header row and attempts to match common column names automatically — Date, Transaction Date, Description, Narrative, Amount, Reference, and so on. Pre-filled mappings save time, and you can adjust any of them before committing the import.

Existing parsing capabilities are unchanged: UK-format dates (DD/MM/YYYY), ISO dates, bracket-notation negatives (£100.00), and currency symbols are all handled transparently.

Sortable transaction ledger

The previous fixed grid has been replaced with a proper data table. Four columns are now sortable by clicking their headers:

  • Date — defaults to newest first on load
  • Description
  • Reference
  • Amount

A small arrow indicator shows whether the column is sorted ascending, descending, or not at all. Sort state is local to the page session and resets on navigation.

The inline manual-match form still expands below the relevant row and collapses when you close or confirm it. Row hover highlighting makes it easier to track which transaction you are working on when the table is long.

Excel export

When at least one transaction exists for the selected block, an Export Excel button appears next to the Import CSV button. Clicking it:

  1. Calls the new reconciliation.exportTransactions endpoint and fetches up to 10,000 rows (respecting any active status filter)
  2. Generates an .xlsx workbook in the browser using ExcelJS
  3. Triggers an automatic download named reconciliation-{block-name}-{date}.xlsx

The workbook is ready to share with auditors or accountants. It includes:

  • Block name and postcode in the title
  • Export date for traceability
  • Styled column headers
  • Colour-coded amounts — credits in green, debits in red, formatted as £#,##0.00
  • Alternating row shading for readability
  • A summary footer with Total Credits, Total Debits, and Net

Every export is recorded in the audit log so there is a complete record of who exported what and when.

Getting started

  1. Go to Reconciliation in the sidebar.
  2. Choose a block from the dropdown.
  3. Click Import CSV and drag your bank statement file onto the drop zone.
  4. Confirm column mappings and import.
  5. Use the status filter to focus on unmatched transactions, then match or exclude them.
  6. When you're ready to share the ledger, click Export Excel.

The financials.read permission is required to use the export feature. Contact your organisation administrator if the button is not visible.