|   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  A M Benjamin
  Services | 
    | 
 
 
  |   | 
    | 
    | 
    | 
   
  
   | 
    | 
    | 
    | 
 
 
  |   | 
  Bookkeeping
  and Tax Consulting | 
    | 
 
 
  |   | 
  835 O
  Farrell St. # 404 | 
    | 
 
 
  |   | 
  San
  Francisco, CA 94109 | 
    | 
 
 
  |   | 
  415/596-3164 | 
    | 
 
 
  |   | 
  ambenjamin79@yahoo.com | 
    | 
 
 
  |   | 
  www.a-m-benjamin-services.net | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  by: Anthony
  M. Benjamin Sr. | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler is an accounting article on reconciling | 
    | 
 
 
  |   | 
   your cash account and bank statement. | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  After
  reading this article the small business person should have a | 
    | 
 
 
  |   | 
  a better
  understanding of the following subjects | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  (1) What a
  bank reconciliations is ? | 
    | 
 
 
  |   | 
  (2) Why you
  needs to know what they are looking at ? | 
    | 
 
 
  |   | 
  (3) Many
  bank reconciliation major terms ? | 
    | 
 
 
  |   | 
  (4) The Key
  Elements of Bank Reconciliations ? | 
    | 
 
 
  |   | 
  (5) Some
  microsoft excel key formula's ? | 
    | 
 
 
  |   | 
  (6) The Key
  Elements of Bank Reconciliations ? | 
    | 
 
 
  |   | 
  (7) Some
  microsoft excel key formula's ? | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
   While this article was written to show my
  potential client my skills | 
    | 
 
 
  |   | 
   as an accountant; it was also written as a
  tool for the small business  | 
    | 
 
 
  |   | 
  to check
  their employees work. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  To many of
  my idols from the past died poor because they did not | 
    | 
 
 
  |   | 
  take the
  time to learn the secrets of bank reconciliations, this | 
    | 
 
 
  |   | 
  article will
  show anyone how to do it and what to look for. | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  previous
  page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
  n/a | 
   | 
  02 of 20 | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Table of
  Contents | 
    | 
 
 
  |   | 
  Page 02 | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  | 0 | 
  (01) The Ultimate Reconciler - Title Page | 
    | 
 
 
  | ## | 
  (02) The Ultimate Reconciler - Table of Contents | 
    | 
 
 
  | ## | 
  (03) Why reconcile your Cash Account ? | 
    | 
 
 
  | ## | 
  (04) The Beauty of Zero ! | 
    | 
 
 
  | ## | 
  (05) What is your cash balance ? | 
    | 
 
 
  | ## | 
  (06) What are
  Cash Receipts ?  | 
    | 
 
 
  | ## | 
  (07) What are your cash disbursements ? | 
    | 
 
 
  | ## | 
  (08) What is your ending cash bank balance ! | 
    | 
 
 
  | ## | 
  (09) What is your bank deposits | 
    | 
 
 
  | ## | 
  (10) What is your bank disbursement ! | 
    | 
 
 
  | ## | 
  (11) The Cash Reconciliation Formula ! | 
    | 
 
 
  | ## | 
  (12) The Deposit Reconciliation formula | 
    | 
 
 
  | ## | 
  (13) The Disbursement Reconciliation formula | 
    | 
 
 
  | ## | 
  (14) The Magic of Microsoft  Excel Spreadsheets ! | 
    | 
 
 
  | ## | 
  (15) Company Financial Data Example | 
    | 
 
 
  | ## | 
  (16)
  Complete Bank Reconciliation Example  | 
    | 
 
 
  | ## | 
  (17) Glossary of terms | 
    | 
 
 
  | ## | 
  (18) About the Author | 
    | 
 
 
  | ## | 
  (19) Marketing Message ! | 
    | 
 
 
  | ## | 
  (20) Final Thanks | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table
  of contents | 
  next page | 
    | 
 
 
  |   | 
  01 of 20 | 
   | 
  03 of 20 | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 03 | 
    | 
 
 
  |   | 
  Why
  reconcile your cash account.? | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  This
  article is for the small business owner who wants to know a  | 
    | 
 
 
  |   | 
  little more
  about bank reconciliations. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Without a
  doubt, your business most important account is "Cash". | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  How you manage "Cash"
  will  | 
    | 
 
 
  |   | 
  (1) measure
  the success of your business, | 
    | 
 
 
  |   | 
  (2) help
  protect you from fraud | 
    | 
 
 
  |   | 
  (3) improve
  your credit rating by paying | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  While
  the operating and marketing your business may be your  | 
    | 
 
 
  |   | 
  main
  job and force you to delegate bank reconciling to another  | 
    | 
 
 
  |   | 
  person, it
  is imperative that you take a look at your "Cash" account | 
    | 
 
 
  |   | 
   as a business owner on a consistent basis
  because as the  | 
    | 
 
 
  |   | 
  owner or
  accounting officer of a business, any mismanagement of " | 
    | 
 
 
  |   | 
  Cash"
  will be blamed on you with serious legal consequences  | 
    | 
 
 
  |   | 
  attached to
  your personal and business reputation. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Reconciling
  your cash  will help your business grow
  and keep you  | 
    | 
 
 
  |   | 
  safer from
  government agencies and business creditors. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
  02 of 20 | 
   | 
  04 of 20 | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 04 | 
    | 
 
 
  |   | 
   The Beauty of Zero ! | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  In
  the Science of Accounting, the number "Zero" is every  | 
    | 
 
 
  |   | 
  accountants,
  bookkeeper or clerk perfect dream; because when | 
    | 
 
 
  |   | 
  you
  have two set of numbers, and when you subract the totals and  | 
    | 
 
 
  |   | 
  get
  "Zero", you have a reason to celebrate. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  "Zero"
  in bank reconciliations  tells you
  everything is alright and | 
    | 
 
 
  |   | 
  you
  completed your mission. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  "Zero"
  in bank reconciliations tells you almost all of your money   | 
    | 
 
 
  |   | 
  has been
  accounted for which is a magical pill 
  that will let you | 
    | 
 
 
  |   | 
  that will
  let you sleep a little easier that night. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  "Zero",
  when attained in bank reconciliation on a consistant basis | 
    | 
 
 
  |   | 
  tells the
  business world you are a professional and have acheived | 
    | 
 
 
  |   | 
  a level of
  excellence in accounting that few people dream of. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Without
  "Zero there can be no bank reconciliation. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
  03 of 20 | 
   | 
  05 of 20 | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 05 | 
    | 
 
 
  |   | 
  What is your
  cash balance ? | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  On the
  surface, your figure for cash in your trial balance and | 
    | 
 
 
  |   | 
  balance
  sheet, looks like a simple number amongst many other | 
    | 
 
 
  |   | 
  numbers. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  But in
  reality your cash balance is a summary statement of  | 
    | 
 
 
  |   | 
  all the
  money that came into and went out of your hands or | 
    | 
 
 
  |   | 
  business for
  a specific period of time. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Your cash
  balance consist of two components: | 
    | 
 
 
  |   | 
  (1) deposits
  - the money coming into your business | 
    | 
 
 
  |   | 
  (2)
  disbursement - the money leaving your business | 
    | 
 
 
  |   | 
  the
  components above will be discuss more indepth in the next | 
    | 
 
 
  |   | 
  two
  chapters. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  But as a
  business owner or operator, always knowing what your | 
    | 
 
 
  |   | 
  cash balance
  is a daily job that is very important. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
   04 of 20 | 
   | 
  06 of 20 | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 06 | 
    | 
 
 
  |   | 
  What are
  Cash Receipts ? | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
   Cash Reciepts in your Business and Bank
  Reconciliation are  | 
    | 
 
 
  |   | 
   two of sources of pride that uplift your
  spirit and reminders of | 
    | 
 
 
  |   | 
   of your ability to generate income. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
   Primarily a list of: | 
    | 
 
 
  |   | 
           1. 
  Dates | 
    | 
 
 
  |   | 
           2. 
  Clients Names | 
    | 
 
 
  |   | 
           3. 
  Amounts of Money that came in | 
    | 
 
 
  |   | 
           4. 
  Income and Receivable Codes | 
    | 
 
 
  |   | 
    that enter your business during a specific
  period of time, your | 
    | 
 
 
  |   | 
    Cash Receipts are the energy that keep your
  company alive. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
   Keeping accurate records of the elements
  above measures | 
    | 
 
 
  |   | 
  a. your
  financial success or failure | 
    | 
 
 
  |   | 
  b. suggest
  how you can improve your cash flow | 
    | 
 
 
  |   | 
  c. an
  informed list for taxes and other government reports | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  The
  business that carefully monitors its cash receipts, is the  | 
    | 
 
 
  |   | 
  business
  that can do an easy bank reconciliation and be very  | 
    | 
 
 
  |   | 
  sure the
  information on their balance sheet is correct. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
  05 of 20 | 
   | 
  07 of 20 | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 07 | 
    | 
 
 
  |   | 
  What are
  Cash Disbursement  ? | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
   Cash Disbursement in your Business and Bank
  Reconciliation are  | 
    | 
 
 
  |   | 
  pictures of
  your financial obligations and ability to give to workers | 
    | 
 
 
  |   | 
  and business
  associates during a specific period of time ! | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
   Primarily a list of: | 
    | 
 
 
  |   | 
           1. Dates | 
    | 
 
 
  |   | 
           2. Vendor Names | 
    | 
 
 
  |   | 
           3. Amounts of Money that went out | 
    | 
 
 
  |   | 
           4. Expense and Payable codes | 
    | 
 
 
  |   | 
    that enter your business during a specific
  period of time, your | 
    | 
 
 
  |   | 
    Cash Disbursements are the energy that keep
  your company alive. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
   Keeping accurate records of the elements
  above measures | 
    | 
 
 
  |   | 
  a.  where your money went | 
    | 
 
 
  |   | 
  b.  how much money you spent | 
    | 
 
 
  |   | 
  c.  keep you in good repore with credit
  bureau's | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  The
  business owner that carefully monitors its cash disbursements,  | 
    | 
 
 
  |   | 
  is the
  business that has happy vendors and employees and spends | 
    | 
 
 
  |   | 
  less time
  worrying about there money ! | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
  06 of 20 | 
   | 
  08 of 20 | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 08 | 
    | 
 
 
  |   | 
  What is your
  Ending Cash Balance ? | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Your Ending
  Balance on your Bank Reconciliations is an  | 
    | 
 
 
  |   | 
  important
  number balance sheet because it is a summary of your | 
    | 
 
 
  |   | 
  sources and
  uses of cash. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Without your
  ending cash balance you have no number to compare | 
    | 
 
 
  |   | 
  to the the
  bank ending balance that verifies what your company | 
    | 
 
 
  |   | 
  state is
  true or documents that support your financial growth or | 
    | 
 
 
  |   | 
  financial
  decline. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  When
  the Ending Cash Balance is carefully monitored, you can  | 
    | 
 
 
  |   | 
  tell without
  indepth analyzation | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  1. how much
  your business improved or declined | 
    | 
 
 
  |   | 
  2. how close
  your business stuck to the budget | 
    | 
 
 
  |   | 
  3. more time
  for searching on ideas for growth | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  The Ending
  Cash Balance is like a tombstone, it is the final number | 
    | 
 
 
  |   | 
  that people
  and organization will remember by when determining | 
    | 
 
 
  |   | 
  credit, tax
  reports and other business reports. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
  07 of 20 | 
   | 
  09 of 20 | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 09 | 
    | 
 
 
  |   | 
  What are
  your bank deposits ? | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Banks are
  more than places than places we put our cash to | 
    | 
 
 
  |   | 
  keep it
  safe, they are verifier of what we say is true and | 
    | 
 
 
  |   | 
  financial
  associates that assist in running our business smoothly. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  The number
  on the monthly bank statement, specificly the | 
    | 
 
 
  |   | 
   bank deposits tells us, | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  1.  did the accountant record all receipts | 
    | 
 
 
  |   | 
  2.  what information may be missing | 
    | 
 
 
  |   | 
  3.  are there any suprises we need to check out | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Unlike your
  company cash receipt, the bank deposit does not | 
    | 
 
 
  |   | 
  have a
  client names on the bank statements, so bank reconcilers | 
    | 
 
 
  |   | 
  must
  be very careful in recording dates so matching clients with  | 
    | 
 
 
  |   | 
  bank figures
  will be easier. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  An important
  name in the analysis of bank deposits is  | 
    | 
 
 
  |   | 
  "deposit
  in transits", the accounting terms that tell what the | 
    | 
 
 
  |   | 
  bank has not
  recorded and what you have recorded. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Bank
  Deposits are your proof of what you Earned or Borrowed ! | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
  08 of 20 | 
   | 
  10 of 20 | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 10 | 
    | 
 
 
  |   | 
  The Cash
  Reconciliation Formula | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Bank
  disbursement on your monthly bank statement is a list of | 
    | 
 
 
  |   | 
  the money
  that left your business account during a period of time. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  While seldom
  the same number of your company disbursements, | 
    | 
 
 
  |   | 
  it is a
  starting point to see where your money went and key  | 
    | 
 
 
  |   | 
  figure in
  verifying all your information is matching correctly. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  To reconcile
  the bank disbursements to the company checks | 
    | 
 
 
  |   | 
   the reconciler must be able to identify
  three key figures: | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  1.  prior month checks | 
    | 
 
 
  |   | 
  2. 
  bank charges not listed on  | 
    | 
 
 
  |   | 
  3.  company currents checks not listed on bank
  statement | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Different
  from bank deposits, bank disbursements have the same | 
    | 
 
 
  |   | 
  check number
  as your company so reconciling this element is | 
    | 
 
 
  |   | 
  easier. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Similiar to
  Bank Deposit, Bank Disbursement are proof of what | 
    | 
 
 
  |   | 
  you have
  spent and invested in your business. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
  09 of 20 | 
   | 
  11 of 20 | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 11 | 
    | 
 
 
  |   | 
  The Cash
  Reconciliation Formula | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  The beauty
  of accounting and bank reconciliation is that it is a | 
    | 
 
 
  |   | 
  universal
  formula that when applied correctly will give you | 
    | 
 
 
  |   | 
  that magical
  number that number that accountant love, "zero" | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  The science
  of accounting is concern with matching | 
    | 
 
 
  |   | 
  debits and
  credits, the left and right side of a trial balance. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  The science
  of bank reconciliation is concern with matching | 
    | 
 
 
  |   | 
  your company
  financial data to the banks financial data ! | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  When
  the bank reconciliation formula below is applied correctly,  | 
    | 
 
 
  |   | 
  you can be
  confident your work is correct. | 
    | 
 
 
  |   | 
  
  
  
  
   | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  When
  the formula above subtract to zero, you have the recorded  | 
    | 
 
 
  |   | 
  everything
  and can sleep easy tonight. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
  10 of 20 | 
   | 
  12 of 20 | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 12 | 
    | 
 
 
  |   | 
  The
  Disbursement Reconciliation Formula ! | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  While the
  primary bank reconciliation formula are sets of number | 
    | 
 
 
  |   | 
  from both
  your company and your bank account records, the  | 
    | 
 
 
  |   | 
  cash deposit
  reconciliation formula is a specialize set of numbers | 
    | 
 
 
  |   | 
  that
  requires research of your bank records. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  The bank
  deposit reconciliation formula requires you to keep | 
    | 
 
 
  |   | 
  a track of
  both your current month deposits and your previous | 
    | 
 
 
  |   | 
  months
  deposits, when done correctly, you can be assured | 
    | 
 
 
  |   | 
  your bank
  reconciliation is correct and know where to look when | 
    | 
 
 
  |   | 
  a number is
  incorrect on your bank reconciliation. | 
    | 
 
 
  |   | 
  
  
  
  
   | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  Thou many
  accounting software programs has automatic bank  | 
    | 
 
 
  |   | 
  reconciler's,
  the only way to be 100% sure is to use the formula  | 
    | 
 
 
  |   | 
  above for
  deposits and look for yourself. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
  11 of 20 | 
   | 
  13 of 20 | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 13 | 
    | 
 
 
  |   | 
  The
  Disbursement Reconciliation Formula ! | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  My experience as
  an accountant has always been that  | 
    | 
 
 
  |   | 
  disbursement
  reconciliation has always been more of a  | 
    | 
 
 
  |   | 
  challenge
  than receipts reconciliation. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Receipts has
  always been with a few numbers, while the numbers | 
    | 
 
 
  |   | 
  in
  disbursement has often ran into the hundreds of checks, | 
    | 
 
 
  |   | 
  some time
  even thousands. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  No matter
  how checks or disbursements you have, you will always | 
    | 
 
 
  |   | 
  be able to
  reconcile your bank statement and books if you make a | 
    | 
 
 
  |   | 
  good listing
  of old and new old standing checks. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  While
  shortcuts may exist, your business needs to be 100%  | 
    | 
 
 
  |   | 
  certain and
  using this formula is one way  to be
  sure. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
   
  
   | 
    | 
    | 
  
  
   | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
  12 of 20 | 
   | 
  14 of 20 | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 14 | 
    | 
 
 
  |   | 
  The Magic of Microsoft Excel Spreadsheets ! | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  If
  accounting and bank reconciliers had a best friend, with a doubt | 
    | 
 
 
  |   | 
  the
  Microsoft Excel Spreadsheet. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Not
  only does Microsoft Excel Spreadsheet eliminate the need to  | 
    | 
 
 
  |   | 
  the perfect
  the use of an adding machine and many sheets of | 
    | 
 
 
  |   | 
  papers,
  it ability to store formula's and replicate documents  | 
    | 
 
 
  |   | 
  cuts the
  work of the professional bookkeeper by 75%. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  In
  addition to uses for accounting and business management,  | 
    | 
 
 
  |   | 
  Microsoft
  Excel Spreadsheet is a great tool for preparing  | 
    | 
 
 
  |   | 
  Web Pages,
  Writing Letter and Drawing Images because of the | 
    | 
 
 
  |   | 
  lines and
  boxes that is built into it. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  If you are
  not familiar with Microsoft Excel Spreadsheet, here are | 
    | 
 
 
  |   | 
  tools or
  icons that will let you help you do basic calculations | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  1. all
  arithmetic operation begins with the keyboard symbol (=) | 
    | 
 
 
  |   | 
  2. the
  multiplication is represented by the keyboard (*) symbol | 
    | 
 
 
  |   | 
  3. the
  division is represented by the keyboard (/) symbol | 
    | 
 
 
  |   | 
  
  
  
  
   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  If you need
  some help with the basic formula email me for a small fee! | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
  13 of 20 | 
   | 
  15 of 20 | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 15 | 
    | 
 
 
  |   | 
  Company
  Financial Data Example | 
    | 
 
 
  |   | 
   
  
   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
  12 - Sample
  Data for Bank Reconciliation Example | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
  May Bank Statement | 
    | 
    | 
    | 
    | 
  Beginning Book Balance | 
    | 
   $
  10,730.00  | 
    | 
  Bank Balance 5/31/05 | 
    | 
   $ 19,590.00  | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
  Beginning Balance | 
    | 
    | 
   $ 
  5,000.00  | 
    | 
  Receipts | 
    | 
   $ 13,725.00  | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
  Deposits | 
    | 
    | 
   $
  17,525.00  | 
    | 
  Disbursements | 
    | 
   $ (2,625.00) | 
    | 
  Deposit in Transit | 
    | 
   $ 
  2,700.00  | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
  Disbursements | 
    | 
    | 
   $ (2,885.00) | 
    | 
  Bank Adj | 
    | 
   $           
  -    | 
    | 
  Outstanding Checks | 
    | 
   $     
  (70.00) | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
  Adjustments
  (bank fees) | 
    | 
    | 
   $     
  (50.00) | 
    | 
  Ending Balance | 
    | 
   $ 21,830.00  | 
    | 
  Adj Bank Balance | 
    | 
   $ 22,220.00  | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
  Ending Balance | 
    | 
    | 
   $ 19,590.00  | 
    | 
    | 
    | 
    | 
  05 bank clear checks | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
  current outstanding checks | 
   current bank disbursements  | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
  May Reciepts | 
    | 
    | 
    | 
    | 
  05 checks | 
    | 
    | 
   $ 2,225.00  | 
   $ 
  70.00  | 
   $ 2,155.00  | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
  date  | 
  amount | 
    | 
    | 
  5/7/2005 | 
  Sarah | 
  3538 | 
   $  
  125.00  | 
   $      
  -    | 
   $  
  125.00  | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
  4/30/2005 | 
   $ 6,500.00  | 
    | 
    | 
  5/7/2005 | 
  Bill | 
  3539 | 
   $  
  100.00  | 
   $      
  -    | 
   $   100.00  | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
  5/3/2005 | 
   $ 1,025.00  | 
    | 
    | 
  5/15/2005 | 
  Vonie | 
  3540 | 
   $    
  75.00  | 
   $      
  -    | 
   $     75.00  | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
  5/15/2005 | 
   $ 2,500.00  | 
    | 
    | 
  5/15/2005 | 
  Vickie | 
  3541 | 
   $  
  400.00  | 
   $      
  -    | 
   $   400.00  | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
  5/16/2005 | 
   $ 7,500.00  | 
    | 
    | 
  5/22/2005 | 
  Liz | 
  3542 | 
   $  
  725.00  | 
   $      
  -    | 
   $   725.00  | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
  May Reciepts
  Total | 
    | 
    | 
   $ 17,525.00  | 
    | 
  5/22/2005 | 
  Dudee | 
  3543 | 
   $    
  80.00  | 
   $      
  -    | 
   $     80.00  | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
  May Disbursement | 
    | 
    | 
    | 
    | 
  5/30/2005 | 
  Jimmie | 
  3544 | 
   $    
  70.00  | 
   $ 
  70.00  | 
    | 
    | 
    | 
 
 
  |   | 
  14 of 20 | 
   | 
  16 of 20 | 
    | 
  Date  | 
  Check # | 
  Amount | 
    | 
    | 
  5/30/2005 | 
  Rodney | 
  3545 | 
   $  
  650.00  | 
   $      
  -    | 
   $   650.00  | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 16 | 
    | 
 
 
  |   | 
  Complete Bank Reconciliation
  Example  | 
    | 
 
 
  |   | 
   
  
   | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
  15 of 20 | 
   | 
  17 of 20 | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 17 | 
    | 
 
 
  |   | 
  Glossary of
  Terms | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  (01) Company
  Beginning Balance (BB) - the previous company ending balance carry forward. | 
    | 
 
 
  |   | 
  (02)
  Company  Receipts - a list of company
  receipts for the current month | 
    | 
 
 
  |   | 
  (03) Company
  Disbursements - a list of company checks for the current month | 
    | 
 
 
  |   | 
  (04) Company
  Adjustments - current bank charges and adjust to company beginning balance | 
    | 
 
 
  |   | 
  (05) Company
  Ending Balance (EB) - = the sum of BB + Receipts - Disbursements (+ or -)
  Adjustments | 
    | 
 
 
  |   | 
  (06) Bank
  Ending Balance - a number on  the bank
  statement showing what is available. | 
    | 
 
 
  |   | 
  (07) Bank
  Deposit in Transits - Current company receipts not on bank statement. | 
    | 
 
 
  |   | 
  (08) Bank
  Outstanding Checks - Current company checks not on bank list of checks | 
    | 
 
 
  |   | 
  (09) Bank's
  Adjusted Balance - = the sum of banks EB (+) Deposit in transits (-)
  outstanding checks. | 
    | 
    | 
 
 
  |   | 
  (10)
  Banks prior outstanding checks - a list of checks that is not from the
  current month.  | 
    | 
    | 
 
 
  |   | 
  (11)
  Banks prior receipts - a list of deposit that is not from the current
  month.  | 
    | 
    | 
 
 
  |   | 
  (12) Ending
  Balance Box Check - Company End Balance (-) Bank Adjusted Balance (ok when 0) | 
    | 
    | 
 
 
  |   | 
  (13) Cash
  Receipt Box Check  - Company Receipts
  (-) Cash Receipt ADJ (ok when 0) | 
    | 
    | 
 
 
  |   | 
  (14) Cash
  Disbursement Box Check - Company Checks (-) Cash Disbursement  ADJ (ok when 0) | 
    | 
    | 
 
 
  |   | 
  (15) (*)
  adjustments to company beginning beginning must be shown in company
  adjustments. | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
    | 
 
 
  |   | 
  16 of 20 | 
   | 
  18 of 20 | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 18 | 
    | 
 
 
  |   | 
  About the
  Author ! | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Anthony M.
  Benjamin is the president and founder of  | 
    | 
 
 
  |   | 
  A M Benjamin
  Services, a soul proprietorship located in  | 
    | 
 
 
  |   | 
  San
  Francisco, California dedicated to serving the needs of | 
    | 
 
 
  |   | 
  Small
  Business and Individuals | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Credentials  | 
    | 
 
 
  |   | 
  California
  Registered Tax Preparer - CTEC | 
    | 
 
 
  |   | 
  Computerized  Accounting Certificate - CCSF | 
    | 
 
 
  |   | 
  MB
  Accounting Candidate   -  SFSU | 
    | 
 
 
  |   | 
  Import/Export
  Certicate-  CCSF | 
    | 
 
 
  |   | 
  Microsoft
  Excel Expert - Certiport | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Microsoft
  Partner | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
  17 of 20 | 
   | 
  19 of 20 | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 19 | 
    | 
 
 
  |   | 
  Marketing Message  | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Other
  Electronic Articles by A. M. Benjamin Services. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
   1. The
  Ultimate Accountant - | 
    | 
 
 
  |   | 
             a
  short story on finding an accountant who help your business grow. | 
    | 
 
 
  |   | 
           
     | 
    | 
 
 
  |   | 
  
2. Three Reasons to File your
  Taxes  | 
    | 
 
 
  |   | 
            a
  short story about some major benefits of filing your taxes on time. | 
    | 
 
 
  |   | 
           
     | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
  Bank
  Reconciliation Software Program | 
    | 
 
 
  |   | 
             specialized software that is
  compatiable with microsoft excel that  | 
    | 
 
 
  |   | 
           
  automatically sums all the columns for you after you put in the
  figures. | 
    | 
 
 
  |   | 
           
  suggested retail price $29.99 | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
  18 of 20 | 
   | 
  20 of 20 | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  The Ultimate
  Bank Reconciler | 
    | 
 
 
  |   | 
  Page 20 | 
    | 
 
 
  |   | 
  Final Thanks | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  Thank you for
  reading The Ultimate Bank Reconciler,  | 
    | 
 
 
  |   | 
  if there was anything about this article you didnot
  understand | 
    | 
 
 
  |   | 
  I may be contacted by email for one free questions. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
  A M Benjamin Services also offers online
  bookkeeping and | 
    | 
 
 
  |   | 
  tax preparation services which you can pay with my
  online | 
    | 
 
 
  |   | 
  Paypal service. | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
   
  
   | 
    | 
    | 
    | 
 
 
  |   | 
  A M Benjamin
  Services | 
    | 
 
 
  |   | 
  Bookkeeping
  and Tax Consulting | 
    | 
 
 
  |   | 
  835 O
  Farrell St. # 404 | 
    | 
 
 
  |   | 
  San
  Francisco, CA 94109 | 
    | 
 
 
  |   | 
  415/596-3164 | 
    | 
 
 
  |   | 
  ambenjamin79@yahoo.com | 
    | 
 
 
  |   | 
  www.a-m-benjamin-services.net | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  previous page | 
  table of contents | 
  next page | 
    | 
 
 
  |   | 
  19 of 20 | 
   | 
  01 of 20 | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
  1 | 
  April
  Receipt's | 
  05 Receipt | 
    | 
 
 
  |   | 
    | 
  2 | 
  date | 
  client | 
  number | 
  amount | 
  date | 
  client | 
  number | 
  amount | 
    | 
 
 
  |   | 
    | 
  3 | 
  4/3/2005 | 
  Kaylese | 
  4001 | 
   $    
  1,025.00  | 
  5/3/2005 | 
  Kaylese | 
  5001 | 
   $   
  1,025.00  | 
    | 
 
 
  |   | 
    | 
  4 | 
  4/15/2005 | 
  Sis | 
  4002 | 
   $    
  2,500.00  | 
  5/15/2005 | 
  Sis | 
  5002 | 
   $   
  2,500.00  | 
    | 
 
 
  |   | 
    | 
  5 | 
  4/30/2005 | 
  Cleo | 
  4003 | 
   $    
  6,500.00  | 
  5/16/2005 | 
  Cleo | 
  5003 | 
   $   
  7,500.00  | 
    | 
 
 
  |   | 
    | 
  6 | 
    | 
    | 
    | 
    | 
  5/28/2005 | 
  John B | 
  5004 | 
   $   
  1,200.00  | 
    | 
 
 
  |   | 
    | 
  7 | 
    | 
    | 
    | 
    | 
  5/29/2005 | 
  John H | 
  5005 | 
   $   
  1,500.00  | 
    | 
 
 
  |   | 
    | 
  8 | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
  9 | 
  April Receipt's Total | 
    | 
    | 
   $   10,025.00  | 
  May Receipt Total | 
    | 
    | 
   $  13,725.00  | 
    | 
 
 
  |   | 
    | 
  10 | 
  April Checks | 
  05 checks | 
    | 
 
 
  |   | 
    | 
  11 | 
  date | 
  vendor | 
  number | 
  amount | 
  date | 
  client | 
  number | 
  amount | 
    | 
 
 
  |   | 
    | 
  12 | 
  4/7/2005 | 
  Sarah | 
  3529 | 
   $       
  125.00  | 
  5/7/2005 | 
  Sarah | 
  3538 | 
   $      
  125.00  | 
    | 
 
 
  |   | 
    | 
  13 | 
  4/7/2005 | 
  Bill | 
  3530 | 
   $       
  100.00  | 
  5/7/2005 | 
  Bill | 
  3539 | 
   $      
  100.00  | 
    | 
 
 
  |   | 
    | 
  14 | 
  4/15/2005 | 
  Vonie | 
  3531 | 
   $         
  75.00  | 
  5/15/2005 | 
  Vonie | 
  3540 | 
   $        
  75.00  | 
    | 
 
 
  |   | 
    | 
  15 | 
  4/15/2005 | 
  Vickie | 
  3532 | 
   $       
  400.00  | 
  5/15/2005 | 
  Vickie | 
  3541 | 
   $      
  400.00  | 
    | 
 
 
  |   | 
    | 
  16 | 
  4/22/2005 | 
  Liz | 
  3533 | 
   $       
  725.00  | 
  5/22/2005 | 
  Liz | 
  3542 | 
   $      
  725.00  | 
    | 
 
 
  |   | 
    | 
  17 | 
  4/22/2005 | 
  Dudee | 
  3534 | 
   $         
  80.00  | 
  5/22/2005 | 
  Dudee | 
  3543 | 
   $        
  80.00  | 
    | 
 
 
  |   | 
    | 
  18 | 
  4/30/2005 | 
  Jimmie | 
  3535 | 
   $         
  70.00  | 
  5/30/2005 | 
  Jimmie | 
  3544 | 
   $        
  70.00  | 
    | 
 
 
  |   | 
    | 
  19 | 
  4/30/2005 | 
  Rodney | 
  3536 | 
   $       
  650.00  | 
  5/30/2005 | 
  Rodney | 
  3545 | 
   $      
  650.00  | 
    | 
 
 
  |   | 
    | 
  20 | 
  4/30/2005 | 
  George | 
  3537 | 
   $       
  400.00  | 
  5/30/2005 | 
  Fred | 
  3546 | 
   $      
  800.00  | 
    | 
 
 
  |   | 
    | 
  21 | 
  April Checks Total | 
    | 
    | 
   $     2,625.00  | 
   May Checks Total  | 
    | 
    | 
   $   
  3,025.00  | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
  April Receipt's | 
    | 
 
 
  |   | 
    | 
  date | 
  client | 
  number | 
    | 
    | 
 
 
  |   | 
  1 | 
  4/3/2005 | 
  Kaylese | 
  4001 | 
   $    
  1,025.00  | 
    | 
 
 
  |   | 
  2 | 
  4/15/2005 | 
  Sis | 
  4002 | 
   $    
  2,500.00  | 
    | 
 
 
  |   | 
  3 | 
  4/30/2005 | 
  Cleo | 
  4003 | 
   $    
  6,500.00  | 
    | 
 
 
  |   | 
  4 | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  5 | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  6 | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  7 | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  8 | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  9 | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  10 | 
  April Receipt's Total | 
    | 
    | 
   $   10,025.00  | 
    | 
 
 
  |   | 
    | 
  05 Receipt | 
    | 
 
 
  |   | 
    | 
  date | 
  client | 
  number | 
  amount | 
    | 
 
 
  |   | 
  1 | 
  5/3/2005 | 
  Kaylese | 
  5001 | 
   $    
  1,025.00  | 
    | 
 
 
  |   | 
  2 | 
  5/15/2005 | 
  Sis | 
  5002 | 
   $    
  2,500.00  | 
    | 
 
 
  |   | 
  3 | 
  5/16/2005 | 
  Cleo | 
  5003 | 
   $    
  7,500.00  | 
    | 
 
 
  |   | 
  4 | 
  5/28/2005 | 
  John B | 
  5004 | 
   $    
  1,200.00  | 
    | 
 
 
  |   | 
  5 | 
  5/29/2005 | 
  John H | 
  5005 | 
   $    
  1,500.00  | 
    | 
 
 
  |   | 
  6 | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  7 | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  8 | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  9 | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  10 | 
  May Receipt Total | 
    | 
    | 
   $   13,725.00  | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
 
 
  |   | 
    | 
  April Checks | 
    | 
 
 
  |   | 
    | 
  date | 
  vendor | 
  number | 
  amount | 
    | 
 
 
  |   | 
    | 
  4/7/2005 | 
  Sarah | 
  3529 | 
   $       
  125.00  | 
    | 
 
 
  |   | 
  1 | 
  4/7/2005 | 
  Bill | 
  3530 | 
   $       
  100.00  | 
    | 
 
 
  |   | 
  2 | 
  4/15/2005 | 
  Vonie | 
  3531 | 
   $         
  75.00  | 
    | 
 
 
  |   | 
  3 | 
  4/15/2005 | 
  Vickie | 
  3532 | 
   $       
  400.00  | 
    | 
 
 
  |   | 
  4 | 
  4/22/2005 | 
  Liz | 
  3533 | 
   $       
  725.00  | 
    | 
 
 
  |   | 
  5 | 
  4/22/2005 | 
  Dudee | 
  3534 | 
   $         
  80.00  | 
    | 
 
 
  |   | 
  6 | 
  4/30/2005 | 
  Jimmie | 
  3535 | 
   $         
  70.00  | 
    | 
 
 
  |   | 
  7 | 
  4/30/2005 | 
  Rodney | 
  3536 | 
   $       
  650.00  | 
    | 
 
 
  |   | 
  8 | 
  4/30/2005 | 
  George | 
  3537 | 
   $       
  400.00  | 
    | 
 
 
  |   | 
  9 | 
  April Checks Total | 
    | 
    | 
   $     2,625.00  | 
    | 
 
 
  |   | 
    | 
    | 
    | 
    | 
    | 
    | 
 
 
  |   | 
  10 | 
  05 checks | 
    | 
 
 
  |   | 
    | 
  date | 
  client | 
  number | 
  amount | 
    | 
 
 
  |   | 
    | 
  5/7/2005 | 
  Sarah | 
  3538 | 
   $       
  125.00  | 
    | 
 
 
  |   | 
    | 
  5/7/2005 | 
  Bill | 
  3539 | 
   $       
  100.00  | 
    | 
 
 
  |   | 
    | 
  5/15/2005 | 
  Vonie | 
  3540 | 
   $         
  75.00  | 
    | 
 
 
  |   | 
    | 
  5/15/2005 | 
  Vickie | 
  3541 | 
   $       
  400.00  | 
    | 
 
 
  |   | 
    | 
  5/22/2005 | 
  Liz | 
  3542 | 
   $       
  725.00  | 
    | 
 
 
  |   | 
    | 
  5/22/2005 | 
  Dudee | 
  3543 | 
   $         
  80.00  | 
    | 
 
 
  |   | 
    | 
  5/30/2005 | 
  Jimmie | 
  3544 | 
   $         
  70.00  | 
    | 
 
 
  |   | 
    | 
  5/30/2005 | 
  Rodney | 
  3545 | 
   $       
  650.00  | 
    | 
 
 
  |   | 
    | 
  5/30/2005 | 
  George | 
  3546 | 
   $       
  400.00  | 
    | 
 
 
  |   | 
    | 
  May Checks Total | 
    | 
    | 
   $     2,625.00  | 
    | 
 
 
  |   | 
    | 
    | 
    | 
 
 
  |   | 
    | 
    | 
 
 
 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   |