Content
monthly
bank
statement
MONTH
PREVIOUS BALANCE
TOTAL DEPOSITS
JUNE
$2,525.54
$5,400.00
YEAR
ENDING BALANCE
TOTAL WITHDRAWLS
2013
$6,550.54
$1,375.00
monthly bank reconciliation tips:
Enter in the month, year, and previous
balance and the rest will automatically
calculate. Use the tables below the
summary to enter your information.
deposits
deposit no.
date
amount
description
reconciled
1
2013-6-2
$1,500.00
job 1, check 1
yes
2
2013-6-15
$1,200.00
job 2, check 1
yes
3
2013-6-16
$1,500.00
job 1, check 2
yes
4
2013-6-30
$1,200.00
job 2, check 2
yes
TOTAL
$5,400.00
This shape represents a table
slicer. Table slicers are supported
in Excel 2013 or later.
If the shape was modified in an
earlier version of Excel, or if the
workbook was saved in Excel
2007 or earlier, the slicer can't be
used.
withdrawals
type