# Transposition Errors in Data Entry: The Divide-by-9 Clue - Author: CheapBankConvert (https://cheapbankconvert.com) - Published: 2026-10-17 - Category: The cost of manual data entry - Canonical: https://cheapbankconvert.com/blog/transposition-errors-in-data-entry > How transposition errors in data entry happen, why a difference divisible by 9 gives them away, and what one swapped amount costs to find. Transposition errors in data entry happen when you type two neighbouring digits in the wrong order, such as 1,284 for 1,248. Your eyes read the right number and your fingers swap it. The clue is in the totals: when a typed column is off by an amount that divides evenly by 9, look for a swapped pair first. ## What is a transposition error in data entry? A transposition error is a pair of adjacent digits typed in reverse order. The value looks plausible, every digit is present, and nothing about the cell warns you. That is why it survives a quick glance and only shows up when a total or a balance fails to match. On a bank statement the swap can land anywhere in an amount. It can hit the dollars, as in 63.10 typed as 36.10, or the cents, as in 52.71 typed as 52.17. Dates suffer too: 03/12 becomes 03/21, and the row slides into another week. Dates are harder to catch because no total depends on them. Swaps tend to happen when you read a number in one window and type it in another. You hold the digits in memory for a second, and the order slips. Fatigue, long amounts and a busy page make it more likely. Typing on the number pad helps because your hand stays in one place, a habit covered in [setting up numeric keypad data entry for statement amounts](/blog/numeric-keypad-data-entry). ## Why is a transposition difference always divisible by 9? Swapping two adjacent digits always changes a number by a multiple of 9. If the digits are a and b in neighbouring places, the error equals 9 times the gap between them, times the place value. So a column that is off by 9, 18, 36, 0.54 or 450 points to a swap before anything else. Here is the arithmetic in plain terms. The pair "48" is worth 4 tens and 8 ones, which is 48. The swapped pair "84" is worth 84. The difference is 36, which is 9 times 4, and 4 is the gap between the digits 8 and 4. The same rule holds in any position. A swap in the cents, 0.71 against 0.17, gives 0.54, which is 9 times 0.06. The quotient helps you search. Divide the difference by 9 and you get the gap between the swapped digits, scaled to their place. A quotient of 4 means you are looking for an amount whose ones and tens digits differ by 4. A quotient of 0.06 points to cents digits that differ by 6. ## Divide-by-9 worked example on a typed statement total The divide-by-9 test turns a vague "the total is wrong" into a short list of suspect rows. You subtract the two totals, divide by 9, and scan for amounts whose digits fit the result. The example below uses made-up figures. Say you typed a month of debits from a statement. The statement lists total withdrawals of 4,912.37. Your sheet sums to 4,948.37. 1. Difference: 4,948.37 minus 4,912.37 equals 36.00. 2. 36.00 divided by 9 equals 4, with nothing left over, so a swap is likely. 3. A quotient of 4 in the ones place means two neighbouring digits in the tens and ones that differ by 4: 0 and 4, 1 and 5, 2 and 6, 3 and 7, 4 and 8, or 5 and 9. 4. Your sheet is 36 too high, so the typed amount is the larger order of the pair. Scan for amounts ending in 40, 51, 62, 73, 84 or 95 dollars. 5. You find 1,284.00 in row 23. The statement shows 1,248.00. Fix it and the totals tie. In this example the search covered a handful of rows instead of the whole column. That is the value of the test: it tells you what shape of number to look for. ## Transposition look-alikes: slides, doubled rows and two errors at once A difference divisible by 9 does not prove a transposition. A slide, where the decimal point moves, also leaves a multiple of 9: 45.20 typed as 452.00 is off by 406.80, which is 9 times 45.20. Other errors break the pattern completely, so the test is a first guess, not a verdict. Watch for these cases: - **Slides.** A shifted decimal gives a large multiple of 9. If the quotient equals one of your amounts, as 45.20 does here, look for that amount with its decimal moved. - **Doubled or skipped rows.** A row typed twice makes the total too high by exactly that amount. Search for an amount equal to the difference before you divide. - **Two errors at once.** Two mistakes can cancel or combine into a number that hides both. If the divide-by-9 search finds nothing, compare the sheet with the statement page by page using page subtotals. - **A few cents off.** A gap of a few cents may be rounding, or a total that included tax. Before you blame typing, check that both sides measure the same thing, the trap described in [comparing PDF converter prices with sales tax included](/blog/pdf-converter-sales-tax). ## The cost of hunting one transposed statement amount One swapped amount costs the minutes you spend finding it, plus the risk if you never do. With the divide-by-9 test a search might take two minutes. Without it, comparing 80 rows line by line can take fifteen. At an example rate of $25 an hour, that gap is the difference between about $0.83 and $6.25. The larger cost is the swap you miss. A transposed amount in a budget makes one category look bigger and another smaller. In records for a tax preparer or a lender, it is a wrong figure with your name on it. The full arithmetic of typing time, checking and errors is laid out in [what manual data entry costs per statement](/blog/manual-data-entry-cost). A conversion removes the retyping step where swaps happen, because the digits come from the PDF's own text. At CheapBankConvert's early pricing, a statement of up to 10 pages is $2.99, and you still compare the converted totals with the printed ones before you rely on them. The product is not open yet; [get started](/get-started) to be told when it is. ## Habits that keep transposition errors out of a typed statement The best defence against transposition is a check that fires within a few rows of the mistake, not at the end of the month. A running balance column does this, because a swapped amount breaks the balance on the very row you typed. Two or three habits at the keyboard cut the rest. - **Type a running balance.** Add a column that computes the balance and compare it with the printed one every few rows. - **Read amounts in chunks.** Say "twelve, forty-eight" in your head rather than "one, two, four, eight". Chunks hold their order better. - **Enter one record at a time.** A record-style entry screen keeps your place, which the guide to [the Excel data entry form for statement transactions](/blog/excel-data-entry-form) sets up step by step. - **Check subtotals per page.** A wrong page total narrows the search to a few dozen rows. - **Slow down on long numbers.** Five-digit and six-digit amounts are where swaps cost the most.