Use a blank Excel worksheet to create a trial balance sheet. In row A, add the titles for each column: "Account Name/Title," in column A, "Debit," in column B and "Credit" in column C.

Open a new Excel spreadsheet. Enter "Account" in cell A1. Input "Debits" in cell B1 and "Credits" in cell C1. Input each account name into a separate cell of column A.

A trial balance is a bookkeeping worksheet in which the balances of all ledgers are compiled into equal debit and credit account column totals.

How to get a yearly balance in Excel Our simple data set has transactions for only one year, 2020, but that doesn’t matter. We can expect only one balance for the data set.