Multiple bank accounts are often held by individuals due to banks having competitive interest rates, account balance minimums and other account features. Effectively managing your multiple bank accounts is easy if you have the right tools. If you have had your bank accounts for a long time, you can apply the steps below as of a starting date rather than when the account was first opened. Simply pick your starting point as the time the bank account was last reconciled, which is usually the end of the prior month.
Choose one of your bank accounts. Create a new file for the account. Identify the account by its account number. Using the last statement received to record the opening balance.
Record all transactions for the bank statement period including deposits, checks written, bank fees and interest earned. Each transaction should, at a minimum, include a date, payee and the amount.
Add as much detail to each transaction as desired. For deposits, include the source of the deposit. For checks, include the type of payment, such as a credit card, mortgage or doctor visit in addition to any applicable memos. For bank fees, include the reason the fee was incurred in the memo section. For interest earned, include the period the interest applies to.
Create new files for your other bank accounts. Identify the accounts with their specific account numbers. Record all transactions as you did for the previous account.
Download transactions, if possible, from your bank accounts. Banks offering online banking will generally allow you to download transactions into your software. This is useful if you want to capture many transactions and do not want to enter each transaction for each account individually. Alternatively, you can set up each bank account by manually entering the information and then downloading the transactions each month.
Create reports that analyze spending and savings at regular time intervals. One benefit to money management software is that reports are created easily and can be customized. If you customize a report, you can save the parameters to use again at a later date. Reports will assist you in managing the activity in all or some of your accounts.
Tips
If you do not have money management software available to you, you can create a spreadsheet in Microsoft Excel or another spreadsheet program. Include the same information for each transaction. Create a different spreadsheet for each bank account.
References
- Free Money Management Software
- Northwestern Mutual. "Here's the Difference Between Banks, Credit Unions and Brokerages." Accessed April 6, 2020.
- Federal Deposit Insurance Corporation. "FDIC Community Banking Study," Page 1. Accessed April 6, 2020.
- Federal Deposit Insurance Corporation. "Learning Bank - Checking & Savings Accounts." Accessed April 6, 2020.
- Federal Deposit Insurance Corporation. "Five Things to Know About Safe Deposit Boxes, Home Safes and Your Valuables." Accessed April 6, 2020.
- U.S. Bank. "U.S. Bank Mobile App." Accessed April 6, 2020.
- Bank of America. "Bank Account Rates & Fees FAQs." Accessed April 6, 2020.
- American Express Company. "APY vs. APR: The Basics About How Interest Is Calculated." Accessed April 6, 2020.
- The Federal Reserve. "Regulation D1 Reserve Requirements," Page 1. Accessed April 6, 2020.
- Wells Fargo. "Debit Card Questions." Accessed April 6, 2020.
- Investor.gov. "Certificates of Deposit (CDs)." Accessed April 6, 2020.
- Ally. "6 Ways to Avoid Checking Account Fees." Accessed April 6, 2020.
- PNC Bank. "PNC Virtual Wallet Features and Fees," Page 1. Accessed April 6, 2020.
- Bank of Alma. "Checking With Choices." Accessed April 6, 2020.
- HelpWithMyBank.gov. "Answers About Funds Availability: I Opened a New Checking Account, but the Bank Will Not Let Me Withdraw My Funds Immediately." Accessed April 6, 2020.
- ChexSystems. "Frequently Asked Questions (FAQ's)." Accessed April 6, 2020.
- ChexSystems. "Common Mistakes to Avoid." Accessed April 6, 2020.
- Experian. "Why Was I Denied a Checking Account?" Accessed April 6, 2020.
- Consumer Financial Protection Bureau. "Helping Consumers Who Have Been Denied Checking Accounts," Page 2. Accessed April 6, 2020.
Tips
- If you do not have money management software available to you, you can create a spreadsheet in Microsoft Excel or another spreadsheet program. Include the same information for each transaction. Create a different spreadsheet for each bank account.
Writer Bio
Jessica Kent started writing professionally in 2002. Her articles have appeared in publications including the New York State Bar Association's "Family Law Review," "Valuation Strategies" and "Metropolitan Corporate Counsel." Through her writing, she strives to assist people in making informed financial decisions. She is a Certified Public Accountant in New York. Kent holds a Bachelor of Science in accounting from Binghamton University.