Re: [GNC] Misc Newbie Questions

[Adrien Monteleone]

> On May 28, 2019, at 8:48 PM, Peter088  wrote:
> 
> 
> 5) I get the reconciliation function, but every once in a while I make a 
> mistake while reconciling.  When I go back and correct the reconciled 
> transaction it changes the status to "n" and I'm unable to change it back 
> without either repeating the entire reconciliation process starting with 
> resetting the status of every transaction on the statement or having to 
> remember to roll it into the next month's statement.  These are both very 
> arduous.  There is no way around this?
> 
> Thanks,
> 
> Peter

Just re-reconcile that account as of the last statement date again. You’d only 
have the one transaction that needs to be checked off and then finish the 
process.

Clicking in the “R" field in a register can cycle it to ‘cleared’ (‘c’) so when 
you click the Reconcile button again, it is already checked off. Then just 
click the icon in the toolbar to finish it.

If you do this right away, you probably don’t even have to manually change any 
dates or amounts in the dialogs.

Otherwise, be sure to go ahead and clear the transaction anyway, so it is 
already checked off for the next formal reconcile chore, then you won’t have to 
remember to do anything with it. Its flag will just get changed to ‘y’ as it 
should.

Regards,
Adrien
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Misc Newbie Questions

[Peter088]

Thanks Adrien.

Regarding 2), I'm up to date on Windows 10 and have just upgraded to V3.5
I'll will try and isolate a repeatable instance.

3) Got it

5) I get the reconciliation function, but every once in a while I make a 
mistake while reconciling.  When I go back and correct the reconciled 
transaction it changes the status to "n" and I'm unable to change it back 
without either repeating the entire reconciliation process starting with 
resetting the status of every transaction on the statement or having to 
remember to roll it into the next month's statement.  These are both very 
arduous.  There is no way around this?

Thanks,

Peter

-Original Message-
From: gnucash-user 
[mailto:gnucash-user-bounces+peter088=petermacdonough@gnucash.org] On 
Behalf Of Adrien Monteleone
Sent: Wednesday, 29 May 2019 11:14 AM
To: gnucash-user
Subject: Re: [GNC] Misc Newbie Questions



> On May 28, 2019, at 7:04 PM, Peter088  wrote:
> 
> Hello,
> 
> 
> 
> I'm a recent convert from Quicken.  I apologize for dragging my expectations
> with me, but there are a few things I can't figure out how to do.  Perhaps
> these are not possible.  They are mostly small, so I thought I'd include
> them in one email instead of killing e-trees:
> 
> 
> 
> 1)  How can you enter a scheduled transaction before it's due date?
> (Used to check cash flow)

See the Help Manual and Guide. You can enter future transactions manually and 
run reports to include those future dates, or you can enter Scheduled 
Transactions which haven’t fired yet, and run a report to show you the effects 
as if they did.

> 
> 2)  Why don't backspace and delete work sometimes, even in the text
> fields?

They should. What version are you using and on what OS? There were some bugs in 
earlier 3.x releases, but they should have been fixed by 3.5, the current 
release.

> 
> 3)  What is my "working register?'  (This is what you close and open
> instead of closing and opening GNUCash to bump the internal calendar date)

There shouldn’t be a need to close and open anything to change the date. Just 
change the date. I leave GC open 24/7. While the next empty transaction’s date 
won’t change automatically, once you enter a current day’s transaction and 
change the date manually, the next empty transaction will default to the 
current system date.

If you like to leave GC open, but don’t want to ever be bothered with manually 
changing a date for a current-day transaction, just don’t leave a register open 
across midnight. When you open the register the next day, the default day in 
the empty transaction will be current.

But the ‘working register’ is whatever account register you have open at the 
time. So if you have your checking account register up, that is your ‘working 
register’. (you can have many open at once, but only the active tab is the 
‘working’ one.

> 
> 4)  How can you change the order of the items in a split?

You can type them in any order, but GC will default to re-ordering them as 
debits first. I don’t think there is a way around this. (the debits will stay 
in their as-entered order and credits in their order however)
> 
> 5)  Is there any way to mark a transaction as reconciled ("y") without
> going through the reconciliation process?

Nope. That’s the whole point. Reconciliation is not a per-transaction process, 
it is for a group of transactions against a set balance. (though I guess 
technically, any period could have only 1 transaction in it) You *can* mark an 
split as ‘cleared’ which means when you reconcile, it will be checked off for 
you by default.

Regards,
Adrien
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] To: GnuCash Documentation Team Re: Accounting Explanation Concept for GnuCash help file?

[David Cousens]

Hi Brian,

This the real application of the general accounting equation which is often
written in the form
Assets = Liabilities + Equity + (Income  - Expenses). Accounting students
usually have this drummed into them from lecture 1

If you rearrange it so there are no negative terms with assets on the left
hand side (LHS) then

Assets + Expenses = Liabilities + Equity + Income 

which is the same as the equation you have with the ,  then the accounts on
the LHS of the equal sign are known as debit balance accounts and those on
the RHS as credit balance accounts. 

Debits increase the balance of the debit balance accounts (LHS) and credits
decrease the balance.
Credits increase the balance of the credit balance accounts (RHS) and debits
increase the balance.

I have been meaning to add this to the explanantion in the Help manual for
some time to clarify it.  It is almost in there but not quite.  In modern
accounting practice I have never seen draws on equity referred to as a
separate class of accounts as they are a class of transactions reducing the
balance of the accounts.


David Cousens





-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Misc Newbie Questions

[Adrien Monteleone]

> On May 28, 2019, at 7:04 PM, Peter088  wrote:
> 
> Hello,
> 
> 
> 
> I'm a recent convert from Quicken.  I apologize for dragging my expectations
> with me, but there are a few things I can't figure out how to do.  Perhaps
> these are not possible.  They are mostly small, so I thought I'd include
> them in one email instead of killing e-trees:
> 
> 
> 
> 1)  How can you enter a scheduled transaction before it's due date?
> (Used to check cash flow)

See the Help Manual and Guide. You can enter future transactions manually and 
run reports to include those future dates, or you can enter Scheduled 
Transactions which haven’t fired yet, and run a report to show you the effects 
as if they did.

> 
> 2)  Why don't backspace and delete work sometimes, even in the text
> fields?

They should. What version are you using and on what OS? There were some bugs in 
earlier 3.x releases, but they should have been fixed by 3.5, the current 
release.

> 
> 3)  What is my "working register?'  (This is what you close and open
> instead of closing and opening GNUCash to bump the internal calendar date)

There shouldn’t be a need to close and open anything to change the date. Just 
change the date. I leave GC open 24/7. While the next empty transaction’s date 
won’t change automatically, once you enter a current day’s transaction and 
change the date manually, the next empty transaction will default to the 
current system date.

If you like to leave GC open, but don’t want to ever be bothered with manually 
changing a date for a current-day transaction, just don’t leave a register open 
across midnight. When you open the register the next day, the default day in 
the empty transaction will be current.

But the ‘working register’ is whatever account register you have open at the 
time. So if you have your checking account register up, that is your ‘working 
register’. (you can have many open at once, but only the active tab is the 
‘working’ one.

> 
> 4)  How can you change the order of the items in a split?

You can type them in any order, but GC will default to re-ordering them as 
debits first. I don’t think there is a way around this. (the debits will stay 
in their as-entered order and credits in their order however)
> 
> 5)  Is there any way to mark a transaction as reconciled ("y") without
> going through the reconciliation process?

Nope. That’s the whole point. Reconciliation is not a per-transaction process, 
it is for a group of transactions against a set balance. (though I guess 
technically, any period could have only 1 transaction in it) You *can* mark an 
split as ‘cleared’ which means when you reconcile, it will be checked off for 
you by default.

Regards,
Adrien
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] More Startup Questions

[Adrien Monteleone]

> On May 28, 2019, at 7:34 PM, Peter088  wrote:
> 
> Hi Everyone,
> 
> 
> 
> A few more intro questions:
> 
> 
> 
> 1)  I don't like the "softer" contrast in the new release.  Is there any
> way to change the look to the old one?

See the wiki about custom colors and such. You can create a custom CSS file 
where you can change some colors for the various parts of the app.

> 
> 2)  Is it true that to create custom reports, you have to be able to
> program?

‘Custom’ yes, you’ll need to be able to program in Scheme. But more than 
likely, the included reports can be ‘customized’ via built-in options to 
achieve what you are looking for, no need for programming.

What report specifically are you looking for and can’t seem to find?

> 
> 3)  Is it possible to create Quicken-like reports with variable
> reporting periods that can be changed on the fly or must the periods be
> hard-coded?

The default periods for many reports is ‘current accounting period’ so they’ll 
change automatically. But that is usually defined as 1 year in your 
preferences, not one month. You can of course use the options to set up monthly 
reports to ‘current month’ and save that configuration. If you run the reports 
in different months, you’ll get different numbers. Explore the various report 
options and play around with them. The date selectors can be exact or ‘fuzzy’ 
to current/last and then month/quarter/year.

> 
> 4)  Is there any way to export GNUCash data to a .QIF file?
> 

I think CSV is the only option. Though there may be a CSV to QIF converter 
somewhere on the web. However, Quicken should be able to import CSV also.

Regards,
Adrien
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Misc Newbie Questions

[Rich Shepard]

On Wed, 29 May 2019, Peter088 wrote:


I'm a recent convert from Quicken. I apologize for dragging my
expectations with me, but there are a few things I can't figure out how to
do. Perhaps these are not possible. They are mostly small, so I thought
I'd include them in one email instead of killing e-trees:


Peter,

Have you read the gnucash-help and gnucash-guide docs?

Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] More Startup Questions

[Peter088]

Hi Everyone,

 

A few more intro questions:

 

1)  I don't like the "softer" contrast in the new release.  Is there any
way to change the look to the old one?

2)  Is it true that to create custom reports, you have to be able to
program?

3)  Is it possible to create Quicken-like reports with variable
reporting periods that can be changed on the fly or must the periods be
hard-coded?

4)  Is there any way to export GNUCash data to a .QIF file?

 

Thanks,

 

Peter

 

 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Xcode project/buildable non X11 Mac version?

[Adrien Monteleone]

kentsor,

A screenshot of what you are seeing might be instructive.

If what you are seeing looks like win95, something is wrong.

To be sure, v2.x looked really dated, but v3.x fits in much better on MacOS. It 
still isn’t native, but certainly is not jarring. One could also use some 
custom CSS to theme and tweak the appearance quite a bit. There are some wiki 
pages to guide you and we have a few threads here on the list on specifics. 
(some of that info from those threads ended up on the wiki as well)

Regards,
Adrien

> On May 27, 2019, at 11:33 AM, kentsor  wrote:
> 
> Much as I'd like to use a QB alternative, as a Mac user I can not stand
> looking at GNUCash as it is now. The UI is staggeringly bad. The money I
> save is not worth using this.
> 
> There must have been attempts by other Mac people to replace the UI in the
> past. Most likely abandoned years ago so it'd be old versions but that's ok,
> my accounting needs are straightforward. Where can I go to download (dare I
> hope) an old Xcode project for an UI replacement for GNUCash ?

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] To: GnuCash Documentation Team Re: Accounting Explanation Concept for GnuCash help file?

[briancady413--- via gnucash-user]

Hi folks,
In puzzling over Debits increasing some accounts,  while Credits increase 
others, I stumbled over an explanation that I hope will help me and others 
trying to learn accounting better than by remembering DEADCLIC or DEALS/ GIRLS, 
etc.-
If one sets A = L & E equal to zero by subtracting A from both sides( 0 = 
-A + L + E )
Then the debit account has negative signs in front of them, and is the one 
debits increase.-
We can adapt this to the expanded equation (A = L + E + Revenues - Expenses - 
Draws), re-phrasing as:0 = - Assets - Expenses - Draws on equity                
                                         + Liabilities + Equity + Revenues,
On the left, Debit side are the debit accounts, increased by debiting, while on 
the right, Credit side are the credit accounts, increased by crediting!-
(Note: BeanCounter Dave Marshall's equation 'Property = Property rights' 
summation of 'Assets = Liabilities + Equities' really opened doors for me - 
thanks to him; I use it here.)-
We can rewrite Marshall's simplified equation, then under it, the expanded 
equation, like this:

0 = - Property   + Property 
Rights|___   - Draws   + 
Principal/Equity/Ownership  |  Owner's Line0 = - Assets 
  + Liabilities  |  Business 
Line
   - Expenses + Revenues/Income 
  |  Changes Line
|_0 =  - Debits   + 
Credits-|-
_So the debit accounts all are types of property, while the credit accounts are 
all types of property rights,and the debit accounts, on the left, are increased 
by debits, (Draws, Assets and Expenses)
while the credit accounts, on the right, are increased by crediting. 
(Principal, Liabilities, Income)-
Do you think that helps?

Brian
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Trace file curiosity

[John Ralls]

> On May 28, 2019, at 9:42 AM, Greg Feneis  wrote:
> 
> Hi Folks,
> 
> I'm running 2.6.21 and took a look at recent trace files just out of
> curiosity.  They all say various things, but practically all have this one
> note in common:
> 
> * 20:33:21  WARN  Could not spawn perl: Failed to execute
> child process (No such file or directory)
> 
> Does anyone know what causes this?  I'm not having a problem or anything,
> just curious what's going on.

It's GnuCash looking for perl to see if it should enable online quotes, utterly 
routine. The message should probably be reduced to an INFO.

Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing investment info from Financial Planner's

[Joseph Hymel via gnucash-user]

Thanks for the information. I will try your suggestions. Thanks again.

Sent from Yahoo Mail on Android 
 
  On Tue, May 28, 2019 at 8:31 AM, csingley wrote:   Just 
to summarize what people are telling you:

GnuCash doesn't have any sort of functionality to automatically create
accounts for an investment the first time it's seen, if that's what you're
after.  You will need to manually set up your accounts with beginning
balances.  It's not that bad, unless your RIA is way off the deep end on the
"zillions of ETFs" gameplan.

Having done that, you can import investment transactions into GnuCash. 
GnuCash hasn't implemented direct web connection for investment
transactions, so you'll need to save the transactions to a local file, then
use File -> Import -> Import OFX/QFX inside GnuCash to import the saved file
and map it to your account structure.

Your advisor's website probably has a facility for downloading OFX/QFX data. 
If not, it looks like Ameriprise has a publicly-available OFX server; you
should be able to download the data.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Trace file curiosity

[Greg Feneis]

Hi Folks,

I'm running 2.6.21 and took a look at recent trace files just out of
curiosity.  They all say various things, but practically all have this one
note in common:

* 20:33:21  WARN  Could not spawn perl: Failed to execute
child process (No such file or directory)

Does anyone know what causes this?  I'm not having a problem or anything,
just curious what's going on.

Thanks.




Kind regards,

Greg Feneis
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] ofxtools - a Python OFX library

[csingley]

John Ralls-2 wrote
> 
> Thanks.
> 
> A couple of things you might be interested in: We use AQBanking for OFX
> Direct Connect imports, but if you import an OFX or QFX file we use
> https://github.com/libofx/libofx.
> 
> The other is that there's a more up-to-date database of OFX Direct-Connect
> supporting institutions at https://ofxhome.com. AQBanking retrieves its
> connection parameters from there.
> 
> Regards,
> John Ralls
> ___
> gnucash-user mailing list

> gnucash-user@

> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

libofx is great, and certainly much faster than my parser.  On the other
hand, ofxtools can generate arbitrary OFX, and I believe covers
significantly more of the spec.  Different tasks, different tools.

OFX Home is where I pulled down the FI data for ofxtools (I've been talking
to Jesse about it - he provides a great service).  I walked through every FI
he's got, recording connection parameters that resulted in receiving an OFX
profile response.  Some of them have odd formatting requirements, like SGML
must not have closing tags on leaf elements, or XML must have newlines
inserted between tags.  This database is included in ofxtools, and is the
part I imagine would be most immediately useful to GnuCash users very
easy to configure OFX downloads, with settings that can be transferred to
GnuCash.   It would be great if some of this information were published
through the OFX Home API.

One of these days I'm going to set up wireshark and capture an updated list
of URL/FI/ORG parameters for OFX servers that Quicken knows about...



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] ofxtools - a Python OFX library

[John Ralls]

> On May 28, 2019, at 7:10 AM, csingley  wrote:
> 
> Some of you might be interested in a project I've been working on:
> 
> https://pypi.org/project/ofxtools/
> 
> This originally started almost 10 years ago when I asked Jeremy Jongsma if
> he minded if I reworked his ofx.py script (he didn't).  One thing led to
> another, and I ended up implementing a superset of libofx in Python (as you
> do).  It's grown into a sort of a Swiss army knife for dealing with OFX
> data.
> 
> Y'all are all hooked up with AqBanking, so I suppose you don't have much
> need of the meat of the library.  However I have recently been beefing up
> the client utility, which might be of interest to those trying to set up
> connections to download OFX data.  It contains a listing of every FI from
> the old MS Money database that's still online, along with working connection
> parameters (URL, OFX version, ORG, FID, BROKERID, along with oddball markup
> formatting requirements for FIs like Vanguard).  You can use this to set up
> AqBanking direct connect, or download the data directly.
> 
> ofxtools can generate OFX, so it's pretty handy for writing conversion
> utilities from other formats into OFX so the data can be imported.  It can
> also edit OFX data, so it can be helpful in standardizing the bizarre
> variety of protocol implementation quirks seen at various FIs.  Working in
> Python makes it pretty easy to develop something that works.
> 
> I hope an announcement on this list isn't in poor taste - it's certainly no
> kind of commercial solicitation.  I just hope to make it easier for users of
> free software to get access to their financial data, and for developers to
> work with it.  Feedback is welcome.
> 
> Cheers, and thanks to the GnuCash developers for continuing to produce great
> software.
> 

Thanks.

A couple of things you might be interested in: We use AQBanking for OFX Direct 
Connect imports, but if you import an OFX or QFX file we use 
https://github.com/libofx/libofx.

The other is that there's a more up-to-date database of OFX Direct-Connect 
supporting institutions at https://ofxhome.com. AQBanking retrieves its 
connection parameters from there.

Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Fwd: Impossible to generate reports.

[Geert Janssens]

Other things to look for:
What do you get if you export the report (even though it's blank in GnuCash) ? 
Does the exported file actually contain html you can open in Chrome or Firefox 
?
Are there message in the trace file [1] after you tried to open the report ?

Geert

[1] http://wiki.gnucash.org/wiki/Tracefile

Op dinsdag 28 mei 2019 16:49:59 CEST schreef Derek Atkins:
> Hi,
> 
> cag...@free.fr writes:
> > For me it's not a "new instal".
> > 
> > I have been using Win10 for a couple of years and generated many
> > reports during that time. I don't know what blocked me all of a
> > sudden.
> 
> I am afraid I have no other suggestions.
> I don't actually use Windows.
> Maybe someone else can help?
> Sorry,
> 
> -derek




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Fwd: Impossible to generate reports.

[Geert Janssens]

- And overzealeous anti-virus program perhaps ? Try disabling it temporarily.
- Have you tried running gnucash as a different (windows) user to rule out 
user specific issues ?

As Derek I'm not using Windows, so I can only offer generic suggestions.

Geert

Op dinsdag 28 mei 2019 16:49:59 CEST schreef Derek Atkins:
> Hi,
> 
> cag...@free.fr writes:
> > For me it's not a "new instal".
> > 
> > I have been using Win10 for a couple of years and generated many
> > reports during that time. I don't know what blocked me all of a
> > sudden.
> 
> I am afraid I have no other suggestions.
> I don't actually use Windows.
> Maybe someone else can help?
> Sorry,
> 
> -derek




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Fwd: Impossible to generate reports.

[Derek Atkins]

Hi,

cag...@free.fr writes:

> For me it's not a "new instal". 
>
> I have been using Win10 for a couple of years and generated many
> reports during that time. I don't know what blocked me all of a
> sudden.

I am afraid I have no other suggestions.
I don't actually use Windows.
Maybe someone else can help?
Sorry,

-derek
-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] ofxtools - a Python OFX library

[csingley]

Some of you might be interested in a project I've been working on:

https://pypi.org/project/ofxtools/

This originally started almost 10 years ago when I asked Jeremy Jongsma if
he minded if I reworked his ofx.py script (he didn't).  One thing led to
another, and I ended up implementing a superset of libofx in Python (as you
do).  It's grown into a sort of a Swiss army knife for dealing with OFX
data.

Y'all are all hooked up with AqBanking, so I suppose you don't have much
need of the meat of the library.  However I have recently been beefing up
the client utility, which might be of interest to those trying to set up
connections to download OFX data.  It contains a listing of every FI from
the old MS Money database that's still online, along with working connection
parameters (URL, OFX version, ORG, FID, BROKERID, along with oddball markup
formatting requirements for FIs like Vanguard).  You can use this to set up
AqBanking direct connect, or download the data directly.

ofxtools can generate OFX, so it's pretty handy for writing conversion
utilities from other formats into OFX so the data can be imported.  It can
also edit OFX data, so it can be helpful in standardizing the bizarre
variety of protocol implementation quirks seen at various FIs.  Working in
Python makes it pretty easy to develop something that works.

I hope an announcement on this list isn't in poor taste - it's certainly no
kind of commercial solicitation.  I just hope to make it easier for users of
free software to get access to their financial data, and for developers to
work with it.  Feedback is welcome.

Cheers, and thanks to the GnuCash developers for continuing to produce great
software.




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Importing investment info from Financial Planner's website

[csingley]

Just to summarize what people are telling you:

GnuCash doesn't have any sort of functionality to automatically create
accounts for an investment the first time it's seen, if that's what you're
after.  You will need to manually set up your accounts with beginning
balances.  It's not that bad, unless your RIA is way off the deep end on the
"zillions of ETFs" gameplan.

Having done that, you can import investment transactions into GnuCash. 
GnuCash hasn't implemented direct web connection for investment
transactions, so you'll need to save the transactions to a local file, then
use File -> Import -> Import OFX/QFX inside GnuCash to import the saved file
and map it to your account structure.

Your advisor's website probably has a facility for downloading OFX/QFX data. 
If not, it looks like Ameriprise has a publicly-available OFX server; you
should be able to download the data.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Post Invoice offers only the wrong currency's A/Receivable account?

[Jim DeLaHunt]

Thank you, Derek. This fixed my problem.

I had created a new Customer entry to match my new Customer. The 
Customer had Billing Information - Currency  defaulting to CAD (Canadian 
Dollars), the default currency in my book.  When I assigned that 
Customer to my new invoice, the invoice currency became CAD. Thus 
GnuCash only offered to post to my CAD A/Receivable account, instead of 
the correct USD.


The fix was, as Derek said, to edit the customer and set Billing 
Information - Currency explicitly to the correct currency (USD), then 
from the invoice select the Customer again, and then Post the invoice. 
It now posted to the correct USD A/Receivable account.


The following aspects of GnuCash contributed to this problem for me. 
I'll list them as notes for future improvements.


1. In GnuCash 3.4 on Mac OS, the Customer dialogue has three tabs:
   Customer, Billing Information, and Shipping Address. It is easy to
   overlook the Billing Information tab, and never see the Currency
   field in there. When the customer should have a different Currency
   than the book's default, you lose.
2. In the Edit Invoice UI, I do not see the Invoice currency displayed.
   It's value is only implicitly visible  by which A/Receivable account
   GnuCash chooses.
3. The documentation on Invoices, especially the Post section
   
,
   does not seem to mention invoice currency, and what to do if GnuCash
   is presenting a different currency's A/Receivable account than what
   you intend.
4. The documentation on Customers, especially the New section
   
,
   does mention the affect of Customer currency on invoices: "All
   invoices will be denominated in [Customer] currency and GnuCash will
   require an Accounts Receivable account in this currency." However,
   this is not an obvious section to read when investigating an invoice
   posting problem.

I have now posted my invoice, in the desired currency. Thank you for the 
help.


Best regards,
    —Jim DeLaHunt, Vancouver, Canada

On 2019-05-27 20:10, Derek Atkins wrote:
The invoice currency is obtained from the customer currency when the 
invoice customer is selected. If that changed after the invoice was 
created then the invoice didn't get updated. In that case you need to 
Edit Invoice and reselect the customer.


-derek
Sent using my mobile device. Please excuse any typos.
On May 27, 2019 10:38:28 PM Jim DeLaHunt  wrote:


Hello, fellow GnuCash users:

I am having difficulty with my first invoice for a new customer. My book
has business accounts, including A/Receivable accounts, in two
currencies: USD and CAD (US and Canadian dollars). I have been
generating USD invoices in recent months, and CAD invoices before that.
Today I tried to generate a new USD invoice for a new customer. I can
generate the invoice. It has a single item, which links to a USD sales
income account.

When I try to post the invoice, the only posting account which GnuCash
offers me is the CAD A/Receivable account. The pull-down menu does not
show either of my two USD A/Receivable accounts.

When I try to manually type in the USD A/Receivable account I want to
use, GnuCash offers a currency conversion dialogue.

So, I guess that somewhere GnuCash got the idea that this invoice is in
CAD, but the only item it lists is in USD.

How can I post this invoice to a USD A/Receivable account?

I am using GnuCash Version: 3.4, Build ID: 3.4+ (2018-12-30) on Mac OS
10.11.6.

Thanks in advance for any advice.

--
    --Jim DeLaHunt, j...@jdlh.com http://blog.jdlh.com/ 
(http://jdlh.com/)

  multilingual websites consultant

  355-1027 Davie St, Vancouver BC V6E 4L2, Canada
 Canada mobile +1-604-376-8953

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.





--
--Jim DeLaHunt, j...@jdlh.com http://blog.jdlh.com/ (http://jdlh.com/)
  multilingual websites consultant

  355-1027 Davie St, Vancouver BC V6E 4L2, Canada
 Canada mobile +1-604-376-8953

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.