Input deposits and (payments) into appropriate columns.
Formula is automatically shown in the balance column, however it is hidden.
To show balance, click on $ Icon and the answer will appear.
Save as the month appropriate month.
For the next month, insert the balance forwarded in the Deposits column. Make a notation in the description section that this is
Attach cancelled checks and instruct students on completing the reconciliation at the bottom of the statements.
Note: Rename the worksheet tabs with the students' ID numbers and last name. This will then appear in the header when the
Students can use a preprinted check register to record payments and deposits, or allow them to access the "Register", which c
in the description section that this is the forwarded balance.
m of the statements.
then appear in the header when the individual statements are printed.
em to access the "Register", which can be saved in their directories.
3d1b712f-bd6d-4d30-90b9-9f6565d5c7bc.xlsx 1 11/8/2011
Bank Statement
Date Type Description Debit ( -- ) Credit ( + ) Account
Balance
0.00 $ -
$ -
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
Balance your Register
1. Enter the balance shown on your statement in the box provided. 1.
2. Total any deposits listed in your check register that do not appear on this statement and write total in box provided. 2.
3. Add Box 1 and Box 2 write the answer in the box provided. 3.
4. Total any outstanding checks and withdrawals from your register that do not show on your statement in Box 4. 4.
5. Subract Box 4 from Box 3. This amount should be the same as the current balance in your check register. 5.
3d1b712f-bd6d-4d30-90b9-9f6565d5c7bc.xlsx 2 11/8/2011
Bank Statement
Date Type Description Debit ( -- ) Credit ( + ) Account
Balance
0.00 $ -
$ -
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
Balance your Register
1. Enter the balance shown on your statement in the box provided. 1.
2. Total any deposits listed in your check register that do not appear on this statement and write total in box provided. 2.
3. Add Box 1 and Box 2 write the answer in the box provided. 3.
4. Total any outstanding checks and withdrawals from your register that do not show on your statement in Box 4. 4.
5. Subract Box 4 from Box 3. This amount should be the same as the current balance in your check register. 5.
3d1b712f-bd6d-4d30-90b9-9f6565d5c7bc.xlsx 3 11/8/2011
Bank Statement
Date Type Description Debit ( -- ) Credit ( + ) Account
Balance
0.00 $ -
$ -
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
Balance your Register
1. Enter the balance shown on your statement in the box provided. 1.
2. Total any deposits listed in your check register that do not appear on this statement and write total in box provided. 2.
3. Add Box 1 and Box 2 write the answer in the box provided. 3.
4. Total any outstanding checks and withdrawals from your register that do not show on your statement in Box 4. 4.
5. Subract Box 4 from Box 3. This amount should be the same as the current balance in your check register. 5.
3d1b712f-bd6d-4d30-90b9-9f6565d5c7bc.xlsx 4 11/8/2011
Bank Statement
Date Type Description Debit ( -- ) Credit ( + ) Account
Balance
0.00 $ -
$ -
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
Balance your Register
1. Enter the balance shown on your statement in the box provided. 1.
2. Total any deposits listed in your check register that do not appear on this statement and write total in box provided. 2.
3. Add Box 1 and Box 2 write the answer in the box provided. 3.
4. Total any outstanding checks and withdrawals from your register that do not show on your statement in Box 4. 4.
5. Subract Box 4 from Box 3. This amount should be the same as the current balance in your check register. 5.
3d1b712f-bd6d-4d30-90b9-9f6565d5c7bc.xlsx 5 11/8/2011
Bank Statement
Date Type Description Debit ( -- ) Credit ( + ) Account
Balance
0.00 $ -
$ -
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
Balance your Register
1. Enter the balance shown on your statement in the box provided. 1.
2. Total any deposits listed in your check register that do not appear on this statement and write total in box provided. 2.
3. Add Box 1 and Box 2 write the answer in the box provided. 3.
4. Total any outstanding checks and withdrawals from your register that do not show on your statement in Box 4. 4.
5. Subract Box 4 from Box 3. This amount should be the same as the current balance in your check register. 5.
3d1b712f-bd6d-4d30-90b9-9f6565d5c7bc.xlsx 6 11/8/2011
Bank Statement
Date Type Description Debit ( -- ) Credit ( + ) Account
Balance
0.00 $ -
$ -
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
Balance your Register
1. Enter the balance shown on your statement in the box provided. 1.
2. Total any deposits listed in your check register that do not appear on this statement and write total in box provided. 2.
3. Add Box 1 and Box 2 write the answer in the box provided. 3.
4. Total any outstanding checks and withdrawals from your register that do not show on your statement in Box 4. 4.
5. Subract Box 4 from Box 3. This amount should be the same as the current balance in your check register. 5.
3d1b712f-bd6d-4d30-90b9-9f6565d5c7bc.xlsx 7 11/8/2011
Bank Statement
Date Type Description Debit ( -- ) Credit ( + ) Account
Balance
0.00 $ -
$ -
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
Balance your Register
1. Enter the balance shown on your statement in the box provided. 1.
2. Total any deposits listed in your check register that do not appear on this statement and write total in box provided. 2.
3. Add Box 1 and Box 2 write the answer in the box provided. 3.
4. Total any outstanding checks and withdrawals from your register that do not show on your statement in Box 4. 4.
5. Subract Box 4 from Box 3. This amount should be the same as the current balance in your check register. 5.
3d1b712f-bd6d-4d30-90b9-9f6565d5c7bc.xlsx 8 11/8/2011
Bank Statement
Date Type Description Debit ( -- ) Credit ( + ) Account
Balance
0.00 $ -
$ -
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
Balance your Register
1. Enter the balance shown on your statement in the box provided. 1.
2. Total any deposits listed in your check register that do not appear on this statement and write total in box provided. 2.
3. Add Box 1 and Box 2 write the answer in the box provided. 3.
4. Total any outstanding checks and withdrawals from your register that do not show on your statement in Box 4. 4.
5. Subract Box 4 from Box 3. This amount should be the same as the current balance in your check register. 5.
3d1b712f-bd6d-4d30-90b9-9f6565d5c7bc.xlsx 9 11/8/2011
Bank Statement
Date Type Description Debit ( -- ) Credit ( + ) Account
Balance
0.00 $ -
$ -
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
Balance your Register
1. Enter the balance shown on your statement in the box provided. 1.
2. Total any deposits listed in your check register that do not appear on this statement and write total in box provided. 2.
3. Add Box 1 and Box 2 write the answer in the box provided. 3.
4. Total any outstanding checks and withdrawals from your register that do not show on your statement in Box 4. 4.
5. Subract Box 4 from Box 3. This amount should be the same as the current balance in your check register. 5.
3d1b712f-bd6d-4d30-90b9-9f6565d5c7bc.xlsx 10 11/8/201110
Bank Statement
Date Type Description Debit ( -- ) Credit ( + ) Account
Balance
0.00 $ -
$ -
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
Balance your Register
1. Enter the balance shown on your statement in the box provided. 1.
2. Total any deposits listed in your check register that do not appear on this statement and write total in box provided. 2.
3. Add Box 1 and Box 2 write the answer in the box provided. 3.
4. Total any outstanding checks and withdrawals from your register that do not show on your statement in Box 4. 4.
5. Subract Box 4 from Box 3. This amount should be the same as the current balance in your check register. 5.
Number Date Description Debit ( -- ) Credit ( + ) Account
a
Balance
0.00 $ -
$ -
$ -
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
: