Difference between revisions of "Import Isolved Transactions"

From GivenHansco Keystone Help
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 3: Line 3:
 
*The iSolved/Keystone API interface.  This option is still pending.
 
*The iSolved/Keystone API interface.  This option is still pending.
  
=Export/Import vis transfer file=
+
=Export/Import via transfer file=
  
 
==General Ledger==
 
==General Ledger==
Line 9: Line 9:
 
NOTE: The General Ledger export will also include Job Cost Data.
 
NOTE: The General Ledger export will also include Job Cost Data.
  
===Export from iSolved===
+
===Export file from iSolved===
  
 
*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.
Line 28: Line 28:
 
*Save to a convenient folder on your local computer.
 
*Save to a convenient folder on your local computer.
  
===Import into Keystone===
+
===Import file into Keystone===
  
 
*Select Import Transactions from General Ledger Entry/Inquiry menu.
 
*Select Import Transactions from General Ledger Entry/Inquiry menu.
[[File:Import GL Menu.png]]
+
:[[File:Import GL Menu.png]]
 +
:[[File:Import GL Screen.png]]
 
**You will need to select the file you exported from iSolved.
 
**You will need to select the file you exported from iSolved.
 +
 +
  
 
==Post the Imported batch==
 
==Post the Imported batch==
 
*Select Journal Entry from the General Ledger Entry/Inquiry menu
 
*Select Journal Entry from the General Ledger Entry/Inquiry menu
[[File:Post GL Menu.png]]
+
:[[File:Post GL Menu.png]]
 
*Select the newly created batch
 
*Select the newly created batch
 +
:[[File:Post GL Screen.png]]
 
*Hit the Post option
 
*Hit the Post option

Latest revision as of 20:42, 30 December 2024

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.

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.
  • Select the report menu from the main iSolved menu. This will normally be under Reports/Report Archive.
iSolved Menu
iSolved Menu
  • Scroll to the bottom of the list

Islvd Export Select.png

  • 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.
Import GL Menu.png
Import GL Screen.png
    • 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
Post GL Menu.png
  • Select the newly created batch
Post GL Screen.png
  • Hit the Post option