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.
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 -
Pages to are hidden for
"Monthly Bank Reconciliation"Please download to view full document