hehe -- well that is exactly how i did it -- but in order to do so i had to use beginning & ending balances in reconcile fields (i needed Something to put in those boxes -- i needed the running balance in q since i don't have statements any longer... respectfully - if had MW had a running balance - i could have looked down the running balances that until the two apps didnt match in running balance - which would have quickly pointed out the start of date range of issue and from there the charge/payment issue... much quicker than manually going month by month...
i tried to reconcile 1998 to 2009 - failed, then tried 2 yrs- failed, then 6 months failed, had to do 1 month in 2001... and then each month for about 8 months before i noticed the pattern of 1 transaction per month that had been imported wrong as a payment instead of a charge... at that point i sorted by that payee - converted them to charges ... (and i really wanted a way to pre-back up or undo this major change in data if i was wrong at the time) i also had to enter zero as starting balance for 1998 - as that 1st charge was a charge -- not just a starting balance (well it was a starting balance charge... )... so i had to infer it was zero before that date. after i did all that i was able to reconcile from dec 01 to jun 09...and that took 5 hours... and a vmware windows session.... and a wish that i had known it was off when i imported way back when... (the biggest confusion being i thought it was reconciled cause the reconcile status was imported for each transaction way back when...and current month reconciles were all working fine...) also i dont have 'ten years' of data really (and i don't know why this is - but it goes back to q) there is only 1 transaction in 1998... then it jumps to 2001 (perhaps an archive etc.. of course i have no idea where that data went but its gone from q to)... i keep that data for warranties etc... (in fact q has all the receipts for that data attached.... still working on getting those into mw). but because there is that one transaction from 1998 -- i had no way of getting statement balances for that... or anything up to 5-2003 when i have e- statements. i will be honest - i completely ignored the bottom daily balance... and frankly rarely use it as i find it hard to read (on my mac its dark grey on a grey background).... :) i generally use the left hand balances in the account list. ah well - everyone looks at a data differently :) ml On Jun 2, 5:57 pm, Kevin Hoctor <ke...@nothirst.com> wrote: > On Jun 2, 2009, at 2:13 PM, ciara belle wrote: > > > ok -so i had to open q up - this is another argument for running > > balances...and get balances from there - and compare transactions- as > > that was the only way i could reconcile back to 1998... i only have e- > > statments to 2003... and no paper statements from ten plus years > > ago... looks like a bunch of the same type of transaction (payee) all > > imported as payment rather than charge... so i had to go month by > > month for all of 2001 - then i was finally able to reconcile it up to > > today... > > > what a mess > > Actually, I think this is an argument against running balances. Now > I'm a programmer so I think in efficient algorithms but if I had 10+ > years of data (first I wouldn't keep it all on one document, I'd have > a history document and a current one), I would split the list in half > until I found the problem. I'd check the end transaction and then the > first one. If the first is right and then end is wrong, I'd got to the > middle. If the middle was right, then I'd split the list again in the > first half. > > I only check the daily balance at the bottom a few times until I > isolate the day of the balance problem. Then I only have to fix that > single day of transactions. This is very quick because 10,000 > transactions goes down to a handful in just a few iterations. > > Peace, > > Kevin Hoctor > ke...@nothirst.com > No Thirst Software LLChttp://nothirst.comhttp://kevinhoctor.blogspot.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "No Thirst Software User Forum" group. To post to this group, send email to no-thirst-software@googlegroups.com To unsubscribe from this group, send email to no-thirst-software+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/no-thirst-software?hl=en -~----------~----~----~----~------~----~------~--~---
