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@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-requ...@gnucash.org <gnucash-user-requ...@gnucash.org> > wrote: > > Send gnucash-user mailing list submissions to > gnucash-user@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-requ...@gnucash.org > > You can reach the person managing the list at > gnucash-user-ow...@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 (davidcousen...@gmail.com) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 13 Jun 2022 11:20:54 +1000 > From: "Chris Good" <goodchri...@gmail.com> > To: <gnucash-user@gnucash.org> > Cc: <t...@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....@gnucash.org > <mailto:gmail....@gnucash.org> > <mailto:gnucash-user-bounces+gylemc <mailto:gnucash-user-bounces%2Bgylemc> > =gmail....@gnucash.org <mailto:gmail....@gnucash.org> > > on > behalf of Top Cat <t...@fractalcat.io <mailto:t...@fractalcat.io> > <mailto:t...@fractalcat.io <mailto:t...@fractalcat.io> > > > Sent: Saturday, June 11, 2022 12:44 PM > To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > <gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@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....@gmail.com> > To: Chris Good <goodchri...@gmail.com> > Cc: Gnucash Users <gnucash-user@gnucash.org>, Top Cat > <t...@fractalcat.io> > Subject: Re: [GNC] questions on 4.1 > Message-ID: > <cadygsbnobfteyvrchtf1yeqq_r+w3q-p_fjx_o0aryd-nun...@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 <goodchri...@gmail.com> wrote: > > > From: gnucash-user <gnucash-user-bounces+gylemc=gmail....@gnucash.org > > <mailto:gmail....@gnucash.org> > > <mailto:gnucash-user-bounces+gylemc <mailto: > gnucash-user-bounces%2Bgylemc> > > =gmail....@gnucash.org <mailto:gmail....@gnucash.org> > > on > > behalf of Top Cat <t...@fractalcat.io <mailto:t...@fractalcat.io> > > <mailto:t...@fractalcat.io <mailto:t...@fractalcat.io> > > > > Sent: Saturday, June 11, 2022 12:44 PM > > To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > > <gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@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@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 <gfowl...@outlook.com> > To: Kevin T <neviki...@yahoo.com> > Cc: "gnucash-user@gnucash.org" <gnucash-user@gnucash.org> > Subject: Re: [GNC] register description field width > Message-ID: > < > sj0pr19mb44456ef683460597bdd1720d8f...@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 <neviki...@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 <neviki...@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 < > > gfowl...@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@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@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" <goodchri...@gmail.com> > To: "'David Carlson'" <david.carlson....@gmail.com> > Cc: "'Gnucash Users'" <gnucash-user@gnucash.org>, "'Top Cat'" > <t...@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....@gmail.com> > Sent: Monday, 13 June 2022 11:59 AM > To: Chris Good <goodchri...@gmail.com> > Cc: Gnucash Users <gnucash-user@gnucash.org>; Top Cat <t...@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 <goodchri...@gmail.com <mailto: > goodchri...@gmail.com> > wrote: > > From: gnucash-user <gnucash-user-bounces+gylemc=gmail....@gnucash.org > <mailto:gmail....@gnucash.org> > <mailto:gmail....@gnucash.org <mailto:gmail....@gnucash.org> > > <mailto:gnucash-user-bounces+gylemc <mailto:gnucash-user-bounces%2Bgylemc> > <mailto:gnucash-user-bounces%2Bgylemc <mailto: > gnucash-user-bounces%252Bgylemc> > > =gmail....@gnucash.org <mailto:gmail....@gnucash.org> <mailto: > gmail....@gnucash.org <mailto:gmail....@gnucash.org> > > > on > behalf of Top Cat <t...@fractalcat.io <mailto:t...@fractalcat.io> <mailto: > t...@fractalcat.io <mailto:t...@fractalcat.io> > > <mailto:t...@fractalcat.io <mailto:t...@fractalcat.io> <mailto: > t...@fractalcat.io <mailto:t...@fractalcat.io> > > > > Sent: Saturday, June 11, 2022 12:44 PM > To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> <mailto: > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > > <gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> <mailto: > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@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@gnucash.org <mailto:gnucash-user@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 <cleanoutmys...@gmail.com> > To: Chris Good <goodchri...@gmail.com>, 'David Carlson' > <david.carlson....@gmail.com> > Cc: 'Gnucash Users' <gnucash-user@gnucash.org>, 'Top Cat' > <t...@fractalcat.io> > Subject: Re: [GNC] questions on 4.1 > Message-ID: <d21a307d-71fa-66a5-7e95-8e4a1f8fa...@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....@gmail.com> > > Sent: Monday, 13 June 2022 11:59 AM > > To: Chris Good <goodchri...@gmail.com> > > Cc: Gnucash Users <gnucash-user@gnucash.org>; Top Cat <t...@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 <goodchri...@gmail.com <mailto: > goodchri...@gmail.com> > wrote: > > > > From: gnucash-user <gnucash-user-bounces+gylemc=gmail....@gnucash.org > <mailto:gmail....@gnucash.org> > > <mailto:gmail....@gnucash.org <mailto:gmail....@gnucash.org> > > > <mailto:gnucash-user-bounces+gylemc <mailto: > gnucash-user-bounces%2Bgylemc> <mailto:gnucash-user-bounces%2Bgylemc > <mailto:gnucash-user-bounces%252Bgylemc> > > > =gmail....@gnucash.org <mailto:gmail....@gnucash.org> <mailto: > gmail....@gnucash.org <mailto:gmail....@gnucash.org> > > > on > > behalf of Top Cat <t...@fractalcat.io <mailto:t...@fractalcat.io> <mailto: > t...@fractalcat.io <mailto:t...@fractalcat.io> > > > <mailto:t...@fractalcat.io <mailto:t...@fractalcat.io> <mailto: > t...@fractalcat.io <mailto:t...@fractalcat.io> > > > > > Sent: Saturday, June 11, 2022 12:44 PM > > To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> <mailto: > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > > <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > > > <gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> <mailto: > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > > <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@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@gnucash.org <mailto:gnucash-user@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@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 <neviki...@yahoo.com> > To: "gnucash-user@gnucash.org" <gnucash-user@gnucash.org> > Subject: [GNC] importing csv and negative numbers > Message-ID: <805842610.1735335.1655096449...@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_br...@fastmail.fm> > To: gnucash-user@gnucash.org > Subject: Re: [GNC] importing csv and negative numbers > Message-ID: <ef3ac587-c854-0b4f-90df-8439768be...@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: davidcousen...@gmail.com > To: gnucash-user@gnucash.org > Subject: Re: [GNC] importing csv and negative numbers > Message-ID: <ba80987956fe3bf8646bab6c62f3a3f395e2df5f.ca...@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@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@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@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@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.