Import bank fil

Jarle Lidal's Avatar

Jarle Lidal

11 Jun, 2020 06:15 PM

Hi
I am Norwegian, and have no change bank to the Norwegian bank Nordea. They does not support Direct Connect, and the only fils I can download is PDF or XLS.
How can I get this XLS fil imported?
It looks like this:
COLUMN A: emty
COLUMN B: date: 2020.05.29
COLUMN C: emty
COLUMN D: transfer type
COLUMN E: emty
COLUMN F: shows the shop I have been to...
COLUMN G: emty
COLUMN H: amount out of the account
COLUMN I: emty
COLUMN J: amount into the account

  1. 1 Posted by mhoggie on 11 Jun, 2020 06:51 PM

    mhoggie's Avatar

    Just a user,
    Open your xls file with Excel and "save as" csv (comma delimited). Then you can import the CSV file with Moneydance.

    If you don't have Excel, you can get a free compatible spreadsheet program called Softmaker Office. There spreadsheet program (PlanMaker) will load XLS files and save as CSV.

  2. 2 Posted by -Kevin N. on 11 Jun, 2020 07:09 PM

    -Kevin N.'s Avatar

    Hi Jarle Lidal,

    As forum member mhoggie mentioned, you will first need to open your bank's XLS file in Excel and use the 'Save As' option to Save the file as a CSV (comma separated value) file. (sometimes referred to as a comma delimited file).

    You should now have an Eksempel.csv file.

    Open Moneydance.
    From the Menu bar, go to File > Import.
    A file browser will open allowing you to navigate to the Eksempel.csv file that you just created.
    You should then be presented with a form similar to the attached screenshot.
    (Import_CSV_1.jpg)
    Make sure to set the Date Format: to 'Year Month Day'.
    Click 'Next'.
    In the resulting form, set the fields as displayed in the attached screenshot.
    (Import_CSV_2.jpg)
    Click 'Finish'.
    Look to the attached screenshot of the register.
    (Import_CSV_3.jpg)
    If the transactions look OK to you then that is all you need to do.
    The importer should remember the settings going forward.

    If there is something that is not OK with the transactions, let me know and you can explain what you would need changed.

    -Kevin N. (not a member of MD support)

  3. 3 Posted by Jarle Lidal on 14 Jun, 2020 01:49 PM

    Jarle Lidal's Avatar

    Thanks :)

    Med vennlig hilsen
    Jarle Lidal
    Tlf 900 90 625
    On 11. jun. 2020, 20:51 +0200, mhoggie <[email blocked]>, wrote:

  4. 4 Posted by Jarle Lidal on 14 Jun, 2020 02:32 PM

    Jarle Lidal's Avatar

    Hi again
    This is not working.
    I am following your lead, but nothing is coming in to the account??
    Se pictures

    Med vennlig hilsen
    Jarle Lidal
    Tlf 900 90 625
    On 11. jun. 2020, 21:09 +0200, -Kevin N. <[email blocked]>, wrote:

  5. 5 Posted by Dan P on 14 Jun, 2020 02:57 PM

    Dan P's Avatar

    Hello,

    I am another user. I noticed in your Excel file you have two sheets. The first is blank. Perhaps that is the reason. Make sure you select the correct sheet before saving as csv.

    Good Luck!

    Dan

  6. 6 Posted by Jarle Lidal on 14 Jun, 2020 03:10 PM

    Jarle Lidal's Avatar

    Hi
    Yes, I have deleted the empty one, still not working.

    Med vennlig hilsen
    Jarle Lidal
    Tlf 900 90 625
    On 14. jun. 2020, 16:58 +0200, Dan P <[email blocked]>, wrote:

  7. 7 Posted by -Kevin N. on 14 Jun, 2020 03:39 PM

    -Kevin N.'s Avatar

    Hi Jarle Lidal,

    Can you attach your converted Eksempel.csv file?

    -Kevin N. (not a member of MD support)

  8. 8 Posted by Dan P on 23 Jun, 2020 06:49 PM

    Dan P's Avatar

    Jarle Lidal,

    Just curious if you've resolved this and how. I have a friend who is considering Moneydance and his data file will be Excel too.

    Thanks!

  9. 9 Posted by Jarle Lidal on 23 Jun, 2020 07:16 PM

    Jarle Lidal's Avatar

    Hi Dan
    No, my Excel file will not work臘‍♂️

    Med vennlig hilsen
    Jarle Lidal
    Tlf 900 90 625

  10. 10 Posted by -Kevin N. on 23 Jun, 2020 08:24 PM

    -Kevin N.'s Avatar

    Hi Jarle Lidal,

    Again, can you attach your converted Eksempel.xls file that you saved as a CSV file? e.g. Eksempel.csv

    With the CSV file that you are attempting to import we may be able to discover the anomaly as to why it is not importing for you.

    -Kevin N. (not a member of MD support)

  11. 11 Posted by Jarle Lidal on 24 Jun, 2020 05:36 PM

    Jarle Lidal's Avatar

    Hi Kevin
    Here is a file + a picture of different files I can save the excel document to. I have tried all of the CSV types of files, but it won’t work.
    Picture 1, 2 and 3 shows how I am importing the fil. Picture 3 shows that nothing is imported.

    Thanks

    Med vennlig hilsen
    Jarle Lidal
    Tlf 900 90 625
    On 23. jun. 2020, 22:24 +0200, -Kevin N. <[email blocked]>, wrote:

  12. 12 Posted by -Kevin N. on 24 Jun, 2020 06:02 PM

    -Kevin N.'s Avatar

    Hi Jarle Lidal,

    Your Test.csv file uses a semi-colon ( ; ) as the Field Delimiter and a comma ( , ) as the Decimal Point.

    Try changing those two settings on the importer. Doing so, I was able to import your Test.csv file.

    A useful tip is that you can open any CSV file in a simple word processor to see what it uses for a delimiter, decimal point and how the Date is formatted.

    -Kevin N. (not a member of MD support)

  13. 13 Posted by Jarle Lidal on 24 Jun, 2020 06:16 PM

    Jarle Lidal's Avatar

    Yes, it's working.
    Thank you Kevin!

    Med vennlig hilsen
    Jarle Lidal
    Tlf 900 90 625
    On 24. jun. 2020, 20:02 +0200, -Kevin N. <[email blocked]>, wrote:

  14. 14 Posted by -Kevin N. on 24 Jun, 2020 07:01 PM

    -Kevin N.'s Avatar

    Hi Jarle Lidal,

    You're welcome. I'm glad to hear that you were able to get it working.

    Thank you for reporting back with your results.

    -Kevin N. (not a member of MD support)

  15. Maddy closed this discussion on 24 Jun, 2020 09:56 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