[GNC] Switching to trading accounts in existing database
Hi, I have been using gnucash for over ten years. My data contains all data (Sqlite database ~20MB). I have lived in four different countries and since the move never was a clear cut, I ended up having four separate Equity/Assets/Liabilities/Expenses/Income hierarchies, one for each. I made extensive usage of the multi-currency functionality (e.g., living in country A, paying with credit card from country B) which has an exchange rate for each transaction/split when the two accounts have different currencies. Recently I stumbled into this problem: "Securities" (crypto currency) which I buy from different brokers in each country. So I have a broker in Canadian dollars, US Dollars, Euro. Now these "shares" (=Bitcoin) get transfered to my personal wallet. This personal wallet is represented as Stock account with security BTC and the sources of its transactions are the stock accounts of each trader with different currencies. Suddenly it gets messy ... the personal wallet account would mix different currencies in the same ledger (Price/Buy/Sell values represent 1:1 the values of the source accounts -- there is no currency conversion). So I got recommended using trading accounts. But suddenly all my previous multi-currency transactions get a small grey box with a cross (hinting the transaction is inconsistent). How do I best deal with this? Is it possible to keep my old multi currency transactions as-is and use trading accounts only for securities/stocks? If not, how do I migrate while ensuring my ten years worth of data does not suddenly get inconsistent? Thanks, Lukas ___ 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] Setting up accounts for account number order
There are plenty of Charts of Accounts online with various numbering schemes depending on your local jurisdiction (and personal) requirements. Regards, Adrien On 1/18/21 10:02 PM, John G Sullivan wrote: I’ve used GnuCash for years; although, I never worded about account number order. Most of the time I exported reports and then manipulated the order or just looked at them in whatever method they displayed. I always want to figure out the system. Now I need to know since one account is am working requires it from top to bottom; sub accounts and all. 1000assest 2000liabilities 3000equity 4000income 5000expense I have seen something a couple of years ago; however, I can’t find it now. Any pointers, places to look. Too easy or too hard? ___ 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] Setting up accounts for account number order
On Mon, Jan 18, 2021 at 11:03 PM John G Sullivan wrote: > 1000assest > 2000liabilities > 3000equity > 4000income > 5000expense If it matters to you at all, it's standard (or so I was taught in the mid-1980s) to number them as follows: 1000-1999 Assets 2000-2999 Liabilities 3000-3999 Equity 4000-4999 Income 5000-5999 Cost of Goods Sold 6000-6999 Expenses 7000-7999 Other I don't remember why goods bought for sale are tracked differently from assets. I believe it was for tax purposes. And again, this is only of it matters to you. If you never buy anything with the purpose of reselling it in mind, If it were I, I'd just skip the 5000 series altogether. Another thing I'll suggest is to not give your existing accounts sequential numbers if you're naming them alphabetically. Put maybe ten between them. That way, if you want to add an account later, you've got room to add it in alphabetical order. https://strategiccfo.com/standard-chart-of-accounts/ -- () ascii ribbon campaign * against html e-mail /\ www.asciiribbon.org * against proprietary attachments Home: http://nlphilia.com * Blog: http://nlphilia.net ___ 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.