How to Make a Trial Balance Entry on Excel. Businesses use trial balance sheets to calculate the monthly debits and credits posted in their general ledgers. Debits are the money a business spends ...

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.