Excel Formats for Bank Statements
Excel File Type Read the Excel file types to be used for import. Excel Sheet Name Excel Sheet Name, should be as default Voucher Type Name for the respective voucher type. Example, for sales vouchers, sheet name should be “Sales” For purchase vouchers, sheet name should be “Purchase” For debit…
Excel File Type Read the Excel file types to be used for import. Excel Sheet Name Sheet name should be as the Name of the Master Type and without space in the name. Example, for Ledger Master, sheet name should be as “Ledger”, For Stock Item Master, sheet name should be as “StockItem”…
There are two types of Excel formats available for Receipts & Payments. Simple Columnar Formats Multi Line Formats
1. Excel File Type Check the Excel file types to be used for import.
Below are the types of errors may arise during import
Excel file type and Formats
Excel File Type Excel file should be in “.xls” formats only Use Save as option in file menu for saving excel file in *.xls format. In save as from, in Save as type, choose > Excel 97-2003 Workbook (*.xls), then save the file.