How to Create a Simple Checkbook Register With Microsoft Excel

••• Jupiterimages/Stockbyte/Getty Images

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