Re: [GNC] importing csv multisplit multicurrency problems

2020-03-10 Thread pobox . deva
Sorry Gio, I don’t have any experience with the import or multi-currency 
transactions in GnuCash.

I only responded to your query because you wanted a better way to load a price 
database rather than entering them manually.

Cheers.

> On 11-Mar-2020, at 10:32 AM, Gio Bacareza  wrote:
> 
> Hi Pobox.Deva,
> 
> Thank you for the suggestion. I'll try that out. However my problem, I think 
> though I may be wrong, is not the price database but the importing 
> multicurrency transactions.
> 
> I even made it simpler. Pre-import, I calculated and populated the currency 
> conversions using just 1 exchange rate. I thought that by doing this I avoid 
> having to maintain a price database that could change on a daily basis. 
> Because this would mean the calculating the conversions prior to import will 
> require me to have a different conversion rate depending on the day. It's 
> possible but I thought it will take more work.
> 
> But I may be wrong. So do you think that fixing the price database will fix 
> the multi-currency import problem I am having?
> 
> Thanks.
> 
> 
> On Fri, Mar 6, 2020 at 1:37 PM  > wrote:
> Gio,
> 
> If you are using the 3.x series, there’s a convenient CSV price importer that 
> works well. You can even save the CSV price file template for future use, so 
> you’d have to set it up only once.
> 
> That should alleviate a lot of burden in entering prices in price database 
> manually.
> 
> Cheers.
> 
> > On 06-Mar-2020, at 9:53 AM, gnucash-user-requ...@gnucash.org 
> >  wrote:
> > 
> > Date: Fri, 6 Mar 2020 12:23:17 +0800
> > From: Gio Bacareza mailto:gbacar...@gmail.com> 
> > >>
> > To: GnuCash Users  >   > >>
> > Subject: Re: [GNC] importing csv multisplit multicurrency problems
> > Message-ID:
> >> 
> >   > >>
> > Content-Type: text/plain; charset="UTF-8"
> > 
> > As mentioned I did some follow through tests with empty and pre-populated
> > currency price databases. Sharing it here:
> > 
> > Conclusions:
> > When doing multi-currency csv imports, it works when the price database is
> > pre-populated with exchange rates consistent with exchange rates used in
> > the import.
> > The issue I have with this is that pre-populating the price DB is
> > cumbersome.
> > There has to be a better way.
> > 
> > More details of test here
> > https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing
> >  
> > 
> >  
> >  >  
> > >
> ___
> 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.
> 
> 
> -- 
> cheers,
> 
> Gio

___
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] Find or search all expenses in a certain account

2020-03-10 Thread Gio Bacareza
Hi Alton, I'm sorry I shot from the hip and answered before I realized I
misunderstood you. Your solution is exactly what I'm following now. Thanks.

On Wed, Mar 11, 2020 at 7:31 AM Alton Brantley 
wrote:

> In situations like this, I have usually just moved the 10 or so
> transactions from the current account(“AccountX”) to a new account (say
> AccountXNew), then delete AccountX, then rename AccountXNew to AccountX.



-- 
cheers,

Gio
___
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] Find or search all expenses in a certain account

2020-03-10 Thread Gio Bacareza
Hi Alton, I actually tried that at first but I have hundreds of
transactions and it became cumbersome fast. Thanks for the suggestion.

On Wed, Mar 11, 2020 at 7:31 AM Alton Brantley 
wrote:

> In situations like this, I have usually just moved the 10 or so
> transactions from the current account(“AccountX”) to a new account (say
> AccountXNew), then delete AccountX, then rename AccountXNew to AccountX.



-- 
cheers,

Gio
___
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 csv multisplit multicurrency problems

2020-03-10 Thread Gio Bacareza
Hi Pobox.Deva,

Thank you for the suggestion. I'll try that out. However my problem, I
think though I may be wrong, is not the price database but the importing
multicurrency transactions.

I even made it simpler. Pre-import, I calculated and populated the currency
conversions using just 1 exchange rate. I thought that by doing this I
avoid having to maintain a price database that could change on a daily
basis. Because this would mean the calculating the conversions prior to
import will require me to have a different conversion rate depending on the
day. It's possible but I thought it will take more work.

But I may be wrong. So do you think that fixing the price database will fix
the multi-currency import problem I am having?

Thanks.


On Fri, Mar 6, 2020 at 1:37 PM  wrote:

> Gio,
>
> If you are using the 3.x series, there’s a convenient CSV price importer
> that works well. You can even save the CSV price file template for future
> use, so you’d have to set it up only once.
>
> That should alleviate a lot of burden in entering prices in price database
> manually.
>
> Cheers.
>
> > On 06-Mar-2020, at 9:53 AM, gnucash-user-requ...@gnucash.org wrote:
> >
> > Date: Fri, 6 Mar 2020 12:23:17 +0800
> > From: Gio Bacareza mailto:gbacar...@gmail.com>>
> > To: GnuCash Users  gnucash-user@gnucash.org>>
> > Subject: Re: [GNC] importing csv multisplit multicurrency problems
> > Message-ID:
> >   <
> caec3bmq5irklc0ew79ra3ktvb+xejkou72r9pv0a9v7bxi_...@mail.gmail.com
>  >>
> > Content-Type: text/plain; charset="UTF-8"
> >
> > As mentioned I did some follow through tests with empty and pre-populated
> > currency price databases. Sharing it here:
> >
> > Conclusions:
> > When doing multi-currency csv imports, it works when the price database
> is
> > pre-populated with exchange rates consistent with exchange rates used in
> > the import.
> > The issue I have with this is that pre-populating the price DB is
> > cumbersome.
> > There has to be a better way.
> >
> > More details of test here
> >
> https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing
> <
> https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing
> >
> ___
> 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.
>


-- 
cheers,

Gio
___
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] Income Statement for specific Asset Account ?

2020-03-10 Thread Peter West
Cash Flow is one of the Income & Expense reports in the Reports menu (on my 
Mac, anyway.)

Peter

--
Peter West
p...@pbw.id.au
“Judge not, and you will not be judged; condemn not, and you will not be 
condemned; forgive, and you will be forgiven; give, and it will be given to 
you.”

> On 11 Mar 2020, at 9:22 am, Michael or Penny Novack 
>  wrote:
> 
> On 3/10/2020 12:59 PM, Long wrote:
>> Hello Adrien Monteleone-2,
>> 
>> I think P doesn't have ability to report for only my asset account. For
>> example, i have Asset named "ME" and Assets named "You". each accounts have
>> their own expenses - income. i want to have MONTHLY REPORT (Expense vs
>> Income) for each Asset Accounts.
>> 
>> Now, the only ways are use the Cash Flow report, And it doesn't have Monthly
>> Report (P doesn't have monthly report too, i saw no option to do that).
>> 
>> Regards.
>> 
> Let's break this apart ..
> 
> a) P doesn't connect to asset accounts OR liability accounts because 
> whether something is income has nothing to do with whether it increased an 
> asset (it COULD have reduced a liability) and whether something is expense 
> has nothing to do with how that paid for (it COULD be a decease in an asset 
> like cash OR an increase of a liability)
> 
> b) You CAN select what accounts (which income or expense accounts are 
> included in the P)
> 
> c) As I said, you PROBABLY mean cash flow, not P But in any case both 
> these reports ALWAYS have a from date and a to date (are for some interval) 
> and you can most certainly specify those to span a month.
> 
> d) Take a look at the cash flow report. See what you can or cannot specify in 
> the report options before saying what it can or can;t do. Same with P (the 
> Income Statement report)
> 
> 
> Michael D Novack
> 
> 
> 
> ___
> 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] GNC Equity and Retained Earnings not tracking together?

2020-03-10 Thread David Cousens
Christopher,

In another post on this thread in reply to Mike Novak's reply  to an earlier
post I outlined how Equity:Retained Earnings is generally used in accounting
theory and the distinction between contributed capital and earned capital
usually made in corporate accounting. The Retained Earnings is the nett
*operating* income as you suggest (usually separate from any income from
financing activities of a company. This clear separation is perhaps really
only essential for corporate structures where there is a legal separation of
the liabilities of the shareholder from the liabilities of the business
although other business users (partneships, sole traders) may want to
provide a similar degree of separation for their management purposes.

Do you know if GnuCash has a flag indicating whether the books have been
closed formally or is just the presence or absence of the closing
transactions used to detect this?  

If the books are not formally closed then it is obviously difficult to
reflect the transfer between earned capital and contributed capital that
occurs when dividends are paid or money is reinvested in the business unless
the accounts specifically affecting retained earnings can be specified,
perhaps in the options?  Not all credit splits to equity for example will
reflect such transfers as there are likely to be transactions involving the
share capital (splitting, buy backs etc) which don't affect Retained
Earnings.

David



-
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] Find or search all expenses in a certain account

2020-03-10 Thread Alton Brantley
In situations like this, I have usually just moved the 10 or so transactions 
from the current account(“AccountX”) to a new account (say AccountXNew), then 
delete AccountX, then rename AccountXNew to AccountX.
___
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] Income Statement for specific Asset Account ?

2020-03-10 Thread Michael or Penny Novack

On 3/10/2020 12:59 PM, Long wrote:

Hello Adrien Monteleone-2,

I think P doesn't have ability to report for only my asset account. For
example, i have Asset named "ME" and Assets named "You". each accounts have
their own expenses - income. i want to have MONTHLY REPORT (Expense vs
Income) for each Asset Accounts.

Now, the only ways are use the Cash Flow report, And it doesn't have Monthly
Report (P doesn't have monthly report too, i saw no option to do that).

Regards.


Let's break this apart ..

a) P doesn't connect to asset accounts OR liability accounts because 
whether something is income has nothing to do with whether it increased 
an asset (it COULD have reduced a liability) and whether something is 
expense has nothing to do with how that paid for (it COULD be a decease 
in an asset like cash OR an increase of a liability)


b) You CAN select what accounts (which income or expense accounts are 
included in the P)


c) As I said, you PROBABLY mean cash flow, not P But in any case both 
these reports ALWAYS have a from date and a to date (are for some 
interval) and you can most certainly specify those to span a month.


d) Take a look at the cash flow report. See what you can or cannot 
specify in the report options before saying what it can or can;t do. 
Same with P (the Income Statement report)



Michael D Novack



___
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] GNC Equity and Retained Earnings not tracking together?

2020-03-10 Thread David Cousens
Brian,Michael

I did misunderstand Brian's original question.

My comment below is a general accounting perspective based on general
accounting theory for corporations ( Financial Accounting Horngren etal 5 th
edition, Accounting Theory  Godfrey etal Wiley Australia  (Accounting Theory
Kahn Wiley US looks to be a US equivalent) ) and may be affected by specific
corporation's law requirements/arrangements specific to the jurisdiction. 

The general accounting rationale is to keep clearly separate:

  a contributed capital -  raised from financing transactions;
  b earned capital - derived from profit making activities.

The earned capital consists of the unappropriated profits or retained
earnings. 
Retained earnings may then be appropriated for specific purposes. Retained
earnings does not represent a particular asset. Certain transaction types
will effecct transfers between earned capital and contributed capital (share
dividends, reinvestment etc.).

If the corporation wants to appropriate money from retained earnings for
specific purposes, it will normally establish reserve accounts which would
normally appear immediately above retained earnings in the balance sheet 
(this may depend on local practice). Reserves are generally established for
purposes like reinvestment, dividends etc.  To establish the reserve
accounts . Retained Earnings is debited and the reserve account is credited.
Unused reserves are usually returned to the Retained Earnings account.  When
money is used to increase long term assets for example there would normally
be a credit to a bank account and a debit to the appropriate long term asset
account and a corresponding debit to the appropriate reserve account and a
credit to the share capital account. That is money has been transferred from
the earned capital of the corporation into the share capital by this
transaction.  Similarly if there is a reserve account for Dividends Payable,
money is allocated by a debit to Retained Earnings and a credit to the
reserve Dividends Payable account  and Dividends Payable will be debited and
Share capital credited (again a transfer of earned capital to contributed
capital) when the dividend is paid along with the corresponding credit to a
bank account and debit to share capital (probably  Brian's Shareholder
Distributions which is a contra account) representing the actual payment to
the share holder.

GnuCash where it is  not using the close books and explicit accounting above
should be calculating any reductions to Retained Earnings from the
Shareholder Distributions as Brian implied. Whether this can be done
generally enough in the reports to fit all user situations is the real
question?

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] Income Statement for specific Asset Account ?

2020-03-10 Thread Adrien Monteleone
A quick follow up...

I know that last reply was really long.

Don’t try to grasp it all right away.

Read it over once or twice.

Run a Transaction Report following the steps I outlined. (forget about tags for 
now)

See how the report looks. If you like that, great, if not, fiddle with the 
options till you get something you like.

Without closing the report tab, go back to a register and start tagging some 
expense and income transactions, a few (or even one) at a time. Add your tag in 
Options > Filter as instructed.

Reload the report. See how the resulting data changed based on the tag. Repeat 
that last step with transactions in other months to see the monthly breakdown 
option.

Refine as needed and tag your remaining relevant transactions.

You’ll learn much more by doing (playing) with the report than by reading. You 
might even discover a different process that works even better.

Regards,
Adrien

> On Mar 10, 2020 w11d70, at 12:57 PM, Adrien Monteleone 
>  wrote:
> 
> Let’s clear up a few things:
> 
> 0. *Play* with reports to learn them, particularly, don’t use the Ok button 
> in Options until it looks the way you want, use the Apply button to keep the 
> Options window visible as you adjust settings and preferences.
> 
> 1. P doesn’t report ‘for’ asset accounts. It reports on only Expense and 
> Income accounts. Assets accounts do not ‘own’ those income and expense 
> accounts and those accounts do not ‘belong to’ any asset account. All are 
> part of the book, which belong to the entity. (a person, a household, a club, 
> an organization, a business, etc.)
> 
> 2. Both the P and the Cashflow report are for a period, with a start and 
> end date. You can make this period anything you want in GnuCash. (some apps 
> restrict you here, GnuCash does not) There are preset ‘quick dates’ and the 
> default is the ‘accounting period’ which for most people is one year. (this 
> is set in preferences) But there are quick dates for ’start of this month’ 
> ’start of last month’ ’start of this quarter’ etc. (along with their 
> comparable ‘end of dates’) But you can also specify exact dates.
> 
> What you won’t see is a 12 month side-by-side report. (there is an 
> experimental multi-column version of the Income Statement in the Experimental 
> reports menu, set your Duration to ‘monthly’)
> 
> If you want that for the Cashflow report, you’ll have to run a report for 
> each month separately, then move it to a spreadsheet and manipulate further 
> from there.
> 
> 3. If you want to show Income - Expenses *for the entire book* (with account 
> selection), you want the P or Income Statement report. (same report, two 
> names)
> 
> 4. The Cashflow report will show *all* movements of cash, not just those 
> involving income or expenses. For example, a payment on a loan or credit card 
> is not an expense, but it is a cash flow. (the expense was incurred when you 
> charged on the card at the store, not when you pay the bill) A loan usually 
> is for some asset like a car, land, house, or equipment, but it could be for 
> a major expense as well. The expense is incurred when you receive the 
> goods/services, not when you pay the loan.
> 
> 5. If you are using your book for multiple people, like those in a household 
> and you want to see each person’s income-expenses in addition to the entire 
> household, then you can take three approaches:
> 
>  5a. Separate Books for each person, and a combined book for the entire 
> household
>  5b. One book, with entirely separate account trees for each person
>  5c. One book, with separate asset accounts like checking and cash, and 
> possibly income, but common expense accounts, using a tagging system for the 
> expenses and income.
> 
> 5a. Will require duplicating entries into the common household book - the 
> formal method. (can use Income/P report)
> 5b. Will require lots of extra accounts and diligence to make sure you aren’t 
> using the wrong account in transactions. (can use Income/P report)
> 5c. Is the least work, but does require making up a tagging system and likely 
> saved *Transaction* report configurations for each person. (to save time 
> later) Can’t use built-in Income/P Reports, use Transaction Report instead.
> 
> The tagging system would work like this:
> 
> Using the Notes or Memo field, include text like “#me” or “#bob” et cetera 
> for each income and expense transaction. (The exact text can be anything you 
> want, even emojis I think)
> 
> Then run a Transaction Report
> 
> 1. Options > Accounts - select all expense accounts and the income accounts. 
> (if segregated, then just those for that person)
> 
> 2. Options > Filter > Transaction Filter - enter the tag text you want to 
> filter by, you have an option to use Regular Expressions if you like. (or 
> even exclude a text match, such as running a report for the household sans 
> #bob)
> 
> 3. Options > General > Start/End Date - set to ’start/end of this month’ or 
> as desired
> 
> 

Re: [GNC] Income Statement for specific Asset Account ?

2020-03-10 Thread Adrien Monteleone
Let’s clear up a few things:

0. *Play* with reports to learn them, particularly, don’t use the Ok button in 
Options until it looks the way you want, use the Apply button to keep the 
Options window visible as you adjust settings and preferences.

1. P doesn’t report ‘for’ asset accounts. It reports on only Expense and 
Income accounts. Assets accounts do not ‘own’ those income and expense accounts 
and those accounts do not ‘belong to’ any asset account. All are part of the 
book, which belong to the entity. (a person, a household, a club, an 
organization, a business, etc.)

2. Both the P and the Cashflow report are for a period, with a start and end 
date. You can make this period anything you want in GnuCash. (some apps 
restrict you here, GnuCash does not) There are preset ‘quick dates’ and the 
default is the ‘accounting period’ which for most people is one year. (this is 
set in preferences) But there are quick dates for ’start of this month’ ’start 
of last month’ ’start of this quarter’ etc. (along with their comparable ‘end 
of dates’) But you can also specify exact dates.

What you won’t see is a 12 month side-by-side report. (there is an experimental 
multi-column version of the Income Statement in the Experimental reports menu, 
set your Duration to ‘monthly’)

If you want that for the Cashflow report, you’ll have to run a report for each 
month separately, then move it to a spreadsheet and manipulate further from 
there.

3. If you want to show Income - Expenses *for the entire book* (with account 
selection), you want the P or Income Statement report. (same report, two 
names)

4. The Cashflow report will show *all* movements of cash, not just those 
involving income or expenses. For example, a payment on a loan or credit card 
is not an expense, but it is a cash flow. (the expense was incurred when you 
charged on the card at the store, not when you pay the bill) A loan usually is 
for some asset like a car, land, house, or equipment, but it could be for a 
major expense as well. The expense is incurred when you receive the 
goods/services, not when you pay the loan.

5. If you are using your book for multiple people, like those in a household 
and you want to see each person’s income-expenses in addition to the entire 
household, then you can take three approaches:

  5a. Separate Books for each person, and a combined book for the entire 
household
  5b. One book, with entirely separate account trees for each person
  5c. One book, with separate asset accounts like checking and cash, and 
possibly income, but common expense accounts, using a tagging system for the 
expenses and income.

5a. Will require duplicating entries into the common household book - the 
formal method. (can use Income/P report)
5b. Will require lots of extra accounts and diligence to make sure you aren’t 
using the wrong account in transactions. (can use Income/P report)
5c. Is the least work, but does require making up a tagging system and likely 
saved *Transaction* report configurations for each person. (to save time later) 
Can’t use built-in Income/P Reports, use Transaction Report instead.

The tagging system would work like this:

Using the Notes or Memo field, include text like “#me” or “#bob” et cetera for 
each income and expense transaction. (The exact text can be anything you want, 
even emojis I think)

Then run a Transaction Report

1. Options > Accounts - select all expense accounts and the income accounts. 
(if segregated, then just those for that person)

2. Options > Filter > Transaction Filter - enter the tag text you want to 
filter by, you have an option to use Regular Expressions if you like. (or even 
exclude a text match, such as running a report for the household sans #bob)

3. Options > General > Start/End Date - set to ’start/end of this month’ or as 
desired

4. Options > Sorting > Show subtotals only (hide transactional data) - check 
this box

5. Apply or Ok

This will give you a single column informal Income Statement. (that is, it 
doesn’t create headings for Income and Expenses or separate them) Depending on 
your account tree, more than likely, your expense accounts will be first, 
followed by income accounts.

The default is to show a single figures column with income as negative. You can 
switch to Debit/Credit columns via Options > Display > Amount > ‘Double’. With 
’Single’ you get the option to alter the Reverse Balance setting, but it 
doesn’t appear to work as expected.

The ‘Grand Total’ will be the net income.

!!BONUS

The Transaction Report is very versatile and *can* give you a monthly breakdown.

1. Options > Sorting > Primary Key - change to ‘Date’
2. Options > Sorting > Primary Subtotal for Date Key - set to ‘Monthly’
3. Options > Sorting > Secondary Key - set to ‘Account Name’
4. Options > Sorting > Secondary Subtotal - check this box

optional for readability:

5. Options > General > Table for Exporting - check this box

Now, you’ll get each month for the period 

Re: [GNC] Income Statement for specific Asset Account ?

2020-03-10 Thread Long
Hello Adrien Monteleone-2,

I think P doesn't have ability to report for only my asset account. For
example, i have Asset named "ME" and Assets named "You". each accounts have
their own expenses - income. i want to have MONTHLY REPORT (Expense vs
Income) for each Asset Accounts.

Now, the only ways are use the Cash Flow report, And it doesn't have Monthly
Report (P doesn't have monthly report too, i saw no option to do that).

Regards.



--
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] GNC Equity and Retained Earnings not tracking together?

2020-03-10 Thread Brian via gnucash-user
Christopher, my error.  If you re-read the original post the transaction
was posted Assets:Cash and Equity:Shareholder Distribution.  Liability
was not in the equation.  Basically, your comments confirm that the
GNUCash automatic calculation is rudimentary and to get a true
"retained earnings" that one must "close" books, or consider the
Balance Sheet report with a correction needed for the "Retained
Earnings" line is involved.

My previous statement should have read
> > Christopher, then I believe you are saying to get a proper "retained
> > earnings", which recognizes the reduction of Assets:Cash and
> > increase to EQUITY:Shareholder distribution, that one
> > would need to properly close the books by moving income and expense to a
> > EQUITY:Retained Earnings sub-account?

While that is disappointing, I can properly calculated true
"retained earnings" from the Balance Sheet report and simply need to add
the steps of "saving" a "open" version prior to closing the books, then
closing income and expense to "EQUITY:Retained earnings" and "saving"
that gnucash version with a tag of "closed" in the file name.  Then
there will be available a non-close version to go back and make
corrections if errors are found in the future.  Extra steps but
workable.  Thanks for the help. 
--
On Tue, 10 Mar 2020 16:33:12 +
Christopher Lam  wrote:

> The right answer will be to submit the Transaction Report to the
> accountant, have him/her calculate the Retained Earnings and
> Shareholder Distribution for you, then you pay your shareholders via
> Assets:Bank/Cash -> Liability:Shareholder (and later
> Liability:Shareholder -> Expenses:Shareholder Dividends I guess?)
> 
> I also think you'd close the books to an Equity:Retained Earnings
> account rather than Liability:Retained Earnings. I think untold
> surprises will arise if closing books to Liability.
> 
> IMHO Balance Sheet's Retained Earnings seems designed to be Net Income
> https://en.wikipedia.org/wiki/Net_income
> 
> That's all I know.
> 
> On Tue, 10 Mar 2020 at 15:29, Brian via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
> > > On Tue, 10 Mar 2020 at 01:02, Brian via gnucash-user <
> > > gnucash-user@gnucash.org> wrote:
> > >  
> > > > I'm wondering if GNUCash is actually calculating RETAINED
> > > > EARNINGS properly.  Because after issuing a distribution to
> > > > shareholder the Retaining Earning calculation increased by Net
> > > > Income but did not decrease by Asset:Cash which was debited and
> > > > credited to Equity:Shareholder Distribution.
> > > >  
> > >
> > > The calculation of Retained Earnings and Unrealized Gains in the
> > > Balance Sheet is rather primitive, and has been as such since
> > > nearly forever.
> > >
> > > Retained Earnings = sum total of income less expenses at the
> > > balance-sheet date.
> > > Unrealized Gains = sum total of (asset-liability) value, minus sum
> > > total of (asset-liability) cost.  
> >
> > Christopher, then I believe you are saying to get a proper "retained
> > earnings", which recognizes the reduction of Assets:Cash and
> > increase to Liability:Shareholder distribution, that one would need
> > to properly close the books by moving income and expense to a
> > Liability:Retained Earnings sub-account?
> >
> >
> >
> >
> >
> > ___
> > 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] Any ways to have monthly cash flow report ?

2020-03-10 Thread Long
Hi,

I thought it's difference between my questions, so i made a new question.
OK, i will delete this question.

Regards.



--
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] GNC Equity and Retained Earnings not tracking together?

2020-03-10 Thread Adrien Monteleone
Just for the record,

That should be a reduction of cash *and* a reduction of ’Shareholder 
distribution’, not an increase. You aren’t increasing your liability by paying 
it down.

Dr. Liability:Shareholder Distribution
Cr. Cash

The liability is increased via a transaction with Retained Earnings.

Dr. Equity:Retained Earnings
Cr. Liability:Shareholder Distribution

Research Dividends transactions for corporate accounting. You’ll find the 
appropriate accounts needed and how to structure the transactions. (better yet, 
speak to a local CPA!) I think the general term for your ’Shareholder 
Distribution’ is ‘Dividends Payable’ or ‘Dividends Declared’ (which might be a 
separate account)

Some also simply make those distribution accounts as contra-equity accounts 
under Retained Earnings or Shareholder’s equity and don’t involve liability 
accounts at all. It depends on the nature of the payment.

You can have an actual Retained Earnings account along with not closing the 
books, but you may wish instead to close the books. Otherwise, you’ll have two 
Retained Earnings lines on your balance sheet (one as net-income, one as actual 
account) which will require you to export to spreadsheet, combine them, then 
print. An improvement to the current report would be to add the balance of the 
real account to the net-income calculation.

Regards,
Adrien



> On Mar 10, 2020 w11d70, at 10:27 AM, Brian via gnucash-user 
>  wrote:
> 
>> On Tue, 10 Mar 2020 at 01:02, Brian via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>> 
>>> I'm wondering if GNUCash is actually calculating RETAINED EARNINGS
>>> properly.  Because after issuing a distribution to shareholder the
>>> Retaining Earning calculation increased by Net Income but did not
>>> decrease by Asset:Cash which was debited and credited to
>>> Equity:Shareholder Distribution.
>>> 
>> 
>> The calculation of Retained Earnings and Unrealized Gains in the
>> Balance Sheet is rather primitive, and has been as such since nearly
>> forever.
>> 
>> Retained Earnings = sum total of income less expenses at the
>> balance-sheet date.
>> Unrealized Gains = sum total of (asset-liability) value, minus sum
>> total of (asset-liability) cost.
> 
> Christopher, then I believe you are saying to get a proper "retained
> earnings", which recognizes the reduction of Assets:Cash and increase to
> Liability:Shareholder distribution, that one would need to properly
> close the books by moving income and expense to a Liability:Retained
> Earnings sub-account?

___
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] Any ways to have monthly cash flow report ?

2020-03-10 Thread Adrien Monteleone
Why did you ask the question again?

I just answered this in your other thread, "Income Statement for specific Asset 
Account ?”

Regards,
Adrien

> On Mar 10, 2020 w11d70, at 11:29 AM, Long  wrote:
> 
> Hello,
> 
> I want to have a look for specific Asset Account (Expenses and Income). So i
> thought about Cash Flow report. But it's only show for specific time, not
> monthly ? 
> Do you have any idea to have monthly expenses - income report for specific
> asset account ?
> 
> Regards.

___
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] Income Statement for specific Asset Account ?

2020-03-10 Thread Adrien Monteleone
The GnuCash ‘Cashflow Report’ is misnamed because it doesn’t work like every 
other Cash Flow report out there. (A Cash Flow report is supposed to show the 
effects of cash movements that don’t get reported in the P) It breaks down 
flows by special categories. There is a bug report on this. I don’t think the 
plan is to junk the current report, but until a proper one is made, it will 
retain the current name.

The GnuCash version is more like an overall in-out report, which might well be 
what you are looking for and yes, you can run it each month.

What you won’t see are income and expenses organized like a P, but you will 
see *all* flows in and out, even those that don’t include income or expense 
accounts. (like paying down a liability, it was cash-out but not an expense, so 
it won’t show up on the Income Statement)

You likely want to restrict the account selection for this report to just your 
asset accounts like a checking account and/or a cash account.

Either the Cashflow or P (Income Statement) can be customized with select 
accounts. So if you have multiple sub-entities within your household books you 
can still report on the activity of those entities. But that will depend on 
having either separate accounts for each entity in your tree, or using a field 
like Notes, Memo, or Description to add some sort of tag as part of the text, 
then filtering the report for that tag. (note, this is not official 
functionality of GnuCash, but it is possible to do)

Regards,
Adrien

> On Mar 10, 2020 w11d70, at 11:11 AM, Long  wrote:
> 
> Thank you for your help, i've searched some results on internet, it's seem
> like there are no ways to have CASH FLOW monthly report ? I think it's very
> helpful. Do you have any idea ?


___
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] GNC Equity and Retained Earnings not tracking together?

2020-03-10 Thread Christopher Lam
The right answer will be to submit the Transaction Report to the
accountant, have him/her calculate the Retained Earnings and Shareholder
Distribution for you, then you pay your shareholders via Assets:Bank/Cash
-> Liability:Shareholder (and later Liability:Shareholder ->
Expenses:Shareholder Dividends I guess?)

I also think you'd close the books to an Equity:Retained Earnings account
rather than Liability:Retained Earnings. I think untold surprises will
arise if closing books to Liability.

IMHO Balance Sheet's Retained Earnings seems designed to be Net Income
https://en.wikipedia.org/wiki/Net_income

That's all I know.

On Tue, 10 Mar 2020 at 15:29, Brian via gnucash-user <
gnucash-user@gnucash.org> wrote:

> > On Tue, 10 Mar 2020 at 01:02, Brian via gnucash-user <
> > gnucash-user@gnucash.org> wrote:
> >
> > > I'm wondering if GNUCash is actually calculating RETAINED EARNINGS
> > > properly.  Because after issuing a distribution to shareholder the
> > > Retaining Earning calculation increased by Net Income but did not
> > > decrease by Asset:Cash which was debited and credited to
> > > Equity:Shareholder Distribution.
> > >
> >
> > The calculation of Retained Earnings and Unrealized Gains in the
> > Balance Sheet is rather primitive, and has been as such since nearly
> > forever.
> >
> > Retained Earnings = sum total of income less expenses at the
> > balance-sheet date.
> > Unrealized Gains = sum total of (asset-liability) value, minus sum
> > total of (asset-liability) cost.
>
> Christopher, then I believe you are saying to get a proper "retained
> earnings", which recognizes the reduction of Assets:Cash and increase to
> Liability:Shareholder distribution, that one would need to properly
> close the books by moving income and expense to a Liability:Retained
> Earnings sub-account?
>
>
>
>
>
> ___
> 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] Any ways to have monthly cash flow report ?

2020-03-10 Thread Long
Hello,

I want to have a look for specific Asset Account (Expenses and Income). So i
thought about Cash Flow report. But it's only show for specific time, not
monthly ? 
Do you have any idea to have monthly expenses - income report for specific
asset account ?

Regards.




--
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] Income Statement for specific Asset Account ?

2020-03-10 Thread Long
Thank you for your help, i've searched some results on internet, it's seem
like there are no ways to have CASH FLOW monthly report ? I think it's very
helpful. Do you have any idea ?



--
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] GNC Equity and Retained Earnings not tracking together?

2020-03-10 Thread Brian via gnucash-user
> On Tue, 10 Mar 2020 at 01:02, Brian via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
> > I'm wondering if GNUCash is actually calculating RETAINED EARNINGS
> > properly.  Because after issuing a distribution to shareholder the
> > Retaining Earning calculation increased by Net Income but did not
> > decrease by Asset:Cash which was debited and credited to
> > Equity:Shareholder Distribution.
> >  
> 
> The calculation of Retained Earnings and Unrealized Gains in the
> Balance Sheet is rather primitive, and has been as such since nearly
> forever.
> 
> Retained Earnings = sum total of income less expenses at the
> balance-sheet date.
> Unrealized Gains = sum total of (asset-liability) value, minus sum
> total of (asset-liability) cost.

Christopher, then I believe you are saying to get a proper "retained
earnings", which recognizes the reduction of Assets:Cash and increase to
Liability:Shareholder distribution, that one would need to properly
close the books by moving income and expense to a Liability:Retained
Earnings sub-account?  





___
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] Income Statement for specific Asset Account ?

2020-03-10 Thread Michael or Penny Novack
You can select/exclude accounts when running the Income Statement 
report. HOWEVER, asset (and liability) accounts are not involved in an 
Income-Expense report. Why? Because (taking expense first) not concerned 
with whether an expense was paid for by a decrease in cash (from your 
wallet) or increase of  debt (put on your credit card).


It is possible what you want is a report on cash flow. The two reports 
are not the same.


Michael D Novack


On 3/10/2020 10:47 AM, Long wrote:

Hello,

I have one Asset Account for me, and 1 for my family. And i have my own
expenses and income, So there are any ways to know Expense vs Income for me
?
Example Account Structure :
Assets :
- A (Current Asset)
---Wallet
- B (Current Asset)
---Wallet
Expenses :
1
2
3
Income :
1
2
3

If it's not possible to track, can you advise some ideas to me ?



--
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.



--
There is no possibility of social justice on a dead planet except the equality 
of the grave.

___
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] GNC Equity and Retained Earnings not tracking together?

2020-03-10 Thread Michael or Penny Novack
This question MAY require delving into "accounting for corporations when 
using gnucash". It may be that for corporations, the usual process of 
not closing the books and having gnucash showing a VIRTUAL account 
"retained earnings" isn't going to work well for corporations << where 
dividends paid out of earnings and dividends representing a return of 
capital are treated differently >>


It has been far too many years (decades) since I looked at an 
"accounting for corporations" text. We need an accountant here, then 
first describe what is needed were it being done the old fashioned way 
(pen and ink on paper) and THEN seeing how we get gnucash to model that.


Michael D Novack


On 3/9/2020 9:44 PM, David Cousens wrote:

Brian,

Brian the Retained Earnings is a component of the total Equity of the
business that records what the operation of the business has contributed to
the Equity. When a distribution is paid it is paid out of Equity and if it
is debited to the Shareholder Distributions and credited to the Asset:Bank
account then it has decreased the Equity appropriately. If you were to also
debit it from Equity:Retained Earnings what is the other account for the
debit side of the transaction? You will have decreased the equity twice for
the one distribution to the shareholders and Retained Earnings will no
longer reflect the operational contribution to the Equity of the business.
The shareholder distribution is not part of the operational aspect of the
business but a part of its capital/financing structure.

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.



--
There is no possibility of social justice on a dead planet except the equality 
of the grave.

___
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] Income Statement for specific Asset Account ?

2020-03-10 Thread Long
Hello,

I have one Asset Account for me, and 1 for my family. And i have my own
expenses and income, So there are any ways to know Expense vs Income for me
?
Example Account Structure :
Assets :
- A (Current Asset)
---Wallet
- B (Current Asset)
---Wallet
Expenses :
1
2
3
Income :
1
2
3

If it's not possible to track, can you advise some ideas to me ?



--
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] GNC Equity and Retained Earnings not tracking together?

2020-03-10 Thread Christopher Lam
On Tue, 10 Mar 2020 at 01:02, Brian via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I'm wondering if GNUCash is actually calculating RETAINED EARNINGS
> properly.  Because after issuing a distribution to shareholder the
> Retaining Earning calculation increased by Net Income but did not
> decrease by Asset:Cash which was debited and credited to
> Equity:Shareholder Distribution.
>

The calculation of Retained Earnings and Unrealized Gains in the Balance
Sheet is rather primitive, and has been as such since nearly forever.

Retained Earnings = sum total of income less expenses at the balance-sheet
date.
Unrealized Gains = sum total of (asset-liability) value, minus sum total of
(asset-liability) cost.
___
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] Help Find Feature

2020-03-10 Thread Christopher Lam
On Tue, 10 Mar 2020 at 03:08, Gio Bacareza  wrote:

> PS The root of all this was the issue with gnucash importing multicurrency
> transactions with CSV. Would you have any idea if other imports eg QIF can
> handle multi-currency?
>

There's old code to handle multicurrency/stock QIF imports but no one knows
how/if/when it works anymore.
___
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] Wrong currency when recording a stock purchase

2020-03-10 Thread Nelson
Thank you Adrien. The currency of the stock account is indeed the currency of
the parent. The account hierarchy you are recommending is mandatory when
holding muti-currency stocks with the same broker.



--
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] GC 2.6.19 & GC 3.8

2020-03-10 Thread Frank H. Ellenberger
Hi,

Am 02.03.20 um 05:18 schrieb David Cousens:
> It will depend upon where your 2.6.19 version is installed to and where in
> the file heirarchy the flatpak installs to. Main problem will be if the
> libraries for both versions get installed to the same locations. I think
> flatpaks install under~/.local/share/flatpak/exports/share/applications

~/.local/share/flatpak/app/org.gnucash.GnuCash/current/active/files/
on my PC with Flatpak 1.6.2.

> for per usr  and 
> under /var/lib/flatpak/exports/share/applications for sytemwide
> installations. 
> 
> If 2.6.19 was installed with apt from the system repository it will likely
> be under /usr/local/{bin/share/lib/etc} where the components are installed
> in the appropriate directory from the set in {}.

again: /usr/{bin|share|lib ...} is for distribution provided and
/usr/local/* for self compiled programs.

> https://wiki.gnucash.org/wiki/Flatpak may contain more info.
> 
> David

Frank
___
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.