How to Keep Track of Credit and Debit Using Excel. Keeping track of income and spending for even just one person can be a whirlwind of slips of paper, checks, receipts and more, and it can get a ...

Using Excel 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.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Put simply, a credit is money owed, and a debit is money due. Debits increase the balance in asset, expense, and dividend accounts, and credits decrease them.