Автоматизация сверки дебиторской задолженности

So I work for a city. I do the AR reconciliation. A lot of job tasks were put on the backburner due to the ACFR. So June is my first reconciliation. Hopping between tasks. There are approximately 10 accounts I believe. Animal (simple plug, looking at the subledger for Animal AR),BAE, BAES, Cobra, Construction, Fire (easy, just a single input), Lease General (pain in butt, 12-14 GL's), Transit, Street, Utilities (Pain in butt #2). There are 42 GL's that currently have balances spread among these accounts. The total amount amongst it all, 22 million dollars. Amounts can be as little as finance charges (.25 cents for example), small invoices (50 bucks), to as much as a large invoices (one is 705k, now paid down to 605, but this is accross multiple accounts). If there is a variance be…