Software > Digital Downloads > Movers & Shakers > Personal Finance



Price: $9.95

(as of 2016-07-03 18:44:33 PST)

Available Now

Personal Finance

Rating: 1.0 / 5.0 (1 votes)

Released: 2016-04-01


Georges Excel Checkbook Register v3 – Checkbook Software for Excel – Checkbook Template Spreadsheet for Checking Accounts and Credit Card Accounts – Requires Microsoft Excel 2007 or higher [Download] by George Alzamora

Software Details

Brand: George AlzamoraMedia: DownloadHardware Platform: PCOperating System: Windows 10
Check All OffersAdd to Wish ListCustomer Reviews

Description

Bank account reconciliation is simplified since the checkbook software allows you to mark reconciled transactions (cleared transactions) which will then display a green checkmark indicator next to them to easily identify them. The top of each Excel checkbook register displays key amounts used in account reconciliation including totals for Total Outstanding, Total Cleared and Register Balance. These amounts will help reconcile your accounts along with viewing the transactions and amounts in your bank account statements, credit card statements, or viewing online banking and comparing the bank statements against the Excel checkbook registers.

The Excel checkbook registers have columns to record the details of each transaction including the date of transaction, check number, description of the transaction, a memo field, a field to mark an item as reconciled, an optional category field, and an amount field.

Use the optional Category field to indicate the type transaction such as a Groceries Category. If you use the Category field, you can then filter a particular checkbook register spreadsheet and create Category subtotals such as displaying total spending in the Groceries Category this month or this year or display total expenses for a particular account register for any other category that you entered thus providing a way to track actual household expenses and income by categories.

Ability to sort transactions in the Excel check registers by date.

Insert date feature saves you time so you do not have to type out full date for each transaction that you enter in the excel checkbook templates.

Accounts Summary includes amounts for each checkbook register including Account Balances, Total Outstanding, number of Transactions Outstanding, Total Cleared, Total Assets, Total Liabilities, and Net Amount.

Importing of transactions from online banking or another financial institution can be done manually by downloading the transactions from the bank into an csv or txt formatted file and then opening that file in Excel and then aligning and formatting the columns to match the checkbook software register columns and then copy / paste special values the data into the check registers.

Memo field can be used to mark items as potentially tax deductible such as health insurance and medical expenses which can help when preparing year end Federal tax returns.

Use the checkbook software to enter and record different types of transactions such as deposits, purchases, withdrawals, payments, electronic transfers between accounts, automatic online bill payments, checks written, and other account inflows, outflows, debits, and credits.

The checkbook software template file contains Excel VBA macros that must be enabled for the software to work. These macros help simplify features such as sorting, filtering, and navigating the software.

The checkbook software can be saved on your desktop computer or laptop computer, thereby giving you more control of your personal financial information as opposed to having all your financial information saved in the cloud with an online file storage service, web based software, online personal finance software, or checkbook app.

Copyright 2016 George Alzamora. All Rights Reserved.

Georges Excel Checkbook Register is a single user license.

Georges Excel Checkbook Register is licensed not sold. Georges Excel Checkbook Register is for purchase only. Georges Excel Checkbook Register is not for resale. Unauthorized copying, sharing, or distribution of Georges Excel Checkbook Register, or any portion thereof, is prohibited.

The maximum number of registers / accounts is 7. Each Register has 1500 rows in which transactions can be entered into.

Georges Excel Checkbook Register is provided "as is" and without any warranties of any kind. By using Georges Excel Checkbook Register, you assume any risks for damages related to its use. You cannot recover any damages, including consequential, lost profits, special, indirect or incidental damages related to the use of Georges Excel Checkbook Register.

Amounts are in US $ currency only.

Georges Excel Checkbook Register's worksheets, workbook structure, and related Visual Basic Project may have been password protected by George Alzamora to protect the integrity of the data and Copyrighted information. Do not attempt to break into the password protected areas or to change, alter, or use in another application any formula, macro, module, custom form, Visual Basic Project or general layout/structure of Georges Excel Checkbook Register. If a sheet has been password protected, do not unprotect any password protected sheets in Georges Excel Checkbook Register. If the workbook feature is password protected, do not unprotect the workbook feature of Georges Excel Checkbook Register. Do not use the Visual Basic Project portion of Georges Excel Checkbook Register.


System Requirements:
Processor:  1.8 GHz processor or higher
RAM:  2 GB or more
Hard Disk:  10 MB of free hard disk space
Video Card:  Integrated or dedicated video card
Additional Requirements:  Requires Microsoft Excel 2007, Excel 2010, Excel 2013, or Excel 2016 on a PC Windows Computer.

Platforms

Windows 10, Windows 8, Windows 7, Windows Vista, Windows XP

Product Features

  • Easy to use checkbook software designed as a Microsoft Excel template.
  • Simple checkbook spreadsheet helps keep track of your transactions and account balances in your checking accounts, bank accounts, credit card accounts and savings accounts.
  • Excel checkbook registers make it easy to enter and record transactions so you can know what your account balance is.
  • The Accounts Summary shows you a summary of all your account balances so you to get a better picture of your financial accounts and personal finances on one worksheet.
  • Since Microsoft Excel does the calculations using Excel formulas, you can save time and potentially avoid costly overdraft errors that can happen when you keep track of your checkbook with a paper checkbook register.

More Details

Category: Personal FinanceBinding: Software DownloadLanguage: English


Comments




Become a fan of Software and Software Downloads! on Facebook for the inside scoop on latest and most exclusive software.