Odoo Help

0

How do I export income/bank statements?

By
Jarryd Putter
on 5/15/14, 6:59 AM 1,103 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

0

michel Guénard

--michel Guénard--
1043
| 5 5 8
VIROFLAY, France
--michel Guénard--

VP operations & finance Social entrepreneur Certified Public Accountant Past Chief internal auditor

michel Guénard
On 5/21/14, 4:43 AM

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,

 

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)

Stats

Asked: 5/15/14, 6:59 AM
Seen: 1103 times
Last updated: 3/16/15, 8:10 AM