This Bank Conciliation is a spreadsheet designed to help an organization reconcile its bank statements with its accounting records. Differences may occur when companies have issued checks that have yet to be cashed, or when certain charges have already been recorded by the organization's bank but are not yet reflected in the organization's accounting records. This document can help an organization identify discrepancies between its bank statements and accounting records and make necessary adjustments to reconcile those amounts.
Company Name Bank conciliation of the month of January 2010 Bank of America account number 0157-5782-244 in Pesos Balance according to bank statement $ 21,655.52 Date Number Description Amount Plus: Deposits not considered by the bank 0.00 Minus: Deposits not considered in accounting 0.00 Minus: Checks not cash -14,106.43 23-May-10 8 Elai monk 563.50 27-Jan-10 86 Company co. ltd 8,050.00 27-Jan-10 94 Marco Tolama 3,114.20 27-Jan-10 95 Enterprise ltd 2,378.73 Accounting Balance $ 7,549.09 TRUE ERP Balance $ 7,549.09 Bank of America account number 0157-8568-177 in USD Balance according to bank statement $ 1,299.84 Plus: Deposits not considered by the bank 0.00 Minus: Deposits not considered in accounting 0.00 Minus: Checks not cash 0.00 Accounting Balance $ 1,299.84 ERP Balance $ 1,299.84 Exchange rate last day of the month 10.4167 Real balance in Pesos 13,540.04 Accounting balance in Pesos 10,172.21 11,472.05 Exchange rate win 2,067.99
Pages to are hidden for
"Bank Conciliation"Please download to view full document