An Excel checkbook register eliminates some of the stress involved in managing a checking account. It does some of the math for you, which makes it for many people a handy and useful tool. Although you could download a check register template from the Microsoft Office website, creating one from scratch isn’t difficult. To build a simple register that calculates your checking account balance automatically, you need only a basic structure, some formatting and a few formulas.
Create the Basic Structure
Format the Register
Add a Balance Calculation Formula
Use the Register
Based in Green Bay, Wisc., Jackie Lohrey has been writing professionally since 2009. In addition to writing web content and training manuals for small business clients and nonprofit organizations, including ERA Realtors and the Bay Area Humane Society, Lohrey also works as a finance data analyst for a global business outsourcing company.