Re: [GNC] Help with using formula in NUM field of Scheduled Transactions

and guidance If the answer is NO then thanks for your honesty and do you know of any workarounds that I might consider to achieve this function Many thanks Adrian From: R Losey Sent: 11 April 2025 02:32 To: David H Cc: adrian_jo...@btinternet.com; gnucash-user@gnucash.org Subject

[GNC] Help with using formula in NUM field of Scheduled Transactions

I require to schedule a weekly transaction, where the Num field increments by 1 for each transaction My template has " i + 1 " (without the quotes), in the Num field. But all I get is " i + 1 " (without the quotes) in each and every transaction. What am I doing wro

Re: [GNC] QIF import not working

Thanks David T. Modified the file and it now works. Regards Adrian From: gnucash-user on behalf of David T. via gnucash-user Sent: 30 March 2025 09:09 To: gnucash-user@gnucash.org Subject: Re: [GNC] QIF import not working Seehttps://gbr01

[GNC] QIF import not working

I am using GnuCash Version 5.10 with F::Q 1.64 on Windows 11. The QIF import seems to go all the way through until it gets to transferring the data to the account when it does not load anything. I have now tried it on two different files from two different providers and it does the same on each.

Re: [GNC] Problems getting prices from Yahoo as JSON

again for all your help Adrian From: Bruce Schuck Sent: 04 March 2025 16:28 To: 'GnuCash User' Cc: Adrian Holbrook ; Kalpesh Patel Subject: Re: [GNC] Problems getting prices from Yahoo as JSON On 3/4/25 12:01 AM, Adrian Holbrook wrote: > I think t

Re: [GNC] Problems getting prices from Yahoo as JSON

hough my issues are now resolved I am still a bit puzzled with the results I got! Thanks for your help and I am enjoying finding out a bit more about the inner workings of Perl but I fear it is too late for me to become even semi-proficient! Adrian From: Ka

Re: [GNC] Problems getting prices from Yahoo as JSON

Thank you From: Kalpesh Patel Sent: 02 March 2025 17:34 To: 'Adrian Holbrook' ; gnucash-user@gnucash.org Subject: RE: [GNC] Problems getting prices from Yahoo as JSON If Strawberry Perl and F::Q are installed correctly then run following in a comm

Re: [GNC] Finance::Quote sometimes returns stock prices in pence

y to just test the first two characters? From: Kalpesh Patel Sent: 02 March 2025 17:53 To: 'Adrian Holbrook' ; gnucash-user@gnucash.org Subject: RE: [GNC] Finance::Quote sometimes returns stock prices in pence >From the latest code you can wrap lin

[GNC] Finance::Quote sometimes returns stock prices in pence

grateful. Regards adrian ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can

Re: [GNC] Problems getting prices from Yahoo as JSON

I am using Windows 11 and have just Gnucash 5.10. I have downloaded the F::Q 1.64_03 file but not sure what to do with it. Is there an installation program or do I have to use the command prompts to manually install? Best regards Adrian From: Kalpesh Patel

Re: [GNC] Problems getting prices from Yahoo as JSON

Thanks. Not sure how to install a module from CPAN as suggested by Murugan so will attempt to modify the file. Best regards Adrian From: Kalpesh Patel Sent: 28 February 2025 22:57 To: 'Adrian Holbrook' ; gnucash-user@gnucash.org Subject: RE: [GNC

Re: [GNC] Problems getting prices from Yahoo as JSON

Sorry - I am using Windows 11. Thanks for the prompt reply. I will now attempt to see if I can get the patch! Best regards Adrian From: Murugan Mariappan Sent: 28 February 2025 21:32 To: Adrian Holbrook ; gnucash-user@gnucash.org Subject: Re: Problems getting

[GNC] Problems getting prices from Yahoo as JSON

I am having the same problem as reported on a recent thread. I was not sure how to respond on the thread as the reply arrow was grayed out. I am not sure how to make the quick fix mentioned by Kalpesh Patel as I cannot find the file YahooJSOM.pm. Can anyone help? Thanks Adrian

[GNC] Batch transfer from one expense category to another.

I have a number of entries that I have classified under the expense category "Utilities". I now wish to remove all my phone payments from that category and have a new category for "Phone". The description for all these entries is the same so I have sorted by description and am laboriously going

Re: [GNC] AlphaVantage now restricting users to 25 quotes

ucash can only use one conversion. Would be interested to understand this a bit more. From: Mike Alexander Sent: 31 October 2023 06:19 To: Adrian Holbrook Cc: gnucash-user@gnucash.org Subject: Re: [GNC] AlphaVantage now restricting users to 25 quotes On 27 Oct

[GNC] AlphaVantage now restricting users to 25 quotes

I have been using Alphavantage for my stock quotes for some time now using F:Q. IRecently it stopped working for me - the last valid quotes I have are dated October 20th 2023. I now get a message that they are restricting quotes to 25 per user per day. I currently import around 50 at a time but

[GNC] Unable to update prices using Yahoo as JSON

Share price updates using Yahoo as JSON are not working for some reason. Is anyone else having this problem? Tried to access the mailing list to see if anyone else is having this problem but I keep on getting an authorisation failure. ___ gnucash-user

Re: [GNC] Does anyone produce a "UK balance sheet" (FRS 102) ?

Apologies, my complaint was about General Leger... On Sat, Dec 11, 2021 at 5:02 PM Adrian Yong wrote: > Hi David, > > I asked for the same thing but was told that since entries are made using > the double entry system, Assets = Liability + Proprietorship is complied > with... >

Re: [GNC] Does anyone produce a "UK balance sheet" (FRS 102) ?

transactions in the accounting period will have their balances brought forward ie. Equity... Regards, Adrian On Sat, 11 Dec. 2021, 11:42 Dr. David Kirkby, < drkir...@kirkbymicrowave.co.uk> wrote: > I realise this is not something the developers can realistically do, but I > wonder i

Re: [GNC] General Ledger amounts missing

will always be observed. However, sometimes an entry may be a negative Asset instead of being a positive Liability and this is not so easily picked up without a normal General Ledger... I have downloaded the General Ledger or Transaction Report and created my normal GL using Excel. Regards, Adrian

Re: [GNC] Big problem GC 4.6 wiping history list? Mac OS Big Sur

Hi Anita, That is my greatest fear... Hope you managed to resolve the issues.. Please share your experience... Regards, Adrian On Wed, Jun 30, 2021 at 12:07 PM Anita Graves wrote: > Please see the attached screenshot: > > I don’t know what to do but I refuse to delete the file I nee

Re: [GNC] GnuCash 4.6 Released

Hi, I am using v3.7. Is there a *procedure *for me to upgrade to v4.6 without risk loss of data ? Like, can I run two versions of GNUcash on the same data files until I am certain that the updated version is running properly ? Thank you. Regards, Adrian On Mon, Jun 28, 2021 at 9:41 PM Fross

[GNC] GnuCash v3.7 - Trial Balance giving zeros

Hi, I am using v3.7 and for FY ending 2020; I am getting zeros in my Trial Balance. It was ok for 2019. Any advice on what I should do ? Regards, Adrian ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or

Re: [GNC] Gnucash 4.1

gards, Adrian On Wed, 5 Aug. 2020, 07:51 David H, wrote: > Hi John, > > Go to gnucash.org and click the Download GnuCash 4.1 Apple macOS >= 10.13 > :High Sierra" link if you are on High Sierra 10.13 or later, see pic > below... > > Direct link is > > https://source

Re: [GNC] Alpha Vantage problems

Thanks Adriano. Although it is not good news at least now I do not have to keep on trying out different things to work out why it is not working! Regards Adrian On Fri, Jul 10, 2020 at 8:57 PM Adriano Baldi wrote: > Hi, to all > > I have bad news! > > It looks like Alphav

Re: [GNC] Alpha Vantage problems

I have a list of about 50 stocks that used to work and do not work now - a small selection AAL.L AV.L AZN.L BATS.L BBY.L BDEV.L BEZ.L BILN.L BKG.L BME.L BP.L BRBY.L BT-A.L BVIC.L BWY.L Regards Adrian Adrian Holbrook Tel: +44 (0)1564 230038 Mob: +44 (0)777 238 3299 Skype: megagrumpy Web

Re: [GNC] Gnucash - user

Thanks for all the advice - Nabble is no longer going to be used by me. I really thought it was an inherent part of the Gnucash approach but I am happy to part with it. On Tue, Jul 7, 2020 at 2:36 PM Derek Atkins wrote: > Dear Adrian, > > On Tue, July 7, 2020 2:46 am, Adrian Holbr

Re: [GNC] Alpha Vantage problems

Thanks fo the advice. I was going to download the alpphvantage addon for Excel but instead used gnc-fq-dump. I can get all the NYSE stocks but nothing off the LSE using the suffix .L. Fails every time;. Adrian On Tue, Jul 7, 2020 at 12:01 PM Chris Good wrote: > Hi Adrian, how are you gett

Re: [GNC] Alpha Vantage problems

term I have changed my source to Yahoo JSON and that is working. I would just like to be able to get Alphavantage working as well so that if one fails I have a backup source. Regards Adrian On Tue, Jul 7, 2020 at 9:10 AM Chris Good wrote: > Message: 3 > Date: Tue, 7 Jul 2020 07:58:33

Re: [GNC] Gnucash - user

I registered as a new user on Gnucash mailing list. I then got an email from Nabble that asked me to click on a link to confirm my membership - see below [image: image.png] That takes me into Nabble and then I cannot post without contacting Hugo sho does not respond! Regards Adrian On Tue, Jul

[GNC] Alpha Vantage problems

download was on June 12th and since then all attempts have failed. All my shares are on the LSE. I have not checked trying to get quotes from NYSE but that would be my next test. I am using Gnucash 4.0 and Finance::Quote 1.49 Regards Adrian ___ gnucash-user

[GNC] Gnucash - user

subscribe form. I am very confused and would love a simple process that worked like a normal forum without having to go through hoops Adrian Holbrook Tel: +44 (0)1564 230038 Mob: +44 (0)777 238 3299 Skype: megagrumpy Web: www.megagrumpy.com email: adrian.holbr...@gmail.com

Re: [GNC] Potential regression: PDFs generated using "Make PDF" have a superfluous blank page

Hi Adrien, After speaking to you the last time, I tried exporting documents (ie. General Ledger) to pdf and xlsx formats and I got gibberish... I am using version 3.7... Regards, Adrian On Tue, Jun 30, 2020 at 2:47 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I ca

Re: [GNC] QUESTION: transaction classes (tags) like QuickBooks?

Thanks Liz.. Very valid point... I don't have much problems with GNUcash... On Tue, Jun 23, 2020 at 4:33 PM Liz Dodd wrote: > On Mon, 22 Jun 2020 20:06:05 +0800 > Adrian Yong wrote: > > > As Gnucash is still under development, > > This is a place to point out a

Re: [GNC] QUESTION: transaction classes (tags) like QuickBooks?

s in locating their files after updating... I think the current version is 3.10 and I am on 3.x... I have this fear of updating to 3.10... Maybe I will do it after my auditors confirmed that they have got everything they need... Regards, Adrian On Mon, 22 Jun. 2020, 17:52 Zi via gnucash-user,

[GNC] Scheduled payment question

have to reset the date manually and/or delete duplicates. Is there anyway to set these payments automatically? Adrian Sutton UK ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe

Re: [GNC] General Ledger

gt; will accept any separator or let you specify on import. Some choke on > anything but a comma. GnuCash gives you the flexibility to choose what you > need. > > The problem you found isn’t a problem with GnuCash, it is a limitation of > how the Windows OS recognizes files. > *Poi

Re: [GNC] General Ledger

ename. All your other comments are relevant if we get this file type specification step correct. Regards, Adrian On Mon, Mar 30, 2020 at 12:28 AM Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > On 3/28/2020 11:21 PM, Adrian Yong wrote: > > I can't change the fil

Re: [GNC] General Ledger

Thanks Fred... On Sun, 29 Mar. 2020, 16:54 Fred Bone, wrote: > On 29 March 2020 at 10:40, Adrian Yong said: > > > Hi Adrien, > > > > Below is the screenshot... I get a file type FILE. > > > > [image: image.png] > > Because you chose to give it a plain n

Re: [GNC] General Ledger

en it. > > Otherwise, you can still open it with Excel via the right-click menu using > a ‘open with’ option, or, start Excel first, then try to File > Open, or > Insert > Sheet from File operation. > > Regards, > Adrien > > > On Mar 28, 2020 w13d88, at 9:4

Re: [GNC] General Ledger

Hi Adrien, I tried exporting the "Export Account Tree to csv" and "Export Accounts" options. However the exported files cannot be opened in MSExcel nor Acrobat Reader DC... Regards, Adrian On Thu, Mar 19, 2020 at 8:30 AM Adrian Yong wrote: > Thanks Adrien.. > >

Re: [GNC] General Ledger

ar 18, 2020 w12d78, at 6:01 PM, Adrian Yong < > adrianyong.88p...@gmail.com> wrote: > > > > Thank you very much, Adrien, Michael and Stephen for helping me > understand > > Gnucash... > > > > I will submit the documents as

Re: [GNC] General Ledger

; On 3/18/2020 1:52 PM, Stephen M. Butler wrote: > > Adrian, > > > > I give my CPA three items: > > > > 1. Balance Sheet. > > > > 2. Profit Loss statement > > > > 3. Transaction Report of all transactions for the year sorted by > > acc

Re: [GNC] General Ledger

Thank you very much for your assistance. I submit the following to the auditors: 1) P&L 2) Balance Sheet 3) Journal 4) General Ledger 5) Funds(Cash) Flow Statement 6) Trial Balance That's because they don't use QuickBooks... Regards, Adrian On Wed, 18 Mar. 2020, 13:21 Adr

Re: [GNC] General Ledger

provided with a General Ledger which is a collation of all transactions sorted into each of the accounts. If the auditors uses Gnucash, all I need to do is to furnish them with gnucash data file and my problem would vanish... But Regards, Adrian On Wed, 18 Mar. 2020, 01:28 Adrien

Re: [GNC] General Ledger

nual accounting. Somehow, I have to generate a report on each account and collate them manually into one collection.. Regards, Adrian On Tue, 17 Mar. 2020, 13:39 Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > If you mean you want to see the individual transaction activity in yo

Re: [GNC] General Ledger

with a single line in the report called ‘Retained Earnings’ or > ‘Retained Losses’) > > Regards, > Adrien > > > On Mar 16, 2020 w12d76, at 11:29 PM, Christopher Lam < > christopher@gmail.com> wrote: > > > > Try the customer report in the experimental m

Re: [GNC] General Ledger

Thanks Christopher On Tue, 17 Mar. 2020, 13:19 Christopher Lam, wrote: > If it fits your needs then yes > > On Tue, 17 Mar 2020, 12:47 pm Adrian Yong, > wrote: > >> Hi Christopher, >> >> That means I have to generate a report for each of the accounts ie Cas

Re: [GNC] General Ledger

Hi Christopher, That means I have to generate a report for each of the accounts ie Cash in Bank, Trade Debtors, each customer at a time ? Regards, Adrian On Tue, 17 Mar. 2020, 12:29 Christopher Lam, wrote: > Try the customer report in the experimental menu. > > On Tue, 17 Mar 2020,

Re: [GNC] General Ledger

customer... Otherwise, how would one audit the transactions for a particular customer ? Regards, Adrian On Tue, 17 Mar. 2020, 11:33 Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > Is this a duplicate question? > > Something very similar appeared on this list just

[GNC] General Ledger

Hi, I am trying to generate a General Ledger which lists all the transactions for the period, opening balance and closing balance for each account and or subaccount. Can someone guide me through the General Ledger process to achieve this, please ? Regards, Adrian

[GNC] General Ledger

Hi, Is a General Ledger in GNUcash, the same as for general accounting practices where transactions, opening and closing balances are listed for every account and subaccounts ? Regards, Adrian ___ gnucash-user mailing list gnucash-user@gnucash.org To

Re: [GNC] GC 3.2 Import Price File CSV

Thanks for your response. Can you tell me when the spam was sent? I did have some problems some time ago but have changed my password a couple of times since then. Get Outlook for Android From: gnucash-user on behalf of Liz Sent: Wednes

Re: How to create an asset with a reduced value compared to my regular currency (dollars)

way you want if this is just for you > to keep track of, but the goal should always be to use transactions to > show an accurate picture of what happened. What happened is NOT that you > saved money on future purchases. What happened is you received a gift of > $70 in the form of a stored

Re: How to create an asset with a reduced value compared to my regular currency (dollars)

Tommy Trussell wrote >> Adrian: >> In the case at hand I spent $430 on the gift card and when I buy >> something >> that costs $100, I'm really only spending $86. That's what makes sense >> to >> me for how this ought to be counted. Since I don&#x

Re: How to create an asset with a reduced value compared to my regular currency (dollars)

There may be technical accounting reasons to treat rebates as offsets to expenses rather than income. But my own reasons are simply that it's what makes sense to me. I don't really track income very carefully. I mainly track expenses. A rebate is a complex form of discount where the vendor is

RE: How to create an asset with a reduced value compared to my regular currency (dollars)

has a 15% discount, I’m curious about how it can be done at all. Is it indeed a simple matter to set it up the way I wanted? From: Christopher Lam [mailto:christopher@gmail.com] Sent: Friday, December 1, 2017 3:21 To: Mariano, Adrian V. Cc: gnucash-user@gnucash.org Subject: Re: How to

How to create an asset with a reduced value compared to my regular currency (dollars)

I bought a $500 gift card for $430 this week. I would like to add this to gnucash as some kind of asset so that as I spend it, the correctly scaled amount gets transferred to the expense account I use. In other words, if I spend $100 from this account it's really only $86. I tried to do this

Re: Finance-Quote 1.47 released!

Thanks for your response - i tried Morningstar GB but got no response at all - normally I get the reply "Unable to retrieve quotes ..." but this time it looked like it had worked but no updates in the price editor. From: gnucash-user on behalf of Richard Ullger