Odoo Help


2 Answers

Mustufa Rangwala (mra) India

--Mustufa Rangwala (mra)--
| 2 1 4
Ahmedabad, India
--Mustufa Rangwala (mra)--

- Around 7+ years of strong experience in Odoo (Formerly OpenERP) which is world's largest Open Source Business Applications driven by CEO Fabien Pinckaers. - Played key role in developing and maintaining various Odoo Product modules and integrating them on Open Source ERP Environment. - Experience on Scrum methodology for project management - Experience in Team Building - Quick Start Implementations. - Worked on almost all versions (4.0, 5.0, 6.0, 6.1, 7.0, SAAS, Trunk(8.0)...) of Odoo (Formerly OpenERP) . Specialities: Odoo Business Process And OpenERP Implementation. Odoo Application Support and Maintenance. Odoo Technical & Functional Training. Business Process Mapping & Gap Analysis (Functional and Technical Analysis)

Mustufa Rangwala (mra) India
4/18/13, 8:10 AM

When you import invoices in bank statement means you are importing only unpaid invoices on it and which will be paid after validating your bank statements.

So basically whatever accounting entries/ Journal entries created by Invoices will be linked with bank statements. (You can find bank statement reference on journal items.)

Hope this help.

Regards, Mustufa Rangwala

Cameron United Kingdom
4/18/13, 8:27 AM

Cheers, So! My thinking is!
We Validate the Invoice And when a customer pays us, we acknowledge the payment (using Customer Payments) but do NOT Validate it?.. Same with Suppliers! Then hopefully we use the Bank Reconciliation process to Validate!

Mustufa Rangwala (mra) India
4/18/13, 8:48 AM

That flow is also correct.. but in OpenERP 6.1 version OpenERP allow to select you the Payment (Your draft customer/supplire payments) on bank statement lines but now in 7.0 its not possible so it create customer/supplier payment new does not link your existing draft payments.. Need to check this case ..

Cameron United Kingdom
4/18/13, 8:52 AM

Thanks again!

You say "That flow is ALSO correct."

What flow would you use?

Mustufa Rangwala (mra) India
4/18/13, 9:01 AM

Cameron, I am not accountant but I can say how normally accountant can do.. They create invoice and once end of day/week/month they received bank statement and find the payment from customer they import the invoice and reconcile/paid it.. But some time it may happen accountant has to create customer payment before receiving bank statements (Cheque given and deposited) so they just create customer payment again that invoice and validate it, after receiving bank statement they can directly reconcile bank statement with existing payment (Bank Statement reconciliation..) ..

Cameron United Kingdom
4/18/13, 9:36 AM

Many many thanks!

I will proceed with the knowledge and report back how I get on!

Cameron United Kingdom
4/29/13, 7:04 AM

I know believe my problems stems from not being an accountant!

Any skills or methods that I have come from using "Sage 50" which although is a DEBKeeping package its tailored for muppets like me!

Sage's version of "reconciliation" is a wizard type module where you select every entry against the statement.

Being a muppet I was trying to replicate this, when all I needed to do was 'with a pencil' tick every entry on the bank statement that appeared in the Journal, and ensure closing balances match! KISS

Kevin United Kingdom
1/13/15, 6:47 AM

Hi Cameron,

I too have reached this point having come from the world of Sage (currently parallel running).  I have tried to understand what we need to do here to be able to reconcile a bank statement and looked for an answer but am still struggling to understand the process in Version 7.

We have started to 'pay' our customer invoices so the aged debtors on sage and Open ERP can be reconciled, this process is going well.  The next logical step on from here (in the sage world) is to look at bank statement and to match the paper statement to the transactions in Sage.  Similar to you I presumed the creation of a bank statement in Open ERP would ‘pull’ in all of the payment transactions etc. for the period requested so we could tick off the transaction and find and enter any missing bank transactions, this is not what is currently happening.

Did you find a way to allow from a fellow sage user point of view?

Many thanks,




Ask a Question
Keep Informed
1 follower(s)
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.

Odoo Training Center

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

Test it now