Balance/Check Register Excel Template

Balance Tracking Tool: Download

View other templates here: Excel Templates

This template does not contain macros/VBA code.

Directions:

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).

lbt

Advertisements

Leave a Reply

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

WordPress.com Logo

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

Google photo

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

Twitter picture

You are commenting using your Twitter 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.

%d bloggers like this: