Re: [GNC] GNC] Mutual Fund - Price Import from csv, "Namespace could not be understood"

. Cheers, Deva -- Date: Sat, 7 Aug 2021 21:35:30 +0100 From: Ashok Sinha To: gnucash-user@gnucash.org Subject: [GNC] Mutual Fund - Price Import from csv, "Namespace could not be understood&quo

Re: [GNC] When Do Account Totals Update When Updating Prices

Sounds good, Jack. Thanks for the revert. Cheers, Deva Sent from Outlook<http://aka.ms/weboutlook> From: Jack Frillman Sent: 21 May 2021 16:56 To: Deva - ; gnucash-user@gnucash.org Subject: Re: [GNC] When Do Account Totals Update When Updating Prices

Re: [GNC] Using the advanced portfolio report for mutual fund income

I'm glad to hear that your problem is resolved. Copying the list for the benefit of millenials (pre and post)... Cheers, Deva Sent from Outlook<http://aka.ms/weboutlook> From: Alister Briggs Sent: 10 May 2021 17:59 To: pobox.d...@outlook.in Subject: Re

Re: [GNC] When Do Account Totals Update When Updating Prices

n I do the View->Refresh action. Hopefully, this will solve your problem as well. If this doesn't work, I'm afraid I don't have much else to offer you. Cheers, Deva - From: Jack Frillman To: Gnucash Users Subject: [GNC] When Do Account Totals Update When Up

Re: [GNC] About 'parent-account-subtotal' option.

layouts, so I have no objections either. Cheers. Sent from Outlook<http://aka.ms/weboutlook> From: Christopher Lam Sent: 13 February 2021 06:47 To: Adrien Monteleone ; Deva - Cc: gnucash-user@lists gnucash. org Subject: Re: [GNC] About 'parent-account-subto

Re: [GNC] About 'parent-account-subtotal' option.

at the top of the sub-accounts (along the parent line), then I'd prefer to avoid that. Cheers, Deva --- Date: Sat, 13 Feb 2021 02:41:58 + From: Christopher Lam To: GnuCash users group Subject: [GNC] About 'parent-account-subtotal

Re: [GNC] Using the advanced portfolio report for mutual fund income

ge that setting for you to use $Cash account every time. Cheers, Deva > On 04-Sep-2020, at 9:30 PM, gnucash-user-requ...@gnucash.org wrote: > > Date: Fri, 4 Sep 2020 15:02:55 +1000 > From: Alister Briggs mailto:aliste...@gmail.com>> > To: gnucash-user@gnucash.org <mailto:gn

Re: [GNC] Setting up for restricted/unrestricted PCC accounts - what's a reasonable approach

llow it at all. Cheers, Deva > On 29-Aug-2020, at 3:48 PM, gnucash-user-requ...@gnucash.org wrote: > > Date: Sat, 29 Aug 2020 11:14:46 +0100 > From: Chris Green mailto:c...@isbd.net>> > To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > Subject: [GNC] Setting

Re: [GNC] Question marks instead of currency in reports

Gio, I had the same problem with my invoice report a while ago whereby my INR currency symbol was displayed as question marks. Adrien helped with some CSS styling code (which I had to put on the Notes tab in Embedded CSS box). After I put this snippet there, it all works fine now. h1.coyname

Re: [GNC] Australian Foreign Investments Taxation

. The CSV Price Importer works very well and it even has a Save Template option, which you can reuse on future imports. Easy, peasy! Cheers, Deva > On 07-Apr-2020, at 2:52 PM, gnucash-user-requ...@gnucash.org wrote: > > Message: 12 > Date: Tue, 07 Apr 2020 19:22:19 +1000 > Fr

Re: [GNC] Stock Entry Issue with Version 3.8

Timothy, In the stock register, shares and amount are more important for tracking purposes (and tax purposes), so you need to enter only the shares and Tot Buy columns and GnuCash will calculate the price. Due to rounding adjustments, the price may be off by a little bit from your actual

Re: [GNC] importing csv multisplit multicurrency problems

Sorry Gio, I don’t have any experience with the import or multi-currency transactions in GnuCash. I only responded to your query because you wanted a better way to load a price database rather than entering them manually. Cheers. > On 11-Mar-2020, at 10:32 AM, Gio Bacareza wrote: > > Hi

Re: [GNC] importing csv multisplit multicurrency problems

Gio, If you are using the 3.x series, there’s a convenient CSV price importer that works well. You can even save the CSV price file template for future use, so you’d have to set it up only once. That should alleviate a lot of burden in entering prices in price database manually. Cheers. >

Re: [GNC] Missing invoice on Income & GST Statement Report

Many thanks to you and Maf for your suggestions - I was able to fix the problem by setting the General/Add options summary to know what was wrong. The offending invoice was issued to a new customer who started in Jan, so the corresponding Income account was created recently. When this new

Re: [GNC] Missing invoice on Income & GST Statement Report

Yes, there’s 1 split going to Income account. See screenshot link below. This screenshot is from the IGST @ 18% account view. The account, Assets:Business:Invoices, is my A/R account. https://drive.google.com/open?id=1mgf4H13ywbMPKv9UtthyQrl7NJ_2o7Te

Re: [GNC] Missing invoice on Income & GST Statement Report

Yes, the previous quarter ends on 31-DEC-2019. Perhaps I was misunderstood. Since I didn’t find the invoice showing up in the current quarter (Jan - Mar 2020), I ran the report for the previous quarter to check if it somehow shows up there. But it didn’t. In fact, I ran the report for the

[GNC] Missing invoice on Income & GST Statement Report

Hello, I am running 3.7 on Mac OS High Sierra 10.13.6. Something peculiar is happening with my datafile this month. See attached 2 screenshots - one from Find Invoice dialog for the date range 1-JAN-2020 to 1-FEB-2020. The other from the Income & GST Statement report. There’s one invoice

Re: [GNC] Accelerator Key for Jump button

Michael, I had a similar issue some years ago and the resolution provided by list members is to go edit a file by the same name under a different folder. On a Mac, I think it resides in a folder under $HOME/Library/Application Support/ I am not at my Mac right now, so I can't confirm the

Re: [GNC] Error Retrieving Quotes

Sachin, India stock quote retrieval hasn’t worked for me either. If you google for solutions, then you will come across some posts where someone has posted an edited version of Quote.pm for India stocks, but last time I looked, it was pretty old and I can’t vouch for the authenticity either

Re: [GNC] Modifying Balance Sheet Report

Paul, You can experiment with Edit->Report Options menu and see how the report changes with various options. In your particular case, you can set Price Source to “Average Cost” on the “Commodities” tab. That should give you what you are looking for. Please note that somewhere around 2.6.12 or

Re: [GNC] Fwd: Bonus share entry

Try using the Stock Split assistant to record bonus shares. When you use that assistant, it seems to have special privileges to accommodate a split with just the shares without associating a value to it. But when you try to replicate the same splits manually, you run into issues that you have

Re: [GNC] How to handle bounced check

Mike, In such cases, you could try creating a credit note - this will reverse both the invoice and the bank deposit and you have the audit trail. Then create a new invoice (but this time, wait until the cheque gets credited to your bank). You can always pre-date invoices after the cheque has

Re: [GNC] accounts catergories are missing

Awijeet, You can try changing the locale to US and re-launch Gnucash. It should show the Common Accounts setup this time. Once you have chosen your account setup and saved your datafile, you can switch your locale back to India. I setup my datafile around mid 2015 when GST Indian Business was

Re: [GNC] Currency symbol (INR) not showing on Tax Invoice report

cash.org>> Subject: Re: [GNC] Currency symbol (INR) not showing on Tax Invoice report Message-ID: mailto:e66699fd-c6cb-44d8-a4b6-e042491da...@lusfiber.net>> Content-Type: text/plain; charset=utf-8 Deva, My apologies for your wasted time with my inaccurate code. If you only want to ch

Re: [GNC] Currency symbol (INR) not showing on Tax Invoice report

sion. Hope that helps. Regards, Adrien On Jan 19, 2019, at 7:25 AM, Deva - mailto:pobox.d...@outlook.in>> wrote: Adrien, I am happy to raise a bug, but after reading all responses on this issue, perhaps it?s not a bug even. Geert and you pointed out that the report can be changed usin

Re: [GNC] Currency symbol (INR) not showing on Tax Invoice report

-b534-92a928a85...@lusfiber.net>> Content-Type: text/plain; charset=utf-8 Glad to hear you can get the info you need, sorry to hear the suggestion doesn?t work. I?d say this is bug worthy. Regards, Adrien On Jan 19, 2019, at 5:53 AM, Deva - mailto:pobox.d...@outlook.in>> wrote:

Re: [GNC] Currency symbol (INR) not showing on Tax Invoice report

Thanks for the clarification, Geert. I’m afraid I am not familiar with CSS styling, so I will just use the workaround for now. Cheers. > On 19-Jan-2019, at 6:07 PM, Geert Janssens wrote: > > Op zaterdag 19 januari 2019 12:53:10 CET schreef Deva -: >> Adrien, >> >

Re: [GNC] Currency symbol (INR) not showing on Tax Invoice report

As you click each one, at the top right you?ll get an enlarged version and just below that, you?ll see the name of the font it belongs to. Regards, Adrien On Jan 18, 2019, at 6:06 AM, Deva - mailto:pobox.d...@outlook.in>> wrote: Geert is probably right. As I mentioned in my previous po

Re: [GNC] Currency symbol (INR) not showing on Tax Invoice report

Geert is probably right. As I mentioned in my previous post, I did try to change the default stylesheet fonts to a few commonly used fonts in documents (Arial/Helvetica/MS Sans Serif), but rupee symbol didn’t come up for any of them. I can see from the character viewer on my Mac that there are

Re: [GNC] Currency symbol (INR) not showing on Tax Invoice report

le/Easy/Fancy Invoice" reports and let us know? With MacOS it'll be very difficult to investigate this; usually we'd advocate 'bisecting' i.e. try various releases until the exact breaking one is found, but I'm not sure this is feasible with MacOS. Sorry, and good luck. On 15/1/19 8:58 pm, D

Re: [GNC] Currency symbol (INR) not showing on Tax Invoice report

lse I can try. Cheers. [cid:0133440E-F5D0-4450-BC47-65D732752428@Belkin] On 15-Jan-2019, at 7:38 PM, Frank H. Ellenberger mailto:frank.h.ellenber...@gmail.com>> wrote: Hi Deva, Am 15.01.19 um 13:58 schrieb Deva -: Hello, I am on GnuCash 3.4, Mac OS 10.13.6 (High Sierra). Please see

[GNC] Currency symbol (INR) not showing on Tax Invoice report

currency symbol is showing up as a missing symbol icon. Any suggestions on how to fix this? I tried turning off the display of currency symbol in the report via Edit->Report Options, but didn’t see anything to that effect. Cheers, Deva Invoice-000267-01_15_2019.pdf Description: Invoice-000

Re: [GNC] Feedback: Balance Sheet (Multi-Column) / Income Statement (Multi-Column)

er difficult, or very limiting, to try generate a true monthly average (i.e. I'm not keen of trying this). ~C On Sat, 13 Oct 2018 at 15:56, Deva - mailto:pobox.d...@outlook.in>> wrote: Thank you! That is an interesting use of Transaction report. Interpretation of the period

Re: [GNC] Feedback: Balance Sheet (Multi-Column) / Income Statement (Multi-Column)

heet (Multi-Column) / Income Statement (Multi-Column) Message-ID: mailto:b95c4659-4f44-f176-a85f-ab3bdca17...@gmail.com>> Content-Type: text/plain; charset=utf-8; format=flowed Hi Deva Thanks for feedback. Charts were planned but not quite finished. Period Average is actually present i

[GNC] Feedback: Balance Sheet (Multi-Column) / Income Statement (Multi-Column)

Hello Christopher, A while ago, you posted the multi-column versions of balance sheet and income statement to this list for beta testing. Recently, my son started college and he was “voluntold” to use GnuCash and share the datafile with me for monthly analysis. These 2 reports you published

Re: [GNC] Mutual fund cost basis changes between 2.6.6 and 2.6.19

everything I need from GnuCash. Cheers. On 12-Jan-2018, at 8:44 PM, John Ralls mailto:jra...@ceridwen.us>> wrote: On Jan 12, 2018, at 3:43 AM, Deva - mailto:pobox.d...@outlook.in>> wrote: Hello, I am on Mac OS Sierra v10.12.6. Until a few days ago, I was using GnuCash 2.

Re: [GNC] GC 3.2 Import Price File CSV

Thanks Geert. But please note this was not an issue for me; I was just trying to help another poster with his problems (cc’d on this mail). Bob can rest easy because the OP said he finally solved it. Something to do with the way he exported his price data from a spreadsheet to CSV was the

Re: [GNC] GC 3.2 Import Price File CSV

That's a bummer! And I am out of ideas... Perhaps a developer can shed some light on your problems... Cheers. On Friday 24 August 2018 08:05 PM, gnucash-user-requ...@gnucash.org wrote: Date: Fri, 24 Aug 2018 01:48:52 -0500 (CDT) From: Megagrumpy

Re: [GNC] GC 3.2 Import Price File CSV

I think what Sebastien meant was that there appears to be a leading space in your stock definition in gnucash, not in your CSV file. At least, it appears that way from the screenshots you sent out. Of course, as he noted, it may just be a visual effect… Cheers. On 21-Aug-2018, at 9:30 PM,

Re: [GNC] GC 3.2 Import Price File CSV

8, 08:54 Megagrumpy mailto:megagru...@hotmail.com>> wrote: Thanks for the response, Deva. I have tried every combination of date format, and security ID with no luck. Unfortunately my screenshots were taken from different times so I agree - if I had tried to use those particular settings I wou

Re: [GNC] GC 3.2 Import Price File CSV

Thanks. I just recreated a new GC datafile with just 1 security definition as shown in your screenshot. I put your CSV price entry in a text file and imported it but gives me the error you have shown. Here’s why - Your security definition is ABF.L, but your CSV file has this set to ABF.

Re: [GNC] GC 3.2 Import Price File CSV

Can you please share a screenshot? Of both CSV import setting screen and the definition of the security in the security editor. The CSV import price screen should also allow settings for date formats, locale, delimiters and such. Once I look at your whole import screen, I may be able to help

Re: [GNC] Getting CAGR for stocks/accounts

I agree that the return figures shown in the Advanced Portfolio report isn’t of much use to folks tracking their portfolios over long periods. Annualised return (or CAGR) would have been nice, but it’s not there yet. On dividends, there must be something you are doing wrong with the way you

Re: [GNC] Error in Finance:Quote

Shokster, I have been unable to get F:Q to work with Indian stocks and mutual funds either, but that limitation is now overcome with GC 3.* series introducing the ability to upload prices from a CSV file. I have been using this feature in 3.2 and it works well. In fact, if your CSV format is

Re: [GNC] Frequency of 28 Days

If you are talking about setting up a schedule transaction that recurs every 28 days, you can try this - - right click on a transaction you want to schedule and choose menu option “Schedule” - In the window that opens, click on Advanced - On the Advanced Editor window, click on “Frequency” tab

Re: [GNC] Linux Mint 18.2 Sonya and Gnucash 3.2

Sorry, I am a newbie to Linux ecosystem and foolishly thought Sonya was the posters name instead of Linux mint version! In any case, OP should now know what’s possible on Linux. Thanks for the clarification. Cheers. > On 28-Jul-2018, at 5:50 PM, David Cousens wrote: > > Deva >

Re: [GNC] Linux Mint 18.2 Sonya and Gnucash 3.2

I recently experimented with Linux mint (Tara) edition (which I think is 18.2 - version you are using) and the first thing I checked was the version of GnuCash available for use. As you noted, the Software Manager has an older version, but you can get the latest 3.2 version from flatpack.

Re: [GNC] consolidate transactions report

Thank you Doug. This report looks interesting and useful, though I haven’t explored its many features yet. I had some initial hiccups getting the report to show up in GC 3.1 (on Mac OS Sierra) - seems like the config file in question has changed from 2.6 series. It used to be called

Re: [GNC] Invoice tax rouding issue in 2.x

For rounding adjustments like these, I typically use the discount columns. In your example, you can do the following to get the final total right - Discount Type = “$" Discount How = “=“ Discount = 0.01 The Tax Invoice report allows you to change some column headers, so I just change the

Re: GnuCash 3.0 initial observations

before you can call him a man how many years must a mountain exist before it is washed to the sea … the answer is blown’ in the wind And the last thing I want to see as the wind blows is GnuCash’s eguile balance sheet! So please keep it alive! Cheers, Deva On 05-Apr-2018, at 9:07 PM, <gnuc

Re: GnuCash 3.0 initial observations

, but splitting transactions in an account into many sub accounts was not. I think the CSV transaction importer can provide many benefits in this regard. Cheers, Deva > On 05-Apr-2018, at 9:07 PM, Adrien Monteleone <adrien.montele...@gmail.com> > wrote: > > >> On Apr 5

Re: trial balance - how to find mismatch question

releases will bring back the average cost computation as it was before 2.6.12, so this is not an issue, at least for me. Cheers. On 16-Feb-2018, at 9:02 PM, John Ralls <jra...@ceridwen.us<mailto:jra...@ceridwen.us>> wrote: On Feb 16, 2018, at 5:58 AM, Deva - <pobox.d...@outlook.in

Re: trial balance - how to find mismatch question

I am seeing huge imbalances in my trial balance report as well. This is one report I have not been sending to my tax professional until I understand how to interpret it. This behaviour is seen in 2.6.19 currently, but I am sure I have seen it in previous versions as well (I have been on GC

Re: Instructions for GST India

Thanks Amish. I am glad you were able to compensate for my failings… I am sure many users can benefit from your template, especially if it gets shipped as part of the next release like Frank said. Cheers, Deva > > Message: 1 > Date: Wed, 7 Feb 2018 22:26:35 +0530 > From: Am

Re: Instructions for GST India

o long ago. Cheers, Deva -- From: Liz <ed...@billiau.net<mailto:ed...@billiau.net>> To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> Subject: Re: Instructions for GST India Message-ID: <20180205205957.0c294...@billiau.net<mailto:2

Re: Mutual fund cost basis changes between 2.6.6 and 2.6.19

, at 9:43 PM, Deva - <pobox.d...@outlook.in<mailto:pobox.d...@outlook.in>> wrote: Thanks John. I haven’t filed a bug/enhancement before - GnuCash has been wonderful as it is! I will look into how to do this and add the use case as you suggested. In the meantime, should I downgrade

Re: Mutual fund cost basis changes between 2.6.6 and 2.6.19

to:jra...@ceridwen.us>> wrote: On Jan 12, 2018, at 3:43 AM, Deva - <pobox.d...@outlook.in<mailto:pobox.d...@outlook.in>> wrote: Hello, I am on Mac OS Sierra v10.12.6. Until a few days ago, I was using GnuCash 2.6.6 and just in the last 2 days, I upgraded to the lates

Re: Mac OS accelerator keys

instead of the “Alt” key. Just thought I’d list the observation here just in case the intended behaviour was different. Thanks again to both of you for timely help. Cheers. Deva On 13-Sep-2017, at 1:17 PM, Christoph R <subscriptions+lis...@rohland.net<mailto:subscriptions+lis...@rohland.net>

Re: Mac OS accelerator keys

; (gtk_accel_path "/GncPluginPageRegisterActions/DuplicateTransactionAction" "d”) I perform these actions fairly frequently on any given transaction register, so I am keen on getting this to work. Am I missing something? Cheers, Deva On 12-Sep-2017, at 8:09 PM, John Ralls &l

Mac OS accelerator keys

u please let me know how I can set this up for a Mac? Cheers, Deva >>> start post From: Christopher Lam [mailto:christopher@gmail.com] Sent: Saturday, September 9, 2017 3:49 AM To: Drew H. <dre...@outlook.com<mailto:dre...@outlook.com>> Cc: gnucash-user@gnucash.org<mailt