Downloading transactions

gsealbe's Avatar

gsealbe

11 Jan, 2018 11:09 PM

I tried again. After downloading transactions from my bank and using the FILE > IMPORT facility I am only able to obtain the first transaction in the download CSV file. I don't have the ability to use the OFX or QFX format - only CSV. My purchasing MD relies on my being able to download transactions from my bank which is a NON US bank.
If I can't download then I really can't purchase. Please respond soonest.

  1. 1 Posted by dwg on 11 Jan, 2018 11:31 PM

    dwg's Avatar

    I' just a user.

    Your CSV files appears to be inconsistent

    Look at the first two lines:

    ,-67.44,EFTPOS COLES 0673 MORNINGTON AU,,5/01/2018 4/01/2018,-42.98,EFTPOS WW PETROL 3006\WODONGA VIC AU,,

    In row 1 the date is at the end in row 2 it is at the beginning of the row.

    A CSV file MUST be consistent, every column must be in the same place in each row. I would expect the date to be the first value.

    The importer will not deal with this, you could not really expect it to.

    On my cursory look the rest seems to be OK.

    Are you sure that CSV is the only option, most Australian banks at least provide QIF, that format has been a standard for years in the finance space.

  2. 2 Posted by gsealbe on 13 Jan, 2018 12:07 AM

    gsealbe's Avatar

    Hey thnx for that. How the date got transported to the end I do not
    know.However I revisited the CSV issue and whilst my ANZ bank does not
    provide an OFX outright it does so by captioning it a 'Quicken file'. I
    missed this at first, but when I selected the 'Quicken' format everything
    worked perfectly. I'm really pleased because I believe MD to be a very good
    platform.
    I thank you again. You mentioned that your a user; how would you rate the
    software and the support?

  3. 3 Posted by dwg on 13 Jan, 2018 01:31 AM

    dwg's Avatar

    A Quicken file will either be a QIF or a QFX file, both will work and a damn sight easier and better than a CSV file.

    I used Reckon before Moneydance and i have to say that that software was the most complete, if bloated solution, to deal with that company however makes dealing with Telcos, banks, energy companies etc look almost a pleasure. My computer was failing and trying to deal with them and convince them that I did have a failed machine and was not trying to just install it on a second box was something I dreaded not to mention trying to convince them again when I bought a replacement, and they would have charged me $4.95 a minute while I was trying to convince them....

    In my search I looked at a lot of programs, overall I felt Moneydance was the best, although not complete, it was and is still lacking in the area of share investments, I live in hope, many other programs were not as good as Moneydance in this area. If you just have Bank and Credit card accounts you will have no problems.

    Official support can be somewhat patchy, really good at times and sadly lacking at other times. The user base can be very helpful.

  4. 4 Posted by roddurston on 13 Jan, 2018 01:56 AM

    roddurston's Avatar

    Hi Graham

    I'm an ANZ customer and I can download a Quicken QIF file and this works really well with MD.

    Regards Rod.

  5. 5 Posted by gsealbe on 13 Jan, 2018 10:46 PM

    gsealbe's Avatar

    Australia is playing catch up with Personal Finance Platforms. As yet we
    don' have MINT and the market is dominated by RECKON. There are a number of
    systems offered but they all have some limitations, sometime important
    limitations. They are basically geared to budgeting and don't provide a
    broad spectrum of facilities. In my search I happened upon MD and I like it
    very much. I'm a retired accountant and the MD format is very familiar to
    me. However MD does not support synchronization to my ANZ bank so therefore
    the direct download was an important issue. Thnx again for your help.

  6. 6 Posted by dwg on 14 Jan, 2018 07:29 AM

    dwg's Avatar

    As far as I am aware no Australian Bank supports Direct Connect, most banks that do are in the U.S. market, so I would not be hopeful of it ever coming here. Web Connect is developed by Quicken, I've never found any public specs for it so believe it is a proprietary solution. Given Reckon's involvement with Quicken (Intuit) they probably could have implemented Web connect in their product, but I do not expect the Australian banks would be interested, Reckon, used to at least, bank with ANZ so if they do not offer it ....

    Hence we only have the capability to download Quicken files - whether they be either QIF or OFX files, this is basically the capability that is offered in most parts of the world however so most places are pretty equal in this regard.

  7. 7 Posted by gsealbe on 15 Jan, 2018 12:18 AM

    gsealbe's Avatar

    I'm assuming 'Direct Connect' is the same as synchronization. There are
    multiple software such as MoneySoft, Money Brilliant, MyProsperity, and
    few that do synchronize with Aussie Banks. That being said I wonder why MD
    would not offer a synchronization option with the ANZ bank which trades
    worldwide.

  8. 8 Posted by dwg on 15 Jan, 2018 03:42 AM

    dwg's Avatar

    Direct Connect is the Open Financial eXchange standard for passing financial information.

    http://www.ofx.net/

    If a bank provides this service to their customers then Moneydance will work with it.

  9. 9 Posted by gsealbe on 15 Jan, 2018 08:15 PM

    gsealbe's Avatar

    I raised the Direct Connect issue with the support team and their response
    is as follows:

    // Please reply above this line
    ==================================================

    *From*: Ian O (Support staff)

    Hi Graham,

    There are two methods that personal finance software can use to access your
    accounts: Direct Connect and Web Connect.

    With *Web Connect*, the software basically connects to your bank's website
    and downloads and imports OFX, QFX, QIF, and OFC files automatically. This
    is likely what other personal finance softwares are using to connect with
    your bank.

    *Direct Connect* actually connects to a server at your bank instead of
    their website and usually requires different login credentials than you
    would use to log into your banks website. I'm afraid there are few banks
    outside the US that support this connection method.

    Moneydance only supports automatic connections through Direct Connect and
    not Web Connect.

    You can view a list of our supported financial institutions here -
    http://infinitekind.com/fi
    Unfortunately, it appears your bank does not support direct OFX
    connections, which Moneydance requires to talk directly to a bank.

    The best way to get your files into Moneydance is to use a web browser to
    download them from your bank's web site. You can download into QFX, OFX or
    OFC files (aka Quicken or MS Money files), any of which will import cleanly
    into Moneydance.

    You can also open your bank's download page directly (after entering the
    appropriate address in the Account --> Edit Account menu) by going to the
    menu bar and selecting Online --> Open Account Website, which makes the
    download process easier.

    I hope this information is helpful, please let me know if I can be of
    further assistance.

    Ian O
    Infinite Kind Support

  10. System closed this discussion on 16 Apr, 2018 08:20 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

Recent Discussions

27 May, 2018 10:46 PM
27 May, 2018 10:46 PM
27 May, 2018 08:16 PM
27 May, 2018 07:44 PM
27 May, 2018 06:13 PM