Re: [GNC] Any way to clean up (not totally delete) saved auto-complete saved register entries?

Are they in the gzipped xml text of the data file, where they could be edited into a new order, or in the user config files, like current tabs showing? Many such features use some sort of help, like sorting so the top of the list is probable and defunct suggestions are deep in the basement, and

Re: [GNC] Any way to clean up (not totally delete) saved auto-complete saved register entries?

On Sun, 22 Dec 2024 08:21:44 -0800 Steve Miller wrote: > And separately, and I know this has come up again and again (and > again), I just find the format of this email list so difficult to > read and search. I've asked Santa year after year, guess I've been > bad... Sorry, but it's not as bad

Re: [GNC] Any way to clean up (not totally delete) saved auto-complete saved register entries?

Yes, but it takes a lot of work. You would need to standardize your descriptions to a select few and modify all prior entries to be in that selected set. On Sun, Dec 22, 2024, 08:23 Steve Miller wrote: > Running Windows 11, GnuCash 5.10. > > My checking account registers have so m

Re: [GNC] Any way to clean up (not totally delete) saved auto-complete saved register entries?

Are you talking about the list of choices that appears in the autocomplete dialog? That could become a serious issue if it keeps getting longer. On Sun, Dec 22, 2024, 10:23 AM Steve Miller wrote: > Running Windows 11, GnuCash 5.10. > > My checking account registers have so many saved auto-comple

[GNC] Any way to clean up (not totally delete) saved auto-complete saved register entries?

Running Windows 11, GnuCash 5.10. My checking account registers have so many saved auto-complete options that I'll never use again in my lifetime, anyway to edit that last so one can do some kind of clean-up, so I'm not looking at an excessive drop down that I have to scroll each time? And separa

Re: [GNC] Credit Card entries

Courtey One critical bit of information. A bank prepares your credit card statement from their position where your account is an asset to them whereas for you the credit card is a liability. This means that debits and credits are reversed in your books wrt to the use of debits and credits as used

Re: [GNC] Credit Card entries

Courtney, Read chapter 7 of the Tutorial < https://gnucash.org/viewdoc.phtml?rev=5&lang=C&doc=guide> On Thu, Dec 12, 2024 at 1:06 PM Courtney Perry via gnucash-user < gnucash-user@gnucash.org> wrote: > What is the correct entry procedures for recording card transactions from > the monthly stat

[GNC] Credit Card entries

What is the correct entry procedures for recording card transactions from the monthly statement? For: 1. Online Purchases made2. Expenses3. Deposit to Credit Card 4. Online Transfers to Credit Card 5. Late Payment fees6. Interest Charge Thank you.Courtney  Yahoo Mail: Search, organise, conquer _

Re: [GNC] Problem with auto generation of entries

Here is a fuller explanation. I think I have solved my problem. For some reason (that I no longer remember) I changed my locale settings to France. I am an Englishman living in France and usually do everything as if in the UK (even via a VPN normally). I am not even sure if this change occur

Re: [GNC] Problem with auto generation of entries

Yes it was a locale issue but the odd thing is that even though I selected France as my locale, I overrode the comma so that it used a point but it did not work. I have reversed it all back top a UK setting and it is fine again. Geoff Jankowski +44 20 7100 1092 +44 7770 58 48 38 +33 9 85 20 68

Re: [GNC] Problem with auto generation of entries

Geoff, First, go to Edit > Preferences > Scheduled Transactions and uncheck the box "Run when data file opened" This will stop the duplication of entries along with the [possible] incrementation of counters that is happening as bad [and also good] scheduled transactions are cre

Re: [GNC] Problem with auto generation of entries

Hi Geoff, I agree with Fred here. It looks like the SX was written with one locale of decimal, but you are now in a different locale of decimal. The SX processor is sensitive in that it stores the raw text and needs the same locale it was written in to properly parse it. Did you perhaps change

Re: [GNC] Problem with auto generation of entries

On 23 October 2024 at 16:42, Geoff Jankowski said: > Hi All, (Again! I am trying to send it as plain text to see if the image > gets through the server) > > I have resent this with the image attached as suggested. Looks as though it's expecting a comma as the decimal separator, and you have use

Re: [GNC] Problem with auto generation of entries

transaction and got > this response: > > Couldn’t parse sx-debit-formula for split””. > > So I am really stuck until I can resolve this. > > Below is my orignal message (edited for errors!). > > > > All of a sudden my auto generation of entries (Scheduled Transa

[GNC] Problem with auto generation of entries

!). All of a sudden my auto generation of entries (Scheduled Transactions) has gone wacky. To make sure it was not an issue in 5.8 I have upgraded to 5.9. I am using a Silicon M1 chip on an AppleMac. I am not sure how to upload images and for some reason I cannot connect to all the pages on

Re: [GNC] Problem with auto generation of entries

FYI, the network returned at 7:09pm US/EDT last night, so it was offline for less than 24 hours. However that outage certainly would have affected access to the Wiki and some of the Documentation. The rejection could be due to the network outage -- can you send me the bounce message? FYI, images

Re: [GNC] Problem with auto generation of entries

On Mon, 21 Oct 2024 08:26:05 +0200 Geoff Jankowski via gnucash-user wrote: > I am not sure how to upload images and for some reason I cannot > connect to all the pages on the Gnucash.org website (Installation and > Getting Help are both stalling) so was unable to log there. > > Here is the image

Re: [GNC] Problem with auto generation of entries

You need to *attach* the images, do not try pasting them into the message. I'm not certain of all of allowed formats off the top of my head, but JPG, BMP, & PNG should be fine. Regards, Adrien On 10/21/24 1:26 AM, Geoff Jankowski via gnucash-user wrote: I am not sure how to upload images and

[GNC] Problem with auto generation of entries

Hi All, Of a sudden my auto generation of entries has gone wacky. To make sure it was not an issue in 5.8 I have upgraded to 5.9. I am using a Silicon M1 chip on an AppleMac. I am not sure how to upload images and for some reason I cannot connect to all the pages on the Gnucash.org website

Re: [GNC] Reconciling duplicate entries of same transaction

While I'm a bit puzzled as to how duplicate transactions were reconciled, you can always adopt the old-fashioned accounting practice of never deleting anything and add in reconciliation entries to reverse any duplicates you find... for example, if you have two duplicate grocery entries for

Re: [GNC] Reconciling duplicate entries of same transaction

On 10/13/24 11:00, Art Chimes wrote: A credit card reconciliation has given me a discrepancy of several hundred dollars. The account was reconciled a month or two ago, but the I couldn’t get the latest statement to work. So I have laboriously been working my way backwards to see where the problem

[GNC] Reconciling duplicate entries of same transaction

A credit card reconciliation has given me a discrepancy of several hundred dollars. The account was reconciled a month or two ago, but the I couldn’t get the latest statement to work. So I have laboriously been working my way backwards to see where the problem(s) lie. I was embarrassed to discover

Re: [GNC] Autocomplete only searches displayed entries

This is fixed in 5.8 -- please get a newer release https://bugs.gnucash.org/show_bug.cgi?id=799047 On Wed, 10 July 2024, 2:59 pm Keith Edmunds, wrote: > I've just upgraded vrom v4.13 to v5.6. I have my ledgers filtered to hide > reconciled transactions. With 4.13 the autocomplete would search a

[GNC] Autocomplete only searches displayed entries

I've just upgraded vrom v4.13 to v5.6. I have my ledgers filtered to hide reconciled transactions. With 4.13 the autocomplete would search all transactions in the ledger, hidden or not. With 5.6, the autocomplete doesn't seem to search hidden transactions. Being able to autoccomplete using prev

Re: [GNC] Why or why not to do year-end closing journal entries? (Close Books?)

Oops! Thanks for the heads-up, Geoff. I mentally tune out those figures at the bottom because I never understand what they mean, so I failed to cover them up when covered the others. And it was only after I'd sent the screenshot that I realized I could have cut off everything below the header line

Re: [GNC] Why or why not to do year-end closing journal entries? (Close Books?)

Thanks, Stan. Got it. -- Eric Chapman GnuCash 4.14 on MacOS 14.1 Sonoma running on an Apple M3 Max computer. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/ma

Re: [GNC] Why or why not to do year-end closing journal entries? (Close Books?)

Thank you, Geoff! I got it to work. Eric On 12/4/23 20:43, Geoff wrote: Eric, see attached. Try making your screen wider - or maximising it. Regards Geoff = -- Eric Chapman GnuCash 4.14 on MacOS 14.1 Sonoma running on an Apple M3 Max computer. _

Re: [GNC] Why or why not to do year-end closing journal entries? (Close Books?)

Eric, see attached. Try making your screen wider - or maximising it. Regards Geoff = On 5/12/2023 12:29 pm, Eric Chapman wrote: Stan, Could you please take a screenshot of the down arrow you are talking about and attach it? I can't seem to find it. Thanks! Eric On 12/4/23 20:25, Sta

Re: [GNC] Why or why not to do year-end closing journal entries? (Close Books?)

On 12/4/2023 8:07 PM, Eric Chapman wrote: Hi, Geoff, OK, it looks as if it's just as good not to close the books, if, e.g., I might want to run an income statement comparing 2022 and 2023. Eric But THAT would unlikely be a good reason unless you were not regularly running/storing such re

Re: [GNC] Why or why not to do year-end closing journal entries? (Close Books?)

Eric, you can still do this if you close the books each year: > OK it looks as if it's just as good not to close the books if, e.g., I > might want to run an income statement comparing 2022 and 2023. Be brave! Try it and see for yourself ;--) Regards Geoff = On 5/12/2023 12:07 pm, Eric Ch

Re: [GNC] Why or why not to do year-end closing journal entries? (Close Books?)

Stan, Could you please take a screenshot of the down arrow you are talking about and attach it? I can't seem to find it. Thanks! Eric On 12/4/23 20:25, Stan Brown wrote: On 2023-12-04 17:07, Eric Chapman wrote: OK, it looks as if it's just as good not to close the books, if, e.g., I might

Re: [GNC] Why or why not to do year-end closing journal entries? (Close Books?)

On 2023-12-04 17:07, Eric Chapman wrote: > OK, it looks as if it's just as good not to close the books, if, e.g., I > might want to run an income statement comparing 2022 and 2023. > > However, does that mean that every time I look at the "Accounts" tab I > will see ever-growing amounts that refle

Re: [GNC] Why or why not to do year-end closing journal entries? (Close Books?)

Hi, Geoff, OK, it looks as if it's just as good not to close the books, if, e.g., I might want to run an income statement comparing 2022 and 2023. Eric Geoff or anyone else, However, does that mean that every time I look at the "Accounts" tab I will see ever-growing amounts that reflect tra

Re: [GNC] Why or why not to do year-end closing journal entries? (Close Books?)

ous reports to extract that    data without zeroing the account out. (1) I'm from an old school accounting background, so I like the idea of closing the books after all journal entries have been made for a fiscal year. Is there a reason I should not do that? (2) Is the "Closing Books

[GNC] Why or why not to do year-end closing journal entries? (Close Books?)

at data without zeroing the account out. (1) I'm from an old school accounting background, so I like the idea of closing the books after all journal entries have been made for a fiscal year. Is there a reason I should not do that? (2) Is the "Closing Books procedure" referred t

Re: [GNC] Need advice I use Quickbooks and only for personal use. All I do is bank accounts entries & credit cards, just use P&L & Balance Sheet reports

Brad, Does Square have a CSV (or Excel) export option? It wouldn't be 'integration' but you should be able to get the data out of Square and into GnuCash that way. Part of that process could perhaps be somewhat automated, though likely not all of it. Regards, Adrien On 8/17/23 4:43 AM, Br

Re: [GNC] Need advice I use Quickbooks and only for personal use. All I do is bank accounts entries & credit cards, just use P&L & Balance Sheet reports

Donating money isn't going to get anything implemented. Not only is it really expensive to hire or contract for programmers, the GnuCash project doesn't have the necessary overhead resources to even try: There's no GnuCash corporate entity to make contracts and nobody in the core group with the

Re: [GNC] Need advice I use Quickbooks and only for personal use. All I do is bank accounts entries & credit cards, just use P&L & Balance Sheet reports

Hi Michael/all, It does not appear that Square lists a GnuCash app as an option - https://squareup.com/us/en/app-marketplace Square also doesn't have Odoo (https://www.odoo.com/) listed as an app option. I do not know what those kinds of technical integrations would involve, but I assume tha

Re: [GNC] Need advice I use Quickbooks and only for personal use. All I do is bank accounts entries & credit cards, just use P&L & Balance Sheet reports

Brad, Thank you for answering! I appreciate it very much! Susan Sent from my iPhone On Aug 12, 2023, at 6:02 AM, Brad Morrison wrote:  Hi Gregory/Susan/Richard/all, I think that it is important to remember that GnuCash is an all volunteer project and

Re: [GNC] Need advice I use Quickbooks and only for personal use. All I do is bank accounts entries & credit cards, just use P&L & Balance Sheet reports

On 8/12/2023 9:02 AM, Brad Morrison wrote: Hi Gregory/Susan/Richard/all, I think that it is important to remember that GnuCash is an all volunteer project and not an accounting system suitable for almost any type of organization, other than a very simple one: https://github.com/Gnucash/gnuca

Re: [GNC] Need advice I use Quickbooks and only for personal use. All I do is bank accounts entries & credit cards, just use P&L & Balance Sheet reports

Hi Gregory/Susan/Richard/all, I think that it is important to remember that GnuCash is an all volunteer project and not an accounting system suitable for almost any type of organization, other than a very simple one: https://github.com/Gnucash/gnucash/pull/1623#issuecomment-1583966278 - "But

Re: [GNC] Need advice I use Quickbooks and only for personal use. All I do is bank accounts entries & credit cards, just use P&L & Balance Sheet reports

On Tue, Aug 8, 2023 at 6:40 AM Gregory Robertson wrote: > I'm use to QuickBooks Pro but as I mentioned I only use a few of the > features. Is this a good software for me to do just the basics. Also, I > just want to do on desktop, no online. I am not use to your format. Could > you please send me

Re: [GNC] Need advice I use Quickbooks and only for personal use. All I do is bank accounts entries & credit cards, just use P&L & Balance Sheet reports

On 8/7/2023 8:44 PM, Gregory Robertson wrote: I'm use to QuickBooks Pro but as I mentioned I only use a few of the features. Is this a good software for me to do just the basics. Also, I just want to do on desktop, no online. I am not use to your format. Could you please send me an answer to m

[GNC] Need advice I use Quickbooks and only for personal use. All I do is bank accounts entries & credit cards, just use P&L & Balance Sheet reports

I'm use to QuickBooks Pro but as I mentioned I only use a few of the features. Is this a good software for me to do just the basics. Also, I just want to do on desktop, no online. I am not use to your format. Could you please send me an answer to mswr...@gmail.com. Than

Re: [GNC] quandary with proper entries for cost-of-goods-sold and inventory

On 17 June 2023 at 15:28, Stan Brown said: [...] > One important point: If you receive messages in a digest, you'll also > need to (a) edit the subject line, by copy/pasting the subject of the > individual message you're referring to, and (b) Delete all the text of all > the messages you're _not_

Re: [GNC] quandary with proper entries for cost-of-goods-sold and inventory

Welcome to GnuCash, Eric! I can't respond to your accounting question, but here are some pointers for your mailing-list questions. On 2023-06-17 11:50, Eric Hammond wrote: > First, what is the proper way to reply / request to this email sequence? You managed to do it right in the end. It looks l

Re: [GNC] quandary with proper entries for cost-of-goods-sold and inventory

I don't think Michaels explanation is very clear, but he's right that you're not thinking of this right. Purchasing the widget is an asset transfer, so you DR inventory and CR what ever account sources the funds. That would be Accounts Payable if you're doing accrual accounting or a bank or lia

Re: [GNC] quandary with proper entries for cost-of-goods-sold and inventory

To discuss the first part, you post to gnucash-user@gnucash.org (as you did). I'm using Google's gmail web interface, and if I just hit "Reply", it goes to you instead of to this list. I have to use the "Reply to all" to make sure it goes to the list (I don't have a "Reply to list" option). Other

Re: [GNC] quandary with proper entries for cost-of-goods-sold and inventory

You are expecting the cost of goods sold at the wrong time. It is unrelated to when the goods are obtained (added to inventory) To perhaps make this easier for you to see, we'll use an example from one of "my" org as "organizations which had tee shirts, both sold to supporters AND given to vol

Re: [GNC] quandary with proper entries for cost-of-goods-sold and inventory

First, what is the proper way to reply / request to this email sequence? I follow the instructions at the end: "Please remember to CC this list on all your replies." "You can do this by using Reply-To-List or Reply-All." But only end up with "gnucash-u...@gnucassh.org" and get mildl

Re: [GNC] Zero entries in Balance Sheet

t; In the Balance Sheet options, Display: > > I have unchecked Include accounts with zero total balances. > > I have checked Omit zero balance figures > > Yet, my report has many entries with 0 shares and $0. > > Is there I am missing? > > > > OS: Linux Fedora 37

Re: [GNC] Zero entries in Balance Sheet

wrote: In the Balance Sheet options, Display: I have unchecked Include accounts with zero total balances. I have checked Omit zero balance figures Yet, my report has many entries with 0 shares and $0. Is there I am missing? OS: Linux Fedora 37 GnuCash

[GNC] Zero entries in Balance Sheet

In the Balance Sheet options, Display: I have unchecked Include accounts with zero total balances. I have checked Omit zero balance figures Yet, my report has many entries with 0 shares and $0. Is there I am missing? OS: Linux Fedora 37 GnuCash 4.14

[GNC] Tax schedule report outputting entries outside of selected date range

I'm trying to generate a tax report (federal 1040) for entry into my tax software, as I do every year and have never ran into this issue. Not sure of the version of GNC I'm running on Windows 10. Running Version 4.13 Build ID: Flathub 4.13 Finance Quote: 1.5301 under Ubuntu 20.04 LTS. Both ver

Re: [GNC] problem to delete multiple entries

d somewhere that to be able to >delete multiple entries quickly one can make keyboard shortcut by >editing ; (gtk_accel_path >"/GncPluginPageRegisterActions/DeleteTransactionAction" " ") >in the accelerator-map file to (gtk_accel_path >"/GncPluginPa

[GNC] problem to delete multiple entries

I have gnucash and windows 10. I read somewhere that to be able to delete multiple entries quickly one can make keyboard shortcut by editing ; (gtk_accel_path "/GncPluginPageRegisterActions/DeleteTransactionAction" " ") in the accelerator-map fil

Re: [GNC] How to bulk import about 130 Securities entries?

> On Aug 16, 2022, at 8:18 PM, list+gnuc...@jdlh.com wrote: > > On 2022-08-16 19:54, john wrote: > >> OTOH I'm pretty sure that gnc_commodity is fully exposed to the Python >> bindings so you should >> be able to write a python script using them to do the same thing without >> voiding your wa

Re: [GNC] How to bulk import about 130 Securities entries?

On 16 August 2022 at 17:11, Robert Simmons said: > > running the *.gnucash through gunzip, add in the text, and run it back > through gzip > > As a connoisseur of bad ideas for adding data to GnuCash myself, I have to > point out that one should use a programming language that has a library > wit

Re: [GNC] How to bulk import about 130 Securities entries?

On 2022-08-16 19:54, john wrote: OTOH I'm pretty sure that gnc_commodity is fully exposed to the Python bindings so you should be able to write a python script using them to do the same thing without voiding your warranty or needing to unzip the file or, for that matter, caring which backend i

Re: [GNC] How to bulk import about 130 Securities entries?

> On Aug 16, 2022, at 2:11 PM, Robert Simmons wrote: > >> running the *.gnucash through gunzip, add in the text, and run it back > through gzip > > As a connoisseur of bad ideas for adding data to GnuCash myself, I have to > point out that one should use a programming language that has a libr

Re: [GNC] How to bulk import about 130 Securities entries?

cond paragraph, making it easy to think his problem had mostly to do with importing investment transactions. However, a closer reading of the post, along with his explanations later in the thread, make it clear that his primary problem is the creation of 130 entries in the Securities datab

Re: [GNC] How to bulk import about 130 Securities entries?

Chris: On 2022-08-16 02:36, Chris Good wrote: …There is code in the ofx import to handle creating securities which is done before an investment transaction if the security (commodity) does not exist and Preference, Import, "Automatically create new commodities" is ticked. I have never used it

Re: [GNC] How to bulk import about 130 Securities entries?

> running the *.gnucash through gunzip, add in the text, and run it back through gzip As a connoisseur of bad ideas for adding data to GnuCash myself, I have to point out that one should use a programming language that has a library with support for the structured data format that one wants to add

Re: [GNC] How to bulk import about 130 Securities entries?

As xml is text, and xml storage is used in my gnucash, one might add securities by running the *.gnucash through gunzip, add in the text, and run it back through gzip, unless there is a nasty checksum in there somewhere?  Keep a copy of the original! I pulled this from my file using shell tools

Re: [GNC] How to bulk import about 130 Securities entries?

roblem had mostly to do with importing investment transactions. However, a closer reading of the post, along with his explanations later in the thread, make it clear that his primary problem is the creation of 130 entries in the Securities database. Your final comment summarizes the conundrum. If

Re: [GNC] How to bulk import about 130 Securities entries?

e directly. Regards, Adrien On 8/16/22 2:52 AM, David T. via gnucash-user wrote: flywire, You're crossing up threads here. Jim specifically needs to create Security entries in his GnuCash file (and has stated this on several occasions) so that he can add transactions for those securities late

Re: [GNC] How to bulk import about 130 Securities entries?

Actually, it was clear to me. Jim's point was that if you do these steps 130 times in a row, your brain will explode. Certainly it would be nice to be able to import them. On Aug 16, 2022, 14:05, at 14:05, flywire wrote: >Obviously it wasn't clear that the post copied below identifies the >keys

Re: [GNC] How to bulk import about 130 Securities entries?

Hi, Am 16.08.22 um 13:03 schrieb flywire: btw A lot (the majority?) ofhttps://wiki.gnucash.org/wiki/Published_tools are so old they won't work. as it is a wiki you can just update it. The page would probably also deserve more links from other pages so that it is easier found. Regards Frank

Re: [GNC] How to bulk import about 130 Securities entries?

Obviously it wasn't clear that the post copied below identifies the keystroke operations from opening GnuCash through the Security Editor with *** as user input. The Import accounts was an aside comment. (Thanks David for start the account tree comments.) Interestingly New security is one of the fe

Re: [GNC] How to bulk import about 130 Securities entries?

Message: 1 Date: Sun, 14 Aug 2022 19:19:44 -0700 From: Jim DeLaHunt To: gnucash-user@gnucash.org Subject: Re: [GNC] How to bulk import about 130 Securities entries? Message-ID: <137f3e3b-148f-feb2-9950-d7fcb32f6...@jdlh.com> Content-Type: text/plain; charset=UTF-8; format=flowed Kalpesh:

Re: [GNC] How to bulk import about 130 Securities entries?

Jim, As you continue down this project, consider how you want to handle various aspects of accounting for stocks and mutual funds--particularly, how you want to manage tax-related transactions, such as dividend income, capital gains income, etc. With that many commodities, you will want to ge

Re: [GNC] How to bulk import about 130 Securities entries?

flywire, You're crossing up threads here. Jim specifically needs to create Security entries in his GnuCash file (and has stated this on several occasions) so that he can add transactions for those securities later. Your advice regarding adding commodity transactions using csv import too

Re: [GNC] How to bulk import about 130 Securities entries?

Geoff's suggestion (to use an external automation tool) would best be placed on the Using Gnucash page (https://wiki.gnucash.org/wiki/Using_GnuCash) that Adrien suggested. Flywire suggested Piecash, which is already listed on the Published tools page. On 8/16/2022 12:05 AM, Frank H. Ellenber

Re: [GNC] How to bulk import about 130 Securities entries?

I haven't used GnuCash securities before the last week and I'm still not clear about them. I understood importing security entries were transactions. Further to my last post with minimal security information the fraction traded is not required. I hadn't realised importing tr

Re: [GNC] How to bulk import about 130 Securities entries?

Am 14.08.22 um 18:33 schrieb Adrien Monteleone: Check the 'Using GnuCash' page perhaps. And for tools https://wiki.gnucash.org/wiki/Published_tools Regards Frank Regards, Adrien On 8/14/22 9:50 AM, Tom Browder wrote: P.S. Is there a spot on the Wiki to list things like Geoff's suggestio

Re: [GNC] How to bulk import about 130 Securities entries?

On 2022-08-15 06:54, flywire wrote: Once share securities are created the share accounts can be created with File, Import, Import accounts from CSV. True. But the topic of the thread is, how to bulk create the share securities themselves. File, New Cancel Tools, Security Editor Securiti

Re: [GNC] How to bulk import about 130 Securities entries?

Once share securities are created the share accounts can be created with File, Import, Import accounts from CSV. File, New Cancel Tools, Security Editor Securities: Add New security Full Name: *** Symbol: *** Type: *** - Sticky Fraction Traded: *** OK File, Import, Import Accounts from CSV Next

Re: [GNC] How to bulk import about 130 Securities entries?

; > Subject: [GNC] How to bulk import about 130 Securities entries? Message-ID: mailto:c70b6819-fef8-511e-28ac-350b49e3b...@jdlh.com> > Content-Type: text/plain; charset=UTF-8; format=flowed Hello, folks: I am a long-time GnuCash user, and for all those years I have pretty

[GNC] How to bulk import about 130 Securities entries?

with importation. -- Message: 8 Date: Sat, 13 Aug 2022 18:28:22 -0700 From: Jim DeLaHunt mailto:list+gnuc...@jdlh.com> > To: Gnucash Users mailto:gnucash-user@gnucash.org> > Subject: [GNC] How to bulk import about 130 Securities entries?

Re: [GNC] How to bulk import about 130 Securities entries?

The program you want to use that is the macOS equivalent of what the other reply suggested is called "Automator". As long as you have not moved it, it is located in "Launchpad > Other > Automator" or "Applications > Automator". Also, this is just a general suggestion about XML manipulation (or man

Re: [GNC] How to bulk import about 130 Securities entries?

ities are stored in a certain order, sorted by then . There is a entity which seems to contain a text count of the non-CURRENCY gnc:commodity entries. This makes me wonder if I could transform my list of 130 security names and symbols into entities, and insert them into the GnuCash XML o

Re: [GNC] How to bulk import about 130 Securities entries?

Check the 'Using GnuCash' page perhaps. Regards, Adrien On 8/14/22 9:50 AM, Tom Browder wrote: P.S. Is there a spot on the Wiki to list things like Geoff's suggestion and flycatcher's program? If not, I will be glad to start one--suggestions welcomed. ___

Re: [GNC] How to bulk import about 130 Securities entries?

On Sun, Aug 14, 2022 at 00:40 Geoff wrote: > Hi Jim > > I don't have any experience manipulating GnuCash XML files, but in > principle what you want to do should work, although it does void your > GnuCash warranty. > > However, if you are going to all this effort you may find it more > worthwhile

[GNC] How to bulk import about 130 Securities entries?

Jim, this overlaps with what I was putting into https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102404.html so I stripped the data exchange part out. The sample data sets and references might still be useful. The GnuCash GUI won't import security data so in addition to what has been m

Re: [GNC] How to bulk import about 130 Securities entries?

here appears to be a pretty simple relationship between the fields of the dialogue and the text within the entity. The entities are stored in a certain order, sorted by then . There is a entity which seems to contain a text count of the non-CURRENCY gnc:commodity entries. This makes me wonder

[GNC] How to bulk import about 130 Securities entries?

entities are stored in a certain order, sorted by then . There is a entity which seems to contain a text count of the non-CURRENCY gnc:commodity entries. This makes me wonder if I could transform my list of 130 security names and symbols into entities, and insert them into the GnuCash XM

Re: [GNC] Example of accounts for a personal residence with entries for US tax basis

If you need, you can split the expenditure between the Asset (affecting the basis) and the Expense accounts. The purpose of accounting is INFORMATION. That is what my "PS" was all about. Thinking that you have to split the expenditure is an illusion. You might want/need all of part of that

Re: [GNC] Example of accounts for a personal residence with entries for US tax basis

Hi, On Tue, July 12, 2022 11:32 am, Tom Browder wrote: > On Tue, Jul 12, 2022 at 09:38 Michael or Penny Novack < > stepbystepf...@comcast.net> wrote: > [snip] > Thanks, Michael. Yes, I understand the need for carefully determining, > according to IRS rules, what is allowed for basis. But I'm not

Re: [GNC] Example of accounts for a personal residence with entries for US tax basis

On Tue, Jul 12, 2022 at 09:38 Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > On 7/12/2022 9:01 AM, Derek Atkins wrote: > > The way I do it personally (note: IANAA) is that I have an Assets:Fixed > > Assets: account with subaccounts for, e.g. Purchase, > > Renovations, etc. > > > >

Re: [GNC] Example of accounts for a personal residence with entries for US tax basis

On 7/12/2022 9:01 AM, Derek Atkins wrote: The way I do it personally (note: IANAA) is that I have an Assets:Fixed Assets: account with subaccounts for, e.g. Purchase, Renovations, etc. That way I account for improvements that change the basis, and the summed balance of A:FA: is my current basis.

Re: [GNC] Example of accounts for a personal residence with entries for US tax basis

On Tue, Jul 12, 2022 at 08:01 Derek Atkins wrote: > The way I do it personally (note: IANAA) is that I have an Assets:Fixed > Assets: account with subaccounts for, e.g. Purchase, > Renovations, etc. > > That way I account for improvements that change the basis, and the summed > balance of A:FA: i

Re: [GNC] Example of accounts for a personal residence with entries for US tax basis

The way I do it personally (note: IANAA) is that I have an Assets:Fixed Assets: account with subaccounts for, e.g. Purchase, Renovations, etc. That way I account for improvements that change the basis, and the summed balance of A:FA: is my current basis. -derek On Tue, July 12, 2022 8:38 am, To

[GNC] Example of accounts for a personal residence with entries for US tax basis

I have looked at several accounting books and websites for an example of accounting for an owner's personal residence and US fedral tax treatment for improvements contributing to basis, but I haven't yet found a recipe suitable for my lame level of bookkeeping knowledge. Can anyone point to such a

Re: [GNC] Itemize multiple tax entries in invoice

If you are viewing a report, the menu entry is found in the Edit menu, but in this case, it is always a toolbar icon as well. Regards, Adrien On 6/15/22 10:02 PM, Jay Thompson wrote: Where can I find the "report options" in the menu? Thanks ___ gnu

Re: [GNC] Itemize multiple tax entries in invoice

Where can I find the "report options" in the menu? Thanks On Wed, Jun 15, 2022 at 10:32 PM Derek Atkins wrote: > Hi, > > On Wed, June 15, 2022 10:22 pm, Jay Thompson wrote: > > I use a tax table that contains multiple entries. For example: > > Tax table entries: &

Re: [GNC] Itemize multiple tax entries in invoice

Hi, On Wed, June 15, 2022 10:22 pm, Jay Thompson wrote: > I use a tax table that contains multiple entries. For example: > Tax table entries: > 1- Federal ; 5% > 2- State ; 7% > > The tax breakdown *absolutely* needs to show up on the invoice. For > example: > 1 item

[GNC] Itemize multiple tax entries in invoice

I use a tax table that contains multiple entries. For example: Tax table entries: 1- Federal ; 5% 2- State ; 7% The tax breakdown *absolutely* needs to show up on the invoice. For example: 1 item= $100 *Federal tax* = $5 *State tax* = $7 == Total price

Re: [GNC] Zero price entries

le gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: Fred Tydeman Sent: Thursday, June 9, 2022 10:54 AM To: Gyle McCollam Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Zero price entries On Thu, Jun 9, 2022 at 7:46 AM Gyle McColla

Re: [GNC] Zero price entries

Fred, Technically, these are not price entries, which implies the PriceDB in GnuCash. They are transaction entries in a register. I am not sure whether Gyle's solution would work, since I'm not sure how you'd search for those entries; from your screenshot, it looks as if the

Re: [GNC] Zero price entries

it finds the > transaction it displays them in a new tab. All you have to do is delete > them from there and they will gone in the account they were found in. > > I am not looking for transactions with zero price. I am looking for entries in the price datab

  1   2   3   >