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.
