Georges Excel Checkbook Register v7.0
Georges Excel Checkbook Register v7.0
Excel checkbook register with categories, account reconciliation, and spending reports to manage your money in Microsoft Excel. Track up to 10 of your personal financial accounts in the registers whether they are bank accounts, credit card accounts, savings accounts or other financial accounts. Start tracking your money and spending so you can take control of your finances, know where your money is going, cut expenses, and save money for your future.
Checkbook Features: (watch video below for overview)
In each Excel checkbook register template, using the category field, you can tag your financial transactions with a spending category such as groceries, restaurants or gas or an income category such as salary or bonus. Once you assign a spending category or income category to a transaction, you can use the Excel filter to get a subtotal of how much money you spent in a particular spending category or how much you made in an income category such as your job salary in that particular Excel account register. In the Excel checkbook spreadsheet, you can use the Excel filter and get amount subtotals based on category, date periods (such as this month, last month, this year, last year, specific days, or quarters of the year), by description such as Walmart (payee), by amounts, and specific financial accounts.
A great new feature of Georges Excel Checkbook Register v7 is a new consolidated register that combines the other 10 individual account registers into one register in one worksheet so you can search and filter through all transactions from the 10 different account registers in one location. This combined master register is automatically created as you enter transactions in one of the 10 separate accounts/registers. Using the Excel filter in this consolidated register, you can get the total spending in a particular category based on all 10 financial accounts. Before this new version of the Georges Excel Checkbook Register v7, you could only get the total spending in a particular category from a single register at a time. Now with the combined register, you can get the spending total of all transactions from all registers for a specific category. So in the combined register, you can use the filter to get an expense report subtotal of how much was spent on groceries in all 10 accounts or you could even also choose specific accounts to get a spending amount in a particular category whether that is an expense category or income category.
In addition to the 10 accounts / registers to track your personal finances, there is a separate single consolidated register that contains all transactions from all the other 10 registers/accounts. Using this consolidated register, you can use the Excel filters to search through and filter data from all transactions in a single register. For example, if you use several credit cards to purchase groceries, you can use the consolidated register to search and filter the Category column by groceries and see a filtered list of all groceries transactions from all accounts in one place and get a subtotal of your grocery spending. You can further filter by date, description, all other register columns. You can also filter by specific accounts (in any combination) or filter by all financial accounts.
New Feature: The checkbook software with categories, now has a new worksheet that has PivotTable reports to help you visually see your income vs spending. Using the custom Excel PivotTable, you can create weekly spending reports, biweekly spending reports, monthly spending reports, quarterly spending reports, and yearly spending reports. The custom Excel Pivot table can also be used to create weekly income versus expense reports, biweekly income versus expense reports, monthly income versus expense reports, quarterly income versus expense reports, and yearly income versus expense reports. The income vs expense reports are also known as the Income Statement reports. You can also track all inflows vs outflows from your financial accounts. The PivotTable reports can be across multiple periods of time such as multiyear years to compare income and spending from year to year, compare month to month, every two weeks, or weekly comparison reports. Using this information of the checkbook software with spending reports, you can better track your personal finances and start saving money.
Another great feature of the Excel checkbook register template is that the worksheet that the Excel Pivot Table designed in is not locked (not password protected) like all the other worksheets in the checkbook software. This allows you to create the custom PivotTables and custom PivotCharts that meet your personal financial situation such as those wanting to track their finances on a weekly basis vs monthly basis.
The default Excel PivotTable also has a timeline connected to the PivotTable, so you can easily filter through and display specific time periods with just one click or a few mouse clicks. The PivotTable timeline allows you to filter PivotTable data visually and interactively, thus saving you time in designing your desired PivotTable layout.
The default PivotTable has a slicer connected to the PivotTable based on the Category Type field so you can easily filter based on the main category types which are income, expense, not categorized, deferred compensation, and transfers and payments.
The PivotTable fields can be fully customized by you to meet your desired layout based on your financial needs. The default custom Pivot table layout will display the following pivotable fields: account name field, date field, years field (via grouping), category type field, category field, and sum of amount field.
The Excel checkbook software with categories, you can create an Excel PivotTable based of the combined checkbook registers to get more detailed spending reports, expense reports and income reports. With Excel PivotTables, you can quickly summarize a large amount of data (in this case, transactions from your financial accounts that are in the Excel checkbook registers or Excel credit card registers) and create financial reports and charts (PivotCharts).
New feature: The checkbook software with spending reports now has a dedicated Excel worksheet for adding, editing, and deleting your own categories whether they are income categories or expense categories. This makes it easier to enter your transactions in the Excel checkbook register templates because you can now select a category from a dropdown list when choosing a category to assign to your transactions.
Also, the checkbook software will include the ability to add Excel comments to any editable cell in the checkbook registers (excluding the combined register). So in additional entering the details of a financial transaction in the registers such as the date, description, category and amount, you will be able to add separate Excel comments that can contain additional information that can be viewed when hovering over the cell with your mouse.
These new Excel checkbook template features have been added to the checkbook software based on customer feedback of users of the Excel checkbook software and based on checkbook software reviews with the goal of making this product the best checkbook software with categories and spending reports.
Using the Excel checkbook software with account reconciliation in Excel is made easy with the use simple to see green checkbook marks to mark a transaction as cleared and totals at the top of each checkbook register show you the total amount outstanding, the register balance, and the total cleared amount, thus helping to keep your personal financial accounts organized. Also, if you reconcile your bank accounts, the Account Summary worksheet show a reconciliation summary for each account in one worksheet. So if you are trying to determine how to reconcile your checking account, balance your checkbook, or how to reconcile your credit card account, the checkbook software with categories and spending reports helps simplify the financial account reconciliation process where you reconcile your accounts based off your monthly bank statements or based off your latest online banking information. Monthly bank statement reconciliation is simplified using the Excel checkbook software, thus helping you manage your personal financial information.
Bills are usually monthly bills, but sometimes they are due quarterly and even yearly such as property taxes. Manage in your money in Excel using this simple checkbook software with spending categories, reports and reconciliation so that you will be prepared to pay your bills and other expenses by knowing how much money you have to spend in your checkbook.
Microsoft Excel macros are used to simplify using the checkbook software, thus saving you time managing your money in Excel and help making this Excel template on of BuyExcelTemplates.com best selling checkbook software templates.
The Excel checkbook register template is delivered by digital download after purchased so you can start to use the checkbook software right away. There are online support articles and YouTube videos that help show you how to use the Excel checkbook software with categories.
- PC (Microsoft Windows computer) with Excel for Microsoft 365 (previously called Excel for Office 365) (part of Office 365 subscription / Microsoft 365 subscription) or Microsoft Excel 2021
- Mac Computer with Excel for Microsoft 365 for Mac (Excel for Office 365 for Mac) (part of Office 365 subscription / Microsoft 365 subscription) or Microsoft Excel 2021 for Mac. You need to have one of these specific versions of Microsoft Excel for Mac. Not compatible with Apple iphone or Apple iPAD.
- Supported in the United States, Canada, and Australia as amounts are formatted with the $ symbol. The Date field in the Excel checkbook registers are formatted as MM/DD/YYYY.
- The Excel checkbook register template is not compatible with Google Sheets (Google Spreadsheets) as the Excel file contains custom Excel VBA macros and Excel functions and Excel formulas not compatible with Google sheets.
- The Excel checkbook spreadsheet is not compatible with Apple Numbers spreadsheets.
- The Excel checkbook register template is not compatible with Microsoft's free "Excel Online" app that is part of the free Office Online apps. These online apps are web browser based and have limited features compared to the full desktop version of Microsoft Excel.
- The Excel checkbook spreadsheet template is not compatible with the Excel Mobile app whether using Android or iphone. (Excel mobile app is part of Microsoft Office Mobile apps that allow you to use a feature reduced version of Excel on your compatible mobile phone and smaller tablet devices to review, update, and create spreadsheets). The Excel template requires one of the full desktop versions of Excel listed above under the system requirements.
- The PC Windows computer or Mac computer should have minimum 3 GHz processor, 8 GB RAM and SSD storage.
- Your PC Windows computer with Microsoft Windows 11, Windows 10, Windows 8, Windows 7 or Apple Mac Computer running a particular version of the Apple macOS operating system needs to be compatible with one of the listed compatible versions of Microsoft Excel and meet the other system requirements.
- If you may be looking for checkbook app for Windows 11, checkbook software for Windows 10, checkbook software for PC, or Excel checkbook software for macOS, compare this best selling checkbook software with categories and account reconciliation in Excel to other top selling checkbook apps online.
- Install the 64 bit version of Excel and the 64 bit version of your operation system for best performance (vs the 32 bit version). The 64 bit versions are installed by default.
License Terms and Refund Policy:
By purchasing you agree with the License Terms / Terms of Sale.
By purchasing you agree with the refund policy.
Excel is a registered trademark of Microsoft Corporation.
Video: Excel Checkbook Template with Reconciliation
This checkbook register spreadsheet has simplified my personal financial recordkeeping. It's super easy to use, and any questions that come up have been quickly and thoroughly answered. I recommend this highly, it's worth many times the asking price.
Thank you for the awesome review!
Initially a little tricky to navigate, once you get it, it's really easy and streamlined to use. Only wish you could show transfers between accounts, but given how wonderful everything else works, I highly recommend it...
Thank you for your feedback and positive review! You can enter transactions for transfers between accounts and view all of the transfers in one location using the filters within the master register (automatically combined transactions from all accounts/registers) and in summary using the custom Excel Pivot Table reports.
I bought Georges Excel Checkbook Register v7.0 about 6 weeks ago and wanted to use it a while before reviewing. I'd been using Quicken for quite a few years and was tired of the constant renewal costs. As well, I don't need a lot of features, just a solid checkbook and good reporting for yearend tax purposes, which is why I didn't look at the versions with specific budgeting ability. I have been looking for a while for a Quicken replacement, and I'm glad I found this.
The app is well thought-out and executed; it works perfectly and I'm very happy with it. It's exactly what I was looking for. I'm a long-time (light) Excel user and don't really have the time or expertise to develop anything as comprehensive and useful as this. But George has done that, so it's well worth the small cost for an app that works so good.
Because I started the register a few months into the year, I back-filled my earlier register items for the year by importing them. I did set up a few categories that I needed and the app makes that easy.
All in all, I highly recommend it!
We initially purchased the checkbook register to keep track of one of farm business accounts. It's very simple to use and has all the features we need. We are actually purchasing another license for the checkbook spreadsheet to use with our other/smaller farm account.