The only thing that is of significant value for developers to be working on, would be matching systems that allow disparate accounting systems to communicate with each other to perform the mechanical aspects of managing interparty balances.
The word "reconciliation" has a specific meaning; that is, to identify and/or adjust the differences between two lists that supposedly enumerate the same universe of entries. The creditor and debtor parties in trade (or bank/depositor) maintain separate lists of what is supposed to be the same liability. Most reconciliation differences are business differences and the decision favoring one or the other party cannot be automated. However, the simple identification of those differences is a mechanical matter that should have been automated long ago. And it would have been automated, but for the irresponsible and bad-faith behavior of the leading accounting software vendors, who placed such a high priority on lock-in of users' data that it was adverse to the interests of their own users. And this remains the case today, ten years after the emergence of the commercial Internet with no real end in sight. Todd Boyle CPA - AR/AP everywhere www.arapxml.net You need something like this: http://www.gldialtone.com/UEEN.htm At 06:35 AM 6/25/02, Richard Lyons wrote: >On Tuesday 25 June 2002 11:35, Mark Williamson wrote: >[snip] > > Hmm looks like, not too many people are reconciling their accounts.. > > O.K. they have to be. > > > > Do people mainly use the "Chart of Accounts Report", then click on the > > bank account, that they are reconciling, set the dates for the report, > > and then maybe make a get the report into a spreadsheet, use the > > spreadsheet, for making notes about the reconcile, maybe then adjust > > account for the month to suit, maybe work on all the other accounts till > > they are all reconciled for that month. Maybe use the "audit control" to > > close for that month, as once you have reconciled, as one may not want > > those records to change.. O.K. I haven't tried that method as yet. >[snip] >Well, I had bank reconciliation high on my wish list (posted last Sat). I've >been working on the old "fake it till you make it" basis. That means working >down the screen systematically and ticking off the entries in the bank sheet. > It also means starting from the year beginning every time so as to get a >correct balance. Oh, and I used my primitive perl unskills to hack ac.pl to >print out a final balance after the dr and cr totals. I might yet have it >print cumulative balances on every line if I get to feeling brave. > >I see there is a field called 'cleared' and one called fx_transaction in the >table acc_trans. Both are full of 'f' entries -- I guess that is false for a >binary field (?). I wonder what they do. We really need a 'reconciled' >field, then the hacking for point-and-click reconcilliation should be >straightforward enough. I've been considering taking a bigger risk and >trying to write a special sign (such as ~) to the end of the source field as >entries are reconciled, but that would be a kludge (even by my standards!) >and I do hope someone more expert does the job properly before I get driven >to trying that. > >-- >richard > > >------------------------------------------------------- >Sponsored by: >ThinkGeek at http://www.ThinkGeek.com/ ------------------------------------------------------- This sf.net email is sponsored by: Jabber Inc. Don't miss the IM event of the season | Special offer for OSDN members! JabConf 2002, Aug. 20-22, Keystone, CO http://www.jabberconf.com/osdn
