Accounting Talk Accounting Talk    FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  most recent reconciliation date for all bank accounts?          Accounting Talk Forum Index -> Quickbooks View previous topic :: View next topic   Author Message notme@nospam.com Guest Posted: Fri Mar 30, 2007 4:30 am    Post subject: most recent reconciliation date for all bank accounts? Using QB Pro 2006, I have upwards of two dozen bank accounts that I am tracking historically over several years (for an estate, not a business). How can I get a simple listing of the last reconciliation date for each account? I can't find any report that supports this. I can go to "Reconcile" and manually click on each account in the drop down list to see the date, but that is unsatisfactory for such a simple requirement. I spent some time searching the group archives and did not find an answer. TIA. Back to top   Ads Advertising Sponsor Peter Saxton Guest Posted: Sat Mar 31, 2007 12:55 am    Post subject: Re: most recent reconciliation date for all bank accounts? On Thu, 29 Mar 2007 23:30:06 GMT, "notme@nospam.com" <notme@nospam.com> wrote: Quote: Using QB Pro 2006, I have upwards of two dozen bank accounts that I am tracking historically over several years (for an estate, not a business). How can I get a simple listing of the last reconciliation date for each account? I can't find any report that supports this. I can go to "Reconcile" and manually click on each account in the drop down list to see the date, but that is unsatisfactory for such a simple requirement. I spent some time searching the group archives and did not find an answer. TIA. It doesn't seem to be possible. I do think it's very easy to use the wrong reconciliation date when doing reconciliations so I wouldn't be too confident that the date is correct. -- Peter Saxton from London peter@petersaxton.co.uk Back to top   Ads Advertising Sponsor MDB Guest Posted: Sat Mar 31, 2007 1:16 am    Post subject: Re: most recent reconciliation date for all bank accounts? The only thing I see in reports is Reports>>Banking>>Previous Reconciliation. <notme@nospam.com> wrote in message news:2_XOh.3184$YL5.1233@newssvr29.news.prodigy.net... Quote: Using QB Pro 2006, I have upwards of two dozen bank accounts that I am tracking historically over several years (for an estate, not a business). How can I get a simple listing of the last reconciliation date for each account? I can't find any report that supports this. I can go to "Reconcile" and manually click on each account in the drop down list to see the date, but that is unsatisfactory for such a simple requirement. I spent some time searching the group archives and did not find an answer. TIA. Back to top   Ads Advertising Sponsor Scott Guest Posted: Sat Mar 31, 2007 7:57 pm    Post subject: Re: most recent reconciliation date for all bank accounts? One way would be to memorize a report on cleared items, which would show you dates of items cleared for a certain period - just go to the last entries & verify the date, should let you know when the last reconciliation was for. I'd set it up as follows: Highlight any bank account in the chart of accounts, select Reports / Quick Report. Select Modify Report / Filters. Under the Account filter choose All bank accounts from the drop-down list. Under the Cleared filter choose Yes. I'd also pare down some items from the Display tab to clear out any columns you don't need to see (leave the date for sure). This will give you a list of all cleared items by bank account & then date - just look at the last cleared items in each account & you should be able to determine the last reconciliation date. You can also adjust the Dates from All to something more manageable such as current year or whatever works for you. Don't forget to Memorize the report once you've tweaked it to your needs. Then you can run it anytime you want to check for recs, again adjusting the dates if needed. Scott out. <notme@nospam.com> wrote in message news:2_XOh.3184$YL5.1233@newssvr29.news.prodigy.net... Quote: Using QB Pro 2006, I have upwards of two dozen bank accounts that I am tracking historically over several years (for an estate, not a business). How can I get a simple listing of the last reconciliation date for each account? I can't find any report that supports this. I can go to "Reconcile" and manually click on each account in the drop down list to see the date, but that is unsatisfactory for such a simple requirement. I spent some time searching the group archives and did not find an answer. TIA. Back to top   Ads Advertising Sponsor Mark Bole Guest Posted: Sun Apr 01, 2007 8:06 pm    Post subject: Re: most recent reconciliation date for all bank accounts? Scott wrote: Quote: One way would be to memorize a report on cleared items, which would show you dates of items cleared for a certain period - just go to the last entries & verify the date, should let you know when the last reconciliation was for. Thanx for the suggestions, the one above is closest to the result. The date surely is stored in the QB database for each account, it seems odd that it couldn't just be an optional display column in a regular report. -Mark Bole Back to top   Ads Advertising Sponsor Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         Accounting Talk Forum Index -> Quickbooks All times are GMT Page 1 of 1   Jump to: Select a forum Accounting Talk----------------Accounting TalkPeachtreeQuickbooksQuicken  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum 68 Attacks blocked Powered by phpBB © 2001, 2005 phpBB Group