A reconciliation difference divisible by 9 usually means two digits were swapped or a decimal point moved when an amount was keyed. Both mistakes always leave a gap that is a multiple of 9. Divide the gap by 9 and the result tells you how far apart the swapped digits are and in which places to look.
Why does a transposition leave a difference divisible by 9?
A transposition is two digits entered in the wrong order, such as 63 typed as 36. The gap it leaves is always a multiple of 9 because every place value is one more than a multiple of 9: 10 is 9 plus 1, 100 is 99 plus 1, and so on.
Take a two-digit amount with tens digit a and units digit b. Its value is 10a + b. Swapped, it becomes 10b + a. Subtract one from the other and you get 9a − 9b, which is 9 × (a − b). The 9 never goes away, whatever the digits are.
The same holds when the swapped digits sit further left, in the hundreds and thousands. The difference becomes 9 × (a − b) × 10, or × 100, depending on the places involved. It also holds for digits that are not next to each other, such as 1,203 typed as 3,201. A swap two places apart leaves a multiple of 99 and a swap three places apart a multiple of 999: 3,201 less 1,203 is 1,998, which is 999 × 2. Both are multiples of 9.
One practical point: run the test on the amount in cents. A $4.50 gap is 450 cents, which divides by 9 exactly, and it fits a swap of the dollars and dimes digits, such as $15.06 entered as $10.56.
What does the quotient of a nine-divisible difference say?
The quotient is the gap divided by 9, and it carries two facts. Its leading digit is the difference between the two swapped digits. Its number of trailing zeros tells you which pair of places swapped. A quotient of 400 means two digits 4 apart, in the thousands and hundreds places.
The table shows example gaps for swaps of adjacent digits. Values are illustrations, not from any client file.
| Example entry error | Gap | Gap ÷ 9 | What the quotient says |
|---|---|---|---|
| $63.00 keyed as $36.00 | $27.00 | 3 | Units and tens, digits 3 apart |
| $1,580.00 keyed as $1,850.00 | $270.00 | 30 | Tens and hundreds, digits 3 apart |
| $5,120.00 keyed as $1,520.00 | $3,600.00 | 400 | Hundreds and thousands, digits 4 apart |
| $412.97 keyed as $412.79 | $0.18 | 0.02 | Dimes and cents, digits 2 apart |
A worked example: a $3,600.00 gap
In this example a reconciliation is out by $3,600.00, with the books showing less cash than the bank. 3,600 ÷ 9 = 400. So look for an amount whose thousands and hundreds digits differ by 4, such as 1 and 5, 2 and 6, 3 and 7, 4 and 8 or 5 and 9. A customer deposit of $5,120.00 recorded as $1,520.00 fits exactly. The bank shows $5,120.00, which agrees with the deposit slip, so the ledger is the side to correct.
Notice that the size of the quotient also limits the search. A 400 quotient cannot come from an amount under $1,000.00, so every small line drops out at once.
Slides and the divide-by-nine test
A slide is a misplaced decimal point, such as $1,250.00 entered as $125.00. Slides also leave a multiple of 9. A slide one place left removes nine tenths of the amount, so the gap is 9 × the smaller figure. A two-place slide leaves 99 × the smaller figure.
That gives a second reading of the quotient. If the gap is $1,125.00, the quotient is 125, and an entry of $125.00 that should have been $1,250.00 fits. If the gap divided by 99 gives a clean amount, look for a two-place slide, such as $8.40 entered for $840.00. Slides and transpositions overlap in what they produce, and the methods for telling them apart are covered in the slide error arithmetic for misplaced decimals.
Narrowing candidate lines for a nine-divisible gap
Narrowing the candidates means using the quotient to rule out lines before you read them. Start with amounts someone typed by hand, because imported bank lines rarely contain swapped digits. Then filter by size, using the place values the quotient names.
A short order that works on most months:
- Compute the gap in cents and confirm it divides by 9.
- Write the quotient and note its leading digit and trailing zeros.
- List hand-keyed ledger entries: checks written, manual deposits, journal entries to cash.
- Drop every amount too small to hold digits in the named places.
- For each remaining amount, swap the two named digits and see whether the result appears on the statement.
- Also try dividing the gap by 99 and by 9 as a slide, then search for that amount.
If the statement shows the swapped figure and the deposit slip or check image agrees with the statement, correct the ledger. If your source document agrees with the ledger, the bank may have keyed it wrong, which is handled as described in proving a bank error on a bank statement.
When the list of hand-keyed lines is long, an auditor might test a selection of them instead of all, using the methods in audit sampling for bank transactions. For finding a single known error, though, the quotient filter usually leaves few enough lines to check every one.
When a difference divisible by 9 is only a coincidence
A difference divisible by 9 is only a hint, not proof. Roughly one whole number in nine is a multiple of 9 by chance, so an omitted $45.00 fee or a missing $1,080.00 deposit passes the test without any digits being swapped. Always check for single omitted lines too.
Combined errors cause the other false readings. A $27.00 transposition plus a $10.00 unrecorded fee leaves $37.00, which fails the test even though a transposition is present. A $20.00 omission plus a $16.00 omission leaves $36.00, which passes without any transposition at all. When the test fails, fix what you can find, recompute the gap, and test again.
A last caution: two transpositions in opposite directions can cancel each other and leave no gap. The reconciliation then balances while two ledger lines disagree with the statement. Only line-by-line matching catches that.
PreciseBankFlow is built to report unexplained differences with the statement line whose amount matches the gap, when there is one, which shortens the candidate list before you divide anything. You can see how on the PreciseBankFlow homepage.