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

Although a running balance is commonly maintained on the same Excel worksheet as the debits or credits, you can also keep a running balance with figures that reside on different Excel sheets.