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
