Excel Checkbook Register – Small Business Edition

Building on years of work, I’m pleased to release an Excel Checkbook Register template that is targeted for small business and can be suitable as a Quickbooks replacement if your needs are not complicated.

In a hurry and want the spreadsheet template right away? Click here.

System Requirements / Compatibility Notes: You must already have the Microsoft Excel program on a Mac or Windows PC. This Excel template is compatible with Excel 2019 or higher (Windows). It is not compatible with the free Excel online (web) version, nor Google sheets, LibreOffice, OpenOffice, or any other office clone. For Mac users, you will need Microsoft 2021 or newer 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 $99.99/year (or $9.99/month) with the first month free, 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.

A favorite computer magazine website of mine offers Microsoft Office 2021 (lifetime license) for a great price, if needed!

Summary of Features of Excel Checkbook for Small Business

• Manage up to 15 different bank accounts (checking, savings, credit cards)
• Easily categorize each entry to track spending by category
• Easily specify which business the transaction is for if you use one bank account for multiple businesses
• See a visual reminder at the top of each register with current balance, future balance, and last check number entered
• Easily reconcile your checkbook with your bank statements
• Gain the ability to quickly post recurring transactions and deposits to your register with a single click
• View your spending with a 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, category, and business
• View a profit & loss statement with filter buttons to choose a specific year and/or business
• Accelerate data entry with convenient drop-downs for Date, Trx Type, as well as a drop-down list of frequent Payee/Descriptions which will auto-populate your preferred category when chosen
• Enter recurring future transactions quickly
• Split a transaction across multiple categories for better tracking of spending, especially helpful for large expenses and/or when a transaction should be split across your different businesses
• Enter a transfer transaction (e.g., a withdrawal from checking which deposits to savings) as a single entry to save time.

Up to 15 Registers

You can record transactions for fifteen 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! 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.

Split a Transaction

For larger expenses or deposits, you can click a button to split out the amounts into different categories for more accurate tracking of your expenses.

Enter a Transfer Between Two Accounts

If you often move money between two accounts (e.g., from a checking account to a savings account), this feature accelerates the data entry so that you only have to enter one entry and it will create the corresponding entry in the other account.

Reconcile Transactions

If you need to reconcile your transactions against your monthly bank statement, it’s easy to do so. Clicking the button at the top of the register (Reconcile Details) will open a panel of rows where you’ll enter your bank statement’s end date and ending balance. You can review each transaction and mark each one as reconciled, and the screen will keep you updated on how many withdrawals and deposits have not yet cleared.

Note: this uses the checkbox feature that is only available in Microsoft 365. However, older versions of Excel will work just fine by putting a single letter (e.g., R, or c, or X) to mark each entry.

Financial Dashboard

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 and/or a specific business. Note: a VBA macro is embedded in the template for this feature. Learn more about macros.

Financial Report/Statement

View a text-based report with filter buttons to see expenses and credits by year, month, category, bank account, and a specific business.

Profit & Loss Statement (P&L)

Easily view a profit and loss statement with options to see it by year, month and per small business.

Demonstration Video

• View this walk-through video on how to use the checkbook spreadsheet.
• Note: the reconcile feature was updated in April, 2026. See this video.

Click the purchase button to download

$39.95 – Purchase Click to Checkout Added to cart