>>> Rather than using xml data files, which have always seemed odd to me <<<
There are pros and cons to substituting a RDBMS for XML. Since GnuCash was
originally designed for an in-memory data store, the XML is it's native
persistence system. Over time, it has been altered to substitute a SQL
The presence of the lock file and an unchanged XML data store would be the
expected condition if GnuCash had yet to terminate for some reason. A
simple way in Windows to check for termination would be to run the test with
a task manager open. GnuCash would blink out once it terminated, at which
I like that idea. I often looked for such a functionality where I can store my
incomplete sometimes just missing of an internal number prevents putting items
on an invoice for a month and it needs to wait for the next month.
At the moment I use an excel sheet where I store the incomplete work.
Heidi,
Also, this sounds like a credit card being used for several purchases
throughout the month. In which case it is better to record the
individual purchases as they occur. Or, download the individual lines
to import.
In that case, you will have a Liability:Credit Card:nameofcc account
heidi,
It would appear you don't understand the basis of double entry accounting which
is what is used in accounting practice generally and by GnuCash.
The Tutorial and Concepts Guide for GnuCash,
https://www.gnucash.org/docs/v4/C/gnucash-guide/index.html, has a brief outline
of the basis of
Nope, because GnuCash uses the DB only as a data store. All of the business
logic and referential integrity are inside GnuCash. If you write the database
from outside of that you can far too easily unbalance transactions or break
critical references.
Regards,
John Ralls
> On Jan 21, 2022, at
I am going to try one more time before I give up regarding the split
transaction. Let’s say last month I paid from my checking account a credit card
balance of $500.00, the credit card charge was $200 for grocery, $300.00 for
two chairs. So I recorded a split transaction of debit grocery
Apologies: I sent this to the OP rather than to the list.
I know we discussed having the list set Reply-To the list rather than
the individual, but I can't remember why that was rejected.
Forwarded Message
Subject: Re: [GNC] Short-Term Capital Gains question - Entering Mutual
Is any tool, perhaps SQLite studio (https://sqlitestudio.pl/about/), supported
as the alternate to an GNC API as the Editor that won’t void the warranty?
From: Thomas Forrester
Sent: Friday, January 21, 2022 5:03 PM
To: John Ralls
Cc: Kalpesh Patel ; gnucash-user
Subject: Re: [GNC]
Kalpesh,
If PocketSense downloads OFX files you don't need to do anything with the
GnuCash bindings. Just use File>Import>Import OFX/QFX on the downloaded file.
Besides, the importers aren't accessible from the python bindings.
Regards,
John Ralls
> On Jan 21, 2022, at 3:08 PM, Kalpesh Patel
Sadly Vanguard does not offer OFX formatted download. They only provide QIF,
in one account or individual mutual fund accounts, or CSV format - very
limited formats. Even with QIF format it is a hit or miss in importing to
GNC and CSV formatted requires good deal of post-processing
If you
Art,
>From an accounting perspective you can use any combination of sub-accounts you
like/need to provide the information you need for either taxation and/or
management purposes.
If there is no need to differentiate dividend and STCG for taxation purposes and
you don't need to for your own
Dan,
This really has nothing to do with crash recovery per se, just makes that easier
as it is easier to locate the appropriate files.
You can move an existing data file to its own directory by using the file
manager to create a suitable directory and then moving the main data file and
any
John,
Haha! Yeah, I'm afraid I've voided that warranty a few times, but only to
correct reconciliation issues that took me moments to correct in Access,
yet seem to cause much hair-pulling and gnashing of teeth with others.
I don't think it would be any performance or storage issue to simply
Kalpesh,
That's a medium sized file.
>From https://www.sqlite.org/features.html: "* cross-platform: Android, *BSD,
>iOS, Linux, Mac, Solaris, VxWorks, and Windows (Win32, WinCE, WinRT) are
>supported out of the box. Easy to port to other systems."
SQLite3 is remarkably stable and widely
Having the database read-only in Access sounds like a feature: Writing to the
GnuCash database using anything except the GnuCash API voids your warranty.
Access insisting on a non-text Primary Key an Access bug. All of GnuCash's
tables have primary keys already, but they're mostly text
I have tried to switch to SQLite3 this afternoon, and although I cannot
answer all your questions, I have observed the following:
1. Regarding your stability on Windows question, Check Wiki on SQLite.
It's pretty ubiquitous at this point and extraordinarily stable on all
platforms. I don't
Art,
I'm no accountant, and I'm only speaking from my own experience.
I have similar holdings and reporting. For my purposes, I track dividends,
LTCG and STCG in separate accounts by brokerage. That way, I can match my
accounts against the EOY reports issued by the brokerages and track
Few questions in regards to SQLite3 backend recommendation because currently
XML format for my data is compressed size of 1.82MB so exploring moving to
it. Not sure if this is considered small sized XML file or not but .
1 - SQLite was natively born on UNIX systems with UNIX systems in mind so
Peter,
Stan's procedure is fine for creating a new file going forward.
If you want to bring your previous file up to date so it works with the latest
version the following procedure as outlined by Adrien in an earlier post today
is recommended.
Stan
When you have the report set as the main tab, the Edit Menu will have a Report
Options in the pop-up. Select it then change the values to those you require and
close the dialogue and the report will display with the selected options.
David Cousens
On Fri, 2022-01-21 at 09:01 -0700,
Heide,
Try increasing the "Level of Subaccounts" setting on the Accounts tab of
the Report Options ?
Cheers David H.
On Sat, 22 Jan 2022 at 04:37, Heide Wang wrote:
> If I have three different bank account under the current asset- bank, how
> do you get the balance sheet to show all the bank
Good point, John. I agree that MySQL has a large administrative footprint
and certainly does take an IT mindset. I hadn't considered, or even
realized that GnuCash could use a SQLite database. Maybe that's because
the use of SQL as a backend was just a beta thing back when I boarded this
bus?
Thanks for this -- and the other replies -- it's just what I was looking
for.
I neglected to make clear that my question was entirely about the CoA
structure; I am very clear about the tax reporting requirements and
consequences.
I like the idea of an intermediate-level account for each
Most of my mutual funds and exchange-traded funds distribute earnings
in three categories — dividends, short-term capital gains, and
long-term capital gains.
In the U.S., LTCG are profits from the sale of securities one year or
more after purchase, and they are taxed at a favorable rate. STCG are
If I have three different bank account under the current asset- bank, how do
you get the balance sheet to show all the bank account balance. My balance
sheet only show the total of three different bank accounts.
Heide
___
gnucash-user mailing list
Thank you for the excellent advice.
From: gnucash-user on
behalf of Stephen M. Butler
Sent: 21 January 2022 17:45
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Advice on restarting use of GnuCash
On 1/21/22 08:45, Derek Atkins wrote:
> Hi,
>
> On Fri,
On 1/21/22 08:45, Derek Atkins wrote:
Hi,
On Fri, January 21, 2022 11:04 am, Peter Coleman wrote:
I used GnuCash for our household finances up until about two years ago. I
now want to start using it again with effect from 1.1.22. The version of
my software is 2.6.19 (probably about 5 years
On 1/21/22 08:01, bonoposo007 wrote:
HELP!!! How can I print my profit/loss for 2021…reports only wants to print
current year.I have googled and looked at manual, tells me to go to option in
reports but there is no such tab in my file.
The system says I have 4.8
The Top row should end with
Hi,
First, please only reply to the specific message, not the whole digest
message...
On Fri, January 21, 2022 12:18 pm, Dan wrote:
> Thank you David Cousens for your reply, I have studied it to great
> benefit.
> One question I have is whether the mainfile can be automatically stored in
> its
Thank you David Cousens for your reply, I have studied it to great benefit.
One question I have is whether the mainfile can be automatically stored in
its own directory through a setting, or if I need to move the mainfile to
its own directory manually. Also, should this be done on a regular
Hi,
On Fri, January 21, 2022 11:04 am, Peter Coleman wrote:
> I used GnuCash for our household finances up until about two years ago. I
> now want to start using it again with effect from 1.1.22. The version of
> my software is 2.6.19 (probably about 5 years old).
>
> I would like to keep the
Very few users will be able to manage a MySQL database server safely.
Fortunately GnuCash provides a SQLite3 backend that doesn't require any
database admin skills. The only caveat is that unlike XML it doesn't write a
fresh file every session so you need to arrange backups on your own; the
Click the Options button once you have the report up. Then go to the
General tab and change the date range.
Regards,
Adrien
p.s. when replying to a digest, please only quote the relevant part, and
when starting a new thread, just send a new message to the list rather
than hitting 'reply' to
I used GnuCash for our household finances up until about two years ago. I now
want to start using it again with effect from 1.1.22. The version of my
software is 2.6.19 (probably about 5 years old).
I would like to keep the existing account structure, as I have saved lots of
detail there, but
HELP!!! How can I print my profit/loss for 2021…reports only wants to print
current year.I have googled and looked at manual, tells me to go to option in
reports but there is no such tab in my file.
The system says I have 4.8
STAN PERKINS, MBA
Senior VP Sales & Investment Consulting
NAI
Are you certain you are in the right data file and not in an old or
different one?
Regards,
Adrien
On 1/20/22 10:00 AM, Richard E. Barmann wrote:
After using GnuCash for years I suddenly have it start me with a o1
Invoice number instead of 001478, Also I cannot retrieve my STYLE of
Heide,
It would likely be safest and easiest to upgrade in these steps:
1. 2.6.21 (the last 2.6.x version)
2. 3.11 (the last 3.x version)
3. 4.9 (the current version)
I'm fairly certain, you don't need to upgrade to lower releases of each
major version first. (such as 3.0 or 3.1, and 4.0 or
Seems like a lot of work. No doubt you're finding interesting anomalies,
but...
Rather than using xml data files, which have always seemed odd to me (a la,
this thread), if you use a MySQL database instead, all saves are automatic
and completely bypass the need for all this testing. You still
After using GnuCash for years I suddenly have it start me with a o1
Invoice number instead of 001478, Also I cannot retrieve my STYLE of
Invoice. I have some old files with the invoice style. How can I go back
to them.
Richard Barmann
___
The test cases that appear to have failed aren't conclusive, however, without
confirming that GnuCash had actually terminated, and terminated normally.
-Original Message-
From: gnucash-user On
Behalf Of Peter
Sent: Thursday, January 20, 2022 9:39 AM
To: gnucash-user@gnucash.org
41 matches
Mail list logo