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 that any other standard format.
For this reason, we recommend using either OFX, QFX, OFC or QIF files for importing your data whenever possible. OFX and QFX files are the best format, with QIF files being the second best and CSV files being a distant third.
Importing CSV Files -
Navigate to File --> Import, then select the file CSV you'd like to import.
You can then choose the import settings.
-
Specify the account you'd like to import data into.
-
'Fields Delimiter' is the character that's used in your CSV file to separate the fields. Comma is quite common and so is tab, but if you're using something different you can specify that as well. If you're unsure, select comma.
-
You may also need to change the date format to the format used within the file.
-
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, open the CSV file with a text program like NotePad or TextEdit. This will allow you to see the file contents and you can check the delimiter, the 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. "Field 1" is the first, left most column in the file. "Field 2" is column 2, to the right of the first column, 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 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 - rather than including extra fields assigning them as 'Ignore'.
Click "Finish" to import the file.
CSV Importing Problems -
If data has imported, but the information displayed is incorrect (e.g. dates are wrong) then it's possible the wrong settings were selected during the import process.
You can create a new dummy account by selecting Account --> New Account. Using this new account will allow you to test the import settings, until you find the correct settings to use. When you're done, you can delete the 'Test' account without effecting 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 by creating a discussion on the forum.
Importing transactions in this way will import them as 'unconfirmed' and as though they have been downloaded from your bank.
If you need to import transactions from other personal finance software, you should use the 'Text File Importer' extension instead. You can refer to the 'Extensions' section here for more information.
-
Purchasing and Upgrading
-
Accounts and Categories
-
Register and Transactions
-
Budgeting
-
Online Banking and Bill Pay
-
Moneydance+
-
Reminders
-
Graphs and Reports
-
General
-
Investment Accounts
-
Loan Accounts
-
Syncing and Sharing Data
-
Currency and VAT/GST
-
Backups and Exporting
-
Importing Data from Other Programs
-
Customizing and Preferences
-
File Locations and Changes
-
Foresight
-
Extensions
-
Moneydance 2017
-
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