ses any restrictions or not at this stage.
> > David Cousens
> > On Wed, 2019-01-16 at 18:19 -0600, David Carlson wrote:
> >> On Wed, Jan 16, 2019, 4:36 PM David Cousens wrote:
> >>> David
On Wed, Jan 16, 2019, 4:36 PM David Cousens David
> Have you tried examining the file with ofxdump? If you are on Linux, it can
> be installed with "sudo apt install ofx". Not sure about how to get it for
> WIndows or MacOS. It will dump to stdout whatever ofxdump can determine
> about an ofx
Using GnuCash 2.6.17? in Ubunutu 16.04 I noticed that the OFX importer from
time to time will fail to import some, but not all transaction memos for
only one of the banks that that are currently active in my data.
This bank tends to send lenghthy memos. One of the failed memos had 98
Certainly you know how difficult it is to select text on a smartphone.
On Sun, Jan 13, 2019, 3:01 PM Geert Janssens Op zondag 13 januari 2019 21:30:54 CET schreef Stan Brown:
> > The real issue, I'm sorry top say, is that many people are lazy, and
> > just start typing wherever their
Unfortunately, gmail seems to force me into top posting by opening up my
reply with the previous text at the bottom an d hidden below three dots.
Especially on a tablet, where it is difficult to do anything more
sophisticated than touchong a virtual keyboard with my thumb hoping I won't
recently found the hp49g+ calculator that i bought about a decade ago and
discovered that it can work either in exact or approximate CAS modes, as
they describe them. And it still works!
On Wed, Jan 9, 2019 at 11:31 AM Fred Bone wrote:
> On Wednesday, January 9, 2019 at 9:44, David Carl
I believe you just have to live with it in release 2.6.21 or several other
releases below 3.3. You should be able to manually re save any particular
entry in decimal form if it is really bothering you, but why bother if it
does not appear that way in reports?
On Wed, Jan 9, 2019 at 9:52
Absolutely, I was not expecting agreement with the bank, I just think the
creation of an unbalanced transaction is bad form.
On Wed, Jan 9, 2019, 9:03 AM John Ralls
> > On Jan 9, 2019, at 6:26 AM, Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
I have created https://bugs.gnucash.org/show_bug.cgi?id=797032.
On Wed, Jan 9, 2019 at 2:29 AM David Carlson
> With those numbers payment number 2 has an error.
> David C
> On Wed, Jan 9, 2019 at 2:23 AM David Carlson
>> I am wor
With those numbers payment number 2 has an error.
On Wed, Jan 9, 2019 at 2:23 AM David Carlson
> I am working on a test scenario.The interest formula is ipmt( 0.03500 /
> 12.00 : i : 180.00 : 172,000.00 : 0 : 0 ), the others have the same numbers
> and the 71st payment
> > On Jan 8, 2019, at 5:46 PM, Christopher Lam
> > Well the SCM has numerous references to "round" and "rounding errors" so
> it's to be expected.
> > Please file a bug with example numbers, and hopefully these
> The thee functions are defined in
> prefixed with gnc: (so gnc:ipmt etc.).
> At line 41ff you'll see that ppmt = pmt - ipmt.
> John Ralls
> > On Jan 8, 2019,
. If ipmt were expressed as pmt-ppmt, there would be no imbalance,
but one of the other two ways to express all three may be less likely to
generate inaccurate results.
On Mon, Jan 7, 2019 at 10:19 PM John Ralls wrote:
> > On Jan 7, 2019, at 3:14 PM, David Carlson
y don’t know.
> I am using Windows 10, home.
> Thx Tom.
> *From:* David Carlson [mailto:firstname.lastname@example.org]
> *Sent:* Monday, January 7, 2019 3:01 PM
> *To:* Tom Murphy
> *Cc:* Gnucash Users
> *Subject:* Re: [GNC] ERROR MESSAGE - NO SUITAB
What version of GnuCash did you update from?
On Mon, Jan 7, 2019, 6:30 PM Tom Murphy I am using Windows 10 with the latest updates installed. In the
> instructions it says the file is saved automatically so I am using whatever
> the default is.
> -Original Message-
I wonder if GnuCash follows exactly the same rules for income and expense
accounts that it does for asset and liability accounts. I know that I
never bother with reconciling income or expense accounts.
On Mon, Jan 7, 2019 at 5:22 PM Liz wrote:
> On Sun, 6 Jan 2019 07:34:35 -0800
I just had a scheduled transaction that was set up by the loan/mortgage
repayment assistant appear with 0.01 Imbalance-USD.
I would think that GnuCash should have an accuracy method that would
prevent this from happening. Is this a bug?
I am using GnuCash 2.6.17 in Ubuntu 16.04 today.
That normally means that your data is in a database format but GnuCash does
not have the correct tools to open it. This can happen after an update.
Alas, I do not use a database format but I do know that there are
differences depending on which operating system you are using. Let us know
tried to paste into a spreadsheet the resulting cell structure was so
bad that it was impossible to clean up to get a decent print anyway.
On Sun, Jan 6, 2019, 9:55 AM Geert Janssens On Thursday, January 3, 2019 5:33:06 PM CET David Carlson wrote:
> > I was able to run a quick test
money this would mean also adding all those cash-in and cash-out
On Sat, Jan 5, 2019 at 5:29 AM D via gnucash-user
> I'd go further and say that, while it is possible to do as Maf says, it
> can be quite confusing to manage, especially
This is my initial advice to a new user:
First skim through the Help manual up to chapter 6
Then start GnuCash following the instructions in chapter 3 and create a
test file with a minimal set of accounts. You should consider it to be a
paste the data to a new libreoffice calc file I get
> only 'paste only' as an option under >edit, and nothing else recognisable
> from >insert.
> > I have tried 'insert sheet' under >insert but only get the option to
> insert before or after and then cannot copy
I had to paste this message into a different computer that is able send
G-Mail, so I hope I got all the good parts...
I was able to run a quick test using release 2.6.17 in Ubuntu 16.04 and
found that first, when I tried to save a P report in HTML format GnuCash
did not append a .html suffix. In
> > insert before or after and then cannot copy the 'new' sheet into an
> > existing one, if I add 'after'
> > There doesn't seem to be a method of cut and paste directly, afaics.
> > Thanks, Barry
> > On 02/01/2019 17:51,
You may need to first open a new blank spreadsheet then cut and paste from
the html document into the spreadsheet rather than trying to directly open
HTML with Calc.
My experience with LibreOffice Calc is that it will import several
different kinds of files. I use it regularly to
to skip all the effort to correctly account
for realized gains and losses and just forward your brokers' tax report to
That is my 2 cents...
On Wed, Jan 2, 2019 at 6:12 AM D via gnucash-user
> I can't test this right now, since I'm not at m
If you still have copies of your bank statements you can review the
register a nd compare the running balances to your statements to see if or
when the balances do not match. If there are a few outstanding items at
the end of a statement period they should account for any difference.
ign currency assets, it would be nice
> to have another way to collapse the individual stock accounts, but this
> solution will work for the time-being. A new challenge for another day.
> Thanks again!
> On Tuesday, January 1, 2019, 5:45:10 PM GMT-5, Dav
> Today's Topics:
> 1. Re: Adding an exchange to the list of exchanges (David T.)
> 2. Re: Tutorial for moving stock between accounts? (David Carlson)
> 3. Re: Tutorial for moving stock between accounts? (David Carlson)
> 4. Re: Tutorial for moving stock bet
purchase are just virtual transactions. This sort of situation might come
up in transfers of custodial assets in or out of trusts or other tax
On Mon, Dec 31, 2018 at 10:09 PM David Carlson
> I forgot to mention that if the value has chan
the pseudo-purchase transaction.
On Mon, Dec 31, 2018 at 10:00 PM David Carlson
> Now David Cousens, you are confusing me. If you are referring to
> re-writing the original purchase transaction to correct an error, and the
> cash that is also transferred in that tr
Now David Cousens, you are confusing me. If you are referring to
re-writing the original purchase transaction to correct an error, and the
cash that is also transferred in that transaction is also corrected to the
new brokerage account, then I agree with you.
If, however, this is a new
The thread GNCupdating advice seems to have answers that could apply to
Adding to both: In the release 2.6.xx family, a simple method to find the
last used data file is to start the File > Save as process and see where
GnuCash wants to put the new file. Then cancel before actually
Wow, that looks like a lot of progress has been made! Thanks to the
developers for their hard work!
On Sun, Dec 30, 2018 at 2:03 PM John Ralls wrote:
> The GnuCash development team announces GnuCash 3.4, the fifth release of
> the 3.x stable release series.
> Between 3.3
I would either enter a simple transaction from a/r to expense or use two
transactions , one from a/r to cash and one from cash to expense.
On Sun, Dec 30, 2018, 1:44 PM gn00b Someone owes me $100 (Accounts Receivable). But instead of paying me $100,
> they pay for an expense of mine
John requested that users report every detail of your actions leading up to
the problem and exactly which keystrokes do not work. So far the
developers cannot replicate the problem. A "Same here" comment does not
help with diagnosing the problem.
On Sun, Dec 30, 2018 at 2:09 AM
Once is enough with the duplicated messages. The previous responses by
John and Derek seemed to cover your concerns but since you are asking for
elaboration, I as an experienced user can answer your questions #1 & #2.
The QIF Import wizard in the GnuCash Releases 2.6.21 and earlier
I am a little bit behind, as I am still using release 2.6.x where x ranges
between 16 and 19 depending on which machine I have fired up, so I am still
looking at a file named saved-reports-2..4, but I think that it is not too
different from your file.
I think you are aware that the file
You could try using the Close Books function to create model transactions
then duplicate them to get copies that likely do not contain the odd dates.
On Fri, Dec 28, 2018, 1:37 PM Stan Brown > From: David Cousens
> > Subject: Re: [GNC] Basic Question (I hope) - End of Year
I am not sure if this will help. Check that the register sort order is set
to date posted. If that does not work please let us know which GnuCash
release you are using and your operating system.
On Mon, Dec 24, 2018, 4:49 AM Finbar Mahon Hello, this is not urgent, just so I don't
If all the transactions are in only one account, start your Edit > Find
>Number > Contains ... or Edit > Find > Number > Matches Regex ...
operation from that account register. If they are in several accounts,
start your Edit > Find >Number > Contains ... or Edit > Find > Number >
What thread are you responding to?
On Wed, Dec 19, 2018, 8:58 AM Elmar I gather this is only in version 3.x? Any hope for us still on version
> 2.6.12 ?
> - Elmar
> On 12/18/18 10:58 PM, gnucash-user-requ...@gnucash.org wrote:
> > In GnC, click on the Tools menu and then on
Michael, Try exporting the report to html.
On Wed, Dec 19, 2018 at 5:31 AM Michael Hendry
> Here is a screen-shot to demonstrate the problem:
> The report is readable, but inelegant.
a 'wildcard' type of accounts selection, it's a
> good entry-level idea for a budding scheme hacker :)
> On 19/12/18 5:42 am, David Carlson wrote:
> > On that subject, I would like to see a way to document the current
> > of a report, perhaps by including it as an a
On that subject, I would like to see a way to document the current settings
of a report, perhaps by including it as an appendix to the report
printout. Then I would like to see a way to export and import settings
from one data file to another.
On Tue, Dec 18, 2018 at 2:58 PM Adrien
By Check Register do you mean a list of transactions in one ban account?
To do that, open the Account window for that bank account, Click on View >
Filter By..., choose the date range that you want to print out, then choose
Reports > Account Report, and print it out. Note that you may see
> From: gnucash-user blueyonder.co...@gnucash.org> On Behalf Of Stephen M. Butler
> Sent: 10 December 2018 17:47
> To: email@example.com
> Subject: Re: [GNC] GNU crashes when any Report is selected
> On 12/10/18 4:46 AM, Stan Brown wrote:
> > Hi, Arni
hese have worked perfectly for
> 11 months.
> Best Regards
> *From:* John Ralls
> *Sent:* 10 December 2018 01:17
> *To:* Arnie Reeves
> *Cc:* David Carlson ; Gnucash Users <
> *Subject:* Re: [GNC] GNU crashes when a
ever I have the same excessive delay waiting for
> Reports to open. Do you have any thoughts to correct this please.
> Best Regards
> *From:* John Ralls
> *Sent:* 10 December 2018 14:26
> *To:* Arnie Reeves
> *Cc:* David Carl
gt; fine) and 3.3 etc. Which is best, and bug free, for my simple home accounts.
> > Arnie
> > From: karnd...@blueyonder.co.uk
> > Sent: 08 December 2018 21:37
> > To: David Carlson
> > Cc: Gnucash Users
> > Subject: Re: [GNC] GNU crashes when any Report is
> As far as I know, I only got one response... to double-click on the dark
> column line. Nothing happened with that.
> On Sat, Dec 8, 2018 at 3:57 PM David Carlson
>> Which of the three responses was the on
Which of the three responses was the only one you tried?
I personally think John Ralls' has the best chance of working, but as he
stated it is very tricky to get the mouse focus into precisely the right
If that fails there is another way that requires deleting a file that also
I did forget to mention that I use Gnucash mostly in Ubuntu 16.04 with
occasional forays into Windows 7 and rare forays into Windows 10.
On Sat, Dec 8, 2018, 3:21 PM David Carlson Arnie,
> Did you get a Windows update or have any other significant change to your
Did you get a Windows update or have any other significant change to your
Release 2.6.19 itself has not changed, and various 2.6.x releases are still
working for me.
On Sat, Dec 8, 2018, 12:10 PM Arnie Reeves via gnucash-user <
> I use
Just wondering, since there apparently is not a standardized trick to reset
all column widths in the view, would toggling between 1 line and double
line views or switching between basic ledger auto split ledger or
transaction journal views make any difference?
On Thu, Dec 6, 2018, 11:04
Another quirk to watch out for is whether Explorer was refreshed after the
last file was created.
On Tue, Dec 4, 2018 at 11:44 AM Adrien Monteleone <
> True. I forgot about that one. I use sqlite and indeed it is always
Windows does not show the file extensions in File Explorer unless you
change a setting in your Windows preferences. Most of the experienced
Windows users, A.K.A. 'Old Fogies' (like me) change that setting early on
and forget that some people may not be familiar with it.
I am away from my computer right now so I cannot confirm the exact wording,
but it s something like how often to make backups. I dont remember the
default. It may be only 5 minutes, I have it set to 30 minutes but I
religiously do manual saves before certain activities such as imports.
If, at some time in the past you modified that data file with that (short)
filename by going into Edit >Preferences > General and selecting 'Retain
log/backup files: Never, then no log or backup files will be generated.
You did not do that because you do see .log files being generated.
I think you need to ask your cloud about that. Gnucash doesn't do backups.
On Mon, Dec 3, 2018, 5:50 PM IanCarol - PC I am using cloud backup service to back up my Gnu data.
> I wish to be able to restore to a different PC. How can I do that?
> Ian Waterfield
I think that Windows calls them text files if once you opened one with
They are constructed with text characters, but they are not exactly human
On Mon, Dec 3, 2018, 1:39 PM Gareth Davies via gnucash-user <
> Thanks for the reply D,
I would like to see it implemented as a pop-up dialog asking the user if
(s)he would like to update the 'other side' to the same value if it is a
simple two line transaction. If the user closes the transaction without
responding yes the imbalance amount is entered.
ts to pdf and it will print. However, the result is a
> blank page. HB
> On 12/2/2018 9:00 AM, David Carlson wrote:
> That behavior is very similar to what you see when the output goes to the
> wrong printer.
> Have you tried things like printing to PDF or printing from a
he Pages area is blank. This indicates there are no pages to print
> - I think. If I then go ahead and click on print then the print icon shows
> up in the bottom tray. But it indicates there are no documents in the cue.
> It then goes away after a couple of minutes.
You can see how old this bug is, I am not sure if you can run IE9 in
windows 10. Perhaps someone knows if this work-around can be adapted to
On Sun, Dec 2, 2018 at 1:40 AM David Carlson
> I found the bug report. Check comment 40.
oblems. That may
> be my inability to search properly. So if anyone knows the fix that you are
> referring to I hope they will give me the location.
> Thanks for the help,
> On 12/1/2018 1:30 PM, David Carlson wrote:
> That looks identical to the same file on
hanks for the help,
> HB Sidman
> 703-938-6700 (O) 703-562-1953 (F)
> On 12/1/2018 11:46 AM, David Carlson wrote:
> I did not address the failure to print problem. That is probably not
> related to the .chk files but something else. Can you print r
I did not address the failure to print problem. That is probably not
related to the .chk files but something else. Can you print reorts?
On Sat, Dec 1, 2018 at 10:42 AM David Carlson
> Windows always calls *.chk files 'Recovered File Fragments'
Windows always calls *.chk files 'Recovered File Fragments'
If the files are in the 'C:\Program Files
(x86)\gnucash\share\gnucash\checks' directory they are not fragments but
the files that you want, at least for 2.6.x releases of GnuCash in
Windows. You can open them (carefully) with
Your subject line is misleading. I think you are having issues with
Actions > Online Actions > Get Transactions... Is that correct? It would
be helpful to know what version GnuCash you are running and your computer
On Wed, Nov 28, 2018 at 7:37 PM Hook wrote:
> I have 3 users
I just found a discussion about how it is applied in GnuCash:
I am not sure if it still applies to release 3.x.
On Wed, Nov 28, 2018 at 9:47 AM David Carlson
> If you are looking for a technically detailed answer, Gnu
If you are looking for a technically detailed answer, GnuCash uses a
technique called Bayesian matching which is well known in mathematical
circles. The success is very dependent on the details of implementation,
and GnuCash took steps toward improvement in the 3.x series by using a
The developers cannot guarantee anything. Many users have had good
results, but many of us needed to run tests with about a month's data at a
time mostly because Quicken allowed sloppy records that do not import very
well. If that is your situation you might be better served to manipulate
; based on what you've read.
> > >
> > > There are issues, but it's not like gnucash 3.x has suddenly become
> > > completely
> > > unusable.
> > >
> > > Regards,
> > >
> > > Geert
> > >
> > > Op zondag 25
You are not the only one that concerned about whether the new releases meet
your needs any better than what you used before. A bird in hand is
I am staying with my favorite 2.6.15 or 2.6.17 until I am satisfied that
3.4 or whatever is sufficiently well debugged to not present
Whenever there is more than one currency in a transaction GnuCash creates a
split to record the exchange between currencies, so there is a separate
split line for each currency. When a multi-currency transaction is
imported, there will be two split lines, not one. That is an artifact of
Sometimes, but not always, it can be useful to open the task manager and
look under processes to see if GnuCash is using a lot of CPU time. If it
is "frozen" it probably is using a lot of CPU time, but it also uses a lot
at other times too.
On Fri, Nov 23, 2018, 6:40 PM John
2018 às 01:14, David Carlson <
> firstname.lastname@example.org> escreveu:
>> While I am not addressing the issue you stated in your first post, I do
>> expect an import to consider existing multi-split transactions that match
>> the amount and ti
nto multi-line requires extensive extra
> processing because I have a ton of transactions.
> Em qui, 22 de nov de 2018 às 21:09, David Carlson <
> email@example.com> escreveu:
> > I have not used the new CSV importer, so I am not sure whether this
I have not used the new CSV importer, so I am not sure whether this comment
actually applies to your case...
If the new CSV importer is used similarly to the old CSV importer, there is
a step in the process to offer an opportunity to match the new transaction
to existing transactions if there are
I have been using GnuCash for many years and I am still using release
2.6.17 or similar depending on which computer I am using. I just noticed
that when I am importing a CSV transactions file and I get to the step to
determine which account to import the transactions into, the list of
There could be several problems, and you may need to do some research to
figure out which you are having and how to work around it.
First, are you able to open and mount the Veracrypt volume. You will need
to have the Veracrypt program installed and running and have your Veracrypt
key to succeed
€ capital losses
> I hope it is now easier to understand my initial question.
> El mié., 14 nov. 2018 a las 19:40, David Carlson (<
> firstname.lastname@example.org>) escribió:
>> If funds were used to buy a different security f
n't the lots
> functionality work for them? I believe that it uses FIFO exclusively...
> David T.
> On November 14, 2018, at 8:23 PM, David Carlson <
> email@example.com> wrote:
> I think that Christian is asking a slightly different question. I
I think that Christian is asking a slightly different question. I
interpret it that in one parent custodial mutual fund account he purchased
Fund A on dates 1, 2 and later then sold some or all of Fund A and bought
Fund B in the same custodial account on date 3.
Now I am not sure if he needs to
I do not need to file a bug report about a missing highlight since it is
only missing in release 2.6.17 and possibly other 2.6.x releases but not in
the current 3.3 release. However, judging by recent flurry of emails
regarding control over the new (to GnuCash) GTK-3 tools, it may not easy
I have recently observed that in release 2.6.17 of GnuCash the parent
account is not highlighted in the Edit Account window, at least when
account colors are used for some accounts.
Since release 2.6.17 is no longer supported by the developers, and, in
fact, the current release uses a completely
I think that editing the FITID of a transaction in the OFX file will also
trigger a 'new' import.
On Fri, Nov 9, 2018 at 10:38 AM Derek Atkins wrote:
> Changing the date on the transaction is not sufficient; GnuCash stores the
> unique FITID to match against the OFX file, so it will
I based the estimate to be massive on your comments that you said you lost
hundreds of transactions and it will take hours to reconstruct your lost
If you make a backup every 15 minutes, you should only lose 15 minutes work
Sun, Nov 4, 2018, 7:56 PM btrib 100
I believe the CSV importer in release 3.3 is greatly improved over the old
importer. However, being relatively new it probably has a few kinks
remaining to be worked out.
IT appears that you are trying to do a massive import from old files,
possibly without sufficient planning and
So because Liinux does not use a backslash, that is erroneous?
On Fri, Nov 2, 2018 at 11:15 PM Wm via gnucash-user <
> On 01/11/2018 09:27, Geert Janssens wrote:
> > Op woensdag 31 oktober 2018 17:09:27 CET schreef Wm via gnucash-user:
> >> On 31/10/2018 01:24, D
that is not a constructive comment.
On Fri, Nov 2, 2018 at 11:00 PM Wm wrote:
> On 01/11/2018 09:19, Colin Law wrote:
> > On Thu, 1 Nov 2018 at 08:23, Wm via gnucash-user
> > wrote:
> >> On 31/10/2018 01:24, D via gnucash-user wrote:
> >>> Check out
Look under File>Properties>Accounts and see if you have set a value for Day
Threshold for read only transactions. If so, either increase the number of
days or set it to zero to disable it.
Then you should be able to edit the transaction to assign an account to any
split line or even add
If I recall correctly QDF format is a proprietary and encrypted format
owned by Intuit. The only way to extarct the data is to use the Guicken
program to open the file and then export to QIF format. Hang on to Quicken
until you have experimented with importing the QIF files into GnuCash to be
If you think that link contains incorrect and misleading information, why
don't you contact the developers and help them correct it.
On Thu, Nov 1, 2018 at 3:22 AM Wm via gnucash-user
> On 31/10/2018 01:24, D via gnucash-user wrote:
> > Check out
I do not think it is possible to make a zero value transaction split line
actually show zeros.
Years ago I set up a special income account that I called 'zComments' [to
make it sort to the bottom] to use as a collector for transactions that
were there just as reminders. Since then, GnuCash now
> unions. Besides this one problem, I'm pretty happy at this one.
> On Mon, Oct 29, 2018, at 11:41 PM, David Carlson wrote:
> What do you mean by online banking.? Are you actually using the OFX
> If so, just do not use
What do you mean by online banking.? Are you actually using the OFX import?
If so, just do not use the option to update the transaction when matching.
Then Gnucash leaves the description unchanged.
On Mon, Oct 29, 2018, 7:49 PM John Ralls wrote:
> > On Oct 29, 2018, at 5:38 PM,
Obviously the solution to your problem is to move to Arizona!
On Mon, Oct 29, 2018 at 9:09 AM Colin Law wrote:
> I am seeing similar problems in the UK running 3.3 on Ubuntu 18.10, from
> Ubuntu repo.
> The issue occurs if one tries to enter 28/10/18 in the statement date,
> which is
eekend. What list are you talking about that
> I should "search?"
> On Sun, Oct 28, 2018 at 9:57 PM David Carlson
>> AlphaVantage stopped working for those of us with more than a few
>> securities several months ago when t
1 - 100 of 554 matches
Mail list logo