0 0

Business Bank Reconciliation

ABOUT THIS DOCUMENT

This document provides a template spreadsheet to compare data from bank statements with computed book balances on a monthly basis. 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: 11455 times
Used: 15 times
Pages: 1
Size: 30 kb
Format: Excel Spreadsheet

Text Version

[Company Name]



Monthly Bank Reconciliation Date:





Date of Statement Ending Balance from Bank Statement $



Add: Deposits in Transit Date Amount Date Amount









-

Total Deposits in Transit



Less: Regular Checks: Payroll Checks:









Total Outstanding Checks -



Computed Book Balance $





Book Reconciliation



Computed Book Balance $



Add: Deposits - Income Trucks Cash & Checks

Counter Cash & Checks

MC/Visa/Discover

Debit

Other Deposits -



Less: Checks issued - Regular

Checks issued - Payroll

Federal Tax Deposits (FTD) -



Analysis Charge

Credit Card Discounts

Other Charges - -



Book Balance Revised $





Designed by: Kara L. Rothert

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?