openerp-expert-accounting team mailing list archive

[DP Hicks <dphicks@xxxxxxxxxxxxxxxxxx>]

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"

Attachment: BankAccountReconciliation7_Documentation.doc
Description: MS-Word document