Spreadsheet - Tracking Bank Account Balances

(Note: This blog is intended to be read from the first post to the last post. You can find the first post here.)
 

 Introduction

The  instructions for the expenses portion of the spreadsheet are in the previous post. This portion will explain using the spreadsheet to track bank account balances. It will track up to four accounts.

 

Spreadsheet

The program will track balances for up to four accounts. It's only as accurate as the data entered, so check your account balances carefully.

1. At the beginning of the month, enter the end of month balances for all your accounts in the dark green cells. Be sure to adjust the balances for any outstanding checks.
2. Rollovers are the amount from each account you plan to spend each month.
3. Follow the example for deposits and withdrawals. If transferring money from one account to another, enter a withdrawal and a deposit. Withdrawals must be entered as a negative amount.
   
   When making a deposit or withdrawal enter the bank account number in the Act column.
   
   Note: Deposits and withdrawals will be added or subtracted from the starting balance.
4. Enter your expected paychecks for the month. When they are actually received put the account number in the right column.

When you spend money during the month, enter the account number in the blue act column.

 Summary

After you complete the expenses section and the bank account section, the summary box in the upper left hand corner of the spreadsheet will have the income/deposits, planned expenses, the surplus/deficit, additions to savings envelopes and the total surplus/deficit. You do not need to make any entries in this section.

 

Conclusion

This completes the instructions for the budgeting tab of the spreadsheet.  So far, everything in the spreadsheet seems to be working properly. If you have any questions or find any errors, please email me at gershon_ben_franja@yahoo.com. Put Frugal Budgeter in the subject so I know the email isn't spam.