Re: How to get rid of "Could not determine the account currency. Using the default currency provided by your system."

[Paul Neuwirth]

On Thu, 4 Jan 2018 06:05:02 +0100
Paul Neuwirth  wrote:

> On Wed, 03 Jan 2018 13:45:46 -0500
> Derek Atkins  wrote:
> 
> > Hi,
> > 
> > Paul Neuwirth  writes:
> >   
> > > Hello,
> > > I always get "Could not determine the account currency. Using the
> > > default currency provided by your system." when opening an account
> > > since upgrade to 2.6.19.
> > > according to SQL 
> > > SELECT * FROM gnucash.accounts a left join gnucash.commodities c
> > > on c.guid = a.commodity_guid;
> > > all accounts have a currency set.
> > >
> > > Book Option "Use Trading Accounts" is off
> > > Preferences Accounts, Default Currency is set (choose: EUR)
> > >
> > > what am I missing?
> > 
> > What type of account is it?
> > Specifically, is it a stock/mutual fund account?
> > If so, is it a top-level account?
> > 
> > Stock/Mutual accounts need to be children of an Asset with a
> > currency.  
> 
> Thank you.
> it was any account, any type and everywhere was Euro (EUR) set (not
> changable in dialog).. I saw in the mysql table commodities, EUR
> defined twice. when I imported transactions duplicate accounts where
> made with the "other EUR currency". I replaced old commodity-guids in
> all tables by the new guid..
> 
> update gnucash.transactions set
> currency_guid='2e2395017967d7799120dc8585cf4080' where currency_guid =
> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.accounts set
> commodity_guid='2e2395017967d7799120dc8585cf4080' where commodity_guid
> = 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.customers set
> currency='2e2395017967d7799120dc8585cf4080' where currency =
> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.invoices set
> currency='2e2395017967d7799120dc8585cf4080' where currency =
> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.prices set
> currency_guid='2e2395017967d7799120dc8585cf4080' where currency_guid =
> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.prices set
> commodity_guid='2e2395017967d7799120dc8585cf4080' where commodity_guid
> = 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.vendors set
> currency='2e2395017967d7799120dc8585cf4080' where currency =
> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; 
> 
> and deleted the old EUR currency... 
> now everything is fine.. 
> 
Now I have the same issue with all foreign currency accounts...

Execute:
> SELECT * FROM gnucash.commodities

+ - + -- + - + - + -- + 
- + --- + - + - +
| guid  | namespace  | mnemonic  | fullname  | cusip  | 
fraction  | quote_flag  | quote_source  | quote_tz  |
+ - + -- + - + - + -- + 
- + --- + - + - +
| 090f9175bf272d914fc77cf8990ddde8 | CURRENCY   | USD   | US-Dollar 
| 840| 100   | 1   | currency  |
   |
| 1669bedf79e858ba5ec3358346eee9b1 | CURRENCY   | ZWL   | 
Simbabwe-Dollar | 716| 100   | 0   | currency   
   |   |
| 2d24b3b5c4ac803f1ef048f43801905c | CURRENCY   | GBP   | Pfund 
Sterling | 826| 100   | 1   | currency  |   
|
| 2e2395017967d7799120dc8585cf4080 | CURRENCY   | EUR   | Euro  
| 978| 100   | 1   | currency  |
   |
| 4636ac6477efed452967bdb61c4a46ff | CURRENCY   | PLN   | Zloty 
| 985| 100   | 1   | currency  |
   |
| aad29cfc8037ac37b0a30fb16fad538a | template   | template  | template  
| template   | 1 | 0   |   |
   |
| bc7184bbbdac77765e615d7a3e2547d3 | CURRENCY   | USD   | US-Dollar 
| 840| 100   | 1   | currency  |
   |
| NULL  | NULL   | NULL  | NULL  | NULL   | 
NULL  | NULL| NULL  | NULL  |
+ - + -- + - + - + -- + 
- + --- + - + - + 8 rows

what is bad at first entry for USD (old accounts), but new want the
last line's USD...
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to get rid of "Could not determine the account currency. Using the default currency provided by your system."

[Paul Neuwirth]

On Wed, 03 Jan 2018 13:45:46 -0500
Derek Atkins  wrote:

> Hi,
> 
> Paul Neuwirth  writes:
> 
> > Hello,
> > I always get "Could not determine the account currency. Using the
> > default currency provided by your system." when opening an account
> > since upgrade to 2.6.19.
> > according to SQL 
> > SELECT * FROM gnucash.accounts a left join gnucash.commodities c on
> > c.guid = a.commodity_guid;
> > all accounts have a currency set.
> >
> > Book Option "Use Trading Accounts" is off
> > Preferences Accounts, Default Currency is set (choose: EUR)
> >
> > what am I missing?  
> 
> What type of account is it?
> Specifically, is it a stock/mutual fund account?
> If so, is it a top-level account?
> 
> Stock/Mutual accounts need to be children of an Asset with a currency.

Thank you.
it was any account, any type and everywhere was Euro (EUR) set (not
changable in dialog).. I saw in the mysql table commodities, EUR defined
twice. when I imported transactions duplicate accounts where made with
the "other EUR currency". I replaced old commodity-guids in all tables
by the new guid..

update gnucash.transactions set
currency_guid='2e2395017967d7799120dc8585cf4080' where currency_guid =
'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.accounts set
commodity_guid='2e2395017967d7799120dc8585cf4080' where commodity_guid
= 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.customers set
currency='2e2395017967d7799120dc8585cf4080' where currency =
'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.invoices set
currency='2e2395017967d7799120dc8585cf4080' where currency =
'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.prices set
currency_guid='2e2395017967d7799120dc8585cf4080' where currency_guid =
'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.prices set
commodity_guid='2e2395017967d7799120dc8585cf4080' where commodity_guid
= 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.vendors set
currency='2e2395017967d7799120dc8585cf4080' where currency =
'c7a51d86fdeb16c7e93c09eb9af9b5e3'; 

and deleted the old EUR currency... 
now everything is fine.. 

> 
> > Any help appreciated.
> >
> > Happy new year,
> >
> > Paul  
> 
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.  
> 
> -derek
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to deal with RRSP's (Canada)

[Cam Ellison]

On 03/01/18 04:36 PM, Matthew Pounsett wrote:

I am not an accountant.. or even a bookkeeper.. but here's how I deal with
RRSPs.



For me, the RRSPs have been converted to Income Funds, but the principle

and procedure are still the same. Contribution is straightforward: from a
Current Asset account to the RRSP, like this:

Assets:Current Assets:Chequing Account$5,000
Assets:Investments:RRSP$5,000



RRSPs are investments–typically mutual funds–and not savings accounts (at
least, every RSP account I've ever had has been presented that way: as X
units worth $Y per unit).  So, when I buy in to my RRSPs it shows in my GC
books as a purchase of shares of a mutual fund.  Transfers out as a sale of
shares.




Withdrawal is more complex, because you have to show Income, Withholding
Tax, the receiving Account, and the RRSP account, so using an Equity
account for RSP/RIF withdrawals is needed to balance, like this:


It only needs to be more complex if you're trying to use GC to calculate
your tax for you.  If that's the case, then there's additional complexity
on both the purchase and sale of RRSP shares.  On purchase, you need to
reduce your income, but I'm not sure what that would be balanced against.
The most likely prospect seems to me to be a liability, probably.   On sale
there's no withholding, or any immediate tax activity.. that all comes at
the end of the year when you calculate your taxes.  This makes sense if you
think about the fact that (assuming you purchase RRSP shares from out of
your assets) there was no negative change to withholding when you bought
the RRSP shares in the first place.  That only occurs if your employer is
buying shares on your behalf pre-tax, which will still work out, because
that immediately reduces whatever you would have put in your income
(salary) account.

So on purchase of RRSP shares you'd reduce your effective income and
increase an offset (liability?) account.  On sale, do the reverse until
your chosen offset account hits zero, and then any other withdrawls are new
income (gains on the investment).  I believe the rest should come out in
the wash (tax forms).  The only question in my mind is what to balance the
income account against.. and I'm afraid for that I only have guesses.

The examples I used were (perhaps over-) simplifications. In practice, I 
actually have a number of stocks and money market accounts within two 
RIFs, like so:


Assets:investments:RIF:Stock1
Assets:Investments:RIF:Stock2
Assets:Investments:RIF:MoneyMarket1
Assets:Investments:RIF:Cash
etc.

A withdrawal from the RRSP/RIF is actually from the cash account within 
the RRSP/RIF subsequent to selling money market shares. Everything is a 
Stock, except the cash account. If you have mutual funds, substitute 
appropriately. I have RIFs, being over 71, but for our purposes here the 
difference between RRSP and RIF is in name only. If there is only one 
financial instrument, then you obviously would dispense with the 
detailed breakdown shown above.


The offset account can't be a liability - that would double the impact 
of the withdrawal and screw up your balance sheet. It pretty much needs 
to be either an Equity or an Expense account. As I think about it more, 
there is a certain logic to the latter, since it was originally Income. 
I may have been doing that part wrong. When I moved everything into 
GnuCash lo, these many years ago, I had to use Equity:Opening Balances 
as the offset to each item within the RRSP, and simply continued the 
practice, with a different sub-account


I am not an accountant, either, but perhaps a member of this list who is 
might weigh in on this last point.


I think if your employer contributes to your RRSP or a fund or other 
instrument within it, that probably needs to be dealt with as Income. 
Also, it may count as a taxable benefit.


Cheers

Cam

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Transfer From Moneydance

[Roger Miskowicz]

Thanks, I guessed that it would take a while which partially explains my
procrastination. 

On Wed, Jan 3, 2018 at 9:17 PM, David Carlson 
wrote:

> I too used Moneydance for a while after Quicken.  That was long ago.  I
> think that Moneydance was able to generate fairly good QIF files which
> imported into GnuCash with about the same quirks as Quicken QIFs.
>
> That said, it is good to run a lot of tests and plan carefully before
> making a 'for real' data file.
>
>
> David C
>
> On Wed, Jan 3, 2018 at 7:48 PM, Roger Miskowicz 
> wrote:
>
>> I have been using gnucash for a business account for some time while using
>> Moneydance for personal accounts.
>>
>> Are there tips or a preferred procedure for transferring from Moneydance
>> accounts  to gnucash?
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Transfer From Moneydance

[David Carlson]

I too used Moneydance for a while after Quicken.  That was long ago.  I
think that Moneydance was able to generate fairly good QIF files which
imported into GnuCash with about the same quirks as Quicken QIFs.

That said, it is good to run a lot of tests and plan carefully before
making a 'for real' data file.


David C

On Wed, Jan 3, 2018 at 7:48 PM, Roger Miskowicz  wrote:

> I have been using gnucash for a business account for some time while using
> Moneydance for personal accounts.
>
> Are there tips or a preferred procedure for transferring from Moneydance
> accounts  to gnucash?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Transfer From Moneydance

[Roger Miskowicz]

I have been using gnucash for a business account for some time while using
Moneydance for personal accounts.

Are there tips or a preferred procedure for transferring from Moneydance
accounts  to gnucash?
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to deal with RRSP's (Canada)

[Matthew Pounsett]

I am not an accountant.. or even a bookkeeper.. but here's how I deal with
RRSPs.


>
>> For me, the RRSPs have been converted to Income Funds, but the principle
> and procedure are still the same. Contribution is straightforward: from a
> Current Asset account to the RRSP, like this:
>
> Assets:Current Assets:Chequing Account$5,000
> Assets:Investments:RRSP$5,000
>
>
RRSPs are investments–typically mutual funds–and not savings accounts (at
least, every RSP account I've ever had has been presented that way: as X
units worth $Y per unit).  So, when I buy in to my RRSPs it shows in my GC
books as a purchase of shares of a mutual fund.  Transfers out as a sale of
shares.



> Withdrawal is more complex, because you have to show Income, Withholding
> Tax, the receiving Account, and the RRSP account, so using an Equity
> account for RSP/RIF withdrawals is needed to balance, like this:
>

It only needs to be more complex if you're trying to use GC to calculate
your tax for you.  If that's the case, then there's additional complexity
on both the purchase and sale of RRSP shares.  On purchase, you need to
reduce your income, but I'm not sure what that would be balanced against.
The most likely prospect seems to me to be a liability, probably.   On sale
there's no withholding, or any immediate tax activity.. that all comes at
the end of the year when you calculate your taxes.  This makes sense if you
think about the fact that (assuming you purchase RRSP shares from out of
your assets) there was no negative change to withholding when you bought
the RRSP shares in the first place.  That only occurs if your employer is
buying shares on your behalf pre-tax, which will still work out, because
that immediately reduces whatever you would have put in your income
(salary) account.

So on purchase of RRSP shares you'd reduce your effective income and
increase an offset (liability?) account.  On sale, do the reverse until
your chosen offset account hits zero, and then any other withdrawls are new
income (gains on the investment).  I believe the rest should come out in
the wash (tax forms).  The only question in my mind is what to balance the
income account against.. and I'm afraid for that I only have guesses.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Printing Hard Copy

[David Carlson]

I don't think that RJ was clear about what he really wants.  I thought that
he asked for a listing of all the accounts and their current balances
similar to a subset of the CoA.  That should be easy.

David C

On Wed, Jan 3, 2018 at 5:59 PM, Maf. King  wrote:

> On Wednesday, 3 January 2018 23:42:14 GMT Matthew Pounsett wrote:
>
> >
> > Is there a report that reproduces a Basic, Auto-Split, or Transaction
> > Journal ledger?
> >
>
>
> Hi,
>
> isn't this what the Account Report is for -  printing the details of a
> register view, as filtered / date limited etc.?
>
> Maf.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Printing Hard Copy

[Maf. King]

On Wednesday, 3 January 2018 23:42:14 GMT Matthew Pounsett wrote:

> 
> Is there a report that reproduces a Basic, Auto-Split, or Transaction
> Journal ledger?
> 


Hi,

isn't this what the Account Report is for -  printing the details of a 
register view, as filtered / date limited etc.?

Maf.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Printing Hard Copy

[Matthew Pounsett]

On 3 January 2018 at 13:28, Derek Atkins  wrote:

> Hi,
>
> rj ruble  writes:
>
> > How can I print my accounts to hard copy?
>
> Generate the appropriate report that shows the accounts as you want, and
> then you can print the report.
>
>
Is there a report that reproduces a Basic, Auto-Split, or Transaction
Journal ledger?

OP, I think the answer is, "you can't."   At least not directly from within
GnuCash.  The best I've ever found is to export an account to CSV, hide or
delete the columns I'm not interested in, and print that.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Close Year

[Christopher Lam]

You can 'close the year' with Tools > Close Year which adds a 'Closing
entry' transaction from Expense and Income accounts on a specific date to
the Equity account. The benefit is that the Income & Expense balances will
reflect 'balance this year' so far.
It doesn't however prevent modification of prior entries.

In practice, few of us actively close the books.

To create an income/expense report, you can use the 'Report > Transaction
Report' and display transactional data, or run 'Report > Income & Expense >
Income Statement' for summaries. You will have to tweak the options. Please
be aware that the "Income Statement" can exclude the closing entries
created above, whereas the Transaction Report will include Closing Entries
unless you actively filter them out by selecting "Accounts > Filter By" to
"exclude transactions to/from" and Filter-accounts to closing-entries
equity account.

On 4 January 2018 at 02:03, Richard Barmann 
wrote:

> How do I close out the year and what do I need to print out for taxes.
>
> I think last year I printed out several sheets that had expenses and
> income listed.
>
> Thank You.
>
> Richard Barmann
>
> r...@barmannsbar.com
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Check Register view disappeared; how do I get it back?

[Mike or Penny Novack]

On 1/3/2018 1:38 PM, Dave Orsinger wrote:

Hi,
I asked this basic question several days ago and still haven't found a 
solution. I was starting with gnucash on a very basic, personal 
level.  I was entering data in the basic "check" register. When taking 
a break, I accidentally "x'd" the check register tab and it went away 
(no surprise). However, when I tried to make it reappear, I cant 
figure out how to do it. My data is still there as I can run reports, 
etc. but I need the "check" register to continue entering more data.
Perhaps someone can create a "dummy" account (named after me), do what 
I did in closing the check register, and figure out how to get it back.


Much appreciated.
Dave O
You had been keeping this account "open" (a tab for it on the bar) and 
you closed it so the tab went away?


What tabs DO you still have on that bar? Surely one for "accounts". 
Click on that and it will bring up a view of your CoA (chart of 
accounts; your hierarchy of accounts). You then find your checking 
account in that hierarchy and open it (click on it) which will put it 
back on the bar. Yes, MOST of the time your checking account will be one 
of the accounts affected by a transaction but not always, so you need to 
learn how to open ANY account in your CoA. So learning how to (re)open 
your checking account useful.


Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Close Year

[Richard Barmann]

How do I close out the year and what do I need to print out for taxes.

I think last year I printed out several sheets that had expenses and
income listed.

Thank You.

Richard Barmann

r...@barmannsbar.com

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Check Register view disappeared; how do I get it back?

[Colin Law]

On 3 January 2018 at 18:38, Dave Orsinger  wrote:

> Hi,
> I asked this basic question several days ago and still haven't found a
> solution. I was starting with gnucash on a very basic, personal level.  I
> was entering data in the basic "check" register. When taking a break, I
> accidentally "x'd" the check register tab and it went away (no surprise).
> However, when I tried to make it reappear, I cant figure out how to do it.
> My data is still there as I can run reports, etc. but I need the "check"
> register to continue entering more data.
> Perhaps someone can create a "dummy" account (named after me), do what I
> did in closing the check register, and figure out how to get it back.
>

Have you got a tab there titled Accounts? If so then open it and you should
be able to see all the accounts. Double click the account you want to
open.  If you haven't got the accounts tab then presumably you closed that
one too.  Click on View > New Accounts Page and it will open it again.

Colin


>
> Much appreciated.
> Dave O
>
> On 1/1/2018 7:25 PM, Liz wrote:
>
>> On Mon, 1 Jan 2018 19:14:57 -0800
>> Greg Feneis  wrote:
>>
>> Yes you can. Check the view menu for an item with a similar name.  I
>>> can't recall exactly what it's called
>>>
>>> Kind regards, Greg Feneis
>>>
>>
>> You would like to see "Double Line" from the View menu.
>>
>> Liz
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Thank You!

[Alen Siljak]

   I'll join in on the thanks list by saying that I'm getting happier by
   the day after recently switching to GnuCash. It's a wonderful piece of
   software. Double-entry accounting often saves the day and makes me
   wonder how could I live without it for so long.
   And the sugar on top of all that is the fact that I can tap directly
   into the database and create a report/view for any piece of information
   I want to see. I'm still getting used to this but finally I feel my
   hands are untied and I can create a set of tools I've kinda been
   waiting for years to be implemented by someone else.
   So, thanks guys for being there for so long and keeping this software
   humming along.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to get rid of "Could not determine the account currency. Using the default currency provided by your system."

[Derek Atkins]

Hi,

Paul Neuwirth  writes:

> Hello,
> I always get "Could not determine the account currency. Using the
> default currency provided by your system." when opening an account since
> upgrade to 2.6.19.
> according to SQL 
> SELECT * FROM gnucash.accounts a left join gnucash.commodities c on
> c.guid = a.commodity_guid;
> all accounts have a currency set.
>
> Book Option "Use Trading Accounts" is off
> Preferences Accounts, Default Currency is set (choose: EUR)
>
> what am I missing?

What type of account is it?
Specifically, is it a stock/mutual fund account?
If so, is it a top-level account?

Stock/Mutual accounts need to be children of an Asset with a currency.

> Any help appreciated.
>
> Happy new year,
>
> Paul

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

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Check Register view disappeared; how do I get it back?

[Dave Orsinger]

Hi,
I asked this basic question several days ago and still haven't found a 
solution. I was starting with gnucash on a very basic, personal level.  
I was entering data in the basic "check" register. When taking a break, 
I accidentally "x'd" the check register tab and it went away (no 
surprise). However, when I tried to make it reappear, I cant figure out 
how to do it. My data is still there as I can run reports, etc. but I 
need the "check" register to continue entering more data.
Perhaps someone can create a "dummy" account (named after me), do what I 
did in closing the check register, and figure out how to get it back.


Much appreciated.
Dave O

On 1/1/2018 7:25 PM, Liz wrote:

On Mon, 1 Jan 2018 19:14:57 -0800
Greg Feneis  wrote:


Yes you can. Check the view menu for an item with a similar name.  I
can't recall exactly what it's called

Kind regards, Greg Feneis


You would like to see "Double Line" from the View menu.

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Payment Term 60 Days with Cut-off Day

[Derek Atkins]

HI,

Chen Thomas  writes:

> Hi,
>
> I have some business with payment term 60 days or 90 days with a
> cut-off day, for example, 25th of the month.
> I can set up the term with "Day" type because it's over 30 days, but
> there is no cut-off day field.
> If I use the other type, there is a cut-off day field, but due day
> must be a day of a month, which can not be over 31.
>
> Is there any way to handle this kind of payment term in GnuCash?

No, not really.

> Or any workaround? Thank you.

The "terms" is more of a textual notification for the users.  Other than
computing the Due Date, GnuCash does not do anything with it.

> Thomas

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

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Dealing with a large QIF file

[Derek Atkins]

Liz  writes:

> On Mon, 25 Dec 2017 00:46:30 +
> "cliffhan...@gardener.com"  wrote:
>
>>Thanks. Yes one can import one at a time but this cheque ac from
>>Quicken is huge and has references to other card accounts as
>> categories within it. These accounts don't exist anymore and gnucash
>> is trying to create them as part of the import. This is something I'd
>> like to avoid. Hope this makes sense. Cliff
>
> Everything in Gnucash must reference (at least) one other account. You
> would be well advised to follow Lincoln's advice to make a single
> account to put the other half of these transactions.

Or...  After you perform the import, re-hide the accounts.

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

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Sorting options for Credit Card account

[Derek Atkins]

Hi,

"John Rogers"  writes:

> I have a rather active credit card account (approximately 6 charges per day)
> that I'm trying to keep in sync with my bank.   I enter the transactions as
> I see the receipts.   I also mark the transaction in the Reconcile column
> from n to c when I see it has cleared my bank's website.   I have the sort
> order set to Statement Date.  This seems to do what I want in that it does
> move the transactions that have been cleared to the top and the ones that
> are not cleared to the bottom.   However, the issue is that let's say that I
> put in 6 transactions for 12/22/2017 in the register in a random order.   2
> of them have cleared and I have set them to a c.   They show at the top.
> However, the Balance that shows on the right side shows the balance in the
> order the transactions were entered, not by the cleared status.   Is there
> any way to show the transaction AND balance by the cleared status ?

The short answer is no.

The balance is a split-parameter computed based on the standard sort
order.  Changing the sort order does not recompute the balance entries.
The balance is not "computed", because we don't want to show the
"incorrect" balance if you're only showing a subset of transactions.

> See attached screenshot.   The balance after adding in 26.34 to 1089.83
> should be 1116.17.   However, it shows 1250.34 which I'm assuming is several
> of the other [un-cleared] transactions as well.

Correct.

> Thanks in advance for any assistance,

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

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How are PINs stored? (aqbanking)

[Derek Atkins]

bhoth  writes:

> Just bringing this back up. is there any change on remembering the online
> update pins permanently. I just switched a few days ago from Quicken and
> it's annoying to have to enter the password each day or whenever I connect
> for online "get transactions".

GnuCash will save it in memory for the session, but will not store it.
I don't know if there are any plans to add KeyStore storage for it.

> Thank you

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

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Falure to open gnucash

[Derek Atkins]

Hi,

Jerome Kremen  writes:

> Dear Members
> I tried to access my gnucash accounts yesterday and got the cryptic
> error message gnucash failed to open because of a problem.
> I am using the Mac operating system which I recently upgraded to High
> Sierra 10.13.2.  Can that be the cause of my failure to open Gnucash?
> I then downloaded the latest version of gnucash but did not install it
> because I didn’t know whether the new installation would wipe out my
> company books.

What version of GnuCash?  You need at least 2.6.18 for High Sierra.

> Is it safe to install a new version?

Yes.

>    Will it preserve my accounts?

Yes.

> Your help would be much appreciated.  Since I am not sure how to
> navigate the mailing lists and would not know where to find a reply,
> please reply to jerry.kre...@engopt.com.
> Best wishes,
> Jerry kremen

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

-derek
-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: import transactions from CSV with mutiple accounts

[Paul Neuwirth]

On Wed, 3 Jan 2018 12:40:13 +0100
Paul Neuwirth  wrote:

> On Sat, 30 Dec 2017 17:03:13 +0100
> Geert Janssens  wrote:
> 
> > Op zaterdag 30 december 2017 16:20:53 CET schreef Paul Neuwirth:  
> > > Hi List,
> > > 
> > > I hope someone can give me a hint. Is it a bug of the importer or
> > > am I doing something wrong? Or is there a tool which converts csv
> > > to qif or other advanced format?
> > > I have a CSV file with transactions of different bank accounts
> > > (ca. 12 bank accounts, export from banking software moneyplex).
> > > If I import csv files with only transactions of one account,
> > > gnucash selects (automatically) the correct account (slot
> > > 'online-id' of account is identically to account number in csv).
> > > But if I do import transactions belonging to different accounts,
> > > all transactions are being imported into the account of the first
> > > line in the csv.
> > > This does not make any sense for me, as you can select account as
> > > a column...
> > > 
> > > It would be quiet unconvinient to do seperate imports for every
> > > account. On the other side (moneyplex) does have advanced export
> > > functions, but not for transactions of multiple accounts (therefor
> > > only search results can be exported to csv or xml)..
> > 
> > Hi Paul,
> > 
> > I don't think the csv importer was designed with your use case in
> > mind. I believe it was written to import transactions one bank
> > account at the time.
> > 
> > So for the 2.6 series unfortunately you will have to live with this 
> > limitation. There are some tools floating around on the net for
> > converting csv files to qif, or more exactly LibreOffice Calc to qif
> > or Excel to qif (but both applications should be able to open csv
> > files just fine).
> > 
> > For gnucash 3.0 (to be released in a couple of months) the csv
> > importer has been rewritten and the new one should be able to handle
> > csv files in your format just fine.
> > 
> > Regards,
> > 
> > Geert  
> 
> thank you very much for the hints. I am about gnucash 3.0..
> Just wrote a script to generate a QIF file from moneyplex search
> result csvs.. pretty simple and working :)
> 
> I whis you a prosperous new year 
> 
> Paul

exasperating...
glad qif import works.. but (compared to csv import, with very helfull
aditional screen..) correlation is not done.. bunch of duplicates now.. 
but i do not give up hope.. best way right now is doing csv
import account by account.. :-/
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: import transactions from CSV with mutiple accounts

[Paul Neuwirth]

On Sat, 30 Dec 2017 17:03:13 +0100
Geert Janssens  wrote:

> Op zaterdag 30 december 2017 16:20:53 CET schreef Paul Neuwirth:
> > Hi List,
> > 
> > I hope someone can give me a hint. Is it a bug of the importer or
> > am I doing something wrong? Or is there a tool which converts csv
> > to qif or other advanced format?
> > I have a CSV file with transactions of different bank accounts (ca.
> > 12 bank accounts, export from banking software moneyplex).
> > If I import csv files with only transactions of one account, gnucash
> > selects (automatically) the correct account (slot 'online-id' of
> > account is identically to account number in csv).
> > But if I do import transactions belonging to different accounts, all
> > transactions are being imported into the account of the first line
> > in the csv.
> > This does not make any sense for me, as you can select account as a
> > column...
> > 
> > It would be quiet unconvinient to do seperate imports for every
> > account. On the other side (moneyplex) does have advanced export
> > functions, but not for transactions of multiple accounts (therefor
> > only search results can be exported to csv or xml)..  
> 
> Hi Paul,
> 
> I don't think the csv importer was designed with your use case in
> mind. I believe it was written to import transactions one bank
> account at the time.
> 
> So for the 2.6 series unfortunately you will have to live with this 
> limitation. There are some tools floating around on the net for
> converting csv files to qif, or more exactly LibreOffice Calc to qif
> or Excel to qif (but both applications should be able to open csv
> files just fine).
> 
> For gnucash 3.0 (to be released in a couple of months) the csv
> importer has been rewritten and the new one should be able to handle
> csv files in your format just fine.
> 
> Regards,
> 
> Geert

thank you very much for the hints. I am about gnucash 3.0..
Just wrote a script to generate a QIF file from moneyplex search result
csvs.. pretty simple and working :)

I whis you a prosperous new year 

Paul
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.