Menu Close

Excel Checkbook – Special Expanded 20-Register Version (2025)

A few customers have often shared that they have a lot of bank accounts — more than can be supported by the standard version of my Excel checkbook spreadsheet. I recently decided to create a mega-big version that supports up to 20 registers along with the optional Card Debt worksheet that can also chart your progress on credit cards you no longer use but plan to pay off. Most people don’t need this many register worksheets, and having to navigate among so many worksheets isn’t ideal which is why the standard version has a more modest number of 8 registers. But if you have a lot of checking, savings and credit cards that you like to track in one big spreadsheet, read on.

In a hurry and want the spreadsheet template right away? Click here. To see a brief video overview of the changes, click here.

System Requirements / Compatibility Notes: You must already have the Microsoft Excel program. This Excel template is compatible with Excel 2016 or higher (Windows). It is not compatible with Google sheets, LibreOffice, OpenOffice, or any other office clone. For Mac users, you will need Microsoft 365 in order for the dashboard to work as ‘power query’ is not available in older versions of Excel for the Mac. If needed, the latest version of Microsoft Office is available for $69.99/year (or $6.99/month), or as a one-time purchase (no subscription).
Tip to save money: Microsoft has a discount program that offers 30% off of Microsoft 365 for many employees, teachers and current/past military.

  • Manage up to 20 different bank accounts (checking, savings, credit cards)
  • Easily categorize each entry to track spending by category
  • See a visual reminder at the top of each register with current balance, future balance, and last check number entered
  • Enjoy two ways to reconcile your checkbook with your bank statement
  • Gain the ability to quickly post recurring transactions and deposits to your register with a single click
  • Track and visually graph your progress for paying down your credit card debt
  • View your spending with the revamped dashboard which displays charts for deposits & withdrawals by category and sub-category, with buttons to filter your data by year, month, register and/or category
  • View your spending with a text-based report, suitable for printing, which also features convenient buttons (slicers) to filter your transactions by year, register, and category
  • To accelerate data entry, there are convenient drop-downs for Date, Trx Type, as well as a drop-down list of frequent Payee/Descriptions which will also auto-populate your preferred category when chosen
  • The Future Transactions feature, for quickly posting recurring entries, has been enhanced with grouping. You can now designate a group letter (A, B, C or D) for your recurring entries so that you can designate that only a certain group of entries is posted when you click the button.

You can record transactions for 20 different bank accounts. Those can be any combination of checking, savings and/or credit card accounts — anything that has transactions with dates and dollar amounts.

Post Future Transactions with a One-Click Button

This feature is available and unchanged in this special version. It makes it super quick to post your recurring transactions into your checkbook with a single button click. In other words, you can create a list of expenses that you have every month, and when you want to paste them into your register, you can click a button and all of them will get entered! These can also be separated into groups, in case you only want to post a subset early in the month and a different set when it’s later in the month. Note: a VBA macro is embedded in the template for this feature. Learn more about macros.

Why is this handy? I like to keep an eye on my bottom line. How much money will I have at the end of the month before I get paid again? By putting in those future expenses, it helps me see how much money I’ll likely have later in the month.

Enhanced to support all 20 registers! If you need to reconcile your transactions against your monthly bank statement, there are two different features to make that task easy. The first feature will show you the total dollar amount of withdrawals, deposits and checks that you have already entered into your spreadsheet for the date range specified. This is often all that is needed to confirm you have everything entered correctly.

When needed, you can also review each transaction against your monthly bank statement. As you mark each one with an “R”, the screen will subtract each amount from the totals displayed.

Enhanced to support all 20 registers, the financial dashboard consolidates all of your bank accounts to a single dashboard. There are filter buttons to easily focus in on a particular year, month, category and/or to focus on a specific bank account. Note: a VBA macro is embedded in the template for this feature. Learn more about macros.

Enhanced to support all 20 registers, there’s a text-based report available with filter buttons to see expenses and credits by year, month, category and by a specific bank account.

If you have personal loans or credit cards you have stopped using but you’d like to visually track your progress on paying them off, this sheet makes it easy to update your card balances each month in order to visually track your efforts and help to motivate your progress. This is something you might do instead of using one of the register sheets to record transactions of rarely used credit cards.

Click the purchase button for instant download

 by Cheryl Iverson on Excel Checkbook Register (2025 Version)
Not a nice to have, a MUST have!

As a now former Quicken user, who hated the $72/year fee they charge for the privilege of getting an app for mobility, I wish there were 10 stars instead of 5 for this software - it's well deserved. I've been trying out various alternatives and have never found anything sufficient for my needs. Until now! This software is so well thought out. It does everything I need in a register without being bloated. Nice interface, and I am extremely impressed with how much documentation and how-to videos there are behind the software. WAY beyond what you expect for software in this category. The software reflects how important customer satisfaction is. Customer Support is beyond belief. I have only just bought it and already, I'm excited to push DEL on my Quicken software. This gets HUGE thumbs up for flexibility and reliability as well as over the top customer support. You won't be sorry you bought it. I've never written this glowing of a review before (and I've written many) - it's worth every penny.

Thank you Cheryl! You made my day!

 by Daniel Saragosa on Excel Checkbook Register (2025 Version)

Thanks

If I could reach through this internet connection I’d kiss you right on the lips! I have been looking desperately for an easy to use checkbook program for a small group that wouldn’t break the bank AND that a novice Excel user could relate to. I did try to get fancy one time and wiped out part of my page, but with a small nudge from my Excel expert kids, everything is now back to rights.

I absolutely recommend this product, especially for those old folks like me that need an easy to use, but very useful, checking accounting program. 5 Stars!

I recently purchased your spreadsheet Excel Checkbook 2025 Version. Can't tell you how pleased I am with the product. It works GREAT for me and I like it waaaay more than Quicken. I am a Rideshare/Gig worker so I can keep track of my work easily and keep track of my checking accounts and other investments. Just wanted to say thank you for your product.

A Great Checkbook

I have successfully, finally, downloaded the 2025 new version. Any problems I had in downloading were of my own doing! This checkbook has been an answer to my prayers! I have not used it for my personal checkbook; however, and planning to do so this year. The new version is for a very small foundation that doesn’t need all the bells and whistles that every other option I checked has. It is just what I need. Thanks for your kind, patient help!

Page 1 of 4:
«
 
 
1
2
3
4
 
»
 

Video Walk-through (watch on YouTube site)

A note about macros / security warning / how to fix

Since this new version is a macro-enabled file, if you use Microsoft Windows, please see this article for steps to follow.


How to Transfer (Copy) Your Transactions from an Old Version to the New Version

Please see see this video which will demonstrate how to safely copy your bank transactions from any previous version to the latest version.

Submit your review
1
2
3
4
5
Submit
     
Cancel

Create your own review

A Better Excel Checkbook Register (2024 Version)
Average rating:  
 0 reviews

2 Comments

    • Logan

      Hi Barbara, I absolutely recommend using OneDrive or Dropbox or any other cloud storage service as a backup protection. The file can definitely be stored there, and you can copy the file.
      Since you just purchased the expanded 20-register version, I apologize as I was hoping to get it updated with all of the new April 2025 features before anyone bought it again. I’ll be working on that today.

Comments are closed.