$1.$ Use spreadsheet software to prepare a bank reconciliation. Format the document and key appropriate headings as shown in Figure $7-6.$ Use October $31$ of the current year as the date.

$2.$The bank statement dated October $25$ shows an ending balance of $$4,452\mathrm{.}03.$ The statement also shows a service charge of $$15$ for checks you ordered and received. Key these amounts in the appropriate places on your spreadsheet.

$3.$You have checked all the deposits and all the checks shown on the statement. You also have compared the returned canceled checks with your check register. Key the following information from your worksheet in the appropriate places on your spreadsheet:

$-$The check register balance on October $31,$ before adjustment, is $$3,560\mathrm{.}58.$

$-$One deposit dated October $27$ for $$1,256\mathrm{.}50$ is in transit $($outstanding$).$

$-$The following checks are outstanding: #$457$ for $$356\mathrm{.}76,$ #$481$ for $$125\mathrm{.}00,$ #$482$ for $$890\mathrm{.}65,$ and #$483$ for $$790\mathrm{.}54.$

$4.$Enter formulas to calculate the adjusted check register balance and the adjusted bank balance. These two amounts should be the same. If they are not, check to see that the numbers and formulas have been entered correctly.