[GNC] Fwd: ^F Find not finding recently entered text in Memo field

2023-01-23 Thread David Carlson
I will never learn how Gmail works. -- Forwarded message - From: David Carlson Date: Mon, Jan 23, 2023 at 10:22 PM Subject: Re: [GNC] ^F Find not finding recently entered text in Memo field To: Jeff Albrecht , Jeff, Please reply to list so others can contribute to the

[GNC] Fwd: Delivery Status Notification (Failure)

2023-01-23 Thread David Carlson
I cut and pasted an incomplete address. This should work -- Forwarded message - From: Mail Delivery Subsystem Date: Mon, Jan 23, 2023 at 10:22 PM Subject: Delivery Status Notification (Failure) To: [image: Error Icon] Address not found Your message wasn't delivered to

Re: [GNC] No Online Banking List of Banks

2023-01-23 Thread john
That is/was provided by ofxhome.com , which has new owners: https://www.ofxhome.com/ofxforum/viewtopic.php?pid=109005 Maybe something has changed that broke whatever API AQBanking uses. You can still do your queries on the website and copy the info into AQBanking setup

Re: [GNC] Questions about setting up new accounts from brand new user

2023-01-23 Thread R Losey
I agree. I let GnuCash create a chart of accounts and then modify it to meet my needs. On Mon, Jan 23, 2023 at 12:21 PM David Carlson wrote: > Maf showed you how to start to create a single account. > > If you want to create an entire chart of accounts click File > New and > select the option

Re: [GNC] Entering Dividend Confusion

2023-01-23 Thread R Losey
On Sat, Jan 21, 2023 at 3:28 PM flywire wrote: > R Losey wrote: > >> You need to make sure that your... stock is set up as an account type of >> "Mutual Fund" or "Stock" > > No you don't, dividends can be entered into a dividend account like any > other transaction. The main feature of a "Stock"

Re: [GNC] Is there any way to find all outstanding bills?

2023-01-23 Thread Dr. David Kirkby
On Tue, 24 Jan 2023 at 01:50, Murugan Muruganandam < m.muruganan...@hotmail.com> wrote: > have you tried looking at the Payable ageing report > > > Saludos Cordiales > > > Murugan > No, I had not, and that seems to have what I wanted. I'm just a bit puzzled that some of the figures don't make

[GNC] No Online Banking List of Banks

2023-01-23 Thread Nicholas Rood via gnucash-user
Hello, I've been using GnuCash for quite a while mainly on Linux but haven't added any new online banking info in a long time.  In the online banking setup there is no longer a list of banks populated in the bank settings for OFX DirectConnect User Setup. GnuCash 4.13 Build ID: Flathub 4.13

Re: [GNC] Is there any way to find all outstanding bills?

2023-01-23 Thread Murugan Muruganandam
have you tried looking at the Payable ageing report Saludos Cordiales Murugan From: gnucash-user on behalf of Dr. David Kirkby Sent: Monday, January 23, 2023 7:25 PM To: GNU Cash User Subject: [GNC] Is there any way to find all outstanding bills? A

Re: [GNC] Is there any way to find all outstanding bills?

2023-01-23 Thread Adrien Monteleone
The Bills Due Reminder is not just short term, it should show all unpaid bills *that are posted*. (in conjunction with setting the reminder window via Preferences > Business > Bills > Notify when due & Days in advance.) You can also do Business > Vendor > Find Bill and set the criteria to

Re: [GNC] Questions about setting up new accounts from brand new user

2023-01-23 Thread Adrien Monteleone
On 1/23/23 2:33 PM, flywire wrote: that isn't the latest, nor official documentation. No, it's not but it is the version I recommend. Feedback on how it compares with the official version would be useful. The official documentation should always be the recommendation. It is actively

Re: [GNC] ^F Find not finding recently entered text in Memo field

2023-01-23 Thread David Carlson
Jeff, Is the text that you are searching for in a split line for the home bank register or is it in the "other" split line? On Mon, Jan 23, 2023, 4:41 PM Jeff Albrecht wrote: > On 1/23/2023 3:27 PM, David H wrote: > > Jeff, > > > > If you do a find from the accounts tab it will search in all

Re: [GNC] Merge two pairs -> one 4-way split

2023-01-23 Thread Justin Vallon
Maybe unrelated, but when entering reimbursable transactions, I enter a second transaction to indicate a reimbursable expense. Mostly so I don't lose it. For example: Day1 Doctor Visit - Copay                          Amex  -20                      Doc       +20                

[GNC] python bindings: How to add or get commodity quotation records in python?

2023-01-23 Thread Arkadiusz Dabrowski
Hi all In GnuCash GUI I'm able to add commodity quotations manually. But I'd like to add some quotations using my own script Surprisingly I don't see any related operation in GncCommodity class. Also I haven't found anything interesting in gnc-commodity.h Have I missed something? Is it possible at

Re: [GNC] ^F Find not finding recently entered text in Memo field

2023-01-23 Thread Jeff Albrecht
On 1/23/2023 3:27 PM, David H wrote: Jeff, If you do a find from the accounts tab it will search in all splits, if however you do a find in a Register tab it only looks at splits for that particular Register, it doesn't search in splits belonging to other Register's.  Are you falling into

Re: [GNC] ^F Find not finding recently entered text in Memo field

2023-01-23 Thread David H
Jeff, If you do a find from the accounts tab it will search in all splits, if however you do a find in a Register tab it only looks at splits for that particular Register, it doesn't search in splits belonging to other Register's. Are you falling into this trap ? Cheers David H. On Tue, 24

[GNC] Is there any way to find all outstanding bills?

2023-01-23 Thread Dr. David Kirkby
A look at* Liabilities:Accounts Payable* allows me to find out how much. If the bills are due, then looking at Business -> Vendor -> Bills Due Reminder, will allow me to find any that need to be paid soon. But is there any way of finding a list of everyone owed money at some time in the future? I

[GNC] ^F Find not finding recently entered text in Memo field

2023-01-23 Thread Jeff Albrecht
Windows 11 Version: 4.13 Build ID: 4.13+(2022-12-17) FWIW I've been, happily, using GNUCash for several years. I'm working on my 2022 taxes importing .OFX files from my banks. I generally want to add a memo on most transactions with notes  found from the vendor transaction details on their

Re: [GNC] Exporting Reports to CSV

2023-01-23 Thread Phyllis Bruce
Thanks David, my first try of copy and paste showed me it would be too much work. I found this site: www.myofficetricks.com › how-to-import-data-from How to Import Data from HTML into Excel - My Microsoft Office ...

Re: [GNC] Questions about setting up new accounts from brand new user

2023-01-23 Thread David Cousens
Ann, I you are getting the window with the Accounts tab (it is the default until you open an account register) click on it then right click on whichever of the top level accounts you wish to create the account under and slect New Account and the account creation dialogue will come up. You can edit

Re: [GNC] Exporting Reports to CSV

2023-01-23 Thread David Cousens
Phyllis , You can copy and paste from the html opened in a browser into Excel or Libre Office. Certainly isn't perfect but most of the alignment is kept but if you are going that route, you are going to reformat it anyway. David Cousens On Mon, 2023-01-23 at 10:35 -0600, Phyllis Bruce wrote: >

Re: [GNC] Getting OFX files via the command line: (was: Re: Morgan Stanley Portfolio)

2023-01-23 Thread Stephen
This is quite interesting. I'm not sure if I'm a future user but I do love to learn and explore things. I know zip about Python. I did explore the links a bit. I'm way over my head. One thing I did notice was the SSL Failed validation msgs in the ofxhome directory for Morgan Stanley and for

[GNC] Questions about setting up new accounts from brand new user

2023-01-23 Thread flywire
If you do the "Putting It All Together" sections as you go through the guide you will learn the basics and have a sample set of books. It starts with: https://gnucash-docs-rst.readthedocs.io/en/latest/guide/C/ch_basics.html#putting-it-all-together > that isn't the latest, nor official

[GNC] farm

2023-01-23 Thread James Baxter via gnucash-user
Miss Ann.I am a Gnucash user. I use it to keep up with my check book and others.  But I don't need to get away from Gnucash. There is Quick Books out there. I don't know if Gnucash will help you. There are alot of things that go into farming. As I am looking to get to that point.  As like you.

Re: [GNC] Exporting Reports to CSV

2023-01-23 Thread Adrien Monteleone
For completeness, Once you have the report in the spreadsheet app of choice, you can then save/export from there as CSV if that format is otherwise still needed. Regards, Adrien On 1/23/23 11:32 AM, Phyllis Bruce wrote: Oops, never mind. Found good instructions on Chrome.

Re: [GNC] Questions about setting up new accounts from brand new user

2023-01-23 Thread Adrien Monteleone
Ann, that isn't the latest, nor official documentation. For that, see https://gnucash.org/docs.phtml (the Documentation link from the left-hand menu under either Downloads or Support) There is the 'Help' and the 'Tutorial & Concepts Guide'. Both should be accessible from the Help menu when

Re: [GNC] Questions about setting up new accounts from brand new user

2023-01-23 Thread David Carlson
Maf showed you how to start to create a single account. If you want to create an entire chart of accounts click File > New and select the option to create New Account Hierarchy Setup You might want to try this more than once because it will then give you a lot of choices for different

Re: [GNC] Exporting Reports to CSV

2023-01-23 Thread Phyllis Bruce
Oops, never mind. Found good instructions on Chrome. On Mon, Jan 23, 2023 at 11:26 AM Phyllis Bruce wrote: > Thanks Maf. Do I assume a comma delimiter or what? I'm familiar with > importing delimited files into excel. > > On Mon, Jan 23, 2023 at 10:54 AM Maf. King wrote: > >> >> >> On

Re: [GNC] Exporting Reports to CSV

2023-01-23 Thread Dan Black
Copy and paste into Excel is also an option. Dan On January 23, 2023 12:26:49 PM Phyllis Bruce wrote: Thanks Maf. Do I assume a comma delimiter or what? I'm familiar with importing delimited files into excel. On Mon, Jan 23, 2023 at 10:54 AM Maf. King wrote: On Monday, 23 January

Re: [GNC] Questions about setting up new accounts from brand new user

2023-01-23 Thread Maf. King
On Monday, 23 January 2023 17:10:51 GMT Ann Bowes wrote: > Hi folks, > > I'm trying to set up a simple manual checking account for a small farm > business. I've down-loaded the gnucash program to my laptop (linux > zorin OS), and have tried to open new accounts, but am completely > stumped as to

Re: [GNC] Exporting Reports to CSV

2023-01-23 Thread Phyllis Bruce
Thanks Maf. Do I assume a comma delimiter or what? I'm familiar with importing delimited files into excel. On Mon, Jan 23, 2023 at 10:54 AM Maf. King wrote: > > > On Monday, 23 January 2023 16:35:21 GMT Phyllis Bruce wrote: > > I found out how to export transactions, but how can I export my

[GNC] Questions about setting up new accounts from brand new user

2023-01-23 Thread Ann Bowes
Hi folks, I'm trying to set up a simple manual checking account for a small farm business.  I've down-loaded the gnucash program to my laptop (linux zorin OS), and have tried to open new accounts, but am completely stumped as to how to do this.  I've read through the tutorial (at

Re: [GNC] Exporting Reports to CSV

2023-01-23 Thread Maf. King
On Monday, 23 January 2023 16:35:21 GMT Phyllis Bruce wrote: > I found out how to export transactions, but how can I export my Tax report > as CSV? My only options are HTML or TXF, neither allow me to reformat in > Excel. > LibreOffice calc can work on the HTML export; I imagine that excel

[GNC] Exporting Reports to CSV

2023-01-23 Thread Phyllis Bruce
I found out how to export transactions, but how can I export my Tax report as CSV? My only options are HTML or TXF, neither allow me to reformat in Excel. Thanks, Pobruce ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Re: [GNC] exporting from gnucash to Excel

2023-01-23 Thread Maf. King
Just a thought - can you mangle the VAT spreadsheet to sum the CSV exported box 1 and box 6 (nett) figures to give you a grossed-up number? Maf. On Thursday, 19 January 2023 17:20:31 GMT you wrote: > How could I organise my accounts such that I can pull my total sales > including VAT into

[GNC] Getting OFX files via the command line: (was: Re: Morgan Stanley Portfolio)

2023-01-23 Thread Ed Greenberg
This was a great success.   I'll embellish a bit for the sake of others. 1. Install ofxtools.  For Windows, you may need python. For Mac and Linux, it's probably there. Go to  https://ofxtools.readthedocs.io/en/latest/index.html to get the documentation, which includes an "Installing"

Re: [GNC] QIF upload ends abruptly at import step, last message "Transaction with no or only one associated account"

2023-01-23 Thread davidbrown.rdps
A quick question regards "Save As" I find that there is quite a delay in the SaveAs dialog box appearing and the main window shows "Not Responding". Is that a normal delay all users find? Regards David -- This email has been checked for viruses by AVG antivirus software. www.avg.com