To put your ledger to work for you year after year, turn it into a template. Once you've entered all of the G/L codes and the terms in the next column, click the "File" tab, select "Save As," and ...

Importing into Excel Once this Print to File option has been created, you can print the general ledger to this printer option from your accounting system and import the resulting .prn file into Excel.