Currently the data contains columns labeled Withdrawal, Deposit, and Balance. The Withdrawal column contains expenses, or money that the fictional small business has paid to other people or businesses. The Deposit column contains money brought in to the small business, typically invoices paid by customers or clients. The Balance column is almost completely empty. Using the carryover balance, withdrawals, and deposits, a running balance can be calculated.
When the Annual Report data was imported, it contained the carryover balance from the previous year. This amount can be used to calculate the running balance throughout the current year.
To calculate the new balance, begin with the previous balance, subtract any withdrawals, and add any deposits.
To select the correct cell,
Click in cell G3
To start the formula, type:
To enter the cell address containing the previous balance,
Click in cell G2
To subtract any withdrawals, type:
To add any deposits, type:
In the Formula bar, you see =G2-E3+F3. This formula is telling Excel to take the previous balance, subtract the closest occurrence of Withdrawal, and add the closest occurrence of Deposit.
To enter this formula, press:
The new balance appears in cell G3 and is $50 less than the previous balance.
It is possible to copy this formula to the rest of the cells in the Balance column (column G).
To make cell G3 the active cell,
Click in cell G3
To use the AutoFill handle to copy the formula,
The formula is copied throughout the Balance column.
To deselect the column,
Click in any cell
It may be necessary to widen the Balance column so that all of the numbers are visible.
To widen the Balance column, in the column headers,