Journal Entry Import Format
General ledger journal entries can be imported into Paradigm from a .csv text file. The import file has two different formats, one for header entries and another for detail entries.
Example: H,01/20/2019,Payroll Import,DEPT
LineType, GLAccountNumber, GLDepartmentCode,Description,Debit, Credit
Example: D,1-1100,DEPT,Net Payroll From Checking,0,5510.25
LineType – Must be a value of “H” to indicate a Header line.
Date – The posting date of the journal entry in MM/DD/YYYY format.
Reference – The description of the journal entry.
GLDepartmentCode – (Optional) – A GL Department code that matches a Paradigm GL Department code.
LineType – Must be a value of “D” to indicate a Detail Line.
GLAccountNumber – A GL Account Number that matches a GL Account number found in the Paradigm Chart of Accounts.
GLDepartment – A GL Department code that matches a Paradigm GL Department code. If blank, the default department will be assigned by the import procedure.
Description – The description or memo for the journal line.
Debit – The line item amount if it’s a Debit line item.
Credit – The line item amount if its a Credit line item. (Note that a line item cannot contain both a Debit and Credit Amount. Use value of 0 for the field that does not contain an amount)
JobID – Optional – If used, it must match an existing Paradigm Job ID.
JobPhase – Optional – If used, it must match a phase for the provided Job ID.
Job Phase Classification – Optional – If used, it must match a classification for the Job Phase.
The import file must start with a Header Line, followed by the associated Detail lines like the example below. A file may contain multiple Header/Detail sections, a new journal entry will be created for each one.
D,1-1100,DEPT,Net Payroll From Checking,0,5510.25
D,6-1426,DEPT,Employer Tax Expense,410.25,0
Import Example with Job Info:
D,1-1100,DEPT,Net Payroll From Checking,0,5510.25,JOB-00000,Phase 1,Labor
D,6-1140,DEPT,Payroll Wages,5100,0,JOB-00000,Phase 1,Labor
D,6-1426,DEPT,Employer Tax Expense,410.25,0,JOB-00000,Phase 1,Labor