Adding Balance History entries from exported Mint data

Ask Anything
1

Hi,
I have a lot of balance history exported from Mint that I would like to add for my accounts. The article
‘Understanding the Balance History Sheet’ doesn’t quite match the content I see in the Balance History sheet.

I think I can map everything needed from my Mint export to the actual sheet columns, except for ‘Balance ID’. Is ‘Balance ID’ important? Can I leave it blank? If I can’t leave it blank, does it have to be unique for each row?

Thanks

2

Welcome to the Tiller Community!

That is populated when new balances are brought in through the tiller service, leaving them blank with self imported data from mint will have no ill effect on any of the templates.

Carry on!

1 Like
3

I do want to add that the Balance ID column is pretty important for any future troubleshooting purposes with your data that pulls in, so please don’t remove it :slight_smile:

1 Like
4

That is true, i have had to troubleshoot some of mine previously for duplicating with support and they did need those.

5

Hi @smf ,
How were you able to export balance history from Mint?
I am following this Reddit post and updating the calendar to a Jan 1 to Dec 31 timeframe for each year going backwards from 2022 to when my accounts started. Each of these will generate a CSV file with a number next to an account. Is this your method as well? If so, are you then just appending those CSV values into the Balance History sheet with the Tiller provided names for each account?

@morgan - Is this appending at the end of the Balance History safe to do with respect to future imports that Tiller might perform? I figured yes, but just wanted to confirm since I will be adding close to 10 years worth of balance history (expecting to append close to 100 lines).

6

I used a chrome extension called “Mint Data Exporter, by Monarch Money”. It put all the balance histories in separate csv files.

Then I added and re-arranged columns using data from the accounts in Tiller. I just cut and pasted the results of my editing into the balance history sheet. There may be an easier way, but that worked for me.

I have excel, so I edited the csv files in that.

Make sure all of the columns show the data, if the column is too narrow, it may show ######, and that will be what is pasted, not the actual data.

In excel, you can get the week and month of a date using these formulas (may work in google sheets too). Assuming the date you want to get month and week from is in column A –
To convert date to start of week date
=A2-WEEKDAY(A2)+1
To convert date to start of month date
=A2-DAY(A2)+1

1 Like