Monthly Bank Reconciliation

VIEWS: 560 PAGES: 2

The Monthly Bank Reconciliation form allows a company to balance its books by entering transactions and deposits represented on the bank statement that are not recorded in the company's bank general ledger. Companies should also record deposits made and checks issued that are not cleared on the bank statement in order to calculate a revised account balance. This spreadsheet can help an organization find differences between its bank statement and accounting records and make necessary adjustments to reconcile those amounts.

More Info
									Bank Reconciliation
[ENTER BANK ACCOUNT NAME]

Date of Bank Statement:                                                                          31-07-2011
Statement Ending Balance:                                                        $                     -
Transactions Not on Check Register (Company's Books/ Records):
(Bank Services Charges, Interest Income, Automatic Withdrawals, etc.)
Description of Deposit Transaction:               Date:              Ref:        Amount:
                                                                                 $                     -
                                                                                                       -
                                                                                                       -
                                                                        Sub-total $                    -
Description of Payment Transaction:               Date:              Ref:        Amount:
                                                                                 $                     -
                                                                                                       -
                                                                                                       -
                                                                        Sub-total $                    -
Transactions Not on Bank Statement:
(Deposits not cleared on bank statement, payroll and bill payments made but not cleared, etc.)
Description of Deposits:                          Date:              Check #:    Amount:
                                                                                 $                     -
                                                                                                       -
                                                                                                       -
                                                                                                       -
                                                                        Sub-total $                    -
Description of Payments:                          Date:              Check #:    Amount:
                                                                                 $                     -
                                                                                                       -
                                                                                                       -
                                                                                                       -
                                                                                                       -
                                                                                                       -
                                                                                                       -
                                                                                                       -
                                                                                                       -
                                                                                                       -
                                                                                                       -
                                                                        Sub-total $                    -
CALCULATED ACCOUNT BALANCE   -
								
To top