Are you like me and have always carried a check register from the bank to record all your debit transactions and checks written? Well, recently I decided to become a little more digital by using a check register in Excel on my smart phone and I am loving it! (This post may contain affiliate links. This means that if you purchase a product through a link we have here in the post, we may be compensated at no cost to you.)
Why I Decided To Use Excel for My Check Register
I am a big fan and user of the cash envelopes system (see here). However, most of us still use a debit card with our checking account even if we don’t write many checks. In my case, I wanted to separate a buffer amount in my checking account without using a separate manual register to record it. Angie has long been using Excel in a similar system on her computer, however, I needed a simpler version on my phone.
Since I have been using this new checking register, I have found these benefits to make my life easier:
- My check register is created in MS Excel and located in One Drive, so it can be accessed by my computer and phone. Any spreadsheet application should be sufficient, however, I like MS Excel.
- I have a link on my phone to access it directly.
- My extra sheets in Excel are like digital cash envelopes!
Financial Organization Benefits
My checking register is created from MS Excel free templates in Office (Checking Register with Transaction Codes). In Excel you can have multiple sheets which allowed me to add a ‘Buffer’ sheet. So, my Excel Checking Register allows me to separate out my money to fit my needs:
- Checking Register sheet: This sheet is my main check register. I add my debits, credits as usual. The Transaction Codes included in this particular template are editable. I added a few and removed a few. One of the Transaction Codes I added was for adding money to the Buffer and pulling money back from the Buffer
- Buffer sheet: Now I know I have been talking about a ‘Buffer’ sheet, so let me explain. I have always tried to keep money in my checking account that is not seen in my check register. This is my ‘buffer’ money. It gives me a cushion in case my checking account gets overdrawn for unforeseen reasons. I am able to handle the ‘overdrawn’ amount without involving the bank at all!
These are the only two sheets that I use at this time, however, there is potential for so many others! Some additional sheet ideas are:
- Christmas Budget
- Home Remodel Budget
- Car Insurance Budget
- Grocery Budget
- Car Maintenance Budget
The ideas are endless and can fit whatever need you have! Please share with us what you think about this system and if you have done anything similar!