Re: [GNC] Finance-Quote 1.61 released!

2024-04-28 Thread Klaus Dahlke via gnucash-user
It took a while to figure out why yahoo_json didn't work. When trying to fetch the cookie from fc.yahoo.com the response was 'connection refused', also when trying to connect via browser. In the end it turned out that pihole blocked fc.yahoo.com. Once I added fc.yahoo.com to the whitelist in

Re: [GNC] Identify error transaction in QIF import

2024-04-28 Thread Kalpesh Patel
While this is not specific to the problem at hand (which others have provided work around - namely fall back to GNC 5.5 which likely is to have better success), given that I went through the migration while back (circa GNC v4.3) to import data since at least 1993, these are the lessons I've

Re: [GNC] Identify error transaction in QIF import

2024-04-28 Thread Hao Huang
Hi, The original problem was "The erroneous transaction seems to be the last of those imported". If that's the case, it won't apply. What is shown in my case is there is no investment transaction on that day and it's somewhere in the middle of all the dates. Also, in Quicken I can't find any

Re: [GNC] One LLC pay expense of another LLC

2024-04-28 Thread Ian Bellamy
Not advice but in accounting terms if LLC-b needs to raise cash it can be done either through equity finance or debt finance. LLC-b sells common stock at par (amount above par goes into Additional Paid-in Capital account) to LLC-a in exchange for cash OR LLC-a lends cash to LLC-b in the form of a

Re: [GNC] Identify error transaction in QIF import

2024-04-28 Thread hh8923
Hi, Thanks for the advice. I run Quicken -> Validate and Repair File and it reported a few errors that I fixed. However, I still get the same error message Missing QIF investment action for transaction dated 9/19/2019 I opened the QIF in text editor and searched for 9/19’19.

Re: [GNC] Identify error transaction in QIF import

2024-04-28 Thread Joseph Keithley
I feel your pain, my quicken data went back almost thirty years. If there is a more definitive description in some GnuCash log file for qif import errors, I haven't found it. Hopefully someone with more knowledgeable on the inner workings of GnuCash can shed more light on that. I gather the

Re: [GNC] Use 4.14 and 5.6 on same file (at different times)

2024-04-28 Thread john
> On Apr 28, 2024, at 9:07 AM, Fred Tydeman wrote: > > Will I run into problems if I use both GnuCash 4.14 and 5.6 on the same > file / book? > That is, 4.14 is on my current production Linux system and where I use > Gnucash. > I have installed a later Linux system on a different disk

[GNC] One LLC pay expense of another LLC

2024-04-28 Thread Fred Tydeman
If LLC-a pays an expense of LLC-b ie, cash from LLC-a goes to expense of LLC-b, should I also show a transfer of equity from LLC-a to LLC-b? It seems that needs to be done so that the Balance sheet for LLC-b is correct. ___ gnucash-user mailing list

[GNC] Reconciliation oddity.

2024-04-28 Thread Tom Veik
I always reconcile my accounts to the penny and it has always worked well for me in the past except today.  In my credit card account.  I some how ended up with two extra charge transactions in my account that shouldn't have been there.  Both had amounts equal to two other valid charge

Re: [GNC] Identify error transaction in QIF import

2024-04-28 Thread Geoff
Hello HH Please read this: https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111431.html Regards Geoff = On 28/04/2024 9:43 pm, hh8...@gmail.com wrote: Hi, Thanks for the advice. I run Quicken -> Validate and Repair File and it reported a few errors that I fixed.

Re: [GNC] Identify error transaction in QIF import

2024-04-28 Thread Christopher Lam
Please pick a recent build from https://code.gnucash.org/builds/win32/stable/ On Sun, 28 Apr 2024 at 21:54, Hao Huang wrote: > Hi, > > The original problem was "The erroneous transaction seems to be the last > of those imported". If that's the case, it won't apply. What is shown in my > case is

[GNC] Use 4.14 and 5.6 on same file (at different times)

2024-04-28 Thread Fred Tydeman
Will I run into problems if I use both GnuCash 4.14 and 5.6 on the same file / book? That is, 4.14 is on my current production Linux system and where I use Gnucash. I have installed a later Linux system on a different disk partition and it has Gnucash 5.6 If I were to use Gnucash 5.6 to enter some

Re: [GNC] Finance-Quote 1.61 released!

2024-04-28 Thread Bruce Schuck
On 4/28/24 06:28, Klaus Dahlke wrote: It took a while to figure out why yahoo_json didn't work. When trying to fetch the cookie from fc.yahoo.com the response was 'connection refused', also when trying to connect via browser. In the end it turned out that pihole blocked fc.yahoo.com. Once I

[GNC] The equivalent for Quicken Tag

2024-04-28 Thread hh8923
Hi, I'm new to GnuCash. In Quicken, I use Tag a lot. For example, I create one tag for each charity and set a single category for Donation and use Tag to track charity. Search yielded discussion in 2017 as the latest when it's not available. What's the latest status? If not available,

Re: [GNC] The equivalent for Quicken Tag

2024-04-28 Thread Geoff
Hi HH There are several solutions to this scenario, here is one using the chart of accounts. EXPENSES --AUTOMOBILE FUEL REPAIRS --DONATIONS CHARITY01 CHARITY02 CHARITY03 --EDUCATION BOOKS FEES etc etc Hope this helps. Regards Geoff = On 29/04/2024 11:03

Re: [GNC] The equivalent for Quicken Tag

2024-04-28 Thread Geoff
Hi HH > This means a sub category for each charity. No, a sub Account. GnuCash isn't Quicken and you need to change your mindset to get the best results from using it. > In Stack Exchange, some suggested to use Note or Label. As I said, there are several solutions to this scenario, here is

Re: [GNC] The equivalent for Quicken Tag

2024-04-28 Thread Jim Passmore
How about a sub-account for each charity, as Geoff suggested, and *zero* tags? Once you have the sub-accounts and use them, you can track the charity by running a transaction report. Go to options, select Donations and all the sub accounts on the accounts tab, and set the desired date range on

Re: [GNC] The equivalent for Quicken Tag

2024-04-28 Thread sunfish62--- via gnucash-user
For your example, I simply use a report that subtotals by description. One account (Expenses:Charity). Each transaction uses the charity name for the description. Report Subtotal set to use Description. Report tells me each charity and its annual total. Easy. As for why this hadn't been

Re: [GNC] Identify error transaction in QIF import

2024-04-28 Thread hh8923
Good news. The last stable build Apr 28 could import the full QIF file. It took 9 hours but finished with some warning (those stocks that no longer exists). Now my question is whether I should wait for a released version – otherwise if the build has some bugs it would be very difficult to

Re: [GNC] The equivalent for Quicken Tag

2024-04-28 Thread hh8923
Hi, This means a sub category for each charity. Now, if we have c categories and t tags, in Quicken we'd have c*t number of combination. Creating 1 sub category for each tag under each category will be tedious. In Stack Exchange, some suggested to use Note or Label. But I could not seem to

Re: [GNC] Identify error transaction in QIF import

2024-04-28 Thread hh8923
Some quick check shows some account balance does not match – including credit card or banking. This is a bad situation as I have to manually find what’s missing. When the conversion finished, it only has warning of stock symbols. What can I do to find what transaction was missed? Thanks

Re: [GNC] The equivalent for Quicken Tag

2024-04-28 Thread hh8923
I turned on double line and can see Notes. There is one more space next to it but it’s not editable. The example for Donation can be solved with several different approach. It’s more challenge to solve the general problem. For example, there are multiple sub-account under main Account

Re: [GNC] One LLC pay expense of another LLC

2024-04-28 Thread Michael or Penny Novack
On 4/28/2024 12:17 PM, Fred Tydeman wrote: If LLC-a pays an expense of LLC-b ie, cash from LLC-a goes to expense of LLC-b, should I also show a transfer of equity from LLC-a to LLC-b? It seems that needs to be done so that the Balance sheet for LLC-b is correct. This is an accounting problem,

[GNC] The equivalent for Quicken Tag

2024-04-28 Thread flywire
Use the custom transaction report at https://github.com/dawansv/gnucash-custom-reports?tab=readme-ov-file#tag-prefix ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: