[GNC] Bump-Import Saved Settings Gone (John Ralls)

[Patrick James]

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 <mike at gilana.org> 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
> gnucash-user at 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.