It’s not uncommon to download a trial balance into Excel and then make adjustments within Excel to produce the desired set of management reports. Problem is; that we’re back to using Excel and Excel, as good as it is, is notorious for allowing us humans to make mistakes.

Technology today should allow us to make the adjustments in the accounting system and extract the information quickly in the way we want to see it. With the right technology, it is possible to create dynamic links between the cells in Excel and the data within your system - using Excel as your report writer: set it up once and then refresh the data when needed.

So, no more typing into Excel, Download – yes, dynamic linking – yes, pivot tables from ODBC driver data – yes, making adjustments in Excel – no (unless you really really have to!)