Re: [GNC] Help with Reports Please!

[Jean-David Beyer]

On 08/11/2018 02:22 PM, Diane Forrest wrote:
> Hello out there:  1) Am a former user of Quicken, finally "moved"  to try a
> new system.  2)  I have spent a huge amount of time getting acclimated to
> double-entry, importing QIF data, etc.  I finally feel like I get the
> system, even like the system, after ignoring my community for more than a
> week of vacation. 2) Am using what purports to be the recent, updated
> version:   *Version: 3.2  Build ID: 3.2+ (2018-06-24)  *
> 
> 3) MY ISSUE:   Imagine my (gulp) extreme disappointment to find that *after
> all that effort* ... cleaning up & entering about 7 months of Income,
> Expense, Liability, Asset Data... but for the life of me, I can't seem to
> get anything even close to a Quicken style cashflow report.

Does Reports->Income & Expense->Cashflow not do what you want?

Set the account(s), beginning and end date desired.

> What I used to
> do was print *monthly, numerical, income/expense reports*.  All those
> transactions nicely summed under all my expense subaccounts I could
> really tell what was going on.  I do not use (or even like) piecharts,
> scatterplots, or tables of little color bars.  I do not want Grand Account
> Totals (Jan to June), I want a table by month, for each Account, with it's
> sub-account "children" below it.

I get a report like this:

Cash Flow Operating - 2017-08-01 to 2018-07-31

Selected Accounts
Money into selected accounts comes from 
Gifts Received:ANONYMOUS$987.65
Gifts Received:PRIVATE:Beyer, Jean-David$1,234.56
[snip]
Other Income$1,357.00
Money In$25,046.67
Money out of selected accounts goes to  
Advancement $76.54
Assistance  $123.45
Bank Charge $97.65
[snip]
Utilities:Verizon   $543.21
Money Out   $25,699.83
Difference  -$653.16

> 
> 4) I really have studied various GNUcash documentation,  manuals, looked at
> a few videos,  searched on line.  I think I'm smart enough, been patient
> enough, I'm really working hard... but to what end?  What on earth is the
> deal?  What am I missing here?  Is it the version I'm using, and if so, can
> someone tell me what to do, please.  Thx in advance,   DF

More difficult, but more flexible, might be a Transaction Report and a
lot of fiddling with the Sort option.


-- 
  .~.  Jean-David Beyer  Registered Linux User 85642.
  /V\  PGP-Key:166D840A 0C610C8B Registered Machine  1935521.
 /( )\ Shrewsbury, New Jerseyhttp://linuxcounter.net
 ^^-^^ 21:50:01 up 31 days, 21:40, 3 users, load average: 4.67, 4.34, 4.22
___
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

[Shokster]

Thanks John. I'm not using currency exchanges, so is there a way to suppress
the currency update part of F::Q, and just use the Mutual funds update.
Also, I was hoping, that even though the currency update fails, the mutual
fund updates might still go through ok, but obviously not. Ok, so now off to
get an alpha vantage key... 
 
 

John Ralls-2 wrote
>> On Aug 10, 2018, at 9:16 AM, Shokster 

> ashok.sinha@

>  wrote:
>> 
>> 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. 
>> http://gnucash.1415818.n4.nabble.com/file/t308877/security_editor.jpg;
>>  
>> 
>> 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: 
>> http://gnucash.1415818.n4.nabble.com/file/t308877/console.jpg; 
>> 
>> 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. 
> 
> The shift to Alphavantage *is* relevant in this case because it’s now
> where F::Q gets currency exchange rates, replacing the no-longer-available
> Yahoo! service.
> 
> Regards,
> John Ralls
> 
> ___
> gnucash-user mailing list

> gnucash-user@

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





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

[GNC] Help with Reports Please!

[Diane Forrest]

Hello out there:  1) Am a former user of Quicken, finally "moved"  to try a
new system.  2)  I have spent a huge amount of time getting acclimated to
double-entry, importing QIF data, etc.  I finally feel like I get the
system, even like the system, after ignoring my community for more than a
week of vacation. 2) Am using what purports to be the recent, updated
version:   *Version: 3.2  Build ID: 3.2+ (2018-06-24)  *

3) MY ISSUE:   Imagine my (gulp) extreme disappointment to find that *after
all that effort* ... cleaning up & entering about 7 months of Income,
Expense, Liability, Asset Data... but for the life of me, I can't seem to
get anything even close to a Quicken style cashflow report. What I used to
do was print *monthly, numerical, income/expense reports*.  All those
transactions nicely summed under all my expense subaccounts I could
really tell what was going on.  I do not use (or even like) piecharts,
scatterplots, or tables of little color bars.  I do not want Grand Account
Totals (Jan to June), I want a table by month, for each Account, with it's
sub-account "children" below it.

4) I really have studied various GNUcash documentation,  manuals, looked at
a few videos,  searched on line.  I think I'm smart enough, been patient
enough, I'm really working hard... but to what end?  What on earth is the
deal?  What am I missing here?  Is it the version I'm using, and if so, can
someone tell me what to do, please.  Thx in advance,   DF
___
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] Production of UK VAT reports

[David Cousens]

Edward,

This is probably worth a new feature request in the bug reports  as VAT/GST
now applies in many jurisdictions. It may take some time for someone to
tackle the problem. It would require an additional flag on each transaction
which may involve considerable recoding.

One possibility for a short term workaroundwould be to use the reconciled
flag on your tax accounts to signal whether or not the tax has been included
in previous returns or not. You would not normally reconcile your tax
accounts against any external statement.  The trick would be fiddling the
starting and end balances when you run the reconcile procedure as you will
not have an end balance from a statement. The starting balance will be
determined by the transactions you have reconciled and the end balance can
be edited from the main reconcile window while you are doing a
reconciliation.  transactions from previous periods and future periods which
have not been reconciled do show up in the reconciliation window so thay are
accessible to mark. I would put a note in the memo flagging any transactions
which were not included in the return for the period they are posted in
indicating which return they were corrected in

This would at least give you a process to mark transactions. You can then
open the transactions from the tax account registers and determine the
amounts for the corrections to your return from the splits for each
transaction. You would then rerun the reconciliation on your VAT accunts to
flag these transactions once you have included them.

OK if you only have a relatively small number of rogue transactions each
reporting period, but not if you have a high turnoverand a significant
number.

David




-
David Cousens
--
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] Reconciliation Report

[Mike stagl]

That was my suspicion.  I am trying to print reports for archiving to show that 
our account was reconciled to the prior month's bank statement.


I am able to show what I need to show in the Reconciliation Report, I was just 
hoping to be able to remove the transactions after the first of the current 
month as they are not needed for my purposes.


Thanks for the help!


Mike



From: Christopher Lam 
Sent: Friday, August 10, 2018 12:19 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Reconciliation Report

The reconcile report 'date' selection applies to the 'reconcile date',
so any reconciled transaction whose reconcile-date falls between
start-date and end-date is included. I think this behaviour applies from
3.2 onwards.

Any unreconciled transactions are also included. The reasoning was that
any unreconciled transactions were deemed likely to be useful in a
reconciliation report. This also roughly matches the behaviour of the
formal reconcile tool -- it lists any cleared or unreconciled
transactions (income on left, expense on right), ready for ticking prior
to clicking 'Finalise'.


On 11/08/18 01:04, Mike stagl wrote:
> Sorry, I forgot the basics.  GnuCash 3.2 on Windows 7.
>
>
> I've attached a screenshot as well.
>
> Thanks in advance!
>
>
> Mike
>
> 
> From: David Carlson 
> Sent: Friday, August 10, 2018 11:23 AM
> To: Mike stagl
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Reconciliation Report
>
> Which version of GnuCash are you using and which OS?
>
> On Fri, Aug 10, 2018 at 8:59 AM, Mike stagl 
> mailto:m_st...@hotmail.com>> wrote:
> When running a stock reconciliation report, I cannot get the Start Date and 
> End Date to work correctly.  If I choose Start of Previous Month and End of 
> Previous Month, or even use actual dates, I get transactions from the start 
> date all the way to the current date.
>
>
> This month I am seeing un-reconciled transactions from August, when I am 
> running a report with the dates 7/1/2018 to 7/31/2018.
>
>
> For what it's worth, other reports appear to correctly implement the date.
>
>
> Thanks for any help,
>
>
> 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
gnucash-user Info Page
lists.gnucash.org
This (occasionally high-volume) mailing list is devoted to the discussion of 
general accounting topics as well as how to use GnuCash to implement specific


> 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] Get Quote is Not Working?

[David Carlson]

Not quite... If you have a sacrificial computer such as a Virtualbox
machine, try release 3.2 on it first, along with a test copy of your data
file.  Then, if you do not like the results you have not corrupted your
main machine.

Before installing 3.2 on a Windows machine, I would suggest making a backup
of all the configuration files including the F:Q related stuff if you use
it before migrating.  Once a computer has had GnuCash 3.2 installed on it
it is changed as well as any data file that has been opened by it.  Then to
revert you would need to completely remove release 3.2 using the Windows
uninstaller (in my conservative opinion) and install release 2.6.21 to be
able to read files that release 3.2 touched.

On a another side note, I use a free third party program to track my
portfolios in nearly real-time.  If you are interested, Google 'Takestock2'
for more info.


David C

On Sat, Aug 11, 2018 at 3:16 PM, samsurd2  wrote:

> I'm finding myself going down a similar rabbit hole. After editing my funds
> (38 in all) to reflect yahoo_json as had been suggested elsewhere, I still
> couldn't get any quotes. I removed Strawberry Perl using both Windows
> Control Panel and File Explorer and then, for good measure, did a Registry
> scrub using a utility I've used successfully for years. I then reinstalled
> Strawberry Perl via the "Install Online Price Retrieval" utility which in
> turn installed F::Q 1.47 and tried once more to get quotes. Again, no
> success. This morning, I updated all items manually.
>
> Since I've read that GNC 3.2 has the ability to import quotes from a CSV
> file, I guess I'll try that now. I've been reluctant to install any 3.x
> version because of the bugs that a new major version of any program
> exhibits
> even though I know that the Gnucash developers do a good job of sorting out
> such things. At worst, I can always go back to the 2.6.16 version for which
> everything I use (except F::Q) works fine.
>
> Megagrumpy wrote
> > I am using GnuCash 2.6.18 and I am not sure what version of F:Q I was
> > using
> > but I reinstalled it a couple of days ago to ensure it was the latest
> > version. Still not getting any quotes at all. Have updated manually but
> at
> > more than 50 stocks that is quite arduous. It appears to me that the
> > suppliers of quotes are getting a bit more savvy that there is a
> potential
> > income stream that they could use. I already have on line accounts (Bank,
> > Broker, Stockopedia and Motley Fool) where I pay and where I can get
> > quotes
> > but I do not suppose there is anyway of linking to those accounts?
> >
> > Is there a possibility of importing quotes from an external file? I could
> > download my share data into Excel say, run a macro to strip out the date,
> > Share ID and quote and then import this into GC?
> >
> >
> >
> > --
> > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-
> f1415819.html
> > ___
> > gnucash-user mailing list
>
> > gnucash-user@
>
> > 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.
>
>
>
>
>
> --
> 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.

Re: [GNC] Get Quote is Not Working?

[samsurd2]

I'm finding myself going down a similar rabbit hole. After editing my funds
(38 in all) to reflect yahoo_json as had been suggested elsewhere, I still
couldn't get any quotes. I removed Strawberry Perl using both Windows
Control Panel and File Explorer and then, for good measure, did a Registry
scrub using a utility I've used successfully for years. I then reinstalled
Strawberry Perl via the "Install Online Price Retrieval" utility which in
turn installed F::Q 1.47 and tried once more to get quotes. Again, no
success. This morning, I updated all items manually.

Since I've read that GNC 3.2 has the ability to import quotes from a CSV
file, I guess I'll try that now. I've been reluctant to install any 3.x
version because of the bugs that a new major version of any program exhibits
even though I know that the Gnucash developers do a good job of sorting out
such things. At worst, I can always go back to the 2.6.16 version for which
everything I use (except F::Q) works fine.

Megagrumpy wrote
> I am using GnuCash 2.6.18 and I am not sure what version of F:Q I was
> using
> but I reinstalled it a couple of days ago to ensure it was the latest
> version. Still not getting any quotes at all. Have updated manually but at
> more than 50 stocks that is quite arduous. It appears to me that the
> suppliers of quotes are getting a bit more savvy that there is a potential
> income stream that they could use. I already have on line accounts (Bank,
> Broker, Stockopedia and Motley Fool) where I pay and where I can get
> quotes
> but I do not suppose there is anyway of linking to those accounts?
> 
> Is there a possibility of importing quotes from an external file? I could
> download my share data into Excel say, run a macro to strip out the date,
> Share ID and quote and then import this into GC?
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list

> gnucash-user@

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





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

[GNC] Associate file with transaction path

[Anthony Marrian]

So sorry: version 3.2

From: Anthony Marrian
Sent: 11 August 2018 11:23
To: 'gnucash-user@gnucash.org' 
Subject: Associate file with transaction path

The preference I've set under Edit / Preferences / General / Path Head for 
Transaction Associated Files is ignored. Any tips, please?

With best wishes - Anthony


___
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] Associate file with transaction path

[Anthony Marrian]

The preference I've set under Edit / Preferences / General / Path Head for 
Transaction Associated Files is ignored. Any tips, please?

With best wishes - Anthony


___
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] Get Quote is Not Working?

[Megagrumpy]

I am using GnuCash 2.6.18 and I am not sure what version of F:Q I was using
but I reinstalled it a couple of days ago to ensure it was the latest
version. Still not getting any quotes at all. Have updated manually but at
more than 50 stocks that is quite arduous. It appears to me that the
suppliers of quotes are getting a bit more savvy that there is a potential
income stream that they could use. I already have on line accounts (Bank,
Broker, Stockopedia and Motley Fool) where I pay and where I can get quotes
but I do not suppose there is anyway of linking to those accounts?

Is there a possibility of importing quotes from an external file? I could
download my share data into Excel say, run a macro to strip out the date,
Share ID and quote and then import this into GC?



--
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] Hidden accounts and balances

[Liz]

On Fri, 10 Aug 2018 10:21:34 -0500
Bridgit Griffin  wrote:

> For sanity's sake I imported the Quicken file into another financial 
> program and the results were similar to what is in Quicken. There
> were many many more accounts that are closed (aka zeroed balances)
> that GNUcash was reporting differently. And if the account had a
> balance when I selected closed in the new software that account was
> removed from the balances. I think it is in the importing process
> that causes many issues as categories and certain transactions were
> broken out into their own accounts. Looking like I'll forgo GNUCash
> for now. Thank you for all the input.


Just to think more deeply about this

There are some things in Quicken-type accounting which are apparently
balanced but are not in true double entry accounting (yes, I did use
Quicken once)

There are things which are difficult to sort out after an import
Small incremental imports and data correction from the source
may be needed

If you have used a work-around (in this example hiding a joint account
balance when circumstances changed, rather than making an entry to
close the account) everything will be laid bare when you go to double
entry accounting.

Lastly
Professional advice on how to set up your books and how to handle odd
situations (like the example above) can often save a lot of your own
time. To me, with an income, it is worthwhile paying for such advice.

Liz
___
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] Production of UK VAT reports

[Maf. King]

On Friday, 10 August 2018 12:27:12 BST Edacc wrote:
> Hi,
> 
> There is documentation on employing a Gnuash account hierarchy to produce
> special purpose gl codes for VAT, and that is extremely helpful. I can see
> that a report could be then run against them to produce the numbers to go
> into the various boxes of the return and first time round the return can be
> filtered by 'before the cut off date' so transactions belonging to a future
> quarter are not included.
> 
> Next time the VAT report is required for the following period the 'before
> date' filter stops me including post date transactions again, but how do I
> not include transactions dated within the prior period, but not included in
> the prior return?
> 
> This is a common situation, especially with input transactions which can get
> 'temporarily lost' and are posted to the books after preparation of a
> period's VAT return although they are dated within that period. The proper
> thing to do is then to include them in the next VAT return, and because
> they are inputs there is no cashflow loss to HMRC so no hassle.
> 
> Other computerised and paper systems I have seen have a mechanism to also
> mark all transactions included in a VAT report and form with either a simple
> 'VAT done' flag, or an identifier for the specific VAT period return the
> transaction has been reported on. I am struggling to find anything
> equivalent to this in GnuCash (and there is so much other real good stuff).
> 
> Similar considerations would apply to UK HMRC NRLT, CIS, IPT, MGD and many
> other statutory schemes both in relation to the taxes due/deductible and
> total inputs and outputs. In regards the VAT I am thinking about the
> standard arrangement, not cash accounting or fixed payment on account VAT
> arrangements.
> 
> If VAT returns are being done with GNUCash I am presuming there is a simple
> answer.
> 
> Many thanks
> 

Hi Edward.

I have been through exactly your scenario - completed the VAT return upto the 
end of jusn (file during july)  only to have a (copy) Vendor Bill arrive due to 
being "lost in the post" and well over a month late.

I handle this by recording the bill on the date it arrives and put notes both 
on the paper copy and the GC transaction to explain the discrepancy  between 
the official tax date the date of record.  I'll also pay it promptly rather 
than 
30 days or whatever from the posting date.

the VAT is then picked up in the following quarter return correctly.  I also 
compare the reports box 1 & 4 numbers with what the actual GC account say 
should be due on the end of each quarter.

I hasten to add that this is only a very occasional thing for me, and while 
not strictly following the rules, all the due tax is paid (eventually...).  
Having been inspected, HMRC seem understanding of the real world not quite 
meeting their rule book, and as long as there is an explanation and no tax 
owing it seems to me that you get little more than a "don't do it again" 
warning.

Maf.





___
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] Hidden accounts and balances

[David Cousens]

Bridgit,

The hidden feature in GnuCash simply means that the account will not be
visible in the Account Tree (and any popup selection menus ? - see below),
not that the account is inactive, and not in use at all and is effectively
removed from the account tree.

A hidden account can still have transactions which target the account, its
balance still sums into any parent accounts. It is primarily a convenience
to simplify the account tree presentation and selection popups. This is an
exerpt from the help manual on creating accounts
https://www.gnucash.org/docs/v3/C/gnucash-help/acct-create.html

"The Placeholder check-box sets an account to read-only status and prevents
the addition of transaction data to the account.

Note
Setting an account to Placeholder will also hide that account in the pop-up
account list in a register. Sub-accounts to the placeholder account will
still display in the pop-up, however.

The Hidden check box hides an account (and any sub-accounts) in the account
tree. To reset this option, you will first need to open the View → Filter
By... dialog for the account tree and check the Show hidden accounts option.
Doing so will allow you to select the account and reopen this dialog.

Note
Hidden accounts still appear in the pop-up account list in a register. To
remove an account from this pop-up account list as well, check the
Placeholder check box."

It is also worth noting here that an account which has transactions into it
can be set as a placeholder, i.e. readonly and the existing transactions can
remain, it still has a balance associated with those transactions and
itsbalance should also include the sum of any child accounts as well as any
transactions to the placeholder itself.

If you want to remove an account from the account tree completely the Delete
Account option in the popup menu which appears when you right click on an
account in the account tree presents you with a dialog which will transfer
the transactions in the account to another specified account before deleting
the account.

David Cousens




-
David Cousens
--
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] Production of UK VAT reports

[Christopher Lam]

The simple answer is there is no 'VAT-done' flag. You'd either book the 
VAT-able transaction using posted-date, or not... If a transaction is 
booked in error and already processed/reported to authorities, then do 
another reversing transaction (IMHO; if the accountant agrees) at a 
later date.



On 10/08/18 19:27, Edacc wrote:

Hi,

There is documentation on employing a Gnuash account hierarchy to produce
special purpose gl codes for VAT, and that is extremely helpful. I can see
that a report could be then run against them to produce the numbers to go
into the various boxes of the return and first time round the return can be
filtered by 'before the cut off date' so transactions belonging to a future
quarter are not included.

Next time the VAT report is required for the following period the 'before
date' filter stops me including post date transactions again, but how do I
not include transactions dated within the prior period, but not included in
the prior return?

This is a common situation, especially with input transactions which can get
'temporarily lost' and are posted to the books after preparation of a
period's VAT return although they are dated within that period. The proper
thing to do is then to include them in the next VAT return, and because they
are inputs there is no cashflow loss to HMRC so no hassle.

Other computerised and paper systems I have seen have a mechanism to also
mark all transactions included in a VAT report and form with either a simple
'VAT done' flag, or an identifier for the specific VAT period return the
transaction has been reported on. I am struggling to find anything
equivalent to this in GnuCash (and there is so much other real good stuff).

Similar considerations would apply to UK HMRC NRLT, CIS, IPT, MGD and many
other statutory schemes both in relation to the taxes due/deductible and
total inputs and outputs. In regards the VAT I am thinking about the
standard arrangement, not cash accounting or fixed payment on account VAT
arrangements.

If VAT returns are being done with GNUCash I am presuming there is a simple
answer.

Many thanks



___
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

[Shokster]

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. 



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

[GNC] Production of UK VAT reports

[Edacc]

Hi,

There is documentation on employing a Gnuash account hierarchy to produce
special purpose gl codes for VAT, and that is extremely helpful. I can see
that a report could be then run against them to produce the numbers to go
into the various boxes of the return and first time round the return can be
filtered by 'before the cut off date' so transactions belonging to a future
quarter are not included.

Next time the VAT report is required for the following period the 'before
date' filter stops me including post date transactions again, but how do I
not include transactions dated within the prior period, but not included in
the prior return?

This is a common situation, especially with input transactions which can get
'temporarily lost' and are posted to the books after preparation of a
period's VAT return although they are dated within that period. The proper
thing to do is then to include them in the next VAT return, and because they
are inputs there is no cashflow loss to HMRC so no hassle.

Other computerised and paper systems I have seen have a mechanism to also
mark all transactions included in a VAT report and form with either a simple
'VAT done' flag, or an identifier for the specific VAT period return the
transaction has been reported on. I am struggling to find anything
equivalent to this in GnuCash (and there is so much other real good stuff).

Similar considerations would apply to UK HMRC NRLT, CIS, IPT, MGD and many
other statutory schemes both in relation to the taxes due/deductible and
total inputs and outputs. In regards the VAT I am thinking about the
standard arrangement, not cash accounting or fixed payment on account VAT
arrangements.

If VAT returns are being done with GNUCash I am presuming there is a simple
answer.

Many thanks



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