Re: [GNC] sales tax liability report?

[Deva via gnucash-user]

Michael,

If I’m not mistaken, Ted mentioned that he was looking for income & liabilities 
report. 

Hence my caveat - if the user followed instructions in the guide to setup tax 
tables and appropriate accounts, the report I mentioned could meet his 
requirements. 

In fact, before Income & GST Statement was introduced as part of standard 
reports, I was doing something similar when India was still under Sales Tax 
regime. I think at the time, the Transaction Report options had to be tweaked 
to produce something similar to the standard report now. 

By income, I presume Ted means net income after accounting for sales tax 
liability. 

Cheers. 

===
Date: Thu, 9 May 2024 09:52:49 -0400
From: Michael or Penny Novack 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] sales tax liability report?
Message-ID: <44cd4d3d-502e-45cb-8a95-62cd472c5...@comcast.net>
Content-Type: text/plain; charset=UTF-8; format=flowed

On 5/9/2024 2:57 AM, Deva via gnucash-user wrote:
> Ted,
>
> If you have setup your accounts based on suggestions in the tutorial and 
> concepts guide, you can try the following report -
>
> Reports -> Income & Expense -> Income and GST Statement
>
> In your case, GST = Sales Tax

We MIGHT need a clarification, but my sense was that the sales tax 
amounts collected but not yet sent to the gov't were (correctly) being 
credited to a liability, not an income account. So would not show up as 
an account under an I report. In other words, the amount collected (on 
behalf of some gov't) not being considered income so when paid to the 
gov't not an expense. Never YOUR money, just holding it for the gov't 
till sent, quarterly, or whatever.

Maybe what we want here is a better description of the report that is 
wanted? What is it supposed to show?. For example, were I running a 
business that was collecting sales tax for many states, I'd probably 
want a report showing how much I owed each << and I think I would be 
using part of a Balance Sheet report to get that (ignore the rest of 
it). in other words, I'd have a parent under liabilities "sales tax 
owed" under which a child for each jurisdiction. Run each quarter (or 
whatever) looking at JUST this parent and its children to see what 
payment to make to each jurisdiction >>

Michael D Novack

___
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 do this by using Reply-To-List or Reply-All.

Re: [GNC] sales tax liability report?

[Deva via gnucash-user]

Ted,

If you have setup your accounts based on suggestions in the tutorial and 
concepts guide, you can try the following report -

Reports -> Income & Expense -> Income and GST Statement

In your case, GST = Sales Tax

Cheers. 

—
Date: Tue, 7 May 2024 15:35:20 -0700
From: tburmas 
To: gnucash-user@gnucash.org
Subject: [GNC] sales tax liability report?
Message-ID: 
Content-Type: text/plain; charset=UTF-8; format=flowed

Hello,

 ??? Is there a way to have a single report that shows sales tax 
liabilities?? This would need to have income and liabilities in one 
report, which I am not sure can be done (at least i haven't found it yet).


Thank you,

Ted
___
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 do this by using Reply-To-List or Reply-All.

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

[Deva -]

Ashok,

You can check/try the following -

a. In the security editor, confirm that INDIAMUTUAL is in fact the namespace 
used for those 2 MF ISINs.
b. I use the CSV importer every month to do just what you are trying to do. 
Only difference from your data is that I use the date format in -mm-dd 
format (in the data file) and in the import screen, I choose the y-m-d option 
instead.
c. Actually, this might be your problem because your dates in the CSV file are 
dd/mm/yy, whereas the importer is expecting d-m-y. (separator is -, but you 
have /).

Otherwise, your settings and data looks ok.

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"
Message-ID:

Content-Type: text/plain; charset="utf-8"

Hello everyone, trying this list for the first time, I hope I am following
the instructions.

I have downloaded and prepared an import.csv file with 2 lines as:
05/08/21, INDIAMUTUAL,INF209KA12Z1, INR,143.021
05/08/21, INDIAMUTUAL,INF209K01546, INR,27.1064

Where the columns are Date, Namespace, From Symbol, To Currency, Amount

The 'Namespace', & 'Currency To' dropdown comes up with an error
respectively as:
Error 1: Column 'From Namespace' could not be understood. Value can't be
parsed into a valid namespace.
Error 2: Column 'Currency To' could not be understood. Value can't be
parsed into a valide commodity.

Could somebody please explain to me how to import the prices? I think I'm
doing it right - there's a screenshot below.

The above example has 2 different mutual funds. Once the concept is proved,
I plan to update many (~20) mutual fund prices from a single import csv
file on a weekly basis.

Thanks,
Ashok


Sent from Outlook<http://aka.ms/weboutlook>



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"
Message-ID:

Content-Type: text/plain; charset="utf-8"

Hello everyone, trying this list for the first time, I hope I am following
the instructions.

I have downloaded and prepared an import.csv file with 2 lines as:
05/08/21, INDIAMUTUAL,INF209KA12Z1, INR,143.021
05/08/21, INDIAMUTUAL,INF209K01546, INR,27.1064

Where the columns are Date, Namespace, From Symbol, To Currency, Amount

The 'Namespace', & 'Currency To' dropdown comes up with an error
respectively as:
Error 1: Column 'From Namespace' could not be understood. Value can't be
parsed into a valid namespace.
Error 2: Column 'Currency To' could not be understood. Value can't be
parsed into a valide commodity.

Could somebody please explain to me how to import the prices? I think I'm
doing it right - there's a screenshot below.

The above example has 2 different mutual funds. Once the concept is proved,
I plan to update many (~20) mutual fund prices from a single import csv
file on a weekly basis.

Thanks,
Ashok

___

gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

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


Deva,
I found this in my junk folder and I have no idea why it ended up there and all 
the others GNC emails didn't.

Your suggestion of doing the refresh does in fact update the account totals 
like I wanted.

A belated thanks for the suggestion.

Jack

On 4/8/21 7:23 AM, Deva - wrote:
Jack,

I don't exactly have an answer to your question, but I find that such 
mysterious behaviour goes away sometimes when I do View->Refresh. For instance, 
when I am switching datafiles, sometimes the accounts page shows all totals as 
zero (I am on Ubuntu GNC 3.10). All totals reappear when 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 <mailto:jcf_m_li...@me.com>
To: Gnucash Users <mailto:gnucash-user@gnucash.org>
Subject: [GNC] When Do Account Totals Update When Updating Prices
Message-ID: 
<8b17fa76-f11f-8408-f985-5093b129f...@me.com><mailto:8b17fa76-f11f-8408-f985-5093b129f...@me.com>
Content-Type: text/plain; charset=utf-8; format=flowed


I have an IRA account set up where the parent account is a Bank Account
and under that are a number of Stock and Mutual Funds accounts.
When I update the prices by importing a CSV file the total $ amount for
the parent (IRA Account) account does not always update right away.
Sometimes it take a while and I'm a bit confused on what's going on.

What triggers the account totals to update?

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous



--



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

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: [GNC] Using the advanced portfolio report for mutual fund income


Hello Deva,

In fixing the problem with this report I am reminded of a quote from Winston 
Churchill in the early days of the second world war "Americans can always be 
trusted to do the right thing, once all other possibilities have been 
exhausted". I have done the same in respect to this GnuCash report. If I'd 
followed every step of your advice it would have been fixed much more quickly. 
Things started to go wrong when I entered the bank transaction into the staging 
account before entering each fund distribution. The transaction order entry in 
the staging account seems to be important. After that failure and several more 
my efforts faded. Then I read your email again and Eureka ... it works!

I apologise for the lateness of my response, and thank you for your advice.

Best regards

Alister


On 5/09/2020 4:31 pm, pobox.d...@outlook.in<mailto:pobox.d...@outlook.in> wrote:
Alister,

I had a similar problem when I recorded multiple stock buys in a single 
transaction covering over a dozen splits to account for purchases in different 
stock accounts along with its attendant brokerage and statutory levies. 
Advanced portfolio report would show incorrect brokerage amounts in that case.

The way I got around it was to create a dummy asset account (called $Cash in my 
case, but you can call it "Broker" or "Suspense” or “Staging” account, etc.). 
This is a dummy asset account that acts as a staging account - a sort of a 
bridge between fund/stock accounts and your bank account. This account is of 
simple type Asset (not Mutual Fund or Stock). And it can reside under the main 
“Investments” asset account. For example -

Assets:Investments:$Cash
Assets:Investments:Mutual Fund:Fund1
Assets:Investments:Mutual Fund:Fund2
.
.
. and so on...
Assets:Investments:Stocks:Stock1
Assets:Investments:Stocks:Stock2
.
.
. and so on...

The idea is, $Cash will always be a zero balance account after your record all 
your transactions.

With this structure in place, you can record multiple distributions from your 
fund house as if they were single distributions on each fund (as you stated in 
example 1), but instead of depositing your bank account, you would deposit your 
$Cash staging account instead. After recording your $75 distribution from fund 
1 and $25 distribution from fund 2 in the respective fund accounts, you would 
now have a balance of $100 in your $Cash (staging) account.

Now from your $Cash account, record a single transaction to move $100 from it 
to your bank account. This will bring your $Cash account back to 0.

$Cash account will not be visible if you have your settings to hide zero 
balance accounts, so you have to change 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<mailto: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:gnucash-user@gnucash.org>
Subject: [GNC] Using the advanced portfolio report for mutual fund
income
Message-ID: 
<03a772fd-0aac-e623-69b0-ffe51c387...@gmail.com<mailto:03a772fd-0aac-e623-69b0-ffe51c387...@gmail.com>>
Content-Type: text/plain; charset=utf-8; format=flowed

Can anybody help me work around a problem using the Advanced Portfolio
Report to report income on mutual funds where a single payment is made
for multiple funds? The Advanced Portfolio report requires atransaction
split to include a dummy transaction of zero value as shown below:

Scenario 1 - A single distribution payment per fund

Direct Credit CFS Distribution







100



100



Assets: Bank: CBA



100







Income: Mutual Funds: CFS: Fund1





100





Assets: Investments: Fund managers: CFS: Fund1



0



0











In this situation the Advanced Portfolio Report correctly reports the
income for Fund1 as $100.

Where more than one fund is paid the split becomes more complicated:


Scenario 2 - A single distribution payment for two funds

Direct Credit CFS Distribution







100



100



Assets: Bank: CBA



100







Income: Mutual Funds: CFS: Fund1





75





Assets: Investments: Fund managers: CFS: Fund1



0



0





Income: Mutual Funds: CFS: Fund2





25





Assets: Investments: Fund managers: CFS: Fund2



0



0



In this situation the Advanced Portfolio Report incorrectly reports the
income for both Fund1 and Fund2 as $100. How do I correct this so the
result for Fund1 is $75 and Fund2 is $25?

I am using GnuCash 4.1 on Wi

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

[Deva -]

Jack,

I don't exactly have an answer to your question, but I find that such 
mysterious behaviour goes away sometimes when I do View->Refresh. For instance, 
when I am switching datafiles, sometimes the accounts page shows all totals as 
zero (I am on Ubuntu GNC 3.10). All totals reappear when 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 Updating Prices
Message-ID: <8b17fa76-f11f-8408-f985-5093b129f...@me.com>
Content-Type: text/plain; charset=utf-8; format=flowed


I have an IRA account set up where the parent account is a Bank Account
and under that are a number of Stock and Mutual Funds accounts.
When I update the prices by importing a CSV file the total $ amount for
the parent (IRA Account) account does not always update right away.
Sometimes it take a while and I'm a bit confused on what's going on.

What triggers the account totals to update?

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous



--

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

Thanks Chris and Adrien.

>>>
Parent account balances ( Account Balance / Subtotal / Do not show)
Parent account sub-totals (Show subtotals / Do not show)
<<<

If the end result is that the options will change to what you described above, 
it doesn't alter my report 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-subtotal' option.

To clarify:

The subtotal options are:

Parent account balances ( Account Balance / Subtotal / Do not show)
Parent account sub-totals (Show subtotals / Do not show / Text-book style 
(experimental))

The first one describes subtotals before an account group -- see [1] below.
Options will cause this line to show either "$0", "$108,000" or blank.

The second one describes subtotals after an account group -- see [2] below.
Options will cause this line to show either "$108,000", or blank (line 
skipped), "$108,000" with an unusual alignment.

e.g.
Asset $0   [1]
Asset:Bank $8,000
Asset:House $100,000
Total Asset $108,000[2]

The proposal would modify saved reports with "Parent account sub-totals" set to 
"Text-book style (experimental)" to use "Show subtotals", and options limited 
to:

Parent account balances ( Account Balance / Subtotal / Do not show)
Parent account sub-totals (Show subtotals / Do not show)


I suspect that the number of users adversely affected will be near zero.

Hello Christopher,
I am not sure I understand the impact of this change.
My settings on the Income report are -

Include accounts with zero total balances (unchecked)
Omit zero balance figures (checked)
Parent account balances (Do not show)
Parent account sub-totals (Show sub-totals)

I don't use the Text book style (experimental) option.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

Hello Christopher,

I am not sure I understand the impact of this change.

My settings on the Income report are -

Include accounts with zero total balances (unchecked)
Omit zero balance figures (checked)
Parent account balances (Do not show)
Parent account sub-totals (Show sub-totals)

I don't use the Text book style (experimental) option.

This doesn't print the parent subtotals at the top, but it's aligned to the 
bottom, after all sub-accounts are printed. If this format is still possible 
with your change, then I am good.

If you mean, with this change, the subtotals will get printed 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' option.
Message-ID:

Content-Type: text/plain; charset="UTF-8"

To long-time and new users,

Regarding subtotals in several reports e.g.

Asset $0
Asset:Bank $8,000
Asset:House $100,000
Total Asset $108,000

>From 2003 onwards, there was a 'parent account subtotals' option 'text book
style (experimental)' to show subtotal after groups of accounts. It mimics
'parent account subtotals' = 'show subtotals' with a different alignment.
It has never graduated from experimental and is buggy. I suggest we remove
it, and switch the option to 'show subtotals'. The change will be in 4.5
due in March/April. The relevant PR is
https://github.com/Gnucash/gnucash/pull/908

Any objections?

--


Sent from Outlook<http://aka.ms/weboutlook>


From: gnucash-user  on 
behalf of gnucash-user-requ...@gnucash.org 
Sent: 12 February 2021 21:12
To: gnucash-user@gnucash.org 
Subject: gnucash-user Digest, Vol 215, Issue 31

Send gnucash-user mailing list submissions to
gnucash-user@gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
gnucash-user-requ...@gnucash.org

You can reach the person managing the list at
gnucash-user-ow...@gnucash.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."


Today's Topics:

   1. Re:  USAA FSB requires newer QWIN support (Bob White)
   2. Re:  Fwd: GnuCash window placement (David Carlson)
   3. Re:  Fwd: GnuCash window placement (David Cousens)
   4. Re:  Fwd: GnuCash window placement (David Carlson)
   5. Re:  Fwd: GnuCash window placement (David Carlson)
   6.  About 'parent-account-subtotal' option. (Christopher Lam)
   7. Re:  USAA FSB requires newer QWIN support (Jon Schewe)
   8. Re:  About 'parent-account-subtotal' option. (Adrien Monteleone)
   9. Re:  USAA FSB requires newer QWIN support (Jon Schewe)
  10. Re:  About 'parent-account-subtotal' option. (Christopher Lam)
  11.  Scheduled Transactions (bdp3)
  12. Re:  Scheduled Transactions (David Carlson)


--

Message: 1
Date: Fri, 12 Feb 2021 22:29:36 -
From: Bob White 
To: gnucash-user@gnucash.org
Cc: "gnucash-de...@gnucash.org" 
Subject: Re: [GNC] USAA FSB requires newer QWIN support
Message-ID: 
Content-Type: text/plain;charset=utf-8;format=flowed

I got new USAA OFX download working with GNC 4.4.1.

It's mainly a configuration task.

-- User config --
int uniqueId=""
char backendName="aqofxconnect"
char userName=""
char userId=""
char customerId=""
char country="us"
char bankCode="314074269"
int lastSessionId="0"

data {
? backend {
? ? char bankName="USAA Federal Savings Bank"
? ? char org="USAA Federal Savings Bank"
? ? char fid="67811"
? ? char 
serverAddr="https%3A%2F%2Fdf3cx-services.1fsapi.com%2Fcasm%2Fusaa%2Faccess.ofx"
? ? char appId="QMOFX"
? ? char appVer="2300"
? ? char headerVer="103"
? ? char clientUid=""
? ? int httpVMajor="0"
? ? int httpVMinor="0"
? ? char httpUserAgent="InetClntApp%2F3.0"
? } #backend
} #data
-

Notes:
? -- 'httpUserAgent' is currently not configurable through GNC v4.4.1, but it 
works when included in the file. ?It has been added in newer AqBanking, look 
for support in next GNC release.
? -- 'CLIENTUID' can be found in OFXLog.txt generated by Quicken. ?Signup for 
trial and cancel within 30 days no charge.
? -- 'your new USAA access id' can be found at https://www.usaa.com/accessid

You will need to disconnect accounts from within the AqBanking Wizard, download 
accounts with new user configuration, then reconnect accounts. ?In my case, the 
new credit card account numbers in the accounts 

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

[pobox . deva]

Alister,

I had a similar problem when I recorded multiple stock buys in a single 
transaction covering over a dozen splits to account for purchases in different 
stock accounts along with its attendant brokerage and statutory levies. 
Advanced portfolio report would show incorrect brokerage amounts in that case.

The way I got around it was to create a dummy asset account (called $Cash in my 
case, but you can call it "Broker" or "Suspense” or “Staging” account, etc.). 
This is a dummy asset account that acts as a staging account - a sort of a 
bridge between fund/stock accounts and your bank account. This account is of 
simple type Asset (not Mutual Fund or Stock). And it can reside under the main 
“Investments” asset account. For example -

Assets:Investments:$Cash
Assets:Investments:Mutual Fund:Fund1
Assets:Investments:Mutual Fund:Fund2
.
.
. and so on...
Assets:Investments:Stocks:Stock1
Assets:Investments:Stocks:Stock2
.
.
. and so on...

The idea is, $Cash will always be a zero balance account after your record all 
your transactions.

With this structure in place, you can record multiple distributions from your 
fund house as if they were single distributions on each fund (as you stated in 
example 1), but instead of depositing your bank account, you would deposit your 
$Cash staging account instead. After recording your $75 distribution from fund 
1 and $25 distribution from fund 2 in the respective fund accounts, you would 
now have a balance of $100 in your $Cash (staging) account.

Now from your $Cash account, record a single transaction to move $100 from it 
to your bank account. This will bring your $Cash account back to 0.

$Cash account will not be visible if you have your settings to hide zero 
balance accounts, so you have to change 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:gnucash-user@gnucash.org>
> Subject: [GNC] Using the advanced portfolio report for mutual fund
>   income
> Message-ID: <03a772fd-0aac-e623-69b0-ffe51c387...@gmail.com 
> <mailto:03a772fd-0aac-e623-69b0-ffe51c387...@gmail.com>>
> Content-Type: text/plain; charset=utf-8; format=flowed
> 
> Can anybody help me work around a problem using the Advanced Portfolio 
> Report to report income on mutual funds where a single payment is made 
> for multiple funds? The Advanced Portfolio report requires atransaction 
> split to include a dummy transaction of zero value as shown below:
> 
> Scenario 1 - A single distribution payment per fund
> 
> Direct Credit CFS Distribution
> 
>   
> 
>   
> 
>   
> 
> 100
> 
>   
> 
> 100
> 
>   
> 
> Assets: Bank: CBA
> 
>   
> 
> 100
> 
>   
> 
>   
> 
>   
> 
> Income: Mutual Funds: CFS: Fund1
> 
>   
> 
>   
> 
> 100
> 
>   
> 
>   
> 
> Assets: Investments: Fund managers: CFS: Fund1
> 
>   
> 
> 0
> 
>   
> 
> 0
> 
>   
> 
>   
> 
>   
> 
>   
> 
>   
> 
> In this situation the Advanced Portfolio Report correctly reports the 
> income for Fund1 as $100.
> 
> Where more than one fund is paid the split becomes more complicated:
> 
> 
> Scenario 2 - A single distribution payment for two funds
> 
> Direct Credit CFS Distribution
> 
>   
> 
>   
> 
>   
> 
> 100
> 
>   
> 
> 100
> 
>   
> 
> Assets: Bank: CBA
> 
>   
> 
> 100
> 
>   
> 
>   
> 
>   
> 
> Income: Mutual Funds: CFS: Fund1
> 
>   
> 
>   
> 
> 75
> 
>   
> 
>   
> 
> Assets: Investments: Fund managers: CFS: Fund1
> 
>   
> 
> 0
> 
>   
> 
> 0
> 
>   
> 
>   
> 
> Income: Mutual Funds: CFS: Fund2
> 
>   
> 
>   
> 
> 25
> 
>   
> 
>   
> 
> Assets: Investments: Fund managers: CFS: Fund2
> 
>   
> 
> 0
> 
>   
> 
> 0
> 
>   
> 
> In this situation the Advanced Portfolio Report incorrectly reports the 
> income for both Fund1 and Fund2 as $100. How do I correct this so the 
> result for Fund1 is $75 and Fund2 is $25?
> 
> I am using GnuCash 4.1 on Windows 10 and fairly new user.
> 
> 
> Thank you for your efforts
> 
> Alister
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[pobox . deva]

Chris,

You will find plenty of discussions on this list on restricted/unrestricted 
funds for charity, trust, etc. Much of the account setup also revolves around 
taxation in your jurisdiction, so I won’t delve into those aspects.

My comment here is restricted to your query on which account setup is the way 
to go as you stated in the post below…

Since GnuCash’s account hierarchy starts with 5 fundamental account types as 
the root accounts viz., Assets, Equity, Expenses, Income & Liabilities, you 
will find that your first model will be easy to tailor in your scheme of things.

If you try to set it up as per your second model, you will soon run into 
technical restrictions imposed by GnuCash such as certain account types cannot 
be child accounts of certain parents and so on. So a lot more struggle will be 
involved in setting that up, or in some cases, it may just not allow 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 up for restricted/unrestricted PCC accounts -
>   what's a reasonable approach.
> Message-ID: <20200829101446.GA138604@esprimo>
> Content-Type: text/plain; charset=us-ascii
> 
> I have installed GnuCash on my xubuntu system and I've done the
> default 'business' accounts set-up as that seems closest to what a PCC
> needs.
> 
> Now presumably I need to apply some sort of restricted/unrestricted
> account types.
> 
> It would seem that the way to go would be to split 'expenses' into
> 'restricted expenses' and 'unrestricted expenses' and, similarly have
> 'restricted income' and 'unrestricted income'.  I guess these should
> be a layer below 'expenses' and 'income' so one has:-
> 
>expenses
>restricted
>church repairs
>new church furniture etc.
>unrestricted
>vicar's expenses
>CofE
>electricity bill
> 
> ... and similar for income.
> 
> Or should one have it the other way about:- 
> 
>restricted
>expenses
>   ...
>   ...
>income
>   ...
>   ...
> 
>unrestricted
>expenses
>
> 
>income
>
> 
> 
> It feels like the first is right as one can then still do overall
> expenses versus income more easily, or have I got it completely wrong
> and I shouldn't have restricted/unrestricted placeholders at all?
> 
> -- 
> Chris Green
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[pobox . deva]

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 { text-align: left; }
* { font-family: Helvetica; }

You can try with a font-family name of your choice to see if that helps.

Cheers.

> On 19-Jun-2020, at 3:59 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> Date: Fri, 19 Jun 2020 18:29:38 +0800
> From: Gio Bacareza mailto:gbacar...@gmail.com>>
> To: Christopher Lam  >
> Cc: GnuCash Users mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] Question marks instead of currency in reports
> Message-ID:
>>
> Content-Type: text/plain; charset="utf-8"
> 
> Thank you for the help Christopher. Yes there are bold fonts capable of
> displaying Philippine Peso but the report still displays question marks.
> See screenshot below
> 
> [image: image.png]
> 
> On Thu, Jun 18, 2020 at 2:20 PM Christopher Lam  >
> wrote:
> 
>> The only technical difference between regular lines and total lines is
>> that the latter is in bold. Try checking your font for bold symbol?
>> 
>> On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza, > > wrote:
>> 
>>> it now shows up in the reports but the total is still a question mark. see
>>> screenshot below
>>> [image: image.png]
>>> 
>>> On Thu, Jun 18, 2020 at 1:49 PM Gio Bacareza >> > wrote:
>>> 
 Hi Adrien and others,
 
 I checked the character viewer and Peso is confirmed to be there
>>> available
 in various fonts including Apple Symbols collection. See screenshot.
 [image: image.png]
 
 It is also in the Security Editor. see screenshot below
 [image: image.png]
 
 So I don't know what else I need to do.
 
 
 
 On Thu, Jun 18, 2020 at 12:47 AM Adrien Monteleone <
 adrien.montele...@lusfiber.net > 
 wrote:
 
> Your font probably doesn?t have that symbol. Check your custom CSS file
> and find a different font. I?d use either the Mac Character Viewer or
>>> Font
> Book to find a suitable one. It looks like that is Unicode 20B1. A
>>> simple
> search in Character Viewer for ?peso? brought it right up. Select the
> character in the search results in the middle pane, then use the
> bottom-right pane to click each sample to see what fonts have it.
>>> (that is
> a really bad UI/UX for this, but it is doable)
> 
> Also check Tools > Security editor and make sure a symbol is displayed
> there. If not, you can reset it manually.
> 
> Regards,
> Adrien
> 
>> On Jun 17, 2020 w25d169, at 3:34 AM, Gio Bacareza <
>>> gbacar...@gmail.com >
> wrote:
>> 
>> Why am I getting question marks instead of currency in the reports?
>> 
>> Gnucash Version: 3.7
>> Preferences / Default Currency = PHP (Philippine Peso)
>> 
>> Mac OSX Catalina
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> 
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists 
>  for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
 
 
 --
 cheers,
 
 Gio
 
>>> 
>>> 
>>> --
>>> cheers,
>>> 
>>> Gio
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org 
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>>> 
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists 
>>>  for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>> 
>> 
> 
> -- 
> cheers,
> 
> Gio

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more 

Re: [GNC] Australian Foreign Investments Taxation

[pobox . deva]

Ben,

I use the CSV Price Importer for loading stock/mutual fund prices every month 
(all in INR).

Though I haven’t used this in the context of currency exchange rates, I think 
it should be possible because you are essentially converting price from one 
commodity to another in both scenarios.

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
> From: Ben Stanley mailto:ben.stan...@gmail.com>>
> To: Christopher Lam  <mailto:christopher@gmail.com>>
> Cc: GnuCash users group  <mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] Australian Foreign Investments Taxation
> Message-ID:
>   <17153f294f8.27d0.e122910561de4a0ea07b2811c86c2...@gmail.com 
> <mailto:17153f294f8.27d0.e122910561de4a0ea07b2811c86c2...@gmail.com>>
> Content-Type: text/plain; format=flowed; charset="us-ascii"
> 
> I can get a CSV file of daily exchange rate data. Is there a way of 
> importing it into the price database?
> 
> On 7 April 2020 7:17:54 pm Christopher Lam  <mailto:christopher@gmail.com>> wrote:
>> The only report which is capable of using closest-to-date conversion is the 
>> Transaction Report from the Income:Dividends(USD) and Income:CapGains(USD) 
>> accounts, using a Report Currency of AUD. It will choose the USD/AUD price 
>> from the price editor list closest to each transaction's posting date.
>> 
>> You'll have to ensure the price list has prices at your desired dates 
>> manually.
>> 
>> 
>> 
>> On Tue, 7 Apr 2020 at 09:13, Ben Stanley > <mailto:ben.stan...@gmail.com>> wrote:
>> 
>> Hello Gnucash people,
>> 
>> This question may be more suited to Gnucash developers, but lets try it
>> here first.
>> 
>> I need to perform a tax calculation in accordance with instructions from
>> the Australian Taxation Office. All foreign income, deductions and
>> foreign tax paid must be converted to Australian Dollars for tax purposes.
>> 
>> https://www.ato.gov.au/Business/International-tax-for-business/In-detail/Investing-overseas/Converting-foreign-income-to-Australian-dollars/
>>  
>> <https://www.ato.gov.au/Business/International-tax-for-business/In-detail/Investing-overseas/Converting-foreign-income-to-Australian-dollars/>
>> 
>> The conversion used must correspond to the transaction date.
>> 
>> In Gnucash, it would appear that the price editor could be used to enter
>> the necessary conversion data, if it were easy to see all of the dates
>> where conversions are required. However, this is tedious.
>> 
>> Far better would be to use Finance::Quote to fetch the necessary
>> conversion data for the dates it is required for. However, it seems that
>> Finance::Quote is only capable of fetching "recent" data. (The
>> documentation that I looked at seemed to be very old.)
>> 
>> http://finance-quote.sourceforge.net/documentation.html 
>> <http://finance-quote.sourceforge.net/documentation.html>
>> 
>> What is needed is the ability to pass a date, or a range of dates, and
>> request Finance::Quote to fetch prices for that date or date interval.
>> This would make Finance::Quote far more useful than just fetching the
>> most recent price data.
>> 
>> Is there some feature in Gnucash that I have missed that would allow me
>> to generate a report, with dividends and Capital Gains converted from
>> USD -> AUD using the currency conversion as at the transaction dates?
>> 
>> Thanks,
>> Ben Stanley.
>> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Stock Entry Issue with Version 3.8

[pobox . deva]

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 price, but that can be 
ignored. This way, you will have your share balance computed correctly.

Cheers.

> On 25-Mar-2020, at 11:51 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> 
> Message: 2
> Date: Wed, 25 Mar 2020 13:21:17 -0500
> From: "Dr. Timothy B. Jones"  >
> To: gnucash-user@gnucash.org 
> Cc: gnucash-user@gnucash.org 
> Subject: [GNC] Stock Entry Issue with Version 3.8
> Message-ID:  >
> Content-Type: text/plain; charset="us-ascii"
> 
> Greetings:
> 
> On 12/13 I entered a stock trade on a new stock added to the database without 
> incident.  On 12/31 I upgraded to Version 3.8Windows Version.  Today I 
> have been trying to enter additional buys over the past two months and the 
> software is adding a decimal to my shares (no matter how I enter) calculating 
> the correct price, but since it changes the share decimal, it calculates the 
> wrong total and share balance.  I have tried it every possible way and no 
> matter what...the software changes the share decimal incorrectly and gives me 
> an incorrect entry.  Here is a screen shot:
> -- next part --
> A non-text attachment was scrubbed...
> Name: image1.jpeg
> Type: image/jpeg
> Size: 46442 bytes
> Desc: not available
> URL: 
>   
> >
> -- next part --
> Note...the system forced calculation is incorrect.  It was entered 10.0 
> shares at a cost of $915.  No matter which variable I leave off I get this 
> result and if I enter all three I get the error that the math is wrong, which 
> variable would I like to have calculated.  Errplease help!

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] importing csv multisplit multicurrency problems

[pobox . deva]

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 Pobox.Deva,
> 
> Thank you for the suggestion. I'll try that out. However my problem, I think 
> though I may be wrong, is not the price database but the importing 
> multicurrency transactions.
> 
> I even made it simpler. Pre-import, I calculated and populated the currency 
> conversions using just 1 exchange rate. I thought that by doing this I avoid 
> having to maintain a price database that could change on a daily basis. 
> Because this would mean the calculating the conversions prior to import will 
> require me to have a different conversion rate depending on the day. It's 
> possible but I thought it will take more work.
> 
> But I may be wrong. So do you think that fixing the price database will fix 
> the multi-currency import problem I am having?
> 
> Thanks.
> 
> 
> On Fri, Mar 6, 2020 at 1:37 PM  > wrote:
> 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.
> 
> > On 06-Mar-2020, at 9:53 AM, gnucash-user-requ...@gnucash.org 
> >  wrote:
> > 
> > Date: Fri, 6 Mar 2020 12:23:17 +0800
> > From: Gio Bacareza mailto:gbacar...@gmail.com> 
> > >>
> > To: GnuCash Users  >   > >>
> > Subject: Re: [GNC] importing csv multisplit multicurrency problems
> > Message-ID:
> >> 
> >   > >>
> > Content-Type: text/plain; charset="UTF-8"
> > 
> > As mentioned I did some follow through tests with empty and pre-populated
> > currency price databases. Sharing it here:
> > 
> > Conclusions:
> > When doing multi-currency csv imports, it works when the price database is
> > pre-populated with exchange rates consistent with exchange rates used in
> > the import.
> > The issue I have with this is that pre-populating the price DB is
> > cumbersome.
> > There has to be a better way.
> > 
> > More details of test here
> > https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing
> >  
> > 
> >  
> >  >  
> > >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> 
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists 
>  for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> 
> -- 
> cheers,
> 
> Gio

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] importing csv multisplit multicurrency problems

[pobox . deva]

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.

> On 06-Mar-2020, at 9:53 AM, gnucash-user-requ...@gnucash.org wrote:
> 
> Date: Fri, 6 Mar 2020 12:23:17 +0800
> From: Gio Bacareza mailto:gbacar...@gmail.com>>
> To: GnuCash Users mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] importing csv multisplit multicurrency problems
> Message-ID:
>>
> Content-Type: text/plain; charset="UTF-8"
> 
> As mentioned I did some follow through tests with empty and pre-populated
> currency price databases. Sharing it here:
> 
> Conclusions:
> When doing multi-currency csv imports, it works when the price database is
> pre-populated with exchange rates consistent with exchange rates used in
> the import.
> The issue I have with this is that pre-populating the price DB is
> cumbersome.
> There has to be a better way.
> 
> More details of test here
> https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing
>  
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[pobox . deva]

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 income account 
was added, it didn’t automatically get selected in the Report Options->Accounts 
tab. This was made evident by the add option summary setting, in which this 
account wasn’t listed.

To Maf’s musings, yes, the account tree is quite nested, because this was done 
at a time of chaotic rollout of GST in India and I was trying to keep all 
possibilities open by way of reporting - hence the granularity.

This is an extremely valuable report for my GST filings, so I am relieved that 
the taxes I have been paying are accurate.

Cheers.



> On 02-Feb-2020, at 4:44 PM, Christopher Lam  wrote:
> 
> Set General/Add options summary to 'always', and paste the headers.
> 
> On Sun, 2 Feb 2020 at 10:36,  > wrote:
> 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 
> 
> 
> Thank you for making time to review this anomaly.
> 
> Cheers.
> 
>> On 02-Feb-2020, at 2:04 PM, Christopher Lam > > wrote:
>> 
>> This report doesn't query the A/R register. It queries the Income account. 
>> Did you post it there?
>> 
>> On Sun, 2 Feb 2020, 4:09 pm , > > wrote:
>> 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 entire financial year thus far (1-APR-19 to 1-FEB-20) and 
>> that particular invoice doesn’t show up in any quarter or month.
>> 
>> It happened once before about 2 years ago when an invoice was posted on 1st 
>> of the month, internally, it got recorded as 31st of the previous month in 
>> one of the splits and the report correctly didn’t show that particular 
>> invoice. But this was in the 2.6 series and I was able to edit the A/R 
>> register then, so I went in and changed the offending date to 1st and 
>> everything worked fine from then on.
>> 
>> But in the current 3.x series, the A/R register edit feature is now 
>> disabled. However, all dates are stored correctly, so I am at a loss as to 
>> why it’s not showing on the report.
>> 
>> I am not sure if the PNG attachments I sent earlier came through. If it 
>> didn’t, I am sharing the same via Google Drive links here. Hopefully this 
>> will work.
>> 
>> https://drive.google.com/open?id=1FsWMCgwszskdxeNuOi6VApvxn_vyS7_y 
>> 
>> https://drive.google.com/open?id=1qqbvieyO4NnTlxDyzlMRmvqd_u-29X3p 
>> 
>> 
>> Please let me know if you need any more information.
>> 
>> Cheers.
>> 
>> 
>>> On 02-Feb-2020, at 1:34 AM, Christopher Lam >> > wrote:
>>> 
>>> Doesn't previous quarter end on 31/12/2019?
>>> 
>>> On Sat, 1 Feb 2020, 10:58 pm , >> > wrote:
>>> 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 that’s not showing up in the Income & GST Statement 
>>> (i.e., invoice id = 000361). And I can’t find out why.
>>> 
>>> This invoice was opened on 2-JAN-2020, posted on 6-JAN-2020 and paid on 
>>> 2-JAN-2020. I tried unposting and changing all dates to 2-JAN-2020 and it 
>>> still doesn’t show up on the report.
>>> 
>>> When I run the Income & GST Statement report for the previous quarter, this 
>>> invoice isn’t there either.
>>> 
>>> Can someone please help since my GST tax payment is due in the coming week?
>>> 
>>> This invoice is no different from any other invoice in the period and I 
>>> have confirmed that it is still marked active.
>>> 
>>> Cheers.
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org 
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>>> 
>>> If you are using Nabble or Gmane, please see 
>>> 

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

[pobox . deva]

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 


Thank you for making time to review this anomaly.

Cheers.

> On 02-Feb-2020, at 2:04 PM, Christopher Lam  wrote:
> 
> This report doesn't query the A/R register. It queries the Income account. 
> Did you post it there?
> 
> On Sun, 2 Feb 2020, 4:09 pm ,  > wrote:
> 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 entire financial year thus far (1-APR-19 to 1-FEB-20) and 
> that particular invoice doesn’t show up in any quarter or month.
> 
> It happened once before about 2 years ago when an invoice was posted on 1st 
> of the month, internally, it got recorded as 31st of the previous month in 
> one of the splits and the report correctly didn’t show that particular 
> invoice. But this was in the 2.6 series and I was able to edit the A/R 
> register then, so I went in and changed the offending date to 1st and 
> everything worked fine from then on.
> 
> But in the current 3.x series, the A/R register edit feature is now disabled. 
> However, all dates are stored correctly, so I am at a loss as to why it’s not 
> showing on the report.
> 
> I am not sure if the PNG attachments I sent earlier came through. If it 
> didn’t, I am sharing the same via Google Drive links here. Hopefully this 
> will work.
> 
> https://drive.google.com/open?id=1FsWMCgwszskdxeNuOi6VApvxn_vyS7_y 
> 
> https://drive.google.com/open?id=1qqbvieyO4NnTlxDyzlMRmvqd_u-29X3p 
> 
> 
> Please let me know if you need any more information.
> 
> Cheers.
> 
> 
>> On 02-Feb-2020, at 1:34 AM, Christopher Lam > > wrote:
>> 
>> Doesn't previous quarter end on 31/12/2019?
>> 
>> On Sat, 1 Feb 2020, 10:58 pm , > > wrote:
>> 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 that’s not showing up in the Income & GST Statement 
>> (i.e., invoice id = 000361). And I can’t find out why.
>> 
>> This invoice was opened on 2-JAN-2020, posted on 6-JAN-2020 and paid on 
>> 2-JAN-2020. I tried unposting and changing all dates to 2-JAN-2020 and it 
>> still doesn’t show up on the report.
>> 
>> When I run the Income & GST Statement report for the previous quarter, this 
>> invoice isn’t there either.
>> 
>> Can someone please help since my GST tax payment is due in the coming week?
>> 
>> This invoice is no different from any other invoice in the period and I have 
>> confirmed that it is still marked active.
>> 
>> Cheers.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org 
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>> 
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists 
>>  for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[pobox . deva]

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 entire financial year thus far (1-APR-19 to 1-FEB-20) and that 
particular invoice doesn’t show up in any quarter or month.

It happened once before about 2 years ago when an invoice was posted on 1st of 
the month, internally, it got recorded as 31st of the previous month in one of 
the splits and the report correctly didn’t show that particular invoice. But 
this was in the 2.6 series and I was able to edit the A/R register then, so I 
went in and changed the offending date to 1st and everything worked fine from 
then on.

But in the current 3.x series, the A/R register edit feature is now disabled. 
However, all dates are stored correctly, so I am at a loss as to why it’s not 
showing on the report.

I am not sure if the PNG attachments I sent earlier came through. If it didn’t, 
I am sharing the same via Google Drive links here. Hopefully this will work.

https://drive.google.com/open?id=1FsWMCgwszskdxeNuOi6VApvxn_vyS7_y 

https://drive.google.com/open?id=1qqbvieyO4NnTlxDyzlMRmvqd_u-29X3p 


Please let me know if you need any more information.

Cheers.


> On 02-Feb-2020, at 1:34 AM, Christopher Lam  wrote:
> 
> Doesn't previous quarter end on 31/12/2019?
> 
> On Sat, 1 Feb 2020, 10:58 pm ,  > wrote:
> 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 that’s not showing up in the Income & GST Statement 
> (i.e., invoice id = 000361). And I can’t find out why.
> 
> This invoice was opened on 2-JAN-2020, posted on 6-JAN-2020 and paid on 
> 2-JAN-2020. I tried unposting and changing all dates to 2-JAN-2020 and it 
> still doesn’t show up on the report.
> 
> When I run the Income & GST Statement report for the previous quarter, this 
> invoice isn’t there either.
> 
> Can someone please help since my GST tax payment is due in the coming week?
> 
> This invoice is no different from any other invoice in the period and I have 
> confirmed that it is still marked active.
> 
> Cheers.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> 
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists 
>  for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Missing invoice on Income & GST Statement Report

[pobox . deva]

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 that’s not showing up in the Income & GST Statement (i.e., 
invoice id = 000361). And I can’t find out why.

This invoice was opened on 2-JAN-2020, posted on 6-JAN-2020 and paid on 
2-JAN-2020. I tried unposting and changing all dates to 2-JAN-2020 and it still 
doesn’t show up on the report.

When I run the Income & GST Statement report for the previous quarter, this 
invoice isn’t there either.

Can someone please help since my GST tax payment is due in the coming week?

This invoice is no different from any other invoice in the period and I have 
confirmed that it is still marked active.

Cheers.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Accelerator Key for Jump button

[Deva -]

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 exact location of the 
alternate file. If you edit that file, all will be well. I have CMD-J setup to 
do Jump action as well.

If something is still amiss, you can search this list archive for the same 
query posted by me and responded to by John Ralls (among others).

Cheers.
-
From: Michael Hendry 
To: Gnucash Users 
Subject: [GNC] Accelerator Key for Jump button
Message-ID: <6d5a65f2-c1ac-4659-9365-e8c40ec0d...@gmail.com>
Content-Type: text/plain;   charset=utf-8

A recent thread drew my attention to the Jump button, which I hadn?t previously 
used, and I realise I?ve been doing things the hard way!

I?m using version 3.5 on iMac macOS High Sierra 10.13.6, and have been trying 
in vain to set up Cmd-J as an accelerator key for Jump.

I found /Applications/Gnucash 
3.5.App/Contents/Resources/share/gnucash/ui/osx_accel_map and altered the 
JumpTransactionAction as follows:

?
; (gtk_accel_path 
"/gnc-plugin-business-actions/EmployeeFindEmployeeOpenAction" "")
; (gtk_accel_path 
"/GncPluginPageRegisterActions/JumpTransactionAction" "")
(gtk_accel_path "/GncPluginPageRegisterActions/PasteTransactionAction" 
"v")
; (gtk_accel_path 
"/gnc-plugin-business-actions/BusinessTestInitDataAction" ??)
?

?
; (gtk_accel_path 
"/gnc-plugin-business-actions/EmployeeFindEmployeeOpenAction" "")
(gtk_accel_path "/GncPluginPageRegisterActions/JumpTransactionAction? 
?j")
(gtk_accel_path "/GncPluginPageRegisterActions/PasteTransactionAction" 
"v")
; (gtk_accel_path 
"/gnc-plugin-business-actions/BusinessTestInitDataAction" ?")
?

but this did not do what I hoped.

Professor Google hasn?t been able to provide a solution, so I thought it best 
to seek expert advice before I break something.

Regards,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Error Retrieving Quotes

[Deva -]

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 (you 
have to put this edited file at the location where Finance Quote is installed 
on your computer).

If you are using Gnucash to track stocks, you are probably not a day trader 
because only in that case, you may need frequent price updates.

If you are using Gnucash for tracking stocks over longer periods, then you are 
unlikely to need price updates on a daily or weekly basis (I do a monthly 
update).

You can simply use the CSV Price Importer (if you are using 3.x versions and it 
works very well) and once a month import the CSV price file for all your 
stocks. If you fix the format of the CSV file, you can even save the price 
import as a template so that future imports are even smoother.

Cheers.

On 28-Apr-2019, at 8:19 PM, 
gnucash-user-requ...@gnucash.org wrote:

Date: Sun, 28 Apr 2019 18:48:18 +0530
From: Sachin Danave mailto:sachin.dan...@gmail.com>>
To: gnucash-user@gnucash.org
Subject: [GNC] Error Retrieving Quotes
Message-ID:
mailto:cakn2wtwudybcmvwvdxhf0af-urjmgdwx7yvkpm05lfzyx3y...@mail.gmail.com>>
Content-Type: text/plain; charset="UTF-8"

Hi All,

Sorry to raise an old topic, but I do hope I can get some help.

I am from India and I have setup stock accounts for various stocks that I
hold and which are traded on National Stock Exchange in India. I have
installed the relevant pre-requisites including Perl on my Windows 10
machine.

In the Security Editor, I have set up a stock (e.g. HDFC Bank Limited -
HDFCBANK.NS) with the correct ticker symbol on Yahoo Finance. I used the
various Online Quotes options :
a) Single - Yahoo as JSON or Yahoo as YQL
b) Unidentified - yahoo, yahoo asia etc

When I try to Get Quotes, I get a message that there was an unidentified
error while retrieving quotes.

Does this even work for any of the stocks traded on Indian stock exchanges
? Just dont want to waste my time in something that is not available ...

Thanks in advance for your help

Best Regards

Sachin

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Modifying Balance Sheet Report

[Deva -]

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 so (and later), there was a bug 
that corrupted the average cost reporting. This has now been fixed (I am 
currently using 3.4).

Cheers.

———

Date: Fri, 5 Apr 2019 15:47:47 -0600
From: Paul Schwartz mailto:pmjs1...@gmail.com>>
To: gnucash-user@gnucash.org
Subject: [GNC] Modifying Balance Sheet Report
Message-ID:
mailto:caknqof+2tasj+vv8aywoqstru5mcz_g8xsrwlys2huaiakz...@mail.gmail.com>>
Content-Type: text/plain; charset="UTF-8"

I would like to create a Balance Sheet report that reports the value of a
stock entry as the number of shares x the cost of those shares. Anybody
have some guidance as to how to approach this?

Thanks
Paul Schwartz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Fwd: Bonus share entry

[Deva -]

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 described.

To use the stock split assistant -

- first, open the register in which bonus shares have been declared
- then click on Actions -> Stock Split, then Next
- it will automatically select the stock account you are in, so click next
- on the next screen, enter the date when bonus was issued and the no. of bonus 
shares (in your case, 16). You can change the description to Bonus instead of 
Stock Split
- on the next screen, it will ask you if there was a cash payout as well. If 
there was, enter the details here or skip. Then you are done.

This will create a split in your stock register without the imbalance issue.

You can run the Advanced Portfolio report and the balance sheet report after 
recording this split. It should show that your cost basis hasn’t changed.

Cheers.


On 06-Mar-2019, at 5:55 PM, 
mailto:gnucash-user-requ...@gnucash.org>> 
mailto:gnucash-user-requ...@gnucash.org>> 
wrote:

Date: Wed, 6 Mar 2019 22:38:26 +1030
From: Gnucash Xboxboy Mageia 
mailto:xboxboy.mageia+gnuc...@gmail.com>>
To: fred.b...@dial.pipex.com
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Fwd: Bonus share entry
Message-ID:
mailto:cakfyohr_stteywc20f2p5jmugp6ulvnyzniz20zoj6dqons...@mail.gmail.com>>
Content-Type: text/plain; charset="utf-8"

On Wed, Mar 6, 2019 at 10:22 PM Fred Bone 
mailto:fred.b...@dial.pipex.com>> wrote:

On Wednesday, March 6, 2019 at 22:00, Gnucash Xboxboy Mageia said:

[...]
Hi Derek,

I've attached a picture, I don't think I'm explaining very well.

Please see attached.

What can I do about that imbalance line?

Delete it, and delete the price and value on the "buy" split.


Fred,
I think I've done as you say, but it continues to place 1 in the line below?

I've attached an updated pic
-- next part --
A non-text attachment was scrubbed...
Name: Screenshot_20190306_223604.png
Type: image/png
Size: 28399 bytes
Desc: not available
URL: 


--

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to handle bounced check

[Deva -]

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 cleared.

FYI - credit note is on the same window as invoice creation - whenever you 
click on new invoice, the window that pops up has an option for you to specify 
whether it’s a new invoice or a new credit note (it defaults to new invoice).

Cheers.

On 02-Feb-2019, at 5:03 PM, 
mailto:gnucash-user-requ...@gnucash.org>> 
mailto:gnucash-user-requ...@gnucash.org>> 
wrote:

Date: Fri, 1 Feb 2019 23:24:22 -0500
From: Mike Alexander mailto:m...@umich.edu>>
To: gnucash-user mailto:gnucash-user@gnucash.org>>
Subject: [GNC] How to handle bounced check
Message-ID: 
<12325d4d-60c4-46fd-8013-c93cb9442...@umich.edu>
Content-Type: text/plain; charset=utf-8

A few weeks ago I received a check in payment for an invoice I had sent to a 
customer.  I recorded the payment and deposited the check.  A couple of weeks 
later I got notice from my bank that the check had bounced.  My question is how 
to record this.  I want to ?unpay? the invoice and charge the amount back to 
the customer, but I can?t find a good way to do this.

I tried entering a transaction to debit Accounts Receivable and credit the bank 
account after which I manually added the split in A/R to the lot for that 
invoice.  This sort of worked, but the invoice is still marked paid in the 
customer report.  I can, however, select it in the ?Process Payment? dialog to 
pay it again and it shows up as unpaid in the receivables aging report.  Can I 
do better than this?

  Mike

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] accounts catergories are missing

[Deva -]

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 non-existent 
and so it showed me the Common Accounts to create my own hierarchy from 
scratch. But when I try to setup a new accounts file now, yes, I too see only 
the GST Indian Business.

I think the Common Accounts hierarchy is more useful to new users than GST 
Indian Business. The latter is only useful if you are providing services under 
GST. It will be nice to have the option of both hierarchies, so a new user can 
pick whichever (s)he wants.

Cheers.

On 02-Feb-2019, at 9:45 AM, 
gnucash-user-requ...@gnucash.org wrote:

Date: Sat, 2 Feb 2019 04:14:55 +
From: Awijeet Rishav mailto:awij...@outlook.com>>
To: "gnucash-user@gnucash.org" 
mailto:gnucash-user@gnucash.org>>
Subject: [GNC] accounts catergories are missing
Message-ID:
mailto:hk0pr04mb2788e3c68301a7d6ed5c8ce7bd...@hk0pr04mb2788.apcprd04.prod.outlook.com>>

Content-Type: text/plain; charset="iso-8859-1"

Dear Seniors,

I just installed GNUCash for my personal financial tracking, credit cards in 
particularly.

while setting up, I was not able to find any categories, other than INDIAN 
BUSINESS SETUP, have a look at  screenshot

[cid:3eca0648-8524-46a9-8178-f7e1f148912a]




please do guide me how to setup, it for personal use,

regards,
Awijeet
Bengaluru

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

No problem, Adrien. Considering you stayed with me on this topic, I can’t 
really complain.

Further to your mail below, using font-family as the keyword does work!

Now, my currency symbol also shows up!

Thank you for your support. Much appreciated.

Cheers.

On 25-Jan-2019, at 10:30 PM, 
gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org> wrote:

Date: Fri, 25 Jan 2019 07:25:01 -0600
From: Adrien Monteleone 
mailto:adrien.montele...@lusfiber.net>>
To: "gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>" 
mailto:gnucash-user@gnucash.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 change the font use this:

* { font-family: Helvetica; }

If you use what I provided earlier:

* { font: Helvetica; }

which is the shorthand property, it won?t work, you must at least specify a 
size like so:

* { font: 1em Helvetica; }

I just tested this.

Again, my apologies. If that still doesn?t work, I?m out of ideas.

Regards,
Adrien

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

Sorry Adrien, still no joy!

I was ok with changing the font on the entire invoice, so I used your first 
example.

In character viewer, I can see rupee symbol available in Helvetica font, so I 
tried using that font with and without double quote, but nothing changes.

So I tried other fonts for which rupee symbol was available (eg. Bangla MN, 
American Typewriter). No matter what I write in the embedded CSS section, 
nothing changes on the report. Not just the rupee symbol not appearing, but 
even the report font doesn’t seem to change with changes in CSS section.

But thank you for taking the time to research this.

Cheers.

On 24-Jan-2019, at 10:22 PM, 
gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org> wrote:

Date: Thu, 24 Jan 2019 07:14:14 -0600
From: Adrien Monteleone 
mailto:adrien.montele...@lusfiber.net>>
To: "gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>" 
mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] Currency symbol (INR) not showing on Tax Invoice
report
Message-ID: 
mailto:fbe20849-afd7-4085-96fd-f18190e17...@lusfiber.net>>
Content-Type: text/plain; charset=utf-8

Place the following in the Embedded CSS section of the Notes tab under the 
invoice?s options:


* {font: ?name of font"; }


This will change the font on the entire invoice. It should then render the INR 
currency symbol. If the font name has spaces, you must enclose it in ??.

If you only want to affect the header and actual invoice table (and not the 
notes section) use this:


table {font: ?name of font"; }


Note, that you can also specify a different font size, style (like bold and/or 
italics) and even color like so:


* {font: ?Arial" 1.5em bold italics; color: blue; }


(an ?em? is a relative unit for font sizes. 1 ?em? is 100% of whatever the base 
style was. Or you can use px or pt such as 16px or 16pt if you prefer.)

If you want to target only cells with currency values this *might* work:


table.entries td > nobr:first-child { font: ?name of font"; }


Also note, I don?t see a way to edit this permanently so you?d have to insert 
it for every invoice. (perhaps saving the report config and then specifying a 
different invoice number might do the trick) Otherwise, you?d have to edit 
taxinvoice.css but that will get overwritten when you update Gnucash to the 
next version.

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 using CSS styling, so 
someone with that know-how may be able to get what they want. I am ok with the 
workaround for now.

Besides, if I recall correctly, Christopher also mentioned that since Tax 
Invoice report is eguile-based, it?s unlikely to be maintained. I am not even 
sure what eguile is, but I seem to like the presentation, flexibility and 
layout of both the balance sheet and tax invoice reports. So it?s unfortunate 
that the eguile reports may be going away soon.

Cheers.

On 19-Jan-2019, at 6:38 PM, 
mailto:gnucash-user-requ...@gnucash.org><mailto:gnucash-user-requ...@gnucash.org>>
 
mailto:gnucash-user-requ...@gnucash.org><mailto:gnucash-user-requ...@gnucash.org>>
 wrote:

Date: Sat, 19 Jan 2019 06:25:38 -0600
From: Adrien Monteleone 
mailto:adrien.montele...@lusfiber.net><mailto:adrien.montele...@lusfiber.net>>
To: 
"gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org><mailto:gnucash-user@gnucash.org>"
 
mailto:gnucash-user@gnucash.org><mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] Currency symbol (INR) not showing on Tax Invoice
report
Message-ID: 
<14328ebb-6e35-4081-b534-92a928a85...@lusfiber.net<mailto:14328ebb-6e35-4081-b534-92a928a85...@lusfiber.net><mailto:14328ebb-6e35-4081-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><mailto:pobox.d...@outlook.in>>
 wrote:

Adrien,

Thanks for the pointer on how to figure the font associated with a symbol. Yes, 
I now see the names of all fonts for the various rupee symbols (including 
Helvetica).

However, when I edit the default stylesheet to use any of the the available 
rupee symbol fonts (I tried a couple of them - there were too many to try all 
of them), the tax invoice report still doesn?t show the symbol.

So for now, I am afraid I have to stick with the text version of the symbol.

Cheers.

On 18-Jan-2019, at 10:30 PM, 
gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org><mailto:gnucash-user-requ...@gnucash.org><mailt

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

[Deva -]

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 using CSS styling, so 
someone with that know-how may be able to get what they want. I am ok with the 
workaround for now.

Besides, if I recall correctly, Christopher also mentioned that since Tax 
Invoice report is eguile-based, it’s unlikely to be maintained. I am not even 
sure what eguile is, but I seem to like the presentation, flexibility and 
layout of both the balance sheet and tax invoice reports. So it’s unfortunate 
that the eguile reports may be going away soon.

Cheers.

On 19-Jan-2019, at 6:38 PM, 
mailto:gnucash-user-requ...@gnucash.org>> 
mailto:gnucash-user-requ...@gnucash.org>> 
wrote:

Date: Sat, 19 Jan 2019 06:25:38 -0600
From: Adrien Monteleone 
mailto:adrien.montele...@lusfiber.net>>
To: "gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>" 
mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] Currency symbol (INR) not showing on Tax Invoice
report
Message-ID: 
<14328ebb-6e35-4081-b534-92a928a85...@lusfiber.net<mailto:14328ebb-6e35-4081-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:

Adrien,

Thanks for the pointer on how to figure the font associated with a symbol. Yes, 
I now see the names of all fonts for the various rupee symbols (including 
Helvetica).

However, when I edit the default stylesheet to use any of the the available 
rupee symbol fonts (I tried a couple of them - there were too many to try all 
of them), the tax invoice report still doesn?t show the symbol.

So for now, I am afraid I have to stick with the text version of the symbol.

Cheers.

On 18-Jan-2019, at 10:30 PM, 
gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org><mailto:gnucash-user-requ...@gnucash.org>
 wrote:

Date: Fri, 18 Jan 2019 08:25:54 -0600
From: Adrien Monteleone 
mailto:adrien.montele...@lusfiber.net><mailto:adrien.montele...@lusfiber.net>>
To: 
"gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org><mailto:gnucash-user@gnucash.org>"
 
mailto:gnucash-user@gnucash.org><mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] Currency symbol (INR) not showing on Tax Invoice
report
Message-ID: 
mailto:b2a1446e-3d35-4cde-acde-6bd5ce65f...@lusfiber.net><mailto:b2a1446e-3d35-4cde-acde-6bd5ce65f...@lusfiber.net>>
Content-Type: text/plain; charset=utf-8

In Character Viewer, look up the rupee symbol via a search. Click the glyph for 
it in the middle pane. You?ll then see a list of font variations on the bottom 
right. 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><mailto:pobox.d...@outlook.in>>
 wrote:

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 a number of 
variations of the rupee symbol available, but I can?t figure out which font is 
used on each of those variations. So for the time being I have changed the 
symbol to text (INR) in the currency editor.

Cheers.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

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,
>> 
>> Thanks for the pointer on how to figure the font associated with a symbol.
>> Yes, I now see the names of all fonts for the various rupee symbols
>> (including Helvetica).
> 
>> However, when I edit the default stylesheet to use any of the the available
>> rupee symbol fonts (I tried a couple of them - there were too many to try
>> all of them), the tax invoice report still doesn’t show the symbol.
> 
>> So for now, I am afraid I have to stick with the text version of the
>> symbol.
> 
> Allow me to point out that the tax invoice is not affected by changes in the 
> default style sheet at all as far as I know.
> 
> It uses css styling, not the stylesheet editor built-in into gnucash. So to 
> test changes of font you will have to add a font property to the css for that 
> report. The easiest way is as Adrien suggested in an earlier reply via the 
> report's option dialog. On the Notes tab you can add custom css snippets.
> 
> I don't know off-hand what an appropriate snippet would look like in this 
> particular case. Perhaps someone else could provide that.
> 
> Regards,
> 
> Geert
> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

Adrien,

Thanks for the pointer on how to figure the font associated with a symbol. Yes, 
I now see the names of all fonts for the various rupee symbols (including 
Helvetica).

However, when I edit the default stylesheet to use any of the the available 
rupee symbol fonts (I tried a couple of them - there were too many to try all 
of them), the tax invoice report still doesn’t show the symbol.

So for now, I am afraid I have to stick with the text version of the symbol.

Cheers.

On 18-Jan-2019, at 10:30 PM, 
gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org> wrote:

Date: Fri, 18 Jan 2019 08:25:54 -0600
From: Adrien Monteleone 
mailto:adrien.montele...@lusfiber.net>>
To: "gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>" 
mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] Currency symbol (INR) not showing on Tax Invoice
report
Message-ID: 
mailto:b2a1446e-3d35-4cde-acde-6bd5ce65f...@lusfiber.net>>
Content-Type: text/plain; charset=utf-8

In Character Viewer, look up the rupee symbol via a search. Click the glyph for 
it in the middle pane. You?ll then see a list of font variations on the bottom 
right. 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 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 a number of 
variations of the rupee symbol available, but I can?t figure out which font is 
used on each of those variations. So for the time being I have changed the 
symbol to text (INR) in the currency editor.

Cheers.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

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 a number of 
variations of the rupee symbol available, but I can’t figure out which font is 
used on each of those variations. So for the time being I have changed the 
symbol to text (INR) in the currency editor.

Cheers.

> On 18-Jan-2019, at 4:21 PM, Geert Janssens  wrote:
> 
> Op donderdag 17 januari 2019 15:49:26 CET schreef David T. via gnucash-user:
>> Not that I am an expert on these issues, but your observation suggests that
>> the font that the Tax Invoice uses lacks a valid INR symbol. I believe
>> there are style sheets for that report which can be used to change the font
>> and remedy the problem (provided the newly-selected font has a Rupee
>> symbol).
> The other possible issue is that the eguile  based reports (like the Tax 
> Invoice one) may not be handling non-ascii characters properly.
> 
> That would be a problem with the code and not something the end user could 
> remedy unfortunately.
> 
> Regards,
> 
> Geert
> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

Thanks Christopher.

Went back and tried the Printable/Easy/Fancy invoice reports and the currency 
symbol shows up fine on those reports. So it’s only the Tax Invoice report that 
has a problem.

My preference still remains the Tax Invoice report because it allows me to 
change column headings. For instance, I have renamed the column header for 
“Action” on my report to “SAC” because this is the place I capture the GST 
related code that’s mandatory in our invoice. Since Printable/Easy/Fancy 
invoices don’t allow me change column headers, I have to use Tax Invoice for 
now.

However, following up on the wiki links in Frank’s mail further, I overlooked 
an aspect in the second wiki, where it says I can set the currency symbol to 
any text I want in the security/currency editor. So I went into that currency 
editor and changed the rupee symbol to just text - INR. Now instead of the 
symbol, it shows the text INR for all amounts on the invoice. I can work with 
this for now, but the problem remains a puzzle.

Only flip side is, now even my account tree page shows INR instead of the rupee 
symbol and takes up more column space. I kinda liked the symbol display, but 
alas we live to fight the battle another day!

Thank you all for your help. Much appreciated.

Cheers.

On 16-Jan-2019, at 8:22 PM, Christopher Lam 
mailto:christopher@gmail.com>> wrote:


This seems to be the eguile-based "tax invoice" report.

Perhaps you can try the other "Printable/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, Deva - wrote:

Hello,

I am on GnuCash 3.4, Mac OS 10.13.6 (High Sierra).

Please see attached for a sample invoice I generate out of GnuCash based on the 
Tax Invoice report (sensitive data has been masked). Today was the first time I 
tried to run this report from GnuCash 3.4 and I noticed that the INR 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




___
gnucash-user mailing list
gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

Thank you for your response, Frank.

When I look at the “Default” stylesheet, Arial is the default font. When I look 
at the Character Viewer on my Mac, I can see that the INR (rupee) symbol is 
available, though I couldn’t figure out what font that is.

This was not a problem until 3.3, so I am not sure how to fix this in 3.4.

I tried changing the default stylesheet’s font to Helvetica/MS Sans Serif, but 
it still doesn’t show the report with proper symbol for INR.

Following your other wiki instructions, I then looked at Tools->Security Editor 
to check if the currency symbol is there and everything looks ok on that screen 
(see attached screenshot). I can see the currency editor shows the proper 
symbol for INR (rupee).

Also note that this is only a problem in reports. The currency symbol is 
showing fine on the main account tree page.

Please let me know if there’s anything else 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 attached for a sample invoice I generate out of GnuCash based on the 
Tax Invoice report (sensitive data has been masked). Today was the first time I 
tried to run this report from GnuCash 3.4 and I noticed that the INR currency 
symbol is showing up as a missing symbol icon.

Any suggestions on how to fix this?

You need (to install and) use a font, wich contains the symbol. See
https://wiki.gnucash.org/wiki/FAQ#Q:_How_get_I_rid_of_strange_unreadable_characters_or_adjust_the_font_size

I tried turning off the display of currency symbol in the report via 
Edit->Report Options, but didn’t see anything to that effect.

At least you should be able to use something else, see
https://wiki.gnucash.org/wiki/FAQ#Q:_I_dislike_some_of_the_new_currency_symbols_of_GnuCash_2.6

Cheers,
Deva

Cheers
Frank


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

Hello,

I am on GnuCash 3.4, Mac OS 10.13.6 (High Sierra).

Please see attached for a sample invoice I generate out of GnuCash based on the 
Tax Invoice report (sensitive data has been masked). Today was the first time I 
tried to run this report from GnuCash 3.4 and I noticed that the INR 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-000267-01_15_2019.pdf
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

Noted. That explains my musings on period column numbers for some of the 
accounts.

Thanks for the clarification.

Cheers.

On 13-Oct-2018, at 8:20 PM, 
gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org> wrote:

Date: Sat, 13 Oct 2018 21:41:57 +0800
From: Christopher Lam 
mailto:christopher@gmail.com>>
Cc: GnuCash users group 
mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] Feedback: Balance Sheet (Multi-Column) / Income
Statement (Multi-Column)
Message-ID:
mailto:CAKVAZZ+nuEuD=c1brtwghcqyqby1vodbrfhbbxfihftnveu...@mail.gmail.com>>
Content-Type: text/plain; charset="UTF-8"

You're welcome.
As a side note about this "Average" - this is not strictly a 'monthly'
average as such... instead, it's a 'column' average.
This only matters if, e.g. your secondary-key is 'date', secondary subtotal
is 'monthly', and expect Jan-Dec transactions.
If there is 1 month missing i.e. transactions on every month except in
November, then the subtotal-table will have 11 columns, and the average
will be (Jan->Dec total) / 11.
This is a limitation of the averaging function which divides total by
number of columns, and is rather 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 columns is slightly different from what I had in mind, but this
version of the report should give me what I am looking for, with a little
adjustment in thought process.

Cheers.

On 12-Oct-2018, at 8:46 PM, 
gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org>mailto:gnucash-user-requ...@gnucash.org>> 
wrote:

Date: Fri, 12 Oct 2018 22:04:40 +0800
From: Christopher Lam 
mailto:christopher@gmail.com>mailto:christopher@gmail.com>>>
To: 
gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org><mailto:gnucash-user@gnucash.org>
Subject: Re: [GNC] Feedback: Balance Sheet (Multi-Column) / Income
Statement (Multi-Column)
Message-ID: 
mailto:b95c4659-4f44-f176-a85f-ab3bdca17...@gmail.com>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 in the Transaction Report. Select
either Asset/Liability accounts, or Income/Expense accounts, (or both).
>From sorting tab, select Primary-Key = account-name, Secondary-Key =
date, secondary-subtotal = month, Display / Subtotal table = enabled.

You'll find monthly subtotals per account in the subtotal table.

~C



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

Thank you!

That is an interesting use of Transaction report. Interpretation of the period 
columns is slightly different from what I had in mind, but this version of the 
report should give me what I am looking for, with a little adjustment in 
thought process.

Cheers.

On 12-Oct-2018, at 8:46 PM, 
gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org> wrote:

Date: Fri, 12 Oct 2018 22:04:40 +0800
From: Christopher Lam 
mailto:christopher@gmail.com>>
To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
Subject: Re: [GNC] Feedback: Balance Sheet (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 in the Transaction Report. Select
either Asset/Liability accounts, or Income/Expense accounts, (or both).
>From sorting tab, select Primary-Key = account-name, Secondary-Key =
date, secondary-subtotal = month, Display / Subtotal table = enabled.

You'll find monthly subtotals per account in the subtotal table.

~C

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

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 
are coming in handy because that’s just the information I need to help with 
tracking his assets/expenses, month after month.

Comments

Both reports have a check box for “Enable charts” in the report options dialog. 
I’m guessing this is work in progress because I don’t see any charting when 
this option is enabled.

Income Statement has a nice option wherein I can ask for “Period Totals” as a 
summary column at the end. I know “Period Totals” doesn’t make sense for the 
balance sheet version, but I was wondering if you can show “Period Average” 
instead, in the balance sheet report. While I can see how my son's financial 
standing is changing by looking at his assets month after month, it will be 
nice to know what is needed on a monthly average basis, so I can plan for next 
year’s funding accordingly. It will also help me analyse which month’s he is 
going over/under average.

Otherwise, the reports look pretty good. Thanks for sharing.

Cheers.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

John,

Thanks for fixing the issue on average cost basis in release 3.3. I can now 
confirm that 3.3 reports balance sheet numbers correctly and my imbalance only 
shows 0.20 over 18 years of data (instead of 100’s of thousands before).

With this fix and the CSV price importer feature, I have 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.6.6 and just in the last 2 days, I 
upgraded to the latest version 2.6.19.

After running a preliminary test of some of the reports I use for tax reporting 
purposes, I noticed that the cost basis on one of my mutual funds has changed 
significantly (see attached screenshot for the transactions on that mutual fund 
account).

Some history on this fund. It used to be called Fidelity Flexi Gilt Fund and I 
had invested INR 850,000 and accumulated 70,362.427 shares as of 16-Nov-12. But 
on 23-Nov-2012, Fidelity sold its mutual fund business in India to L Mutual 
Fund and the latter decided to merge Fidelity’s gilt fund into its own - now 
called L Gilt Fund.

When this merger happened, I simply used the stock split assistant to reduce 
the no. of shares by 34,769.081 based on the account statement sent by L

As of 2.6.6, the (average) cost basis on the balance sheet report correctly 
showed INR 850,000 even after the “stock split” transaction. But in the latest 
version 2.6.19, the balance sheet report shows the same cost basis as 
429,978.69. I think it has reduced the cost basis by the cost of the shares 
reduced from the merger i.e., 34,769.081 shares.

This is causing such differences to show up as imbalance in my reports!

Has the computation of cost basis changed between these versions? If so, how 
should I go about accounting for cases such as above to maintain proper cost 
basis?

Odd thing though is that I have a no. of stocks that declared a stock split, 
but in those cases, the cost basis is correctly maintained even after the 
split. This behaviour is only seen in mutual fund shares (as far as I can tell).

I rely on GnuCash reports for my annual tax reporting, so it’s important that 
the reports I generate have a proper explanation for the numbers shown.

Thanks in advance for your time.

Yes, the calculation of average cost changed in 2.6.12 to fix a bug, but that 
opened another can of worms, see 
https://bugzilla.gnome.org/show_bug.cgi?id=775368. I intend to have a solution 
for 3.0 and if you can add the details of your use-case to the bug that will 
help.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GC 3.2 Import Price File CSV

[Deva -]

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 
problem. Once he fixed that, everything worked ok. He posted his solution on 
this list as well.

Thanks for the follow up.

Cheers.

On 29-Aug-2018, at 4:06 PM, Geert Janssens 
mailto:geert.gnuc...@kobaltwit.be>> wrote:

megagru...@hotmail.com

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GC 3.2 Import Price File CSV

[Deva -]

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 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] GC 3.2 Import Price File CSV
Message-ID: 
<1535093332487-0.p...@n4.nabble.com>
Content-Type: text/plain; charset=us-ascii

There are no spaces in the stock definition. Also in answer to your question
about the date format. I have tried all the date formats and I never get a
failure to read the date correctly. When I import data in quicken format
from my bank it tends to be in M-D-Y format for some reason.

I have also followed your advice and generated a completely new GC file with
only one stock in it. I have put in ABF under Eurex as the default format
only shows Amex, Eurex, Nasdaq and NYSE as options for the "Type" of stock.
(My stocks are all LSE so I had added LSE as an additional type in my
definitions and thought that maybe that was causing the problem). I get
exactly the same problem with the message "Commodity From could not be
understood. Value can't be parsed into valid commodity."




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GC 3.2 Import Price File CSV

[Deva -]

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, 
gnucash-user-requ...@gnucash.org wrote:

Date: Tue, 21 Aug 2018 01:28:54 -0500 (CDT)
From: Megagrumpy mailto:megagru...@hotmail.com>>
To: gnucash-user@gnucash.org
Subject: Re: [GNC] GC 3.2 Import Price File CSV
Message-ID: 
<1534832934531-0.p...@n4.nabble.com>
Content-Type: text/plain; charset=us-ascii

I have checked the CSV file and there are no spaces. I tried initially to
import a number of shares and none or them were recognised by the import
tool. It must be a fault in my security definitions I think. When F::Q was
working it would import the prices from Alphavantage so it was happy with
the security definition but maybe the CSV import tool is looking for a
specific structure in the database. I have defined all my shares in a
subcategory "LSE" and I cannot remember if this was a Gnucash structure or
one I made myself. See Screen shot:







___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GC 3.2 Import Price File CSV

[Deva -]

Hmmm… Other than what Sebastien suggested, one other thing I can think of is to 
delete the commodity in your gnucash datafile and recreate it.

Perhaps you can try what I did. Just create a new blank datafile and setup this 
single security of ABF.L for testing. You don’t need any accounts as such. Then 
import and see what happens. If that works, then something in your main 
datafile is inconsistent with the import definition.

Do you have multiple definitions of accounts using ABF.L security or multiple 
definitions of ABF.L itself setup in different namespaces (perhaps for 
different brokerage accounts)? Not sure why that would cause a problem, but if 
the test datafile with a single definition works, then that might be an area to 
look at.

Since you are using m-d-y for dates, is your locale still UK or some other? 
Reason I ask is because your security currency is GBP, but if your locale is 
set to imply some other, then that might be causing a problem.

Sorry, grasping at straws here! Wish I could be of better help…

Cheers.

On 18-Aug-2018, at 8:04 PM, 
gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org> wrote:

Date: Sat, 18 Aug 2018 10:35:02 +0200
From: S?bastien de Menten mailto:sdemen...@gmail.com>>
To: Megagrumpy mailto:megagru...@hotmail.com>>
Cc: Gnucash userlist mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] GC 3.2 Import Price File CSV
Message-ID:
mailto:cab2pxduxsxxjp71wkfbqownbagw_wqsldz24ssj32m3prhx...@mail.gmail.com>>
Content-Type: text/plain; charset="UTF-8"

Would it be possible you have a blank as first character in your security
editor (i.e. " ABF.L")? The screenshot you sent give me this impression...
But it may be just a visual artifact.

On Sat, Aug 18, 2018, 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 would have had an error.  I have followed your instructions to the letter
and still I get the message "Commodity From could not be understood"! In
this case I have used the MDY date format. my input file reads:
ABF.L,08/12/2018,25,GBP

My commodity in the security editor is defined as ABF.L - see Scrrebshot:
<http://gnucash.1415818.n4.nabble.com/file/t377722/ABF_Security_Editor.jpg>


I still get the same error and it is only that the security ABF.L cannot be
recognised - see Screenshot:

<
http://gnucash.1415818.n4.nabble.com/file/t377722/ABF_error_screenshot.jpg>


As you can see the date and all the other fields are OK and parse
successfully. Only the Stock ID is rejected.





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GC 3.2 Import Price File CSV

[Deva -]

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. 
Change the CSV file to ABF.L (I know you said you tried this before and it 
still didn’t work, but we are not done yet).

Next, change the date format on the import screen from m-d-y to d-m-y. Now you 
will see your CSV price data being accepted. Click Next and Apply to import the 
price.

Of course, the question remains as to why the date format needs to change 
because the date 12/08/2018 should have been understood as 12-Aug (if the 
format was taken as d-m-y) and as 8-Dec (if the format was taken as m-d-y). 
From your stock and currency, I am guessing the date you intended was 12-Aug, 
so change the date format to match the data.

Hope this helps.

Cheers.

On 15-Aug-2018, at 9:29 PM, 
mailto:gnucash-user-requ...@gnucash.org>> 
mailto:gnucash-user-requ...@gnucash.org>> 
wrote:

Message: 1
Date: Tue, 14 Aug 2018 01:21:51 -0500 (CDT)
From: Megagrumpy mailto:megagru...@hotmail.com>>
To: gnucash-user@gnucash.org
Subject: Re: [GNC] GC 3.2 Import Price File CSV
Message-ID: 
<1534227711704-0.p...@n4.nabble.com>
Content-Type: text/plain; charset=us-ascii

I will try to show my problem with screenshots  - hopefully it will work but
never tried this before.

This is my entry in the database:


This is the single line in my CSV vile:
ABF,12/08/2018,25,GBP

And this is my import form:









___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GC 3.2 Import Price File CSV

[Deva -]

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 further.

Things to check -

a. your date formats (though this is less likely to be your problem)
b. are your stock ids enclosed in quotes? If so, either change the import 
setting to imply that or remove enclosed quotes from the file
c. In the small grid shown in the import window, are all your fields correctly 
divided into columns? If not, there may be a delimiter problem

Cheers.

On 14-Aug-2018, at 11:31 AM, 
mailto:gnucash-user-requ...@gnucash.org>> 
mailto:gnucash-user-requ...@gnucash.org>> 
wrote:


Message: 8
Date: Mon, 13 Aug 2018 03:59:24 -0500 (CDT)
From: Megagrumpy mailto:megagru...@hotmail.com>>
To: gnucash-user@gnucash.org
Subject: Re: [GNC] GC 3.2 Import Price File CSV
Message-ID: 
<1534150764820-0.p...@n4.nabble.com>
Content-Type: text/plain; charset=us-ascii

I was specifically referring to the the CSV price import tool in Version 3.2.
I am trying to import the stock prices using this tool. Cannot get the Share
ID to be recognised whatever I do.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html


--

Message: 9
Date: Mon, 13 Aug 2018 07:49:19 -0500 (CDT)
From: Megagrumpy mailto:megagru...@hotmail.com>>
To: gnucash-user@gnucash.org
Subject: Re: [GNC] GC 3.2 Import Price File CSV
Message-ID: 
<1534164559579-0.p...@n4.nabble.com>
Content-Type: text/plain; charset=us-ascii

That is what I have done. I am testing now with only one commodity -
Associated British Food. I have the id set in the security editor as ABF.L.
I have tried setting this on the CSV file to ABF.L. I have also tried ABF.
Still get the message "Commodity From could not be recognised". I have
changed the ID in the security editor to both ABF.L and ABF and still get
the same error message.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Getting CAGR for stocks/accounts

[Deva -]

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 
setup your dividend payouts. If you follow the instructions in the Tutorial and 
Concepts Guide, dividends do show up in Advanced Portfolio report under the 
Income column. In fact, the Total Return is a sum of capital gains and 
dividends.

Go through the online document - perhaps try it for just 1 security - and see 
how your report changes.

Cheers.

On 11-Aug-2018, at 8:18 PM, 
mailto:gnucash-user-requ...@gnucash.org>> 
mailto:gnucash-user-requ...@gnucash.org>> 
wrote:

Message: 9
Date: Sat, 11 Aug 2018 02:16:54 -0500 (CDT)
From: Megagrumpy mailto:megagru...@hotmail.com>>
To: gnucash-user@gnucash.org
Subject: [GNC] Getting CAGR for stocks/accounts
Message-ID: 
<1533971814285-0.p...@n4.nabble.com>
Content-Type: text/plain; charset=us-ascii

I have been trying to find a way to be able to get a true performance of
investments which I think is best shown by calculating the CAGR over the
life of that investment. The Advanced Portfolio report gives the overall
increase as a percentage but this is meaningless if comparing investments
with differing purchase dates or where there have been significant dividends
over time or reinvestments. I currently download the information into a
spreadsheet and have a separate calculation where I calculate the CAGR -
unfortunately I have to add dividends etc manually for each share which
takes a long time! is there any way in GC to be able to calculate this?

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Error in Finance:Quote

[Deva -]

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 finalised, then you can even 
save your import settings, so next time, you will have less options to tweak.

All that the CSV price importer needs is as follows -

Date,Price/NAV,Commodity,Currency

Commodity is the mutual fund code or whatever is the security code you setup in 
the security editor. Currency, in our case, is INR.

Only observation is that all uploaded prices have the “type” set to “last”. 
Mutual funds don’t have “last”, so I go in and update them to “NAV” instead. If 
you are not too finicky, you can leave them as is - it’s only for informational 
purposes.

Cheers.

On 11-Aug-2018, at 8:18 PM, 
mailto:gnucash-user-requ...@gnucash.org>> 
mailto:gnucash-user-requ...@gnucash.org>> 
wrote:

Message: 3
Date: Fri, 10 Aug 2018 11:16:43 -0500 (CDT)
From: Shokster mailto:ashok.si...@gmail.com>>
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Error in Finance:Quote
Message-ID: 
<1533917803525-0.p...@n4.nabble.com>
Content-Type: text/plain; charset=us-ascii

Hi all, sorry if this is not the right place (if so, please advise) for this
post.

I'm having a hard time trying to get GnuCash to 'Get Quotes'. It throws an
error saying 'Unable to retrieve quotes for these items: Currency:INR
Continue using only the good quotes? Yes/No'.

I've got just the 1 security for now. It's a mutual fund code 101143 at
https://www.amfiindia.com/spages/NAVAll.txt

Seems like it's setup ok on Security editor.


So, I've had a crash course into running perl modules, and ran (from a
run.bat file):

perl "C:\Program Files (x86)\gnucash\bin\gnc-fq-dump" indiamutual 125112
pause

This works as:


But I can't figure out why the 'Get Quote' via GnuCash won't work! :(

From reading around, there seems to be a major shift (to Alpha Vantage) that
shouldn't be relevant to this case?

Currently, I work with Excel, and will port my accounts to GnuCash if the
price editor can import mutual fund NAV's.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Frequency of 28 Days

[Deva -]

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
- Here, you can choose frequency as “daily” and set the field “Every…days” tp 28

If you want to schedule a transaction without ever having entered one, you can 
go to Actions->Scheduled Transaction Editor, then on the ST editor tab that 
opens, you can click on menu option - Schedule->Add…

These dialogs and workflow are on Mac OS, GC 3.2. Other OS should be similar.

Cheers.

On 02-Aug-2018, at 9:30 PM, 
mailto:gnucash-user-requ...@gnucash.org>> 
mailto:gnucash-user-requ...@gnucash.org>> 
wrote:


Message: 6
Date: Thu, 2 Aug 2018 10:41:08 -0500 (CDT)
From: adb34 mailto:ad...@rocketmail.com>>
To: gnucash-user@gnucash.org
Subject: [GNC] Frequency of 28 Days
Message-ID: 
<1533224468172-0.p...@n4.nabble.com>
Content-Type: text/plain; charset=us-ascii

I am using this for home use. I get some of my payments every 28 days. Can
anybody give me any pointers on how I can do the 28 day pay-in?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

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
> 
> Linux Mint 19 is called Tara and is based on Ubuntu 18.04. 
> Linux Mint 18.2 is called Sonya and is based on Ubuntu 16.04
> The flatpak version is available in both from the Software manager.
> 
> The flatpak version is fine as long as you don't want any of the
> optional GnuCashfeatures like
> aqbanking
> sql backends etc
> as they do not have these options included in the build. It however
> does have any bugs recorded for GnuCash v3.2 so far.
> 
> There is an issue to this effect registered with the flatpak package
> maintainer on Github but so far no response.
> 
> David Cousens
> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

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. Click on Flatpack (or perhaps called Flathub) 
when inside the Software Manager and search for GnuCash and you will find one 
packaged. It doesn’t show version info, but when I installed it and ran 
GnuCash, I found out that it is indeed the latest version.

if you are new to GnuCash, be sure to read the Tutorial & Concepts Guide - an 
outstandingly well written document! It helped me get over my fear of 
accounting terminology and accounting in general. All I did was spend half a 
day with it!

Have fun!

Cheers.

On 28-Jul-2018, at 12:35 PM, 
mailto:gnucash-user-requ...@gnucash.org>> 
mailto:gnucash-user-requ...@gnucash.org>> 
wrote:

--

Message: 1
Date: Sat, 28 Jul 2018 01:11:08 -0500 (CDT)
From: "Shabuboy.joy" mailto:shabu...@hotmail.com>>
To: gnucash-user@gnucash.org
Subject: [GNC] Linux Mint 18.2 Sonya and Gnucash 3.2
Message-ID: 
<1532758268668-0.p...@n4.nabble.com>
Content-Type: text/plain; charset=us-ascii

Hello,

I just migrated from Quicken to Gnucash. Loving it so far!

The question i have is: Will Gnucash 3.2 be available for Linux Mint 18.2?
The software manager installed 2.6.12
i did the apt update and upgrade and still same version is listed.

i also tried the getweb but got the same version, at least it told me the
same version was installed already.

I see the new version can be built from the source, but I am far from being
a Linux expert and never done that before.

I also have a MacOS running the 3.2 version, so wanted to match both version
on both systems in order to avoid possible bugs between the different
releases.

Regards

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] consolidate transactions report

[Deva -]

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 config.user, but now it’s called config-user.scm (thanks 
to the wiki on custom report info). Once I copied your config file entries to 
the new config file, it shows up and runs fine.

Cheers.

On 05-Jun-2018, at 9:30 PM, 
mailto:gnucash-user-requ...@gnucash.org>> 
mailto:gnucash-user-requ...@gnucash.org>> 
wrote:

From: Cindy Doughty mailto:dbdoug...@gmail.com>
   >
   Date: Sun, Jun 3, 2018 at 6:46 PM
   Subject: consolidate transactions report
   To: gnucash-user 
mailto:gnucash-user@gnucash.org>
   >
   Cc: gnucash-de...@gnucash.org 



   Attached is an updated version of the transaction report I
   published last
   year

   ...
   for linux and os see the following from the wiki - note you
   want the right
   hand column:

   Operating SystemUser Config Directory (2.6 and older)User
   Config Directory
   (3 and newer)
   *Linux/Unix* /home/YourName/.gnucash
   /home/YourName/.config/gnucash...
   -- next part --
   A non-text attachment was scrubbed...
   Name: config-user.scm
   Type: application/octet-stream
   Size: 296 bytes
   Desc: not available
   URL:
   
>
   -- next part --
   A non-text attachment was scrubbed...
   Name: consolidate-transactions.scm
   Type: application/octet-stream
   Size: 187996 bytes
   Desc: not available
   URL:
   
>
   -- next part --
   A non-text attachment was scrubbed...
   Name: gnctimeperiod-utilities.scm
   Type: application/octet-stream
   Size: 65612 bytes
   Desc: not available
   URL:
   
>


   ___
   gnucash-user mailing list
   gnucash-user@gnucash.org 

   To update your subscription preferences or to unsubscribe:
   https://lists.gnucash.org/mailman/listinfo/gnucash-user
   
   If you are using Nabble or Gmane, please see
   https://wiki.gnucash.org/wiki/Mailing_Lists
    for more information.
   -
   Please remember to CC this list on all your replies.
   You can do this by using Reply-T

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Deva -]

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 discount column names to “Adjustment”. It would be nice to be able 
to hide those columns through option settings, so no one needs to see these 
adjustments…

On some occasions, you may end up with a final total that is less than the 
amount received (in your case, say it shows 418.09). In that case, you would 
simply make the discount as -0.01.

Not a pretty solution, but I get by with these adjustments.

Cheers.

On 23-May-2018, at 4:47 PM, 
> 
> 
wrote:

Date: Tue, 22 May 2018 21:11:26 -0400
From: Matthew Pounsett >
To: Gnucash Users >
Subject: [GNC] Invoice tax rouding issue in 2.x
Message-ID:
>
Content-Type: text/plain; charset="UTF-8"

I've got an off-by-a-cent error on an invoice due to the way taxes are
calculated.  GnuCash (2.6.21) is calculating the tax on each individual
taxable item, then summing that up, and adding that value to the subtotal.
This causes an error because each individual tax calculation is rounded
prior to subtotalling.

Given a tax rate of 13%, GnuCash is doing this:

   Item Tax
 277.50   36.08
  92.50   12.03
Subtotal: 370.00 + 48.11 = 418.11

When the real calculation should be:

   Item  Tax
 277.50   36.075
  92.50   12.025
Subtotal: 370.00 + 48.100 = 418.10

This could be fixed by GnuCash not rounding tax amounts until the final
total, but typically I believe the calculation done is to add up all the
taxable items and apply the tax calculation to that subtotal, so that it's
not necessary to track many decimal places to avoid a rounding error.

I did some searching through the mailing lists and I see a lot of reported
issues about rounding errors in GnuCash 2.x.  I can work around this by
putting in an extra line item to correct the taxes, but it would be nice
not to have to do that.  Is this something that's been fixed in 3.x?  I've
been avoiding the update because I haven't had time for a careful
migration, and testing whether I'm affected by any of the various issues
that have been reported since its release.  But, this might be a reason to
set that time aside.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GnuCash 3.0 initial observations

[Deva -]

Christopher,

I think the list converts any attachments into links at the end of the mail - 
at least, that’s how I have been looking at others attachments. Anyway, Adrien 
helped with some answers, so I’m good.

It’s unfortunate that eguile balance sheet is going to see its demise soon - a 
veritable case of chronicle of a death foretold! Though I take your point about 
regular balance sheet showing unrealised gains, I liked the eguile version 
because it kept the income and expense detail at account level instead of 
grouping them into a single line item called Retained Earnings.

The eguile format helped answer questions, both financial and philosophical, 
such as -

a. what is my contribution to my family?
b. what is my contribution to society (gifts/charitable contributions made)?
c. what have I received from society (gifts received)?
d. and more philosophically, what is the value of my life?

Having maintained nearly 2 decades of my life in numbers and with no intention 
of backing out now, I hope to find the answer to that last ponderance, at least 
as a financial metric, before my time is done.

Bob Dylan said it best when he sang -

how many roads must a man walk down
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, 
<gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org>> 
<gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org>> 
wrote:

Date: Thu, 5 Apr 2018 18:38:13 +0400
From: Christopher Lam 
<christopher@gmail.com<mailto:christopher@gmail.com>>
To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
Subject: Re: GnuCash 3.0 initial observations
Message-ID: 
<2ba7cda3-a5eb-4e43-96fd-9577d03d8...@gmail.com<mailto:2ba7cda3-a5eb-4e43-96fd-9577d03d8...@gmail.com>>
Content-Type: text/plain; charset=utf-8; format=flowed

Hi Deva

First you forgot to attach screenshots.

I'll assist where I can:

On 05/04/18 16:43, Deva - wrote:
Hello,

Firstly, thank you all for this new and much awaited version.

I have just installed GC 3.0 on Mac OS High Sierra 10.13.4 and have been 
browsing through what?s new and what?s improved and these are observations from 
my initial test run?

1. When I first moved from 2.6.6 to 2.6.19, I ran into an issue with average 
cost as a price source on my mutual fund account. See 
https://bugzilla.gnome.org/show_bug.cgi?id=775368. I thought this was fixed in 
3.0, but it doesn?t seem to be. Note, however, that the use case I gave in that 
bug report earlier has been fixed, but other investment accounts seem to have 
issues. Upon reviewing the account with the cost issue, only thing I can see is 
that when a mutual fund account has both purchases and redemptions, the balance 
sheet report using average cost price source doesn?t report the cost correctly. 
When there are only purchases, the cost is computed correctly. Is anyone else 
seeing this problem? I am keen on moving to 3.0 due to other features 
introduced in this version, but this is keeping me grounded. I can share an 
account report and the balance sheet report privately to whoever is interested 
in diagnosing this problem.


2. The currency symbol (INR in this case) is printed in bold (looks that way 
from its appearance), which makes it look like a blob on the reports. On the 
main CoA page, the currency is distinctly clearer. Is there a setting to make 
it look like the way it appears on CoA? (see screenshot attached)
Can't see :)
SNIP

4. When I first came across balance sheet (eguile) report in 2.6.6, I took a 
liking for this report more than the regular balance sheet report. However, the 
eguile report contained a warning as a footnote saying - Development version - 
double check the numbers?
In all the time I have looked at this report since, I haven?t come across any 
differences between the eguile and the non-eguile versions. I haven?t 
scrutinised this on an account by account basis, just on an overall equity, 
assets, liability, etc. and the numbers always matched.
But I see this warning even in the 3.0 version! Has anyone ever had problems 
trusting the numbers on the eguile report?
From my understanding of eguile balance sheet, it should be broadly
similar to the regular balance sheet. However the regular balance sheet
has more processing and will note unrealized gains/losses. The eguile
one doesn't. This is one difference that I've noted. Unfortunately the
eguile report developer is no longer active and the eguile reports are
too complicated to debug, and may be removed in the future.
5. Having said that, v3.0 does seem to have a problem with the eguile balance 
sheet report (see screenshot attached). Towards the end, where it prints the 
exchange rates used for s

Re: GnuCash 3.0 initial observations

[Deva -]

Adrien,

John is right about that bug I linked to - it’s not a price source selection 
problem, it’s more involved than that. He helped last time around in fixing one 
aspect of that bug, but needs more work I think.

Thing is, Indian tax laws require us to quote the cost of investment on all 
financial holdings and the balance sheet report up until 2.6.11 has given me 
the correct numbers. This is what is stopping me from upgrading to 2.6.20 (when 
it’s released) or 3.0 version.

On the currency font selection, I tried changing the font on Default 
stylesheet, but to no effect. Seems like the report is getting these setting 
from someplace else. However, upon running other reports, I now see that this 
isn’t a major issue for me. Only on the balance sheet (eguile) report, currency 
is printed in bold and thus makes it look patchy. On many other reports, most 
of the line items are in regular font (showing the currency clearly) and only 
the summary total lines have the currency marked in bold, where it looks 
patchy. I can live with it because you can see what the currency is from the 
rest of the report sections.

Thank you for the tip on changing the delimiter on the price source file. I 
changed it from comma to pipe and it was able to see the columns properly. I 
still had an issue with selecting the column type from the grid showing the 
data file. But the trick is to click on the grid header and when the list with 
4 column type options pops up, I have to scroll down the list using the 
keyboard and make the selection. If I scroll down using the mouse, then no 
selection is being made. With that workaround and a pipe delimited file, I was 
able to import a price data file successfully.

On the balance sheet (eguile) error, I am at a loss. I don’t use trading 
accounts, my entire datafile is in a single currency, but I do have accounts 
tracking stock/mutual fund buys and sells. Will report back if I can provide 
more information.

The CSV price importer and GST Income Statement report (this is a valuable new 
report in 3.0) are strong reasons for me to move to 3.0, but I can’t until my 
balance sheet reflects correct numbers.

I also think the CSV transaction importer can act as a surrogate for breaking 
up transactions in 1 account into sub-accounts if needed. Up until now, rolling 
up from sub-accounts into a parent or merging 2 accounts was easy, 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, 2018, at 7:43 AM, Deva - <pobox.d...@outlook.in> wrote:
>> 
>> Hello,
>> 
>> Firstly, thank you all for this new and much awaited version.
>> 
>> I have just installed GC 3.0 on Mac OS High Sierra 10.13.4 and have been 
>> browsing through what’s new and what’s improved and these are observations 
>> from my initial test run…
>> 
>> 1. When I first moved from 2.6.6 to 2.6.19, I ran into an issue with average 
>> cost as a price source on my mutual fund account. See 
>> https://bugzilla.gnome.org/show_bug.cgi?id=775368. I thought this was fixed 
>> in 3.0, but it doesn’t seem to be. Note, however, that the use case I gave 
>> in that bug report earlier has been fixed, but other investment accounts 
>> seem to have issues. Upon reviewing the account with the cost issue, only 
>> thing I can see is that when a mutual fund account has both purchases and 
>> redemptions, the balance sheet report using average cost price source 
>> doesn’t report the cost correctly. When there are only purchases, the cost 
>> is computed correctly. Is anyone else seeing this problem? I am keen on 
>> moving to 3.0 due to other features introduced in this version, but this is 
>> keeping me grounded. I can share an account report and the balance sheet 
>> report privately to whoever is interested in diagnosing this problem.
>> 
> I think that’s intended behavior of the ‘average cost’ option. (‘cost’ is 
> supposed to only look at buys, not sells, but it in fact, looks at both) You 
> probably want ‘weighted average’ instead. Read over this comment from a bug 
> report on the ‘average cost’ issue: 
> https://bugzilla.gnome.org/show_bug.cgi?id=775368#c4
> 
> This was ‘fixed’ by making ’nearest in time’ the default instead of ‘average 
> cost’.
> 
>> 2. The currency symbol (INR in this case) is printed in bold (looks that way 
>> from its appearance), which makes it look like a blob on the reports. On the 
>> main CoA page, the currency is distinctly clearer. Is there a setting to 
>> make it look like the way it appears on CoA? (see screenshot attached)
> 
> I could be wrong, but that lo

Re: trial balance - how to find mismatch question

[Deva -]

Thanks John. Last time you directed me to this bug report, I didn’t pay 
attention to the entire discussion - just browsed through to ensure I was 
adding my use case to the right bug. But this time, I went through all the 
*gory* details and I think I have a better understanding of what various price 
source options mean.

I was wrong when I said I have seen the imbalance in trial balance in previous 
versions - the huge imbalance appears only in 2.6.19 (other versions I am 
running are 2.6.11 and 2.6.6). When I go back to 2.6.6 or 2.6.11, there’s still 
a difference, but not a huge one - imbalance is only to the tune of few rupees 
(presumably due to rounding adjustments on 18 years of data).

I know now that my previous posting on mutual fund cost basis issue and this 
trial balance issue in 2.6.19 are connected, so sorry for taking up your time. 
I can already see that future 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<mailto:pobox.d...@outlook.in>> wrote:

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 since 2.6.6).

Though I started using GC only since 2015, I actually entered past 18 years of 
my transaction history from annual spreadsheets I used to maintain before. 
After reading this thread, I went back year after year change the end date 
until I hit the first mismatch between credits and debits - just over INR 70 as 
of Mar 2009. Progressively after that, this report now shows a difference of 
over INR 600,000!

There’s nothing in imbalance or orphan accounts and my entire datafile is in 
single currency (INR).

Only thing I can see from the time this first mismatch popped up in 2009 till 
now is that I have had capital gains from sale of shares since 2009. Though I 
recorded these gains carefully each year manually from statements, etc., the 
difference still shows up.

One reason I can think of is this -

When I run the trial balance report (or balance sheet report), the options 
given for commodity pricing are: average cost, weightage average, nearest in 
time and most recent. However, when computing capital gains, Indian tax 
authorities will only accept gains/losses computed on a FIFO basis (FIFO option 
can be selected when running Advanced Portfolio Report).

Since FIFO is not one of the options I can select for commodity pricing in 
trial balance and balance sheet reports, I am guessing the difference in 
credits and debits  is coming from cost basis determined by FIFO and average 
cost basis methods?

Deva,

See https://bugzilla.gnome.org/show_bug.cgi?id=775368.

“Average Cost” as a price source isn’t the same as “Average Cost” as a capital 
gains recognition policy. In GnuCash reports it means that the price used for 
converting one commodity to another is derived from the actual transactions, 
not from prices recorded in the price database. Read the bug for lots of gory 
details.

Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: trial balance - how to find mismatch question

[Deva -]

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 since 2.6.6).

Though I started using GC only since 2015, I actually entered past 18 years of 
my transaction history from annual spreadsheets I used to maintain before. 
After reading this thread, I went back year after year change the end date 
until I hit the first mismatch between credits and debits - just over INR 70 as 
of Mar 2009. Progressively after that, this report now shows a difference of 
over INR 600,000!

There’s nothing in imbalance or orphan accounts and my entire datafile is in 
single currency (INR).

Only thing I can see from the time this first mismatch popped up in 2009 till 
now is that I have had capital gains from sale of shares since 2009. Though I 
recorded these gains carefully each year manually from statements, etc., the 
difference still shows up.

One reason I can think of is this -

When I run the trial balance report (or balance sheet report), the options 
given for commodity pricing are: average cost, weightage average, nearest in 
time and most recent. However, when computing capital gains, Indian tax 
authorities will only accept gains/losses computed on a FIFO basis (FIFO option 
can be selected when running Advanced Portfolio Report).

Since FIFO is not one of the options I can select for commodity pricing in 
trial balance and balance sheet reports, I am guessing the difference in 
credits and debits  is coming from cost basis determined by FIFO and average 
cost basis methods?

Cheers.

On 16-Feb-2018, at 7:32 AM, 
gnucash-user-requ...@gnucash.org wrote:

It seems at least in my case, the imbalance really appears to be Gnucash?s 
fault.

I narrowed down the date to my opening date. This should be easy right? Not so 
fast.

Of course, everything is in balance as I expected it to be.

So I decided to compare the report totals for each account to the individual 
amounts in the accounts themselves.

Bingo.

The Trial Balance report shows the wrong total for one account, by the amount 
of the discrepancy listed on the report.

The account in question is an asset account for silver bullion held in ounces 
of XAG. (not entirely appropriate I?m sure, but since I can?t create my own 
currency, this is the best I could muster and the price is reasonably close for 
my purposes)

I was retrieving prices automatically, but can?t seem to get finance quote to 
consistently work, so I just enter the numbers by hand each month. (I?m not an 
active trader, this is on-hand stuff) The very first price, I set the same as 
my opening book date and it is manually entered.

It seems Gnucash is shortcutting on this report and causing a rounding error. 
The commodity itself is held accurate to 6 decimal places, but the USD 
conversion rounds off to whole ?. I don?t want to add decimals for all of my 
accounts just to satisfy that report. (which I never use anyway)

There are several opening balance lines in this account for each type of 
bullion I had on that date. The trial balance report is taking the total 
ounces, converting to dollars and using that figure. It is not using the 
individual USD figures it calculated in order to balance against the equity 
account.

Therefore, this report will always be off and will always tell me I?m out of 
balance, even when I?m not.

(it incidentally reports unrealized losses, presumably based on that account, 
but since it?s only for one day, I can?t fathom how such a calculation is 
possible)

Regards,
Adrien

On Feb 15, 2018, at 5:52 PM, Adrien Monteleone 
> wrote:

I just noticed the subject was wrong due to a user-digest error, re-applying 
the original.

???

I?m having a bit of issue understanding the point of the trial-balance report 
in modern times. (I generally don?t use it as I mentioned)

If each transaction self-balances, that is, debits = credits, how is it 
possible to add up the debits individually and the credits individually and not 
get a result that still balances? You can?t add up 1+2+3 = 5 and 1+2+3 = 6. 
It?s a mathematical impossibility.

In addition, if you enter a transaction that doesn?t balance, Gnucash forces it 
to balance by using either the imbalance or orphan accounts. So at least you?re 
alerted to amounts you need to fix, but technically, debits still equal credits.

Let?s assume I entered a transaction backwards and debited my cash account 
instead of crediting it, and credited an expense account instead of debiting 
it. This should not affect the trial-balance. Sure, the amounts are wrong for 
each account, but they still balance. Debits still equal credits.

If I transpose two digits (the divisible by ?9? trick) then as 

Re: Instructions for GST India

[Deva -]

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: Amish <anon.am...@gmail.com>
> To: gnucash-user@gnucash.org
> Subject: Re: Instructions for GST India
> Message-ID: <9ab0f1b1-c69b-707b-6bb9-262578619...@gmail.com>
> Content-Type: text/plain; charset=utf-8; format=flowed
> 
> 
> On Tuesday 06 February 2018 08:02 PM, Frank H. Ellenberger wrote:
>> Hi,
>> 
>> Am 06.02.2018 um 13:07 schrieb Deva -:
>>> And yes, it can certainly go on the wiki for those looking for help.
>>> I wish I had something like that to guide me when I was doing the
>>> same, but with trial and error, I got to what I wanted.
>> Or, if one of you were volunteering to create a template, we could ship
>> it with future releases.
>> 
>> The basics to create one are described in
>> https://wiki.gnucash.org/wiki/Account_Hierarchy_Template .
> 
> Created pull request:
> https://github.com/Gnucash/gnucash/pull/275
> 
> Description:
> This is the base module for setting up accounts for an Indian Business 
> with Goods and Service Tax (GST).
> 
> Mostly uses Indian terminology to ease the filing of many Indian 
> Government returs - e.g. Income tax returns, MCA returns and GST returns.
> 
> Amish
> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Instructions for GST India

[Deva -]

This is in response to the post titled in the subject line…

I can concur with Amish’s setup for GST India, but with a few minor 
observations.

I have a similar setup, though not as elaborate as Amish’s. This is largely due 
to the fact that I don’t claim GST input tax credit for purchases (my tax 
credits are negligible compared to what I pay as GST). Also, I have to deal 
with only 1 tax rate of 18%, but that does involve setting up of 3 tax tables 
like Amish pointed out - CGST @ 9%, SGST @ 9% and IGST @ 18%.

My few observations -

a. Not sure if you need 2 A/R accounts. Since these accounts are not directly 
used in reports, just having one should do (sub-accounts for GST and NonGST can 
be merged into the parent).
b. You may find it more helpful by actually putting the tax rate in the tax 
account name itself. For instance, "Liabilities:Sales:GST:IGST @ 18%” as the 
account name, instead of "Liabilities:Sales:GST:IGST”. While this will not make 
a difference if you are using Tax Invoice report, it will show up nicely in 
case of a Printable Report or Fancy Invoice report because the tax line will 
read IGST @ 18% (instead of just IGST).
c. I haven’t segregated the NonGST vs. GST (registered vs. unregistered 
dealers), though I can see the benefit given GST reporting requirements. 
However, I think with the new transaction report that was posted on this list 
sometime back (by Doug, I think), one can easily generate summaries based on 
descriptions in the transaction registers. So if you are diligent about tagging 
your transactions with proper notes/memos, etc. then you can always generate 
summaries based on those with the new transaction report to meet the GST 
reporting requirements.

I think if you are dealing with large volumes of GST related transactions, 
Amish’s setup is the way to go, though it may seem a bit tedious to set it up 
in the beginning. My GST invoices are to the tune of about 100 invoices a year, 
so I have cut down on my account hierarchy to keep it simple.

And yes, it can certainly go on the wiki for those looking for help. I wish I 
had something like that to guide me when I was doing the same, but with trial 
and error, I got to what I wanted.

I am sure all of us continue to remain indebted to GnuCash to help keep our 
financial matters in order despite the chaotic rollout of GST that India 
witnessed not so 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:20180205205957.0c294...@billiau.net>>
Content-Type: text/plain; charset=UTF-8

Are there any other Indian users of GST who wish to comment, because
this needs copying into the wiki if it is "ready to use".
Liz


On Mon, 5 Feb 2018 11:22:40 +0530
Amish <anon.am...@gmail.com<mailto:anon.am...@gmail.com>> wrote:

On Sunday 04 February 2018 09:29 PM, TBUA wrote:
hello there,

Have you figured out a work around for this? Would really like some
help with this !

Hello

This is how I have done it.

It looks complicated at first but works perfectly for me for getting
data for GSTR1/2/3B

Just giving rough idea.

You need to know how to use tax tables in Gnucash and assign them to
right accounts.
You also need to learn how to generate reports in Gnucash using right
accounts.

Note: Colon indicates/separates subaccounts

Stage 1: (Account creation)


1) Create these income accounts

Income:Sales:GST (sales to all GST registered dealers)
Income:Sales:NonGST (sales to all unregistered dealers)
Income:Sales:Roundoff (any roundoff in bill goes here)

2) Create these expense accounts

Expense:Purchase

My purchase is always from GST registered dealers so I have not
created GST/NonGST subaccounts.
You may create 2 sub accounts for GST and NonGST dealers.

3) Create these Asset (GST Tax paid on purchase) accounts

Assets:GST-Purchase:CGST
Assets:GST-Purchase:IGST
Assets:GST-Purchase:SGST

Again you may create NonGST purchase accounts if you want.

4) Create these Liabilities (GST tax to be paid to government for
sales) accounts

Liabilities:Sales:GST:CGST
Liabilities:Sales:GST:IGST
Liabilities:Sales:GST:SGST
Liabilities:Sales:NonGST:CGST
Liabilities:Sales:NonGST:IGST
Liabilities:Sales:NonGST:SGST

5) Create these receivables (GST sales - including tax) accounts

Assets:Trade Receivables:GST
Assets:Trade Receivables:NonGST

6) Create these payables (GST purchase payments to be made) accounts

Liabilities:Trade Payables

Again my purchase is always from GST registered dealers so I have not
created subaccounts.


Stage 2: (Tax tables)
---

Now that all accounts are set. Here are the tax tables that I have
created.

In my case taxes are either 5% (IGST), 12% (IGST), 2.5%+2.5%
(CGST+SGST), 6%+6% (CGST+SGST)

Such tax structure exists for bo

Re: Mutual fund cost basis changes between 2.6.6 and 2.6.19

[Deva -]

Noted. As suggested, I have kept both 2.6.11 and 2.6.19 for now. Hopefully, 
when 3.0 is released, I can run a single version to maintain the correct cost 
basis.

Cheers.
On 13-Jan-2018, at 8:31 PM, John Ralls 
<jra...@ceridwen.us<mailto:jra...@ceridwen.us>> wrote:



On Jan 12, 2018, 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 to 2.6.11 (last version where cost basis is 
correctly reported)? The reason I upgraded was because I saw some post on the 
list stating that if I upgrade to Mac OS High Sierra, then GnuCash needs to be 
at 2.6.19. So I upgraded GnuCash in preparation of the Mac OS upgrade.

If I downgrade to 2.6.11, will it be compatible with Mac OS High Sierra?

I don’t say it enough - this community’s immense support is deeply appreciated. 
Not just on technical aspects, I have gotten so many good ideas on accounting 
concepts as well, just by reading through other’s posts. Many thanks to all of 
you for your timely help!

Cheers.
On 12-Jan-2018, at 8:44 PM, John Ralls 
<jra...@ceridwen.us<mailto: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 latest version 2.6.19.

After running a preliminary test of some of the reports I use for tax reporting 
purposes, I noticed that the cost basis on one of my mutual funds has changed 
significantly (see attached screenshot for the transactions on that mutual fund 
account).

Some history on this fund. It used to be called Fidelity Flexi Gilt Fund and I 
had invested INR 850,000 and accumulated 70,362.427 shares as of 16-Nov-12. But 
on 23-Nov-2012, Fidelity sold its mutual fund business in India to L Mutual 
Fund and the latter decided to merge Fidelity’s gilt fund into its own - now 
called L Gilt Fund.

When this merger happened, I simply used the stock split assistant to reduce 
the no. of shares by 34,769.081 based on the account statement sent by L

As of 2.6.6, the (average) cost basis on the balance sheet report correctly 
showed INR 850,000 even after the “stock split” transaction. But in the latest 
version 2.6.19, the balance sheet report shows the same cost basis as 
429,978.69. I think it has reduced the cost basis by the cost of the shares 
reduced from the merger i.e., 34,769.081 shares.

This is causing such differences to show up as imbalance in my reports!

Has the computation of cost basis changed between these versions? If so, how 
should I go about accounting for cases such as above to maintain proper cost 
basis?

Odd thing though is that I have a no. of stocks that declared a stock split, 
but in those cases, the cost basis is correctly maintained even after the 
split. This behaviour is only seen in mutual fund shares (as far as I can tell).

I rely on GnuCash reports for my annual tax reporting, so it’s important that 
the reports I generate have a proper explanation for the numbers shown.

Thanks in advance for your time.

Yes, the calculation of average cost changed in 2.6.12 to fix a bug, but that 
opened another can of worms, see 
https://bugzilla.gnome.org/show_bug.cgi?id=775368. I intend to have a solution 
for 3.0 and if you can add the details of your use-case to the bug that will 
help.

The issue with 2.6.17 and earlier on High Sierra is a mismatched version of 
libz. You can work around it on the earlier versions by copying 
/usr/lib/libz.1.dylib to Gnucash.app/Contents/Resources/lib. That’s more easily 
done from the command line as Finder prefers not to show either /usr or the 
inside of app bundles, though it can be coerced to.

Note as well that you can have both 2.6.11 and 2.6.19 on a Mac. Either rename 
one of the bundles or keep them in separate directories.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Mutual fund cost basis changes between 2.6.6 and 2.6.19

[Deva -]

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 to 2.6.11 (last version where cost basis is 
correctly reported)? The reason I upgraded was because I saw some post on the 
list stating that if I upgrade to Mac OS High Sierra, then GnuCash needs to be 
at 2.6.19. So I upgraded GnuCash in preparation of the Mac OS upgrade.

If I downgrade to 2.6.11, will it be compatible with Mac OS High Sierra?

I don’t say it enough - this community’s immense support is deeply appreciated. 
Not just on technical aspects, I have gotten so many good ideas on accounting 
concepts as well, just by reading through other’s posts. Many thanks to all of 
you for your timely help!

Cheers.
On 12-Jan-2018, at 8:44 PM, John Ralls 
<jra...@ceridwen.us<mailto: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 latest version 2.6.19.

After running a preliminary test of some of the reports I use for tax reporting 
purposes, I noticed that the cost basis on one of my mutual funds has changed 
significantly (see attached screenshot for the transactions on that mutual fund 
account).

Some history on this fund. It used to be called Fidelity Flexi Gilt Fund and I 
had invested INR 850,000 and accumulated 70,362.427 shares as of 16-Nov-12. But 
on 23-Nov-2012, Fidelity sold its mutual fund business in India to L Mutual 
Fund and the latter decided to merge Fidelity’s gilt fund into its own - now 
called L Gilt Fund.

When this merger happened, I simply used the stock split assistant to reduce 
the no. of shares by 34,769.081 based on the account statement sent by L

As of 2.6.6, the (average) cost basis on the balance sheet report correctly 
showed INR 850,000 even after the “stock split” transaction. But in the latest 
version 2.6.19, the balance sheet report shows the same cost basis as 
429,978.69. I think it has reduced the cost basis by the cost of the shares 
reduced from the merger i.e., 34,769.081 shares.

This is causing such differences to show up as imbalance in my reports!

Has the computation of cost basis changed between these versions? If so, how 
should I go about accounting for cases such as above to maintain proper cost 
basis?

Odd thing though is that I have a no. of stocks that declared a stock split, 
but in those cases, the cost basis is correctly maintained even after the 
split. This behaviour is only seen in mutual fund shares (as far as I can tell).

I rely on GnuCash reports for my annual tax reporting, so it’s important that 
the reports I generate have a proper explanation for the numbers shown.

Thanks in advance for your time.

Yes, the calculation of average cost changed in 2.6.12 to fix a bug, but that 
opened another can of worms, see 
https://bugzilla.gnome.org/show_bug.cgi?id=775368. I intend to have a solution 
for 3.0 and if you can add the details of your use-case to the bug that will 
help.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Mac OS accelerator keys

[Deva -]

Thanks Christoph.

It seems all lines had that “;” at the beginning, even the commonly used 
cut/copy/paste, so it didn’t occur to me that these were commented lines.

I removed the “;” at the beginning of the said entires and it works just fine.

One peculiar observation though. I used  as a tag on some shortcuts 
while tagging the others with . I was expecting the  ones to 
invoked by using +key and the  ones to be invoked by using 
+key.

However, on launching gnucash, all menu options get converted to +key 
and can be invoked only by the  key (even the ones meant for invoking 
by the  key).

So, I closed gnucash and went back and looked the accelerator-map file again. 
And it looks like all the lines I edited with the  tag have been 
converted back to use  tag.

Not an issue, just an observation. I can make useful shortcuts for now - all to 
be invoked with the “Command” key 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>> 
wrote:

Hi Deva,

did you remove the semicolon at the start of the line?
The semicolon is the comment character which will make Gnucash ignore the line.

Cheers,
Christoph

Am 13.09.2017 um 07:44 schrieb Deva - 
<pobox.d...@outlook.in<mailto:pobox.d...@outlook.in>>:

Thank you for the response John.

It was nice to know some historical context on this one.

I changed the ~/Library/Application Support/Gnucash/accelerator-map file as you 
suggested (see sample extract below). First, I had it as "b”, “l”, 
etc. Started up gnucash, but nothing was happening when I pressed the Alt+l or 
Alt+j key on an open account register while I was on a transaction line.

So I closed gnucash, went back and edited the file again to replace  with 
 as shown in the extract here. Started up gnucash again, and used the 
“Command” key with these letter combinations, but still no effect.

; (gtk_accel_path "/GncPluginPageRegisterActions/ViewStyleBasicAction" 
"b”)
; (gtk_accel_path 
"/GncPluginPageRegisterActions/ViewStyleAutoSplitAction" "l”)
; (gtk_accel_path 
"/GncPluginPageRegisterActions/JumpTransactionAction" "j”)
; (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 
<jra...@ceridwen.us<mailto:jra...@ceridwen.us><mailto:jra...@ceridwen.us>> 
wrote:



On Sep 12, 2017, at 5:30 AM, Deva - 
<pobox.d...@outlook.in<mailto:pobox.d...@outlook.in><mailto:pobox.d...@outlook.in>>
 wrote:

Hello,

I am running Gnucash v2.6.6 on Mac OS Sierra.

This is in response to an earlier post clarifying how to setup keyboard access 
to frequently performed functions by Christopher Lam (see below). I couldn’t 
find a way to respond to that specific thread from my daily digest mail, hence 
this.

I presume that post was about a windows fix. On my Mac, I found a similar file 
called osx_accel_map under 
/Applications/Gnucash/Contents/Resources/share/gnucash/ui.

I edited the file (after making a backup of the original file) for the 2 lines 
mentioned in the earlier post, but instead of "j" and "l”, I 
changed it to “j” and “l” based on other such entries in the file.

I restarted gnucash after these edits, but these accelerator keys don’t seem to 
work on an open register. I tried pressing both  as well as  for 
the  key, but with no effect - nothing happens.

Can you please let me know how I can set this up for a Mac?

Deva,

The file you want to edit is ~/Library/Application 
Support/Gnucash/accelerator-map. The one in the bundle is obsolete and not used.

 means “Command” on Mac and “Control” everywhere else.  means 
“Alt”; on a Mac that’s the Alt/Option key. (The history about that is that I 
had a spirited discussion with Mitch Natterer of The GIMP about how to map 
control to command.  isn’t a modifier key in Gtk. I wanted to map 
command to meta, but Mitch insisted that  should be Alt/Option to be 
consistent with Linux and Win32. He solved the problem rather elegantly by 
inventing . Shortly after that Mike Alexander improved my accelerator 
map code in GnuCash to not use osx_accel_map but didn’t remove it in case it 
might prove useful.)

Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

__

Re: Mac OS accelerator keys

[Deva -]

Thank you for the response John.

It was nice to know some historical context on this one.

I changed the ~/Library/Application Support/Gnucash/accelerator-map file as you 
suggested (see sample extract below). First, I had it as "b”, “l”, 
etc. Started up gnucash, but nothing was happening when I pressed the Alt+l or 
Alt+j key on an open account register while I was on a transaction line.

So I closed gnucash, went back and edited the file again to replace  with 
 as shown in the extract here. Started up gnucash again, and used the 
“Command” key with these letter combinations, but still no effect.

; (gtk_accel_path "/GncPluginPageRegisterActions/ViewStyleBasicAction" 
"b”)
; (gtk_accel_path 
"/GncPluginPageRegisterActions/ViewStyleAutoSplitAction" "l”)
; (gtk_accel_path 
"/GncPluginPageRegisterActions/JumpTransactionAction" "j”)
; (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 
<jra...@ceridwen.us<mailto:jra...@ceridwen.us>> wrote:



On Sep 12, 2017, at 5:30 AM, Deva - 
<pobox.d...@outlook.in<mailto:pobox.d...@outlook.in>> wrote:

Hello,

I am running Gnucash v2.6.6 on Mac OS Sierra.

This is in response to an earlier post clarifying how to setup keyboard access 
to frequently performed functions by Christopher Lam (see below). I couldn’t 
find a way to respond to that specific thread from my daily digest mail, hence 
this.

I presume that post was about a windows fix. On my Mac, I found a similar file 
called osx_accel_map under 
/Applications/Gnucash/Contents/Resources/share/gnucash/ui.

I edited the file (after making a backup of the original file) for the 2 lines 
mentioned in the earlier post, but instead of "j" and "l”, I 
changed it to “j” and “l” based on other such entries in the file.

I restarted gnucash after these edits, but these accelerator keys don’t seem to 
work on an open register. I tried pressing both  as well as  for 
the  key, but with no effect - nothing happens.

Can you please let me know how I can set this up for a Mac?

Deva,

The file you want to edit is ~/Library/Application 
Support/Gnucash/accelerator-map. The one in the bundle is obsolete and not used.

 means “Command” on Mac and “Control” everywhere else.  means 
“Alt”; on a Mac that’s the Alt/Option key. (The history about that is that I 
had a spirited discussion with Mitch Natterer of The GIMP about how to map 
control to command.  isn’t a modifier key in Gtk. I wanted to map 
command to meta, but Mitch insisted that  should be Alt/Option to be 
consistent with Linux and Win32. He solved the problem rather elegantly by 
inventing . Shortly after that Mike Alexander improved my accelerator 
map code in GnuCash to not use osx_accel_map but didn’t remove it in case it 
might prove useful.)

Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Mac OS accelerator keys

[Deva -]

Hello,

I am running Gnucash v2.6.6 on Mac OS Sierra.

This is in response to an earlier post clarifying how to setup keyboard access 
to frequently performed functions by Christopher Lam (see below). I couldn’t 
find a way to respond to that specific thread from my daily digest mail, hence 
this.

I presume that post was about a windows fix. On my Mac, I found a similar file 
called osx_accel_map under 
/Applications/Gnucash/Contents/Resources/share/gnucash/ui.

I edited the file (after making a backup of the original file) for the 2 lines 
mentioned in the earlier post, but instead of "j" and "l”, I 
changed it to “j” and “l” based on other such entries in the file.

I restarted gnucash after these edits, but these accelerator keys don’t seem to 
work on an open register. I tried pressing both  as well as  for 
the  key, but with no effect - nothing happens.

Can you 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<mailto:gnucash-user@gnucash.org>
Subject: Re: Add icon for "Get Transactions..."

Ah but there exists mechanism to add keyboard shortcuts.Edit your 
.gnucash/accelerator-map and maybe you'll find appropriate entry.
I've added Ctrl-J for Jump as Ctrl-L for Split as follows:

(gtk_accel_path "/GncPluginPageRegisterActions/JumpTransactionAction" 
"j")
(gtk_accel_path "/GncPluginPageRegisterActions/SplitTransactionAction" 
"l”)

<<< end post


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.