Formats
I think you need to make your financial statement formats uniform. It causes a lot of extra work because they are not. The same item needs to be on the same numbered line, i.e. Net Income needs to be on the same line in every report, even if some preceding lines are blank if I can pull things into my models by line. On the other hand, if you put "Net Income" on a line as a header and then put "Net Income to Company" below that, and then "Net Income" with the data on the next line, VLOOKUP finds the first Net Income and it has to be changed in the model to pick up the numbers.
In addition to that, some of the reports have the entire amount, and in others, numbers are by thousands, i.e. Net Income 10,000,000 versus 10,000 in thousands. Don't understand why you do that. Also the date formats aren't clear as to what they refer to on the financial statements. Does "2018" refer to the calendar date or the fiscal year? Another problem is the number formats are in text and have to be changed to numbers via the little button on the side. Maybe there is some reason why people want the text format but it has the problem that if I don't get all of those changed the numbers don't add correctly and skew the results. It is necessary to be hyper vigilant about something that could be fixed by you.
converting text data in numbers doesn't work for data that are expressed with a dollar sign in it. And percentage data needs to be changed manually to reflect the percentage
One year ago and still not solved ?