openerp-expert-accounting team mailing list archive

[Marc Cassuto <marc.cassuto@xxxxxxxxxxxxxxxxxxxx>]

Hello Leonardo, 

I could not tell in UK, but in Quebec we use the same word and expect the same result. 

Moreover, after testing, I have some questions : 
* where is the link between the 4 recommended accounts (Master Bank Account, Bank (AR) Account Checking, Bank Payroll Account and Bank Payable Account Checking) ? 
* why does the module import only the balance of a bank statement and not all its entries ? 
* is there a report to print so that the accountant can keep track of its bank reconciliation process before closing the period ? 

Regards, 
Marc 

== 
Marc Cassuto, Ing. MBA Itil 

SAVOIR-FAIRE LINUX 
Consultant solutions ERP 
T: 514-276-5468 #180 

----- Original Message -----

> From: "Leonardo Pistone" <leonardo.pistone@xxxxxxxxxxxxxx>
> To: "Pedro Manuel Baeza Romero" <pedro.baeza@xxxxxxxxx>
> Cc: openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
> Sent: Friday, March 28, 2014 10:41:46 AM
> Subject: Re: [Openerp-expert-accounting] module for bank account
> reconciliation

> Thanks Pedro.

> Being the module written by a US company, I assume the name to be
> correct at least in the US. Can anyone from the UK confirm if the
> module name sounds good to them?

> As for the model, it is a new one that does not inherit anything. I
> agree with that: the logic seems to be very different from the
> openerp statement object.

> I will proceed with a MP then.

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

> > Yeah, I see, in Spain that is called "punteo" or the verb
> > "puntear",
> > that is literally traduced as "to dot". Maybe we need to find the
> > exact verb in English that is used for this task.
> 

> > It is very interesting indeed. One more question: is that made
> > using
> > normal bank statements, or does it use another different model?
> 

> > BTW, I agree with its inclusion on OCA banking-payment repository.
> > If
> > you don't have to make any job but remove npg_ prefix, I would say
> > that you can make the MP and discuss there if anyone doesn't agree.
> 

> > Regards.
> 

> > 2014-03-28 15:22 GMT+01:00 Leonardo Pistone <
> > leonardo.pistone@xxxxxxxxxxxxxx > :
> 

> > > 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
> > > > 
> > > 
> > 
> 

> _______________________________________________
> 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