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 follow the exact order as presented below; if this order is not exact the import will be unsuccessful. The header rows are not themselves imported, but define the layout of the subsequent data rows which will be imported. Any error in a data row will result in the entire voucher being rejected by the import, but other vouchers will still be imported. The import screen will display any errors that occur and will provide record counts.

If you leave a data field blank, the import will skip that field and not change the data that exists in that field. If you try to import data into a text field and that data is longer than what the text field can accept, your data will be imported but the excess data will be truncated. For example, the employee name fields are limited to 50 characters. If you try to import a name that exceeds 50 characters, the excess characters will get cut off.

This import is for adding multiple move vouchers, and it will not update existing vouchers. This import cannot be “undone”. If necessary, the imported data can be manually changed or deleted using the internal voucher screen, after the import completes.