Odoo Help

Welcome!

This community 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.

0

How do I export income/bank statements?

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

 

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

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