Checking Account Balance Alerts

Applies to Excel template: "Georges Budget for Excel v20",

(back to All Support Topics)

 

Set up checking account balance alerts to visually alert you to a low balance in the checkbook software register balance in one of your bank accounts such as your checking or savings accounts.

How to set up account balance alerts:

In the budget spreadsheet or checkbook software (only available in specific versions), in the Account Summary, click the button "Set Balance Alerts", which will take you to the "Register Balance Alerts" worksheet. The "Register Balance Alerts" sheet will automatically create a list of all your accounts that you added in the Accounts Summary worksheet. All you have to do in the "Register Balance Alerts" worksheet, is put a Yes or No next to the alert that you want to visually be displayed in the checkbook app and the amount that you want these indicators to be displayed if your register balance falls below that amount.

In the checkbook software, you can set up to two different account balance alerts:

An alert that will shade the Running Balance amounts a different cell shade if the running balance amount falls below the low balance amount that you set.

An alert that will put a red indicator flag next to the "Register Balance" in the Account Summary and the "Register Balance" at the top of an register when the "Register Balance" falls below the low balance amount that you set.

You can set the alert to show for one or both of the different alert types.

Benefits of Account Balance Alerts:

One of the main benefits of the checkbook spreadsheet low balance alert is to alert you that you only have a specific amount of money left in your account and that it may be time to deposit more cash so that you do not overdraw your account and incur bank fees and so that you have sufficient funds to make future purchases, bill pays, checks, and withdraws. These account balance alerts can be set up for both personal checking accounts and business checking accounts.

Please note that the budget spreadsheet and checkbook app alerts are different from the financial bank account alerts that you may set up for your bank accounts using online banking or directly with your local bank. Those account alerts are more extensive and include alerts such as fraud alerts, balance alerts, transaction alerts, bank statement ready alerts, bill pay alerts and more. The low balance alerts that you might set up with your bank using online banking are tied to your online banking account balances and bank statements with are created and kept by your bank and are different from the account register balances that you keep track of in the checkbook software. For example your online checking account balance can be different from you checkbook register balance that you track in the checkbook software, so you can set up account balance alerts in both your online banking and in the checkbook app.

In addition to the low balance alerts for your checking and savings accounts in the checkbook software, see all accounts alerts that you can set up in your online banking.

 

(back to All Support Topics)