Reconciling Multiple Credits to a Single Debit

**Caitie94** · 12-15-2021, 06:06 PM

HAALLLPPPP!

I'm completely new to VBA. Basically, I have a reconciliation spreadsheet that I pull monthly that lists all debit and transactions in the GL for a certain account. I have to go in and match these up. However, the specific account I am working on is large (300+ unreconciled lines) and the debit transactions typically include multiple non-sequential/unequal credits. Is there a faster way that trying to match these up manually? I attempted to use Solver, but my variable range was too large. In the sample I attached, the color coded cells have already been manually matched up.

**jomili** · 12-17-2021, 03:42 PM

Caitie94,
I'm confused. When you "Match Up", what exactly are you matching? Are you looking for the same amounts in the Debit column as the Credit column, or amounts in Credit that add up to the Debit amounts? If not, WHAT are you matching with WHAT?

**jomili** · 12-17-2021, 04:00 PM

I THINK what you're trying to do is find the values in the Credit column that add up to the Debit column. If so, I haven't seen a new solution to that in a long time, but I have a couple of old solutions from MUCH smarter people. Someone today might be able to improve on these, but they're what I used back in the old days, and they still work. Sorry they're not the most user friendly, but explore them and see if they help.