If you're transitioning from Mint to Tiller you can use these steps to help get your data out of Mint and into your Tiller spreadsheet.
Steps for Google Sheets
1. Start with the Foundation template for Google Sheets
You can skip these steps if you've already started a Google Sheet with Tiller Money Feeds
On the Console click "Create a spreadsheet" and then Start with Google Sheets
Follow the instructions on the Install Help tab to install the Tiller Money Feeds add-on and feed your bank data into the Google Sheet
2. Get your data out of Mint
Log into your Mint.com account.
Choose the Transactions menu option.
Click the export link at the bottom of the page to automatically download a CSV file of your transactions.
3. (optional) Grab your categories
If you've already spent some time setting up Categories in your Foundation template you probably want to skip this step. If you're brand new to Tiller you may want to quickly get started with those existing categories from Mint and customize later.
Navigate to your Google Drive at https://drive.google.com
Drag & drop your Mint CSV export into your Google Drive
Double click the CSV file and choose "Open with Google Sheets" at the top
Use the quick formula below in a blank cell to grab a unique list of categories from your data
Copy the list of categories
Paste it into the Categories sheet and overwrite the example categories by right clicking and choose Paste Special > Values only
=unique(F2:F)
4. (optional) Clear your transaction data
If you'd like to just move over the Mint data with all the categorizations, and you have all your data up to today's date, you can clear the Transactions sheet making sure to leave the header row (row 1).
Alternatively, you can just bring in a segment of historical data that pre-dates the Transaction data Tiller was able to automatically pull into your Google Sheet.
5. Import your Mint CSV
Choose Tools > Import CSV Line Items
Upload the Mint CSV from your computer
On the summary screen, choose a date range for the data you'd like to add to the Tiller-powered sheet
Click "Add to Transactions sheet"
Manual workflow
In the Google Sheets version of the Mint export from step 3 above, delete the column used to create the unique list of categories
Delete Notes and Labels columns if not using
Add a column header in the first empty column to the right called "Corrected Amount"
Paste the below formula into the first cell in that column (row 2) to get the corrected amount data for your transactions, which should pre-fill to all subsequent rows
Add a new column header called "Final amount" to the right of the "Corrected Amount" column
Copy the data from the "Corrected Amount" column and paste special > Values only into the "Final Amount" column
Delete the Corrected Amount, Amount, and Transaction (type) column as those are no longer needed
Rearrange columns so they are in the following order Date, Description, Category, Amount, Account name
If you're wanting to copy over the data from the Notes or Labels columns from Mint you'll need to add those columns in the appropriate place in the Tiller Transactions sheet before proceeding to step 6.
Delete the Original Description column
=ARRAYFORMULA(IF(E2:E="debit",-D2:D,D2:D))
6. Move your Mint data to Tiller
Select all the data in the Mint export from row 2 (do not copy row 1) to the last cell
Copy the selected data
In your Tiller Transactions sheet, select the first empty cell in the Date column (do not select row 1)
Right click and choose Paste Special > Values only
6. Customize Categories
You can customize your categories on the Categories sheet. You can totally re-think the way you want to categorize transactions. Update category names or delete ones you no longer want or need. Each category should have a Group and a Type.
To update Transactions that have already been categorized:
Turn on the Filter in the Transactions sheet
Sort the Category column from A>Z
Update one invalid entry (red triangle in upper right)
Use the quick fill square to update the other entries
Repeat for each category you want to adjust
Alternatively, you can use AutoCat and run it on "All Transactions" to help you update categories and build a ruleset for ongoing automatic categorization.
7. Start Budgeting
Set your Budget targets for each category on the Categories sheet in column E (you may need to expand these columns.) These values will cascade across to all months in the budgeting year. Edit any month directly.
Steps for Microsoft Excel
1. Start with the Foundation template for Microsoft Excel
You can skip these steps if you've already started a Excel workbook with Tiller Money Feeds
On the Console click "Create a spreadsheet" and then Start with Microsoft Excel
Follow the instructions on the Install Help tab to install the Tiller Money Feeds add-in and feed your bank data into the workbook.
Note if you don't see the My Add-ins option on the Insert ribbon, check the Home ribbon.
2. Get your data out of Mint
Log into your Mint.com account.
Choose the Transactions menu option.
Click the export link at the bottom of the page to automatically download a CSV file of your transactions.
3. (optional) Grab your categories
If you've already spent some time setting up Categories in your Foundation template you probably want to skip this step. If you're brand new to Tiller you may want to quickly get started with those existing categories from Mint and customize later.
Open the CSV file you downloaded from Mint in Microsoft Excel
Use the quick formula below in a blank cell to grab a unique list of categories from your data - you should input your last row number where it says "use last row number" in the formula
Clear out the example categories in your Foundation Template's Categories sheet
Copy the list of categories from the Mint export
Paste it into the Categories sheet column A by right clicking the first empty cell in the Category column and choose Paste Special > Values only
=unique(F2:F[use last row number])
4. (optional) Clear your transaction data
If you'd like to just move over the Mint data with all the categorizations, and you have all your data up to today's date, you can clear the Transactions sheet making sure to leave the header row (row 1).
Alternatively, you can just bring in a segment of historical data that pre-dates the Transaction data Tiller was able to automatically pull into your Google Sheet.
5. Prep Mint data for Tiller
Delete the column used to create the unique list of categories
Delete Notes and Labels columns if not using
Select all the data in the export and choose Format as Table from the home ribbon and click OK in the pop up
Add a column header in the first empty column to the right called "Corrected Amount"
Paste the below formula into the first cell in that column to get the corrected amount data for your transactions, which should pre-fill to all subsequent rows
Add a new column header called "Final amount" to the right of the "Corrected Amount" column
Copy the data from the "Corrected Amount" column and paste special > Values only into the "Final Amount" column
Delete the Corrected Amount, Amount, and Transaction (type) column as those are no longer needed
Rearrange columns so they are in the following order Date, Description, Category, Amount, Account name
Delete the Original Description column
=IF(E2="debit",-D2,D2)
6. Move your Mint data to Tiller
Select all the data in the Mint export from row 2 (do not copy row 1) to the last cell
Copy the selected data
In your Tiller Transactions sheet, select the first empty cell in the Date column (do not select row 1)
Right click and choose Paste Special > Values only
7. Customize Categories
You can customize your categories on the Categories sheet. You can totally re-think the way you want to categorize transactions. Update category names or delete ones you no longer want or need. Each category should have a Group and a Type. Group is the bigger bucket that categories fall into.
To update Transactions that have already been categorized:
Use the filter in the Transactions sheet
Sort the Category column from A>Z
Update one invalid entry (red triangle in upper right)
Use the fill handle to update the other entries
Repeat for each category you want to adjust
Alternatively, you can use AutoCat and run it on "All Transactions" to help you update categories and build a ruleset for ongoing automatic categorization.
8. Start Budgeting
Set your Budget targets for each category on the Categories sheet in column E (you may need to expand these columns.) These values will cascade across to all months in the budgeting year. Edit any month directly.