Re: [GNC] Running mixed versions (okay?)

2024-02-24 Thread David H
It's all documented in the wiki at https://wiki.gnucash.org/wiki/Flatpak including how to run it :-) Cheers David H On Sun, 25 Feb 2024 at 5:29 pm, R Losey wrote: > As a follow-up to this, I installed flatpack and installed GnuCash (there > was a lot of good how-to stuff)... what was harder to

Re: [GNC] Running mixed versions (okay?)

2024-02-24 Thread R Losey
As a follow-up to this, I installed flatpack and installed GnuCash (there was a lot of good how-to stuff)... what was harder to find (not lots harder, but enough to be annoying) was how to run it from flatpak. I found it and am running 5.5. I then removed the repository GnuCash 4.8 so I won't

Re: [GNC] Running mixed versions (okay?)

2024-02-24 Thread R Losey
Thanks for this... I haven't seen any notice about file changes between major versions (probably because - as you say - it is silently checked). Yes, the Ubuntu version is from the repository. I'll have to look up installing flatpak to get the 5.x version of GnuCash - I'm not going to do the

Re: [GNC] Removing Scheduled Transaction From a Closed Year

2024-02-24 Thread Gyle McCollam
Even if you don't have "Review created transactions" preference checked on, you can always use the find option. Look for "Date Posted" use the "is on or after" option to find all transactions after 1/1/?? and you can then delete them. You would have to change the preference before you open an

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread David H
So basically you got rid of the quotes around everything as I suggested :-) Cheers David H. On Sun, 25 Feb 2024 at 11:17, Alan Johnson via gnucash-user < gnucash-user@gnucash.org> wrote: > So, I was working on it and here was that worked as I was playing with > it. I'm using LibreOffice to edit

Re: [GNC] Net Assets

2024-02-24 Thread Fred Tydeman
On Sat, Feb 24, 2024 at 4:23 PM Fred Tydeman wrote: > The "Net Assets" value at the bottom of the screen does NOT match the > Assets account Present(USD) value. > So, when I saw the word "Net", I assumed Assets-Liability. > But, as you pointed out, that would be Equity. > > If I play with

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Alan Johnson via gnucash-user
So, I was working on it and here was that worked as I was playing with it. I'm using LibreOffice to edit the CSVs.  Edit the filter on the "save as" dialog, then I set the field delimiter and deleted the string delimiter and unchecked 'quote all text cells'.  Then I was able to successfully able

Re: [GNC] Removing Scheduled Transaction From a Closed Year

2024-02-24 Thread David H
Correct, I'm aware of the preference and also have it checked on as it saves me keystrokes :-) What is the point of the preference? Well obviously most times it's useful and saves you having to run the "Since last run" process to create them yourself. But for the odd time that you don't want

Re: [GNC] Net Assets

2024-02-24 Thread Fred Tydeman
799026 appears to be that bug report (search for "Summary Bar") On Sat, Feb 24, 2024 at 4:06 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > And I'm pretty sure there is a bug filed on it. > > Regards, > Adrien > > On 2/24/24 2:14 PM, David H wrote: > > Thank you for that as I

Re: [GNC] Net Assets

2024-02-24 Thread Fred Tydeman
The "Net Assets" value at the bottom of the screen does NOT match the Assets account Present(USD) value. So, when I saw the word "Net", I assumed Assets-Liability. But, as you pointed out, that would be Equity. If I play with Edit:Preferences:Accounting Period I can keep or remove Grand total (at

Re: [GNC] Net Assets

2024-02-24 Thread David H
And don't forget there's preferences for this :-) [image: gnucash_MNvtUxxRux.png] On Sun, 25 Feb 2024 at 10:06, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > And I'm pretty sure there is a bug filed on it. > > Regards, > Adrien > > On 2/24/24 2:14 PM, David H wrote: > > Thank you

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread David H
Aha I read that as you'd tried it with and without the header line nothing was said about the quotes :-) On Sun, 25 Feb 2024 at 10:11, Alan Johnson wrote: > I did read the manual, hence my usage of the quotes. I had done it before > without. > > I'll make a video and send it out shortly. > >

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Alan Johnson via gnucash-user
I did read the manual, hence my usage of the quotes. I had done it before without.   I'll make a video and send it out shortly.  Alan On Sun, 2024-02-25 at 10:02 +1000, David H wrote: > Alan, > > Your file imports fine here after I add the vendor, create the > Accounts Payable liability,

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Adrien Monteleone
There is the caveat, noted in that link, that if you use the same delimiter for your account tree as the CSV, then (and only then) do you need to enclose account references in double-quotes. (this is generally a CSV thing, not something specific to GnuCash) Regards, Adrien On 2/24/24 6:02

Re: [GNC] Net Assets

2024-02-24 Thread Adrien Monteleone
And I'm pretty sure there is a bug filed on it. Regards, Adrien On 2/24/24 2:14 PM, David H wrote: Thank you for that as I don't think that in 10 or more years of using Gnucash that I've realised that it is a drop down list :-) I've always been puzzled as to why it always shows a zero amount

Re: [GNC] Removing Scheduled Transaction From a Closed Year

2024-02-24 Thread Adrien Monteleone
That would be: Preferences > Scheduled Transactions > Since Last Run > Run when data file opened. So you want a dialog box to confirm the preference each time? What's the point of the preference then? Regards, Adrien On 2/24/24 2:03 PM, David H wrote: Strikes me that it wouldn't be a bad

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread David H
Alan, Your file imports fine here after I add the vendor, create the Accounts Payable liability, remove the header line and remove the double quotes that you have plastered around every field for some reason which probably causes the other errors. It might pay to read up on Gnucash Bills

Re: [GNC] Net Assets

2024-02-24 Thread Michael or Penny Novack
On 2/24/2024 2:10 PM, Fred Tydeman wrote: I am looking at the Accounts account screen. At the bottom of the screen, is Net Assets: $xxx and Profits: $yyy I assume Net Assets is the current value of Assets - Liabilities. If that is the case, numbers are wrong by a lot. Wrong assumption. If

Re: [GNC] Net Assets

2024-02-24 Thread Stan Brown (using GC 4.14)
Thanks for writing, but nothing changes in the display, whether I hold down the mouse button or not. But see David H's screen shot, sent a few minutes ago. That shows many currencies, but everything in my book is in US$, so I suspect that's why I don't get anything in the drop-down. Stan Brown

Re: [GNC] Net Assets

2024-02-24 Thread Fred Tydeman
The grand total net assets on bottom of screen does not match Balance Sheet. Also, what date is being used for Grand Total net assets? Today? End of accounting period? On Sat, Feb 24, 2024 at 11:36 AM Murugan Muruganandam < m.muruganan...@hotmail.com> wrote: > fred > > the bottom ticker net

Re: [GNC] Net Assets

2024-02-24 Thread Fred Tydeman
With arrow/cursor over "down arrow" on right side of bottom line, Press and hold down the left mouse button . While still pressing down the left mouse button, press "down cursor/arrow button" (can also press up arrow button to scroll thru the list of assets). Trying again, it appears one does not

Re: [GNC] Net Assets

2024-02-24 Thread Stan Brown (using GC 4.14)
Thanks. Maybe it's because everything is in US dollars in my books. I see from your screen shot that it gives you different currencies to choose from, but that wouldn't apply to me. Stan Brown Tehachapi, CA, USA https://BrownMath.com On 2024-02-24 15:12, David H wrote: > Stan, > > This is what

Re: [GNC] Net Assets

2024-02-24 Thread David H
Stan, This is what it looks like dropped down in Gnucash 5.5. Cheers David H. [image: gnucash_Vif9y3IJMz.png] On Sun, 25 Feb 2024 at 09:08, Stan Brown (using GC 4.14) < stan...@fastmail.fm> wrote: > Is this a new thing (or possibly a fixed bug) in 5.x? > > In 4.14 I have Net Assets and

Re: [GNC] Net Assets

2024-02-24 Thread Stan Brown (using GC 4.14)
Is this a new thing (or possibly a fixed bug) in 5.x? In 4.14 I have Net Assets and Profits at the bottom of my Accounts list as Fred described, and there is a drop-down arrow, but all it does is make the bar containing Net Assets and Profits wider than the GC window. I can't see anything to

Re: [GNC] Net Assets

2024-02-24 Thread David H
Murugan, Thank you for that as I don't think that in 10 or more years of using Gnucash that I've realised that it is a drop down list :-) I've always been puzzled as to why it always shows a zero amount for "$, Grand Total" on the left hand side when in actual fact this is just displaying the

Re: [GNC] Removing Scheduled Transaction From a Closed Year

2024-02-24 Thread David H
What OS & Gnucash version ? What I would try is to just close all apps running/open on your pc, then set your pc date and time to the last updated date/time of your Gnucash file. Open the file which hopefully won't trigger any scheduled txns and then turn off the "run when data file opened"

Re: [GNC] Net Assets

2024-02-24 Thread Murugan Muruganandam
fred the bottom ticker net asset displays multiple accounts, from the drop down select Grand total then it will show you the net asset as per your balance sheet Saludos Cordiales Murugan From: gnucash-user on behalf of Fred Tydeman Sent: Saturday,

[GNC] Net Assets

2024-02-24 Thread Fred Tydeman
I am looking at the Accounts account screen. At the bottom of the screen, is Net Assets: $xxx and Profits: $yyy I assume Net Assets is the current value of Assets - Liabilities. If that is the case, numbers are wrong by a lot. If that is not the case, what is Net Assets? Running GnuCash 4.14 on

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Alan Johnson via gnucash-user
I tried that with the same result. GNC says it ignored that line, and that's fine. I'm concerned with the error messages indicating that the vendor and accounts don't exist. Have I input that data incorrectly? Feb 24, 2024 13:00:20 Adrien Monteleone : > Although you should be able to have

Re: [GNC] Trouble importing bills via csv

2024-02-24 Thread Adrien Monteleone
Although you should be able to have header row(s), perhaps remove it and try again. The Documentation for this is worded oddly, but the samples provided don't show header info at all. https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html Regards, Adrien On 2/24/24

Re: [GNC] Running mixed versions (okay?)

2024-02-24 Thread Adrien Monteleone
There are some changes between major versions. There are checks silently run when you first open your file with a new major version. You can run those checks explicitly via Actions > Check & Repair. The goal is usually to keep compatibility between the last minor release of a major version

Re: [GNC] Removing Scheduled Transaction From a Closed Year

2024-02-24 Thread Michael or Penny Novack
On 2/23/2024 4:02 PM, Stan Brown (using GC 4.14) wrote: On 2024-02-23 10:46, Grace wrote: I am needing to revisit my GNUCash records for 2022. I forgot to erase all the scheduled transaction before I "archived" it, so now when I open the app, it applies all the scheduled transaction for 2023

[GNC] Running mixed versions (okay?)

2024-02-24 Thread R Losey
So I have wonderful GnuCash installed on WIndows 10, on an M1 iMac, and on Linux (Ubuntu 22.04LTS). I mostly use the iMac and Windows versions, and I've always kept these two versions in sync; that is, when I decided to upgrade to 5.1, I install 5.1 back-to-back on the iMac and Windows

Re: [GNC] Bank Balance Higher Than Actual

2024-02-24 Thread G R Hewitt
Hello Paul, There are many possible reasons why your GnuCash (GC) bank balance is higher than the actual bank account, and so you will need to be methodical in your approach to fixing it. In the first instance, I would go through the statements from the bank and see if there are any entries that

Re: [GNC] Bank Balance Higher Than Actual

2024-02-24 Thread Paul Roberts
Since the invoice amount shows up in Accounts Receivable I will need to investigate more closely to discover why the statement balance is so much higher than the actual bank balances. One reason would be that someone is stealing our money, but I find that quite hard to believe. The other