Ability to import net worth data from other personal finance apps, such as Mint (edited)
Comments
-
Can we also allow downloading the Net Worth over time in a .CSV format (similar to transactions)? Is this something that was ever considered?
1 -
Hello @Matt Anfang,
There are a couple Idea posts that are close to what you're asking for. I'd recommend that you take a look and add your vote:
I hope this helps!
-Coach Kristina
1 -
I was able to find a workaround for the painful account by account method which seems to be breaking a lot for people, especially with investment accounts. In Quicken Simplifi I created a manual asset account (other asset) and set the balance to zero. I named this account "Mint Net Worth History." Then I checked my net worth history in Quicken Simplifi and saw I only had history starting November 2023. So I went into Mint in the Trends→Net Worth area and selected to export a .csv with all accounts selected and all time selected. I followed the formatting requirements of the .csv import (not mint import) required by Quicken simplifi when you select that option. This required some editing and formatting of the csv file.
-I deleted the rows containing November 2023 and later so it wouldn't double up on the already imported history.
-I had to change the DATE column title to Date and set the dates to mm/dd/yyyy format (be sure to include the preceding zeroes). You can accomplish this by creating a new column of dates starting on say 04/01/2010 and then 05/01/2010 and then create a box around those and drag down to repeat the pattern through the years then paste that into the dates column.
-I deleted the columns for Assets and Debts and only kept the column called Net and renamed it to "Amount."
-I changed the values in the Amount column away from currency to just number and selected the option to remove the commas from the number as well. So it should look like 145256.51 instead of $145,256.51.In Quicken simplifi I selected the import historical data within the net worth area and selected the "Mint Net Worth History" account I previously created as the account I wanted to upload to. Upload the .csv and presto, all history is there. It takes a few minutes in excel or whatever spreadsheet editor you're using, but it works and is much faster than importing one account at a time.
This method obviously will not break out assets, debts, investments, etc when you look at that dropdown in Simplifi, however the historical nets will be there and for me having history back to 2010 in Mint it is nice to have moved over.
6 -
Thanks @Coach Kristina
0 -
These are excellent instructions, thank you!
I also started with Simplifi in Nov 2023.
The only tweak I needed to make in order to get this to work for me, was instead of deleting the rows, I added the following values to my CSV (b/c without this data, Simplify thinks the "Mint Net Worth History" amount for the months between 11/01/2023 and 03/11/2024 is equal to the the amount from 10/01/2023, and it throws off the Simplifi Net Worth number in reports:
Date 11/01/2023 Amount 0.00
Date 12/01/2023 Amount 0.00
Date 01/01/2024 Amount 0.00
Date 02/01/2024 Amount 0.00
Date 03/01/2024 Amount 0.000
