|
IEEE Region 3
|
Every Section should have an IEEE Concentration Account established by the end of year 2000. This worksheet is the place to record all your transactions in this account. In the upper right hand corner, in cell J1, enter your Sections Concentration Account number. In cell L5, enter the balance in this account carried forward on January 1 from the end of last year. If your transactions extend beyond row 100 in this worksheet, you will need to adjust the formula in cell J2 that generates the current balance in your account. Just click on cell J2 and it will be obvious how to adjust the formula for more rows.
For each transaction you make in the Concentration Account during the year, enter the appropriate account number, the date, the check number if any, the payee of the check, a transaction memo if needed and the amount of the transaction. Checks you write should show the amount in the Debit column. Deposits you receive should be shown in the Credit column. The balance in this account will be automatically calculated at the top of the worksheet in the Current Balance cell. Interest earned and credited by the bank and other deposits will not show a check number. Transfers between cash accounts will not show an account number. When you receive your bank statements, place an x in the "Clrd" column between the Debit and Credit columns for all transactions that have cleared the bank.
At the bottom of this worksheet is a special section for reconciling the Check Register with the Bank Statement at the end of each month. For each transaction that has NOT cleared (no x in the "Clrd" column), copy that transaction line and paste it to the first blank line in the Reconciliation table. At the bottom of the Reconciliation table you will find the sum of the outstanding checks and deposits and the balance that should be on the bank statement. If there is a discrepancy between the bank statement amount shown here and the actual bank statement, there is an error that should be found and corrected.
NOTE: On this worksheet as on most worksheets in this workbook there are "named" cells. When your cursor highlights one of these cells, the cell name will be shown in the left hand space in the formula bar for this worksheet. These names are crucial to the operation of all the automatic actions in this workbook. DO NOT change these names. If you want to find the location in the workbook where any named cell is defined, click on the drop-down table button on the cell name window and select the name for the cell you wish to locate by clicking on it. The cursor will then move to the worksheet and cell that defines this name.