Bank Reconciliation Excel Format {XLX 2007}

Need to reconcile banking financial details monthly or daily basis? So here are some professional template in MS excel 2007 format. You can simple download the XLX editable file and use it for own requirement. Each company staff must prepare this document for keep tracking any outstanding checks according to particular date and time for maintain their balance sheet.

What necessary things are required for this document? When to use this sheet? As an accountant you must take care of it. Some basics are required to fulfill empty area of reconciliation statement. Bank NO with particular Account NO adds in header of template with Date. Then comes to body section, in which “PER Bank” regarding Balance 11/30/xx with receipts, disbursements and balance date enter. Now comes to 2nd row of template.


In which “ADD” Deposits in transit, deducted amount, any outstanding checks with monthly description like “OCTOBER” “NOVEMBER”

Checklist of BRS Format 2007

  • Deposits in Transit
  • Deduct
  • Outstanding Checks
  • Other Items (Bank Charges not recorded)
  • Per Book
  • Prepared By
  • Date

So this template is only editable in Excel 2007 format, make sure before download this particular type of template, you can also add you bank logo, tag line and other important note in the footer of template for showing authorized paper.

Cas Dave

Leave a Reply

Your email address will not be published. Required fields are marked *