openerp-expert-accounting team mailing list archive

[Leonardo Pistone <leonardo.pistone@xxxxxxxxxxxxxx>]

DP Hicks, thanks you for your explanation and your work.

As for the 6.1 backport, is it OK for you if I propose it for merging into
lp:banking-addons/6.1, or you have any other suggestion?


On Fri, Mar 28, 2014 at 5:10 PM, DP Hicks <dphicks@xxxxxxxxxxxxxxxxxx>wrote:

> Hello All,
>
> This is D.P. Hicks the owner of NovaPoint Group, Inc. here in the U.S.
>
> Thank you all for doing the due diligence necessary to further understand
> this module.  NovaPoint Group continues to build out what we call "Banking
> Requirements" here in the U.S. but, as said in a post earlier, this is not
> just U.S. functionality.
>
> OpenERP Bank Reconciliation does a lot to deal with the electronic
> transactions that EU banking entities deal with.  Here in the US and, from
> Savoirfairelinux's post, in Canada as well we deal with 2 sets of entries
> (transactions).  By that I mean we receive paper bank statements that are
> monthly balance and transaction related summaries that we use to balance
> our accounts.  There is another set of functionality that some banks offer
> while others don't which is OFX transmissions allowing the software to
> download daily transactional files and compare against internal banking
> legders (not journals as OpenERP has established).
>
> In the very near future you will see quite a bit of updated BANKING
> functionality we've been working on but for this purpose the Bank
> Reconciliation functionality was created to allow U.S. users of OpenERP to
> balance hardcopy monthly banking statements provided from their bank per
> account and balance.
>
> I hope this helps and here is a document sharing how this functionality
> started.  We're continuing to enhance this functionality with Check Logs
> and other functionality that will be quite interesting to all shortly.
>
> To specifically answer the questions about the 4 bank accounts it's how I
> run things internal NPG today.  In order to minimize fraud and keep banking
> more secure we propose 4 bank accounts.  1st is the Master/Operating
> account.  This account is the main account that money flows in and out of
> but no checks written, ACHs transacted, etc.  The 2nd account is your
> accounts payable account.  Here the Master/Operating account funds the A/P
> account with ONLY the amount necessary to support all bills paid and
> upcoming electronic transactions.  This helps fraudulent activity to be
> transacted against your main Master/Operating account.  3rd is the A/R
> account.  All deposits are deposited here and then moved over to the
> Master/Operating account.  Finally is the Payroll account.  Again like the
> A/P this account is funded for Payroll related transactions like FUTA,
> SUTA, Unemployment Compensation Insurance, etc.
>
> Thanks for reading my post.
>
> --
> D.P. Hicks
> President
> NovaPoint Group LLC
> 810.531.1777
> www.novapointgroup.com
> "OpenERP 2012 Partner of the America's"
>
>
> On Fri, Mar 28, 2014 at 10:48 AM, Marc Cassuto <
> marc.cassuto@xxxxxxxxxxxxxxxxxxxx> wrote:
>
>> 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
>>
>> ------------------------------
>>
>> *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
>>
>>
>>
>> _______________________________________________
>> 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
>>
>>
>
>
> --
> D.P. Hicks
> President
> NovaPoint Group LLC
> 810.531.1777
> www.novapointgroup.com
> "OpenERP 2012 Partner of the America's"
>