YNAB imports creating false totals from Investment/Brokerage accounts
I typed this up once already and it didn't post... just deleted :|
Anyway, love the app, it's been really useful since day one... Until I started linking/tracking my investment accounts. The issue I'm posting about is related to 2 accounts I have with the investment company called Betterment. The two accounts I have are (1)High yield savings account and (2)Build Wealth stock portfolio.
With my Savings account, I will transfer $ from my bank into this account which YNAB records on import. Then, when that company invests in stocks like it's supposed to, YNAB imports those stock purchases as inflow. Virtually doubling the amount of money I actually have in that account. Basically: transfer $, $ gets invest, YNAB imports/reports that acount as having $x2 which is grossly innaccurate.
The second issue regarding my investment account is similar. But instead the only account activity being imported into YNAB is dividend gains. No losses and no consulting fees that are represented in the portfolio account activity. An example would be: I invest $1000(not real numbers) and I gain $100 in dividends. Then, I lose $50 in fees and market drops but YNAB does not import that information which then says that the account is worht $1100 when in reality it's $1050.
I've been dealing with this for quite some time and the frustration of deleting imported info, deleting/editing or reconsiling the accounts is finally too much for me not to seek out help.
I'm hoping this might be an issue due to my ignorance and not YNAB, because if it's YNAB I'm having a difficult time believing that something this ridiculous exists with this program.
Thanks for taking the time to read this.
YNAB doesn't automatically adjust your investment account balance in response to changes in asset values. The way many people handle this is to just do an occasional reconciliation of the investment tracking account, enter the current balance, and let YNAB make an adjustment. I do this once per quarter or so.
As for the savings account, what kind of account is this? I got confused when you said "when that company invests in stocks." If it's investing in stocks, it's not a savings account. If it is a savings account, contact YNAB support. Sometimes they can help with Direct Import problems, sometimes not, but it's definitely worth a shot.
James Daniel Salazar said:
Anyway, love the app, it's been really useful since day one... Until I started linking/tracking my investment accounts.
YNAB is not designed to track investments. People who want to track net worth in YNAB typically update investment account values manually, on whatever frequency they find to be the best balance between labor and timely information.
Personally, I don't bother including investment accounts in YNAB. I need YNAB to manage my budget, and, to a lesser extent, my cash flow. I have a better solution for tracking investments with Quicken, or even just looking at my broker's web site.
Hi James Daniel Salazar !
Patzer and mamster are correct.
Since the transaction data for investment/loan accounts is handled differently than that of checking/savings/CC accounts, these have always proven a bit difficult when it comes to direct import. We’re currently looking into ways of improving that handling on this end, but for now, if the transactions import incorrectly (or don’t import at all), that’s expected behavior.
The good news is, since investment/loan accounts are typically (read: recommended) added as Tracking accounts, they don't affect your daily budget. With that said, we certainly understand the motivation for tracking your net worth, so here's an easy way to manage them without direct import:
- Set up the account as an Unlinked Tracking account. (Tracking > Asset or Liability)
- Create a Scheduled Transaction to show your regular contributions or payments.
- Update the balance like this as it changes, or as frequently as you wish.
Let us know if you have any questions about that! :)
People who want to track net worth in YNAB typically update investment account values manually, on whatever frequency they find to be the best balance between labor and timely information.
The Net Worth report has a resolution of one month, so updating with the end of month balance on investment accounts is sufficient for long-term data.
I have several tracking investment accounts, some with direct import. You are correct, the Betterment direct import is nearly useless. The suggestions of nolesrule and Faness are better than what I've been doing. So far, I import everything, approve the Dividend entry and reject all of the Stock Buy or Sell transactions. Busy work, and probably not worth it. Once per month manual adjustment is plenty of information for tracking net worth.