Re: [GNC] Consolidation of family member accounts

[Paras Desai]

Hello Stan

Thanks for your response.

As I have replied to Liz and addressing your valid point, i am maintaining 
three separate books for each one of us, independent to each other. And that is 
why I raised a query how I can combine or consolidate three books to create one 
virtual book which I would call a family book.

Your and Liz point is absolutely correct and fortunately I am following the 
same.

Thanks a lot

With my best regards

Paras




Get Outlook for Android

From: Stan Brown 
Sent: Monday, August 14, 2023 9:04:48 AM
To: gnucash-user@gnucash.org 
Cc: Paras Desai 
Subject: Re: [GNC] Consolidation of family member accounts

On 2023-08-13 20:16, Paras Desai wrote:
> Your idea of debiting equity is good. May need to create a sub account of 
> equity  specifically to capture related party transaction (as they call in 
> legal parlance ).

Well, that's one possibility. Another would be to have a placeholder
account, "Family Equity", with three subaccounts for the three of you.
(No transactions to a placeholder account can be made directly.
Transactions are always made to a subaccount. In reports, you can set
placeholder accounts to have value equal to the total of their
subaccount values.)

Please understand, however, that your question is not really a question
about GnuCash. GC is just the old pen-and-ink accounting translated to
computer files. The question of how to structure a transaction has the
same answer in GC as it would have if you were making pen-and-ink
transactions in one of those old leatherbound journals.

I didn't see you respond to the person who suggested that you should
perhaps have a separate book for each of the three of you. As that
person suggested, if you have everything in one book, when your son
leaves to establish his own household, it may be significant work to
separate his affairs for yours. The same is true if you and your wife
should ever establish separate households, or if one of you should
predecease the other.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com/
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Consolidation of family member accounts

[Paras Desai]

Hello Liz

Thanks for your point. It is absolutely correct and relevant.

As such I am maintaining three separate books for me, my wife and son 
independent of each other. And that is why the question came up, how do I 
consolidate three separate accounts or books to have a report as what is 
happening at family level.

When he goes his own way, once he completes his studies, he can. Bring his 
account and his NetWorth both. And when that happens, my family NetWorth will 
be mine and my wife's combined ( provided we will together, which is more 
likely than not )

With my best regards

Paras

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

[GNC] Consolidation of family member accounts

[Paras Desai]

Hello Flywire

Thanks for your option. Tagged report is an interesting feature to add. I can 
certainly tag transactions, had I been using same books for all family members 
to generate report. But I am maintaining three separate books.

However, I have a different user case in my mind, with your report.

Thank you

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

[GNC] Consolidation of family member accounts

[Paras Desai]

Hello Micheal

Thanks a lot for your kind reply.
Yes I am maintaining three separate books for three family members, as that is 
the way to go.

Your idea of debiting equity is good. May need to create a sub account of 
equity  specifically to capture related party transaction (as they call in 
legal parlance ). This will certainly take care of duplication!! This is 
excellent suggestion. I have to transfer all past transaction from expense or 
receivables to this equity account.

Generally, I consider equity as a holy account, as it is a result of all we do 
with all other accounts, but this case could be an exception.


As regarding consolidation, Of course I can arithmetically add three books 
having avoided duplicates, but it is a good feature to have if GNC can have an 
engine to do this!  Of course this is just a desirable and not an essential 
feature.

Thanks a lot for your suggestion

Paras



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

Re: [GNC] Imbalanced in-kind stock transfer

[David Carlson]

Read the entire Tutorial section on investments.  After you have figured
out how to record a security purchase and a security sale, you will need to
enter both a purchase and a sale in brokerage security account A and a
purchase in brokerage security account B. That will effect a transfer of a
security from brokerage security account A to brokerage security account B
Note that you will need to enter the share price for each transaction so
that you can correctly enter the capital asset value for each transaction.
You will also need to enter a transaction line to enter the capital gain or
loss in the closing or sale transaction. Even if you are just moving a
stock certificate from one place to another, GnuCash will consider it a
sale and purchase because it does not know whether both accounts are owned
by the same taxable entity.

You are correct that GnuCash does not force you to enter both a source and
a destination account for shares of securities like it does for currency,
but it does conserve the value of the security account.  That share
tracking is up to the user.

On Sun, Aug 13, 2023 at 8:01 PM Dong Lin via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi,
> I have two stock accounts A and B linked to the same security. Want to
> transfer 100 shares from A to B.  So in the register of A, set the transfer
> column to B, and enter -100 (negative) shares, hit ENTER.
> The balance of A is decreased by 100. However, B's balance is unchanged
> and the shares column is empty.
> Should double-entry be maintained for stock accounts? Debug logging showed
> that this should have been handled in gnc_split_register_save_cells for
> both bank accounts and stock accounts if I read the code correctly.
> However, it performs double-entry by value, but not by amount/shares. So
> stock accounts are not enforced. Should gnc_split_register_save_shares_cell
> perform double-entry by amount? It sets the amount for one split, but not
> the other one.
>
>
> Thanks.
> Dong
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Imbalanced in-kind stock transfer

[Dong Lin via gnucash-user]

Hi,
I have two stock accounts A and B linked to the same security. Want to transfer 
100 shares from A to B.  So in the register of A, set the transfer column to B, 
and enter -100 (negative) shares, hit ENTER.
The balance of A is decreased by 100. However, B's balance is unchanged and the 
shares column is empty.
Should double-entry be maintained for stock accounts? Debug logging showed that 
this should have been handled in gnc_split_register_save_cells for both bank 
accounts and stock accounts if I read the code correctly. However, it performs 
double-entry by value, but not by amount/shares. So stock accounts are not 
enforced. Should gnc_split_register_save_shares_cell perform double-entry by 
amount? It sets the amount for one split, but not the other one.


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

Re: [GNC] Consolidation of family member accounts

[flywire]

> it's already available as a custom report which I will maintain for the
time being: https://github.com/dawansv/gnucash-custom-reports

On Mon, 14 Aug 2023 at 09:57, flywire  wrote:

> A classic case for a single file with tags:
> https://github.com/Gnucash/gnucash/pull/1623
>
> It works but it is not part of standard 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Consolidation of family member accounts

[flywire]

A classic case for a single file with tags:
https://github.com/Gnucash/gnucash/pull/1623

It works but it is not part of standard 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Today's search....for .lck

[David Carlson]

One possibility that I might suggest is to buy a couple of USB memory keys
and move every file that you can find  in whichever user folders on your
'C;' drive to folders with similar names on one of the USB keys.  Then try
to pick out the files that appear to have data that belongs in your final
data file and use them to reconstruct your file on the other USB key.  Plan
a method that allows you to keep track of which files you have checked and
keep them afterwards as backup in case you need to make another try.

On Sun, Aug 13, 2023 at 2:12 PM Maf. King  wrote:

> On Sunday, 13 August 2023 19:41:29 BST Mahon Finbar via gnucash-user wrote:
>
> >
> > Could I suggest I try saving individually GNU files from the period
> > before 30.7.2023, which is when the issue of not being able to save the
> > files started, as .txt files and sent them over?
>
> Barry.
>
> This whole thing seems to be a mess, with different users, different
> levels of
> backup files being used and reused, and folders seemingly vanishing.  I'm
> not
> sure that introducing .txt files randomly will help anyone.
>
> Can you still open whatever you think is your most "recent" gnucash data
> file
> (ie the one you think has the most recent changes in it)?   (just starting
> the
> program from the menu might do it - not worrying about users and data
> files and
> so on)
>
> Can you then "Save As"  and a create new file (choose a sensible filename)
> just
> in the top level of the user's folder?  (that at least will get over the
> problem of which user is trying to save files, clean-up can wait)
>
> 0.02
> Maf.
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Strawberry Perl 5.38 breaks F::Q (with workaround)

[byemail]

Hello,

I use winget to automatically update apps on my Windows devices. Last 
week, winget automatically updated Strawberry Perl from 5.32 to 5.38. In 
doing so, it broke F::Q in Gnucash. (broke=greyed out button in 
Tools->Price Database). When I tried reinstalling F::Q it failed while 
making Module::CPANTS::Analyze. I overcame this with a "force install 
Module::CPANTS::Analyze", then successfully re-installed F::Q.  I'm not 
sure why it failed and someone else versed in these things could 
probably provide a proper fix. Bug I just wanted to let the devs know 
about the new 5.38 version (on Github atm) and provide a note for any 
other users that may experience this.


Doug

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

Re: [GNC] Consolidation of family member accounts

[Liz]

On Sun, 13 Aug 2023 17:04:26 +
Paras Desai  wrote:

> 4. Neither is a good practice, as at family level, it will
> erroneously show duplicate expenses (mine as gift to wife and, wife's
> actual expenses with gifted fund)

consider another reason it is not good practice
 5. At some time I anticipate your son will leave home and set up an
 independent household. Having to disentangle accounts at that time
 would be very difficult.

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
-
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 transfer all my accounts etc. to new computer. Linux version

[Liz]

On Sun, 13 Aug 2023 16:50:26 +0200
"Frank H. Ellenberger"  wrote:

> Updated. BTW the FAQ is a terrible place because it is hard to
> maintain. In most cases wiki's search offers more recent topics.

I deliberately chose the FAQ because it was recommended to the
Windows user changing computers.

It's far too long and contains a lot of information. I can understand
that it is hard to maintain.

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Sort Transactions in Alphabetical Order, For Entering Expense Category (Account)

[Tom Balazs]

According to John Ralls:
"Several others have answered the question already: Import small pieces, a
month or two at a time, until the matcher gets it mostly right, then move
to larger pieces. This is another common issue to users coming to GnuCash
from Quicken and there's a longer explanation at
https://wiki.gnucash.org/wiki/Quicken_Migration.;

On Sun, Aug 13, 2023, 12:22 PM john  wrote:

>
>
> On Aug 13, 2023, at 07:13, Tom Balazs  wrote:
>
>  (I know these are called accounts in GnuCash, but
> I mean "account" like "auto expenses", and "home repair expenses", not
> "account" like "Credit Card #1", and "Checking Account #1".)
>
>
> That indicates that you don't understand double-entry accounting. They're
> not called accounts, they *are* accounts. You need to spend some time
> studying the Tutorial and Concept Guide and perhaps a basic accounting
> text.
>
> Regards,
> John Ralls
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Consolidation of family member accounts

[Michael or Penny Novack]

On 8/13/2023 1:45 PM, Paras Desai wrote:

Thanks for your reply

The question arises because;

My wife and I maintain separate accounts. She has her own income and tax 
filing. So we need to maintain accounts independent of each other.

But at the same time, we wish to maintain family level account which generally 
gives us idea about

Total Family income, total family expense and total family investment.

This is the same scenario as two independent legal companies wherein one is a 
parent company and another is subsidiary company. Both legal entity has to 
maintain their own accounts/ books for their respective tax filing and legal 
compliances but have to report consolidated financial statement at group level.

Hope I am able to explain the scenario unambiguously

Thanking you

Paras


Yes, understood now. The simplest solution is to have three separate books.

Notice that EACH of these will have a total income, total expense, total 
investment, and total net worth. Surely it would not be difficult to 
simply add triplets to get family totals. If you don;t want to use pen 
and paper, could be a spreadsheet . As for the issue of this duplicating 
the amount of expenses (eg: once when you transfer to wife and again 
when she expends it) this is a matter of how you enter the transfer. 
When you make the transfer, do a "journal transaction". Debit your 
equity instead of an expense (temporary account of fundamental type 
equity). Then the amount transferred will not  falsely duplicate expense 
but will correctly affect your net worth. She would do the same in 
reverse, not enter as income but directly to equity.


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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Sort Transactions in Alphabetical Order, For Entering Expense Category (Account)

[John Ralls]

Please remember to copy the list on all replies.

No smackdown intended. You really need to understand basic accounting in order 
to use GnuCash effectively, and thinking that accounts in GnuCash are somehow 
equivalent to Quicken's categories is a common mistake for those new to 
GnuCash. 

Several others have answered the question already: Import small pieces, a month 
or two at a time, until the matcher gets it mostly right, then move to larger 
pieces. This is another common issue to users coming to GnuCash from Quicken 
and there's a longer explanation at 
https://wiki.gnucash.org/wiki/Quicken_Migration.

Regards,
John Ralls


> On Aug 13, 2023, at 1:29 PM, Tom Balazs  wrote:
> 
> Well you gave me a good smack down. But are you going to answer the question 
> I asked?
> 
> On Sun, Aug 13, 2023, 12:22 PM john  wrote:
> 
> 
>> On Aug 13, 2023, at 07:13, Tom Balazs  wrote:
>> 
>>  (I know these are called accounts in GnuCash, but
>> I mean "account" like "auto expenses", and "home repair expenses", not
>> "account" like "Credit Card #1", and "Checking Account #1".)
> 
> That indicates that you don't understand double-entry accounting. They're not 
> called accounts, they *are* accounts. You need to spend some time studying 
> the Tutorial and Concept Guide and perhaps a basic accounting text. 
> 
> Regards,
> John Ralls
> 

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

Re: [GNC] Today's search....for .lck

[Maf. King]

On Sunday, 13 August 2023 19:41:29 BST Mahon Finbar via gnucash-user wrote:

> 
> Could I suggest I try saving individually GNU files from the period
> before 30.7.2023, which is when the issue of not being able to save the
> files started, as .txt files and sent them over?

Barry.

This whole thing seems to be a mess, with different users, different levels of 
backup files being used and reused, and folders seemingly vanishing.  I'm not 
sure that introducing .txt files randomly will help anyone.

Can you still open whatever you think is your most "recent" gnucash data file  
(ie the one you think has the most recent changes in it)?   (just starting the 
program from the menu might do it - not worrying about users and data files and 
so on)

Can you then "Save As"  and a create new file (choose a sensible filename) just 
in the top level of the user's folder?  (that at least will get over the 
problem of which user is trying to save files, clean-up can wait)

0.02
Maf.



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

Re: [GNC] Sort Transactions in Alphabetical Order, For Entering Expense Category (Account)

[Stephen M. Butler]

See if your bank or CC company offers download in OFX format.  In a 
couple of cases I've been forced to use CSV format.  In both cases use 
small batches at first to train the matcher so it learns what 
transactions go to which accounts.


Note that with the CSV you will need to save the format layout for 
future use so you don't have to setup the layout each time.


Stephen M Butler
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

On 8/13/23 07:13, Tom Balazs wrote:

I'm importing a large number of transactions into GnuCash. I want to speed
up entering the expense category (account) of transactions, especially for
credit card transactions. (I know these are called accounts in GnuCash, but
I mean "account" like "auto expenses", and "home repair expenses", not
"account" like "Credit Card #1", and "Checking Account #1".)

There are two ways I could do that:
 1. Create a column for account in the CSV file (exported from the
bank's site), sort by payee name and enter account (expense category).
Important, I need this to conform to the expense categories I created in
GnuCash; I don't want GnuCash to automatically create new expense
categories with the expense. That could lead to small typos creating new
categories; e.g. "auto repair" and "auto rpeair".
 2. Or I want to import all the transactions, and then in GnuCash sort
by payee name, and then add expense category to 10-15 transactions at a
time.

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


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

Re: [GNC] Today's search....for .lck

[Mahon Finbar via gnucash-user]

Apropos, the whole issue ofthehistory of the GNU files, I have been 
having a lot of problems trying to get the into a fo that can be senton 
here here. There are so many files with very small differences it seems 
to "confuse" cutting and pasting.


Could I suggest I try saving individually GNU files from the period 
before 30.7.2023, which is when the issue of not being able to save the 
files started, as .txt files and sent them over?


Barry

On 07/08/2023 23:34, Adrien Monteleone wrote:
Yeah, I'm suspecting the "can't write to file" message is when trying 
to save the file back to its original location which is under a 
different user than the one who's desktop is front and center at that 
moment.


But we'll need that error message screenshot to confirm.

And then there is the obvious backup file(s) mess to clean up. And as 
you note, that will likely involve copying files from one user to 
another and correcting their permissions accordingly. (before any 
cleanup within GnuCash itself!)


I'm not versed on such, but I'm sure someone here is.

Regards,
Adrien


p.s. — I used to use Gmail for this list till I discovered the same 
problem so I switched to an account provided by my ISP and it has been 
a few years with no issues. (though I now use the list via gmane. And 
that reminds me, I'm long overdue for a wiki write up for gmane I 
promised!)


On 8/7/23 4:23 PM, David Carlson wrote:
Wow.  I just went to the archives of this list and discovered that 
not all
the messages were appearing in my Gmail folder.  Specifically there 
was a

reply to my first message about providing a path/filename where you
provided

C:\users\administrato\documents is where the only one which "fits" i.e.
where GNU FEB 12 2019.gnucash is. There are literally hundreds of others

to which Adrien has now responded.  He correctly suggests that is a 
major

part of your problem, and begins to work on a solution. For some reason
that message from you is not in my Gmail, but that is a completely
different problem that is for another place.

Presumably administrato is your root user name with different rights 
than

your ordinary Barry Mahon user name.  Part of the untangling will be to
aggregate everything under one user name, preferably without root 
rights.

I am not qualified to help you with that.





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

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

Re: [GNC] Consolidation of family member accounts

[Adrien Monteleone]

In that case, you would probably be better served with two books, one 
for yourself and your wife.


In each of those books, you'd have some sort of 'family assets' account 
as a source of funds, that each of you might independently add money to 
before spending it. Either of you could then run reports on money spent 
from that family account. (an alternative would be to maintain a 3rd 
joint book.)


Regards,
Adrien

On 8/13/23 12:45 PM, Paras Desai wrote:

Thanks for your reply

The question arises because;

My wife and I maintain separate accounts. She has her own income and tax 
filing. So we need to maintain accounts independent of each other.

But at the same time, we wish to maintain family level account which generally 
gives us idea about

Total Family income, total family expense and total family investment.

This is the same scenario as two independent legal companies wherein one is a 
parent company and another is subsidiary company. Both legal entity has to 
maintain their own accounts/ books for their respective tax filing and legal 
compliances but have to report consolidated financial statement at group level.

Hope I am able to explain the scenario unambiguously


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

Re: [GNC] Consolidation of family member accounts

[Adrien Monteleone]

This is the same case as reimbursement tracking. (covered in the Wiki - 
Using GnuCash, it might also be in the Tutorial & Concepts Guide)


I would simply create two asset accounts, one for your wife and your son 
each.


When you give them money, you would credit your bank/cash-on-hand 
account, and debit their 'reimbursement' account.


Do the reverse if they return any money to you.

When they spend those funds and you want to record the expense, simply 
do so through the reimbursement account as the source of funds and split 
against normal expense accounts as if you had made the purchase.


If they never return any money to you, and/or if they have access to 
spend out of say a checking account directly with an 'allowance limit' 
then you can make those as sub-accounts of the Bank account.


If you need some other level of tracking who spent on what, tag your 
transactions in some way in the Description, Notes, Memo, etc. Then you 
can run a Transaction Report filtered to transactions matching the 
desired 'tag'.


Regards,
Adrien

On 8/13/23 12:04 PM, Paras Desai wrote:

Hello sirs,

1. I am adopting GNC for my family members (me, wife and son)
2. There are lots of transfer takes place between family members. For example, 
I transfer an amount to wife account , for her expense or investment. Same for 
son.
3. At present I can adopt two approach for such transfer
Either I can show transferred amount as gift expense or create account 
receivable in name of family member.
4. Neither is a good practice, as at family level, it will erroneously show 
duplicate expenses (mine as gift to wife and, wife's actual expenses with 
gifted fund)

So my question is

Is there a way in GNC to consolidate family members account to arrive at net 
worth of entire family?

When we do consolidation of accounts, we eliminate inter transaction between 
members (as we do between a parent and subsidiary company in business scenario)

I will be happy to explore the way, if there is any way I can achieve this in 
GNC


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

Re: [GNC] Consolidation of family member accounts

[Paras Desai]

Thanks for your reply

The question arises because;

My wife and I maintain separate accounts. She has her own income and tax 
filing. So we need to maintain accounts independent of each other.

But at the same time, we wish to maintain family level account which generally 
gives us idea about

Total Family income, total family expense and total family investment.

This is the same scenario as two independent legal companies wherein one is a 
parent company and another is subsidiary company. Both legal entity has to 
maintain their own accounts/ books for their respective tax filing and legal 
compliances but have to report consolidated financial statement at group level.

Hope I am able to explain the scenario unambiguously

Thanking you

Paras


Get Outlook for Android

From: David T. 
Sent: Sunday, August 13, 2023 11:03:06 PM
To: Paras Desai 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Consolidation of family member accounts

A transfer between two asset accounts (your account to your wife's) doesn't 
need any further entries, unless you're considering these transfers as some 
kind of bookable event. Are you paying them, or just transferring them funds? 
If the latter, then just two entries crediting/debiting the two assets.

When your wife receives the funds this way, there's no change in the family net 
worth. When she buys something, the transaction includes her bank account and 
the proper expense account.

David T.
On Aug 13, 2023, at 8:05 PM, Paras Desai 
mailto:desaipa...@outlook.com>> wrote:

Hello sirs,

1. I am adopting GNC for my family members (me, wife and son)
2. There are lots of transfer takes place between family members. For example, 
I transfer an amount to wife account , for her expense or investment. Same for 
son.
3. At present I can adopt two approach for such transfer
Either I can show transferred amount as gift expense or create account 
receivable in name of family member.
4. Neither is a good practice, as at family level, it will erroneously show 
duplicate expenses (mine as gift to wife and, wife's actual expenses with 
gifted fund)

So my question is

Is there a way in GNC to consolidate family members account to arrive at net 
worth of entire family?

When we do consolidation of accounts, we eliminate inter transaction between 
members (as we do between a parent and subsidiary company in business scenario)

I will be happy to explore the way, if there is any way I can achieve this in 
GNC

Thank you

Paras




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

Re: [GNC] Consolidation of family member accounts

[Mark at Lorimark]

I'm not a CPA.  Just someone that uses and loves GnuCash, so... grains 
of salt needed here...


Those are really separate "accounting systems" are they not?  Would not 
each person maintain their own set of books?


If so, then when you transfer funds to your son, you ~could~ expense 
that, and to you it shows as an 'expense' or 'gift', and you have to 
account for that.  If you're giving someone money, don't you have to 
account for and report on that?  That's 'one side' of the transactional 
relationship (a double-post in YOUR account system showing a transfer).


Then, in your sons 'accounting system' he would show an double-posted 
'income' and 'asset', where he would receive income, and it would land 
as an asset.


Your expense and liability (to the tax man) is covered in your entries, 
and your sons 'income and subsequent expenses' are also tracked 
accordingly and properly in HIS accounting system.


Same with your wife.

Then, at tax time, everyone runs their 'books' to see all their incomes 
and expenses...


Does it make sense to break it up this way, to at least understand the 
'flow of monies' between all these individuals?  Because, if so, I think 
it would be possible to 'combine but separate' the 'Son' and 'Wife' 
systems in to a single (hierarchical) account file, and then get your 
taxes report by separating those accounts accordingly...


~mark petryk
~w:http://www.lorimarksolutions.com
~h:KG5OBY
~q:might as well... it's not getting any cheaper

On 8/13/23 12:04, Paras Desai wrote:

Hello sirs,

1. I am adopting GNC for my family members (me, wife and son)
2. There are lots of transfer takes place between family members. For example, 
I transfer an amount to wife account , for her expense or investment. Same for 
son.
3. At present I can adopt two approach for such transfer
Either I can show transferred amount as gift expense or create account 
receivable in name of family member.
4. Neither is a good practice, as at family level, it will erroneously show 
duplicate expenses (mine as gift to wife and, wife's actual expenses with 
gifted fund)

So my question is

Is there a way in GNC to consolidate family members account to arrive at net 
worth of entire family?

When we do consolidation of accounts, we eliminate inter transaction between 
members (as we do between a parent and subsidiary company in business scenario)

I will be happy to explore the way, if there is any way I can achieve this in 
GNC

Thank you

Paras


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

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

Re: [GNC] Consolidation of family member accounts

[David T. via gnucash-user]

A transfer between two asset accounts (your account to your wife's) doesn't 
need any further entries, unless you're considering these transfers as some 
kind of bookable event. Are you paying them, or just transferring them funds? 
If the latter, then just two entries crediting/debiting the two assets. 

When your wife receives the funds this way, there's no change in the family net 
worth. When she buys something, the transaction includes her bank account and 
the proper expense account. 

⁣David T. ​

On Aug 13, 2023, 8:05 PM, at 8:05 PM, Paras Desai  
wrote:
>Hello sirs,
>
>1. I am adopting GNC for my family members (me, wife and son)
>2. There are lots of transfer takes place between family members. For
>example, I transfer an amount to wife account , for her expense or
>investment. Same for son.
>3. At present I can adopt two approach for such transfer
>Either I can show transferred amount as gift expense or create account
>receivable in name of family member.
>4. Neither is a good practice, as at family level, it will erroneously
>show duplicate expenses (mine as gift to wife and, wife's actual
>expenses with gifted fund)
>
>So my question is
>
>Is there a way in GNC to consolidate family members account to arrive
>at net worth of entire family?
>
>When we do consolidation of accounts, we eliminate inter transaction
>between members (as we do between a parent and subsidiary company in
>business scenario)
>
>I will be happy to explore the way, if there is any way I can achieve
>this in GNC
>
>Thank you
>
>Paras
>
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Consolidation of family member accounts

[Paras Desai]

Hello sirs,

1. I am adopting GNC for my family members (me, wife and son)
2. There are lots of transfer takes place between family members. For example, 
I transfer an amount to wife account , for her expense or investment. Same for 
son.
3. At present I can adopt two approach for such transfer
Either I can show transferred amount as gift expense or create account 
receivable in name of family member.
4. Neither is a good practice, as at family level, it will erroneously show 
duplicate expenses (mine as gift to wife and, wife's actual expenses with 
gifted fund)

So my question is

Is there a way in GNC to consolidate family members account to arrive at net 
worth of entire family?

When we do consolidation of accounts, we eliminate inter transaction between 
members (as we do between a parent and subsidiary company in business scenario)

I will be happy to explore the way, if there is any way I can achieve this in 
GNC

Thank you

Paras


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

Re: [GNC] Sort Transactions in Alphabetical Order, For Entering Expense Category (Account)

[john]

> On Aug 13, 2023, at 07:13, Tom Balazs  wrote:
> 
>  (I know these are called accounts in GnuCash, but
> I mean "account" like "auto expenses", and "home repair expenses", not
> "account" like "Credit Card #1", and "Checking Account #1".)

That indicates that you don't understand double-entry accounting. They're not 
called accounts, they *are* accounts. You need to spend some time studying the 
Tutorial and Concept Guide and perhaps a basic accounting text. 

Regards,
John Ralls

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

Re: [GNC] Sort Transactions in Alphabetical Order, For Entering Expense Category (Account)

[Adrien Monteleone]

When you do the import, you get to assign the existing expense accounts. 
GnuCash won't create new accounts if you do this.


Note, do not try to import hundreds or thousands of transactions in one 
go. The matcher needs to be trained, so it is advisable to usually 
import a month at a time, reconcile, then proceed. As you train the 
matcher it will save you time having to assign accounts in subsequent 
imports.


Regards,
Adrien

On 8/13/23 9:13 AM, Tom Balazs wrote:

I'm importing a large number of transactions into GnuCash. I want to speed
up entering the expense category (account) of transactions, especially for
credit card transactions. (I know these are called accounts in GnuCash, but
I mean "account" like "auto expenses", and "home repair expenses", not
"account" like "Credit Card #1", and "Checking Account #1".)

There are two ways I could do that:
 1. Create a column for account in the CSV file (exported from the
bank's site), sort by payee name and enter account (expense category).
Important, I need this to conform to the expense categories I created in
GnuCash; I don't want GnuCash to automatically create new expense
categories with the expense. That could lead to small typos creating new
categories; e.g. "auto repair" and "auto rpeair".
 2. Or I want to import all the transactions, and then in GnuCash sort
by payee name, and then add expense category to 10-15 transactions at a
time.

How can I do that?


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

Re: [GNC] How to transfer all my accounts etc. to new computer. Linux version

[Frank H. Ellenberger]

Hi Liz,

Am 13.08.23 um 02:40 schrieb Liz:

What does the FAQ say?
https://wiki.gnucash.org/wiki/FAQ#Q:_I_moved.2Frenamed_my_data_file_and_my_reports_disappeared._How_do_I_get_them_back.3F

"Reports are stored in a separate file in the ~/.gnucash/books
directory."

Nope, no such directory
$ ls ~/.gnucash/books
ls: cannot access '/home/liz/.gnucash/books': No such file or directory


Updated. BTW the FAQ is a terrible place because it is hard to maintain. 
In most cases wiki's search offers more recent topics.


Regards
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Sort Transactions in Alphabetical Order, For Entering Expense Category (Account)

[Tom Balazs]

I'm importing a large number of transactions into GnuCash. I want to speed
up entering the expense category (account) of transactions, especially for
credit card transactions. (I know these are called accounts in GnuCash, but
I mean "account" like "auto expenses", and "home repair expenses", not
"account" like "Credit Card #1", and "Checking Account #1".)

There are two ways I could do that:
1. Create a column for account in the CSV file (exported from the
bank's site), sort by payee name and enter account (expense category).
Important, I need this to conform to the expense categories I created in
GnuCash; I don't want GnuCash to automatically create new expense
categories with the expense. That could lead to small typos creating new
categories; e.g. "auto repair" and "auto rpeair".
2. Or I want to import all the transactions, and then in GnuCash sort
by payee name, and then add expense category to 10-15 transactions at a
time.

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

Re: [GNC] How to transfer all my accounts etc. to new computer. Linux version

[Maf. King]

On Sunday, 13 August 2023 01:40:15 BST Liz wrote:


> Gnucash opens, but a lot of my preferences are gone, and even which is
> my next invoice number.
>


Hi Liz.

I'm reasonably certain (but have not checked), that the "counters" for the 
next invoice number etc are stored within the datafile itself.

Maybe you've uncovered a bug related to the version change?

0.02
Maf.


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

Re: [GNC] How to transfer all my accounts etc. to new computer. Linux version

[Liz]

On Sun, 13 Aug 2023 09:46:14 +0200
Geert Janssens  wrote:

> That data is managed via GSettings, which on Linux uses dconf as
> back-end. I have no idea how dconf manages its internal database
> unfortunately. It's tied into dbus but that's a black box for me.
> 
> You can dump the the contents via dconf or GSettings tools and then
> import this on the new machine. As I'm not near a computer right now,
> I can't offer much more than a pointer in the right direction.
> 
Old machine
$ dconf dump /org/gnucash/ > /home/liz/gnucash-dconf
$ scp /home/liz/gnucash-dconf
l...@192.168.xxx.xxx:/home/liz/gnucash-dconf

New machine
$ dconf load /org/gnucash/ < gnucash-dconf

The last matter of the date settings was that when the locale was set
in Debian the default went to "none" instead of en_AU.
Running "dpkg-reconfigure locales", not adding any and setting the
default locale was necessary to fix that.

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
-
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 transfer all my accounts etc. to new computer. Linux version

[Liz]

On Sun, 13 Aug 2023 09:46:14 +0200
Geert Janssens  wrote:

> That data is managed via GSettings, which on Linux uses dconf as
> back-end. I have no idea how dconf manages its internal database
> unfortunately. It's tied into dbus but that's a black box for me.
> 
> You can dump the the contents via dconf or GSettings tools and then
> import this on the new machine. As I'm not near a computer right now,
> I can't offer much more than a pointer in the right direction.
> 
Someone on reddit has supplied some answers here
https://www.reddit.com/r/linuxquestions/comments/oqbyqr/how_to_copy_dconf_settings_from_dead_machine/

and I'll report on success or failure, as I can ssh into the old
machine.


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
-
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 transfer all my accounts etc. to new computer. Linux version

[Geert Janssens]

That data is managed via GSettings, which on Linux uses dconf as back-end. I 
have no idea how dconf manages its internal database unfortunately. It's tied 
into dbus but that's a black box for me.

You can dump the the contents via dconf or GSettings tools and then import this 
on the new machine. As I'm not near a computer right now, I can't offer much 
more than a pointer in the right direction.

Liz  schreef op 13 augustus 2023 04:50:34 CEST:
>On Sun, 13 Aug 2023 11:15:52 +1000
>David Cousens  wrote:
>
>> The saved reports are in
>> /home/liz/.local/share/gnucash/saved_reports2.8. GNC_USERDATA_DIR is
>> the location for the user preferences data 
>
>all very well, but that file
>~/.local/share/gnucash/books/*.gcm contains the data for the registry
>displays but where is the date format, the last invoice number,
>accounting period and so on?
>
>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
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.

-- 
Verzonden van mijn Android telefoon met K-9 Mail.
Sent from my smartphone. Please excuse my brevity.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.