Bank Conciliation

Document Sample
Bank Conciliation Powered By Docstoc
					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
				
DOCUMENT INFO
Description: 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.
This document is also part of a package Bookkeeping Forms for your Business 49 Documents Included