Bulk Reconcile Tweak

[elliots]

Mark,
Two minor low priority suggestions. Just started using Bulk Reconciliation which I really like. Suggestion 1: The position file to use defaults to the current date -- I don't know about other users, but I'm always using the prior day's statement file and have to change it. It would be nice if the default date was the prior business date. Second: If I look at a sub-portfolio and select Reconcile, the screen shows the correct date last reconciled (from the bulk reconcile) but the statement date shown looks like the date of the file I last used when individually reconciling the account - I'd rather see the date of the file used in the bulk reconciliation.

[Mark]

Hi elliots,

Glad you like the feature, it does make for a good time saver. Thanks for the idea on defaulting to the prior business day. Makes sense...

There is only 1 "last reconciled" date per sub-portfolio. Whether you reconciled using the individual account method, or bulk reconcile, either way will set the last reconciled date. You must "Finish" the reconciliation though, or else it won't be updated. So, if you are using the bulk reconciliation wizard, and run it to look at the results, but do not click "Finish", your last reconciliation dates will not be updated. I'm guessing this is the case here. Clicking "Cancel", or hitting the "Close" button in the upper-right, exit the bulk reconciliation wizard without making any changes to the last reconciliation dates. Please let me know if this doesn't fix this issue.

[elliots]

Mark,

I'm pretty sure I finish the bulk reconcile and the "date last reconciled" field is showing the date of the bulk reconciliation. I'm talking about the (below) Statement Source:Statement File fill-in field where an older file date is appearing by default -- that's the file reference I'd like to see be the file used in the bulk reconciliation.

Elliot

[Mark]

Hi Elliot,

When you open up the individual account reconciliation from the bulk reconciliation wizard, the statement file is filled in by default with the file that was used in the bulk reconciliation. In the bulk reconciliation wizard you are entering a date, and a folder. FM figures out what statement file has positions for that date in that folder, and uses that file. This same file should be filled into this statement file edit box when you select a sub-portfolio, and choose "Reconcile...". Is this not happening this way for you? You shouldn't have to change that filename when opening up this dialog from the bulk reconciliation wizard. What is the source of your statement file (which broker)?

[elliots]

Mark,

Sorry to be causing all this fuss over a minor point. Here's what's happening. I finished a bulk reconciliation a few days ago ( almost certainly 1/6). Today I opened a sub-portfolio to check something and didn't remember when I had last reconciled, so I right-clicked and opened the Reconcile Wizard in that sub-portfolio. The Reconciliation Wizard showed the 1/6/11 date, but the lower fill-in field showed the source file with a date of 12/31/10. The broker is Scottrade.

[Mark]

Hi Elliot,

Thanks, I understand now. You are opening the account reconciliation directly, instead of from the bulk reconciliation wizard. This makes sense... Defaulting this to the last used file from either the individual or bulk reconcile makes sense.