Can Journal Ledger Be Imported to General Ledger?

Q - Can the General Journal ledger be imported from a spreadsheet into the General Ledger as opposed to manually entering it?

A - Yes. You can go to General Ledger -> Processing -> Interface from Other Package -> CSV Import. See sample screen below.

The CSV file consists of 6 columns:

  • Account #
  • Trx Date
  • Trx Source
  • Amount 
  • Reference
  • Interface Flag
Account#: This is the GL Account.  Enter the value like you normally would -- such as 1100 if you have do not have a profit center or department segment. If you have profit center, the account would be something like 1100-001.  If you have both a profit center and a department segment, then the account would be something like 1100-001-01.
Trx Date: This would be a date in the MM/DD/YYYY format, such as 12/12/2015 for December 12, 2015.
Trx Source: This is the 10-digit Journal Source, such as a batch ID for cross-referencing purposes.  The source is displayed extensively in General Ledger inquiry screens and printing reports. You can use GL -> Reports -> Source Cross Reference Report to retrieve information by source.
Amount: This is the amount of the transaction.  Enter a positive amount -- something like 123.52 for debit amount -- or a negative number like -100 for a credit amount. Including a comma or decimal in your amount is optional.
Reference: This is a 30-digit reference information field in the free-form format for notation purposes.
Interface Flag: This column is typically not used. It is for multiple company GL consolidation purposes. You can just leave it blank.

Prepare/Edit Journal Ledger in Spreadsheet Default File Format
Even though Elliott can't import from XLS or XLSX files directly, we still suggest that you prepare and edit your GL Journal Ledger spreadsheet in the XLS or XLSX format.  When you are ready to import the journal to Elliott, do a "save as" to a CSV file.  Then import that CSV file to Elliott.

Pre-Interface vs. Interface
Before you interface the CSV to Elliott, we suggest that you use the "Pre-Interface" option first.  "Pre-Interface" will check to see if your data has any errors. The following is a list of errors or warnings that the system will check for:
  • Invalid Data - like Invalid GL Account, Date, Amount, etc.
  • Trx Date outside of cutoff range, as specified during the import
  • Size Error - like Trx Source exceeds the maximum 10 digits, trx amount exceeds maximum 2-digit decimal precision, the reference field exceeds 30 digits...etc.
If there's no error in the CSV File, then you can proceed to the "Interface" option. Upon successful interface, the CSV File will be deleted.

This G/L CSV "Interface" options is a two-step process.  Once you successfully import the General Journal CSV file, it is added to the General Journal Trx.  You will need to post the General Journal Trx before it becomes your General Ledger.

General Ledger

  1. GLMENU General Ledger Package Overview
  2. My General Ledger Interface with Other Package Is Out of Balance
  3. Can Journal Ledger Be Imported to General Ledger?
  4. Is There a Way to Pull All Manual GL Entries Out of Elliott?
  5. How to Print a Wider Financial Statement
  6. General Journal Transaction Out Of Balance After Interface with AR
  7. How to Archive GL Data Before Year-End Closing Procedure
  8. GL Year-End Closing Checklist
  9. Do I Need to Kick My Users Out When Interfacing with Other Packages in GL?
  10. General Journal Transaction In Balance But Not Able to Post
  11. Net Income from Profit & Loss Statement Does Not Match Balance Sheet
  12. Feature - G/L Interface from Other Package Customer/Vendor/Employee Number/Name Default
  13. Error During GL Interface from Other Package and Journal Transaction Is Lost
  14. COMPRESS General Ledger Processing Compress General Ledger TRX File
  15. GLBUDMNT General Ledger Budget File Maintenance
  16. GLCMPMNT General Ledger Comparative File Maintenance
  17. GLCONSOL General Ledger Company Consolidation
  18. GLCTLMNT General Ledger G/L Setup
  19. GLDSTMNT General Ledger Distribution Code File Maintenance
  20. GLENTMNT General Ledger Financial Entity File Maintenance
  21. GLJNLLST General Ledger Journal History Report
  22. GLPRDMNT General Ledger Accounting Period File Maintenance
  23. GLPRDSCN General Ledger Period Account Balance Report
  24. GLRATSCN General Ledger Financial Ratio Report
  25. GLRECALC General Ledger Recalculate Account Balances
  26. GLRECENT General Ledger Recurring Journal Trx Processing
  27. GLSRCMNT General Ledger Source File Maintenance
  28. GLTRIALB General Ledger Trial Balance Report
  29. GLWRKSHT General Ledger Print General Ledger Worksheet
  30. INTERFAC General Ledger Interface From Other Packages
  31. TEXTMNT General Ledger Statement Text File Maintenance
  32. SRCEXREF General Ledger Source Cross Reference Report
  33. YEAREND General Ledger Year-End Procedure
  34. GLACTMNU General Ledger G/L Account File
  35. GNJINLENT General Ledger General Journal Trx Processing
  36. My Net Income (BSNI) at Balance Sheet Does Not Equal My Net Income on the P&L Statement
  37. Budget File Maintenance Questions & Answers
  38. LAYMNU General Ledger Statement Layout File Maintenance 1
  39. LAYMNU General Ledger Statement Layout File Maintenance 2
  40. LAYMNU General Ledger Statement Layout File Maintenance 3
  41. LAYMNU General Ledger Statement Layout File Maintenance 4
  42. LAYMNU General Ledger Statement Layout File Maintenance 5
  43. LAYMNU General Ledger Statement Layout File Maintenance 6
  44. LAYMNU General Ledger Statement Layout File Maintenance 7
  45. LAYMNU General Ledger Statement Layout File Maintenance: Index
  46. STMNTMNU Select and Print Financial Statements 1
  47. STMNTMNU Select and Print Financial Statements 2
  48. STMNTMNU Select and Print Financial Statements 3
  49. STMNTMNU Select and Print Financial Statements 4
  50. STMNTMNU Select and Print Financial Statements: Index
  51. Job Code Adjustment through GL Journal Entries
  52. How to Distribute Sales to General Ledger by Warehouse Location
  53. What Is the Meaning of Leading Two Letters of Journal Source in General Ledger or Distribution?

Feedback and Knowledge Base