This question has been flagged
1 Reply
3929 Views

Hi guys, can anyone tell me if there's a simple way to export income statements and bank statements to excel/csv? thanks in advance

Avatar
Discard
Best Answer

1) create a bank statement record (for instance for the current month; you name it as you like: "bank stat for may 2014")

2) This name will be the first column of the bank file (csv) you plan to import. It is given only on the first line of your csv file

3) The second column must refer to the bank account of the company (the one set up into OpenErp). It is given only on the first line of your csv file

4) ONE single column for the amounts (be careful because the debits shown by the bank correspond to a credits into your books (and vice-versa for credits) (this is because the banks are reporting what is into their own books). Thus this column contains both debits (positive) and credits (negative) amounts

OBI is the name for the description of the transaction

Statement, Account, Date, OBI, Amount,

 

Avatar
Discard