- This topic has 5 replies, 5 voices, and was last updated 11 years, 7 months ago by .
-
Topic
-
Just wondering your experiences with this…
Had a client in private practice who prepared and gave investors a set of heavily misstated financials – missing subsidiaries, improper accruals, inter-company transactions, wrong usage of terminology, etc. The investors were not pleased.
The controller then sends you a 20 MB spreadsheet that supposedly shows all the cash flow transactions for each individual entity on Wedsnesday afternoon saying that he needs accurate consolidated Income Statements and Balance Sheets for each of the 5 previous fiscal quarters, He says he needs it first thing Friday morning, but you let him know that it is a tall order considering each entity has 500+ trial balance accounts and almost definitely will need to take some time.
The controller is 60 years of age, not a CPA, and never has been.
Thursday is the 4th of July.
You work through your holiday and come in early Friday, finding that there are unwarranted plugs/formulas, and account balances that are not in fact the sum of provided details (granted, the cash and account totals may be correct as provided — but any misstatements in any other account would cause the cash balance to change, and details do not substantiate all totals).
The task, to create an excel tool/code that can covert this stack into the requested set of financial statements, is possible but lengthy, and would be prone to error regarding any new periods or additional accounts not provided (which is exactly what is going to happen). The controller calls Friday morning and is not amused that the task has not been complete; he needs this NOW and you spend the next 20 hearing about why its so easy from the guy who uses the terms “net revenue” and “net income” interchangeably.
I’m not crazy for thinking that this kind of thing takes time, right?
- The topic ‘Advisory Services – Ever been yelled at by a client?’ is closed to new replies.