How to Create a Simple Checkbook Register With Microsoft Excel

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

References

• Microsoft Office: Quick Start: Format a Worksheet
• Microsoft Office: Format a Date the Way You Want
• Microsoft Office: Format Numbers as Currency
• Microsoft Office: Examples of Commonly Used Formulas
• Microsoft Office: The IF Function: What It Is and How To Use It

Show More