Re: [GNC] Auto fill repeat transaction

[Liz Dodd]

On Thu, 3 Sep 2020 21:16:49 -0400
Derek Zehr  wrote:

> GnuCash has the neat feature of duplicating a transaction when you
> copy the description. What's the best way to update/change the
> amount? Right now I edit the Debit, then tab to the credit and type
> in the amount again. If I forget that step the amount is put into an
> Orphan/Imbalance account. Any way to make it update the second column
> automatically, or at least to not automatically put it in the
> Imbalance account?
> 
> Thanks,
> 
> Derek
> 

Our advice is not to use the  key. Just keep using the  key.

Liz
___
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] Auto fill repeat transaction

[David G Hamblen]

If you enter amounts in Basic Ledger view, rather than Auto-Split, it 
will change both the debit and credit automatically (at least if there 
are only 2 splits).  But you then have to go into Auto-split to see if 
it worked.


On 9/4/20 6:46 AM, Liz Dodd wrote:

On Thu, 3 Sep 2020 21:16:49 -0400
Derek Zehr  wrote:


GnuCash has the neat feature of duplicating a transaction when you
copy the description. What's the best way to update/change the
amount? Right now I edit the Debit, then tab to the credit and type
in the amount again. If I forget that step the amount is put into an
Orphan/Imbalance account. Any way to make it update the second column
automatically, or at least to not automatically put it in the
Imbalance account?

Thanks,

Derek


Our advice is not to use the  key. Just keep using the  key.

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


--
dhamb...@afrinc.com
home phone (207) 633-4342
Cell Phone (207) 350-0440

___
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] Import quicken

[PhilipChaban]

What steps to go thru for a Quicken QIF file import to Gnucash

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

Re: [GNC] Import quicken

[D. via gnucash-user]

Hello, 

Reading the available help is a great way to start. 

Start with: 
https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_importing.html
Next: https://wiki.gnucash.org/wiki/Quicken_Migration




 Original Message 
From: PhilipChaban 
Sent: Thu Sep 03 08:57:11 EDT 2020
To: gnucash-user@gnucash.org
Subject: [GNC] Import quicken

What steps to go thru for a Quicken QIF file import to Gnucash

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

___
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] Asset accounts: cost, or value?

[Michael or Penny Novack]

On 9/3/2020 7:14 PM, David Cousens wrote:

Marcus

As a number have people have pointed out you may need to keep the cost basis
of your house separate from any adjustments for the estimate of the current
value you may apply to calculate your estimated current net worth. You can
have your cake and eat it too in this case.


The purpose of accounting is to be able to supply information.

There are certain conditions where it might be important/useful to have 
information that would NOT be provided by your standard set of books. Or 
provided only with greatest difficulty (and still have the books useful 
for normal purposes).


The solution is multiple sets of books, your "real" set of books (you'll 
need for taxes, etc.) and then one or more "virtual" sets of books that 
provide information on different basis. I have given in the past as an 
example the books I keep for our solar system as if it were a separate 
entity that "borrowed" money from us as its capital and was paying off 
that loan by the virtual transfers that exist between it and us.


But real estate might be another example. It might be a major financial 
activity intended to build net worth, buying a residence, fixing it up, 
selling it and then getting another more valuable, repeat. (this is 
taking advantage of the special tax rules applied to gains from primary 
residence) You might want something that tracked your progress toward 
that wealth building goal. It  might be a similar situation if a large 
percentage of net worth was in things that had significant  conditional 
components.


What I am saying is don't try to do these things within your 
main/regular books but that doing them outside of those books does NOT 
mean has to be done outside of gnucash.


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 4.1 Make Fail - MX-LINUX (Debian Buster)

[John Ralls]

Please remember to copy the list on all replies.

If you don't know about pinning you didn't do it, and I suppose you didn't 
build boost yourself either. That suggests that the issue is with your distro, 
so go to their support channel and raise the issue with them.

You haven't said what distro you're using so we can't really help you with the 
details of rolling back ICU to version 63; another reason for ensuring that you 
copy the list is that there are others there who know more than I do about the 
details of managing any of them.

Regards,
John Ralls

> On Sep 4, 2020, at 9:30 AM, Mike Commissaris  
> wrote:
> 
> Thanks John
> I am quite new to linux but have a feel for what you are saying. I saw hints 
> of this conflict while working on this the last couple of days. ICU and boost 
> are new unexplored areas. Is there a workaround for this? Can you point me to 
> info for pinning to ICU63?
> Thank you so much.
> 
> On Thu, Sep 3, 2020 at 8:55 PM John Ralls  wrote:
> 
> 
> > On Sep 3, 2020, at 7:45 PM, Mike Commissaris  
> > wrote:
> > 
> > Trying to build 4.1 but cannot finish. Hope someone can help. All
> > dependencies seem to be met. Hope someone can help.
> 
> [SNIP]
> 
> > 
> > gnucash/CMakeFiles/gnucash.dir/gnucash-gresources.c.o
> > [ 72%] Linking CXX executable ../bin/gnucash
> > /usr/bin/ld: warning: libicudata.so.63, needed by
> > /usr/lib/x86_64-linux-gnu/libboost_regex.so, may conflict with
> > libicudata.so.67
> > /usr/bin/ld: warning: libicui18n.so.63, needed by
> > /usr/lib/x86_64-linux-gnu/libboost_regex.so, may conflict with
> > libicui18n.so.67
> > /usr/bin/ld: warning: libicuuc.so.63, needed by
> > /usr/lib/x86_64-linux-gnu/libboost_regex.so, may conflict with
> > libicuuc.so.67
> > /usr/bin/ld: ../lib/gnucash/libgnc-csv-import.so: undefined reference to
> > `boost::re_detail_106700::icu_regex_traits_implementation::do_transform(int
> > const*, int const*, icu_67::Collator const*) const'
> > collect2: error: ld returned 1 exit status
> > make[2]: *** [gnucash/CMakeFiles/gnucash.dir/build.make:183: bin/gnucash]
> > Error 1
> > make[1]: *** [CMakeFiles/Makefile2:6942:
> > gnucash/CMakeFiles/gnucash.dir/all] Error 2
> > make: *** [Makefile:163: all] Error 2
> > 
> 
> ICU versions their libraries so that if you've compiled something with ICUX 
> you can't later link it with ICUY. If you built Boost yourself you just need 
> to clean and rebuild it so that it links with the new version of ICU. If not 
> first make sure that you didn't pin the boost version; if you did either 
> remove the pin or roll ICU back to ICU63 and  pin it too. If not then the 
> Boost packager for your distro needs a kick to get a recompiled package 
> linked with the right ICU version.
> 
> Regards,
> John Ralls
> 
> 
> 
> -- 
> Mike

___
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] How to add investment accounts to existing gnucash file

[Default User]

Hi!

I am using gnucash 3.10, up to date.

I have a file with existing accounts in it, but no investment accounts.

Is there a simple way to add investment accounts without starting a new
file, or overwriting the existing one, and thus losing my existing accounts
(and their data)?
___
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] How to add investment accounts to existing gnucash file

[David Carlson]

Funny you should ask.  Chapter 9 of the user guide was written just for you
https://code.gnucash.org/docs/C/gnucash-guide/invest_accounts1.html

On Fri, Sep 4, 2020 at 8:37 PM Default User 
wrote:

> Hi!
>
> I am using gnucash 3.10, up to date.
>
> I have a file with existing accounts in it, but no investment accounts.
>
> Is there a simple way to add investment accounts without starting a new
> file, or overwriting the existing one, and thus losing my existing accounts
> (and their data)?
> ___
> 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.
>


-- 
David Carlson
___
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] How to add investment accounts to existing gnucash file

[Default User]

On Fri, Sep 4, 2020, 22:03 David Carlson 
wrote:

> Funny you should ask.  Chapter 9 of the user guide was written just for you
> https://code.gnucash.org/docs/C/gnucash-guide/invest_accounts1.html
>
> On Fri, Sep 4, 2020 at 8:37 PM Default User 
> wrote:
>
>> Hi!
>>
>> I am using gnucash 3.10, up to date.
>>
>> I have a file with existing accounts in it, but no investment accounts.
>>
>> Is there a simple way to add investment accounts without starting a new
>> file, or overwriting the existing one, and thus losing my existing
>> accounts
>> (and their data)?
>> ___
>> 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.
>>
>
>
> --
> David Carlson
>



Hi, David.

Thanks for the reply.

I have of course read about using the New Account Heirarchy Setup to add
the investment accounts.

But I thought it would be a great idea to ask first if my existing data
would be lost.

As any carpenter will tell you - "Measure twice, cut once!"
___
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] How to add investment accounts to existing gnucash file

[David Carlson]

Along your line of thinking, it is also recommended that you try major
changes with a disposable copy of your data file, keeping a backup if you
don't like the results.  Sometimes that may mean running two copies in
parallel for a period of time.
Good luck!

On Fri, Sep 4, 2020 at 9:27 PM Default User 
wrote:

> On Fri, Sep 4, 2020, 22:03 David Carlson 
> wrote:
>
> > Funny you should ask.  Chapter 9 of the user guide was written just for
> you
> > https://code.gnucash.org/docs/C/gnucash-guide/invest_accounts1.html
> >
> > On Fri, Sep 4, 2020 at 8:37 PM Default User 
> > wrote:
> >
> >> Hi!
> >>
> >> I am using gnucash 3.10, up to date.
> >>
> >> I have a file with existing accounts in it, but no investment accounts.
> >>
> >> Is there a simple way to add investment accounts without starting a new
> >> file, or overwriting the existing one, and thus losing my existing
> >> accounts
> >> (and their data)?
> >> ___
> >> 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.
> >>
> >
> >
> > --
> > David Carlson
> >
>
>
>
> Hi, David.
>
> Thanks for the reply.
>
> I have of course read about using the New Account Heirarchy Setup to add
> the investment accounts.
>
> But I thought it would be a great idea to ask first if my existing data
> would be lost.
>
> As any carpenter will tell you - "Measure twice, cut once!"
> ___
> 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.
>


-- 
David Carlson
___
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] How to add investment accounts to existing gnucash file

[Adrien Monteleone]

If the Guide wasn't clear, perhaps there is room for improvement, but 
that setup wizard is just to get you started. You can add and remove 
accounts all you want after the fact. (with some caveats if removing 
accounts that contain transactions)


You can even skip that new hierarchy setup entirely and create all of 
your accounts from scratch.


GnuCash would be a in a sad state indeed if adding an account after the 
initial setup destroyed data!


You don't have to use the wizard, just click the 'New' button on the 
toolbar when viewing the Accounts tab. Then follow the examples in the 
Guide.


Regards,
Adrien

On 9/4/20 9:25 PM, Default User wrote:


Hi, David.

Thanks for the reply.

I have of course read about using the New Account Heirarchy Setup to add
the investment accounts.

But I thought it would be a great idea to ask first if my existing data
would be lost.

As any carpenter will tell you - "Measure twice, cut once!"


___
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] Using the advanced portfolio report for mutual fund income

[pobox . deva]

Alister,

I had a similar problem when I recorded multiple stock buys in a single 
transaction covering over a dozen splits to account for purchases in different 
stock accounts along with its attendant brokerage and statutory levies. 
Advanced portfolio report would show incorrect brokerage amounts in that case.

The way I got around it was to create a dummy asset account (called $Cash in my 
case, but you can call it "Broker" or "Suspense” or “Staging” account, etc.). 
This is a dummy asset account that acts as a staging account - a sort of a 
bridge between fund/stock accounts and your bank account. This account is of 
simple type Asset (not Mutual Fund or Stock). And it can reside under the main 
“Investments” asset account. For example -

Assets:Investments:$Cash
Assets:Investments:Mutual Fund:Fund1
Assets:Investments:Mutual Fund:Fund2
.
.
. and so on...
Assets:Investments:Stocks:Stock1
Assets:Investments:Stocks:Stock2
.
.
. and so on...

The idea is, $Cash will always be a zero balance account after your record all 
your transactions.

With this structure in place, you can record multiple distributions from your 
fund house as if they were single distributions on each fund (as you stated in 
example 1), but instead of depositing your bank account, you would deposit your 
$Cash staging account instead. After recording your $75 distribution from fund 
1 and $25 distribution from fund 2 in the respective fund accounts, you would 
now have a balance of $100 in your $Cash (staging) account.

Now from your $Cash account, record a single transaction to move $100 from it 
to your bank account. This will bring your $Cash account back to 0.

$Cash account will not be visible if you have your settings to hide zero 
balance accounts, so you have to change that setting for you to use $Cash 
account every time.

Cheers,
Deva

> On 04-Sep-2020, at 9:30 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> Date: Fri, 4 Sep 2020 15:02:55 +1000
> From: Alister Briggs mailto:aliste...@gmail.com>>
> To: gnucash-user@gnucash.org 
> Subject: [GNC] Using the advanced portfolio report for mutual fund
>   income
> Message-ID: <03a772fd-0aac-e623-69b0-ffe51c387...@gmail.com 
> >
> Content-Type: text/plain; charset=utf-8; format=flowed
> 
> Can anybody help me work around a problem using the Advanced Portfolio 
> Report to report income on mutual funds where a single payment is made 
> for multiple funds? The Advanced Portfolio report requires atransaction 
> split to include a dummy transaction of zero value as shown below:
> 
> Scenario 1 - A single distribution payment per fund
> 
> Direct Credit CFS Distribution
> 
>   
> 
>   
> 
>   
> 
> 100
> 
>   
> 
> 100
> 
>   
> 
> Assets: Bank: CBA
> 
>   
> 
> 100
> 
>   
> 
>   
> 
>   
> 
> Income: Mutual Funds: CFS: Fund1
> 
>   
> 
>   
> 
> 100
> 
>   
> 
>   
> 
> Assets: Investments: Fund managers: CFS: Fund1
> 
>   
> 
> 0
> 
>   
> 
> 0
> 
>   
> 
>   
> 
>   
> 
>   
> 
>   
> 
> In this situation the Advanced Portfolio Report correctly reports the 
> income for Fund1 as $100.
> 
> Where more than one fund is paid the split becomes more complicated:
> 
> 
> Scenario 2 - A single distribution payment for two funds
> 
> Direct Credit CFS Distribution
> 
>   
> 
>   
> 
>   
> 
> 100
> 
>   
> 
> 100
> 
>   
> 
> Assets: Bank: CBA
> 
>   
> 
> 100
> 
>   
> 
>   
> 
>   
> 
> Income: Mutual Funds: CFS: Fund1
> 
>   
> 
>   
> 
> 75
> 
>   
> 
>   
> 
> Assets: Investments: Fund managers: CFS: Fund1
> 
>   
> 
> 0
> 
>   
> 
> 0
> 
>   
> 
>   
> 
> Income: Mutual Funds: CFS: Fund2
> 
>   
> 
>   
> 
> 25
> 
>   
> 
>   
> 
> Assets: Investments: Fund managers: CFS: Fund2
> 
>   
> 
> 0
> 
>   
> 
> 0
> 
>   
> 
> In this situation the Advanced Portfolio Report incorrectly reports the 
> income for both Fund1 and Fund2 as $100. How do I correct this so the 
> result for Fund1 is $75 and Fund2 is $25?
> 
> I am using GnuCash 4.1 on Windows 10 and fairly new user.
> 
> 
> Thank you for your efforts
> 
> Alister
> 

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