Mike, if the specific import value is positive: 1. import "Amount" results in a debit entry. 2. import "Amount (Negated)" results in a credit entry.
if the specific import value is negative: 1. import "Amount (Negated)" results in a debit entry. 2. import "Amount" results in a credit entry. You also can use both columns, and if you only use positive values [import values are all greater than or equal to zero]: "Amount" is for debits | "Amount (Negated) is for credits The debits and credits switched if the sign of your import value is switched. > On 04/06/2026 7:58 AM PDT Mike Brasler <[email protected]> wrote: > > > Thank you John Ralls. > > I have always saved the csv import as there are two, one from Amazon, > one from bank, same names as the .CSV files. > For some reason after import for February and all preceding months, they > were not available in March for selection. > It required me to re-create them, no real problem there, but when the > amount column needed selection, I noticed "Negated" (Forgotten or new?) > Previously had used "Value" > > I think I know where the CSV import "went"... > I had to re-instate a backup copy as the main file, renaming the > original as xxxxx.gnucash.broken and renaming the timestamped one as > xxxxx.gnucash > Is it possible that the book file was lost there? > > That aside it leads me to the question below... > > I did the import and had to later swap all DR and CR in the register as > the signage was incorrect. > > The Amazon CSV import has expenses as unsigned (+) numbers. > The Bank CSV import has expenses as signed negative numbers. Credits are > unsigned. > > Which "Value" or "Amount" should I select for the above? (It has worked > for months and been so long since I have had to go to that heading) > > Thank you for working through this with me. I really appreciate being > here and not being the smartest guy in the room. > > Mike. > > > > > > _______________________________________________ > gnucash-user mailing list > [email protected] > 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 [email protected] 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.
