Import iSolved Transactions

There are 2 options for Importing ISolved Transactions into Keystone

• The iSolved/Keystone API interface. This is rolling out - you will be notified by iSolved when available to you.
• The Export and Import Process where iSolved Exports a .csv file and Keystone loads it.

Export/Import via the iSolved API

This option pulls data directly from iSolved into Keystone. It will only be available when activated by iSolved and then Keystone is configured with proper credentials by GivenHansco support. NOTE: Keystone can be configured for various levels of consolidation from extremely detailed to summarized.

Importing from the API

• In Keystone, select Import Payroll Transactions from Genderal Ledger - Entry/Inquiry Menu.

• Select the Run to import. By default the latest run will be first.

• Select which items to import, General Ledger, Cash Management and Job Cost. All items are checked by default.

• Hit OK

This will create batches for each application.

Posting

For each application, find the new batch and post as you would any other batch.

• General Ledger: Journal Entry on the Entry/Inquiry menu.
• Cash Manegment: Post Imported Transactions on the Entry/Reconciliation menu
• Job Cost: Transaction Entry on the Entry/Inquiry menu.

Export/Import via transfer file

This method involves exporting one file for General Ledger, which will include Job cost if needed, and one file for Cash Managment. These files must be downloaded from iSovled and saved in an easy to access (and remember) location. You might want to create a folder on your computer or network with a notable name, e.g. c:\iSolved_transfer.

• Make sure your iSolved team has provided you with the standard g/l and c/m reports designed for Keystone.
• See Tip below - Make sure browser settings allow you to select the save location of downloaded files.

General Ledger

NOTE: The General Ledger export will also include Job Cost Data.

Export file from iSolved

• Select the report menu from the main iSolved menu. This will normally be under Reports/Report Archive.

iSolved Menu

• Scroll to the bottom of the list

• Select the desired report.
• Pick the correct weeks payroll.
• Make sure to save in CSV format.
• Save to a convenient folder on your local computer.

Import file into Keystone

• Select Import Transactions from General Ledger Entry/Inquiry menu.

• • You will need to select the file you exported from iSolved.

Post the Imported batch

• Select Journal Entry from the General Ledger Entry/Inquiry menu

• Select the newly created batch

• Hit the Post option

Cash Management

• Select the report menu from the main iSolved menu. This will normally be under Reports/Report Archive.
• Scroll to the bottom of the list

• Select the desired report. (e.g. Keystone Cash Management Export)
• Pick the correct weeks payroll.
• Make sure to save in CSV format.
• Save to a convenient folder on your local computer.

Import file into Keystone

• Select Import Transactions from Cash Management Entry/Inquiry menu.
  • You will need to select the file you exported from iSolved.

NOTE: You must close this option at the end of each imported file when importing multiple files.

Post the Imported batch

• Select Post Imported Transactions from the Cash Management Entry/Inquiry menu
• Select the newly created batch
• Hit the Post option

Tip: Configure Browser to ask for Save Location

By default, most browsers save files to the specified download folder. This can be difficult to find from Keystone programs. Make your life easier by changing the browser settings to ask for a file location each time you download.

Change save location in Edge / Chrome

• Click the ... button in the top right corner
• Click Settings
• Click Downloads on the left
• Turn on the setting "Ask me what to do with each download"