Find the numbers that add up to a target sum – and the ones that are missing. For reconciliations, invoices and payslip checks.
The sum finder looks through a list of numbers for the ones that add up to a specific sum. You paste in the numbers and the target sum, and the tool shows every combination that works. Under each combination are the numbers that are left out. These are often exactly what you are looking for: the missing invoice, the entry that creates the difference, or the pay component that is not included in the pension.
Enter the sum in Target sum and paste the numbers with one number per line – for example straight from an Excel column or a bank statement. Click Analyse. The tool tries every combination and shows the ones that hit the sum, closest first.
In Excel this problem can only be solved with the Solver add-in, which needs a helper column and constraints to be set up. Solver also finds just one solution. The sum finder shows all solutions, so you can see whether the numbers can add up in more than one way. Amounts can be pasted in the format you already have: 1,286.00, 1.286,00 and 1 286,00 are all read correctly.
When a reconciliation does not balance, the difference is almost always one or more entries that are missing, appear twice or are posted wrongly. Use the difference as the target sum and the period's entries as the list. The tool shows which entries add up to the difference.
The bank shows 1,637.50 more than the ledger. The month's entries are 412.50 · 1,225.00 · 89.95 · 2,340.00 · 618.00 · 318.75 · 1,104.25 · 145.00.
412.50 + 1,225.00 = 1,637.50 ✓
Those are the two entries to check in the ledger. Try the example with the Find the difference button at the top.
A customer has paid 4,750 without quoting invoice numbers. The open invoices are 1,200 · 850 · 2,700 · 1,450 · 3,250.
1,200 + 850 + 2,700 = 4,750 ✓
Under Not included in the sum you will find 1,450 and 3,250 – the invoices that are still open.
This section is about Danish payslips and collective agreements (overenskomster); the amounts are in Danish kroner (DKK). A payslip usually shows only the pension contribution or the free-choice amount (fritvalgslønkonto) – not which pay components the amount was calculated from. You find the basis by dividing the amount by the rate. Use the basis as the target sum and the payslip's pay components as the list. The tool shows which components are included and which are not. Use an allowed deviation of 1–2 DKK, because the amounts are rounded to whole øre.
The company pension is 8% = DKK 2,522.91. The basis is 2,522.91 / 0.08 = DKK 31,536.38. The pay components are basic salary 28,450.00 · personal supplement 1,850.00 · unsocial-hours allowance (genetillæg) 1,236.40 · overtime 2,114.60.
28,450.00 + 1,850.00 + 1,236.40 = 31,536.40 ✓
Overtime appears under Not included in the sum, so it is not part of the pension basis. Try the example with the Check pension basis button.
The free-choice pay account (fritvalgslønkonto) is 4% = DKK 1,198.00. The basis is 1,198.00 / 0.04 = DKK 29,950.00. The pay components are basic salary 28,100.00 · supplement 1,850.00 · unsocial-hours allowance 1,236.40 · overtime 2,114.60.
28,100.00 + 1,850.00 = 29,950.00 ✓
The unsocial-hours allowance and overtime are not included. Use the rate from your own payslip – it depends on the collective agreement.
You can work out the rate with the percentage calculator if the payslip shows only the amount. To check the rest of the pay, use the salary conversion calculator or the real wage calculator.
Target sum 4,750, deviation 0. Invoices: 1,200, 850, 2,700, 1,450, 3,250.
1,200 + 850 + 2,700 = 4,750 ✓
Target sum 31,536.38, deviation 1. Pay components: 28,450.00, 1,850.00, 1,236.40, 2,114.60.
28,450.00 + 1,850.00 + 1,236.40 = 31,536.40 ✓ (deviation 0.02)
A mathematical match is not proof. If several combinations add up, check the vouchers before you clear or correct an entry.
If you have more than 20 entries, split the reconciliation up – for example by week or by customer – and look for partial sums.
Which pay components are pensionable or count towards the free-choice pay account is set out in your collective agreement or contract. The tool shows what has actually been included – compare it with the agreement.
If you find a pay component that should have been included, take the payslip to your shop steward or your trade union.
Content last reviewed October 2026.