Standard GL Export Interface

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",""

 

Be the first to review this article