How do I covert a csv spreadsheet to a QFX file?

Question

I have downloaded last year's account entries from my bank which will only download in a csv format. I am using Quicken 2020 - Home, Business & Rental Property. How do I make the conversion and/or which is the best converting software?

Btw, when I ran the One-Step Update it only updated/downloaded the last 6 months, not the entire year.

Many thanks in advance.

mshiggins · Answer

@Reese Shellman you may wish to review this recent discussion on the same topic:

https://community.quicken.com/discussion/7884668/how-to-convert-xlsx-or-csv-to-qfx-for-importing#latest

Reese Shellman · Answer

QP, thanks for the response.

Assuming that the financial institution only can/will provide the csv file then is there a preferred converter? Manual entry of 6+ months of data would be a monumental task that I would rather not have to undertake!

Quicken Paloma · Answer

Hello @Reese Shellman,

Thank you for reaching out to the Quicken Community. We apologize you are having this issue. To clarify, the financial institution would be the one that needs to provide a QFX formatted file. If the financial institution can not provide a QFX file, the other alternative would be manual entry.

In addition, it is completely normal for Quicken to not download an entire year's worth of transactions. Typically only 87-90 days will be downloaded using the One-Step Update feature.  We apologize for any confusion.

Please let us know of any other questions or concerns.

-Quicken Paloma