There are three editions of the Excel Checkbook Register available for download.
| New 2024 Version (link) | 2023 Version (link) | Basic Version (link) |
|---|---|---|
| Support for 6 bank accounts | Support for 4 bank accounts | Support for 2 bank accounts |
| Customizable categories list | Customizable categories list | Customizable categories list |
| Robust dashboard with buttons to filter transactions by year, month, register, and category | Basic dashboard | No dashboard or charts |
| Has several Excel macros to enhance functionality which includes a macro to post future transactions with 1-click* | Two versions are provided. One version has a single macro and the other version is macro-free* | No macro* |
| Worksheet to track progress of paying off credit cards (up to 12 cards/loans) | Worksheet to track progress of paying off credit cards (up to 8 cards/loans) | |
| One-click button to post recurring transactions to your register | ||
| Reconciliation features to assist with monthly bank statement reconcile | ||
| (On sale! See the discount offer!) |
See the testimonials and comments I have received from real people who are using these checkbook templates.
*What are macros and why should you care? Macros are small bits of programming that can automate repetitive functions. Excel macros are typically written in visual basic (VBA), and over the years, some hackers have taken advantage of the power of VBA to add malicious code to Excel or Word documents. This is why Microsoft will warn you when a document or Excel file has macros. I avoided the use of Excel macros for a long time due to these valid concerns, but eventually I added some simple macros to my checkbook template because macros can add awesome functionality. The macro programming in my Excel checkbook templates is safe and harmless. I value the trust that you place in me when you become a customer and I never want to do anything that is harmful or manipulative.
And as part of being fully transparent with you my customer, I have a link to a screenshot of the macro code in the ‘2024’ version of my spreadsheet. While it might be a bit cryptic to read, it truly is harmless code.