First, I am not thinking money right now, I am much more interested in solving my issue. Yesterday I spent the whole day loading a bunch of filed in hyperion. W

First, I am not thinking money right now, I am much more interested in solving my issue. Yesterday I spent the whole day loading a bunch of filed in hyperion. With a good script that takes 10 seconds. Second, accounting does have a logic (GAAP...). In fact, hyperion does make money, even being a horrible tool (not web based, it is used with citrix, you can imagine...). Third, the main problem of all this software that 'assists', as you say, is that it invents csv formats and standards every time. Leaving you no choice but using GUIs that when it comes to generate a lot of reports slow you down a lot (think of SAP that doesn't have an easy way to script things). Fourth, Excel is not a database. And not being a database, you lose all the SQL operations. No group by, sum, order, where, and stuff. Yes you have pivot tables, but you can't perform a join and you can't use big datasets with them. Fifth, in accounting working vertically on the dataset is not enough. You need to perform various 'shaping' operations. You can do this with excel, yes, but again, it is painful. Sixth, there are for sure better ways of consolidating data from different files. In excel you 'link' different workbooks in a master file. I am even going to tell you why that is a bad practice, I think it speaks for itself. So, no, it's really not about the mapping. It's about serious technical issues that nobody is taking care of. And I am pretty sure this is because programmers don't dare to think like an accountant.