What is a transposition error?
A transposition error happens when two adjacent digits are accidentally swapped during data entry. The amount $1,845 becomes $1,485. The payment of $9,270 gets recorded as $9,720. The check for $3,056 is entered as $3,506.
The number looks right. It has the correct number of digits. It's in the right ballpark. And that's exactly what makes it dangerous.
Why transposition errors are especially hard to catch in reconciliation
Most data entry errors are obvious. A missing zero, an extra digit, a decimal in the wrong place — these produce amounts that look wrong. A $15,000 payment doesn't get confused for a $150,000 one without someone noticing.
Transposition errors are different. When you swap two adjacent digits, the resulting number:
- Has the same number of digits as the original
- Is close in magnitude to the correct value — often within a few hundred dollars
- Passes visual inspection — both numbers look plausible
- Can appear on either side — the bank statement, the GL entry, or both
In a reconciliation with hundreds of transactions, a single transposition error produces one unmatched pair where the amounts are *almost* the same but not quite. Without a tool flagging the relationship, a human reviewer has to notice that $1,845 and $1,485 are the same digits in a different order. Under deadline pressure, with hundreds of items to review, that doesn't always happen.
The divisible-by-9 property
There's a well-known mathematical property of transposition errors: the difference between the correct and transposed amounts is always divisible by 9.
Swap two digits that differ by *d* positions in value, and the resulting difference is always 9 × d × (10^position).
Examples:
- $1,845 vs $1,485 → difference of $360 → 360 ÷ 9 = 40 ✓
- $9,270 vs $9,720 → difference of $450 → 450 ÷ 9 = 50 ✓
- $3,056 vs $3,506 → difference of $450 → 450 ÷ 9 = 50 ✓
This is why experienced accountants are taught: *if your variance is divisible by 9, look for a transposition error.*
It's a useful diagnostic. But it only helps if you already know there's a problem. In a reconciliation context, you often don't know which specific unmatched pair is the culprit — you just see that your variance isn't $0.00 and you have a list of open items to investigate.
How transposition errors compound
A single transposition error that goes undetected in month one doesn't stay isolated. Because the incorrect amount is now your reconciled value for that transaction, subsequent periods start with a wrong carry-forward. The error propagates forward in your books until someone digs into the history and finds it.
In a company reconciling monthly, a transposition error discovered six months later means:
- Six periods need to be re-examined
- Adjusting journal entries need to be booked
- Any financial reports based on those periods may need to be restated
- An auditor asking "how did this happen" gets an uncomfortable answer
Catching it in the period it occurs costs 5 minutes. Catching it six months later costs days.
How BankRecon catches transposition errors automatically
BankRecon's matching engine doesn't just look for exact amount matches — it analyzes the relationships between unmatched amounts. When it finds two items whose difference is divisible by 9 and whose digits are a rearrangement of each other, it flags them as transposition candidates directly in the reconciliation workspace.
Instead of a reviewer having to manually spot that $1,845 and $1,485 are related, BankRecon surfaces it with a visual indicator on the transaction row. The reviewer sees the flag, investigates the source, and either confirms the transposition (and corrects the entry) or clears the flag and moves on.
This happens automatically — no configuration required, no rules to set up. Every reconciliation period benefits from transposition detection without any extra work on your team's part.
The broader lesson
Transposition errors aren't rare. They're a predictable consequence of manual data entry at volume. Every month that humans type numbers into accounting systems, some of those numbers will have swapped digits.
The difference between a clean close and a messy one often comes down to whether your tools flag these patterns before you lock the period. Spreadsheets don't. Purpose-built reconciliation software does.
If your current reconciliation process relies on a human to spot that $9,270 ≠ $9,720 while reviewing 400 unmatched transactions under month-end pressure — you're relying on luck.
BankRecon takes that off your plate.