openerp-expert-accounting team mailing list archive

[Leonardo Pistone <leonardo.pistone@xxxxxxxxxxxxxx>]

Dear Naran Moturi.

Did you publish your version of the module?

As for our version for 6.1, I will make a MP to banking-addons.

Thanks!

On Sat, Mar 29, 2014 at 2:04 AM, Naran Moturi <nmoturi@xxxxxxxxxxxx> wrote:

> Hello All,
>
> We have been using this module for our customers in Australia and is been
> a very valuable tool for our customers to reconcile paper based bank
> statements, the only small change we did was adding refresh functionality ,
> by default the current functionality assumes is to finish all the bank
> transactions before we start reconciling , our customers requested they
> should be able to reconcile the new bank transactions which were added
> after the reconciliation procedure started.
>
> Thanks,
>
> [image: Description: RU3IX Pty Ltd] <http://www.ru3ix.com.au/>
>
> *Naran Moturi*
> nmoturi@xxxxxxxxxxxx
>
> *RU3IX Pty Ltd*
> http://www.ru3ix.com.au
> This e-mail message may contain confidential or legally privileged
> information and is intended only for the use of the intended recipient(s).
> Any unauthorized disclosure, dissemination, distribution, copying or the
> taking of any action in reliance on the information herein is prohibited.
> E-mails are not secure and cannot be guaranteed to be error free as they
> can be intercepted, amended, or contain viruses. Anyone who communicates
> with us by e-mail is deemed to have accepted these risks. RU3IX Pty Ltd is
> not responsible for errors or omissions in this message and denies any
> responsibility for any damage arising from the use of e-mail. Any opinion
> and other statement contained in this message and any attachment are solely
> those of the author and do not necessarily represent those of the company.
>
> On 29 Mar 2014, at 3:23 am, Leonardo Pistone <
> leonardo.pistone@xxxxxxxxxxxxxx> wrote:
>
> 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"
>>
>
> _______________________________________________
> 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
>
>
>