Re: [GNC] Merge amounts in report

[Steve Butler]

The only way I know is to select both (all such) in a transaction report.
Then produce the grand total.

You would have to setup the options to get the specifics how you want them.

On Fri, Apr 19, 2024, 20:00 Bruno Sampaio Alves 
wrote:

> I have some expenses accounts that hold the same name (for example, "eating
> out") but one is related to my personal expenses and the other either is
> related to the mutual expenses I have with my fianceé or to a trip expense,
> for example.
> I would like to know if there is a way that when I'm looking at an expense
> report, for example, I could see the total amount of these accounts sumed
> up rather than the each amount separately.
>
> I'd appreciate thoughts on the topic.
>
> Bruno Alves
> ___
> 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] What account name do you use to record the apartment/house expenses related to the building?

[Steve Butler]

On Tue, Apr 16, 2024, 10:49 john  wrote:

>
>
> > On Apr 14, 2024, at 17:45, Oleander via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > Hello,
> > is "Housing" a proper account name if I want to include only my
> apartment expenses like Rent/Mortgage and Repairs? I'd like to
> record my Utilities expenses separately within another account so that my
> "Housing" account adds up only the expenses related to the building.
> >
> > If not, what would you use?
>
> Rent is an expense but if you're renting then maintenance should generally
> be the landlord's responsibility.



If you are the owner and renting out the property, then rent is income.


A mortgage means you own the place and the payment gets split up into one
> or more expenses (at least interest; maybe insurance, fees, and others
> depending on the terms of the loan) and principal payment that reduces the
> loan amount. Property owners also need to distinguish between maintenance
> and improvements: The latter increase the value of the property, the former
> are an expense.
>
> 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.
>
___
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] Can't open old GnuCash file

[Steve Butler]

Can you install version 4.x on your box and try again.  Maybe even a 3.x.

On Thu, Feb 15, 2024, 17:01 MegaBrutal  wrote:

> Hello,
>
> I've been using GnuCash between 2015 to 2017 to help to straighten out
> my personal finances. Due to changes in my life, my transaction count
> increased significantly which required more and more time to enter,
> while I got less free time to do the accounting. Meanwhile, my
> financial problems basically got resolved and my motivation to keep on
> updating my GnuCash file dropped significantly.
>
> Now I got a situation that I'm looking for certain transactions from
> around that time and I remembered that I should check my old GnuCash
> file, untouched since 2017-09-21. To my shock, the modern GnuCash
> version that comes with my distro (Ubuntu 23.10) crashes when I try to
> open my old file. Here is my GnuCash version and the backtrace I get:
>
> ---
>
> GnuCash 5.3
> Build ID: 5.3+(2023-06-26)
>
> Backtrace:
> In ice-9/boot-9.scm:
>   1752:10  5 (with-exception-handler _ _ #:unwind? _ #:unwind-for-type _)
> In unknown file:
>4 (apply-smob/0 #)
> In ice-9/boot-9.scm:
>2836:4  3 (save-module-excursion # ice-9/eval-string.scm:66:9 ()>)
> In ice-9/eval-string.scm:
>  38:6  2 (read-and-eval # #:lang _)
> In ice-9/eval.scm:
> 619:8  1 (_ #(#
> # *
> 563d43f24190>))
> In unknown file:
>0 (GncOption-set-value # (absolute
> 1496181600 . 0))
>
> ERROR: In procedure GncOption-set-value:
> Wrong type (expecting exact integer): (1496181600 . 0)
>
> Some deprecated features have been used.  Set the environment
> variable GUILE_WARN_DEPRECATED to "detailed" and rerun the
> program to get more information.  Set it to "no" to suppress
> this message.
>
> ---
>
> Maybe I was wrong that I expected some backward compatibility that
> modern versions are capable of performing incremental updates to old
> files to update it to the current file format... What to do now? Any
> suggestions?
>
>
> Best regards,
> MegaBrutal
> ___
> 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 with Interactive Brokers

[Steve Butler]

That is true for the first time.  After that it will learn the matches you
make and only ask for new ones.

On Tue, Feb 6, 2024, 16:35 km22 via gnucash-user 
wrote:

> Thanks.
>
>
> Upon importing the OFX I am prompted to match the different bonds in the
> statement with the relevant asset in GnuCash:
>
> This is quite a manual process having to match these manually
> one-by-one.  Do you know whether there is a way for me to define the
> assets in GnuCash so this mapping is more automated? (Or at least where
> GnuCash is able to select the best match for me to review?)
>
>
> Since it reads "Please note that the exchange code of the commodity you
> select will be overwritten" does this mean that if I set the ISIN/CUSIP
> correctly in GnuCash the mapping would be more seamless?
>
>
>
>
>
>
> On 2024-02-05 22:17, Kalpesh Patel wrote:
> >
> > Ken, as Gyle mentioned, they are sibling to each other. In terms of
> > technical specs, QFX is modified OFX format which contains additional
> > Intuit’s non-XML header but GNC treats them both equal as it simply
> > ignores that header. From the transaction wise they both will contain
> > identical data.
> >
> > *From:*Gyle McCollam 
> > *Sent:* Monday, February 05, 2024 8:59 AM
> > *To:* Kalpesh Patel ; km22 
> > *Cc:* gnucash-user@gnucash.org
> > *Subject:* Re: [GNC] GnuCash with Interactive Brokers
> >
> > It doesn't "prefer" either, in fact the import is OFX/QFX.
> >
> > Thank You,
> >
> > *Gyle McCollam*
> >
> > Gyle McCollam
> >
> > gmccol...@live.com email
> >
> > 
> >
> > *From:*gnucash-user
> >  on behalf of km22
> > via gnucash-user 
> > *Sent:* Monday, February 5, 2024 4:54 AM
> > *To:* Kalpesh Patel 
> > *Cc:* gnucash-user@gnucash.org 
> > *Subject:* Re: [GNC] GnuCash with Interactive Brokers
> >
> > Hi Kalpesh,
> >
> > Thanks for your reply. IBKR offers these "Third-party Downloads":
> >
> > 1. Quicken Web Connect -> which generate a QFX file
> >
> > 2. GainsKeeper
> >
> > 3. TradeLog
> >
> > 4. MS Money -> which generates a OFX file
> >
> >
> > Do you know whether GnuCash prefers OFX or QFX?
> >
> > I have downloaded both and will experiment with them.
> >
> > Thanks,
> >
> > Ken
> >
> >
> >
> > On 2024-02-05 10:27, Kalpesh Patel wrote:
> > > While I am NOT with Interactive Broker, your best bet is to see if
> > you can download transactions in OFX (Open Financial Exchange) or QFX
> > (Quicken Financial Exchange) format. That would be the best format and
> > I believe most broker-dealers support that format as a download method
> > from their web portal.
> > >
> > > -Original Message-
> > > From: km22
> > > Sent: Sunday, February 04, 2024 4:57 AM
> > > To:gnucash-user@gnucash.org
> > > Subject: [GNC] GnuCash with Interactive Brokers
> > >
> > > Hi Gnucash Users,
> > >
> > > Does anyone on this mailing list have a method for importing
> > transactions from Interactive Brokers (IBKR) to GnuCash? (Especially
> > multi-currency users.)
> > >
> > > I currently enter all transactions manually but would like to
> > explore ways of importing transactions.
> > >
> > > Please share your approach if so.
> > >
> > > Thanks,
> > >
> > > Ken
> > >
> > >
> > >
> > >
> > ___
> > 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] Automatic account match doesn't work when import transactions

[Steve Butler]

Which import?  CSV?

On Sun, Feb 4, 2024, 13:04 Jediator  wrote:

> I couldn't get the automatic account match to work when importing
> bank/credit card transactions to GC.  Is there anyway to manually create
> the matching rules?  Thanks!  -- JC
> ___
> 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] Feature request: Import assistant, room for big improvements

[Steve Butler]

I do it every OFX import.  Works well.  Ubuntu 23.10.  GnC 5.4-117.

Need anything else?  BTW, works fine, the right click.


On Mon, Jan 15, 2024, 21:12 Christopher Lam 
wrote:

> Has anyone tried right click the relevant transaction(s) in the ofx or csv
> import assistant?
>
> On Tue, 16 Jan 2024, 12:49 pm David Carlson, 
> wrote:
>
> > Which import assistant is being discussed here?  The Generic assistant
> > behind the OFX and QIF imports is quite limited in placing new
> transactions
> > into the desired account or in matching incoming transactions to correct
> > pre-existing transactions, but the new CSV transaction importer is
> better,
> > if harder to configure optimally.  Also, I think they all have changed in
> > recent GnuCash releases, so tell us which release you are currently
> using.
> >
> > I doubt that the Generic assistant can be improved very much unless it is
> > completely rewritten.
> >
> >
> > On Mon, Jan 15, 2024 at 10:26 PM Phyllis Bruce 
> > wrote:
> >
> > > 
> > >
> > >
> > > > On Jan 15, 2024, at 10:17 PM, Derek Atkins  wrote:
> > > >
> > > > 
> > > > No, I would call that the description.
> > > > -derek
> > > > Sent using my mobile device. Please excuse any typos.
> > > >
> > > >> On January 15, 2024 23:06:07 Phyllis Bruce 
> > wrote:
> > > >>
> > > >> Thanks, David.  I think I am being unclear.  My research provides
> what
> > > you
> > > >> call the transfer account for unmatched items.  That's all good.  It
> > is
> > > the
> > > >> memo field which I use to remind me of what I did that is not
> > available
> > > in
> > > >> the reconciliation screen.  For instance I want to remember that I
> > paid
> > > >> Amazon for *smart plugs*, or Sandi paid me $70 for *her share of
> > > groceries
> > > >> at Christmas*.  Would you call that the "action"?
> > > >>
> > > >> On Mon, Jan 15, 2024 at 3:21 PM David Cousens <
> > davidcousen...@gmail.com
> > > >
> > > >> wrote:
> > > >>
> > > >>> Ulrich,
> > > >>>
> > > >>> There is nothing to stop you supplying the transfer account
> > > information in
> > > >>> an
> > > >>> import record if it is available. There is a header which can be
> > > assigned
> > > >>> to the
> > > >>> appropriate column of your input file for the transfer account.
> > > >>>
> > > >>> The first time you import with a given account name in he record
> you
> > > will
> > > >>> be
> > > >>> asked to specify the internal GnuCash account to which it
> > corresponds.
> > > >>> After
> > > >>> that it will be matched to that account.
> > > >>>
> > > >>> The Bayesian process only assigns a probable account in cases where
> > the
> > > >>> import
> > > >>> record does not specify the  transfer account.
> > > >>>
> > > >>> David Cousens
> > > >>>
> > >  On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
> > >  Hello fellow GnuCash users,
> > > 
> > >  I wonder if there are plans on improving the import filter, for
> > > importing
> > >  bank transfers.
> > >  The situation now is, that some hidden engine tries to learn from
> > > doing.
> > >  But the truth is, that even after one year of importing bank
> > > transfers, I
> > >  have to check every single transaction, since errors keep
> occurring.
> > > If I
> > >  miss an error, this transaction is put in the wrong ledger
> account.
> > > 
> > >  E-boekhouden.nl uses an import assistant where you can specify a
> > > ledger
> > >  account number, other keywords and/or amounts of money. The import
> > >  assistant puts the transactions into the right ledger account,
> with
> > > far
> > >  less errors than with GnuCash. In fact, only where a specific
> > keyword,
> > >  leger number or amount is missing, or where no import rule is made
> > > for a
> > >  specific payment, the transaction has to be placed into the right
> > > general
> > >  ledger by hand.
> > > 
> > >  Have a nice day!
> > > 
> > >  --
> > >  नमस्ते (Namasté),
> > >  Ulrich
> > > 
> > > 
> > > >>>
> > >
> >
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> > >  ¤º°`°º¤ø
> > > 
> > >  " Can't talk to you without talking to me; we're guilty of the
> same
> > > old
> > >  thing.
> > >    Thinking a lot about less and less, and forgetting the Love we
> > >  bring "
> > > [Grateful Dead, in: 'Althea']
> > > 
> > > 
> > > >>>
> > >
> >
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> > >  ¤º°`°º¤ø
> > >   Mijn blog: ✡ theskepticaltheist.eu ✡
> > >  ___
> > >  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.
> > >  

[GNC] gnu-cash users to meet in person?

[Steve Freeman]

Do any gnu-cash user groups meet in person? I'd like to meet and perhaps
occasionally work with other gnu-cash users. 

If no groups exist, but any of you might care to meet with another user,
please direct reply. 

I live in central Connecticut and would be happy to host a group. 

I travel occasionally to New York (especially Westchester), New Jersey,
Philadelphia, Vermont and Boston and would be happy to meet with any users
in any of these areas.

Thanks, Steve 

___
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] Transaction not showing as reconciled when it should be.

[Steve Butler]

I suspect you have a transaction for the  £107.29 that has already been
reconciled when it shouldn't have been.  Probably for a different date.  Go
get a transaction report for this account and sort by reconcile date.  Look
at transactions reconciled after the last good reconciliation date.

I once found a dupe that was entered for a year prior to the other.  Now as
I reconcile I check the transaction date to be sure I'm not reconciling
something with a very old date unless it was a true error that I went back
and fixed.

On Mon, Nov 20, 2023, 12:41 David Kirkby 
wrote:

> On Mon, 20 Nov 2023 at 19:57, David Carlson 
> wrote:
>
> > That image does not appear to be from the reconciliation tool.  If it is
> > from the reconciliation report, it probably cannot actually reconcile a
> > transaction, but I have never used that report and I dont know how it
> works.
> >
>
> That's correct, but here's a view from the reconciliation tool. I picked a
> date that had just one extra transaction compared to the previous
> reconciled amount. So selecting the £98 deposit the account will reconcile.
> But to get to that point, the must have already been reconciled,
> but I'm still shown the option to select it.
> [image: image.png]
>
>
>
> >
> >
> >
> > On Mon, Nov 20, 2023, 1:28 PM David Kirkby <
> drkir...@kirkbymicrowave.co.uk>
> > wrote:
> >
> >> I've reconciled my accounts. To do that I would have needed to include a
> >> particular transaction of £107.29 to Digikey, but not the one of £176.20
> >> to
> >> Digikey on the same day. However, the £107.29 is not marked as
> reconciled.
> >> If I try to reconcile to any later date, I'm always presented with the
> >> option to reconcile that transaction. But the accounts will not
> reconcile
> >> unless I ignore that one.
> >>
> >> It seems the "n" in the reconciliation status needs to be changed to a
> >> "y",
> >> but why this is happening I don't have a clue.
> >>
> >>
> >> [image: image.png]
> >>
> >>
> >> --
> >> Dr David Kirkby Ph.D
> >> Kirkby Microwave Ltd
> >> Email: drkir...@kirkbymicrowave.co.uk
> >> Web: https://www.kirkbymicrowave.co.uk/
> >> Telephone 07910 441670 (UK) or +44 7910 441670 (international)
> >> Registered in England and Wales, company number 08914892.
> >> Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3
> 6DT
> >> ___
> >> 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.

[GNC] All Saved Reports Return Empty

[Steve Isenberg via gnucash-user]

I think this problem has cropped up before, but I don't remember the solution.
   I'm on Pop!_OS 22.04 LTS   Version 5.4 (Flathub 5.4.1)
I brought over my saved-reports-2.8 file from my Windows backup laptop and put 
them in ~/.var/app/org.gnucash.GnuCash/data/gnucash
Every report I run returns empty. Nothing works, but there are no errors.
I tried editing a couple of them, but that did not help. I even tried creating 
a new report, but that did not help either.
How do I fix this issue?
Thanks in advance
Steve
___
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] I need basic help

[Steve Butler]

On Wed, Oct 18, 2023, 23:04 Edwin Booth  wrote:

> Steve,
>
> Thanks for getting back to me!
>
> It seems that I need to first delete my newly downloaded file from GnuCash
> and re-import it but first assign all the
>

Yes, remove those transitions or restore to a pre-import backup.

transactions to various accounts. I have

This is done during the import process just after you open the file.  You
should see a list of the transactions that will be loaded.  Pick each one
and be sure it has the correct destination account.  That's how the import
process is taught.

 gone through the process (I think) of creating a hierarchy of accounts
(though I will surely want to add more expense accounts later).

>
> Okay, I have deleted the AMEX credit card OFX account that I imported into
> GnuCash and have gone back to my Mac Downloads file. How do I now assign
> all those transactions to their proper accounts without first importing
> this OFX file into GnuCash? Doesn’t it have to be in GnuCash before it can
> even know what accounts are available?
>
> It’s late now, so I’ll wait for an answer to this first question before
> going on.
>
> But for some reason I saw this email in my Yahoo mail app rather than
> in my Gmail app. Please respond to this by sending out my Gmail account.
> elybee...@gnail.com.
>
> Thanks,
>
> Edwin
>
>
> Sent from Yahoo Mail for iPhone
>
> On Wednesday, October 18, 2023, 2:05 PM, Stephen M. Butler 
> wrote:
>
> Edwin,
>
> I routinely download my CC transactions using OFX.  I think you missed a
> very important step.
>
> It sounds like you did tie this OFX file to your CC Liability Account.
> That will be remembered for all future imports from this CC.
>
> It also sounds like you may not have set up all the various expense
> accounts (Groceries, Fuel, Hardware, etc).  Those need to be setup as
> accounts under the Expense top-level account.
>
> Then, during the import process, after you pick the file but before
> doing the actual import step you will see a list of all the
> transactions.  During this first import none of them will show the
> corresponding expense account.  You will need to click on each line and
> indicate to which account that expense should be assigned.  In some
> cases you will have a payment so up.  For the first time you will need
> to assign this to your Asset/Checking account.
>
> This process of assigning accounts to each transaction will teach the
> import process how to automatically assign them in the future. As the
> importer learns each transaction (based on the description), it will
> begin to automatically assign the proper accounts. Occasionally you may
> need to correct the account assignment or it may see a new description
> and not know leaving it assigned to the Invalid Account.  This is your
> clue to click on that line (perhaps double click) and make the
> appropriate assignment.
>
> Hopefully this helps you on future imports.
>
> --Steve
>
> Stephen M Butler
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
> On 10/18/23 11:09, Edwin Booth wrote:
> > Hi. New to this. I just downloaded an OFX file for a credit card I have.
> I
> > imported it into my “Unsaved Book.” That worked. It is now on the
> Accounts
> > Page with an amount under the “Total” column. But there is also a line
> that
> > says “Imbalance-USD” with the same same amount under Total. I understand
> (I
> > think) that that Imbalance is due to the fact that I have no other
> account
> > in there and so there is nothing to balance my CC account with.
> >
> > So, I obviously need to enter some new accounts. I haven’t paid off all
> of
> > that CC account, but I have paid some of it. The unpaid portion would be
> > under “Liability” I assume, and the paid part under “Expense.”
> >
> > Not sure what to do next. I’m running GnuCash on a MacBook Pro, which I’m
> > also pretty new at.
> >
> > Thanks,
> >
> > Edwin
> > ___
> > 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/mailm

[GNC] Sorry, first post: frequent imports always requiring intervention

[Steve Freeman]

Sorry, it was my first post in the listserv. I didn't know how exactly how
it worked. Will not use default signature again and will use a fresh email
to start a new thread.

-original 
When I import transactions (using csv) about 10% do not import, i.e. show up
in red as requiring intervention. Some of these are repeated transactions,
e.g. Apple.Com/Bill $5.32. 

Is there some way to teach GnuCash to accept these?

Thank you for any help.

Steve 


___
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] frequent imports always requiring intervention

[Steve Freeman]

When I import transactions (using csv) about 10% do not import, i.e. show up
in red as requiring intervention. Some of these are repeated transactions,
e.g. Apple.Com/Bill $5.32. is there some way to teach GnuCash to accept
these?

Thank you for any help.

Steve 

-
Steven F. Freeman *  http://sffreeman.com
<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fsffreeman.com=E,1,QzXD
SswwaM6wgd_K3ufbl_p4CzgW5tok_SF9gyv43RXjI187brQr55aVaxuOq77r5sAQbnXln_Iy0nw6
R3MH5T79wQeOovtPvBGnB6wg=1>  * Google/ Gab/ Mewe/ Facebook/ Linked-In/
Twitter/ Skype: sffreeman * Best email: s...@alum.mit.edu
<mailto:s...@alum.mit.edu>  * +1 (215) 802 4680 * Hub: ARMs for the Rest of
Us: A Systems Approach to Applied Research Methods
http://sffreeman.com/ARMs/
<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fsffreeman.com%2fblog%2f;
c=E,1,xTKv_9nFPSu-Shnbuwgq7rSxhHIfbj3rUkLyot4MA5TnWCx12pfx6VzS9ZUf9TBpsDeXNM
UvdyHe_rq2Vhw18qdzVFcK5wwTOL4V_H7H6L1rrmoNk-XApDD9PmOm=1> 
 
Recent Articles: Knowledge + Leadership
<https://medium.com/knowledge-leadership>  (Rigorous, relevant research and
concise insight on leadership)
*   Psychological Containment: A Critical Leadership Success Factor
<https://medium.com/knowledge-leadership/psychological-containment-284b3a7f0
875>   (with Marc Maltz)
*   The Astonishing Power of Shared Opportunity and Moral Purpose:
<https://medium.com/@sffreeman/the-astonishing-power-of-shared-opportunity-a
nd-moral-purpose-aa9d8315e946?source=your_stories_page--
->  The Secret to Sandler O'Neill's Resurrection from the Ashes of 9/11
Devastation
<https://medium.com/@sffreeman/the-astonishing-power-of-shared-opportunity-a
nd-moral-purpose-aa9d8315e946?source=your_stories_page--
-> 
*   A Crisis is a Terrible Thing to Waste: Recovering Agency in
Coronavirus Times
<https://medium.com/@sffreeman/a-crisis-is-a-terrible-thing-to-waste-recover
ing-agency-in-coronavirus-times-86e87472a96e>  
Election Integrity <https://medium.com/election-integrity>  (Paper Ballots /
Process Transparency / Election Day Voting / Democracy-Building / Education)

*   How to Restore Trust and Peace in America
<https://medium.com/election-integrity/how-to-restore-trust-and-peace-in-ame
rica-180bd8e3c5f8?source=your_stories_page--
---> : Why Election Transparency is critically important
<https://medium.com/election-integrity/how-to-restore-trust-and-peace-in-ame
rica-180bd8e3c5f8?source=your_stories_page--
---> 
*   Elections We Can All Believe In
<https://medium.com/election-integrity/elections-we-can-all-believe-in-a2546
02fc8f7?source=your_stories_page-> : The
*Other* Reason America Needs Election Integrity
<https://medium.com/election-integrity/elections-we-can-all-believe-in-a2546
02fc8f7?source=your_stories_page-> 
*   America Needs Elections We Can All Believe In
<https://medium.com/election-integrity/america-needs-elections-we-can-all-be
lieve-in-159f3fc37089?source=your_stories_page--
--->  An impartial perspective on US elections
<https://medium.com/election-integrity/america-needs-elections-we-can-all-be
lieve-in-159f3fc37089?source=your_stories_page--
---> 


 
___
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] Frequent imports always requiring intervention

[Steve Freeman]

When I import transactions (using csv) about 10% do not import, i.e. show up
in red as requiring intervention. Some of these are repeated transactions,
e.g. Apple.Com/Bill $5.32. 

Is there some way to teach GnuCash to accept these?

Thank you for any help.

Steve 

-
Steven F. Freeman *  http://sffreeman.com
<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fsffreeman.com=E,1,QzXD
SswwaM6wgd_K3ufbl_p4CzgW5tok_SF9gyv43RXjI187brQr55aVaxuOq77r5sAQbnXln_Iy0nw6
R3MH5T79wQeOovtPvBGnB6wg=1>  * Google/ Gab/ Mewe/ Facebook/ Linked-In/
Twitter/ Skype: sffreeman * Best email: s...@alum.mit.edu
<mailto:s...@alum.mit.edu>  * +1 (215) 802 4680 * Hub: ARMs for the Rest of
Us: A Systems Approach to Applied Research Methods
http://sffreeman.com/ARMs/
<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fsffreeman.com%2fblog%2f;
c=E,1,xTKv_9nFPSu-Shnbuwgq7rSxhHIfbj3rUkLyot4MA5TnWCx12pfx6VzS9ZUf9TBpsDeXNM
UvdyHe_rq2Vhw18qdzVFcK5wwTOL4V_H7H6L1rrmoNk-XApDD9PmOm=1> 
 
Recent Articles: Knowledge + Leadership
<https://medium.com/knowledge-leadership>  (Rigorous, relevant research and
concise insight on leadership)
*   Psychological Containment: A Critical Leadership Success Factor
<https://medium.com/knowledge-leadership/psychological-containment-284b3a7f0
875>   (with Marc Maltz)
*   The Astonishing Power of Shared Opportunity and Moral Purpose:
<https://medium.com/@sffreeman/the-astonishing-power-of-shared-opportunity-a
nd-moral-purpose-aa9d8315e946?source=your_stories_page--
->  The Secret to Sandler O'Neill's Resurrection from the Ashes of 9/11
Devastation
<https://medium.com/@sffreeman/the-astonishing-power-of-shared-opportunity-a
nd-moral-purpose-aa9d8315e946?source=your_stories_page--
-> 
*   A Crisis is a Terrible Thing to Waste: Recovering Agency in
Coronavirus Times
<https://medium.com/@sffreeman/a-crisis-is-a-terrible-thing-to-waste-recover
ing-agency-in-coronavirus-times-86e87472a96e>  
Election Integrity <https://medium.com/election-integrity>  (Paper Ballots /
Process Transparency / Election Day Voting / Democracy-Building / Education)

*   How to Restore Trust and Peace in America
<https://medium.com/election-integrity/how-to-restore-trust-and-peace-in-ame
rica-180bd8e3c5f8?source=your_stories_page--
---> : Why Election Transparency is critically important
<https://medium.com/election-integrity/how-to-restore-trust-and-peace-in-ame
rica-180bd8e3c5f8?source=your_stories_page--
---> 
*   Elections We Can All Believe In
<https://medium.com/election-integrity/elections-we-can-all-believe-in-a2546
02fc8f7?source=your_stories_page-> : The
*Other* Reason America Needs Election Integrity
<https://medium.com/election-integrity/elections-we-can-all-believe-in-a2546
02fc8f7?source=your_stories_page-> 
*   America Needs Elections We Can All Believe In
<https://medium.com/election-integrity/america-needs-elections-we-can-all-be
lieve-in-159f3fc37089?source=your_stories_page--
--->  An impartial perspective on US elections
<https://medium.com/election-integrity/america-needs-elections-we-can-all-be
lieve-in-159f3fc37089?source=your_stories_page--
---> 


 
___
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] get quotes via gnucash-cli for unknown quote source

[Steve Butler]

Not on this thread.  Create a new subject and ask.

On Wed, Aug 23, 2023, 21:08 jackielou wong  wrote:

> Hello there
>
> Can i ask for importing 100 transactions using csv.
>
> On Thu, Aug 24, 2023, 12:00 PM john  wrote:
>
> >
> >
> > > On Aug 23, 2023, at 02:26, Jascha K via gnucash-user <
> > gnucash-user@gnucash.org> wrote:
> > >
> > > Hi,
> > >
> > > I've been trying to get quotes via gnucash-cli with the following
> > command:
> > >
> > > gnucash-cli --quotes get mysql://
> > >
> > > However, I get the following message when executing the command and no
> > quotes are fetched: 'Price retrieval failed: GncQuotes::Fetch called with
> > no commodities.'
> > >
> > > All of my quote sources are of type 'Unknown' (tradegate, fondsweb).
> > >
> > > When I get the quotes via 'Get Quotes' in the Price Database, the
> quotes
> > are fetched normally, so it seems to be a problem with the CLI.
> > >
> > > After some investigation, I found out 2 things:
> > >
> > > 1. When switching the quote source for a security to a source that is
> > not Unknown, the CLI is able to fetch that security's quote.
> > >
> > > 2. When I edit the file libgnucash/engine/gnc-commodity.c and add the
> > tradegate and fondsweb sources to the 'single_quote_sources' variable
> (thus
> > making them known sources), the CLI is able to fetch all quotes, no more
> > errors.
> > >
> > > This leads me to believe that the CLI fetching ignores securities where
> > the quote source is Unknown, whereas the GUI fetches the quotes
> regardless
> > of the quote source. I was not able to pin down this behavior in the
> > source, but maybe somebody can clarify whether this is the desired
> behavior
> > for the CLI.
> > >
> > > Tested with most recent stable branch and Flatpak version 5.3, F::Q
> > versions 1.54, 1.56 and 1.58, on Ubuntu 22.04.
> >
> > Not desired behavior but not surprising either: In order to know about
> the
> > unknown quote source gnucash-cli -Q get needs to retrieve them from F::Q
> > and it doesn't do that. Shouldn't be too hard to fix, but please file a
> bug
> > so that the problem doesn't get lost in mailing list entropy.
> >
> > 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.
> >
> ___
> 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] Description field, freezes

[Steve Miller]

Just noticed that someone else here reported (see below) the exact same
problem I experienced after installing 5.3 GnuCash in Windows, weeks ago.
And I thought I was the only one (I posted my frustration here several
weeks ago)

Subject: Re: [GNC] Unable to enter data in "Description" field of a
Transaction
My issue is that, yes, I can retreat and go back, but it still freezes
after adding 1 character.  I have to retreat and go back for nearly ever
single character in my description ... REALLY annoying!!

If I opt to manually enter a description (by opting out of the
autocomplete) in the description field, it FREEZES after entering a single
character.  If I'm trying to enter a 10 character word for a new entry, I
enter the first character, it freezes, I then save it by clicking outside
that entry, then go back and enter the 2nd character, it freezes I save it
by clicking outside the entry, etc etc etc.  It is, frustrating.to say the
least.  Why I previously asked if there was a way to just turn off the
entire auto-field description feature (I understand there is 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Accounts which are both Income and Expense accounts

[Steve Butler]

I tend to create these as Asset type accounts (I loan value to my buddy so
this is Accounts Receivable or something for which I am to be reimbursed).
That way a negative amount means I owe my buddy.

It could also be a Liability account in that I borrowed from my buddy and
it is an Account Payable.  If it is negative then he owes me money.

Pick one way of looking at it.

On Mon, Jul 24, 2023, 09:03 Phyllis Bruce  wrote:

> I'd set that account up as a credit card. Or I'd use Venmo for payments
> between friends.
>
> On Mon, Jul 24, 2023 at 10:54 AM Chris Green  wrote:
>
> > Is there a 'right' way to handle an account which gets payments in two
> > directions?
> >
> > E.g. I have good relations with a friend and we often buy things for
> > each other and settle up at the end of the month.  Sometimes I owe the
> > friend some money, other times the friend owes me some money but it's
> > very definitely one account and one wants to see all the payments in
> > one place.
> >
> > I guess one can just say it's an 'Expense' account and make payments
> > in either direction as required, is this the only way or is there a
> > special name for such an account?
> >
> > --
> > Chris Green
> > ___
> > 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] Another try at "How to record payments for several items paid with a single transaction?"

[Steve Butler]

Enter it just as you described.  You may want to change your view to, I
think it is, Journal Mode.  I would first type in the "line" or "split" to
debit 'cash in pocket' (an asset account) for $3.49.  The next split has
the memo line 'one bar of chocolate' @$0.99.  Note that GnC would have
preloaded a credit of $3.49 which you change to $0.99. You would also type
in the appropriate Expense Account on this split.  Note that I am avoiding
the word 'enter' as you hit the tab key and not the enter key to move to
the next line.

At this point GnC should have the next split showing a credit of $2.50.
Type in the memo 'Two bags of pear drops', pick the appropriate expense
account and change the credit field to $1.50.  Hit tab again.

Now GnC has a split showing the $1.00 credit still left to make the
transaction balance.  Type the memo 'chewing gum' and pick the appropriate
expense account.  This time you don't need to change the credit field.

Check that all four splits are the way you want them.  Now hit that Enter
Key.

I always use Journal view for all my accounts so I always see all the
splits associated with each transaction.  This way I have spotted some
entries to wrong accounts and been able to fix them without changing to the
other account.

-- Steve

On Mon, Jul 24, 2023, 02:39 Chris Green  wrote:

> Maybe I should put this a different way, the answers so far don't seem
> to quite address my question, probably because I'm not describing what
> I'm trying to do.
>
> So, very simply, say I am buying sweets in a shop and I select:-
>
> One bar of chocolate0.99
> Two bags of pear drops  1.50
> Chewing gum 1.00
>
> Then I pay the shopkeeper   3.49
>
>
> I want to record this in GnuCash in a way that shows that it is a
> single transaction debiting 'cash in my pocket' and crediting
> 'shopkeeper' but I want to detail the items making up the transaction.
>
> How do I do this?
>
> --
> Chris Green
> ___
> 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] Trouble building 5.3

[Steve Butler]

First I would upgrade those 191 packages.

sudo apt update
sudo apt upgrade

Make sure everything upgradable was upgraded.

Check that you have build-essentials.

On Sat, Jul 22, 2023, 14:15 Simon Roberts 
wrote:

> Hi all, I'm looking to build GNC 5.3 on my Ubuntu 20.04 box. I did this as
> a trial run on a laptop with Ubuntu 22.04, where it went flawlessly. But,
> on this 20.04 "production" machine, the same process is failing. I don't
> want to upgrade this at this time if I can help it--it would disturb too
> many other things that are working smoothly.
>
> I did this:
>
> $ sudo apt-get build-dep gnucash
> Reading package lists... Done
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> 0 upgraded, 0 newly installed, 0 to remove and 191 not upgraded.
>
> (I'm not sure why it installed nothing, I don't think I built GNC on this
> before)
> But then when I run the cmake process with:
>
> $ cmake -DCMAKE_INSTALL_PREFIX=${HOME}/gnucash5.3 gnucash-5.3/
>
> It progresses a while before reporting:
>
> -- Checking for module 'gwenhywfar>=5.6.0'
> --   Requested 'gwenhywfar >= 5.6.0' but version of gwenhywfar is 5.1.3
> CMake Error at /usr/share/cmake-3.16/Modules/FindPkgConfig.cmake:463
> (message):
>   A required package was not found
>
> At the risk of stating the obvious, it seems I have the older version:
>
> $ sudo apt list libgwenhywfar\*
> Listing... Done
> libgwenhywfar-core-dev/focal,now 5.1.3-1build1 amd64 [installed,automatic]
> libgwenhywfar-data/focal,focal,now 5.1.3-1build1 all [installed,automatic]
> libgwenhywfar-doc/focal,focal 5.1.3-1build1 all
> libgwenhywfar79-dev/focal 5.1.3-1build1 amd64
> libgwenhywfar79/focal,now 5.1.3-1build1 amd64 [installed]
>
> And it doesn't seem that 20.04 is willing to upgrade this.
>
> Am I toast? Do I have to have Ubuntu 22.04 if I am to build this
> successfully? Or can anyone offer a workaround (e.g. is it perhaps
> practical to build the newer version of this library by hand?)
>
> Thanks for any ideas!
> Cheers,
> Simon
>
> --
> Simon Roberts
> (303) 249 3613
> ___
> 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] Income Statement versus Transaction Report

[Steve Butler]

Look on the currency tab if I remember correctly.

On Wed, Jul 19, 2023, 20:25 David Cousens  wrote:

> Fred,
>
> You may need to look at the report options for the transaction report to
> ensure
> they match the settings used for the income statement report particularly
> the
> setting for beginning and end dates and the account settings.
>
> David Cousens
>
> On Wed, 2023-07-19 at 19:26 -0700, Fred Tydeman wrote:
> > In looking at Income Statement versus Transaction Report for just
> > Income accounts for all of last year, the numbers do not match.
> >
> > My main currency is USD.  However, for this file, all the income
> > was in COP.  Now, during the year the number of COP / USD varied
> > a lot: from around 3748 to 4846; year end was 4846.
> >
> > For Report Options, I am picking:
> >Commodities: Price Source: Last up through report date.
> >
> > It appears that the Income Statement sums up all the COP
> > for the year and uses the year end COP/USD value.
> >
> > While the Transaction Report uses the month end COP/USD value
> > for the transactions in that month.
> >
> > I believe that the US tax people want foreign transaction values
> > converted to USD at the time of the transaction (not use the
> > year end COP/USD value).  So, I think the Transaction Report
> > has the correct values.
> >
> > Is there a way to have the Income Statement use values like the
> > Transaction Report?
> > ___
> > 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.

[GNC] user groups that meet in person?

[Steve Freeman]

Are there any user groups that meet in person? I'd really like to
occasionally work with others. Live in Connecticut, but travel to New York
(especially Westchester), New Jersey  and Philadelphia.

 

Steve Freeman

___
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] GnuCash 5.3 autofill headaches

[Steve Miller]

Window 11 user here.  I finally upgraded to the 5 series, 5.3 specifically.
It all works great EXCEPT the autofill on the description in the register.
I wish there was an option in the preferences to turn that OFF.

I've spent more time playing around with that than I care to remember...
things I experience with it?

If I type any letter A-T, the list of prior descriptions pops up, but if I
type a letter U-Z it freezes.

if I type gibberish really fast when I get into the description box, I can
make the gibberish appear (not that that is useful!)

But if i try to type anything else, it generally (85%) of the time, will
freeze when I get to the second letter.  Then i have to delete the entry.

I've tried re-downloading 5.3, I've tried re-starting GnuCash repeatedly,
I've rebooted, I've changed the size of window for GnuCash, so I dunno, I'm
about to go back to version 4.14 or whatever I've been using for past
several years.

I just wish there was a way to switch that "feature" off...  I can't get it
consistently, or most of the time to work.  I'm quite happy manually typing
in descriptions...
___
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] Get Quotes under Ver 4.14 v 5.0 or 5.1 or 5.2 or 5.3

[Steve Miller]

That worked perfectly. Thank you. Your brief instruction should be added to
the GnuCash help manual.

On Mon, Jun 26, 2023 at 8:58 PM David H  wrote:

> It's a perl script - basically a text file which you can open with Notepad
> if you want to look at the contents.  Run it in a command prompt window
> using perl as follows - perl "C:\Program Files
> (x86)\gnucash\bin\gnc-fq-update" - you need double quotes around the file
> path as it contains a space.
>
> On Tue, 27 Jun 2023 at 12:21, Steve Miller 
> wrote:
>
>> Ok, from searching around it appears your suggestion is indeed what I
>> need to do, eg run gnc-fq-update. In the gnucash bin directory I see a file
>> with that name, but how on earth do I run it?  It appears to just be a text
>> file.  Also, when I go to the start menu, there is no longer a folder for
>> gnucash, just the main program app so no program in there w that name, so
>> that's not helpful. I've looked in the gnucash documentation, but that
>> provides no info as to how to run/execute that file.
>>
>> On Mon, Jun 26, 2023 at 6:21 PM David H  wrote:
>>
>>> Steve,
>>>
>>> Try running C:\Program Files (x86)\gnucash\bin\gnc-fq-update, I seem to
>>> recall that fixed it for me on Windows when I initially went to version 5.0.
>>>
>>> Cheers David H.
>>>
>>>
>>> On Tue, 27 Jun 2023 at 10:21, Steve Miller <
>>> srmnonessential2...@gmail.com> wrote:
>>>
>>>> *So I'm running Windows 11, for years have used GnuCash version 4.14.
>>>> It
>>>> also shows I'm using Finance:Quote 1.53.  When I go to prices, to "Get
>>>> Quotes" and click the button, it works fine, always has, still does.*
>>>>
>>>> *BUT, when I install any GnuCash 5.0 version, the "Get Quotes" button is
>>>> grayed out, so I can't get any quotes.  If I revert to 4.14, it works
>>>> great
>>>> again.*
>>>>
>>>> *Any idea what's going on in GnuCash 5.0 and above that would cause
>>>> that?*
>>>> ___
>>>> 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] Get Quotes under Ver 4.14 v 5.0 or 5.1 or 5.2 or 5.3

[Steve Miller]

Ok, from searching around it appears your suggestion is indeed what I need
to do, eg run gnc-fq-update. In the gnucash bin directory I see a file with
that name, but how on earth do I run it?  It appears to just be a text
file.  Also, when I go to the start menu, there is no longer a folder for
gnucash, just the main program app so no program in there w that name, so
that's not helpful. I've looked in the gnucash documentation, but that
provides no info as to how to run/execute that file.

On Mon, Jun 26, 2023 at 6:21 PM David H  wrote:

> Steve,
>
> Try running C:\Program Files (x86)\gnucash\bin\gnc-fq-update, I seem to
> recall that fixed it for me on Windows when I initially went to version 5.0.
>
> Cheers David H.
>
>
> On Tue, 27 Jun 2023 at 10:21, Steve Miller 
> wrote:
>
>> *So I'm running Windows 11, for years have used GnuCash version 4.14.  It
>> also shows I'm using Finance:Quote 1.53.  When I go to prices, to "Get
>> Quotes" and click the button, it works fine, always has, still does.*
>>
>> *BUT, when I install any GnuCash 5.0 version, the "Get Quotes" button is
>> grayed out, so I can't get any quotes.  If I revert to 4.14, it works
>> great
>> again.*
>>
>> *Any idea what's going on in GnuCash 5.0 and above that would cause that?*
>> ___
>> 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] Get Quotes under Ver 4.14 v 5.0 or 5.1 or 5.2 or 5.3

[Steve Miller]

*So I'm running Windows 11, for years have used GnuCash version 4.14.  It
also shows I'm using Finance:Quote 1.53.  When I go to prices, to "Get
Quotes" and click the button, it works fine, always has, still does.*

*BUT, when I install any GnuCash 5.0 version, the "Get Quotes" button is
grayed out, so I can't get any quotes.  If I revert to 4.14, it works great
again.*

*Any idea what's going on in GnuCash 5.0 and above that would cause that?*
___
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] "Easy" way to revert to default Gnucash?

[Steve Miller]

I'm currently using Windows 11 and GnuCash 4.14.

Several years ago I installed a theme, something like leather dark, I
really don't remember which one or where I got it, it took me seemingly
forever to install it, I have zero memory of what I did.

*Is there any easy way to go back to a "clean" default install of GnuCash
using my current datafile?*
___
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] Not getting any emails

[Steve Butler]

James,  only you can determine what is important enough to warrant a backup.

However, my philosophy is that everything I put on my computer, no matter
how trivial, needs to be on a backup of some kind.

So I look for backup strategies that get everything.  That way I don't have
to worry about individual applications (OpenOffice, GnuCash, Word, Excel,
etc.).

For Ubuntu (Unix/Linux), I use the included Backup facility and grab the
entire home folder nightly  Plus I list out all the installed packages in
case I need to rebuild from a new O/S.

For Windows I use their supplied backup facility to grab all user data plus
any additional storage areas (but not the backup NAS) nightly.

Everything, including phones, tablets, laptops, is backed up to that NAS on
a nightly basis.

The NAS is copied to a large external drive on a regular basis for off site
stoage.

None of this is specific for GnuCash.  But GnuCash is included due to the
inclusive nature of my backup strategy.

I hope this is helpful to you.

On Fri, Jun 23, 2023, 09:02 James Baxter via gnucash-user <
gnucash-user@gnucash.org> wrote:

> This is James Baxter and I am not getting an updates. One thing I am
> looking at is. I was doing a backup every time I do something on my laptop.
> I need to know. Do I need to backup gnucash.
> ThanksJames Baxter
>
> Sent from Yahoo Mail on Android
> ___
> 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] from James Baxter to do with bank charge

[Steve Butler]

Hey James, maybe I am not understanding your question.  To me, this appears
to be a bank service charge of some sort.  That would be an expense to you
so you need a expense account for that other side.

Do you want to track different types of bank service charges?  Such as:
Monthly service charge.
Overdraft service charge.
Statement charge (yup my bank now charges if I get paper statements).
Wire transfer fee.

If so, set these all up as children to the Bank Fees parent expense account.

If not, just set up a single Bank service charge expense account and use
that for all the different service charges.

They are all an expense that you pay.

On Thu, May 11, 2023, 10:57 James Baxter via gnucash-user <
gnucash-user@gnucash.org> wrote:

> As I am James Baxter, email address is kangaro...@yahoo.com.  I am
> looking at the bank statement and have a bank service charge. It is not
> listen in the statement. as I must be charded for it. So when I add it to
> the line. it dont seen to work.I am looking to use the screen that said is
> there a bank interset.  I tsaid you cant send it to the same account.  it
> is coming up with credit to credit. so that dont work for me.
>
> HelpJames Baxter
> ___
> 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] ACCOUNTS tab - how to show today's balances

[Steve Butler]

Yes.



Click on the down arrow on the right side of the header line.  Choose
"Present".  You may also want "Total (Period)" if you don't close the books
each year but want Expense and Income accounts to just show current year
totals.

On Wed, May 10, 2023, 18:22 Xe Roy  wrote:

> The TOTAL column of the ACCOUNTS tab shows the balance of each account,
> including future scheduled transactions.
> Is there a way to show the total as-of today without applying future
> transactions?
>
>
> Sent from Outlook
> ___
> 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] How to upgrade to 5.1 in Ubuntu

[Steve Butler]

I have been unable to find a reliable PPA that keeps up to date.  It would
be wonderful if someone could build GnC on launchpad.

The best current solution is to compile it yourself.

On Mon, May 8, 2023, 05:29 Roland Giesler via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi all,
>
> I'm looking for some details on how to upgrade to GNUCash 5.1 on Ubuntu
> 22.04.  I installed GNUCash from the repositories (v 4.8), but the new
> version is not in the repos yet.  So, if I install manually, I'll
> probably end up having both versions installed, not?
>
> Question 1: Is there a Debian or Ubuntu repository somewhere that I
> could install from?
>
> Question 2: Failing q1 above, should I uninstall my GNUCash and then
> install from the tarball?
>
> thanks in advance for your valued responses!
>
>
> Roland
> ___
> 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] Price Quotes

[Steve Miller]

Re the price quote issue w yahoo json, in the big picture is no biggie,
cause alphaadvantage seems to work just fine, so will just switch all over
tomorrow to that source...

On Wed, Apr 19, 2023 at 7:06 PM Steve Miller 
wrote:

> Running Version: 4.14
> Build ID: 4.14+(2023-03-25)
> Finance::Quote: 1.53
>
> *Never, ever got this before... did something break???  I've changed
> nothing!  Help!  Have always used Yahoo json...*
>
> [image: Screenshot 2023-04-19 190342.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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Price Quotes

[Steve Miller]

Running Version: 4.14
Build ID: 4.14+(2023-03-25)
Finance::Quote: 1.53

*Never, ever got this before... did something break???  I've changed
nothing!  Help!  Have always used Yahoo json...*

[image: Screenshot 2023-04-19 190342.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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Uninstalled 5.0, went to 4.14 gladly

[Steve Miller]

Installed 5.0 from 4.13 on Windows. Description field kept freezing.
Couldn't download prices, told me I had an invalid install but when I went
and did the checks, said I was fine. Wouldn't work. Has always worked for
years.

Uninstalled 5.0 and 4.14 works perfectly.  Not worth the headache, remind
me next year and I'll maybe give it another whirl...
___
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.

[Steve Brown]

Hi Stan,

I read your email again.

It appears that you are you accessing the Vanguard site as a web site?
It's an OFX server. You have to send it properly formatted OFX requests
in order to get a response. The ofxget tool will do this for you. So
should aqbanking, although I haven't had much luck.

Steve 

On Thu, 2023-03-16 at 09:28 -0700, Stan Brown (using GC 2.6.19) wrote:
> 
> On 2023-03-16 09:17, Steve Brown wrote:
> > I've been using ofxget from ofxtools to download from my banks and
> > broker. So long as your bank has a functioning OFX server, it
> > should
> > work.
> > 
> > There is a website with a comprehensive list of OFX server status
> > at
> > https://www.ofxhome.com/
> 
> Like so many online lists, it seems to suffer from not being kept up
> to
> date. It includes the Vanguard group, but the URL given just gets an
> error message. As I recall, someone here posted a couple of weeks ago
> that Vanguard no longer supports OFX.
> 
> 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] Help with downloading transactions.

[Steve Brown]

The command 'ofxget prof vanguard' seems to talk to the Vanguard OFX
server. I get a profile response back.

It appears that the ofxhome site tests the ofx servers almost daily and
reports whether or not they are up.

Steve

 On Thu, 2023-03-16 at 09:28 -0700, Stan Brown (using GC 2.6.19) wrote:
> 
> On 2023-03-16 09:17, Steve Brown wrote:
> > I've been using ofxget from ofxtools to download from my banks and
> > broker. So long as your bank has a functioning OFX server, it
> > should
> > work.
> > 
> > There is a website with a comprehensive list of OFX server status
> > at
> > https://www.ofxhome.com/
> 
> Like so many online lists, it seems to suffer from not being kept up
> to
> date. It includes the Vanguard group, but the URL given just gets an
> error message. As I recall, someone here posted a couple of weeks ago
> that Vanguard no longer supports OFX.
> 
> 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] Help with downloading transactions.

[Steve Brown]

I've been using ofxget from ofxtools to download from my banks and
broker. So long as your bank has a functioning OFX server, it should
work.

There is a website with a comprehensive list of OFX server status at
https://www.ofxhome.com/

Steve

On Wed, 2023-03-15 at 20:17 -0400, Chip Reid wrote:
> This is my second post to the list and I was very pleased with how
> willing
> others were to help us new guys.  The promptness was also
> appreciated.
> 
> I think I have finally gotten far enough along to do most daily
> functions
> but I sure would like to download transactions from my bank and
> credit card
> companies.  I had been doing this for years in Quickbooks but so far,
> even
> following the available on-line information, I have not been able to
> get it
> to work.  My bank does not show up in the list for choosing the bank
> name.
> 
> Windows 10 Pro
> GNUCash 4.13
> 
> Thanks
> 
> Chip Reid
> ___
> 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] Using Plaid

[Steve Brown]

If you are referring to the file I store, it is the response from the
OFX server and doesn't contain credentials. 

If you are referring to the request, I'm using the keyring approach
referred to by Sherlock.

Steve

On Fri, 2023-03-03 at 09:43 -0600, Tom Browder wrote:
> On Fri, Mar 3, 2023 at 04:20 Steve Brown  wrote:
> 
> > I've been using ofxget to download statements from Fidelity, Wells
> > Fargo and Truist for the last several months. I made a few changes
> > so
> > it writes to a file that I import to Gnucash.
> 
> 
> How do you use (wrap) the file to protect your credentials?
> 
> -Tom
> ___
> 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] Using Plaid

[Steve Brown]

I've been using ofxget to download statements from Fidelity, Wells
Fargo and Truist for the last several months. I made a few changes so
it writes to a file that I import to Gnucash.

The ofxtools package also has support for creating billpay aggregates
however, nothing is implemented in ofxget. I added it. I've
successfully exported vendor and payment info from Gnucash and used the
modified ofxget to send billpay requests to Truist. This is really just
a very rough prototype to help me understand the issues. But, the
checks do get mailed.

BTW: "ofxget prof vanguard" shows a functioning OFX server. I'd suspect
that with the proper credentials, ofxget would happily download
statements.

Steve

On Thu, 2023-03-02 at 21:05 -0500, Kalpesh Patel wrote:
> Vanguard doesn't provide ability to download OFX formatted data as a
> download
> option but there is indirect way to get it. I have been happily
> downloading so
> using something called PocketSense which I have mentioned in the past
> here. It
> can be found here:
> https://sites.google.com/site/pocketsense/home/msmoneyfixp1. It is
> quite
> simple to setup actually and happily works with Vanguard and Fidelity
> and
> number of others financial providers. I also believe ofxget is likely
> to work
> as well although I have not tried with it. 
> 
> Sadly, I do agree that download-you-data landscape for finances in
> the US is
> just broken and likely to stay that way.
> 
> 
> --
> 
> Message: 5
> Date: Wed, 1 Mar 2023 08:26:12 -0800
> From: Jean L 
> To: Steve Brown , gnucash-user@gnucash.org
> Subject: Re: [GNC] Using Plaid
> Message-ID: <5f7b6e1c-6043-44df-033f-4c702e4eb...@gmail.com>
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> And now, vanguard apparently no longer offers OFX as a download
> option,
> just csv files. >:(
> hopefully this is temporary, but I'm not holding my breath.
> 
> The entire download-you-data landscape for finances in the US is just
> broken
> 
> Jean
> 
> On 3/1/2023 2:51 AM, Steve Brown wrote:
> > This is interesting.
> > 
> > https://www.plaidsettlement.com/
> > 
> > This prompted me to look at a Quicken OFX log after downloading
> > investment transactions from Raymond James. That log stays traffic
> > comes from
> > 
> > https://directconnect.rjf.com/eftxweb/access.ofx
> > 
> > but the traffic really comes from
> > 
> > https://services.quicken.com/ofx-secure-plus
> > 
> > Third parties collecting your bank credentials and sniffing your
> > financial traffic, what can go wrong?
> > 
> > Steve
> > 
> > On Tue, 2023-02-28 at 15:51 -0800, Jean Laroche wrote:
> > > To me it's very different.? You're not giving a user name and a
> > > password
> > > to AQBanking. I started using Plaid, then got really spooked by
> > > the
> > > fact
> > > that they do have access to your account as if they were you.
> > > Removed
> > > my
> > > account and canceled my keys.
> > > There are no current alternatives at the moment, unlike in Europe
> > > where
> > > there seem to be, I believe mandated by the EU.
> > > I wrote automated scripts to scrape my banks for the OFX files,
> > > but
> > > that's a royal pain in the butt, and it's not robust at all.
> > > 
> > > Jean
> > > 
> > > On 2/28/23 3:44 PM, Ben Pracht wrote:
> > > > ? I read that disclaimer. It says to keep the token secure and
> > > > yes,
> > > > the
> > > > bearer of that token gets access. As they said:
> > > > "The access token generated by using this tool is sensitive
> > > > material as it
> > > > grants access to your accounts. It should be handled with care
> > > > and
> > > > protected from unauthorized access. You must be sure to store
> > > > it in
> > > > such a
> > > > way that makes it impossible for others to gain access. The
> > > > creators and
> > > > maintainers of Plaid2QIF are in no way responsible if you
> > > > mishandle
> > > > your
> > > > access token."
> > > > 
> > > > GIving Plaid2QIF this token is no different than me giving a
> > > > username and
> > > > password to AQBanking, except that Plaid has a chance of
> > > > working. I
> > > > don't
> > > > like having an intermediary, in this case Plaid and Plaid2QIF,
> > > > but
> > > > OFX is
> > > > unusa

Re: [GNC] Using Plaid

[Steve Brown]

This is interesting.

https://www.plaidsettlement.com/

This prompted me to look at a Quicken OFX log after downloading
investment transactions from Raymond James. That log stays traffic
comes from 

https://directconnect.rjf.com/eftxweb/access.ofx

but the traffic really comes from

https://services.quicken.com/ofx-secure-plus

Third parties collecting your bank credentials and sniffing your
financial traffic, what can go wrong?

Steve

On Tue, 2023-02-28 at 15:51 -0800, Jean Laroche wrote:
> To me it's very different.  You're not giving a user name and a
> password 
> to AQBanking. I started using Plaid, then got really spooked by the
> fact 
> that they do have access to your account as if they were you. Removed
> my 
> account and canceled my keys.
> There are no current alternatives at the moment, unlike in Europe
> where 
> there seem to be, I believe mandated by the EU.
> I wrote automated scripts to scrape my banks for the OFX files, but 
> that's a royal pain in the butt, and it's not robust at all.
> 
> Jean
> 
> On 2/28/23 3:44 PM, Ben Pracht wrote:
> >   I read that disclaimer. It says to keep the token secure and yes,
> > the
> > bearer of that token gets access. As they said:
> > "The access token generated by using this tool is sensitive
> > material as it
> > grants access to your accounts. It should be handled with care and
> > protected from unauthorized access. You must be sure to store it in
> > such a
> > way that makes it impossible for others to gain access. The
> > creators and
> > maintainers of Plaid2QIF are in no way responsible if you mishandle
> > your
> > access token."
> > 
> > GIving Plaid2QIF this token is no different than me giving a
> > username and
> > password to AQBanking, except that Plaid has a chance of working. I
> > don't
> > like having an intermediary, in this case Plaid and Plaid2QIF, but
> > OFX is
> > unusable, and at the moment, AQBanking isn't even showing the list
> > of banks
> > anymore. Does anyone know of a US bank or credit union that uses a
> > modern
> > REST based API that they actually share with developers?
> > 
> > Regards,
> > Ben
> > 
> > On 2/22/23 23:08, john wrote:
> > 
> > On Feb 22, 2023, at 2:01 PM, Ben Pracht
> >   wrote:
> > 
> > I'd like to use Plaid with GnuCash. There is a plaid2qif project
> > that
> > claims to have been extensively tested with GnuCash and Plaid.
> > However,
> > when I created the Plaid account, it asks for either a limited
> > developer
> > account or a production account with a compliance audit. What
> > account type
> > should I use? Anything else helpful to know?
> > 
> > 
> > Neither. See
> > https://github.com/ebridges/plaid2qif/blob/master/gen-access-token/README.md
> > ,
> > 
> > Pay particular attention to the disclaimer at the bottom of that
> > page.
> > 
> > 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.
> ___
> 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

[Steve Butler]

Just copy the data file.  No export/import needed.

On Thu, Feb 16, 2023, 15:24 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.

[GNC] Vendor account number on check

[Steve Brown]

Many of my vendors are large firms. If I don't put the account number
they have assigned me on the check, they don't always apply the payment
properly.

I know I can put it in the check memo field, but I have to look it up
each time. 

Is there a recommended way to add it to the vendor record and get it
placed on the check?

Thanks,

Steve

___
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] "Nested" Expense Category Report

[Steve Cohen]

Actually it's even worse than the example shown.  Had there been no
transactions at the top level Auto, then all the subcategories would show
up without any indication that they were under the top level auto account.

On Fri, Feb 3, 2023 at 3:37 PM Steve Cohen  wrote:

> I am trying to produce a report of expenses that follows the tree
> structure of accounts under Expenses.
>
> For example, I'd like something like this:
>
> Auto  $6.50
>
> Fees
>
> $150.00
>
> Gas
>
> $250.00
>
> Parking
>
> $40.25
>
> Repair and Maintenance
>
> $2000.00
>
> Tolls
>
> $40.00
>
> Total Auto$2486.75
>
>
> Instead, I get this:
>
> Auto $6.50
> Fees $150.00
> Gas $250.00
> Parking $40.25
> Repair and Maintenance $2000.00
> Tolls $40.00
>
>
> There is no indication of the nested structure of the accounts and no
> subtotals for the group.
> How may I achieve this?
>
> I would send you the configuration I am using if I could figure out how to
> save the config as a readable file.
>
___
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] "Nested" Expense Category Report

[Steve Cohen]

I am trying to produce a report of expenses that follows the tree structure
of accounts under Expenses.

For example, I'd like something like this:

Auto  $6.50

Fees

$150.00

Gas

$250.00

Parking

$40.25

Repair and Maintenance

$2000.00

Tolls

$40.00

Total Auto$2486.75


Instead, I get this:

Auto $6.50
Fees $150.00
Gas $250.00
Parking $40.25
Repair and Maintenance $2000.00
Tolls $40.00


There is no indication of the nested structure of the accounts and no
subtotals for the group.
How may I achieve this?

I would send you the configuration I am using if I could figure out how to
save the config as a readable file.
___
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] Morgan Stanley Portfolio

[Steve Brown]

Morgan Stanley is running an OFX server. I'd see if I could get online
banking to connect with it and download that.

I haven't tried it as I don't have an account there, but I think all
the info you need to set it up is here:

https://www.ofxhome.com/index.php/institution/view/500

I was able to download the profile with ofxget from ofxtools and it
promises to support investments.

Good luck,

Steve


On Sun, 2023-01-22 at 06:29 -0500, Ed Greenberg wrote:
> I have a portfolio at Morgan Stanley which generates some dividends, 
> income, cap gains distribution, etc. All sorts of odd transactions.
> MS 
> does not offer a QFX/OFX, but only an excel download which is
> inadequate 
> for import. Near as I can tell.
> 
> Does anybody have suggestions for interacting with Morgan Stanley?
> 
> I'm considering writing a transformation program that will read the
> csv 
> and rewrite it in a more importable set of csv columns. Or just
> biting 
> the bullet and keying it all in manually.
> 
> On the other hand, what procedures have people developed to track
> just 
> the asset value of the entire portfolio and update it each month?
> 
> Thanks,
> 
> Ed Greenberg
> 
> 
> ___
> 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 csv files

[Steve Brown]

I've had very good results with this
https://github.com/erikmack/qb-escape.git

I had to back out the account code stuff in the most recent commit as
it didn't work for my use case.

The article referenced in the README was similarly helpful.

Steve

On Wed, 2023-01-18 at 19:29 -0600, 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...?
> 
> 
> Thanks,
> 
> Rudy Beuc
> 
> 
> 
> 
> 
> ___
> 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] Advice on investment accounts

[Steve Hill]

At the moment, I handle investments (e.g. my pension) as normal bank 
accounts.  At the end of each year I receive a statement and I add a 
transaction into the account such as "Interest (5.05%)" which transfers 
the interest from an Income account (or to an Expense account in the 
event of a loss).  I calculate the interest rate that I have received 
and add it into the transaction description (e.g. "5.05%" in the example 
above).


This means that I can easily see how the account has performed, 
irrespective of how much I have deposited over the year by looking at 
the % interest rate that I have noted in the description.  I can also 
see how much (in my currency, GBP) the account was worth at the end of 
each year.


I want to switch over to using Gnucash's "Mutual Fund" and "Stock" 
account types.  But there doesn't seem to be equivalent functionality:


1. Since the security isn't actually being bought/sold at the end of 
each year, the gains/losses for the year are unrealised so there won't 
be an "Interest" transfer.  I guess I could add a blank transaction to 
note down the % interest that they year's gains/losses equates to, but 
is there a better way?


2. I can't see an easy way to see what the account was worth (in GBP) at 
a specific point in the past.  I can add a "Total (GBP)" column to the 
main accounts page, which would tell me how much it is currently worth, 
but not how much it was worth in the past.  It seems that an extra 
column in the account itself showing its total value at the time of each 
transaction would be a solution, but there doesn't seem to be a way of 
doing this?


I presume this functionality is buried somewhere in reports - seems 
significantly more clunky and hard to use than it just being available 
on the account's own tab?


Many thanks.

--
- Steve
___
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 4.900 Released

[Steve Butler]

This is an experimental pre-5.0 release.  4.13 is for everyday use until
5.0 comes out.

On Wed, Jan 11, 2023, 13:11  wrote:

> I see many references to GnuCash 4.900, but the website only has version
> 4.13 (Windows).  Am I missing something here?
>
> Thank you 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] Fields present in invoices?

[Steve Brown]

Looking further, the taxinvoice report Options->Display screen allows
using an alternate template and css file. On my system,
~/.local/share/gnucash is on the search path. I put the modified and
renamed files there and they get used. This works with a standard
distribution.

Unless you want to do your own build, you are stuck with the
taxinvoice.scm file that comes with the distribution.

I now have a new default invoice that places the company and addressee
properly in my window envelopes.


On Tue, 2023-01-03 at 10:47 -0700, Simon Roberts wrote:
> Steve, Adrien, thanks again. I think I shall have a look at hacking
> the
> source for the default invoice. It's important to me to keep my
> bookkeeper's life as easy as possible during this transition.
> Fortunately,
> we have a very simple business with very few clients, and virtually
> all the
> work is the same kind of service-based thing, so I should have no
> difficulty creating a build-specific default that "just works" for
> our
> needs. Then I'll wait till some of these RFEs are acted on and the
> world
> will continue to improve :)
> 
> As a side question, Adrien, you commented that one of my replies had
> been
> delayed. I notice there seem to be two distinct (although similar)
> email
> addresses for the list:  gnucash-user@gnucash.org and
> gnucash-u...@lists.gnucash.org. Evidently they end up in the same
> place,
> but is one or other preferred?
> 
> Thanks again,
> Simon
> 
> 
> On Tue, Jan 3, 2023 at 9:44 AM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> 
> > Interesting approach concerning modifying the tax invoice.
> > 
> > I'd say all of that sounds correct to my understanding as well,
> > save I
> > think you have the Scheme—HTML bit reversed.
> > 
> > The files are in Scheme, which generate the report as an HTML
> > table.
> > (not the other way around)
> > 
> > I'm pretty sure there are already several RFE's filed, but the
> > ability
> > to set one's own default report and default spreadsheet would
> > greatly
> > enhance the reporting system and avoid hacks like re-writing an
> > existing
> > report. (entirely inaccessible to most folks)
> > 
> > Regards,
> > Adrien
> > 
> > On 1/3/23 5:03 AM, Steve Brown wrote:
> > > I've been wrestling with this too, specifically with regard to
> > > invoices. This is a rather lengthy comment. I hope it is useful.
> > > Also,
> > > if some of this is inaccurate, which is likely, please let me
> > > know.
> > > 
> > > I've looked at the wiki and sifted through the code trying to
> > > understand how reports work. There appear to be two approaches.
> > > 
> > > One uses scheme to wrap html around the report variables. These
> > > report
> > > files live in gnucash/report/reports/standard. Each has at least
> > > 3
> > > sections, one to define the report, it's location in the menu and
> > > a
> > > guid identifier, one for the options menu and one to render the
> > > report.
> > > A report file can contain several report definitions that may
> > > share the
> > > same render section. My opinion is that these files are quite
> > > opaque
> > > and very fragile.
> > > 
> > > The other and apparently newer approach has a report file that
> > > contains
> > > the same report and option sections as above, but preprocesses a
> > > html
> > > document with embedded scheme tags and a companion css file to
> > > generate
> > > scheme for the render section. The template and css files live in
> > > gnucash/report/reports/support. At this point, only 3 reports
> > > have been
> > > converted/rewritten using this approach. Only one is for
> > > invoices.
> > > 
> > > This second approach is discussed in the eguile section of the
> > > wiki but
> > > seems out of sync with the implementation. A better explanation
> > > is in
> > > the source of the preprocessor. It lives at
> > > gnucash/report/eguile.scm.
> > > 
> > > The report for printing invoices is chosen at Edit->preferences-
> > > > business->Report for printing. That is a glade screen and is
> > > > hardwired
> > > to the guids of 4 specific reports, Printable, Fancy, Easy and
> > > Tax.
> > > Only the latter uses the equile preprocessor. The first 3 are
> > > packaged
> > > in a single file, invoice.scm.
> > > 
> > > At this point, 

Re: [GNC] Fields present in invoices?

[Steve Brown]

I've been wrestling with this too, specifically with regard to
invoices. This is a rather lengthy comment. I hope it is useful. Also,
if some of this is inaccurate, which is likely, please let me know.

I've looked at the wiki and sifted through the code trying to
understand how reports work. There appear to be two approaches.

One uses scheme to wrap html around the report variables. These report
files live in gnucash/report/reports/standard. Each has at least 3
sections, one to define the report, it's location in the menu and a
guid identifier, one for the options menu and one to render the report.
A report file can contain several report definitions that may share the
same render section. My opinion is that these files are quite opaque
and very fragile.

The other and apparently newer approach has a report file that contains
the same report and option sections as above, but preprocesses a html
document with embedded scheme tags and a companion css file to generate
scheme for the render section. The template and css files live in
gnucash/report/reports/support. At this point, only 3 reports have been
converted/rewritten using this approach. Only one is for invoices.

This second approach is discussed in the eguile section of the wiki but
seems out of sync with the implementation. A better explanation is in
the source of the preprocessor. It lives at gnucash/report/eguile.scm.

The report for printing invoices is chosen at Edit->preferences-
>business->Report for printing. That is a glade screen and is hardwired
to the guids of 4 specific reports, Printable, Fancy, Easy and Tax.
Only the latter uses the equile preprocessor. The first 3 are packaged
in a single file, invoice.scm. 

At this point, I plan to modify the tax invoice to meet my needs. This
seems to be the only way the Print Invoice button on the View Invoice
screen will generate my custom invoice. 




On Mon, 2023-01-02 at 17:32 -0700, Simon Roberts wrote:
> Still working on the invoice mechanism...
> 
> Is there any control over the fields displayed, auxiliary text, and
> perhaps
> the position of fields?
> 
> When I looked up how to change the appearance of the invoice, the
> docs only
> seem to talk about adding images.
> 
> In most cases I don't need "net price", "tax" or "total price" (I
> almost
> invariably bill a single "item" on a single invoice). Similarly the
> "Action", "Quantity", "Unit price", "discount" and "taxable" fields
> are
> generally irrelevant for me.
> On the other hand it would be nice to be able to include the Job
> description.
> 
> Thanks again,
> Cheers,
> Simon
> 

___
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] Printing Invoices

[Steve Brown]

File->Print Invoice prints an opened invoice using the template at
gnucash/report/reports/standard/invoice.scm.

So does the Print Invoice button in the Find Invoice screen
And ditto the Print Invoice in the heading of the View Invoice screen

OTOH, Reports->Business->Printable Invoice just gives a "No valid
invoice selected" message. The other Reports->Business invoice reports
do the same thing.

The wiki gives some instructions to avoid this, but they don't seem to
work. 

In looking at the scheme file, this is caused by an "invoice" argument
of null being passed.

What am I missing?

I'm trying to create a custom report with 4.13



___
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] Feature request - prevent a transaction with todays date

[Steve Butler]

If I paid today and enter the transaction today it should have today's date
on it.

Especially if paid with cash.  If I wrote a check I must be ready for them
to go immediately to the bank and cash it

On Tue, Dec 27, 2022, 10:52 Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

>
>
> > If you create a bill, then entering multiple items then defaults to the
> > original date. However, once posted, the next thing to do is pay it. The
> > payment date defaults to the current date.
>
> Just pointing out again, but accounting (and gnucash) not a "real tine"
> activity. The CORRECT date to use for entering payment of a bill is when
> you made legal payment of it. Not when you got around to entering the
> transaction. The "current date" (date at the time you entered the
> transaction isn't relevant to anything, or should not be.
>
> If this seems to be persnickety, image that there are discounts for on
> time payments or late fees for late payments.
>
>
> 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.
>
___
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] Fidelity Investment

[Steve Brown]

On 12/24/2022 1:44 PM, rov...@comcast.net wrote:

Does anyone have a working configuration to download ofx file from Fidelity
Investments. I have at this point been able to sigh in to Fidelity
Investments and get a list of my accounts. I also assigned a Test bank
account in GNUcash to the fidelity account. When trying to download


I've generally had bad luck with aqbanking. I have successfully 
downloaded ofx files with ofxtools' ofxget from Fidelity and then 
imported the file.


Steve

___
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] Improvement suggestion

[Steve Butler]

Backup is a system function.  You need to plan that for all your data
beyond just GnuCash.

You can do a simple Save As to put that data in another spot.  But that
leaves your spreadsheets unprotected.

On Thu, Dec 22, 2022, 16:36 Daryl Hillgrove 
wrote:

> Can a simple backup function be added to gnucash?
>
> I am very concerned that if my computer fails I will lose all my data. I
> want to store the backup data to external storage such as a memory stick.
>
> Thanks
>
> Daryl Hillgrove
> ___
> 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] What accounts should I reconcile?

[Steve Butler]

What would it mean to reconcile an account for which there is no external
"authority"?

I can't think of one.

Now, I did reconcile the interest paid for my mortgage for the year as it
was in a dedicated account:  Expenses:Interest:Mortgage and the mortgage
company sent me a statement for my YTD interest paid.

But my Expenses:Vehicle:Fuel includes purchases from multiple places and
they won't send me a comprehensive statement for the year.

On Mon, Dec 19, 2022, 17:22 Dr. David Kirkby 
wrote:

> For simplicity assume that I havé the following two accounts, all in GBP.
>
> Assets -> Bank
> Assets > PayPal
>
> I can reconcile those, and I find the process useful.
>
> However, I noticed that it is possible to reconcile most, if not all other
> accounts. Is there any point in reconciling the other accounts, such as
>
> Expenses > Office supplies?
>
>
> Dave
> --
> Dr. David Kirkby,
> Kirkby Microwave Ltd,
> drkir...@kirkbymicrowave.co.uk
> https://www.kirkbymicrowave.co.uk/
> Telephone 01621-680100./ +44 1621 680100
>
> Registered in England & Wales, company number 08914892.
> Registered office:
> Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
> Kingdom
> ___
> 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] QIF Import troubles

[Steve Silva via gnucash-user]

 
Hi Kalpesh,
Thank you for the very thoughtful insight into this process.  I will review it 
again and see if I can get some traction.
SteveOn Thursday, December 15, 2022 at 11:30:49 AM CST, Kalpesh Patel 
 wrote:  
 
 
Steve,

  

I went through this process of converting Quicken data into GNC format in early 
2020 when Quicken 2017 got sunset and Quicken pulled the plug on able to 
connect via direct connect before moving on to subscription model. My data was 
even more messier (my earliest data file is from end-of-year copy from 1993 
that was upgraded but I believe it is even earlier when I started using it as I 
was on 3 year upgrade cycle).

  

For me it was well worth the exercise going to double entry system which gives 
me more power to generate reports then Quicken provided. Most of my 
transactions did not have “categories” (in quicken they normally were enclosed 
in square brackets in the memo field – so called quicken “transfer”) as I was 
liberally using  memos only. As it turns out that in GNC converted those memos 
into contra accounts when imported. And then use the delete account feature of 
the GNC to “re-position” account transactions to consolidate them or create 
parent-child relationship by re-parenting contra accounts – this is where a bit 
creativity comes in as its precision allows you to see how you want this set up 
for your own use; this capability does NOT exist in Quicken.

  

This is the general flow that worked great for me in case you want to give a 
try to the conversion –

  

§  Get quicken file to be error free (‘file à file operation à validate and 
repair’ and then followed by ‘file àfile operation àcopy’; did this at least 
three times and when you open it  in next iteration open the copy and perform 
the process again; review and fix transactions as necessary until at least two 
consecutive runs are error free)

§  Create year end file from the last set of cleaned up files and work with 
that to export transactions (‘file àfile operation à year-end copy’)

§  NOTE: Make sure you make a backup copy in GNC before going on to next file 
import so if imported transactions doesn’t look right then you can “roll back” 
and try import again until you get it right.

§  Export one, and only one, account to a single QIF formatted file at a time 
from the year end copy and import that single file only and iterate for all 
accounts in Quicken in this manner (this will give you opportunity to reconcile 
contra accounts if transactions do not match up as you import one account at a 
time)

· Start with the largest investment account and go down to smallest 
investment account until all are imported. (Primary Accounts à Investing and 
Retirement in Quicken; this will create the most work as you will have to 
create each security if it doesn’t exist – if you want a quick way to import 
securities then download a qfx/ofx formatted file from your broker, import 
while letting GNC bulk create securities then deleting all transaction from GNC 
so that you are only left with securities and no transactions. Do so for all 
brokerage accounts before importing very first QIF file)

· Start with the largest Bank account and go down to smallest bank 
account (Primary Accounts à Spending & Savings in Quicken)

· Start with the largest credit card account and go down to smallest 
credit card account  (Primary Accounts à Spending & Savings in Quicken)

  

 With this I was able to bring in entire history of investment transactions and 
banking account which were the most important transactions for me. Credit Card 
and etc. I started with blank with an opening balance entry and moved forward 
from there on. If there is any particular account for which you desire to have 
longer history then you can export from the pre-year end copy of the Quicken 
file as a single QIF file and import.

  

Hope this helps. 

  

--

  

Message: 4

Date: Wed, 14 Dec 2022 00:34:11 + (UTC)

From: Steve Silva 

To: "gnucash-user@gnucash.org" 

Subject: [GNC] QIF Import troubles

Message-ID: <1846355561.5252767.1670978051...@mail.yahoo.com>

Content-Type: text/plain; charset=UTF-8

  

Hi All,

I am trying out gnucash to replace Quicken.? I have Quicken convert my accounts 
into a QIF file and import that to gnucash.? The whole process seems to go well 
until I see the result.? It seems like all or most of the register entries are 
duplicated, each with a debit and credit of the same amount.? I have tried 
various permutations of exporting and importing but these split transactions 
keeps showing up.? Is there someone who has seen this issue and figured out a 
way around it?

Thanks, Steve

  

--
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/g

Re: [GNC] QIF Import troubles

[Steve Silva via gnucash-user]

 Hi All,
Thanks a lot for your input.  Based on your observations, I really don't think 
I am going to make gnucash work for me, I have nearly 30 years worth of QIF 
data files and it seems like this odd double entry method is something I can't 
control, nor can I go back through 30 years of data and try to correct it.  
Trying to get away from quicken sure is a chore and I am not going to pay for 
their program every year.  I appreciated your time.
Steve
On Wednesday, December 14, 2022 at 12:11:07 PM CST, David Carlson 
 wrote:  
 
 Hi Steve,

As Michael suggested, it is best to start with baby steps to learn how to
get good results with the import process.  If you import more than one
account at a time you risk getting duplicates if both accounts in a
transaction are in the same import.  There is a step in the import process
that attempts to detect this but it must work on one transaction at a time.

Good luck.

On Tue, Dec 13, 2022 at 7:17 PM Fross, Michael  wrote:

> Hi Steve,
>
> I was in the same situation when I first started about 7 years ago.  Read
> through the guide.  It's really well written, easy to read, and answers a
> lot of questions.
>
> As for the imports, do some tests until you get comfortable.  I would just
> export your checking account, then import that.  Figure out that
> categories are now other accounts and instead of assigning a transaction to
> a category for reporting, you debit one account and credit another.
> Understand splits and you'll be set.  It's also a great time to really
> think through your account strategy.
>
> It's really not hard, but read through the guide and you'll get it.
>
> Michael
>
> On Tue, Dec 13, 2022 at 6:52 PM Steve Butler  >
> wrote:
>
> > That is the classic double entry bookkeeping system that GnuCash uses.
> >
> > If you don't want that you need to use some other software.
> >
> > On Tue, Dec 13, 2022, 16:35 Steve Silva via gnucash-user <
> > gnucash-user@gnucash.org> wrote:
> >
> > > Hi All,
> > > I am trying out gnucash to replace Quicken.  I have Quicken convert my
> > > accounts into a QIF file and import that to gnucash.  The whole process
> > > seems to go well until I see the result.  It seems like all or most of
> > the
> > > register entries are duplicated, each with a debit and credit of the
> same
> > > amount.  I have tried various permutations of exporting and importing
> but
> > > these split transactions keeps showing up.  Is there someone who has
> seen
> > > this issue and figured out a way around it?
> > > Thanks, Steve
> > > ___
> > > 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.
>


-- 
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.
  
___
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] QIF Import troubles

[Steve Butler]

That is the classic double entry bookkeeping system that GnuCash uses.

If you don't want that you need to use some other software.

On Tue, Dec 13, 2022, 16:35 Steve Silva via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi All,
> I am trying out gnucash to replace Quicken.  I have Quicken convert my
> accounts into a QIF file and import that to gnucash.  The whole process
> seems to go well until I see the result.  It seems like all or most of the
> register entries are duplicated, each with a debit and credit of the same
> amount.  I have tried various permutations of exporting and importing but
> these split transactions keeps showing up.  Is there someone who has seen
> this issue and figured out a way around it?
> Thanks, Steve
> ___
> 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] QIF Import troubles

[Steve Silva via gnucash-user]

Hi All,
I am trying out gnucash to replace Quicken.  I have Quicken convert my accounts 
into a QIF file and import that to gnucash.  The whole process seems to go well 
until I see the result.  It seems like all or most of the register entries are 
duplicated, each with a debit and credit of the same amount.  I have tried 
various permutations of exporting and importing but these split transactions 
keeps showing up.  Is there someone who has seen this issue and figured out a 
way around it?
Thanks, Steve
___
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] Why doesn't GnuCash have an Export function?

[Steve Thompson]

Thank you, and others who posted.

So I went looking for the Gnu Cash installation files (that is 
what was installed and actually being used) and after looking at 
the 2.6 Migrating GnuCash Data for a second time, I now 
understand the *files *I need to copy over (not as bad as the 
Thunderbird migration -- since my system is beyond their 2GB 
limit). So I can make this file copy  happen within minutes 
since all my systems are connected to a file server (something 
newish that I've gotten working).


And I also had the opportunity to read the 2.5 Backing Up and 
Recovering Data. I like this!!


But cutting to the chase, I thought that since GnuCash imports 
QIF, that perhaps that should be one of the EXPORT options.


Why?  Because the CPAs that I have been involved with all ask for 
data in that format so they can more easily do our tax returns. 
(Not a fan of Quicken since they bought Parson's and destroyed 
MoneyCounts -- they did this to get the customer list long 
story ancient history now).


And I realize that Gnu Cash is "free" software, but I do 
contribute to different groups whose software I use. So as soon 
as I can get my company restarted, this is high on my list.


Regards,
Steve Thompson


On 12/4/2022 9:50 PM, Michael or Penny Novack wrote:


But, to the question, now that we have covered the problem 
that brought me to this question: Why doesn't GnuCash have an 
export functions so that one can more easily migrate from one 
computer system to another?


Because the DATA is not dependent on the computer. This is NOT 
different from other data you are moving between computers, 
even ones under different operating systems. You do not have to 
export/import, you just have to move the FILE.


You are picturing export from the gnucash data file to a file, 
move that file to another computer, import that file (into the 
gnucash data file on the new computer). You don;t have to do 
that. You just move (copy) the data file to the new 
computer.(where if the PROGRAM gnucash is installed, you can 
now open the file).


Michael D Novack




And it may be needed to migrate from Gnucash's data format to 
another system used by one's CPA. 


THAT is another matter. If what you mean is "move to the 
accountant's computer" same as another of your own IF the 
accountant willing to install gnucash to ope it. But if you 
mean move data so that it can be opened/read by another 
accounting application, yes, now an export/import pair is 
needed along with a data converter since in general a different 
data format (I mean logical format, but physical data format 
difference might also be involved). The problem is, there is no 
agreed standard for an exported general ledger that all 
accounting applications have agreed to use for export/import. 
<< what makes you think that this other application would be 
able to import the exported data without a data conversion 
step.  One specific to that pair of applications. THAT is the 
sort of thing they used to pay me to write -- "quick Mike, we 
need some data from X converted so that we can import it into 
our system >>



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.


___
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] Why doesn't GnuCash have an Export function?

[Steve Thompson]

Hi all and forgive me if this has been asked and answered before. 
I'm trying to get used to this particular list server and how it 
functions and my search didn't seem to return what I thought it 
should.


I was trying to migrate from Linux (Suse Leap 15.3) to Windows 
11. I'm being forced into this because of customers and Teams 
(which crashed my Linux system), and the lack of Adobe Acrobat 
for Linux.


I finally gave up (even though I have a file server that all my 
systems are connected to) and started from scratch on Windows, 
having to hand enter all of this years records (thankfully this 
has been a short year).


But, to the question, now that we have covered the problem that 
brought me to this question: Why doesn't GnuCash have an export 
functions so that one can more easily migrate from one computer 
system to another?


And it may be needed to migrate from Gnucash's data format to 
another system used by one's CPA.


Regards,
Steve Thompson
Indy area USA
___
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] Description list

[Steve Elstad]

In my simple mind, to do autocomplete you are looking up the entered values
in a list for a closest match.  Seems you could export that list?

Steve

-Original Message-
From: gnucash-user On Behalf Of Jeff
Sent: Wednesday, June 29, 2022 5:16 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Description list

Hi Steve,

That's a great idea, and one that I wish was there, as it's always those
seldom used ones that you can't remember what you typed it as.

It may not be possible to generate the list from within GnuCash, but you
could always export the register to Excel and remove the duplicate entries
to create your own list.

Regards,
Jeff.

On 30/6/22 10:05, Steve Elstad wrote:
> Thanks for that.  Is there a way to produce a list of all those
descriptions that I have used before?  Autocomplete is great if I am close
to spelling the description I want.  Otherwise I am just guessing and would
like to reuse a previously used description.
>
>   
>
> Steve
>
>   
>
> From: Glenn Fowler
> Sent: Wednesday, June 29, 2022 4:38 PM
> To: Steve Elstad 
> Cc: GnuCash users group 
> Subject: Re: [GNC] Description list
>
>   
>
> Hi Steve,
>
>   
>
> Your register *is* your list. Auto-complete just matches previous entries
as type.
>
>   
>
> On Wed, Jun 29, 2022 at 7:21 PM Steve Elstad mailto:st...@ngc7331.com> > wrote:
>
> Hi, is there a way to create a list of all the items I have used in 
> the Description field?  The autocompletion works if I remember the 
> description correctly.  Would like to see a list for those rarely used
ones.
>
>
>
> In the Transfer field there is a pull down list of accounts.
>
>
>
> Thanks,
>
>
>
> Steve
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> To update 
> your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>

___
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] Description list

[Steve Elstad]

Roger on that.

 

Steve

 

From: Gyle McCollam 
Sent: Wednesday, June 29, 2022 5:21 PM
To: Steve Elstad ; gnucash-user@gnucash.org
Subject: Re: [GNC] Description list

 

Steve, I should have mentioned that if you are in a particular register, it
will only look in that register.  If you are in the accounts (CoA) it will
find it in any register.

 

Thank You,   

Gyle McCollam

Gyle McCollam

 <mailto:gmccol...@gyleshomes.com> gmccol...@live.com   email

  _  

From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf of
Steve Elstad mailto:st...@ngc7331.com> >
Sent: Wednesday, June 29, 2022 8:05 PM
To: 'Glenn Fowler' mailto:gfowl...@outlook.com> >
Cc: 'GnuCash users group' mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] Description list 

 

Thanks for that.  Is there a way to produce a list of all those descriptions
that I have used before?  Autocomplete is great if I am close to spelling
the description I want.  Otherwise I am just guessing and would like to
reuse a previously used description. 

 

Steve

 

From: Glenn Fowler 
Sent: Wednesday, June 29, 2022 4:38 PM
To: Steve Elstad mailto:st...@ngc7331.com> >
Cc: GnuCash users group mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] Description list

 

Hi Steve,

 

Your register *is* your list. Auto-complete just matches previous entries as
type.

 

On Wed, Jun 29, 2022 at 7:21 PM Steve Elstad mailto:st...@ngc7331.com> > wrote:

Hi, is there a way to create a list of all the items I have used in the
Description field?  The autocompletion works if I remember the description
correctly.  Would like to see a list for those rarely used ones.



In the Transfer field there is a pull down list of accounts.  



Thanks,



Steve

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
<mailto:gnucash-user@gnucash.org> 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Description list

[Steve Elstad]

Thanks for that, as a workaround I have done a search and iterated on that
to get a pseudo list.  Was clunky and didn't end up with what I wanted.  

Steve

-Original Message-
From: gnucash-user On Behalf Of Jeff
Sent: Wednesday, June 29, 2022 5:16 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Description list

Hi Steve,

That's a great idea, and one that I wish was there, as it's always those
seldom used ones that you can't remember what you typed it as.

It may not be possible to generate the list from within GnuCash, but you
could always export the register to Excel and remove the duplicate entries
to create your own list.

Regards,
Jeff.

On 30/6/22 10:05, Steve Elstad wrote:
> Thanks for that.  Is there a way to produce a list of all those
descriptions that I have used before?  Autocomplete is great if I am close
to spelling the description I want.  Otherwise I am just guessing and would
like to reuse a previously used description.
>
>   
>
> Steve
>
>   
>
> From: Glenn Fowler
> Sent: Wednesday, June 29, 2022 4:38 PM
> To: Steve Elstad 
> Cc: GnuCash users group 
> Subject: Re: [GNC] Description list
>
>   
>
> Hi Steve,
>
>   
>
> Your register *is* your list. Auto-complete just matches previous entries
as type.
>
>   
>
> On Wed, Jun 29, 2022 at 7:21 PM Steve Elstad mailto:st...@ngc7331.com> > wrote:
>
> Hi, is there a way to create a list of all the items I have used in 
> the Description field?  The autocompletion works if I remember the 
> description correctly.  Would like to see a list for those rarely used
ones.
>
>
>
> In the Transfer field there is a pull down list of accounts.
>
>
>
> Thanks,
>
>
>
> Steve
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> To update 
> your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>

___
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] Description list

[Steve Elstad]

Thanks, that is interesting.  I migrated from Quicken end of last year and
it is one of the things I got used to with Quicken and can't find an analog
with GnuCash.  Overall GnuCash has been wonderful, and my workflow is more
efficient for my needs.  

 

Steve

 

From: Gyle McCollam 
Sent: Wednesday, June 29, 2022 5:15 PM
To: Steve Elstad ; 'Glenn Fowler' 
Cc: 'GnuCash users group' 
Subject: Re: [GNC] Description list

 

Steve,

You could use Edit/Find.  Then select Description-Contains-(type in part of
the description, can be just one letter) and if you check Match Case it will
find any descriptions that match.  It will show the same description
multiple times however.  Obviously, if it is a seldom used description it
won't show up that often.

 

Thank You,   

Gyle McCollam

Gyle McCollam

 <mailto:gmccol...@gyleshomes.com> gmccol...@live.com   email

  _  

From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf of
Steve Elstad mailto:st...@ngc7331.com> >
Sent: Wednesday, June 29, 2022 8:05 PM
To: 'Glenn Fowler' mailto:gfowl...@outlook.com> >
Cc: 'GnuCash users group' mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] Description list 

 

Thanks for that.  Is there a way to produce a list of all those descriptions
that I have used before?  Autocomplete is great if I am close to spelling
the description I want.  Otherwise I am just guessing and would like to
reuse a previously used description. 

 

Steve

 

From: Glenn Fowler 
Sent: Wednesday, June 29, 2022 4:38 PM
To: Steve Elstad mailto:st...@ngc7331.com> >
Cc: GnuCash users group mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] Description list

 

Hi Steve,

 

Your register *is* your list. Auto-complete just matches previous entries as
type.

 

On Wed, Jun 29, 2022 at 7:21 PM Steve Elstad mailto:st...@ngc7331.com> > wrote:

Hi, is there a way to create a list of all the items I have used in the
Description field?  The autocompletion works if I remember the description
correctly.  Would like to see a list for those rarely used ones.



In the Transfer field there is a pull down list of accounts.  



Thanks,



Steve

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
<mailto:gnucash-user@gnucash.org> 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Description list

[Steve Elstad]

Thanks for that.  Is there a way to produce a list of all those descriptions 
that I have used before?  Autocomplete is great if I am close to spelling the 
description I want.  Otherwise I am just guessing and would like to reuse a 
previously used description. 

 

Steve

 

From: Glenn Fowler 
Sent: Wednesday, June 29, 2022 4:38 PM
To: Steve Elstad 
Cc: GnuCash users group 
Subject: Re: [GNC] Description list

 

Hi Steve,

 

Your register *is* your list. Auto-complete just matches previous entries as 
type.

 

On Wed, Jun 29, 2022 at 7:21 PM Steve Elstad mailto:st...@ngc7331.com> > wrote:

Hi, is there a way to create a list of all the items I have used in the
Description field?  The autocompletion works if I remember the description
correctly.  Would like to see a list for those rarely used ones.



In the Transfer field there is a pull down list of accounts.  



Thanks,



Steve

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Description list

[Steve Elstad]

Hi, is there a way to create a list of all the items I have used in the
Description field?  The autocompletion works if I remember the description
correctly.  Would like to see a list for those rarely used ones.

 

In the Transfer field there is a pull down list of accounts.  

 

Thanks,

 

Steve

___
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] Quotes issue

[Steve]

On Sat, 28 May 2022 17:26:47 -0700
John Ralls  wrote:

> You're missing that the environment in your shell isn't necessarily
> the one that GnuCash sees unless you launch GnuCash from that shell.
> Enter your API key in Preferences>Online Quotes to cover that case.
> 
> Regards,
> John Ralls
> 

That was it!
Thanks,
Steve

> 
> > On May 28, 2022, at 4:42 PM, Steve  wrote:
> > 
> > When I do Tools->Price Database->Get Quotes I get:
> > 
> > ERROR: ALPHAVANTAGE_API_KEY must be set for currency and quotes.
> > See
> > https://wiki.gnucash.org/wiki/Online_Quotes/#Source_Alphavantage.-2C_US
> > 
> > and yet:
> > 
> > steve@stevesdesktop:~/Downloads$ env|grep ALPHAVANTAGE
> > ALPHAVANTAGE_API_KEY=D5IXXX
> > 
> > steve@stevesdesktop:~/Downloads$ gnc-fq-dump currency GBP USD
> > 1 GBP = 1.2630887 USD
> > 
> > steve@stevesdesktop:~/Downloads$ gnc-fq-dump yahoo_json GOOGL
> > Finance::Quote fields Gnucash uses:
> >   symbol: GOOGL<=== required
> > date: 05/27/2022   <=== recommended
> > currency: USD  <=== required
> > last: 2246.33  <=\   
> >  nav:  <=== one of these
> >price:      <=/
> > timezone:  <=== optional
> > steve@stevesdesktop:~/Downloads$ 
> > 
> > I have all my quotes set up to use yahoo_json so what am I missing?
> > 
> > Steve
> > ___
> > 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] Quotes issue

[Steve]

When I do Tools->Price Database->Get Quotes I get:

ERROR: ALPHAVANTAGE_API_KEY must be set for currency and quotes.
See
https://wiki.gnucash.org/wiki/Online_Quotes/#Source_Alphavantage.-2C_US

and yet:

steve@stevesdesktop:~/Downloads$ env|grep ALPHAVANTAGE
ALPHAVANTAGE_API_KEY=D5IXXX

steve@stevesdesktop:~/Downloads$ gnc-fq-dump currency GBP USD
1 GBP = 1.2630887 USD

steve@stevesdesktop:~/Downloads$ gnc-fq-dump yahoo_json GOOGL
Finance::Quote fields Gnucash uses:
symbol: GOOGL<=== required
  date: 05/27/2022   <=== recommended
  currency: USD  <=== required
  last: 2246.33  <=\   
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional
steve@stevesdesktop:~/Downloads$ 

I have all my quotes set up to use yahoo_json so what am I missing?

Steve
___
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] Mass Reconcile

[Steve Butler]

Do they all have the same parent?  If so, reconcile the parent and check
the box to include all sub-accounts.

On Sat, May 21, 2022, 22:17 Fred Tydeman  wrote:

> I added over 300 dummy #yymmdd accounts and am using them as tags in splits
> in transactions (to simulate Quicken classes).  I now realized that those
> splits are not reconciled.  It is a slow process to  reconcile them one by
> one.  Is there an easy way to pick many of those #yymmdd accounts and have
> them all be reconciled at once?
> ___
> 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] Reinstall GnuCash after Ubuntu upgrade to 22.04

[Steve Cohen]

I just upgraded my system to Ubuntu 22.04 (from 21.10). As a non-official
application, GNUcash seems to have been removed from the system or rendered
non-functional though a launch icon remains and does nothing.  Prior to
install, I was running GNC 4.9.

Can someone please point me in the right direction for building or
installing the best version of GNUcash on my new system?

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.

Re: [GNC] Quotes issue

[Steve]

On Sun, 17 Apr 2022 12:54:56 -0700
John Ralls  wrote:

> > On Apr 17, 2022, at 9:24 AM, john  wrote:
> > 
> > 
> >   
> >> On Apr 17, 2022, at 8:07 AM, Steve  wrote:
> >> 
> >> On Sat, 16 Apr 2022 19:48:52 -0700
> >> john  wrote:
> >>   
> >>>> On Apr 16, 2022, at 9:47 AM, Steve  wrote:
> >>>> 
> >>>> I'm getting this error:
> >>>> 
> >>>> steve@stevesdesktop:~$ gnc-fq-check
> >>>> Json3.c: loadable library and perl binaries are mismatched (got
> >>>> handshake key 0xce00080, needed 0xed00080)
> >>>> 
> >>>> But...
> >>>> steve@stevesdesktop:~$ sudo find /usr -name "libperl.so*" -exec
> >>>> ls -lah {} \; 2>/dev/null -rw-r--r-- 1 root root 3.6M Sep 24
> >>>> 2021 /usr/lib/x86_64-linux-gnu/libperl.so.5.32.1 lrwxrwxrwx 1
> >>>> root root 17 Sep 24  2021
> >>>> /usr/lib/x86_64-linux-gnu/libperl.so.5.32 -> libperl.so.5.32.1
> >>>> 
> >>>> steve@stevesdesktop:~$ perl --version
> >>>> 
> >>>> This is perl 5, version 32, subversion 1 (v5.32.1) built for
> >>>> x86_64-linux-gnu-thread-multi (with 47 registered patches, see
> >>>> perl -V for more detail)
> >>>> 
> >>>> So why does gnc-fq-check think there is a mismatch? 
> >>> 
> >>> As a first guess your perl json module is linked to a different
> >>> version of libjson than the one you have. If you used
> >>> gnc-fq-update to set up Finance::Quote then running it again
> >>> should fix the problem. If you installed F::Q from your distro's
> >>> package manager and there aren't any updates then the packager
> >>> for that module is running a bit behind, a common problem for
> >>> most distros since they rely on volunteers.
> >>>   
> >> 
> >> steve@stevesdesktop:~/Downloads$ sudo gnc-fq-update
> >> Reading '/root/.cpan/Metadata'
> >> Database was generated on Sun, 17 Apr 2022 00:17:02 GMT
> >> Date::Manip is up to date (6.86).
> >> Finance::Quote is up to date (1.51).
> >> 
> >> (update done here)
> >> 
> >> steve@stevesdesktop:~/Downloads$ sudo apt-get upgrade
> >> Reading package lists... Done
> >> Building dependency tree... Done
> >> Reading state information... Done
> >> Calculating upgrade... Done
> >> The following packages have been kept back:
> >> qdbus
> >> 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
> >> 
> >> steve@stevesdesktop:~/Downloads$ dpkg -l | egrep -i
> >> 'perl.*json|json.*perl' ii  libjson-parse-perl
> >> 0.61-1 amd64module to read
> >> JSON into a Perl variable ii  libjson-perl
> >>   4.03000-1  all  module for
> >> manipulating JSON-formatted data ii  libjson-xs-perl
> >>  4.030-1+b1 amd64
> >> module for manipulating JSON-formatted data (C/XS-accelerated)
> >> 
> >> So am I right in thinking that the 4.030 versions are the problem?
> >> If so, I'll have to contact the maintainers.  
> > 
> > Please remember to copy the list on all replies.
> > 
> > libjson-xs-perl is probably the mismatched library.  briefly
> > explains the nature of the problem. Before you can blame the Debian
> > packager (the libjson-xs-perl maintainer is innocent) for upgrading
> > perl without upgrading all of the packages you need to be sure that
> > that's the only instance of libjson-xs-perl on your system. If
> > there's another one earlier in perl's include path it might be the
> > mismatched library. Have you ever run gnc-fq-update or used cpan
> > directly  on this machine?  
> 
> 
> I forgot to paste in the URI that explains the problem. It's
> https://foursixnine.io/blog/2019/01/21/perl-binaries-are-mismatched.html
> 
Looks like you are correct:

steve@stevesdesktop:~/Downloads$ sudo find / -name "libjson-xs-perl*" 
2>/dev/null
[sudo] password for steve: 
/var/lib/dpkg/info/libjson-xs-perl.md5sums
/var/lib/dpkg/info/libjson-xs-perl.list
/var/cache/apt/archives/libjson-xs-perl_3.030-1_amd64.deb
/var/cache/apt/archives/libjson-xs-perl_4.030-1+b1_amd64.deb
/var/cache/apt/archives/libjson-xs-perl_3.040-1+b1_amd64.deb
/usr/share/doc/libjson-xs-perl

This is starting to come back to me now. IIFC, the version of perl that
came with my distribution did not have a Finance module and I ended up
with a separate version of Perl that did have Finance. I've done several
dist-upgrades since then so I'm going to delete the separate perl
version and attempt to install the Finance module from the distribution
perl.

Thanks,
Steve
___
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] Quotes issue

[Steve]

I'm getting this error:

steve@stevesdesktop:~$ gnc-fq-check
Json3.c: loadable library and perl binaries are mismatched (got handshake key 
0xce00080, needed 0xed00080)

But...
steve@stevesdesktop:~$ sudo find /usr -name "libperl.so*" -exec ls -lah {} \; 
2>/dev/null
-rw-r--r-- 1 root root 3.6M Sep 24  2021 
/usr/lib/x86_64-linux-gnu/libperl.so.5.32.1
lrwxrwxrwx 1 root root 17 Sep 24  2021 
/usr/lib/x86_64-linux-gnu/libperl.so.5.32 -> libperl.so.5.32.1

steve@stevesdesktop:~$ perl --version

This is perl 5, version 32, subversion 1 (v5.32.1) built for 
x86_64-linux-gnu-thread-multi
(with 47 registered patches, see perl -V for more detail)

So why does gnc-fq-check think there is a mismatch? 

Thanks,
Steve
___
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] create desktop icons for GNC 4.9 Flatpak on Ubuntu - solved

[Steve Butler]

Jeff,

Per chance are you on a Unix/Linux derevitive?  I have seen Windows line
endings cause problems for different shells trying to process the script.
Changing to Unix style line endings fixed the problem.  To the text editor
I was using the files appeared to be the same.

--Steve

On Mon, Apr 4, 2022, 07:16 Jeff  wrote:

>
> Geert, don't ask me how I did it because I do not know but the new icon
> now works.
>
> Just for kicks and grins I created a desktop file for LibreOffice Writer
> and it worked right the first time.  So then I edited my desktop icon
> for GNC and compared it to yours and couldn't see any differences except
> the path and data file name.  Renamed my file and copied yours into a
> text editor, changed the path and filename accordingly.  Saved it and
> right clicked the allow launching and it worked.
>
> Working version (copied and edited from your post):
>
> [Desktop Entry]
> Type=Application
> Terminal=false
> Exec=flatpak run org.gnucash.GnuCash /media/jeffrey/'Mac
> Drive'/Ledgers/Dad/Dad.gnucash
> Name=GnuCash 4.9 FLATPAK Dad
> Comment=Manage home and small business accounts
>
> Icon=/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico
>
> ==
> Non-working version:
>
> [Desktop Entry]
> Type=Application
> Terminal=false
> Exec=flatpak run org.gnucash.GnuCash /media/jeffrey/**'Mac
> Drive'/Ledgers/Dad/Dad.gnucash
> Name=GnuCash 4.9 FLATPAK Dad
> Comment=Manage home and small business accounts
> Icon=/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico
>
>
>
>
> To the naked eye they look identical but one works and the other does
> not.  Both are right clicked to allow launching.  The only difference I
> can see, now that I copied and pasted into this e-mail, is that the text
> width is different. I don't know if that has something to do with it or
> not (hidden high bit character that doesn't show up in Text Editor
> perhaps?).
>
> I then created an icon for another set of books (which works) and
> checked the permissions for both.  They are not the same.  The copy of
> yours shows a check mark in the 'Allow executing file as program', the
> second one has a '-' .  My original had a check mark too.
>
> Thank you!
>
> --
> --JEffrey Black M.B.A.
>
> On 4/2/22 11:28 AM, Geert Janssens wrote:
> > [Desktop Entry]
> > Type=Application
> > Terminal=false
> > Exec=flatpak run org.gnucash.GnuCash /home/janssege/testfile.gnucash
> > Name=GnuCash 4.9 FLATPAK Dad
> > Comment=Manage home and small business accounts
> > Icon=/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/
> > share/gnucash/pixmaps/gnucash-icon.ico
>
>
> ___
> 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] Reports No Longer Work

[Steve Isenberg via gnucash-user]

$ gtk-launch --version   results in 3.24.30
Adding WEBKIT_DISABLE_COMPOSITING_MODE=1 to .bashrc did not help 

Upgrading to version 4.10 DID help.
I usually wait a bit before I upgrade, but this time could not wait.

Thanks again and take care,Steve 
 

On Friday, April 1, 2022, 01:00:49 AM EDT, John Ralls  
wrote:  
 
 Please remember to copy the list on all replies.

I just realized that you're using flathub and GnuCash 4.9, so it's definitely 
the WebKit problem, https://bugs.gnucash.org/show_bug.cgi?id=798486. Just get 
the new 4.10 from flathub and you should be back in business.


Regards,
John Ralls

> 
> 
> On Mar 31, 2022, at 2:13 PM, Steve Isenberg  wrote:
> 
> On second thought if I did this correctly:
> 
> $ gtk-launch --version
> results in 3.24.30
> 
> 
> Steve 
> 
> 
> On Thursday, March 31, 2022, 05:09:00 PM EDT, Steve Isenberg 
>  wrote:
> 
> 
> John, thanks for writing back directly. 
> 
> Sorry, but I don't know how to check the version of webkit or set the 
> environment variable as described below. 
> 
> Can you provide some help with setting this: WEBKIT_DISABLE_COMPOSITING_MODE=1
> 
> Thanks again 
> 
> Steve
> 
> 
> On Thursday, March 31, 2022, 04:25:47 PM EDT, John Ralls  
> wrote:
> 
> 
> 
> 
> > On Mar 31, 2022, at 1:11 PM, Steve Isenberg via gnucash-user 
> >  wrote:
> > 
> > No reports work. None of my saved reports display info. Nothing from the 
> > menu displays info. Even reports I never run display nothing. 
> > 
> > Every report, saved or otherwise, displays a blank report screen. No errors 
> > or warning. 
> > 
> > System 76: Pop!_OS 21.10Gnome Version: 40.4.0
> > GnuCash Version: 4.9Build ID: Flathub 4.9-2Finance::Quote: 1.49
> > Custom report file appears correct: 
> > /home/xx/.var/app/org.gnucash.GnuCash/data/gnucash/saved-reports-2.8
> > All was working last week. There were some system updates this week, a 
> > Gnome update as well, but I cannot say what was specifically updated. 
> > Otherwise, the system is current with updates as of today.
> > 
> > It's tax time here in the states. How do I fix this ASAP?
> 
> 
> Was one of the updates for webkit2gtk-4.0 to version 2.26.0? They changed a 
> default that breaks the way GnuCash renders reports. The work-around is to 
> set WEBKIT_DISABLE_COMPOSITING_MODE=1 in the environment before running 
> GnuCash.
> 
> 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.

[GNC] Reports No Longer Work

[Steve Isenberg via gnucash-user]

No reports work. None of my saved reports display info. Nothing from the menu 
displays info. Even reports I never run display nothing. 

Every report, saved or otherwise, displays a blank report screen. No errors or 
warning. 

System 76: Pop!_OS 21.10Gnome Version: 40.4.0
GnuCash Version: 4.9Build ID: Flathub 4.9-2Finance::Quote: 1.49
Custom report file appears correct: 
/home/xx/.var/app/org.gnucash.GnuCash/data/gnucash/saved-reports-2.8
All was working last week. There were some system updates this week, a Gnome 
update as well, but I cannot say what was specifically updated. Otherwise, the 
system is current with updates as of today.

It's tax time here in the states. How do I fix this ASAP?
Thanks
Steve 
___
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] IRA/401K income detection

[Steve Butler]

I made a subaccount under the asset in which to record the distributions.
That subaccount is cleaned out each year by an adjusting transaction that
moves that to the main account.  That way the balance sheet year end report
shows the yearly distribution amount.  Makes it easy to pick off and send
to the CPA.

On Thu, Mar 10, 2022, 11:11 David G. Pickett via gnucash-user <
gnucash-user@gnucash.org> wrote:

> When I move money from an IRA or 401K account to my bank account and the
> tax man, that is all a taxable distribution, but GNUCash mostly sees a
> transfer.  How do I capture the income?
> ___
> 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] Automatic sales tax

[Steve Butler]

As soon as you dream up something that can't occur, the legislative
assistants will incorporate that scenario into new law.

On Mon, Feb 28, 2022, 09:48 Fred Bone  wrote:

> On 28 February 2022 at 10:28, William Prescott said:
>
> > Sebastian,
> >
> > Just to clarify, where the "item changed hands" may not be the seller's
> > location. I use to live just outside the border of a city that charged a
> > sales tax. When purchasing an item from a store within the city, I would
> > pay sales tax if I went into the store, purchased it, and took it home.
> > However, if I went into the store and purchased something that they then
> > delivered to my house, e.g. lumber, there was no sales tax. So the tax
> was
> > based on the delivery address not the seller's location.
>
> Out of idle curiosity ... Is it possible to dream up some complication
> that does *not* occur, somewhere?
>
> ___
> 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] Report unreliable (invalid totals)

[Steve Butler]

Look for future dated transactions.  I entered some for last December and
they ended up for next December.  Happens when entering backdated entries
in January!

On Sun, Feb 27, 2022, 15:15 David H  wrote:

> Bruce,
>
> Have you double-checked the report options to ensure all accounts are
> selected.  Also maybe try increasing the "Levels of Subaccounts" ?
>
> Cheers David H.
>
>
> On Mon, 28 Feb 2022 at 07:22, Bruce Irving  wrote:
>
> > I'm using Version: 4.9, Build ID: Flathub 4.9-2 on Peppermint 10 (Ubuntu
> > 20.04 based).
> > Looking at the liabilities section of my Balance Sheet
> > (Liabilities_2022-02-27.png); it showed 1 AP account of -90.68 totaling
> to
> > -80.68!
> > I tried running the report limiting it to only liabilities.  The rest of
> > the options, except show zero values, were the same for both reports.
> > (Liabilities_2022-27.html)  Now it shows both payees but the total is
> stil
> > $10.00!  and the Total liabilities is -43.18 for both reports.
> > 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.
>
___
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] (no subject)

[Steve Butler]

Please plan a compressive backup strategy for your entire system.  Include
email, Libre Office documents, other misc files and not just GnuCash.

That way it won't matter where files are "hidden" as you will have a
complete backup strategy that isn't specific to any particular application.

On Tue, Feb 22, 2022, 09:51 Mario Nigrovic  wrote:

> Many years ago, I had used gnucash, and was pretty happy with it. I was
> very careful to make regular backups of my data, and so, when my disk
> inevitably crashed, I was not too worried. However, I was mortified to
> discover that, although all my transaction data had been saved, all my
> custom reports were lost, as they had been stored separately in a secret
> undisclosed location, I later discovered to be elsewhere in my home
> directory.
>
> Recently, I have decided to try again to use gnucash, but I would like very
> much to ensure ALL my data is backed up. So I hit upon the idea of running
> the tool under a custom value of $HOME, but I was then shocked to discover
> that even with this method, gnucash was able to remember previous locations
> of my database file, which suggests that the tool is also using some kind
> of other mechanism to save historical data, and that makes me very nervous
> about actually being able to do proper backups of everything related to the
> tool.
> Doing some sleuthing using strace, I was able to find the previous database
> location delivered through some socket connection, and that really scares
> me, since it is now possible critical data is stored via some other Linux
> service and I will have no way to trace out where this may be to avoid
> future nasty surprises.
> I have not seen any documentation about backup strategies other than the
> aromatic saving of previous data files, yet I do see that there was data
> being stored at least in ~/.local, so I'm hoping someone on this list may
> be able to point me to some more thorough discussion of ALL the places user
> data from gnucash may be stored.
> Thanks for your help!
>
> -- Mario
>
> -- Mario
> ___
> 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] Bug 798423 - IMPORT QIF crashes on a Quicken transaction Reminder (NOT a scheduled reminder)

[Steve Conley]

I submitted this bug, which was my only "stopper" so far.

Taking import a bit at a time, but it seems to be working well.

I discovered a couple of minor issues with my entries in 26 years pf
quicken and am correcting this and restarting.

Just wanted to thank everyone again, and if I did anything wrong with the
bug submission, please let me know.

I did search Google and the bug list and did not find this bug.

Steve Conley
___
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 get debug to work (saying "uncle")

[Steve Conley]

A BIG Thanks to all who responded with clues or solutions ...
r
Geert, QUITE RIGHT about the broken -lotto.  I now have it working. "Who
would have that the only place it did not work was where the doc said it
should be ...).

I finally successfully loaded up to "about" where it died.  I am proceeding
to check the Quicken QIF and work my way slowly "over" the bug - either in
Quicken output or gnucash input.

The import seemed to do, on the surface, the 3 years I imported mostly the
correct things ... will verify and report, if anyone is interested, the
things that failed.

CURRENTLY: I still have these messages to the CONSOLE if run in a command
window.
These "seem" to be harmless bugs "so far", but someone might like to know
about them:

Gtk-Message: 11:47:04.747: Failed to load module "appmenu-gtk-module"
Gtk-Message: 11:47:05.351: Failed to load module "canberra-gtk-module"
Gtk-Message: 11:47:05.418: Failed to load module "canberra-gtk-module"
Found Finance::Quote version 1.49.

LOTS OF THESE:
(gnucash:2): Gtk-WARNING **: 11:50:59.099: Negative content width
-2147483648 (allocation -2147483648, extents 0x0) while allocating gadget
(node progress, owner GtkProgressBar)

(gnucash:2): Gtk-WARNING **: 11:50:59.099: Drawing a gadget with negative
dimensions. Did you forget to allocate a size? (node progress owner
GtkProgressBar)

(gnucash:2): Gtk-WARNING **: 11:50:59.164: Negative content width
-2147483648 (allocation -2147483648, extents 0x0) while allocating gadget
(node progress, owner GtkProgressBar)

(gnucash:2): Gtk-WARNING **: 11:50:59.165: Drawing a gadget with negative
dimensions. Did you forget to allocate a size? (node progress owner
GtkProgressBar)

Anyway, THANKS AGAIN.
Steve Conley




On Tue, Jan 18, 2022 at 2:58 AM Geert Janssens 
wrote:

> In addition to David's suggestions, here's one to get debug logs.
>
> In flatpak the log file is not generated by default (due to some internal
> conflicts in the sandbox wrt where gnucash wants to write the log file).
>
> So if you want to generate the logs add
>
> --logto=
>
> to you flatpak command.
>
> The filename can be either 'stdout' to print directly to your console
> window or any file path that's not in /tmp, for example
> "$HOME/gnucash.trace"
>
> Regards,
>
> Geert
>
> Op maandag 17 januari 2022 22:12:31 CET schreef Steve Conley:
>
> > I have been trying for 5 days now to chunk Quicken and start using
> gnucash.
>
> > ANY CLUES will be sincerely appreciated.
>
> >
>
> > The immediate problem I am trying to solve:
>
> > Quicken export to qif of accounts/categories "seems" to complete - but
>
> > nothing visible in gnucash.
>
> > Quicken export to qif of tranactions seems to work also.  (large).
>
> >
>
> > *But gnucash import of even a limited qif data to 2001, gets to the final
>
> > import stage and gnucash dies with no error.  Sometime in late QIF
> import -
>
> > before matching step.*
>
> >
>
> > Naturally I try to get a debug log but the ONLY way I was able to make
>
> > anything happen was
>
> >
>
> > (I pulled the startup command from the .desktop entry):
>
> > /usr/bin/flatpak run --branch=stable --arch=x86_64 --command=gnucash
>
> > --file-forwarding org.gnucash.GnuCash --debug
>
> > (and added --debug)
>
> >
>
> > This does not put a trace/debug file anywhere I can find. Definitely not
> in
>
> > /tmp.
>
> >
>
> > I next tried specifying the logto option with /tmp/gnucash.trace or
>
> > ~/gnucash.trace
>
> > The trace goes neither place.
>
> >
>
> > Running this:
>
> > /usr/bin/flatpak run --command=gnucash --file-forwarding
>
> > org.gnucash.GnuCash --debug gcashdata_3.gnucash
>
> >
>
> > (I had to remove the branch and arch options that are in the desktop
> entry
>
> > (which I copied from above) to even get his outputof warnings)
>
> >
>
> > and then doing the qif import, results in about 40 lines of:
>
> > (gnucash:2): Gtk-WARNING **: timestamp: Negative content width
> -2147483648
>
> >  while allocating gadget (node progress, owner GtkProgressBar)
>
> > and
>
> > (gnucash:2): Gtk-WARNING **: timestamp: Drawing a gadget with negative
>
> > dimensions. did you forget to allocate a size? (node progress, owner
>
> > GtkProgressBar)
>
> >
>
> > Whether this results in the actual crash, I have no idea.
>
> >
>
> > OTHER BACKGROUND ON WAY TO HERE ...
>
> >
>
> > Whenever gnucash is started, I get the Gtk messages as foll

[GNC] How to get debug to work (saying "uncle")

[Steve Conley]

I have been trying for 5 days now to chunk Quicken and start using gnucash.
ANY CLUES will be sincerely appreciated.

The immediate problem I am trying to solve:
Quicken export to qif of accounts/categories "seems" to complete - but
nothing visible in gnucash.
Quicken export to qif of tranactions seems to work also.  (large).

*But gnucash import of even a limited qif data to 2001, gets to the final
import stage and gnucash dies with no error.  Sometime in late QIF import -
before matching step.*

Naturally I try to get a debug log but the ONLY way I was able to make
anything happen was

(I pulled the startup command from the .desktop entry):
/usr/bin/flatpak run --branch=stable --arch=x86_64 --command=gnucash
--file-forwarding org.gnucash.GnuCash --debug
(and added --debug)

This does not put a trace/debug file anywhere I can find. Definitely not in
/tmp.

I next tried specifying the logto option with /tmp/gnucash.trace or
~/gnucash.trace
The trace goes neither place.

Running this:
/usr/bin/flatpak run --command=gnucash --file-forwarding
org.gnucash.GnuCash --debug gcashdata_3.gnucash

(I had to remove the branch and arch options that are in the desktop entry
(which I copied from above) to even get his outputof warnings)

and then doing the qif import, results in about 40 lines of:
(gnucash:2): Gtk-WARNING **: timestamp: Negative content width -2147483648
 while allocating gadget (node progress, owner GtkProgressBar)
and
(gnucash:2): Gtk-WARNING **: timestamp: Drawing a gadget with negative
dimensions. did you forget to allocate a size? (node progress, owner
GtkProgressBar)

Whether this results in the actual crash, I have no idea.

OTHER BACKGROUND ON WAY TO HERE ...

Whenever gnucash is started, I get the Gtk messages as follows:
Gtk-Message: timestamp" Failed to load module "appmenu-gtk-module"
Gtk-Message: timestamp" Failed to load module "canberra-gtk-module"
Gtk-Message: timestamp" Failed to load module "canberra-gtk-module"

I tried all manner of suggestions of loading appmenu-gtk/2/3 and
libcanberra-gtk/2/3 etcand reinstalling each. all said they were installed
and all re-installs also completed without error.
But did not get rid of the messge.

The machine is a core-i3 with 4GB of RAM and a large drive - so space
should not be an issue.
But it is an Inspiron 13 - set at 1080p resoultion.

Why GNCash ...
I like what I see and have read the pdfs of documentation and played around
with examples.
(BTW, I am a 49 year - before retiring veteran of computer science with a
PhD in Comp Sci and Electronics.  I have 6 Xubuntu Linux machines at  home
in addition to a couple of hated Win10 achines.)

So I have 23 years of history in my Quicken data.
I have run the Quicken Repair options, and they say all is well.

Quicken (latest) export to qxf crashes.So I can't try gnucash import of
qxf.

First I am running for this machine Pop!_OS versus Xubuntu as it will be my
wife's and she is better with GUI.
AND I have ordered a System76 Pop!_OS laptop to replace my failing (screen)
Dell Inspiron 15.
___
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 4.9

[Steve Mortimer]

What I did to correct my problem was to take the last backup file and 
remove all of the dates in the file name and made that my main 
(orginial) transaction file.  I opened that file as the data file and 
used it.  This corrected the issue with I was having.


Thanks everyone for your responses.
Steve


Adrien Monteleone <mailto:adrien.montele...@lusfiber.net>
Monday, January 3, 2022 8:30 PM
Your original file never changes names, unless you do a File > Save 
As, or change it via your OS file manager.


If you ever see a file with a date stamp, it is a backup. Do not try 
to open it in order to work in your main file. If you do, you are 
instead working in a backup copy and the main file never gets changed.


This new backup then becomes your current 'working copy'.

If those truncated file names contain several (not just two) time 
stamps, this means you've done this repeatedly and have now seriously 
branched your file.


If you know for certain you never worked in any previous original or 
backup file after opening a later one, just do a File > Save As on the 
currently open file with a simpler name. Then only open that file to 
start GnuCash in the future. Or better yet, if you are only using a 
single file, just open GnuCash itself. It always defaults to the last 
open file.


If you want a desktop shortcut, make it to the GnuCash app itself, not 
your file. Store that in your Documents as already suggested. 
(backups, logs, and lck files will be stored with it)


Regards,
Adrien



___
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.
Steve Mortimer <mailto:noahsark0...@att.net>
Monday, January 3, 2022 6:27 PM
Adrien,

Here is what I have found out.  Each time the program is closed it 
adds that date and time to the name of the file.  How can this be 
stopped?


I can change the name of the file so that there is only one date for 
the file name and bring it up with all of the transactions in the 
file.  I close the program and the file now has two dates showing on it.


Guess there is no original file on the computer.
Steve




--
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the man 
of God may be complete, equipped for every good work

___
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 4.9

[Steve Mortimer]

Adrien,

Here is what I have found out.  Each time the program is closed it adds 
that date and time to the name of the file.  How can this be stopped?


I can change the name of the file so that there is only one date for the 
file name and bring it up with all of the transactions in the file.  I 
close the program and the file now has two dates showing on it.


Guess there is no original file on the computer.
Steve


Steve Mortimer <mailto:noahsark0...@att.net>
Monday, January 3, 2022 5:40 PM
Thanks.  Looking into this.
Steve


Adrien Monteleone <mailto:adrien.montele...@lusfiber.net>
Monday, January 3, 2022 4:12 PM
Steve,

I'll add that it appears you are opening backup files, not the main 
GnuCash file. The very long file names indicate this. So it seems you 
have backups of backups. If you find the main file, it might not have 
all the same transactions as whatever you are currently working in.


Regards,
Adrien



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



--
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the man 
of God may be complete, equipped for every good work

___
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 4.9

[Steve Mortimer]

Thanks.  Looking into this.
Steve


Adrien Monteleone <mailto:adrien.montele...@lusfiber.net>
Monday, January 3, 2022 4:12 PM
Steve,

I'll add that it appears you are opening backup files, not the main 
GnuCash file. The very long file names indicate this. So it seems you 
have backups of backups. If you find the main file, it might not have 
all the same transactions as whatever you are currently working in.


Regards,
Adrien



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



--
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the man 
of God may be complete, equipped for every good work

___
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 4.9

[Steve Mortimer]

David,

Thanks for the information.
Steve


David Carlson <mailto:david.carlson@gmail.com>
Monday, January 3, 2022 1:32 PM
Steve,
In Windows you have a folder called Documents or similar.  Using your 
file explorer create a sub folder in Documents called "MyGnucsahData" 
or whatever you like.  Then, as the others here have said, move your  
data file there either with your file explorer or by using File > Save 
As from inside GnuCash.  Then set your GnuCash preferences using Edit 
> Preferences > Retain Log/Backup files to save them for 30 days or 7 
days, but forever would, IMHO, be too long.




--
David Carlson


--
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the man 
of God may be complete, equipped for every good work

___
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 4.9

[Steve Mortimer]

Using the File Explorer and moving the files to a GNUcash folder did the 
trick.

Thanks for every ones help.

Steve

Glenn Fowler <mailto:gfowl...@outlook.com>
Monday, January 3, 2022 1:12 PM
Just use File Explorer and move it to the folder you prefer and then 
open from new location with File > Open in GnuCash


Steve Mortimer <mailto:noahsark0...@att.net>
Monday, January 3, 2022 12:59 PM
How do I get the main program to save other than to the desktop?
Steve


Dan Black <mailto:dblack2...@outlook.com>
Monday, January 3, 2022 12:21 PM
You seem to be saving your main file on the desktop, which is not a 
good practice. The program will save a backup and a log file in the 
folder where the main file is located. In your email, you show the log 
file and lock file. The lock file should be deleted when you close the 
program.


Dan


On January 3, 2022 12:51:15 PM Steve Mortimer  
wrote:



Steve Mortimer <mailto:noahsark0...@att.net>
Monday, January 3, 2022 11:50 AM
I have been running Gnucash on this computer, Win10, for sometime now 
and have been having the same problem all along.  I have upgraded to 
version 4.9.  When I close the program there are two files that are 
not removed from the desktop and I have to go and delete the 
manually.  If I do not delete them manually after each time I close 
the program the program just keeps adding more of the same files to 
the desktop.


The files are:
1223GNUCASH.gnucash.20...0103063517.gnucash.LCK
1223GNUCASH.gnucash.201...cash.20220103114501.log

What do I need to do so these files are deleted every time the program 
is closed?


Regards,
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the 
man of God may be complete, equipped for every good work

___
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 4.9

[Steve Mortimer]

How do I get the main program to save other than to the desktop?
Steve


Dan Black <mailto:dblack2...@outlook.com>
Monday, January 3, 2022 12:21 PM
You seem to be saving your main file on the desktop, which is not a 
good practice. The program will save a backup and a log file in the 
folder where the main file is located. In your email, you show the log 
file and lock file. The lock file should be deleted when you close the 
program.


Dan


On January 3, 2022 12:51:15 PM Steve Mortimer  
wrote:



Steve Mortimer <mailto:noahsark0...@att.net>
Monday, January 3, 2022 11:50 AM
I have been running Gnucash on this computer, Win10, for sometime now 
and have been having the same problem all along.  I have upgraded to 
version 4.9.  When I close the program there are two files that are 
not removed from the desktop and I have to go and delete the 
manually.  If I do not delete them manually after each time I close 
the program the program just keeps adding more of the same files to 
the desktop.


The files are:
1223GNUCASH.gnucash.20...0103063517.gnucash.LCK
1223GNUCASH.gnucash.201...cash.20220103114501.log

What do I need to do so these files are deleted every time the program 
is closed?


Regards,
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the 
man of God may be complete, equipped for every good work


--
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the man 
of God may be complete, equipped for every good work

___
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 4.9

[Steve Mortimer]

I have closed the program either way and there is no difference.
Thanks for the prompt response.
Steve


Derek Atkins <mailto:de...@ihtfp.com>
Monday, January 3, 2022 12:12 PM
Hi,

On Mon, January 3, 2022 12:50 pm, Steve Mortimer wrote:

I have been running Gnucash on this computer, Win10, for sometime now
and have been having the same problem all along.  I have upgraded to
version 4.9.  When I close the program there are two files that are not
removed from the desktop and I have to go and delete the manually.  If I
do not delete them manually after each time I close the program the
program just keeps adding more of the same files to the desktop.

The files are:
1223GNUCASH.gnucash.20...0103063517.gnucash.LCK
1223GNUCASH.gnucash.201...cash.20220103114501.log

What do I need to do so these files are deleted every time the program
is closed?

How are you closing the program?  Are you just clicking on the [X]?  Or
are you using File -> Quit?


Regards,
Steve Mortimer
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-derek

Steve Mortimer <mailto:noahsark0...@att.net>
Monday, January 3, 2022 11:50 AM
I have been running Gnucash on this computer, Win10, for sometime now 
and have been having the same problem all along.  I have upgraded to 
version 4.9.  When I close the program there are two files that are 
not removed from the desktop and I have to go and delete the 
manually.  If I do not delete them manually after each time I close 
the program the program just keeps adding more of the same files to 
the desktop.


The files are:
1223GNUCASH.gnucash.20...0103063517.gnucash.LCK
1223GNUCASH.gnucash.201...cash.20220103114501.log

What do I need to do so these files are deleted every time the program 
is closed?


Regards,
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the 
man of God may be complete, equipped for every good work


--
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the man 
of God may be complete, equipped for every good work

___
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] GNUCash 4.9

[Steve Mortimer]

I have been running Gnucash on this computer, Win10, for sometime now 
and have been having the same problem all along.  I have upgraded to 
version 4.9.  When I close the program there are two files that are not 
removed from the desktop and I have to go and delete the manually.  If I 
do not delete them manually after each time I close the program the 
program just keeps adding more of the same files to the desktop.


The files are:
1223GNUCASH.gnucash.20...0103063517.gnucash.LCK
1223GNUCASH.gnucash.201...cash.20220103114501.log

What do I need to do so these files are deleted every time the program 
is closed?


Regards,
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the man 
of God may be complete, equipped for every good work

___
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 QFX Import

[Steve Cohen]

There do not appear to be any duplicate FITIDs here.

I ran the command

grep FITID downloaded.QFX | sort > fitid.txt

and could easily see that there were no duplicates in the 136 entries in
the file. The bank (Chase) appears to assign FITIDs of the form mmDD#
where # is a consecutive number from 0-9.  What it would do if there were
more than 10 entries isn't clear to me but that eventuality did not occur
in this file which has only 136 entries over a year.



On Wed, Dec 29, 2021 at 4:18 PM Jean Laroche  wrote:

> GC will not import an ofx transaction it thinks it already has imported.
> To determine whether a transaction has been imported GC looks at the
> FITID. So if two transactions in your OFX file have the same FITID, the
> second one won't be imported.
>
> Can you check that the transactions that are missing don't have the same
> FITID as some of the transactions that were imported?
> Some banks are not good at assigning unique FITID to transactions, and
> that can cause a problem for GC.
> Jean
>
> On 12/29/21 2:13 PM, Steve Cohen wrote:
> > Additionally, I tried exiting GnuCash and trying the import again.  This
> > made no difference.
> >
> > On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen  wrote:
> >
> >> I downloaded all of 2021's transactions from my bank in QFX format and
> >> tried to import the file.
> >>
> >> As I was doing so, I noticed an anomaly.  I receive monthly direct
> >> deposits from a pension, all arrive on or shortly after the first of
> each
> >> month, the same amount every month. But on the QFX import screen, only
> 5 of
> >> the months showed the deposit,
> >> for January, May, August, September and December.  The other seven
> months
> >> were not on the import screen. I tried sorting by date, by amount, by
> >> description - they aren't there.
> >>
> >> In an attempt to learn what was going on, I first checked my bank
> >> statements.  Was the pension not being deposited?  No, that wasn't it,
> the
> >> deposits came in every month as they were supposed to. I then opened the
> >> QFX file in a text editor to see if the deposits were listed in the QFX.
> >> They all were.  So I am trying to understand if there's a bug in the
> import
> >> function that would throw these transactions away.
> >>
> >> Here are the QFX entries from December and November. Perhaps someone
> >> looking at them can tell me why the first one was accepted and the
> second
> >> not? I see no important difference.
> >>
> >> 
> >> CREDIT
> >> 2021120112[0:GMT]
> >> 1772.79
> >> 202112010
> >> COOK COUNTY PENS PENSIONS
> >> PPD ID: 3660023021
> >> 
> >>
> >> 
> >> CREDIT
> >> 2021110112[0:GMT]
> >> 1772.79
> >> 202111010
> >> COOK COUNTY PENS PENSIONS
> >> PPD ID: 3660023021
> >> 
> >>
> > ___
> > 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] Incorrect QFX Import

[Steve Cohen]

Additionally, I tried exiting GnuCash and trying the import again.  This
made no difference.

On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen  wrote:

> I downloaded all of 2021's transactions from my bank in QFX format and
> tried to import the file.
>
> As I was doing so, I noticed an anomaly.  I receive monthly direct
> deposits from a pension, all arrive on or shortly after the first of each
> month, the same amount every month. But on the QFX import screen, only 5 of
> the months showed the deposit,
> for January, May, August, September and December.  The other seven months
> were not on the import screen. I tried sorting by date, by amount, by
> description - they aren't there.
>
> In an attempt to learn what was going on, I first checked my bank
> statements.  Was the pension not being deposited?  No, that wasn't it, the
> deposits came in every month as they were supposed to. I then opened the
> QFX file in a text editor to see if the deposits were listed in the QFX.
> They all were.  So I am trying to understand if there's a bug in the import
> function that would throw these transactions away.
>
> Here are the QFX entries from December and November. Perhaps someone
> looking at them can tell me why the first one was accepted and the second
> not? I see no important difference.
>
> 
> CREDIT
> 2021120112[0:GMT]
> 1772.79
> 202112010
> COOK COUNTY PENS PENSIONS
> PPD ID: 3660023021
> 
>
> 
> CREDIT
> 2021110112[0:GMT]
> 1772.79
> 202111010
> COOK COUNTY PENS PENSIONS
> PPD ID: 3660023021
> 
>
___
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] Incorrect QFX Import

[Steve Cohen]

I downloaded all of 2021's transactions from my bank in QFX format and
tried to import the file.

As I was doing so, I noticed an anomaly.  I receive monthly direct deposits
from a pension, all arrive on or shortly after the first of each month, the
same amount every month. But on the QFX import screen, only 5 of the months
showed the deposit,
for January, May, August, September and December.  The other seven months
were not on the import screen. I tried sorting by date, by amount, by
description - they aren't there.

In an attempt to learn what was going on, I first checked my bank
statements.  Was the pension not being deposited?  No, that wasn't it, the
deposits came in every month as they were supposed to. I then opened the
QFX file in a text editor to see if the deposits were listed in the QFX.
They all were.  So I am trying to understand if there's a bug in the import
function that would throw these transactions away.

Here are the QFX entries from December and November. Perhaps someone
looking at them can tell me why the first one was accepted and the second
not? I see no important difference.


CREDIT
2021120112[0:GMT]
1772.79
202112010
COOK COUNTY PENS PENSIONS
PPD ID: 3660023021



CREDIT
2021110112[0:GMT]
1772.79
202111010
COOK COUNTY PENS PENSIONS
PPD ID: 3660023021

___
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] Credit Card Rewards Refund

[Steve Butler]

I also record as misc. non-taxed income.  Thinking of titling a new income
account as "Rebates".

On Thu, Oct 14, 2021, 05:34 rsbrux via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I have a credit card which, like a few others, accrues a small
> percentage (1-2%) of the amounts spent as a rebate.  The rebate isn't
> subtracted from each charge, but accumulates in the card account as
> "Reward Points" until I cash them in.  The amount is then credited to
> the card account as a payment.  Should such payments be recorded as
> income or as a negative expense?
>
> ___
> 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] Credit Card Rewards Refund

[Steve Welch via gnucash-user]

One further thought:  treating rewards as a negative expense will mask the true 
cost of whatever was purchased.  If you stop using your rewards card, suddenly 
your apparent expenses will go up. 

Both professionally and personally I generally prefer to not muddy expense 
accounts with negative entries unless it really makes sense. 

Sent from my iPhone

> On Oct 14, 2021, at 8:34 AM, rsbrux via gnucash-user 
>  wrote:
> 
> I have a credit card which, like a few others, accrues a small percentage 
> (1-2%) of the amounts spent as a rebate.  The rebate isn't subtracted from 
> each charge, but accumulates in the card account as "Reward Points" until I 
> cash them in.  The amount is then credited to the card account as a payment.  
> Should such payments be recorded as income or as a negative expense?
> 
> ___
> 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] Credit Card Rewards Refund

[Steve Welch via gnucash-user]

Because the rewards aren’t necessarily attributable to any one expense (or to 
split them out proportionately would be a whole lot of work), I always book 
them to miscellaneous income.  I also include that income when I budget. 

Hope that helps,

Steve

Sent from my iPhone

> On Oct 14, 2021, at 8:34 AM, rsbrux via gnucash-user 
>  wrote:
> 
> I have a credit card which, like a few others, accrues a small percentage 
> (1-2%) of the amounts spent as a rebate.  The rebate isn't subtracted from 
> each charge, but accumulates in the card account as "Reward Points" until I 
> cash them in.  The amount is then credited to the card account as a payment.  
> Should such payments be recorded as income or as a negative expense?
> 
> ___
> 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] Budget Report Questions

[Steve Welch via gnucash-user]

Thanks Jon (& Christopher)!

Your advice was helpful - I guess I was sorta tired when I was trying to figure 
it out.  
Playing with those options did help me better understand what they do and how 
to approximate what I’m looking for.  
Hopefully I can get to a place where I can get enough of what I want so that it 
is useful.

Steve


> On Oct 10, 2021, at 9:51 PM, Jon Schewe  wrote:
> 
> Steve,
> 
> In the report options I believe you will find the following settings
> useful.
> 
> Under the display tab:
> I have Budget and Actual turned off and Difference turned on. This fits
> with my idea of envelope budgeting. You should experiment with which of
> these 3 columns you find the most useful. 
> 
> Under the general tab:
> Check "Use accumulated amounts"
> Check "Report for range of budget periods"
> Range Start: Current budget period
> Range End: Next budget period
> Check "Include collapsed periods before selected"
> Check "Include collapsed periods after selected"
> 
> Jon
> 
> On Sun, 2021-10-10 at 18:20 -0400, Steve Welch via gnucash-user wrote:
>> I apologize in advance if the answers to these questions are
>> painfully obvious.  I have tried to read the resources provided but
>> no luck so far.
>> I set up my budget with 12 periods (months) - each item is simply
>> 1/12th of the annual total.
>> What I am used to using (Moneydance, Quicken) are two basic reports:
>> 1.  Budget vs. Actual - year to date (YTD budget vs. YTD actuals)
>> 2.  Budget vs. Actual - annual (full year budget vs. YTD actuals)
>> When I view the GNC “Budget Report” it looks like I’m seeing #2
>> above.  How can I view a report that shows #1 - YTD budget vs. YTD
>> actuals?
>> Also, is there a way to collapse or hide the monthly columns so that
>> I can see the totals (far right) next to the account names?  With 12
>> months displayed, I have to constantly scroll left - right to see the
>> name and then the totals.  
>> Finally, is “Budget Report” the only one that shows budgeted figures
>> next to actuals?  I haven’t found any others but wanted to be sure.
>> 
>> Again, sorry if I’m missing something simple here.  And thanks!
>> 
>> Steve
>> ___
>> 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] Budget Report Questions

[Steve Welch via gnucash-user]

I apologize in advance if the answers to these questions are painfully obvious. 
 I have tried to read the resources provided but no luck so far.
I set up my budget with 12 periods (months) - each item is simply 1/12th of the 
annual total.
What I am used to using (Moneydance, Quicken) are two basic reports:
1.  Budget vs. Actual - year to date (YTD budget vs. YTD actuals)
2.  Budget vs. Actual - annual (full year budget vs. YTD actuals)
When I view the GNC “Budget Report” it looks like I’m seeing #2 above.  How can 
I view a report that shows #1 - YTD budget vs. YTD actuals?
Also, is there a way to collapse or hide the monthly columns so that I can see 
the totals (far right) next to the account names?  With 12 months displayed, I 
have to constantly scroll left - right to see the name and then the totals.  
Finally, is “Budget Report” the only one that shows budgeted figures next to 
actuals?  I haven’t found any others but wanted to be sure.

Again, sorry if I’m missing something simple here.  And thanks!

Steve
___
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] OFX - Citi Setup Trouble

[Steve Welch via gnucash-user]

Thanks to Kalpesh and Gyle!  I finally got it!  I assumed that because I had 
already set up my Citi account to download transactions with Moneydance and 
Quicken, that nothing further was needed on the Citi end.  Of course, that was 
wrong. 
Once I logged in and did the “Add Access” routine, I was able to get GNC to 
successfully connect and download transactions.
Now I get the joy of reconciling / resolving duplicates.

Thanks again everyone!  Hoping GNC works out as a viable option for us.

Steve

> On Oct 9, 2021, at 12:32 PM, Kalpesh Patel  wrote:
> 
> Doesn't Citi requires validation steps in States? I believe they can be found
> under "Profile" --> "More Settings" --> "App with Account Access" in their web
> portal.
> 
> 
> I had it working at one time with following settings:
> 
> -> "User Settings":
> User Name: 
> User id: 
> Client UUID: 
> 
> -> "Bank Settings":
> Bank Name: Citi Credit Card
> Broker Id: 
> FID: 24909
> ORG: Citigroup
> Server URL: https://mobilesoa.citi.com/CitiOFXInterface
> 
> -> "Application Setting":
> Emulation Application: --select--
> Application ID: QWIN
> Application Version: 200
> Header Version: 100
> 
> 
> See if any of that helps.
> 
> Kalpesh...
> 
> 
> -- Original Message --
> Received: Sat, 09 Oct 2021 10:49:38 AM EDT
> From: gnucash-user-requ...@gnucash.org
> To: gnucash-user@gnucash.org
> Subject: gnucash-user Digest, Vol 223, Issue 27
> 
>> Send gnucash-user mailing list submissions to
>>  gnucash-user@gnucash.org
>> 
>> To subscribe or unsubscribe via the World Wide Web, visit
>>  https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> or, via email, send a message with subject or body 'help' to
>>  gnucash-user-requ...@gnucash.org
>> 
>> You can reach the person managing the list at
>>  gnucash-user-ow...@gnucash.org
>> 
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of gnucash-user digest..."
>> 
>> 
>> Today's Topics:
>> 
>>   1. Re:  OFX - Citi Setup Trouble (Gyle McCollam)
>> 
>> 
>> --
>> 
>> Message: 1
>> Date: Sat, 9 Oct 2021 14:46:00 +
>> From: Gyle McCollam 
>> To: Steve Welch 
>> Cc: "gnucash-user@gnucash.org" 
>> Subject: Re: [GNC] OFX - Citi Setup Trouble
>> Message-ID:
>> 
> 
>>  
>> Content-Type: text/plain; charset="windows-1252"
>> 
>> I had a lot of trouble with Citi as well, But I got it working with the
> following settings:
>> The Server url has the following added to the end of what you see in the
> screenshot  "interface" minus the quotes so it is
> https://mobilesoa.citi.com/CitiOFXinterface.
>> 
>> The first setup screen which is not shown here has my full name in the USER
> NAME field, m Citi user ID in the USER ID field, and an internet generated
> CLIENT UID.  I don't know if the CLIENT UID is required, but I added it.  I
> don't remember if it worked without it, but I seem to remember reading
> somewhere that CITI required it.  I set this up within the last 2 weeks so the
> setting should work for
> you.[cid:2d2d11b9-a87e-46aa-8797-a0647785ca8c][cid:df7fd88f-dcee-441e-962d-49f33b375019]
>> 
>> 
>> 
>> Thank You,
>> Gyle McCollam
>> 
>> Gyle McCollam
>> 
>> 609.680.2326 Mobile
>> 
>> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
>> 
>> 
>> From: gnucash-user  on
> behalf of Steve Welch via gnucash-user 
>> Sent: Friday, October 8, 2021 8:57 PM
>> To: Gnucash-User 
>> Subject: [GNC] OFX - Citi Setup Trouble
>> 
>> Firstly, thanks to those who have offered advice already.  I am still trying
> to get my Citi credit card transactions to download and having no success.
>> I have tried what is in the Wiki, plus Colin?s suggestions and those posted
> previously by Nicholas Rood.  When I request the account list from within the
> wizard, this is the log I get:
>> 
>> 20:41:41 Sending request...
>> 20:41:41 Using GnuTLS default ciphers.
>> 20:41:41 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
>> 20:41:41 Waiting for response...
>> 20:41:41 Parsing response...
>> 20:41:41 Status for signon request: General error (Code 2000, severity
> "ERROR")
>> Error other than those specified by the remaining error codes. (Note:
> Servers 

[GNC] OFX - Citi Setup Trouble

[Steve Welch via gnucash-user]

Firstly, thanks to those who have offered advice already.  I am still trying to 
get my Citi credit card transactions to download and having no success.
I have tried what is in the Wiki, plus Colin’s suggestions and those posted 
previously by Nicholas Rood.  When I request the account list from within the 
wizard, this is the log I get:

20:41:41 Sending request...
20:41:41 Using GnuTLS default ciphers.
20:41:41 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
20:41:41 Waiting for response...
20:41:41 Parsing response...
20:41:41 Status for signon request: General error (Code 2000, severity "ERROR")
Error other than those specified by the remaining error codes. (Note: Servers 
should provide a more specific error whenever possible. Error code 2000 should 
be reserved for cases in which a more specific code is not available.)
20:41:41 Status for account info request: General error (Code 2000, severity 
"ERROR")
Error other than those specified by the remaining error codes. (Note: Servers 
should provide a more specific error whenever possible. Error code 2000 should 
be reserved for cases in which a more specific code is not available.)
20:41:41 Received account (no bank code)/(no account number) ((no bank 
name)/(no account name))
20:41:41 Operation finished, you can now close this window.

I have checked and double checked the various fields but can find no typos, etc.
I am really at an impasse and about to give up.  Because we use our credit card 
for most transactions, not having a simple, seamless download is a dealbreaker 
for our financial software.  

Any further ideas would be most welcome.

Steve
___
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 Posting Order

[Steve Butler]

Other approach is to have the payroll happen the day before (think day of
week) the allowance.

On Fri, Oct 1, 2021, 14:32 Stan Brown  wrote:

>
> On 2021-10-01 14:01, Robin Chattopadhyay wrote:
> > Is there a way to control the posting order of scheduled transactions?
> >
> > For example, I have scheduled transaction A that runs every two weeks
> > (payroll) and scheduled transaction B (kids' allowance) that runs every
> > week.
> >
> > For the bank account side of the transaction, it would be nice if the
> > deposit (from transaction A) would appear in the register before the
> > withdrawal (from transaction B).
>
> You can put something in the Num field in the Scheduled Transaction
> Editor. For instance, you could number the deposit as 1 and the
> withdrawal as 2.
>
> That's not terribly satisfactory, since every other week you will have a
> 2 but not a 1, but it's the best I know how to do.
>
> (I'm using GC 2.6.19, but I don't imagine the Scheduled Transaction
> Editor has dropped the Num field in later versions.)
>
> Another possibility is simply to let the transactions appear, and then
> assign numbers to the new posted transactions. GC will display
> transactions in Num order.
>
> --
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> https://OakRoadSystems.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.