Importing CSV Files
The CSV (comma-separated values) format is essentially a table of rows and columns, like a spreadsheet. It is very versatile and not specifically designed to contain financial information.
As such there is no standard way for a bank to store data in such a file. There is no standard order for the columns in a CSV file or names for those columns.
As a result of this, the import process for CSV files is much more involved than any other standard format.
For this reason, we recommend using either OFX, QFX or QIF files for importing your data whenever possible. The steps for importing these files are outlined in this article.
OFX and QFX files are the best formats to download, with QIF files being the second best and CSV files being a distant third.
Importing CSV Files -
If CSV is the only file format your bank provides, you can follow the steps below to import -
Open Moneydance and choose File > Import.
Then select the CSV file.
You should check and amend the import settings -
-
Specify the account you'd like to import data into.
-
"Field Delimiter" is the character that's used in your CSV file to separate the fields.
Comma is quite common and so is tab. If you're unsure, select comma. -
You may need to change the date format so it matches the format used within the CSV file.
This isn't always the format you expect i.e. It won't necessarily be the date format you use in Moneydance -
Then specify either a period
.
or comma,
as the decimal used in the file and click Next.
If you're unsure of any of these settings, you can check.
To do this, open the CSV file with a text program like NotePad or TextEdit.
This will allow you to view the file contents and you can check the delimiter, date format and the decimal used.
The next window displays a list of fields.
Each of these fields represents a column in the CSV file.
E.g. The first field (at the top of the list) is the first, left most column in the CSV file.
The second field (just below this) is column 2, to the right of the first column in the file, and so on...
You need to select the Moneydance transaction field that corresponds with the column in the CSV file.
To do this we suggest opening your CSV file in a spreadsheet program (like Excel or Numbers).
This will allow you to see which column is which, and use that as a reference to match the different field values to the corresponding columns in the CSV file.
Use the "More Fields" and "Fewer Fields" buttons to adjust the number of fields to import, corresponding to the number of columns in your CSV file.
The number of fields you set should match the exact amount of columns within the CSV file.
Do not include extra fields and assign them as 'Ignore'.
Do not leave out any fields because you don't want to import the data from those columns.
Set the exact number of fields to match the number of columns in the CSV file.
Then (using the CSV file contents as a reference) specify what data is included in each column.
When you're happy with the import settings, click "Finish" to import the file.
Importing transactions with this method will import them as "Unconfirmed", as though they have been downloaded from your bank. You should go through the confirmation process to handle the downloaded data.
If you need to import CSV transactions from other personal finance software (rather than from a financial institution), you should use the "Text File Importer" extension instead. You should refer to the 'Extensions' section of the knowledge base here for more information about downloading and using this extension.
CSV Importing Problems -
If data has been imported, but the information displayed is incorrect (or some data is missing) then it's most likely that the wrong settings were selected during the import process.
You can create a new dummy/test account - this will allow you to test the import settings until you find the correct settings to use, without affecting your existing accounts.
To do this, choose Account > New Account.
Create a "Bank Account" and name it something like "Import Test".
Once you've determined which settings you need, you can delete the "Test" account without affecting your other accounts or balances.
You can then proceed to import your data into the correct account, using the correct settings.
If you're unsure which import settings to use, you can contact the support team by emailing support@infinitekind.com, or create a private discussion on the support forum.
It would be useful for you to send a copy or sample of the CSV file with your support request.
-
Purchasing and Upgrading
-
Getting Started
-
Accounts and Categories
-
Register and Transactions
-
Online Banking and Bill Pay
-
Moneydance+
-
Popular Banks
-
Navigating Moneydance
-
Budgeting
-
Reminders
-
Graphs and Reports
-
Syncing and Sharing Data
-
Backups and Exporting
-
Investment Accounts
-
Loan Accounts
-
Currency and VAT/GST
-
Importing Data from Other Programs
-
Customizing and Preferences
-
File Locations and Changes
-
Foresight
-
Extensions
-
Linux
-
Older Versions
-
ARCHIVE - Getting Started
-
ARCHIVE - Moneydance 2017
- Archive - Moneydance 2017 license keys and upgrade policy
- Archive - Upgrading to Moneydance 2017 from Moneydance 2012, 2014 and 2015
- Archive - Upgrading to Moneydance 2017 from Moneydance 2011 or earlier
- Archive - Changing colours and theme in Moneydance 2017
- Archive - Sharing data using the Moneydance 2017 syncing engine
- View all (15 more)
-
ARCHIVE - Moneydance 2014 and 2015
- Archive - Moneydance 2015 license keys and upgrade policy
- Archive - Upgrading to Moneydance 2015 from Moneydance 2012 and 2014
- Archive - Upgrading to Moneydance 2015 from Moneydance 2011 or earlier
- Archive - Opening a backup file in Moneydance 2015
- Archive - How to restore from a checkpoint in Moneydance 2012 and 2014
- View all (3 more)
-
ARCHIVE - Program Basics
-
ARCHIVE - Account Basics
-
ARCHIVE - Entering Transactions
- Archive - Does Moneydance allow for assigning 'classes' to transactions?
- Archive - How do I get the Register to auto fill todays date instead of the last entered date?
- Archive - How do I move a transaction to a different account?
- Archive - How do I enter my Paycheck?
- Archive - How do I create a split transaction?
- View all (2 more)
-
ARCHIVE - Online Banking
-
ARCHIVE - Mobile
- Archive - Syncing Moneydance 2015 with your Mobile Device
- Archive - Syncing Moneydance 2012 and 2014 with your Mobile Device
- Archive - How to sync with Moneydance 2008, 2010, and 2011
- Archive - How do I delete a transaction on the iPhone, iPad, or iPod touch?
- Archive - How to sync one data file with multiple iOS devices using different Dropbox accounts
- View all
-
ARCHIVE - Budgeting and Reminders
- Archive - Creating reminders (automatic repeating transactions or notes)
- Archive - Creating a budget using the 'Newer' format
- Archive - Creating a budget using the 'Mixed Interval' (Older) format
- Archive - What's the difference between a General and Transaction reminder?
- Archive - How do I have a reminder automatically entered into my register?
- View all (1 more)
-
ARCHIVE - International Tools
- Archive - Setting up VAT/GST
- Archive - Can you change the word "Check" to "Cheque" anywhere in the programme?
- Archive - How can I enter the exact amounts on both sides of a foreign currency transfer?
- Archive - My household/country/company uses a fiscal year instead of a calendar year. Can I do this in Moneydance?
- View all
-
ARCHIVE - Investments
- Archive - How do I add Securities to a new Investment Account?
- Archive - How can I import security, stock or mutual fund prices?
- Archive - Entering your current holdings
- Archive - Creating a new investment subtype
- Archive - Downloading security, stock or mutual fund prices from non-US stock exchanges
- View all (5 more)
-
ARCHIVE - Extensions
-
ARCHIVE - Everything Else