Re: [GNC] Get quote - online price retrieval

[Geoff]

Ashok, I have tried to replicate your issue on a new Windows 10 installation.

You said:-
"Did the cpan Date::Manip, but that freezes at the point of the below stage.
Have to "Ctrl"+C, ugly exit."

You need to be more patient, it wasn't frozen, just having a rest!  The
complete installation process of all the necessary perl modules for price
quotes (if you use "gnc-fq-update" the recommended gnucash installer) took
about 30 minutes on my machine, and there were a couple of significant
pauses along the way.

Once you have successfully installed Finance::Quotes and all of its
dependencies, you will be able to get a quote for your fund:

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump -v amfiindia 106876
Finance::Quote fields Gnucash uses:
symbol: 106876   <=== required
  date: 08/14/2020   <=== recommended
  currency: INR  <=== required
  last:  <=\
   nav: 17.6037  <=== one of these
 price:  <=/
  timezone:  <=== optional

All fields returned by Finance::Quote for stock 106876

stock   field  value
-   -  -
106876   currency: INR
106876   date: 08/14/2020
106876isodate: 2020-08-14
106876   link: https://www.amfiindia.com/spages/NAVAll.txt
106876 method: amfitable
106876   name: Aditya Birla Sun Life International Equity Fund -
Plan B - Growth - Regular Plan
106876nav: 17.6037
106876 source: http://www.amfiindia.com/
106876success: 1
106876 symbol: 106876


I have also attached a screenshot of getting a quote from within gnucash -
don't forget to add your AlphaVantage API key first as explained here:
https://wiki.gnucash.org/wiki/Online_Quotes


DETAILED INSTRUCTIONS
=
Windows 10 Version 1903

Download gnucash 4.1 for Windows 10 from:
https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/4.1/gnucash-4.1.setup.exe

Verify the checksum from https://www.gnucash.org/news.phtml
We are expecting:
"836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0" for
gnucash-4.1.setup.exe

08/17/2020  12:56 PM  ..
08/17/2020  12:56 PM   148,789,209 gnucash-4.1.setup.exe

C:>certutil -hashfile gnucash-4.1.setup.exe SHA256
SHA256 hash of gnucash-4.1.setup.exe:
836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0
CertUtil: -hashfile command completed successfully.


Download strawberry perl from http://strawberryperl.com/
http://strawberryperl.com/download/5.30.2.1/strawberry-perl-5.30.2.1-64bit.msi

08/17/2020  01:04 PM  .
08/17/2020  01:04 PM   106,541,628 strawberry-perl-5.30.2.1-64bit.msi

C:>perl -v
This is perl 5, version 30, subversion 2 (v5.30.2) built for
MSWin32-x64-multi-thread

C:>cd "C:\Program Files (x86)\gnucash\bin"

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check

You need to install the following Perl modules:
  Finance::Quote

Use your system's package manager to install them,
or run 'gnc-fq-update' as root.
missing-lib

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update
Fetching with LWP:
http://cpan.strawberryperl.com/authors/01mailrc.txt.gz
Fetching with LWP:
http://cpan.strawberryperl.com/modules/02packages.details.txt.gz
Fetching with LWP:
http://cpan.strawberryperl.com/modules/03modlist.data.gz
Creating database file ... Done!
Running install for module 'Date::Manip'
Fetching with LWP:
http://cpan.strawberryperl.com/authors/id/S/SB/SBECK/Date-Manip-6.82.tar.gz
Fetching with LWP:
HASH(0x5250c90)authors/id/S/SB/SBECK/CHECKSUMS
Fetching with LWP:
HASH(0x5250c90)authors/id/S/SB/SBECK/CHECKSUMS.gz
Fetching with LWP:
http://cpan.strawberryperl.com/authors/id/S/SB/SBECK/CHECKSUMS
Checksum for
C:\Strawberry\cpan\sources\authors\id\S\SB\SBECK\Date-Manip-6.82.tar.gz ok
Configuring S/SB/SBECK/Date-Manip-6.82.tar.gz with Makefile.PL
Checking if your kit is complete...
Looks good

~~~ snip ~~~

2900 lines later it should complete successfully with:

Installing C:\Strawberry\perl\site\lib\Finance\Quote\YahooYQL.pm
Installing C:\Strawberry\perl\site\lib\Finance\Quote\ZA.pm
Installing C:\Strawberry\perl\site\lib\Finance\Quote\ZA_UnitTrusts.pm
Appending installation info to C:\Strawberry\perl\lib/perllocal.pod
  ECOCODE/Finance-Quote-1.49.tar.gz
  C:\Strawberry\c\bin\gmake.exe install UNINST=1 -- OK

C:\Program Files (x86)\gnucash\bin>

Hope this helps.

Geoff
=
 



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

Re: [GNC] help increasing size of font in GnuCash?

[John Ralls]

And in order to see it in Finder you need to click the gear or control-click 
with your home folder selected, click Show View Options from the context menu, 
and then in the View Options window check Show Library Folder. Contrary to 
*everyone's* HIG that item disappears when any folder other than your home one 
is selected.

Regards,
John Ralls


> On Aug 16, 2020, at 3:53 PM, David Reiser via gnucash-user 
>  wrote:
> 
> That’s the wrong library folder. There’s another one in /Users/[your user 
> name]/Library.
> 
> Dave
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> 
> 
> 
> 
>> On Aug 16, 2020, at 5:56 PM, Marilyn Graves Kimple via gnucash-user 
>>  wrote:
>> 
>> No problem-- there were actually two of us with the same problem, and I do 
>> have a Mac but the other was Windows. But I know about Application Support 
>> and I do not have a GnuCash folder. No idea why not.
>> Best regards, mgk
>> > PM.png>___
>> 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.

___
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] help increasing size of font in GnuCash?

[David Reiser via gnucash-user]

That’s the wrong library folder. There’s another one in /Users/[your user 
name]/Library.

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Aug 16, 2020, at 5:56 PM, Marilyn Graves Kimple via gnucash-user 
>  wrote:
> 
> No problem-- there were actually two of us with the same problem, and I do 
> have a Mac but the other was Windows. But I know about Application Support 
> and I do not have a GnuCash folder. No idea why not.
> Best regards, mgk
>  PM.png>___
> 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] Recording Tax Correctly

[Christopher Lam]

As I said before

VAT:Input VAT receives only VAT on Purchases
VAT:Output VAT receives only VAT on Sales
VAT:VAT Return receives only periodic government VAT transfers

The VAT parent account does not receive any splits; but its balance
(including children accounts) will tell me, roughly, the VAT payable (or
receivable). It will reset towards zero.

On Sun, 16 Aug 2020 at 13:46, Omer Hayat  wrote:

> @Christopher Lam  I'll show this to my
> accountant.
> In the meanwhile, I tried following:
>
> Created a 'TAX' account under 'Liability' parent account. Then created 2
> sub-accounts under the TAX account, Input VAT & Output VAT respectively.
> Now, when I post the vendor bills or customer invoices, the VAT is recorded
> properly in these sub-accounts, and their main account TAX also shows a
> final figure. But, from here I'm not clear what to do. I passed an entry:
>
> DR TAX
> CR Bank
>
> with the equivalent amount. This did make the amount to '0' for the TAX,
> but the 2 sub-accounts still have the respective amounts in them. Although,
> the Liabilities parent account was also showing a correct balance, as I
> think it just picks up the amount from TAX.
>
> Not sure if this will be a correct way of doing, or maybe there are
> multiple ways to do this.
> --
> *From:* Christopher Lam 
> *Sent:* Sunday, August 16, 2020 2:00 PM
> *To:* Omer Hayat 
> *Cc:* gnucash-user@gnucash.org 
> *Subject:* Re: [GNC] Recording Tax Correctly
>
> Hi Omer, my approach is:
>
>- VAT:Input VAT - an ASSET account
>- VAT:Output VAT- a LIABILITY account
>- VAT:VAT Return - an ASSET or LIABILITY account
>
> and run the "Income & GST Statement" periodically, posting the govt
> returns as follows:
> Dr VAT:VAT Return
> Cr Bank
>
> HTH, C
>
> On Sun, 16 Aug 2020 at 07:55, Omer Hayat  wrote:
>
> Hi.
> We have a 5% VAT charged on all bills and invoices. To the government, we
> pay the difference.
> I have setup an 'Input VAT(paid to Vendor)' and 'Output VAT(received from
> Customers)' accounts under Liabilities, and set them up. These are
> recording the VAT paid & received from Bills/Invoices correctly. The Input
> VAT account has negative values, and output VAT has positive values. We are
> supposed to pay the difference of these.
> For example:
>
> VAT paid to Vendor
> (50.00)
> VAT received from Customer  75.00
> FINAL VAT PAYABLE TO GOVT   25.00
>
> Keeping the above example, I would like to pass one entry, and pay off the
> difference amount.
> Example:
> DR Final Payable to Govt
> CR Bank
> But, how can I pass the Debit entry? Should I create a 'Tax' placeholder
> account and pass it to that? But then the individual Input & Output VAT
> accounts might have a balance.
>
> Please advise.
> ___
> 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] help increasing size of font in GnuCash?

[Mahon Finbar]

I have done that, but on my Lenovo W10 1903  the 'magified' text is 
blurred.


I would like there to be a simple text size option under settings.

I needed, and very much appreciate, an accounting app which is not run 
by money grabbers (especially accountants :-). In GNU I found it, but, 
although I am a nerd, sort of, I don't really want to dive into the nuts 
and bolts. So, things like GTK are a step too far.


Thanks, Barry

On 16/08/2020 03:24, David H wrote:

nor,

Check out Settings >> Ease of Access >> Magnifier - you can use the Win Key
together with + or - to zoom in and out on Win 10.

Cheers David H.


On Sat, 15 Aug 2020 at 15:58, nor via gnucash-user 
wrote:


It is too complicated to modify gtk file for an accountant. I had posted
earlier on this subject as below,quote,At time register is to small to
view.
Now that ver 4 series is developed, asetting in a menu to change the fonts
will be of great help for the peoplewith poor eye sight. Standard Zoom
in/out with control key +or- does notwork either.Appreciate your
advise,Regards,norUnquote.Regards,



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


___
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] Finance::Quote stock code with ampersand

[John Ralls]

> On Aug 16, 2020, at 7:03 AM, Jour Maken  wrote:
> 
> This is an issue with F:Q accessed through Gnucash or gnc-fq-dump. A stock I 
> need to retrieve quotes from Yahoo JSON has an ampersand in its code and 
> hence fails to retrieve the correct prices. If someone has faced this and 
> come up with a workaround, I would like to know, please. The code is M for 
> Mahindra and Mahindra, and the links for the same are as follows:
> 
> https://www.nseindia.com/get-quotes/equity?symbol=M%26M
> 
> https://in.finance.yahoo.com/quote/M?p=M&.tsrc=fin-srch
> 
> I have tried escape sequence ‘M\’, ‘MM.NS’ and ‘M%26M.NS’ but in 
> each case quotes for just ‘M’ corresponding to Macy’s is retrieved in USD - 
> my locale is set for INR currency.
> 
> Please advise,
> 


The last works for me:

gnc-fq-dump yahoo_json 'M%26M.NS'
Finance::Quote fields Gnucash uses:
symbol: M%26M.NS <=== required
  date: 08/14/2020   <=== recommended
  currency: INR  <=== required
  last: 614.45   <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

and
echo '(yahoo_json  "M%26M.NS")' | gnc-fq-helper
(("M%26M.NS" (symbol . "M%26M.NS") (gnc:time-no-zone . "2020-08-14 12:00:00") 
(last . #e614.45) (currency . "INR")))

I tried it in GnuCash. Worked there too.

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] Recording Tax Correctly

[Michael or Penny Novack]

PS: Yes, as Christopher notes, could place VAT paid as an asset (which 
it properly is). I was following the set up you were describing instead, 
placing VAT paid as a contra account. Also sensible, as under normal 
conditions, the parent VAT is going to have a net credit balance << your 
business would  be selling more than it pays or you would be operating 
at a loss* >>


Michael D Novack


* However that COULD be normal, and even profitable << not for the 
business itself, but operating/controlling the business might have "side 
effects" that were profitable >>


___
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] Finance::Quote stock code with ampersand

[Jour Maken]

This is an issue with F:Q accessed through Gnucash or gnc-fq-dump. A stock I 
need to retrieve quotes from Yahoo JSON has an ampersand in its code and hence 
fails to retrieve the correct prices. If someone has faced this and come up 
with a workaround, I would like to know, please. The code is M for Mahindra 
and Mahindra, and the links for the same are as follows:

https://www.nseindia.com/get-quotes/equity?symbol=M%26M

https://in.finance.yahoo.com/quote/M?p=M&.tsrc=fin-srch

I have tried escape sequence ‘M\’, ‘MM.NS’ and ‘M%26M.NS’ but in each 
case quotes for just ‘M’ corresponding to Macy’s is retrieved in USD - my 
locale is set for INR currency.

Please advise,

Divakar

Sent from Mail for Windows 10

___
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] Recording Tax Correctly

[Michael or Penny Novack]

On 8/16/2020 3:54 AM, Omer Hayat wrote:

Hi.
We have a 5% VAT charged on all bills and invoices. To the government, we pay 
the difference.
I have setup an 'Input VAT(paid to Vendor)' and 'Output VAT(received from 
Customers)' accounts under Liabilities, and set them up. These are recording the 
VAT paid & received from Bills/Invoices correctly. The Input VAT account has 
negative values, and output VAT has positive values. We are supposed to pay the 
difference of these.
For example:

VAT paid to Vendor
(50.00)
VAT received from Customer  75.00
FINAL VAT PAYABLE TO GOVT   25.00

Keeping the above example, I would like to pass one entry, and pay off the 
difference amount.
Example:
DR Final Payable to Govt
CR Bank
But, how can I pass the Debit entry? Should I create a 'Tax' placeholder account 
and pass it to that? But then the individual Input & Output VAT accounts might 
have a balance.

Please advise.


I am not SURE about your description of the accounts, but let's say that 
under liabilities you have an account VAT and under it children "VAT 
paid" and "VAT received" << set up that way, the amount shown for the 
parent will be the net >>


Are you asking what the transaction would look like when you paid the 
net amount to the government? Worried (correctly) that if you did that 
by debiting the parent (correctly bring the net to zero) it still leaves 
balances in the children?


What makes you think that a transaction has just one debit and one 
credit? Have you not yet entered any "split" transactions? Try doing 
that. The transactions would debit "VAT received", and credit "checking" 
and "VAT paid"  << the amount of the credit to checking would be the 
amount of the net >>


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
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] Recording Tax Correctly

[Omer Hayat]

@Christopher Lam I'll show this to my 
accountant.
In the meanwhile, I tried following:
Created a 'TAX' account under 'Liability' parent account. Then created 2 
sub-accounts under the TAX account, Input VAT & Output VAT respectively. Now, 
when I post the vendor bills or customer invoices, the VAT is recorded properly 
in these sub-accounts, and their main account TAX also shows a final figure. 
But, from here I'm not clear what to do. I passed an entry:
DR TAX
CR Bank
with the equivalent amount. This did make the amount to '0' for the TAX, but 
the 2 sub-accounts still have the respective amounts in them. Although, the 
Liabilities parent account was also showing a correct balance, as I think it 
just picks up the amount from TAX.
Not sure if this will be a correct way of doing, or maybe there are multiple 
ways to do this.

From: Christopher Lam 
Sent: Sunday, August 16, 2020 2:00 PM
To: Omer Hayat 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Recording Tax Correctly

Hi Omer, my approach is:

  *   VAT:Input VAT - an ASSET account
  *   VAT:Output VAT- a LIABILITY account
  *   VAT:VAT Return - an ASSET or LIABILITY account

and run the "Income & GST Statement" periodically, posting the govt returns as 
follows:
Dr VAT:VAT Return
Cr Bank

HTH, C

On Sun, 16 Aug 2020 at 07:55, Omer Hayat 
mailto:omer.ha...@outlook.com>> wrote:
Hi.
We have a 5% VAT charged on all bills and invoices. To the government, we pay 
the difference.
I have setup an 'Input VAT(paid to Vendor)' and 'Output VAT(received from 
Customers)' accounts under Liabilities, and set them up. These are recording 
the VAT paid & received from Bills/Invoices correctly. The Input VAT account 
has negative values, and output VAT has positive values. We are supposed to pay 
the difference of these.
For example:

VAT paid to Vendor
(50.00)
VAT received from Customer  75.00
FINAL VAT PAYABLE TO GOVT   25.00

Keeping the above example, I would like to pass one entry, and pay off the 
difference amount.
Example:
DR Final Payable to Govt
CR Bank
But, how can I pass the Debit entry? Should I create a 'Tax' placeholder 
account and pass it to that? But then the individual Input & Output VAT 
accounts might have a balance.

Please advise.
___
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] Inconsistency Between Balance of Stock Account and Display in Accounts, File Integrity Check

[rsbrux via gnucash-user]

1. My so-called discrepancy was an optical illusion, What I read as 
0.982352 shares was really 0 shares of (valora number) 982352. ;-}


2. I found the file check in the "Actions" menu, under "Check & Repair". ;-}

Boy, do I feel stupid!

On 16.08.20 11:47, rsbrux wrote:
ISTR that GC has a built-in file integrity checker, but I can no 
longer find out how to invoke it.


Perhaps the peculiarity mentioned below is caused by some 
inconsistency in the file.


Can someone please refresh my memory on how to perform a file 
integrity check?


On 13.08.20 19:31, rsbrux wrote:
I am still running GC 2.6.19 under Ubuntu Studio 18.04, but plan to 
update to Ubuntu Studio 20.04 soon and will then get a newer version 
of GC.


Meanwhile, I have a problem which I find very hard to understand:
I purchased 600 shares of a stock last year and sold them again this 
year.


When I open the ledger of the stock account, it displays the balance 
correctly as 0.


However, in the Accounts list, the stock account still shows a 
balance of 0.982352 shares


What could account for this discrepancy?

How likely is it that a newer version of GC will correct this 
misrepresentation?


Is there some way of troubleshooting it, or should I just hide the 
(now empty) account and forget about it?


Thanks for any advice!


___
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] Recording Tax Correctly

[Christopher Lam]

Hi Omer, my approach is:

   - VAT:Input VAT - an ASSET account
   - VAT:Output VAT- a LIABILITY account
   - VAT:VAT Return - an ASSET or LIABILITY account

and run the "Income & GST Statement" periodically, posting the govt returns
as follows:
Dr VAT:VAT Return
Cr Bank

HTH, C

On Sun, 16 Aug 2020 at 07:55, Omer Hayat  wrote:

> Hi.
> We have a 5% VAT charged on all bills and invoices. To the government, we
> pay the difference.
> I have setup an 'Input VAT(paid to Vendor)' and 'Output VAT(received from
> Customers)' accounts under Liabilities, and set them up. These are
> recording the VAT paid & received from Bills/Invoices correctly. The Input
> VAT account has negative values, and output VAT has positive values. We are
> supposed to pay the difference of these.
> For example:
>
> VAT paid to Vendor
> (50.00)
> VAT received from Customer  75.00
> FINAL VAT PAYABLE TO GOVT   25.00
>
> Keeping the above example, I would like to pass one entry, and pay off the
> difference amount.
> Example:
> DR Final Payable to Govt
> CR Bank
> But, how can I pass the Debit entry? Should I create a 'Tax' placeholder
> account and pass it to that? But then the individual Input & Output VAT
> accounts might have a balance.
>
> Please advise.
> ___
> 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] Inconsistency Between Balance of Stock Account and Display in Accounts, File Integrity Check

[rsbrux via gnucash-user]

ISTR that GC has a built-in file integrity checker, but I can no longer 
find out how to invoke it.


Perhaps the peculiarity mentioned below is caused by some inconsistency 
in the file.


Can someone please refresh my memory on how to perform a file integrity 
check?


On 13.08.20 19:31, rsbrux wrote:
I am still running GC 2.6.19 under Ubuntu Studio 18.04, but plan to 
update to Ubuntu Studio 20.04 soon and will then get a newer version 
of GC.


Meanwhile, I have a problem which I find very hard to understand:
I purchased 600 shares of a stock last year and sold them again this 
year.


When I open the ledger of the stock account, it displays the balance 
correctly as 0.


However, in the Accounts list, the stock account still shows a balance 
of 0.982352 shares


What could account for this discrepancy?

How likely is it that a newer version of GC will correct this 
misrepresentation?


Is there some way of troubleshooting it, or should I just hide the 
(now empty) account and forget about it?


Thanks for any advice!


___
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] Recording Tax Correctly

[Omer Hayat]

Hi.
We have a 5% VAT charged on all bills and invoices. To the government, we pay 
the difference.
I have setup an 'Input VAT(paid to Vendor)' and 'Output VAT(received from 
Customers)' accounts under Liabilities, and set them up. These are recording 
the VAT paid & received from Bills/Invoices correctly. The Input VAT account 
has negative values, and output VAT has positive values. We are supposed to pay 
the difference of these.
For example:

VAT paid to Vendor
(50.00)
VAT received from Customer  75.00
FINAL VAT PAYABLE TO GOVT   25.00

Keeping the above example, I would like to pass one entry, and pay off the 
difference amount.
Example:
DR Final Payable to Govt
CR Bank
But, how can I pass the Debit entry? Should I create a 'Tax' placeholder 
account and pass it to that? But then the individual Input & Output VAT 
accounts might have a balance.

Please advise.
___
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.