Re: [GNC] Reports not displaying.

2024-03-09 Thread Eric Koski
John, I also have this issue... was just prepping taxes so I needed the reports. The "WEBKIT_DISABLE_COMPOSITING_MODE=1 flatpak run org.gnucash.GnuCash" works as described.  Just wanted to provide you with my system details for your investigation: System:   Kernel: 5.15.0-97-generic x86_64 b

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

2024-03-09 Thread David Carlson
Neal, By chance are you using the enter key during your editing? That triggers the full transactiion calculatkions. Use arrow keys, ta b key or mouse buttons until you are ready to see the transaction calculation. I think calculztions within individual amount fields happen as soon as you move o

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Adrien Monteleone
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 ac

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread David H
Hi Robert, If I copy and paste a Gnucash report directly into LibreOffice Calc (version 7.6.4.1 on Win10) everything is black as expected except for the negative numbers that are red which is what I also expected to happen ? Not sure what's happening with OP's calc. Cheers David H. On Sun, 10

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Robert Heller
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. At Sat, 9 Mar 2024 18:13:04 -0600 adrien.montele...@lusfibe

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

2024-03-09 Thread Adrien Monteleone
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

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

2024-03-09 Thread Adrien Monteleone
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

Re: [GNC] trying to use good gnucash billing in personal books

2024-03-09 Thread David Cousens
Tim It is usually good practice to keep your personal accounts and business accounts separate and that usually involves having a separate bank account for business transactions. There is sometimes a grey area when you are setting up a business. Where you pay bills, which are bills of the business

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

2024-03-09 Thread Adrien Monteleone
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 Vi

Re: [GNC] Separating tax years for payments in next year

2024-03-09 Thread Adrien Monteleone
Why not create a transaction for the appropriate year between tax expense and tax payable? Dr. Expenses:FederalTax Cr. Liabilities:FederalTaxPayable Then when you actually pay, Dr. Liabilities:FederalTaxPayable Cr. Checking (or whatever source account) That way, the expense shows up for t

Re: [GNC] trying to use good gnucash billing in personal books

2024-03-09 Thread Adrien Monteleone
Liabilities and Accounts Payable are not Equity type accounts so they don't belong there. They both are of type 'Liability' generally and belong in that part of the tree, but specifically, the Accounts Payable account is the special type 'Accounts Payable' in the GnuCash Edit Account dialog.

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Adrien Monteleone
1. Export Report 2. Open Calc 3. Open the report file in Calc. Result is the report imported into cells based on the html table. or 1. Export Report 2. Open Calc 3. Click 'Sheet' Menu, then 'Insert Sheet from file...' and select the exported report file. Answer the dialogs, result is same as

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

2024-03-09 Thread W. Neal Lewis
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 m

Re: [GNC] trying to use good gnucash billing in personal books

2024-03-09 Thread Tim via gnucash-user
I started down the path of setting up accounts payable to hold the bills that my sole proprietorship sends to me which I then pay. I created a first bill, assigning the line items to various expense accounts in my personal books, which is where I want those line items to be allocated. I'm appare

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Abe Sternberg
Thanks.  It may be best if I start this thread again.  I sincerely appreciate your taking the time to get me knowledgeable. Abe On 3/9/2024 15:35, David H wrote: Abe, You can't include/paste pictures inline on the Gnucash mailing list so they didn't show up :-(  You have to either save each

Re: [GNC] Bill total does not match real total

2024-03-09 Thread Carl Linkletter via gnucash-user
Thanks for all that Michael. So the summary is, why would I think that one system could possibly handle all the regulations that incompetent and narcissistic bureaucrats could come up with?What was I thinking??? :-) Peter Carl Linkletter VMware Consultant and VMware Certified Instructor

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread David Cousens
Abe, The default colors which come up in Calc are going to depend upon its preference settings and any formatting already set in Calc before importing. GnuCash has no control over that. Cal's cell "currency" setting has the option of negative numbers appearing in red. If you format all cells cont

Re: [GNC] Bill total does not match real total

2024-03-09 Thread Michael or Penny Novack
On 3/9/2024 1:34 PM, R Losey wrote: Regarding below, perhaps Amazon does it that way because some states (locations) exempt certain items from sales tax: Wisconsin, for example, used to not tax food. In Texas also, food is not taxed. And Massachusetts does not tax food or clothing. The necessary

Re: [GNC] gnucash-user Digest, Vol 252, Issue 21

2024-03-09 Thread David H
Cool, glad you got it sorted. Cheers David H. On Sun, 10 Mar 2024 at 03:09, Eric H. Bowen via gnucash-user < gnucash-user@gnucash.org> wrote: > David/john: > > Thanks for the helpful replies. After you mentioned it, I remembered the > auto-history version save of my NAS-based cloud drive. Upon

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread David H
Abe, You can't include/paste pictures inline on the Gnucash mailing list so they didn't show up :-( You have to either save each pic as a file and attach them to your email or I've found that you can get away with pasting 1 pic as the very last thing in your email and it makes it. Cheers David H

Re: [GNC] Maddening!!!!!!!!

2024-03-09 Thread Jack Slater
Thanks John! On Sat, Mar 9, 2024 at 9:25 AM john wrote: > No, that's a re-bundling of GnuCash 5.5 for Windows with a rebuilt > WebKitGtk so that it doesn't crash when you try to run a business or chart > report. There are no changes to GnuCash itself. > > The fix for the left-over splits from ed

Re: [GNC] Separating tax years for payments in next year

2024-03-09 Thread David G. Pickett via gnucash-user
Subfolders is a good alternative, better for reports over multiple years but more maintenance creating and destroying folders. If GNUCash wanted, they might make a magic subcategory /Prior to qualify the date's year to year - 1, but that seems very tricky to code into every date filter. Autom

Re: [GNC] Separating tax years for payments in next year

2024-03-09 Thread R Losey
I like the idea -- I usually just "remember" that the Jan payment is for the previous year. But if you're going to make sub-accounts under taxes, why not use actual years? Taxes/Federal/2023 and Taxes/Federal/2024. Once a year is done with, you can easily hide the account so that it doesn't show up

Re: [GNC] Bill total does not match real total

2024-03-09 Thread R Losey
Regarding below, perhaps Amazon does it that way because some states (locations) exempt certain items from sales tax: Wisconsin, for example, used to not tax food. In Texas also, food is not taxed. On Fri, Mar 8, 2024 at 11:56 AM Stan Brown (using GC 4.14) < stan...@fastmail.fm> wrote: > > > On

Re: [GNC] Error Retrieving Gold Price for Price Database

2024-03-09 Thread Fred Bone
On 09 March 2024 at 16:35, john said: > XAU is a currency because ISO 4217 says it is, along with XBA (silver), Precious metals are coded as X followed by the relevant chemical symbol, so silver is XAG ___ gnucash-user mailing list gnucash-user@gnuca

Re: [GNC] gnucash-user Digest, Vol 252, Issue 21

2024-03-09 Thread Eric H. Bowen via gnucash-user
David/john: Thanks for the helpful replies. After you mentioned it, I remembered the auto-history version save of my NAS-based cloud drive. Upon checking in there, I found two versions which had saved within two seconds of each other at the time I attempted to switch books. The second one, whi

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Robert Heller
At Sat, 9 Mar 2024 11:41:31 -0500 Abe Sternberg wrote: > > I guess I am a bit dense - old age will do that to you.  Let me try and > be a bit more specific on my actions and the errors I get. Below is a > screenshot of a budget performance report in GnuCash. > > > > Next, I export it to the

Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Abe Sternberg
I guess I am a bit dense - old age will do that to you.  Let me try and be a bit more specific on my actions and the errors I get. Below is a screenshot of a budget performance report in GnuCash. Next, I export it to the folder I want it in and open it in Calc. The file opens in a browser ta

Re: [GNC] Error Retrieving Gold Price for Price Database

2024-03-09 Thread john
XAU is a currency because ISO 4217 says it is, along with XBA (silver), XPT (platinum), and XPD (Palladium). They're supposed to represent a troy ounce of the respective metal. Keep in mind that ISO-4217 is a banking industry specification and doesn't necessarily apply to anything you as an indi

Re: [GNC] Maddening!!!!!!!!

2024-03-09 Thread john
No, that's a re-bundling of GnuCash 5.5 for Windows with a rebuilt WebKitGtk so that it doesn't crash when you try to run a business or chart report. There are no changes to GnuCash itself. The fix for the left-over splits from editing an auto-completed transaction will be in GnuCash 5.6. Flatp

Re: [GNC] GnuCash Will Not Open Book After Changing Books (Bug 645216)

2024-03-09 Thread john
Are you using the SQLite3 backend? If so and it's really corrupted see https://www.sqlite.org/recovery.html. Good luck. Regards, John Ralls > On Mar 8, 2024, at 22:43, David H wrote: > > Eric, > > Are you sure you haven't got a more recent backup? I have multiple backups > (currently 77 -

Re: [GNC] 5.5-1 crashing on macOS 14.3

2024-03-09 Thread john
Good that you've gotten it working. Maybe open an issue at https://github.com/finance-quote/finance-quote/issues about YahooWeb.pm not setting the right error code when it fails to get a quote. And please, in the future, start a new thread or at least change the subject when you digress like th

Re: [GNC] Error Retrieving Gold Price for Price Database

2024-03-09 Thread Kalpesh Patel
Most likely the case ... I am not sure how XAU was determined to be a currency when in fact it is an Index. I suspect it is historical carried forward ... Anyways, '^XAU' and 'GC=F' (or 'SI=F') will need to be added manually as attributes in the Currency namespace are not modifiable (at least I