Import G/L Transactions - Revision history

Chanson: /* Standard Import Format */

2022-03-31T13:10:22Z

Standard Import Format

Chanson: /* Standard Import Format */

2022-03-31T13:07:36Z

Standard Import Format

Chanson at 14:35, 14 January 2022

2022-01-14T14:35:06Z

User: 1 revision imported

2020-01-08T12:59:58Z

1 revision imported

en>User: 1 revision imported

2017-01-06T21:00:41Z

1 revision imported

New page

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==
<PRE>
"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"
</PRE>

Sample with Job Cost:
<PRE>
"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"
</PRE>

@@ Line 11: / Line 11: @@
 :'''SourceCode''' <String 2>
 :'''Description1''' <String 35>
-:'''Description2''' <String 35>
+:'''Description2''' <String 35> - Optional
 :'''Job ID'''  <String 20 - Optional - Requires Budget Category and Tranaction Type>
 :'''Budget Category'''

@@ Line 11: / Line 11: @@
 :'''SourceCode''' <String 2>
 :'''Description1''' <String 35>
-:'''Description21''' <String 35>
+:'''Description2''' <String 35>
 :'''Job ID'''  <String 20 - Optional - Requires Budget Category and Tranaction Type>
 :'''Budget Category'''

@@ Line 4: / Line 4: @@
 == Standard Import Format ==
-:GLAccount <String 20>
+:'''GLAccount''' <String 20>
-:TrxDate < mm/dd/yy>
+:'''TrxDate''' < mm/dd/yy>
-:RefNo <Normally 0>
+:'''RefNo''' This is ignored
-:CheckNo <Normally 0>
+:'''CheckNo''' <0 or check number>
-:TrxAmount <numeric>
+:'''TrxAmount''' <numeric>
-:SourceCode <String 2>
+:'''SourceCode''' <String 2>
-:Description1 <String 35>
+:'''Description1''' <String 35>
-:Description21 <String 35>
+:'''Description21''' <String 35>
-:Job ID  <String 20 - Optional - Requires Budget Category and Tranaction Type>
+:'''Job ID'''  <String 20 - Optional - Requires Budget Category and Tranaction Type>
-:Budget Category
+:'''Budget Category'''
-:Transaction Type
+:'''Transaction Type'''
-:Asset <Optional when Job fields are used>
+:'''Asset''' <Optional when Job fields are used>
 ==Sample File==

← Older revision	Revision as of 12:59, 8 January 2020
(No difference)