The fix for Mint's CSV and JSON export file mess

Options
nothin7
nothin7 Member ✭
edited April 15 in Share your Success!

A helpful Redditor made a script that merges the CSV files provided by Mint and Monarch's Chrome extension:

https://www.reddit.com/r/mintuit/comments/18q8r1m/beware_if_youre_exporting_your_mint_data/

The problem for me was that Mint's CSV (generated after March 23, 2024) included duplicates, and Monarch's Mint CSV changed all subcategories (custom or default) to the parent category. Interestingly, half of my categories were missing from the Mint JSON export file that the "Export Mint to Simplifi" extension generated—not from the transactions themselves, but from the "categories" JSON property, which meant the transaction subcategory within the "transactions" JSON property was seemingly randomly assigned. I spent much of this weekend Javascripting the JSON file (to remove duplicates and restore descriptions/categories) before realizing this. Between the Mint CSV, Mint JSON, and Monarch CSV, a single transaction had three different categories. The Python script linked above finally allowed me to accurately import thousands of meticulously labeled and categorized transactions.

Tagged:

Comments

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Comment As ...

Categories