Re: only deposits show

[David Carlson]

You do not mention important details that are needed to give a definitive
answer, but assuming that you followed the a likely path, you exported
transactions from your Quicken file in QIF format then imported them into
GnuCash in the same format.

The QIF format creates a data section for each account which includes
transfers to or from whatever other accounts are used.  To get complete
information you need a section for every asset and liability account in
your file.  I would guess that you are missing some sections for some of
your accounts.

It happens that Quicken uses the term Category for account types Income and
Expense, and there is no need to have QIF sections for Categories, but all
Asset and Liability accounts need to be imported individually or in a
combined file.

If your Quicken file is large we usually recommend breaking down your QIF
file into separate files for each account, and possibly for limited time
intervals, such as Bank1_2016, Bank1_2015, etc.This helps to get better
results with matching the two sides of transfers during the import and
avoiding Imbalance entries.

Good Luck.

David C



On Mon, Oct 2, 2017 at 5:22 PM, frank raney  wrote:

> Just installed  and imported a quicken file.  after import, one of my
> checking accounts on;y shows deposits made from another checking account.
> It does not show checks od debits.
>
> Any idea why
>
>
> Frankie Raney
> 12454 Auberry Rd.
> Clovis, Ca.
> 559.297.8577 H
> 559.304.1751 C
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> 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: budget with ytd difference option and ?improved? readability

[Larry]

HI, 
I am new too and don't have gnucash on my tablet. I was able to create a new 
style with borders that makes it easier to read the tables in the report. I 
can't tell you how for a day or two due to being quite tied up but if you look 
up styles you may be able to figure it out.
Larry


Sent from my Samsung Galaxy Tab® S

 Original message 
From: gbguy  
Date: 2017-10-02  16:02  (GMT-08:00) 
To: gnucash-user@gnucash.org 
Subject: Re: budget with ytd difference option and ?improved? readability 

Well, idiot here figured out the primary problem. I had File Explorer's View
option inadvertently set to hide file extensions. The two files I downloaded
actually had .txt extensions (e.g., budget-plus.scm.txt). Yet another reason
to dislike Windows :-) 

I renamed the files and successfully ran a Budget+ report. However, I have
an issue. (I'm providing details in case anyone has questions on how to run
this report). 

I created a budget, which had a Budget Period beginning on 01/01/2017 and 12
Periods, via Actions -> Budget -> New Budget. I then opened (Action ->
Budget -> Open Budget) the newly created budget . 

I then did Reports -> Budget -> Budget+ Report while the budget was open and
chose these report options:
General: Yearly Budget option. Display: Show Budget, Show Actual, Show
Difference, YTD Difference, Show Column with Totals. 

Things look good at a cursory glance. /However, there aren't any cell colors
or borders/.



--
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: [Solved] - OFX failing for Bank Of America Checking

[Bill Starrs]

Hi, was able to resolve the issue by generating a client GUID for the
account in aqbanking.  When I tried to download transacations I received
an error.

I logged in on the web and was presented with a dialog to accest T for
online banking and was given 10 minutes to connect.

I went back to Gnucash and successfully downloaded transactions.

I also changed the AppId to QWIN 2600 (which I assume would be Quicken
2017).

wjstarrsiii
___
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: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

[GWB]

So AT's network equipment works when nothing is connected to it?
Clearly this is a success story.  If the tech had been allowed to try
the new modem, that would have greatly sped up the troubleshooting
process.  If it had worked as before, then problem solved.  If not,
then you could debug your network topography on your side.

That's actually more frustrating than I thought.  Maybe another phone
call to ask them to just please try a different modem before you spend
all that time chasing a problem that might not exist.

I have managed to keep the static (fixed) IP I have, but not without a
struggle.  The solution is sometimes just having a "dumb" modem
connected to the LAN with the switching equipment at the telecomm set
to assign a fixed IP.  Sometimes I have to lease a fixed IP from a
different provider who then contracts with a local telecomm.  In any
event, it's worth it, and necessary.

Check around.  Anywhere from Cambridge to Dedham should be any number
of telecomm trunk leasing outfits.

Gordon

On Mon, Oct 2, 2017 at 6:57 PM, Derek Atkins  wrote:
> [removed -announce]
>
> On Mon, October 2, 2017 6:09 pm, GWB wrote:
>> Derek,
>>
>> Sorry to hear that, and its frustrating.  Perhaps AT could, in the
>> meantime, install a different modem temporarily to see if that solves
>> the problem?  I've been through this with various T line providers,
>> and their default response is often "Something you did", even when the
>> internal set up has not changed in years.  Not all of them do this,
>> but the repair techs are sometimes tied by their instructions from on
>> high.
>
> Alas, they basically said "disconnect all your equipment to prove to us
> it's *OUR* problem", and of course when I did do that I was able to show
> there was no problem.  So from their perspective it's a problem on my end,
> not theirs.
>
> The tech actually did have a new modem box for me, but wasn't allowed to
> install it.  The fact that I have static IPs from them is half the problem
> with why he couldn't just replace the modem.  Also the fact that the
> problem only occurs when my network devices are connected.  :(
>
> I've still got a few avenues to explore.
>
> The fact that it started at midnight just seems suspicious (or highly
> coincidental).
>
> -derek
>
>>
>> Gordon
>>
>> On Mon, Oct 2, 2017 at 12:28 PM, David Carlson
>>  wrote:
>>> That might be difficult, as it may be a loose connector or even
>>> corrosion
>>> inside a cable or connector or component in a power supply or ???
>>>
>>> Good luck.
>>>
>>> David C
>>>
>>> On Oct 2, 2017 10:42 AM, "Derek Atkins"  wrote:
>>>
 Hi,

 Just a quick follow-up.

 AT did come, and with their help we debugged the network only to
 discover that it's something inside my network that is causing their
 modem to go all futzy.

 I'm now in the process of trying to debug further, but it's going to
 take time.  Expect further interuptions until I can isolate the issue.

 -derek

 Derek Atkins  writes:

 > Hi,
 >
 > tl;dr:  AT is coming to fix some network issues tomorrow, Sunday,
 > between 1-4pm EDT; service can last up to 2 hours and may involve
 > several network outages.
 >
 > LONG VERSION:
 >
 > As some of you may have noticed, there have been some network issues
 to
 > code which started just over a week ago.  One of the downsides was
 > significant packet loss and gncbot disappearing from IRC.  Alas, I
 had
 > been out of the country while this was happening and couldn't start
 to
 > really look into it; I restarted gncbot several times while I was
 away
 > but due to the persistent network issues it regularly would lost
 > contact.
 >
 > I'm seeing anywhere from 20-40% packet loss and ping times to my
 > immediate router anywhere from 200-1000ms (whereas it's usually
 3-4ms).
 > I called AT, my ISP, and they are sending a tech tomorrow, Sunday,
 > October 1, between 1-4pm EDT.  The maintenance could potentially take
 2
 > hours once they arrive, but of course it all depends on what the
 issue
 > is.
 >
 > This will affect code, lists, and wiki services including email,
 gncbot,
 > etc.
 >
 > I'll attempt to keep people informed over IRC, assuming of course
 that I
 > can get online prior to the work being done.
 >
 > Please let me know if you have any questions.
 >
 > -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
 

Re: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

[Derek Atkins]

[removed -announce]

On Mon, October 2, 2017 6:09 pm, GWB wrote:
> Derek,
>
> Sorry to hear that, and its frustrating.  Perhaps AT could, in the
> meantime, install a different modem temporarily to see if that solves
> the problem?  I've been through this with various T line providers,
> and their default response is often "Something you did", even when the
> internal set up has not changed in years.  Not all of them do this,
> but the repair techs are sometimes tied by their instructions from on
> high.

Alas, they basically said "disconnect all your equipment to prove to us
it's *OUR* problem", and of course when I did do that I was able to show
there was no problem.  So from their perspective it's a problem on my end,
not theirs.

The tech actually did have a new modem box for me, but wasn't allowed to
install it.  The fact that I have static IPs from them is half the problem
with why he couldn't just replace the modem.  Also the fact that the
problem only occurs when my network devices are connected.  :(

I've still got a few avenues to explore.

The fact that it started at midnight just seems suspicious (or highly
coincidental).

-derek

>
> Gordon
>
> On Mon, Oct 2, 2017 at 12:28 PM, David Carlson
>  wrote:
>> That might be difficult, as it may be a loose connector or even
>> corrosion
>> inside a cable or connector or component in a power supply or ???
>>
>> Good luck.
>>
>> David C
>>
>> On Oct 2, 2017 10:42 AM, "Derek Atkins"  wrote:
>>
>>> Hi,
>>>
>>> Just a quick follow-up.
>>>
>>> AT did come, and with their help we debugged the network only to
>>> discover that it's something inside my network that is causing their
>>> modem to go all futzy.
>>>
>>> I'm now in the process of trying to debug further, but it's going to
>>> take time.  Expect further interuptions until I can isolate the issue.
>>>
>>> -derek
>>>
>>> Derek Atkins  writes:
>>>
>>> > Hi,
>>> >
>>> > tl;dr:  AT is coming to fix some network issues tomorrow, Sunday,
>>> > between 1-4pm EDT; service can last up to 2 hours and may involve
>>> > several network outages.
>>> >
>>> > LONG VERSION:
>>> >
>>> > As some of you may have noticed, there have been some network issues
>>> to
>>> > code which started just over a week ago.  One of the downsides was
>>> > significant packet loss and gncbot disappearing from IRC.  Alas, I
>>> had
>>> > been out of the country while this was happening and couldn't start
>>> to
>>> > really look into it; I restarted gncbot several times while I was
>>> away
>>> > but due to the persistent network issues it regularly would lost
>>> > contact.
>>> >
>>> > I'm seeing anywhere from 20-40% packet loss and ping times to my
>>> > immediate router anywhere from 200-1000ms (whereas it's usually
>>> 3-4ms).
>>> > I called AT, my ISP, and they are sending a tech tomorrow, Sunday,
>>> > October 1, between 1-4pm EDT.  The maintenance could potentially take
>>> 2
>>> > hours once they arrive, but of course it all depends on what the
>>> issue
>>> > is.
>>> >
>>> > This will affect code, lists, and wiki services including email,
>>> gncbot,
>>> > etc.
>>> >
>>> > I'll attempt to keep people informed over IRC, assuming of course
>>> that I
>>> > can get online prior to the work being done.
>>> >
>>> > Please let me know if you have any questions.
>>> >
>>> > -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.
>>>
>> ___
>> 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 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

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

only deposits show

[frank raney]

Just installed  and imported a quicken file.  after import, one of my checking 
accounts on;y shows deposits made from another checking account.  It does not 
show checks od debits.

Any idea why


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 H
559.304.1751 C

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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: budget with ytd difference option and ?improved? readability

[gbguy]

Well, idiot here figured out the primary problem. I had File Explorer's View
option inadvertently set to hide file extensions. The two files I downloaded
actually had .txt extensions (e.g., budget-plus.scm.txt). Yet another reason
to dislike Windows :-) 

I renamed the files and successfully ran a Budget+ report. However, I have
an issue. (I'm providing details in case anyone has questions on how to run
this report). 

I created a budget, which had a Budget Period beginning on 01/01/2017 and 12
Periods, via Actions -> Budget -> New Budget. I then opened (Action ->
Budget -> Open Budget) the newly created budget . 

I then did Reports -> Budget -> Budget+ Report while the budget was open and
chose these report options:
General: Yearly Budget option. Display: Show Budget, Show Actual, Show
Difference, YTD Difference, Show Column with Totals. 

Things look good at a cursory glance. /However, there aren't any cell colors
or borders/.



--
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: budget with ytd difference option and ?improved? readability

[gbguy]

Well, idiot here figured out the major part of the problem.  I unknowingly
had File Explorer's View set to hide "file name extensions" and my files
were actually named with a .txt extension (e.g., budget-plus.scm.txt).  Yet
another reason to dislike Windows :-)I changed the file names and have
successfully displayed a Budget+ report.  However, there is no separate
background color, everything is white.I'll report later with details.  I
just wanted to let people know that the primary problem had been solved.



--
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: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

[GWB]

Derek,

Sorry to hear that, and its frustrating.  Perhaps AT could, in the
meantime, install a different modem temporarily to see if that solves
the problem?  I've been through this with various T line providers,
and their default response is often "Something you did", even when the
internal set up has not changed in years.  Not all of them do this,
but the repair techs are sometimes tied by their instructions from on
high.

Gordon

On Mon, Oct 2, 2017 at 12:28 PM, David Carlson
 wrote:
> That might be difficult, as it may be a loose connector or even corrosion
> inside a cable or connector or component in a power supply or ???
>
> Good luck.
>
> David C
>
> On Oct 2, 2017 10:42 AM, "Derek Atkins"  wrote:
>
>> Hi,
>>
>> Just a quick follow-up.
>>
>> AT did come, and with their help we debugged the network only to
>> discover that it's something inside my network that is causing their
>> modem to go all futzy.
>>
>> I'm now in the process of trying to debug further, but it's going to
>> take time.  Expect further interuptions until I can isolate the issue.
>>
>> -derek
>>
>> Derek Atkins  writes:
>>
>> > Hi,
>> >
>> > tl;dr:  AT is coming to fix some network issues tomorrow, Sunday,
>> > between 1-4pm EDT; service can last up to 2 hours and may involve
>> > several network outages.
>> >
>> > LONG VERSION:
>> >
>> > As some of you may have noticed, there have been some network issues to
>> > code which started just over a week ago.  One of the downsides was
>> > significant packet loss and gncbot disappearing from IRC.  Alas, I had
>> > been out of the country while this was happening and couldn't start to
>> > really look into it; I restarted gncbot several times while I was away
>> > but due to the persistent network issues it regularly would lost
>> > contact.
>> >
>> > I'm seeing anywhere from 20-40% packet loss and ping times to my
>> > immediate router anywhere from 200-1000ms (whereas it's usually 3-4ms).
>> > I called AT, my ISP, and they are sending a tech tomorrow, Sunday,
>> > October 1, between 1-4pm EDT.  The maintenance could potentially take 2
>> > hours once they arrive, but of course it all depends on what the issue
>> > is.
>> >
>> > This will affect code, lists, and wiki services including email, gncbot,
>> > etc.
>> >
>> > I'll attempt to keep people informed over IRC, assuming of course that I
>> > can get online prior to the work being done.
>> >
>> > Please let me know if you have any questions.
>> >
>> > -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.
>>
> ___
> 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: budget with ytd difference option and ?improved? readability

[gbguy]

Well, idiot here figured out the primary problem.  I had File Explorer's View
option inadvertently set to hide file extensions.  The two files I
downloaded actually had .txt extensions (e.g.,  budget-plus.scm.txt).  Yet
another reason to dislike Windows :-)

I renamed the files and successfully ran a Budget+ report.  However, I have
an issue.  (I'm providing details in case anyone has questions on how to run
this report).

I created a budget, which had a Budget Period beginning on 01/01/2017 and 12
Periods, via Actions -> Budget -> New Budget.  I then opened (Action ->
Budget -> Open Budget) the newly created budget .

I then did Reports -> Budget -> Budget+ Report while the budget was open and
chose these report options:
/General/: Yearly Budget option.
/Display/: Show Budget, Show Actual, Show Difference, YTD Difference, Show
Column with Totals.

Things look good at a cursory glance.  /However, there aren't any cell
colors or borders./



--
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: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

[David Carlson]

That might be difficult, as it may be a loose connector or even corrosion
inside a cable or connector or component in a power supply or ???

Good luck.

David C

On Oct 2, 2017 10:42 AM, "Derek Atkins"  wrote:

> Hi,
>
> Just a quick follow-up.
>
> AT did come, and with their help we debugged the network only to
> discover that it's something inside my network that is causing their
> modem to go all futzy.
>
> I'm now in the process of trying to debug further, but it's going to
> take time.  Expect further interuptions until I can isolate the issue.
>
> -derek
>
> Derek Atkins  writes:
>
> > Hi,
> >
> > tl;dr:  AT is coming to fix some network issues tomorrow, Sunday,
> > between 1-4pm EDT; service can last up to 2 hours and may involve
> > several network outages.
> >
> > LONG VERSION:
> >
> > As some of you may have noticed, there have been some network issues to
> > code which started just over a week ago.  One of the downsides was
> > significant packet loss and gncbot disappearing from IRC.  Alas, I had
> > been out of the country while this was happening and couldn't start to
> > really look into it; I restarted gncbot several times while I was away
> > but due to the persistent network issues it regularly would lost
> > contact.
> >
> > I'm seeing anywhere from 20-40% packet loss and ping times to my
> > immediate router anywhere from 200-1000ms (whereas it's usually 3-4ms).
> > I called AT, my ISP, and they are sending a tech tomorrow, Sunday,
> > October 1, between 1-4pm EDT.  The maintenance could potentially take 2
> > hours once they arrive, but of course it all depends on what the issue
> > is.
> >
> > This will affect code, lists, and wiki services including email, gncbot,
> > etc.
> >
> > I'll attempt to keep people informed over IRC, assuming of course that I
> > can get online prior to the work being done.
> >
> > Please let me know if you have any questions.
> >
> > -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.
>
___
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: How to modify many transactions at once

[Derek Atkins]

Hi,

Malcolm Fitzgerald  writes:

> I'm just starting out with gnucash and I've imported a large number of
> bank transaction records. I now have hundreds of imbalance notices
> that I'd like to correct.  Whoops.

If you're just starting out then I'd suggest you try a do-over.  These
imbalances imply that you did not assign correct Income/Expense accounts
during your import process.  The importer is the only place you can
"mass assign" transactions.  So I suggest you start over and re-do the
imports, and be sure to assign the transactions this time around.

> Many of my transactions are scheduled payments, so I can easily
> discover them with a find. Is there a way in which I can transform a
> batch of transactions? I'd like to locate the transactions then move
> all of them to an account. Is this possible? Can it be scripted?
>
> thanks,
>
> Malcolm

> 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: Report Question

[David T. via gnucash-user]

Mike,

I think the question is more about the report and how it aggregates 
information, rather than how the accounts are structured (although, of course 
that too can affect things). As Christopher Lam replied to the original 
poster’s posting of this on Saturday, the likely answer is to change the 
settings on the report to increase the number of bars in the report, or to do 
as Maf suggests, and reduce the accounts selected for the report.

Joe, did you try what Christopher suggested on Saturday, when you posted this 
originally? If not, why did you post the question again?

David

> On Oct 2, 2017, at 6:01 PM, Mike or Penny Novack 
>  wrote:
> 
> On 10/2/2017 4:42 AM, Joseph Hesse wrote:
>> Hi,
>> I am using the latest version 2.6.17 of gnucash.  I just ran the report 
>> "Expense Over Time = Expense Barchart" with the maximum number of vertical 
>> bars selected. The report lists all my expense items including one called 
>> "Other". Since the amount of "Other" is high, I would like to get a 
>> breakdown of the expense items included under "Other".
>> 
>> Is there a way to do this?
>> 
>> Thank you,
>> Joe Hesse 
> 
> Yes of course there is, you set up your CoA for as many categories of 
> expenses as you like.
> 
> Step back a moment and think about this problem. Suppose you had NO sub 
> accounts under "expense" (all lumped together). You would then have this 
> problem with ALL of your expenses. So you decided to have some number of sub 
> accounts that let you characterize (group) like expenses and then a bucket 
> "other" for those you choose not to categorize/group because totally 
> unrelated and/or unimportant.
> 
> At some later time, you realize that a number of transactions in this "other" 
> account ARE related* and so you want them grouped also. Then DO THAT. Create 
> a new expense sub account for those and move them there << The technically 
> correct procedure would be to create a "correcting transaction" to do that 
> but you will perhaps choose to edit the existing transactions >>
> 
> When you create your books, you will be very unlikely to know all of the 
> accounts you will eventually need or want.
> 
> Michael D Novack
> 
> * Or maybe just one, but clearly so important/significant to your finances 
> that you want it clearly listed instead of buried in a miscellaneous category.
> 
> ___
> 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: Report Question

[Maf. King]

On Monday, 2 October 2017 09:42:53 BST Joseph Hesse wrote:
> Hi,
> 
> I am using the latest version 2.6.17 of gnucash.  I just ran the report
> "Expense Over Time = Expense Barchart" with the maximum number of
> vertical bars selected. The report lists all my expense items including
> one called "Other". Since the amount of "Other" is high, I would like to
> get a breakdown of the expense items included under "Other".
> 

Hi Joe,

I think the only way to do what you want is to run the report with some of the 
accounts de-selected.  

Effectively, the report is saying that you have more accounts than it has bars 
available.  so running the report again with the individual larger accounts 
off will allow GC to drill into the "other" summary.  I think.

HTH,
Maf.

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

Report Question

[Joseph Hesse]

Hi,

I am using the latest version 2.6.17 of gnucash.  I just ran the report 
"Expense Over Time = Expense Barchart" with the maximum number of 
vertical bars selected. The report lists all my expense items including 
one called "Other". Since the amount of "Other" is high, I would like to 
get a breakdown of the expense items included under "Other".


Is there a way to do this?

Thank you,

Joe Hesse

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