In the first article we looked at the process of getting data out of Sage and into Excel via Sage's File'Send Contents To Excel facility.
When the data came over from Sage, a lot of work was required to clean it up - dates were not real dates, debits and credits were both exported as positive numbers, essential fields were missing.
This, unfortunately, is par for the course - in fact Sage is better than most. In practice, when exporting data into Excel you tend to find that most of the time is spent time tidying up the data ' producing the final management reports themselves often only takes a matter of minutes.
Data Capture from Excelforaccountants.com
Users need to get together to persuade software vendors to supply an 'analysis-ready file' as part of their package. The data...