Import G/L Transactions

This option imports G/L transactions into a Keystone G/L Batch where it can be editited and posted. Optionally Job Cost fields can also be imported.

Standard Import Format

GLAccount <String 20>

TrxDate < mm/dd/yy>

RefNo <Normally 0>

CheckNo <Normally 0>

TrxAmount <numeric>

SourceCode <String 2>

Description1 <String 35>

Description21 <String 35>

Job ID <String 20 - Optional - Requires Budget Category and Tranaction Type>

Budget Category

Transaction Type

Asset <Optional when Job fields are used>

Sample File

"G/L ACCOUNT","TRANS DATE","REF NO.","CHECK NO.","TRANS AMT","SOURCE CODE","DESCRIPTION","DESCRIPTION2","JOB ID","BUD CAT","TRX TYPE","ASSET"
"718.00","11/29/02",0,0,-137.5,"PR","401K DED"
"718.00","11/29/02",0,0,34.38,"PR","CO 401K"
"647.00","11/29/02",0,0,-400.25,"PR","MEDICAL"
"645.00","11/29/02",0,0,-102.3,"PR","FICA"
"645.00","11/29/02",0,0,71.99,"PR","KSsutaEX"
"645.00","11/29/02",0,0,9.6,"PR","FUTA EXP"
"645.00","11/29/02",0,0,102.3,"PR","CFICA EX"
"639.00","11/29/02",0,0,1737.5,"PR","GROSS PY"
"220.00","11/29/02",0,0,-71.99,"PR","KSsutaWH"
"220.00","11/29/02",0,0,-9.6,"PR","FUTA W/H"
"215.00","11/29/02",0,0,-46.74,"PR","KS TAX"
"212.00","11/29/02",0,0,-94.72,"PR","FED TAX"
"212.00","11/29/02",0,0,-102.3,"PR","CFICA PB"
"110.00","11/29/02",0,0,-955.99,"PR","NET PAY"

Sample with Job Cost:

"822.10","11/29/02",0,0,1400,"TIRES","Trk 22","T22","MAINT","PARTS"
"822.10","11/29/02",0,0,1400,"TIRES","Trk 22","T16","MAINT","PARTS","3MT168"