[GNC] transaction entries

[Carl Hofinga]

When I make transactions entries I enter 1) the date; 2) a reference number if 
applicable; 3) for the description column I enter a vendor or payee name such 
as Target or the payee's name; 4) the correct general ledger account number; 5) 
the debit or credit  $ amount. There can be splits also. A few days ago I 
encountered a problem. When I entered a previously used vendor like Target it 
automatically displays the previous entry for this vendor & in this case it was 
a split and the new entry is not. This means that I needed to enter only one 
account number for the charge. I am crediting or using a liability account for 
a specific credit card payable. But it would not let me delete parts of the 
split transaction down to one account. The latest upgrade has been made - I 
think it was 3.8. In the past, I have not had a problem deleting unneeded 
accounts for a specific account. To get around this problem I had to create a 
new vendor name for Target like Target-1.

Actually I would prefer to not have the previous entry display its account & 
debit or credit amounts when making an entry for a previously used vendor.

Is there a way to not to display the general ledger and dollar entries when 
making entries for a previously used  vendor. I do not have vendor account 
names set up as I do not write checks using GnuCash.

Thank you.
___
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] Question about new 5 fundamental budget categories

[Caleb Begly]

In the changelog for 3.8, it says:

 [gnc-budget-view.c] totals - 5 fundamental types
previous showed income/expense/transfers/totals budget totals, of uncertain
meaning. now shows income/expense/asset/liability/equity budget totals. The
5 lines also become sensitive to the global sign-reverse property.


Previously with 3.7 and previous, I would use the totals column to signal
if the combination of income, expense, and transfers balances (when totals
= 0, then it is balanced). However with the new categories, I don't see a
way to confirm balance besides manually adding them up. Is there some way
to enable an Imbalance summary row so it can show if the budget for that
period is balanced or not?
___
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] Setting up Gnucash for Household

[Malcolm Fitzgerald]

Hi David,

Thanks for providing a clear explanation of the options, it was very helpful 
for me.

Malcolm

> On 6/01/2020, at 9:32 PM, David Cousens  wrote:
> 
> Malcolm,
> 
> As others have said you really need professional advice. It will depend upon
> your local legislation and how your business affairs are structured whether
> you need to maintain separate books for your business activities or not.
> What follows is an attempt to outline how GnuCash might be used and does not
> constitute any advice that any of the suggestions are optimal for your
> situation or even legal to use in your juridiction. In accounting a person
> or business which has a separate legal existence (primarily responsibility
> for the debts of the business) is usually referred to as an entity. A single
> legal entity might however might have a number of separate business
> activities which might have an operational separation but no separate legal
> existence.
> 
> GnuCash has the flexibility to be able to setup treatmentof your finances
> either in one single book, two books for the business activities of yourself
> and your wife and another one for your and your wife's personal activities
> if that were suitable. The optimal strutcure will depend upon the taxation
> and business legislation you operate under and its record keeping and
> reporting requirements about which we cannot offer any advice.
> 
> If you did use a single set of books, it would likely be a good idea to have
> separate income, expense, asset, liability and equity accounts for your
> personal activities and each of the business activities/entities. In GnuCash
> the top level accounts are of type Asset, Liability, Equity, Income and
> Expense and any separation of accounts between your activity/entities would
> have to take place under each of the top level account. This would allow you
> to structure separate reports for each activity for example. 
> 
> One limitation to keep in mind is that the business features of GnuCash, if
> you have need to use them are not designed to support multiple entities in
> the one set of book,s which might make business reporting difficult.
> 
> If the books (files) were to be totally separate you would treat transfers
> of funds into the business accounts from your personal accounts as a
> decrease in your personal equity and an increase in your equity in the
> business activity with the reverse for transfers from the business account
> to your personal account with a transaction of the form
> 
> Asset:CurrentAssets:ChequeCr  $
> Equity:   Dr $
> 
> in your personal book/file (notated appropriately in the description and
> memo fields and another separate transaction
> 
> Asset:CurrentAssets:BusinessAccount   Dr $
> Equity:Owners contributions Cr $   
> 
> in the separate book/file for the business.  
> 
> If you were using a single set of books (file) a transfer of funds might
> look like
> 
> Asset:CurrentAssets:Cheque   Cr $
> Asset:CurrentAssets:BusinessAccount  Dr $
> Equity:Personal  Dr $
> Equity:OwnersContributionstoBusiness Cr $
> 
> which would be a single transaction with what are called 4 splits or entries
> in Gnucash to the four accounts.
> 
> Hope this gives you some ideas about how GnuCash might be used to discuss
> with your accountant.
> 
> 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.

___
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] Suggested source for LibOFX?

[Bennie Gibson]

    I'm a new GNUCash user and would like to get OFXDirect working.  
Wondering where most folks get LibOFX.  SourceForge seems the most 
"official" looking but want to feel more comfortable about the source of 
this library.


Thanks

___
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] Gnucash Reports - Comparative Income Statement

[Adrien Monteleone]

I can confirm that on 3.8, you can use the proper dates. I ran a test for those 
2 years prior to my last comment and it worked as expected.

As for YTD, you’d have to run 2 separate reports and then move to a spreadsheet.

There is a comparison transaction report floating around the list from a couple 
of years ago. It could compare any 2 or more periods of any definition (that I 
recall) for any set of accounts. I played with it when budgeting, but haven’t 
used it in some time. I think the code needs to be updated for 3.x. (some date 
function call issues if I remember)

I’ll try to dig it up and test it out again.

Finally, if you have a budget set up (it doesn’t have to be populated with 
budgeted amounts) then you can try the Budget Report as it has YTD facilities, 
but you’d still have to run the two periods separately and move to spreadsheet 
to see them together.

The traditional multi-column report might be of some utility but it has the 
drawback of really being two entirely separate reports in each ‘column’ 
complete with their own row headers so there is a lot of duplication of info 
and can look a bit messy. I’ve used it in the past before going to spreadsheet 
and then deleting the duplicate column of row headers for sanity while reading 
it.

Regards,
Adrien

> On Jan 6, 2020 w2d6, at 7:16 PM, Bill Dika  wrote:
> 
> michael d novack
> 
> Thanks for the reply. I agree with everything you said but I am not looking
> for presentation Financial Statements. I am looking to make quick year to
> year comparisons with the reporting facility in Gnucash. Having ten years
> of financial data, I would like to make quick comparisons of YTD (year to
> date) of this year with last year (for various years), without exporting
> and massaging the presentation.
> 
> But I think Adrien is on to something (see below).
> 
> adrien monteleone
> 
> Thanks for the replies.
> 
> the new (experimental) multi-column Income Statement in v3.8. That will get
>> your two periods lined up neatly.
> 
> 
> This is what I am looking for. Thank you. The "Options" dialog is a little
> off (to get an income comparison of the two years being January 1, 2018 to
> December 31, 2019, I must put in a start date of January 1, 2018
> (intuitive) but to get the correct income for 2019 I need to put in an end
> date of January 1, 2020 (not intuitive to me)). I do not need a variance
> column. Also, I am not sure how to get a YTD (year to date) comparison of
> this year to YTD for the same period last year (if you know how to get this
> from this dialog, I would be appreciate hearing it). In any case I now have
> something to work with and look forward to this coming out of experimental
> status.
> 
> Thanks to all.
> 
> Bill Dika
> 
> 


___
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] Gnucash Reports - Comparative Income Statement

[Christopher Lam]

On Tue, 7 Jan 2020, 9:18 am Bill Dika,  wrote:

>
> This is what I am looking for. Thank you. The "Options" dialog is a little
> off (to get an income comparison of the two years being January 1, 2018 to
> December 31, 2019, I must put in a start date of January 1, 2018
> (intuitive) but to get the correct income for 2019 I need to put in an end
> date of January 1, 2020 (not intuitive to me)).


I think this has been fixed in 3.8

I do not need a variance
> column. Also, I am not sure how to get a YTD (year to date) comparison of
> this year to YTD for the same period last year (if you know how to get this
> from this dialog, I would be appreciate hearing it).


Not possible with this report I'm afraid.
___
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] Gnucash Reports - Comparative Income Statement

[Bill Dika]

michael d novack

Thanks for the reply. I agree with everything you said but I am not looking
for presentation Financial Statements. I am looking to make quick year to
year comparisons with the reporting facility in Gnucash. Having ten years
of financial data, I would like to make quick comparisons of YTD (year to
date) of this year with last year (for various years), without exporting
and massaging the presentation.

But I think Adrien is on to something (see below).

adrien monteleone

Thanks for the replies.

the new (experimental) multi-column Income Statement in v3.8. That will get
> your two periods lined up neatly.


This is what I am looking for. Thank you. The "Options" dialog is a little
off (to get an income comparison of the two years being January 1, 2018 to
December 31, 2019, I must put in a start date of January 1, 2018
(intuitive) but to get the correct income for 2019 I need to put in an end
date of January 1, 2020 (not intuitive to me)). I do not need a variance
column. Also, I am not sure how to get a YTD (year to date) comparison of
this year to YTD for the same period last year (if you know how to get this
from this dialog, I would be appreciate hearing it). In any case I now have
something to work with and look forward to this coming out of experimental
status.

Thanks to all.

Bill Dika

On Mon, Jan 6, 2020 at 9:46 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 1/5/2020 1:46 PM, Bill Dika wrote:
> > What would it cost for someone to create a comparative income statement
> report comparing this period to the corresponding period last year?
> >
> > I am willing to pay if it is not too much. The report could be included
> in Gnucash and released under the GPL v3 or later.
> > If this is not the correct list to ask for this, please direct me to
> where I might find someone willing to prepare this.
> > Thanks.
> >
> > Bill Dika
> > ___
>
>
> It is the right place to ask, but let me first give the advice I
> received when I first took over as treasurer for a 501(c)3 << it is
> NORMAL for the "Statement of Revenue and Expenses"* of a non-profit to
> be presented that way, at least the annual one >>
>
> At the time a recently retired very senior systems analyst, able to at
> least read LISP (scheme is a LISP dialect) I asked the lawyer/accountant
> if I should code those special reports. He said "Don't bother Mike. Just
> run the raw reports, export them, and then bring that data in under
> control of your favorite full power editor. It's what any experienced
> accountant would choose to do. That's because you will STILL have
> editing to do" << add fixed text, add notations, deal with accounts not
> entirely corresponding in the two periods, deal with "pretty printing",
> etc. >> In other words, because STILL going to be doing editing, might
> as well do that in one place, and where you have the power of a real
> editor.
>
> Try looking at the annual statements of a non-profit or two and you will
> quickly see that this is what must have been done. That the report
> presented matches everything else (fonts, etc.) and not the direct
> output of some accounting software.
>
> Understand?  I am the sort of person who could have done this coding,
> but following this advice chose not to.,
>
> Michael D Novack
>
> * The "Income Statement" report -- that's what a non-profit calls the
> "Profit and Loss" statement (in gnucash, "Income Statement". But the
> same in parallel is wanted for the Balance Statement.
>
>
>
> ___
> 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] Setting up Gnucash for Household

[Richard Dawson]

I'm not an accountant by any means, so this might be bad advice. I will 
tell you how I handle my personal and business accounts in one Gnucash 
file.  I have the usual set of accounts, Equity, Assets, Cash, Income, 
Liabilities, and Opening Balance for my personal accounts.  These have 
the usual subaccounts for detailing transactions with in those 
categories.  For my Rental Business I have have another account with its 
subaccounts for Equity, Assets, Cash, Income, Liabilities, and Opening 
Balance.  All of this within one Gnucash file.  The business files are 
independent of the personal files, but it is easy to transfer amounts 
between them when that is appropriate.


Richard


___
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] Budget Flow Report - no column titles, & nothing in the help file

[briancady413--- via gnucash-user]

I've worked on a one-year budget in GNUCash 2.6.19, and now have made a budget 
flow report with two columns, but it has no column titles, nor is there 
explanation of the columns in the help files - There is only the words 'Budget 
Flow', under standard reports overview, beneath 'Budget Reports'.

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

Re: [GNC] Chaning left sidebar spacing

[Adrien Monteleone]

The GnuCash GTK3 wiki page will help: 
https://wiki.gnucash.org/wiki/GTK3#Visual_Styling

Report back if there is something there you need more info on.

Regards,
Adrien


> On Jan 6, 2020 w2d6, at 3:42 PM, AEG via gnucash-user 
>  wrote:
> 
> Adrien Monteleone-2 wrote
>> Alan,
>> 
>> You have to create the gtk-30.css file. It isn’t there by default.
>> 
>> Regards,
>> Adrien
> 
> Adrien,
> 
> Thank you for pointing that out. I'll try to find out how to do that but
> would be grateful for any advice/guidance towards the best route.
> 
> Regards,
> Alan
> 


___
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] Chaning left sidebar spacing

[AEG via gnucash-user]

Adrien Monteleone-2 wrote
> Alan,
> 
> You have to create the gtk-30.css file. It isn’t there by default.
> 
> Regards,
> Adrien

Adrien,

Thank you for pointing that out. I'll try to find out how to do that but
would be grateful for any advice/guidance towards the best route.

Regards,
Alan


>> On Jan 4, 2020 w1d4, at 5:33 PM, AEG via gnucash-user 

> gnucash-user@

>  wrote:
>> 
>> Colin Law wrote
>>> By comparing the heights of the register lines and the tabs I see that
>>> I get 9 tabs in the height of 14 register lines whereas the photo
>>> shows only about 6.5 tabs in 14 register lines.
>>> 
>>> Colin
>> 
>> I'm also seeing only 6.5 tabs in 14 register lines with Windows 10 and GC
>> version 3.5, whereas the tabs in version 2.6.21 were significantly
>> smaller
>> and more convenient to use.
>> 
>> I've looked at the possibility of editing the css settings as described
>> in
>> the GTK3 wiki page but don't appear to have the relevant files on my
>> computer (the css folder is empty).
>> 
>> Alan





--
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] Corrupt security information

[Bruno Acklin]

Yes, this did the trick!! Thanks for the great coaching, John!

I guess the takeaway is that the origin of bug 
https://bugs.gnucash.org/show_bug.cgi?id=797512 
 could be a double entry in 
the trading account.

I just found that I had other stocks with two or even three trading accounts; 
it seems that when I change the name of a stock, for instance when yahoo does 
so, eg from NESN.VX to NESN.SW, GnuCash creates another trading account, rather 
than renaming the existing one.

Now I am trying to find out why the lot scrubber sometime insists to create two 
identical Realized Gain/Loss entries..

Best regards,
Bruno

> On Jan 6, 2020, at 10:11 AM, John Ralls  wrote:
> 
> Bruno,
> 
> First delete the test transactions and the gain/loss transactions. Then 
> delete Trading:NASDAQ:INTC. Save.
> 
> You can try moving Trading:NYSE:INTC to Trading:NASDAQ:INTC (use Edit Account 
> and change the parent account to Trading:NASDAQ with the selector at the 
> bottom). While you're in the account editor check the commodity and make sure 
> that it's set to NASDAQ INTC and not NYSE INTC.
> 
> Try running the Lot scrubber. If the G/L transactions are created correctly 
> then try your test transactions.
> 
> If either fails you can quit GnuCash without saving to clear out the bad 
> transactions.
> 
> Regards,
> John Ralls
> 
>> On Jan 6, 2020, at 9:29 AM, Bruno Acklin  wrote:
>> 
>> Hi John,
>> 
>> Yes, a great feature if it worked fully, but.. (one of its flawed features 
>> is that one does not have control over when it generated Realized Gain/Loss 
>> entries.) 
>> 
>> Sorry to confuse you. The number of transactions does not tie: I have 5 
>> trades, which are reflected in trading/NYSE/INTC, plus 2 test trades I 
>> entered using the NASDAQ/INTC security with the previously described 
>> problem. Then the lot scrubber generated 5 Gain/Loss entries also tied to 
>> the NASDAQ/NYSE account, and apparently unbalanced (same amount in 
>> Trading/NASDAQ/INTC, Orphaned Gains and (negative in Trading/Currency/USD)).
>> Strangely, the initial purchase in the asset account against /NYSE/INTC is 
>> unbalanced and is reflected once in the Trading/NYSE/INTC and twice in the 
>> Trading/NASDAQ/INC account.. - all stuck in unbalanced.
>> 
>> Do you agree that I should delete one of these trading accounts? If I delete 
>> Trading/NYSE/INTC I probably loose my correct transactions (saved). If I 
>> delete the Trading/NASDAQ/INTC account can rename the Trading/NYSE/INTC to 
>> Trading/NASDAQ/INTC?
>> 
>> Best regards,
>> Bruno
>> 
>> 
>>> On Jan 5, 2020, at 8:31 PM, John Ralls  wrote:
>>> 
>>> Bruno,
>>> 
>>> Ugh, the lot scrubber. Another variable in the problem.
>>> 
>>> Now I'm confused about the two trading accounts because you say that you've 
>>> got 5 trades in the asset account and each trading account. Do you have 
>>> splits both INTC trading accounts for one transaction? What about 
>>> Trading:CURRENCY:USD?
>>> 
>>> Regards,
>>> John Ralls
>>> 
 On Jan 5, 2020, at 3:17 PM, Bruno Acklin  wrote:
 
 I don’t think I have more than one asset account for INTC, and none of the 
 trading accounts shows any transactions outside of the one I am using.
 I am pretty sure I did not create a 2nd asset INTC (and doubt Gnucash 
 would have let me), but I may have edited / moved it from NYSE to INTC in 
 the security editor (which answers my last question, I guess ;-).
 No worries, only about 5 trades in the asset account (and each trading 
 account); I am mostly worried about loosing 20 years of pricing history, 
 which is why I was looking for a way to export.
 
 The issue came up when I started using Actions/View lots for calculating 
 cap gains (working, but would need some work, such as an indication of the 
 purchase date or lot in the automated entry, or way to define/edit a new 
 lot, I think..)
 
 Best regards,
 Bruno
 
 
 
 
> On Jan 5, 2020, at 2:56 PM, John Ralls  wrote:
> 
> That's interesting. Do you have more than one INTC asset account, perhaps 
> with different brokers (and perhaps hidden on your Accounts page either 
> because you marked it hidden or have hide accounts with 0 balances turned 
> on)? When you realized that INTC trades on NASDAQ and not NYSE did you 
> edit the security or make a new one?
> 
> How many transactions are in each account?
> 
> Regards,
> John Ralls
> 
>> On Jan 5, 2020, at 2:34 PM, Bruno Acklin  wrote:
>> 
>> Thanks John,
>> 
>> I had a suspicion that this may be due to an ambiguous trading account: 
>> I had noticed that originally some transactions appeared under NYSE/INTC 
>> while my present security and prices are all under NASDAQ/INTC. There is 
>> no security defined under NYSE/INTC, but there is a trading account with 
>> that name (which has correct 

Re: [GNC] Corrupt security information

[John Ralls]

Bruno,

First delete the test transactions and the gain/loss transactions. Then delete 
Trading:NASDAQ:INTC. Save.

You can try moving Trading:NYSE:INTC to Trading:NASDAQ:INTC (use Edit Account 
and change the parent account to Trading:NASDAQ with the selector at the 
bottom). While you're in the account editor check the commodity and make sure 
that it's set to NASDAQ INTC and not NYSE INTC.

Try running the Lot scrubber. If the G/L transactions are created correctly 
then try your test transactions.

If either fails you can quit GnuCash without saving to clear out the bad 
transactions.

Regards,
John Ralls

> On Jan 6, 2020, at 9:29 AM, Bruno Acklin  wrote:
> 
> Hi John,
> 
> Yes, a great feature if it worked fully, but.. (one of its flawed features is 
> that one does not have control over when it generated Realized Gain/Loss 
> entries.) 
> 
> Sorry to confuse you. The number of transactions does not tie: I have 5 
> trades, which are reflected in trading/NYSE/INTC, plus 2 test trades I 
> entered using the NASDAQ/INTC security with the previously described problem. 
> Then the lot scrubber generated 5 Gain/Loss entries also tied to the 
> NASDAQ/NYSE account, and apparently unbalanced (same amount in 
> Trading/NASDAQ/INTC, Orphaned Gains and (negative in Trading/Currency/USD)).
> Strangely, the initial purchase in the asset account against /NYSE/INTC is 
> unbalanced and is reflected once in the Trading/NYSE/INTC and twice in the 
> Trading/NASDAQ/INC account.. - all stuck in unbalanced.
> 
> Do you agree that I should delete one of these trading accounts? If I delete 
> Trading/NYSE/INTC I probably loose my correct transactions (saved). If I 
> delete the Trading/NASDAQ/INTC account can rename the Trading/NYSE/INTC to 
> Trading/NASDAQ/INTC?
> 
> Best regards,
> Bruno
> 
> 
>> On Jan 5, 2020, at 8:31 PM, John Ralls  wrote:
>> 
>> Bruno,
>> 
>> Ugh, the lot scrubber. Another variable in the problem.
>> 
>> Now I'm confused about the two trading accounts because you say that you've 
>> got 5 trades in the asset account and each trading account. Do you have 
>> splits both INTC trading accounts for one transaction? What about 
>> Trading:CURRENCY:USD?
>> 
>> Regards,
>> John Ralls
>> 
>>> On Jan 5, 2020, at 3:17 PM, Bruno Acklin  wrote:
>>> 
>>> I don’t think I have more than one asset account for INTC, and none of the 
>>> trading accounts shows any transactions outside of the one I am using.
>>> I am pretty sure I did not create a 2nd asset INTC (and doubt Gnucash would 
>>> have let me), but I may have edited / moved it from NYSE to INTC in the 
>>> security editor (which answers my last question, I guess ;-).
>>> No worries, only about 5 trades in the asset account (and each trading 
>>> account); I am mostly worried about loosing 20 years of pricing history, 
>>> which is why I was looking for a way to export.
>>> 
>>> The issue came up when I started using Actions/View lots for calculating 
>>> cap gains (working, but would need some work, such as an indication of the 
>>> purchase date or lot in the automated entry, or way to define/edit a new 
>>> lot, I think..)
>>> 
>>> Best regards,
>>> Bruno
>>> 
>>> 
>>> 
>>> 
 On Jan 5, 2020, at 2:56 PM, John Ralls  wrote:
 
 That's interesting. Do you have more than one INTC asset account, perhaps 
 with different brokers (and perhaps hidden on your Accounts page either 
 because you marked it hidden or have hide accounts with 0 balances turned 
 on)? When you realized that INTC trades on NASDAQ and not NYSE did you 
 edit the security or make a new one?
 
 How many transactions are in each account?
 
 Regards,
 John Ralls
 
> On Jan 5, 2020, at 2:34 PM, Bruno Acklin  wrote:
> 
> Thanks John,
> 
> I had a suspicion that this may be due to an ambiguous trading account: I 
> had noticed that originally some transactions appeared under NYSE/INTC 
> while my present security and prices are all under NASDAQ/INTC. There is 
> no security defined under NYSE/INTC, but there is a trading account with 
> that name (which has correct transactions and behaves normally), and one 
> under Trading/NASDAQ/INTC with phony transactions ($number in the 
> increase column instead of INTC shares), which is also caught in a 
> rebalance loop.
> 
> Should I just delete one of the two trading accounts, and which one? I 
> lean towards the NASDAQ one with the phony entries and then try to move 
> INTC from NYSE to NASDAQ - how?
> 
> Best regards,
> Bruno
> 
> 
> 
> 
> 
>> On Jan 5, 2020, at 11:22 AM, John Ralls  wrote:
>> 
>> Bruno,
>> 
>> Don't do anything drastic yet, but everything is pretty independent. You 
>> could change the name on the old INTC and create a new INTC security and 
>> GnuCash will happily use your INTC prices for pricing the new security. 
>> They're linked by the security name 

Re: [GNC] Corrupt security information

[Bruno Acklin]

Hi John,

Yes, a great feature if it worked fully, but.. (one of its flawed features is 
that one does not have control over when it generated Realized Gain/Loss 
entries.) 

Sorry to confuse you. The number of transactions does not tie: I have 5 trades, 
which are reflected in trading/NYSE/INTC, plus 2 test trades I entered using 
the NASDAQ/INTC security with the previously described problem. Then the lot 
scrubber generated 5 Gain/Loss entries also tied to the NASDAQ/NYSE account, 
and apparently unbalanced (same amount in Trading/NASDAQ/INTC, Orphaned Gains 
and (negative in Trading/Currency/USD)).
Strangely, the initial purchase in the asset account against /NYSE/INTC is 
unbalanced and is reflected once in the Trading/NYSE/INTC and twice in the 
Trading/NASDAQ/INC account.. - all stuck in unbalanced.

Do you agree that I should delete one of these trading accounts? If I delete 
Trading/NYSE/INTC I probably loose my correct transactions (saved). If I delete 
the Trading/NASDAQ/INTC account can rename the Trading/NYSE/INTC to 
Trading/NASDAQ/INTC?

Best regards,
Bruno


> On Jan 5, 2020, at 8:31 PM, John Ralls  wrote:
> 
> Bruno,
> 
> Ugh, the lot scrubber. Another variable in the problem.
> 
> Now I'm confused about the two trading accounts because you say that you've 
> got 5 trades in the asset account and each trading account. Do you have 
> splits both INTC trading accounts for one transaction? What about 
> Trading:CURRENCY:USD?
> 
> Regards,
> John Ralls
> 
>> On Jan 5, 2020, at 3:17 PM, Bruno Acklin  wrote:
>> 
>> I don’t think I have more than one asset account for INTC, and none of the 
>> trading accounts shows any transactions outside of the one I am using.
>> I am pretty sure I did not create a 2nd asset INTC (and doubt Gnucash would 
>> have let me), but I may have edited / moved it from NYSE to INTC in the 
>> security editor (which answers my last question, I guess ;-).
>> No worries, only about 5 trades in the asset account (and each trading 
>> account); I am mostly worried about loosing 20 years of pricing history, 
>> which is why I was looking for a way to export.
>> 
>> The issue came up when I started using Actions/View lots for calculating cap 
>> gains (working, but would need some work, such as an indication of the 
>> purchase date or lot in the automated entry, or way to define/edit a new 
>> lot, I think..)
>> 
>> Best regards,
>> Bruno
>> 
>> 
>> 
>> 
>>> On Jan 5, 2020, at 2:56 PM, John Ralls  wrote:
>>> 
>>> That's interesting. Do you have more than one INTC asset account, perhaps 
>>> with different brokers (and perhaps hidden on your Accounts page either 
>>> because you marked it hidden or have hide accounts with 0 balances turned 
>>> on)? When you realized that INTC trades on NASDAQ and not NYSE did you edit 
>>> the security or make a new one?
>>> 
>>> How many transactions are in each account?
>>> 
>>> Regards,
>>> John Ralls
>>> 
 On Jan 5, 2020, at 2:34 PM, Bruno Acklin  wrote:
 
 Thanks John,
 
 I had a suspicion that this may be due to an ambiguous trading account: I 
 had noticed that originally some transactions appeared under NYSE/INTC 
 while my present security and prices are all under NASDAQ/INTC. There is 
 no security defined under NYSE/INTC, but there is a trading account with 
 that name (which has correct transactions and behaves normally), and one 
 under Trading/NASDAQ/INTC with phony transactions ($number in the increase 
 column instead of INTC shares), which is also caught in a rebalance loop.
 
 Should I just delete one of the two trading accounts, and which one? I 
 lean towards the NASDAQ one with the phony entries and then try to move 
 INTC from NYSE to NASDAQ - how?
 
 Best regards,
 Bruno
 
 
 
 
 
> On Jan 5, 2020, at 11:22 AM, John Ralls  wrote:
> 
> Bruno,
> 
> Don't do anything drastic yet, but everything is pretty independent. You 
> could change the name on the old INTC and create a new INTC security and 
> GnuCash will happily use your INTC prices for pricing the new security. 
> They're linked by the security name and namespace, not by GUID. 
> Unfortunately GnuCash won't let you reassign the account but you can 
> create a new one and transfer the balance with a transaction.
> 
> Regards,
> John Ralls
> 
>> On Jan 5, 2020, at 9:37 AM, Bruno Acklin  wrote:
>> 
>> Hi John,
>> 
>> Thanks for the impressively quick reply - and yes, I agree this looks 
>> like the same problem!
>> Unfortunately there does not seem to be another fix than recreating the 
>> stock, account and transactions..
>> 
>> Do you know of a way I might preserve the 20 years of price data I have 
>> on that stock? I saw a suggestion to create a suitable report and 
>> reimport the resulting file, but I dd not see any report that would 
>> allow me to save price 

Re: [GNC] Opening Balance on Reports

[Evenmoreconfused]

Wow, that's great.

Talk about fast turn-around!

Thank you very much,
Paul

Christopher Lam wrote
> Good news; future releases where "Running Balance" is enabled, and the
> sorting/grouping options include account, *will* now print the balance
> brought forward. Zero-amount transaction hack isn't needed anymore.





--
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] Gnucash Reports - Comparative Income Statement

[Michael or Penny Novack]

On 1/5/2020 1:46 PM, Bill Dika wrote:

What would it cost for someone to create a comparative income statement report 
comparing this period to the corresponding period last year?

I am willing to pay if it is not too much. The report could be included in 
Gnucash and released under the GPL v3 or later.
If this is not the correct list to ask for this, please direct me to where I 
might find someone willing to prepare this.
Thanks.

Bill Dika
___



It is the right place to ask, but let me first give the advice I 
received when I first took over as treasurer for a 501(c)3 << it is 
NORMAL for the "Statement of Revenue and Expenses"* of a non-profit to 
be presented that way, at least the annual one >>


At the time a recently retired very senior systems analyst, able to at 
least read LISP (scheme is a LISP dialect) I asked the lawyer/accountant 
if I should code those special reports. He said "Don't bother Mike. Just 
run the raw reports, export them, and then bring that data in under 
control of your favorite full power editor. It's what any experienced 
accountant would choose to do. That's because you will STILL have 
editing to do" << add fixed text, add notations, deal with accounts not 
entirely corresponding in the two periods, deal with "pretty printing", 
etc. >> In other words, because STILL going to be doing editing, might 
as well do that in one place, and where you have the power of a real 
editor.


Try looking at the annual statements of a non-profit or two and you will 
quickly see that this is what must have been done. That the report 
presented matches everything else (fonts, etc.) and not the direct 
output of some accounting software.


Understand?  I am the sort of person who could have done this coding, 
but following this advice chose not to.,


Michael D Novack

* The "Income Statement" report -- that's what a non-profit calls the 
"Profit and Loss" statement (in gnucash, "Income Statement". But the 
same in parallel is wanted for the Balance Statement.




___
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] Opening Balance on Reports

[Christopher Lam]

Good news; future releases where "Running Balance" is enabled, and the
sorting/grouping options include account, *will* now print the balance
brought forward. Zero-amount transaction hack isn't needed anymore.

On Mon, 6 Jan 2020 at 05:01, Christopher Lam 
wrote:

> Wouldn't seem right to offer disable zero in the transaction report. But a
> "running balance brought forward" as shown is a worth while addition that
> can be added imminently.
>
> So there won't be any need for the zero-amount transaction hack.
>
> On Mon, 6 Jan 2020, 10:47 am Adrien Monteleone, <
> adrien.montele...@lusfiber.net> wrote:
>
>> Bummer.
>>
>> Regards,
>> Adrien
>>
>> > On Jan 5, 2020 w2d5, at 5:35 PM, Christopher Lam <
>> christopher@gmail.com> wrote:
>> >
>> > A disable-zero option does not feature in the transaction report though.
>> >
>>
>>
>> ___
>> 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] Gnucash Reports - Comparative Income Statement

[Adrien Monteleone]

Even simpler - I forgot about the new (experimental) multi-column Income 
Statement in v3.8.

That will get your two periods lined up neatly. Then you just need to move that 
to a spreadsheet and add your variance column & formulas.

Filing an RFE to add the variance column to the report would get you what you 
are looking for right out of the box.

Regards,
Adrien

> On Jan 6, 2020 w2d6, at 3:44 AM, Adrien Monteleone 
>  wrote:
> 
> While it is a small amount of work, you can do this yourself.
> 
> Run each period’s report.
> 
> Save/open or copy/paste the resulting reports into a spreadsheet.
> 
> Add percentage/variance columns as desired with formulas.
> 
> To make your life easier, you should use the same set of accounts for each 
> period, and do not hide zero balanced accounts. That will make easy work of 
> placing the two periods side by side.
> 
> Regards,
> Adrien
> 
>> On Jan 5, 2020 w2d5, at 12:46 PM, Bill Dika  wrote:
>> 
>> What would it cost for someone to create a comparative income statement 
>> report comparing this period to the corresponding period last year?
>> 
>> I am willing to pay if it is not too much. The report could be included in 
>> Gnucash and released under the GPL v3 or later.
>> 
>> If this is not the correct list to ask for this, please direct me to where I 
>> might find someone willing to prepare this.
>> 
>> Thanks.
>> 
>> Bill Dika


___
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] Gnucash Reports - Comparative Income Statement

[Adrien Monteleone]

While it is a small amount of work, you can do this yourself.

Run each period’s report.

Save/open or copy/paste the resulting reports into a spreadsheet.

Add percentage/variance columns as desired with formulas.

To make your life easier, you should use the same set of accounts for each 
period, and do not hide zero balanced accounts. That will make easy work of 
placing the two periods side by side.

Regards,
Adrien

> On Jan 5, 2020 w2d5, at 12:46 PM, Bill Dika  wrote:
> 
> What would it cost for someone to create a comparative income statement 
> report comparing this period to the corresponding period last year?
> 
> I am willing to pay if it is not too much. The report could be included in 
> Gnucash and released under the GPL v3 or later.
> 
> If this is not the correct list to ask for this, please direct me to where I 
> might find someone willing to prepare this.
> 
> Thanks.
> 
> Bill Dika

___
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] Gnucash Reports - Comparative Income Statement

[Bill Dika]

What would it cost for someone to create a comparative income statement report 
comparing this period to the corresponding period last year?

I am willing to pay if it is not too much. The report could be included in 
Gnucash and released under the GPL v3 or later.

If this is not the correct list to ask for this, please direct me to where I 
might find someone willing to prepare this.

Thanks.

Bill Dika
___
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] Setting up Gnucash for Household

[David Cousens]

Malcolm,

As others have said you really need professional advice. It will depend upon
your local legislation and how your business affairs are structured whether
you need to maintain separate books for your business activities or not.
What follows is an attempt to outline how GnuCash might be used and does not
constitute any advice that any of the suggestions are optimal for your
situation or even legal to use in your juridiction. In accounting a person
or business which has a separate legal existence (primarily responsibility
for the debts of the business) is usually referred to as an entity. A single
legal entity might however might have a number of separate business
activities which might have an operational separation but no separate legal
existence.

GnuCash has the flexibility to be able to setup treatmentof your finances
either in one single book, two books for the business activities of yourself
and your wife and another one for your and your wife's personal activities
if that were suitable. The optimal strutcure will depend upon the taxation
and business legislation you operate under and its record keeping and
reporting requirements about which we cannot offer any advice.

If you did use a single set of books, it would likely be a good idea to have
separate income, expense, asset, liability and equity accounts for your
personal activities and each of the business activities/entities. In GnuCash
the top level accounts are of type Asset, Liability, Equity, Income and
Expense and any separation of accounts between your activity/entities would
have to take place under each of the top level account. This would allow you
to structure separate reports for each activity for example. 

One limitation to keep in mind is that the business features of GnuCash, if
you have need to use them are not designed to support multiple entities in
the one set of book,s which might make business reporting difficult.

If the books (files) were to be totally separate you would treat transfers
of funds into the business accounts from your personal accounts as a
decrease in your personal equity and an increase in your equity in the
business activity with the reverse for transfers from the business account
to your personal account with a transaction of the form

Asset:CurrentAssets:ChequeCr  $
Equity:   Dr $

in your personal book/file (notated appropriately in the description and
memo fields and another separate transaction

Asset:CurrentAssets:BusinessAccount   Dr $
Equity:Owners contributions Cr $   

in the separate book/file for the business.  

If you were using a single set of books (file) a transfer of funds might
look like

Asset:CurrentAssets:Cheque   Cr $
Asset:CurrentAssets:BusinessAccount  Dr $
Equity:Personal  Dr $
Equity:OwnersContributionstoBusiness Cr $

which would be a single transaction with what are called 4 splits or entries
in Gnucash to the four accounts.

Hope this gives you some ideas about how GnuCash might be used to discuss
with your accountant.

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.