Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Bank Conciliation

VIEWS: 1,223 PAGES: 1

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.

More Info
									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
								
To top