|
IEEE Region 3
|
The fundamental key to making this workbook work for you as automatically as possible is that every entry in the check registers is repeated in the proper Income or Expense account. For maximum efficiency as well as the avoidance of typographical errors, when each entry is completed in the Check Registers, immediately COPY that entry from the Date column to the Credit and PASTE that entry into the proper Income or Expense account. The columns of the Income and Expense accounts have been set up to allow the Copy and Paste method with correct placement of data in the Income and Expense account columns. Space has been allowed for a typical number of transactions in each account. However, if more lines are needed, use the "Insert, Row" command to add rows. It is a good idea to check the formula that sums the items in any account that you expand to be sure the sum formula correctly covers the new range and correct it if necessary. Normally the formula will automatically adjust. It will not adjust if the Inserted Row is outside the original range of the formula.
For the great majority of transactions, the Check Register and the Income or Expense account entries are all that will be necessary. However, there are a few types of transactions where there also will be required a manual entry into one of the L50 Schedules. Where this is required, there will be a note in the Income or Expense account that prompts you to make this additional entry. For example, see Income Account A-3.32: Receipts from RAB, Other Major Boards. Under the heading for this account is the note: "(Show also on L50, Sch III, Line 3.32.)" This prompts you that another entry is needed and guides the Treasurer in where to place it. Another example is for Expense Accounts B-5.60 – Other Management & General Expenses where these transactions must also be shown on L50 Schedule IV.