INSTRAM

BTD · Bank Transaction Dashboard

Every account in a case – and the money's path.

BTD opens a case from INSTRAM's signed data, reconciles the way different banks spell the same parties, and from then on you can ask what matters in the case: where the money came from, where it went, who stands in the chain, and what is suspicious about it. In the browser, on the organisation's own server.

BTD's relationship graph in organic layout: the invented case's account holders as stars, counterparties as diamonds, connections with amounts; green for credits, red for debits.
Relationship graph: nine account holders and their counterparties, the amounts on the arrows.

1 · Case, import, reconciliation

Only unaltered data gets in, and only reconciled data is analysed.

A case is made from one or more signed CSVs. BTD checks the signature before a single row is loaded; nothing is taken from a file that is altered or unsigned. Rows in other currencies are converted into the case's currency at the central bank's daily rate, and repeats within a file and between imports are filtered out.

Analysis opens only after reconciliation: the same holder may appear under several spellings, and the program merges them – the original values are kept, so the step can be reversed. Counterparties get one name per account with a single click.

BTD's data standardization view: the invented case's account holders with their original and standardized names, account numbers and currencies.
Reconciliation: "HARBOURLINE CONSULTING LTD" and "Harbourline Consulting Ltd." become one name – the original is kept.

2 · Table

Every row, with every filter.

The table holds every row of the case: a filter on each column, free-text search, labels, saved views. What is filtered here is what every other view sees – the graph, the maps and the summary draw the same set of rows. A row can be starred and given a note; the filtered rows export to Excel and to Analyst's Notebook, and credits can be traced forwards and debits backwards with one click.

BTD's table view: the invented case's rows, with debit and credit totals above, the toolbar and the filters.
The table: 2,473 rows, debits and credits totalled, a toolbar for labels, tracing and export.

3 · Relationship graph

Who paid whom – and by which route the money got there.

The graph draws the account holders and their counterparties, with the amounts on the connections, in organic or hierarchical layout, with an amount threshold and a node limit. The route finder gives every path along which money got from one party to another, step by step with the smallest amount – pick one and the drawing highlights only that. The graph exports as HTML.

BTD's route finder: two routes found from a construction company to a Lebanese company, the chosen one highlighted with red arrows.
Route search: four steps from the construction company to Lebanon, each with its amount.

4 · Counterparties, timeline, balance

The same data, for other questions.

The partner accounts view shows, per counterparty, the credits, debits, balance, turnover and imbalance. The partner timeline draws an account holder's largest counterparties month by month, with a weekly activity heatmap. The balance candles show day by day how an account's balance moved.

BTD's partner accounts view: per counterparty the credits, debits, balance, turnover, imbalance and period.
Partner accounts: who sent and received how much.
BTD's partner timeline: the invented construction company's ten largest counterparties per month, as a line chart.
Partner timeline: the largest counterparties month by month.
BTD's balance candles: an account's daily balance changes as a candlestick chart.
Balance candles: the daily movement of the balance.

5 · Maps

Where did the money go abroad, and where was it drawn in cash?

The world map shows incoming and outgoing money per country, from the IBANs, with the net direction in colour. The cash map places ATM and counter withdrawals and deposits on the points of the Hungarian central bank's national branch and ATM finder, down to the street and number: in the same place, in one town, or far from the registered office.

BTD's world map: six countries with the invented case's foreign transactions, from Estonia to Lebanon and the United Arab Emirates.
World map: six countries, money in and out, the net direction.
BTD's cash map: a map of Budapest with the invented case's ATM withdrawals as circles sized by amount.
Cash map: 767 of 872 cash rows on the map, the rest can be translated.

6 · Scenarios

Fourteen patterns an experienced analyst looks for.

The scenarios run over the whole case and show which account was caught by what – pattern by pattern, with dates, shares and the rows that prove it. High-risk countries are checked against the FATF and EU lists in force on the day the money moved, not today's. Thresholds are set on the server, and every change carries a reason and a name.

  • Rapid pass-through
  • Smurfing
  • Just under a threshold
  • High-risk countries
  • Large cash movements
  • Same-day ATM withdrawals
  • Crypto
  • Dormant account wakes
  • Large single transaction
  • New account, early international transactions
  • Volume jump
  • International activity surge
  • Activity surge
  • Registered-office provider
The accounts hit: nine invented accounts, each with the scenarios that found it.
Accounts hit: which scenario found which account.
The smurfing scenario: eight patterns on an invented company, small credits from many sources followed by a large transfer abroad.
Smurfing: money from 4–7 sources, then one large transfer.
The high-risk countries scenario: transfers to Lebanon marked with the FATF and EU lists.
High-risk countries: by the FATF and EU lists in force on the row's day.
The same-day ATM withdrawals scenario: two invented people's ATM withdrawals on the same days.
Same-day ATM withdrawals: two people on the same days.
The just-under-a-threshold scenario: an invented company's cash deposits just under 10,000 euros.
Just under a threshold: deposits between 9,860 and 9,990 euros.
The scenarios' parameters: thresholds, the program's default and the last change.
The parameters: value, default, who changed it and why.

7 · Chain analysis

Tracing money, arranged into chains.

Chain analysis follows large credits forwards and debits backwards: with tolerances, a time window, a split percentage and a chain depth. The result is a list of chains – by type (complex, merging, splitting), with a confidence level and the share passed on at each level – highlighted on the chain drawing and exported to an Excel workbook.

On the chain drawing money moves from left to right, and whatever carried more of it stands higher. A chain picked out stands out from the rest; on every edge, the amount and the numbers of the chains the edge belongs to.

The chain drawing with one chain picked out: Meridian Construction Ltd., Harbourline Consulting Ltd., Greenbough Trading Ltd., Swiftpass Trading Ltd., the revenue authority and an Estonian company; on the edges the amounts and the chain numbers, the other chains faint behind.
The chain drawing: the highlighted chain's 76.9K euros over six levels – from Meridian Construction Ltd. through Harbourline Consulting Ltd. and Swiftpass Trading Ltd.
The chain analysis overview: 46 chains, 1.3 million euros, 6 participants; chain types and confidence levels as charts.
Overview: 46 chains, 1.3 million euros.
Browsing chains: one chain expanded level by level, with account holder, counterparty, date and amount.
One chain level by level, every step with its row.

8 · Reports and exports

The findings, written down – and every download logged.

A report is written about one account holder or the whole case, in four kinds: general, cash, chain and foreign involvement. With summary findings, what stands out for the investigation, and a table of the accounts analysed; it can be worked on in the editor and exported to Word. Every export and download goes into the case's event log.

9 · Company checks

Who is behind the account?

The Companies view checks every account holder against the company registry, the tax authority's debtor lists, the sanctions lists and the press, and whether its registered office is at a registered-office provider. At a glance you see where there is something to do.

BTD's Companies view: the invented case's account holders with columns for state, negative information, tax debtor lists, sanctions, press and registered-office provider.
Company checks per account holder, in registries and on lists.

10 · Questions in plain language

Ask about the case – the model never sees the bank rows.

The AI chat turns a question into an analysis function, which the program runs in an isolated process on the case's data, returning a table, a chart or a workbook. The model never receives the bank rows, and runs with the user's own key. Functions that prove useful can be saved and run again later.

A figure made by the AI chat: the accounts that sent most abroad, by country and by month, as bar charts.
The question: “Which account sent the most money abroad, by country and by month?” – the chat answered with these charts.
The end of the chat's answer: a downloadable workbook, the chart's preview and the name of the analysis function used.
Beside the answer: a workbook to download, and the analysis function it wrote – saved, to run again.

11 · Robby, the investigator's assistant

It goes through the case the way an experienced investigator would.

Robby works through the program's own actions while the interface follows: it reconciles, runs the scenarios, recognises the type of case, labels, draws charts, writes a workbook and a report. Whatever it would change, it first asks you to approve, and every step goes into the case's event log. In teaching mode it explains, step by step, what it does and why.

Robby's panel at the end of the investigation: an overview of the case, the statements to ask for, and the Robby's report button.
At the end: an overview of the case and the statements worth requesting.

Installation and operation

On the organisation's server, in the browser.

  • Your own server

    BTD runs inside the organisation's network, at one address, with the organisation's database. An online environment is available for trials.

  • Many users

    User accounts, access per case, cases shared with colleagues.

  • Event log

    Every import, export and download in a case is logged; a download link opens only for the person who requested it.

  • Shared lists

    Sanctions and risk lists, the bank branch and ATM registry, the IBAN country registry – on the server, the same for everyone.

  • AI only when switched on

    The AI features run with the user's own key, and the operator can switch them off.

  • In the user's language

    The interface translates itself into the browser's language as it runs.

The pictures are taken from the programs' real interface, with the data of invented companies, people and accounts – no real case and no real bank appears in them. Click a picture to see it full size.

Try it with your own questions.

After the demo we give you online trial access to BTD, so your organisation can see where its own questions lead.