All version of MySQL using DB name = gnucash, never change.
I have never setup and using SSL in MySQL.
Remote access via SSH tunnel.
Therefore the error message "SSL certificate issue" is strange as me
I will try to search it.
Thanks
Adrien Monteleone 於 2022年3月17日 週四 下午1:09寫道:
>
> As John
As John mentioned, the db name seems incorrect. Did you register the db
on MacOS?
Error 2026 deals with SSL certificate issues.
A web search should provide some guidance.
Maybe try without SSL to see if that resolves it? Then you can
troubleshoot the SSL problem.
-
And again, why do
Thank you for the clarification.
Hi Adrien
I am using MySQL @ FreeBSD remote mainly,
MySQL @ MACOS for the issue tested.
GNUCASH @ MACOS work fine both MySQL v8.0.23.
Hi Josh
Either MySQL v8.0.23 or v8.0.28, all parameter
same(user/password/database name).
Therefore issue caused from libdbi I
If you're looking for 'inventory control/manangement' or 'item tracking'
by quantity, no, GnuCash can't do it. (out of the box)
Some people have finagled it to do so using user-defined commodity
accounts, but that seems like more trouble than it is worth.
Inventory management should be done
Neko,
AFAiCT this has nothing to do with macOS but rather that your MySQL server
doesn't recognize the database name you passed it plus another error, number
2026, that GnuCash doesn't know how to handle.
As a reminder, users using the MySQL or Postgresql backends *must* be *expert*
database
You have to install MySQL/MariaDB on MacOS separately as far as I
recall. (then save the file in that backend format)
But before you go through all of that trouble, what advantages do you
think you will gain by using the MySQL backend vs. XML or SQLite?
Regards,
Adrien
On 3/16/22 8:31 PM,
> On Mar 16, 2022, at 5:08 PM, Art Chimes wrote:
>
> I well remember agonizing over this when I first set up price imports.
> There's a bit of a learning curve here.
>
> "Namespace" can be FUND (if it's a mutual fund), NYSE or NASDAQ or
> AMEX if it's a stock on the New York Stock Exchange,
And Stan has now given the breakdown of the splits to accomplish it.
That would be followed up with:
Dr. Liability:Taxes payable
Cr. Checking
when they are physically paid.
Regards,
Adrien
On 3/16/22 7:54 PM, D. via gnucash-user wrote:
Yeah, I get that an accountant doesn't call this
Good to know, thanks for the clarification.
Regards,
Adrien
On 3/16/22 6:49 PM, D. via gnucash-user wrote:
Oh, I know about using the tax flag and TXF report. Done it for years. But
unless you figure out how to do what Mike has mentioned (consistently over the
years), if you flag these
On Thu, 17 Mar 2022 01:59:28 +
Frederick wrote:
> Hi there, i am a interested in abandoning my Accounting software and
> looking to see if Gnucash will work for my one person business.
>
> The main issue is that i manufacture items to sell and need software
> that can account for
Hi there, i am a interested in abandoning my Accounting software and looking to
see if Gnucash will work for my one person business.
The main issue is that i manufacture items to sell and need software that can
account for assemblies. This can go by the name of manufacture/build or
assembly.
Hi All
I have no idea how to run on MACOS still.
Can help/information for it?
Thanks a lot
>
> Hi gnucash-user
>
> I had been encounter as subject, can help to resolve?
>
> Detail:
> I have both Gnucash v4.9 in MACOS 12 and Ubuntu 20 and both work fine
> @ MySQL 8.0.23
> After MySQL upgrade to
Yeah, I get that an accountant doesn't call this income, but frankly, I don't
really care about the esoterica of accounting in this case. I care about what
the government says is income. Accountants can yap all day long about how the
IRA payouts aren't income; the IRS is still going to fine me
Michael,
I think I get what you're saying. In my own case, I've taken to separating the
pretax streams into their own income accounts, which seemingly addresses some
of your points.
But one of the big selling points of IRA/401Ks is that they earn money tax
deferred (which I've also isolated
Every stock has a Namespace in Gnucash. "NYSE" "NASDAQ" are examples.
I have an online spreadsheet into which I can paste my Advanced Portfolio data,
and then a second worksheet in the file compiles the prices for the result set,
which can be cut and pasted locally for import.
On 2022-03-16 15:09, D. via gnucash-user wrote:
> when Joe Retiree takes money from their IRA, the IRS considers it income, and
> taxes it accordingly. But when Joe tries to enter the transfer from their IRA
> to their checking account in GnuCash, it doesn't get treated as income
--
Stan
I track the prices of Mutual Funds, Stocks and Precious Metals and
import them all with a single CSV file.
In all three cases I do not use any of the pre-defined GNUCash Namespace
names. I use all user defined name space.
On 3/16/22 8:08 PM, Art Chimes wrote:
I well remember agonizing
I well remember agonizing over this when I first set up price imports.
There's a bit of a learning curve here.
"Namespace" can be FUND (if it's a mutual fund), NYSE or NASDAQ or
AMEX if it's a stock on the New York Stock Exchange, NASDAQ, or the
American Stock Exchange, respectively.
Most
Oh, I know about using the tax flag and TXF report. Done it for years. But
unless you figure out how to do what Mike has mentioned (consistently over the
years), if you flag these accounts as tax-related, they still don't show as
income, because you're transferring money from one asset account
Thanks.
One question... I don't know what is "the entry from Gnucash" ? err...
what entry from Gnucash?
:George
On 3/16/2022 2:59 PM, D. wrote:
I am able to import prices from csv with a four column source:
Ticker, Namespace, Price, Date
Namespace is the entry from Gnucash.
GnuCash also lets you mark accounts as tax implicated and you can I
think tie them to certain 'lines' or certain 'forms'. That's used for
personal taxes as well.
I wasn't even thinking about the sales tax features for invoices/bills
which is something entirely separate.
If simply marking
On 3/16/2022 7:03 PM, Gyle McCollam wrote:
Michael has the right approach. Recording this when taking income involves 4
account. However, don't forget that if it is coming from a Roth IRA there is
no tax. 401K and Traditional IRA will involve a tax liability, but that is a
whole other
On 3/16/2022 6:09 PM, D. via gnucash-user wrote:
Adrien,
Overall, I think you're right, but I believe the tax features you're referring
to are used to calculate taxes for a business? The issue with deferred income--
and this has been true for as long as I can remember-- is that when Joe
Michael has the right approach. Recording this when taking income involves 4
account. However, don't forget that if it is coming from a Roth IRA there is
no tax. 401K and Traditional IRA will involve a tax liability, but that is a
whole other animal.
Thank You,
Gyle McCollam
Gyle McCollam
Adrien,
Overall, I think you're right, but I believe the tax features you're referring
to are used to calculate taxes for a business? The issue with deferred income--
and this has been true for as long as I can remember-- is that when Joe Retiree
takes money from their IRA, the IRS considers
I am able to import prices from csv with a four column source:
Ticker, Namespace, Price, Date
Namespace is the entry from Gnucash.
Original Message
From: George Riner
Sent: Wed Mar 16 11:36:14 EDT 2022
To: gnucash-user@gnucash.org
Subject: [GNC] importing prices from csv
My specs:
Platform: Windows 10 (64-bit) build 19044.1586 (32Gb RAM)
Gnucash: 4.9+(2021-12-18) Enaaglish
Finance Quote: 1.51a
I live and work in California, USA.
I've been trying to use the "Import Prices from a CSV file..." tool.
I've got a CSV with symbols ('ticker symbols'?) and prices, and
On 3/16/2022 10:48 AM, David G. Pickett via gnucash-user wrote:
OK, not anything like an accountant, so my books have just asset, liability,
income, expense. Equity might be a better place for the IRA/401K, since it is
an asset with a varying value and an attached tax liability TBD. So, how
I handle qualified plans with 3 generic transactions.
1. Contributions to plan: credit cash (if making a contribution from a bank
account) or wage income (if making the contribution directly from your
paycheck), debit to your plan
2. Gains to your plan. Unrealized gains should adjust the plan
I could be missing something, but I thought that was already covered by
one of the answers. Also, I'm pretty sure the proper place to record and
track that is in an Asset account, not Equity.
As for the transactions, if you need to do virtual 'extra tracking'
beyond just the physical
On 2022-03-16 07:48, David G. Pickett via gnucash-user wrote:
> Equity might be a better place for the IRA/401K, since it is an asset
If it's an asset (and I agree that it is), then I submit that Assets is
the best place for it!
--
Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
OK, not anything like an accountant, so my books have just asset, liability,
income, expense. Equity might be a better place for the IRA/401K, since it is
an asset with a varying value and an attached tax liability TBD. So, how
should I have set up such 100% pretax deferred income accounts to
32 matches
Mail list logo