[GNC] gnucash-user Digest, Vol 231, Issue 31
Kevin T
nevikintx at yahoo.com
Mon Jun 13 10:13:56 EDT 2022
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
*********************************************
More information about the gnucash-user
mailing list