Docstoc

Bank Account Template - Excel

Document Sample
Bank Account Template - Excel Powered By Docstoc
					Company Name:                                           Bank Name(s):
Period End:                                             Bank Account(s):
                                                        G/L Account(s):




Adjust cash account in general ledger (Section 1)
Balance per cash account in general ledger

 Adjustments to cash account (based on bank statement):
           Add:                   Bank interest
                                  Credit / wire transfers
           Subtract:              Bank charges
                                  Standing orders
                                  Direct debits / ACH
                                  Dishonoured checks
           Add/Subtract:          Errors
Adjusted cash account in general ledger                                              -


Adjust balance on bank statement (Section 2)
Balance per bank statement

 Adjustments to bank statement balance (based on accounting records):
           Add:                  Deposits in transit
           Subtract:             Checks issued, but have not cleared bank
           Add/Subtract:         Bank errors
Adjusted balance per bank statement                                                  -


Compare adjusted balances (Section 3)
Adjusted cash account in general ledger                                              -
Adjusted balance per bank statement                                                  -
Difference                                                                           -


Reconciling items
           Item a – short description
           Item b – short description
           Item c – short description
           Add more reconciling item descriptions here
           …
           …
           …
Total reconciling items (= Difference)                                               -


           You need to fill the cell
           The cell contains the formula

Best Practice: Keep (attach) supporting documentation to this reconciliation.


Prepared by:                                             Date:

Approved by:                                             Date:




                                                                                http://simplestudies.com

				
DOCUMENT INFO
Description: Bank Account Template document sample