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

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.

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/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 

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.

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.

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

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

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.

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

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

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

[Steve Butler]

Barry,

This comes down to building your chart of accounts (COA).  You would be
adding Income and/or expense accounts.  Easy to do when sitting on the
accounts tab.  The top menu bar will have entries to ADD, DELETE, or EDIT.

The user guide will also walk you through the exercise.  Give it a good
read and follow along using a test file.

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

> I am a new GnuCash user.  I successfully set up an account and imported my
> business bank account statement.
>
> In the list of transactions I was able to assign an income or expense
> category to each transaction, however there is no expense category for
> “advertising”, “consulting”, “internet” or equipment purchase. For my
> internet expenses I just used Subscriptions.
>
> Similarly, there is no income category for “sales”, so I used “Bonus”.
>
> It it possible to add new categories?  If so, how might I accomplish that?
>
> Thanks for your help.
>
> Barry G. Hall
> Director, Bellingham Research Institute
> ba...@bellinghamresearch.com
> http://www.bellinghamresearch.com 
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Switching between 2 bank accounts

[Steve Butler]

Switching in which way?  Are they not just two different accounts in your
chart of accounts?  You should be able to move funds between them as with
any other pair of accounts.

But, I presume you mean something else.

On Sun, Jan 27, 2019, 22:20 Joanne Paradise  I just finished my 2018 year end reports for my personal bank account.  I
> needed to add a 2nd bank account.  After creating the second account I
> can’t for the life of me figure out how to get back to my personal bank
> account.  Any suggestions out there?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] new to gnucash

[Steve Butler]

Sounds right to me.

Remember that Asset and Expense accounts are Debit accounts.  So Debit
increases and Credit decreases the balances in the accounts.

Liability, Income, and Equity/Capital accounts are Credit accounts.  So
Debit decreases and Credit increases the balance.

On Sat, Jan 5, 2019, 08:44 Mike Kerstetter  Hello all. I'm brand new to gnucash. I want it to do just the basics of
> keeping a register and reconciliation of a couple bank and credit card
> accounts. I had Money Sunset Deluxe and currently have Quicken (which is
> now charging a yearly subscription). I'm muddling through setting up my
> accounts and I am baffled at the seemingly backward credit and debit
> columns in the register. A deposit to my Checking (or payment to my
> credit card account) shows up under "DEBIT" and a charge to my accounts
> shows up under "CREDIT".  The balance is correct. Am I doing something
> wrong in my set-up?
>
> Thanks,
>
> Mike Kerstetter
> ___
> 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] Data entry problem

[Steve Butler]

That was a bug on certain releases that has been fixed.  You didn't
indicate what version of GnC you are using nor did you say which O/S or
hardware.  Without that info it is impossible to determine whether your
issue has been fixed or if it raised its ugly head again.

On Thu, Dec 20, 2018, 07:52 avigr...@juno.com  When I type something by mistake, my delete and backspace key do not work
> to allow me to correct the error.  How do you correct a typo in GnuCash?
> ___
> 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.