[GNC] importing csv and negative numbers (gnucash-user Digest, Vol 231, Issue
David Carlson
david.carlson.417 at gmail.com
Mon Jun 13 14:41:30 EDT 2022
I would think that the import mapping process feature that separately maps
debits and credits could handle that issue. If not, it might be possible
to pre-process the csv so it could be mapped.
On Mon, Jun 13, 2022, 9:14 AM Kevin T via gnucash-user <
gnucash-user at gnucash.org> wrote:
> I haven't seen a singular reply to the question, so I am replying to the
> gnu cash list directly.
> This is windows and the version is 4.1+ (3/26)
> The bank provides data with debits in a different column than the
> credits. The debits are always positive, the credits are always negative.
> For Stan. It is a). It may be consistent, and appropriate. But this
> consistently difficult to manage.
> A negative value in a credit column as provided by the bank is getting
> converted to a debit. This makes sense. But, that means that ALL entries
> are converted to a debit. The positive entries in the debit column become
> 'charges' and the negative entries in the credit column also become
> 'charges'. Unless I look at the CSV file to see which entries are
> negative, I have no way of knowing which entries are 'supposed' to be
> credits.
> I could write a sed script to remove the '-' signs from the file, I could
> also just edit the csv by hand for this bank which we all know that is what
> we are trying to avoid, hand edits. I am operating in the windows env and
> I haven't installed all the unix features, so the sed script wont work for
> me. Nor do I really want to install all the unix features.
> The correct solution is have the bank a) stop using two columns and
> continue to use positive and negative numbers. or b) continue to use two
> columns and remove the negative numbers from all columns. I am pretty sure
> that getting the bank to change behaviors is exceedingly unlikely. But, I
> can ask you guys to add an option to remove negative values to the import
> flow. Or, have the option to preprocess the csv file with a some script to
> achieve the desired results. There are already a number of features to
> ease the import task. This solution is a singular button with a singular
> line of code behind the button. OK maybe two lines of code, one to check
> if it is a number and another to change sign.
> I tested with two options.a) removed the negative values with a text
> editor. This worked and the values showed up in the correct column in
> gnucash.b) during the import, i told the import tool to import both the
> credit and debit columns as 'withdrawal'. No changes to the file itselft.
> This also worked ! The entries showed up in the proper columns in
> gnucash. Give the coders an attaboy for not imposing strict usage on the
> importer.
> The b solution is the winner! no edits needed.
> The b solution is a bit counterintuitive. Having a button to remove
> negatives, makes more sense. It might also solve this issue a bit quicker
> to the next new user who runs into this.
>
> Kevin
>
> On Monday, June 13, 2022, 12:35:18 AM CDT,
> gnucash-user-request at gnucash.org <gnucash-user-request at gnucash.org>
> wrote:
>
> Send gnucash-user mailing list submissions to
> gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
> 1. Re: questions on 4.1 (Chris Good)
> 2. Re: questions on 4.1 (David Carlson)
> 3. Re: register description field width (Glenn Fowler)
> 4. Re: questions on 4.1 (Chris Good)
> 5. Re: questions on 4.1 (Geoff)
> 6. importing csv and negative numbers (Kevin T)
> 7. Re: importing csv and negative numbers (Stan Brown)
> 8. Re: importing csv and negative numbers (davidcousens49 at gmail.com)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 13 Jun 2022 11:20:54 +1000
> From: "Chris Good" <goodchris96 at gmail.com>
> To: <gnucash-user at gnucash.org>
> Cc: <tc at fractalcat.io>
> Subject: Re: [GNC] questions on 4.1
> Message-ID: <004801d87ec3$d5decaa0$819c5fe0$@gmail.com>
> Content-Type: text/plain; charset="us-ascii"
>
> From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org
> <mailto:gmail.com at gnucash.org>
> <mailto:gnucash-user-bounces+gylemc <mailto:gnucash-user-bounces%2Bgylemc>
> =gmail.com at gnucash.org <mailto:gmail.com at gnucash.org> > > on
> behalf of Top Cat <tc at fractalcat.io <mailto:tc at fractalcat.io>
> <mailto:tc at fractalcat.io <mailto:tc at fractalcat.io> > >
> Sent: Saturday, June 11, 2022 12:44 PM
> To: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> >
> <gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> > >
> Subject: [GNC] questions on 4.1
>
> I have been using gnucash since 2.x with a MySQL database
>
>
> I recently build a new machine and updated to 4.1, and have run into
> several
> issues
>
> 1. On the accounts page, I can no longer show the account numbers, or
> sort by them
> 2. On reconciliations, paired transactions (like transfers from one
> subaccount to another) no longer clear "both sides" when one is checked -
> it
> requires manually marking both sides separately.
>
>
> Is this correct behavior? Are there settings I am missing? do I need to
> reinstall/save and restore data?
>
> Any help would be appreciated
>
> _______________________________________________
>
> Hi Top Cat,
>
> Re 2.:
> This behaviour changed in 3.9. and again in 3.11 as detailed in Bug 797648
> https://bugs.gnucash.org/show_bug.cgi?id=797648.
>
> BTW, The changes in each release are listed at
> https://www.gnucash.org/news.phtml.
>
> Regards,
> Chris Good
>
>
>
> ------------------------------
>
> Message: 2
> Date: Sun, 12 Jun 2022 20:58:42 -0500
> From: David Carlson <david.carlson.417 at gmail.com>
> To: Chris Good <goodchris96 at gmail.com>
> Cc: Gnucash Users <gnucash-user at gnucash.org>, Top Cat
> <tc at fractalcat.io>
> Subject: Re: [GNC] questions on 4.1
> Message-ID:
> <CADYgSbnobfTeYvrchTF1YeQQ_R+W3q-p_FJX_o0aRyD-nUn3Wg at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Chris,
>
> Thank you for your input. However, your reference to a bug that was
> created in release 3.9 and reverted in 3.11 may not be identical to the
> behavior that Top Cat saw in release 3.7 which seems to be different in
> release 4.1.
>
> Is it possible that the reversion in 3.11 did not exactly return to the
> behavior of releases prior to release 3.9? If so, which is correct or at
> least preferable?
>
> On Sun, Jun 12, 2022, 8:21 PM Chris Good <goodchris96 at gmail.com> wrote:
>
> > From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org
> > <mailto:gmail.com at gnucash.org>
> > <mailto:gnucash-user-bounces+gylemc <mailto:
> gnucash-user-bounces%2Bgylemc>
> > =gmail.com at gnucash.org <mailto:gmail.com at gnucash.org> > > on
> > behalf of Top Cat <tc at fractalcat.io <mailto:tc at fractalcat.io>
> > <mailto:tc at fractalcat.io <mailto:tc at fractalcat.io> > >
> > Sent: Saturday, June 11, 2022 12:44 PM
> > To: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> > <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> >
> > <gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> > <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> > >
> > Subject: [GNC] questions on 4.1
> >
> > I have been using gnucash since 2.x with a MySQL database
> >
> >
> > I recently build a new machine and updated to 4.1, and have run into
> > several
> > issues
> >
> > 1. On the accounts page, I can no longer show the account numbers,
> or
> > sort by them
> > 2. On reconciliations, paired transactions (like transfers from one
> > subaccount to another) no longer clear "both sides" when one is checked -
> > it
> > requires manually marking both sides separately.
> >
> >
> > Is this correct behavior? Are there settings I am missing? do I need to
> > reinstall/save and restore data?
> >
> > Any help would be appreciated
> >
> > _______________________________________________
> >
> > Hi Top Cat,
> >
> > Re 2.:
> > This behaviour changed in 3.9. and again in 3.11 as detailed in Bug
> 797648
> > https://bugs.gnucash.org/show_bug.cgi?id=797648.
> >
> > BTW, The changes in each release are listed at
> > https://www.gnucash.org/news.phtml.
> >
> > Regards,
> > Chris Good
> >
> > _______________________________________________
> > 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
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> ------------------------------
>
> Message: 3
> Date: Sun, 12 Jun 2022 22:21:51 -0400
> From: Glenn Fowler <gfowler1 at outlook.com>
> To: Kevin T <nevikintx at yahoo.com>
> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: Re: [GNC] register description field width
> Message-ID:
> <
> SJ0PR19MB44456EF683460597BDD1720D8FAB9 at SJ0PR19MB4445.namprd19.prod.outlook.com
> >
>
> Content-Type: text/plain; charset="UTF-8"
>
> There isn't a value for the description field. You can set the others as
> you found out. The description width is basically what is left over from
> the width of the other columns you set.
>
> On Fri, Jun 10, 2022 at 10:51 AM Kevin T <nevikintx at yahoo.com> wrote:
>
> > I have found the file in question.
> > I edited the file in question, with vim a text editor, to make all the
> non
> > description fields the same. save the file.
> > I start the tool.
> > If I change anything, window size, or field size of some tab, any tab,
> the
> > file is overwritten by the tool. vim notifies me that the file has
> changed.
> >
> > I have learned more about the behavior of the tool which makes it
> > understandable at least. Not preferable, but understandable.
> >
> > Kevin
> >
> >
> > On Thursday, May 26, 2022, 08:24:57 PM CDT, Kevin T <nevikintx at yahoo.com
> >
> > wrote:
> >
> >
> > i have scanned the directories mentioned for entries with 'description'
> > and 'width'. I can find nothing that is specific to the 'Description'
> > field in the support files that exist.
> >
> > again this is a windows install.
> >
> > do know what file, in what directory, with what content, you modified?
> >
> > Kevin
> >
> >
> > On Thursday, May 26, 2022, 06:48:33 AM CDT, Glenn Fowler <
> > gfowler1 at outlook.com> wrote:
> >
> >
> > Hi,
> >
> > If you want to hardcode the widths of columns, you can do that in user
> > data. I wanted my books and accounts to all be exactly the same so I did
> it
> > this way.
> >
> > Depending on your OS, the user data locations are described here:
> > https://wiki.gnucash.org/wiki/Configuration_Locations
> >
> > On Thu, May 26, 2022 at 12:11 AM Kevin T via gnucash-user <
> > gnucash-user at gnucash.org> wrote:
> >
> > I have found how to make the fonts large enough to read through
> inspection
> > of the mailing list history. it is now 14pt.
> > This is great but now the gnucash window has to be almost, 80% of my
> > screen width. 70% of that width is due to the width of the description
> > field. through the mailing lists I have found that double clicking the
> > vertical bars between the fields will adjust them to the width of the
> > data. It works for all but the description field. This field behaves as
> > if there is an extra 200 spaces attached to the end of each entry.
> Trying
> > to pull the right hand vertical bar will move the header, temporarily,
> but
> > the field width remains the same.
> > Is there some way to hard code, force, change the width of the
> description
> > field?
> >
> > Kevin
> >
> > _______________________________________________
> > 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
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> >
>
>
> ------------------------------
>
> Message: 4
> Date: Mon, 13 Jun 2022 12:24:28 +1000
> From: "Chris Good" <goodchris96 at gmail.com>
> To: "'David Carlson'" <david.carlson.417 at gmail.com>
> Cc: "'Gnucash Users'" <gnucash-user at gnucash.org>, "'Top Cat'"
> <tc at fractalcat.io>
> Subject: Re: [GNC] questions on 4.1
> Message-ID: <009a01d87ecc$b6d37850$247a68f0$@gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hi David,
>
>
>
> In 3.9, it was changed so that changing 1 split for the bank account (or
> it?s subaccounts) changed all splits for the bank account (and it?s
> subaccounts) to the new status, rather than toggling the status of the
> other splits. Toggling means: c to n and n to c.
>
> In 3.11 it was changed so that other splits are NOT modified so that the
> status of each split can be individually maintained in the reconcile window.
>
>
>
> Regards,
>
> Chris Good
>
>
>
> From: David Carlson <david.carlson.417 at gmail.com>
> Sent: Monday, 13 June 2022 11:59 AM
> To: Chris Good <goodchris96 at gmail.com>
> Cc: Gnucash Users <gnucash-user at gnucash.org>; Top Cat <tc at fractalcat.io>
> Subject: Re: [GNC] questions on 4.1
>
>
>
> Chris,
>
>
>
> Thank you for your input. However, your reference to a bug that was
> created in release 3.9 and reverted in 3.11 may not be identical to the
> behavior that Top Cat saw in release 3.7 which seems to be different in
> release 4.1.
>
>
>
> Is it possible that the reversion in 3.11 did not exactly return to the
> behavior of releases prior to release 3.9? If so, which is correct or at
> least preferable?
>
>
>
> On Sun, Jun 12, 2022, 8:21 PM Chris Good <goodchris96 at gmail.com <mailto:
> goodchris96 at gmail.com> > wrote:
>
> From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org
> <mailto:gmail.com at gnucash.org>
> <mailto:gmail.com at gnucash.org <mailto:gmail.com at gnucash.org> >
> <mailto:gnucash-user-bounces+gylemc <mailto:gnucash-user-bounces%2Bgylemc>
> <mailto:gnucash-user-bounces%2Bgylemc <mailto:
> gnucash-user-bounces%252Bgylemc> >
> =gmail.com at gnucash.org <mailto:gmail.com at gnucash.org> <mailto:
> gmail.com at gnucash.org <mailto:gmail.com at gnucash.org> > > > on
> behalf of Top Cat <tc at fractalcat.io <mailto:tc at fractalcat.io> <mailto:
> tc at fractalcat.io <mailto:tc at fractalcat.io> >
> <mailto:tc at fractalcat.io <mailto:tc at fractalcat.io> <mailto:
> tc at fractalcat.io <mailto:tc at fractalcat.io> > > >
> Sent: Saturday, June 11, 2022 12:44 PM
> To: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> <mailto:
> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> >
> <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> > >
> <gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> <mailto:
> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> >
> <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> > > >
> Subject: [GNC] questions on 4.1
>
> I have been using gnucash since 2.x with a MySQL database
>
>
> I recently build a new machine and updated to 4.1, and have run into
> several
> issues
>
> 1. On the accounts page, I can no longer show the account numbers, or
> sort by them
> 2. On reconciliations, paired transactions (like transfers from one
> subaccount to another) no longer clear "both sides" when one is checked -
> it
> requires manually marking both sides separately.
>
>
> Is this correct behavior? Are there settings I am missing? do I need to
> reinstall/save and restore data?
>
> Any help would be appreciated
>
> _______________________________________________
>
> Hi Top Cat,
>
> Re 2.:
> This behaviour changed in 3.9. and again in 3.11 as detailed in Bug 797648
> https://bugs.gnucash.org/show_bug.cgi?id=797648.
>
> BTW, The changes in each release are listed at
> https://www.gnucash.org/news.phtml.
>
> Regards,
> Chris Good
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
>
> ------------------------------
>
> Message: 5
> Date: Mon, 13 Jun 2022 13:47:16 +1000
> From: Geoff <cleanoutmyshed at gmail.com>
> To: Chris Good <goodchris96 at gmail.com>, 'David Carlson'
> <david.carlson.417 at gmail.com>
> Cc: 'Gnucash Users' <gnucash-user at gnucash.org>, 'Top Cat'
> <tc at fractalcat.io>
> Subject: Re: [GNC] questions on 4.1
> Message-ID: <d21a307d-71fa-66a5-7e95-8e4a1f8faa3d at gmail.com>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> > In 3.11 it was changed so that other splits are NOT modified so that
> the status of each split can be individually maintained in the reconcile
> window.
>
> Which is for me a really useful feature!
>
> Geoff
> =====
>
> On 13/06/2022 12:24 pm, Chris Good wrote:
> > Hi David,
> >
> >
> >
> > In 3.9, it was changed so that changing 1 split for the bank account (or
> it?s subaccounts) changed all splits for the bank account (and it?s
> subaccounts) to the new status, rather than toggling the status of the
> other splits. Toggling means: c to n and n to c.
> >
> > In 3.11 it was changed so that other splits are NOT modified so that the
> status of each split can be individually maintained in the reconcile window.
> >
> >
> >
> > Regards,
> >
> > Chris Good
> >
> >
> >
> > From: David Carlson <david.carlson.417 at gmail.com>
> > Sent: Monday, 13 June 2022 11:59 AM
> > To: Chris Good <goodchris96 at gmail.com>
> > Cc: Gnucash Users <gnucash-user at gnucash.org>; Top Cat <tc at fractalcat.io>
> > Subject: Re: [GNC] questions on 4.1
> >
> >
> >
> > Chris,
> >
> >
> >
> > Thank you for your input. However, your reference to a bug that was
> created in release 3.9 and reverted in 3.11 may not be identical to the
> behavior that Top Cat saw in release 3.7 which seems to be different in
> release 4.1.
> >
> >
> >
> > Is it possible that the reversion in 3.11 did not exactly return to the
> behavior of releases prior to release 3.9? If so, which is correct or at
> least preferable?
> >
> >
> >
> > On Sun, Jun 12, 2022, 8:21 PM Chris Good <goodchris96 at gmail.com <mailto:
> goodchris96 at gmail.com> > wrote:
> >
> > From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org
> <mailto:gmail.com at gnucash.org>
> > <mailto:gmail.com at gnucash.org <mailto:gmail.com at gnucash.org> >
> > <mailto:gnucash-user-bounces+gylemc <mailto:
> gnucash-user-bounces%2Bgylemc> <mailto:gnucash-user-bounces%2Bgylemc
> <mailto:gnucash-user-bounces%252Bgylemc> >
> > =gmail.com at gnucash.org <mailto:gmail.com at gnucash.org> <mailto:
> gmail.com at gnucash.org <mailto:gmail.com at gnucash.org> > > > on
> > behalf of Top Cat <tc at fractalcat.io <mailto:tc at fractalcat.io> <mailto:
> tc at fractalcat.io <mailto:tc at fractalcat.io> >
> > <mailto:tc at fractalcat.io <mailto:tc at fractalcat.io> <mailto:
> tc at fractalcat.io <mailto:tc at fractalcat.io> > > >
> > Sent: Saturday, June 11, 2022 12:44 PM
> > To: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> <mailto:
> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> >
> > <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> > >
> > <gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> <mailto:
> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> >
> > <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> > > >
> > Subject: [GNC] questions on 4.1
> >
> > I have been using gnucash since 2.x with a MySQL database
> >
> >
> > I recently build a new machine and updated to 4.1, and have run into
> several
> > issues
> >
> > 1. On the accounts page, I can no longer show the account numbers,
> or
> > sort by them
> > 2. On reconciliations, paired transactions (like transfers from one
> > subaccount to another) no longer clear "both sides" when one is checked
> - it
> > requires manually marking both sides separately.
> >
> >
> > Is this correct behavior? Are there settings I am missing? do I need to
> > reinstall/save and restore data?
> >
> > Any help would be appreciated
> >
> > _______________________________________________
> >
> > Hi Top Cat,
> >
> > Re 2.:
> > This behaviour changed in 3.9. and again in 3.11 as detailed in Bug
> 797648
> > https://bugs.gnucash.org/show_bug.cgi?id=797648.
> >
> > BTW, The changes in each release are listed at
> > https://www.gnucash.org/news.phtml.
> >
> > Regards,
> > Chris Good
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > 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
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>
> ------------------------------
>
> Message: 6
> Date: Mon, 13 Jun 2022 05:00:49 +0000 (UTC)
> From: Kevin T <nevikintx at yahoo.com>
> To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: [GNC] importing csv and negative numbers
> Message-ID: <805842610.1735335.1655096449524 at mail.yahoo.com>
> Content-Type: text/plain; charset=UTF-8
>
> It seems that when importing CSV files, to a CC account, if the 'credit'
> column, which when imported is called the 'deposit' field, has a negative
> value in it, it is imported as a 'debit' transaction.? I have to refer to
> the statement, to find which of these transactions are supposed to be
> credits.? ?IE i can't trust the import.
> is there any way to work around this behavior.
> Kevin
>
> ------------------------------
>
> Message: 7
> Date: Sun, 12 Jun 2022 22:23:08 -0700
> From: Stan Brown <the_stan_brown at fastmail.fm>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] importing csv and negative numbers
> Message-ID: <ef3ac587-c854-0b4f-90df-8439768beb4d at fastmail.fm>
> Content-Type: text/plain; charset=utf-8
>
>
> On 2022-06-12 22:00, Kevin T via gnucash-user wrote:
> > It seems that when importing CSV files, to a CC account, if the
> > 'credit' column, which when imported is called the 'deposit' field,
> > has a negative value in it, it is imported as a 'debit' transaction.
> > I have to refer to the statement, to find which of these transactions
> > are supposed to be credits. IE i can't trust the import.> is there any
> way to work around this behavior.
>
> Can you clarify please? Do you mean that
> (a) a credit column in CSV contains minus $100.00, the import shows
> POSITIVE $100.00 in the debit column and nothing in credit, or
> (a) a credit column in CSV contains minus $100.00, the import shows
> NEGATIVE $100.00 in the debit column and nothing in credit, or
> (c) something else?
>
> If it's (a), that's correct and consistent behavior. GC won't let you
> manually enter a transaction with a negative number in credit or debit;
> it changes that to a positive number in debit or credit respectively.
> After all, a credit of minus $100 is equivalent to a debit of plus $100.
> If this is what is happening, you _can_ trust the import. And while I
> myself have had instances where I wanted to record something as a
> negative credit rather than a positive debit, as far as I know there's
> no way to do that. And after all, the two _are_ equivalent so it's
> purely a matter of presentation and not of incorrect numbers.
>
> If you mean (b), something seems off. I'll let others, who are more
> familiar with the details of importing, ask you questions. (One thing
> you could and should always do, when reporting a possible problem, is
> state which version number of GC you're using, which operating system,
> and whether you're using a prebuilt version or you compiled it yourself.)
>
> If you mean (c), please explain all that is in the CSV file for this
> transaction, and all that is in the transaction after import. Screen
> shots might help; be sure to attach them, as opposed to including them
> inline in HTML.
>
> --
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
>
>
> ------------------------------
>
> Message: 8
> Date: Mon, 13 Jun 2022 15:33:09 +1000
> From: davidcousens49 at gmail.com
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] importing csv and negative numbers
> Message-ID: <ba80987956fe3bf8646bab6c62f3a3f395e2df5f.camel at gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> The difficulty is that the sign convention in a CSV file is normally
> determined
> by the originating bank and there is no guarantee that it is what GnuCash
> thinks
> it should be.
>
> Some banks will use a signed amount column to represent debits and credits,
> others will provide a debit column and a credit column with an unsigned
> amount.
> Most will use a convention where the file is prepared from there point of
> view,
> i.e. deposits you make into the account will be credits and withdrawals
> from the
> bank account will be debits in the file (and on the statement) but there
> are
> always the banks who try to be helpful.
>
> The importer has to be able to handle these combinations and any reversal
> of the
> sign convention so there is some arbitrarinesss to the assignment of the
> Deposit
> and Withdrawal headers to the appropriate columns in the CSV file in the
> importer setup.
>
> My bank uses a single signed amount column in which positive amounts are
> credits
> on the statement and negative amounts are debits on the statement. Because
> the
> statement is written from the banks accounting perspective and not yours
> the
> positive amounts become debits and the negative amounts credits in your
> accounts
> in GnuCash so I can assign the Deposit header to the single amount column
> in the
> CSV file and it imports correctly. If I am importing a Credit card
> statement,
> assigning the "Deposit" header also seems to work as GnuCash realizes it is
> importing to a liability and not an asset account. If your bank follows
> the same
> convention and has two columns you would assign the "Deposit" header to the
> Credit column in the file and the "Withdrawal" header to the Debit column
> in the
> file.
>
> The best bet is to truncate a file to a couple of transactions and
> experiment to
> get the setup right and then use that to import the complete file. Then if
> it
> imports incorrectly you only have 1-2 transactions to delete before try the
> other options.
>
> David Cousens
>
> On Mon, 2022-06-13 at 05:00 +0000, Kevin T via gnucash-user wrote:
> > It seems that when importing CSV files, to a CC account, if the 'credit'
> > column, which when imported is called the 'deposit' field, has a negative
> > value in it, it is imported as a 'debit' transaction. I have to refer
> to the
> > statement, to find which of these transactions are supposed to be
> credits.
> > IE i can't trust the import.
> > is there any way to work around this behavior.
> > Kevin
> > _______________________________________________
> > 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
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
>
> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
> ------------------------------
>
> End of gnucash-user Digest, Vol 231, Issue 31
> *********************************************
>
> _______________________________________________
> 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
More information about the gnucash-user
mailing list