To start using the I'm No Accountant Workbook for Excel, only a small amount of setup is required. After you have gone through the Start up procedure, you can learn about the organization of the workbook by reading through the using the accounting workbook section. Continue reading this section to get started right away.
If you plan to do the accounting for a single business with one checking account, load the workbook INA189S.XLS and then press the OK key after the sign-on screen appears. If you want to do the accounting for multiple businesses with one checking account, load the workbook INA189M.XLS. If you have multiple checking accounts, use one workbook for each checking account.
The help file you are reading now is for both the single and multiple business workbooks.
To get started, press the ALT A key to pull down the Accounting menu. Select the Accounts item by clicking on it. The Accounts dialog box will be displayed. Click on the Clear All item.
To start up a new accounting workbook, click on OK. Fill in the dialog box with the starting amount in your checking account, the number of the next check you will write, and the title that you want to have on printouts. See the Start up section for more details. After all of this information is entered, click on OK.
You are given a final chance to back out. This is in case you started to clear all of the transactions from an old workbook and then changed your mind. Just click on OK for now. A message box will ask you to save the file under a new name. Click on OK. You should now use the File Save As command to save the workbook under a new name. Use the new name from now on. Each year you will probably want to start a new workbook with a new name, so it is helpful to include the year in the name of the workbook. For example, the name could be MyBz1999.XLS for 1999 accounting.
If you are updating to the new version of the workbook from an older one that contains your transactions, select the Import item from the Accounting menu bar item. Transactions in the old workbook will be read and entered into the new version.
At this time you may want to examine the default account names. Just select the Accounts item from the Accounting menu bar item and click on Cancel. The worksheet of accounts will be shown. Click on the Print icon to print the page. You can use the Accounts Add or Accounts Delete command to change the list. If you only want to change a description, simply type over the old one. For the multiple business workbook, use the Business command to define the business names.
You are now ready to use the Transactions command to enter new deposits and payments. At the end of the month when you get the bank statement, the Reconcile command is used to compare your records with the statement. The Print command is used to print balances, accounts, and transactions.