Balance/Check Register

Balance Tracking Tool: Download

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

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

%d bloggers like this: