Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Schwab Cash Transactions

Questions about updating prices or transactions in Fund Manager

Postby crawfordn » Tue Aug 15, 2017 9:21 am

Marc,
Since the last update cash disbursements are creating a "client" security and debiting it while making a corresponding purchase of the default cash account. I have to manually remove the client security and change the default cash account item to a sell. For the moment, I will just uncheck these transactions on the download and do them manually. Am I missing something? Rick
crawfordn
 
Posts: 56
Joined: Wed Nov 14, 2007 10:54 am

Postby Mark » Tue Aug 15, 2017 9:27 am

Hi Rick,

Are you retrieving transactions (OFX) or importing them from a *.TRN file?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby crawfordn » Tue Aug 15, 2017 10:27 am

I am importing them via a .trn file from Schwablink.
crawfordn
 
Posts: 56
Joined: Wed Nov 14, 2007 10:54 am

Postby Mark » Tue Aug 15, 2017 10:30 am

Hi Rick,

Do you have on the import option "Combine All Cash Transactions Into Default Cash Account"?

It sounds like you do have a default cash account assigned, correct?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby crawfordn » Tue Aug 15, 2017 10:35 am

I do have the combine all on and there is a default cash set.
crawfordn
 
Posts: 56
Joined: Wed Nov 14, 2007 10:54 am

Postby Mark » Tue Aug 15, 2017 10:39 am

Could you email me the .TRN file that causes one of these? You can edit it first to change the account number to something like 12345. Just keep the same number of digits. The .TRN file is a text file, so you can edit it with something like Notepad.

I just sent you an email, so you can reply to that.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby Mark » Tue Aug 15, 2017 11:11 am

Hi Rick,

Thanks for the file. You sent a CS<date>.TRN file. Those are Schwab's older file formats. I'd recommend only downloading/importing their new core B/D files. This newer transaction file has a filename format of CRS<date>.TRN. When importing, only import the CRS files if you have both. If you're importing all files in a folder, move/delete the CS files before importing, or just don't download the CS files to begin with.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby crawfordn » Tue Aug 15, 2017 11:14 am

Thanks Mark,
I will investigate and adjust he download accordingly. Rick
crawfordn
 
Posts: 56
Joined: Wed Nov 14, 2007 10:54 am

Postby crawfordn » Tue Oct 17, 2017 11:09 am

Hi Mark,
I've just updated to FM 2018 and it looks excellent. Answers a lot of issues. Regarding the Schwab downloads, I am now working off the new versions and have found one problem. When foreign dividends are distributed, I also receive appropriately distributed expenses for ADR fees and foreign taxes. FM seems to be reading the ADR fee correctly as a debit but is crediting the foreign tax amount. I'm not sure if this is a Schwab issue or FM... Rick
crawfordn
 
Posts: 56
Joined: Wed Nov 14, 2007 10:54 am

Postby Mark » Tue Oct 17, 2017 11:23 am

Hi Rick,

Were you importing these correctly in Fund Manager 2016? Maybe you can email me a sample transaction file that shows this problem?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby crawfordn » Tue Oct 17, 2017 11:30 am

This problem is unrelated to the 2018 update. It began when the new Schwab import module appeared and appears to relate to the newer Schwab Transaction files. I will email a copy.
Rick
crawfordn
 
Posts: 56
Joined: Wed Nov 14, 2007 10:54 am

Postby Mark » Thu Oct 19, 2017 11:53 am

Thanks Rick. I see the issue, and we'll have it fixed for the next release.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby crawfordn » Fri Oct 20, 2017 8:28 am

MAny Thanks as always.
Rick
crawfordn
 
Posts: 56
Joined: Wed Nov 14, 2007 10:54 am


Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 10 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.