You can create your salary guides in Excel, save them as CSV or TXT files, and upload them directly into Keystone. This allows you to quickly and easily update salary guides without having to manually enter the data in Keystone.
Under the "Salary Tables" menu, click "Salary Guides" (KE0059).
Select the applicable Salary Guide, and double click on the Salary Guide detail for the Year and Phase you wish to update.&nbsp;
NOTE: You should leave the “Remote Table Path” and “Table Name” blank – this allows you to search your own PC for the file to be uploaded. If these fields are currently filled in, you should clear them out. 
Select either "Comma Delimited" or "Tab Delimited" (CSV or TXT), depending on how you decided to save the file from Excel. (If saving as a CSV file, be sure that the dollar amounts do not include commas.)
If your file contains headers and/or row descriptions, change the Starting Row and Starting Column fields accordingly. Otherwise, leave them set to "1" and "A".&nbsp;
Click the "Load Remote Table" button, and a Windows dialog box should appear, allowing you to search for the file and import it to Keystone.&nbsp;
<img src="https://cdn.livechat-static.com/api/file/kb/file/5399341/c2fcebdc51-791ed6c79d5108c4dbeb.png" alt="undefined" style="float:none;height: undefined;width: undefined"/>

You can create your salary guides in Excel, save them as CSV or TXT files, and upload them directly into Keystone. This allows you to quickly and easily update salary guides without having to manually enter the data in Keystone.
Under the "Salary Tables" menu, click "Salary Guides" (KE0059).
Select the applicable Salary Guide, and double click on the Salary Guide detail for the Year and Phase you wish to update. 
NOTE:  You should leave the “Remote Table Path” and “Table Name” blank – this allows you to search your own PC for the file to be uploaded. If these fields are currently filled in, you should clear them out.  
Select either "Comma Delimited" or "Tab Delimited" (CSV or TXT), depending on how you decided to save the file from Excel. (If saving as a CSV file, be sure that the dollar amounts do not include commas.)
If your file contains headers and/or row descriptions, change the Starting Row and Starting Column fields accordingly. Otherwise, leave them set to "1" and "A". 
Click the "Load Remote Table" button, and a Windows dialog box should appear, allowing you to search for the file and import it to Keystone. 
 


How do I import a Salary Guide from a spreadsheet (CSV or TXT format)?

Where do I find HRCODES TERM.CODES to change the list?

Where do I change the body of an email for the direct deposit notification?

I'm not getting email notifications from employees making changes on the employee portal

How do I create a deduction type?

Is there a quick way to run a report for a specific attendance code?

On the Chart of Accounts Maintenance screen (GL0018), what is the significance of the 3 checkboxes?

How do I delete a payroll batch?

How do I increase the maximum gross pay and maximum net pay limits?

While updating Payroll, it wants to close Quarter 1 of the current year instead of Quarter 4- what do I  do? 

How do I add a new bank name for direct deposit?

How do I create the scattergrams for the salary guides?

Where are the Federal Tax Tables?

Why are the taxable wages (and tax withheld) incorrect?

How do I add a job code to an employee's  pay line?

What Keystone standard Meta Table reflects the information on the Employee Pay (KE0043) screen?

On Calculate Payroll report I have 2 checks to print How to find who's not set up for direct deposit

In KeyNet Applicant, how do I adjust the "New Hire Approval," so we can approve job applicants?

How do I make an earning code hit on a different account when posting in the general ledger?

What would make an employee pay line not initiate when Initiate Payroll Transactions (KE0090) is run?

How do I update/create a new hire sequence?

How do I fix a recurring event on an employee calendar?

Where do I change who gets an email when there is a new status of a new/terminated/moved employee?

How do I find the report for Form 941 Information (KE0660)?

How do I find an employee’s employment status?

What does the “A/P” field mean in an employee’s direct deposit screen?

The deduction/benefit is not calculating, how do I check the Earning Code is blocking deductions?

How do I update an employee’s annual salary?

Common reasons a pay line may not automatically pull into payroll.

I already created checks and/or direct deposits for my payroll but need to make a change. How do I make a change?

How do I add a position code for OASIS?

How do I add retirement to new deduction codes for health insurance?

How do I make an earning code hit on a different account when posting to the general ledger?

How do I add/edit/delete code options to a code table (e.g., HR Code ATTACHMENT.TYPE)?

How do I pull one earning code from Job Assignments to payroll so it can be paid?

How do I add a new note type to the Notes screen under Employee Maintenance?

How do I delete an Employee Cost Projection Model?

How do I rebuild the leave summary?

How do I track how many hours an employee has worked for a specified date range?

How do I set up the Positive Pay Parameters in KEMS?

Can I reprint the Post Substitute Pay Report after posting?

How do I add an employee(s) into a payroll batch?

How do I set up an Earning Code for Direct Debit?

How do I increase the limit when I receive an error on my Calculate Payroll Report that the gross or net pay is greater than the maximum?

The deduction/benefit isn't calculating, is the code defined on the Setup Payroll Parameters Screen?

How do I find out if a payline is active?

What employee statuses are included when running automatic timecards?

On the payroll calendar, will the run number be 1 for the first payroll of the month?

How do I initiate payroll transactions?

How do I set the default fields to update when rolling from Job Assignments to Payroll?

How do I manually update the paid to date information on the new pay line after it's rolled for an employee?

Where do I change the bank name and routing number on an ACH file for Payroll?

Where do I go to add a certification code?

What are the best practices for setting up supervisors?

Why isn't my deduction or benefit calculating correctly?

How do I assign and set up notifications for the ACA responsible person?

Where do I view the comments on Job Assignments?

How do I set up accruals for a leave code?

How do I set up an attendance code to dock an employee’s pay if the available time is exceeded?

How do I know if the pay cycle for the payline is defined on the Payroll Calendar?

What do each of the Benefit Enrollment Status codes mean?

What should I consider when giving previous employee's access to their information on KeyNet?

If I get an error when entering two leave transactions for the same day, what do I do?

When setting up payroll calendar in Payroll Calendar Maintenance, what is the box with "P"?

What's the difference between Employee End Date/Scheduled End Date on position control transactions?

How do I enter start and end dates on a calendar code for a group of employees?

An employee changed jobs but I failed to activate the new payline for their payroll, what do I do?

Can I build a W2 file anytime during the current year?

If deduction/benefits did not calculate, is it using the Service Months as part of the calculation?

How do I clear the posting information on employees job assignment and roll job assignment to payroll?

How do I delete an existing pay line in payroll?

How do I prevent Attendance Codes from rolling to the Next Fiscal Year?

How do I build a W2 file during the current year?

How do I check if the last voucher numbers updated?

How does the “ACA Review Import” option work?

Program KE0148 allows historical picture's of employee's, where does Keystone pull these from?

Is it possible to have a single leave code record in hours rather than days?

What does error 'Account not found LOC' mean when calculating payroll for a new employee?

When I calculate payroll I get the message, 'Employee Status is Deceased'. Can I still complete the payroll?

How do I get the total expenditures for an employee for a fiscal year?

Where do I go to add a new Pennsylvania local tax (PSD) code?

How do I change the school year on the Differences Between Status Screens (KE0880)?

How do I change our Paystub Logo?

How do I change the number of pays on a pay cycle?

How do I run a payroll register for a date range instead of a pay period?

How do I fix leave that's in the wrong fiscal year?

How do I set up my holiday calendar with non-working days for specific groups of employees?

Can I use the void/reissue to void a Direct Deposit and reissue with a paper check? 

How do I update the new (2020 and later) W-4 Form in Keystone Client?

Where do I enter the comments for Job Assignments?

An employee had a deduction incorrectly withheld in the last pay.  How do I fix this?

How do I turn off/on the taxable benefit for retirement pop up on Deduction and Benefit Code Maintenance?

KEMS

Welcome to Keystone's Knowledge Base!