Is there a way to change the date on multiple investment transactions at one time?

jmpinternet

Periodically, multiple investment transactions that occur at the end of the month are reported via download as occurring on the last day or two of the month, but the monthly statement displays them as UNSETTLED TRADES, with a posting date in the first days of the following month. This confuses Quicken which then displays, for example, cash balances incorrectly. Manually changing the date on 70 transactions is not very palatable, but you can't select multiple transactions to change the date of all at once. Ideas welcome.

Boatnmaniac

Quicken isn't confused.  It will accurately reflect the cash balance as if the trades have been fully settled but the online cash balance from the brokerage will accurately show the real account cash balance because some of those buy and sell transactions haven't actually been paid for, yet. 

The SEC allows for up to 3 days to settle trades (with no penalty).  Settlements will occur at various times within that window but in the end everything should balance out correctly.

I do not recommend changing trade dates to fix this because:

• At a minimum your account register transactions will no longer reflect your brokerage records.
• The transaction share price will be different from what the NAV share price is for the date the transaction was changed to.
• Quicken and brokerages use the transaction date, not the settlement date, for calculating capital gains (long-term vs short-term) so it has tax implications.
• Quicken's Capital Gains and Schedule D reports might not match the 1099-B forms received from the brokerage.

I think the best thing to do is to wait 3-4 days and run OSU in the evening or the next morning at which time everything should balance out properly, again, and can then be reconciled.  I can wait the 3-4 days.

Boatnmaniac

Quicken isn't confused.  It will accurately reflect the cash balance as if the trades have been fully settled but the online cash balance from the brokerage will accurately show the real account cash balance because some of those buy and sell transactions haven't actually been paid for, yet. 

The SEC allows for up to 3 days to settle trades (with no penalty).  Settlements will occur at various times within that window but in the end everything should balance out correctly.

I do not recommend changing trade dates to fix this because:

• At a minimum your account register transactions will no longer reflect your brokerage records.
• The transaction share price will be different from what the NAV share price is for the date the transaction was changed to.
• Quicken and brokerages use the transaction date, not the settlement date, for calculating capital gains (long-term vs short-term) so it has tax implications.
• Quicken's Capital Gains and Schedule D reports might not match the 1099-B forms received from the brokerage.

I think the best thing to do is to wait 3-4 days and run OSU in the evening or the next morning at which time everything should balance out properly, again, and can then be reconciled.  I can wait the 3-4 days.