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
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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.
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
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
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
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,
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
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
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
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.
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 -
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
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
33 matches
Mail list logo
