It does seem odd that the importer does not default to the same choice that
the user has chosen for the data file, even though it is important to allow
the user to change it if (s)he has a CSV file with a different choice.
On Sat, Jul 29, 2017 at 7:36 AM, Jean-David Beyer
My home Wi-Fi has suddenly developed a bad case of dropouts in spite of a
very strong signal. Several times a day various devices need to reconnect.
With that background, if GnuCash is in the process of saving the data file
(over Wi-Fi) when the dropout happens, GnuCash appears to hang and my
Is that the new package of release 2.6.17 from getdeb that I just tried to
download into Ubuntu and have not had time to test yet?
On Aug 1, 2017 8:25 PM, "John Griessen" wrote:
> I have not been able to upgrade gnucash for a while now.
> Will there be a
Another thing to try that once helped me to fix some old and broken SEx's
(android did tat and I can't fix it.) is to enter zero's into every empty
acccouunt value box so there are two values in each line.
Sounds crazy but it actually worked
On Aug 3, 2017 2:48 AM, "Steve"
There is a steep hill to climb to export history from a 'Q' program and
import it into GnuCash.
Many of GnuCash's current users felt that it was worth the effort to switch.
Even if you do not import any history, there is a learning curve to get
your account tree set up correctly, etc.
In my experience it depends on which method you use. I usually use the OFX
import and if I choose update the new text replaces the existing so I often
either choose match which keeps the existing text or add to keep.the
existing transaction intact so I can manually merge text later.
If your accounts are in different currencies, which they might be, each one
should be denominated in the correct currency. The parent accounts
(Assets:Current) probably also need to be set up separately for each
However, I am not a multi-currency user, so I may be wrong
Did you look at gti90...@gmail.com answers in the clean CSI export thread?
On Jul 3, 2017 9:42 AM, "John Ralls" wrote:
> > On Jul 3, 2017, at 6:38 AM, aegross wrote:
> > On Mon, Jul 3, 2017 at 12:50 AM, John Ralls-2 [via GnuCash] <
When you say you use the transaction again, do you mean that it is
scheduled and comes up when running the Since Last Run Assistant? Exactly
at what point does it crash?
On Thu, Jul 6, 2017 at 1:14 AM, Frank wrote:
> I'm relatively to gnucash and am looking to
Does that mean that when users download files from their financial
institutions and import them offline they will always get that message in
the description field?
I would prefer "OFX ext. info: |Trans type:Generic debit|Memo:" as before,
unless an option is added to even suppress that
Sorry, I am confused about field names. Is that new message in the
description field instead of the current data or is it actually in the
Notes field where the previous message was prepended to the FI note?
On Thu, Jul 6, 2017 at 1:26 PM, David Carlson <david.carlson@gmail.
The Opening Balance shortcut that you see when creating an account is not
functional after the account is created, as you have seen.
That shortcut just creates a transaction to offset the opening balance with
an entry in Equity:Opening Balances. You can open that account and
It seems that you are the first to report your problem. That is why the
developers are asking so many questions about details. Please check the
about gnucash screen and tell them the exact release number and build date.
On Wed, Aug 2, 2017 at 7:24 AM, Christine Maloney via
It is curious that this form is not in the list. For tax related accounts
that cannot be assigned to the proper form you could just mark the account
as tax related without the form assignment, and it will be in the report
where you will at least be reminded to include it in your filing.
What I do is keep two register views open on the 'parent' account, one
'with sub-accounts' which shows the totals as seen by the bank and one
normal register view which shows the amount not dedicated to the 'virtual'
As suggested in the thread that you cited, I do not tell the
For me the time to move, decrypt, and decompress the data file and generate
the register views and report views is so much longer than loading the
program that I do not even try to measure that part.
On Sun, Aug 6, 2017 at 5:50 PM, Greg Feneis wrote:
> Also FWIW, I
ike would be for some "real" transactions to
> reference the parent account and some to reference the virtual account.
> Then when importing the QFX the import process would look in the parent
> account and the sub-accounts.
> On Sun, Aug 6, 2017 at 6:15 PM, David Carlson &
I would not recommend doing that, as it would fill your bank account
register with many entries that would be a nightmare to reconcile against
your bank statement, but one brute force way to do it would be to duplicate
the transaction as many times as necessary, then edit each one to delete
I would also suggest trying the View>Auto Split Ledger>and View>Transaction
Journal menu options to see how those affect what you see while you are
I also happen to like to use the Double Line view. In fact I wish the
double line view was the out-of-the-box default.
In Summary -
A few of the reasons that GnuCash might report (or suggest opening) a file
as read-only are:
1. The last time the file was opened it was not closed properly, leaving a
.LCK file in the data file folder.
2. The data file is in a folder that the OS has marked Read-Only.
3. There could
It has been several years since I had a similar situation, but I see that
GnuCash still has a stock split assistant (Chapter 11, I think of the
tutorial) which helps to mash all of the parts of a split into a single
transaction. Did you try that?
On Thu, May 18, 2017 at 3:18 AM,
I used to think that GnuCash created .log files periodically when
theauto-save interval has passed since the last edit.
Now, it seems that GnuCash does a complete file save according to that
interval. If that is the case, why have a .log file?
Are you using View>New Accounts Page to see the list of accounts?
On Mon, Jun 12, 2017 at 4:37 AM, Jonathan Silvey
> have two problems that may or may not be related.
> First, when I want to go to my main list of assets and liabilities, the
-- Forwarded message --
From: Andrew Shalaurov
Date: Tue, Jun 20, 2017 at 12:14 PM
Subject: Import Transactions to Gnucash Excised from: Gnucash file is
Can someone explain to me how to import transactions so 2 GL accounts are
assigned to each
none if I do an early save.
Sent via the Samsung Galaxy S® 5 ACTIVE™, an AT 4G LTE smartphone
From: Buddha Buck <blaisepas...@gmail.com>
Date: 5/16/17 2:41 PM (GMT-06:00)
To: David Carlson <firstname.lastname@example.org>, gnucash-user
There are a number of things that could go wrong. To eliminate some of
them, can GnuCash print any of the standard reports? Have you followed the
procedure outlined in chapter 6 of the help manual? If so, which part does
Which operating system do you have? Are you using GnuCash
I really hate to rain on your parade...
Check your Edit>Preferences>Accounts>Reverse Balanced Accounts.
I believe the default is labelled Credit, but that means Credit Card,
Equity and Income, and that is probably what is checked in your file.
If that is so, then the balance
Seems like the Since Last Run assistant could have an optional feature to
rerun automatically from time to time if there is something to do and the
program has been open overnight.
On Thu, Jun 8, 2017 at 11:34 AM, Maf. King wrote:
> On Thursday, 8 June 2017 17:06:50
Must have been intermittent. I was there a couple of days ago too.
On Jun 8, 2017 10:00 AM, "Maf. King" wrote:
> ISTR that I was on it yesterday (or the day before. Looking at the FAQ to
> point Edwin in the right direction). of course, I may have found a cache
threads got scrambled here. Is this still about the website health?
On Thu, Jun 8, 2017 at 1:38 PM, Kalin KOZHUHAROV wrote:
> On Thu, Jun 8, 2017 at 6:59 PM, Derek Atkins wrote:
> > On Thu, June 8, 2017 12:45 pm, Kalin KOZHUHAROV wrote:
> >> On
I often have duplicate entries appear in transfer accounts when I import
transactions resulting from imperfect matching during the import process.
While these are usually easy to find and fix, sometimes I make an error and
"fix" the wrong transaction or split.
If a previously reconciled
Ok, the next thing to do is to go into your register view and look at the
running total next to each of the transactions that you show in your
images, to see if the value was correctly added or subtracted by GnuCash.
Also set the register view to Transaction Journal to see if there are any
If the MySql format data file is not on the main hard drive but a) on a USB
2.0 or 3.0 key, b) on another computer accessed by Wi-Fi or Ethernet, c) on
a cloud server.
Would the MySql database format be faster than the compressed XML in any of
the above scenarios, particularly when periodic
When you have the curser in a split line of a transaction, the word 'Tot'
disappears. You only see that when the curser is in boxes that are not a
part of a split line.
On Fri, Jun 16, 2017 at 10:53 AM, Maf. King wrote:
> On Friday, 16 June 2017 16:04:02 BST
Well, if you read the manual you will find the answer to all your prayers,
or at ieast to all the "faults" that you have found so far with GnuCash.
Well, there is no way to replace the description with the notes other than
to put the text that you want to see in the Description field. Isn't that
Follow this link.
On Jun 18, 2017 1:41 PM, "Kalin KOZHUHAROV" wrote:
On Sun, Jun 18, 2017 at 6:45 PM, Alain Dormoy wrote:
> My problem is I had in the past
To elaborate on Derek's explanation, all the 'Charges' in your credit card
(Liability) account should appear on the right side in the credit card
account, and on the left side in the various expense accounts if you 'jump'
to the expense accounts.
On Tue, Jun 13, 2017 at 11:44 AM, Derek Atkins
I think that John Ogden has a valid question which should be covered better
somewhere in the manual.
The short answer, unfortunately, is that there is no way to split out old
data to shrink the data file. Also, it is a fact that eventually your file
may grow to the point where it taxes your
Wow, now we are getting some well detailed suggestions!
I will add a couple: To quickly see if all previous transactions were
really reconciled, select View > Filter by .> Status > uncheck Reconciled.
If you don't have too many transactions with dates earlier than the bank
cleared them, your
Good call David R,
Another point of possible confusion for even long-time users like me is
that the column titles will change as the curser moves around in the
transaction display, so the user must carefully note the current position
of the curser to correctly interpret the column title.
Did you try replacing the cable? Low hanging fruit...
On Fri, Oct 6, 2017 at 8:39 AM, Derek Atkins <warl...@mit.edu> wrote:
> David Carlson <email@example.com> writes:
> > Derek,
> > Is it possible to read event logs and deter
; On Fri, October 6, 2017 10:27 am, David Carlson wrote:
> > Derek,
> > Did you try replacing the cable? Low hanging fruit...
> > David C
> > On Fri, Oct 6, 2017 at 8:39 AM, Derek Atkins <warl...@mit.edu> wrote:
> >> Da
> *Clovis, Ca
> *559.297.8577 <(559)%20297-8577> H*
> *559.304.1751 <(559)%20304-1751> C*
> On 10/2/2017 10:11:19 PM, Da
Frank and David T,
I believe that the QIF importer may not work exactly the same way that it
did back in the 2.2 series or the 2.4 series or even the 2.6 series before
If that is the c as e then we really do need someone who is familiar with
the way it works now to jump in and
, 2017 at 6:55 PM, frank raney <frankraney...@gmail.com> wrote:
> *Frankie Raney*
> *If it worked good in 2.2, then maybe I can get that version, try it and
> if it works good, then upgrade.*
> On 10/7/2017 4:45:51 PM, David Carlson <firstname.lastname@example.org
You do not mention important details that are needed to give a definitive
answer, but assuming that you followed the a likely path, you exported
transactions from your Quicken file in QIF format then imported them into
GnuCash in the same format.
The QIF format creates a data section for each
ad to translate this to the menu entry
> >"edit/find" (not "search")
> >- elmar
> >On 10/09/2017 04:16 PM, David Carlson wrote:
> >> Geert,
> >> Gmail used those ing triple dots to hide yo
Not sure about more efficient ways to import via QIF, which, by the way, is
reasonably efficient when done in small chunks, but another caveat that
has not been raised recently is that as the data file grows it takes longer
to do the frequent file saves.
In Windows each save for my data file
I am not a developer, but I can point out that the QIF importer works in
several discrete steps where (roughly) it
1. identifies the 'source' account type and name and tries to associate it
to an existing account in the data file. If there is more than one
'source' account in the QIF file it
It sounds to me like you are unwilling make the effort to "shepherd" your
data through the import process. Many of us, including David T are trying
to tell you that we have succeeded in completing massive imports from
Quicken into GnuCash, but we needed to take several steps to plan our
I think that what you both are seeing is, in fact, as you have correctly
asserted, Garbage In Garbage Out.
Normally there are no running totals in search register views because they
are an accumulation of transactions over an indeterminate sub set of the
entire data set. Then a report derived
I think it is about the same as from Quicken, but perhaps easier because
Moneydance is closer to being double entry.
If they still have QIF exports ...
On Oct 16, 2017 8:51 AM, "Roger Miskowicz" wrote:
> Is there a recommended procedure for migrating Moneydance
ate tab. Thanks
> On Sep 25, 2017 2:04 PM, "David Carlson" <email@example.com>
>> On the Template tab it is in the upper left as in the register view.
>> David C
>> On Mon, Sep 25, 2017 at 12:23 PM, <rmom...@gm
The OFX import assistant includes a step to match newly imported
transactions to existing transactions, as you probably noticed.
The problem is that it is error prone and has to be monitored carefully
during the import process. I prefer to import a small number of
transactions at a time so that
I use Remind in Advance for that purpose, but it is somewhat clumsy too. I
put the word Sched in the Num field to remind me that the transaction has
not really happened yet.
On Mon, Sep 25, 2017 at 10:12 AM, Matthew Pounsett
> On 25 September 2017 at 10:57,
They already are
On Sep 27, 2017 1:37 PM, "Dan" wrote:
> When will Excel or CSV import be available?
> gnucash-user mailing list
Just one comment from another user;
My banks do not show holds online, or if they do, it is a simple summary of
book balance vs available balance. They warn that ACH transfers these-days
often clear on the same day.
To me, it is too much effort to try to track that, and as others have
That might be difficult, as it may be a loose connector or even corrosion
inside a cable or connector or component in a power supply or ???
On Oct 2, 2017 10:42 AM, "Derek Atkins" wrote:
> Just a quick follow-up.
> AT did come, and with their help
I think the answer is "What works best for you."
When most of our bank account transactions were checks (cheques in many
countries) we entered each check by date and number in the checkbook
register. When the bank statement came we compared it to our register,
checking off each one that appeared
Is it possible to read event logs and determine that some pieces of
equipment are definitely not causing the problem?
On Oct 3, 2017 10:04 AM, "Derek Atkins" wrote:
> GWB writes:
> > So AT's network equipment works when nothing is connected
What is the Future Scheduled Transactions Summary report supposed to do?
It looks like it might work, but it seems to be cluttered with a lot of
strange values with too many decimal places and/or fractions with large
On Sun, Sep 24, 2017 at 7:31 PM, R. Victor Klassen
monitor tool of some sort that you can run to see
> how much memory is being used. Try running that and then the report
> and see if you are running out of RAM
> On 24 August 2017 at 22:59, David Carlson <firstname.lastname@example.org>
> > It i
I do not use budgets so I cannot comment on that part, but several other
reports run very slowly for me, meaning they sometimes take minutes to
update. GnuCash pretty much single threads, even on very powerful
computers. The developers know about that and they are working feverishly
In the United States "Sales Tax" is a generic term for taxes that are
collected at the point-of-sale and usually turned over to a state, city,
county or other government agency by retailers.
It is even difficult to make a concise and grammatically correct statement
to describe the process.
It sounds like you are starting GnuCash more times than you are shutting it
down. GnuCash can open more than one instance at a time, which would cause
the same message.
Take care to return to the open instance rather than starting a new
instance when you return, because it is possible to lose
hile I save whatever still needs
to be saved and I click on the cross in the upper right corner of my screen
(am I missing something?) *
*De :* David Carlson <email@example.com>
*Date :* samedi 2 septembre 2017 12:37
*À :* Alain Dormoy <cag...@free.fr>
*Cc :* Colin Law &l
Gmail used those ing triple dots to hide your reply in my mail folder.
Lucky for me I suspected as much when there appeared to be no reply .
On Mon, Oct 9, 2017 at 2:48 PM, Geert Janssens
> Start with a search from the account hierarchy
*559.304.1751 <(559)%20304-1751> C*
On 10/7/2017 7:15:37 PM, David Carlson <firstname.lastname@example.org> wrote:
I did not mean to imply that it worked better then, but it may have worked
differently in older releases. In any case, if you went that f
> *Frankie Raney*
> *12454 Auberry Rd.
> *Clovis, Ca
> *559.297.8577 <(559)%20297-8577> H*
> *559.304.1751 <(559)%20
There is still a problem with Gnucash on your computer because it should
not be crashing.
It may be somehow related to the account named Trading that GnuCash
created. Normally, GnuCash will only create that account for users that
know that they want to use a special feature that is there
I forgot to mention that there is a setting somewhere called "Use Trading
Accounts" that turns that feature on or off. I think it is mentioned
somewhere in the documentation.
On Wed, Oct 11, 2017 at 4:07 PM, David Carlson <email@example.com>
> *559.297.8577 <(559)%20297-8577> H*
> *559.304.1751 <(559)%20304-1751> C*
> On 10/11/2017 2:14:08 PM, David Carlson <firstname.lastname@example.org>
> I forgot to mention that there is a se
There is a section in the GnuCash FAQ about what files are where for the
various OS's. IIRC there is a .gnucash directory under ~user or some such
which can be copied and pasted into another machine, even under a different
OS but that would overwrite whatever is there. Do not try that without
> *559.297.8577 <(559)%20297-8577> H*
> *559.304.1751 <(559)%20304-1751> C*
> On 10/11/2017 10:00:32 PM, David Carlson <email@example.com>
> What O S are you installing int
John R. Sowden,
Could you please elaborate on your assertions that
1. "errors, often based on changing amounts (2 debits, etc.,) are hidden
from the user."
2. "A 'preference' switch to allow users who are familiar and comfortable
with the 'Intuit Way' to continue, vs. those with accounting
Are you having a problem using the Export function or is your problem with
reading the output with a spreadsheet program?
On Mon, Oct 23, 2017 at 3:58 PM, Jonathan Silvey
> I'd like to export a single account to Excel but I can't find Export on
A running balance is defined on the premise that amounts are in only one
account sorted in chronological order.
Your find criteria cross accounts and may not necessarily be in
chronological order, so it would be purely coincidental if the numbers
matched a transaction report on some
The CSV import assistant in release 2.6 series is not able to import files
created by GnuCash.
This is a known problem which will be corrected when the 2.8 release comes
That release will change the data file structure in a way that will not be
readable by older releases of GnuCash.
I thought I saw instructions somewhere on how to update the Finance-Quote
module, but now I cannot find it. The instructions in the GnuCash FAQ are
not sufficiently complete for dummies like me. I get an error
gnc-fq-update command not found then I do not know what to do next.
What is the name of your data file and where do you have it stored? If all
the accounts are devoid of transactions, are they all present?
Did you look for the backups that are mentioned in the online FAQs?
On Thu, Nov 9, 2017 at 2:39 PM, Roy Molepo wrote:
As far as I know, what you are describing has been the way GnuCash works on
Windows for the entire life of the 2.6 series as well as the 2.4 series
I am currently using various releases from 2.6.12 on to release 2.6 16 in
Windows and Linux and I see the same with files saved in
Is there a way to export data from Quicken in QXF format?
On Sat, Nov 25, 2017 at 9:50 AM, Ken Schneider
> On 11/24/2017 05:15 PM, Kenneth Schneider wrote:
>> I did this a few months ago and found it best to do each quicken account
>> separately. If the
Do you have similar problems with other files on that computer? Do you
check it for malware regularly? It seems a little odd that you were able
to place the file there without write permission unless you do have
multiple users on that computer. You may need to find an expert that is
You have the attention of several different experienced GnuCash users from
various different backgrounds, and we all share your frustration.
Your experience does not match that of a typical user. In my opinion there
is something unusual about your computer or how you managed to get the
If you receive income you might deposit it into the bank. If you spend
money for groceries, you use cash. If you withdraw money from the bank you
transfer from bank to cash.
That is what double entry is about.
On Sun, Nov 26, 2017 at 6:33 PM, Christine via gnucash-user <
Are you asking for GnuCash to perform magic or just pretend?
On Dec 5, 2017 12:25 AM, "Jesse Cochran" wrote:
> To whom it may concern,
> Given how limited and un-free our monetary system is nowadays, I think
> GNUcash would make a great tool for the
Could this script be referenced somewhere in the GnuCash WIKI?
On Sat, Dec 16, 2017 at 3:44 AM, David T. via gnucash-user <
> I’m sorry. Your original characterization was vague, and I didn’t
> understand what your issue with that report was. I see what
The two bug reports contain different descriptions of the reasoning behind
calling it a bug, so I think that it would be appropriate to just leave
them cross referenced until the situation is resolved, rather than marking
one as a duplicate.
On Fri, Dec 15, 2017 at 9:25 PM, Daniel
at 11:20 AM, D <sunfis...@yahoo.com> wrote:
> See below.
> On November 13, 2017, at 9:02 PM, David Carlson <
> firstname.lastname@example.org> wrote:
> >I have been using GnuCash for many years and there are many securities in
> >my file that I no longer own,
I have been using GnuCash for many years and there are many securities in
my file that I no longer own, but I may or may not have discontinued
downloading their prices. In trying to get my Alphavantage source working,
it appears that it does not work if there is a mix of some securities
Yes, that is the way Gnucash behaves when you select the Update + Reconcile
option while matching transactions. I rarely use that option for that very
reason. I mostly use the Reconcile option.
I will get on my soapbox here, since I think that the word Reconcile is not
used correctly in
the file before starting the
import. I recommend saving first in every case.
On Mon, Nov 20, 2017 at 6:57 PM, David Carlson <email@example.com>
> Yes, that is the way Gnucash behaves when you select the Update +
> Reconcile option while matchin
The lock file is always in the same folder as the data file and it always
has the same name as the data file with the suffix .LCK Unless you are
doing something very unusual, the files will be visible in your file
explorer as long as you put them somewhere in your user folder on your
I believe that others will concur that you do not have write permission in
the folder containing that data file. Is your user name User?
That is also why GnuCash failed to create a .LCK file. You need to make a
new folder on your desktop, call it Moira_GnuCash_Data or similar and use
I have succeeded in re-using scheduled transactions but there are some
limitations. In your case, I think that using the for some number of
occurrences may be what is preventing further use of that SX. I have never
used that box. Last Occurred is only settable by the program so once it
I assume that you know that 2.7 is is a pre-release version, I would call
it an alpha or beta version, not for production use.
That said, I thought that the developers had updated it so that it did not
crash instantly in Windows. Be sure that you have the most recent build.
It may be a bit hard
If you check the other thread on this user maillist, you will find more
In the meantime the simplest work-around is to log in to your favorite
finance website, get the prices that you need and manually enter them in to
I am not happy about that either.
On Fri, Nov
The OFX/QFX import requires a lot of TLC during the import to get
everything right. During the verification step it is critical to examine
each transaction carefully to be sure that if it is new it gets added, if
it matches an existing transaction in your data it is matched to the
w. I'll try that tomorrow. Thanks
> On Oct 31, 2017 7:20 PM, "David Carlson" <firstname.lastname@example.org>
>> Roger, for your second question, I think that a search in the General
>> ledger view should produce it's results in a new results view rather
I wonder exactly what "Term of Service" we violated?
On Thu, Nov 2, 2017 at 6:10 PM, MGC wrote:
> The error message I'm getting now says:
> It has come to our attention that this service is being used in violation
> the Yahoo Terms of Service. As such, the
1 - 100 of 509 matches
Mail list logo