So I searched more in Reddit and GitHub and it seems that this has not been resolved yet. Here's the summary of my findings if any of you would find it useful.
- *May 2023 – rellieberman*: Reported confusion over removal of *Deposit/Withdrawal* fields in CSV import. - *May 2023 – Vincent Dawans, John Ralls*: Discussed renaming *"Amount (Negated)"* to *"Amount (sign-reversed)"* and adding *dynamic labels per account type*. - *May–June 2023 – Community Discussion*: Debated *single-column vs. dual-column support* and whether to use *formal Debit/Credit labels*. - *July 1, 2023 – **dawansv*: moved convo to Bug 798922 - No withdrawal/deposit fields in csv import dialog #1699 and Proposed dynamic column labels based on *base account selection* and UI improvements* commit*: Implemented *dynamic column labels*, added *formal accounting labels*, and updated *import instructions*. - *July 2023 – nomis, flywire, gjanssens*: Suggested keeping *dual-column support* but ensuring *single-column imports work*. - *February 2025 – User Testing (you)*: Found that *single-column "Amount" import does not work*, requiring *dual-column workaround*. - *Current Status*: Feature *not fully functional*; likely *incomplete implementation or a bug*. Bug report recommended. sources https://bugs.gnucash.org/show_bug.cgi?id=798922 and https://github.com/Gnucash/gnucash/pull/1699 On Sun, Feb 9, 2025 at 12:38 PM Gio Bacareza <gbacar...@gmail.com> wrote: > Dear Brad and Others, > > Thank you for your response. > > I appreciate the link you provided, but it seems to only discuss QIF > conversions. While I may consider QIF in the future, I'm currently looking > for guidance specifically on the new CSV import fields in GnuCash 5.10. > > I've used CSV import successfully in the past. However, the recent update > introduced new terminology (Amount, Amount (Negated), Transfer Amount, > Transfer Amount (Negated)) that I'm struggling to understand in relation to > my previous CSV structure. > > I have already searched the GnuCash documentation and wikis, but I haven't > found any information about these new terms. The documentation still seems > to refer to the old "Withdrawal" and "Deposit" fields. > > For example from > https://www.gnucash.org/viewdoc.phtml?rev=5&lang=C&doc=help, this is what > it says: > > """ > > The dropdown list of *GnuCash* transaction data fields which may be > associated with a column of the imported data contains the following: > > - > > *None*: The column is not assigned to a transaction data field and is > not imported; > - > > *Date*: Ensure the date format in the column matches the Miscellaneous > date Format Setting; > - > > *Num*: Transaction Num field - Use for check numbers etc.; > - > > *Description*; > - > > *Notes*; > - > > *Transaction Commodity*; > - > > *Void Reason*; > - > > *Action*; > - > > *Account*: This header should be matched to a column specifying the > source account for a transaction if it is present. Otherwise, set the > source account in the *Account* combo box; > - > > *Deposit*: Apply this header to a column containing the amount of the > transaction. Positive amounts in the column generally represent an increase > in the account balance and negative amounts a decrease in the balance > (asset accounts: Checking, Savings). In external statements supplied by a > bank for a check or savings account, a credit (Cr) is normally an increase > in the account balance and a debit (Dr) a decrease in the account balance. > In the banks eyes, your savings or checking account is a Liability to them; > > If the amount data is in separate columns for debits and credits you > will have to apply both this heading and the Withdrawal heading. > - > > *Withdrawal*: Apply this header to a column with the amount of the > transaction where positive amounts in the column represent a decrease in > the account balance and negative amounts an increase in the balance (e.g. > Liability account: credit card). > > """ > And from > https://www.gnucash.org/docs/v5/C/gnucash-manual/trans-import.html#idm6675 > : > """ > > The import panel shows the data being imported as it is interpreted using > the settings chosen to define columns and formats. The dropdown lists in > the headers for each column of the import allow you to associate a specific > column in the imported data with a specific field in the display of a > transaction in an account register. At a minimum to import data, columns in > the imported data containing the following information *must* be > specified: > > - > > *Date*: of transaction; > - > > *Account*: into which transaction is to be imported (or alternatively > set the base account as above); > - > > *Description*: of the transaction; > - > > *Deposit or Withdrawal*: column. > > """ > > There is no mention at all of the new terms: *Amount, Amount (Negated), > Transfer Amount, Transfer Amount (Negated)* > > I would be grateful if you could provide clarification on the new CSV > field names and how they should be used. > > By the way, I'm on MacOS Sequoia 15.3 > > Sincerely, > Gio > > > > On Sat, Feb 8, 2025 at 7:57 PM Brad Morrison <bradmorri...@sonic.net> > wrote: > >> Hi Gio/GNUCash users, >> >> https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data - here is >> the FAQ section on importing & exporting data, you could also try >> searching the GnuCash Wiki for more information for "CSV" >> >> In addition, which operating system are you using? >> >> --- >> Thanks, >> >> Brad - https://www.facebook.com/brad.morrison.12327/ & >> https://nextdoor.com/profile/01mP46jj8KCzj3sP4 & >> https://norcal.social/@BradMorrison >> >> On 2025-02-07 22:04, Gio Bacareza wrote: >> >> > Dear GnuCash Community, >> > >> > I recently upgraded GnuCash on my Mac to Version 5.10 and noticed a >> > significant change in the CSV import feature. The "Deposit" and >> > "Withdrawal" fields have been replaced with "Amount," "Amount >> (Negated)," >> > "Transfer Amount," and "Transfer Amount (Negated)." >> > >> > My previous CSV structure was straightforward: date, description, >> account, >> > transfer account, withdrawal, deposit. I'm having trouble understanding >> the >> > differences between the new fields and how they relate to my old CSV >> > format. I've searched the documentation, but it doesn't seem to be >> updated >> > yet, as it still refers to withdrawals and deposits. >> > >> > Could you please clarify the purpose of each new field and provide >> guidance >> > on how to map my old CSV data to the new format? >> > >> > Thank you for your time and assistance. >> > >> > Sincerely, >> > Gio >> > _______________________________________________ >> > gnucash-user mailing list >> > gnucash-user@gnucash.org >> > To update your subscription preferences or to unsubscribe: >> > https://lists.gnucash.org/mailman/listinfo/gnucash-user >> > ----- >> > Please remember to CC this list on all your replies. >> > You can do this by using Reply-To-List or Reply-All. >> _______________________________________________ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> ----- >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > > -- > cheers, > > Gio > -- cheers, Gio _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
