With all due respect, most of the issues raised by Peter are covered in some
way in section 2.9.4 of the Guide, especially in the notes and warnings
embedded there.
A deeper exploration of the different methods a user can implement to recover
from some of these more challenging situations
Generally, I find that transactions ONLY get dereconciled due to an action I
have taken-- like changing some element of said transaction. They don't just
"get unreconciled"-- at least, not for me.
There was a short period of time where the app was very strict about when a
transaction was
And if your currency is using character strings ("USD", "CHF", etc.), you can
customize the currency designator so that Excel can process them.
David T.
On May 19, 2024, 8:50 PM, at 8:50 PM, "Stan Brown (using GC 4.14)"
wrote:
>On 2024-05-19 09:39, David Long wrote:
>> When I copy data
Further to the point, I've used Google Sheets financial functions to retrieve
stock prices pretty quickly. Those functions can pull prices for any given
date, so you could set some dates and import them that way. It's not ideal, but
it could get things done in a pinch.
David T.
On May 10,
Of course there is. The csv importer can handle any price data, including
historical data, as long as you supply the proper dates along with the other
data elements.
The challenge is gathering that price data in the first place. It used to be
possible to retrieve unlimited price quotes from a
My 4.12 copy on my older Windows 10 laptop has had significant delays (2-4
secs) for a couple of years now. I've chalked it up to my particular hardware
configuration.
David T.
On May 1, 2024, 8:28 AM, at 8:28 AM, David Carlson
wrote:
>The delay is much shorter in very recent releases
For your example, I simply use a report that subtotals by description. One
account (Expenses:Charity). Each transaction uses the charity name for the
description. Report Subtotal set to use Description. Report tells me each
charity and its annual total. Easy.
As for why this hadn't been
That's a known issue that is being worked on.
David T.
On Apr 27, 2024, 8:23 AM, at 8:23 AM, coolnodje wrote:
>Hi,
>
>QIF imports is failing in 5.6.
>I had to revert to 5.5 to be able to be able ro import as usual.
>
>The error message is "Missing QIF investment action for transaction
While I am uncomfortable with Jim's overall tone, he makes valid points to
consider.
Also, https://code.gnucash.org/builds/win32/releases/gnucash-5.6-1.setup.exe
was pushed out a couple of weeks ago and announced as a fix to an import
problem, I believe. I admit I don't pay too much attention
David,
My goal in the example was not pedagogical; it was to give others in the
community information that they might use for themselves. I'm pretty sure that
in the earlier thread, I gave all the information necessary (including actual
cell formulae) for others to test it for themselves. If
vert them to semi-colon separated files
>through LibreOffice Calc, and then it works.
>
>/Jacob
>
>On 2024-04-11 17:16, sunfish62--- via gnucash-user wrote:
>
>> In the past, I have used a Google sheet that captured all my stock
>> prices in one fell swoop, using Google'
Several years back, I sent this in to the list:
https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079430.html
Pretty sure it still works.
David T.
On Apr 12, 2024, 10:02 PM, at 10:02 PM, "David G. Pickett via gnucash-user"
wrote:
>Not all users know that the nice table of your
In the past, I have used a Google sheet that captured all my stock prices in
one fell swoop, using Google's financial functions and a pasted copy of the
Advanced Portfolio report. I put the AP in one tab, and retrieve all quotes
using references in a second tab. Save the sheet as CSV, which can
Again, nothing that I'm no expert:
It seems to me that your solution has four splits, while mine has... four
splits.
Depending on the actual event, either could be valid. For example, a conversion
between accounts at a single brokerage might look like your example, while one
from one
Phyllis,
I have many questions about this issue.
1. Are you importing the transactions with all their splits defined, and splits
within those imported transactions are not actually getting in to the GnuCash
data file?
2. Are you importing a record from another account (for instance, your
That's not always the case. Some brokerages (Schwab, for example) pull the
money into an account directly, from which shares are purchased at some later
date. It's essentially a cash based asset account, but it doesn't appear
separately to the user.
One way to handle this is to place these
I am not really knowledgeable in this area (or many other areas, to be honest),
but I found the following discussion (in a Quicken forum) that might lead you
towards an answer:
Upgrading is usually pretty straightforward, but it differs depending on your
OS and platform. For example, on Windows, the new version uninstalls the
earlier version, regardless. On Mac, you drag the new version into Applications
(but you can keep earlier versions with simple renaming). On
In recent years, I've been using GnuCash on Windows machines, and the idea of
environment variables is foreign, so providing that option is, perhaps, less
than ideal.
Although the developers of GnuCash dislike it, I wonder whether it would be
possible to have a user-visible setting for the
The update process depends on your operating system. But keep in mind that
GnuCash is only up to 5.5 (soon to be 5.6).
David T.
On Mar 27, 2024, 4:35 AM, at 4:35 AM, Nathan Rosenthal
wrote:
>I am currently running version 4.12 for two different organizations.
>
>If I was to update to 5.12
Weekly, every 4 weeks
David T.
On Mar 23, 2024, 8:45 AM, at 8:45 AM, David Jordan
wrote:
>Hello,
>
>
>
>I am trying to schedule a Deposit transaction that is paid every 4
>weeks
>(i.e. 13 times per year) but unlike Quicken GNUCash doesn't seem to
>allow a
>scheduled transaction that happens
I'll note that because GnuCash keeps a running really of the amount needed to
balance the transaction, users adding a new line to that transaction can get
confusing results.
For example, a user adds a new transaction for a grocery store and places a
left column entry for $35 assigned to
So,
If you think it's theme related; naming the theme might help. Also, to me, the
theme you choose is beyond the GnuCash scope.
And you don't explicitly say, but it appears you're running GnuCash 5.5 on
Fedora 39, based on the package name.
As I happen to have Fedora 39 running here, I
Or save the report to HTML, open in a browser, and print.
David T.
On Mar 1, 2024, 6:46 PM, at 6:46 PM, Murugan Muruganandam
wrote:
>you can alter the bottom margins from file->page setup.
>
>you may have to do couple of trials to get it correct. again each
>report you may have different
Sure. Is that short enough for you?
David T.
On Feb 8, 2024, 8:17 AM, at 8:17 AM, Fred Bone wrote:
>On 07 February 2024 at 22:17, sunfis...@yahoo.com said:
>
>> Agreed.
>>
>> David T.
>
>followed by 15k of someone else's message including quotes about six
>levels deep featuring the
Agreed.
David T.
On Feb 7, 2024, 10:02 PM, at 10:02 PM, Patrick James
wrote:
>After suggesting that the manual was read, and that "the double entry
>is understood," at some point the best answer becomes "it's time to
>hire an accountant."
>
>> On 02
Your register shows transactions. They add up to zero (as I and others have
noted) and so don't show in the Chart of Accounts.
RTFM
David T.
On Feb 7, 2024, 9:40 PM, at 9:40 PM, accounting Billing
wrote:
>I think this is a technical difficulty. Because none of the
>transactions
>are
You keep entering the second entry in your transaction **into the same account
you're in. **
Think of it this way, you take $20 out of your right pocket, and then put $20
into your right pocket. Assuming your right pocket started with $20, how much
is left after this transaction? ($20)
Also, you need to read the manual to understand double entry accounting and its
implementation in GnuCash. (Stephen's previous reply to your question about
Equity applies here as well.)
And GnuCash list etiquette.
David T.
On Feb 7, 2024, 5:27 PM, at 5:27 PM, accounting Billing
wrote:
Still nope on the screenshot. Images must be attached, not inline.
David T.
On Feb 3, 2024, 10:14 PM, at 10:14 PM, Dan O'Brien wrote:
>(With screen shot attached this time).
>
>I can’t make heads or tails of scheme code, so I’m not sure where to
>even look for the issue here.
>
>I’m using
Personally, I'd export the data I wanted (from a report, say) to a spreadsheet.
David T.
On Feb 3, 2024, 7:09 PM, at 7:09 PM, Phyllis Bruce wrote:
>藍藍藍
>
>
>> On Feb 3, 2024, at 9:53 AM, G R Hewitt wrote:
>>
>> 'Visualise' is the horizontal wavy line that hovers in your field of
>>
https://wiki.gnucash.org/wiki/Closing_Books
Does that cover it?
David T.
On Jan 13, 2024, 4:25 PM, at 4:25 PM, Adrien Monteleone
wrote:
>You could add A2b:
>
>Export your Chart of Accounts and write down the ending balances as
>needed. Start a new file, import your exported chart of
For the record, the US tax features in GnuCash function by assigning accounts
to specific tax lines, much like your approach.
It's helpful insofar as it guides your accounting decisions (what types of
entries I need to track for tax purposes, etc.), but it doesn't make your
decisions for you.
The problem with that Wikipedia article is that it focuses solely on Quicken,
but the QIF format has essentially become an open format that other
applications use (and implement).
Since that article doesn't mention the designation of bracketed accounts as
fitting in any particular category, it
Yes. These topics are all covered in the documentation and the wiki.
David T.
On Jan 7, 2024, 4:50 AM, at 4:50 AM, barry milliken
wrote:
>I've been frustrated using Quicken for years. Maybe GNUcash will do
>what I want.
>
>My list of functions is small:
>I use Quicken for personal
Changing the description won't change the reconciled status of a transaction in
most versions of GnuCash.
There was a period of time when any edits of a reconciled transaction would
cause everything associated with the transaction to de-reconcile, but maybe
you're not using one of those
Further to these answers, you could simply select the June statement, enter
that closing balance listed when prompted, and start by selecting everything
prior to that month's statement. Then continue reconciling June as normal.
If the closing balance in GnuCash matches the statement balance
That's a known bug that's been fixed. The fix will appear in the next release.
David T.
On Nov 11, 2023, 9:29 PM, at 9:29 PM, Ruaraidh Sackville Hamilton
wrote:
>I've just upgraded from 4.14 to 5.4 on Windows 11 and have noticed that
>the
>latest log file now remains open and locked even
While the generic subject line of this thread could cover practically any
subject (and seemingly has), I'd like to recommend that users get in the habit
of creating new threads for new topics.
David T.
On Oct 25, 2023, 8:23 PM, at 8:23 PM, Fred Tydeman
wrote:
>At top left of screen, click
Doesn't Chapter 2.1 Accounting Concepts cover exactly this?
David T.
On Oct 22, 2023, 11:46 PM, at 11:46 PM, David Cousens
wrote:
>Adrien,
>
>This needs to make it into the Basics section of the Guide. I am
>planning to
>revise it when I get a break from grandchildren and other activities
FWIW, Jeff reported his problem in 2014, and was happy when Derek advised him
to enter the number of shares and the total dollar amount of the transaction,
leaving the price to be calculated. I'm not sure whose problem is being solved
by this drawn out discussion.
David T.
On Oct 8, 2023,
Hi,
You don't quite say what exactly you're doing that isn't working, but does this
help?
https://www.gnucash.org/docs/v5/C/gnucash-guide/basics-running-gnucash.html#basics-register2
David T.
On Oct 8, 2023, 10:52 AM, at 10:52 AM, Veli Izzet wrote:
>Hi,
>
>I am using 5.4-1 on W11.
>
>I
Hi,
Welcome to GnuCash!
You can add columns to the Chart of Accounts by clicking the triangle at the
upper right corner of the accounts page.
David T.
On Oct 8, 2023, 10:41 AM, at 10:41 AM, Jose Fuenzalida
wrote:
>Hi , my name is Jose and I stared using Gnucash about a month ago and I
I'll refer you to a process I sent in to the lists a while back.
https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079430.html
David T.
On Sep 30, 2023, 1:38 AM, at 1:38 AM, flywire wrote:
>I'll work with the Price Import Assistant druid. Is it actually
>documented?
>I found
Since GnuCash bases its currency lists on the ISO standard, presumably a
specific enhancement request for this to be added would be unnecessary, and
patience will see the desired result?
David T.
On Sep 15, 2023, 2:26 AM, at 2:26 AM, Murugan Muruganandam
wrote:
>please raise a
ow whose experience is more true.
>>
>> David T.
>> On Sep 14, 2023, at 8:20 PM, john wrote:
>>
>>
>> On Sep 13, 2023, at 21:01, sunfish62--- via gnucash-user
> wrote:
>>
>> Hello,
>>
>> In another thread, it was noted that the la
plete data set based on existing
data. Others have said that this isn't the case, though.
So, I don't know whose experience is more true.
David T.
On Sep 14, 2023, 8:20 PM, at 8:20 PM, john wrote:
>
>
>> On Sep 13, 2023, at 21:01, sunfish62--- via gnucash-user
> wrote:
>>
Hello,
In another thread, it was noted that the latest version of auto complete in
version 5 of GnuCash restarts the auto completion data store. That gave me
pause, as I make use of the feature extensively to speed the entry of
transactions for a large number of stocks and mutual funds. (I
Others will correct me, but my understanding is that the log files are not used
with the database backend, since the changes are committed immediately.
David T.
On Sep 11, 2023, 9:03 AM, at 9:03 AM, Jediator
wrote:
>Hi GC users, I am using GC (version 5.3) on Mac. I noticed that the
>log
Or you could use the Asset Barchart or Liability Barchart report. Ticking the
Show table option has the added benefit of displaying the figures for each
account included.
David T.
On Sep 7, 2023, 5:19 AM, at 5:19 AM, Alan Hopkins wrote:
> Hello Tom
> It's fairly straightforward, if I
ISTR many years back encountering this discrepancy (that is, GnuCash saying it
was deleting transactions only to find them still there after).
I chalked it up to GnuCash being GnuCash, and decided that deleting accounts
with transactions in them was more confusing than stepping through an
Ok. This comes up from time to time. Others may chime in with additional
pointers, but here's how I'd go about it.
1) I would change the date of the Opening Balance transaction to the day before
your starting date (December 31, 2017 for example), and change the amounts of
both lines in this
Paul,
I don't use the cut and paste transaction feature. If I want to move a
transaction, I will change the account assignment for that split, which
effectively moves the transaction from one register to another.
I would wonder at the utility of cut and paste in this example. A
transaction
53 matches
Mail list logo
