Linking downloaded entries between accounts

I have successully downloaded enties from my checking account for 2004 and 2005 and also from multiple other accounts, such as a Vanguard mutual fund account and a credit card account.

My checking account reflects numerous downloaded entries for automatic purchases in the Vanguard account and reflects the monthly on-line bill-pays from the checking account to the credit card account.

The downloaded transactions in the Vanguard account also reflect each of the transactions in which shares of mutual funds were automatically purchased with funds from the checking account.

The downloaded transactions in the credit card account also reflect each of the transactions in which the monthly bill was paid on-line with funds from the checking account.

So, with downloaded data, on the one hand, the checking account correctly shows each entry for purchasing mutual fund shares and for paying the monthly credit card, and the latter two accounts appears to correctly reflect each of those events.

However, the entries in the checking account don't reflect the transactions as linked between the checking acct and the Vanguard and credit card accounts, and when I edit the checking account entry to correctly reflect the xfer, it creates an additional entry in the other, corresponding account (the Vanguard or credit card acct).

Your thoughts, plz, on best ways to handle this.

Thx much.

Reply to
baldeagle333
Loading thread data ...

There is an easy solution and an easier solution.

The easy solution is to download from your bank first and then before yo udo the other downloads(or at least before you accept the transactions) you modify those transactions in your banking account that are transfers, You do that by putting the target account in the category field. (Eg. If your vanguard account is called "Vanguard", then the category for the transfer to Vanguard is "[Vanguard]"). Now when yo uaccept the transactions in your Credit card and Vanguard accounts, they will "match" those transfers and won't create duplicate entries.

The easier solution is to schedule those transfers to Vanguard so that they are automatically entered into your accounts. Then when you download, they will be matched without you having to do anything. For the credit card payments, when you make the payment, enter it in your register, so that it will not need modification when you download.

Reply to
Mike B

Thx, Mike. I'll experiment with your options next weekend. Appreciate your help.

Reply to
baldeagle333

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.