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 between the Subledgers and the detail summary, I have to find where those variances are (duh). Sometimes there are incorrect entries, as I just discovered, which create weird transfer transactions that our system creates automatically. Sometimes even though there is an AR in a subledger, that won't split to the other subledgers even if it does have the correct GL split.
My boss says that it takes her 8 hours to do this. I have been on it for weeks. Keep in mind I also get pulled away to do other things and was just on a 6 day vacation. Additionally was able to complete other tasks as well, like council resolutions, Prl recons, and random entries.
So my ask is, does this sound like a one day thing. Keep in mind she has been with the city for 9 years. I started this last year and have been away from it for half a year for ACFR. I honestly can't for the life of me understand this thing. And I will admit, she is way smarter than I am. But I have been breaking this stupid stuff down piece by piece. It still blows my mind when she is like, here it is, this is how I did it...