Re: [GNC] Scheduled Transactions Question

[David Carlson]

Never mind, I can't read your whole message at once on my phone

On Fri, Jan 13, 2023, 12:50 PM David Carlson 
wrote:

> David,
>
> Which version of GnuCash are you using?
>
> On Fri, Jan 13, 2023, 10:49 AM David T. via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>> Hi,
>>
>> Gnucash 4.13 Windows 10. Long time user.
>>
>> I am trying out using a variable in a scheduled transaction for the
>> first time, and it's not behaving the way I expect. I am creating a
>> multi-entry transaction that transfers a single amount between two pairs
>> of accounts. in other words:
>>
>> DB Checking TOTALAMT
>> CR Asset TOTALAMT
>> CR Income A TOTALAMT
>> DB Income B TOTALAMT
>>
>> [This is testing out how to create a transaction to track an IRA
>> distribution]
>>
>> I expect GnuCash to prompt me for the TOTALAMT figure once when the
>> transaction is created, but GnuCash prompts me for *each* TOTALAMT entry
>> in the transaction (i.e., four times). Is there a way to have just one
>> request that gets assigned four times?
>>
>> David T.
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@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@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.

Re: [GNC] Scheduled Transactions Question

[David Carlson]

I do recall this same issue came up in another thread and I thought there
was already a solution mentioned,  but it is really difficult to search for
it on a phone .

Perhaps someone else remembers where to find it?

On Fri, Jan 13, 2023, 12:52 PM David Carlson 
wrote:

> Never mind, I can't read your whole message at once on my phone
>
> On Fri, Jan 13, 2023, 12:50 PM David Carlson 
> wrote:
>
>> David,
>>
>> Which version of GnuCash are you using?
>>
>> On Fri, Jan 13, 2023, 10:49 AM David T. via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>>
>>> Hi,
>>>
>>> Gnucash 4.13 Windows 10. Long time user.
>>>
>>> I am trying out using a variable in a scheduled transaction for the
>>> first time, and it's not behaving the way I expect. I am creating a
>>> multi-entry transaction that transfers a single amount between two pairs
>>> of accounts. in other words:
>>>
>>> DB Checking TOTALAMT
>>> CR Asset TOTALAMT
>>> CR Income A TOTALAMT
>>> DB Income B TOTALAMT
>>>
>>> [This is testing out how to create a transaction to track an IRA
>>> distribution]
>>>
>>> I expect GnuCash to prompt me for the TOTALAMT figure once when the
>>> transaction is created, but GnuCash prompts me for *each* TOTALAMT entry
>>> in the transaction (i.e., four times). Is there a way to have just one
>>> request that gets assigned four times?
>>>
>>> David T.
>>>
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@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@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.

Re: [GNC] Scheduled Transactions Window Sorting

[David Carlson]

David,

I would wait for a reply from one of the more active developers.  I do
agree with your sentiments.

On Sat, Jan 14, 2023 at 8:32 AM David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Well, thanks for the confirmation.
>
> I disagree with the conclusion, though. Based on your reasoning, registers
> should only save a chronological sort; thankfully, they allow other sort
> orders for users who prefer them.
>
> ⁣David T. ​
>
> On Jan 14, 2023, 4:15 PM, at 4:15 PM, John Layman <
> john.lay...@laymanandlayman.com> wrote:
> >I'm running 4.13 on Windows 10 and can tell you that sort order is
> >'sticky' only if you are sorting on one of the two occurrence columns.
> >It's a calendar-oriented feature, so I can't say I consider that an
> >oversight.
> >
> >-Original Message-
> >From: gnucash-user
> > On Behalf Of
> >David T. via gnucash-user
> >Sent: Saturday, January 14, 2023 1:44 AM
> >To: Gnucash Users 
> >Subject: [GNC] Scheduled Transactions Window Sorting
> >
> >Hello,
> >
> >Gnucash 4.13 Windows 10.
> >
> >As I reacquaint myself with scheduled transactions, I find myself
> >opening that window regularly. Each time I open the window,
> >transactions are listed in last created order. This despite my having
> >sorted the list alphabetically the previous time.
> >
> >My question is this: is there some material reason why the Scheduled
> >Transactions Window sort order isn't sticky (like most other windows in
> >GnuCash), or is this simply an oversight?
> >
> >⁣David T. ​
> >___
> >gnucash-user mailing list
> >gnucash-user@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@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] A bug or not ? - Windows shuts down with no warning of GnuCash running.

[David Carlson]

There are still scenarios where a power outage happens or the user shuts
Windows down thinking all programs are safely closed when that is not true,
as two of innumerable examples.

On Mon, Jan 16, 2023 at 4:14 PM R Losey  wrote:

> You wrote "if shutting down GnuCash" - do you mean shutting down Windows
> while GnuCash is running with an unsaved file?
>
> It's nice that Windows notes if LibreOffice is running, but I always assume
> I'll lose data if I shut down with unsaved files and I normally close down
> everything I'm running before I shut down or restart Windows.
>
> I thought that if I attempted to shut down GnuCash without first saving the
> file, that I get a warning, but I haven't done that it a while.
>
>
> On Mon, Jan 16, 2023 at 11:31 AM Dr. David Kirkby <
> drkir...@kirkbymicrowave.co.uk> wrote:
>
> > I'm running GnuCash 4.12 on linux, and 4.13 on Windows. If I try to shut
> > down Windows, it detects programs like LibraOffice are running, and does
> > not shut down until I have confirmed if I want to save the data or not.
> I'm
> > no fan of Windoze,. but I can see the point of that.
> >
> > There's no similar warning if shutting down GnuCash with a file open.
> One
> > just gets the warning the next time GnuCash opens that it can't get the
> > lock on the file, and offering the change to open read-only, quit, open
> > anyway - or something like that from memory.
> >
> > Dave
> > ___
> > gnucash-user mailing list
> > gnucash-user@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.
> >
>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Importing csv files

[David Carlson]

Mark,

The Help manual chapter 6 gives a good starting point to configuring a
successful CSV transaction import.  However, it does not describe importing
accounts.

GnuCash is supposed to be able to import anything that it can export, so if
you try to find an existing account tree example in a test file, possibly
created by the Gnucash account setup wizard, you can try exporting it to
see what might work in the import direction.  If you have tried that and it
still fails, you should at least have a well detailed example to use when
you return to ask this group for additional help.



On Thu, Jan 19, 2023 at 8:43 PM Mark Bole  wrote:

> By coincidence, I too am trying to import my QuickBooks well-tuned COA
> into GnuCash via CSV files.  I already knew to try the things
> recommended in this thread but still have indeterminate results. I
> realize by now that with the time already invested (especially after I
> finish writing this), I could have manually altered the sub-account
> status and been done with it, but I want to understand what is going on
> at a lower level.
>
> I broke my QB accounts into smaller chunks for better testing and
> recovery if needed. _/My first batch import of type BANK accounts worked
> fine!/_  But now, with the same CSV format, I find I cannot successfully
> import further small groups of account rows from CSV files.  The
> Preview, even more frustrating, can show that the first four or five
> input rows don't parse correctly, but then suddenly  row six is fine for
> import in the preview.
>
> Is there documentation somewhere as to allowed characters, field
> lengths, etc for CSV import of accounts?
>
> Here is an example of an import file that fails for me.  The top level
> and sub-accounts exist.  Why won't it import successfully?
>
> Type,Full Account Name,Account Name,Description,Account
> Color,Notes,Symbol,Namespace,Hidden,Tax Info,Placeholder
> ASSET,Current Assets:Other Current Assets:Ibond,Ibond,Treasury
> Direct,,,USD,CURRENCY,F,F,F
>
> -Mark B.
>
> On 2023-01-19 11:58, R Losey wrote:
> > Also, do you really need to import data from Quickbooks? I used Quicken,
> > not Quickbooks, but (by and large), I just started up GnuCash afresh and
> > went back to Quicken only when I needed to look things up.  Now that I'm
> > years into GnuCash, I have had no need to go back to Quicken.
> >
> >
> >
> > On Wed, Jan 18, 2023 at 7:30 PM rudy beuc  wrote:
> >
> >> Hello,
> >>
> >> I'm trying to migrate from Quickbooks to GnuCash.
> >>
> >> I'd like to keep as much information as I can for record keeping. To
> >> that end I've first been trying to import my accounts structure in via a
> >> csv file and failing badly.
> >>
> >> Pre Christmas holidays I was getting an error message I could not
> >> interpret. Now I've installed the latest stable version 4.13 and it just
> >> dies mid process.
> >>
> >> I'm running on Windows 11 and using open office to manipulate the csv
> >> files before trying to import.
> >>
> >> Where can I find a good discussion or indepth material on importing csv
> >> files, the expected format for them, ect...?
> >>
> _______
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] OFX import reverses charge/payment on CC account (Comenity BJ's MC)

[David Carlson]

Perhaps Comenity is to blame.  I have the same problem with Petco, which is
another Comenity card.

On Sun, Jan 22, 2023 at 12:59 AM Justin  wrote:

> I noticed that my CC (BJ's via Comenity) has an OFX export, so I tried
> it.  Unfortunately, the signs are backwards:
>
> Here are two snippets from the OFX:
>
>  
>  Charge
>  2022122212[0:GMT]
>  26.42
>  ...
>  ...
>  REPLACE
>  BJS FUEL...
>  
>  
>  Payment
>  2022120912[0:GMT]
>  -505.43
>  ...
>  ...
>  REPLACE
>  AUTOMATIC PAYMENT - THANK YOU
>  
>
> This shows up as:
>
> Date   | Description | Account  | Payment | Charge
> 2022-12-09 | AUTOMATIC PAYMENT - THANK YOU | CC   | | 505.43
> | Checking |  505.43 |
> 2022-12-22 | BJS Fuel  | CC   |   26.42 |
> | Fuel | |  26.42
>
> The "payment" to the CC from Checking is showing up as +505.43 in Checking.
>
> I reversed the signs in the file (X to -X, -Y to Y), and the
> reimported entries were correct.
>
> I can write a script to correct the file, but wondering if anybody has
> seen this.  Maybe the OFX file is wrong, maybe import is wrong.
>
> -Justin
>
>
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Questions about setting up new accounts from brand new user

[David Carlson]

Maf showed you how to start to create a single account.

If you want to create an entire chart of accounts click File > New and
select the option to create New Account Hierarchy Setup
You might want to try this more than once because it will then give you a
lot of choices for different applications and you may be a little
overwhelmed the first time around.

On Mon, Jan 23, 2023 at 11:29 AM Maf. King  wrote:

> On Monday, 23 January 2023 17:10:51 GMT Ann Bowes wrote:
> > Hi folks,
> >
> > I'm trying to set up a simple manual checking account for a small farm
> > business.  I've down-loaded the gnucash program to my laptop (linux
> > zorin OS), and have tried to open new accounts, but am completely
> > stumped as to how to do this.  I've read through the tutorial (at
> > https://gnucash-docs-rst.readthedocs.io/en/latest/index.html), but I'm
> > still stumped  Can anyone give me some pointers?
> >
>
> Hi Ann,
>
> you mean you need to create an account in your Gnucash books?
>
> see the attached image for a pointer...
>
> HTH,
> Maf.
>
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] ^F Find not finding recently entered text in Memo field

[David Carlson]

Jeff,
Is the text that you are searching for  in a split line for the home bank
register or is it in the "other" split line?


On Mon, Jan 23, 2023, 4:41 PM Jeff Albrecht  wrote:

> On 1/23/2023 3:27 PM, David H wrote:
> > Jeff,
> >
> > If you do a find from the accounts tab it will search in all splits,
> > if however you do a find in a Register tab it only looks at splits for
> > that particular Register, it doesn't search in splits belonging to
> > other Register's.  Are you falling into this trap ?
>
> Thanks David. Interesting,
>
> If I do the find from the Accounts tab it does find the transaction. But
> I have been searching in the bank register where the transaction I'm
> looking for resides. It doesn't find the transaction that is in the bank
> register searched from that specific bank register where the transaction
> I'm looking for resides.
>
>   - Jeff
>
>
> >
> > Cheers David H.
> >
> >
> > On Tue, 24 Jan 2023 at 08:06, Jeff Albrecht  wrote:
> >
> > Windows 11
> > Version: 4.13
> > Build ID: 4.13+(2022-12-17)
> >
> > FWIW I've been, happily, using GNUCash for several years.
> >
> > I'm working on my 2022 taxes importing .OFX files from my banks. I
> > generally want to add a memo on most transactions with notes found
> > from
> > the vendor transaction details on their respective sites. Since this
> > adding memos isn't currently possible during the import I move
> > transaction to a temporary 'unaccounterd for 2022' register where
> > I add
> > notes in the memo field, categorize the transaction and save.
> >
> > Occasionally I want to verify that I entered the correct notes in the
> > Memo field. I do a find with 'contains' searching in the
> > 'description,
> > notes or memo' This find operation doesn't appear to be finding
> > transactions I've entered today although if I search visually through
> > the register they have been entered. I did upgrade to 4.13 from some
> > 4.xx version before I started working on this .OFX import. I haven't
> > used Find for some time but if my memory is correct I've used find
> > similarly in the past successfully.
> >
> > I tried to find some kind of re-indexing function. Does such an
> > option
> > exist?
> >
> > I did try exiting and restarting GNUCash and repeating the find
> > with the
> > same results, not finding transaction with memos entered today.
> >
> >
> >
> >
> >
> > --
> > Jeff Albrecht KF7CRU @jhalbrecht
> > ___
> > gnucash-user mailing list
> > gnucash-user@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.
> >
>
> --
> Jeff Albrecht KF7CRU @jhalbrecht
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

[GNC] Fwd: Delivery Status Notification (Failure)

[David Carlson]

I cut and pasted an incomplete address.  This should work

-- Forwarded message -
From: Mail Delivery Subsystem 
Date: Mon, Jan 23, 2023 at 10:22 PM
Subject: Delivery Status Notification (Failure)
To: 


[image: Error Icon]
Address not found
Your message wasn't delivered to *u...@gnucash.org* because the address
couldn't be found, or is unable to receive mail.
The response from the remote server was:

550 5.1.1 : Recipient address rejected: User unknown



-- Forwarded message ------
From: David Carlson 
To: Jeff Albrecht , u...@gnucash.org
Cc:
Bcc:
Date: Mon, 23 Jan 2023 22:22:28 -0600
Subject: Re: [GNC] ^F Find not finding recently entered text in Memo field
- Message truncated -----


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

[GNC] Fwd: ^F Find not finding recently entered text in Memo field

[David Carlson]

I will never learn how Gmail works.

-- Forwarded message -
From: David Carlson 
Date: Mon, Jan 23, 2023 at 10:22 PM
Subject: Re: [GNC] ^F Find not finding recently entered text in Memo field
To: Jeff Albrecht , 


Jeff,
Please reply to list so others can contribute to the discussion.  I took
the liberty of posting this reply to the list.

Looking at your illustration, if you search for that text string
"Detection" starting from the register for "Expenses:Household:Misc"  or
from the Accounts tab, it will be found, but it will not be found if you
start your search from that bank account register.  That is no different
from GnuCash behavior over the last several years.

On Mon, Jan 23, 2023 at 6:10 PM Jeff Albrecht  wrote:

> On 1/23/2023 4:36 PM, David Carlson wrote:
>
> Jeff,
> Is the text that you are searching for  in a split line for the home bank
> register or is it in the "other" split line?
>
> Here is an image previously removed by the list. Sorry, I don't know how
> to answer you precisely. However if my memory of using find in the past is
> correct find is not currently, in my installation, behaving as it has in
> the past for me.
>
> This image is my search from the bank register where the transaction with
> the string I'm trying to find resides.
>
> Today, I have entered a couple splits to a transaction with what I believe
> is 'memo' detail which were not found by the find command executed in the
> containing banking register. Note that the find did list some transactions
> found in that register from previous years - ?possibly pointing to version
> 4.13 as the culprit? It appears to be finding as I would expect for
> transactions entered previous to my upgrade to 4.13
>
>
>
>
>  - Jeff
>
>
> On Mon, Jan 23, 2023, 4:41 PM Jeff Albrecht  wrote:
>
>> On 1/23/2023 3:27 PM, David H wrote:
>> > Jeff,
>> >
>> > If you do a find from the accounts tab it will search in all splits,
>> > if however you do a find in a Register tab it only looks at splits for
>> > that particular Register, it doesn't search in splits belonging to
>> > other Register's.  Are you falling into this trap ?
>>
>> Thanks David. Interesting,
>>
>> If I do the find from the Accounts tab it does find the transaction. But
>> I have been searching in the bank register where the transaction I'm
>> looking for resides. It doesn't find the transaction that is in the bank
>> register searched from that specific bank register where the transaction
>> I'm looking for resides.
>>
>>   - Jeff
>>
>>
>> >
>> > Cheers David H.
>> >
>> >
>> > On Tue, 24 Jan 2023 at 08:06, Jeff Albrecht  wrote:
>> >
>> > Windows 11
>> > Version: 4.13
>> > Build ID: 4.13+(2022-12-17)
>> >
>> > FWIW I've been, happily, using GNUCash for several years.
>> >
>> > I'm working on my 2022 taxes importing .OFX files from my banks. I
>> > generally want to add a memo on most transactions with notes found
>> > from
>> > the vendor transaction details on their respective sites. Since this
>> > adding memos isn't currently possible during the import I move
>> > transaction to a temporary 'unaccounterd for 2022' register where
>> > I add
>> > notes in the memo field, categorize the transaction and save.
>> >
>> > Occasionally I want to verify that I entered the correct notes in
>> the
>> > Memo field. I do a find with 'contains' searching in the
>> > 'description,
>> > notes or memo' This find operation doesn't appear to be finding
>> > transactions I've entered today although if I search visually
>> through
>> > the register they have been entered. I did upgrade to 4.13 from some
>> > 4.xx version before I started working on this .OFX import. I haven't
>> > used Find for some time but if my memory is correct I've used find
>> > similarly in the past successfully.
>> >
>> > I tried to find some kind of re-indexing function. Does such an
>> > option
>> > exist?
>> >
>> > I did try exiting and restarting GNUCash and repeating the find
>> > with the
>> > same results, not finding transaction with memos entered today.
>> >
>> >
>> >
>> >
>> >
>> > --
>> > Jeff Albrecht KF7CRU @jhalbrecht

Re: [GNC] Gift of stock

[David Carlson]

The US allows gifts to go untaxed within certain limits.   Capital gains
can get interesting as well.  If you're not certain,  talk to your
accountant.

On Tue, Jan 24, 2023, 6:48 PM Liz Dodd  wrote:

> On Wed, 25 Jan 2023 10:34:51 +1100
> flywire  wrote:
>
> > I doubt your jurisdiction is that naive. I'd expect you'd pay tax on
> > the $25k capital gain on disposal and your son would have a $30k
> > basis price.
>
>
> I agree, you gave your son the equivalent of $30K, and you get to pay
> tax on the capital gain.
> However if your jurisdiction sees it as your son paying the capital
> gain, then you gave him $5K in your books.
>
> Liz
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

Re: [GNC] GnuCash: What scheduled transactions can't do

[David Carlson]

Would it be possible to rework the Future Scheduled Transactions Summary
report to display the scheduled transactions?

On Fri, Jan 27, 2023 at 4:15 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

>
> > If you mean in number 1 that there's no way to specify a future exchange
> rate, that's correct.
>
> ROFL
>
> If it were possible for gnucash to CORRECTLY predict what exchange rates
> will be at some future date then I wouldn't be using it just to automate
> my bookkeeping. I'd be using it to make a LOT of money..
>
> Michael D Novack
>
>
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Scheduled Transactions Window Sorting

[David Carlson]

Adrien M,

Are you able to sort transactions in the Since Last Run dialog as well as
in the Scheduled Transactions Editor?  Are they still sorted the same way
the next time that you open the Scheduled Transactions Editor?

I think there may be some confusion about when the stickiness arises.  I
think that it only arises in windows that are still open when the program
is shut down with Alt-F-Q, Ctrl-Q, and possibly clicking the upper right
red X in Windows or many Linux desktops.  I have no knowledge about Apples.

With that in mind, I think that it would be a nice enhancement if there
were a way to make the attributes of the current window such as sort order,
window positions and column widths 'stick' in the same way in the user
settings as they do now when the program is closed, but without actually
closing the program.  I think that this could be added in the right-click
menu for registers, possibly called Freeze Window Attributes.

On Sat, Jan 14, 2023 at 9:03 AM David Carlson 
wrote:

> David,
>
> I would wait for a reply from one of the more active developers.  I do
> agree with your sentiments.
>
> On Sat, Jan 14, 2023 at 8:32 AM David T. via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>> Well, thanks for the confirmation.
>>
>> I disagree with the conclusion, though. Based on your reasoning,
>> registers should only save a chronological sort; thankfully, they allow
>> other sort orders for users who prefer them.
>>
>> ⁣David T. ​
>>
>> On Jan 14, 2023, 4:15 PM, at 4:15 PM, John Layman <
>> john.lay...@laymanandlayman.com> wrote:
>> >I'm running 4.13 on Windows 10 and can tell you that sort order is
>> >'sticky' only if you are sorting on one of the two occurrence columns.
>> >It's a calendar-oriented feature, so I can't say I consider that an
>> >oversight.
>> >
>> >-Original Message-
>> >From: gnucash-user
>> > On Behalf Of
>> >David T. via gnucash-user
>> >Sent: Saturday, January 14, 2023 1:44 AM
>> >To: Gnucash Users 
>> >Subject: [GNC] Scheduled Transactions Window Sorting
>> >
>> >Hello,
>> >
>> >Gnucash 4.13 Windows 10.
>> >
>> >As I reacquaint myself with scheduled transactions, I find myself
>> >opening that window regularly. Each time I open the window,
>> >transactions are listed in last created order. This despite my having
>> >sorted the list alphabetically the previous time.
>> >
>> >My question is this: is there some material reason why the Scheduled
>> >Transactions Window sort order isn't sticky (like most other windows in
>> >GnuCash), or is this simply an oversight?
>> >
>> >⁣David T. ​
>> >___
>> >gnucash-user mailing list
>> >gnucash-user@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@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.
>>
>
>
> --
> David Carlson
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Find not working on multi-currency transactions.

[David Carlson]

I believe the correct URL is https://bugs.gnucash.org/show_bug.cgi?id=779926

On Thu, Feb 2, 2023 at 4:58 AM Geert Janssens 
wrote:

> Op donderdag 2 februari 2023 08:56:29 CET schreef Dr. David Kirkby:
> > I found what I feel is a bug - see attachment. It's basically the same as
> >
> > https://bugs.gnucash.org/show_bug.cgi?id=779888
> >
> > reported by Christopher Lam, and marked as fixed. But I don't think it is
> > fixed, so I added a comment.
> >
> So did I to explain why you experience what you describe. In short I think
> you want to find
> by amount, not by value.
>
> > There's a link to another bug on that bug, but the link points to nowhere
> > useful.
> >
> That's a leftover from when we tracked our bugs on bugzilla.gnome.org.
> The new url is this
> https://bugzilla.gnome.org/show_bug.cgi?id=779926[1]
>
> Regards,
>
> Geert
>
> 
> [1] https://bugzilla.gnome.org/show_bug.cgi?id=779926
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] How to force y in reconcile field

[David Carlson]

If there are any transactions that should not have been marked reconciled
because they actually were not on the particular statement being reconciled
or a previous one, those transactions must be found and un-marked before
the transaction will reconcile.  There is no way to bulk un-mark
transactions previously marked as reconciled on or after a given date, and
there is rarely a need or ability to re-run an old reconciliation report,
so it is easier to just wait and run the next month's reconciliation
marking all old transactions then.



On Thu, Feb 2, 2023 at 4:19 PM Phyllis Bruce  wrote:

> That's a valid observation, Dr. Kirby, since gnucash will choose the
> balance based on the statement date.  There are almost ALWAYS uncleared
> transactions.
>
> On Thu, Feb 2, 2023 at 4:14 PM Dr. David Kirkby <
> drkir...@kirkbymicrowave.co.uk> wrote:
>
> > On Thu, 2 Feb 2023 at 19:27, Derek Atkins  wrote:
> >
> > > Yes, when you start the reconcile dialog you can enter in the closing
> > date
> > > AND closing balance.  GnuCash tries to give you an option, but you can
> > > (and SHOULD) ensure it is the correct balance for the day.
> > >
> > > -derek
> > >
> >
> > I sometimes wonder if it would be better if there was no default value,
> > forcing one to enter a value. It is less likely to lead to mistakes.
> > ___
> > gnucash-user mailing list
> > gnucash-user@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@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Quicken Import Matcher

[David Carlson]

I don't recall the details from memory, but I think they vary somewhat
depending on the import type and possibly on the release of GnuCash that
you are using.  Please provide that information.

On Fri, Feb 3, 2023 at 3:43 PM Dale Alspach  wrote:

> Apparently sometime in the past I made an error when the matcher asked
> about a brokerage account. I have two TIAA brokerage accounts, one within a
> tax deferred IRA and one taxed. This did not matter much in the past
> because the small number of transactions could easily be fixed. Now there
> are many more and I would like to get the matcher to match correctly.
> I do not see any way to start fixing these transactions during the import.
> The account needs to be changed rather than the transfer account and I do
> not see how to do this.
>
> Is there a way to alter the setting for the account in the matcher?
>
> Dale
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Entry of unknown transaction

[David Carlson]

I have occasionally found a stray deposit receipt near an ATM when I was
withdrawing cash.  If I carelessly pocketed it with my receipt, I might get
a surprise later. The stray would have a different account number on it.
Could this be what happened to you?

On Sat, Feb 4, 2023 at 8:32 AM Michael Hendry 
wrote:

> On 4 Feb 2023, at 11:58, Jeff  wrote:
>
> >
> > I have discovered several transactions that show up in one account but
> do not show up in any other existing account. Regardless of what the bank
> image shows of where the check was deposited.
> >
> > I.E.  I have a deposit slip that shows it went to our checking account
> but never showed up there  (OFX or printed mailed statement).  I can not
> reconcile it so how do  handle it?
> >
> > In other words, I have half of a double entry transaction.  More than
> one, unfortunately.
> >
> > --
> > --JEffrey Black M.B.A.
>
> Not entirely sure what you mean, Jeffrey.
>
> Are the transactions you refer to recorded in GNUCash as money paid into
> your account but without a recorded source account? This should have a
> corresponding entry in the Imbalance account, automatically created when
> you put in an unbalanced transaction.
>
> Did you receive a check which you deposited in your checking account and
> for which your received a receipt from the bank in the form of a date-stamp
> on the deposit slip, but for which there is no record in the bank statement
> (paper or electronic)?
>
> If yes, then you need to take that up with the bank - was the check
> bounced?
>
> When you’re reconciling, you’re matching up the bank’s view of the world
> with your own, and can only mark as reconciled the transactions which
> appear in both.
>
> Michael
>
>
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Splitting an imported transaction?

[David Carlson]

 Simon ,
This is not too different from the situation with a personal payroll
deposit.  Like John suggested, create a template scheduled transaction
modelled after the document that the bank provides detailing the
transaction, but include something describing it as a template.  Then, when
you have the actual document in hand and, after importing the actual
transaction from the bank (which has the actual total), modify the
transaction created by the Since Last Run druid to match the real bank
numbers and then delete the imported transaction.

On Sat, Feb 4, 2023 at 11:18 AM john  wrote:

> > On Feb 4, 2023, at 7:23 AM, Simon Roberts <
> si...@dancingcloudservices.com> wrote:
> >
> > Hi all,
> >
> > I use a third party organization to run payroll, and they make two
> > withdrawals from my bank. One is the amount actually paid to employees
> (two
> > of us :) and the other is the sum of taxes collected from those
> employees,
> > plus the employer's tax contributions.
> >
> > Unsurprisingly, when this imports, from the bank records, it shows as two
> > transactions, and the tax stuff is all lumped into a single transaction.
> >
> > As yet, I've only handled this once and did it wrong anyway (I fixed it
> up
> > by hand OK though). However, in three months it'll happen again so I
> figure
> > if I ask now I could be ready to try to do it right next time.
> >
> > What I'd like--but suspect might be impossible, is to persuade the import
> > operation to create a split to the two accounts (payroll taxes: employer
> > and payroll taxes-employee). I'm not so concerned about how the money is
> > allocated across the split (there's really no way for the system to know
> > what to do about that, after all), but if there's a placeholder, that
> would
> > be a nice start.
> >
> > Or perhaps there's some other approach that I've not thought of?
> >
> > What do folks recommend?
>
> I suggest creating a scheduled transaction that creates the splits. Make
> the descriptions the same as the imported transaction and the posted date
> and amount as close as possible. The goal is for the matcher to see that as
> possibly the same as the imported transaction and offer to match it instead
> of creating a new one.
>
> Regards,
> John Ralls
>
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Operation is still running, wait for it to complete before quitting

[David Carlson]

I have occasionally seen that release of GnuCash do something similar to
that when it crashes.  In my case I just re-start it and click open anyway
at the prompt.  Then I check to see if whatever I was doing completed or if
I lost any recent keystrokes.  Usually there is little or nothing missing
because I do frequent saves before starting anything involving a lot of
keystrokes.

On Mon, Feb 13, 2023 at 5:52 PM Richard Dawson  wrote:

> On 2/13/23 14:06, Tommy Trussell wrote:
> > On Mon, Feb 13, 2023 at 3:46 PM Richard Dawson  wrote:
> >
> > Several hours after after successfully completing reconciliation, I
> > attempted to add another transaction, and I was greeted with the
> > message, "Operation is still running, wait for it to complete before
> > quitting." I've been waiting for an hour or so, and there is no hard
> > drive activity.  Attempting to save gives the same message.
> >
> >   If I recall correctly, I had saved the file when I completed the
> > reconciliation,  as that is my general practice, but I left the
> > machine
> > on with the file open.
> >
> > How should I proceed?
> >
> >
> > Unless your system is very very slow, I wouldn't expect ANYTHING in
> > GnuCash to take more than a few seconds to complete, though I am sure
> > there must be exceptions. I would strongly suspect a hardware or
> > network problem in your case.
> >
> > Can you determine and tell us the version of GnuCash you're running
> > (and where you got it, if not from an official source), and can you
> > tell us what operating system is running on your computer?
> >
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
> GnuCash 4.8, Build ID 4.8a+(2021-09-28)  I installed it from Ubuntu
> repository.
>
> My operating system is Kubuntu 22.04
>
> I've been running this version of gnucash for several years, since it
> became available via Ubuntu.
>
> I agree that it shouldn't take this long...  It's now been several hours
> more!
>
> Richard
>
>
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Net Income & Retained Earnings do not match

[David Carlson]

What document type is that attachment?  If it isn't something my computer
can scan for viruses, I won't open it.

Now, if you started a new file with the same account tree, it won't have
any transactions, so those reports will be different, in fact, IIRC, net
income should be zero and retained earnings whatever you set  the opening
balance to when you set up the new books.

On Tue, Feb 14, 2023 at 11:14 AM John Wilson 
wrote:

> I have set up a new set of books by exporting a tree of accounts from
> 2022, the old books, to 2023 the new books.
>
> In the old books the Net Income in my P&L report matched the Retained
> Earnings in my Balance Sheet report but it doesn't in my new set of books.
>
> Is this 'a bug' or have I done something to my tree of accounts?
>
> Help!
>
> --
> John Wilson,
> 3770 San Mateo Drive,
> Port Alberni, BC, V9Y 5H4
> Tel: 250-723-3752
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Migrating from PC to Mac

[David Carlson]

Martin

Open the file on your pc, then hover over the top entry in the drop down
menu under File.  Then the file name and folder will appear in the bottom
of the window.



On Thu, Feb 16, 2023, 5:49 PM Martin Taylor  wrote:

>Thanks
>Where do I find the data file?
>
>On 17/02/2023 12:35, David Cousens  wrote:
>
>  Martin
>
>  Coy the data file from your PC to your Mac and open it with GnuCash
>  on the Mac.
>  You could also store the data file in an online storage location
>  (Dropbox or
>  similar) or networked storage on your LAN if applicable, so that you
>  can open it
>  from either system.
>  If you have any saved reports you may also want to copy them See
>   https://wiki.gnucash.org/wiki/Configuration_Locations  for details.
>
>  David Cousens
>
>  On Fri, 2023-02-17 at 12:23 +1300, Martin Taylor wrote:
>  >
>  > I’ve got 4.13 installed and running on my PC, and I’ve also set up
>  4.13 on my
>  > Mac.
>  >
>  > I’ve tried exporting the account tree and transactions from the PC
>  to an
>  > external drive and then importing them into the Mac but have
>  struck a problem
>  > with the transaction file where the importer doesn’t recognise the
>  date format
>  > or the data in the Deposit and Withdrawal columns, and nothing
>  I’ve tried has
>  > got me past that point.
>  > The account tree seems to come across okay
>  > I’m sure there’s another way to do this, would welcome any
>  suggestions
>  >
>  > Martin
>  > ___
>  > gnucash-user mailing list
>  > gnucash-user@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@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@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@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.

Re: [GNC] importing

[David Carlson]

Hopefully that is a problem caused by the import being based on posting
dates rather than transaction dates.  Then it should be possible to sort it
out by looking at the monthly statement  and manually changing the
transaction dates if you want to go by transaction  dates  or as an
alternate manually putting the date in the transaction notes.

If they messed it up so badly that it is impossible to import the data,  I
would be inclined to move my business to a different provider.



On Thu, Feb 16, 2023, 5:54 PM Gyle McCollam  wrote:

> I ran into a unique problem with a credit card import.  I was buying gas
> at a station using a mastercard.  The transaction was on my credit card as
> pending, but would disappear and not be on my bill.  This went on for 6
> months, but they finally corrected the problem and billed me for the 6
> months of gas this month.  However, when I imported the file it said there
> were no matching transactions.  I used preferences to change the import
> parameters, but I could not change the dates to allow for transactions that
> old.  I could set the proper expense account, but that would double up on
> the transaction.  Is there a way to click or double click on the import
> matcher and manually select the matching transaction?
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccol...@live.com   email
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

Re: [GNC] Migrating from PC to Mac

[David Carlson]

I don't use a Mac.  We need a Mac user to answer that question.



On Thu, Feb 16, 2023, 6:48 PM Martin Taylor  wrote:

> Thanks David
>
> Found the file and have moved it to an iCloud folder. How then do I access
> it from the Mac?
>
> M
>
>
> On 17/02/2023, at 1:33 PM, David Carlson 
> wrote:
>
> Martin
>
> Open the file on your pc, then hover over the top entry in the drop down
> menu under File.  Then the file name and folder will appear in the bottom
> of the window.
>
>
>
> On Thu, Feb 16, 2023, 5:49 PM Martin Taylor 
> wrote:
>
>>Thanks
>>Where do I find the data file?
>>
>>On 17/02/2023 12:35, David Cousens  wrote:
>>
>>  Martin
>>
>>  Coy the data file from your PC to your Mac and open it with GnuCash
>>  on the Mac.
>>  You could also store the data file in an online storage location
>>  (Dropbox or
>>  similar) or networked storage on your LAN if applicable, so that you
>>  can open it
>>  from either system.
>>  If you have any saved reports you may also want to copy them See
>>   https://wiki.gnucash.org/wiki/Configuration_Locations  for details.
>>
>>  David Cousens
>>
>>  On Fri, 2023-02-17 at 12:23 +1300, Martin Taylor wrote:
>>  >
>>  > I’ve got 4.13 installed and running on my PC, and I’ve also set up
>>  4.13 on my
>>  > Mac.
>>  >
>>  > I’ve tried exporting the account tree and transactions from the PC
>>  to an
>>  > external drive and then importing them into the Mac but have
>>  struck a problem
>>  > with the transaction file where the importer doesn’t recognise the
>>  date format
>>  > or the data in the Deposit and Withdrawal columns, and nothing
>>  I’ve tried has
>>  > got me past that point.
>>  > The account tree seems to come across okay
>>  > I’m sure there’s another way to do this, would welcome any
>>  suggestions
>>  >
>>  > Martin
>>  > ___
>>  > gnucash-user mailing list
>>  > gnucash-user@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@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@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@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.

Re: [GNC] credit account negative balance increases with payment

[David Carlson]

Taking into consideration the advice given by others here, now try changing
Edit>Preferences>Accounts>Reverse Balanced Accounts to None from Credit.
This will change the running balance in your credit card accounts to the
red color that you prefer, but it will not change the text color, signs or
columns of the amounts in the transactions.



On Sat, Mar 4, 2023 at 4:14 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

>
>
> > I would take Stan's advice and change, at least temporarily, to the
> formal
> > accounting labels. The logic implemented in GnuCash to keep to the
> accounting
> > formalism is most clearly expressed in that format.
>
> Yes --- those new to double entry bookkeeping can be easily confused by
> the supposedly user friendly column titles. Gnucash is showing ledger
> accounts in three column format (pretty much a 20th Century change form
> the older two column format with no running balance kept. The three
> columns are debit, credit, and running balance.
>
> > A purchase made via  a Credit card account (a liability)  will have a an
> entry
> > with a split crediting that account with the other split a debit entry
> to an
>
> You can confuse folks new to double entry bookkeeping when you use a
> term like "split" that way. All transactions have AT LEAST two accounts
> affected, a debit and a credit. Reserve "split" for when there are more
> than two so either the debit side, the credit side, or both are split
> into more than one account on that side of the transaction.
>
> OK, back to the original problem. The transaction represented by a
> payment on a credit card would be a debit to the credit card account and
> a credit to the account from which the payment was made. That would
> USUALLY be a checking account, but notice that I am not assuming that <<
> the transaction MIGHT be a "balance transfer" between two credit cards >>
>
> I strongly suggest you choose options like "show as negative" only once
> you are experienced with double entry bookkeeping. Double entry
> bookkeeping evolved before European math accepted negative numbers. The
> "senses" are debit and credit (not positive and negative) and that's not
> the same. Instead, the different fundamental account types have either a
> debit or credit natural balance. If an account whose natural balance is
> debit has a credit balance that's like a negative but note that the
> reverse is true. For an account whose natural balance is credit, a debit
> balance would be like negative. In other words, can;t associate debit
> with plus and credit with minus.
>
> Michael D Novack
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Scrolling register

[David Carlson]

Ctrl G Enter takes you to today, or add mmddor mmdd to go to any
date.cant get any easier.

On Thu, Mar 9, 2023, 12:49 AM Peggy Schletty  wrote:

> My old GNU program let me scroll the register in date mode from start to
> present.  4.2 only goes so far & then jumps dates and I have to go back &
> find the date I was looking for. I’ve tried all sorting configurations and
> can’t change it. What do I do please?
>
> Sent from Mail for Windows 10
>
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

Re: [GNC] Schedule transaction for 2 Wednesday?

[David Carlson]

We must be having fun by now!  The only schedule that I have not been able
to implement correctly every single time is the Friday after the second
Thursday of the month, but then I really don't expect to get that one
right.🙂

On Fri, Mar 10, 2023 at 9:57 AM mjchurchil--- via gnucash-user <
gnucash-user@gnucash.org> wrote:

>  I think Stephen Butler is right. I get a deposit every 3rd Wednesday and
> gnucash gets it right every time. Don't remember the process to set it up,
> but his sounds correct. gnucash 4.13. Mike
> On Thursday, March 9, 2023 at 10:29:50 PM PST, Stephen M. Butler <
> stephen.m.butle...@gmail.com> wrote:
>
>  Set it on the Frequency tab.
>
> Frequency -- pick Monthly
> Every ? months -- (enter 1 into that box)
> On the {big drop down list}  -- Pick the '2nd Wed' from the list.
>
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
>
>
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Change column widths

[David Carlson]

There is a description of how to do this in the help.  Basically, grab the
right edge of the account column header and move it either way to the
desired width, then grab the right edge of the description column header
and move it left far enough to eliminate the horizontal scroll bar.

You can start by double clicking the category header, and if that makes the
account column too wide, grab the right edge an move it left as desired.

In the next software release there will be a fix so all the column widths
will be remembered when the register is closed.  Currently sometimes they
are not.

On Mon, Mar 13, 2023, 2:29 PM Björn Sunde 
wrote:

> I would like to shorten the width of the Description column and increase
> the width of the Transfer column as some of the Transfer entries are
> very long.  Is there some way to do this?
>
> Thanks in advance.
>
> James Wilde
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

Re: [GNC] Help with downloading transactions.

[David Carlson]

One thing that I am having trouble figuring out how to adapt to with
imports in any format is getting the transfer account right, particularly
with such things as "Zelle", which my bank gives very little additional
information with.  For those, sometimes there is an invoice in the mail but
we don't get a reference to it in the import from the bank.  I don't know
if the "Zelle" process allows adding a description when initiating the
transfer.

On Fri, Mar 17, 2023 at 6:56 PM George Riner 
wrote:

> I'm and 'M' and a 'K'.  I download from banks and I reconcile. I'm also
> a enter-by-hand (I don't know what letter-type that would be).
>
> I like downloading because it catches things I don't get receipts for
> and that I forget to hand-enter. On-line purchases, gas pumps that run
> out of receipt paper, or the receipt didn't get out of my pocket and
> went through the laundry.
>
> I reconcile, because it catches when I enter the charge in the wrong
> credit card acct, and it informs me for when a check I wrote has not
> cleared the bank, or some charge is delayed, or for when I hand-enter
> something and I do a typo.
>
> When I download, I never use the 'U' option - there's too much useless
> noise in the downloaded transactions that gets into my registers that
> only serves to clutter up reports. I'm assuming these numbers are
> meaningful to someone at the bank/creditcard, or maybe the retailer, but
> I've yet to find anything they match. They aren't Amazon order numbers
> or Amazon receipt numbers, nor Amazon invoice numbers. Maybe some
> transaction number that only the bank knows about?  Plus, names of
> businesses rarely match, and even when they do, they're often all UPPER
> CASE and often include misguided attempts by the retailer for Customer
> Relationship Management by adding in "THANK YOU FOR YOUR PURCHASE!!"
> which is totally useless in my accounts & reports.
>
> I wish there was a way to turn off the 'Bayesian" amount matching.
> Because I don't want to be close, I want to be exact. So when
> reconciling I have to carefully watch the matching transactions to make
> sure they're aren't off by $0.02 or some tiny amount.
>
> For downloaded transactions that have to be added, I use the 'A' option,
> but I force all those transactions to go into a special account - I name
> it 'Unspecified' (under Expenses).  I then apply the downloaded
> transaction and then go through all the 'Unspecified' entries in Journal
> view and clean them up and correct the expense account to apply them to.
>
> The Reconcile function also has a really useful way of creating the
> payment transaction and giving it a future date (the payment due date,
> for example), and posting it to my bank acct.
>
> :George
> Windows 10 build 19045.2604
> Gnucash Build ID: 4.11+(2022-06-25)
>
>
>
> On 3/17/2023 1:57 AM, ed...@billiau.net wrote:
> > On Thu, 16 Mar 2023 15:38:25 +
> > Gyle McCollam  wrote:
> >
> >> You really should try to download and import transactions.
> > This is a philosophical point.
> > There is group "M" who always enter every transaction first in their
> > books and then use the bank documents to reconcile
> >
> > and
> >
> > There is group "K" who enter some things and use the bank download to
> > keep their accounts.
> >
> > There are pros and cons to each method. Gnucash allows you to make your
> > own choice.
> >
> >
> > Liz
> > ___
> > gnucash-user mailing list
> > gnucash-user@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@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Two versions, same computer

[David Carlson]

As an experienced user of VirtualBox, I would say that your use case is
exactly what VirtualBox is best for,  ie temporary computer needs.  The
main requirement is having enough RAM and cpu's to share with your other
programs.

On Mon, Mar 20, 2023, 3:21 PM Stan Brown (using GC 2.6.19) <
stan+gnuc...@fastmail.fm> wrote:

> I apologize for asking a question that must have been asked before, but
> I couldn't turn up answers by googling or in the archives.
>
> Can GC 4.13 coexist on the same Windows 10 machine with GC 2.6.19? They
> would be accessing separate data files in separate folders, and would
> not be executing simultaneously, but I worry about preferences, reports,
> most-recently-used file lists, and anything else that might get stored
> in the System Registry or a fixed location.
>
> It might be helpful to explain my use case.
>
> I'm on the board of a small nonprofit. Our longtime volunteer bookkeeper
> is bowing out, and the treasurer who will have to take over the
> bookkeeping doesn't have experience with any accounting software. We
> have an average of just a couple of dozen transactions a month, and the
> reports we need are just the standard income statement and balance
> sheet, plus transaction reports for the Income:Donors and
> Expenses:Musician Fees accounts. There's no need for the software to
> print checks or 1099 tax forms (we must file one 1099 for each
> non-employee we make payments to), though that would be a nice plus.
> I want to put together a chart of accounts and the transactions for
> the year to date in GC 4.13. If the treasurer feels comfortable with
> entering transactions and pulling reports, I will install everything for
> the nonprofit to her computer. All of that will be in the 4.13 and only
> that version.
> But I'm keeping my own books on my computer, and they're in GC
> 2.6.19 and only 2.6.19 for now. (I know it's necessary to upgrade in
> phases and I'm not ready to do that now.)
>
> I suppose I could install a virtual machine for running 4.13, but that
> seems like a lot of work for a short-term need. Another possibility is
> the portable 4.13 install at
> 
> but I remember some discussion in this list about some reasons not to
> use that.
>
> Can I install 4.13 on my current machine without it and 2.6.19
> interfering with each other, provide that they don't run simultaneously
> or use the same saved reports?
>
> --
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

Re: [GNC] Cut & Paste transaction problem

[David Carlson]

I would be willing to bet that you never automatically got the original
date on any copy.  When I use the copy transaction feature in previous
releases of GnuCash up to 3.8 it always asks for the date and defaults to
today if not changed.

On Mon, May 3, 2021, 2:19 PM Robert Stocker  wrote:

> Follow up to my earlier post, which I just noticed. My recommended
> work-around for the Cut Transaction & Paste Transaction problem (using Copy
> Transaction & Paste Transaction) has an issue I have never noticed before:
>
> When I just used Copy Transaction & Paste Transaction, the date of the
> original transaction did not carry through when I pasted, the new
> transaction took today's date. Though I can't swear that it wasn't doing
> this before, I am 95% certain it did not.
> ___
> 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.

Re: [GNC] Blank entry in my check register -- can't be removed

[David Carlson]

I have occasionally had the 'New Transaction' window seem to get stuck in a
fixed position in the transaction sequence of the register view and not
disappear or fall to the bottom of the window when it ordinarily would.
When that happened to me, it would revert to it's expected behavior after
saving and re-booting.  I was never able to figure out why.

On Mon, May 3, 2021 at 5:03 PM randix  wrote:

> I'm using Windows 10 Pro, GnuCash Version: 4.5
> Build ID: 4.5+(2021-03-27)
> Finance::Quote: 1.49
>
> This issue is a new one, I've never experienced in all the years of using
> GnuCash.
>
> In my check register for one of my accounts, I just noticed a blank
> transaction (has a May 2nd date and all other fields are empty). If I try
> and delete it, *nothing happens*. I exited out of GnuCash and then
> re-started, but it's still there.  It's almost like it's "locked" but that
> feature doesn't exist (does it?) in GnuCash.  This blank line appears
> amongst other transactions, both before and after, eg it's not the
> "standard" blank line for new entries (that remains unchanged) that appears
> on the current date.
>
> It's not impacting the balance, etc., so I guess it's "harmless" but...
>
> Any ideas of what's goin' on?
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Trouble Installing Online Price Retrieval Tool

[David Carlson]

Sudesh,

I think you have completed the installation correctly.   Since you also
obtained a key from Alpha Vantage you should be able to use their service
to download prices if they provide the ones that you want. For some stock
quotes you may get better results using one of the other services that the
finance-quote software can access.  Ask here about specific quotes on
specific exchanges.

For example,  I use Yahoo as json service for quotes on the US exchanges
because I download about 30 prices at a time.






On Wed, May 5, 2021, 5:19 AM Sudesh Chandar via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello Geoff,
> Many thanks for the fast reply.
> Actually the Perl scripts ran longer than 30 minutes much closer to 3
> hours and after all that It threw up an error about "Alpha Vantage  API
> Key". I had to manually visit the alphavantage website and request a key
> and update Gnucash app under edit/preferences.
> Is this normal?
> Once I updated the key It seems work okay now.
> Like I said before, I am still a newbie at this,
> My next step is how to setup a stock symbol in the price database/Get
> quotes button?
> Currently pressing the button only gives me currency conversion between
> USD and INR.
> Thanks,
> - SudeshOn Wednesday, May 5, 2021, 01:00:54 PM GMT+5:30, Geoff <
> cleanoutmys...@gmail.com> wrote:
>
>  Hi Sudesh
>
> Some of the required Perl modules take a considerable time to install
> and the process may appear to "freeze" when in fact it is only "resting".
>
> Can you try again - you need to run the "gnc-fq-update" script located
> in the "C:\Program Files (x86)\gnucash\bin\" directory - and send a
> screenshot if it is still hanging after 30 minutes.
>
> Thanks
>
> Geoff
> =
>
> On 5/05/2021 5:09 pm, Sudesh Chandar via gnucash-user wrote:
> > Hello  Group,
> > I am a new user of GNU cash and have recently downloaded and installed
> Gnucash ver 4.5 on a windows 10 64 bit machine.
> > I am trying to run the script for Installing online price retrieval and
> the command line freezes after a while.
> > It installed the Strawberry perl just fine and the install check and
> version check passes ok and then it copies all the *.pm files just ok.
> > Where it hangs is after the message  "C:\Strawberry\c\bin\gmake.exe --
> OK'
> > What am I missing?
> > I also checked the Gnucash app under the help menu/ about and the
> "Finance::Quote" module is not installed.
> > Any Help from the group as to why this is happening and how to resolve
> it?
> > Regards,Sid
> > ___
> > 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.
>
___
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.

Re: [GNC] The welcome section that would provide assistance to get started is not showing up. Where can I find it?

[David Carlson]

If you are referring to the "Tip of the Day" dialog or the startup splash
screen, there are settings under Edit > Preferences > General to enable or
disable them.  General help can always be found by clicking F1.


On Mon, May 10, 2021 at 8:17 PM Carolyn Knee 
wrote:

>
>
> Sent from Mail for Windows 10
>
>
>
> --
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] What is the current GnuCash version and...

[David Carlson]

Fran,

Since you are using Windows, the Windows installer will automatically
remove the current version and install the new version.

If you had done a non-standard installation that might not work smoothly,
but it will leave your saved report settings, window sizes, etc. intact.  I
believe there may be an issue with selecting accounts if you are building
new transactions in that particular release - see "[Bug 798061] Quickfill
for account splits on Windows: input freeze if more than 2 characters are
typed" for info.  If that will affect you, you may want to wait for the
next release before updating.

On Wed, May 12, 2021 at 7:51 PM Glenn Fowler  wrote:

> Hi,
>
> The current version is 4.5 which you can d/l here:
> https://www.gnucash.org/download.phtml
>
> You shouldn't have any issues upgrading from 4.1 to 4.5 since it's not a
> major release change as detailed here:
>
> https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade
>
> On Wed, May 12, 2021 at 8:04 PM Fran_3 via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> > Running Version: 4.1
> > Build ID: 4.1+(2020-07-25)here on  Windows 10 system
> > What is the latest version and can I just download it and install it or
> > should I remove the old version first... or what proceedure?
> > Thanks for any help.
> > ___
> > 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.
>


-- 
David Carlson
___
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.

[GNC] Url and file links in scheduled transactions.

[David Carlson]

I have not figured out how to attach a url or a file link to a scheduled
transaction.   Is that possible?
___
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.

Re: [GNC] Transparent background on selected Transfer choice

[David Carlson]

I did not see anything about themes in that bug report
https://bugs.gnucash.org/show_bug.cgi?id=797493 except in a reference to
another bug report where the user admitted to choosing a non-standard
desktop theme.  I did see the problem myself briefly recently but now I
forgot when.  I suspect that I may have seen it on Windows rather than
Linux.  Tht referenced bug report stated that when the user switched to the
Adwaita theme (which, IIRC, is the default theme for several Linux
desktops) the problem disappeared.  Thus IMHO the theme concern does not
apply to 797493

I don't change desktop themes often, if ever or themes for GnuCash, I leave
it as 'out of the box', and I believe if David Pickett did too, then I
think it is a GnuCash bug

On Thu, May 13, 2021 at 10:17 AM Chris Good  wrote:

> Message: 4
> > Date: Thu, 13 May 2021 13:45:04 + (UTC)
> > From: "David G. Pickett" 
> > To: "gnucash-user@gnucash.org" 
> > Subject: [GNC] Transparent background on selected Transfer choice
> > Message-ID: <964888588.96833.1620913504...@mail.yahoo.com>
> > Content-Type: text/plain; charset="utf-8"
> >
> > I run GNUCash on Ubuntu LTS Linux, and when I select a transfer choice,
> the background under the choice goes transparent, showing the transaction
> screen below, see attached; not at all helpful!
> > -- next part --
> > A non-text attachment was scrubbed...
> > Name: Screenshot from 2021-05-13 09-41-41.png
> > Type: image/png
> > Size: 249379 bytes
> > Desc: not available
> > URL: <
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210513/ae179ec6/attachment.png
> >
> >
> >
> Hi David,
>
> This looks like https://bugs.gnucash.org/show_bug.cgi?id=797493 which is
> a problem with your theme.
>
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Transparent background on selected Transfer choice

[David Carlson]

Thanks for finding work-arounds for cases where there is an issue.

On Fri, May 14, 2021 at 2:06 AM Chris Good  wrote:

> Hi David(s),
>
>
>
> David Carlson,
>
> Did you see https://bugs.gnucash.org/show_bug.cgi?id=797493#c4 which
> mentions themes?
>
> I tested this in Windows 10 and could not duplicate it.
>
>
>
> I did duplicate this problem in Ubuntu 20.04 and found a couple of
> work-arounds.
>
> Please see
>
> https://bugs.gnucash.org/show_bug.cgi?id=797493#c6
>
>
>
> Regards,
>
> Chris Good
>
>
>
> *From:* David Carlson 
> *Sent:* Friday, 14 May 2021 7:21 AM
> *To:* Chris Good 
> *Cc:* Gnucash Users ; David 
> *Subject:* Re: [GNC] Transparent background on selected Transfer choice
>
>
>
> I did not see anything about themes in that bug report
> https://bugs.gnucash.org/show_bug.cgi?id=797493 except in a reference to
> another bug report where the user admitted to choosing a non-standard
> desktop theme.  I did see the problem myself briefly recently but now I
> forgot when.  I suspect that I may have seen it on Windows rather than
> Linux.  Tht referenced bug report stated that when the user switched to the
> Adwaita theme (which, IIRC, is the default theme for several Linux
> desktops) the problem disappeared.  Thus IMHO the theme concern does not
> apply to 797493
>
>
>
> I don't change desktop themes often, if ever or themes for GnuCash, I
> leave it as 'out of the box', and I believe if David Pickett did too, then
> I think it is a GnuCash bug
>
>
>
> On Thu, May 13, 2021 at 10:17 AM Chris Good  wrote:
>
> Message: 4
> > Date: Thu, 13 May 2021 13:45:04 + (UTC)
> > From: "David G. Pickett" 
> > To: "gnucash-user@gnucash.org" 
> > Subject: [GNC] Transparent background on selected Transfer choice
> > Message-ID: <964888588.96833.1620913504...@mail.yahoo.com>
> > Content-Type: text/plain; charset="utf-8"
> >
> > I run GNUCash on Ubuntu LTS Linux, and when I select a transfer choice,
> the background under the choice goes transparent, showing the transaction
> screen below, see attached; not at all helpful!
> > -- next part --
> > A non-text attachment was scrubbed...
> > Name: Screenshot from 2021-05-13 09-41-41.png
> > Type: image/png
> > Size: 249379 bytes
> > Desc: not available
> > URL: <
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210513/ae179ec6/attachment.png
> >
> >
> >
> Hi David,
>
> This looks like https://bugs.gnucash.org/show_bug.cgi?id=797493 which is
> a problem with your theme.
>
> 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.
>
>
>
> --
>
> David Carlson
>


-- 
David Carlson
___
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.

Re: [GNC] Interface Issues

[David Carlson]

I think there are a huge number of serious bugs, not to mention previously
registered enhancement requests that IMHO would take priority over those
requests even if the developers were to take them seriously.  They would
love some assistance if you can help.

On Fri, May 14, 2021 at 7:03 PM flywire  wrote:

> 8) [Transaction] Report, Sorting tab options at bottom of form should be on
> Display tab.
> 9) [Transaction] Report, Sorting tab /Show subtotals only (hide
> transactional data)/ is very useful but headings should be normal text at
> this level.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
>


-- 
David Carlson
___
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.

[GNC] Associate a file with the selected transaction.

[David Carlson]

I would like help with the above subject.  This is an action in the
transaction menu which seems to have no description of what it does or how
to use it.  I tried to use it and it produced a letter in the top bar of
the transaction display.  Now when I right-click on the transaction there
is an action Open Associated File/Location.

When I try that, I get an error message "GnuCash could not open the
associated Url:" then it shows a URL that should be pointing to a file or a
location.  However, there is no information on how to fix the problem.  It
seems like the solution might depend on the OS and certain characteristics
of the URL.  I would like a general answer for Windows, Linux, MAC, and
local vs network locations and, perhaps, relative vs absolute addressing if
that matters.

-- 
David Carlson
___
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.

Re: [GNC] importing transactions overwrites notes

[David Carlson]

Welcome to the GnuCash user list.

You can limit what information GnuCash overwrites by choosing the Update
option while in the matching phase of a OFX or QIF import.  For each
transaction note what GnuCash will overwrite, which may be the notes that
you want to keep, the amount or the date.  If it is the notes, then choose
to either make the imported transaction 'New" if it contains data necessary
for correct reconciliation, or do not import it.  Then later you must
remember to manually fix the issue that you could not fix during the import
process, a lot of work, I know. Set up a routine that makes it easier to
remember everything.

I will warn you against trying to edit the existing transactions during the
import process, because it is possible to accidentally place the curser in
an incoming transaction which can make quite a mess while trying to
extricate it.



On Sat, May 15, 2021 at 11:38 AM Robert F. Crochelt 
wrote:

> Good morning:
> I am a new gnucash user and I find it quite useful.
> When I enter a transaction I often put data in the "notes" field.
> However, when that transaction is imported via a Quicken file it
> overwrites the note entry I made.  Can I modify this behavior?
> Thanks
> --
>
> Bob Crochelt MD, PhD, FACS
> Ukiah, CA
>
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Associate a file with the selected transaction.

[David Carlson]

David H,

I cannot find any help for that setting either.  Is that mandatory to make
the individual associations work?  Do all associated files need to be in
the same place? What if the GnuCash data file is on a USB key?  Did I
mention encryption?

On Sat, May 15, 2021 at 6:04 PM David H  wrote:

> David,
>
> Don't forget there's also a Gnucash : General : Linked Files preference
> that allows you to set the "Path head for Linked Files Relative Paths"
> which I believe is used to point to the folder you want to keep your
> associated files in.
>
> Cheers David H.
>
>
> On Sun, 16 May 2021 at 02:41, David Carlson 
> wrote:
>
>> I would like help with the above subject.  This is an action in the
>> transaction menu which seems to have no description of what it does or how
>> to use it.  I tried to use it and it produced a letter in the top bar of
>> the transaction display.  Now when I right-click on the transaction there
>> is an action Open Associated File/Location.
>>
>> When I try that, I get an error message "GnuCash could not open the
>> associated Url:" then it shows a URL that should be pointing to a file or
>> a
>> location.  However, there is no information on how to fix the problem.  It
>> seems like the solution might depend on the OS and certain characteristics
>> of the URL.  I would like a general answer for Windows, Linux, MAC, and
>> local vs network locations and, perhaps, relative vs absolute addressing
>> if
>> that matters.
>>
>> --
>> David Carlson
>> ___
>> 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.
>>
>

-- 
David Carlson
___
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.

Re: [GNC] Associate a file with the selected transaction.

[David Carlson]

Michael,

The topic is Associate a file with the selected transaction
and the discussion is about identifying and locating the associated files.
This issue just gets more complicated when multiple books are involved.

On Sun, May 16, 2021 at 10:16 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

>
> > and for people with multiple books, how to easily store in separate
> > places for each book
> >
> > Liz
>
> I have (and have had) many different sets of books kept under gnucash.
> For this reason, I am totally unclear what problem users seem to be having.
>
> A set of books under gnucash is a file. When you create a file (not
> specific to gnucash) you give it a name, possibly/usually including a
> file extension indicating type, and specify a location for it (directory
> aka file folder). For example, when you crate a new set of books, the
> first "save" should be a "save as" and at that time you would get to
> specify what you want for the name of this file and where you want it to
> be.
>
> Is THAT the problem?
>
> Are people saying that they have a problem with multiple books, storing
> in multiple locations never doing this? Simply doing a "save" (that
> first time) accepting the default name and default location? << these
> would always be the same >>
>
> Michael D Novack
>
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] CSV matching produces duplicates?

[David Carlson]

I can't read that file on my smartphone,  but what are we supposed to do
with it?  Ask our bankers to change their csv format to match it?

On Mon, May 17, 2021, 5:32 AM flywire  wrote:

> Sample account that shouldn't need manual matching:
>
> <
> http://gnucash.1415818.n4.nabble.com/file/t374675/GnuCashCsvImportMatchingExample.png>
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.

Re: [GNC] Migrating and updating 2.6.21 in Windows 7 to 3.11 in Windows 10 No sub-accounts

[David Carlson]

Unfortunately it is hard to tell where GnuCash is getting stuck, if it is.
 For a large data file or a computer with limited resources it may take
more than ten minutes, possibly an hour or more to do the repair steps.
You may need to use the task manager to monitor whether GnuCash is still
using cpu time.

Perhaps someone else has a suggestion.

On Tue, May 18, 2021, 3:04 PM  wrote:

> I am going to try again by starting a new thread to get past where I'm
> stuck
> updating version 2.6.21 on a Windows 7 computer to version 3.11 on a
> Windows
> 10 computer.
>
>
>
> I moved the 2.6.21 database to the Windows 10 computer along with the
> .gnucash file with the saved reports. Saved reports is not as important as
> getting access to the data completely. I installed version 3.11 on the new
> computer, opened the program and from there opened the 2.6.21 data file.
> Then I ran Action>Check & Repair>Check & Repair All.
>
>
>
> The problem I'm having is that the sub-accounts under Assets appear but not
> under liabilities, equity, income and expenses. Running Action>Check &
> Repair>Check & Repair sub-accounts one at a time for liabilities, equity,
> income and expenses seems to work so some extent but not completely. There
> are three levels of sub-accounts in some cases. The totals under the major
> account headings, assets, liabilities, etc. appear to be correct and the
> information is in the database, just having trouble opening the arrow to
> access the sub-accounts.
>
>
>
> We couldn't stop work so have continued to use the Windows 7 computer to
> keep up with the account while we figure this out. When we do, we will have
> to start again and move the latest version of the database to the new
> computer, replacing the file we are working with and go through the check
> and repair process again.
>
>
>
> What step am I missing to correct this problem?
>
>
>
> Thanks,
>
> Roger
>
> ___
> 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.

Re: [GNC] Cannot always over-type, clear selected amounts

[David Carlson]

David P.

I am running a similar setup, GnuCash 3.8 in Linux Lite which is a
derivative of Ubuntu 20.04 on a virtual machine.  For me, GnuCash seems
rather slow responding from time to time, and sometimes needing to be
'kicked' by somehow moving the curser to a different field in order to
'wake it up' and enter text keystrokes.  Seems strange that it sometimes
cannot accept text yet accept other keystrokes and mouse gestures.  When I
get too frustrated I close GnuCash and re-open it and it will work better
for a few hours.  If it gets really bad I sometimes need to re-boot.  So
far, I have figured out that it is not overloading the cpus or using enough
RAM to need to swap memory.

On Tue, May 18, 2021 at 11:27 AM David G. Pickett via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Sometimes GNUCash gets in a mood, and I cannot over-type or delete
> selected amount fields in a transaction.  I can click aside to deselect and
> then backspace/delete the digits, decimal and type in the correct number,
> but I wonder what happened to the usual GUI behaviors?  I run Ubuntu
> 20.04.2 LTS and GNUCash 3.8b+(2019-12-29) and Finance Quote 1.49, the
> latest defined for Ubuntu LTS.
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] A Linux utility/program to print ABA and account numbers on stock/blank checks

[David Carlson]

Been years since I tried it but in the past I think that it is as simple as
going to your bank account register, highlighting a transaction, and
clicking File > Print Checks.  That should get you to a screen where you
design your checks, print test pages, etc.

On Thu, May 20, 2021 at 4:14 PM local10 via gnucash-user <
gnucash-user@gnucash.org> wrote:

> May 20, 2021, 10:57 by tom.brow...@gmail.com:
>
> > Keep an eye out for my Raku module CheckWriter at <>
> https://github.com/tbrowder/CheckWriter> > (a WIP). I bought a pack of
> single-check letter-size paper from Office Depot to use it with.
> >
>
> I took a look at the CheckWriter module but I'm a bit confused how you use
> it with GnuCash. What are the steps that are necessary to print a check
> from GnuCash using the CheckWriter module?
>
> Thanks,
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Bank & Credit Card account balance

[David Carlson]

Where do you want to see the present balance?  If you have the account
register open you can see the present balance in the bottom left corner of
the register next to the future balance, cleared balance, reconciled
balance and projected minimum balances.  You can run various reports to get
many account balances on one page.
 If, for some reason you want to temporarily hide future transactions in a
single account you can click View > Filter by > and choose to hide dates
after today...

On Sun, May 23, 2021 at 2:41 PM Ze'ev Ionis  wrote:

> Currently the bank and credit card balances reflect all the activity in
> the account.  But I enter many post-dated entries (future dated).  Is it
> possible to display Current balance - i.e. ignore future activity?
>
> Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows 10
>
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Trial Balance Error

[David Carlson]

Dennis,

When you sold the stock you realized a capital gain or loss.  To account
for that in GnuCash is a little tricky.  You can determine the amount by
adding up all cash spent to buy the stock and the sale proceeds.  The
difference is the (hopefully) gain.  Look in the tutorial for details on
recording the capital gain.

I will warn you that you need to use the tab key to navigate into the split
line where you actually enter the gain in order to avoid entering a
quantity of shares.

Good Luck

On Sun, May 23, 2021 at 3:40 PM dennis adams  wrote:

> I recently ran a Trial Balance report for the first time.  Debits and
> credits different by tens of thousands.  Most problems were easy to find
> and got the difference down to about $161.50.  I walked the difference
> first by year, then by month and then by day until I found the day where it
> went from balanced (11/19/20) to unbalanced (11/20/20).  Then ran a
> transaction report for 11/20/21.  There were only two, sale of a stock and
> a dividend for another stock.
>
>
> The dividend entry had a debit with a corresponding credit in the correct
> accounts.The stock sale proceeds showed a debit for my sweep account
> (asset) but no credit for any other account although it showed a credit for
> the number of shares sold.  Checked the stock account and sweep account and
> everything looked good.  I ran a balance sheet for the day and assets minus
> liabilities equaled total equity.  Finally, I did a side by side, line by
> line comparison of the 11/19/20 and 11/20/20 Trial Balance reports.
> Everything matched perfectly with the exception of the bank sweep account
> and the stock dividend account which reflected the transactions for
> 11/20/20.  The only other differences was the unrealized gains for stocks
> and the daily downloaded stock prices from 11/19/20 to 11/20/20.  I do not
> know what else to do to try to find the error.  Any thoughts or
> recommendations?
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Trial Balance Error

[David Carlson]

Dennis.

I do not have a good understanding of how the trial balance report works,
but it does look at security prices in the GnuCash price database.  That is
over my pay grade.
If you have been tracking that stock price in GnuCash, that can do funny
things to the way the report assigns values to the stock at various times.
In fact, I have found that there are ways to fill the price database with
bad numbers so it would not hurt to look at what is in your price
database..

I also do not use scrubbing, so I cannot comment there either.

On Sun, May 23, 2021 at 4:40 PM  wrote:

> Hi David,
> Thanks.  I’ve studied the cap gains and think I have a reasonable
> understanding of how to determine either manually or by scrubbing.  In this
> case, I sold the stock for exactly what I paid for it.  I waited until the
> price was close and put a limit order in and it hit.  No commission either
> way so cap gain is zero.  I did the automatic with scrub but nothing
> registered anywhere and I assumed it was because there was zero gain/loss.
> Do you think that might be my trial balance report difference even though
> the numbers aren’t close or multiples?
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Transparent background on selected Transfer choice

[David Carlson]

What are the disadvantages of the flatpak version?

On Fri, May 28, 2021 at 6:30 PM David H  wrote:

> You either compile it yourself or use the flatpak version -
> https://wiki.gnucash.org/wiki/Flatpak
>
> Personally I've just gone to the flatpak version as it's a lot easier than
> dicking around trying to compile it and it's kept up to date with each
> Gnucash release - thanks Geert, John, et al - much appreciated.
>
> Cheers David H.
>
> On Sat, 29 May 2021 at 08:02, David G. Pickett via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> > How do I force the install of a higher version than Software Updater
> > allows?
> >
> >
> > -Original Message-
> > From: Eric Coates 
> > To: Chris Good ; gnucash-user@gnucash.org
> > Cc: dgpick...@aol.com
> > Sent: Fri, May 28, 2021 7:07 am
> > Subject: Re: [GNC] Transparent background on selected Transfer choice
> >
> >  Good Morning All
> >  Hi David (dgpick...@aol.com) + Eric (twistedw...@talktalk.net),
> >
> > Can you please test the fix Geert found in
> > https://bugs.gnucash.org/show_bug.cgi?id=797493#c12
> > and let us know how you go?
> >
> > Can you reconfirm the Linux distro and version too please so I can
> document
> > in the bug.
> >
> > Regards, Chris Good
> >
> >
> >  I'm running Ubuntu 21.04 with GnuCash 4.4 with Finance Quote 1.49.
> >   I created the file
> > $HOME/.var/app/org.gnucash.GnuCash/config/gnucash/gtk-3.0.css  and added
> in
> > Geert's snippet. I was then able to choose the Yaru theme and the
> > transparency issue was not apparent. I can also confirm Geert's assertion
> > that the Adwaita theme is not affected. Thanks to all those who took time
> > to investigate and fix this problem.
> >   Take care Eric
> >
> >
> > ___
> > 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.
>


-- 
David Carlson
___
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.

Re: [GNC] question - how do I move one or more transactions between accounts?

[David Carlson]

The method described by DaveC49 is about the only practical way to do it.

However,  if you want to change the account for a split line from the
current account to a different account,  it is faster to first jump to one
of the other accounts in that transaction before changing.   Changing the
"home" is much slower, and waiting for the transaction to disappear is a
pain in the neck.

On Sat, May 29, 2021, 5:13 AM DaveC49  wrote:

> To move one split of  a transaction from one account to another if you edit
> the transaction in the register for the account of the split which is going
> to be unchanged. A all you have to do is change the account in the Account
> column. Delete the existing selected account and you should get a drop down
> list which will allow you to select the new account for the split. There is
> no bulk cut and paste type operation AFAIK.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.

Re: [GNC] New Imbalance-XXX Behavior

[David Carlson]

The Imbalance-xxx account will reappear the next time an error is made in
balancing a transaction, or if a transaction is intentionally left out of
balance to be fixed later, so it is useless to delete the account.
I agree with David T that new entries should go to the existing account,
even if it is not in the default position in the CoA.

On Mon, May 31, 2021 at 9:45 AM Derek Atkins  wrote:

> The existence of an Imbalance account means you have an error in a
> transaction.  So you should fix it and empty it..
>
> -derek
> Sent using my mobile device. Please excuse any typos.
> On May 31, 2021 10:34:48 AM "D. via gnucash-user"
>  wrote:
>
> > Hello,
> >
> > I have noticed a new behavior in regards to the automatic creation of
> > entries to Imbalance-XXX (in my case,  Imbalance-USD).
> >
> > When I first started using Gnucash, I found the creation of a top level
> > imbalance account to be additional unwanted clutter to my Chart of
> > Accounts. I found, by sheer coincidence, that I could move the top level
> > account into a different area of my CoA (in my case, a top level
> > placeholder called Special Accounts, which includes a number of these
> types
> > of accounts), and Gnucash would use that newly-situated Imbalance-XXX
> > account for all new automatically-created imbalance entries.
> >
> > Alas, this is no more. In my most recent session, I have found that
> Gnucash
> > has decided that it must ALWAYS use a top level Imbalance account for
> these
> > entries. I find the concomitant clutter of my books annoying.
> >
> > This is disappointing. Does anyone know why this behavior has changed,
> and
> > is there any point to submitting a bug request to have the previous
> > behavior restored?
> >
> > David T.
> > Gnucash user since 2005
> > Current: GC 4.5 on Windows 10
> >
> > ??
> > ___
> > 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.
>


-- 
David Carlson
___
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.

Re: [GNC] New Imbalance-XXX Behavior

[David Carlson]

DaveC49,

Your information is interesting, but it does not restore the behavior that
previous releases already had, and the current release lost, as David T
pointed out.  I think he is saying that in his opinion, it wasn't broke,
didn't need fixing.

On Mon, May 31, 2021 at 10:24 PM DaveC49  wrote:

> David,
>
> I'm not sure why the behaviour has changed, but from a programming
> prospective, it is much simpler to create the imbalance accounts at the top
> level. There is no need to search for a location which may be different in
> every user's CoA. One reason perhaps for keeping it at the top level is
> that
> it sticks out and alerts the user they have made an error in a transaction,
> which is perhaps a benefit for new users, although annoying for those who
> have an established workflow which takes care of detecting errors anyway
>
> If an older version of GnuCash was able to create new imbalance accounts in
> a lower level position in the account heirarchy, then it had to be
> recording
> that location in the heirarchy that the Imbalance account had been shifted
> to after its initial creation at the top level in some manner.
>
> It should not be too hard to have a preference setting for the Imbalance
> account location and if a user shifts an Imbalance account from the default
> location, set that preference location to the location in the CoA the
> account is moved to and use that for subsequent creation of Imbalance
> account entries.  I can imagine that some users could want to have
> Imbalance
> accounts for different currencies in different locations which would
> require
> a preference location for each currency in use.
>
> Just requires someone to program/reprogram it.
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

[David Carlson]

I might add here that there are corner cases where it is very difficult to
quickly bring a transaction into balance, and sometimes it is necessary for
an accounting judgement needing to be made.
Many of these cases arise when something does not have a well defined
value, so an estimated value needs to be assigned, possibly by someone
other than the person entering the transaction.
Other times it is necessary to draw on calculations that cannot be made on
the fly, such as realized gains on security sales, which may need
cumulative values from multiple opening transactions, along with multiple
previous partial closing transactions and time intervals calculated as well.

On Tue, Jun 1, 2021 at 4:35 PM David Cousens 
wrote:

> John,
>
> Actually you are given the opportunity to fix it during entry. When the
> Imbalance account appears in a transaction in the account column, all you
> have
> to do is click on it in the Account column and assign the correct account
> from
> the drop down list, before closing (pressing Enter) the transaction.
>
> In two split transactions GnuCash will assign the amount of the entry in
> the
> first split to the second split automatically and if you select a valid
> transfer
> account no imbalance will occur. If you don't select a valid account or
> alter
> the amount when creating a transaction with 3 or more splits, the
> imbalance can
> be created.
>
> As Michael indicated the other common scenario is when the target account
> does
> not exist and has not been created before entry.
> David Cousens
> (yet another David)
>
> On Tue, 2021-06-01 at 11:07 -0400, John Morris wrote:
> > Given the extremely long history of this question with many good people
> > expressing good reasons on both sides of the debate, I would have
> expected the
> > developers to give the user the choice. There should be a switch in the
> > preferences that allows the user to decide if the necessary extra
> accounts
> > will be created as needed to address an imbalance or the user will be
> forced
> > to correct the imbalance before completing the transaction. Personally, I
> > would choose the latter, but I am not allowed that freedom with GnuCash.
> >
> > John
> >
> > > The question about imbalance entries goes back a long ways in GnuCash,
> and
> > > you can find discussions about it in the lists over the years.
> > >
> > > Essentially, the debate boils down to this: is it better to allow a
> user to
> > > enter an imbalanced transaction and automatically create the balancing
> entry
> > > in a dummy account (Imbalance-XXX generically speaking), or should the
> > > program nag the user to balance the transaction every time? Gnucash
> choose
> > > the former many years ago, and has stuck with that model since.
> > >
> > > David
> > ___
> > 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.
>


-- 
David Carlson
___
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.

Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

[David Carlson]

As David pointed out in his very first post of the other thread. GnuCash
has removed an existing function without warning.  Some of us use it and
want it back.

On Wed, Jun 2, 2021 at 3:40 PM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 6/2/2021 2:27 PM, D. via gnucash-user wrote:
> > The discussion about the location of Imbalance-XXX accounts is under a
> different thread, and I explained there my reasons for my account structure
> and Gnucash's previous implementation. Suffice to say that I'd rather keep
> Imbalance-USD around (since it will get created all over again), but put it
> in the location of MY choosing.
>
> The "location" of an account is, in effect, part of its name, its full
> name. You could have half a dozen accounts with the "name" Imbalance as
> long as each was a different leaf of the tree (location in the CoA). How
> do you propose gnucash to "know" WHICH of these you intend to be used as
> the account to use for imbalance situations?
>
> What you are asking form in effect, is the ability to specify an account
> to be used for the purpose.
>
> I know you are thinking, just look for a leaf with name Imbalance. That
> could work IF gnucash reserved the name, disallowed you creating an
> account with that name. Account names in gnucash do NOT have to be
> unique/distinct.  Is it the case that in your own books you do not have
> accounts with the same "name" but different leaves of the tree so you
> don't see the problem. The developers put Imbalance at the top level of
> the tree precisely because that would be unique (could only be one).
>
> Michael D Novack
>
>
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

[David Carlson]

Since you bring up the concept of reserved names, perhaps any account name
that Gnucash creates probably should be a reserved name so the entire
argument about creating accounts with the same name should be moot.  Then
the previous behavior of allowing it to be moved would not be an issue.

On Wed, Jun 2, 2021 at 3:56 PM David Carlson 
wrote:

> As David pointed out in his very first post of the other thread. GnuCash
> has removed an existing function without warning.  Some of us use it and
> want it back.
>
> On Wed, Jun 2, 2021 at 3:40 PM Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
>
>> On 6/2/2021 2:27 PM, D. via gnucash-user wrote:
>> > The discussion about the location of Imbalance-XXX accounts is under a
>> different thread, and I explained there my reasons for my account structure
>> and Gnucash's previous implementation. Suffice to say that I'd rather keep
>> Imbalance-USD around (since it will get created all over again), but put it
>> in the location of MY choosing.
>>
>> The "location" of an account is, in effect, part of its name, its full
>> name. You could have half a dozen accounts with the "name" Imbalance as
>> long as each was a different leaf of the tree (location in the CoA). How
>> do you propose gnucash to "know" WHICH of these you intend to be used as
>> the account to use for imbalance situations?
>>
>> What you are asking form in effect, is the ability to specify an account
>> to be used for the purpose.
>>
>> I know you are thinking, just look for a leaf with name Imbalance. That
>> could work IF gnucash reserved the name, disallowed you creating an
>> account with that name. Account names in gnucash do NOT have to be
>> unique/distinct.  Is it the case that in your own books you do not have
>> accounts with the same "name" but different leaves of the tree so you
>> don't see the problem. The developers put Imbalance at the top level of
>> the tree precisely because that would be unique (could only be one).
>>
>> Michael D Novack
>>
>>
>> ___
>> 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.
>>
>
>
> --
> David Carlson
>


-- 
David Carlson
___
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.

Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

[David Carlson]

Stephen,

There have been several posts explaining why it can be desirable to allow
postponement of the completion of a balanced transaction because not all
the details are known but the core of the transaction should not be
postponed into oblivion.

On Wed, Jun 2, 2021 at 4:24 PM Stephen M. Butler <
stephen.m.butle...@gmail.com> wrote:

> On 6/2/21 11:22 AM, D. via gnucash-user wrote:
> > Why delete an account that's only going to get created again?
>
> 1.  So you know when something needs attention.
> 2.  Make you more careful to not let the account be created in the first
> place.
>
> --Steve
> >
> >
> >  Original Message 
> > From: Michael Hendry 
> > Sent: Wed Jun 02 12:25:39 EDT 2021
> > To: Peter West 
> > Cc: GnuCash users group 
> > Subject: Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST
> CURIOUS
> >
> >> On 2 Jun 2021, at 02:44, Peter West  wrote:
> >>
> >> I’m a fairly naive user, but I find the Imbalance-XXX and Orphan-XXX
> accounts (at top level in my CoA) extremely useful, and I understand why
> they are there. If I ever see a balance, I know I have to fix something,
> which is a good reason to have them at the top. I can’t comment on any
> changes that might have occurred in the behaviour of these accounts
> recently. However, in respect of the tidiness of the CoA, one possible
> solution is to create a special case for these accounts, such that they
> only display in the CoA listing when they have a non-zero balance.
> >>
> >> Peter
> >
> > Why not simply delete the Imbalance and Orphan accounts when you’ve
> sorted out the problem and zeroed their contents - they’ll be created
> automatically if required.
> >
> > Michael
> >
> > ___
> > 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.
>
>
> --
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] how to search

[David Carlson]

A small addendum to Derek's comments:

When in the GnuCash program hit F1 to see the help manual.

Also, on the website are links to both the help manual <
https://www.gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=help>l and  the
Tutorial and Concepts Guide <
https://www.gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=guide>

On Thu, Jun 3, 2021 at 7:27 AM Derek Atkins  wrote:

> Hi Billie,
>
> On Thu, June 3, 2021 7:50 am, Billie-Internet wrote:
> > Good Morning,
> > I have been using gnucash since 1/1/2021 and I am frustrated with split
> > transactions and unbalance account.
>
> The Imbalance account gets created when you *enter* an imbalanced
> transaction.  This happens when you, um, hit the *enter* key.  If you're
> creating a split transaction then you should not hit the enter key until
> you are absolutely done will all the splits.
>
> The GnuCash Guide documentation goes through a very detailed, step-by-step
> instruction on how to enter a split transaction.  I highly recommend you
> read the docs.
>
> > Now, I could rip gnucash out of my computer and stomp it to death but I
> > have 6 months worth of data it in.
> > I have spent 2 days trying to search for answers and I am amazed that so
> > many smart people that can write this program can't do a better job of
> > "support"  or finding an answer.
>
> Maybe the issue is not asking the right question?  Even here, in this
> email, you don't actually say WHAT your issue is, so I'm only guessing.
>
> > Could someone please send me a link on how to seach the mail lists.  A
> > link
> > that is understandable to the non-computer-geek-normal-user.
>
> Go to www.google.com and search for:
>
>   site:lists.gnucash.org 
>
> > Better than that, someone share a link on where someone can be hired to
> > just fix the problem!
>
> You don't actually state what your problem is...
>
> > Thanks.
> > Frustrated,--
> > Billie
> > 706-383-9057
>
> Good Luck,
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] how to search

[David Carlson]

In my case, if I let GnuCash OFX import with Bayesian matching do the
matching unsupervised it often applies payments to an incorrect expense
account rather than Imbalance-xxx, but that is mostly with a certain bank
that I do a lot of business with..

On Thu, Jun 3, 2021 at 6:21 PM Greg Feneis  wrote:

> Another source of imbalance is if the user imports downloaded data from
> their FI and the matcher hasn't found a match for the transaction and the
> user accepts all of the new transactions without correcting.
>
>
>
>
>
>
> Kind regards,
>
> Greg Feneis <http://www.linkedin.com/in/electromechanical>
>
>
>
>
> On Thu, Jun 3, 2021 at 6:44 AM Glenn Fowler  wrote:
>
>> To add to this here are the user list archives:
>> https://lists.gnucash.org/pipermail/gnucash-user/
>>
>> Info on searching the archives:
>> https://lists.gnucash.org/search/?idxinfo=gnucash-user
>>
>> On Thu, Jun 3, 2021 at 9:21 AM David Carlson > >
>> wrote:
>>
>> > A small addendum to Derek's comments:
>> >
>> > When in the GnuCash program hit F1 to see the help manual.
>> >
>> > Also, on the website are links to both the help manual <
>> > https://www.gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=help>l and  the
>> > Tutorial and Concepts Guide <
>> > https://www.gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=guide>
>> >
>> > On Thu, Jun 3, 2021 at 7:27 AM Derek Atkins  wrote:
>> >
>> > > Hi Billie,
>> > >
>> > > On Thu, June 3, 2021 7:50 am, Billie-Internet wrote:
>> > > > Good Morning,
>> > > > I have been using gnucash since 1/1/2021 and I am frustrated with
>> split
>> > > > transactions and unbalance account.
>> > >
>> > > The Imbalance account gets created when you *enter* an imbalanced
>> > > transaction.  This happens when you, um, hit the *enter* key.  If
>> you're
>> > > creating a split transaction then you should not hit the enter key
>> until
>> > > you are absolutely done will all the splits.
>> > >
>> > > The GnuCash Guide documentation goes through a very detailed,
>> > step-by-step
>> > > instruction on how to enter a split transaction.  I highly recommend
>> you
>> > > read the docs.
>> > >
>> > > > Now, I could rip gnucash out of my computer and stomp it to death
>> but I
>> > > > have 6 months worth of data it in.
>> > > > I have spent 2 days trying to search for answers and I am amazed
>> that
>> > so
>> > > > many smart people that can write this program can't do a better job
>> of
>> > > > "support"  or finding an answer.
>> > >
>> > > Maybe the issue is not asking the right question?  Even here, in this
>> > > email, you don't actually say WHAT your issue is, so I'm only
>> guessing.
>> > >
>> > > > Could someone please send me a link on how to seach the mail
>> lists.  A
>> > > > link
>> > > > that is understandable to the non-computer-geek-normal-user.
>> > >
>> > > Go to www.google.com and search for:
>> > >
>> > >   site:lists.gnucash.org 
>> > >
>> > > > Better than that, someone share a link on where someone can be
>> hired to
>> > > > just fix the problem!
>> > >
>> > > You don't actually state what your problem is...
>> > >
>> > > > Thanks.
>> > > > Frustrated,--
>> > > > Billie
>> > > > 706-383-9057
>> > >
>> > > Good Luck,
>> > >
>> > > > Please remember to CC this list on all your replies.
>> > > > You can do this by using Reply-To-List or Reply-All.
>> > >
>> > > -derek
>> > >
>> > > --
>> > >Derek Atkins 617-623-3745
>> > >de...@ihtfp.com www.ihtfp.com
>> > >Computer and Internet Security Consultant
>> > >
>> > > ___
>> > > 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
>> > &

Re: [GNC] Reconcile multiple child accounts

[David Carlson]

Reconciliation only works with one currency or security at a time.  As you
discovered, security subaccounts must be reconciled separately.  I have set
up a monthly transaction in my data file to show every active security
account in each brokerage account.  Those serve to point to all the
security accounts that I want to reconcile for that month.


-- 
David Carlson
___
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.

Re: [GNC] How to do property asset and loan when acquired in the past

[David Carlson]

The part about tracking loan payments when trying to create a partially
paid down loan in GnuCash is tricky.  GnuCash only does simple interest
calculations, so many times the best you can do is get an estimated
periodic payment transaction which you will have to correct manually each
month after you know the actual values .

On Tue, Jun 8, 2021 at 6:51 AM flywire  wrote:

> Work through https://gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=guide
>
> It would have been simpler as a tutorial if it was only two accounts deep.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Transaction ordering on num field

[David Carlson]

I would prefer 999a to sort before 1000a and character sorts to be case
insensitive, but I do not depend on that for any purpose.

I do, however, depend on the auto numbering function ignoring strings
containing non-numeric characters as it currently does, so it currently
only increments numbers and still numbers the next check correctly if I use
non-numeric characters in transactions that do not represent checks.

Those are my preferences!

On Tue, Jun 8, 2021 at 1:37 PM John Ralls  wrote:

> Really the effective num field because of the split-action option, but
> anyway...
>
> The submitter of PR#963 complained that sorting on the num field doesn't
> work right if the value is bigger than an int can hold; that's 9 digits.
> His knowledge of C wasn't quite up to the task of fixing it, but I've fixed
> his implementation and have it ready to push for GnuCash 4.6.
>
> So far so good, but it changes the order of transactions when the num
> field isn't all numeric and I want to know if the change will cause trouble
> for anyone.
>
> The current behavior is that a string beginning with a letter will have a
> sort value of 0 and one starting with a number will have a value equal to
> the numbers up to the first non-number character, so for example 12ab34
> will have a sort value of 12, up to ±(10^10 - 1). "abc" and "def" will sort
> equally so the compare would fall through to the next criterion; "abc"
> would sort between "-12ab34" and "12ab34".
>
> The new way is that if both strings are all numbers and there are fewer
> than 19 characters in each then the sort values will be their numeric
> values and the comparison will be numeric, so e.g. 2 sorts before 10. If
> those conditions aren't true then the two values will be string-compared,
> meaning a lexical sort: A very large number beginning with 2 will sort
> before a shorter number beginning with 3; "abc" will sort before "def" but
> after both "123" and "-123" because 1 and - sort before a. That's for an
> English locale; in order to accommodate UTF-8 strings the collation of the
> current locale.
>
> Will that break anyone's carefully-crafted transaction ordering?
>
> Regards,
> John Ralls
>
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Transaction ordering on num field

[David Carlson]

My bank doesn't print leading zeros on my checks

On Thu, Jun 10, 2021 at 9:42 AM w...@theprescotts.com 
wrote:

> For those that care, it is perfectly easy to have numbers sort correctly
> with an alphanumeric sort, simply include the leading zeros.
> If you think your check numbers will never exceed 1000, just number the
> checks: 0001, 0002,... 0100, 0101, etc.If you expect to write more than
> 1000, add another leading 0.
>
> Will
>
> On 2021 Jun 10, at 06-10 01:40:24, flywire  wrote:
>
> How can special customisation to sort a GnuCash field be justified when it
> makes future transitions even more difficult? This field should be sorted
> in
> a standard way. It's clearly the old *numeric* field for sorting cheques,
> and the banks tell us cheques are as good as dead. When it was changed to
> alphanumeric the sort order should have changed too, ie 10 before 2.
>
> I note David's comment on current functionality. Significant changes should
> occur at major versions.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Check printing

[David Carlson]

A few days ago the MICR printer cartridge that I used to use popped up out
of some black hole so I may try printing checks again.   As I recall, tho
it used to be reasonably easy to print test checks on plain paper first,
then just be sure the desired transactions had the word print in the Num
field.  Oh, there was a trick to matching up check numbers which now slips
my mind.

I suppose that is the issue Bruce is wrestling with.



On Thu, Jun 10, 2021, 12:08 PM Bruce Irving  wrote:

> I'm getting to the point that I can rarely read my own handwriting.  So I
> started playing with printing checks from GC bank reisters.
> I am using 'Quicken/QuickBooks (tm) US-Letter 3-part' checks in GC Version
> 4.4 Flatpak under Peppermint 10 (based on Ubuntu 16?? or 18??)
> It works - sometimes.  If I "print" a check, and the printer mis-behaves, I
> can't reprint it!  The other day, I needed to write eight checks to
> different parties, other than the payee, the checks were the same, I could
> only print one of them!  I had to hand write the others.
> Is there any way that I can get a check to reprint?  Or, to print multiple
> nearly identical checks?
> Bruce
> ___
> 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.

Re: [GNC] Check printing

[David Carlson]

I believe there was something more to the printing part of the process
because GnuCash has to be aware of whether there are one, two or three
blank checks in the first sheet.

On Fri, Jun 11, 2021 at 3:04 PM Bruce Irving  wrote:

> That is what I did, Victor.  (It is Ctrl-P on my platform.)  Only the
> first one printed.  Each of the others, when I did Ctrl-P, went through the
> procedure on the screen but it never went to the printer.
> Bruce
>
>
> On Thu, Jun 10, 2021 at 10:55 AM R. Victor Klassen 
> wrote:
>
>> What I would do under your circumstances is fill out all the details in
>> the register for the first one,  duplicate transaction and edit the payee
>> and number fields, and so on until I had them all in the register.  Then
>> command-p on the Mac for each of them.  It might be control-p on your
>> platform I don’t know.  Does that not work?
>>
>> Sent from my iPhone
>>
>> > On Jun 10, 2021, at 12:46 PM, Bruce Irving 
>> wrote:
>> >
>> > I am using preprinted check stock that has the MICR already on it.  I
>> don.t
>> > need to use MICR printing
>> > Bruce
>> >
>> >> On Thu, Jun 10, 2021 at 10:39 AM David Carlson <
>> david.carlson@gmail.com>
>> >> wrote:
>> >>
>> >> A few days ago the MICR printer cartridge that I used to use popped up
>> out
>> >> of some black hole so I may try printing checks again.   As I recall,
>> tho
>> >> it used to be reasonably easy to print test checks on plain paper
>> first,
>> >> then just be sure the desired transactions had the word print in the
>> Num
>> >> field.  Oh, there was a trick to matching up check numbers which now
>> slips
>> >> my mind.
>> >>
>> >> I suppose that is the issue Bruce is wrestling with.
>> >>
>> >>
>> >>
>> >>> On Thu, Jun 10, 2021, 12:08 PM Bruce Irving 
>> wrote:
>> >>>
>> >>> I'm getting to the point that I can rarely read my own handwriting.
>> So I
>> >>> started playing with printing checks from GC bank reisters.
>> >>> I am using 'Quicken/QuickBooks (tm) US-Letter 3-part' checks in GC
>> Version
>> >>> 4.4 Flatpak under Peppermint 10 (based on Ubuntu 16?? or 18??)
>> >>> It works - sometimes.  If I "print" a check, and the printer
>> mis-behaves,
>> >>> I
>> >>> can't reprint it!  The other day, I needed to write eight checks to
>> >>> different parties, other than the payee, the checks were the same, I
>> could
>> >>> only print one of them!  I had to hand write the others.
>> >>> Is there any way that I can get a check to reprint?  Or, to print
>> multiple
>> >>> nearly identical checks?
>> >>> Bruce
>> >>> ___
>> >>> 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.
>>
>

-- 
David Carlson
___
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.

Re: [GNC] Check printing

[David Carlson]

I found the relevant chapter of the help manual.  I presume that you read
this: <https://www.gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=help>

On Fri, Jun 11, 2021 at 7:52 PM David Carlson 
wrote:

> I believe there was something more to the printing part of the process
> because GnuCash has to be aware of whether there are one, two or three
> blank checks in the first sheet.
>
> On Fri, Jun 11, 2021 at 3:04 PM Bruce Irving  wrote:
>
>> That is what I did, Victor.  (It is Ctrl-P on my platform.)  Only the
>> first one printed.  Each of the others, when I did Ctrl-P, went through the
>> procedure on the screen but it never went to the printer.
>> Bruce
>>
>>
>> On Thu, Jun 10, 2021 at 10:55 AM R. Victor Klassen 
>> wrote:
>>
>>> What I would do under your circumstances is fill out all the details in
>>> the register for the first one,  duplicate transaction and edit the payee
>>> and number fields, and so on until I had them all in the register.  Then
>>> command-p on the Mac for each of them.  It might be control-p on your
>>> platform I don’t know.  Does that not work?
>>>
>>> Sent from my iPhone
>>>
>>> > On Jun 10, 2021, at 12:46 PM, Bruce Irving 
>>> wrote:
>>> >
>>> > I am using preprinted check stock that has the MICR already on it.  I
>>> don.t
>>> > need to use MICR printing
>>> > Bruce
>>> >
>>> >> On Thu, Jun 10, 2021 at 10:39 AM David Carlson <
>>> david.carlson@gmail.com>
>>> >> wrote:
>>> >>
>>> >> A few days ago the MICR printer cartridge that I used to use popped
>>> up out
>>> >> of some black hole so I may try printing checks again.   As I recall,
>>> tho
>>> >> it used to be reasonably easy to print test checks on plain paper
>>> first,
>>> >> then just be sure the desired transactions had the word print in the
>>> Num
>>> >> field.  Oh, there was a trick to matching up check numbers which now
>>> slips
>>> >> my mind.
>>> >>
>>> >> I suppose that is the issue Bruce is wrestling with.
>>> >>
>>> >>
>>> >>
>>> >>> On Thu, Jun 10, 2021, 12:08 PM Bruce Irving 
>>> wrote:
>>> >>>
>>> >>> I'm getting to the point that I can rarely read my own handwriting.
>>> So I
>>> >>> started playing with printing checks from GC bank reisters.
>>> >>> I am using 'Quicken/QuickBooks (tm) US-Letter 3-part' checks in GC
>>> Version
>>> >>> 4.4 Flatpak under Peppermint 10 (based on Ubuntu 16?? or 18??)
>>> >>> It works - sometimes.  If I "print" a check, and the printer
>>> mis-behaves,
>>> >>> I
>>> >>> can't reprint it!  The other day, I needed to write eight checks to
>>> >>> different parties, other than the payee, the checks were the same, I
>>> could
>>> >>> only print one of them!  I had to hand write the others.
>>> >>> Is there any way that I can get a check to reprint?  Or, to print
>>> multiple
>>> >>> nearly identical checks?
>>> >>> Bruce
>>> >>> ___
>>> >>> 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.
>>>
>>
>
> --
> David Carlson
>


-- 
David Carlson
___
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.

Re: [GNC] Check printing

[David Carlson]

I thought that link pointed specifically to chapter 6.15 which is the check
printing help.  Sorry, while the rest of the help is interesting, it is not
so relevant.

On Fri, Jun 11, 2021 at 8:10 PM David Carlson 
wrote:

> I found the relevant chapter of the help manual.  I presume that you read
> this: <https://www.gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=help>
>
> On Fri, Jun 11, 2021 at 7:52 PM David Carlson 
> wrote:
>
>> I believe there was something more to the printing part of the process
>> because GnuCash has to be aware of whether there are one, two or three
>> blank checks in the first sheet.
>>
>> On Fri, Jun 11, 2021 at 3:04 PM Bruce Irving 
>> wrote:
>>
>>> That is what I did, Victor.  (It is Ctrl-P on my platform.)  Only the
>>> first one printed.  Each of the others, when I did Ctrl-P, went through the
>>> procedure on the screen but it never went to the printer.
>>> Bruce
>>>
>>>
>>> On Thu, Jun 10, 2021 at 10:55 AM R. Victor Klassen 
>>> wrote:
>>>
>>>> What I would do under your circumstances is fill out all the details in
>>>> the register for the first one,  duplicate transaction and edit the payee
>>>> and number fields, and so on until I had them all in the register.  Then
>>>> command-p on the Mac for each of them.  It might be control-p on your
>>>> platform I don’t know.  Does that not work?
>>>>
>>>> Sent from my iPhone
>>>>
>>>> > On Jun 10, 2021, at 12:46 PM, Bruce Irving 
>>>> wrote:
>>>> >
>>>> > I am using preprinted check stock that has the MICR already on it.
>>>> I don.t
>>>> > need to use MICR printing
>>>> > Bruce
>>>> >
>>>> >> On Thu, Jun 10, 2021 at 10:39 AM David Carlson <
>>>> david.carlson@gmail.com>
>>>> >> wrote:
>>>> >>
>>>> >> A few days ago the MICR printer cartridge that I used to use popped
>>>> up out
>>>> >> of some black hole so I may try printing checks again.   As I
>>>> recall, tho
>>>> >> it used to be reasonably easy to print test checks on plain paper
>>>> first,
>>>> >> then just be sure the desired transactions had the word print in the
>>>> Num
>>>> >> field.  Oh, there was a trick to matching up check numbers which now
>>>> slips
>>>> >> my mind.
>>>> >>
>>>> >> I suppose that is the issue Bruce is wrestling with.
>>>> >>
>>>> >>
>>>> >>
>>>> >>> On Thu, Jun 10, 2021, 12:08 PM Bruce Irving 
>>>> wrote:
>>>> >>>
>>>> >>> I'm getting to the point that I can rarely read my own
>>>> handwriting.  So I
>>>> >>> started playing with printing checks from GC bank reisters.
>>>> >>> I am using 'Quicken/QuickBooks (tm) US-Letter 3-part' checks in GC
>>>> Version
>>>> >>> 4.4 Flatpak under Peppermint 10 (based on Ubuntu 16?? or 18??)
>>>> >>> It works - sometimes.  If I "print" a check, and the printer
>>>> mis-behaves,
>>>> >>> I
>>>> >>> can't reprint it!  The other day, I needed to write eight checks to
>>>> >>> different parties, other than the payee, the checks were the same,
>>>> I could
>>>> >>> only print one of them!  I had to hand write the others.
>>>> >>> Is there any way that I can get a check to reprint?  Or, to print
>>>> multiple
>>>> >>> nearly identical checks?
>>>> >>> Bruce
>>>> >>> _______
>>>> >>> 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.
>>>>
>>>
>>
>> --
>> David Carlson
>>
>
>
> --
> David Carlson
>


-- 
David Carlson
___
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.

Re: [GNC] GnuCash very slow to start up and quit

[David Carlson]

Speed depends on not only the factors that you have identified, but other
factors as well.  I have an instance of release 3.8 running in a Linux Lite
environment within a  Virtualbox on a laptop.  Of course this hardware has
its limits too.

I happen to normally store my compressed XML datafile on a Network Attached
Storage device connected via Ethernet in (probably unencrypted) SMB
protocol, which I thought was a speedy connection.  However, I recently set
up an alternate arrangement on a locally attached USB 3.0 memory stick and
found that file saves in particular sped up from around 30 seconds to
around 2 or 3 seconds.  This is anecdotal information as I currently am not
in a position to perform a controlled experiment.  I suspect that there
must be a kink in the Ethernet possibly limiting it to 1 MHz or 10 MHZ.
instead of the 100 MHz I expect on my rather dated network.  I do know that
the network saves take roughly the same amount of time when Wi-Fi is used
as the transmission medium, but there is still one ethernet cable between
the router and the NAS.  That connection could be 1 Gigahertz if the cable
is good enough.  I will be checking that when I get a chance in a week or
two.

On Sun, Jun 13, 2021 at 5:11 AM Tim Hume  wrote:

> On Sunday, June 13th, 2021 at 18:28, Saša Janiška 
> wrote:
>
> > Just wonder how does SQLite back-end compare with XML and whether you
> > recommend one over the other? (my XML is 20MB uncompressed and under
> > VCS).
>
> I just ran a test. My data file is 37 MByte in SQLite format, and 52 MByte
> when in XML and uncompressed. However, the compressed XML is under 4 MByte.
>
> It took 1m 17s to open GnuCash with the compressed XML file, and 55s with
> the SQLite file. I'd recommend the SQLite format based on these tests.
>
> My CPU is currently an i5 6300U. I was looking at a small PC with a Ryzen
> 7 4700U CPU. Given GnuCash runs on a single thread, I suspect speedup in
> loading the data will be about 1.5 times given it seems to be CPU bound.
> I'm not sure if I'm going to upgrade. The advantage of my current setup is
> that it's on a laptop, so if the power goes out (which it does frequently
> enough) I don't lose everything. Mind you, I wouldn't mind the extra speed.
> Once GnuCash is loaded, it's fast enough to do the tasks I want it to do,
> so I normally just keep it open.
>
> Cheers,
>
> Tim
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Incorrect Trial Balance Amounts

[David Carlson]

It would be nice if that method were described accurately in the
documentation, because going by the name it sounds like something
completely different and wrong if it  is using incorrectly estimated prices
instead of actual transaction prices.  I would make the same mistake if I
were doing what volker was doing.

On Tue, Jun 15, 2021 at 1:02 AM Volker Englisch  wrote:

> Thank you for the explanation, John!  I did have the price source for
> the report set to "Nearest in time".  After setting the source to
> "Average Cost" the numbers came out as expected.
>
> Regarding your question about the proper recording of the capital gains,
> I'm still going through the documentation to set up the accounts as
> listed. My initial problem was that the numbers didn't add up even
> before I sold anything.
>
> --
> Volker Englisch
> phone: (240) 343-5343 (mobil)
> mailto:vol...@englisch.us
>
> On 6/14/21 12:06 PM, John Ralls wrote:
> >> On Jun 13, 2021, at 5:39 PM, Volker Englisch 
> wrote:
> >>
> >> Hi there,
> >>
> >> I would like to check if I'm doing something wrong or if I'm correct in
> my assumption that the Trial Balance report isn't displaying correct
> amounts in all cases.
> >>
> >> I'm using Ubuntu 20.04.2 LTS with GnuCash 3.8.
> >>
> >> I started keeping track of some stock and entered the number of shares
> on Jan. 1, 2021, for example.  Let's say I have 100 shares worth $2 each.
> >> Asset:Investment:MyStock200 (for 100 shares at $2)
> >> Equity:Opening Balance200
> >>
> >> After a while (April 1st) I sell all shares and enter the corresponding
> transaction.  The price for the shares increased to $3 since I started
> tracking (I wish!):
> >>  Asset:Current Asset:Checking Account300
> >>  Asset:Investment:MyStock 300 (for 100 shares, $100
> realized gains)
> >>
> >> When I run the trial balance report for the day I first entered MyStock
> everything looks good: $200 debit / $200 credit.  The same is true for the
> day I sold MyStock: $300 debit / $200 credit, the difference is my gain.
> However, when I run the trial balance for 03/01 for instance, the trial
> balance shows $300 debit / $300 credit with $100 listed as unrealized gains.
> >>
> >> What seems to be happening is that the TB calculates the value of the
> stock based on the last price entered in the price editor rather than using
> the last price prior to the date for which the TB is run.  With two entries
> in the price editor DB, one for 01/01 and one for 04/01 I would expect the
> price for 01/01 to be used until 03/31.
> >>
> >> Am I doing something wrong?  It's possible I'm not understanding
> precisely how the TB is coming up with the numbers.
> >>
> >> Thank you!
> > Did you record an income split for the capital gain? You mention the
> gain but I don't see the split for it in your example transaction. See
> https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_capgain.html for
> details about how to record capital gains/losses and why you should do so.
> >
> > As for price, the default in the Trial Balance Report is Average Cost
> (which isn't really, but the algorithm behind it is tailored specifically
> for the Trial Balance Report). That looks at the actual amounts and values
> in the splits; the Nearest in Time and Latest Price price sources consult
> the pricedb and won't balance, so don't use them.
> >
> > Regards,
> > John Ralls
> >
> _______
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Reconciliation screw-up

[David Carlson]

Jeff,

If both accounts A and C are bank accounts and you are satisfied with the
same transaction appearing in both accounts, perhaps with differing split
memos, just select one of the two to edit to that result.

When you delete the other transaction and the edited transaction appears in
that account, you can re-reconcile that account by changing the reconcile
date to repeat the last reconciliation and pick up the newly created entry.

I am not sure if that will unreconcile the retained but edited transaction
but if it does, you can also re-reconcile that account.

If you want different numbers or descriptions on the two transactions you
will have to edit both of them to transfer to a different (suspense)
account to keep them both as separate transactions.

I personally use both  methods depending on the details that I want to show
on the transactions.

On Wed, Jun 16, 2021 at 11:10 PM Jeff  wrote:

> I may confuse myself even more here, so would appreciate some patience
> and guidance.
>
> I was given bank statements for 2 accounts (A and C).  Unbeknownst to me
> there was a transaction that was supposed to go from account A to C (A
> $1 -> C $1).  When the entries were made, the transactions were entered as
>
> A $1 -> B $1
>
> and
>
> C $1 -> D $1
>
> Accounts B and D never get reconciled.  Accounts A and C do, and are
> now.  What would be the simplest way to correct this error?
>
> I am using GNC 4.2 on Ubuntu 20.04.  Data-file is uncompressed XML.
>
> --
> --JEffrey Black M.B.A.
>
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Transactions imported from the file assigned to wrong account

[David Carlson]

And what version of GnuCash are you running?  Newer releases have an easier
way to fix the problem.

On Mon, Jun 21, 2021 at 3:29 PM Aleksandar Kocic  wrote:

> It is QFX.
>
> On Mon, Jun 21, 2021 at 4:21 PM Derek Atkins  wrote:
>
> > Hi,
> >
> > Are you downloading QIF?  OFX?  CSV?  Something else?
> >
> > -derek
> >
> > On Mon, June 21, 2021 4:17 pm, Aleksandar Kocic wrote:
> > > I download the file from the bank's site and manually import it.
> > >
> > > I can see the account number in the file. However, for whatever reason,
> > > the
> > > application chooses another account and it seems that cannot be
> changed.
> > >
> > >
> > > On Mon., Jun. 21, 2021, 3:55 p.m. John Ralls, 
> > wrote:
> > >
> > >>
> > >>
> > >> > On Jun 21, 2021, at 12:08 PM, Aleksandar Kocic 
> > >> wrote:
> > >> >
> > >> > Hi there,
> > >> >
> > >> > I am trying to import transactions downloaded from the bank.
> However,
> > >> since
> > >> > I have multiple accounts with the same institution, the transactions
> > >> are
> > >> > assigned to an already existing account.
> > >> >
> > >> > How do I select the account I want to use for importing
> transactions?
> > >>
> > >> How are you doing the import and doesn't the bank include the bank
> > >> account
> > >> number?
> > >>
> > >> Regards,
> > >> John Ralls
> > >>
> > >>
> > > ___
> > > 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.
> > >
> >
> >
> > --
> >Derek Atkins 617-623-3745
> >de...@ihtfp.com www.ihtfp.com
> >Computer and Internet Security Consultant
> >
> >
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Transactions imported from the file assigned to wrong account

[David Carlson]

According to
https://lists.gnucash.org/pipermail/gnucash-user/2018-April/076671.html for
releases 3.0 onward you can open the Tools> Import Map Editor search the
Online ID list for the incorrect match and delete it.  On the next import
GnuCash will ask for the correct match.

On Mon, Jun 21, 2021 at 5:01 PM Aleksandar Kocic  wrote:

> Updated to the latest version, same issue:
> Version: 4.5
> Build ID: 4.5+(2021-03-27)
>
> On Mon, Jun 21, 2021 at 4:55 PM Aleksandar Kocic 
> wrote:
>
>> Version: 4.4
>> Build ID: 4.4+(2020-12-28)
>>
>> Just to clarify that the files do have the account numbers and they are
>> different. Here is an obfuscated example:
>>
>> CADXXXCREDITLINE
>>
>> CADYYYCREDITLINE
>>
>>
>>
>> On Mon, Jun 21, 2021 at 4:50 PM David Carlson <
>> david.carlson@gmail.com> wrote:
>>
>>> And what version of GnuCash are you running?  Newer releases have an
>>> easier way to fix the problem.
>>>
>>> On Mon, Jun 21, 2021 at 3:29 PM Aleksandar Kocic 
>>> wrote:
>>>
>>>> It is QFX.
>>>>
>>>> On Mon, Jun 21, 2021 at 4:21 PM Derek Atkins  wrote:
>>>>
>>>> > Hi,
>>>> >
>>>> > Are you downloading QIF?  OFX?  CSV?  Something else?
>>>> >
>>>> > -derek
>>>> >
>>>> > On Mon, June 21, 2021 4:17 pm, Aleksandar Kocic wrote:
>>>> > > I download the file from the bank's site and manually import it.
>>>> > >
>>>> > > I can see the account number in the file. However, for whatever
>>>> reason,
>>>> > > the
>>>> > > application chooses another account and it seems that cannot be
>>>> changed.
>>>> > >
>>>> > >
>>>> > > On Mon., Jun. 21, 2021, 3:55 p.m. John Ralls, 
>>>> > wrote:
>>>> > >
>>>> > >>
>>>> > >>
>>>> > >> > On Jun 21, 2021, at 12:08 PM, Aleksandar Kocic <
>>>> akoci...@gmail.com>
>>>> > >> wrote:
>>>> > >> >
>>>> > >> > Hi there,
>>>> > >> >
>>>> > >> > I am trying to import transactions downloaded from the bank.
>>>> However,
>>>> > >> since
>>>> > >> > I have multiple accounts with the same institution, the
>>>> transactions
>>>> > >> are
>>>> > >> > assigned to an already existing account.
>>>> > >> >
>>>> > >> > How do I select the account I want to use for importing
>>>> transactions?
>>>> > >>
>>>> > >> How are you doing the import and doesn't the bank include the bank
>>>> > >> account
>>>> > >> number?
>>>> > >>
>>>> > >> Regards,
>>>> > >> John Ralls
>>>> > >>
>>>> > >>
>>>> > > ___
>>>> > > 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.
>>>> > >
>>>> >
>>>> >
>>>> > --
>>>> >Derek Atkins 617-623-3745
>>>> >de...@ihtfp.com www.ihtfp.com
>>>> >Computer and Internet Security Consultant
>>>> >
>>>> >
>>>> ___
>>>> 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.
>>>>
>>>
>>>
>>> --
>>> David Carlson
>>>
>>

-- 
David Carlson
___
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.

Re: [GNC] Transaction report export file type

[David Carlson]

I have not tested this, but sometimes one can either open a pdf file with a
spreadsheet application or copy a PDF file and paste it into a new
spreadsheet.  Once that is done it is often relatively easy to clean up
stray cells and save in CSV format.

On Thu, Jun 24, 2021 at 4:32 PM Rich Shepard 
wrote:

> Is there a way to export a transaction report as a .csv or .txt file? I
> looked at all options and didn't see any place to select the export format.
> When I did export the file it defaulted to .html; that would take a lot of
> cleaning and it would be nice to export to .csv or .txt.
>
> Any thoughts?
>
> Rich
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Transaction report not seeing selected account

[David Carlson]

If you want to repeat a report later with the same or similar settings you
need to memorize it with a name that makes sense to you.

On Sun, Jun 27, 2021, 10:35 AM Rich Shepard 
wrote:

> For some reason I need to learn a transaction report fails telling me it
> needs an account name. I've selected the single account for which I want to
> see all transactions to a payee. The failure report shows the account (see
> attached) and I don't know what's missing or what I did incorrectly.
>
> A clue stick will be helpful.
>
> Regards,
>
> Rich
> ___
> 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.

Re: [GNC] GNU cash - Introduction

[David Carlson]

So the bottom line is that you have an income that must be assigned to an
income account in GnuCash and a cash deposit initially into your cash
drawer then into your bank thus it is assigned to the bank account in
GnuCash.  That is a complete 'double entry' transaction.

On Sat, Jul 3, 2021 at 7:39 AM Fred Bone via gnucash-user <
gnucash-user@gnucash.org> wrote:

> On 02 July 2021 at 20:10, 3JS Airconandtechservices said:
>
> > Hi there,
> >
> > Can someone please help me, our  problem is whenever i add an income (not
> > only income but also all other sales like acount) transaction , it
> > willautomatically duplicate this particular transaction but the amount is
> > now tranferred to "Charge" resulting to zero balance. see sample
> > screenshot below : [image: image.png]
>
> You need to tell Gnucash where the income is going to. You have it going
> to the same place it is coming from, which is why the two sides of the
> transaction show up in the same account.
>
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] gnucash version 4.6 precission issue in price

[David Carlson]

In the  price database the precision is individually set for each currency
or commodity.  That is defined in the securities database using the
Security editor, normally when you initially define the currency or
security, tho you can change it later.  If you are at the stage of entering
a transaction where you need a price to complete the transaction, it is
usually easiest to enter the number of shares and total value and let
GnuCash calculate the price.

On Sat, Jul 3, 2021 at 2:19 PM  wrote:

> hi,
>
> in the price database tool, I am trying to set a price of 1.0079 but it
> "corrects" me to 1.01
> a value of 1.0001 becomes 1
>
> I tried to change the preferences -> numbers -> decimal point to 4/5/6
> places, and also remove the "force prices to display as decimals"
> but it didn't work
>
> What am I missing? Is there a bug?
>
> BR,
> Shay
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] gnucash version 4.6 precission issue in price

[David Carlson]

Just noted in another thread.  See
https://bugs.gnucash.org/show_bug.cgi?id=798219


On Sat, Jul 3, 2021, 4:41 PM D  wrote:

> I seem to recall a bug about this in recent days, but cannot locate it
> now.
> On Jul 3, 2021, at 16:12, s310...@gmail.com wrote:
>>
>> hi David,
>>
>> thanks for the reply,
>>
>> I tried to change the precision as you noted. but it didn't help
>>
>> some more info:
>> I am not using the online quotes option. I enter the prices manually every
>> weekend.
>> The issue started with version 4.6. in version 4.5 I didn't experience any
>> issue and it is the same gnucash file (no new stocks/bonds have been added
>> for a while now).
>> As a matter of fact, I have reinstalled version 4.5 and it works fine
>> with 4.5.
>>
>> BR,
>> Shay
>>
>>
>>
>> On Sat, Jul 3, 2021 at 10:37 PM David Carlson 
>> wrote:
>>
>>  In the  price database the precision is individually set for each currency
>>>  or commodity.  That is defined in the securities database using the
>>>  Security editor, normally when you initially define the currency or
>>>  security, tho you can change it later.  If you are at the stage of entering
>>>  a transaction where you need a price to complete the transaction, it is
>>>  usually easiest to enter the number of shares and total value and let
>>>  GnuCash calculate the price.
>>>
>>>  On Sat, Jul 3, 2021 at 2:19 PM  wrote:
>>>
>>>  hi,
>>>>
>>>>  in the price database tool, I am trying to set a price of 1.0079 but it
>>>>  "corrects" me to 1.01
>>>>  a value of 1.0001 becomes 1
>>>>
>>>>  I tried to change the preferences -> numbers -> decimal point to 4/5/6
>>>>  places, and also remove the "force prices to display as decimals"
>>>>  but it didn't work
>>>>
>>>>  What am I missing? Is there a bug?
>>>>
>>>>  BR,
>>>>  Shay
>>>> --
>>>>
>>>>  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.
>>>
>>>
>>>
>>>
>>>  --
>>>  David Carlson
>>
>>
>> --
>>
>> 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.

[GNC] OFX Imports to new account reversed

[David Carlson]

I have been using GnuCash for years with OFX imports correctly populating
bank and credit card accounts with deposits and withdrawals.

Today, using release 3.8 I set up a new credit card account, went online,
downloaded an OFX transaction file and proceeded to import it into
GnuCash.

Surprise, purchases were entered as payments.  I checked the raw OFX file
and it appears to be correct.  The account type is Credit Card under a
Liability top account.

What else can cause this?

-- 
David Carlson
___
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.

Re: [GNC] Accounting for GST in Australia

[David Carlson]

Even worse, sometimes local sales taxes in the 🇺🇸 depend on where the
buyer lives, not where the seller does business.



On Wed, Jul 7, 2021, 10:34 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 7/7/2021 7:41 AM, flywire wrote:
> > GST is only really supported if it's auto-calculated otherwise a user has
> > to enter twice the splits with the associated logic and keying errors.
> I've
> > only been using the Account Register for data entry.
>
> But GST in Australia appears to be a simple problem compared to "sales
> tax" here. Which not only varies by state (with respect to rate) but on
> what is or is not subject to the sales tax.
>
> This may be too much to expect from an ACCOUNTING system like gnucash if
> we expect automation. Usually this sort of thing is handled by what is
> called a POS system (point of sales) which builds the invoice of sales
> receipt << it will have the total sales tax attributed to this sale
> figured by adding up the sales tax on each item since whether taxable or
> at what rate depends on the item >> Such systems also need to make
> provision of "no tax" sales where the buyer has a certificate of
> exemption on file with the vendor.
>
> Typically a POS system is paired with an accounting system. The latter
> has only to be able to accept the transaction as created by the POS, not
> figure it out.
>
> Michael D Novack
>
>
> ___
> 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.

Re: [GNC] Accounting for GST in Australia

[David Carlson]

Yep.  Lake County Illinois just added 4 cents per gallon tax on gasoline  ⛽
sales.  You can bet good money that most locals are planning their
purchases to occur in Wisconsin when possible.

On Wed, Jul 7, 2021, 10:57 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 7/7/2021 11:46 AM, David Carlson wrote:
> > Even worse, sometimes local sales taxes in the 🇺🇸 depend on where
> > the buyer lives, not where the seller does business.
>
> That is almost always true, and to make this even worse, JUST the
> buyer's postal address might not be a correct indication of the state.
> Postal zip codes do NOT respect state boundaries. If that seems odd to
> you, imagine the situation where a road is the boundary between two
> states or crosses back and forth across the boundary. Do you imagine the
> post office sends two postal trucks, one to deliver to one side of the
> road and the other for the other side, or one to deliver to the
> stretches of road in one state and another for the stretches in the
> other state.
>
> How many of us have customer databases that in addition to customer
> address, store the state where this actually is as opposed to just going
> by the state that the post office is in (for that zip code)
>
> Michael D Novack
>
>
___
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.

Re: [GNC] how to import a csv of transactions?

[David Carlson]

Arman,

While CSV transaction imports are definitely supported in GnuCash, there
have been some bugs reported with the 'new' CSV importer.  There used to be
a fatal bug with the 'old' CSV importer that caused GnuCash to crash if the
incorrect date format was selected, and it may still be possible to see
that crash if you choose the wrong date format.  That is the reason that
there is a new process to save import settings including the base account
selection.  It is critical to do that import setup and save very carefully.

Additionally, when getting familiar with the import process it is very
possible to get results that you do not like so you can expect to fine tune
settings until you like the results.  With some financial institutions you
may even want to preprocess the CSV file before importing it.  Thus, start
with a disposable copy of your data file and work with small import files.
This especially includes the process of training the import matcher in the
final step of the import.  At that stage, when you can describe in detail
what you want to do, users here will step up to help.

Good luck.

On Mon, Jul 12, 2021 at 7:40 AM Geoff  wrote:

> Hi Arman
>
> Yes, this *definitely* works with v4.4 on Windows.  I haven't tried v4.6
> yet, but I'd be surprised if it was broken.
>
> See the fifth post in this thread which includes screenshots and a
> sample CSV file:
>
>
> http://gnucash.1415818.n4.nabble.com/GNC-Tracking-cash-flows-with-balanced-transactions-td4721056.html
>
> Good luck!
>
> Geoff
> =
>
> On 12/07/2021 10:01 pm, Arman Schwarz wrote:
> > I've tried on both 4.4 and 4.6 but it seems that importing csv
> transactions
> > is broken. Before I continue down this path, is csv importing an actually
> > supported feature or are the issues with it known? Normally I'd put more
> > effort into repro steps but I think it's so broken the devs hopefully
> > already know about it. Errors I encountered:
> >
> > - Anything more than 200 transactions results in a fatal exception when
> > selecting "GnuCash export format"
> > - Account name is ignored, meaning you have to manually link every
> account.
> >
> > I'm on windows.
> >
> > Are there any working alternatives for getting transactions out of one
> > gnucash file and into another?
> >
> > Sorry again for the lack of detail.
> >
> > Arman
> > ___
> > 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Adding new income category or new expenses category

[David Carlson]

Welcome to GnuCash and this user mail list.

If you simply accepted the default account list when you created your first
data file you may want to start over , possibly first choosing business
accounts with the New Account Hierarchy assistant before you import your
first bank statement.   Read the account setup section of the Tutorial to
help with making that decision.

Also read whatever suggestions others make here.  I don't personally use
any of the business features,  so others may have better suggestions than
mine.



On Thu, Jul 15, 2021, 1:34 PM Barry G. Hall  wrote:

> I am a new GnuCash user.  I successfully set up an account and imported my
> business bank account statement.
>
> In the list of transactions I was able to assign an income or expense
> category to each transaction, however there is no expense category for
> “advertising”, “consulting”, “internet” or equipment purchase. For my
> internet expenses I just used Subscriptions.
>
> Similarly, there is no income category for “sales”, so I used “Bonus”.
>
> It it possible to add new categories?  If so, how might I accomplish that?
>
> Thanks for your help.
>
> Barry G. Hall
> Director, Bellingham Research Institute
> ba...@bellinghamresearch.com
> http://www.bellinghamresearch.com 
>
>
>
>
> ___
> 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.

Re: [GNC] Stopping auto transfer

[David Carlson]

The QFX importer gives you a chance to edit each transaction individually,
'training' it to select the desired account and whether to accept the
cleared date at teh bank or choose a different date, or, importantly, to
discard mis-matches to existing transactions.  While the process is tedious
at first, after several months there are fewer mis-matches, depending on
how your bank formats the descriptions.  GnuCash only learns what you train
it during the import process.

There are a few settings under Edit > Preferences > Online Banking that
fine-tunes the import process, but I have not tried to adjust them myself.

On Thu, Jul 22, 2021 at 11:41 PM Niranjan Rao  wrote:

> Greetings,
>
>
> On Ubuntu 20.04, GunCash V3.8
>
>
> When I import QFX files downloaded from my financial institutions,
> gnucash often miscategorizes the transfer. For example, typically when I
> import my bank transactions, any payment is imported as transfer to my
> credit card. Any credit card transaction imports result into most of the
> transactions as transfers to bank.
>
> This of course creates lot of confusion as when I try to reconcile the
> accounts.
>
>
> Is there any way to stop automatic transfer. I'm ok if it shows transfer
> to imbalance usd as it gives me a chance to review the transaction.
>
>
> Regards,
>
>
> Niranjan
>
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Scheduled transaction with variable amount

[David Carlson]

Gyle,

I believe you cannot create a transaction with a variable automatically
created, i.e. do not check the second box in the editor screen.  Then it
will ask for a value when you run the since last run assistant.

On Tue, Jul 27, 2021 at 7:18 PM Gyle McCollam  wrote:

> Derek, this is something I was looking for, however when I tried to put
> "total" in the debit and credit formula it wouldn't allow the "s.  So I
> tried with the quotes and it wouldn't save the scheduled transaction.  See
> the attach screen shot.  Can you tell me what I did wrong?
>
> [cid:b223ae00-6131-45ea-a805-a1b590e0d7dc]
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>
> 
> From: gnucash-user  on
> behalf of Derek Atkins 
> Sent: Tuesday, July 27, 2021 4:37 PM
> To: Aleksandar Kocic 
> Cc: Gnucash Users 
> Subject: Re: [GNC] Scheduled transaction with variable amount
>
> Hi,
>
> On Tue, July 27, 2021 4:24 pm, Aleksandar Kocic wrote:
> > Hi there,
> >
> > I wonder if it would be possible to schedule a transaction with a
> variable
> > amount. For example, if I want to schedule a credit card payment, I need
> > to
> > provide a fixed amount per transaction although we know that these
> > amounts vary month to month. Instead, it would be nice to have a way to
> > set
> > a transaction that would just pay the balance every month.
>
> Yes, just put a variable (string) in the debit/credit formula.  Eg,
> "total".  When the SX fires, it will ask you for the actual amount to put
> in.
>
> Enjoy.
>
> >
> > Please advise.
> >
> > Regards,
> > Aleksandar
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com<http://www.ihtfp.com>
>Computer and Internet Security Consultant
>
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Difficulties entering share purchases

[David Carlson]

So far there has been no useful information presented in this thread, at
least that I can find now that I am looking at it with Gmail on my laptop
.  While I am not a developer, I have been working closely with them on a
couple of possibly related problems.  Clearly there is a problem which
needs to be documented in a fresh bug report.

It appears that Eric Coats' problem as he originally presented it relates
mostly to changes that GnuCash made in some releases in the 3.x and 4.x
series in the behavior of the logic surrounding the process of balancing
the exchange rates applied when transactions are created with multiple
currencies and/or securities. There is a lot of interaction that may or may
not be consistently applied if the transaction creation is done manually,
by cloning a previous transaction or by the Since Last Run assistant, and
possibly other nuances as well.  This was complicated by a clarification of
the actual action that happens when the "Nearest in Time" method is
selected vs when the new "Nearest Before" method is selected as described
in https://bugs.gnucash.org/show_bug.cgi?id=743753.  Release 4.6 also
contained a fix<https://bugs.gnucash.org/show_bug.cgi?id=797928> that was
supposed to resolve problems with the  Since Last Run assistant that may
have impacted this in an unforeseen way.

It may be necessary for Eric to provide a very detailed description of
which version of GnuCash he is actually using including whether if is a
flatpak version or user compiled, then keystroke-by-keystroke to get the
inconsistent result.  Then, if it is possible to resolve them as a
work-around for the current release by adjusting exchange rates, for
example, we should get a handle on the problem.

The share/price/value relationship is a separate issue which is a little
awkward but not known to be broken and probably does not apply to Eric's
problem.

-- 
David Carlson
___
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.

Re: [GNC] Scheduled transaction with variable amount

[David Carlson]

Gyle,

It looks like there are some spurious characters somewhere in your data.
Do you see problems in any other windows such as import windows, the chart
of accounts or other places?

On Wed, Jul 28, 2021 at 9:30 AM Gyle McCollam  wrote:

> Speaking of reconciliation, I have a problem with deposits not showing on
> one of my accounts and I don't know why this is happening (see below).  I
> didn't include the right side, which is fine, because it shows other banks
> and credit accounts.  Even if I maximize the page it doesn't change.
> [cid:4011b06e-5772-49ff-b374-e249e2baaa78]
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>
> 
> From: D. 
> Sent: Wednesday, July 28, 2021 8:17 AM
> To: Aleksandar Kocic 
> Cc: David Carlson ; Gyle McCollam <
> gmccol...@live.com>; gnucash-user@gnucash.org ;
> Derek Atkins 
> Subject: Re: [GNC] Scheduled transaction with variable amount
>
> Creating a transaction for a total amount as of a certain date doesn't
> seem particularly useful. What if you have a dispute, or a return, or a
> transaction that is not accurate, or needs correction? An
> automatically-created transaction will need to be corrected as well.
>
> Gnucash provides an option during the final step of the reconcile process
> to create a payment in the total statement amount. From an accounting
> perspective, this is the best point to create this payment. You have just
> established that your books and theirs match, and the amount due is
> confirmed.
>
> If you're not seeing this dialog during the reconcile process, you have
> turned the feature off for that account, but it can be reset. Just don't
> ask me how...
>
> David T.
> 
> From: Aleksandar Kocic
> Sent: Tue Jul 27 21:51:04 EDT 2021
> To: David Carlson
> Cc: Gyle McCollam , "gnucash-user@gnucash.org" , Derek Atkins
> Subject: Re: [GNC] Scheduled transaction with variable amount
>
>
> Thanks,
>
> While there is a way to not enter the amount, it is not an automated
> process, and, in a sense, it is not different from putting a random value
> and changing it later. Also, if a transaction can't be created
> automatically, it means it will be even more manual steps to get it done.
>
> What I was looking for is a scheduler checking the account balance and
> setting the value automatically.
>
> Maybe one day.
>
> Regards,
> Aleksandar
>
> On Tue, Jul 27, 2021 at 8:43 PM David Carlson  >
> wrote:
>
>  Gyle,
>
>  I believe you cannot create a transaction with a variable automatically
>  created, i.e. do not check the second box in the editor screen.  Then it
>  will ask for a value when you run the since last run assistant.
>
>  On Tue, Jul 27, 2021 at 7:18 PM Gyle McCollam  wrote:
>
>  Derek, this is something I was looking for, however when I tried to put
>  "total" in the debit and credit formula it wouldn't allow the "s.  So I
>  tried with the quotes and it wouldn't save the scheduled transaction.
>  See
>  the attach screen shot.  Can you tell me what I did wrong?
>
>  [cid:b223ae00-6131-45ea-a805-a1b590e0d7dc]
>
>  Thank You,
>
>  Gyle McCollam
>
>  Gyle McCollam
>
>  609.680.2326 Mobile
>
>  gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>
> 
>
>  From: gnucash-user  http://gmail.com>@gnucash.org>
>  on
>  behalf of Derek Atkins 
>  Sent: Tuesday, July 27, 2021 4:37 PM
>  To: Aleksandar Kocic 
>  Cc: Gnucash Users 
>  Subject: Re: [GNC] Scheduled transaction with variable amount
>
>  Hi,
>
>  On Tue, July 27, 2021 4:24 pm, Aleksandar Kocic wrote:
>  Hi there,
>
>  I wonder if it would be possible to schedule a transaction with a
>  variable
>  amount. For example, if I want to schedule a credit card payment, I
>  need
>  to
>  provide a fixed amount per transaction although we know that these
>  amounts vary month to month. Instead, it would be nice to have a way to
>  set
>  a transaction that would just pay the balance every month.
>
>  Yes, just put a variable (string) in the debit/credit formula.  Eg,
>  "total".  When the SX fires, it will ask you for the actual amount to put
>  in.
>
>  Enjoy.
>
>
>  Please advise.
>
>  Regards,
>  Aleksandar
>
>  Please remember to CC this list on all your replies.
>  You can do this by using Reply-To-List or Reply-All.
>
>  -derek
>
>  --
>

Re: [GNC] No Suitable Backend Found

[David Carlson]

Adam,
the data files with the .gnucash suffix are a special form of text file
that can be read with your regular text editors such as wordpad, notepad or
an office editor like MSWord or LibreOffice.  GnuCash normally compresses
these files by default, so you may need to uncompress the files with your
favorite file compression program.

As Derek mentioned, recovered files must be on a different physical medium
than your unrecovered files.  You are running your OS and GnuCash from a
fresh copy on a different physical drive as well, I hope.

If any of those editor programs can display clear text and it looks like
transaction data rather than other information like window dimensions or
report settings  then you probably have  recovered your data.

On Wed, Jul 28, 2021 at 11:04 AM Derek Atkins  wrote:

> Hi,
>
> On Wed, July 28, 2021 11:57 am, Adam Hodnett wrote:
> > Maybe it is a metadata file... I do have many of the
> > .MMDDHHMMSS.gnucash files in the same directory as the
> > .gnucash file. They all give the same error. There are also
> .txt
> > files with the same names.
> >
> > I recovered the data with EaseUS Data Recovery. I am attempting to
> recover
> > the same data with a different program at the moment, in case that's the
> > issue.
>
> It is sounding like the recovery did not succeed.  If the backup failed to
> recover even a single block of data it will cause the decompression to
> fail.  Windows doesn't really have all the best tools to debug these kinds
> of issues.
>
> > .gnucash files are all between 70kb and about 140kb.
>
> Assuming you mean KB (KiloBytes) and not kb (kilobits), those files are
> probably about the correct size if you don't have a ton of transactions.
> My 15-year-old data file is 2.8 MB.
>
> Note:  Backups only work if you copy the data to another storage system
> off your main system.
>
> > Adam Hodnett
> > Videographer | Project Coordinator
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Scheduled transaction with variable amount

[David Carlson]

Gyle,

Whatever the problem is, it seems to be only with that one account.  Have
you tried Actions > Check and Repair > All Transactions while viewing that
account register?

On Wed, Jul 28, 2021 at 11:44 AM Gyle McCollam  wrote:

> I found that is the problem.  When I maximize the reconciliation window I
> see the scroll bar.  When I scroll all the way to the right I see the other
> columns.  However, it will let me make the 2nd column bigger, but it will
> not let me make it smaller.  I can adjust the other columns either smaller
> or larger, just not that second column.
>
> Thank You,
> *Gyle McCollam*
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.comemail
> ------
> *From:* David Carlson 
> *Sent:* Wednesday, July 28, 2021 11:32 AM
> *To:* Gyle McCollam 
> *Cc:* D. ; bugs-ad...@bugs.gnucash.org <
> bugs-ad...@bugs.gnucash.org>; gnucash-user@gnucash.org <
> gnucash-user@gnucash.org>
> *Subject:* Re: [GNC] Scheduled transaction with variable amount
>
> Gyle,
>
> It looks like there are some spurious characters somewhere in your data.
> Do you see problems in any other windows such as import windows, the chart
> of accounts or other places?
>
> On Wed, Jul 28, 2021 at 9:30 AM Gyle McCollam  wrote:
>
> Speaking of reconciliation, I have a problem with deposits not showing on
> one of my accounts and I don't know why this is happening (see below).  I
> didn't include the right side, which is fine, because it shows other banks
> and credit accounts.  Even if I maximize the page it doesn't change.
> [cid:4011b06e-5772-49ff-b374-e249e2baaa78]
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>
> 
> From: D. 
> Sent: Wednesday, July 28, 2021 8:17 AM
> To: Aleksandar Kocic 
> Cc: David Carlson ; Gyle McCollam <
> gmccol...@live.com>; gnucash-user@gnucash.org ;
> Derek Atkins 
> Subject: Re: [GNC] Scheduled transaction with variable amount
>
> Creating a transaction for a total amount as of a certain date doesn't
> seem particularly useful. What if you have a dispute, or a return, or a
> transaction that is not accurate, or needs correction? An
> automatically-created transaction will need to be corrected as well.
>
> Gnucash provides an option during the final step of the reconcile process
> to create a payment in the total statement amount. From an accounting
> perspective, this is the best point to create this payment. You have just
> established that your books and theirs match, and the amount due is
> confirmed.
>
> If you're not seeing this dialog during the reconcile process, you have
> turned the feature off for that account, but it can be reset. Just don't
> ask me how...
>
> David T.
> 
> From: Aleksandar Kocic
> Sent: Tue Jul 27 21:51:04 EDT 2021
> To: David Carlson
> Cc: Gyle McCollam , "gnucash-user@gnucash.org" , Derek Atkins
> Subject: Re: [GNC] Scheduled transaction with variable amount
>
>
> Thanks,
>
> While there is a way to not enter the amount, it is not an automated
> process, and, in a sense, it is not different from putting a random value
> and changing it later. Also, if a transaction can't be created
> automatically, it means it will be even more manual steps to get it done.
>
> What I was looking for is a scheduler checking the account balance and
> setting the value automatically.
>
> Maybe one day.
>
> Regards,
> Aleksandar
>
> On Tue, Jul 27, 2021 at 8:43 PM David Carlson  >
> wrote:
>
>  Gyle,
>
>  I believe you cannot create a transaction with a variable automatically
>  created, i.e. do not check the second box in the editor screen.  Then it
>  will ask for a value when you run the since last run assistant.
>
>  On Tue, Jul 27, 2021 at 7:18 PM Gyle McCollam  wrote:
>
>  Derek, this is something I was looking for, however when I tried to put
>  "total" in the debit and credit formula it wouldn't allow the "s.  So I
>  tried with the quotes and it wouldn't save the scheduled transaction.
>  See
>  the attach screen shot.  Can you tell me what I did wrong?
>
>  [cid:b223ae00-6131-45ea-a805-a1b590e0d7dc]
>
>  Thank You,
>
>  Gyle McCollam
>
>  Gyle McCollam
>
>  609.680.2326 Mobile
>
>  gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>
> 
>
>  From: gnucash-user  http://gmail.com&

Re: [GNC] Scheduled transaction with variable amount

[David Carlson]

D,

I plead guilty to being a co-conspirator to the hijacking.

Glad Gyle found his solution.

If the OP needs additional help, please speak up.


On Wed, Jul 28, 2021, 12:10 PM D  wrote:

> So, now this thread is officially hijacked. I hope OP finds a solution to
> his problem, or reports back his solution.
> On Jul 28, 2021, at 11:33, David Carlson 
> wrote:
>>
>> Gyle,
>>
>> It looks like there are some spurious characters somewhere in your data.
>> Do you see problems in any other windows such as import windows, the chart
>> of accounts or other places?
>>
>> On Wed, Jul 28, 2021 at 9:30 AM Gyle McCollam < gmccol...@live.com>
>> wrote:
>>
>>> Speaking of reconciliation, I have a problem with deposits not showing
>>> on one of my accounts and I don't know why this is happening (see below).
>>> I didn't include the right side, which is fine, because it shows other
>>> banks and credit accounts.  Even if I maximize the page it doesn't change.
>>> [cid:4011b06e-5772-49ff-b374-e249e2baaa78]
>>>
>>>
>>> Thank You,
>>> Gyle McCollam
>>>
>>> Gyle McCollam
>>>
>>> 609.680.2326 Mobile
>>>
>>> gmccol...@live.com   email
>>>
>>> 
>>> From: D. < sunfis...@yahoo.com>
>>> Sent: Wednesday, July 28, 2021 8:17 AM
>>> To: Aleksandar Kocic < akoci...@gmail.com>
>>> Cc: David Carlson < david.carlson@gmail.com>; Gyle McCollam <
>>> gmccol...@live.com>; gnucash-user@gnucash.org < gnucash-user@gnucash.org>;
>>> Derek Atkins < de...@ihtfp.com>
>>> Subject: Re: [GNC] Scheduled transaction with variable amount
>>>
>>> Creating a transaction for a total amount as of a certain date doesn't
>>> seem particularly useful. What if you have a dispute, or a return, or a
>>> transaction that is not accurate, or needs correction? An
>>> automatically-created transaction will need to be corrected as well.
>>>
>>> Gnucash provides an option during the final step of the reconcile
>>> process to create a payment in the total statement amount. From an
>>> accounting perspective, this is the best point to create this payment. You
>>> have just established that your books and theirs match, and the amount due
>>> is confirmed.
>>>
>>> If you're not seeing this dialog during the reconcile process, you have
>>> turned the feature off for that account, but it can be reset. Just don't
>>> ask me how...
>>>
>>> David T.
>>> 
>>> From: Aleksandar Kocic
>>> Sent: Tue Jul 27 21:51:04 EDT 2021
>>> To: David Carlson
>>> Cc: Gyle McCollam , " gnucash-user@gnucash.org" , Derek Atkins
>>> Subject: Re: [GNC] Scheduled transaction with variable amount
>>>
>>>
>>> Thanks,
>>>
>>> While there is a way to not enter the amount, it is not an automated
>>> process, and, in a sense, it is not different from putting a random
>>> value
>>> and changing it later. Also, if a transaction can't be created
>>> automatically, it means it will be even more manual steps to get it
>>> done.
>>>
>>> What I was looking for is a scheduler checking the account balance and
>>> setting the value automatically.
>>>
>>> Maybe one day.
>>>
>>> Regards,
>>> Aleksandar
>>>
>>> On Tue, Jul 27, 2021 at 8:43 PM David Carlson <
>>> david.carlson@gmail.com>
>>> wrote:
>>>
>>>  Gyle,
>>>
>>>  I believe you cannot create a transaction with a variable automatically
>>>  created, i.e. do not check the second box in the editor screen.  Then
>>> it
>>>  will ask for a value when you run the since last run assistant.
>>>
>>>  On Tue, Jul 27, 2021 at 7:18 PM Gyle McCollam < gmccol...@live.com>
>>> wrote:
>>>
>>>  Derek, this is something I was looking for, however when I tried to put
>>>  "total" in the debit and credit formula it wouldn't allow the "s.  So I
>>>  tried with the quotes and it wouldn't save the scheduled transaction.
>>>  See
>>>  the attach screen shot.  Can you tell me what I did wrong?
>>>
>>>  [cid:b223ae00-6131-45ea-a805-a1b590e0d7dc]
>>>
>>>  Thank You,
>>>
>>>  Gyle McCollam
>>

Re: [GNC] Scheduled transaction with variable amount

[David Carlson]

On my phone I cannot see the thread history while replying.  I think the OP
wants a feature that doesn't exist,  but I hope he understands how the
existing program works.

On Wed, Jul 28, 2021, 12:31 PM David Carlson 
wrote:

> D,
>
> I plead guilty to being a co-conspirator to the hijacking.
>
> Glad Gyle found his solution.
>
> If the OP needs additional help, please speak up.
>
>
> On Wed, Jul 28, 2021, 12:10 PM D  wrote:
>
>> So, now this thread is officially hijacked. I hope OP finds a solution to
>> his problem, or reports back his solution.
>> On Jul 28, 2021, at 11:33, David Carlson 
>> wrote:
>>>
>>> Gyle,
>>>
>>> It looks like there are some spurious characters somewhere in your
>>> data.  Do you see problems in any other windows such as import windows, the
>>> chart of accounts or other places?
>>>
>>> On Wed, Jul 28, 2021 at 9:30 AM Gyle McCollam < gmccol...@live.com>
>>> wrote:
>>>
>>>> Speaking of reconciliation, I have a problem with deposits not showing
>>>> on one of my accounts and I don't know why this is happening (see below).
>>>> I didn't include the right side, which is fine, because it shows other
>>>> banks and credit accounts.  Even if I maximize the page it doesn't change.
>>>> [cid:4011b06e-5772-49ff-b374-e249e2baaa78]
>>>>
>>>>
>>>> Thank You,
>>>> Gyle McCollam
>>>>
>>>> Gyle McCollam
>>>>
>>>> 609.680.2326 Mobile
>>>>
>>>> gmccol...@live.com   email
>>>>
>>>> 
>>>> From: D. < sunfis...@yahoo.com>
>>>> Sent: Wednesday, July 28, 2021 8:17 AM
>>>> To: Aleksandar Kocic < akoci...@gmail.com>
>>>> Cc: David Carlson < david.carlson@gmail.com>; Gyle McCollam <
>>>> gmccol...@live.com>; gnucash-user@gnucash.org <
>>>> gnucash-user@gnucash.org>; Derek Atkins < de...@ihtfp.com>
>>>> Subject: Re: [GNC] Scheduled transaction with variable amount
>>>>
>>>> Creating a transaction for a total amount as of a certain date doesn't
>>>> seem particularly useful. What if you have a dispute, or a return, or a
>>>> transaction that is not accurate, or needs correction? An
>>>> automatically-created transaction will need to be corrected as well.
>>>>
>>>> Gnucash provides an option during the final step of the reconcile
>>>> process to create a payment in the total statement amount. From an
>>>> accounting perspective, this is the best point to create this payment. You
>>>> have just established that your books and theirs match, and the amount due
>>>> is confirmed.
>>>>
>>>> If you're not seeing this dialog during the reconcile process, you have
>>>> turned the feature off for that account, but it can be reset. Just don't
>>>> ask me how...
>>>>
>>>> David T.
>>>> 
>>>> From: Aleksandar Kocic
>>>> Sent: Tue Jul 27 21:51:04 EDT 2021
>>>> To: David Carlson
>>>> Cc: Gyle McCollam , " gnucash-user@gnucash.org" , Derek Atkins
>>>> Subject: Re: [GNC] Scheduled transaction with variable amount
>>>>
>>>>
>>>> Thanks,
>>>>
>>>> While there is a way to not enter the amount, it is not an automated
>>>> process, and, in a sense, it is not different from putting a random
>>>> value
>>>> and changing it later. Also, if a transaction can't be created
>>>> automatically, it means it will be even more manual steps to get it
>>>> done.
>>>>
>>>> What I was looking for is a scheduler checking the account balance and
>>>> setting the value automatically.
>>>>
>>>> Maybe one day.
>>>>
>>>> Regards,
>>>> Aleksandar
>>>>
>>>> On Tue, Jul 27, 2021 at 8:43 PM David Carlson <
>>>> david.carlson@gmail.com>
>>>> wrote:
>>>>
>>>>  Gyle,
>>>>
>>>>  I believe you cannot create a transaction with a variable
>>>> automatically
>>>>  created, i.e. do not check the second box in the editor screen.  Then
>>>> it
>>>>  will ask for a value when you run the since last run assistant.

Re: [GNC] Transactions for multiple accounts in 1 ofx file?

[David Carlson]

Chris, yes, I do regularly download OFX files from my bank that include
transactions from several checking and saving accounts in one file.  It
happens that often there are transfers between accounts, and usually there
are already existing transactions in GnuCash as I planned the transfers
earlier to prepare for tax payments or whatever.  The transfer transactions
appear as duplicates in the files and each has separate memo text that
differs depending on whether the transaction is the 'From' transaction or
the transaction is the 'To' transaction.

Because there are existing transactions to match to, it would be possible
during the import process to avoid resulting duplicate entries by judicious
matching, but it happens that I want to retain memo text from both sides in
the split lines, so I deliberately treat both sides as new and manually
merge them as a post import operation.  If it were possible to merge them
during the import and retain the split memos from both sides it would
simplify my work flow.
.
I would definitely miss the multiple account import feature if it were lost.

On Sat, Jul 31, 2021 at 3:30 AM Chris Good  wrote:

> Hi,
>
>
>
> I'd like some feedback from people who use the ofx/qfx file import,
>
> or any other type of import that uses the 'Generic import transaction
> matcher'
>
> window.
>
> I've been fixing a problem and found another possible problem which I'd
> like
> to
>
> determine is a problem that needs to be fixed.
>
>
>
> The ofx import handles transactions for multiple bank accounts in the 1
> file.
>
> If you have a transfer transaction between 2 bank accounts and the
>
> transactions for both bank accounts are included in the 1 file, the
>
> 'Generic import transaction matcher' window doesn't detect the second
>
> transaction should be a match of the transaction from the first accounts
>
> transactions.
>
>
>
> Does anyone actually get and import a single ofx/qfx file from their bank,
> or somehow
>
> create a file, which includes the transactions for 2 bank accounts?
>
>
>
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Transactions for multiple accounts in 1 ofx file?

[David Carlson]

You will also note that bug report is dated in 2003, the concern was raised
then with the hint that it was inherent in the OFX specification and
therefore probably difficult or impossible to fix.

The most recent changes to the generic import assistant allows re-ordering
the entries into chronological order which will put the duplicate d
transactions close to each other on the screen,  making them very easy to
spot and manually pick one or the other to keep.

I think there is no need to automatically skip one or the other unless the
split notes are merged as I suggested in my previous email.

If you really want to get fancy, highlight the duplicate s and offer to
skip one or the other.



On Sun, Aug 1, 2021, 3:12 AM Chris Good  wrote:

> When I went to create a bug for this I found one already exists:
>
> https://bugs.gnucash.org/show_bug.cgi?id=105334
>  Import multiple account OFX files with transfers between the accounts,
> duplicate transactions are generated
>
> Regards,
> Chris Good
>
> -Original Message-
> From: Chris Good 
> Sent: Sunday, 1 August 2021 5:49 PM
> To: 'Kalpesh Patel' 
> Cc: gnucash-user@gnucash.org
> Subject: RE: Transactions for multiple accounts in 1 ofx file?
>
> Hi Kalpesh Patel,
>
> Your hiccup sounds exactly like the problem I have described.
> 2 people have now said they have transactions from multiple bank accounts
> in
> the 1 .ofx file, so there are probably many more who do not subscribe to
> this email list and who also may come across this problem. I will raise a
> bug to document it.
> If Covid-19 lockdown continues for much longer I may have enough time to
> try
> to fix this myself.
>
> Regards,
> Chris Good
>
> -Original Message-
> From: Kalpesh Patel 
> Sent: Sunday, 1 August 2021 5:05 AM
> To: goodchri...@gmail.com
> Cc: gnucash-user@gnucash.org
> Subject: Re: Transactions for multiple accounts in 1 ofx file?
>
> I use it in this manner all the time and works great.
>
> I use an old program called pocketsense, which I modified a bit, which goes
> out to multiple institutions, downloads from each in ofx format and then
> combines them into single ofx file to import it into gnucash. Literally
> speaking they all are concatenation of individual files into one. It has
> been working fine since version 3.5 (or earlier I think).
>
> Only hickup that I see now and then is If transaction are across two
> accounts (example a transfer) in ofx then gnucash doesn't cross correlate
> them but if that happens then I disable import for the "seconds" account,
> finish first import and then perform second import of the same file and
> then
> it cross correlates automatically. Nice thing with ofx import in gnucash is
> that you can import same file multiple times but not get duplicated entries
> for the same transaction.
>
> I have tested combined ofx file that has investment account, banking
> account
> and a credit card account and if anything it is one of the robust feature
> of
> gnucash, IMHO.
>
> -
> Excuse the typos. It's the mobile thingy!
>
>
>
>
> ___
> 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.

Re: [GNC] Creating a customer report by location

[David Carlson]

No, not unnoticed, but I do not use business features, so I waited to see
if a business user would step up.

GnuCash has no geographical data feature to use for such a report.  You
would have to somehow manually add appropriate information in a text field,
but reports generally only have rudimentary sorting  on text fields, so
maybe at best you could come up with a manually implemented zip code scheme.

Short answer, no.

On Fri, Aug 6, 2021 at 7:43 AM Samantha Payn <
saman...@boorertranslations.com> wrote:

>Is this not possible, or has this request slipped through unnoticed?
>
>Cheers
>
>On 05/08/2021 14:26 Samantha Payn <[1]saman...@boorertranslations.com>
>wrote:
>
>Can anyone tell me how to set up a report on income by customer
>
>location, please?
>
>Many thanks
>
>Samantha Payn
>
>___
>
>gnucash-user mailing list
>
>[2]gnucash-user@gnucash.org
>
>To update your subscription preferences or to unsubscribe:
>
>[3]https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>If you are using Nabble or Gmane, please see
>[4]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.
>
> References
>
>1. mailto:saman...@boorertranslations.com
>2. mailto:gnucash-user@gnucash.org
>3. https://lists.gnucash.org/mailman/listinfo/gnucash-user
>4. https://wiki.gnucash.org/wiki/Mailing_Lists
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Mutual Fund - Price Import from csv, "Namespace could not be understood"

[David Carlson]

Hi,

I have not tried that particular method to import prices but I would
suggest verifying that you created the csv file using the the same encoding
that you are using for the import and that the namespace, symbol and
currency already exist in your data file.

Good Luck

On Sat, Aug 7, 2021 at 3:37 PM Ashok Sinha  wrote:

> Hello everyone, trying this list for the first time, I hope I am following
> the instructions.
>
> I have downloaded and prepared an import.csv file with 2 lines as:
> 05/08/21, INDIAMUTUAL,INF209KA12Z1, INR,143.021
> 05/08/21, INDIAMUTUAL,INF209K01546, INR,27.1064
>
> Where the columns are Date, Namespace, From Symbol, To Currency, Amount
>
> The 'Namespace', & 'Currency To' dropdown comes up with an error
> respectively as:
> Error 1: Column 'From Namespace' could not be understood. Value can't be
> parsed into a valid namespace.
> Error 2: Column 'Currency To' could not be understood. Value can't be
> parsed into a valide commodity.
>
> Could somebody please explain to me how to import the prices? I think I'm
> doing it right - there's a screenshot below.
>
> The above example has 2 different mutual funds. Once the concept is proved,
> I plan to update many (~20) mutual fund prices from a single import csv
> file on a weekly basis.
>
> Thanks,
> Ashok
>
> [image: image.png]
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Mutual Fund - Price Import from csv, "Namespace could not be understood"

[David Carlson]

Yes!

On Sat, Aug 7, 2021 at 6:57 PM Ashok Sinha  wrote:

> Hi David, thanks. Verified that:
>  - csv file encoding same as for the import.
> --> UTF-8 encoding
>  - namespace + symbol + currency already exist in your data file.
> --> These are already in the price database, where I updated manually
> till so far. Now trying importer to add prices.
>
> Hi John,
> Removed leading spaces.
> --> This resolved it! Now it imports beautifully!
>
> Thanks,
> Ashok
>
>
>
>
> On Sat, 7 Aug 2021 at 22:24, John Ralls  wrote:
>
> >
> >
> > > On Aug 7, 2021, at 1:35 PM, Ashok Sinha  wrote:
> > >
> > > Hello everyone, trying this list for the first time, I hope I am
> > following
> > > the instructions.
> > >
> > > I have downloaded and prepared an import.csv file with 2 lines as:
> > > 05/08/21, INDIAMUTUAL,INF209KA12Z1, INR,143.021
> > > 05/08/21, INDIAMUTUAL,INF209K01546, INR,27.1064
> > >
> > > Where the columns are Date, Namespace, From Symbol, To Currency, Amount
> > >
> > > The 'Namespace', & 'Currency To' dropdown comes up with an error
> > > respectively as:
> > > Error 1: Column 'From Namespace' could not be understood. Value can't
> be
> > > parsed into a valid namespace.
> > > Error 2: Column 'Currency To' could not be understood. Value can't be
> > > parsed into a valide commodity.
> > >
> > > Could somebody please explain to me how to import the prices? I think
> I'm
> > > doing it right - there's a screenshot below.
> > >
> > > The above example has 2 different mutual funds. Once the concept is
> > proved,
> > > I plan to update many (~20) mutual fund prices from a single import csv
> > > file on a weekly basis.
> >
> > Try removing the leading spaces from the namespace and currency columns.
> >
> > Regards,
> > John Ralls
> >
> >
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Correct wrong exchange

[David Carlson]

Use Tools > Security Editor.

On Mon, Aug 9, 2021 at 8:20 AM Dr. Gideon Fell  wrote:

> Colleagues,
> I have several stocks which I fat fingered and did NOT specify the
> correct Exchange, (NYSE, NASDAQ, etc). How can I correct this?? I use
> the latest Linux version.
>
> Ron B.
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Importing Multiple Accounts in a single OFX/QFX file

[David Carlson]

While the files that I import from my bank have content that I want to
retain in both sides of the duplicated transactions other use cases
probably differ.  I expect that this solution would work for some users and
I would prefer to keep the multiple source accounts separated during the
import process.  That is the way it used to work in the 2.6.x series, and
it would be easier to find and edit existing transactions if the other
issue of touching an incoming transaction in the register view causing
major havoc (https://bugs.gnucash.org/show_bug.cgi?id=721139) was solved to
work more safely like register edits do in the reconciliation assistant.

On Mon, Aug 9, 2021 at 11:57 PM Chris Good  wrote:

> Hi,
>
>
>
> Re https://bugs.gnucash.org/show_bug.cgi?id=105334#c13
>
>import multiple account OFX files with transfers between the
> accounts, duplicate transactions are generated
>
>
>
> The problem is that when you import OFX transactions for 2 bank accounts
> from the same file, if there is a transfer
>
> between the 2 bank accounts, the 'Generic transaction matcher' window does
> not detect that the transaction in the
>
> transactions for the 2nd bank account is a duplicate and defaults to
> wanting
> to add it (a duplicate transaction) when
>
> it should default to matching it against the first transaction. This is
> because the first transaction has not yet been
>
> stored in the GnuCash datafile.
>
>
>
> A suggestion solution to this problem is to match and store each account's
> transactions 1 at a time, rather than
>
> putting all transactions in the ofx file in the matcher window at the same
> time.
>
>
>
> I'm wondering if this would be unacceptable to some people?
>
>
>
> By the way, I didn't realise you could select multiple .ofx files at once
> in
> the OFX import. Some people may find that useful.
>
> It seems they have to be in the same directory.
>
>
>
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Help Selling & Buying Securities

[David Carlson]

Jack,

If you follow the help manual reference given by Eric earlier (
https://code.gnucash.org/docs/C/gnucash-guide/invest-buy-stock1.html) and
continue forward to the section on stock sales there is a lot of
information there which should help you.  The issue of capturing realized
gains is a complex one with more than one solution, but you can defer that
decision until after you are comfortable with the basic transactions.

On Tue, Aug 10, 2021 at 9:28 AM Fred Bone  wrote:

> On 10 August 2021 at 10:01, Jack Frillman said:
>
> > I sort of got it to work but my cash balance is all messed up.
> > See attached for the example of my transactions.
> >
> > In the parent account the cash Balance should be $1,115.05 not $4,676.09
> > and I can't figure out why.
> >
> > Where did I mess up?
>
> Hard to say without knowing what the txns actually were. What you have
> told Gnucash is:
>
> - you had 1115.05 on 7/21
> - you sold some Midcap Fund for 5213.04 on 8/10
> - you bought some Mid Cap Value for 1652.00 on 8/10
>
> which leaves a balance of 4676.09, as shown.
>
> Presumably you have entered the wrong value for either the sale or the
> purchase txns, but only you can tell which.
>
>
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Help Selling & Buying Securities

[David Carlson]

Be sure to check your next broker's statement for any capital gain that you
may need to pay tax on next year.

On Tue, Aug 10, 2021, 2:10 PM Jack Frillman  wrote:

> I finally got it figured out. My transactions in GNUC are correct after
> all.
> The cash on my brokers website has not been updated yet because the
> transactions have not been closed out. Once that happens the cash
> amounts will agree. So says my financial advisor.
>
> Thanks for the advice.
>
> On 8/10/21 2:01 PM, Fred Bone wrote:
> > On 10 August 2021 at 13:48, Jack Frillman said:
> >
> >> I have been trough all that and don't see how any of it applies to what
> >> I'm trying to do because: 1 - I have no commissions to deal with. 2 - I
> >> have no capital gains to deal with. Very confusing.. It appears I
> have
> >> the sell side correct the the buy may have something wrong.
> > Well, either
> > (a) the value of both sell and buy txns was the same, and you have
> > entered one of them wrong, or
> > (b) the values were different, so you shouldn't be expecting the net
> > result to be nil.
> >
> > Only you can tell which applies.
> >
>
> --
> Old Unix programmers never die, they just mv to /dev/null
> - Anonymous
>
>
___
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.

[GNC] Comenity Bank OFX Exports

[David Carlson]

My wife recently opened a Comenity Bank Petco credit card and their web
presence apparently reverses the values for charges and payments in their
OFX exports, compared to other credit cards.  This surprises me since they
must have many other cards that presumably would not be reversed in their
OFX exports, if they offer them.

1. I would like suggestions of references to other Comenity cards with
correct OFX exports (if any exist) to mention if I decide to ask them to
correct the problem, or

2. Is there an easy way to preprocess OFX transaction import files to
reverse the signs of every transaction?

3.  Their export files also include references to external corrections not
included in the files so GnuCash has to indicate that the missing external
correction exists.  I am not sure if I want to keep those references
either, so is there an easy preporcess way to delete those?  If not, can
the OFX generic import show the references during the import process?  One
of those references looks like this:
obfuscatedidentifier
REPLACE

Other information that I found on the internet suggests that one would be
wise to avoid Comenity cards in general, which is probably why this is the
only Comenity card that we have.
-- 
David Carlson
___
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.