Transposition Error
A transposition error occurs when two adjacent digits are accidentally reversed during data entry (for example, entering 72 instead of 27). Although the mistake may seem small, it can produce meaningful accounting and operational discrepancies that propagate through financial reports, tax filings, banking transactions, customer records, and — in extreme cases — medical dosing or trading systems.
Causes
- Human error during manual data entry (ledgers, invoices, checks).
- Transferring numbers between systems or spreadsheets.
- Typing mistakes in trading platforms (often called “fat-finger” trades).
- Entering values into the wrong spreadsheet cells.
Examples and consequences
- Small errors (e.g., $24.74 vs. $24.47) typically have negligible impact.
- Large errors (e.g., $1,823,000 vs. $1,283,000) can produce substantial financial misstatements, affect tax liabilities, mislead shareholders, and trigger regulatory issues.
- In banking, incorrect check amounts can cause overdrafts; in healthcare, misrecorded dosages can be dangerous.
- Trading mistakes have caused major near-misses — for example, a famous “fat-finger” incident where an erroneous order for hundreds of millions or billions of shares was entered (the order did not ultimately execute).
How to identify transposition errors
A useful mathematical property: the difference between the incorrect and correct amounts produced by a simple transposition of two digits is always divisible by 9. Examples:
* 72 recorded instead of 27 → difference = 45 (45 ÷ 9 = 5).
* 63 recorded instead of 36 → difference = 27 (27 ÷ 9 = 3).
Explore More Resources
Accountants and bank tellers can use this rule as a quick check when investigating unexplained discrepancies.
Prevention and controls
- Reconcile accounts regularly to catch discrepancies early.
- Use data validation rules and input masks in accounting and entry systems to limit manual errors.
- Implement dual controls or independent review for high-value entries.
- Encourage double-entry bookkeeping and automated imports from source documents (invoices, bank feeds) to reduce manual transcription.
- Maintain audit trails and exception reports for prompt investigation.
- Provide staff training and clear procedures for data entry and verification.
Key takeaways
- A transposition error is a reversal of adjacent digits made during entry and is a common form of human transcription error.
- Even small-looking transpositions can produce significant financial and operational consequences.
- The “divisible by 9” rule provides a quick way to detect many simple transposition errors.
- Regular reconciliation, validation, independent review, and automation are effective controls to reduce transposition risk.