The easiest way to get a GL CSV format template is to open any General Journal record and click on Export.
You can also download the template from this link: GL CSV Template.csv
There are two sections in the exported csv file. They are the Header and Detail.
- Header row- This corresponds to the Post Date (Column B), Currency (Column C), Reverse Date (Column D) and Journal Description (Column E) fields of the General Journal screen.
The word 'Header' is required in the A column so that system can determine if it is importing multiple journal records like what is shown below.
2. Detail row(s) - This row consists of following columns:
Account ID (Column A), Transaction Description (Column B), Document Date (Column C), Debit Credit Indicator (Column D), Debit Credit Amount (Column E), Units (Column F), Correcting (Column G), Line Number (Column H), Document (Column I),Comments (Column J) and Reference (Column K)
Account ID - Should have a matching account id in the GL Account Detail | Chart of Accounts tab.
Transaction Description - This corresponds to Transaction Description in the General Journal column grid.
Document Date - This pertains to Document Date in the General Journal column grid. Formatted as mm/dd/yyyy.
Debit Credit Indicator - This is either D or C. D for Debit Amount and C for Credit Amount.
Debit Credit Amount - When imported in Debit or Credit column of the General Journal depending on the Debit Credit Indicator.
Units - When imported in Debit Units or Credit Units column of the General Journal depending on the Debit Credit Indicator.
Correcting - The value must be either “Y” or “N”
Line Number - This determines the order of your journal line records.
Document - This is the Document column of the general journal screen.
Comments - This is the Comments column of the general journal screen.
Reference - This is the Reference column of the general journal screen.