Re: [GNC] Financial Account Structure for Australian Shares and EFTs
Message: 11 Date: Thu, 26 Aug 2021 23:37:15 +1000 From: flywire To: Gnucash Users Subject: [GNC] Financial Account Structure for Australian Shares and ETFs Message-ID: Content-Type: text/plain; charset="UTF-8" The guide leaves stock and mutual fund financial account structure very open and search only showed one Franking/Franked thread in the recent past. I'm wondering what people do in practice. Share dividends looks doable: Bank deposit = Unfranked + Franked - Tax Withheld. Franked has unpaid Franking Credits. Where does the contra account for Franking Credits sit? (I use a fairly simple account tree.) ETFs: have about 10 tax codes that don't bear much resemblance to actual payments. How do people handle these? (I realise financial records only go so far preparing for tax. It's looking like a spreadsheet.) I'm not looking at tracking physical shares/ETFs in GnuCash. -- Hi Flywire, Please see my response https://lists.gnucash.org/pipermail/gnucash-user/2021-August/097360.html I don't know anything about EFT's... Regards, Chris Good ___ 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.
[GNC] Can I Prevent OFX/QFX Import Overwriting Notes?
I wouldn't be surprised if this has been asked in the past, but I don't know of a good way to search the archives for these mailing lists (seems I'd have to download a month at a time in order to search manually). I also wouldn't be surprised if the answer is blatantly obvious / right in front of me and I'm just missing it. I did try an Internet search and got too many irrelevant results (outside of the manual and basic import information, which I did look through a bit, without much luck). I recently migrated from an old PC to a new Mac. As far as I can tell, I was running GnuCash 2.6.16-1 on the PC (I don't remember why I stopped updating), but I figured I should upgrade during the transition, so I'm running 4.6-1 on the Mac. I have always downloaded OFX and/or QFX files from my banks in order to reconcile my manual entries and import additional transaction data (using U+C to complete my register). For the manual entries, I have always used the notes field in the register for most of my bank accounts because there's typically nothing worth importing there anyway (just something like "OFX ext. info: |Trans type:Generic debit"). Previously, on the PC, my manually entered notes were NOT overwritten. Now that I'm on the Mac, the notes are being overwritten by that arcane data, but I don't know if that is a PC vs Mac thing or a version change thing. I also don't know if there is anything I can do to prevent it in either case. What I do know is that the behavior is consistent across file types and banks (I ignored it the first time it happened because I didn't want to re-enter a bunch of previous transactions in order to try to work around it, but I was expecting it this time, with a different bank providing the data, and confirmed it happens for both formats). I don't really want to lose my manually entered data, but I would like to have the bank data imported an synchronized as well. Is there anything I can do so that the generic transaction information doesn't overwrite my previously entered notes? ___ 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] Paying expenses with cryptocurrency
Hi, Am 26.08.21 um 18:25 schrieb John Ralls: > Aside from the way GnuCash presents assets in registers the only difference > between currencies and non-currency commodities is that you can't have Equity > or Payable/Receivable accounts denominated in non-currency commodities. We've > been told by a licensed accountant that one shouldn't have those accounts in > anything other than the book currency anyway. Did you really mean "Payable/Receivable" or was "Income/Expense" accounts intended? If I buy something from CH, they will invoice me in CHF and so I will need an A/P in CHF. 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 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] Paying expenses with cryptocurrency
> On Aug 25, 2021, at 10:29 PM, Peter West wrote: > > The recommended mode of dealing with crypto seems to be to record your crypto > as a stock, and handle fluctuation in prices as you would for a stock. When > you are investing crypto that makes sense. But what if you are using crypto > for purchases? That is, if you are using cryptocurrency for the originally > intended purpose? > > Any ideas on how to record this? Aside from the way GnuCash presents assets in registers the only difference between currencies and non-currency commodities is that you can't have Equity or Payable/Receivable accounts denominated in non-currency commodities. We've been told by a licensed accountant that one shouldn't have those accounts in anything other than the book currency anyway. So the answer is that that's how you account for transactions in all currencies, crypto or national, other than the book currency: You price them back to the book currency on the day of the transaction and record any resulting trading gains or losses. Do it any other way and you'll make yourself crazy trying to get your book to balance. 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 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.
[GNC] Financial Account Structure for Australian Shares and ETFs
The guide leaves stock and mutual fund financial account structure very open and search only showed one Franking/Franked thread in the recent past. I'm wondering what people do in practice. Share dividends looks doable: Bank deposit = Unfranked + Franked - Tax Withheld. Franked has unpaid Franking Credits. Where does the contra account for Franking Credits sit? (I use a fairly simple account tree.) ETFs: have about 10 tax codes that don't bear much resemblance to actual payments. How do people handle these? (I realise financial records only go so far preparing for tax. It's looking like a spreadsheet.) I'm not looking at tracking physical shares/ETFs in 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 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] Search/report by description
The query I showed in the previous email will show you what you paid for whatsits, and this code will show you what you charged for dinguses, limiting to a customer called Mycustomer SELECT invoices.date_posted, invoices.id, invoices.notes, customers.name AS customer, description, quantity_num, quantity_denom, i_price_num, i_price_denom, quantity_num / CAST(quantity_denom AS FLOAT) AS quantity, i_price_num / CAST(i_price_denom AS FLOAT) AS price FROM entries LEFT JOIN invoices ON entries.invoice = invoices.guid LEFT JOIN customers ON invoices.owner_guid = customers.guid WHERE description LIKE '%dingus%' AND customers.name LIKE '%mycustomer%' David On Wed, 25 Aug 2021 at 23:17, david whiting wrote: > While you can't do this directly from gnucash, if you use the sqlite > backend (or other sql backend) you can write your own queries > fairly easily. For example, you could save your gnucash file as an sqlite > file and use sqlitebrowser to view it and write queries > https://sqlitebrowser.org/dl/ (I'm suggesting sqlitebrowser because it is > free and available for windows, mac and linux). > > This query, for example, will find whatsits: > > SELECT invoices.date_posted, invoices.id, invoices.notes, > description, quantity_num, quantity_denom, b_price_num, b_price_denom, > quantity_num / CAST(quantity_denom AS FLOAT) AS quantity, > b_price_num / CAST(b_price_denom AS FLOAT) AS price > FROM entries > LEFT JOIN invoices ON entries.bill = invoices.guid > WHERE description LIKE '%whatsits%' > > You can limit the dates posted in WHERE clause. I haven't tried to link to > customers, but it should be possible. > > David > > > > On Wed, 25 Aug 2021 at 20:06, Derek Atkins wrote: > >> Hi, >> Sorry, there is no way to search Invoice Line-Item data. >> Unclear if PieCash can do that or not. >> -derek >> >> On Wed, August 25, 2021 2:51 pm, R. Victor Klassen wrote: >> > I’m looking for a report or means of searching all bills/invoices for a >> > specific pattern in the description field of any line. I would further >> > like to restrict it (optionally) by date range or customer/vendor. >> > >> > For example I might want to know what we paid for whatsits last year and >> > from whom all we bought them. They might be a small subset of what went >> > in the account and they might have wound up in multiple accounts >> depending >> > on their intended end use. >> > >> > Similarly I might want to know what we charged for dinguses. And there >> > might have been some that were accounted as greenhouse dinguses, while >> > others were grown in the field, but just now I want to know what we >> > charged customer x for them. >> > >> > I’m willing to use piecash if necessary but not write scheme. >> > >> > Sent from my iPhone >> > ___ >> > 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. >> > >> >> >> -- >>Derek Atkins 617-623-3745 >>de...@ihtfp.com www.ihtfp.com >>Computer and Internet Security Consultant >> >> ___ >> 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. >> > > > -- > David Whiting > -- David Whiting ___ 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.