With Hurdlr, you can link your banks and credit cards to automatically track your finances, however, there may be situations where you’re not able to automatically import transactions that you need, such as:
Your bank or credit card isn’t supported and can’t be linked in Hurdlr
You’d like to pull in transactions dating further back than your bank shares with third parties
You don’t want to link your bank/credit card and prefer to track transactions manually
In these cases, Hurdlr Premium allows you to upload a CSV file (spreadsheet) of your bank statement, credit card statement, or even transactions from an app that you used before Hurdlr.
Preparing Your CSV for Import
To use this feature, you’ll first need to download the file from your bank or other app. If you have an option to choose the format, choose CSV. If you don't see that option, select any spreadsheet option available and resave it as a CSV file.
For best results, we recommend using one of the following date formats for the date field when uploading a CSV file into your Hurdlr account:
MM/DD/YYYY (ex: 01/02/2024 is January 2nd, 2024)
MM/DD/YY (ex. 01/02/24 is January 2nd, 2024)
Linking Your CSV Imported Transactions to a Bank Account
If you would like to tag the transactions in your file to a specific bank account or credit card, ensure that you have added that account as a Manually Tracked Account in Hurdlr. The next section will go over how to use that account during the CSV Import process.
To Import your CSV File into Hurdlr
Log into the web app on your computer at web.hurdlr.com/login.
Click the gear icon on the top right
Select ‘Import Income’ or ‘Import Expenses’
On the Import screen, use the drop-down to select if you want to import ‘Both Expenses and Income’, ‘Expense Only’, or ‘Income Only’ from your file
If you added a manual bank account/credit card, select the one to which you’d like to tag these transactions
Select ‘Add File’
Choose the CSV file from your computer
Click ‘Next’ in the top right corner
Assign the columns from your spreadsheet by clicking the drop-down next to each field and selecting the corresponding header for the column with that data
10. Click ‘Next’ in top right corner
11. The overview page will list all of your transactions from the file; you can deselect the checkbox next to any transaction that you do not want imported. You can also reverse the amounts if you mapped the amount column incorrectly.
12. Click ‘Done’
13. You’ll get a pop-up notifying you that the import is complete, click ‘OK’
Once you complete the import of the CSV File, you can then navigate to the Income and/or Expenses tab and start tagging these imported transactions as either Business or Personal.