Your ledger is off, but you cannot tell which entries are missing

Built!

Enter a list of amounts and the difference to explain. The tool finds groups of amounts that add up to that difference.

Current workflow

When the ledger total and the bank balance differ by 43,500 KRW, the only way forward is finding which entries, out of dozens or hundreds, were omitted or duplicated in combination. With hundreds of thousands of possible combinations, it can't be done by eye — so people tap away at a calculator guessing at combinations, or re-check the entire statement from the top. Excel's Solver can do it, but it needs an add-in installed and constraints set up. And in the struggle, the quick checks that should come first get skipped: is the difference a multiple of 9 (the signature of a transposition error, digits written in reverse order)? Is there an entry exactly equal to the difference? Is there an entry equal to half the difference (the sign of a deposit recorded as a withdrawal, or the reverse)?

Solution

Find Items Matching a Difference

How to use

1. Paste the list of transaction amounts. 2. Enter the difference you're hunting for (for example, 37,200 KRW). 3. Candidate combinations that add up exactly to the difference appear. If there are several, check the ones with the fewest entries first. 4. Compare the combination against your records to confirm whether those entries were omitted or duplicated. (A matching sum alone doesn't confirm the cause.)

Example

- Input: a list of transaction amounts (15 entries in this example) and a target difference of 37,200 KRW - Result: candidate combinations that add up to exactly 37,200 KRW (for example, 12,500 KRW + 24,700 KRW), listed with the fewest entries first. Instead of re-checking everything, you start by checking these candidates against your receipts.

Open tool
View details
Limits
- Several combinations can match, and coincidental matches get mixed in. Confirm against actual records. - You can enter up to 40 amounts at a time and get up to 20 results. For large lists, split the run by period.
Cost type
Free

Some differences no combination will explain. If the cause is a mistyped amount — a transposition error like writing 45,000 instead of 54,000 — no subset may add up to the difference. Transposition errors always produce a difference that is a multiple of 9, so when no combination comes out, suspect an error pattern like that first. More than 40 amounts cannot be entered at once, so run the tool period by period (monthly, weekly).

Support

I have this problem too · 0 people

Sign in to support or ask a question

Comments

Be the first to comment.

Additional information

Delete a post made without signing in