openerp-expert-accounting team mailing list archive

[Naran Moturi <nmoturi@xxxxxxxxxxxx>]

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,


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