The pattern that only exists across accounts and weeks STRUCTURING
Nothing on any single line is unusual. It is the fourteenth nine thousand, across four accounts, over eleven weeks, that is the finding.
The statement
What counts as the threshold
The shape of it
Windows that clear the threshold
Either side of the threshold
Money that did not stay
The working
Every one of these shapes has an innocent explanation, and none of them is a finding on its own.
How it works
STRUCTURING finds a pattern that only appears across accounts and weeks: payments kept just under a reporting threshold, repeated across several accounts over time. It measures how tightly amounts cluster below the threshold and how money passes through. It points to patterns for a person to review; it does not make findings. The data stays in this tab.
Questions people ask about STRUCTURING
Why can an alert queue not see this?
Because every rule in it reads one transaction at a time. Nine thousand is an ordinary deposit and it will never be flagged. What is not ordinary is the fourteenth nine thousand, across four accounts, over eleven weeks, and that pattern does not exist in any single row, so nothing that reads rows can find it. The page rolls a window across every account at once, which is the only way it appears.
What is the band ratio for?
Deposits just under a round number are not evidence on their own, because a lot of ordinary banking is round-ish. So the page counts two bands of the same width, one just below the threshold and one just above, and compares them. In data with nothing behind it those hold roughly the same number. A pile below and nothing above is a cliff, and a cliff is the signature.
What does the pass-through figure mean?
How much of the money that came in went out again within a few days at a similar amount. A trading account holds a balance; a conduit does not. It is matched pair by pair with the dates and amounts shown, so each match can be looked at rather than taken on a percentage.
Is a round number suspicious?
On its own, no. Rent is round, wages are round, a float is round. The figure is only interesting as a proportion: instructed and invented amounts are round far more often than takings and invoices are, so a deposit stream that is mostly exact multiples of five hundred is a different kind of stream from one that is not.
Is any of this a finding?
No, and the page says so in as many words next to each one. Every shape here has an innocent explanation: a weekly banking run, a rent account, a business that deals in round prices. What the page does is answer four questions that each need a pivot table, on a statement that never leaves the machine it is opened on.
Doing this often? OBSCURA Books imports bank statements from CSV, OFX and QIF, and explains regular lines with rules as they arrive. Everything is US$5 a month or US$48 a year.