from:"Adrien Monteleone"


Glad that helped.

Please remember to either copy the list on all replies, or just reply to 
the list address to make sure others benefit from the full conversation. 
(and in this case, can see what resolved the issue)


Regards,
Adrien

On 7/8/24 2:52 PM, GNUCash wrote:

Thanks Adrien,

That settings was not set (default to accumulate splits). After enabling this 
setting, the import works fine.
So indeed it seems that the default overrides the CSV file.
I am not sure that is desirable though.

Best,
Etienne



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] accumulate split with import Invoices CSV doesn't work

Verify that Preferences > Business > General > 'Accumulate splits on 
post' is checked.


While you are indicating to do so in the import, the posting code might 
be reading the preference and overriding your column.


If the devs intended that column to work the otherway and override the 
preference, then yes, I'd say it is a bug.


If you have that preference check, then definitely a bug.

Regards,
Adrien

On 7/8/24 2:53 AM, GNUCash wrote:

Hello,

I import Invoices using CSV files; created using python.
When an Invoice has multiple items/lines and accu_split is set as “X” in the 
CSV file, it doesn’t use the accumulation. The importer recognises the 
accumulate split column, so everything is in the correct column.

I need to manually unpost and repost that invoice for the accumulate split to 
function.

See part of a CSV: Order ending with 1114 is 1 Invoice after the import with 3 
lines. The X-es for tax do work fine.


id  date_opened owner_idbilling_id  notes   datedesc
action  account quantityprice   disc_type   disc_how
discounttaxable tax_includedtax_table   date_posted 
due_dateaccount_posted  memo_posted accu_splits
#20215  2024-06-15  01  #20215  Order #20215
2024-06-15  Order #20215MaterialIncome:Revenue  1   
100 X   X   VAT 2024-06-15  
2024-06-15  Assets:Debiteuren   Order #20215X
#20214  2024-06-10  01  #20214  Order #20214
2024-06-10  Order #20214MaterialIncome:Revenue  2   
25  

X   X   VAT 2024-06-10  2024-06-10  Assets:Debiteuren   
Order #20214X
#20214  2024-06-10  01  #20214  Order #20214
2024-06-10  Order #20214MaterialIncome:Revenue  1   
50  X   X   VAT 2024-06-10  
2024-06-10  Assets:Debiteuren   Order #20214X
#20214  2024-06-10  01  #20214  Order #20214
2024-06-10  Order #20214MaterialIncome:Revenue  1   
150 X   X   VAT 2024-06-10  
2024-06-10  Assets:Debiteuren   Order #20214X

Thanks for any suggestion, perhaps it is a bug?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Bogus email?


On 7/7/24 9:30 AM, Frederick Bambrough wrote:

Why? This is the weirdest mail list I've ever subscribed to (the list, not
the contributers :-) ). We're asked to CC to the list whereas on every
other list I've used the principal is to ONLY post to the list.


I would suspect that's the shortest, easiest recommendation that applies 
to everyone. Some folks have clients that have the more appropriate 
'reply to list' button/command. But alas, most modern webmail and even 
desktop clients no longer have it.


I use Thunderbird, reading the list as a 'news server' via gmane. That 
gives me a 'Follow up' button which is functionally equivalent to 'reply 
to list'. (I still have a 'reply' button to e-mail a list user directly, 
but I don't use it)


The advice *could be* to remove the auto-inserted user's e-mails when 
hitting 'reply' or 'reply-all' and leaving, and/or inserting the list 
address, but it is much easier to just advise to 'CC' instead. (the wiki 
*does* offer the more verbose options I've mentioned here, but that is 
too much to put in the bottom of every message.




That aside, I'd rather fetch from a list than receive direct mail. In the
case of gnucash-user, I can be selective in reading from the archive.

That's the beauty of this, you can use the list however it works for you.

To save you the trouble of un/re-subscribing, simply remain subscribed, 
but edit your preferences from the list website to turn off receipt of 
new messages. Then you can view them when you want via the archive, and 
still reply without having to re-subscribe.



Regards,
Adrien

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

Re: [GNC] Consolidated billing of two credit cards

I'm in the camp that would just use a single split transaction payment 
and leave the accounts as-is, if not for the very least, that the bank 
still treats them as separate accounts. They can change how they present 
the statement on a whim. (as they have clearly already done once)


I always attempt to model the real world in my accounting as closely as 
possible.


If it helps with reconciliation, you can put them under a placeholder 
parent account, and opt to include sub-accounts during reconciliation.


Regards,
Adrien

On 7/7/24 10:54 AM, rsbrux via gnucash-user wrote:
I have two credit cards from the same bank, which were previously 
handled completely separately and are therefor represented by separate 
accounts in GnuCash.


Now the bank has consolidated the statements, but not completely.  There 
is now a sinlge statement, but the charges and balance due are listed 
and summed up separateky for each card.


However, the total due for both cards is now applied as a single charge 
to my bank account. Because of the separate totals on the statement, it 
is still convenient to reconcile the two credit card accounts separately.


However, this results in two separate charges to the GnuCash bank 
account, which I then have to mentally add together to reconcile the 
bank account.


This has led me to consider merging the two credit card accounts in 
GnuCash.  How easy is this?  Will this really make things easier, or am 
I better off sticking with the status quo?


Thanks in advance for any tips!


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] More than 4 files


And I see it is in the Wiki FAQ.

Regards,
Adrien

On 7/7/24 9:57 AM, Adrien Monteleone wrote:

Found it surprisingly fast:

https://lists.gnucash.org/pipermail/gnucash-user/2021-January/094869.html


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

Re: [GNC] More than 4 files


Found it surprisingly fast:

https://lists.gnucash.org/pipermail/gnucash-user/2021-January/094869.html

(and not as old of a thread as I thought, or maybe there were others)

Regards,
Adrien

On 7/7/24 9:54 AM, Adrien Monteleone wrote:
I could be mistaken, but I thought this was a hidden preference, at 
least on MacOS that could be edited via a plist file. I'm not sure if 
that situation still exists or if this can be edited on other platforms. 
(or where that file might be) I seem to recall either a list thread or 
bug on the topic, but many years ago.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] More than 4 files

I could be mistaken, but I thought this was a hidden preference, at 
least on MacOS that could be edited via a plist file. I'm not sure if 
that situation still exists or if this can be edited on other platforms. 
(or where that file might be) I seem to recall either a list thread or 
bug on the topic, but many years ago.


Regards,
Adrien

On 7/7/24 7:29 AM, Fred Tydeman wrote:

Is there a way to have the list of files/books have more than 4?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Correcting an over payment on an invoice

The 'correct' accounting way is to never edit an existing transaction, 
but instead, issue a 'correcting transaction'. This could be for the 
difference, or it could be first, a reversing transaction, and then the 
correct transaction. Which is used depends on various factors beyond the 
scope of this message and may well depend on the laws of your local 
jurisdiction. Your question on correct method, is an 'accounting 
question' not a 'how to do the correct thing in GnuCash question'. We 
can't give official accounting advice here.


With that out of the way...

Editing the date of an invoice is possible, but you have to un-post it 
first, make the change, then re-post.


If you are issuing a new invoice, date it however you like when creating it.

But I'm a bit perplexed as to your chosen solution. You indicate the 
client *overpaid*. Why would you issue an invoice to *charge* them the 
difference? They paid you more than they owed. They now have a credit 
with you. You owe them, not the other way around. You can carry this 
credit on your books until their next invoice, and apply it as needed, 
sending them a notice for the remainder. Or you can refund it.


Also, an over-payment doesn't cause your books to be unbalanced or 
unable to reconcile.


Did you enter the payment correctly as an over-payment?

If so, you should be able to reconcile your affected account. 
(checking?, otherwise, what accounts are you having trouble reconciling?)


If not, then you can either edit the payment, or delete and re-enter the 
payment, (or reverse it, then enter a correct one) and then reconcile.


There is no need to mess with the invoice at all.

Regards,
Adrien

On 7/7/24 4:38 AM, Michael Campbell wrote:

I was just reconciling the last quarters books and could not get the damn 
things to reconcile. I finally tracked it down to a client overpaying on an 
invoice by a small amount, transposing some digits on the invoice.
Now I am no accountant.
I thought I could fix the books by just sending the client  another invoice of 
the difference, with a nice funny charge.
Is there any way I can change the date of an invoice in GNUCash to last month 
to reconcile to the bank statements?
Is there a more correct accounting way to correct this?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Scroll Bar and QIF Import OSX


That's the horizontal scroll bar.

The vertical (what I'm guessing the OP is referring to, though it wasn't 
specified) should always be visible. Even in a register with only one 
transaction, I can see it, though the indicator takes up the entire 
height as there is nothing to scroll. If the vertical scrollbar is 
missing, that is a problem.


Regards,
Adrien

On 7/3/24 11:52 AM, David Carlson wrote:

Jim,

The scrollbar only appears when  there is a column that won't fit in the
width of the register window.  If it is not appearing and there is some
text hidden in any column, that column's width may benefit from adjustment.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 crashing after upgrade


Or install an older version in a virtual machine.

Regards,
Adrien

On 7/2/24 6:31 PM, Ernie Wakamatsu wrote:

Thanks again for your help. It sounds like my best option to get around this 
crash and inability to commit QIF import changes is to go back a couple of 
versions and wait for the next stable version of GC for MacOS.

Hmm, or pull out my old MS laptop …


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Scroll Bar and QIF Import OSX

When I was on BigSur, I was also on an older version of GnuCash, so I 
can't say exactly how the new one would work, but I don't presently see 
any issues with 5.7 on Monterey. I do recall some issues with older 
versions of GnuCash on some systems not showing it though. Perhaps 
looking over closed bugs might provide a hint. (bugs.gnucash.org—you 
don't need an account to view bugs, only to file and comment on them)


Is this a problem for all account registers?

Are you using the General Journal, or the individual account registers?

Are you using a 'filtered' view perhaps? (FILTERED indicator in the 
right corner of the status bar)


Does that register contain enough transactions to need a scrollbar?

If so, what happens if you put focus on the bottom transaction and then 
hit Enter? Does the next transaction move up into the window and get 
focus? And do you now get a scrollbar?


Regards,
Adrien

p.s.—GnuCash doesn't have 'categories'. Everything is in Accounts. 
Checking is just one account, of type 'asset'. What you formerly called 
categories in Quicken are Expense accounts in GnuCash.


On 7/2/24 4:08 PM, Jim Johnson wrote:

I’m using GnuCash really simply just as one big checkbook-register to keep 
track of my expenses in each category.

In OSX, there is no scroll-bar in my GNUCash register.

Am I missing something I need to do?

I checked all of the preferences in the GnuCash preferences window, and there 
was nothing I could find about scroll-bar.

And I rechecked my general Mac OSX Preferences to make sure that scroll-bar is 
always turned on for all applications.

Is there something I’m missing?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Account types "Bank" and "Cash"


William,

If you Edit the account, you should see a checkbox for Auto Interest 
Transfer. Unchecking it should prevent the pop-up next reconciliation.


Regards,
Adrien

On 7/2/24 3:33 PM, William Prescott wrote:

I use the "Bank" account type. When I reconcile, it opens a popup window to 
enter an interest payment. Sometimes I use it and sometimes I find it a nuisance so I am 
ambivalent about the value of the feature, but it is there.


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

Re: [GNC] Account types "Bank" and "Cash"

2024-07-02 Thread Adrien Monteleone

At the least, the informal labels change. (thus, when *not* using 
Debit/Credit)


There used to be a feature that allowed for adding an interest 
transaction for checking accounts when using the reconciliation feature. 
I seem to recall it being problematic, and so I think it was disabled, 
but I can't be certain. That would only have triggered for accounts of 
type 'bank'. (there is a comparable feature for 'credit card' type 
accounts) But if you aren't reconciling, I wouldn't think that matters 
anyway.


I don't know of any other particular reason you would want to use the 
special cash and bank types.


Regards,
Adrien

On 7/2/24 2:19 PM, Stan Brown (using GC 4.14) wrote:

Executive summary: Cash and my checking and saving accounts are assets.
What difference does it make if I assign them account types of Cash and
Bank respectively, or just assign all three an account type of Asset?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 card reconciliation - starting balance

2024-07-01 Thread Adrien Monteleone

Have you ever reconciled this account? If not, the starting balance 
should have been zero.


Regards,
Adrien

On 7/1/24 4:34 AM, Trevor Richards via gnucash-user wrote:

I am failing to reconcile a CC account. The ledger appears to replicate my 
statement in the 1st month of transactions. The 1st transaction I entered was 
the starting balance from the previous month's CC stmt (105.00) and all 
transactions appear correct in the months that follow. When I try to reconcile 
this CC account, it tells me my starting balance is 4,448.06. Where did that 
come from?

I've searched my GNUcash file and that number does not come up.
Trevor (stumped)


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 and BS

2024-06-30 Thread Adrien Monteleone

No, P are not a re-evaluation at a specific date. That describes a 
Balance Sheet.


P is a reporting of the results of transactions to expense and revenue 
accounts over a date range. (otherwise known as an Income Statement - 
there are entries for both in the GnuCash Reports menu. They are the 
same report) This is not a 'what if' report. Nothing unrealized belongs 
on it.


Regards,
Adrien

On 6/30/24 6:25 AM, Fred Bone wrote:

Why? Because the P 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 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] Exchange rate fluctuation changes historic amounts in P and BS

2024-06-30 Thread Adrien Monteleone


The transaction is set in stone, of its base currency.

If you report in a different currency that can change based on exchange 
rates to the reporting currency. This is influenced by the Price Source 
of the report Options in the Commodities tab. Unfortunately, some of 
those options don't work quite right as I understand browsing previous 
threads and IRC.


What I don't see is an option for 'nearest in time' to the transaction. 
Transactions themselves can cause exchange rate entries to the db, and 
that is what should be used in such a case. (really, I don't see a need 
to do a conversion at report time as that info already exists in the 
transaction - but this might only be true with Trading Accounts turned on.)


There might be a bug report on this already, but if not, I'd suggest 
filing one.


Regards,
Adrien

On 6/30/24 9:36 AM, G R Hewitt wrote:

Fred, thank you for your reply.

I'm afraid that I don't quite follow the logic of your explanation.

To me, as far as I am aware, the P is, basically, 'How much in' minus
'How much out' equals a profit or a loss.

A finalised transaction, surely, is set in stone - in this case 'Wood' at
€150 cost me £132.27 on Thursday and was recorded as that in the journals.
Come Monday, if the rate changes so that wood bought on the Monday now
costs £128 does not mean I over-paid by £4.27. The price was correct at the
time and now has changed, that is all. I have not gained or lost anything
at all. I might think 'Hmm pity I didn't buy it today', but that is
hindsight not accounting.

Where I taking the figures from 'pen and ink' journals, the £132.27 and
€150 would be recorded in the P as written in the journals. I can't see
that I would hurry to find out the exchange rate and write £128 instead of
£132.27 and then make a journal entry for £4.27 loss to balance the book.
And that is just one entry, what if it were hundreds?

If the P does not record the actual amounts, how can you ever come to
rely on it. Suppose you had hundreds of items you could be £1000's of
pounds out one way or the other if the rate changed on Monday and again on
Tuesday, how would you ever know what your profit or loss actually was?

When I was using Sage, the rate on the day was the rate recorded, it never
changed if the following week when something else was purchased a different
rate was applied.

Apart from which, I always thought the Balance sheet is what was used to
(re)valuate and this would support your reasoning - If my house was
recorded as an asset of €250,000 and became €275,000 due to a rate change
I'd be most please and may sell it; but if the revaluation showed it as
€195,000 then I would not be so inclined.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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?

2024-06-30 Thread Adrien Monteleone

Ken, GnuCash should, by default, set those preferences to match your 
computer's locale. If you are in Canada, unless you have a good reason 
to use a different one, your OS should be set to Canada as your locale. 
Then these preferences wouldn't be an issue.


Regards,
Adrien

On 6/29/24 11:22 AM, Ken McEvoy wrote:

Ultimately, it did turn out to be a currency issue. When I started using
gnucash (way back in version 2), I never specified or worried about
currency, because everything I did was in Canadian dollars, and all the
reports worked as anticipated. Somewhere along the line, there must have
been a change involving how currency was used to generate reports (or maybe
I specified something as Canadian dollars that I should have left alone).

In any case, once I ensured that all my accounts were set to Canadian
dollars, and the currency of choice on the commodities tab of the report
options was set to Canadian dollars, all the reports started to work again
as I had hoped.

However, for a while I was going into the options/commodities every time I
ran a report to switch the currency to CAD. Under the
Edit/Preferences/Accounts tab, I had default currency set to 'choose' and
'CAD (Canadian dollar')', but it took me a while to realize that I also had
to do this under Edit/Preferences/Reports as well.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Imbalance Records with zero amounts

2024-06-28 Thread Adrien Monteleone

I intentionally do this with relevant memo text to keep track of 
transactions I'm not sure about. That gives me an easy list via the 
Imbalance account to see what still needs to be resolved, or just give 
up and committed as-is.


Regards,
Adrien

On 6/27/24 2:06 AM, David Carlson wrote:

Well, Apparently I lied.  I just jumped to Imbalance-USD from a transaction
that I wasn't done editing and I found some old or incredibly old
transactions with zero valued splits.  However, they all had content in the
description field which was serving as an anchor to prevent the
disappearance, usually where I accidentally failed to use my special
account for comments.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Fwd: Credit and Debit Columns in Journal View

2024-06-28 Thread Adrien Monteleone

GnuCash does not use the formal debit/credit labels by default just as 
you describe. (though I personally prefer the formal labels, and 
recommend those new to double-entry turn them on at least while learning 
as that will match textbook examples)


Regards,
Adrien

On 6/26/24 8:58 AM, Sara-Jayne Slocombe wrote:


QuickBooks is really fond of simplifying things. Some packages I've used
show "Money in" and "Money out" instead of Debit and Credit as column
headers in many views. You can usually get to debits and credits with some
work. I suspect Rudy has been using a package like this.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] generating a report for a single transaction type repeated in one account

2024-06-28 Thread Adrien Monteleone

In addition to David's suggestion of doing a Find followed by an Account 
Report, you can use the Transaction Report as you noted with the text 
you want to filter on via the Transaction Filter on the Filter tab in 
the report Options.


Each report will give you the desired transactions, but they each 
present the information differently and the Transaction Report has more 
options to refine or reorganize the report. (and more filtering options)


Regards,
Adrien

On 6/26/24 11:46 AM, Ed wrote:

Gnufriends,
I'm trying to get a report from Gnucash that will display (and produce
a sum of) all instances of a particular transaction in a single
account. For example, I want to go to my checking account and see all
instances of "payroll" - a repeated transaction that takes place
more-or-less on the same day every month going back several years.
I suspect that there's a relatively simple way to do this (?) but I
don't know which Report Type to select ("Transaction"?) and how to
create a filter that will select only those transactions that have
"Payroll" in the description.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Discovered install link for Finance Quotes in Win11 app

2024-06-18 Thread Adrien Monteleone

If gnucash-cli --quotes can write to the book, then try that with the 
Windows Task Scheduler.


Regards,
Adrien

On 6/18/24 1:21 PM, David G. Pickett via gnucash-user wrote:

Only issue now is the price database window hiding itself.
Some way to easily schedule price updates would be nice.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] reconcile buttons

2024-06-17 Thread Adrien Monteleone


One design.

They even all use the GTK toolkit for drawing the UI. (though not always 
the same version across all platforms)


As for the web server idea, see the RoadMap on the Wiki. GnuCash is not 
at present following the MVC paradigm or even an 'proper' database 
application. Work is being done, but it will be several more years 
before that is even a glimmer in someone's eye.


Regards,
Adrien

On 6/15/24 9:55 PM, David G. Pickett via gnucash-user wrote:

  Perhaps it was different on Linux.  I have not done a lot of GnuCash on Win 
until lately, and did not expect there were 2 diverse designs.  Is the code 
that diverse between platforms?  Maybe we should turn GnuCash into a web server 
so the client can look the same on every platform?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 Register Right Click Options

2024-06-17 Thread Adrien Monteleone


Good to know, thanks for reporting back on the resolution.

Regards,
Adrien

On 6/14/24 8:37 PM, j a wrote:

Hi, Adrien,

This is to confirm that the issue has been resolved. It was due to a
misconfiguration on my Gentoo Linux system. I inadvertently compiled some
packages with flags that caused the issue.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Color tabs: General Journal

2024-06-14 Thread Adrien Monteleone


Correct. Neither has an ID.

Regards,
Adrien

On 6/12/24 8:50 AM, Stan Brown (using GC 4.14) wrote:

Thanks, Adrien.  I'll enter the request for enhancement and mention both
General Journal and the Accounts tab, which I'll bet is also not
separately ID'd.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 255, Issue 13

2024-06-14 Thread Adrien Monteleone


Bruce,

Try this:

Set the Journal to show all transactions in Preferences.

Set a filter while viewing the Journal to the period in question.

Run an Account Report.

You can do the same with individual accounts.

The Transaction Report is also very powerful and can be customized quite 
a bit. I don't think it can paginate per account though.


Regards,
Adrien

On 6/12/24 3:56 PM, Bruce Irving wrote:

There is one feature I would like to see, though I doubt many would have a
use for it.  I learned bookkeeping BC (Before Computer) so I learned the
paper/pencil method.  I wish there was a report that would let me print a
General Journal much like what appears on screen for a particular period.
I would also like to print the various active accounts: Date GL 1st
Description, with debit and credit columns.  While I would like a running
balance, I believe the proper way was totals at the bottom.  Oh, and each
account would be its own page(s).


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 now only opens a report

2024-06-12 Thread Adrien Monteleone

Indeed. I guess I never encountered it because I only use tabs and don't 
open reports or registers in separate windows. (*not* using separate 
windows will avoid this issue)


Regards,
Adrien

On 6/12/24 3:17 AM, Geert Janssens wrote:

You can close it as follows:

- Start gnucash
- open a report in a new window
- close the original window

=> you will be left with a window that only holds the report

This is a bug. And I *thought* I had fixed this a long time ago. So either it's 
back or my fix
was bogus.

The workaround is indeed as already mentioned: use View -> New account 
hierarchy to
reopen this tab.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 Register Right Click Options

2024-06-11 Thread Adrien Monteleone

Anytime you have an issue with something not working properly, please 
also include your Operating System. (and version)


I can confirm that the right-click also works fine on 5.6 using MacOS 
12.7.5 Monterey.


I seem to recall some context menu issues (what you get when you 
right-click) way back in the early 3.x days, but those have long been 
resolved.


Something may be amiss with your particular system.

Regards,
Adrien

On 6/11/24 2:42 PM, j a wrote:

I recently upgraded GnuCash from 4.13 to 5.6, and immediately noticed that
the options presented when performing right click options in a register
have been removed.

Please advise of how to implement options that were previously accessible
by right click in a register, including the following:
- sort register entries;
- filter register entries;
- jump to a different register;
- split a transaction
- schedule a transaction


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Color tabs: General Journal

2024-06-11 Thread Adrien Monteleone

I fired up the inspector and poked around. Unfortunately, I didn't see 
any way to target just that tab for styling. It would need an ID 
(optimum) or class to write a CSS rule.


So the only avenue left is to file an RFE on the bug tracker and ask to 
add the ability to set the tab color for the General Journal. (or give 
it an ID or class to expose it for CSS styling)


Regards,
Adrien

On 6/11/24 10:26 AM, Stan Brown (using GC 4.14) wrote:

I've never used GTKInspector, and to be honest I don't think the minor
victory of coloring that tab would justify the time I'd spend in
learning curve. Again, thanks for confirming that I didn't miss
something in the UI.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 now only opens a report

2024-06-11 Thread Adrien Monteleone

GnuCash opens whatever tabs were open when you shut down. Why the 
Accounts tab doesn't come back up for some folks, I have no idea, as I 
don't know of a way to close it. (it is always visible for me)


But you can certainly bring it back up via the View menu as you have 
discovered.


Regards,
Adrien

On 6/11/24 10:19 AM, fromvendor wrote:

Hi Bruce, this has occurred to me.

On the View menu, select the 'New Accounts Page' and it will open the (in my 
mind) the main view again.

I've done this a lot and I'd love an option to always open the Accounts page 
when starting the program.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Color tabs: General Journal

2024-06-10 Thread Adrien Monteleone

Not in the UI, but perhaps with a CSS file. You'll want to fire up 
GnuCash with the GTKInspector to find out how to target that one tab, if 
it is even possible.


Regards,
Adrien

On 6/10/24 8:34 PM, Stan Brown (using GC 4.14) wrote:

I set the color on a couple of accounts, and then went to Edit »
Preferences » Accounts and ticked "Show the Account Color on tabs".

I always have the General Journal open, filtering it to just last
month's and this month's transactions. Is there any way to assign a
color to its tab? I looked at the preferences and right-clicked here and
there, but couldn't find anything.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Clearing filters on account registers

2024-06-10 Thread Adrien Monteleone

Tabs don't change color on their own. You have to do that intentionally 
by editing an account and setting a color. This has nothing to do with 
filters.


Make sure that Preferences > Register Defaults > Number of transactions 
is set to ZERO to show all transactions.


While you mentioned the "Show All" on the Filter by... > Date tab, check 
the Status tab also and check all that apply to *show*. (I always show 
all transactions, and that might be a good place to start, then uncheck 
those you later don't want to hide)


The file list is not inaccessible. The location is documented on the 
Wiki. (and in threads here on the list)


Regards,
Adrien

On 6/10/24 7:25 PM, Paul Chaney--First Certified Arbor Care wrote:

I'm aware of the filter function accessible from the context
(right-click) menu when in registers.  The filters are selected for
"all", in other words, no filtering.  But one would think those filter
selections would determine which transactions show, but in my case, only
those after the current date appear.  The register tab appears green,
which seems to indicate a filter is being applies.  I see no switches to
turn that filtering off.   In Windows, there is a hidden folder called
appdata, and a subfolder called roaming.  In that, there is the gnucash
folder with its own subfolders.  I see a link to this in the Gnu Cash
"help/about" screen.  The files are user-editable.  One of the
subfolders called "books" has a list of the files I have created with
Gnu Cash.  But the file menu of Gnu Cash has a list of recently-opened
files just above the "close" and "quit" options.  That list includes
file names that are not in "books" subfolder, so that list of previously
opened files has to be stored somewhere. When I open Gnu Cash, and it
wants to open a file that has been deleted, a prompt appears asking if I
want to delete the file name from the list, indicating that this list
has to be stored somewhere. I suspect  this data, including the data
that is filtering my register, is stored in an inaccessible hidden file
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Clearing filters on account registers

2024-06-09 Thread Adrien Monteleone


Paul,

To further a bit on David's advice, see the Wiki about File Locations. 
Note the locations of GnuCash files for your particular OS.


Then copy over the appropriate (or all) files between the two machines.

Note, if you make any preference or settings changes, then you'll have 
to re-sync the appropriate files.


That wiki page will also shed some light on which files to pay attention 
to for various types of settings. (general preferences, suppressed 
warnings, saved report configurations, etc.)


Regards,
Adrien

On 6/9/24 10:41 PM, David Carlson wrote:

There are some settings that are associated with the user who is currently
operating the computer that the program is running on rather than the
particular data file that is opened.  I think you are having issues with
some of those settings being different between your two computers, probably
because you didn't realize that it wasn't set in the data file.


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

Re: [GNC] Clearing filters on account registers

2024-06-09 Thread Adrien Monteleone

In any register, if a filter is applied, the right end of the Status Bar 
(top or bottom of the tab, depending on a preference) will say 
'Filtered' to alert you of that fact.


If that is visible, then simple click View > Filter by..., and clear or 
update the filter to match the other computer.


Regards,
Adrien

On 6/9/24 8:44 PM, Paul Chaney--First Certified Arbor Care wrote:

Hi

I'm a new user.

My wife and If have set up our COA and have entered transactions
beginning 1/1/24 in some accounts.
We want to use our file between two computers as we did with
Quickbooks.  We kept the file in Dropbox, and it worked fine just as
long as only one of us used the file at a time.  We tried this with Gnuj
Cash, and it did appear to work.  The files would synchronize.  But
then, it seemed that the files were not synchronizing correctly.  So We
decided to keep the files on a USB flash drive, and pass it back and
forth as needed.

At first, we could see all accounts with all transaction, but on my
computer, *a filter somehow got stuck on the bank account register*, and
on some other of the registers, so that only the transactions after
certain dates appear.  Using the same data file, the behavior is
different between computers.  It is as though a setting was made in some
software switches that make this happen only on my computer. To address
this, I uninstalled, then reinstalled v.Build ID: 5.6+(2024-03-30),
which is the same as on the other computer.  I also saved the file with
a new name, but that has no effect.

However, when I went to open Gnu Cash, a history list of previously
opened files appeared in the file menu. This told me that there were
settings on my computer that did not get removed during the uninstall.
All of the files at the links in the "about" screen had been cleared,
including those in program files and in appdata/roaming.  I suspect that
there are other files in folders that I can't access that stored the
history data and whatever other settings are affecting the performance
on my computer.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Reconciliation Roll Back (Peter Cuthbert)


You don't need to roll back a reconciliation that is now out of whack.

If need be, un-reconcile that transaction split, then re-reconcile.

Regards,
Adrien

On 5/29/24 8:33 AM, Peter Cuthbert via gnucash-user wrote:
So final thought for the GNUCash programmers.  Please consider a 'roll 
back' facility so that one can correct mistakes.  Indeed an 'opening 
balance' entry request for Reconciliations would be useful with a 
warning message that the value one has entered is not what the system 
holds.  If that happened one would not go ahead with the reconciliation, 
but go back and look for obvious mistakes.


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

Re: [GNC] Reconciliation Roll Back (Peter Cuthbert)

GnuCash is supposed to warn you when editing a reconciled transaction 
that would change the flag.


If not, perhaps you turned that message off.

Check Actions > Reset Warnings and look for something like "change 
contents of reconciled split". If it is there, select it and Apply to 
reset the warning to show up next time. (and next time, don't click the 
box to never warn you again)


If it is not there, and you can intentionally repeat an edit without 
getting the warning and see the transaction un-reconcile, then you found 
a bug. Please report it.


Regards,
Adrien

On 5/28/24 12:49 PM, Blake Hannaford wrote:

I find this has been a longstanding problem.   Every once in a while, old
transactions get unreconciled.  I always open GC the same way so I'm sure
I'm not opening backups.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Reconciliation Roll Back


And I learn something new everyday. Thanks David!

Regards,
Adrien

On 5/28/24 9:17 AM, David Carlson wrote:

A tidbit of information that you may find helpful:  If you hover the mouse
over the "y" character in the reconcile box in an account split line, the
date of the reconciliation for that account split in that transaction
appears in a flyover.  It may take a couple of seconds to appear.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Running balance/total from search results is always $0.00

If the Memo field is your only criteria, then just use the Transaction 
Report and use the Filter tab for your Memo text.


Note, you'll need to decide which account you are summing on the report 
though. (likely the same issue with the Account Report) In the case of 
multiple expense accounts for one or more transactions, you'd want to 
sum and sort off the source account for the funds, usually an asset, but 
could be a credit card or other liability. Be warned though, that will 
be the sum of the entirety of those transactions, not just the 
individual splits you want to highlight. So if there are other 
non-interesting splits in those transactions that balance the source 
funds, they'll get included as well.


Regards,
Adrien

On 5/29/24 12:42 AM, Chandler via gnucash-user wrote:

     I'd like the sum of the values from entries with certain criteria in
the "Memo" field in an expense account.  I can get the list of
transactions containing these entries by searching the Memo field.
Then, everything I found says I can open a Report > Account Report to
get the running balance/total, however that column always remains $0.00
for me.

     I wonder if this has to due with the double-entry bookkeeping I'm
using?  The display is also complicated by the fact that these
transactions can include 3 or 4 different expenses which means instead
of just 2 lines for funds in/funds out, there could be 8 lines for funds
in/out of 4 different accounts, all of which are shown in the Account
Report, yet I'm only interested in the values from the one account I
performed the initial search from.

Using Gnucash 5.6


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

Re: [GNC] Using GnuCash with charity restricted and unrestricted funds, advice wanted

2024-05-27 Thread Adrien Monteleone


Both Michael & user 'flywire' have offered the 'how to do that' answer.

Michael's answer involves out-of-the box reports that are further 
manipulated outside of GnuCash to achieve the desired end result, using 
the standard method of entering transactions. (this is quite normal for 
anything but the most basic of reporting needs)


Flywire's answer involves a custom report that someone else was kind 
enough to craft, that you have to add to GnuCash yourself first and then 
use 'tags' in your transactions for your extra reporting dimension.


But in both cases, none of us know what the legal requirements of your 
jurisdiction are. We can make suggestions and offer general guesses 
based on the reasoning of what the term 'restricted funds' means with 
respect to where they belong in the account tree, but if your accountant 
or legal counsel tell you otherwise, you have to follow what *they* tell 
you, not take the suggestions here. If you are not sure how to follow 
*their* advice using GnuCash, we can probably help, or at least suggest 
that you may have to do some finishing work on your reports with other 
software.


Regards,
Adrien

On 5/27/24 8:12 AM, Edward Bainton wrote:

You have to know that first, then ask, "How do I accomplish this using

GnuCash?"

Think of funds accounting as different colours of money. Every account and
every category can include any colour of money.

I need the gross figure for each account and category, the figure for each
account and category broken out into the colours of money that it’s
comprised of, and I need to report on the overall financial position and
movements in any given period of each colour of money, detailing which
accounts and categories it’s comprised of.

How do I accomplish this using 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] Using GnuCash with charity restricted and unrestricted funds, advice wanted

2024-05-26 Thread Adrien Monteleone

This is a perfect example of why this list is not the place for 
accounting advice.


We can't answer, "What should I do?"

You have to know that first, then ask, "How do I accomplish this using 
GnuCash?"


In many cases, the answer is, "The same way you'd do so with Pen & 
Paper." (sans the actual pen and paper of course)


At best, folks here can offer generalizations. Exact implementation 
absolutely *must* be done in consultation with local professionals 
versed in the laws of your jurisdiction if your issue is anything but 
mere personal musings, and in any case where you have any official duty 
or legal obligation.


Regards,
Adrien

On 5/26/24 12:37 PM, Michael Hendry wrote:

I was keen to keep track of restricted funds within GC in a way which would 
make unspent restricted income persist as restricted funds beyond the year end, 
and you suggested the use of a Liability account for this purpose,

Unfortunately, the accountant who examines our accounts before submission to 
OSCR (the Scottish Charities Regulator) advised that this isn’t an acceptable 
way to handle restricted funds in the UK.

The problem with using the income accounts (as below) for the various types of 
Income, is that the money not spent (in our case on bursaries for musicians who 
wouldn’t otherwise be able to attend our courses) doesn’t persist in the that 
account after the year end the way a liability would. A collection at the 
final-day concert which is advertised as being destined for use as bursaries 
won’t be spent until the next year’s course.

On the other hand, if income received for restricted donations is accounted for 
in this way, and funds paid out as bursaries are also accounted for in a 
separate expense account it should be easy enough to keep a year-on-year tally 
of the remaining restricted funds. In practice, we probably spend more than we 
receive on bursaries each year, but a church roof might be a longer-term job.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 should I enter values on a budget in gnucash ?

2024-05-24 Thread Adrien Monteleone


Daniel,

The Budget module needs lots of testing.

Some changes were made (not sure at what release) to sort out issues 
with negative signs and the book preference for 'reverse balanced accounts.'


I used to use this module quite a bit, but about that time, I fell 
behind and haven't gotten back to it.


When that happens, I'll report back in this thread if I find similar 
issues as you, and/or if I find answers/solutions.


Regards,
Adrien

On 5/15/24 6:37 PM, Daniel Sheffield wrote:

Hi all,

I am using Gnucash 4.8. I'm facing the issues discussed here.

I see a bunch of issues here:
https://bugs.gnucash.org/buglist.cgi?component=Budgets=GnuCash=---

Specifically I am hitting these:

* https://bugs.gnucash.org/show_bug.cgi?id=797870
* https://bugs.gnucash.org/show_bug.cgi?id=689754

I've seen a bunch of comments in this e-mail thread about user error or
user preferences. Fact is the budget feature is just plain wrong as there
is currently no form of user entry that gives consistent results in the
following areas:
* Budget Chart - plots actual vs budget bar chart
* Budget Editor Income/Expense/Transfers/Total - this seems to be where the
math error is
* Budget Balance sheet - I don't use this one, but can confirm that it
behaves as described in the issues above.

What I desire:
* Budget Editor Income/Expense/Transfers/Total is correct so that I can
tell at a glance if I've made a mistake in my budget.
* Budget Chart - I need the credits and debits to be plotted in the same
direction. I don't care whether the Reverse value for Credit Accounts is
set or not or which direction debits/credits are plotted so long as they
are consistent.

What I have been doing as a work around:
* In the Budget Editor I put debiting a liability [thus decreasing my
liability] as a +ve value and crediting a liability [thus increasing my
liability] as a -ve value. If I make corresponding transactions in my
accounts, then the Budget Chart of actuals vs budget agree.
* In the Budget Editor I put crediting my Income as a +ve value and
debiting an Expense as a +ve value. If I make corresponding transactions in
my accounts, then the Budget Chart of actuals vs budget agree for Expenses
but are opposite (diverging graph) for Income. But that's OK because I
don't include income in my Budget Chart.
* In the Budget Editor, the totals are calculated like: Remaining to Budget
= Net Income Credits - Net Expense Debits + Net Transfer Debits (where
debits are positive values on the budget sheet and credits are negative
values on the budget sheet). Note that again, the "Reverse value for Credit
Accounts" setting has no effect on the charts or the budget editor as far
as I can tell.
* Thus, the +ve values on my liabilities increase the total remaining to
budget!
* I can rectify the total remaining to budget by using -ve values for
debiting a liability, but if I do that my Budget Chart is off (I include
Expense and Liabilities in my chart).
* So instead, I do a crazy hack: For every +ve value in a Liability, I put
a corresponding -ve value in Equity and a +ve value in Assets.

The result is:
   * The total remaining to budget is correct
   * The Budget Chart shows actuals that go in the same direction as budget
values for Expense and Liabilities.
   * The Budget Report is incorrect for liabilities - but I don't use this
feature - I use the Budget Chart instead.
   * I have to remember to put the hack values in my Assets and Equities on
the Budget Editor (making room for error).

This whole thing makes me afraid to use the budget feature.
As my wife is used to an Envelopes (Single Entry) system rather than Double
Entry accounting, it's critical that I can have a reliable budgeting
feature (essentially what single entry is looking at).

At this point, I'm seriously considering changing my method to the
following:
* Put all values in budget editor as +ve for a debit and -ve for a credit.
* The estimate feature will be applying sign reversal inconsistently with
this approach - but this is less error prone to reverse (multiply each
value by minus -1 as necessary).
* The total remaining to budget will be completely wrong, but I can
calculate this myself by looking at the rolled up top level accounts
(assuming I haven't hard-coded values in any of these accounts). That is,
summing the totals on the top-level accounts should add to zero.
* Assuming corresponding transactions entered in the accounts, ie, sticking
to budget, then all the accounts on the Budget Chart will show actuals
agreeing with budget, including Income accounts (and Equity accounts too?).
* Differences on Budget Chart will be shown correctly (in terms of
magnitude), though wrapping my head around the sign reversal will be a pain
- but this is the "normal" confusion I face with meaning of credit and
debit in terms of accounting vs colloquial usage.
* Budget Report is still wrong (sign reversal applied to Liabilities in
Actual but not in Budget values). But I don't use this feature.
*

Re: [GNC] [gnc] Forecasting savings

2024-05-22 Thread Adrien Monteleone


There is a budget module.

Otherwise, you can use scheduled transactions, or just enter 
transactions in advance and run relevant reports. As the real-world 
transactions happen, edit those already entered to reflect any differences.


If you want to preserve the prediction vs. actual, you might have to do 
this in combination with the budget modules.


However, there are other tools better suited to this than GnuCash.

GnuCash is for recording actual transactions, just like a pen and paper 
ledger.


Regards,
Adrien

On 5/22/24 12:48 AM, Adrien Laveau wrote:

Hello community, I would like to know what is the best way (if there is) to
project savings evolution in gnc based or scheduled transaction (income,
tax, average spending, loan etc...).

The goal is ti properly budget and know if at some time a more important
transaction is reasonable or not (install A/C, buy a car etc...)


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Easier way to print to PDF

2024-05-20 Thread Adrien Monteleone

PDFs that are images are almost always scans of physical paper without 
an OCR step. Though, I'm sure some 'printers' take the image route 
rather than create a proper PDF. (Portable Document Format)


Regards,
Adrien

On 5/20/24 7:43 PM, David G. Pickett via gnucash-user wrote:

PDF pitfall: some apps print a graphical file, which cannot be searched, and 
some print text with annotations to set position and font size, name, bold, 
italic, underlined, which can be searched.  You can even find apps to convert 
the first to the second!  My presbytery sends out the first, despite my 
attempts to educate them.  Probably the MS thing!


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Easier way to print to PDF

2024-05-20 Thread Adrien Monteleone

Does this answer your 
question?:https://askubuntu.com/questions/1263902/how-to-quickly-modify-cups-pdf-printer-output-folder-setting


If not, you can set bookmarks to other locations in that file dialog. 
While this won't change the default, it would just be one extra click on 
the bookmarked location rather than navigating your directory tree every 
time.


The bookmarks appear under the standard set of locations.

If I'm not mistaken, it's just a drag-n-drop operation to add a bookmark 
to that left pane.


Regards,
Adrien

On 5/19/24 6:33 PM, Daffy Duck wrote:

Linux.  The issue is, every time I try to print to PDF, it starts at
home directory, which takes forever to get back to where I was printing
to.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Adrien Monteleone


Any reason not to use CTRL+A?

Regards,
Adrien

On 5/19/24 9:08 PM, Joseph Keithley wrote:

If the whole left-click hold copy and drag doesn't work well, there is an
alternate method.  When you move the mouse cursor to the top left of the
tab, move the cursor slowly to the right until the mouse cursor changes
from an arrow to a line (assuming your PC set up is similar to mine) and
left-click the mouse. Then hold down the shift key (with a finger on the
hand that doesn't work the mouse).  Then, using either the "Page Up/Down"
keyss, the arrow keys, or by clicking and/or dragging the scroll bar,
navigate to the end of your desired data.  Release the shift key and then
left-click the end of you data.  All your data should be highlighted.
Right-click the mouse and then left-click on "Copy".


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 1.62 released!

2024-05-16 Thread Adrien Monteleone


Bruce, et al,

Coding can be fun in many cases, but you seem to find solace in the 
mindbogglingly headache-inducing game of whack-a-mole, to everyone 
else's benefit!


Thank you for the insane amount of effort you put forth on this project.

I have yet to use (or profit) from all of it, but even in my limited 
exposure, I know that if I ran into a snag, many folks would be there to 
guide me along, and not just 'because', but because *you* make the 
effort to keep F::Q humming along. Without this project, many folks 
would be in quite the 'inedible' pickle.


Cheers,
Adrien

On 5/16/24 8:19 PM, Bruce Schuck wrote:

New version 1.62 of Finance-Quote is available with the following changes:

* Fixed AEX.pm
* Removed throttling from AlphaVantage.pm - Issue #363
* Added CurrencyFreaks.pm - new currency module
* YahooJSON.pm - added more error handling - Issue #390
* Fixed MarketWatch.pm module - Issue #389
* Fool.pm - Rewrote Fool.pm and added back to F::Q. Issue #379.
* New Module! StockData.pm. Methods stockdata, nyse, nasdaq.
* Modified yahooJSON.pm module in order handle EU consent redirects 
better.
   * TwelveData.pm - Added "last" to data being returned
* BorsaItaliana.pm - New module for Borsa Italiana, Italian traded 
bonds using ISIN
* YahooWeb.pm - Issue #377. Modified YahooWeb to account for changes 
from Yahoo.

Authors:
   - Erik Colson 
   - Paul Fenwick 
   - Bruce Schuck 
   - Vincent Lucarelli 
   - David Hampton 
   - jvolkening 
   - Pawel Konieczny 
   - Mike Alexander 
   - AndreJ 
   - Vinay S Shastry 
   - Bradley Dean 
   - Brent Neal 
   - Jacinta Richardson 
   - e-dorigatti 
   - goodvibes2 
   - Paul Howarth 
   - Sam Morris 
   - Linas Vepstas 
   - Hiranya Samarasekera 
   - Manuel Friedli 
   - Achim Winkler 
   - Diego Marcolungo 
   - John Haiducek 
   - Rajan Vaswani <111571283+bgr22...@users.noreply.github.com>
   - alex314159 
   - gregor herrmann 
   - Jalon Avens 
   - Sigve Indregard 
   - bgr22112 <111571283+bgr22...@users.noreply.github.com>
   - goodvibes2 
   - Ben Hemming 
   - Caleb Begly 
   - CleanShed <72849657+cleans...@users.noreply.github.com>
   - Eelco Dolstra 
   - Emmanuel Di Pretoro 
   - Florian Schlichting 
   - Gabor Szabo 
   - GitGord <46006740+gitg...@users.noreply.github.com>
   - Gustavo R. Montesino 
   - Henrik Ahlgren 
   - Jean-Marie Pacquet 
   - Joseph Heron 
   - Lance Wicks 
   - Liviu Tinta 
   - Martin Kompf 
   - Pete Ratzlaff 
   - Ross Peachey 
   - Stephan Ebelt 
   - Stephan Gambke 
   - linas 
   - thinus 
   - x42x64 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Use of cash discounts in business account tree

2024-05-16 Thread Adrien Monteleone


I am no accountant, but that doesn't sound quite correct.

If you put the Cash Discounts account under Expenses, then that would be 
a contra-account as it reduces the price of your expenses you pay the 
wholesaler. So that credit is correct, but I don't see that there should 
be a debit to your checking account. It isn't like you received funds in 
return, you just paid less out. So that might look like:


Dr. Expenses:something   100
  Cr. Expenses:Cash Discounts Received10
  Cr. Assets:Checking 90

On the other side, when you are the seller and offer a cash discount, 
that too could be an expense (but this time not contra-balanced) 
however, it might be best *not* to use the same account as above due to 
the potential need to track the discounts you offer being muddled with 
the discounts you receive. As well, there shouldn't be an equal debit to 
Checking here, but rather less money received like so:


Dr. Assets:Checking 90
Dr. Expenses:Cash Discounts Offered 10
  Cr. Income:Sales 100

Some texts and accountants might counsel that this Cash Discount account 
should instead be a sub contra-account of Income:Sales as it is really a 
reduction of Sales, rather than an expense, but that would depend on 
your needs, situation, and legal requirements.


*notice - none of the above is specific to GnuCash, thus, this is an 
'accounting question', not 'how do I do this in GnuCash' question.


We're happy to offer *ideas* here on such questions, but *NONE* of those 
ideas are *advice*.



Regards,
Adrien

On 5/15/24 5:25 PM, nisp1953 wrote:

WHen I get a discount from a wholesaler, then there is a credit to
Cash discounts,
which is an expense. There is also a corresponding debit to my
checking account.
When I issue a site wide discount there is a debit to the cash
discount but a credit
to the checking account. Am I doing that correctly?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Unable to Refine Existing Search

The Transaction Report has a Filter option that takes simple text as 
well as a Regular Expression.



Regards,
Adrien

On 5/14/24 2:24 AM, Patrick Skelton wrote:

I realise what I am really wanting here is a custom report but I need it to
contain only records containing a certain string and I can't see how to get
the reporting to do this.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 transfer customer and vendor information from a previous GNUCash file?

Please remember to hit reply-all or reply-list so others can participate 
and benefit from the discussion.


-
While you can't delete an Invoice/Bill, you can reuse them.

When I end up in such a situation, I change the document ID to "Use 
Next" so I can find it easily, and then simply edit it as needed before 
posting.



Regards,
Adrien

On 5/15/24 12:50 AM, Wesley Brooks wrote:

I just wanted a fresh start on the accounts. I do realise GNUCash is fine to 
keep using the same file indefinitely. I've been using GNUCash for a couple of 
years now, and my approaches and preferences to entering the data has changed. 
I don't want to continually have the old data there and a nagging desire to 
waste my time and go back and edit it to fit my current way of handling the 
data. I also don't like the way scrapped invoices and bills aren't ever really 
deleted either, kind of hanging around like ghosts.

I will add in the customer and vendor information as required.

I use GNUCash to keep my records, and then pass the data to my accountant for 
final check through and submission. I inevitably end up with edits I need to 
make to my records and save another pending post to this forum a fresh start 
with corrected opening balances is an easy way of achieving these corrections.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 enter an accrued expense before Invoice?

Please read over my original reply again. I gave you the transaction 
templates that illustrate what you are looking for.


Step 1 is recording the accrued expense. This should be dated when the 
expense was incurred. (when service rendered)


Step 2 is entering the Vendor Bill which accomplishes the goal of moving 
the accrued expense to liabilities. (this should match the Vendor's date 
on their Invoice to you) Do *not* select the 'Expense' account here for 
your line item. That has already been affected in step 1. This time, you 
select the Accrued Expenses account instead.


Step 3 would be paying the Bill, reducing liabilities. (this is the date 
you actually remit payment)


-
As for payments unlinking themselves when unposting a Bill/Invoice that 
is normal. It however should do its best to automatically re-link that 
payment when you re-post the document after editing.


If it does not, you do not need to delete and re-enter the payment. 
Simply 'Process Payment' via the Toolbar Icon, and select both the 
document you are paying (bill or invoice) *and* the offsetting payment 
transaction. Adjust any details of the payment as needed *other than* 
the amount. (that was already entered the first time)


Regards,
Adrien

On 5/15/24 1:57 AM, Wesley Brooks wrote:
I understand what an accrued expense is, and how in theory it should 
work. But I haven't seen how to enter it in a way that when I raise the 
bill following the above process the debt moves from the Accrued 
expenses to the Accounts payable account?


A little frustration with the system as it stands at the moment is that 
if I subsequently need to edit a bill (wrong date, missed description 
when posted, typo in line, etc), if I unpost it make a change then 
GNUCash forgets the connection between the bill and the transaction that 
cleared the bill. I then need to delete the payment that cleared the 
bill and then re-enter it.


Does that explain the question better?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 enter an accrued expense before Invoice?


That's only if you do everything manually as you describe.

You could also use the Business Features to enter the Accountant's 
Invoice (Bill) to you, and then enter a payment to clear it.


The line item(s) of that Bill, would connect to your Accrued Expenses 
account, though admittedly, not directly to any specific entry in it. 
(though you can roughly accomplish this with proper 
Description/Notes/Memo fields.


Depending on your needs, you may want to investigate unchecking the box 
to 'accumulate splits' when posting a Bill, as that way, all line items 
will appear in the affected registers, rather than multiple line items 
to the same account being consolidated.


Regards,
Adrien

On 5/15/24 3:01 AM, Wesley Brooks wrote:
So in summary from how I now understand this GNUCash doesn't have any 
method of linking the accrued expense to the invoice, it just has to be 
processed manually.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-14 Thread Adrien Monteleone

A confirmation dialog that the Check & Repair was completed (maybe even 
with or without incident or a summary) would be nice to have, but I know 
the devs already have a full plate.


Perhaps file an RFE (Request For Enhancement) in the bug tracker if that 
one doesn't already exist.


Regards,
Adrien

On 5/14/24 10:02 AM, Phyllis Bruce wrote:

Thanks Richard, that helps too.  Didn’t know there was a progress bar
when I was trying to run 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] How to transfer customer and vendor information from a previous GNUCash file?

2024-05-14 Thread Adrien Monteleone

As far as I am aware, there is no means within GnuCash to export/import 
Business Features setup data such as Customers, Vendors, Employees, or 
Tax Tables.


You can import Invoices/Bills from a CSV, (such as data generated by 
another app) but you can't export them. (outside of running relevant 
Transaction reports)


-

But I would ask, why do you want to start with a fresh file simply 
because the year changed?


Why do you think that is necessary or desirable?

GnuCash is designed to happily continue with the same file (book) in 
perpetuity.


Let us know your goals for doing so, and we can further assist. There 
may be better ways to accomplish those goals than starting with an 
entirely new file each year. (though you can if you want of course)


Regards,
Adrien

On 5/14/24 8:43 AM, Wesley Brooks wrote:
I am trying to create a fresh start on my accounts for the next 
accounting year.


I can see how I can export and subsequently import the account tree. I 
would like to do the same for customers and vendors.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 enter an accrued expense before Invoice?

2024-05-14 Thread Adrien Monteleone

This is essentially a basic accounting question, not so much 'how to do 
this in GnuCash.'


The exact accounts used are up to you, but generically between an 
accounts such as:


Dr. Expenses:Professional Services
  Cr. Liabilities:Accrued Expenses

When the invoice is received, draw down the Accrued Expenses account to 
an Accounts Payable account:


Dr. Liabilities:Accrued Expenses
  Cr. Liabilities:Accounts Payable

(when you pay the invoice, you'll draw down the Accounts Payable account 
to whatever Asset account you used as a source of funds, e.g., 
Assets:Checking, as with any other Vendor Bill)


In the case of using the GnuCash features, you can enter the accrued 
expense manually or via an SX. (Scheduled Transaction)


Then when the accountant's invoice is received, enter a Vendor Bill in 
GnuCash with the line items posting to the relevant Accrued Expenses 
account, and posting the entire Bill to the relevant Accounts Payable 
account.


The date of booking the Accrued Expense should be when the expense was 
incurred, thus, when you received service from the accountant.


The date of the Bill should be the date of the accountant's invoice.

The date of the payment is the date you effectively paid it. (usually 
the 'tender' date, such as post-marking if sent by snail mail) There are 
also 'received' and 'cleared' dates in some cases, but those are not 
always relevant to when a debt was considered 'paid' but that will 
depend on your specific jurisdicition and circumstances. (those may be 
relevant to reconciling your bank/credit account however, if it factors in.)


As always, this isn't accounting advice - ask your accountant!


Regards,
Adrien

On 5/14/24 8:39 AM, Wesley Brooks wrote:
I'm a basic level user of GNUCash, and generally enter transaction 
details mostly by raising bills/invoices and subsequently processing the 
payments. The only exceptions to this are how I enter my salary 
payments, and transfers between my company and private accounts covering 
director loans and repayments.


My accountant has added their charge for accounting and an accrued 
expense on their submissions, long before they would raise an invoice.


How do I generate an accrued expense so that it works with a 
subsequently raised the invoice, and processed payment in the following 
year?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-13 Thread Adrien Monteleone

I think there were issues too with reports on Linux with NVIDIA graphics 
though there is a workaround and if I'm not mistaken, now also a fix.


Regards,
Adrien

On 5/12/24 6:03 PM, Paul Kroitor wrote:

You're on a Linux platform so it won't directly matter, but be aware that
the Windows 5.5 version has a major bug (many reports don't work). It's
fixed in 5.5.1 and 5.6, so if you ever share your data files into the
Windows universe, it's unlikely it would be to 5.5.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-11 Thread Adrien Monteleone

Correct. The Check & Repair should run silently automatically upon first 
opening your file with 5.5, but it doesn't hurt to do it intentionally.


The biggest change I recall between 4 & 5 is the new type-ahead search 
method for the Description field. I personally prefer the change, but 
some folks didn't like it by how they use that field and their unique 
list of existing Descriptions.


There is also an issue for some, but not others with respect to 
registers not auto-filling memos from previous session transactions. 
(I'm one so affected) Mileage may vary on that one.


As always - keep a backup.

And since you are not on the last 4.x release on the old machine, I 
wouldn't go back and forth with the same file. Once you migrate, stick 
to 5.5 or drop back to 4.8 and stay there until you decide to finally 
make the upgrade should you notice any problems.


Regards,
Adrien

On 5/11/24 3:08 PM, Chris Green wrote:

So, given that I'm going up just one major release I shouls be OK, but
running "Check & Repair" before doing anything else is a good idea.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] [resolved] Re: no drop-down accounts list in ledger Transfer column.

2024-05-09 Thread Adrien Monteleone


You're welcome.

Though, I don't think those AppImage builds are from the GnuCash 
development team. Caution is advised.


Regards,
Adrien

On 5/9/24 5:59 AM, v@scottsonline.org.uk wrote:

On 09/05/2024 01:16, Adrien Monteleone wrote:

Any opposition to using flatpak? You wouldn't have to wait.


I avoid flatpak, having heard bad things about it. However (and thanks 
for the idea) there is an appimage version on github. I've downloaded 
4.13 and given it a quick test, and it does indeed seem to have the 
issue fully resolved.


I'd not realised these were available. Looks a likely way of keeping a 
common gnucash version across different OS versions.


Many thanks.


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

Re: [GNC] [resolved, sort-of] Re: no drop-down accounts list in ledger Transfer column.

2024-05-08 Thread Adrien Monteleone


Any opposition to using flatpak? You wouldn't have to wait.

Regards,
Adrien

On 5/8/24 3:18 AM, v@scottsonline.org.uk wrote:
That could explain things. Unfortunately, I can't (readily) install 4.13 
on mint - even the latest mint 21.3 has libraries too old for the deb's 
off the website. But thanks for the info - at least I can look forward 
to the next mint upgrade that should sort things. Meanwhile, I can 
muddle through :-{


Thanks to you and to Adrien for replying.




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 drop-down accounts list in ledger Transfer column.

2024-05-07 Thread Adrien Monteleone

Hmm.. it has been many moons since I made the move from 3.x to 4.x, so I 
don't see an obvious preference either. But perhaps toggle the:


  Preferences > Register > Actions > Auto-raise lists

checkbox and see if that helps.

If not, note as I mentioned, you should still be able to type through 
the tree as before to narrow down your account list to choose from.


So starting with for example:

"Expenses:"

Would bring up a (albeit now truncated) list of Expense accounts can get 
you started. Then start typing the next branch of the tree, followed by 
your separator. (default being ":") Proceed as before from there.


You may (or may not) need to uncheck:

  Preferences > Register Defaults > Other Defaults > Only display leaf 
account names



Are you trying to access the *same* book with too different GnuCash 
versions?


While this is possible within a small release window, it probably isn't 
a 'best practice' if it can be avoided.


When advancing the major release number, some lack of backwards 
compatibility occurs. (not sure that is worded correctly) Usually, in 
conjunction with the next major release, the last minor release is 
issued such that both can read the same file.


Thus, at a bare minimum, it is recommended to upgrade to the last minor 
release of a major version before moving to the next major version. 
Since the last release of 3.x was 3.11, that would mean if your other 
computer is on 4.8, you need the one on 3.8 to at least be on 3.11 so it 
can properly read the 4.8 file. (the 4.8 version should be able to read 
a 3.8 file with little issue, but it appears in your case, you are going 
back and forth, not one way from 3.x to 4.x)


Is there some reason you can't get them both sync'd up to 4.8? (or 4.14 
which is the last of that series)


Is there some reason you can't advance them both to the current release? 
(5.6)



Regards,
Adrien

On 5/7/24 3:24 AM, v@scottsonline.org.uk wrote:
I've had a hunt through all the preference stuff, but can't see anything 
that looks relevant. Maybe it's too obvious to spot :-{


Account completion works, but doesn't really help if you can't remember 
the account name!


But to reword/clarify my issue.

Working with 4.8, I have two separate accounts files. One of them shows 
a dropdown list of accounts on clicking in in the Transfer field, the 
other doesn't. There seems no reason the behaviours should be different.


The latter shows either for an existing transaction the highlighted 
current contents or for a new transaction, initially blank (highlighted 
plus a down-arrow) then the first account from the accounts tree with an 
up-arrow when clicked.


On 3.8 I always get a dropdown accounts list.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 drop-down accounts list in ledger Transfer column.

2024-05-06 Thread Adrien Monteleone

4.x introduced a better 'type ahead search' in that field if I'm not
mistaken, which could be why you see a discrepancy between 3.8 & 4.8.

You can still use the old method either directly by typing the beginning
of the full account path with separators like before to speed things up,
or just start typing something matching the desired account and the list
will be limited accordingly.

There is also a global preference I believe to use the old behavior.
(pre 4.x)

If this isn't what you are describing, then please excuse the noise.

Regards,
Adrien

On 5/6/24 4:01 AM, v@scottsonline.org.uk wrote:

Hi all. A "cannot happen" problem.

My desktop box runs gnucash v4.8 on linux mint.

I create a new accounts file, add 3 accounts aaa, bbb, ccc. I open bbb
and to transfer (say) £100 from aaa to bbb. I click in the Transfer
column, and get a highlighted empty box with a down arrow at right. I
click on the down arrow, and see just one suggested account, aaa. No
sign of ccc.

However, if I then type in 'ccc' and Enter to confirm the entry, then on
clicking again in the Transfer column, only ccc is offered.

The weird thing is that (fortunately!) it works perfectly on my
long-standing household accounts file - clicking on the Transfer column
gives a long list of accounts as expected.

But it fails on a second smaller accounts file.

However, with gnucash 3.8 on an older mint, all works perfectly - both
existing files and a new file (as above) offer a full set of accounts in
the Transfer drop-down.

Fortunately, ^T offers a workaround, albeit cumbersome.

Any clue as to what's going on?

An unresolved note at
https://lists.gnucash.org/pipermail/gnucash-user/2021-October/097936.html about what seems to be the same problem suggests it's to do with MATE as that poster says it works under KDE. However, I get the same issue under KDE.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Account Hierarchy

2024-05-03 Thread Adrien Monteleone


Thanks Stan,

I've bookmarked for future reference.

Regards,
Adrien

On 5/3/24 9:50 PM, Stan Brown (using GC 4.14) wrote:

https://github.com/dawansv/gnucash-custom-reports?tab=readme-ov-file#tag-prefix


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Account Hierarchy

2024-05-03 Thread Adrien Monteleone


There is another, simpler, option, such as:

Sales

and that's it.

If you're using the Business Features and will be creating Invoices for 
your sales, then the invoice line items will contain the individual 
product sales data. (you also might have separate sub-accounts under 
Assets:Inventory for each item) By default, this is not exposed for 
reporting, but if you unset the preference to 'consolidate splits on 
posting' then each line item will appear in affected registers. From 
there, you can craft Transaction Reports that filter based on say, the 
name of the product allowing you to create an aggregate sales report. 
(you can do this per invoice, or set a global preference)


I'm not sure what your use of 'Shop A' and 'Shop B' is in the real 
world. Are these just separate physical locations of the same business? 
If not, and these are distinct business entities, the usual 
recommendation is they should have their own individual books.


If they are just different sales locations, you can put that info in the 
Invoice line items as noted, and use the Transaction Report filter tab 
on that text as well. Or, you can go so far as to create:


Sales:
 Shop A
 Shop B

The line items will contain the product data, and the posting account 
will segregate the sales locations. These can be selected per invoice.


There is also a custom 'Tag' version of that report floating around on 
this list. Look for the user 'flywire' to find posts linking to it. 
(it's on Github I think)


If you aren't going to use the business features and will simply be 
doing manual sales transactions (imported, or created individually), 
then you can use a similar approach with filtering and/or tagging and 
put the 'shop' location either in the Description, Notes, or Action 
field. (use Double Line view mode to see Notes) Or as above, create 
sub-accounts under Sales.


The only report that can't filter/tag nicely at present is the 
P/Income Statement, but you could craft something via the Transaction 
Report to get close.


Further possibilities open up if you export said reports to a 
spreadsheet app for further manipulation if you can't get exactly what 
you want within GnuCash.


Any of the above approaches would remove the either/or situation you're 
contemplating and open up more flexibility down the road should you need 
it without having to refactor your historical transactions or account 
structure as you find your needs change.


Regards,
Adrien

On 5/1/24 3:30 AM, Patrick Skelton wrote:

I am about to structure a new set of accounts for a business. GnuCash uses
a hierarchy, which I am currently trying to decide upon. Two
part-hierarchies come to mind:

*FIRST*

Sales

Shop A

Product 1

Product 2

Shop B

Product 1

Product 2


*SECOND*

Sales

Product 1

Shop A

Shop B

Product 2

Shop A

Shop B


The first would make it easy to see sales for each shop but harder to find
out the sales for each product. The second would make it easy to see sales
for each product but harder to find out the sales for each shop.

Both of these seem like reasonable questions to be able to ask of the
accounts. How do I choose which hierarchy to go with and is there any way I
can answer both of these questions?

Any advice would be most welcome as I am no accounting expert and have only
basic knowledge of 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] Printing Reports: Income and Expense Line Chart

2024-04-30 Thread Adrien Monteleone


What version of GnuCash and what OS?

I just created a PDF output via the 'Print to File' option in landscape 
just fine using GnuCash v5.5 on MacOS Monterey v12.7.4.


Regards,
Adrien

On 4/30/24 8:02 AM, Tom Balazs wrote:

Right now I'm struggling with the Income and Expense Line Chart. I want to
print it out to show it to my partner. When I choose to print landscape, it
still prints portrait, and it cuts off the edges. Trying various save and
export methods have not yielded better results.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 on a Mac with a foreign perl

2024-04-26 Thread Adrien Monteleone


John,

I have Homebrew installed.

I'm not familiar with @INC, but happy to learn.

I just ran gnc-fq-update without issues.

I still have the output from that update if you need it, or if you need 
output from any other commands, just let me know.


I'm still on GnuCash 5.5, my Perl is 5.30 and it appears to be at 
/usr/bin/perl.


Regards,
Adrien

Regards,
Adrien

On 4/25/24 9:15 PM, john wrote:

Are there any Mac users who have Homebrew installed and know what @INC is?

At least two users with the first problem but without knowing the second have 
gotten themselves cross-threaded trying to install Finance::Quote because 
Homebrew' screws up their perl installation so that cpan ignores the installed 
modules and since Homebrew doesn't (at least without help) provide SSLeay, 
Net::HTTPS, and IO::Sockets::SSL and macOS doesn't put OpenSSL's headers in 
/usr/include they have to perform all sorts of unnatural acts to get 
gnc-fq-update to work.

We need some simple instructions for the wiki for how to work around the 
problem so that gnc-fq-update uses the system perl (that's after all the only 
one the app bundle can see, it doesn't read the user's shell environment) and 
gets the dependencies from /System/Library/Perl instead of trying to build 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] Please address broken QIF import

2024-04-25 Thread Adrien Monteleone

What do you find about dropping to an earlier release, not 
'straightforward'? It is a simple matter of removing the current 
release, and installing the older one. (I believe on Windows systems, 
you can safely just install the older release as the installer will do 
the in-place replacement for you)


I also can't fathom exactly how you imagine the developers have 'made 
downgrading harder'. I don't see that they've done any such thing. They 
even make an effort to support reverting to recent older releases for 
just this purpose.


If you have followed the recommended upgrade procedure via the Wiki's 
FAQ, you should be able to easily drop down to the last version of the 
last major release before your current one if necessary, though in most 
cases, simply dropping one or two point-releases within the current 
major version is sufficient. (and in some cases, not even necessary as 
there may be workarounds, albeit with a bit of extra effort)


Yes, there have been a few significant issues over the last year or so 
that have prompted more 'downgrades' than previously. But so far as I 
can tell following the threads, every one of those was caused by outside 
software.


Overall, this is one of the most responsive and helpful development 
teams I've experienced for any software I use. And there's no mega-corp 
behind them, just a handful of gracious folks donating their time and 
effort because they care and they want to see the project they use 
themselves, survive and thrive. (the devs are users too, and they can 
experience the same regressions, and frustrations, along with the rest 
of us.)



Regards,
Adrien

On 4/24/24 5:24 PM, Yann Salmon via gnucash-user wrote:
downgrading is really not a
straightforward route as software managers, for good reasons, make 
upgrading software easy and downgrading it harder


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 anyone else getting these malicious e-mails?

2024-04-15 Thread Adrien Monteleone


So far, nothing like that has come across the wire to me.

Regards,
Adrien

On 4/14/24 9:57 PM, Michael DeBusk wrote:

I've gotten two or three obviously-malicious e-mails pretending to be
from this mailing list. The From: line lists the sender as "Gnucash
User" but the address is not this one. I fear a spammer (or worse) has
subscribed and is harvesting addresses.

Is anyone else seeing this?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 find open invoices

2024-04-14 Thread Adrien Monteleone


Business > Customer > Find Invoice

Set criteria to:

Is Posted?, unchecked

You can of course add other criteria to refine the search.

Regards,
Adrien

On 4/13/24 10:07 PM, tburmas wrote:
     I often have invoices that are open (in progress) that are not 
ready to post.  Is there a way to see a list of these?  The only way I 
have found to do so is to remember ahead of time a customer has an open 
invoice and find it.  This is quite error prone.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Zorin os

2024-04-10 Thread Adrien Monteleone

The distro does not matter. (with perhaps some caveats concerning 
dependencies)


While you technically can jump from 2.6.21 to 5.6 (current version), 
that isn't officially supported, nor recommended.


See the Wiki FAQ about upgrading procedures from one major version to 
another. (In this case, you are upgrading from one major version to one 
THREE versions later.)


The recommended and safest path would be:

2.6.21 -> 3.11 -> 4.14 -> 5.6

keeping a backup/copy of your data file at each stage and running 
'Actions > Check & Repair > Check & Repair All' upon first opening your 
file after each upgrade.


Take special care that if you have Saved Report configurations, the name 
of the folder for those reports changed as of 3.x which may or may not 
get automatically renamed for you. (see the FAQ as noted) There may be 
other glitches along the way. (which is why it is best to step one major 
version at a time, and report back here if you encounter such glitches)


Regards,
Adrien

On 4/9/24 10:06 PM, Heinz Kettler wrote:

Can I upgrade to gnucash  5 on my zorin os? I have version 2.6.21 and not
sure if version 5 doc applies to 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] I'm looking at installing GnuCash but has a couple of questions first

2024-04-09 Thread Adrien Monteleone

Mac comes with screensharing built in. No need for a separate app. Some 
linux distributions also include VNC apps by default, or they can easily 
be installed.


Regards,
Adrien

On 4/9/24 3:23 PM, G R Hewitt wrote:

Also Teamviewer runs on a MAC too.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Recording transactions (date)

2024-04-09 Thread Adrien Monteleone

You 'paid' when you 'tendered' the payment. (tender isn't just an offer 
of payment, but includes acceptance/receipt, which has happened in this 
case. It does not include cashing/depositing or otherwise processing a 
negotiable instrument that was tendered as payment.)


How you handle the uncleared check would depend on the amount of the 
check, the amount of the stop payment fee, the amount of an overdraft 
fee, and your propensity to skirt a zero balance in the account.


If you *never* get within the amount of the outstanding check as your 
bank balance, you could likely just add it back.


If you routinely skirt zero, (or within zero and the value of the check) 
then I'd weigh the stop-payment fee vs. the overdraft fee. But keep in 
mind, the stop-payment is only one time. The overdraft would be each and 
every time.


Finally, you can just keep it on your books as-is, always leaving a 
cushion to avoid overdrafts. When you die, the account will be closed 
and the funds returned to your heirs. The check could not be honored at 
that point. (hopefully - better to get legal advice on that one!)



Regards,
Adrien

On 4/9/24 11:50 AM, R Losey wrote:

Legally, are you saying that if I write a check for $50 and send it to my
uncle, it's "paid" whether or not he ever cashes it?

As as aside, I am actually in this situation; I sent e check many years ago
to someone who has never cashed it; when I asked about it, the person told
me that they had no intention of cashing the check, but also couldn't find
it to return it, so I've been carrying that check now for years. Sadly, the
cost of issuing a "stop check" is not worth it, and the bank says it will
honor a check, no matter how old, so I don't see any way out of this.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Recording transactions (date)

2024-04-08 Thread Adrien Monteleone

While there are other considerations, such as cash versus accrual and 
following the Recognition Principle, I see this as more of a general 
case of Your Books vs. the Bank's Books.


You keep Your Books.

The Bank keeps theirs.

You then reconcile the two. (which does *not* involve changing dates)

Simply copying what the bank has misses the opportunity to catch someone 
else's errors. (they *do* happen)


This is a similar question of entering your own transactions as they 
occur, or just downloading from the bank and importing.


It is a personal choice, but can have other implications as noted.

Regards,
Adrien

On 4/8/24 5:11 PM, R Losey wrote:

Since I first learned about recording transactions, I have always dated a
transaction on the date I wrote the check; similarly, when entering credit
card transactions, I use the date that I actually used the credit card.

Recently, however, I was having a discussion with a friend and he said that
he uses the bank or credit card date of entry for all of his transactions.

I thought this was strange - probably because it is different from the
method I've used all of my life. Perhaps I am the odd one... or perhaps
it's merely a matter of choice, so I thought I'd bring it up to this list
to see what people think about it.

 From (a very brief) research about this topic, perhaps this is the
difference between cash basis accounting and accrual accounting?


After thinking about it for a bit, one issue with using the date that the
transactions occur is the reports, especially if one has repeating
transactions.  For example, if the satellite service bill is paid each
month on the 28th, using my method, I record a transaction on the 28th. My
friend will see it on the 29th or 30th, but if the weekend or holiday hits
just right, it can be the 1st or 2nd before he sees it. In the long run
everything should be the same, but the monthly sub-totals can look odd.
Checks can be even worse... someone may hang onto one for weeks.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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-devel list down?

2024-04-08 Thread Adrien Monteleone


An announcement posted on 4/2 came through for me.

And while you can get to it here:

https://lists.gnucash.org/mailman/listinfo/gnucash-devel

The archive link returns a Not Found.

Regards,
Adrien

On 4/7/24 8:50 PM, Michael or Penny Novack wrote:
I have received nothing from that list since 3/22   The on-line site for 
the mailman list is still up (but I never communicate with mailman that 
way)


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] CSS GTK Register padding/spacing

2024-04-01 Thread Adrien Monteleone


The name of the class for #2 is just:

.register-primary

Though I don't know if you can add padding to it or not. (which is where 
the GTK Inspector comes in handy)


Regards,
Adrien

On 4/1/24 2:31 PM, J R via gnucash-user wrote:

  I read all the wiki many times plus other sources
1. This works but effects the whole program/* Application wide font setting */* 
{  font: 16px arial;      padding-top: 5px;      padding-bottom: 5px;}
2. This fails.gnc-class-user-register-primary {
   background-color: #403f3f;  color: white;      padding-top: 5px;      
padding-bottom: 5px; }


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] CSS GTK Register padding/spacing

2024-04-01 Thread Adrien Monteleone


See this wiki page:

https://wiki.gnucash.org/wiki/GTK3

I'm not sure how to run the inspector on Windows. Perhaps some other 
users here can help. There are plenty of threads on CSS in the list 
archives. Maybe one of them describes the Windows process.


Without it, you're just shooting in the dark.

Regards,
Adrien

On 4/1/24 1:20 PM, J R via gnucash-user wrote:

  Just using notepad ++


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] CSS GTK Register padding/spacing

2024-04-01 Thread Adrien Monteleone

Are you using the GTK Inspector? It provides a sandbox to play with 
rules to see their effect and then you can put them in your CSS file.


Keep in mind, not every element in the UI is exposed or even addressable 
for styling.


Regards,
Adrien

On 4/1/24 6:34 AM, J R via gnucash-user wrote:

I cannot apply the correct css tag in the register to increase the spacing between 
transaction lines...I'm getting oldIncreasing the font and other adjustments not a 
problem.I can do it to the font "padding top/bottom" system  wide but it just 
spaces everything too much, I have researched everything


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

Re: [GNC] Find account

2024-03-30 Thread Adrien Monteleone

That only works if the account is visible and not in a collapsed part of 
the tree.


Regards,
Adrien

On 3/30/24 12:03 PM, Stan Brown (using GC 4.14) wrote:

While in the Accounts pane you don't need to "use" anything. Just start
typing a part of the name you're looking for. (It doesn't need to be the
beginning.)


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Segmentation fault while importing invoice data

2024-03-30 Thread Adrien Monteleone

See the wiki about crashes and bug reports. Take a look there as well 
about getting a Tracefile, then file a bug with the crash report and 
tracefile as attachments. (The Tracefile may or may not contain relevant 
info)


You don't mention your OS by the way.

Regards,
Adrien

On 3/30/24 10:56 AM, Emir Herrera wrote:

Anyway, if I click on "continue" to make the importation, after a couple
seconds the system crashes and I get a "Segmentation fault" message on the
terminal, and no detailed information if runned with the "debug" flag...
so... I'm stuck and I need help to import this 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] Finance Quotes Yahoo off the rails again?

2024-03-30 Thread Adrien Monteleone


GnuCash 5.6 should be out tomorrow with F::Q 1.59.

Regards,
Adrien

On 3/29/24 10:32 AM, David G. Pickett via gnucash-user wrote:

  Yes, but as I went to flatpak to get a later release, it is discouraging that 
it fails to get updated for newer releases of Finance Quote and for all I can 
tell, newer GnuCash.  Maybe they update the GnuCash but ignore the Finance 
Quote update?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Updating gnucash

2024-03-27 Thread Adrien Monteleone


David,

I could be mistaken, but I thought that the 'All' function negated the 
need to be viewing the CoA when running it, and that the non-All 
function operates as you describe. (context aware)


Good tip about the task manager. Sometimes the process is so fast, you 
aren't sure if it completed or is stuck. While I think there is feedback 
in the status bar of GnuCash, if it is really quick, you'll never 
notice. Perhaps a dismiss-able confirmation dialog would be more reassuring.


Regards,
Adrien

On 3/27/24 12:25 PM, David Carlson wrote:

I agree with Adrien wholeheartedly.  It is important to note that the Check
and Repair function has a different scope of operation depending on which
type of window has the current focus when it is invoked, and that if
started from a window that allows access to the entire inventory of
transactions, such as the chart of accounts window (I think), the process
may take a considerable amount of time, possibly an hour or longer in some
cases, so it would be desirable to have a task manager running in your OS
to help determine when the action is complete.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 Frozen

2024-03-27 Thread Adrien Monteleone

Anytime you have a problem, please report the GnuCash version and 
Operating System you are using.


As for the issue at hand, my first guess is a hidden window has input 
control, but your OS allows you to scroll other 'background' windows. (I 
know MacOS and some Linux distributions can do this, not sure of Windows)


How to discover if another GnuCash window/dialog has control, but is 
simply overlaid by the main window, or is otherwise hidden, will depend 
on your OS and setup. Another possibility, is if you are using 
multi-monitor setup, the other window could be on another monitor, or 
*think* it is on another monitor that isn't on/connected.


Of course, all of the above is just a guess. We need more info.

Regards,
Adrien

On 3/27/24 10:11 AM, Abe Sternberg wrote:
I've got myself into a pickle and have no idea how it happened or how to 
fix it. Gnucash has one file for my non-profit and one for my personal 
expenses.  The personal expenses file is working fine, my non--profit 
displays correctly but will not take any input at all.


The cursor moves up and down the register and that is all - no data 
entry, none of the actions work, etc.


Does anyone have any idea on what I did and how to fix 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] Updating gnucash

2024-03-27 Thread Adrien Monteleone

In addition to the advice given by the other replies, it is advised to 
run Actions > Check & Repair > Check & Repair All when first opening a 
file after an upgrade between major releases.


These checks and repairs are supposed to run automatically, but that 
doesn't always go smoothly or completely for everyone, hence the 
recommendation to do so manually.


The only other concern with an upgrade would be if you had custom 
reports that use deprecated code in the new version. But this is rare. 
By 'custom' I mean either you, or someone for you, coded them in Scheme. 
I'm not referring to merely Saved Configurations of included reports.


Regards,
Adrien

On 3/24/24 11:37 AM, Nathan Rosenthal wrote:

I am currently running version 4.12 for two different organizations.

If I was to update to 5.12 would I just download it and install it into 
the same folders or would I need to transfer the data files?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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?

2024-03-26 Thread Adrien Monteleone


David,

What makes your messages that contain quoted material difficult to read 
is your e-mail client doesn't indicate they are quoted, so it all 
appears as your new message. There is also some wacky formatting going 
on. That isn't the mailing list software, that is your client as the 
culprit.


Maybe switch to sending 'plain text' and see if it improves.

-
As for Finance Quote, you should be able to install that independently, 
but I don't know how that works with Flatpak with regards to what 
version GnuCash Flatpak can 'see'. I'd think at the least you'd need to 
remove 1.58 to avoid complications.


Regards,
Adrien

On 3/26/24 11:44 AM, David G. Pickett via gnucash-user wrote:

  Fred,
Sorry, but the mail handler makes trash out of carefully formatted and 
informative text.  I do not know why it hates the noble new line character?  
I'd send attachments but they probably get removed, but maybe I can send Google 
Drive URLs to files?  On Ubuntu bugs, I can go to the web site and paste in 
stuff or attach, and then it is fine, but if I send by email, same trashing as 
here.
Hopefully some of the people on the to: and cc: lists get the untrashed 
original and find it informative.  I am just another victim of the unstable 
world of Finance Quotes and quote sites, hoping it gets improved before Friday.

I would be on 1.59 but apparently the wonderful, overworked, volunteer 
supporters have not updated the flatpak version of GnuCash to include it, which 
is how I got 1.58!


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

Re: [GNC] Can't enter expense transactions after migrating

2024-03-21 Thread Adrien Monteleone

Are you 'TAB'ing through the transaction or attempting to 'ENTER' 
through the transaction?


ENTER *commits* the transaction and could possibly generate the 
warning/dialog you mention.


TAB is the documented method for moving from one field to the next 
without committing the full transaction, and should *not* generate the 
message you describe.


Regards,
Adrien

On 3/21/24 2:49 PM, Christopher Burnett wrote:

After migrating to a new computer, all my data seems to be there and
visible in the accounts, but I cannot enter any new expense transactions.
I keep getting a "Save the changed transaction?" message whenever I put
values in the Withdrawal column.  Values entered in the Deposit column are
accepted. I updated to V 5.5 before migrating and am using V 5.5 on the new
Windows 11 computer.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 font sizes in reports (specifically in Transaction Report)


Here's the bug link: https://bugs.gnucash.org/show_bug.cgi?id=799248

Your attachment seems to be a printed version of the report, rather than 
an HTML 'export'. (Use the Export button on the toolbar, don't try to 
'print to file')


I'm spinning up a VM with 4.8 to confirm. As of 5.5 at least, that cell 
does have a class as I noted.


Perhaps switch to the 5.5 flatpak. At least you can style it using the 
method I described in my last post.


Regards,
Adrien

On 3/11/24 12:14 PM, Chris Green wrote:

I have the exported HTML.  It would appear that the section (i.e.
account) headings are in a , see:-

 
 Lloyds
  
  
 
  
 01/01/23
 
 
 
 Lloyds Current

The 'Lloyds' is what I would expect to be in a large font but there
seems to be no class to apply to it.  I have attached the whole
exported HTML file, I can see no way to specify a larger size for the
headings, it needs the HTML changing to give a class name to the
section (account) headings.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Bill total does not match real total

I'm not sure if it is still entirely open source, but it started that 
way. I think they've added on features that are closed. (some may simply 
be built with Odoo itself) The base package is still available as far as 
I'm aware, and it is pretty powerful, but likely overkill for most small 
businesses. They also don't make it easy to build it and get up and 
running, preferring to 'guide' you to their paid support offerings.


Odoo is more of a tool to build an app, rather than a business app itself.

Regards,
Adrien

On 3/11/24 10:33 AM, Michael or Penny Novack wrote:
Well ... if it is really "open software" they would have to make the 
source code available for free (technically can charge reasonable cost 
for a copy on medium -- the 'rule" was made before we got things by 
download). The "open software" rules do NOT forbid charging for 
providing executables, support, etc. The originally concept was that 
nobody could charge excessively for that or somebody else would step in 
and provide at a more reasonable price. Yes, I am old enough to have 
followed the original "open software" discussions real 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] Setting font sizes in reports (specifically in Transaction Report)

The total cells labels *as well as the account name* were all given a 
CSS class:


.total-label-cell

for the labels, and

.total-number-cell

for the actual figures in the totals.

By default, the styling for those is:

td.total-number-cell { font-family: "Avenir", sans-serif; font-size: 
12pt; font-weight: 810;  }
td.total-label-cell { font-family: "Avenir", sans-serif; font-size: 
12pt; font-weight: 780;  }


(visible if you open the exported HTML report in a text editor)

You can use the CSS stylesheet for your report, and copy those above 
rules to it. It is probably not strictly necessary to address the td 
element explicitly like the inline style does, just the class should work.


Or, with the Default stylesheet, simply adjust those options as desired 
on the Fonts tab: "Total Label Cell" and "Total Number Cell".


I'll file a bug on the Account Name sharing a class that makes it 
non-obvious what to change.


Regards,
Adrien

On 3/11/24 5:30 AM, Chris Green wrote:

On Fri, Mar 08, 2024 at 12:01:01PM -0600, Adrien Monteleone wrote:

Chris,

Once again, look into Edit > Stylesheets.

For the record, I'm using defaults, and the  is 12pt
bold and the  lines are 10pt normal weight. The total lines
match the .


On my GnuCash (version 4.8 on Linux) there isn't a separate setting
for the , it's the same size as 'Text Cell'.
Chnaging the font size for 'Text Cell' changes *all* the text (i.e. the
individual transaction descriptions etc.) as well as the account title.

There are no references to 'transaction' or 'name of account' in my
stylesheet settings.

Is this something that has been changed since version 4.8?



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

Re: [GNC] Max value during year

You can take that same report and copy/paste into a spreadsheet, then 
set up a MAX() function in another cell to look at whatever column. 
(Balance, I would presume in this case)


Some spreadsheet apps have a configurable 'stats' bar at the bottom that 
can show preset analysis, such as MIN, MAX, AVG, COUNT, etc. In that 
case, just select the desired column or row (minus the header) and the 
values will auto-populate in the stats bar.


It isn't all done in GnuCash, but it at least saves manual scanning with 
your eyes.


Regards,
Adrien

On 3/10/24 11:47 PM, Fred Tydeman wrote:

Is there an easy way to find the maximum value of an account during a given
time period (such as a year)?

I currently do:  Reports: Assets & Liabilities: Asset chart:
Options:
   Accounts:  the account I care about
   Display: Show table
   General:  Start and End of previous year (or specific dates);
   Step size:  One Day
and then scan the table for the maximum.


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

Re: [GNC] Importing Reports into LO Calc


You can certainly set that as a style in Calc.

Regards,
Adrien

On 3/9/24 9:01 PM, Robert Heller wrote:

I think the OP's issue is the fact that Calc does not preserve the red
coloring of the negative numbers.  The red coloring of the negative numbers is
something *GnuCash* is doing as a "good accounting practice", but the Calc is
not doing.


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

Re: [GNC] I'm getting started in Gnucash and want to list each item that I buy from one merchant

I'm not certain what you are describing, but I'll hazard a guess that 
you are seeing GnuCash auto-balance the transaction. That is normal. 
Every transaction has to be balanced. (Debits *must* equal Credits)


You are free to enter the transaction however you like, as long as that 
holds true. If your self-entered amounts do not result in equal Debits & 
Credits, GnuCash will create a split initially not assigned to any 
account, but when you commit the transaction and that split remains, it 
will be assigned to the account labeled: 'Imbalance-XXX' (where XXX is a 
currency code) for the difference.


Please read the GnuCash Help Manual and the Tutorial & Concepts Guide 
available in the Help Menu, or online, as you are learning the software. 
Then if you get stuck, come back and ask for help here.


Regards,
Adrien

On 3/9/24 8:18 PM, W. Neal Lewis wrote:

When I do the View > Transaction and put in individual numbers for each item in 
the Withdrawal column, it starts to mess with my figures. It puts in a number at 
the very top. It adds deposits to other entries. What I end up with is a mish-mash 
of costs that the program seems to think that I need for some mythical number it 
has come up with.

That's exactly what happened previously. I don't want it adding numbers, or 
changing numbers. I just want to put in the correct values for each line, 
including tax, hit return and have the final value show up on the first line of 
the transaction.

I obviously don't know what I am doing.

Help!
Neal



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

Re: [GNC] I'm getting started in Gnucash and want to list each item that I buy from one merchant


Neal,

You are welcome.

But please remember to hit 'reply-all' or 'reply-list' rather than just 
'reply' so everyone on the list benefits and can participate in this 
discussion.


Individual users may not always be able to help fully with any issue or 
question, others may have better answers or interesting suggestions.


Regards,
Adrien

On 3/9/24 7:10 PM, W. Neal Lewis wrote:

Thank you Adrien,

I will see what I can do with your suggestions.

And yes, I do need a high level of detail.

Thank you again for your reply.

Best regards,
Neal



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

Re: [GNC] I'm getting started in Gnucash and want to list each item that I buy from one merchant

You can certainly do so. The exact work flow can vary depending on your 
precise needs.


I don't often have very long transactions (30 or more items) but it does 
happen a few times a year. I frequently have transactions with at least 
5 or so 'splits'.


I'd recommend experimenting with either View > Transaction Journal (my 
preference) or View > Auto Split. That way, if most of your transactions 
need to show individual line item info, you can see it when you enter 
the transaction (Auto Split) or always see that level of detail for all 
transactions. (Transaction Journal) The default view will be least 
helpful to you.


You will not likely be able to easily auto-add tax per line, but can 
certainly put in tax lines manually. (such as one line for food, one for 
medicine, etc.) GnuCash can help with the math here. I put the rate and 
amount in the memo section and then type in the formula in the debit 
column. (e.g., $15.99 * .0845) GnuCash will replace your formula with 
the result showing what the calculated tax amounts to.


Another (but a bit more complicated) option is to put all such 
transactions into 'Vendor Bills' which can do taxes per line, exclusive 
or inclusive of price. But this requires much more careful setup and may 
or may not work for your particular situation.


Most importantly, if you need reporting at all on this detail, it has to 
be entered somehow into GnuCash. Do not just aggregate and enter the 
result. (don't consolidate line items. Enter each one separately as its 
own split, but do enter them in the same transaction if that is how they 
occurred.)


Regards,
Adrien

On 3/9/24 5:40 PM, W. Neal Lewis wrote:
I would like to use Gnucash to keep track of the costs and information 
of each of the things that I buy from a merchant, such as Kroger, Home 
Depot, etc.


There can be 30 to more items on one transaction.

The items can be for different uses, such as food, lumber, computers, etc.

There can be multiple tax rates, depending on the separate tax rates for 
food, prescriptions, hardware, etc.


This information is needed for use at tax time, since I have a small 
business and need to break things out accordingly.


Is Gnucash the right program to use for these needs?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Separating tax years for payments in next year