You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Pierre Smits <pi...@gmail.com> on 2008/11/02 23:13:45 UTC
How to process bank statements
On bank statements in The Netherlands we have
- (partial) payments by customers
- (partial) payments to suppliers
- payment of bank costs and others
Where and how do I process these in OFBiz?
Regards,
Pierre
Re: What Java Memory options are you using
Posted by BJ Freeman <bj...@free-man.net>.
look at the startofbiz.bat or startofbiz.sh
Mark Grennan sent the following on 11/10/2008 3:01 PM:
> I am curious about the amount of memory and the Java start up memory settings
> everyone is using.
> Please post both and why.
>
>
> Mark Grennan
> Data Center Manager
> Crossroads Wireless
> 5 North McCormick St.
> Oklahoma City, OK 73127
> Desk: 405 694-2100 x3119
> Cell: 405 343-9332
>
>
What Java Memory options are you using
Posted by Mark Grennan <ma...@crossroads.us>.
I am curious about the amount of memory and the Java start up memory settings everyone is using.
Please post both and why.
Mark Grennan
Data Center Manager
Crossroads Wireless
5 North McCormick St.
Oklahoma City, OK 73127
Desk: 405 694-2100 x3119
Cell: 405 343-9332
Re: How to process bank statements
Posted by BJ Freeman <bj...@free-man.net>.
Ok, was going to do that once I got some sleep.
may do more.
:)
Jacques Le Roux sent the following on 11/9/2008 6:58 AM:
> Thanks BJ, and Pierre for comment,
>
> I have just reformatted a bit the page for an easier reading
>
> Jacques
>
> From: "BJ Freeman" <bj...@free-man.net>
>> I will start
>> http://docs.ofbiz.org/display/OFBIZ/How+to+process+bank+statements
>>
>>
>> Jacques Le Roux sent the following on 11/9/2008 3:26 AM:
>>> There are an interesting comments in this thread (I mean
>>> http://www.nabble.com/How-to-process-bank-statements-td20294429.html)
>>> I would suggest to create a Wiky entry to collect informations and make
>>> them more available for others to comment... even later... In the same
>>> spirit than the VAT page for instance
>>> http://docs.ofbiz.org/display/OFBIZ/VAT
>>>
>>> Thanks
>>>
>>> Jacques
>>>
>>> From: "BJ Freeman" <bj...@free-man.net>
>>>> This is at the third party software level.
>>>> the SECAS will check that the proper routing number(tied to Geo) and
>>>> account format for the bank.
>>>> the validation is to run a validation on the bank account for a $1.00.
>>>> the interaction between banks is based on agreements (entity) and a
>>>> page
>>>> from the Trading partners data used currently. I brief review of the
>>>> Oagis looks like it has a similar structure.
>>>>
>>>> Pierre Smits sent the following on 11/7/2008 7:06 AM:
>>>>> Addendum 2.
>>>>>
>>>>> Bank account ID's are normalized per country. And international
>>>>> harmonization is in effect. This should be taken into consideration
>>>>> when
>>>>> defining a solution how to store bank account details.
>>>>>
>>>>> On Fri, Nov 7, 2008 at 4:04 PM, Pierre Smits <pi...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Addendum
>>>>>>
>>>>>> Is using attributes on a Party not a better idea. That way it also
>>>>>> usable
>>>>>> for employees, who get paid electronically (the generic way to pay
>>>>>> employees
>>>>>> in The Netherlands). The attribute should then be selectable in
>>>>>> stead of
>>>>>> free text.
>>>>>>
>>>>>> On Fri, Nov 7, 2008 at 3:55 PM, Pierre Smits
>>>>>> <pi...@gmail.com>wrote:
>>>>>>
>>>>>>> BJ,
>>>>>>>
>>>>>>> I can follow your reasoning. And it would be the simplest thing to
>>>>>>> do for
>>>>>>> customers (Bill-to role?) and Suppliers.
>>>>>>> Using ContactMechs for displaying bank related info in
>>>>>>> communications and
>>>>>>> transaction documents (e.g. purchace and sales orders, invoices)
>>>>>>> would be
>>>>>>> the easiest route to go.
>>>>>>> But these details may not be editable by everyone who can just add
>>>>>>> ContactMechs (preferrably restricted to persons in some kind of
>>>>>>> accounting
>>>>>>> role).
>>>>>>>
>>>>>>> But for the organisations using OFBiz (company and subsidiaries)
>>>>>>> this is a
>>>>>>> bit more complex. A bank account is more than just a ContactMech.
>>>>>>> It is a
>>>>>>> part of the accounting schemas and needs to be auditable....That is
>>>>>>> what the
>>>>>>> transactions in the general ledger (and AP and AR, etc) are for.
>>>>>>>
>>>>>>> A CFO doesn't care less what everybody does with ContactMechs as
>>>>>>> long as
>>>>>>> his part of the system (FICO, AP, AR, etc) are in order and
>>>>>>> auditable.
>>>>>>>
>>>>>>> Regards,
>>>>>>>
>>>>>>> Pierre
>>>>>>>
>>>>>>>
>>>>>>> On Fri, Nov 7, 2008 at 3:14 PM, BJ Freeman <bj...@free-man.net>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> 1) it is easy for the user to put in and change info.
>>>>>>>> 2) to me, that is what the info is, How to get to your bank
>>>>>>>> account, or
>>>>>>>> contact the supplier, or how to get a credit on an order.
>>>>>>>> 4) by making different types of Contact mechs, the program can
>>>>>>>> decide
>>>>>>>> what contact mech to use.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Jacques Le Roux sent the following on 11/7/2008 5:24 AM:
>>>>>>>>> Hi BJ,
>>>>>>>>>
>>>>>>>>> From: "BJ Freeman" <bj...@free-man.net>
>>>>>>>>>> I have adopted using the Contact Mechs instead of properties
>>>>>>>>>> to put
>>>>>>>> the
>>>>>>>>>> bank info for. however that is not the way it is done in ofbiz
>>>>>>>>>> at this
>>>>>>>>>> time.
>>>>>>>>> What did you make this choice (just curious) ?
>>>>>>>>>
>>>>>>>>> Thanks
>>>>>>>>>
>>>>>>>>> Jacques
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>
Re: How to process bank statements
Posted by Jacques Le Roux <ja...@les7arts.com>.
Thanks BJ, and Pierre for comment,
I have just reformatted a bit the page for an easier reading
Jacques
From: "BJ Freeman" <bj...@free-man.net>
>I will start
> http://docs.ofbiz.org/display/OFBIZ/How+to+process+bank+statements
>
>
> Jacques Le Roux sent the following on 11/9/2008 3:26 AM:
>> There are an interesting comments in this thread (I mean
>> http://www.nabble.com/How-to-process-bank-statements-td20294429.html)
>> I would suggest to create a Wiky entry to collect informations and make
>> them more available for others to comment... even later... In the same
>> spirit than the VAT page for instance
>> http://docs.ofbiz.org/display/OFBIZ/VAT
>>
>> Thanks
>>
>> Jacques
>>
>> From: "BJ Freeman" <bj...@free-man.net>
>>> This is at the third party software level.
>>> the SECAS will check that the proper routing number(tied to Geo) and
>>> account format for the bank.
>>> the validation is to run a validation on the bank account for a $1.00.
>>> the interaction between banks is based on agreements (entity) and a page
>>> from the Trading partners data used currently. I brief review of the
>>> Oagis looks like it has a similar structure.
>>>
>>> Pierre Smits sent the following on 11/7/2008 7:06 AM:
>>>> Addendum 2.
>>>>
>>>> Bank account ID's are normalized per country. And international
>>>> harmonization is in effect. This should be taken into consideration when
>>>> defining a solution how to store bank account details.
>>>>
>>>> On Fri, Nov 7, 2008 at 4:04 PM, Pierre Smits <pi...@gmail.com>
>>>> wrote:
>>>>
>>>>> Addendum
>>>>>
>>>>> Is using attributes on a Party not a better idea. That way it also
>>>>> usable
>>>>> for employees, who get paid electronically (the generic way to pay
>>>>> employees
>>>>> in The Netherlands). The attribute should then be selectable in
>>>>> stead of
>>>>> free text.
>>>>>
>>>>> On Fri, Nov 7, 2008 at 3:55 PM, Pierre Smits
>>>>> <pi...@gmail.com>wrote:
>>>>>
>>>>>> BJ,
>>>>>>
>>>>>> I can follow your reasoning. And it would be the simplest thing to
>>>>>> do for
>>>>>> customers (Bill-to role?) and Suppliers.
>>>>>> Using ContactMechs for displaying bank related info in
>>>>>> communications and
>>>>>> transaction documents (e.g. purchace and sales orders, invoices)
>>>>>> would be
>>>>>> the easiest route to go.
>>>>>> But these details may not be editable by everyone who can just add
>>>>>> ContactMechs (preferrably restricted to persons in some kind of
>>>>>> accounting
>>>>>> role).
>>>>>>
>>>>>> But for the organisations using OFBiz (company and subsidiaries)
>>>>>> this is a
>>>>>> bit more complex. A bank account is more than just a ContactMech.
>>>>>> It is a
>>>>>> part of the accounting schemas and needs to be auditable....That is
>>>>>> what the
>>>>>> transactions in the general ledger (and AP and AR, etc) are for.
>>>>>>
>>>>>> A CFO doesn't care less what everybody does with ContactMechs as
>>>>>> long as
>>>>>> his part of the system (FICO, AP, AR, etc) are in order and auditable.
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>> Pierre
>>>>>>
>>>>>>
>>>>>> On Fri, Nov 7, 2008 at 3:14 PM, BJ Freeman <bj...@free-man.net>
>>>>>> wrote:
>>>>>>
>>>>>>> 1) it is easy for the user to put in and change info.
>>>>>>> 2) to me, that is what the info is, How to get to your bank
>>>>>>> account, or
>>>>>>> contact the supplier, or how to get a credit on an order.
>>>>>>> 4) by making different types of Contact mechs, the program can decide
>>>>>>> what contact mech to use.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Jacques Le Roux sent the following on 11/7/2008 5:24 AM:
>>>>>>>> Hi BJ,
>>>>>>>>
>>>>>>>> From: "BJ Freeman" <bj...@free-man.net>
>>>>>>>>> I have adopted using the Contact Mechs instead of properties to put
>>>>>>> the
>>>>>>>>> bank info for. however that is not the way it is done in ofbiz
>>>>>>>>> at this
>>>>>>>>> time.
>>>>>>>> What did you make this choice (just curious) ?
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>>
>>>>>>>> Jacques
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>
>>>
>>
>>
>
Re: How to process bank statements
Posted by BJ Freeman <bj...@free-man.net>.
I will start
http://docs.ofbiz.org/display/OFBIZ/How+to+process+bank+statements
Jacques Le Roux sent the following on 11/9/2008 3:26 AM:
> There are an interesting comments in this thread (I mean
> http://www.nabble.com/How-to-process-bank-statements-td20294429.html)
> I would suggest to create a Wiky entry to collect informations and make
> them more available for others to comment... even later... In the same
> spirit than the VAT page for instance
> http://docs.ofbiz.org/display/OFBIZ/VAT
>
> Thanks
>
> Jacques
>
> From: "BJ Freeman" <bj...@free-man.net>
>> This is at the third party software level.
>> the SECAS will check that the proper routing number(tied to Geo) and
>> account format for the bank.
>> the validation is to run a validation on the bank account for a $1.00.
>> the interaction between banks is based on agreements (entity) and a page
>> from the Trading partners data used currently. I brief review of the
>> Oagis looks like it has a similar structure.
>>
>> Pierre Smits sent the following on 11/7/2008 7:06 AM:
>>> Addendum 2.
>>>
>>> Bank account ID's are normalized per country. And international
>>> harmonization is in effect. This should be taken into consideration when
>>> defining a solution how to store bank account details.
>>>
>>> On Fri, Nov 7, 2008 at 4:04 PM, Pierre Smits <pi...@gmail.com>
>>> wrote:
>>>
>>>> Addendum
>>>>
>>>> Is using attributes on a Party not a better idea. That way it also
>>>> usable
>>>> for employees, who get paid electronically (the generic way to pay
>>>> employees
>>>> in The Netherlands). The attribute should then be selectable in
>>>> stead of
>>>> free text.
>>>>
>>>> On Fri, Nov 7, 2008 at 3:55 PM, Pierre Smits
>>>> <pi...@gmail.com>wrote:
>>>>
>>>>> BJ,
>>>>>
>>>>> I can follow your reasoning. And it would be the simplest thing to
>>>>> do for
>>>>> customers (Bill-to role?) and Suppliers.
>>>>> Using ContactMechs for displaying bank related info in
>>>>> communications and
>>>>> transaction documents (e.g. purchace and sales orders, invoices)
>>>>> would be
>>>>> the easiest route to go.
>>>>> But these details may not be editable by everyone who can just add
>>>>> ContactMechs (preferrably restricted to persons in some kind of
>>>>> accounting
>>>>> role).
>>>>>
>>>>> But for the organisations using OFBiz (company and subsidiaries)
>>>>> this is a
>>>>> bit more complex. A bank account is more than just a ContactMech.
>>>>> It is a
>>>>> part of the accounting schemas and needs to be auditable....That is
>>>>> what the
>>>>> transactions in the general ledger (and AP and AR, etc) are for.
>>>>>
>>>>> A CFO doesn't care less what everybody does with ContactMechs as
>>>>> long as
>>>>> his part of the system (FICO, AP, AR, etc) are in order and auditable.
>>>>>
>>>>> Regards,
>>>>>
>>>>> Pierre
>>>>>
>>>>>
>>>>> On Fri, Nov 7, 2008 at 3:14 PM, BJ Freeman <bj...@free-man.net>
>>>>> wrote:
>>>>>
>>>>>> 1) it is easy for the user to put in and change info.
>>>>>> 2) to me, that is what the info is, How to get to your bank
>>>>>> account, or
>>>>>> contact the supplier, or how to get a credit on an order.
>>>>>> 4) by making different types of Contact mechs, the program can decide
>>>>>> what contact mech to use.
>>>>>>
>>>>>>
>>>>>>
>>>>>> Jacques Le Roux sent the following on 11/7/2008 5:24 AM:
>>>>>>> Hi BJ,
>>>>>>>
>>>>>>> From: "BJ Freeman" <bj...@free-man.net>
>>>>>>>> I have adopted using the Contact Mechs instead of properties to put
>>>>>> the
>>>>>>>> bank info for. however that is not the way it is done in ofbiz
>>>>>>>> at this
>>>>>>>> time.
>>>>>>> What did you make this choice (just curious) ?
>>>>>>>
>>>>>>> Thanks
>>>>>>>
>>>>>>> Jacques
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>
>>
>
>
Re: How to process bank statements
Posted by Jacques Le Roux <ja...@les7arts.com>.
There are an interesting comments in this thread (I mean http://www.nabble.com/How-to-process-bank-statements-td20294429.html)
I would suggest to create a Wiky entry to collect informations and make them more available for others to comment... even later...
In the same spirit than the VAT page for instance http://docs.ofbiz.org/display/OFBIZ/VAT
Thanks
Jacques
From: "BJ Freeman" <bj...@free-man.net>
> This is at the third party software level.
> the SECAS will check that the proper routing number(tied to Geo) and
> account format for the bank.
> the validation is to run a validation on the bank account for a $1.00.
> the interaction between banks is based on agreements (entity) and a page
> from the Trading partners data used currently. I brief review of the
> Oagis looks like it has a similar structure.
>
> Pierre Smits sent the following on 11/7/2008 7:06 AM:
>> Addendum 2.
>>
>> Bank account ID's are normalized per country. And international
>> harmonization is in effect. This should be taken into consideration when
>> defining a solution how to store bank account details.
>>
>> On Fri, Nov 7, 2008 at 4:04 PM, Pierre Smits <pi...@gmail.com> wrote:
>>
>>> Addendum
>>>
>>> Is using attributes on a Party not a better idea. That way it also usable
>>> for employees, who get paid electronically (the generic way to pay employees
>>> in The Netherlands). The attribute should then be selectable in stead of
>>> free text.
>>>
>>> On Fri, Nov 7, 2008 at 3:55 PM, Pierre Smits <pi...@gmail.com>wrote:
>>>
>>>> BJ,
>>>>
>>>> I can follow your reasoning. And it would be the simplest thing to do for
>>>> customers (Bill-to role?) and Suppliers.
>>>> Using ContactMechs for displaying bank related info in communications and
>>>> transaction documents (e.g. purchace and sales orders, invoices) would be
>>>> the easiest route to go.
>>>> But these details may not be editable by everyone who can just add
>>>> ContactMechs (preferrably restricted to persons in some kind of accounting
>>>> role).
>>>>
>>>> But for the organisations using OFBiz (company and subsidiaries) this is a
>>>> bit more complex. A bank account is more than just a ContactMech. It is a
>>>> part of the accounting schemas and needs to be auditable....That is what the
>>>> transactions in the general ledger (and AP and AR, etc) are for.
>>>>
>>>> A CFO doesn't care less what everybody does with ContactMechs as long as
>>>> his part of the system (FICO, AP, AR, etc) are in order and auditable.
>>>>
>>>> Regards,
>>>>
>>>> Pierre
>>>>
>>>>
>>>> On Fri, Nov 7, 2008 at 3:14 PM, BJ Freeman <bj...@free-man.net> wrote:
>>>>
>>>>> 1) it is easy for the user to put in and change info.
>>>>> 2) to me, that is what the info is, How to get to your bank account, or
>>>>> contact the supplier, or how to get a credit on an order.
>>>>> 4) by making different types of Contact mechs, the program can decide
>>>>> what contact mech to use.
>>>>>
>>>>>
>>>>>
>>>>> Jacques Le Roux sent the following on 11/7/2008 5:24 AM:
>>>>>> Hi BJ,
>>>>>>
>>>>>> From: "BJ Freeman" <bj...@free-man.net>
>>>>>>> I have adopted using the Contact Mechs instead of properties to put
>>>>> the
>>>>>>> bank info for. however that is not the way it is done in ofbiz at this
>>>>>>> time.
>>>>>> What did you make this choice (just curious) ?
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>> Jacques
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>
>>
>
Re: How to process bank statements
Posted by BJ Freeman <bj...@free-man.net>.
This is at the third party software level.
the SECAS will check that the proper routing number(tied to Geo) and
account format for the bank.
the validation is to run a validation on the bank account for a $1.00.
the interaction between banks is based on agreements (entity) and a page
from the Trading partners data used currently. I brief review of the
Oagis looks like it has a similar structure.
Pierre Smits sent the following on 11/7/2008 7:06 AM:
> Addendum 2.
>
> Bank account ID's are normalized per country. And international
> harmonization is in effect. This should be taken into consideration when
> defining a solution how to store bank account details.
>
> On Fri, Nov 7, 2008 at 4:04 PM, Pierre Smits <pi...@gmail.com> wrote:
>
>> Addendum
>>
>> Is using attributes on a Party not a better idea. That way it also usable
>> for employees, who get paid electronically (the generic way to pay employees
>> in The Netherlands). The attribute should then be selectable in stead of
>> free text.
>>
>> On Fri, Nov 7, 2008 at 3:55 PM, Pierre Smits <pi...@gmail.com>wrote:
>>
>>> BJ,
>>>
>>> I can follow your reasoning. And it would be the simplest thing to do for
>>> customers (Bill-to role?) and Suppliers.
>>> Using ContactMechs for displaying bank related info in communications and
>>> transaction documents (e.g. purchace and sales orders, invoices) would be
>>> the easiest route to go.
>>> But these details may not be editable by everyone who can just add
>>> ContactMechs (preferrably restricted to persons in some kind of accounting
>>> role).
>>>
>>> But for the organisations using OFBiz (company and subsidiaries) this is a
>>> bit more complex. A bank account is more than just a ContactMech. It is a
>>> part of the accounting schemas and needs to be auditable....That is what the
>>> transactions in the general ledger (and AP and AR, etc) are for.
>>>
>>> A CFO doesn't care less what everybody does with ContactMechs as long as
>>> his part of the system (FICO, AP, AR, etc) are in order and auditable.
>>>
>>> Regards,
>>>
>>> Pierre
>>>
>>>
>>> On Fri, Nov 7, 2008 at 3:14 PM, BJ Freeman <bj...@free-man.net> wrote:
>>>
>>>> 1) it is easy for the user to put in and change info.
>>>> 2) to me, that is what the info is, How to get to your bank account, or
>>>> contact the supplier, or how to get a credit on an order.
>>>> 4) by making different types of Contact mechs, the program can decide
>>>> what contact mech to use.
>>>>
>>>>
>>>>
>>>> Jacques Le Roux sent the following on 11/7/2008 5:24 AM:
>>>>> Hi BJ,
>>>>>
>>>>> From: "BJ Freeman" <bj...@free-man.net>
>>>>>> I have adopted using the Contact Mechs instead of properties to put
>>>> the
>>>>>> bank info for. however that is not the way it is done in ofbiz at this
>>>>>> time.
>>>>> What did you make this choice (just curious) ?
>>>>>
>>>>> Thanks
>>>>>
>>>>> Jacques
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>
Re: How to process bank statements
Posted by Pierre Smits <pi...@gmail.com>.
Addendum 2.
Bank account ID's are normalized per country. And international
harmonization is in effect. This should be taken into consideration when
defining a solution how to store bank account details.
On Fri, Nov 7, 2008 at 4:04 PM, Pierre Smits <pi...@gmail.com> wrote:
> Addendum
>
> Is using attributes on a Party not a better idea. That way it also usable
> for employees, who get paid electronically (the generic way to pay employees
> in The Netherlands). The attribute should then be selectable in stead of
> free text.
>
> On Fri, Nov 7, 2008 at 3:55 PM, Pierre Smits <pi...@gmail.com>wrote:
>
>> BJ,
>>
>> I can follow your reasoning. And it would be the simplest thing to do for
>> customers (Bill-to role?) and Suppliers.
>> Using ContactMechs for displaying bank related info in communications and
>> transaction documents (e.g. purchace and sales orders, invoices) would be
>> the easiest route to go.
>> But these details may not be editable by everyone who can just add
>> ContactMechs (preferrably restricted to persons in some kind of accounting
>> role).
>>
>> But for the organisations using OFBiz (company and subsidiaries) this is a
>> bit more complex. A bank account is more than just a ContactMech. It is a
>> part of the accounting schemas and needs to be auditable....That is what the
>> transactions in the general ledger (and AP and AR, etc) are for.
>>
>> A CFO doesn't care less what everybody does with ContactMechs as long as
>> his part of the system (FICO, AP, AR, etc) are in order and auditable.
>>
>> Regards,
>>
>> Pierre
>>
>>
>> On Fri, Nov 7, 2008 at 3:14 PM, BJ Freeman <bj...@free-man.net> wrote:
>>
>>> 1) it is easy for the user to put in and change info.
>>> 2) to me, that is what the info is, How to get to your bank account, or
>>> contact the supplier, or how to get a credit on an order.
>>> 4) by making different types of Contact mechs, the program can decide
>>> what contact mech to use.
>>>
>>>
>>>
>>> Jacques Le Roux sent the following on 11/7/2008 5:24 AM:
>>> > Hi BJ,
>>> >
>>> > From: "BJ Freeman" <bj...@free-man.net>
>>> >> I have adopted using the Contact Mechs instead of properties to put
>>> the
>>> >> bank info for. however that is not the way it is done in ofbiz at this
>>> >> time.
>>> >
>>> > What did you make this choice (just curious) ?
>>> >
>>> > Thanks
>>> >
>>> > Jacques
>>> >
>>> >
>>> >
>>> >
>>>
>>
>>
>
Re: How to process bank statements
Posted by BJ Freeman <bj...@free-man.net>.
[But these details may not be editable by everyone who can just add
ContactMechs (preferably restricted to persons in some kind of accounting
role).]
yes remember that this is the company party that this is put into.
this then creates the party for the Bank or supplier and links them.
the services for this check the permissions to allow CRUD operations..
[ A CFO doesn't care less what everybody does with ContactMechs as long
as his part of the system (FICO, AP, AR, etc) are in order and auditable.]
no more than the consideration for a PCI audit and security. just
focused on other financial information.
Pierre Smits sent the following on 11/7/2008 6:55 AM:
> BJ,
>
> I can follow your reasoning. And it would be the simplest thing to do for
> customers (Bill-to role?) and Suppliers.
> Using ContactMechs for displaying bank related info in communications and
> transaction documents (e.g. purchace and sales orders, invoices) would be
> the easiest route to go.
> But these details may not be editable by everyone who can just add
> ContactMechs (preferrably restricted to persons in some kind of accounting
> role).
>
> But for the organisations using OFBiz (company and subsidiaries) this is a
> bit more complex. A bank account is more than just a ContactMech. It is a
> part of the accounting schemas and needs to be auditable....That is what the
> transactions in the general ledger (and AP and AR, etc) are for.
>
> A CFO doesn't care less what everybody does with ContactMechs as long as his
> part of the system (FICO, AP, AR, etc) are in order and auditable.
>
> Regards,
>
> Pierre
>
> On Fri, Nov 7, 2008 at 3:14 PM, BJ Freeman <bj...@free-man.net> wrote:
>
>> 1) it is easy for the user to put in and change info.
>> 2) to me, that is what the info is, How to get to your bank account, or
>> contact the supplier, or how to get a credit on an order.
>> 4) by making different types of Contact mechs, the program can decide
>> what contact mech to use.
>>
>>
>>
>> Jacques Le Roux sent the following on 11/7/2008 5:24 AM:
>>> Hi BJ,
>>>
>>> From: "BJ Freeman" <bj...@free-man.net>
>>>> I have adopted using the Contact Mechs instead of properties to put the
>>>> bank info for. however that is not the way it is done in ofbiz at this
>>>> time.
>>> What did you make this choice (just curious) ?
>>>
>>> Thanks
>>>
>>> Jacques
>>>
>>>
>>>
>>>
>
Re: How to process bank statements
Posted by Pierre Smits <pi...@gmail.com>.
Addendum
Is using attributes on a Party not a better idea. That way it also usable
for employees, who get paid electronically (the generic way to pay employees
in The Netherlands). The attribute should then be selectable in stead of
free text.
On Fri, Nov 7, 2008 at 3:55 PM, Pierre Smits <pi...@gmail.com> wrote:
> BJ,
>
> I can follow your reasoning. And it would be the simplest thing to do for
> customers (Bill-to role?) and Suppliers.
> Using ContactMechs for displaying bank related info in communications and
> transaction documents (e.g. purchace and sales orders, invoices) would be
> the easiest route to go.
> But these details may not be editable by everyone who can just add
> ContactMechs (preferrably restricted to persons in some kind of accounting
> role).
>
> But for the organisations using OFBiz (company and subsidiaries) this is a
> bit more complex. A bank account is more than just a ContactMech. It is a
> part of the accounting schemas and needs to be auditable....That is what the
> transactions in the general ledger (and AP and AR, etc) are for.
>
> A CFO doesn't care less what everybody does with ContactMechs as long as
> his part of the system (FICO, AP, AR, etc) are in order and auditable.
>
> Regards,
>
> Pierre
>
>
> On Fri, Nov 7, 2008 at 3:14 PM, BJ Freeman <bj...@free-man.net> wrote:
>
>> 1) it is easy for the user to put in and change info.
>> 2) to me, that is what the info is, How to get to your bank account, or
>> contact the supplier, or how to get a credit on an order.
>> 4) by making different types of Contact mechs, the program can decide
>> what contact mech to use.
>>
>>
>>
>> Jacques Le Roux sent the following on 11/7/2008 5:24 AM:
>> > Hi BJ,
>> >
>> > From: "BJ Freeman" <bj...@free-man.net>
>> >> I have adopted using the Contact Mechs instead of properties to put the
>> >> bank info for. however that is not the way it is done in ofbiz at this
>> >> time.
>> >
>> > What did you make this choice (just curious) ?
>> >
>> > Thanks
>> >
>> > Jacques
>> >
>> >
>> >
>> >
>>
>
>
Re: How to process bank statements
Posted by Pierre Smits <pi...@gmail.com>.
BJ,
I can follow your reasoning. And it would be the simplest thing to do for
customers (Bill-to role?) and Suppliers.
Using ContactMechs for displaying bank related info in communications and
transaction documents (e.g. purchace and sales orders, invoices) would be
the easiest route to go.
But these details may not be editable by everyone who can just add
ContactMechs (preferrably restricted to persons in some kind of accounting
role).
But for the organisations using OFBiz (company and subsidiaries) this is a
bit more complex. A bank account is more than just a ContactMech. It is a
part of the accounting schemas and needs to be auditable....That is what the
transactions in the general ledger (and AP and AR, etc) are for.
A CFO doesn't care less what everybody does with ContactMechs as long as his
part of the system (FICO, AP, AR, etc) are in order and auditable.
Regards,
Pierre
On Fri, Nov 7, 2008 at 3:14 PM, BJ Freeman <bj...@free-man.net> wrote:
> 1) it is easy for the user to put in and change info.
> 2) to me, that is what the info is, How to get to your bank account, or
> contact the supplier, or how to get a credit on an order.
> 4) by making different types of Contact mechs, the program can decide
> what contact mech to use.
>
>
>
> Jacques Le Roux sent the following on 11/7/2008 5:24 AM:
> > Hi BJ,
> >
> > From: "BJ Freeman" <bj...@free-man.net>
> >> I have adopted using the Contact Mechs instead of properties to put the
> >> bank info for. however that is not the way it is done in ofbiz at this
> >> time.
> >
> > What did you make this choice (just curious) ?
> >
> > Thanks
> >
> > Jacques
> >
> >
> >
> >
>
Re: How to process bank statements
Posted by Jacques Le Roux <ja...@les7arts.com>.
Interesting, thanks BJ
Jacques
From: "BJ Freeman" <bj...@free-man.net>
> 1) it is easy for the user to put in and change info.
> 2) to me, that is what the info is, How to get to your bank account, or
> contact the supplier, or how to get a credit on an order.
> 4) by making different types of Contact mechs, the program can decide
> what contact mech to use.
>
>
>
> Jacques Le Roux sent the following on 11/7/2008 5:24 AM:
>> Hi BJ,
>>
>> From: "BJ Freeman" <bj...@free-man.net>
>>> I have adopted using the Contact Mechs instead of properties to put the
>>> bank info for. however that is not the way it is done in ofbiz at this
>>> time.
>>
>> What did you make this choice (just curious) ?
>>
>> Thanks
>>
>> Jacques
>>
>>
>>
>>
>
Re: How to process bank statements
Posted by BJ Freeman <bj...@free-man.net>.
1) it is easy for the user to put in and change info.
2) to me, that is what the info is, How to get to your bank account, or
contact the supplier, or how to get a credit on an order.
4) by making different types of Contact mechs, the program can decide
what contact mech to use.
Jacques Le Roux sent the following on 11/7/2008 5:24 AM:
> Hi BJ,
>
> From: "BJ Freeman" <bj...@free-man.net>
>> I have adopted using the Contact Mechs instead of properties to put the
>> bank info for. however that is not the way it is done in ofbiz at this
>> time.
>
> What did you make this choice (just curious) ?
>
> Thanks
>
> Jacques
>
>
>
>
Re: How to process bank statements
Posted by Jacques Le Roux <ja...@les7arts.com>.
Hi BJ,
From: "BJ Freeman" <bj...@free-man.net>
> I have adopted using the Contact Mechs instead of properties to put the
> bank info for. however that is not the way it is done in ofbiz at this time.
What did you make this choice (just curious) ?
Thanks
Jacques
Re: How to process bank statements
Posted by BJ Freeman <bj...@free-man.net>.
once the
1) entities (current or new) have been determined.
2)the import high level services have been implemented,
3) the low level services that to the actual conversion can be written.
4) Secas and EEcas (if required) can be specific to banks for
reconciling the ofbiz transaction file against the bank totals, that
apply. these would be like third party(banks) drivers.
I have adopted using the Contact Mechs instead of properties to put the
bank info for. however that is not the way it is done in ofbiz at this time.
Pierre Smits sent the following on 11/7/2008 2:56 AM:
> Daniel,
>
> Nice outline of requirements.
>
> My thoughts on this are:
> @1 Parsing
> Not only importing and parsing of imported files has to be possible, but
> also manual entering of bank statements. Some bank statements come only once
> per period with not many line items. In that case the proces of downloading
> - importing - reconciliation would be less user friendly than just entering
> the bank statement.
>
> @2 Data storage
> Some banks also include interest date and currency (incl conversion rate)
> per line item on the bank statement.
>
> @3 Bank statement line items
> Proposing matches - this would be extremely user friendly. Proposed matches
> could be based on bank ID of Customer/Supplier. The system could then
> propose in outstanding invoices to select for further reconciliation.
>
> The solution must also show the difference between the amount to be
> reconciled (Bank Statement Current Balance -/- Bank Statement Previouse
> Balance) and the reconciled transactions.
>
> @8 Overviews (New)
> An overview must exist that states unprocessed bank statements, consisting
> of the bankstatements with status CREATED and IN PROCES, possible items
> shown per bank statement are:
> FinAccount ID,
> Fin Account Name
> Statement ID
> Statement Date
> Status
> Unreconciled Amount
>
> An overview must exist containing the reconciled bank statements (status
> RECONCILED) for audit purposes.
>
>
> Regards,
>
> Pierre
>
>
> On Fri, Nov 7, 2008 at 2:19 AM, Daniel Riquelme
> <da...@gmail.com>wrote:
>
>> I have a few thoughts regarding this issue. Most of them came from
>> analyzing
>> commercial accounting and financial software.
>>
>> All companies use one or more bank accounts in their daily transactions.
>> Some of this transactions relate to their operations (sales and purchases).
>> Others relate to taxes and commisions from the bank or financial
>> institution.
>> There are automatic money transfers, credit payments, and all sorts of
>> monetary transaction.
>>
>> Assuming that the bank almost never makes a mistake, it is a very smart
>> habit to keep the company books in sync with what the bank statement says.
>>
>> I figured a set of requirements to satisfy a client who needs this
>> functionality:
>>
>> 1) There has to be a simple way to input the bank data into the system. As
>> far as I know, all banks let you download this data in some simple and
>> parseable format.
>> -> We need a different parser for each format.
>>
>> 2) The data has to be stored in a common structure in the system. At a
>> minimum this is needed:
>> -Bank Statement number/sequence
>> -Bank Statement date
>> -Current Balance (available and retained)
>> -Previous Balance
>> -Transaction Date
>> -Transaction description
>> -Document number
>> -Credit Amount
>> -Debit Amount
>> -> A common structure is needed to store the data from different banks
>>
>
> Some bank statements also display intrest date and currence (incl.
> conversion rate) per line item
>
>
>> 3) Each line in the bank statement must have a connection to an accounting
>> transaction item. This transactions items could exist already or have to be
>> created to match the bank statement.
>> -> An ui must exist to let a user enter a match between a bank statement
>> line and an accounting transaction item.
>> -> An ui must exist to let a user create a new transaction item with data
>> from a line in a bank statement.
>> -> When a match is made, the bank statement line must be disabled for a new
>> match.
>> -> It would be nice if the system could suggest possible matches.
>>
>> 4) The balances in the corresponding general ledger account and bank
>> statements must match.
>>
>> 5) FinAccount could be used to represent the bank account. Each bank
>> statement will be related to it's corresponding FinAccount.
>>
>> 6) The bank statement lines need the following possible states:
>> - CREATED
>> - RECONCILED
>>
>> 7) The bank statement need the following possible states:
>> - CREATED
>> - IN PROCESS
>> - RECONCILED
>
>
>> Daniel.
>>
>> We would need a way to import the transaction data into OFBiz
>>
>> On Tue, Nov 4, 2008 at 7:48 PM, BJ Freeman <bj...@free-man.net> wrote:
>>
>>> my thought is to import the bank statement, ie, the electronic
>>> tranaction from the bank into it own transaction list, then link those
>>> transaction against the accounting transactions, this would then have a
>>> status in the banks transcatiions of reconciled.
>>> you could use the same scheme for invoices from supplier, and shippers.
>>>
>>> David Goodenough sent the following on 11/4/2008 2:10 PM:
>>>> On Tuesday 04 November 2008, Sharan-F wrote:
>>>>> Hi Pierre
>>>>>
>>>>> You are not alone - a lot of places use bank statement processing.
>>>>>
>>>>> I looked at OFBiz accounts a few months ago and tried to work out how
>> to
>>>>> process bank statements – so would be interested in any other replies
>>> that
>>>>> you get.
>>>>>
>>>>> The main thing I found was that the GL account for the company cheque
>>>>> account doesnt display what the balance is (unless you use the trial
>>>>> balance or other reports) so can be difficult to trace what your
>> closing
>>>>> balance was in line with your last statement.
>>>>>
>>>>> One idea I tried was to look at using the Financial Accounts
>>> functionality
>>>>> as you can input an opening balance and have deposits and withdrawals
>>> just
>>>>> like you have on a bank statement. It's also a Payment Method Type for
>>>>> transactions. The Financial Accounts details can be displayed in Party
>>>>> Manager as part of the party record.
>>>>>
>>>>> The thing I havent sorted out yet is how to mirror the transactions of
>>> the
>>>>> Financial Account into the equivalent GL account (Eg. General Checking
>>>>> Account) so that they stay in synch.
>>>>>
>>>>> Not sure if this helps you at all but if there are other ways to
>> process
>>>>> and track bank statements in OFBiz then I'd be keen to find out about
>>> them
>>>>> too.
>>>>>
>>>>> Thanks
>>>>> Sharan
>>>>>
>>>>> Pierre Smits-3 wrote:
>>>>>> Is The Netherlands the only country where payments of invoices and
>> cost
>>>>>> on bank statements are booked?
>>>>>> How is this to be done in OFBiz?
>>>>>>
>>>>>>
>>>>>> On Sun, Nov 2, 2008 at 11:13 PM, Pierre Smits
>>>>>>
>>>>>> <pi...@gmail.com>wrote:
>>>>>>> On bank statements in The Netherlands we have
>>>>>>>
>>>>>>> - (partial) payments by customers
>>>>>>> - (partial) payments to suppliers
>>>>>>> - payment of bank costs and others
>>>>>>>
>>>>>>> Where and how do I process these in OFBiz?
>>>>>>>
>>>>>>> Regards,
>>>>>>>
>>>>>>> Pierre
>>>> Of course many banks also allow you to download an electronic
>>>> bank statement. Many use OFX for this, others CVS or something like
>>>> a spreadsheet. It would be nice to be able to
>>>> import that rather than re-type it all.
>>>>
>>>> David
>>>>
>>>>
>>>
>
Re: How to process bank statements
Posted by Pierre Smits <pi...@gmail.com>.
Daniel,
Nice outline of requirements.
My thoughts on this are:
@1 Parsing
Not only importing and parsing of imported files has to be possible, but
also manual entering of bank statements. Some bank statements come only once
per period with not many line items. In that case the proces of downloading
- importing - reconciliation would be less user friendly than just entering
the bank statement.
@2 Data storage
Some banks also include interest date and currency (incl conversion rate)
per line item on the bank statement.
@3 Bank statement line items
Proposing matches - this would be extremely user friendly. Proposed matches
could be based on bank ID of Customer/Supplier. The system could then
propose in outstanding invoices to select for further reconciliation.
The solution must also show the difference between the amount to be
reconciled (Bank Statement Current Balance -/- Bank Statement Previouse
Balance) and the reconciled transactions.
@8 Overviews (New)
An overview must exist that states unprocessed bank statements, consisting
of the bankstatements with status CREATED and IN PROCES, possible items
shown per bank statement are:
FinAccount ID,
Fin Account Name
Statement ID
Statement Date
Status
Unreconciled Amount
An overview must exist containing the reconciled bank statements (status
RECONCILED) for audit purposes.
Regards,
Pierre
On Fri, Nov 7, 2008 at 2:19 AM, Daniel Riquelme
<da...@gmail.com>wrote:
> I have a few thoughts regarding this issue. Most of them came from
> analyzing
> commercial accounting and financial software.
>
> All companies use one or more bank accounts in their daily transactions.
> Some of this transactions relate to their operations (sales and purchases).
> Others relate to taxes and commisions from the bank or financial
> institution.
> There are automatic money transfers, credit payments, and all sorts of
> monetary transaction.
>
> Assuming that the bank almost never makes a mistake, it is a very smart
> habit to keep the company books in sync with what the bank statement says.
>
> I figured a set of requirements to satisfy a client who needs this
> functionality:
>
> 1) There has to be a simple way to input the bank data into the system. As
> far as I know, all banks let you download this data in some simple and
> parseable format.
> -> We need a different parser for each format.
>
> 2) The data has to be stored in a common structure in the system. At a
> minimum this is needed:
> -Bank Statement number/sequence
> -Bank Statement date
> -Current Balance (available and retained)
> -Previous Balance
> -Transaction Date
> -Transaction description
> -Document number
> -Credit Amount
> -Debit Amount
> -> A common structure is needed to store the data from different banks
>
Some bank statements also display intrest date and currence (incl.
conversion rate) per line item
>
> 3) Each line in the bank statement must have a connection to an accounting
> transaction item. This transactions items could exist already or have to be
> created to match the bank statement.
> -> An ui must exist to let a user enter a match between a bank statement
> line and an accounting transaction item.
> -> An ui must exist to let a user create a new transaction item with data
> from a line in a bank statement.
> -> When a match is made, the bank statement line must be disabled for a new
> match.
> -> It would be nice if the system could suggest possible matches.
>
> 4) The balances in the corresponding general ledger account and bank
> statements must match.
>
> 5) FinAccount could be used to represent the bank account. Each bank
> statement will be related to it's corresponding FinAccount.
>
> 6) The bank statement lines need the following possible states:
> - CREATED
> - RECONCILED
>
> 7) The bank statement need the following possible states:
> - CREATED
> - IN PROCESS
> - RECONCILED
> Daniel.
>
> We would need a way to import the transaction data into OFBiz
>
> On Tue, Nov 4, 2008 at 7:48 PM, BJ Freeman <bj...@free-man.net> wrote:
>
> > my thought is to import the bank statement, ie, the electronic
> > tranaction from the bank into it own transaction list, then link those
> > transaction against the accounting transactions, this would then have a
> > status in the banks transcatiions of reconciled.
> > you could use the same scheme for invoices from supplier, and shippers.
> >
> > David Goodenough sent the following on 11/4/2008 2:10 PM:
> > > On Tuesday 04 November 2008, Sharan-F wrote:
> > >> Hi Pierre
> > >>
> > >> You are not alone - a lot of places use bank statement processing.
> > >>
> > >> I looked at OFBiz accounts a few months ago and tried to work out how
> to
> > >> process bank statements – so would be interested in any other replies
> > that
> > >> you get.
> > >>
> > >> The main thing I found was that the GL account for the company cheque
> > >> account doesnt display what the balance is (unless you use the trial
> > >> balance or other reports) so can be difficult to trace what your
> closing
> > >> balance was in line with your last statement.
> > >>
> > >> One idea I tried was to look at using the Financial Accounts
> > functionality
> > >> as you can input an opening balance and have deposits and withdrawals
> > just
> > >> like you have on a bank statement. It's also a Payment Method Type for
> > >> transactions. The Financial Accounts details can be displayed in Party
> > >> Manager as part of the party record.
> > >>
> > >> The thing I havent sorted out yet is how to mirror the transactions of
> > the
> > >> Financial Account into the equivalent GL account (Eg. General Checking
> > >> Account) so that they stay in synch.
> > >>
> > >> Not sure if this helps you at all but if there are other ways to
> process
> > >> and track bank statements in OFBiz then I'd be keen to find out about
> > them
> > >> too.
> > >>
> > >> Thanks
> > >> Sharan
> > >>
> > >> Pierre Smits-3 wrote:
> > >>> Is The Netherlands the only country where payments of invoices and
> cost
> > >>> on bank statements are booked?
> > >>> How is this to be done in OFBiz?
> > >>>
> > >>>
> > >>> On Sun, Nov 2, 2008 at 11:13 PM, Pierre Smits
> > >>>
> > >>> <pi...@gmail.com>wrote:
> > >>>> On bank statements in The Netherlands we have
> > >>>>
> > >>>> - (partial) payments by customers
> > >>>> - (partial) payments to suppliers
> > >>>> - payment of bank costs and others
> > >>>>
> > >>>> Where and how do I process these in OFBiz?
> > >>>>
> > >>>> Regards,
> > >>>>
> > >>>> Pierre
> > >
> > > Of course many banks also allow you to download an electronic
> > > bank statement. Many use OFX for this, others CVS or something like
> > > a spreadsheet. It would be nice to be able to
> > > import that rather than re-type it all.
> > >
> > > David
> > >
> > >
> >
> >
>
Re: How to process bank statements
Posted by Daniel Riquelme <da...@gmail.com>.
I have a few thoughts regarding this issue. Most of them came from analyzing
commercial accounting and financial software.
All companies use one or more bank accounts in their daily transactions.
Some of this transactions relate to their operations (sales and purchases).
Others relate to taxes and commisions from the bank or financial
institution.
There are automatic money transfers, credit payments, and all sorts of
monetary transaction.
Assuming that the bank almost never makes a mistake, it is a very smart
habit to keep the company books in sync with what the bank statement says.
I figured a set of requirements to satisfy a client who needs this
functionality:
1) There has to be a simple way to input the bank data into the system. As
far as I know, all banks let you download this data in some simple and
parseable format.
-> We need a different parser for each format.
2) The data has to be stored in a common structure in the system. At a
minimum this is needed:
-Bank Statement number/sequence
-Bank Statement date
-Current Balance (available and retained)
-Previous Balance
-Transaction Date
-Transaction description
-Document number
-Credit Amount
-Debit Amount
-> A common structure is needed to store the data from different banks
3) Each line in the bank statement must have a connection to an accounting
transaction item. This transactions items could exist already or have to be
created to match the bank statement.
-> An ui must exist to let a user enter a match between a bank statement
line and an accounting transaction item.
-> An ui must exist to let a user create a new transaction item with data
from a line in a bank statement.
-> When a match is made, the bank statement line must be disabled for a new
match.
-> It would be nice if the system could suggest possible matches.
4) The balances in the corresponding general ledger account and bank
statements must match.
5) FinAccount could be used to represent the bank account. Each bank
statement will be related to it's corresponding FinAccount.
6) The bank statement lines need the following possible states:
- CREATED
- RECONCILED
7) The bank statement need the following possible states:
- CREATED
- IN PROCESS
- RECONCILED
Daniel.
We would need a way to import the transaction data into OFBiz
On Tue, Nov 4, 2008 at 7:48 PM, BJ Freeman <bj...@free-man.net> wrote:
> my thought is to import the bank statement, ie, the electronic
> tranaction from the bank into it own transaction list, then link those
> transaction against the accounting transactions, this would then have a
> status in the banks transcatiions of reconciled.
> you could use the same scheme for invoices from supplier, and shippers.
>
> David Goodenough sent the following on 11/4/2008 2:10 PM:
> > On Tuesday 04 November 2008, Sharan-F wrote:
> >> Hi Pierre
> >>
> >> You are not alone - a lot of places use bank statement processing.
> >>
> >> I looked at OFBiz accounts a few months ago and tried to work out how to
> >> process bank statements – so would be interested in any other replies
> that
> >> you get.
> >>
> >> The main thing I found was that the GL account for the company cheque
> >> account doesnt display what the balance is (unless you use the trial
> >> balance or other reports) so can be difficult to trace what your closing
> >> balance was in line with your last statement.
> >>
> >> One idea I tried was to look at using the Financial Accounts
> functionality
> >> as you can input an opening balance and have deposits and withdrawals
> just
> >> like you have on a bank statement. It's also a Payment Method Type for
> >> transactions. The Financial Accounts details can be displayed in Party
> >> Manager as part of the party record.
> >>
> >> The thing I havent sorted out yet is how to mirror the transactions of
> the
> >> Financial Account into the equivalent GL account (Eg. General Checking
> >> Account) so that they stay in synch.
> >>
> >> Not sure if this helps you at all but if there are other ways to process
> >> and track bank statements in OFBiz then I'd be keen to find out about
> them
> >> too.
> >>
> >> Thanks
> >> Sharan
> >>
> >> Pierre Smits-3 wrote:
> >>> Is The Netherlands the only country where payments of invoices and cost
> >>> on bank statements are booked?
> >>> How is this to be done in OFBiz?
> >>>
> >>>
> >>> On Sun, Nov 2, 2008 at 11:13 PM, Pierre Smits
> >>>
> >>> <pi...@gmail.com>wrote:
> >>>> On bank statements in The Netherlands we have
> >>>>
> >>>> - (partial) payments by customers
> >>>> - (partial) payments to suppliers
> >>>> - payment of bank costs and others
> >>>>
> >>>> Where and how do I process these in OFBiz?
> >>>>
> >>>> Regards,
> >>>>
> >>>> Pierre
> >
> > Of course many banks also allow you to download an electronic
> > bank statement. Many use OFX for this, others CVS or something like
> > a spreadsheet. It would be nice to be able to
> > import that rather than re-type it all.
> >
> > David
> >
> >
>
>
Re: How to process bank statements
Posted by BJ Freeman <bj...@free-man.net>.
my thought is to import the bank statement, ie, the electronic
tranaction from the bank into it own transaction list, then link those
transaction against the accounting transactions, this would then have a
status in the banks transcatiions of reconciled.
you could use the same scheme for invoices from supplier, and shippers.
David Goodenough sent the following on 11/4/2008 2:10 PM:
> On Tuesday 04 November 2008, Sharan-F wrote:
>> Hi Pierre
>>
>> You are not alone - a lot of places use bank statement processing.
>>
>> I looked at OFBiz accounts a few months ago and tried to work out how to
>> process bank statements – so would be interested in any other replies that
>> you get.
>>
>> The main thing I found was that the GL account for the company cheque
>> account doesnt display what the balance is (unless you use the trial
>> balance or other reports) so can be difficult to trace what your closing
>> balance was in line with your last statement.
>>
>> One idea I tried was to look at using the Financial Accounts functionality
>> as you can input an opening balance and have deposits and withdrawals just
>> like you have on a bank statement. It's also a Payment Method Type for
>> transactions. The Financial Accounts details can be displayed in Party
>> Manager as part of the party record.
>>
>> The thing I havent sorted out yet is how to mirror the transactions of the
>> Financial Account into the equivalent GL account (Eg. General Checking
>> Account) so that they stay in synch.
>>
>> Not sure if this helps you at all but if there are other ways to process
>> and track bank statements in OFBiz then I'd be keen to find out about them
>> too.
>>
>> Thanks
>> Sharan
>>
>> Pierre Smits-3 wrote:
>>> Is The Netherlands the only country where payments of invoices and cost
>>> on bank statements are booked?
>>> How is this to be done in OFBiz?
>>>
>>>
>>> On Sun, Nov 2, 2008 at 11:13 PM, Pierre Smits
>>>
>>> <pi...@gmail.com>wrote:
>>>> On bank statements in The Netherlands we have
>>>>
>>>> - (partial) payments by customers
>>>> - (partial) payments to suppliers
>>>> - payment of bank costs and others
>>>>
>>>> Where and how do I process these in OFBiz?
>>>>
>>>> Regards,
>>>>
>>>> Pierre
>
> Of course many banks also allow you to download an electronic
> bank statement. Many use OFX for this, others CVS or something like
> a spreadsheet. It would be nice to be able to
> import that rather than re-type it all.
>
> David
>
>
Re: How to process bank statements
Posted by David Goodenough <da...@linkchoose.co.uk>.
On Tuesday 04 November 2008, Sharan-F wrote:
> Hi Pierre
>
> You are not alone - a lot of places use bank statement processing.
>
> I looked at OFBiz accounts a few months ago and tried to work out how to
> process bank statements – so would be interested in any other replies that
> you get.
>
> The main thing I found was that the GL account for the company cheque
> account doesnt display what the balance is (unless you use the trial
> balance or other reports) so can be difficult to trace what your closing
> balance was in line with your last statement.
>
> One idea I tried was to look at using the Financial Accounts functionality
> as you can input an opening balance and have deposits and withdrawals just
> like you have on a bank statement. It's also a Payment Method Type for
> transactions. The Financial Accounts details can be displayed in Party
> Manager as part of the party record.
>
> The thing I havent sorted out yet is how to mirror the transactions of the
> Financial Account into the equivalent GL account (Eg. General Checking
> Account) so that they stay in synch.
>
> Not sure if this helps you at all but if there are other ways to process
> and track bank statements in OFBiz then I'd be keen to find out about them
> too.
>
> Thanks
> Sharan
>
> Pierre Smits-3 wrote:
> > Is The Netherlands the only country where payments of invoices and cost
> > on bank statements are booked?
> > How is this to be done in OFBiz?
> >
> >
> > On Sun, Nov 2, 2008 at 11:13 PM, Pierre Smits
> >
> > <pi...@gmail.com>wrote:
> >> On bank statements in The Netherlands we have
> >>
> >> - (partial) payments by customers
> >> - (partial) payments to suppliers
> >> - payment of bank costs and others
> >>
> >> Where and how do I process these in OFBiz?
> >>
> >> Regards,
> >>
> >> Pierre
Of course many banks also allow you to download an electronic
bank statement. Many use OFX for this, others CVS or something like
a spreadsheet. It would be nice to be able to
import that rather than re-type it all.
David
Re: How to process bank statements
Posted by Sharan-F <sh...@gmail.com>.
Hi Pierre
You are not alone - a lot of places use bank statement processing.
I looked at OFBiz accounts a few months ago and tried to work out how to
process bank statements – so would be interested in any other replies that
you get.
The main thing I found was that the GL account for the company cheque
account doesnt display what the balance is (unless you use the trial balance
or other reports) so can be difficult to trace what your closing balance was
in line with your last statement.
One idea I tried was to look at using the Financial Accounts functionality
as you can input an opening balance and have deposits and withdrawals just
like you have on a bank statement. It's also a Payment Method Type for
transactions. The Financial Accounts details can be displayed in Party
Manager as part of the party record.
The thing I havent sorted out yet is how to mirror the transactions of the
Financial Account into the equivalent GL account (Eg. General Checking
Account) so that they stay in synch.
Not sure if this helps you at all but if there are other ways to process and
track bank statements in OFBiz then I'd be keen to find out about them too.
Thanks
Sharan
Pierre Smits-3 wrote:
>
> Is The Netherlands the only country where payments of invoices and cost on
> bank statements are booked?
> How is this to be done in OFBiz?
>
>
> On Sun, Nov 2, 2008 at 11:13 PM, Pierre Smits
> <pi...@gmail.com>wrote:
>
>> On bank statements in The Netherlands we have
>>
>> - (partial) payments by customers
>> - (partial) payments to suppliers
>> - payment of bank costs and others
>>
>> Where and how do I process these in OFBiz?
>>
>> Regards,
>>
>> Pierre
>>
>
>
--
View this message in context: http://www.nabble.com/How-to-process-bank-statements-tp20294429p20331484.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: How to process bank statements
Posted by Pierre Smits <pi...@gmail.com>.
Is The Netherlands the only country where payments of invoices and cost on
bank statements are booked?
How is this to be done in OFBiz?
On Sun, Nov 2, 2008 at 11:13 PM, Pierre Smits <pi...@gmail.com>wrote:
> On bank statements in The Netherlands we have
>
> - (partial) payments by customers
> - (partial) payments to suppliers
> - payment of bank costs and others
>
> Where and how do I process these in OFBiz?
>
> Regards,
>
> Pierre
>