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 <[EMAIL PROTECTED]> 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 > >>> > >>> <[EMAIL PROTECTED]>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 > > > > > >
