Bank Statement Template 03
Bank Statement Template 03
Bank Statement Template 03
JUNE
PREVIOUS BALANCE
$2,525.54
TOTAL DEPOSITS
$5,400.00
monthly bank reconciliation tips:
bank
Enter in the month, year, and previous
balance and the rest will automatically
YEAR ENDING BALANCE TOTAL WITHDRAWLS
statement
calculate. Use the tables below the
2013 $6,550.54 $1,375.00 summary to enter your information.
deposits
deposit no. date amount description reconciled This shape represents a
table slicer. Table slicers are
1 6/2/2013 $1,500.00 job 1, check 1 yes supported in Excel 2013 or
later.
2 6/15/2013 $1,200.00 job 2, check 1 yes
withdrawals
type date amount for reconciled This shape represents a
table slicer. Table slicers are
check 1001 6/1/2013 $150.00 electricity yes supported in Excel 2013 or
later.
check 1002 6/2/2013 $150.00 water/sewer/garbage yes
check 1003 6/4/2013 $850.00 mortgage yes If the shape was modified in
an earlier version of Excel,
debit 6/8/2013 $125.00 groceries yes or if the workbook was
saved in Excel 2007 or
ATM 6/9/2013 $100.00 cash yes earlier, the slicer can't be
TOTAL $1,375.00 used.