Balance Sheet Account Reconciliation Template

Looking for easy way to reconcile your account? Here in this post, I will discuss regarding balance sheet account reconciliation with compare to the general ledger.

Let’s start with some example of creating the financial statement.

Eliminate your accounting errors and remain stress-free with premium quality yet free. Generally, accountants keep track of the payments and they are frustrated to know if the balance differs in the company account while the balance varies in the customer book.

Appropriately you can keep your accounts books and balance sheet error-free with this sheet. Moreover ensuring you have recorded and represented each transaction in your business– and connected with the best resource available.

Your all bank transaction with salary sheet or other keeps it safe with this template.

Balance Sheet

Template Name:- Balance Sheet

File Name & Size:- 43KB

Type:- XLSX

Sort:- Blank

Accounts Reconciliation Formula

As a student and need some example for completing your reconciliation assignment then must keep this formula for completing any company financial statement and revenue management statement.

Balance per Bank Statements + Deposits in Transit – Outstanding Payments = Balance after Account Reconciliation

Do you know our accounting report records Assets and Liabilities and also Owner’s Equity? You are able to differentiate Resources and assets! Do you know about the components of the balance sheet? Your business may have weak areas, so it’s imperative to switch to excel template and leave manual recording practice!

Balance Sheet Account Reconciliation Template


Download this excel spreadsheet in a single click. Learn about it in more details by going through this blog post:

General information

Get started by filling up header section. It comprises of, date, account number, GL account number, account purpose, prepared by, received by and date for both of them here.

** GL stands for general ledger here!

Balance per sub-ledger or detail

Over with the header section, now start filling the body part of the template.

  • Enter adjustments to the sub-ledger and descriptions for all of the components.
  • Descriptions must be entered between cells C16-C21.check G22 for total with the formula =SUM(OFFSET(G22,-1,-1,MATCH(B15,B$1:B$105,0)-ROW()+1))
  • Now fill valid reconciling items in the cell F25, F26 & C27.
  • G30 shows the total balance with formula =SUM(OFFSET(G30,-1,,MATCH(B13,B$1:B$105,0)-ROW()))
  • Check the cell G32 for total with the formula =G30-N30


  • Now fill the final section of template. It comprises of Entry #, DR/CR, account #, account description, debit, and credit.
  • Fill all of the details on the table and your balance sheet is error free!

General Ledger Accounts Reconciliation Template

It’s very important to keep record and reconcile statement with general and ledger accounts. To maintain your financial statement with reconciliation you must require a platform for manage these things, so this Excel template will help you to compare your balance sheet statement at the end of month or year with general ledger.

General Ledger Template Excel

So using these steps before you can create own Balance Sheet Account Reconciliation Template, it’s little bit technical (Finance is always Technical subject).

In addition, so after downloading this template in excel you won’t need to find anything like formulas and checklist detail for resolving any company reconciliation statement with the balance sheet.

Leave a Reply

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