We’re under a contract with one our clients to provide a semi-annual reporting of the amounts we invoice for analytical work versus the amounts we’re supposed to invoice according to the agreed price list for the analyses. The report periods are Jan 01 to Jun 30 and Jul 01 to Dec 31, and the report for each period is due one month following the period’s end.
Today’s major task is clearing up the last-minute questions or concerns about the Jul 01-Dec 31, 2005, report, which of course is due to the client tomorrow.
So I hate today. I have a stack of invoice copies through which I must comb to determine what actually was invoiced; what turnaround time was requested and what TAT was really achieved; and, if any rush charges applied, how they were calculated.
To be fair, the initial data set covers about 1500 line items and I’m only having to review 31 invoices which total a couple hundred of those items, but then there’s a wrinkle.
The prices under which this work is completed changed midway through 2005, and the pricing applicable to any given invoice is determined largely by what can only be described as voodoo.
I have an Excel spreadsheet into which I’ve rammed various magic formulae and conditional-formatting routines and incorporated both pre-2005 and post-2005 price lists. The formulae compare what was invoiced against both of the contract price lists and the conditional formatting highlights the differences so I can spot them easily and figure out just WTF is going on.
:: • :: • :: • :: • ::
I don’t know how anyone does accounting work full-time. The four or five days I spend on it each year drive me right up the damned wall.