User Tools

Site Tools


payroll:utilities:installsalarytaxtables

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
payroll:utilities:installsalarytaxtables [2020/09/01 21:33] emorenopayroll:utilities:installsalarytaxtables [2023/01/02 18:02] (current) emoreno
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'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 45: Line 48:
  
 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). 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.1598996013.txt.gz · Last modified: 2020/09/01 16:33 (external edit)