• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Download Checkbook Register Excel Template

Download Checkbook Register Excel Template

Checkbook Register Template is a ready-to-use template in Excel, Google Sheets, and OpenOffice Calc to track and reconcile your personal or business bank accounts.

Furthermore, this template helps you keep an eagle’s eye on your bank financials and avoid unnecessary charges in the form of interest or penalties.

Table of Contents

  • What Is A Checkbook Register?
  • Purpose of Maintaining A Checkbook Register
  • Checkbook Register Template
    • Content of Checkbook Register Template
  • Printable Checkbook Register
  • How To Balance A Checkbook Register?
  • Frequently Asked Questions

What Is A Checkbook Register?

A Checkbook register is a very useful document for keeping track of your Bank balances for personal and business accounts. In simple terms, it records all deposits and withdrawals for a given checking account and used for performing bank reconciliation.

The Checkbook Register is a crucial document to remain on top of your financials. It helps you to look where the money is coming/going from and how much is left with you.

Purpose of Maintaining A Checkbook Register

Many a time, it happens that bank officials commit some mistakes. If you maintain Checkbook Register, you can identify those errors and get them corrected.

Additionally, you can also prevent bouncing back of checks due to the unavailability of balance. Thus, avoiding unnecessary fees charged on your account.

Checkbook Register Template

We have created an easy to use Checkbook Register Excel Template with predefined formulas. Just insert your bank transaction daily and easily reconcile at the end of every month.

This template can be helpful to individuals, accounting professional,s, and students. You can use this template to keep a track of all your income and expenditures.

Checkbook Register

Excel Google Sheets Open Office Calc

Click here to Download All Accounting Excel Templates for ₹299.

Important Note: To edit and customize the Google Sheet, save the file on your Google Drive by using the “Make a Copy” option from the File menu.

Additionally, you can download other accounting templates like Accounts Payable Template with Aging, Accounts Receivable Template with Aging, and Cash Flow Template.

Content of Checkbook Register Template

This template consists of 2 worksheets: Datasheet and Checkbook Register

The Datasheet consists of lists of the type of transactions. This list is used for creating the dropdown menu in the Checkbook Register Template.

Checkbook Register

Checkbook Register

At the top, there is the heading of the sheet. Insert the following Account Information:

Type: Type of account like Checking, Current, Savings, Personal, etc.

Number: Number for the respective accounts.

Checkbook Register

From: Start date. The Formula given here is =A15, the first line of date column of the data input section.

To: End date. The Formula given here is =MAX(A15: A41), the last date of entry of the date column.

Insert opening and closing balances in the balance info section on the right side.

Checkbook Register

Opening: Opening balance of Bank and Cash as per the records.

Closing: Closing balance of Bank and Cash as per the records.

In addition to the above, it consists of the summary section. It displays all balances automatically as it contains predefined formulas.  Hence, you don’t need to input any data.

Checkbook Register

Opening Balance: This will reflect the opening balance from the Balance section.

Deposits: Total of Deposits column in the Data input section.

Withdrawal: Total of Withdrawals column in the data input section.

Closing Balance: This will reflect the closing balance from the Balance section. If the closing balance will not match the closing balance of the data input section it will show a remark “Incorrect balance” next to this column.

Checkbook Register

Reconciliation Amount: This will reflect the opening balance from the Balance section. To easily reconcile the entries you need to put “R” next to the entries. If the reconciliation of any entry pending, this section will display it in the outstanding column.

Current Balance: This cell will display the ending Balance of account as per the data entered by the user.

Difference: This cell displays the difference if any. If there is a difference then it will display a message “Check Statement” next to the amount. Otherwise, it will display “Balanced” next to the cell.

Checkbook Register

Checkbook Register

Checkbook Entry Section

In this section, the user needs to enter the transaction details as and when they occur during the period.

Checkbook Register

It contains the following column headings:

Date: Date of transaction

Transaction Type: Contains the Transaction types like deposits checks issued, checks receipt, ATM, NEFT, etc. You can select the type of transaction from the drop-down menu.

Trans. Ref: You can put any reference or check numbers in this column.

Description: Description of the payment or receipt

Withdrawals: All the withdrawal entries are to be entered in this column.

Deposits: All the deposit entries are to be entered in this column.

Balance: Balance will show you the balance after each transaction by adding or deducting the deposits and withdrawals.

Reconciliation: In this section, you need to enter “R” if you find the entries in the bank statement.

Balance and Outstanding: No entries are to be made. These cells are given predefined formulas. The balance column shows the end balance and the Outstanding column shows the non-reconciled entries.

Checkbook Register

Printable Checkbook Register

Checkbook Register Tem0plate

Click here to download the Printable version of the Checkbook Register.

Let’s discuss the template contents in detail.

How To Balance A Checkbook Register?

  • Find the current balances.
  • Record all inward and outward transactions.
  • Define the type of transaction and add a description to each transaction.
  • Reconcile and match transactions with your bank statements weekly, biweekly, fortnightly, or monthly.

We thank our readers for liking, sharing, and following us on different social media platforms, especially Facebook.

If you have any queries or questions, share them in the comments below. I will be more than happy to help you.

Frequently Asked Questions

What does it mean to balance your checkbook?

When you balance a checkbook, it means that all the transactions on your bank statement and your checkbook register match with each other.

How often should you balance your checkbook?

Usually, it is advisable to balance the checkbook every month. Balancing your checkbook depends on the frequency of transactions. You can do it weekly, fortnightly, or monthly as per your requirement.

What is the danger of not balancing your bank account?

When you don’t balance your checkbook regularly, it increases the risk of penalties and unnecessary charges by the bank. It also puts forth the risk of being overdrawn while your account has sufficient funds.

How to record Interest Earned as well as service charges in a checkbook register?

A bank levies service charges and provides interest depending on their account policy. Hence, you can record these charges at the time of the reconciliation of your checkbook register.

« Download Budget With Charts Excel Template
Download Purchase Order Excel Template »

Filed Under: Accounting Templates

You are Here: Home / Excel Templates / Accounting Templates / Download Checkbook Register Excel Template

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Accounting Templates

  • Accounts Payable Excel Template
  • Accounts Receivable Excel Template
  • Cash Book Excel Template
  • Invoice Excel Templates
  • Expense Report Excel Template
  • Petty Cash Book Excel Template
  • Inventory Management Excel Template
  • Billing Statement Excel Template
  • Purchase Return Book Excel Template
  • Accounts Payable With Aging Excel Template
  • Accounts Receivable With Aging Excel Template
  • Budget With Charts Excel Template
  • Checkbook Register Excel Template
  • Purchase Order Excel Template
  • Purchase Return Book With Tax Excel Template
  • Marketing Budget Excel Template
  • Asset Inventory Tracker Excel Template
  • Depreciation Calculator Excel Template

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • FAQ’s
  • Blog
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2022. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT