Balance/Check Register Excel Template

Balance Tracking Tool:

Download Here

View other templates here: Excel Templates

This template does not contain macros/VBA code.


Add a date, description, and choose a classification.

If the amount is a debit from the account, enter it in the red column. Do not add a negative to the number, just type the number it will automatically make any number added to the debit field a negative number. If the amount is a credit to the account, enter it in the green column.

It automatically calculates the balance and has a low balance warning indicator when the balance goes under $100. The D/C field gives you a quick indicator of debit or credit based on the color and provides a quick way to filter by debit or credit.

Contains 12 tabs, one for each month of the year. Final balance for a month is carried over to the next month (Assuming you don’t mess with the formulas because nothing is locked and it contains no VBA code, just Excel formulas).


1 reply »

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.