Financial records
Bring in the bank statements and transaction lists you lawfully hold, see where the money went, and get the patterns that deserve a second look described in plain words. Nothing here contacts a bank. The model is i2 Analyst's Notebook's: accounts are nodes, payments are links and events, and a table, a flow chart and theme lines show the same records.
The console's Financial records panel previews a file without recording anything, imports it, and runs the analysis. An agent can do the same.
What an import records
- Importing keeps the file as evidence with its SHA-256, and a chain-of-custody record (who imported it, when, the exhibit reference, where it came from, the mapping used). Exhibit reference and source are required. Every account the file names becomes an account in the case, checked where it can be: an account number that does not check is skipped and counted, never filed as something else. Each row becomes a payment (amount, currency, reference, time) with a payer and a payee. A row whose counterparty has a name but no account keeps the name as a participant known by that name alone. You can say which person or organisation holds a statement's account. A counterparty name the statement prints becomes an organisation (or, for two or three plain words, a person) known by that name alone, linked to the account at low confidence. It is never merged on a name: the ordinary matching rules propose matches and you decide. Accounts and payments identify people, so the purpose gate applies: the import is refused until the case has a purpose.
Importers
Bank statement: one account's statement. Give the account (an IBAN, or a sort code and account number), or let the file's own sort code and account columns say. Columns: date (and time), description, reference, amount (negative is money out) or debit and credit, balance, currency, counterparty name, and counterparty IBAN or sort code and account. Exports from Monzo, Starling, Lloyds/Halifax/Bank of Scotland, NatWest/RBS, Nationwide and Barclays are recognised by their headers and the columns pre-filled; check them in the mapping step. Amounts may be £1,234.50, (12.00), 12.00 DR or 1.234,50. A row is a cash withdrawal when its type, description or name says ATM or cash.
Transactions list: payer account, payee account, amount, currency, date, reference; names optional. Each side is an IBAN, a combined 20-00-00 12345678, or a sort code column plus an account column.
Dates are read day first by default.
The analysis
The analysis shows the payments, each account's totals, the flows between accounts (total, number of payments, first and last), the top counterparties of every account whose statement you hold, and the findings. You can filter by dates, minimum amount and currency.
Each finding is a sentence about the records, a probability-yardstick term (never "certain"), what it cannot tell you, and the payments behind it. They describe patterns; they never say anyone did anything wrong.
| Finding | Raised when (defaults, each can be changed) |
|---|---|
| Round amounts | at least 3 payments of whole hundreds of 500 or more, and at least half of that payer's payments |
| Just below a limit | at least 2 payments from one payer within 5% below 10,000 |
| Money in, then out | an incoming payment of 500 or more, and 80% of it leaves the same account within 48 hours |
| Circular flow | payments A to B to C to A (up to four accounts) of similar size (within 25%) inside 7 days |
| Large payment to a new counterparty | 5,000 or more to a payee whose first record with the payer is within 14 days, after at least 30 days of other records |
| Cash withdrawals | 4 or more cash withdrawals totalling 500 or more within 7 days |
| High-risk jurisdiction | an account whose IBAN prefix, BIC or sort code places it in a country on the list (default the FATF call-for-action list: IR, KP, MM) |
| Sanctions-screen name | a counterparty whose holder is listed on a watchlist or has a sanctions screening proposal |
The country comes from the account number, which says where the account is held, not where the person is. The high-risk list is a policy choice and changes; set the one you work to. A sanctions finding is a name match: check the holder's identity first.
In the console
The steps are in the guide: Import records and Follow money-flow patterns. The report has a Financial records findings section.
Limits
Statements are the bank's view of one account: a counterparty's own account is only as complete as the rows that name it. Two accounts held by one person are two nodes until you say otherwise. Currencies are never converted; flows and findings are per currency. Cash is recognised by words in the row, which banks write differently.