Collector_CSV_Import.xls

The Collector_CSV_Import.xls template applies to the Collector CSV Upload. Please keep header line unchanged and save your document as csv format.

The basic format of the template is shown below.

Collector CSV Upload Import template format

Column	Field Name
A	Doc_Type*
B	Origination Code*
C	Fiscal_Year
D	Fiscal_Period
E	Chart
F	Account
G	Sub_Acct
H	Object
I	Sub_Obj
J	Project
K	Org_Ref_ID
L	Line_Description
M	Amount
N	DocType_OriginCode_FiscalYear_FiscalPeriod_Chart_Account_Object_Amount_are_required