Re: [GNC] Transcation Search & Replace

I think there is also a general accounting philosophical issue (and in some jurisdictions, potentially a legal issue) in cases like this. Changing transactions is something that is discouraged in some accounting contexts. When I first learned accounting in 1980 or so, I was taught never to erase a

Re: [GNC] Cost Basis Report on Transaction

No such report exists. It'll be useful to illustrate a sample list of stock transactions and the desired report. On Fri, 3 Jul 2020, 6:59 am , wrote: > I'm evaluating gnuCash for tracking investments. For my taxes I need a > report of all stock sales during the year, showing the cost basis.

Re: [GNC] Price Quotes

Thanks David. That works. On 7/2/20 8:13 PM, David H wrote: Les, If you're asking where to enter your Alpha Vantage API Key go to Preferences >> Online Quotes and add it. Cheers David H. On Fri, 3 Jul 2020 at 10:48, Les > wrote: An update:  I discovered

Re: [GNC] Price Quotes

Les, If you're asking where to enter your Alpha Vantage API Key go to Preferences >> Online Quotes and add it. Cheers David H. On Fri, 3 Jul 2020 at 10:48, Les wrote: > An update: I discovered that Flatpak has upgraded GC to the 4.0 > version. I assume this is the issue. > > Would someone

Re: [GNC] Split transaction on invoices in foreign currencies

On 2020-07-02 10:24, Antonio Roberts wrote: …Yes, I think I confused you a bit with my description. Just so we're on the same page I'll try. I've transferred (as an example) €200 to my GBP account and it's now £177. I had a £10 bank charge and so I'm trying to split the £177 but when I do this

Re: [GNC] Price Quotes

An update:  I discovered that Flatpak has upgraded GC to the 4.0 version.  I assume this is the issue. Would someone point me to the instructions for installing AlphaVantage on Linux Mint? Thanks, Les On 7/2/20 4:59 PM, Les wrote: I have been using Yahoo as JSON for well over a year and

Re: [GNC] Cost Basis Report on Transaction

Well, if you track your gains, it's simple to track using a transaction report. On Jul 2, 2020, 18:59, at 18:59, gnuc...@runbox.com wrote: >I'm evaluating gnuCash for tracking investments. For my taxes I need a >report of all stock sales during the year, showing the cost basis. >Perhaps even a

Re: [GNC] Accessing online currency rates

Did you remember to run Install Online Price Retrieval for GnuCash from the GnuCash group in the Start Menu? Regards, John Ralls > On Jul 2, 2020, at 4:29 AM, Samantha Payn > wrote: > > I have had to change computers and have installed my existing Gnucash > set-up (in which I could

[GNC] Accessing online currency rates

I have had to change computers and have installed my existing Gnucash set-up (in which I could access online currency rates using the "fetch rate" button) on my new computer but I cannot now access online currency rates. I have installed Strawberry Perl, and added my API key at the

[GNC] Cost Basis Report on Transaction

I'm evaluating gnuCash for tracking investments. For my taxes I need a report of all stock sales during the year, showing the cost basis. Perhaps even a report of the lots used in a sale. I cannot find any of these on Standard Reports. Am I missing it somewhere? Are these reports called

[GNC] Price Quotes

I have been using Yahoo as JSON for well over a year and now, today, when I tried to download quotes, I received an error indicating  that AlphaVantage needed to be installed for quotes. It is true that I had the SSD crash about three weeks ago and reinstalled Linux Mint 19.3 along with GC.

Re: [GNC] Transcation Search & Replace

The best and safest one has already been mentioned. 1. Conduct a ‘Find’ as appropriate to build a working list of transactions. 2. Trudge through them one by one making the desired changes. That sounds daunting, but it depends on the info being changed. If you just want to change the name of an

Re: [GNC] Transcation Search & Replace

Typically bulk search replace changes would be for things like transaction category/account, changes in names in description/notes. etc. My GC data folder is currently 46mb (I have quite a lot of histrorical stuff). Seems like quite a functional omission in GC to me - it must be quite a

Re: [GNC] Split transaction on invoices in foreign currencies

Antonio, Your original description of the situation was clear, and the scenario John and Frank and I outlined was accurate. The point is this: if you enter the transaction from the GBP account, you can add the bank fee split without invoking the second exchange rate dialog.

Re: [GNC] Split transaction on invoices in foreign currencies

> On Jul 2, 2020, at 10:24 AM, Antonio Roberts wrote: > > Hi David, > > Yes, I think I confused you a bit with my description. Just so we're > on the same page I'll try. > > I've transferred (as an example) €200 to my GBP account and it's now > £177. I had a £10 bank charge and so I'm trying

Re: [GNC] Split transaction on invoices in foreign currencies

Got it, thanks. Regards, Adrien > On Jul 2, 2020 w27d184, at 12:13 PM, John Ralls wrote: > > > Read it again: "That currency is determined by the account from which the > TRANSACTION IS CREATED." Once the transaction is created its currency is > immutable. It matters not a whit in what

Re: [GNC] Split transaction on invoices in foreign currencies

Hi David, Yes, I think I confused you a bit with my description. Just so we're on the same page I'll try. I've transferred (as an example) €200 to my GBP account and it's now £177. I had a £10 bank charge and so I'm trying to split the £177 but when I do this it's asking me to do a currency

Re: [GNC] Split transaction on invoices in foreign currencies

Read > On Jul 2, 2020, at 9:39 AM, Adrien Monteleone > wrote: > > Unless I read the original post wrong, and the OP could clarify, but it looks > like they were entering this split in a GBP based account (the GBP bank > account) and adding a GBP split for the bank charge. > > Regards, >

Re: [GNC] Split transaction on invoices in foreign currencies

Antonio, I think the point that John and Frank were making is that if you *entered* the transaction in the EUR account, then it will have EUR as its currency, and you will be asked to provide an exchange rate for every GBP split that is subsequently entered, regardless of your current

Re: [GNC] Split transaction on invoices in foreign currencies

> Unless I read the original post wrong, and the OP could clarify, but it looks > like they were entering this split in a GBP based account (the GBP bank > account) and adding a GBP split for the bank charge. Yes, that is correct. I transferred the funds from EUR to GBP account and in that

Re: [GNC] Custom invoices don't work after upgrade

I'm sorry your distro pulled the rug from under you at this crucial moment. However if it's that crucial perhaps you should revert your system to a backup before the upgrade, do your invoice work and then when the pressure is off, look at upgrading again and what's needed to get your custom

Re: [GNC] Custom invoices don't work after upgrade

Am 02.07.20 um 18:29 schrieb John Ralls: > you have two choices: Never upgrade or don't use custom reports. IMHO there is always a third choice: Submit your customization as an enhancement request. If the team agrees, probably after further modification, you will have no issues with upgrades.

Re: [GNC] Split transaction on invoices in foreign currencies

Unless I read the original post wrong, and the OP could clarify, but it looks like they were entering this split in a GBP based account (the GBP bank account) and adding a GBP split for the bank charge. Regards, Adrien > On Jul 2, 2020 w27d184, at 11:34 AM, John Ralls wrote: > > > >> On

Re: [GNC] Split transaction on invoices in foreign currencies

> On Jul 2, 2020, at 9:08 AM, Antonio Roberts wrote: > > I'm in the UK doing most of my accounting in GBP (£) but in this case > I invoiced someone in EUR (€). Following the advice from here I sent > up a Bank in EUR, invoiced them in EUR and then transferred the EUR > into my GBP Bank with

Re: [GNC] Split transaction on invoices in foreign currencies

Hi, Am 02.07.20 um 18:25 schrieb w...@theprescotts.com: > I don't remember the circumstances, but it seems like I have had the same > issue on transactions that are half in one currency and half in the other. It > will sometimes ask for the exchange rate, when it doesn't need it. Each

Re: [GNC] Custom invoices don't work after upgrade

> On Jul 2, 2020, at 8:37 AM, Frank H. Ellenberger > wrote: > > Hi, > > Am 02.07.20 um 17:01 schrieb lo...@clickworkorange.com: >> On Thu, 2020-07-02 at 13:32 +0100, lo...@clickworkorange.com wrote: >>> My custom invoice template that I've used for many years stopped >>> working after

Re: [GNC] Split transaction on invoices in foreign currencies

If you are adding another split to the same transaction that contains an EUR split, it will need to balance that bank charge split as well. It may be trying to balance all GBP splits with all EUR splits. That might be considered a bug, but you can work around it. Either adjust the EUR split,

Re: [GNC] Split transaction on invoices in foreign currencies

I do a lot of that since I live in Mexico and have bank accounts in both the US and Mexico. I don't remember the circumstances, but it seems like I have had the same issue on transactions that are half in one currency and half in the other. It will sometimes ask for the exchange rate, when it

Re: [GNC] Australian System

On 2/7/20 4:08 pm, Mike Alsop wrote: You have probably been asked a thousand times, but as we entered a new financial year yesterday, I seriously need to look at doing my own books. Bookkeeping fees are now over the moon!! So, does this system comply with the Aussie GST and BAS reporting

[GNC] Split transaction on invoices in foreign currencies

I'm in the UK doing most of my accounting in GBP (£) but in this case I invoiced someone in EUR (€). Following the advice from here I sent up a Bank in EUR, invoiced them in EUR and then transferred the EUR into my GBP Bank with the current exchange rate (my bank supplies the rate at the time of

Re: [GNC] Custom invoices don't work after upgrade

On Thu, 2020-07-02 at 17:37 +0200, Frank H. Ellenberger wrote: > Hi, > > Am 02.07.20 um 17:01 schrieb > lo...@clickworkorange.com > : > > On Thu, 2020-07-02 at 13:32 +0100, > > lo...@clickworkorange.com > > wrote: > > > My custom invoice template that I've used for many years stopped > > >

Re: [GNC] Custom invoices don't work after upgrade

Hi, Am 02.07.20 um 17:01 schrieb lo...@clickworkorange.com: > On Thu, 2020-07-02 at 13:32 +0100, lo...@clickworkorange.com wrote: >> My custom invoice template that I've used for many years stopped >> working after upgrading to 3.4 as part of a dist-upgrade. I had to >> remove a few things such

[GNC] Custom invoices don't work after upgrade

My custom invoice template that I've used for many years stopped working after upgrading to 3.4 as part of a dist-upgrade. I had to remove a few things such as (use-modules (gnucash gnc-module)) (use-modules (gnucash printf)) in order for the template to compile, but I now get

Re: [GNC] Custom invoices don't work after upgrade

On Thu, 2020-07-02 at 13:32 +0100, lo...@clickworkorange.com wrote: > My custom invoice template that I've used for many years stopped > working after upgrading to 3.4 as part of a dist-upgrade. I had to > remove a few things such as > >(use-modules (gnucash gnc-module)) >(use-modules

[GNC] Custom invoices don't work after upgrade

My custom invoice template that I've used for many years stopped working after upgrading to 3.4 as part of a dist-upgrade. I had to remove a few things such as (use-modules (gnucash gnc-module)) (use-modules (gnucash printf)) in order for the template to compile, but I now get

Re: [GNC] Transcation Search & Replace

There are ways to accomplish what you want, but no, there is no built-in ‘Find & Replace All’ feature. I would ask, what are you trying to accomplish? What problem are you trying to solve? and How many transactions are we talking about? Regards, Adrien > On Jul 1, 2020 w27d183, at 2:57 PM,

Re: [GNC] Transcation Search & Replace

listsub3 writes: > Is there any functionality to do bulk search & replace on > transactions?  My old 2002 Quicken had this feature and it was really > useful to do bulk changes/corrections. There is a bulk search, but the replace must be done manually from the resulting search results window.

Re: [GNC] Australian System

GnuCash is designed to be world-neutral. Record your transactions in any currency. There is a report "Income and GST Statement" which will summarise your BAS for you, assuming you have recorded them correctly. On Thu, 2 Jul 2020 at 11:00, Mike Alsop wrote: > You have probably been asked a

Re: [GNC] Australian System

On Thu, 02 Jul 2020 15:38:38 +0930 Mike Alsop wrote: > You have probably been asked a thousand times, but as we entered a new > financial year yesterday, I seriously need to look at doing my own > books. Bookkeeping fees are now over the moon!! > > So, does this system comply with the Aussie

[GNC] Australian System

You have probably been asked a thousand times, but as we entered a new financial year yesterday, I seriously need to look at doing my own books. Bookkeeping fees are now over the moon!! So, does this system comply with the Aussie GST and BAS reporting system for the Australian Taxation Office??