0 0

Bank Conciliation

ABOUT THIS DOCUMENT

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.

Reads: 1129 times
Used: 11 times
Pages: 1
Size: 20 kb
Format: Excel Spreadsheet

Text Version

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

Sign-up for Docstoc Premium
Registration enables you to experience on site recommendations of documents, articles, packages and courses as well as recommendation emails for the content we think you'll love the most
Already a member?
Don't have a Facebook account?
Register with E-mail

Enter a valid email address (xxx@xxx.com)
Preloader
By registering with docstoc.com you agree to
our privacy policy and terms of service
Sign-in
Complete Access to Over 20 Million Professional Documents Including Premium Legal Contracts & Business Forms
Hundreds of Hours of Online Courses & Video Tutorials
24/7 Premium Customer Support
No Cost - No Obligation - No Risk
Use your email and password to sign-in here.
Click forgot your password if you need help.
Need to register?
Forgot Password?
Complete Access to Over 20 Million Professional Documents Including Premium Legal Contracts & Business Forms
Hundreds of Hours of Online Courses & Video Tutorials
24/7 Premium Customer Support
No Cost - No Obligation - No Risk
Use your email and password to sign-in here.
Click forgot your password if you need help.
Need to register?
Don't have a Facebook account?
Login with your Docstoc account.


Email or Username

Preloader

1. Please rate your experience on the following scale:


2. Would you recommend Docstoc to a friend?


Submit

Would you be interested in taking a longer survey for a chance to win a 1-month free subscription to Docstoc Premium?