Import Bank Statement Lines from Excel
Import Bank/Cash Statement Lines from Excel - Odoo App
This app allows you to Import Bank Statement Lines from Excel files into Odoo.
- This app will allow you to import Bank and Cash Statements lines from bank statement / cash statement form view using import button.
- You have to prepare an excel file with Date, Label, Partner, Reference and Amount and import it as shown per sample.
- Sample Excel File is available inside the sample folder inside the app.
Following fields can be Import From Excel Column.
- Date : Date for Transaction.
- Lable : Lable for Transaction.
- Partner : Partner Name for Transaction.
- Reference : Reference for Transaction
- Amount : Amount for Transaction
Make sure you have xlrd Python module installed. https://pypi.python.org/pypi/xlrd
For more details please see Video in Live Preview section. Excel sample is available inside module.