There are four editions of the Excel Checkbook Register available for download. Regardless of the version you choose, you can safely use any version into the future. There are no date-related restrictions. Email support is included with all.
| Feature/Note | Small Business Version | 2026 Version for Home | 2025 Version for Home | 2024 Version for Home |
|---|---|---|---|---|
| Excel Version Required (Windows PC Users) | Excel 2021 or newer | Excel 2019 or newer, Microsoft 365 Recommended but not required | Excel 2019 or newer | Excel 2016 or newer |
| Excel Version Required (Mac Users) | Microsoft 365 | Microsoft 365 | Microsoft 365 | Microsoft 365 |
| Maximum number of bank accounts supported | 15 | 12 | 10 | 6 |
| Customizable categories to categorize income/expenses | ✔ | ✔ | ✔ | ✔ |
| Customizable sub-categories | ✔ | ✔ | ✔ | |
| Charts/Dashboard to visualize expenses by month/year/category | Robust dashboard with filtering by different business entity | Robust dashboard | Robust dashboard | Robust dashboard |
| Monthly bank statement reconciliation | ✔ | ✔ | ✔ | ✔ |
| Easily post recurring (future) transactions to help with budgeting for the month | ✔ | ✔ | ✔ | ✔ |
| Split a large transaction across multiple categories | ✔ | ✔ | ✔ | |
| Debt obligations worksheet | ✔ Enhanced with debt payoff calculator | ✔ | ✔ | |
| Automated feature to record transfer to/from another account | ✔ | ✔ | ✔ | |
| Dropdown list for easy date entry | ✔ | ✔ | ✔ | |
| Dropdown list for frequently used payees | ✔ | ✔ | ✔ | |
| Reporting screen for expenses/income | ✔ | ✔ | ✔ | |
| Profit & Loss Statement (P&L) | ✔ | |||
| Monthly Subscriptions Tracker | ✔ | |||
| Assets Worksheet with Net Worth Calculation | ✔ | |||
| Set Money Aside Feature | ✔ | |||
| Monthly payment calculator for debt obligations | ✔ | |||
| Support for multiple small businesses in the same bank account | ✔ | |||
| Requires Excel macros to be enabled | ✔ | ✔ | ✔ | ✔ |
| See discount offer on page | ||||
If you are looking for something very basic and simple, there’s also an older 2023 version and a very basic checkbook available here.
*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.
SAFETY NOTE: Your safety and peace of mind is important to me. You are encouraged to scan any downloaded file for malware. A terrific website that can scan a file is called Jotii.org (https://virusscan.jotti.org/). Their website will allow you to upload a file and have it scanned using over 12 different virus scanners. My checkbook template will be reported as clean (no viruses found).
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. NOTE: the macro code section is password protected to protect my intellectual property.