Learn how to use Microsoft Excel to unearth and interpret the wealth of data hidden in the general ledger.

A VBA macro in Excel definitely sounds like the way to go. Load the CSV file, load your template spreadsheet, and shuffle the values around. It's pretty straightforward stuff.