I'M NO ACCOUNTANT. (TM) Single Business Journal Template Copyright 1991 Willis E. Howard, III All rights reserved. I'm no accountant. But I run a business and need to keep the books. The checkbook needs to be balanced. At the end of the year, my accountant needs a copy of the books, summarizing where the money came from, and were it went. I looked at accounting software but found it too complex. The I'M NO ACCOUNTANT (TM) accounting template provides quick and easy bookkeeping for a small business. ALT A The main accounting menu comes up when the spreadsheet is loaded or when you press the ALT A key from 1-2-3 READY. The following options can be selected: 1-2-3 Transactions Journal Extract Register Help Quit 1-2-3 enters 1-2-3 (R) READY mode. The TRANSACTIONS menu processes new data. The JOURNAL menu allows balancing and printouts. The EXTRACT menu displays entries by account number. The REGISTER item provides information on registration. The HELP command shows these help screens. The QUIT command from the main menu saves and exits. 1-2-3 Almost all accounting functions can be accessed from the menu items. When other spreadsheet functions are needed, select the 1-2-3 item. The accounting menu will be turned off and you may use standard 1-2-3 (R) commands to access the information in the spreadsheet. When you have finished and wish to return to the main accounting menu, press the ALT A key. This is the first item on each menu. When any menu is displayed, just press the ENTER key to access the 1-2-3 READY mode. Press the ALT A key to continue. TRANSACTIONS When the TRANSACTIONS item is selected from the main menu, the following menu is displayed: 1-2-3 Deposit Payment Salary Reconcile Bottom Help Quit 1-2-3 enters 1-2-3 (R) READY mode. DEPOSIT inputs information on income received. PAYMENT inputs information on checks which are written. SALARY inputs information on a salary paid. RECONCILE allows reconciliation with a bank statement. BOTTOM positions the spreadsheet at the final entry. HELP shows these help screens. QUIT returns to the main menu. TRANSACTIONS Select the DEPOSIT item to enter information on a bank DEPOSIT deposit. Be sure to enter the date, account number, and amount. Keep a list of income (deposit) account numbers handy. To make a list, select a JOURNAL printout item. Words may be used in place of account numbers. If the deposit amount is left blank, the data will be ignored. The spreadsheet will be positioned under the current bank balance. TRANSACTIONS Select the PAYMENT item to provide information on the PAYMENT payment of an expense. Be sure that the date, account number and amount are entered. Keep a list of expense (payment) account numbers handy. To make a list, select a JOURNAL printout item. Words may be used in place of account numbers. If the expense amount is left blank, the data will be ignored. The spreadsheet will be positioned under the current bank balance. TRANSACTIONS Select the SALARY item from the TRANSACTIONS menu when SALARY you pay a salary. Tax and FICA are not computed, but may be entered on the input screen. If the gross salary is left blank, the data will be ignored. The spreadsheet will be positioned under the current bank balance. If the gross salary does not equal the net salary plus the deductions, the entries must be modified. Information may be extracted by Employee ID. Use numbers different from account numbers. TRANSACTIONS The RECONCILE item allows the spreadsheet entries RECONCILE to be reconciled with the bank statement. Invoke this each time you get a new bank statement, after all the month's information is entered. After an initial setup, the spreadsheet will be positioned on an empty entry in the MONTH column. An entry from 1 to 12 indicates which month the item was processed by the bank. Either leave the cell empty or type in a number from 1 to 12, followed by the ENTER key. Pressing ENTER until reaching the end of the spreadsheet is the only way to complete reconciliation. HELP From the main menu, select the HELP item to get help on the commands. This screen is the help screen on HELP. Use the PAGE UP and PAGE DOWN keys to go between the help screens. Press the ENTER key to return to the menu from which you requested help. From 1-2-3 READY mode, press the ALT A key to return to the main accounting menu. JOURNAL When the JOURNAL item is selected from the main menu, the following JOURNAL menu is displayed: 1-2-3 Balance Modify Clear Normal Sideways Help Quit 1-2-3 enters 1-2-3 (R) READY mode. BALANCE will balance all accounts, verifying entries. MODIFY adds new account numbers or changes sort criteria. CLEAR erases all deposit and payment information. (BEWARE !) NORMAL performs a journal listing on a printer. SIDEWAYS performs a SIDEWAYS(R) journal listing. HELP shows these help screens. QUIT returns to the main menu. JOURNAL After entering the information for each month, the BALANCE BALANCE item should be selected. All account information in the journal will be transferred to income and expense ledgers. Total deposits will be compared against income accounts. Total payments will be compared against expense accounts. Improper account numbers must be corrected. Change any of the account names and/or numbers to correspond to your chart of accounts. Add new account numbers with the JOURNAL MODIFY command. JOURNAL When the MODIFY item is selected from the JOURNAL menu, MODIFY the following JOURNAL MODIFY menu is displayed: 1-2-3 Expense Income Sort Help Quit 1-2-3 enters 1-2-3 (R) READY mode. EXPENSE adds a new expense account number and name. INCOME adds a new income account number and name. SORT toggles between showing accounts by number or name. HELP shows these help screens. QUIT returns to the main menu. JOURNAL Selection of the EXPENSE item from the JOURNAL MODIFY menu MODIFY allows you to add a new expense account number and name EXPENSE to the list of expense account numbers. After adding the new number and name, the list is sorted. If no account number is given, the command is ignored. The spreadsheet will be positioned to show expense ledger entries. Use account numbers if your accountant prefers them. It is easier to remember single, short words to identify the account. Set up your accounts with words if you prefer. JOURNAL Selection of the INCOME item from the JOURNAL MODIFY menu MODIFY allows you to add a new income account number and name INCOME to the list of income account numbers. After adding the new number and name, the list is sorted. If no account number is given, the command is ignored. The spreadsheet will be positioned to show income ledger entries. Use account numbers if your accountant prefers them. It is easier to remember single, short words to identify the account. Set up your accounts with words if you prefer. JOURNAL Selection of the SORT item from the JOURNAL MODIFY menu MODIFY changes the way in which the deposit and expense account SORT entries are sorted. If they are currently sorted by account number, they will be resorted alphabetically by name. If now sorted by name, they will be resorted by number. This command has no impact on the information in the ledger, only on how it is displayed. JOURNAL Selection of JOURNAL CLEAR will erase all spreadsheet data. CLEAR All data will be lost by using this command. The initial date and account balance must be set. A new file name for the spreadsheet will be requested. A new business name for the title will be requested. Use this command to start a new year or checking account. JOURNAL To make a printout of the spreadsheet, select the JOURNAL NORMAL item from the main menu. If SIDEWAYS(R) is loaded, you may use the SIDEWAYS print item from the JOURNAL menu. Otherwise, select the NORMAL item for a normal printout using the using 1-2-3 (R) print defaults. For JOURNAL NORMAL printouts only, a header will be automatically generated with business name and date. Before using this template, be sure that 1-2-3 is set up properly for your printer. JOURNAL To make a printout of the spreadsheet, select the JOURNAL SIDEWAYS item from the main menu. If SIDEWAYS(R) is loaded, you may use the SIDEWAYS print item from the JOURNAL menu. Otherwise, select the NORMAL item for a normal printout using the using 1-2-3 (R) print defaults. This product does not come with SIDEWAYS(R) which must be purchased separately if desired. SIDEWAYS(R) is a registered trademark of Funk Software, Inc. The SIDEWAYS(R) add-in must be attached as ALT-F7 or app1 before invoking SIDEWAYS options or else the template may be corrupted. Be sure to configure SIDEWAYS(R). EXTRACT Selection of the EXTRACT option from the main menu results in the display of the following menu: 1-2-3 Input Normal Sideways Up Down Help Quit 1-2-3 enters 1-2-3 (R) READY mode. INPUT allows you to select one account number to view. NORMAL generates a normal printout for that account number. SIDEWAYS produces a sideways printout. UP shows the previous screen up when there is one. DOWN shows the next screen down. HELP shows these help screens. QUIT returns to the main menu. EXTRACT The EXTRACT INPUT command allows a set of journal entries INPUT with the same account number to be viewed. The account number will first be requested. The previous display will be erased before the new display is shown. If an employee ID number is given instead of an expense or deposit account number, the information on salary for that employee will be extracted. An optional starting date and/or ending date may be given. If a starting date is given, no entry before the starting date will be extracted. If an ending date is given, no entry after the ending date will be extracted. The default is to extract entries without regard to the date. EXTRACT After the EXTRACT INPUT command has been given to extract NORMAL the information on one account number, that information may be printed out on the printer. Use the EXTRACT NORMAL command to get a normal printout. Use the EXTRACT SIDEWAYS command to get a sideways printout For EXTRACT NORMAL printouts only, a header will be automatically generated with business name and date. Before using this template, be sure that 1-2-3 is set up properly for your printer. EXTRACT After the EXTRACT INPUT command has been given to extract SIDEWAYS the information on one account number, that information may be printed out on the printer. Use the EXTRACT NORMAL command to get a normal printout. Use the EXTRACT SIDEWAYS command to get a sideways printout This product does not come with SIDEWAYS(R) which must be purchased separately if desired. SIDEWAYS(R) is a registered trademark of Funk Software, Inc. The SIDEWAYS(R) add-in must be attached as ALT-F7 or app1 before invoking SIDEWAYS options or else the template may be corrupted. Be sure to configure SIDEWAYS(R) for your printer. EXTRACT Extracted account information can sometimes fill more than UP one screen. When this happens, use the EXTRACT UP command and the EXTRACT DOWN command to view different parts of the extracted information without entering 1-2-3 (R) READY mode. Use this command only when extracted information is visible on the screen. EXTRACT Extracted account information can sometimes fill more than DOWN one screen. When this happens, use the EXTRACT DOWN command and the EXTRACT UP command to view different parts of the extracted information without entering 1-2-3 (R) READY mode. Use this command only when extracted information is visible on the screen.