Free Bank Reconciliation Template 02
Download the document to the computer for easy use
There are more pages to preview,Read on

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