CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
From Wiki "Reconciliation refers to a process that compares two sets of records (usually the balances of two accounts) to make sure they are in agreement" - Ok!
For our Sins we used to use Sage! We would 1. Create an Invoice in the system (purchase or sale) 2. The client would send us a remittance saying they'd paid or we would pay our supplier 3. We would reconcile the bank statement balance and entries against all the bank entries in the system, to check that the payments had cleared and balances match. Ok so far!
With Openerp when we come to reconciling the bank statement (currently just manually importing the Invoices) we find the transactions aren't their, it appears this is because they have already been reconciled! We ASSuME this has something to do with when we make the payment e.g. following the clients remittance the reconciled box has been ticked?
We also use the "account_transfer" module for bank to bank transfers, these also don't appear on the import list - we ASSuME this has something to do the stages "Confirm" and "Done"
So my question please... Is Reconciliation in OpenERP "marking invoices as paid" or "matching paid and unpaid invoices to the bank statement"?
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
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?
About This Community
Odoo Training Center
|Asked: 4/18/13, 6:34 AM|
|Seen: 9195 times|
|Last updated: 6/29/16, 8:42 AM|