All Collections
Income & Expense Tracking
Tracking Income & Expenses
Can I import my bank transactions from a spreadsheet/CSV file?
Can I import my bank transactions from a spreadsheet/CSV file?
Ashleigh Rockwell avatar
Written by Ashleigh Rockwell
Updated over a week ago

You can upload a CSV file (spreadsheet) of your bank statement, credit card transactions, or even transactions from an app that you used before Hurdlr. This can be helpful for tracking historic data or transactions from an unsupported bank.

To use this feature, you’ll first want 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, then select any spreadsheet option available and resave it as a CSV file.

Now that your file is ready, log into the web app on your computer at web.hurdlr.com/login.

If you would like to tag the transactions in your file to a specific bank account or credit card, first ensure that you have added that account/card as a Manually Tracked Account in Hurdlr. Then, follow these steps:

  1. Click the gear icon in the top right corner

  2. Select “Import Income” or “Import Expenses”

  3. On the Import screen, use the drop-down to select if you want to import Both Expenses and Income, Expenses Only, or Income Only from the file you will be uploading

4. If you added a manual bank/credit card, select the one to which you’d like to tag these transactions

5. Select "Add File"

6. Select the file you want to upload

7. Click "Next" in the top right corner

8. Assign the columns from your spreadsheet by selecting the drop-down next to each field and selecting the corresponding header for the column with that data.

NOTE: If importing both income and expenses, you can select the 2 columns option if your income and expenses are listed in separate columns. For example, if your spreadsheet has one column for positive amounts (i.e., deposits/income) and one column for negative amounts (i.e., withdrawals/expenses), you’d want to select the “2 columns” option and select the correct column heading for the Amount (Out) (i.e., expenses) and Amount (In) (i.e., income). If your bank shows positive and negative numbers in the same column, you should not select the “2 columns” option.

8. After mapping the file columns, click "Next" in the top right corner

9. The overview page will list all of your transactions from the file. You can deselect the checkbox next to any transaction that you don’t want to import

10. Once you’re ready to import the selected transactions, click "Done"

11. You’ll get a pop up letting you know the import is complete and can click "OK"

You can then go to the Income and/or Expenses sections and tag your imported transactions.

If you're having trouble importing a CSV file, try these formatting tips:

If you have any questions about this process or run into any issues, please reach out to our Customer Success team via in-app chat (tap on the chat icon in the top left corner of the mobile app or the question mark icon in the top right corner of the web app) or email at hello@hurdlr.com for assistance.

Did this answer your question?