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.

How to Prepare a Tax-Basis Balance Sheet. Balance-sheet balances carry over from one period to the next. So the ending cash balance from last year will become the beginning cash balance this year.

How to Balance Your Checkbook Using an Excel Spreadsheet March 27, 2016 — 11:44 am EDT. ... it takes extra effort to make sure you're tracking your money appropriately.