Difference between revisions of "Import iSolved Transactions"
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
*Make sure your iSolved team has provided you with the standard g/l and c/m reports designed for Keystone. | *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. | ||
*Select the report menu from the main iSolved menu. This will normally be under Reports/Report Archive. | *Select the report menu from the main iSolved menu. This will normally be under Reports/Report Archive. | ||
| Line 62: | Line 63: | ||
*Select the newly created batch | *Select the newly created batch | ||
*Hit the Post option | *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" | ||
Revision as of 18:08, 17 January 2025
There are 2 options for Importing ISolved Transactions into Keystone
- The Export and Import Process where iSolved Exports a .csv file and Keystone loads it.
- The iSolved/Keystone API interface. This option is still pending.
Contents
Export/Import via transfer file
General Ledger
NOTE: The General Ledger export will also include Job Cost Data.
Export file from iSolved
- 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.
- 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"
