Marina and Brian have a joint checking account. They have a balance of $3,839.25 in the check register. The balance on the bank statement is $3,450.10. Not reported on the statement are deposits of $2,000, $135.67, $254.77, and $188.76 and four checks for $567.89, $23.83, $598.33, and $1,000.
Make a Google spreadsheet
Step 1: Enter the outstanding deposits in cells A3 to A9.
Step 2: Enter the outstanding checks in cells B3 to B9.
Step 3: Have cell A10 calculate the total amount of the outstanding deposits The cell formula for the total of the outstanding deposits in A10 is =sum(A3:A9).
Step 4: Now have cell B10 calculate the total amount of the outstanding checks by using the same procedure as in Step 3.
Step 5: Enter the check register balance in cell C12.
Step 6: Enter the statement ending balance in cell C13.
Step 7: Have cell C14 calculate the revised statement balance, which is the sum of the statement ending balance and total outstanding deposits minus the total outstanding checks. The formula is =C13+A10−B10.
Step 8: Now in cell A16, type the IF statement, =IF(C12=C14, “Statement is reconciled.”, “Statement is not reconciled.”).
Did the Statement Reconcile?