Re: [GNC] Consolidation of family member accounts

2023-08-13 Thread 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

[GNC] Consolidation of family member accounts

2023-08-13 Thread 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

[GNC] Consolidation of family member accounts

2023-08-13 Thread 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

[GNC] Consolidation of family member accounts

2023-08-13 Thread 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

Re: [GNC] Imbalanced in-kind stock transfer

2023-08-13 Thread 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

[GNC] Imbalanced in-kind stock transfer

2023-08-13 Thread 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

Re: [GNC] Consolidation of family member accounts

2023-08-13 Thread 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

[GNC] Consolidation of family member accounts

2023-08-13 Thread 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:

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

2023-08-13 Thread 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

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

2023-08-13 Thread 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

Re: [GNC] Consolidation of family member accounts

2023-08-13 Thread 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

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

2023-08-13 Thread 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.

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

2023-08-13 Thread 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

Re: [GNC] Consolidation of family member accounts

2023-08-13 Thread 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

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

2023-08-13 Thread 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.

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

2023-08-13 Thread 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

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

2023-08-13 Thread 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

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

2023-08-13 Thread 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

Re: [GNC] Consolidation of family member accounts

2023-08-13 Thread 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

Re: [GNC] Consolidation of family member accounts

2023-08-13 Thread 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,

Re: [GNC] Consolidation of family member accounts

2023-08-13 Thread 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

Re: [GNC] Consolidation of family member accounts

2023-08-13 Thread 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

Re: [GNC] Consolidation of family member accounts

2023-08-13 Thread 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

[GNC] Consolidation of family member accounts

2023-08-13 Thread 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

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

2023-08-13 Thread 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

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

2023-08-13 Thread 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,

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

2023-08-13 Thread 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

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

2023-08-13 Thread 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

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

2023-08-13 Thread 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

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

2023-08-13 Thread 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

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

2023-08-13 Thread 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

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

2023-08-13 Thread 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