Re: [GNC] Backup Solution - Linux Desktop to Synology NAS

[Fred Bone]

On 27 September 2024 at 10:33, Chris Miller said:

[...]
> I also note that you may run into problems using rsnapshot on an NTFS
> filesystem mounted CIFS, meaning you are an SMB client. If you are
> "snapping" two files with names differentiated only by case, then these
> will collide on case insensitive filesystems, and you'll lose one of them.
> I believe that this can be changed if you perform the magical and possibly
> mythical NTFS configuration setting that preserves case sensitivity on
> Windows systems and then mount your CIFS shares on an NFS server, and then
> "reshare". 

Just to note that it's not mythical. It's a per-directory setting (which 
you can only change on an empty - normally new - directory).




___
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] Database storage

[Fred Bone]

On 19 September 2024 at 12:31, Michael or Penny Novack said:

> On 9/19/2024 11:16 AM, Roberts K wrote:
> > In my experience the amount of data is relatively small (even for
> > thousands of records)
> 
> A bit of historical perspective is needed, particularly because our 
> heads have not yet absorbed a fundamental change in technology.
> 
> Back in my working days, the IBM 3350's (hard drives) held somewhat over
> 300 mbytes each and our programs on the mainframe had about 10 mbytes core
> (the OS took about 6 mbytes from every program's virtual space.


Oooh, luxury. We 'ad 2311s that gave you 7 whole megabytes. We useter 
DREAM of having 2314s (28 Mb). 


But you'd still never have got a whole disk worth of data into the (64k) 
mainframe memory.

___
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] Monthly Reports

[Fred Bone]

On 18 September 2024 at 10:19, Phyllis Bruce said:

> These are the options I chose.  Still no report.
> 
> [image: image.png]
> [image: image.png]

I see you are restricting the report to Reconciled transactions. Is that 
what you want?


___
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] Recommendations for hosting gnucash file - Google Drive, Microsoft 365, Local server?

[Fred Bone]

On 10 September 2024 at 14:09, R Losey said:

> Well, but think about it... after the password is entered, THEN what? The
> "correct" password would have to be stored somewhere so that GnuCash could
> verify what is entered is correct, and clearly saving the password in
> clear text is not secure. Because the software is open source, anyone
> could read the steps taken to secure the password, and that would be a
> huge help in breaking the password.

Clearly you don't know anything about how password protected files are 
handled.

The password is NOT stored anywhere. It doesn't need to be. So there is 
no code taking "steps to secure the password".

The program doesn't need to "verify what is entered is correct", beyond 
attempting to use it to decrypt the data. That either works or it 
doesn't.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gnucash-user Digest, Vol 256, Issue 16

[Fred Bone]

On 08 September 2024 at 18:28, David Carlson said:

> Robert H
> 
> It isn't July anymore and you didn't condense this according to the
> directions so we do not know why you sent it.

But did you really need to quote the whole thing?

He probably did it by accident, given that (AFAICT) there was no 
additional text.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Scheduled Transaction with Currency Conversion

[Fred Bone]

On 04 September 2024 at 13:19, rsbrux said:

> We have monthly transactions where a payment in USD is credited to a CHF
> bank account. The USD amount is fixed, but the CHF amount varies depending
> on the conversion rate. As has been recommended on this list, I have
> configured these as scheduled transactions with a variable in place of the
> CHF amount .  However, when the scheduled transaction triggers in
> GnuCash, I am asked to fill in both the CHF amount *and* the USD -> CHF
> conversion rate. Unfortunately the bank notification does not include the
> conversion rate.  In fact the bank doesn't even know the conversion rate,
> because this is determined by the payor, which performs the conversion
> before the bank deposit. We don't receive any notification from the payor
> (U.S. Social Security). IMHO, it should be enough to supply *either* the
> credited amount in CHF *or* the USD -> CHF conversion rate, since GnuCash
> can calculate one from the other, but GC won't allow me to click "OK"
> without supplying the USD -> CHF conversion rate explicitly. The scheduled
> transaction template has no place to enter the conversion rate, otherwise
> I would put in a formula based on the variable CHF amount. How can I get
> the scheduled transactions to complete, without knowing the conversion
> rate?

I think I would probably go for a SX with both sides zero (assuming it 
lets you do that without insisting on a conversion ... haven't tried) and 
edit it once I had the figures.

Either that, or just duplicate an earlier txn and edit the result, 
instead of using SX.

That way, you enter *one* amount and, when prompted for the conversion, 
enter the other amount. The program calculates the ratio for you.

___
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] Missing Digests?

[Fred Bone]

On 08 August 2024 at 13:46, Derek Atkins said:

> Hi,
> 
> Have you checked the archives to see if there were actually messages you
> missed?  The traffic has been pretty low the last couple days due to the
> DNS Signature Expiration.

Well, yes. In any case if there are no messages, the digestifier surely 
doesn't just skip an issue number.

Issue 5 contained two messages from John Ralls, both with Subject: 
Consistent way to hang Gnucash, dated 3 Aug and timed 12:49 and 12:54 
EDT.

Issue 9, the next I received, contained one message, from Alan Johnson, 
Subject: Fund management without an actual account, dated 6 Aug and timed 
09:54 MDT. There are about 25 message in between that were perhaps in 
Digests 6, 7 and 8.

Issue 12 contains one message, from Liz (Dodd), Subject: Fund management 
without an actual account, dated 5 Aug and timed 13:32 +1000. This is in 
the archive much earlier than the previously-noted message; I assume it 
was delayed reaching the mailing list (and the archive of course lists 
messages in their "sent" order).

I assume that "DNS signature expiration" refers to the 4 messages about 
"Unable to access Gnucash website" which would presumably have been 
circulated in one of the Digests I haven't received (issue 10 or 11).

So, evidently, the answer to my original question is that yes, something 
has been amiss.

.. F


___
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] Missing Digests?

[Fred Bone]

Hi,

I am subscribed to receive Digests. Is there something amiss with them? 
Of the current volume 257, I seem to have received numbers 1-5, 9 and now 
12.

I do not have any spam checking in place that would delete messages 
unseen, and the missing Digests are not in the spam folder. I conclude 
that they have not made it as far as my ISP's mail system.

.. F

___
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 getting worse?

[Fred Bone]

On 20 July 2024 at 6:19, Nate Bargmann said:

[...]
> Already GNC's column layout is opposite of the
> manual check registers I've been using for 40+ years and that leads to
> mistakes in one or the other for me so the last thing that is needed is
> more ambiguity.

Eh? I was brought up to believe that "debits on the left, credits on the 
right" has been an accounting standard since Adam was a lad.


___
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] Exchange rate fluctuation changes historic amounts in P&L and BS

[Fred Bone]

On 29 June 2024 at 22:05, G R Hewitt said:

> Hello Everyone,
> 
> Basics:
> GnuCash 5.6; MacOS High Sierra 10.13.6
> Using Sterling as the base currency and Euros.
> 
> The problem:
> A few days ago I bought something in euros (€150) and paid for it in
> sterling (£132.27) and the GnuCash system worked out that the rate was
> 0.8818. In the P&L the item was properly shown as £132.27. The card
> account payment showed £132.27 and the euro expense account showed
> €150.00. All well and good.
> 
> I bought something else a few days later in the same manner as above, but
> the exchange rate had changed, all well and good too - card account and
> expense account transactions were correct.
> 
> On running the P&L I noted that the £132.27 of the first transaction
> above was now less at around £128 and some pence instead of the expected
> £132.27. I checked the card account and it was still at £132.27 and the
> euro account was still at €150.
> 
> Why is this and is there a way to have the correct figures shown in the
> P&L without them jumping up and down as the rate changes.

Why? Because the P&L is a (re-)valuation at a specific date (e.g. 
"today") and there's been an unrealised loss on your asset - the €150 is 
now worth only £128+ whereas you paid £132.27 for it, and you haven't 
accounted for this. (Of course, if the Euro subsequently rises enough 
against sterling this might even be reversed and become a gain.)

Consider what happens if what you bought was actual euros (such as in 
preparation for a trip to France). They cost you £132+. If you bought 
them today instead, they'd cost you £128+. You made a £4(+-) loss by 
buying too soon. That's what the P&L is telling you.

The figures ARE correct, at least insofar as you have informed 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Balance sheet totals showing zeros?

[Fred Bone]

On 28 June 2024 at 16:34, Ken McEvoy said:

> I am the treasurer of a small nonprofit, and I have no
> accounting background, and a I'm also a beginner with gnucash ...
> 
> We have a very simple set of accounts; single currency, only a few income
> and expense categories.
> 
> When I run a balance sheet report, the subtotals show accurate amounts,
> but the totals for Assets, Liabilities and Equity are all zero.
> 
> Can you help me understand what I might have done, or why the major totals
> are all zero?

It looks as though your assets are in one currency (C$) and the book in 
another ($) with no conversion rate provided.

___
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] GNU cash error - cannot retreive stock price

[Fred Bone]

On 20 June 2024 at 17:48, Emilio Lopez said:

> Hello
> 
> When I try to retreive the stocks price, I get this error message:
> 
> [image: image.png]
> 
> The translation from Spanish would be: error while retrieving the price:
> Finance Error: unknown quote.
> 
> Looking into the file BVB.pm, this is the content referring to line 92:
> 
> 
> [image: image.png]
> 
> Could you support me to fix this error? at the moment I cannot download
> the prices which is one of the best features of the software.

This appears to be a failure in attempting to parse an HTML page returned 
by a query to a price server. As you haven't provided any information on 
where the page came from, it's impossible to say for sure, but my guess 
would be that the server has been reconfigured and the pages don't look 
they way they used to. In that case you need to get the parsing code 
rewritten to match the new page layout.

___
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] Error Importing Quicken Files Mac OSX

[Fred Bone]

On 20 June 2024 at 11:50, Jim Johnson said:

[...]
> I have been looking for GnuCash 5.5 (5.6 is the current one on the
> website) but was unable to find it on the website.
> 
> Does anyone have any ideas?

If you follow the link "More downloads" (4th bullet-point under "Download 
GnuCash 5.6") the bottom link on the resulting page is "View all GnuCash 
downloads" giving 
https://sourceforge.net/projects/gnucash/files/
which should get you what you want


___
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] Default Transaction Date and Duplicate

[Fred Bone]

On 08 June 2024 at 15:03, Dale Alspach said:

> If I directly enter a transaction in a register, the default date for that
> register gets reset to the date of the newly entered transaction. If I use
> "duplicate" to create a new transaction, the default date is not reset.
> Why?

What do you mean by "default"?

I wouldn't expect the blank txn to change just because I duplicate 
something else. And when I modify the blank txn and commit it, I expect 
the new blank txn to inherit whatever date I'd committed with.

FWIW, I'm on 2.6.21.

___
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] Delete acct + move txns - can't specify acct

[Fred Bone]

On 03 June 2024 at 8:17, Derek Atkins said:

> I presume the accounts have the same currency?
> I honestly do not recall what algorithm is used to choose options there.

Some experimenting (2.6.21, but it doesn't strike me as the sort of thing 
that would have changed) it appears to restrict to the same Account Type. 
If I try to delete a "Bank" account under Assets, it offers all the other 
Bank accounts (including the Orphan and Imbalance ones). For a Cash 
account it offers all the Cash accounts.

Obviously not exhaustive testing but might help.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance Quotes Yahoo off the rails again?

[Fred Bone]

On 26 March 2024 at 16:23, David G. Pickett said:

[lots of stuff, so badly formatted as to be unreadable]

PLEASE TRIM QUOTES

___
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] Finance Quotes Yahoo off the rails again?

[Fred Bone]

On 25 March 2024 at 4:13, David G. Pickett said:

>  Wow, the mail handler seems to hate ascii text!  Is it a side effect of
>  html email?
> 
> I keep forgetting that to run stuff installed by flatpak you need flatpak
> magic like this: flatpak run --command=gnucash-cli org.gnucash.GnuCash -Q
> dump xxx yyy
> 
> What are the valid source codes?

What is your reason for quoting the whole of your original message, not 
just once but twice?

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

[Fred Bone]

On 19 March 2024 at 16:08, J. A. Harris said:

[...]
> (I have been repurposing currencies and do not
> know how many times I have had to stop and figure out what "XTS",  "XXX"
> or "AMD" actually represented.  Certainly any report I generate will be
> confusing to anyone who will not know how I am using those currencies.)

So why not change the "display symbol" to something meaningful?

___
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-user Digest, Vol 252, Issue 33

[Fred Bone]

On 17 March 2024 at 22:47, Anon20x said:

> Hi,
> 
> Will you please unsub me from the mailing list, thankyou!

Have you thought of following the instructions?

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



___
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] Error Retrieving Gold Price for Price Database

[Fred Bone]

On 09 March 2024 at 16:35, john said:

> XAU is a currency because ISO 4217 says it is, along with XBA (silver),

Precious metals are coded as X followed by the relevant chemical symbol, 
so silver is XAG


___
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] Removing Scheduled Transaction From a Closed Year

[Fred Bone]

On 25 February 2024 at 10:43, David H said:

[...]
> But for the odd time that you don't want the Scheduled txns created,
> granted rare, there's no way currently to say, no just this once please
> don't create them.  I've been in this situation myself but can't remember
> exactly why or what I screwed up at the time.
> 
> You can't change the existing preference to "No" until you've opened your
> data file and by then the scheduled txns have already been created.
> Thinking about it further I suppose you could fairly easily delete them
> from the Created Txns tab if you also have the "Review created
> transactions" preference checked on?
> 
> At the moment on startup there's no way to prevent the scheduled txns
> being created if the preference is set to on, it just happens and is
> unstoppable.

Not so.

The preference is at user level, not file level. All you need do is open 
an empty file, change the preference, then open the desired file.

At least, that's true of 2.6.21; I doubt it's changed.


___
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] Start and End of Quarter Dates Incorrect - a Bug?

[Fred Bone]

On 11 February 2024 at 16:15, Jay McSkimming said:

> GnC 5.5
> Mac OS Sonoma 14.2.1
> 
> Running a PNL for previous quarter, the report runs for incorrect dates
> namely starting a month early and ending a month early.  Similar results
> for Cash Flow, Income etc.
> 
> Seems to me that there’s a bug in calculating these dates correctly. 
> Runs correctly if dates are manually entered but that defeats the purpose
> of the system variables.
> 
> I’ve set absolute dates for Start and End of Accounting Period as below
> as that suits what I’m doing currently but makes no difference if it is
> the current FYE 30-6-2024. 

Perhaps you need to move to a different timezone ...


___
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] New user error (was: gnucash-user Digest, Vol 251, Issue 12)

[Fred Bone]

On 07 February 2024 at 22:17, sunfis...@yahoo.com said:

> Agreed. 
> 
> ⁣David T. 

followed by 15k of someone else's message including quotes about six  
levels deep featuring the whole of a messaage digest.

Please trim 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Change Printed Invoice

[Fred Bone]

On 06 February 2024 at 9:27, Glenn Fowler said:

> You can edit invoice.scm and replace "Invoice" with "Tax Invoice". All
> invoices after will say "Tax Invoice".

... which no doubt contravenes the law if the invoice is NOT over 1000 ...

> On Tue, Feb 6, 2024 at 2:42 AM Lester Bennett 
> wrote:
> 
> > Apparently Australian Tax Law requires an invoice over AU$1000 to be
> > titled Tax Invoice. How can I change the  default first line of a
> > printable invoice to read "Tax Invoice #"? At present I save to a pdf
> > then edit it with a pdf editor but it would be simpler to have it read
> > correctly from the start.
> >
> >
> > --
> > This email has been checked for viruses by Avast antivirus software.
> > www.avast.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] SX

[Fred Bone]

On 31 January 2024 at 9:17, Stan Brown (using GC 4.14) said:

> On 2024-01-31 06:27, Gyle McCollam wrote:
> > IIRC the calendar in SX used to show what transactions were due on each
> > day when you moved the mouse to a date in the calendar, but it doesn't
> > do that anymore.  Is that correct or am I remembering wrong?  It doesn't
> > do that anymore.
> 
> In 4.14 I found I have to click once on a date; just hovering isn't
> enough. Maybe it's the same in whatever version you're running?

With 2.6.21, I find I have to click once (more or less anywhere in the 
calendar area, including the margins), after which hovering produces the 
relevant day's data.


___
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] Template Transactions Behavior in Scheduled Transaction Editor

[Fred Bone]

On 12 January 2024 at 23:36, Adrien Monteleone said:

> That's moving beyond Scheduled Transactions and into a more general case
> of Templates. I'm pretty sure I've already filed an RFE for that long ago.
> 
> I see Scheduled Transactions as a special use case of Templates, though
> Scheduled was implemented first.
> 
> The more general Template case is when you definitely want to re-enter the
> format of a transaction (which may or may not be complicated) but you
> don't want to do so on a set periodic basis.

Which is of course simple enough to achieve. Just set your SX to "once", 
and when you want to run it change its date to "today".



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Two questions

[Fred Bone]

On 08 January 2024 at 16:35, Barry Mahon said:

[...]
> 2. I subdivided an a/c to create a 2024 version, using the latest bank
> account balance as the opening balance. All Ok, but the entries are in
> red I cannot find in the help how to change that.

This probably indicates you have the wrong account type. For example, if 
I change a savings account to "liability", the running totals show in 
red.

Check the account type of the new one against the old.


___
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 getting worse?

[Fred Bone]

On 28 December 2023 at 11:05, R Losey said:

[...]
> Since I've been on this mailing list (much less time than I've been using
> GnuCash), I have always waited and watched this list for experiences with
> the new version; it was thanks to this list that I heard about the extra
> process problem with 5.4 and the Scheduled Transaction issue with 5.5.
> 
> I supposed the best way to beta test new versions would be to create a VM
> and play with it there; I wouldn't want to corrupt my good working copy or
> financial records.

The other approach is PortableApps. The current GnuCash Portable is 5.4. 
Y

___
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] Nice to Have?

[Fred Bone]

On 14 December 2023 at 14:09, David Carlson said:

> Grace,
> 
> Please remember to reply to the list.
> 
> I am not sure how to respond to your specific issue,  other users may be
> able to help.
> 
> 
> 
> On Thu, Dec 14, 2023, 2:02 PM Grace  wrote:
> 
> > All of my scheduled transaction are set to "create 1 day in advance",
> > but when the window pops up, *all* of the scheduled transactions are in
> > the list. Only the ones due today have the split display on them. The
> > "remind me" are set to zero days. So when the window pops up I would
> > like to see only Test Scheduled Transaction.
> >
> > The Car Insurance scheduled transaction has "remind me" set to 1, while
> > all the others "remind me" is not selected.
> >
> > Oh!, and if you select cancel, it still adds the transaction.

If you have the txn set to "create automatically" then it has already 
been created by the time the Since-Last-Run display is produced. You can 
see it is marked "Created". "Cancel" won't change that, it's too late.

If you don't want that to happen then uncheck "create automatically". 
Then you'll get a chance to decide what you want to do with it, and 
"cancel" does what you appear to want.


___
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] GNU Cash not performing math functions correctly on entry [SOLVED]

[Fred Bone]

On 01 December 2023 at 9:56, Fred Tydeman said:

> In GC of 4.14 using Automatic Decimal,  1/3 gets 0.33, while 1./3 gets
> 33.33

That figures.

Arguably it's correct. With "automatic decimal" active, the first of 
those means "0.01/0.03" and the second means "1/0.03"

Just that people don;t expect 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.

Re: [GNC] GNU Cash not performing math functions correctly on entry [SOLVED]

[Fred Bone]

On 01 December 2023 at 0:27, Adrien Monteleone said:

> It is working fine here on MacOS and Linux Mint.
> 
> Can you replicate it with a fresh test book using all default settings?

I can readily replicate it on my copy of 2.6.21:

1. Check the "automatic decimal point" setting (with 2dp)
2. Enter "2.40/6" into a suitable box
3. Result is "40.00"
4. Uncheck
5. Repeat 2
6. Result is "0.40"

I conclude that no-one is using the "automatic decimal point" setting who 
also uses the arithmetic-expressions feature, otherwise this would have 
been noticed before now. 2.6.21 has been around for quite a while 
(2018-04-10)


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Setting up an account for stocks

[Fred Bone]

Please copy the list on replies. For one thing, this gives other people 
the chance to come in and help: you could have had further suggestions 
well before I got to see your message.

On 28 November 2023 at 11:41, Max Hilbig said:

> Hi Fred,
> 
> Thanks for your response.
> 
> My first email was a bit incomplete so I will outline my steps from the
> beginning. My reference to the guide below is to the Tutorial and Concept
> Guide available from the Help menu of GnuCash.

[...]
> 3. This displayed the "Select security" dialog box. This I note is also
> different to the Guide Figure 9.7 and I have no Idea what is meant by
> Namespace (see Shot 3). Clicking on the down arrow next to Namespace only
> displays "All non-currency" and the down arrow along side of Security did
> nothing.
> 
> 4. Clicking the New button in the Select security dialog box displayed the
> New security dialog box as shown in shot 4. This also differs form the
> Guide figure 9.8 but I filled it out as shown in shot 4 and this is where
> I could go no further as the bottom half under Quote Source Information is
> greyed out . But it does display the Warning "Finance:Quote not installed
> properly". I have not been able to find any information about this to
> date.
> 
> So I hope you can shed light on my problem. Your input is most welcome.

You need to create a security before you can link it to an account. 
Please read the Tutorial and the Help on creating securities.

The reason you can't complete adding the security isn't because you 
haven't installed Finance:Quote, it's because you've left Namespace blank 
(I think).

I'm on an earlier version but in the one I have you can't leave Namespace 
blank. Mine defaults to AMEX (no idea why, unless because it's first 
alphabetically) but as the Help says you can put anything you like if the 
security you're interested in isn't one of the predefined ones 
(apparently your version doesn't have any predefined).


___
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] Setting up an account for stocks

[Fred Bone]

On 27 November 2023 at 16:38, Max Hilbig said:

> Hi,
> 
> I am a newcomer to GnuCash and finding my way around this application.
> Having set up various Assets, Equity, Expenses and Income accounts I am
> now exploring the Stocks part of this application and have run into a
> brick wall. I have tried to get help from the FAQ area but not found an
> answer to my problem and am trying the User Mailing List. I hope this is
> OK.
> 
> My GnuCash version is 5.4 and Build 5.4+(2023-09-23) and I have been
> following the Tutorial and Concepts Guide accessible from the Help Menu.
> In particular the following section.
> 
> The Common Usage Investments Setup Investment Portfolio Setup Accounts for
> Stocks and Mutual Funds
> 
> I first note that the figure 9.6 differs from the New Account window that
> my version displays, but I have filled out this window using the
> information from Figure 9.6 as a guide. As soon as I then press OK I get a
> window that says “You must choose a commodity”
> 
> I suspect that I have missed something in setting up this application but
> have not been able to find it. Hope you can help. Attached  is a
> screenshot of the New account setup.

Unfortunately the error popup is obscuring the field where you were 
supposed to enter the commodity so we cannot see what you selected.

Can you try again, and shift the popup before taking the screenshot?


___
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] Hidden and duplicated accounts.

[Fred Bone]

On 21 November 2023 at 18:37, David Kirkby said:

> I have a couple of questions related to accounts, and my ability to see
> them and delete them.
> 
> 1) I have some accounts for fees - you can see PayPal (GBP), PayPal (USD)
> and bank fees.
> 
> [image: image.png]
> 
> I remember creating some more to include eBay fees, but since I so rarely
> use eBay, I think I set them to hidden. But when I tried to edit the
> Expenses account, I can see the other entries But I do I unhide these? I
> tried clicking on other accounts, but none show hidden, and all are marked
> as placeholder, so I don't think that's the way to edit their visability.

Have you tried setting View->Filter by, Other, Show hidden accounts?


___
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_user: rounding errors and significant digits

[Fred Bone]

On 08 October 2023 at 4:13, David Carlson said:

> Because the broker charged 15,000.00 for 1,377.41 shares?

Then the effective price paid per share wasn't the stated 10.89 but 
slightly more (approx 10.890003702601258884)


___
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_user: rounding errors and significant digits

[Fred Bone]

On 08 October 2023 at 1:06, Bruce McCoy said:

[...]

> What I do not yet understand is if GnuCash considers a price per share of
> 10.89 to be a precise figure, why GnuCash does not calculate 1,377.41 *
> 10.89 = 15,000.00 for Jeff. If GnuCash doesn’t, would we consider making
> a change to GnuCash to allow it?

There is no good reason to think that 1377.41 * 10.89 = 15000, so why 
would anyone want Gnucash to say it?

___
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] No longer able to import OFX

[Fred Bone]

On 24 September 2023 at 10:15, Mike St. Germaine said:

> Hello,
> At some point earlier in the year I started receiving the attached
> message when attempting to import an OFX from Citizens bank (the
> message is "found 1 previously imported transactions, no new
> transactions" -- the number always matches the number of transactions i'm
> trying to import). These are transactions that have definitely not been
> imported before. I've been manually entering all transactions for a while
> now and that's getting pretty old. This change seemed to coincide with a
> major change the bank made to their website though that could very well be
> a coincidence. If I create a new Gnucash file and import the OFX, it works
> just fine. It just won't allow me to import to the file I've been using
> for the past year or so. Also worth mentioning I'm still able to import
> OFX files from other banks with no issue. I deleted the account assignment
> through the import map editor but that didn't work either. It did ask for
> a new account assignment when importing but then I just received the same
> message described above. Thank you. Mike S.

That suggests that the bank is reusing the "unique" transaction numbers. 
Not a lot you can do about that except go through the file changing them.


___
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] Request for the addition of the SLE (Sierra Leone Leone (New)) currency...

[Fred Bone]

On 15 September 2023 at 8:39, john said:

> No, bug reports are helpful. We don't have any automated way to track
> ISO4217 changes and none of the core team makes time to do it manually.

There's always the "update newsletter"


> the free newsletter service that notifies subscribers about any changes
> related to currency codes like creation of new currencies, withdrawals or
> any other alterations. Subscribe to the ISO 4217 Amendment Newsletter
> today and don’t miss any important updates.

___
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] Recovering

[Fred Bone]

On 14 September 2023 at 21:30, Adrien Monteleone said:

> I'm not clear on your question.
> 
> Are you asking which file is your data file?
> 
> Do a search with your file manager for anything ending in ".gnucash"
> 
> Those are 'book files'. And unless you intentionally made more than one,
> there should be only one result.

Unless you have backups, in which case there will also be many files 
ending in ..gnucash - where  is a string of digits 
in mmddhhmmss format. The latest of these *may* be later than the 
latest "plain" file (depending on when the crash happened relative to the 
last time Gnucash took a backup).


___
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] Import question

[Fred Bone]

On 02 September 2023 at 11:07, R Losey said:

[...]
> Hi. The issue may be with the CSV (which stands for COMMA separated
> values)... if the currency contains commas, it will confuse anything that
> thinks it is separated by commas. 

No. A field in a .CSV file that contains a comma will be enclosed in 
(single or double) quote marks, so the program reading it will not have 
any such problem.

Otherwise it isn't a .CSV file but a text file that happens to have been 
given a .CSV filetype.

___
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] Today's search....for .lck

[Fred Bone]

On 07 August 2023 at 16:05, Adrien Monteleone said:

> Barry,
> 
> At one point you advised you had GnuCash files in:
> 
> C:\Users\Barry Mahon\Documents\Tax accounts and returns\
> 
> now, you are saying it is:
> 
> C:\users\administrato\documents
> 
> These are 2 separate locations and two separate 'users' on this machine.
> 
> Where do you *think* your GnuCash file is supposed to be? (full 
> qualified path please)
> 
> And what do you *think* its file name is supposed to be? (just the file
> name here is fine)
> 
> And for completeness, can you trigger that 'cannot write to file' 
> warning that you originally reported, and send us a screenshot?

Should be trivial.

When signed in as "administrato", try to access the files stored under 
"Barry Mahon". Or vice versa.

___
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] finance Quote Not working

[Fred Bone]

On 06 August 2023 at 16:40, Fross, Michael said:

> As an FYI, on my windows 11 installation, the default location where
> GNUCash installs itself is:
> 
> "C:\Program Files (x86)\gnucash"
> 
> and the full path to the CLI executable is:
> 
> "C:\Program Files (x86)\gnucash\bin\gnucash-cli.exe"
> 
> For command line guys like me, these paths are just crazy

Microsoft doesn't want "command line guys" as customers ...


___
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] Cannot write to file

[Fred Bone]

On 26 July 2023 at 12:29, Mahon Finbar said:

> I have a message -
> 
> "Could not write to file C: xxx check that you have permission to
> write to this file and there is sufficient space to create it"
> 
> The file is a report of annual P&L that I have open , but I am not 
> working on it
> 
> What is the problem??

The problem is that you have it open in another application, so it cannot 
be overwritten.


___
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

[Fred Bone]

On 24 July 2023 at 16:53, Chris Green said:

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

It's an Asset or Liability (two sides of the same coin, in a sense) at 
your choice, depending mainly on which way you expect the balance to  be 
in the long run.

I have an account
 Assets -> Debtors & creditors
where I record this sort of thing, relating to various different 
individuals (typically the odd couple of quid every few weeks). If I had 
one particular acquaintance generating a lot of this activity I'd run a 
sub-account for that acquaintance.

The "Expense" is the other side of the transaction recording what the 
oney was owed for, and might vary according to whether the expenditure 
was a round in the pub or dinner at a local restaurant.

When (if) you actually settle up, the other side of *that* txn is of 
course your bank account, cash in hand, or whatever.


___
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 record payments for several items paid with a single transaction?

[Fred Bone]

On 23 July 2023 at 9:34, Chris Green said:

[...]
> I simply want to be able to able to have (conceptually) a multi-line
> entry in the income sub-account called 'Collections at services' which
> records two (or maybe more) amounts of cash paid in at one time.

But aren't you supposed to record each collection separately for GASDS 
purposes? What happens if the two weeks are in different tax years?

AIUI you should be counting each bagged-up collection separately. It's 
then a simple matter to record it as a txn from "Collection Income" to 
"Money awaiting deposit", plus (I assume) another from "Envelope Income" 
(or is it someone else's job to reconcile envelope contents against 
people's promises?).

Then at pay-in-to-the-bank time, you have one txn from "Money awaiting 
deposit" to "Bank".

This ensures that your books record what happened when, which is after 
all the whole point.

If I were doing it, I'd keep separate "Cash awaiting deposit" and 
"Cheques awaiting deposit" subaccounts, but that's probably not 
essential. It would, however, make it easier to double-check the figures 
on the paying-in slip, which I why I adopt that approach in my role as 
area treasurer of a small charity.

___
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] Reply convention

[Fred Bone]

On 18 July 2023 at 15:32, R Losey said:

[...]
> I don't think the rules can be "imposed", but if  there were something in
> the header or if there was something in the monthly reminder about the
> etiquette of posting, that would be a big help to users that there is a
> "right" way to post.

You might think so, but the Digests tell recipients

| When replying, please edit your Subject line so it is more specific
| than "Re: Contents of gnucash-user digest..."

and that seems to be honoured more in the breach than the observance.

One can always hope ...

___
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] Transferring mutual funds

[Fred Bone]

On 04 July 2023 at 16:29, AC said:

> I recently moved some mutual funds from one brokerage to another. The
> process did not involve a sale, it was just a transfer of control from the
> old to the new.
> 
> In my current books I keep mutual funds listed as subaccount under each
> brokerage as such with their respective security/currency:
> 
> Investments
> -Brokerage 1 (currency)
> --Fund A (security A)
> --Fund B (security B)
> -Brokerage 2 (currency)
> --Fund A (security A)
> --Fund C (security C)
> --Fund D (security D)
> 
> I wanted to expand this to add the new brokerage and then perform a 
> transfer of the funds from one to the other. Let's assume I moved the
> funds under Brokerage 1 to Brokerage 3. So the tree would look like the
> simplified version below (leaving out Brokerage 2 as it is unaffected):
> 
> Investments
> -Brokerage 1 (currency)
> --Fund A (security A)
> --Fund B (security B)
> -Brokerage 3 (currency)
> --Fund A (security A)
> --Fund B (security B)
> 
> The securities are the same because it's the same original mutual funds,
> just moved to another brokerage. The tree would be left intact with the
> funds under Brokerage 1 being zeroed out and the funds under Brokerage 3
> starting off with the incoming values.
> 
> My natural tendency was to create a transfer directly within Brokerage 1
> Fund A that moved all the shares over to Brokerage 3 Fund A but that
> didn't create the transaction I expected.
> 
> By example, I transferred Fund A on July 1 which contained 10 shares at
> the price of the shares on that day. So in Brokerage 1 I entered -10
> shares with a total sell price of X as listed on the statement from
> Brokerage 1. The price is autocalculated and the balance correctly goes to
> zero.
> 
> Looking inside the Brokerage 3 Fund A account I only see a transaction
> that has an amount in the buy column but no shares and a balance of zero.
> I can manually enter the same number of shares in that partially empty
> transaction but why was my thought about the transfer incorrect? Should it
> have not transferred those shares over as well?

Did you work in split view?

I can replicate what I think you are saying if I don't enter the separate 
splits.

If I go about it the obvious way (in split view) and enter balancing 
amounts then it all works.

However, I'm still on 2.6.21 ...

___
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 revert to previous input mode?

[Fred Bone]

On 01 July 2023 at 19:16, Pierre Fortin said:

> On Sat, 1 Jul 2023 16:31:55 + Gyle McCollam wrote:
> 
> >Pierre,
> >you stated you have to:
> >new method:
> > +|-. TAB, TAB, p(long list with "Don't Autocomplete" at top,
> > up-arrow, ENTER, pr(still long list with "Don't Autocomplete" at top,
> > up-arrow, ENTER, pre(still long list with "Don't Autocomplete" at top,
> >arrows or mouse actions once enough characters have been entered to
> >reduce the list where last month's transaction is now visible, etc...
> >
> >I don't understand why you need to up arrow after each character.  You
> >can type "p", then "r", then "e" just like you used to do. You can type
> >as many letters as you need without selecting "Don't Autocomplete" which
> >is what you seem to be saying.
> 
> No, I don't have to up-arrow; but I was trying to make the point that the
> new method has added a lot of extra visual cruft and confusion.  Worse,
> typing "Pens" auto-populated an old "Camper expenses" entry which now
> had to be canceled and restarted.  

So what happens when you type the obvious "PENS "?

___
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] quandary with proper entries for cost-of-goods-sold and inventory

[Fred Bone]

On 17 June 2023 at 15:28, Stan Brown said:

[...]
> One important point: If you receive messages in a  digest, you'll also
> need to (a) edit the subject line, by copy/pasting the subject of the
> individual message you're referring to, and (b) Delete all the text of all
> the messages you're _not_ referring to, as well as any parts of the
> remaining message that are not needed to give context to your answer.

That should read "... If you receive messages in a PLAINTEXT digest ..."

The MIME-Digest works just fine, including having the necessary headers 
to enable "reply all" to 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gunzip test.gnucash fails

[Fred Bone]

On 02 June 2023 at 1:20, David G. Pickett said:

> Now if only the digest email back was a readable as and, unmodified from,
> the email out?

Try the MIME-Digest.


___
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] Finance:Quote again [sorry]

[Fred Bone]

On 11 May 2023 at 16:48, Graham said:

> Dear team
> 
> Apologies if I am being particularly thick, but I can't get up to date
> stock prices. The last ones on the system are from March. I've spent ages
> with the documentation, so I uninstalled strawberry perl, re-run the
> windows install online price retrieval tool. All went well. But...when I
> attempt to run perl gnc-fq-check, I get 'Can't open perl script
> "gnc-fq-check": No such file or directory'.
> 
> In the About section of Gnucash , i get the attached list, with no 
> finance quote shown. Trying to get updated quotes with the price 
> database, it now tells me Finance:Quote is not installed properly.

The first thing you need to mention when asking for support for ANY piece 
of software is the version you are using ...

(And the OS, but as you mentioned Windows in passing people can take an 
educated guess).



___
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 do I reply to a topic?

[Fred Bone]

On 02 May 2023 at 11:16, Lipp F. said:

> I am only getting the "gnucash-user Digest, Vol nnn" emails. How do I
> reply to a topic or to a  topic reply? Thx.

It's trivial if you get MIME-digest rather than the text version.



___
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] set up Gnucash on a new device

[Fred Bone]

On 17 April 2023 at 18:38, Adrien Monteleone said:

> Ah, forgot about the 'S' variant. If I'm not mistaken, it is also 
> possible to convert a regular installation to 'S', but you'd have to know
> you did it. It won't be an accident.

Other way round.

You can install Windows in "S" mode (or get a machine with it 
preinstalled), and then revert to normal, but you can't change *to* "S" 
mode. It wouldn't make sense, because "S" mode is supposed to guarantee 
that only "approved" programs are present, and once the machione ahs been 
running in normal mode that guarantee can't apply.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Fred Bone]

On 07 March 2023 at 18:50, R Losey said:

> But it's not just the split transaction; EVERY charge is decreasing the
> balance. It's like it thinks there was some huge overpayment and every
> charge is reducing that balance.
> 
> The attachment you provided doesn't have any payments, but every charge
> looks like mine. (I did discover that I have the Reverse Balanced Accounts
> set for credit cards; this must be the default, as I've never changed it).
> If this is off for you, the screenshot makes sense.

Take another look (attachment to email with "Date: Mon, 6 Mar 2023 
09:09:49 -0700").

There was one payment shown, which as you would expect increased the 
accumulated overpayment.

Whether the booked overpayment actually happened in reality is another 
matter, of course. The OP's emails suggest it didn't. The solution is 
likely to be found by tracking back in time.


___
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] Confusing version numbers

[Fred Bone]

On 07 March 2023 at 10:36, Maf. King said:

[...]
> Major release 4.  Update (bug fix) 1.   Update 9.. Update 12.
> 
> Update 900 is the "preview" to the next major version (5), and similarly
> 901, 902. etc. follow on in sequence...  100 possible previews should be
> enough!

And if not, there's always 4.1000, 4.1001 ...

;->

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Fred Bone]

On 06 March 2023 at 9:47, Custom Shots said:

> The credit card starts as Liabiliies:CreditCard:"specificcreditcard" It's
> not that charges are reducing the balance. Charges and Payments, both,
> increase the balance owed. The other half of the transaction, calculates
> correctly.

Not on the screenshot you showed us. According to that, you were owed 
3585.23 on 2/21 and your "dining" expense on 2/23 reduced that to 3559.39

Credits and debits (charges and payments) are working in opposite 
directions, as is proper.


___
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,org url is now working

[Fred Bone]

On 03 March 2023 at 7:31, Derek Atkins said:

> Hi.
> Indeed, it does appear that www.gnucash.org lost its brain and, although
> responding, is not the gnucash website.  I will notify Linas to ask what's
> up. 

What appears to be up is the loss of an automatic redirect from
 http://www.gnucash.org
to
 https://www.gnucash.org
which, as this is clearly an Apache webserver, is a matter of one line in 
a .htaccess file.

The corresponding redirect for gnucash.org (without the www. prefix) is 
working.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Fred Bone]

On 02 February 2023 at 21:40, Xe Roy said:

> It looks like the FINISH button only is active if there is zero
> difference. I will have to wait for the next statement in order to
> reconcile and get a zero difference.

Yes, you can only "Finish" once you have verified a zero difference. 
That's the whole point: if there's a difference, you need to find the 
reason for it and make the necessary correction.

However, what you were trying to do was repair an accidental change in a 
previously-reconciled transaction. You already have a statement you can 
reconcile against. Set the date to the date of that statement, the 
closing balance to its closing balance, and you will be able to complete 
the reconciliation.

___
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 do I Upgrade from 2.6.12 to v4?

[Fred Bone]

On 31 January 2023 at 21:19, Gyle McCollam said:

> Martin,
> Sorry to hear your PC is dying, but the upgrade is ot a complicated as you
> think.  1st, what version of Windows are you running on the PC?  Next it
> is recommended that you upgrade to a version 3.x, then run under "Actions"
> Check and Repair.  After you have done that, you can upgrade to version
> 4.x and run Check and Repair again.  

AIUI the advice is to upgrade to 2.6.21 (i.e. the latest 2.6.*) *first*, 
open and save the file, and only *then* upgrade to 3.11 and proceed as 
above.

And of course take a backup copy at each stage in case you need to re-do.


___
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] Is this a wacky idea?

[Fred Bone]

On 29 January 2023 at 5:48, Tom Browder said:

> On Sun, Jan 29, 2023 at 05:23 flywire  wrote:
> 
> > Anyone can run https://portableapps.com/apps/office/gnucash_portable in
> > Windows without installing it. It is probably better than installing
> 
> 
> It sounds great, but color me skeptical.  I have looked at portableapps
> twice now and declined. The fine print says you'll be given a "free"
> two-day membership to what sounds like a dating site. After that you'll be
> hit with a bill for almost $40 monthly. At my age it's easy to forget
> given such a short time to try it out "free."
> 
> I didn't see a way to decline. Frankly, I would be fine with a more modest
> amount per month, with no long-term contract.

And I can't see a way to be offered such a thing ...

I go to portableapps.com.

There I see a large green "button" saying "Download Now - Free". I click 
it and get a page headed
"Download PortableApps.com Platform 23.1 - Free App Store & Menu"
with another green "button" saying "Download from PortableApps.com". I 
click that and the resulting page autostarts a download.

(I cancelled that because I already run PortableApps for a couple of 
things and it will update itself anyway next time I run it).

Yes there are several ads on the page, but there's no compulsion to click 
on them.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Fred Bone]

On 28 January 2023 at 9:55, Kalpesh Patel said:

> Not able to see the  amount or the account name in the reminder pop for
> the scheduled transaction is a huge bummer for me as well. 
> 
> 
> 
> I have multiple scheduled transactions to the same institutions on the
> same date for different assets and I have to make a note of it in each
> transaction's name to discern them differently so they stay sane.  

I rather thought that was the whole point of letting you "name" a SX: so 
that you can tell one from another.

___
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] Have I screwed up with my Accounts Payable and Accounts Receivable?

[Fred Bone]

On 25 January 2023 at 21:09, Dr. David Kirkby said:

> On Wed, 25 Jan 2023 at 20:52, Fred Bone  wrote:
> 
> > On 25 January 2023 at 20:35, Dr. David Kirkby said:
> >
> > > On Wed, 25 Jan 2023 at 19:29, Dr. David Kirkby <
> > > drkir...@kirkbymicrowave.co.uk> wrote:
> > >
> > > >
> > > > I have the attached transaction showing as owing $0.98 to
> > > > Porkbun.com. The number 0.98 happens to be the difference between
> > > > what this cost in USD ($6.90) and what it cost in pounds (£5.92).
> > > >
> > > >  6.90-5.92=0.98.
> >
> > That sounds as though you have set a 1:1 conversion rate between the two
> > currencies ...
> >
> 
> No, I did not set a conversion rate of 1:1. I did not set the conversion
> rate, but the debited or credited amount. The bank account, which I have
> reconciled, shows a credit of £5.92 for the item I purchased for $6.90.
> The 0.98 difference is showing up as a pre-payment in USD. But it is
> neither USD nor GBP.

So what conversion rate is it using?

If you didn't set one, then the only feasible default is 1:1, which would 
adequately explain what you're seeing.

Try setting the rate to GBP5.92=USD6.90 and see what difference that 
makes. You can always do it in a testing copy of the books first.

___
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] Have I screwed up with my Accounts Payable and Accounts Receivable?

[Fred Bone]

On 25 January 2023 at 20:35, Dr. David Kirkby said:

> On Wed, 25 Jan 2023 at 19:29, Dr. David Kirkby <
> drkir...@kirkbymicrowave.co.uk> wrote:
> 
> >
> > I have the attached transaction showing as owing $0.98 to Porkbun.com.
> > The number 0.98 happens to be the difference between what this cost in
> > USD ($6.90) and what it cost in pounds (£5.92).
> >
> >  6.90-5.92=0.98.

That sounds as though you have set a 1:1 conversion rate between the two 
currencies ...


___
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] Is it reasonable to have sub-accounts under Equity:Fixed Assets?

[Fred Bone]

On 17 January 2023 at 16:11, Dr. David Kirkby said:

[...]
> I thought monthly might work better with trying to automate what will be a
> tedious process. The GnuCash Scheduled Transactions could possibly be
> useful there.

While you could use SXs, given that you (presumably) know exactly what 
the depreciation schedule is for each item, you could equally well enter 
all the future amounts now. It's arguably simpler than setting up the 
SXs.

___
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] Website from WIki

[Fred Bone]

On 14 January 2023 at 22:30, Fred Tydeman said:

> I am doing a search (for T-bill) on the gnucash wiki.
> I get the Search Results page (with 181 results).
> On the left side of the page, I click on GnuCash Website.
> That gets me:  Apache2 Ubuntu Default Page
> That seems wrong to me.
> The URL in the address bar of Google Chrome is:  gnucash.org

That's because the link in the Wiki is to
 http://www.gnucash.org
whereas it ought to be to
 https://gnucash.org
or
 https://www.gnucash.org

You'll also have noticed that the "default page" is not-secure (your 
browser should be notifying you of this).

Perhaps the maintainers of the gnucash.org website could add a redirect 
rule for incoming http:// requests.
___
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] Budget report fails in multiple currencies

[Fred Bone]

On 07 January 2023 at 10:21, ml enquirer said:

> Just to add that I was wrong that this could be solved by making budgets
> with a single period. I *think* this problem arises for any multi-currency
> sub-accounts and becomes visible when you have a book which has been
> running for many years. In that circumstance, the 'actual' column is only
> incrementally affected by spends during the actual reporting period (which
> are small compared to the cumulative spending over the years).
> 
> Imagine a case where there is *no* spend on any sub-account in a reporting
> period, but the years prior total 1,000,000 EUR and 1,000,000 GBP. Imagine
> the exchange rate is 1 EUR to GBP at the start of this new 'empty' period
> and 1 EUR to 1.01 GBP at the end. 1) The computed total at the start will
> be 1,000,000 EUR + 1,000,000 GBP = 2,000,000 GBP. 2) The computed total at
> the end will be 1,000,000 EUR + 1,000,000 GBP = 2,010,000 GBP and the
> reported "Actual" spend will be 10,000 GBP despite nothing having been
> spent.

The change in value is indeed 10,000. What's the problem?


___
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] Changing typeface using CSS (Windows 10)

[Fred Bone]

On 21 December 2022 at 0:11, Adrien Monteleone said:

> Terrence,
> 
> You nearly had it right the first time.
> 
> You need the "#" in front of the selector:
> 
>"#gnc-id-main-window"
> 
> The initial post you made left off the '#' sign at the beginning. If it is
> not there in your CSS file, that would be why it didn't work. That symbol
> indicates a CSS 'id' and without it, a 'named node'. If the node is not
> named as such, but does have that id, then your rule without the symbol
> will never work.
> 
> Also, I'm surprised the wiki doesn't show this, but I'm fairly certain you
> have to quote font family names that have spaces in them. 

Not true if the CSS interpreter is conformant, unless one (or more) of 
the words happens to be a CSS keyword or is not parseable as an 
"identifier"


However, quoting is always harmless.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Splitting a Transaction (Newbie Question)

[Fred Bone]

On 17 December 2022 at 22:19, p.f.cuthb...@btinternet.com p.f.cuthbert@ 
said:

[...]
> So let us have an example:
> 
> Payment by bank card (credit entry to Bank Account) of £7.24 comprising a
> book (debit £5.25 to Entertainment) and some milk (debit £1.99 to
> Groceries).
[...]
> If any kind reader can advise on the correct way yo handle this simple
> task I would be most grateful as I do simple domestic accounting but have
> lots of split debit analysis.

Starting from the bank (or credit card) account, i.e. the one from which 
the payment was made:

1. Go to the "new entry" line (at the bottom)
2. Enter the Description
3. Tab to the Credit column
4. Enter the amount (7.24), replacing what was there before
5. Tab. This commits the txn
6. Return to the "Transfer" field of the new txn
7. Right-click and select "Split"
8. Tab to the Debit column on the debit split
9. Enter the correct value (1.99)
10. Tab twice. A new split is added with the difference (5.25) in Debit.
11. Go to the Transfer column of the new split and complete it.

HTH .. F

___
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] Reconciling credit card

[Fred Bone]

On 13 December 2022 at 16:31, Mahon Finbar said:

[...]
> The other question is why does expenses:travel have 'rebate' as a column
> heading??

What would you prefer? "Refund" is the most likely alternative I can 
think of, and "Rebate" is pretty close to synonymous.

Anyway, it only has that if "formal accounting labels" is not selected.

___
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] Reconciling credit card

[Fred Bone]

On 12 December 2022 at 15:44, Mahon Finbar said:

> Another possibility?
> 
> In March 2021 I was reimbursed 1,340.98 by an airline for a trip to 
> Japan which was cancelled due to Covid.
> 
> In error I entered the reimbursement against my credit card, although I
> had paid it from my bank.
> 
> That would account for the 'credit' on the credit card?

Obviously.

If you tell Gnucash that the money went to the credit card when it 
didn't, you should expect to see incorrect results.

"Garbage in, garbage out" has been a maxim in IT since well before I 
started in the business.



___
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] Reconciling credit card

[Fred Bone]

On 12 December 2022 at 11:09, Mahon Finbar said:

> OK, I had forgotten you cannot attach images as pics.
> 
> I did check the a/c and afaics, I didn't pay the CC 1000 extra, I'll
> check again or adjust the preferences, or something.

It's not your preferences (unless you want to switch to formal accounting 
labels, which won't change anything relevant).

Your credit-card account is showing a substantial negative balance. That 
is, you (appear to) have made a substantial overpayment to the provider. 
Any time you make a purchase you reduce this overpayment, and any time 
you make a payment you increase it (make it more negative).

If in fact you are not owed a lot by the provider, you need to find the 
entry/ies where you misinformed Gnucash. Quite likely the original 
balance.




___
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] Reconciling credit card

[Fred Bone]

On 11 December 2022 at 14:58, Mahon Finbar said:

> That is what I do, so why am I getting an increased -ve balance in the
> balance column, like this?

According to your accounts, you have overpaid the credit card by rather 
more than a thousand, so if you were to close the account you would be 
due a substantial refund.

Making purchases decreases the amount the provider owes you, so the 
negative balance reduces. Making further payments to it increases that 
negative balance.


___
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] Reconciling credit card

[Fred Bone]

On 11 December 2022 at 12:03, Mahon Finbar said:

> OK, I have columns marked payment; charge; and balance.

I find these non-formal labels confusing.

> I translated them as payment to the bank/credit card company; spend on the
> credit card and the balance after entries in one or the other.
> 
> Do I change the headings? or am I in the wrong sort of register or type of
> a/c? or are the entries in the wrong place?

In the "credit card" account:
When you buy something, the amount should be in the Credit column, the 
one headed "Charge". This will increase the "Balance".
When you pay the provider from your bank account, the amount should be in 
the Debit column, the one headed "Payment". This will reduce the 
"Balance".

In an Expense account, the amount (relating to the thing you bought) will 
be in the Debit column, which I see gets headed "Expense". This increases 
the "Balance".

In a Bank account, the amount (relating to paying off your credit card) 
will be in the Credit column, informally headed "Withdrawal". This 
reduces the "Balance".

___
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] Possible bug - Note added in Transfer window is ignored. Memo shown twice in Accounts

[Fred Bone]

On 11 December 2022 at 11:04, Dr. David Kirkby said:

> If I transfer funds between two accounts (in my case bank and PayPal), I
> can leave both a note and a memo. I'm not sure of what's the difference
> between these, but when I look at the accounts, I see the memo shown
> twice, but the note is not shown. See the attached screenshots, before
> making the transfer, then in the accounts.
> 
> Are the notes available somewhere else?

Open any account and set View to Double-line and Transaction-journal and 
all will be revealed.

A "Note" belongs to a transaction. A "Memo" belongs to a split.

___
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] Reconciling credit card

[Fred Bone]

On 09 December 2022 at 15:58, Mahon Finbar said:

> Hi,
> I am sure this is explained somewhere, but I haven't been able to find a
> simple explanation.
> 
> I have a register of transactions in an a/c called credit card.
> 
> I enter the data from the monthly statement, allocating them to various
> expenses and enter the monthly payment from a bank account.
> 
> [In my naivety]?? I assumed that when I enter the monthly payment the a/c
> will reflect the 'net' situation, i.e. the balance of current transactions
> less the latest payment.
> 
> I seemed to be motoring along ok until a while ago when everything in the
> balance column ended up -ve!!
> 
> Typically a se of entries looked like this -
> 
> but now it looks like this -
> 
> Obviously I have been doing something wrong or have created an error.
> 
> But what??

Probably entered either the payment or the purchases in the wrong column.

Purchases should be in the Credit column and payments from the bank 
account should be in the Debit column. (That is, when you look at the 
credit card a/c. Obviously the payment will be in the Credit column in 
the bank a/c).

___
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] New user: how to migrate Quicken checking account as a single, flat, checking account

[Fred Bone]

On 04 December 2022 at 11:54, Scott Traurig said:

> I do understand double-entry accounting and that it is the GnuCash
> paradigm.
> 
> What I didn't understand is that on the import GnuCash did create the
> requisite checking account, plus all the expense accounts. I did not see
> the checking account as it was lost in a sea of expense accounts.
> 
> Now that I've gotten that far, is there any way to move accounts en masse
> into a top level "Expenses" account? Or do I have to laboriously edit each
> and every one?

What *might* work is to delete the unwanted accounts.

When you delete an account, Gnucash will ask what you want to do with the 
transactions in it. You can move them to another (already existing) 
account. This will let you (for example) consolidate the grocery 
transactions, with 17 different vendors, into one "Expenses:Grocery" 
account.

If you really want all the expenses in a single account then I suggest 
you don't want an accounting system and Gnucash is not the solution you 
are looking for.


___
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] Accounting for a pre-paid electronic toll card

[Fred Bone]

On 18 October 2022 at 22:54, Tony Vanson said:

> I'm hoping that someone on this list can aid my befuddled brain to get to
> grips with my problem. The tolling system here is not the automated ones
> I'm used to. Here one needs to obtain an electronic card and, once done,
> must be charged with a cash value prior to travelling and topped up with
> cash on a regular basis. My question is what category is this card and how
> do I treat additions and subtractions from it? I initially thought it
> might be treated as a credit card but the way it operates it's obviously
> not. Any advice would be much appreciated *Tony Vanson*

I have
 Assets:Current Assets:Prepaid:Dart-Charge
to which I move funds from (usually) a credit card
and from which I subtract the charges as I incur them.


___
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] new to Gnucash - help with general information

[Fred Bone]

On 11 September 2022 at 9:59, Michael or Penny Novack said:

> 
> >5.  Geoff is also correct here that gnucash saves backup so you don't
> >lose data, but backuping up to another media is always a good idea.
> >
> And asking this question "how do I back-up my gnucash data?" implies a
> more serious misunderstanding about using your computer. It isn't just
> just gnucash data that needs to be backed up but ALL your user data. And
> if you have adopted a plan to back up ALL your user data, gnucash data
> would be included in that, so no need to have a back-up plan specific to
> gnucash.

You do realise that these days many people do all their email via 
webmail, and all their word processing, spreadsheets and so on on Google 
Docs or suchlike "in the cloud", and may find that Gnucash is the only 
application that keeps their data locally?


___
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] Mutual Fund Dividend After Sale

[Fred Bone]

On 06 September 2022 at 14:56, Jack Frillman said:

[...]
> The stock issues it's dividends at the end of each quarter. The stock was
> sold before the end of the quarter and the dividend was issued once the
> new quarter was entered. > > Regards, > John Ralls > >

So there is no reason for it to affect the stock account, and 
specifically to affect the balance of the stock account. So what's the 
problem?


___
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] GC 3.11 crashes during "Check & Repair"

[Fred Bone]

On 28 August 2022 at 16:53, David T. said:

> I'm not an expert, but I'm pretty sure the price db doesn't have splits;
> it's just a list of commodities, prices, and dates (asking with some other
> housekeeping info).
> 
> I believe that "113 of 304" is in reference to the splits within a given
> account, so you'd need to know which account might have had that number of
> splits. 

With that number of splits it could be a "close books" txn. If so, then 
as these can readily be re-created perhaps it would be worth trying the 
effect of deleting all such.


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

[Fred Bone]

On 27 August 2022 at 10:37, john said:

> Yes, we changed the name in 2.6.11 to make clear the difference between
> the price database window and the price editor dialog. The latter is
> opened with the Add and Edit buttons on the former.

Eh? I have 2.6.21 and the Tools menu item is "Price Editor". Which brings 
up the "Price Database" window.


___
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 bulk import about 130 Securities entries?

[Fred Bone]

On 16 August 2022 at 17:11, Robert Simmons said:

> > running the *.gnucash through gunzip, add in the text, and run it back
> through gzip
> 
> As a connoisseur of bad ideas for adding data to GnuCash myself, I have to
> point out that one should use a programming language that has a library
> with support for the structured data format that one wants to add to. You
> use the parser provided by the language to generate objects in that
> language. You then perform operations on those objects. Finally, you use
> the library function to emit well formatted structured data.

Not so much fun, though, as trying to unscramble the results of manual 
tweaking.


___
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-user Digest, Vol 233, Issue 50

[Fred Bone]

On 14 August 2022 at 16:17, James Baxter said:

> Is there an app to work with your cell/mobile phone.
> Thanks James Baxter kangaro...@yahoo.com 
> 
> Sent from Yahoo Mail on Android 

Kindly pay attention to:
[...]
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."

And please trim your quotes.

___
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] Third party OFX/CVS providers

[Fred Bone]

On 08 August 2022 at 10:30, Adrien Monteleone said:

> Kalpesh,
> 
> Thanks for the links. I have a need for a PDF to CSV solution for other
> software and this looks like it is a good fit for me. (folks may be
> shocked how many large businesses in 2022 can't generate decent business
> documents/data in a proper electronic format for using in various
> software.)

EDI standards have only been around for about forty years. It takes some 
people a long time to catch up.

___
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-user Digest, Vol 233, Issue 22

[Fred Bone]

On 08 August 2022 at 13:54, James Baxter said:

>  I am looking for something that I may have already. I have had Linux Mint
>  loaded on this laptop for about a month. also have been playing with
>  Gnucash about 3 weeks. still getting us to this, As I find it very nice
>  program.
> As i dont know if I have a problem with the two of them, I don't know. So
> if anybody know if Gnucash will bring down the items it needs to work
> with. I am looking to do a schooling on Linux, go from there. thanksJames
> baxterkangaro...@yahoo.com

Kindly pay attention to:

> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."

and please trim your posts.

___
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-user Digest, Vol 233, Issue 16

[Fred Bone]

On 06 August 2022 at 19:48, James Baxter said:

>  I am James Baxter email kangaroo52@yahoo.comas i found this next part and
>  i am not good with Linux and Gnucash.org. I am looking to know how to
>  place that code into this linux or where it is design to go.

Kindly pay attention to:

> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."

and please trim your posts.

___
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] New User Oh boy I need an accountant

[Fred Bone]

On 18 July 2022 at 17:32, Phyllis Bruce said:

> I am getting too many unanticipated results.  Watched many YouTube videos
> since I cannot make sense of the Help manual.  I have added accounts where
> they appear to belong, added my opening balances, and imported a couple
> CSV files from a bank account.
> 
> Here is the CSV:   Note columns for Withdrawal and Deposit
> [image: 0fb3e81e-c69c-40b2-b876-6cd92092afe4.png]
> 
> [image: image.png]
> 
> Here is the bank journal showing the transactions and transfer accounts:
> Everything a deposit?! [image: image.png]

Of course. Your bank has put minus signs on the withdrawals.

___
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] CC card balances

[Fred Bone]

On 10 June 2022 at 15:01, Kevin T said:

> I have created a new credit card account.  Completely empty, zero
> balance.From one of the other accounts, I have transferred monies to this
> account.Viewing this account, the transfers show up as entries in the
> 'Payment' column, as they should.But...The balance becomes more negative
> with each transfer.  This is counter intuitive to me.  Is there some
> way of interpreting this different?Why?

If you pay out from a liability account (such as a credit card) the 
balance (amount you owe) increases. When you make payments into it, the 
balance decreases. If you make payments into such an account starting 
from a zero balance, the balance goes negative.

Gnucash is set up to reflect this, unless you change things in 
Preferences.

Of course, if you have set up your credit card as something other than a 
Liability, all bets are off.

___
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] Missing 2nd entry

[Fred Bone]

On 09 June 2022 at 6:59, David Carlson said:

> The capability for zero value transactions with a single account line was
> permitted starting in release 3 point something iirc as hinted by
> Christopher.

Really? Odd, then, that I can do it in 2.6.21.


___
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] edit --> find --> description contains fails to show accounts receivable items

[Fred Bone]

On 09 June 2022 at 13:12, Liz Dodd said:

[...]
> Having an account "in focus" when starting a search restricts the
> search to that tab/account.
> 
> Either a neat trick or a trap for the unwary.

Trap for the unwary? I would have called it entirely obvious.

___
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] Strange incorrect due date calculated on a duplicated bill

[Fred Bone]

On 30 May 2022 at 17:35, Adrien Monteleone said:

> I'm catching up on some paperwork and entering old vendor bills. I've
> never seen this issue before, and can't seem to figure out why this one
> bill is not correctly calculating the due date.
> 
> Screen shot is attached. (hopefully it goes through)
> 
> Terms are set at Net20. Every other bill for this vendor correctly 
> calculates the due date as the 27th of the month, for their bills posted
> on the 7th.
> 
> I don't think using the Duplicate feature is even at play because I just
> did that about 10 times prior with no issues.

An override for days falling at the weekend? (2021-11-27 was a Saturday).


___
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] error when I try to save in MySQL or sqlite3

[Fred Bone]

On 28 May 2022 at 8:17, David T. said:

> Gustavo,
> 
> The image didn't come through, and you didn't give the version of Gnucash
> you're using, but the mail client tag line suggests that you are on
> Windows, and I'll assume it's a recent version of Gnucash. 

The image was attached, and shows an error message reporting that the 
Postgres server "experienced an error or encountered bad or corrupt 
data".

Unfortunately it does not go on to explain the nature of the error. 

An obvious temporary work-round would be to save the file in some other 
format, e.g. the default XML.


___
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] Need Value in Scheduled transaction

[Fred Bone]

On 04 May 2022 at 8:48, Fred J. Tydeman said:

> When I start Gnucash and there are scheduled transactions to be run,
> the window that pops up takes me to a dividend reinvest transaction
> and says it needs a value.  That is confusing in that it is unknown what
> value is it asking for:  Shares, Price, Buy. It appears to be Price, but I
> was expecting it to be Shares.

Can you not inspect the relevant SX in the SX Editor?

For all my SXs that require input at create time I can look at the 
template and see which entries require input.

___
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] Shutdown using the "X" in windows 11

[Fred Bone]

On 24 April 2022 at 23:18, Gyle McCollam said:

> Using Windows 11 and GnuCash 4.10
> 
> Also had this issue in an older version.  Clicked on the "X" to shut down
> and had not saved first.  In the dialogue I clicked on Cancel, but it
> still shutdown.  I expected "Cancel" to cancel the operation (shutdown),
> am I wrong.  What operation is it canceling?  All 3 options have the same
> result,  They all close the program without saving 

I'm running 2.6.21 (on Windows10).

Clicking the X, or File->Quit, both produce a dialog offering a choice of 

close-without-save, cancel, or save-and-close.

"Cancel" does what I expect: cancels the close operation and returns to 
the same state as if I hadn't done File-Quit.

> and upon restart, I got
> the message that "GnuCash could not obtain the lock for
> C:\Users\*\OneDrive\Documents\GNUCash\**.gnucash." 

The filename suggests you are keeping the file "in the cloud", and if so 
this (failure to delete the lock file) seems to be expected behaviour, 
regardless of Windows or Gnucash version.

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

[Fred Bone]

On 13 April 2022 at 15:38, Gyle McCollam said:

> I have a different question about SX.  I had an insurance policy with 10
> payments.  Last year's payments are complete and the SX show never for the
> next scheduled payment.  I want to set up a transaction for the next year
> without deleting last year's and creating a new transaction.  I modified
> the start date for this year, but it still shows "never" in the "next
> occurrence".  I tried removing the check from "enabled", saving and
> reenabling it, but it still shows never as the next occurrence. Isn't
> there a reuse a SX without havu=ing to set it up all over again or will
> this actually work when the time comes and it just isn't displaying
> correctly now.

You probably need to update the "Remaining" count on the "Overview" 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
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] Fw: Re: Upgrade problem

[Fred Bone]

On 29 March 2022 at 9:40, avigr...@juno.com said:

> What is the filename that GnuCash uses to store the data?  I need to know
> what filename I am looking for when I do my search for it.

It stores it under the filename you told it to use.


___
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

[Fred Bone]

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.

Re: [GNC] Question about stock entry

[Fred Bone]

On 09 February 2022 at 20:47, Κωνσταντίνος said:

> And how i can set it in stock?

The "Account Type" dropdown is at the bottom left of the "New Account" 
window, which I think is the one you showed (part of) in your original 
message. You will probably need to scroll down to find the entry for 
"Stock". You need to do this before clicking "Select", and then you will 
get a "Select security" window instead of "Select currency".

Sorry for not making this clear earlier: I thought it was mentioned in 
the documentation.

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

Re: [GNC] Question about stock entry

[Fred Bone]

On 09 February 2022 at 19:16, Κωνσταντίνος said:

> Hello, 
> I am glad that I am starting using the Gnucash. I read the guide and
> seams quite easy and friendly to use.  My question is about the stock
> entries.  
> 
> In the guide  
> https://code.gnucash.org/docs/C/gnucash-guide/invest-setup1.html#invest-se
> tup-stockaccounts2  it is clearly what it needs, but when I go to the
> Gnucash I can’t find other option than currency for the type of the
> stock. 

You need to make sure the "account type" is set to "stock", first. Sorry 
I don't know this in Greek (I did do Ancient Greek at school, many years 
ago, but the syllabus strangely omitted any mention of accounting).

___
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] newbie question

[Fred Bone]

On 06 February 2022 at 22:32, Shevach Pepper said:

> Hello there,
> I have two accounts: income (n.ya.) and cash (my pocket)
> I got payed $500 from n. ya. and the money is  now in "my pocket".
> My problem is when I record in n. ya. charge $500 and in the transfer
> column 'my pocket" it records it as a "spent" right hand column. I just
> can't figure out why it is like this: According to my logic if it goes out
> of income then it should be received by "my pocket" Can someone help me to
> figure out my mistake? Thanks a lot Shevach

You seem to have put the amount in the wrong column.

An income account normally has the amount in the "Credit" (right-hand) 
column and the receiving account ("cash in hand" as I would call it) then 
shows the amount in the "Debit" (left-hand) column.

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