Business

User Tools

Site Tools

Trace:
payroll:utilities:installsalarytaxtables

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
payroll:utilities:installsalarytaxtables [2020/04/06 20:47] – created emorenopayroll:utilities:installsalarytaxtables [2023/01/02 18:02] (current) – emoreno
Line 3: Line 3:
 <div #message></div> <div #message></div>
  
-//**Human Resources > Utilities > Install Salary/Tax Tables**//+//**Payroll > Utilities > Install Salary/Tax Tables**//
  
 <WRAP round intro>This utility is used to import tables from external sources to update current or next year tables.  <WRAP round intro>This utility is used to import tables from external sources to update current or next year tables. 
Line 9: Line 9:
 You can choose between file types that are tab-delimited text (.txt) or database (.dbf). You can choose between file types that are tab-delimited text (.txt) or database (.dbf).
  
-**Note**: At the beginning of each calendar year, the TCC provides a flat text file containing the new calendar year tax tables. This file is accessible to the local ESC consultants via the FTP site. **It is recommended** that the LEA's use the provided file to import the tax data as the pay frequency is no longer being used for calendar years greater than 2019. Additionally, the import relieves the task of having to manually set up the tax table data on the Human Resources > Tables > Taxes/Deductions pages.+**Note**: At the beginning of each calendar year, the TCC provides a flat text file containing the new calendar year tax tables. This file is accessible to the local ESC consultants via the FTP site. **It is recommended** that LEAs use the provided file to import the tax data as the pay frequency is no longer being used for calendar years greater than 2019. Additionally, the import relieves the task of having to manually set up the tax table data on the Payroll > Tables > Taxes/Deductions pages. 
 + 
 +[[academy:business_payroll_updatetaxtableschecklist|Update Tax Tables]] 
  
 </WRAP> </WRAP>
Line 25: Line 28:
  
  
-VCV Under **Current-Next Year**, select either **Current Year** or **Next Year**. These options are only available when the **State Salary** or **Job Code** table is selected.+VCV Under **Current-Next Year**, select one of the following.  
 + 
 +<div indent>These options are only available when the **State Salary** or **Job Code** table is selected. 
 +</div> 
 + 
 +  * **Current Year**  
 +  * **Next Year** 
  
 VCV Under **Process Specifications**: VCV Under **Process Specifications**:
Line 34: Line 43:
  
   * Click **Choose File** and type the drive and folder name from where you want to install a salary/tax table.   * Click **Choose File** and type the drive and folder name from where you want to install a salary/tax table.
-  * Click **Submit** to accept the import file name and return to the Import Salary/Tax Tables page. Otherwise, click **Cancel** to close the dialog box without processing.+  * Click **Submit** to accept the import file name and return to the Import Salary/Tax Tables page.  
 +  * Click **Cancel** to close the dialog box without processing.
  
  
-VCV Click **Execute**. A data preview window displays the name of the table being updated (e.g., Data Preview - Fed. Income Tax Table). +VCV Click **Execute** to execute the process. A data preview window displays the name of the table being updated (e.g., Data Preview - Fed. Income Tax Table). 
-  * If records exist for a table, the system displays the following message: ”Do you wish to replace existing records?” Click **Yes** to delete the existing records for the school/tax year and import the data into the Human Resources current year or next year tables. Otherwise, click **No** to cancel the import process.+  * If records exist for a table, the system displays the following message: ”Do you wish to replace existing records?” Click **Yes** to delete the existing records for the school/tax year and import the data into the Payroll current year or next year tables. Otherwise, click **No** to cancel the import process.
   * If records exist for the salary table, the system deletes the existing records for the current year or next year (as specified) when the user chooses to replace existing records.   * If records exist for the salary table, the system deletes the existing records for the current year or next year (as specified) when the user chooses to replace existing records.
   * If the job table already has data, it cannot be deleted or replaced. The job table can only be loaded from an empty job table.   * If the job table already has data, it cannot be deleted or replaced. The job table can only be loaded from an empty job table.
payroll/utilities/installsalarytaxtables.1586206021.txt.gz · Last modified: 2020/04/06 15:47 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.