I suggest you ...

CSV and Other Import

Currently the CSV (and other like QIF) import dialog is very strict and gives NO facility for MAPPING of accounts to CSV columns etc.
No info on whether to put last column in csv as expenses:Office_Expenses or only Office_Expenses? and then whether gnucash is configured to show
only last of account names or fully qualified names. I tried BOTH combinations, still gnucash Fails EVERYTIME to map accounts.
behaviour I saw was - it maps ALL the entries to one account ( like all csv rows to Office_Expenses !!!)

Then - in last import dialog, we get mapped (or imbalance) accounts which are always distorted
and then I have to keep double clicking EACH row !!! to map it to particular a/c.
I can't even tell gnucash to repeat same for other rows !!!

So first item would be to have

A. Proper and EASY dialogs in Import Wizards

B. It should also allow - while mapping - as debit or credit columns corresponding to accounts

C. Import should be able to read FIRST line of csv file as Column-Headers and use it in mapping

109 votes
Sign in
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Sandeep shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  AdminGeert Janssens (Admin, GnuCash) responded  · 

    Thank you all for the feedback.

    The csv importer is currently being improved on the development branch. Several of the missing parts mentioned here are already being addressed, such as:

    - ability to select transfer account
    - ability to import files exported from gnucash
    - remember account mappings for a future import


    Sign in
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      • Evgenii Pashkin commented  ·   ·  Flag as inappropriate

        "- remember account mappings for a future import"
        This still don't go to official release.
        Any reason for that?
        Other parts of import works very good, big thanks.

      • Herwig commented  ·   ·  Flag as inappropriate

        I agree the "import transactions from CSV" needs further improvment.
        i would like to be able to import data like the following automatically from one file:

        <TransactionNumer> ; <Date> ; <Account_From> ; <Account_To> ; <Description>


        at the moment you only seem to be able to import transactions for one account-from at the time.
        it semms to be the same with with the invoice importer function, a file like the following would import
        all the invoices to Customer 00001


      • Larry Alan Smith commented  ·   ·  Flag as inappropriate

        [GnuCash 2.6.15]
        I download my financial transactions in CSV format from various banks and credit unions.
        Many of the dollar amounts are whole numbers (e.g., $123) with no cents.
        When $123 is imported, it is imported as $1.23, not $123.00.
        I have found no way around this issue.

      • Flickem commented  ·   ·  Flag as inappropriate

        Have to add my disappointment too. CSV import is badly implemented. Why can't CVs's exported from GnuCash itself not be read easily. Needs attention

      • Jonathan commented  ·   ·  Flag as inappropriate

        This is a big problem in my view. I want to be able to use a Python script to quickly clean up the transaction file I get from my bank, and then import that file to Gnucash. However, because I can't add the destination account programmatically, this save much less time than it could.

      • Jakub Narębski commented  ·   ·  Flag as inappropriate

        I think it should be possible to *both* design some column as having name of "category" (destination account) and category to destination account mapping like for QIF import.

      • Anonymous commented  ·   ·  Flag as inappropriate

        The key thing for me is the ability for the CSV being imported to contain a column that specifies the destination account in the "Transfer" column, and for GNU Cash to use this instead of prompting for this information.

      • Sandeep commented  ·   ·  Flag as inappropriate

        If needed I can explain problems encounterd by me in more detail...but in general the CSV Import looks very bad as compared to whole other product i.e. GNU Cash.

      Feedback and Knowledge Base