I had to experiment with the fields to find that amount negated worked the best for me.
Make a copy of your file and run experiments using the different amount fields to see what happens. Once you find a setup that works for you, switch back to your production file and move forward. On Sat, Feb 8, 2025, 20:39 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 > _______________________________________________ > 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.
