Re: Error in Tip of the Day

2017-12-15 Thread Daniel Narvaes
On Fri, 2017-12-15 at 09:36 +0100, Geert Janssens wrote:
> Op zondag 10 december 2017 22:26:40 CET schreef Daniel Narvaes:
> > 
> > I've been using gnucash for a long time, and I usually read the tip
> > of the
> > day, and try it if I have not seen it before.  Today it said "To
> > switch
> > between multiple tabs in the main window, press Control+Page
> > Up/Down."  I
> > tried it and it didn't work.  After browsing the users mailing
> > list, I
> > found out the correct key combination is "Ctrl+Alt+Page Up/Down."
> > 
> > I'm using gnucash 2.6.12 on Ubuntu 14.04 LTS.  Can someone check
> > and see if
> > the description is still wrong on the latest version?  If so, I'll
> > file a
> > bug report, unless you want to do that for me too.  I would still
> > have to
> > create an account on Bugzilla to make a bug report.
> > ___
> > 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.
> You are correct it should be "Ctrl-Alt-Page Up/Down". That's how it
> works on 
> the current stable version (2.6.18) as well.
> 
> On the current development version this appears to be broken. It will
> only 
> work if a notebook tab is clicked on first (which is defeating the
> initial 
> idea). And it breaks down on report pages.
> 
> Please do file a bug report and feel free to quote my findings as
> well.
> 
> Thanks,
> 
> Geert
> 
So, I created an account on Bugzilla, and when I started typing a
description of the bug, it referred me to similar bug reports.  It
turns out there are already a couple of bug reports on this issue,
one of which is over ten years old!

Can you take a look and see if you think there is anything else that
needs to be added to the existing bug reports?
https://bugzilla.gnome.org/show_bug.cgi?id=647744
https://bugzilla.gnome.org/show_bug.cgi?id=450717

-Daniel
___
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: A BASH script to help get tax-related data from gnucash

2017-12-15 Thread azalea4va
GnuCash - User mailing list wrote
> If you have set the accounts as tax-related, why wouldn't you use the Tax
> Schedule Report?  

I thought I addressed that in my post when I said "I find the provided "Tax
Schedule Report" as being les than ideal in its presentation of the
information I seek."

Look at the attached screenshot where I have side-by-side the portions of
the two reports information about "Tax Prep" expenses,  tax-prep.png
  .  The Tax
Schedule report has 4 lines vs 1 in the Income Statement and the Tax
Schedule is almost twice as wide.  They convey the same USEFUL information
but the Tax Schedule takes almost 8 times the space.  Additionally, there is
the "noise" of other info on the Tax Schedule that intereferes with easily
accessing the info I want.  Please understand that this example is just
showing one data item, so the "noise" is not a major issue.  But when one
looks at the entire report with hundreds of lines of output (most of it
noise), then the noise really gets in the way. Yes the tax Schedule also
gives the line number on the tax form.  But that is useless info for me.  I
use tax prep software so I am not dealing with line numbers in forms.  But
also, it is not a number I can rely on as depending on the version of
gnucash and the tax year, that number will not always be accurate. 

In addition, because of the lack of noise in the Income Statement, it is
easy to copy/paste the tax-related data into a spreadsheet (or whatever).
Yes, getting info out of gnucash for use in other things is something of
value to me. For example, in a spreadsheet where I have an added column that
tracks if a data item will have a tax form being sent to me and if that form
has been received or not. The spreadsheet makes it easy to keep track of
cross checking received form data with data in gnucash and data entered into
the tax return itself.

So for those reasons, I find the Income Statement format more useful.  I am
not saying the Income Statement is "better" for everyone, just that I find
it a useful alternative. Your mileage may vary.  I offer the tool for anyone
who finds it of value.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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: Invoice & Bill Posting Date Issues Across Multiple Periods

2017-12-15 Thread Mike or Penny Novack
I have zero experience with gnucash's invoicing system. Nevertheless I 
think in this conversation dates may be confused. When I receive an 
invoice, say for a visit to the doctor, there are SEVERAL dates involved.


a) The date the service was performed.
b) The effective date of the invoice prepared by the doctor's billing 
service.

c) The real time date when the invoice was prepared by the billing service

Which of these dates are we talking about? And from the doctor's point 
of view, which of these dates (were we using gnucash) would be used for 
the date of the transaction? << when affecting AR >>


When people are talking about periods being crossed "when work done" vs 
"when invoice prepared" I wonder whether all are talking about the same 
date. And if gnucash IS using the real time date when somebody gets 
around to entering data, there may be a different sort of problem.


Michael D Novack
___
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: Invoice & Bill Posting Date Issues Across Multiple Periods

2017-12-15 Thread Adrien Monteleone
Thanks Dale,

That’s a very good down-to-earth point.

While I understand not getting lost in the fog of battle of "accuracy for 
accuracy’s sake” I also don’t like ending up in situations where I have to 
revisit or lookup historical information and have to remember “oh yeah, this or 
that figure isn’t right because of some bug, glitch, or workaround.”

Also, for budgeting considerations, I want to avoid unnecessary fluctuations 
for income and expenses particularly. Trying to match up my billable hours vs. 
my expenses can be a mess if everything doesn’t fall where it is supposed to. 
That’s a clear case of needing this for financial decisions. I need to 
continually keep an eye on whether or not my billing rates are sufficient to 
cover those expenses, or the expenses are exceeding what should be a reasonable 
level to earn a particular amount of revenue.

Certainly, if this were being done on paper and computers were not available, 
I’d have to make many a correcting entry. But we do have computers and I’m 
entering in all the relevant data. I just noticed that it isn’t all being used, 
the result of which requires correcting entries that wouldn’t otherwise need 
correcting. My view is that a correcting entry should only be needed because I 
didn’t have the relevant information the first time, not because of some 
limitation of the entry or recording system. Accrual entries are different and 
can’t be avoided, in fact, should be embraced and are necessary with accrual 
based accounting. But if at all possible, they should also be automatic if all 
the relevant info has already been provided.

So as I noted in another reply just now, my approach at least for the pre-paid 
expense issue will be to use my OS calendar reminders and post the transactions 
manually outside of the business features. This has a cost of not getting this 
‘due’ reminder in the same context as the others (in GnuCash) and the 
transactions not being visible on a vendor report, or even discoverable with 
the business features at all, but my accounts will not contain errors or 
require corrections. My balance sheets will not have inflated AP or Asset 
levels.

For the question of ‘job-based’ invoicing, I’ll have to employ the use of a 
‘un-billed work’ revenue account.

For the question of multi-period bills, I’m not sure yet. I guess I’ll have to 
make accrual entries on a case-by-case basis and see how it goes.

Regards,
Adrien

> On Dec 15, 2017, at 12:45 PM, Dale Alspach  wrote:
> 
> Adrien,
> I suggest that you may need to shift your point of view in order to resolve
> this.
> Disclaimer: I am not an accountant.,
> 
> My experience has been that you should not lose sight of the primary
> purpose of an accounting system: It is there to provide the information you
> need to make financial decisions. GAAP, satisfying taxing authorities,
> surviving audits, etc. are secondary.
> 
> Why do you want this prepaid expense to show in your reports? Is it a net
> worth issue? An underlying cash flow issue? Something else?
> 
> When is it important that it show in your balance sheet or other report?
> When is it important to show the obligation to pay the bill when it arrives?
> 
> The answers to these questions should help you determine what you really
> need. Then look for an implementation that satisfies these primary
> conditions and does not cause secondary problems.
> 
> Dale
> 
> On Dec 15, 2017 11:23 AM, "John Ralls"  wrote:
> 
>> 
>> 
>>> On Dec 15, 2017, at 7:51 AM, Derek Atkins  wrote:
>>> 
>>> Adrien,
>>> 
>>> Adrien Monteleone  writes:
>>> 
 Sorry, allow me to rephrase, when do I acquire the pre-paid expense
>> ASSET?
>>> 
>>> Can you please explain what you mean by a "pre-paid expense asset"?  Is
>>> it an Expense?  Or is it an Asset?
>>> 
>>> Could you give a concrete example of something that is a "pre-paid
>>> expense asset"?
>>> 
>>> Sorry for being dense, but I still don't grok what you're trying to do
>>> or how this is mapping into a real-world transaction.
>> 
>> Suppose you have an insurance policy that lets you either pay monthly or
>> for a whole year, with the latter getting a 10% discount, and that even if
>> you pay for the whole year you can cancel and get a pro-rata refund. The
>> annual pre-payment is booked as an asset called "pre-paid expense". Each
>> month you credit 1/12 of the annual payment to expenses:insurance. If 3
>> months in you cancel the policy, the refund creates a transfer transaction
>> back to the bank account.
>> 
>> 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.
>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-

Re: Invoice & Bill Posting Date Issues Across Multiple Periods

2017-12-15 Thread Adrien Monteleone
Yes, I can explain. And the example of insurance is just that. A pre-paid 
expense IS an asset. (in accrual accounting)

I pay in advance for auto insurance. The policy renews every 6 months. (for me, 
this is in December and June)

Paying in advance is a pre-paid expense. This is an asset. I have not yet 
received ‘service’ from the insurance company.

Here’s what the entry should be twice a year:

Dr. Assets:Current_Assets:Pre-Paid_Expenses:Auto_Insurance
Cr. Assets:Current_Assets:Cash

As I receive ‘service’ each month, or ‘use’ the asset, I credit the pre-paid 
expense account and debit the actual expense account for one-sixth of the asset 
(as this is a 6-month policy):

Dr. Expenses:Auto:Auto_Insurance
Cr. Assets:Current_Assets:Pre-Paid_Expenses:Auto_Insurance

The original question was trying to resolve the issue of posting the bill from 
the insurer for each renewal and how that affects recognition of the 
acquisition of the pre-paid expense asset.

My current entry from the bill is:

Dr. Assets:Current_Assets:Pre-Paid_Expenses:Auto_Insurance
Cr. Liabilities:Accounts_Payable

and then when I pay it:

Dr. Liabilities:Accounts_Payable
Cr. Assets:Current_Assets:Cash

Technically, legally, I don’t have this asset until I actually pre-pay. The 
generation of a paper bill from the insurer is not an activity that either is 
the earning of income on their part, the incurring of an expense on mine, or 
even the assumption of a liability on the part of either of us. If I decline to 
pay the bill, the policy never goes into effect, I never receive anything of 
value and the insurer earns nothing, owes me nothing, and has no claim against 
me. (I don’t owe them anything)

Posting the bill on any date other than the actual payment date creates the 
problem of properly recognizing the asset. This is even more problematic if the 
bill for renewal is received and posted into GnuCash in the period prior to the 
renewal and payment date. (frequently the case - the bill usually arrives in 
mid November/May)

Note, I can’t find any guidance online on posting a ‘bill' for pre-paid 
insurance. ALL examples I find state to make the above entry—effective on the 
date of payment. I suspect this is because it is a shift in assets that cannot 
occur until it actually does. This is not a cash vs. accrual problem. The very 
use of the pre-paid expense account is a practice of accrual accounting and NOT 
cash basis accounting. (on a cash basis, the entire premium would be expensed 
when paid)

Accrual vs. Cash doesn’t mean "document-dates vs. payment-dates." It means 
"activity-dates vs. payment-dates.”

In fact, I see very little guidance with reference to the receipt of bills or 
issuing of invoices. What I see is how to make entries for when the relevant 
activity trigger takes place. (an expense is incurred or revenue is earned)

In the case of a pre-paid expense, (a deferred expense) the activity takes 
place in later periods than the payment date. So the expense has to be accrued 
as it is incurred. In the case of an accrued expense (the opposite) the expense 
is recognized when incurred, and is booked as a liability until paid.

It seems the business features only contemplated accrued expenses. (and 
conversely on the invoice side, did not consider un-billed work)

So posting this bill shouldn’t even be a liability, it’s not an accrued 
expense, it’s a deferred expense. It should never hit AP but I can’t see anyway 
around that the way the system presently works.

A complication is that the Bills Due Reminder feature only works on posted 
bills because that is when you enter the due date.(it can’t calculate anything 
without it, unless you have fixed terms, but even with that, unless you post, 
the reminder will not be triggered)

It would be nice to enter the bill when received in GnuCash and have it show up 
on the Bills Due Reminder, but that seems impossible in this case. I can 
certainly enter the bill when received, but I can’t post it till I pay it or 
else my assets will shift too soon.

I suppose I could bypass the business features all together, but then I don’t 
get the benefit of a bill reminder, or an easy to follow history with that 
vendor. (manual transactions won’t show up on the vendor report)

I’ve decided on this approach for now:

Set a reminder in my OS calendar to enter and post the bill as a manual 
transaction when I actually pay it.

This means I can’t see this transaction on a vendor report and I can’t see my 
‘due dates’ all in one place - GnuCash.

However, my AP won’t have an erroneous entry and my assets won’t be inflated in 
November and May of each year.

Regards,
Adrien

> On Dec 15, 2017, at 9:51 AM, Derek Atkins  wrote:
> 
> Adrien,
> 
> Adrien Monteleone  writes:
> 
>> Sorry, allow me to rephrase, when do I acquire the pre-paid expense ASSET?
> 
> Can you please explain what you mean by a "pre-paid expense asset"?  Is
> it an Expense?  Or is it an Asset?
> 
> Could you give a concrete

Re: Invoice & Bill Posting Date Issues Across Multiple Periods

2017-12-15 Thread Adrien Monteleone


> On Dec 13, 2017, at 9:16 AM, Derek Atkins  wrote:
> 
> Adrien Monteleone  writes:
> 
>> Thank you Derek,
>> 
>> The inefficiency I referenced was in respect to having to make many
>> accrual entries at the end and beginning of each month simply to shift
>> the recognition of parts of invoices and bills to their proper periods
>> that otherwise would not have to be done if the posting process
>> allowed for using the line-item dates. As it stands, using a single
>> posting date for a bill/invoice that either crosses periods or
>> contains multiple periods results in incorrect recognition. This is
>> what I mean by a carryover limitation of paper ledgers. That practice
>> was necessary with paper. It is not with computers. (at least I don’t
>> see that it is, of course, if you *want* to make all those entries
>> manually, by all means… )
> 
> The design is such that a single invoice is not supposed to cross period
> boundaries.  If you find you are invoicing your customers across
> periods, that implies (to me) that you don't invoice often enough (or
> your periods are way too short).  Making new invoices (at least one per
> period) is rather cheap, so I recommend you do that ;)

This happens for me more with bills than invoices, but with invoicing customers 
it means not being able to invoice by ‘job’ and instead having to invoice by 
period. (otherwise, using a ‘non-billed work’ account to match against income, 
thus more unnecessary correcting entries)
> 
> It's certainly true that the invoice posting and payments could occur in
> different boundaries -- which revert back to the cash v accrual
> accounting question.  In accrual accounting that disparity is fine.

Yes, that disparity is fine and certainly with single-period expenses, there is 
no issue. The issue is with multi-period expenses on one bill. The limitations 
of ‘paper’ require correcting entries. But this seems unnecessary to me with 
computers. That limitation doesn’t seem to be in keeping with any accounting 
principle but rather appears artificial based on trying to mimic paper entry.

> 
> Oh, and in terms of a vendor bill, in my mind the period is when I
> receive the bill.  If someone did work for me in December and doesn't
> bill me until February, I'm booking it in February.

That would violate the recognition principle. You’re recognizing expenses in a 
period other than when they were actually incurred. If you invoice in February 
for work done in December and don’t post the income till February, you are 
recognizing that in the wrong period as well. Expenses and income will never be 
matched - violating the matching principle.

> 
>> I’m not asking for the business features to work on a cash basis. I’m
>> wanting them to not cause me to have to make multiple correcting
>> entries for proper expense and revenue recognition. I’m not concerned
>> with recognizing bills/invoices when the money changes hands. I’m
>> concerned with recognizing them when the expense is incurred or the
>> work performed. This works perfectly if everything is tidy in one
>> period. It’s a mess if the ‘document' is not.
> 
> If it's your own invoicing, then just invoice more often.

Generating paper isn’t a determinate of when income is earned. When I invoice 
it should be irrelevant to that question. Though I suppose for now I’ll have to 
take the above outlined approach of a non-billed work intermediary account.
> 
> If it's a vendor bill, then treat it as a single transaction regardless
> of when they did the work... Or enter it as multiple related vendor
> bills.
And therein lies the unnecessary extra entries. Either I create multiple bills 
when there is really only one, or I create one and have to make accrual entries 
moving amounts between periods - all when the data is known and already entered 
into GnuCash, just not being used.

> 
>> Perhaps I’m misunderstanding something that you or someone else could
>> help clear up for me. Let’s take a simpler example of a single period
>> bill:
>> 
>> I receive local telephone service in October. The phone company
>> generates a bill for that October service on November 7th. It arrives
>> (postmarked) November 12th. I enter it in GnuCash the same day. The
>> due date is November 27th.
>> 
>> What should my posting date be?
>> 
>> 1) November 7th?
>> 2) November 12th?
>> 2) November 27th?
>> 3) some date in October? (31st perhaps)
>> 4) something else?
> 
> Nov 12.  That's when you received the bill and posted it to your account.
But then the expense gets recognized in November. This is not when I incurred 
it. (which was October)

> 
>> What should the ‘opening date’ be?
>> 
>> 1) November 7th?
>> 2) November 12th?
>> 3) something else?
>> 4) If I enter the bill on November 13th, is *that* the opening date?
>> 
>> I guess I’m thinking the ‘opening date’ must preceded the posting
>> date, but I suppose that doesn’t matter. (maybe that’s me carrying
>> over from paper here)
> 
> The opening date would be N

Re: Invoice & Bill Posting Date Issues Across Multiple Periods

2017-12-15 Thread Dale Alspach
Adrien,
I suggest that you may need to shift your point of view in order to resolve
this.
Disclaimer: I am not an accountant.,

My experience has been that you should not lose sight of the primary
purpose of an accounting system: It is there to provide the information you
need to make financial decisions. GAAP, satisfying taxing authorities,
surviving audits, etc. are secondary.

Why do you want this prepaid expense to show in your reports? Is it a net
worth issue? An underlying cash flow issue? Something else?

When is it important that it show in your balance sheet or other report?
When is it important to show the obligation to pay the bill when it arrives?

The answers to these questions should help you determine what you really
need. Then look for an implementation that satisfies these primary
conditions and does not cause secondary problems.

Dale

On Dec 15, 2017 11:23 AM, "John Ralls"  wrote:

>
>
> > On Dec 15, 2017, at 7:51 AM, Derek Atkins  wrote:
> >
> > Adrien,
> >
> > Adrien Monteleone  writes:
> >
> >> Sorry, allow me to rephrase, when do I acquire the pre-paid expense
> ASSET?
> >
> > Can you please explain what you mean by a "pre-paid expense asset"?  Is
> > it an Expense?  Or is it an Asset?
> >
> > Could you give a concrete example of something that is a "pre-paid
> > expense asset"?
> >
> > Sorry for being dense, but I still don't grok what you're trying to do
> > or how this is mapping into a real-world transaction.
>
> Suppose you have an insurance policy that lets you either pay monthly or
> for a whole year, with the latter getting a 10% discount, and that even if
> you pay for the whole year you can cancel and get a pro-rata refund. The
> annual pre-payment is booked as an asset called "pre-paid expense". Each
> month you credit 1/12 of the annual payment to expenses:insurance. If 3
> months in you cancel the policy, the refund creates a transfer transaction
> back to the bank account.
>
> 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.
>
___
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: Invoice & Bill Posting Date Issues Across Multiple Periods

2017-12-15 Thread John Ralls


> On Dec 15, 2017, at 7:51 AM, Derek Atkins  wrote:
> 
> Adrien,
> 
> Adrien Monteleone  writes:
> 
>> Sorry, allow me to rephrase, when do I acquire the pre-paid expense ASSET?
> 
> Can you please explain what you mean by a "pre-paid expense asset"?  Is
> it an Expense?  Or is it an Asset?
> 
> Could you give a concrete example of something that is a "pre-paid
> expense asset"?
> 
> Sorry for being dense, but I still don't grok what you're trying to do
> or how this is mapping into a real-world transaction.

Suppose you have an insurance policy that lets you either pay monthly or for a 
whole year, with the latter getting a 10% discount, and that even if you pay 
for the whole year you can cancel and get a pro-rata refund. The annual 
pre-payment is booked as an asset called "pre-paid expense". Each month you 
credit 1/12 of the annual payment to expenses:insurance. If 3 months in you 
cancel the policy, the refund creates a transfer transaction back to the bank 
account.

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: New User to GnuCash

2017-12-15 Thread Jack Slater
Thanks Derek! That's a big help!  Reading thru the documentation is
today/weekend to do list!

On Fri, Dec 15, 2017 at 9:46 AM, Derek Atkins  wrote:

> Hi Jack,
>
> Jack Slater  writes:
>
> > I think I'm getting that understanding a little bit. Thanks!
> >
> > Debit Checking Account - Credit Rent - paying a bill and knowing why
> (even
> > though in my Quicken mind the Rent account is just a category)
> >
> > I found a Transfer transaction on the tool bar that accommodates the type
> > of transfer I am used to, i.e.:
> >
> > Debit Checking Account - Credit Visa Account - paying a bill
> >
> > In a perfect world, I'd sure like to use GC the same way.  Maybe with all
> > the help and usage I'll get there.
>
> You can easily restructure your account hierarchy by editing your
> accounts and reassigning them to new parent accounts.  For example, if
> you look at the default account structure that you could create via File
> -> New File and creating a set of empty accounts, it will look something
> like:
>
> Assets/
>Current Assets/
>   Bank/
>  Checking
>  Savings
>   Cash
>Fixed Assets/
>   Car
>   House
> Liabilities/
>Credit Card
>Mortgage
> Equity/
>Opening Balances
> Income/
>Salary
> Expenses/
>Groceries
>Rent
>Utilities/
>   Electricity
>   Gas
>   Internet
>   Phone
>
> Most likely all your Income/Expense accounts got flattened because
> Quicken generally doesn't create a hierarchy like this.  But GnuCash
> can.
>
> All you need to do is select an account in the CoA, click on Edit, and
> then you can reassign to a new parent.  Note that the parent must
> already exist.  So if you create a top-level Expenses account, then you
> can assign Groceries and Rent to that.  Similarly, if you create
> Expenses:Utilities then you can put the other accounts under that.
>
> This will help clean up your accounts.
>
> There is another option: You can start over.  Run the File -> New File,
> create an empty set of accounts, and then, during the QIF Import from
> Quicken, assign each of the QIF Accounts and Categories to the correct
> GnuCash Account.  This will properly populate the hierarchy as you
> desire.
>
> Hope this helps!
>
> -derek
>
> > On Thu, Dec 14, 2017 at 2:38 PM, Mike or Penny Novack <
> > stepbystepf...@dialup4less.com> wrote:
> >
> >> On 12/14/2017 2:10 PM, Jack Slater wrote:
> >>
> >>> I think I get what your saying and at this point (a) I have no clue
> how to
> >>> manage/edit/adjust what I have to that type of structure nor (b) do I
> know
> >>> enough yet to feel confident in making any changes! LOL..
> >>>
> >>> I'm reconciling my November statement as we "speak" and had to add a
> few
> >>> account transfer entries - that in Quicken would credit 1 account and
> >>> automatically debit the transfer account. I have non idea how/if I can
> do
> >>> that in GC!?
> >>>
> >>> Any pointers/help is gladly and thankfully accepted!
> >>>
> >>> On Thu, Dec 14, 2017 at 12:53 PM, Fross, Michael 
> >>> wrote:
> >>>
> >>
> >> When you are entering transactions (of any sort) in gnucash or any other
> >> double entry package you are always debiting one account (or accounts)
> and
> >> crediting one account (or accounts). Whether the second account is being
> >> debited or credited will depend on what you are doing in the first
> account
> >> (the one you are entering the transactions from). THAT is automatic
> using
> >> gnucash.
> >>
> >> << the plurals above refer to split transactions which you will learn
> >> about later >>
> >>
> >> Michael
> >> ___
> >> 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.
> >>
> > ___
> > 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.
> >
> >
>
> --
>Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>Member, MIT Student Information Processing Board  (SIPB)
>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>warl...@mit.eduPGP key available
>
___
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: Fwd: Unused Ledger Accounts in Trial Balance

2017-12-15 Thread Derek Atkins
Hi,

Shirani Gamage  writes:

> Hi
>
> I have been using Gnu  Cash from 2006.
> When the Trial Balance is generated ledger several accounts not used in the
> present Financial year are shown with out values.
>
> Is there a possibility of not showing these accounts when generating a
> Trial Balance.

It looks like that report does not have the ability to hide zero-balance
accounts.  Sorry.  You'll have to either edit the report output by hand
to remove them, or you can try to modify the report implementation to
add that feature.  Or you can file a request for enhancement.

Good Luck,

> Thank you
>
> Shirani

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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: unreconcile multiple transactions

2017-12-15 Thread Derek Atkins
Hi,

frozenjim  writes:

> While there is no "SIMPLE" way to un-reconcile an entire account, I have had
> to do this once or twice in the past and have found what I believe is the
> easiest way:
>
> Open Account Journal   
> Open Search Dialog (CTRL-F)   
> Search for ALL of these conditions:  
>  
> Reconcile : IS : Reconciled 
> Account : Matches Any Account : (enter your account)
>
> Save the Search   
> Manually clear your reconciled entries:  
>  
> Move to the first reconciled entry 
> CONFIRM you are on the line for your account (i.e. the bank account, not the
> vendor) 
> Click on the "Y" in the reconciled column of the first transaction 
> Entry vanishes from search and mouse is moved to the NEXT entry 
> Repeat until there are no entries left  
> This is still time consuming - and you get hypnotized pretty fast so stay
> alert - but it is the simplest and least risky method I have come up with.

I would suggest an easier (and less error-prone) way:

* Open the account you want to unreconcile
* View -> Filter By...
  and select the date range you want to unreconcile
* View -> Filter By... -> Status
  and unclick everything but "reconciled"
* Now go through each line and click on the 'y' in the reconciled
  column.  The line will vanish.  And you'll be certain you're
  unreconciling the entry from *this* account and not accidentally from
  another account.

Enjoy!

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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: Invoice & Bill Posting Date Issues Across Multiple Periods

2017-12-15 Thread Derek Atkins
Adrien,

Adrien Monteleone  writes:

> Sorry, allow me to rephrase, when do I acquire the pre-paid expense ASSET?

Can you please explain what you mean by a "pre-paid expense asset"?  Is
it an Expense?  Or is it an Asset?

Could you give a concrete example of something that is a "pre-paid
expense asset"?

Sorry for being dense, but I still don't grok what you're trying to do
or how this is mapping into a real-world transaction.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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: New User to GnuCash

2017-12-15 Thread Derek Atkins
Jack Slater  writes:

> Ya I forgot to Reply All! 
>
> Using your examples -
>
> If I bought a tractor, I would Debit an Equipment account and Credit
> my Cash asset account?

Correct.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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: New User to GnuCash

2017-12-15 Thread Derek Atkins
Hi Jack,

Jack Slater  writes:

> I think I'm getting that understanding a little bit. Thanks!
>
> Debit Checking Account - Credit Rent - paying a bill and knowing why (even
> though in my Quicken mind the Rent account is just a category)
>
> I found a Transfer transaction on the tool bar that accommodates the type
> of transfer I am used to, i.e.:
>
> Debit Checking Account - Credit Visa Account - paying a bill
>
> In a perfect world, I'd sure like to use GC the same way.  Maybe with all
> the help and usage I'll get there.

You can easily restructure your account hierarchy by editing your
accounts and reassigning them to new parent accounts.  For example, if
you look at the default account structure that you could create via File
-> New File and creating a set of empty accounts, it will look something
like:

Assets/
   Current Assets/
  Bank/
 Checking
 Savings
  Cash
   Fixed Assets/
  Car
  House
Liabilities/
   Credit Card
   Mortgage
Equity/
   Opening Balances
Income/
   Salary
Expenses/
   Groceries
   Rent
   Utilities/
  Electricity
  Gas
  Internet
  Phone

Most likely all your Income/Expense accounts got flattened because
Quicken generally doesn't create a hierarchy like this.  But GnuCash
can.

All you need to do is select an account in the CoA, click on Edit, and
then you can reassign to a new parent.  Note that the parent must
already exist.  So if you create a top-level Expenses account, then you
can assign Groceries and Rent to that.  Similarly, if you create
Expenses:Utilities then you can put the other accounts under that.

This will help clean up your accounts.

There is another option: You can start over.  Run the File -> New File,
create an empty set of accounts, and then, during the QIF Import from
Quicken, assign each of the QIF Accounts and Categories to the correct
GnuCash Account.  This will properly populate the hierarchy as you
desire.

Hope this helps!

-derek

> On Thu, Dec 14, 2017 at 2:38 PM, Mike or Penny Novack <
> stepbystepf...@dialup4less.com> wrote:
>
>> On 12/14/2017 2:10 PM, Jack Slater wrote:
>>
>>> I think I get what your saying and at this point (a) I have no clue how to
>>> manage/edit/adjust what I have to that type of structure nor (b) do I know
>>> enough yet to feel confident in making any changes! LOL..
>>>
>>> I'm reconciling my November statement as we "speak" and had to add a few
>>> account transfer entries - that in Quicken would credit 1 account and
>>> automatically debit the transfer account. I have non idea how/if I can do
>>> that in GC!?
>>>
>>> Any pointers/help is gladly and thankfully accepted!
>>>
>>> On Thu, Dec 14, 2017 at 12:53 PM, Fross, Michael 
>>> wrote:
>>>
>>
>> When you are entering transactions (of any sort) in gnucash or any other
>> double entry package you are always debiting one account (or accounts) and
>> crediting one account (or accounts). Whether the second account is being
>> debited or credited will depend on what you are doing in the first account
>> (the one you are entering the transactions from). THAT is automatic using
>> gnucash.
>>
>> << the plurals above refer to split transactions which you will learn
>> about later >>
>>
>> Michael
>> ___
>> 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.
>>
> ___
> 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.
>
>

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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: Report error An error occurred while running the report.

2017-12-15 Thread Derek Atkins
Dane Dormio  writes:

> Yes, it is a third-level account, and it also works when I just select the two
> parent accounts (without changing the "Show Accounts until level" setting). 
> So now I know two ways to fix it. :)

Ah, yes, there are several reports that don't handle the case where
there are no accounts to actually print.  This happens in your case
because you're 3 levels deep, but the report is set to only print to 2
levels deep --- but there are no top-level or 2nd-level accounts to
print...  So it goes FEH.

The short answer:  Don't do that  ;)

-derek

> - 619-663-7819
>
> www.danedormio.com
>
> On Thu, Dec 14, 2017 at 10:10 PM, Derek Atkins  wrote:
>
> Hi,
>
> Dane Dormio  writes:
>
> > It is an expense over time report.  The options I modified are choosing
> a
> > single expense account and setting the date to a recent 10-day period. 
> I
> > haven't modified any global or book defaults.  The trace file that was
> > created when I most recently got this error is attached.
>
> Well, the good news is that there was definitely an error in the
> tracefile:
>
> ...
>   88: 45* [slotset-map-input #account (split)> ...
>   89: 46* [alist->slotset ()]
> In C:\Program Files (x86)\gnucash\share\gnucash/scm/gnucash/report/report-
> system
> /collectors.scm:
>  135: 47  [make-slotset # ()]
>  104: 48* (if (not (pair? slots)) (throw (quote not-a-list) slots))
>  105: 49  [throw not-a-list ()]
> In unknown file:
>    ?: 50* [dumper not-a-list ()]
> In C:\Program Files (x86)\gnucash\share\gnucash/scm/gnucash/main.scm:
>   99: 51* (let* ((stack #)) (display-backtrace stack (current-error-port))
> ...)
>  102: 52* [apply # # aa7e5f0:bec82e0> .
> ..]
>
> Now, of course, the question is why this not-a-list happens?
>
> You say you selected a single account.  Does this account have a parent?
> Can you make sure you select all parent accounts of the one account you
> want, too?
>
> -derek
>
> >
> > - 619-663-7819
> >
> > www.danedormio.com
> >
> > On Wed, Dec 13, 2017 at 9:28 PM, Christopher Lam <
> christopher@gmail.com>
> > wrote:
> >
> >> Also the trace file will be useful.
> >> https://wiki.gnucash.org/wiki/Tracefile
> >>
> >> On 13 Dec 2017 23:40, "Christopher Lam" 
> wrote:
> >>
> >>> Well start by stating which report caused the error. Which options did
> >>> you modify. Did you change any global or book defaults. Any
> particularities
> >>> about your data file etc.
> >>>
> >>> On 13 Dec 2017 21:08, "Dane Dormio"  wrote:
> >>>
> >>> How would I do this?
> >>>
> >>> - 619-663-7819 <(619)%20663-7819>
> >>>
> >>> www.danedormio.com
> >>>
> >>> On Wed, Dec 13, 2017 at 6:27 PM, Christopher Lam <
> >>> christopher@gmail.com> wrote:
> >>>
>  Not every report handles error conditions smoothly. It would be
> useful
>  to summarise the report chosen and the options used. The report can
> then be
>  fixed for the next release.
> 
>  On 13 Dec 2017 4:22 PM, "Dane Dormio"  wrote:
> 
> > I am running the latest version of GNUcash (2.6.18) on Windows 10.
> > When I
> > choose report type the default report for that type works fine, but
> > when I
> > try to customize the report I get the following error: "Report error
> An
> > error occurred while running the report."  Currently I am trying to
> run
> > an
> > expense report over a ten day period for a single expense category
> and
> > am
> > getting this error.  What can I do to fix it?
> >
> > Thanks
> > ___
> > 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.
> >
> 
> >>>
> >>>
> >
> >
> > ___
> > 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.
> >
>
> --
>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>        Member, MIT Student Information Processing Board  (SIPB)
>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>        warl...@mit.edu                        PGP key available
>

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Informati

Re: A BASH script to help get tax-related data from gnucash

2017-12-15 Thread David T. via gnucash-user
If you have set the accounts as tax-related, why wouldn't you use the Tax 
Schedule Report?  
This works rather well, especially if you assign specific tax lines to your 
accounts. See chapter 10 of the help for detailed instructions. 
David

 
 
  On Fri, Dec 15, 2017 at 13:17, azalea4va wrote:  
 I just started using gnucash this summer, so I am investigating using it to
assist in tax preparation for the first time.  I have gone through the
process of marking all income/expense accounts as tax-related.  But I find
the provided "Tax Schedule Report" as being les than ideal in its
presentation of the information I seek.  (There seems to be an issue with
gnucash in general, the information formats frequently lack clarity and
conciseness so one must wade through lots of "noise" to get the desired
info.  Look at the listing for the general ledger and more than 50% of the
screen is white-space.)

What I have found useful is using the "Income Statement Report", configured
to use exactly those accounts which are tax-related.  I have found no easy
way to accomplish that configuration in gnucash (I must manually click all
those accounts on the account config page, hoping I accurately remember them
all).  So I wrote a BASh script to extract a tax-related account listing
from a gnucash file.  The output from that script includes a line that can
be inserted into the configuration for a report in the
'~/.gnucash/saved-reports-2.4' file so that report will process exactly
those tax-related files.

I provide that script here for those linux geeks who are comfortable
manually editting gnucash configuration files and may find the script 
get-tax-acct.get-tax-acct
  
of use.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.
  
___
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: finance-quote error

2017-12-15 Thread David T. via gnucash-user
Are you sure your alphavantage key is properly set in your environment? 
David

 
 
  On Fri, Dec 15, 2017 at 13:12, batwell wrote:   I am 
still having problems after updating to 1.47.  I have not found any
source that returns a usable response.
Any Idea what I am doing wrong or what to change?  Thanks,  Bob.

bob@bob-Studio-XPS-8100 ~ $ gnc-fq-check
("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx"
"australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero"
"canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch"
"dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct"
"fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france"
"ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney"
"greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual"
"known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp"
"mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds"
"sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse"
"tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx"
"uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd"
"yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe"
"yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts")
bob@bob-Studio-XPS-8100 ~ $ gnc-fq-dump alphavantage TXN
Finance::Quote fields Gnucash uses:
    symbol: TXN (deduced)        <=== required
      date: ** missing **        <=== required
  currency: ** missing **        <=== required
      last:                      <=\      
      nav:                      <=== one of these
    price:                      <=/        
  timezone:                      <=== optional

** This stock quote cannot be used by gnucash!!




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.
  
___
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: finance-quote error

2017-12-15 Thread rmcasali
Have you tried use YAHOO_JSON? It's working for me.

[rmcasali@equilibrium ~]$ gnc-fq-check 
("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia"
"asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil"
"bse" "bsero" "canada" "canadamutual" "cdb_di" "citywire" "cominvest"
"cse" "debbrasil" "deka" "dutch" "dwsfunds" "europe"
"fetch_live_currencies" "fidelity" "fidelity_direct" "fidelityfixed"
"financecanada" "finanzpartner" "finland" "fool" "france" "ftfunds"
"ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" "greece"
"hex" "hu" "hufund" "hungary" "hustock" "indiamutual"
"known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp"
"mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds"
"sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds"
"tdwaterhouse" "tesouro" "tiaacref" "tnetuk" "troweprice"
"troweprice_direct" "trustnet" "tsp" "tsx" "uk_unit_trusts" "ukfunds"
"unionfunds" "usa" "usfedbonds" "vanguard" "vwd" "yahoo" "yahoo_asia"
"yahoo_australia" "yahoo_brasil" "yahoo_europe" "yahoo_json" "yahoo_nz"
"yahoo_yql" "za" "za_unittrusts")
[rmcasali@equilibrium ~]$ gnc-fq-dump yahoo_json TXN
Finance::Quote fields Gnucash uses:
symbol: TXN  <=== required
  date: 12/14/2017   <=== recommended
  currency: USD  <=== required
  last: 100.25   <=\   
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional


On Thu, 2017-12-14 at 12:53 -0700, batwell wrote:
> I am still having problems after updating to 1.47.  I have not found
> any
> source that returns a usable response.
> Any Idea what I am doing wrong or what to change?   Thanks,  Bob.
> 
> bob@bob-Studio-XPS-8100 ~ $ gnc-fq-check
> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr"
> "asia" "asx"
> "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse"
> "bsero"
> "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch"
> "dwsfunds" "europe" "fetch_live_currencies" "fidelity"
> "fidelity_direct"
> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool"
> "france"
> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary"
> "goldmoney"
> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual"
> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp"
> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds"
> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds"
> "tdwaterhouse"
> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp"
> "tsx"
> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard"
> "vwd"
> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe"
> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts")
> bob@bob-Studio-XPS-8100 ~ $ gnc-fq-dump alphavantage TXN
> Finance::Quote fields Gnucash uses:
> symbol: TXN (deduced)<=== required
>   date: ** missing **<=== required
>   currency: ** missing **<=== required
>   last:  <=\   
>nav:  <=== one of these
>  price:  <=/
>   timezone:  <=== optional
> 
> ** This stock quote cannot be used by gnucash!!
> 
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819
> .html
> ___
> 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.
___
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.


Fwd: Unused Ledger Accounts in Trial Balance

2017-12-15 Thread Shirani Gamage
Hi

I have been using Gnu  Cash from 2006.
When the Trial Balance is generated ledger several accounts not used in the
present Financial year are shown with out values.

Is there a possibility of not showing these accounts when generating a
Trial Balance.

Thank you

Shirani
___
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: Error in Tip of the Day

2017-12-15 Thread Geert Janssens
Op zondag 10 december 2017 22:26:40 CET schreef Daniel Narvaes:
> I've been using gnucash for a long time, and I usually read the tip of the
> day, and try it if I have not seen it before.  Today it said "To switch
> between multiple tabs in the main window, press Control+Page Up/Down."  I
> tried it and it didn't work.  After browsing the users mailing list, I
> found out the correct key combination is "Ctrl+Alt+Page Up/Down."
> 
> I'm using gnucash 2.6.12 on Ubuntu 14.04 LTS.  Can someone check and see if
> the description is still wrong on the latest version?  If so, I'll file a
> bug report, unless you want to do that for me too.  I would still have to
> create an account on Bugzilla to make a bug report.
> ___
> 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.

You are correct it should be "Ctrl-Alt-Page Up/Down". That's how it works on 
the current stable version (2.6.18) as well.

On the current development version this appears to be broken. It will only 
work if a notebook tab is clicked on first (which is defeating the initial 
idea). And it breaks down on report pages.

Please do file a bug report and feel free to quote my findings as well.

Thanks,

Geert

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


Error in Tip of the Day

2017-12-15 Thread Daniel Narvaes

I've been using gnucash for a long time, and I usually read the tip of the
day, and try it if I have not seen it before.  Today it said "To switch
between multiple tabs in the main window, press Control+Page Up/Down."  I
tried it and it didn't work.  After browsing the users mailing list, I
found out the correct key combination is "Ctrl+Alt+Page Up/Down."

I'm using gnucash 2.6.12 on Ubuntu 14.04 LTS.  Can someone check and see if
the description is still wrong on the latest version?  If so, I'll file a
bug report, unless you want to do that for me too.  I would still have to
create an account on Bugzilla to make a bug report.
___
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: Report error An error occurred while running the report.

2017-12-15 Thread Dane Dormio
Yes, it is a third-level account, and it also works when I just select the
two parent accounts (without changing the "Show Accounts until level"
setting).  So now I know two ways to fix it. :)

- 619-663-7819

www.danedormio.com

On Thu, Dec 14, 2017 at 10:10 PM, Derek Atkins  wrote:

> Hi,
>
> Dane Dormio  writes:
>
> > It is an expense over time report.  The options I modified are choosing a
> > single expense account and setting the date to a recent 10-day period.  I
> > haven't modified any global or book defaults.  The trace file that was
> > created when I most recently got this error is attached.
>
> Well, the good news is that there was definitely an error in the tracefile:
>
> ...
>   88: 45* [slotset-map-input #account (split)> ...
>   89: 46* [alist->slotset ()]
> In C:\Program Files (x86)\gnucash\share\gnucash/scm/gnucash/report/report-
> system
> /collectors.scm:
>  135: 47  [make-slotset # ()]
>  104: 48* (if (not (pair? slots)) (throw (quote not-a-list) slots))
>  105: 49  [throw not-a-list ()]
> In unknown file:
>?: 50* [dumper not-a-list ()]
> In C:\Program Files (x86)\gnucash\share\gnucash/scm/gnucash/main.scm:
>   99: 51* (let* ((stack #)) (display-backtrace stack (current-error-port))
> ...)
>  102: 52* [apply # # aa7e5f0:bec82e0> .
> ..]
>
> Now, of course, the question is why this not-a-list happens?
>
> You say you selected a single account.  Does this account have a parent?
> Can you make sure you select all parent accounts of the one account you
> want, too?
>
> -derek
>
> >
> > - 619-663-7819
> >
> > www.danedormio.com
> >
> > On Wed, Dec 13, 2017 at 9:28 PM, Christopher Lam <
> christopher@gmail.com>
> > wrote:
> >
> >> Also the trace file will be useful.
> >> https://wiki.gnucash.org/wiki/Tracefile
> >>
> >> On 13 Dec 2017 23:40, "Christopher Lam" 
> wrote:
> >>
> >>> Well start by stating which report caused the error. Which options did
> >>> you modify. Did you change any global or book defaults. Any
> particularities
> >>> about your data file etc.
> >>>
> >>> On 13 Dec 2017 21:08, "Dane Dormio"  wrote:
> >>>
> >>> How would I do this?
> >>>
> >>> - 619-663-7819 <(619)%20663-7819>
> >>>
> >>> www.danedormio.com
> >>>
> >>> On Wed, Dec 13, 2017 at 6:27 PM, Christopher Lam <
> >>> christopher@gmail.com> wrote:
> >>>
>  Not every report handles error conditions smoothly. It would be useful
>  to summarise the report chosen and the options used. The report can
> then be
>  fixed for the next release.
> 
>  On 13 Dec 2017 4:22 PM, "Dane Dormio"  wrote:
> 
> > I am running the latest version of GNUcash (2.6.18) on Windows 10.
> > When I
> > choose report type the default report for that type works fine, but
> > when I
> > try to customize the report I get the following error: "Report error
> An
> > error occurred while running the report."  Currently I am trying to
> run
> > an
> > expense report over a ten day period for a single expense category
> and
> > am
> > getting this error.  What can I do to fix it?
> >
> > Thanks
> > ___
> > 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.
> >
> 
> >>>
> >>>
> >
> >
> > ___
> > 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.
> >
>
> --
>Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>Member, MIT Student Information Processing Board  (SIPB)
>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>warl...@mit.eduPGP key available
>
___
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.


A BASH script to help get tax-related data from gnucash

2017-12-15 Thread azalea4va
I just started using gnucash this summer, so I am investigating using it to
assist in tax preparation for the first time.  I have gone through the
process of marking all income/expense accounts as tax-related.  But I find
the provided "Tax Schedule Report" as being les than ideal in its
presentation of the information I seek.  (There seems to be an issue with
gnucash in general, the information formats frequently lack clarity and
conciseness so one must wade through lots of "noise" to get the desired
info.  Look at the listing for the general ledger and more than 50% of the
screen is white-space.)

What I have found useful is using the "Income Statement Report", configured
to use exactly those accounts which are tax-related.  I have found no easy
way to accomplish that configuration in gnucash (I must manually click all
those accounts on the account config page, hoping I accurately remember them
all).  So I wrote a BASh script to extract a tax-related account listing
from a gnucash file.  The output from that script includes a line that can
be inserted into the configuration for a report in the
'~/.gnucash/saved-reports-2.4' file so that report will process exactly
those tax-related files.

I provide that script here for those linux geeks who are comfortable
manually editting gnucash configuration files and may find the script 
get-tax-acct.get-tax-acct
  
of use.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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: unreconcile multiple transactions

2017-12-15 Thread frozenjim
While there is no "SIMPLE" way to un-reconcile an entire account, I have had
to do this once or twice in the past and have found what I believe is the
easiest way:
   
Open Account Journal   
Open Search Dialog (CTRL-F)   
Search for ALL of these conditions:  
 
Reconcile : IS : Reconciled 
Account : Matches Any Account : (enter your account)
   
Save the Search   
Manually clear your reconciled entries:  
 
Move to the first reconciled entry 
CONFIRM you are on the line for your account (i.e. the bank account, not the
vendor) 
Click on the "Y" in the reconciled column of the first transaction 
Entry vanishes from search and mouse is moved to the NEXT entry 
Repeat until there are no entries left  
This is still time consuming - and you get hypnotized pretty fast so stay
alert - but it is the simplest and least risky method I have come up with.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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: Report error An error occurred while running the report.

2017-12-15 Thread Dane Dormio
By jove, that worked! (It was set at "2" by default).  Thanks! :)

- 619-663-7819

www.danedormio.com

On Thu, Dec 14, 2017 at 4:28 PM, Christopher Lam 
wrote:

> Just a punt
>
>
>
> Try increasing the Accounts / Show Accounts until level to “All”
>
>
>
> Sent from Mail  for
> Windows 10
>
>
>
> *From: *Dane Dormio 
> *Sent: *Thursday, 14 December 2017 5:15 PM
> *To: *sunfis...@yahoo.com
> *Cc: *gnucash-user@gnucash.org
> *Subject: *Re: Report error An error occurred while running the report.
>
>
>
> Yes, I am certain.  It is a recent time period for an account with frequent
>
> transactions.
>
>
>
> - 619-663-7819 <(619)%20663-7819>
>
>
>
> www.danedormio.com
>
>
>
> On Wed, Dec 13, 2017 at 5:27 PM, David T.  wrote:
>
>
>
> > Are you sure that there are any transactions for the period you selected?
>
> > I'm not certain, but I believe that an empty return set gives this. This
> is
>
> > an unfortunate communication.
>
> >
>
> > David
>
> >
>
> >
>
> >
>
> > On Wed, Dec 13, 2017 at 13:18, Dane Dormio
>
> >  wrote:
>
> > I am running the latest version of GNUcash (2.6.18) on Windows 10.  When
> I
>
> > choose report type the default report for that type works fine, but when
> I
>
> > try to customize the report I get the following error: "Report error An
>
> > error occurred while running the report."  Currently I am trying to run
> an
>
> > expense report over a ten day period for a single expense category and am
>
> > getting this error.  What can I do to fix it?
>
> >
>
> > Thanks
>
> > ___
>
> > 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.
>
> >
>
> >
>
> ___
>
> 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.
>
>
>
___
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: finance-quote error

2017-12-15 Thread batwell
I am still having problems after updating to 1.47.  I have not found any
source that returns a usable response.
Any Idea what I am doing wrong or what to change?   Thanks,  Bob.

bob@bob-Studio-XPS-8100 ~ $ gnc-fq-check
("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx"
"australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero"
"canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch"
"dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct"
"fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france"
"ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney"
"greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual"
"known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp"
"mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds"
"sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse"
"tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx"
"uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd"
"yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe"
"yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts")
bob@bob-Studio-XPS-8100 ~ $ gnc-fq-dump alphavantage TXN
Finance::Quote fields Gnucash uses:
symbol: TXN (deduced)<=== required
  date: ** missing **<=== required
  currency: ** missing **<=== required
  last:  <=\   
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

** This stock quote cannot be used by gnucash!!




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.