Import Excel File or PDF

Brendan's Avatar

Brendan

30 Jan, 2016 03:08 PM

Hi, can you import a bank statement in excel format or PDF format? Thanks

  1. Support Staff 1 Posted by Ethan on 30 Jan, 2016 03:31 PM

    Ethan's Avatar

    Hello,

    A PDF file won't work, but you could possibly convert a spreadsheet to a CSV file and import that. First though, make sure your bank doesn't offer files in the OFX, QFX, OFC, or QIF formats (sometimes called Quicken or MS Money files). Any of those will import easily into Moneydance by selecting the downloaded file using the File -> Import option.

    If all you have to work with is an Excel file, you'll want to save this as a CSV file in Excel. The CSV format is essentially a flat table of rows and columns. It is very versatile and it is not specifically designed to contain financial information. As such there is no standard way a bank would use to store data in such a file. Which is to say 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.

    The 'Text File Importer' extension allows you to specify which columns in a CSV file should correspond to which fields in a Moneydance transaction. This can be installed within Extensions --> Manage Extensions.

    Once you have installed the 'Text File Importer' a new menu item will be available at Extensions -->Text File Importer. Select this and you will be presented with a window asking you to browse to the CSV file you want to import. Click the browse button and browse to the CSV file, then click next.

    The next window allows you to specify the account you want to import the data into. You can also specify if the fields in the file a separated by a tab or a comma. You may also need to change the date format to that used in the file. Click Next.

    You will then be presented with a window that has a list of fields. Each of these fields represents a column in the CSV file. e.g. "Field 1" is the first column in the file and "Field 2" is column 2. You need to select which Moneydance transaction field should correspond with which field in the CSV file. You will need to open your CSV file in a text editor and take a look at it to determine which column is which.

    The first time you attempt this, you may want to create a test account, as initially you may have to try different date formats on import to get your data imported correctly. If you go to Account --> New account, and name the file 'TEST', you can mess around with the import of CSV without effecting your other data. Once you've imported this data with the correct settings, you can delete the test account.

    Again, since there is no standard format for CSV files, there is unfortunately no guarantee this will work, as banks can send their data out in all kind of strange formats.

    If you haven't already, I encourage you to download our free trial version from http://infinitekind.com/downloads and experiment with the program before you decide if you would like to purchase it. The demo version is fully functional and allows you to manually enter 100 transactions. Imported transactions are not limited, so you'll be able to fully test things like importing from other programs and connections with your bank. If you decide to purchase the program at a later date you can keep all your data, the license key simply unlocks the ability to manually enter more transactions.

    In case you haven't found it yet, our full user guide can be downloaded from http://help.infinitekind.com/kb/user-guides

    Ethan
    Moneydance Support

  2. System closed this discussion on 30 Apr, 2016 03:40 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac