Menu Close

A Better Excel Checkbook Register (2024 Version)

I originally shared my Microsoft Excel Checkbook Register in 2019 as an alternative to Quicken. Since then, I have received lots of positive feedback on YouTube which has helped inspire ongoing enhancements.

Compatibility Note: this Excel template is compatible with Excel 2013 or higher (Mac and Windows). It is not compatible with Google sheets, Open Office or any other office clone. If needed, the latest version of Microsoft Office is available for $69.99/year (or $6.99/month). Microsoft still offers a one-time purchase version called Office Home and Student 2021, for $149.99.

  • (New for 2024!) Manage up to 6 different bank accounts
  • Easily categorize each entry to track spending by category
  • See a visual reminder at the top of each register with current balance and last check number entered
  • (New for 2024!) Enjoy two ways to reconcile your checkbook with your bank statement
  • Gain the ability to post recurring transactions 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 (New for 2024!) which displays charts for deposits/withdrawals by month or year, expenses by category and sub-category, and buttons to filter your data by year, month, register and/or category

You can record transactions for five (now six!) 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 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! Note: a VBA macro is embedded in the template for this feature. Learn more.

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.

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.

Totally revamped for 2024, the new 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 account. Note: a VBA macro is embedded in the template for this feature. Learn more.

If you would like to visually track your progress on paying off credit card balances or other personal loans on a single dashboard screen, this sheet makes it easy to update your card balances each month in order to visually track your efforts.

Click the purchase button to download

Why not free? I appreciate your support for the 100’s of hours of work that have gone into this Excel template. Note: VBA macros are included in the template. Learn more about the macros here.

Submit your review

Create your own review

A Better Excel Checkbook Register (2024 Version)
Average rating:  
 6 reviews
 by Carol King

Be sure you watch the video, maybe twice to make sure you understand it fully.
I think I messed up one of the registers, it isn't working correctly, but I still have the other 5! (I don't have formal training on Excel so I am sure I messed it up.)

I love this register. I am "old school" and kept a register for many years, but I like the convenience of using a laptop or my tablet. The many features are pure genius. I love the ability to put my monthly expenses into a future transaction sheet and just add them all at once.

I actually intended to use it with my iPad, but I can use it easier on my windows laptop.

I would definitely recommend.

 by Gerald
Great spreadsheet for home finances

The excel-checkbook is a great spreadsheet for handling your checkbook accounts and not like other programs, it is inexpensive!! One charge. No monthly fees!

 by Rusty Sims

This file has turned out to be a terrific resource. It incorporates a number of effective elements that taken together present a way to track and analyze all of my important financial data. It is both a detailed and complete template while also being easily personalized for maximum ease of use. Thanks again!

 by Lou Matarazzo

This is awesome! Why didn’t I know about this sooner!

 by Kristen D.
I can finally dump Quicken.

Thank you so much for your work on this. I can finally dump Quicken. I needed very few of the Quicken options, but the few I needed were hard to find. Plus my bank & Quicken really seem to struggle to communicate properly. Well worth the money.
I highly recommend A Better Excel Checkbook!!!

Page 1 of 2:

Video Walk-through

A note about macros / security warning / how to fix

Since this new version is a macro-enabled file, if you use Microsoft Windows, you’ll likely see a warning like this when you open it:

The link in the warning will take you to this Microsoft article which also has the steps on how to unblock it. In summary, you’ll need to:

  1. Close the file if you still have it opened.
  2. Open Windows File Explorer and go to the folder where you saved the file.
  3. Right-click the file and choose Properties from the context menu.
  4. At the bottom of the General tab, select the Unblock checkbox and select OK.

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

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


  1. Gerald Gruhn

    Using “A Better Excel Checkbook Register 2024”:
    1. Is there any way to run and print out reports?
    2. Are there any add-on excel sheets that run reports?
    3. What does the Data Analysis button do?

    • Logan

      Hello, thanks for reaching out. Regarding printing out reports, Quicken (as an example) does have a lot of great built-in reports. Excel, as a spreadsheet program, is awesome for storing data, sorting and filtering data, charting and visualizing data, but when it comes to reporting, it’s not ideal. You can print anything that you see in an Excel spreadsheet. And you can filter your transactions easily (e.g., show just grocery store transactions), and then you can print those sheets.

      Regarding data analysis, was that perhaps the Excel button for “Analyze Data”? That’s an Excel feature that looks for patterns in your data and it will suggest charts and/or pivot tables that it can help create.

  2. Gerald Gruhn

    Thank you for your prompt response to my initial questions! Now I have some new questions.

    I needed to update my Excel to a newer version. I found Office Suite and it said it was compatible with Microsoft Office. I bought “A Better Excel Checkbook Register 2024” and loaded it on Office Spread sheet, but things are different.

    1. Will your template work with Office Spread sheet?
    2. Do I need to use a newer version of Microsoft Excel?

    • Logan

      Hi Gerald, I’m not familiar with Office Suite. I did Google and find it, but I don’t know much about it. I’m skeptical that it will work, especially regarding the dashboard (charts) as that is reliant on some advanced functionality in Excel called power query.

      If you find it doesn’t work and you’d like a refund for my checkbook register, let me know.

      FYI, the latest version of Microsoft Office is available for $69.99/year. They still offer a one-time purchase version called Office Home and Student 2021, for $149.99

  3. Kristen Doris

    Thank you so much for your work on this. I can finally dump Quicken. I needed very few of the Quicken options, but the few I needed were hard to find. Plus my bank & Quicken really seem to struggle to communicate properly. Well worth the money.
    I highly recommend A Better Excel Checkbook!!!

    • Logan

      It is just a one time charge. The spreadsheet will work forever after download – no expiration.

  4. Bonnie Brighton

    I have pressed the download button and purchase but I don’t see how to continue to puarchase and download.

    • Logan

      After you click the blue “Purchase” button, it changes to say “CHECKOUT” and you’ll need to click that button to continue the checkout process.

    • Logan

      Hi, thanks for asking. There are 3 macros in the spreadsheet. One macro just does a “refresh all” command in the pivot tables; a second macro sits behind the “Reconcile mode on/off” button and it just toggles the visibility of rows 2-3 in the register; and the third macro sits behind the “Post Them” button on the Future Trx sheet. It’s the only complex macro in the spreadsheet. It looks at the transactions listed on the Future Trx sheet and copies/paste the entries to the designated worksheets.

Comments are closed.