Electronic spreadsheets have been around for many years now. They were originally modeled on printed spreadsheets that have been used in accounting for an untold number of years. A remarkable thing about electronic spreadsheets is that very few people use them for accounting. Integrated packages like Quicken have taken hold of the accounting market for PCs. But, there is still a place for the electronic spreadsheet in accounting, especially when direct access to the data is required.
When I needed to start doing accounting tasks, I looked at a lot of the available commercial accounting packages. I'm no accountant, but I wanted to easily enter my checkbook transactions, keep track of transactions by account and business, reconcile my expenses and income with the bank statement, generate a small number of reports at the end of the year for my taxes, and have immediate access to all the data.
I found that the commercial packages were too complex for my needs. I also found that many of them did not give me direct access to all of the transaction information in my accounts. I looked at the way that many small businesses with single entry, cash flow, non-computerized accounting methods kept their books. I then transferred those methods to a dialog oriented Excel workbook. To this day, I use only these workbooks for my own accounting.
I'm No Accountant (TM) Workbooks for Excel perform single entry accounting with dialog based payments, income, and salary transactions. Transactions may be queried by account name and/or date range. Account management, checkbook reconciliation, and report printing are directed through dialog screens. Ledger posting is automatic. The workbooks include comprehensive Windows help files. If you run Excel 97 or later, there is also help directly from the web.
The I'm No Accountant workbook for Excel is organized around these components:
Major advantages of the I'm No Accountant workbook for Excel are ease of data entry and availability of the source code in Visual Basic for Applications (VBA) for inspection and modification. The information is stored in worksheets that are completely accessible to the user. This open access allows experienced users to add custom functions for data transfer, analysis, filtering, sorting, and graphing. It allows all users to easily correct entry mistakes.
If you've ever wished you could use Excel to easily manage your personal or business accounting, then the I'm No Accountant (TM) Workbook is the software for you.
The I'm No Accountant (TM) Workbook for Excel is a shareware program. It includes all features of the program, and is not crippled in any way. You may use it for up to 30 days without charge. If you like the program, and wish to continue using it after the evaluation period, you are required to pay for the program. Any fee you may have paid to others (disk vendors, dealers, etc.) to obtain this version was a fee for their copying and distribution services, not a payment for continued use of the program. Registered users get support, and notification of future versions.
To use this program, you must already have a copy of Excel 5.0 or later running under Windows 3.1, NT, 95, 98, 2000, or ME.. System hardware requirements to run the I'm No Accountant(TM) Workbooks are the same as those to run Excel 5.0, 7.0, 97, or later.
You can download this software now for an evaluation period of 30 days. Registered users get free upgrades. You can also view the complete manual for the I'm No Accountant workbook.
April 01, 2006.
Microsmith Computer Technology home page.