[GNC] Importing to Gnucash

John Ralls jralls at ceridwen.us
Fri Jul 5 12:58:45 EDT 2024



> On Jul 5, 2024, at 09:09, Ronald Solomon <drsolomondc at 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


More information about the gnucash-user mailing list