Re: [GNC] Reorganize Trading accounts
On Sun, 23 Apr 2023 12:49:29 -0400 King Mak wrote: > Hi, > > I have just acquired a new computer. I moved all my gnucash files to > the new computer by copy-paste. But when I open my accounting files > in the new computer, I notice that some of the transactions are > missing . What do I do? start a new thread here after doing your basic checks on file sizes etc. 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] Reorganize Trading accounts
On 4/24/2023 4:24 PM, R Losey wrote: If you have a trust (I assume that it is for someone else), a business, and personal accounts, why not just have three separate books? Not necessarily. From the description, probably only one tax ID. I am guessing the trust might be a revocable trust (we have one for estate planning). As long as you are still alive, it isn't that separate from yourself (because revocable) and only used so the property in it at time of death ISN'T considered part of your estate for will/probate purposes (and will follow its own rules**). Because in this state, the amount of an estate that can use simple, not formal probate is small, almost all of our property (including all but small bank accounts) is technically owned by the trust. However -- even when a business is really just yourself, I would be inclined for it to have its own books. Especially if it is a business you might sell << you would be showing a potential buyer its books, but why show them your personal books >> Michael D Novack ** Probably dumping whatever is in it to a second trust that will distribute to heirs and other beneficiaries. But that second trust needs no books now (it is currently empty) and things like getting a tax ID, keeping books, filing reports, etc. will be whoever you have designated as trustee(s). ___ 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] Reorganize Trading accounts
If you have a trust (I assume that it is for someone else), a business, and personal accounts, why not just have three separate books? On Sun, Apr 23, 2023 at 1:37 AM Fred Tydeman wrote: > When I first setup my file, all of the investments / securities were > organized by type: > Cash-US > Cash-International > Bonds-US > Bonds-International > Stock-US > Stock-International > RealEstate-US > RealEstate-International > > Sometime later, I learned about Trading accounts, so turned on that > feature. I noticed that the Trading accounts mirrored the Securities > organization. > > However, with my initial setup, I am finding it difficult to produce > some reports. So, I am thinking of redoing my chart of accounts. > > I have a business, a trust, and my personal items. Both the business > and the trust are passthru items for income tax purposes. So, for a > tax report or a net worth report, it would be best if all three were > in the same file. But, for balance sheet or income statement, it would > be best if the business and trust were each in their own file. > > The problem is some Trading accounts are a mixture of transactions from > personal, business, and/or trust. I need to seperate them so I can do > correct balance sheets. > > So, I am thinking of three sub-accounts: > Personal > Business > Trust > under each of: > Assets > Liabilities > Equity > Income > Expenses > Trading > > That way, it is easy to pick subsets of accounts (and their children) > for the balance sheet or income statement reports. > > Can I redo the Trading accounts setup and still have things work OK? > Do I also need to redo how the securities are organized? > > Aside: It is possible for the same security to end up in: > Personal - taxable > Personal - tax deferred (regular IRA) > Personal - tax free (Roth IRA) > Trust - taxable > ___ > 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. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ 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] Reorganize Trading accounts
It might be easier at this time to keep separate books and then export and manipulate further in a spreadsheet for the combined reports. (while I understand some reports can be either consolidated or separate, the fact that you need separate Balance Sheet Reports tells me the books should be separate) Maybe when/if some sort of tag/category ability is added to the Balance Sheet & Income Statement report (like the Transaction Report regex filter) then you can have a consolidated book filtering those reports for the type of transaction (Personal, Business, Trust) Alternatively, since the Transaction Report has this ability, you could maybe get close enough using it and then finish that off in a spreadsheet and keep the consolidated book as-is, save having to go back and 'tag' all of your existing transactions in either Description, Notes, or Memos. (you could also do separate Find operations based on those tags and then export those results as an Account Report for different sections of the Balance Sheet & Income Statement) I think your proposed alternative of replicating accounts can also work as there are some folks using that method for managing projects and properties. Only you can decide based on your circumstances how much work that will be to set up and then maintain and work with. Regards, Adrien On 4/23/23 1:36 AM, Fred Tydeman wrote: I have a business, a trust, and my personal items. Both the business and the trust are passthru items for income tax purposes. So, for a tax report or a net worth report, it would be best if all three were in the same file. But, for balance sheet or income statement, it would be best if the business and trust were each in their own file. ___ 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] Reorganize Trading accounts
Most people would have separate books for a business and for personal, possibly also the trust, if it has its own Tax ID (at least in the US). Alex On Sun, Apr 23, 2023 at 9:00 AM wrote: > > > -- Forwarded message -- > From: Fred Tydeman > To: Gnucash Users > Cc: > Bcc: > Date: Sun, 23 Apr 2023 09:36:29 +0300 > Subject: [GNC] Reorganize Trading accounts > When I first setup my file, all of the investments / securities were > organized by type: > Cash-US > Cash-International > Bonds-US > Bonds-International > Stock-US > Stock-International > RealEstate-US > RealEstate-International > > Sometime later, I learned about Trading accounts, so turned on that > feature. I noticed that the Trading accounts mirrored the Securities > organization. > > However, with my initial setup, I am finding it difficult to produce > some reports. So, I am thinking of redoing my chart of accounts. > > I have a business, a trust, and my personal items. Both the business > and the trust are passthru items for income tax purposes. So, for a > tax report or a net worth report, it would be best if all three were > in the same file. But, for balance sheet or income statement, it would > be best if the business and trust were each in their own file. > > The problem is some Trading accounts are a mixture of transactions from > personal, business, and/or trust. I need to seperate them so I can do > correct balance sheets. > > So, I am thinking of three sub-accounts: > Personal > Business > Trust > under each of: > Assets > Liabilities > Equity > Income > Expenses > Trading > > That way, it is easy to pick subsets of accounts (and their children) > for the balance sheet or income statement reports. > > Can I redo the Trading accounts setup and still have things work OK? > Do I also need to redo how the securities are organized? > > Aside: It is possible for the same security to end up in: > Personal - taxable > Personal - tax deferred (regular IRA) > Personal - tax free (Roth IRA) > Trust - taxable > > ___ 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] Reorganize Trading accounts
Hi, I have just acquired a new computer. I moved all my gnucash files to the new computer by copy-paste. But when I open my accounting files in the new computer, I notice that some of the transactions are missing . What do I do? On Sun, Apr 23, 2023 at 2:37 AM Fred Tydeman wrote: > When I first setup my file, all of the investments / securities were > organized by type: > Cash-US > Cash-International > Bonds-US > Bonds-International > Stock-US > Stock-International > RealEstate-US > RealEstate-International > > Sometime later, I learned about Trading accounts, so turned on that > feature. I noticed that the Trading accounts mirrored the Securities > organization. > > However, with my initial setup, I am finding it difficult to produce > some reports. So, I am thinking of redoing my chart of accounts. > > I have a business, a trust, and my personal items. Both the business > and the trust are passthru items for income tax purposes. So, for a > tax report or a net worth report, it would be best if all three were > in the same file. But, for balance sheet or income statement, it would > be best if the business and trust were each in their own file. > > The problem is some Trading accounts are a mixture of transactions from > personal, business, and/or trust. I need to seperate them so I can do > correct balance sheets. > > So, I am thinking of three sub-accounts: > Personal > Business > Trust > under each of: > Assets > Liabilities > Equity > Income > Expenses > Trading > > That way, it is easy to pick subsets of accounts (and their children) > for the balance sheet or income statement reports. > > Can I redo the Trading accounts setup and still have things work OK? > Do I also need to redo how the securities are organized? > > Aside: It is possible for the same security to end up in: > Personal - taxable > Personal - tax deferred (regular IRA) > Personal - tax free (Roth IRA) > Trust - taxable > ___ > 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. > -- *Dr. Polycarpe N. Makinga* MD., Dip Obst., Dip HIV Man., Adv Cert Health Mangt., MPH., MMed (FamMed) Mobile: +1 438 2278912 Fax: +27 86 512 4653 ___ 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] Reorganize Trading accounts
When I first setup my file, all of the investments / securities were organized by type: Cash-US Cash-International Bonds-US Bonds-International Stock-US Stock-International RealEstate-US RealEstate-International Sometime later, I learned about Trading accounts, so turned on that feature. I noticed that the Trading accounts mirrored the Securities organization. However, with my initial setup, I am finding it difficult to produce some reports. So, I am thinking of redoing my chart of accounts. I have a business, a trust, and my personal items. Both the business and the trust are passthru items for income tax purposes. So, for a tax report or a net worth report, it would be best if all three were in the same file. But, for balance sheet or income statement, it would be best if the business and trust were each in their own file. The problem is some Trading accounts are a mixture of transactions from personal, business, and/or trust. I need to seperate them so I can do correct balance sheets. So, I am thinking of three sub-accounts: Personal Business Trust under each of: Assets Liabilities Equity Income Expenses Trading That way, it is easy to pick subsets of accounts (and their children) for the balance sheet or income statement reports. Can I redo the Trading accounts setup and still have things work OK? Do I also need to redo how the securities are organized? Aside: It is possible for the same security to end up in: Personal - taxable Personal - tax deferred (regular IRA) Personal - tax free (Roth IRA) Trust - taxable ___ 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.