A running balance updates as new debits or credits are made, so you always see the most updated balance. 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. As an example, you might want Sheet1 to display the running balance for your business, but have debits on Sheet2 and credits on Sheet 3. Although this segregation may appear daunting at first, using proper references makes creating the running balance only marginally more cumbersome.
|