Jim,
As you continue down this project, consider how you want to handle
various aspects of accounting for stocks and mutual funds--particularly,
how you want to manage tax-related transactions, such as dividend
income, capital gains income, etc. With that many commodities, you will
want to get your thoughts in order before you begin the import/create
process.
For example, you may wish to track dividends and gains by individual
commodity, which may be easier to manage with separate income accounts.
Or, you may opt to track your income by brokerage account and tax status
(I use this method). Or you may not want that detail at all. The
decision is yours, but it is easier to get it right first, rather than
have to alter the transactions and account structure after the fact.
(Note that with GnuCash, you *can* change any and all such structures
after the fact; it's just less convenient.)
For clarity, my method is to use per-brokerage aggregated income accounts:
Income
- Dividends
- - Taxable Dividends
- - - Brokerage Acct A
- - - Brokerage Acct B
- - NonTaxable Dividends
- - - Brokerage Acct C
- - - Brokerage Acct D
With capital gains, I additionally have separate income accounts for
short term and long term gains, since they need to be tracked separately
in my tax realm.
Another thing to consider: how do you want transaction descriptions to
appear in your books? Many exported transactions use generic
descriptions("Dividend", "Realized Gain/Loss", etc.). You may decide
that it is worth modifying the incoming data to be more descriptive (for
example, "AAPL Dividend"), so that the information in your books is
sensible to you.
Best,
David T.
On 8/15/2022 8:07 PM, Jim DeLaHunt wrote:
On 2022-08-15 06:54, flywire wrote:
Once share securities are created the share accounts can be created with
File, Import, Import accounts from CSV.
True. But the topic of the thread is, how to bulk create the share
securities themselves.
File, New
Cancel
Tools, Security Editor
Securities: Add
New security
Full Name: ***
Symbol: ***
Type: *** - Sticky
Fraction Traded: ***
OK
File, Import, Import Accounts from CSV
Next, DemoAccountTree.csv Next, Apply, Apply, Close
_______________________________________________
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.
_______________________________________________
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.
