Uploading negative cash balances

[introvest]

Hello,

My question is regarding uploading my clients data from Scottrade into fund manager. I am importing positions, prices etc.. but whenever I upload a clients account, there cash balance is incorrect. It is usually a negative number or it is a number that does not coincide with the balance on their statements. Any help you can provide would be greatly appreciated. Thank you.

[Mark]

Hi introvest,

Are you importing positions more than once? You should only ever import positions at most one time to establish a new account. Once you've imported positions once, going forward you should only import transactions. I'm not sure if this is related to your issue, but from your question it sounded like you were importing positions periodically.

To figure out the reason why your cash account has a negative balance, look at the transactions it contains. Use the Data Register, and set the Data Type to "Investments (all)". The balance is simply the sum of all prior recorded transactions. Are the transactions correct? Do you have extras, missing something, etc?

Also, typically with Scottrade you should be using a default cash account. Do you have a default cash account assigned?