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.

1

how Bank Reconciliation works in OpenERP?

By
sunil
on 3/29/13, 6:59 AM 5,356 views

Manual Reconciliation ????

5

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 4/2/13, 9:29 AM

A reconciliation process in accounting consists in matching entries made in the various accounts; the objective is to identify unmatched entries for a possible future investigation (errors etc); this is specifically used on accounts receivable/payable between the debits and credits: for instance, an unmatched debit entry on a customer account may indicate that this customer is owing you that unmatched entry; the reverse for a supplier.

For "bank reconciliation", the objective is identical: identify the debits & credits as recorded by you into your company's accounting book which are not (yet) recorded by your bank(s) into their own book (your bank account statement) and symetrically identify debits or credits recorded by the bank and not (yet) by you. Such a bank reconciliation allows also to detect errors made by each of the parties.

OpenErp allows you to key in - entry by entry and manually - the payments you have made or the payment received; this is done with the bank journal and entries are posted to the corresponding bank accounts. As far as I understand how OpenErp works these entries must be limited to payments NOT already recorded by the automated processes - those customers' or suppliers' invoices with a > NON PAID STATUS

  • or by the import of a file - each individual debit or credit the bank statement (that you first downloaded from your Bank system). When importing such a file - which by default contains every debits and credits recorded by the bank-, you will duplicate some entries into your system -the ones that have been already posted thru the automated process provided by OpenErp. To avoid such duplication either you delete potential duplicates BEFORE THE IMPORT OR BEFORE CLICKING ON CONFIRM (after the import)

Am I right saying this?

3

ton123

--ton123--
1418
| 5 6 9
Lisse, Netherlands
--ton123--
End-User. Installed 6.1.1 on a DS412+, DS211+ and DS113J Synology NAS. Reference installation on Ubuntu 12.04/Samsung Notebook. 12-03-2013 In production for Suppliers and Customers, adresbook. 7 small companies. Testing accounting, document management, import and export. Too much showstoppers I haven't fixed at this moment. 06-05-2013 little progress. Migration to v7 impossible because of missing Dutch localisation modules. What I see working is nice, so further testing and asking. Start testing products and warehouse. Happy with this forum and the community.
ton123
On 3/29/13, 7:01 AM

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: 3/29/13, 6:59 AM
Seen: 5356 times
Last updated: 2/20/16, 4:36 AM