Microsoft Excel worksheets can consolidate your general ledger accounts into a trial ... Open a new Excel spreadsheet. Enter "Account" in cell A1. Input "Debits" in cell B1 and "Credits" in ...