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.

Reply to
notme
Loading thread data ...

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.

Reply to
Peter Saxton

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.

Reply to
Scott

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

Reply to
Mark Bole

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.