← Back to team overview

openerp-expert-accounting team mailing list archive

Re: module for bank account reconciliation

 

The user chooses an account and a start/end date (end date is optional).
The move lines in the chosen account/date are shown, and the user can
select manually those that are also in the paper statement and that are
correct.

At the end, selected move lines are checked with a flag (new field in the
move line) so that they do not appear anymore in a subsequent statement.

That process allows to streamline the manual check of the lines on OpenERP
against a bank statement and:

- fix incorrect data in OpenERP
- introduce a workflow to verify bank account data in OpenERP: the approval
process in that module has 2 steps, performed by a "Preparer" user and by a
"Verifier" user.
- identify fraud
- identify missing data in OpenERP (for example, bank charges)
- identify missing data from the bank (for example, a check that has not
been cashed yet).

That usage of the word "reconciliation" is different from how we see it
usually on OpenERP, where it refers to reconciling payables and receivables
in the software.

Best,
Leonardo


On Fri, Mar 28, 2014 at 3:05 PM, Pedro Manuel Baeza Romero <
pedro.baeza@xxxxxxxxx> wrote:

> Hi, Leonardo,
>
> Could you please ellaborate a little more the functionality that adds this
> module?, so that we can judge if it's interesting enough.
>
> Thanks for the initiative.
>
> Regards.
>
>
> 2014-03-28 15:03 GMT+01:00 Leonardo Pistone <
> leonardo.pistone@xxxxxxxxxxxxxx>:
>
>> Dear accounting experts,
>>
>> In the OpenERP US localisation there is an interesting module:
>> npg_bank_account_reconciliation. The module makes it easy to reconcile a
>> paper bank statement with the corresponding account in OpenERP.
>>
>> The module has been developed by NovaPoint Group, who I thank for the
>> great work.
>>
>> The module doesn't have anything specific to the US actually, and we find
>> it interesting in Europe, too. We backported it to 6.1 here:
>>
>>
>> https://code.launchpad.net/~camptocamp/+junk/npg_bank_reconciliation_backport_6.1
>>
>> Do you think that module is a good fit for an OCA project like
>> lp:banking-addons?
>>
>> In case of OCA inclusion, I would remove npg_ from the name, and
>> obviously keep all other references to the original author.
>>
>> For 6.1, the module is not on openerp-usa so there is no conflict.
>>
>> Thanks!
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~openerp-expert-accounting
>> Post to     : openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~openerp-expert-accounting
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>

Follow ups

References