Reconcile debits & credits using Solver [Advanced Excel]
Here is a tricky problem often faced by accountants and finance professionals: Let’s say you have 5 customers. Each of them need to pay you some money. Instead of paying the total amount in one go, they paid you in 30 small transactions. The total amount of these transactions matches how much they need to pay you. But you don’t know which customer paid which amounts. How would you reconcile the books?
If you match the transactions manually, it can take an eternity – after all there are more than 931 zillion combinations (5^30).
This is where solver can be handy. Solver can find optimal solution for problems like this before you finish your first cup of coffee.
August 18, 2015
