How to Make a Trial Balance Entry on Excel. Businesses use trial balance sheets to calculate the monthly debits and credits posted in their general ledgers.

To use Excel to create a General Ledger from General Journal data, you can set up a worksheet, which includes a number of array formulas that sum up the transaction into the proper accounts.

Microsoft Excel worksheets can consolidate your general ledger accounts into a trial balance worksheet for review during the closing process.