[GNC] Importing single transactions to separate deposits and withdrawals

[Brad Morrison]

Hi Paul/GNUCash users, 

https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data - this is
the GNC Wiki entry on importing (and exporting) data from GNUCash,
hopefully it is current... 

Speaking of which - what version of GNUCash are you using? 5.11 is the
current version - https://gnucash.org/download.phtml 

What operating system are you using GNUCash on? 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://nextdoor.com/profile/01mP46jj8KCzj3sP4 &
https://norcal.social/@BradMorrison 

On 2025-04-28 06:53, Murugan Mariappan wrote:

> 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.
_______________________________________________
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.