The Standard GL Export Interface layout is comma-delimited text file that is available in two formats, detailed and summary and both include a header record. The Detailed file has the following layout and parameters.
Parameters
Memo – User typed text field, maximum of 50 characters.
Employee Identification
Drop down list if the employee information should be included for each line item. Options are:
- Blank
- Employee Number
- Employee Number + Surname + First Name
- Employee Number + First Name + Surname
Layout
Account_number | General Ledger Account to post too |
Debit_Amount | The debit amount of the transaction |
Credit_Amount | The credit amount of the transaction |
Transaction_Description | A General description of the line item |
Batch_Date | Batch or Posting date of the transaction |
Memo | User defined description/memo field |
Check_Number | |
Employee_identification | See above |
Sample file - Standard G/L Details Export file:
ACCOUNT_NUMBER,DEBIT_AMOUNT,CREDIT_AMOUNT,TRANSACTION_DESCRIPTION,BATCH_DATE,MEMO,CHECK_NUMBER,EMPLOYEE_IDENTIFICATION
"1414",90.72,0.00,"Employment insurance (ER)","08/16/2019","Payroll","","004"
"1414",189.13,0.00,"Canada pension plan (ER)","08/16/2019","Payroll","","004"
"1515",0.00,90.72,"Employment insurance (ER)","08/16/2019","Payroll","","004"
"1616",0.00,189.13,"Canada pension plan (ER)","08/16/2019","Payroll","","004"
"2222",0.00,3294.31,"Net pay","08/16/2019","Payroll","","004"
"4455",0.00,397.44,"Federal income tax","08/16/2019","Payroll","","004"
"5656",40.00,0.00,"WCB/WSIB","08/16/2019","Payroll","","004"
"56566",0.00,40.00,"WCB/WSIB","08/16/2019","Payroll","","004"
"6262",0.00,189.13,"Canada pension plan","08/16/2019","Payroll","","004"
"6666",0.00,54.32,"302A","08/16/2019","Payroll","","004"
"702",68.93,0.00,"702A","08/16/2019","Payroll","","004"
"702",0.00,68.93,"702A","08/16/2019","Payroll","","004"
"7777",0.00,64.80,"Employment insurance","08/16/2019","Payroll","","004"
"8989",4000.00,0.00,"Salary","08/16/2019","Payroll","","004"
The Summary file has the following layout and parameters
Parameters
Memo – User defined text field, maximum of 50 characters
Layout
Account_number | General Ledger Account to post too |
Debit_Amount | The debit amount of the transaction |
Credit_Amount | The credit amount of the transaction |
Transaction_Description | A General description of the line item |
Batch_Date | Batch or Posting date of the transaction |
Memo | User defined description/memo field |
Sample file - Standard G/L Summary Export File:
ACCOUNT_NUMBER,DEBIT_AMOUNT,CREDIT_AMOUNT,TRANSACTION_DESCRIPTION,BATCH_DATE,MEMO
"1414",189.13,0.00,"Canada pension plan (ER)","08/16/2019",""
"1414",90.72,0.00,"Employment insurance (ER)","08/16/2019",""
"1515",0.00,90.72,"Employment insurance (ER)","08/16/2019",""
"1616",0.00,189.13,"Canada pension plan (ER)","08/16/2019",""
"2222",0.00,3294.31,"Net pay","08/16/2019",""
"4455",0.00,397.44,"Federal income tax","08/16/2019",""
"5656",40.00,0.00,"WCB/WSIB","08/16/2019",""
"56566",0.00,40.00,"WCB/WSIB","08/16/2019",""
"6262",0.00,189.13,"Canada pension plan","08/16/2019",""
"6666",0.00,54.32,"302A","08/16/2019",""
"702",68.93,0.00,"702A","08/16/2019",""
"702",0.00,68.93,"702A","08/16/2019",""
"7777",0.00,64.80,"Employment insurance","08/16/2019",""
"8989",4000.00,0.00,"Salary","08/16/2019",""
