Difference between revisions of "Import G/L Transactions"
Jump to navigation
Jump to search
en>User m (1 revision imported) |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
== Standard Import Format == | == Standard Import Format == | ||
| − | :GLAccount <String 20> | + | :'''GLAccount''' <String 20> |
| − | :TrxDate < mm/dd/yy> | + | :'''TrxDate''' < mm/dd/yy> |
| − | :RefNo | + | :'''RefNo''' This is ignored |
| − | :CheckNo < | + | :'''CheckNo''' <0 or check number> |
| − | :TrxAmount <numeric> | + | :'''TrxAmount''' <numeric> |
| − | :SourceCode <String 2> | + | :'''SourceCode''' <String 2> |
| − | :Description1 <String 35> | + | :'''Description1''' <String 35> |
| − | : | + | :'''Description2''' <String 35> - Optional |
| − | :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== | ==Sample File== | ||
Latest revision as of 13:10, 31 March 2022
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 This is ignored
- CheckNo <0 or check number>
- TrxAmount <numeric>
- SourceCode <String 2>
- Description1 <String 35>
- Description2 <String 35> - Optional
- 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"
