I found it I found it I found it.
After two harrowing weeks and hundreds of spreadsheet manipulations, I finally found the last $2000+ to reconcile the 80 million disbursed for that particular aid year.
It was down to the wire. An unforeseen problem made itself evident as I was doing the final crunching. It was a mess. You just keep whittling away and hope you whittle to the right spot. I had to get a week's extension. But it's done.
And I know what to fix to make it go better for the next year's reconciliation, which I'm starting on right now.
I was trying everything. I had anxiety attacks. I threw my hands up in the air. I teared up a time or two. But I finally found it. When I added up the final numbers on my adding machine and they finally equaled what is on record with the Dept...I almost yelled for joy!
I can keep my job for another week or two.
Whew.