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

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

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

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

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

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

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

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

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

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

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

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

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"

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

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

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 >

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

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

[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:

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

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

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

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

[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

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 >

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

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

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