Salary Conversion Calculator rvsd 2-2-06 by marcusjames

VIEWS: 4 PAGES: 1

									                                    Salary Transfer Conversion Calculator
                                                Benefit Table as of:        12/01/2005




Purpose: This salary conversion tool has been created to assist you in converting salary dollars between two accounts where at least one
account is a salary dollar account (these accounts have benefit dollars that need to be factored in). Examples of the three types of
conversions are: (1) a transfer from "Faculty Salary Regular" to "Faculty Salary Adjunct" or (2) a transfer from "Faculty Salary Regular" to
"Computer Equipment" or (3) a transfer from "Computer Equipment" to "Faculty Salary Adjunct."



            Enter the salary dollars (don't include benefits ) or non-salary
Step 1:     dollars you need .




            Using the drop down list (click your pointer on the gray shaded
Step 2:     cell to the right ), select the account number these salary dollars
            are needed in (the transfer to account ).


            Note: You have selected the following account for the salary
Step 3:     dollars you need. If this is not the account you want, please
            review the chart of accounts and reselect.


            Using the drop down list (click your pointer on the gray shaded
            cell to the right ), select the account number for the salary dollars
Step 4:     from where you want the funds transferred (don't include
            benefits ).




            Note: You have selected the following account for the salary
Step 5:     dollars to be transferred from. If this is not the account you
            want, please review the chart of accounts and reselect.


         Your transfer should increase and decrease the accounts as
Results: follows (shown below ):
                                 Account Number                                                       Increase              Decrease




        Test (if the sum of the increase and the decrease columns do not
Review: equal, please review - these should equal).
                                                                                                  $             -       $             -

            Note: If "0" appears in the account number column, it is because there are no benefits associated
            with one of the accounts you are transferring to/from.



NOTE: This conversion spreadsheet is based on benefit tables that change several times a
year. Please make sure that the date above reflects the tables that are most recent. Any
questions or comments regarding this salary conversion tool should be directed to Cherry
Gilbert (Finance Office) @ x2009 or e-mail:cyueh@spu.edu.


                                                                                         Form Last Revised:                   2/2/2006

								
To top