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.

If you need a monthly or yearly balance for revenue transactions in Microsoft Excel, you're in luck because both are easy! Here's how to find the totals you need.