Page History

The easiest way to get a GL CSV format template is to open any General Journal record and click on Export.

Image Added

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.

1. 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.

Image Added

Image Added

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.

Image Added

    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)

Image Added

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.