[GNC] Importing single transactions to separate deposits and withdrawals

[Murugan Mariappan]

Paul

Import the file into your bank account and select "amount" as the column header.  The import will process it into debits and credits based on the sign of the number.




Saludos Cordiales


Murugan

________________________________
From: gnucash-user <gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org> on behalf of Paul-A via gnucash-user <gnucash-user at gnucash.org>
Sent: 28 April 2025 09:17
To: David Carlson <david.carlson.417 at gmail.com>
Cc: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
Subject: Re: [GNC] Importing single transactions to separate deposits and withdrawals

The format is CSV... not sure if I follow your later suggestion,
but will give it a try to see what I get.

On Mon, Apr 28, 2025 at 01:14:21AM -0500, David Carlson wrote:
> Paul-A,
>
> The possible solution would be different for each type of import.  Please
> tell us if you can import in OFX or QFX format, QIF format or CSV format.
>
>
>
> On Mon, Apr 28, 2025 at 12:35 AM Paul-A via gnucash-user <
> gnucash-user at gnucash.org> wrote:
>
> > I had a bank account, thankfully only for a few months, that exported
> > debits and credits as negative and positive values in the same column.
> >
> > I suppose it'll be easy enough to massage this through awk or perl for
> > import into gnucash, but might there already be some canned solution to
> > handle this situation?
_______________________________________________
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.