> On Jul 5, 2024, at 09:09, Ronald Solomon <drsolomo...@gmail.com> wrote: > > I want to import from a CSV file It has both debit and credit transactions. > When I am labeling the CSV columns I don't see where I label Withdrawal and > deposit. My deposits are in one column and withdrawals are in another > column. > I have set up a test GNUCash file and am running test data. It sees the > transactions however, it negates the amount to 0
Assuming that both columns are unsigned and you’re importing into an asset account use Amount for the debit column and Amount (Negated) for the credit column. If you’re importing into a liability account (e.g. credit card) then you may need to flip that depending on your choice for reverse-balance accounts in Preferences>Accounts. If it comes in backwards, meaning that an amount you intend as a debit imports as a credit then reverse the column types. Regards, John Ralls _______________________________________________ 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.
