The import file must be a comma delimited(.csv) file. An excel file can easily be saved as a comma delimited(.csv) file by selecting the File >> Save As option and changing the Save As Type field to “CSV (Comma Delimited) (*.csv)”. Each column heading needed for the import file is listed below. The import file must contain the exact Column Name listed below. The import uses the column names in the first row to know what type of data is in the column.
The import logic expects the column headings to be in the first row/line of the import file. The second row/line of the file is the first row that it tries to import. If an error occurs on any row (expense), it will skip the entire voucher process whatever rows (expenses/vouchers) it can. The import screen will display any errors that occur and will provide record counts.