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/
