Saturday, January 22, 2022

Every mile is magic

I need to vent about this…

My old AR person, at the other company, kept 6 spreadsheets that all had the same information. AND NONE OF IT MATCHED. She had collection notes spread across them and none of them were the same. If you opened spreadsheet A, it had a note that on [date] she talked to the insured and they said blah, blah, blah. If you opened spreadsheet B, it had a note that on [same date] she called and the number was disconnected. The amounts she was trying to collect on were different. The adjuster’s name, phone number. email were all different. Her replacement and I didn’t know which one was right, so we nuked it all and started from scratch.

That was such a miserable experience.

At the new job (a printing company), the woman I’m replacing is just as bad. I plan on consolidating a few of her spreadsheets because I just can’t deal with it.

Maybe it’s my background in construction, or my interest in becoming a CMA, or just the way I’m wired, but work-in-progress schedules turn me on. Why do you need to keep a pending and a sales spreadsheet with you can combine both? I mean, once you have the billed amount on the spreadsheet, you can see if it’s pending or sold. Why not track the costs? There’s so much this simple schedule can do and so many ways you can tweak it… I mean, this is a portion of the final report I built. IT’S SO USEFUL!

(Yes, it’s blurry on purpose. Yes, those numbers aren’t real. I’m not THAT stupid.)

So… yeah. They don’t track their inventory. They don’t have any means to compare estimates to actuals except by looking at several different reports. They barely know if something’s been billed. (The Controller doesn’t sit in on the Production Meetings!?! She’s too busy - no doubt, because she’s managing a BILLION spreadsheets. Gah.)

OH! And I am SALTY about something that went down yesterday. I accidentally calculated the sales tax on a job that was tax-exempt. The spreadsheet was deleted and redone, without the tax calculation. Supposedly because I didn’t have the time to do needless work, habits be damned. THEN, I find out that I did need that sales tax number after all (to go on yet another spreadsheet). So I had to redo that. I TOUCHED THE SAME SPREADSHEET THREE TIMES TO GET ONE NUMBER.

How do I always find these places?

I don’t know… she’s retiring in March so I just have to hold on until then.

Gotta run. (HA!) I have a hot date with the treadmill. I’m getting a jump start on Dopey training because I refuse to let the dwarf beat me two years in a row. Now that I know exactly what to expect, I have a better idea of how I (personally) need to train. Most training plans are one size fits all, and well, I don’t fit that mold.