Import transactions to multiple accounts in single QIF file

I'm trying to import the same basic transaction into multiple Quicken accounts. I'm generating the QIF file using VBA in Excel.

This is my best effort so far. It is supposed to put the transaction into existing accounts Test3 and Test4.

!Account NTest3 TOth A ^ !Type:Oth A D12/ 1' 5 U30.00 T30.00 PDEC2005 LDues Receivable ^ !Account NTest4 TOth A ^ !Type:Oth A D12/ 1' 5 U30.00 T30.00 PDEC2005 LDues Receivable ^

Quicken Import wants me to identify the account the import is supposed to go into, but one of the choices is "All accounts," which is what I used. It works, but with one small glitch. The transactions don't show up in the transaction register of one of the accounts, although it is definitely there, as reflected in the account balance. If I do something to make Quicken refresh the register, such as sorting into a different order, it shows up. How can I make it "refresh automatically" so the register immediately shows the transaction after the impirt?

TIA

Ed

Reply to
Ed
Loading thread data ...

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.