Re: [GNC] Unable to open GnuCash file: "No suitable backend was found for ."

2023-07-13 Thread Tomer Altman
On 7/13/23 8:55 AM, john wrote: On Jul 13, 2023, at 01:34, Tomer Altman wrote: On 7/12/23 6:26 PM, john wrote: On Jul 12, 2023, at 16:16, Tomer Altman wrote: Hi everyone, Due to filesystem errors, I had to reinstall MacOS on my 2015 Macbook Air (current OS version: Monterey 12.6.7).

[GNC] Two Instances as opposed to two separate files

2023-07-13 Thread Ken Pyzik
Question about a matter of setup. I use Windows 11 - so answers/information specific to that OS would be appreciated. First - can two instances of the program be loaded (exist in the system) such that one instance opens a personal file and one opens a business file? Second - if answer to questi

[GNC] Yahoo Closed the Door on Finance API

2023-07-13 Thread Bruce Schuck
Some of us suspected this would come, getting reports of the Yahoo URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics and https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatisti

Re: [GNC] Equity Account "problem"

2023-07-13 Thread Michael or Penny Novack
1) Gnucash account ledgers should be thought of as primarily just a place to enter and edit actual transactions. That's a SHORT CUT and available only when the transaction being entered has just a single debit and single credit. In a way a "special case" except probably true for 90+% of your

Re: [GNC] Window/Mac Summary Box difference

2023-07-13 Thread Stephen M. Butler
So I deleted those two transactions and Profits stayed at zero. Ended up quitting with saving.  On startup again the Profit was back and correct. Stephen M Butler stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D4

Re: [GNC] Window/Mac Summary Box difference

2023-07-13 Thread Stephen M. Butler
Based on some experimentation, I suspect: 1.  Grand Total should always be zero (blank).  If ever non-zero it means you have an out-of-balance transaction (maybe more than one) somewhere. 2.  Net Assets appears to be Assets - Liabilities + Income - Expenses.  So, Total Equity including retai

Re: [GNC] Equity Account "problem"

2023-07-13 Thread Default User
On Thu, 2023-07-13 at 10:25 -0400, Michael or Penny Novack wrote: > On 7/12/2023 8:18 PM, Default User wrote: > > On Wed, 2023-07-12 at 16:38 -0400, Michael or Penny Novack wrote: > > > On 7/11/2023 6:48 PM, Default User wrote: > > > > This is a case of not knowing the history (how bookkeeping c

Re: [GNC] Window/Mac Summary Box difference

2023-07-13 Thread Adrien Monteleone
On a Mac here (Monterey) and I can't get it to do anything via double-click. It just shows the other currency options same as the drop down arrow. None of my Summary numbers make any sense either, and my "$, Grand Total:" shows nothing like yours. Regards, Adrien On 7/13/23 3:43 PM, David H

Re: [GNC] Window/Mac Summary Box difference

2023-07-13 Thread David H
My Grand Total always just shows as "$, Grand Total:" - hasn't had an amount in it forever so I just ignore these figures anyway as they're quite meaningless to me :-) There's a dropdown arrow on the right hand side that you can use to expand the items on that line - shows entries for each currenc

[GNC] Message-ID:

2023-07-13 Thread Neil Campbell
If you scroll down in the summary box you will see additional rows identified by the currencies and securities in that file, if any exist. Perhaps that would lead to an account and one or more transactions that contain an incomplete closing transaction where some asset or liability was exchanged wi

[GNC] Message-ID:

2023-07-13 Thread Neil Campbell
Perhaps a Balance Sheet would work better. You'd only need to know the headline numbers: Total Assets Total Liabilities Total Equity (perhaps, Retained Earnings/Losses, if you like, though that is part of the Equity section) Goo point Adrian. I was thinking that too, just as long as the figure

Re: [GNC] Unable to open GnuCash file: "No suitable backend was found for ."

2023-07-13 Thread Paul Feakins
Tomer, Good that you sorted it. Note though that if it's gzip-compressed it's an XML file, not a sqlite3 database. Does `file` on the apparently corrupted gnucash file claim that it's a sqlite3 database? Regards, John Ralls You can just add ".tar" to the filename and then unzip it. At lea

Re: [GNC] Unable to open GnuCash file: "No suitable backend was found for ."

2023-07-13 Thread john
> On Jul 13, 2023, at 01:34, Tomer Altman wrote: > > On 7/12/23 6:26 PM, john wrote: >> >> >>> On Jul 12, 2023, at 16:16, Tomer Altman wrote: >>> >>> Hi everyone, >>> >>> Due to filesystem errors, I had to reinstall MacOS on my 2015 Macbook Air >>> (current OS version: Monterey 12.6.7).

Re: [GNC] Window/Mac Summary Box difference

2023-07-13 Thread David Carlson
Neil, If you scroll down in the summary box you will see additional rows identified by the currencies and securities in that file, if any exist. Perhaps that would lead to an account and one or more transactions that contain an incomplete closing transaction where some asset or liability was excha

Re: [GNC] Window/Mac Summary Box difference

2023-07-13 Thread Adrien Monteleone
I'm not sure exactly how those numbers are calculated and I've never relied on them. Perhaps a Balance Sheet would work better. You'd only need to know the headline numbers: Total Assets Total Liabilities Total Equity (perhaps, Retained Earnings/Losses, if you like, though that is part of t

Re: [GNC] Equity Account "problem"

2023-07-13 Thread Michael or Penny Novack
On 7/12/2023 8:18 PM, Default User wrote: On Wed, 2023-07-12 at 16:38 -0400, Michael or Penny Novack wrote: On 7/11/2023 6:48 PM, Default User wrote: This is a case of not knowing the history (how bookkeeping changed over ~thousand year history) and never having kept books pen and ink on pa

Re: [GNC] How to record 'balancing' trnsactions?

2023-07-13 Thread Paul Feakins
On 13/07/2023 10:22, ed...@billiau.net wrote: On Wed, 12 Jul 2023 21:14:51 +0100 Chris Green wrote: Nope, I replied to the list, gnucash-user@gnucash.org, as one should. Here's the headers:- Date: Wed, 12 Jul 2023 14:25:33 +0100 From mairix@mairix Mon Jan 1 12:34:56 1970 From

[GNC] Window/Mac Summary Box difference

2023-07-13 Thread Neil Campbell
I help a friend with their monthly accounting. She has GNUCash installed on a PC. I have GNUCash installed on a Mac mini M1 computer. She does the input. I do the month end transactions and check her input. So we send GNUCash data files backwards and forwards. The way I identify the file I have

Re: [GNC] How to record 'balancing' trnsactions?

2023-07-13 Thread edodd
On Wed, 12 Jul 2023 21:14:51 +0100 Chris Green wrote: > > > > Nope, I replied to the list, gnucash-user@gnucash.org, as one > > should. > Here's the headers:- > > Date: Wed, 12 Jul 2023 14:25:33 +0100 > From mairix@mairix Mon Jan 1 12:34:56 1970 > From: Paul Feakins > To: Chr

Re: [GNC] Unable to open GnuCash file: "No suitable backend was found for ."

2023-07-13 Thread Tomer Altman
On 7/12/23 6:26 PM, john wrote: On Jul 12, 2023, at 16:16, Tomer Altman wrote: Hi everyone, Due to filesystem errors, I had to reinstall MacOS on my 2015 Macbook Air (current OS version: Monterey 12.6.7). After doing so, and restoring my files from a TimeMachine backup using Migration As

Re: [GNC] How to record 'balancing' trnsactions?

2023-07-13 Thread Michael Hendry
On 13 Jul 2023, at 08:01, Chris Green wrote: > > On Wed, Jul 12, 2023 at 02:51:39PM -0700, Vincent Dawans wrote: >> Leaving aside the why you need 2 sets of books, I'll just focus on the how. >> >> First you need to decide if the money in and money out really needs to be >> classified as income

Re: [GNC] How to record 'balancing' trnsactions?

2023-07-13 Thread Chris Green
On Wed, Jul 12, 2023 at 02:51:39PM -0700, Vincent Dawans wrote: > Leaving aside the why you need 2 sets of books, I'll just focus on the how. > > First you need to decide if the money in and money out really needs to be > classified as income and expenses in your first set if books (the main bank