Re: [GNC] Transaction Report Shortcomings

[Christopher Lam]

Hi, yes, that is correct.

On Sat, 4 May 2024 at 21:05, Paul Kroitor  wrote:

> So if I understand correctly, you’re saying the there’s already a setting
> (Sorting/Show Account Description) that is supposed to address this, but it
> doesn’t currently work properly. And that the bug was recently or is about
> to be fixed.
>
>
>
> Also, I should look for the fixed version in the nightly builds, right?
>
>
>
> Is that right?
>
>
>
> Sorry for double-checking, I just want to be sure I understand,
>
> Paul
>
>
>
> *From:* Christopher Lam 
> *Sent:* Thursday, May 2, 2024 1:09 AM
> *To:* Paul Kroitor 
> *Cc:* Gnucash Users 
> *Subject:* Re: [GNC] Transaction Report Shortcomings
>
>
>
> Hi,
>
> See Sorting/Show Account Description. This is a bug which will be fixed
> tomorrow.
>
> https://code.gnucash.org/builds/win32/stable/
>
> HTH
>
>
>
> On Wed, 1 May 2024 at 22:07, Paul Kroitor  wrote:
>
> Is there a way to get the Transaction Report to show Account Description
> rather than Account Name in the group header lines (not the detail lines)?
>
>
>
> I have a number of expense accounts that have identical subaccounts, for
> example House-1:Property Tax and House-2:Property Tax. In the CoA, the Name
> for these sub-accounts is just Prop Tax, but the Description is House-1
> Property Tax.
>
>
>
> The problem is that Transaction Reports (when set to primary key = Account
> Name) become confusing because there become several groups simply titled
> Prop Tax with no further distinction. It would be better if it could
> somehow
> more clearly show the account hierarchy - Quicken's Itemized Categories
> report is great at this with it's collapsable tree design - but just
> showing
> the full account name would be a good start.
>
>
>
> In some reports I can choose to show the Account Description (full name),
> but the Transaction Report doesn't seem to have this option.
>
>
>
> Or perhaps I should look at approaching this from the other direction and
> look for an Income / Expense report showing full detail lines?
>
>
>
> Paul
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report Shortcomings

[Paul Kroitor]

So if I understand correctly, you’re saying the there’s already a setting 
(Sorting/Show Account Description) that is supposed to address this, but it 
doesn’t currently work properly. And that the bug was recently or is about to 
be fixed.

 

Also, I should look for the fixed version in the nightly builds, right?

 

Is that right?

 

Sorry for double-checking, I just want to be sure I understand,

Paul

 

From: Christopher Lam  
Sent: Thursday, May 2, 2024 1:09 AM
To: Paul Kroitor 
Cc: Gnucash Users 
Subject: Re: [GNC] Transaction Report Shortcomings

 

Hi,

See Sorting/Show Account Description. This is a bug which will be fixed 
tomorrow.

https://code.gnucash.org/builds/win32/stable/

HTH

 

On Wed, 1 May 2024 at 22:07, Paul Kroitor mailto:p...@kroitor.ca> > wrote:

Is there a way to get the Transaction Report to show Account Description
rather than Account Name in the group header lines (not the detail lines)?



I have a number of expense accounts that have identical subaccounts, for
example House-1:Property Tax and House-2:Property Tax. In the CoA, the Name
for these sub-accounts is just Prop Tax, but the Description is House-1
Property Tax.



The problem is that Transaction Reports (when set to primary key = Account
Name) become confusing because there become several groups simply titled
Prop Tax with no further distinction. It would be better if it could somehow
more clearly show the account hierarchy - Quicken's Itemized Categories
report is great at this with it's collapsable tree design - but just showing
the full account name would be a good start.



In some reports I can choose to show the Account Description (full name),
but the Transaction Report doesn't seem to have this option.



Or perhaps I should look at approaching this from the other direction and
look for an Income / Expense report showing full detail lines?



Paul 

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

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

Re: [GNC] Transaction Report Shortcomings

[Christopher Lam]

Hi,
See Sorting/Show Account Description. This is a bug which will be fixed
tomorrow.
https://code.gnucash.org/builds/win32/stable/
HTH

On Wed, 1 May 2024 at 22:07, Paul Kroitor  wrote:

> Is there a way to get the Transaction Report to show Account Description
> rather than Account Name in the group header lines (not the detail lines)?
>
>
>
> I have a number of expense accounts that have identical subaccounts, for
> example House-1:Property Tax and House-2:Property Tax. In the CoA, the Name
> for these sub-accounts is just Prop Tax, but the Description is House-1
> Property Tax.
>
>
>
> The problem is that Transaction Reports (when set to primary key = Account
> Name) become confusing because there become several groups simply titled
> Prop Tax with no further distinction. It would be better if it could
> somehow
> more clearly show the account hierarchy - Quicken's Itemized Categories
> report is great at this with it's collapsable tree design - but just
> showing
> the full account name would be a good start.
>
>
>
> In some reports I can choose to show the Account Description (full name),
> but the Transaction Report doesn't seem to have this option.
>
>
>
> Or perhaps I should look at approaching this from the other direction and
> look for an Income / Expense report showing full detail lines?
>
>
>
> Paul
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report Shortcomings

[Paul Kroitor]

Somehow I didn't notice that Show Full Account Name option does something in
that direction: the group header now shows "Expenses:Rental
Properties:House-1:Prop Tax" which does at least disambiguate but is still
pretty clunky. My Account Description fields do already contain exactly the
perfect descriptions -- I just can't see a way to show them!

Paul

-Original Message-
From: gnucash-user  On
Behalf Of Paul Kroitor
Sent: Wednesday, May 1, 2024 10:07 AM
To: 'Gnucash Users' 
Subject: [GNC] Transaction Report Shortcomings

Is there a way to get the Transaction Report to show Account Description
rather than Account Name in the group header lines (not the detail lines)?

 

I have a number of expense accounts that have identical subaccounts, for
example House-1:Property Tax and House-2:Property Tax. In the CoA, the Name
for these sub-accounts is just Prop Tax, but the Description is House-1
Property Tax.

 

The problem is that Transaction Reports (when set to primary key = Account
Name) become confusing because there become several groups simply titled
Prop Tax with no further distinction. It would be better if it could somehow
more clearly show the account hierarchy - Quicken's Itemized Categories
report is great at this with it's collapsable tree design - but just showing
the full account name would be a good start.

 

In some reports I can choose to show the Account Description (full name),
but the Transaction Report doesn't seem to have this option.

 

Or perhaps I should look at approaching this from the other direction and
look for an Income / Expense report showing full detail lines?

 

Paul 

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

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

[GNC] Transaction Report Shortcomings

[Paul Kroitor]

Is there a way to get the Transaction Report to show Account Description
rather than Account Name in the group header lines (not the detail lines)?

 

I have a number of expense accounts that have identical subaccounts, for
example House-1:Property Tax and House-2:Property Tax. In the CoA, the Name
for these sub-accounts is just Prop Tax, but the Description is House-1
Property Tax.

 

The problem is that Transaction Reports (when set to primary key = Account
Name) become confusing because there become several groups simply titled
Prop Tax with no further distinction. It would be better if it could somehow
more clearly show the account hierarchy - Quicken's Itemized Categories
report is great at this with it's collapsable tree design - but just showing
the full account name would be a good start.

 

In some reports I can choose to show the Account Description (full name),
but the Transaction Report doesn't seem to have this option.

 

Or perhaps I should look at approaching this from the other direction and
look for an Income / Expense report showing full detail lines?

 

Paul 

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

Re: [GNC] Transaction Report - Split Transactions

[John Dimitriadis]

Hello Vincent,

Happy New Year. 

Hope my email finds you well.

Just wanted to touch base to see if you managed to take any action on the below?

Many thanks in advance.

> On 19 May 2023, at 08:16, John Dimitriadis  wrote:
> 
> Hello Vincent,
> 
> Thank you very much for the detailed and quick response!
> 
> Splitting the transaction into two separate ones is something I thought of as 
> well, however I concluded that I rather not have perfect reports but  have my 
> transactions properly organised. 
> 
> The tags report is something I came across while looking for a solution, but 
> as you say it is still not ideal. However I am considering it, as at the 
> moment I use some “dimension accounts” which I add into splits with zero 
> credit/debit and use as references when I want to create a report on 
> projects, to gather related expenses from different accounts. So I might be 
> using the tags instead going forward.
> 
> If you manage to make any changes that will resolve the reporting assuming 
> that splits are only on either Debit or Credit side, then that would be 
> great! Otherwise I am sure we will be just fine ! :)
> 
> Thank you once again!
> 
>> On 18 May 2023, at 02:27, Vincent Dawans  wrote:
>> 
>> The last one should show this for proper credit/debi sides
>> 
>> Checking account  100
>> Electricity   60   #OwnerA 
>> in the split memo
>> Electricity   40   #OwnerB 
>> in the split memo
>> 
>> On Wed, May 17, 2023 at 4:26 PM Vincent Dawans > > wrote:
>>> Unfortunately that is a limitation on how the splits work and I have run 
>>> into this myself.
>>> 
>>> When you look at it from the expense accounts, every transaction has a 3 
>>> way split because of the 2 owner accounts, so unfortunately there is no way 
>>> to group by owner account as the secondary sort
>>> When you look at it the other way, selecting Owner A and B as the accounts 
>>> to report on, every transaction is still split because of the other owner 
>>> account, so there is no way to group by owner as primary then expense as 
>>> secondary. You can still get the correct total for each owner, but not the 
>>> subtotal by expense account.
>>> 
>>> It could be an interesting thing to try to change. When showing a split on 
>>> the credit side, and the multiple splits are ONLY on the credit side, then 
>>> we should be able to show the single debit side account name as the other 
>>> account instead of showing "split transaction"; same for the other way 
>>> around, When showing a split on the debit side, and the multiple splits are 
>>> ONLY on the debit side, then we should be able to show the single credit 
>>> side account name as other account instead of showing "split transaction";
>>> 
>>> I might look at changing this as it would help as well because I have 
>>> several reports where I have ran into this problem
>>> 
>>> The alternative is to only use simple transactions, which essentially means 
>>> splitting your transactions into 2. So instead of 
>>> 
>>> Electricity 100
>>> Owner A  60
>>> Owner B 40
>>> 
>>> you end up with 2 transactions
>>> 
>>> Electricity 60
>>> Owner A  60
>>> 
>>> Electricity 40
>>> Owner B 40
>>> 
>>> But it's not really very nice
>>> 
>>> I have also an experimental report using tags but that would require 
>>> changing your setup as well. It would still require splitting the expenses 
>>> however, but both splits could be kept in the same transactions. Only 
>>> advantage is you could get rid of the owner accounts UNLESS they are actual 
>>> escrow accounts (instead of report placeholders while the actual payment is 
>>> done from a single asset account). 
>>> Checking account 100
>>> Electricity60  #OwnerA in the split memo
>>> Electricity40  #OwnerB in the split memo
>>> 
>>> Here it is if you want to give that a try: 
>>> https://github.com/dawansv/gnucash-transaction-tags
>>> 
>>> But ultimately allowing the single matching debit/credit side to show 
>>> instead of "split transactions" would be a more useful solution. I'll look 
>>> at whether I can get that done but it might take a little while.
>>> 
>>> On Wed, May 17, 2023 at 3:22 PM John Dimitriadis >> > wrote:
 Hello,
 
 I have a Gnucash file, which I use to track expenses for a jointly owned 
 property. 
 
 Under Assets, I have two accounts. One for myself and one for the other 
 owner.
 
 Under Expenses, I have the Property, and under that I have sub-accounts 
 for the various types of expenses (eg. Taxes, Service Charges, 
 Maintenance, Bills etc).
 
 A number of the expenses transactions have split entries. Either because 
 something was paid by both owners, or because I keep more detailed records.
 
 I am trying to come 

Re: [GNC] Transaction Report Options menu bug report

[Stephen M. Butler]

Was there in 5.4-62 but fixed by 5.4-117.  I did a git pull and then a 
local build.


Guess I should have tried that first.

On 12/1/23 13:31, Glenn Fowler wrote:

Hi,

This has been fixed since the 5.4 release if you want to try a daily 
build: https://code.gnucash.org/builds/flatpak/stable/


On Fri, Dec 1, 2023 at 3:27 PM Stephen M. Butler  wrote:

799149  filed. 
After
initial set of options for Transaction Report, then the Options,
Print
and Make PDF menu options are greyed out on the menu bar.

Screenshot attached to bug report.

Ubuntu 23.10 and GnuCash Version: 5.4  Build ID: git
5.4-62-g2ca6cb2a34+(2023-11-03)
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


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

Re: [GNC] Transaction Report Options menu bug report

[Stephen M. Butler]

I will update the bug report as I did a git pull for 5.4-117, did the 
build and all works as expected.

I'm going to presume fixed between patch 62 and 117.

On 12/1/23 13:34, Adrien Monteleone wrote:

Might be something in a dependency in 23.10.

I can report it also works fine on MacOS.

Regards,
Adrien

On 12/1/23 2:52 PM, Murugan Muruganandam wrote:

i am able to print and make pdf


Gnucash 5.4 Build Flathub 5.4.1 Ubuntu 22.04.3


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


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

Re: [GNC] Transaction Report Options menu bug report

[Glenn Fowler]

Hi,

This has been fixed since the 5.4 release if you want to try a daily build:
https://code.gnucash.org/builds/flatpak/stable/

On Fri, Dec 1, 2023 at 3:27 PM Stephen M. Butler  wrote:

> 799149  filed.  After
> initial set of options for Transaction Report, then the Options, Print
> and Make PDF menu options are greyed out on the menu bar.
>
> Screenshot attached to bug report.
>
> Ubuntu 23.10 and GnuCash Version: 5.4  Build ID: git
> 5.4-62-g2ca6cb2a34+(2023-11-03)
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report Options menu bug report

[Adrien Monteleone]

Might be something in a dependency in 23.10.

I can report it also works fine on MacOS.

Regards,
Adrien

On 12/1/23 2:52 PM, Murugan Muruganandam wrote:

i am able to print and make pdf


Gnucash 5.4 Build Flathub 5.4.1 Ubuntu 22.04.3


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

Re: [GNC] Transaction Report Options menu bug report

[Murugan Muruganandam]

i am able to print and make pdf


Gnucash 5.4 Build Flathub 5.4.1 Ubuntu 22.04.3


Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Stephen M. Butler 
Sent: Friday, December 1, 2023 5:27 PM
To: GnuCash Users 
Subject: [GNC] Transaction Report Options menu bug report

799149 <https://bugs.gnucash.org/show_bug.cgi?id=799149> filed.  After
initial set of options for Transaction Report, then the Options, Print
and Make PDF menu options are greyed out on the menu bar.

Screenshot attached to bug report.

Ubuntu 23.10 and GnuCash Version: 5.4  Build ID: git
5.4-62-g2ca6cb2a34+(2023-11-03)
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Transaction Report Options menu bug report

[Stephen M. Butler]

799149  filed.  After 
initial set of options for Transaction Report, then the Options, Print 
and Make PDF menu options are greyed out on the menu bar.


Screenshot attached to bug report.

Ubuntu 23.10 and GnuCash Version: 5.4  Build ID: git 
5.4-62-g2ca6cb2a34+(2023-11-03)
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report - Split Transactions

[Vincent Dawans]

For those interested by this feature providing a more permissive match in
the transaction report to reduce the number of "split transaction", I have
implemented this feature in my custom "Transaction Report Extended" here
https://github.com/dawansv/gnucash-custom-reports

The option to enable the more permissive match is on the display tab: "Use
More Permissive Match for Other Account Name and Code".

The permissive match finds more matches by doing the following:
+ Splits on the same side as main split are ignored.
+ Splits with zero value are excluded unless main split is zero as well.
+ If there is still more than one other split, then split on the other side
with same value is matched.

It still shows "split transaction" when there is still more than one split
left after these additional matches

On Fri, May 19, 2023 at 4:37 PM Vincent Dawans  wrote:

> I have submitted a draft PR with changes that would address your use case
> (as well as mine -- I have a set of books for a small nonprofit that I like
> to export in a Google Sheet ledger for simple reporting to the board -- but
> it shows a lot of sad looking "Split Transaction" as well). As you say it's
> not a total deal breaker but essentially we can probably afford  to have a
> more aggressive "other account" match in the reports (where the data is
> only read, not changed) while keeping a more conservative approach in the
> register (where changes are made, hence it's better to work in the split
> view to avoid errors at that point). See
> https://github.com/Gnucash/gnucash/pull/1637  We will have to see what
> form it takes at the end, but could also be done in a custom report if it's
> considered too "risky" for the main report.
>
> On Fri, May 19, 2023 at 4:39 AM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
>> As Vincent noted, you probably can't get there in one report, but
>> consider experimenting with the multi-column report where you can have
>> multiple transaction reports in one screen.
>>
>> Another alternative would be to run the report for each owner, and
>> copy/paste or export to a spreadsheet for further manipulation.
>>
>> Regards,
>> Adrien
>>
>> On 5/16/23 3:24 AM, John Dimitriadis wrote:
>> > Hello,
>> >
>> > I have a Gnucash file, which I use to track expenses for a jointly
>> owned property.
>> >
>> > Under Assets, I have two accounts. One for myself and one for the other
>> owner.
>> >
>> > Under Expenses, I have the Property, and under that I have sub-accounts
>> for the various types of expenses (eg. Taxes, Service Charges, Maintenance,
>> Bills etc).
>> >
>> > A number of the expenses transactions have split entries. Either
>> because something was paid by both owners, or because I keep more detailed
>> records.
>> >
>> > I am trying to come up with a Transaction Report that will summarise:
>> > (a) Total Expenses
>> > (b) Breakdown of Expenses per sub-Account (i.e. type of expense)
>> > (c) How much was paid by each owner, of each type of expense
>> >
>> > The problem I am facing and have not managed to solve no matter what I
>> have tried, is that for the Split Transactions, when Sorting with “Other
>> Account”, I just get a groups for “Split Transaction”, and thus lose the
>> transparency of the Sub-Account or if I structure the Transaction report
>> differently, I lose the transparency/sum for the account from which the
>> payment was made.
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report - Split Transactions

[Vincent Dawans]

I have submitted a draft PR with changes that would address your use case
(as well as mine -- I have a set of books for a small nonprofit that I like
to export in a Google Sheet ledger for simple reporting to the board -- but
it shows a lot of sad looking "Split Transaction" as well). As you say it's
not a total deal breaker but essentially we can probably afford  to have a
more aggressive "other account" match in the reports (where the data is
only read, not changed) while keeping a more conservative approach in the
register (where changes are made, hence it's better to work in the split
view to avoid errors at that point). See
https://github.com/Gnucash/gnucash/pull/1637  We will have to see what form
it takes at the end, but could also be done in a custom report if it's
considered too "risky" for the main report.

On Fri, May 19, 2023 at 4:39 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> As Vincent noted, you probably can't get there in one report, but
> consider experimenting with the multi-column report where you can have
> multiple transaction reports in one screen.
>
> Another alternative would be to run the report for each owner, and
> copy/paste or export to a spreadsheet for further manipulation.
>
> Regards,
> Adrien
>
> On 5/16/23 3:24 AM, John Dimitriadis wrote:
> > Hello,
> >
> > I have a Gnucash file, which I use to track expenses for a jointly owned
> property.
> >
> > Under Assets, I have two accounts. One for myself and one for the other
> owner.
> >
> > Under Expenses, I have the Property, and under that I have sub-accounts
> for the various types of expenses (eg. Taxes, Service Charges, Maintenance,
> Bills etc).
> >
> > A number of the expenses transactions have split entries. Either because
> something was paid by both owners, or because I keep more detailed records.
> >
> > I am trying to come up with a Transaction Report that will summarise:
> > (a) Total Expenses
> > (b) Breakdown of Expenses per sub-Account (i.e. type of expense)
> > (c) How much was paid by each owner, of each type of expense
> >
> > The problem I am facing and have not managed to solve no matter what I
> have tried, is that for the Split Transactions, when Sorting with “Other
> Account”, I just get a groups for “Split Transaction”, and thus lose the
> transparency of the Sub-Account or if I structure the Transaction report
> differently, I lose the transparency/sum for the account from which the
> payment was made.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report - Split Transactions

[John Dimitriadis]

Hello Vincent,

Thank you very much for the detailed and quick response!

Splitting the transaction into two separate ones is something I thought of as 
well, however I concluded that I rather not have perfect reports but  have my 
transactions properly organised. 

The tags report is something I came across while looking for a solution, but as 
you say it is still not ideal. However I am considering it, as at the moment I 
use some “dimension accounts” which I add into splits with zero credit/debit 
and use as references when I want to create a report on projects, to gather 
related expenses from different accounts. So I might be using the tags instead 
going forward.

If you manage to make any changes that will resolve the reporting assuming that 
splits are only on either Debit or Credit side, then that would be great! 
Otherwise I am sure we will be just fine ! :)

Thank you once again!

> On 18 May 2023, at 02:27, Vincent Dawans  wrote:
> 
> The last one should show this for proper credit/debi sides
> 
> Checking account  100
> Electricity   60   #OwnerA in 
> the split memo
> Electricity   40   #OwnerB in 
> the split memo
> 
> On Wed, May 17, 2023 at 4:26 PM Vincent Dawans  > wrote:
>> Unfortunately that is a limitation on how the splits work and I have run 
>> into this myself.
>> 
>> When you look at it from the expense accounts, every transaction has a 3 way 
>> split because of the 2 owner accounts, so unfortunately there is no way to 
>> group by owner account as the secondary sort
>> When you look at it the other way, selecting Owner A and B as the accounts 
>> to report on, every transaction is still split because of the other owner 
>> account, so there is no way to group by owner as primary then expense as 
>> secondary. You can still get the correct total for each owner, but not the 
>> subtotal by expense account.
>> 
>> It could be an interesting thing to try to change. When showing a split on 
>> the credit side, and the multiple splits are ONLY on the credit side, then 
>> we should be able to show the single debit side account name as the other 
>> account instead of showing "split transaction"; same for the other way 
>> around, When showing a split on the debit side, and the multiple splits are 
>> ONLY on the debit side, then we should be able to show the single credit 
>> side account name as other account instead of showing "split transaction";
>> 
>> I might look at changing this as it would help as well because I have 
>> several reports where I have ran into this problem
>> 
>> The alternative is to only use simple transactions, which essentially means 
>> splitting your transactions into 2. So instead of 
>> 
>> Electricity 100
>> Owner A  60
>> Owner B 40
>> 
>> you end up with 2 transactions
>> 
>> Electricity 60
>> Owner A  60
>> 
>> Electricity 40
>> Owner B 40
>> 
>> But it's not really very nice
>> 
>> I have also an experimental report using tags but that would require 
>> changing your setup as well. It would still require splitting the expenses 
>> however, but both splits could be kept in the same transactions. Only 
>> advantage is you could get rid of the owner accounts UNLESS they are actual 
>> escrow accounts (instead of report placeholders while the actual payment is 
>> done from a single asset account). 
>> Checking account 100
>> Electricity60  #OwnerA in the split memo
>> Electricity40  #OwnerB in the split memo
>> 
>> Here it is if you want to give that a try: 
>> https://github.com/dawansv/gnucash-transaction-tags
>> 
>> But ultimately allowing the single matching debit/credit side to show 
>> instead of "split transactions" would be a more useful solution. I'll look 
>> at whether I can get that done but it might take a little while.
>> 
>> On Wed, May 17, 2023 at 3:22 PM John Dimitriadis > > wrote:
>>> Hello,
>>> 
>>> I have a Gnucash file, which I use to track expenses for a jointly owned 
>>> property. 
>>> 
>>> Under Assets, I have two accounts. One for myself and one for the other 
>>> owner.
>>> 
>>> Under Expenses, I have the Property, and under that I have sub-accounts for 
>>> the various types of expenses (eg. Taxes, Service Charges, Maintenance, 
>>> Bills etc).
>>> 
>>> A number of the expenses transactions have split entries. Either because 
>>> something was paid by both owners, or because I keep more detailed records.
>>> 
>>> I am trying to come up with a Transaction Report that will summarise:
>>> (a) Total Expenses
>>> (b) Breakdown of Expenses per sub-Account (i.e. type of expense)
>>> (c) How much was paid by each owner, of each type of expense
>>> 
>>> The problem I am facing and have not managed to solve no matter what I have 
>>> tried, is that for the Split Transactions, when Sorting with 

Re: [GNC] Transaction Report - Split Transactions

[Adrien Monteleone]

As Vincent noted, you probably can't get there in one report, but 
consider experimenting with the multi-column report where you can have 
multiple transaction reports in one screen.


Another alternative would be to run the report for each owner, and 
copy/paste or export to a spreadsheet for further manipulation.


Regards,
Adrien

On 5/16/23 3:24 AM, John Dimitriadis wrote:

Hello,

I have a Gnucash file, which I use to track expenses for a jointly owned 
property.

Under Assets, I have two accounts. One for myself and one for the other owner.

Under Expenses, I have the Property, and under that I have sub-accounts for the 
various types of expenses (eg. Taxes, Service Charges, Maintenance, Bills etc).

A number of the expenses transactions have split entries. Either because 
something was paid by both owners, or because I keep more detailed records.

I am trying to come up with a Transaction Report that will summarise:
(a) Total Expenses
(b) Breakdown of Expenses per sub-Account (i.e. type of expense)
(c) How much was paid by each owner, of each type of expense

The problem I am facing and have not managed to solve no matter what I have 
tried, is that for the Split Transactions, when Sorting with “Other Account”, I 
just get a groups for “Split Transaction”, and thus lose the transparency of 
the Sub-Account or if I structure the Transaction report differently, I lose 
the transparency/sum for the account from which the payment was made.


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

Re: [GNC] Transaction Report - Split Transactions

[Michael or Penny Novack]

Look, we can tell you how to use gnucash to do double-entry bookkeeping. 
But it is beyond our remit to tell you how to set up books for this or 
that type of entity.


For example, I lack the "qualifications" to advise you the way a CPA 
could. But I do know something about it, so I will give you some hints 
as to what you need to learn in order to DIY.


You are describing an entity that is a "partnership". So you should want 
to set up the books for this property that way. Notice that I am talking 
about the entity, not your personal books, because it will be much 
easier that way. Obtain a text (paper or on-line) along the lines of 
"accounting for partnerships 101".


If you have a set of books for this entity, you should NOT have to split 
each and every transaction! Depending on the frequency you want to do 
this, every month, or every quarter, or annually you can allocate each 
partner's share (of income, of expenses, etc.). If you have a separate 
set of books for the entity, on your books your share of the property 
would be an asset (like other forms of investments)


The reason I am unwilling to give advice in more detail (the way the 
accountant would) is that exactly how done depends on lots of things. 
For example, is this a rental property? Do either or both of you live in 
it? Etc.


Michael D Novack





On 5/16/2023 4:24 AM, John Dimitriadis wrote:

Hello,

I have a Gnucash file, which I use to track expenses for a jointly owned 
property.

Under Assets, I have two accounts. One for myself and one for the other owner.

Under Expenses, I have the Property, and under that I have sub-accounts for the 
various types of expenses (eg. Taxes, Service Charges, Maintenance, Bills etc).

A number of the expenses transactions have split entries. Either because 
something was paid by both owners, or because I keep more detailed records.

I am trying to come up with a Transaction Report that will summarise:
(a) Total Expenses
(b) Breakdown of Expenses per sub-Account (i.e. type of expense)
(c) How much was paid by each owner, of each type of expense

The problem I am facing and have not managed to solve no matter what I have 
tried, is that for the Split Transactions, when Sorting with “Other Account”, I 
just get a groups for “Split Transaction”, and thus lose the transparency of 
the Sub-Account or if I structure the Transaction report differently, I lose 
the transparency/sum for the account from which the payment was made.

Any help would be welcome.

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



--
There is no possibility of social justice on a dead planet except the equality 
of the grave.

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

Re: [GNC] Transaction Report - Split Transactions

[Vincent Dawans]

The last one should show this for proper credit/debi sides

Checking account  100
Electricity   60   #OwnerA
in the split memo
Electricity   40   #OwnerB
in the split memo

On Wed, May 17, 2023 at 4:26 PM Vincent Dawans  wrote:

> Unfortunately that is a limitation on how the splits work and I have run
> into this myself.
>
> When you look at it from the expense accounts, every transaction has a 3
> way split because of the 2 owner accounts, so unfortunately there is no way
> to group by owner account as the secondary sort
> When you look at it the other way, selecting Owner A and B as the accounts
> to report on, every transaction is still split because of the other owner
> account, so there is no way to group by owner as primary then expense as
> secondary. You can still get the correct total for each owner, but not the
> subtotal by expense account.
>
> It could be an interesting thing to try to change. When showing a split on
> the credit side, and the multiple splits are ONLY on the credit side, then
> we should be able to show the single debit side account name as the other
> account instead of showing "split transaction"; same for the other way
> around, When showing a split on the debit side, and the multiple splits are
> ONLY on the debit side, then we should be able to show the single credit
> side account name as other account instead of showing "split transaction";
>
> I might look at changing this as it would help as well because I have
> several reports where I have ran into this problem
>
> The alternative is to only use simple transactions, which essentially
> means splitting your transactions into 2. So instead of
>
> Electricity 100
> Owner A  60
> Owner B 40
>
> you end up with 2 transactions
>
> Electricity 60
> Owner A  60
>
> Electricity 40
> Owner B 40
>
> But it's not really very nice
>
> I have also an experimental report using tags but that would require
> changing your setup as well. It would still require splitting the expenses
> however, but both splits could be kept in the same transactions. Only
> advantage is you could get rid of the owner accounts UNLESS they are actual
> escrow accounts (instead of report placeholders while the actual payment is
> done from a single asset account).
> Checking account 100
> Electricity60  #OwnerA in the split memo
> Electricity40  #OwnerB in the split memo
>
> Here it is if you want to give that a try:
> https://github.com/dawansv/gnucash-transaction-tags
>
> But ultimately allowing the single matching debit/credit side to show
> instead of "split transactions" would be a more useful solution. I'll look
> at whether I can get that done but it might take a little while.
>
> On Wed, May 17, 2023 at 3:22 PM John Dimitriadis 
> wrote:
>
>> Hello,
>>
>> I have a Gnucash file, which I use to track expenses for a jointly owned
>> property.
>>
>> Under Assets, I have two accounts. One for myself and one for the other
>> owner.
>>
>> Under Expenses, I have the Property, and under that I have sub-accounts
>> for the various types of expenses (eg. Taxes, Service Charges, Maintenance,
>> Bills etc).
>>
>> A number of the expenses transactions have split entries. Either because
>> something was paid by both owners, or because I keep more detailed records.
>>
>> I am trying to come up with a Transaction Report that will summarise:
>> (a) Total Expenses
>> (b) Breakdown of Expenses per sub-Account (i.e. type of expense)
>> (c) How much was paid by each owner, of each type of expense
>>
>> The problem I am facing and have not managed to solve no matter what I
>> have tried, is that for the Split Transactions, when Sorting with “Other
>> Account”, I just get a groups for “Split Transaction”, and thus lose the
>> transparency of the Sub-Account or if I structure the Transaction report
>> differently, I lose the transparency/sum for the account from which the
>> payment was made.
>>
>> Any help would be welcome.
>>
>> Thank you!
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report - Split Transactions

[Vincent Dawans]

Unfortunately that is a limitation on how the splits work and I have run
into this myself.

When you look at it from the expense accounts, every transaction has a 3
way split because of the 2 owner accounts, so unfortunately there is no way
to group by owner account as the secondary sort
When you look at it the other way, selecting Owner A and B as the accounts
to report on, every transaction is still split because of the other owner
account, so there is no way to group by owner as primary then expense as
secondary. You can still get the correct total for each owner, but not the
subtotal by expense account.

It could be an interesting thing to try to change. When showing a split on
the credit side, and the multiple splits are ONLY on the credit side, then
we should be able to show the single debit side account name as the other
account instead of showing "split transaction"; same for the other way
around, When showing a split on the debit side, and the multiple splits are
ONLY on the debit side, then we should be able to show the single credit
side account name as other account instead of showing "split transaction";

I might look at changing this as it would help as well because I have
several reports where I have ran into this problem

The alternative is to only use simple transactions, which essentially means
splitting your transactions into 2. So instead of

Electricity 100
Owner A  60
Owner B 40

you end up with 2 transactions

Electricity 60
Owner A  60

Electricity 40
Owner B 40

But it's not really very nice

I have also an experimental report using tags but that would require
changing your setup as well. It would still require splitting the expenses
however, but both splits could be kept in the same transactions. Only
advantage is you could get rid of the owner accounts UNLESS they are actual
escrow accounts (instead of report placeholders while the actual payment is
done from a single asset account).
Checking account 100
Electricity60  #OwnerA in the split memo
Electricity40  #OwnerB in the split memo

Here it is if you want to give that a try:
https://github.com/dawansv/gnucash-transaction-tags

But ultimately allowing the single matching debit/credit side to show
instead of "split transactions" would be a more useful solution. I'll look
at whether I can get that done but it might take a little while.

On Wed, May 17, 2023 at 3:22 PM John Dimitriadis  wrote:

> Hello,
>
> I have a Gnucash file, which I use to track expenses for a jointly owned
> property.
>
> Under Assets, I have two accounts. One for myself and one for the other
> owner.
>
> Under Expenses, I have the Property, and under that I have sub-accounts
> for the various types of expenses (eg. Taxes, Service Charges, Maintenance,
> Bills etc).
>
> A number of the expenses transactions have split entries. Either because
> something was paid by both owners, or because I keep more detailed records.
>
> I am trying to come up with a Transaction Report that will summarise:
> (a) Total Expenses
> (b) Breakdown of Expenses per sub-Account (i.e. type of expense)
> (c) How much was paid by each owner, of each type of expense
>
> The problem I am facing and have not managed to solve no matter what I
> have tried, is that for the Split Transactions, when Sorting with “Other
> Account”, I just get a groups for “Split Transaction”, and thus lose the
> transparency of the Sub-Account or if I structure the Transaction report
> differently, I lose the transparency/sum for the account from which the
> payment was made.
>
> Any help would be welcome.
>
> Thank you!
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Transaction Report - Split Transactions

[John Dimitriadis]

Hello,

I have a Gnucash file, which I use to track expenses for a jointly owned 
property. 

Under Assets, I have two accounts. One for myself and one for the other owner.

Under Expenses, I have the Property, and under that I have sub-accounts for the 
various types of expenses (eg. Taxes, Service Charges, Maintenance, Bills etc).

A number of the expenses transactions have split entries. Either because 
something was paid by both owners, or because I keep more detailed records.

I am trying to come up with a Transaction Report that will summarise:
(a) Total Expenses
(b) Breakdown of Expenses per sub-Account (i.e. type of expense)
(c) How much was paid by each owner, of each type of expense

The problem I am facing and have not managed to solve no matter what I have 
tried, is that for the Split Transactions, when Sorting with “Other Account”, I 
just get a groups for “Split Transaction”, and thus lose the transparency of 
the Sub-Account or if I structure the Transaction report differently, I lose 
the transparency/sum for the account from which the payment was made.

Any help would be welcome.

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

Re: [GNC] Transaction Report Advance Portfolio - Options - Account List

[john]

> On May 7, 2023, at 1:17 AM, Martin Booth via gnucash-user 
>  wrote:
> 
> 
> I am running GNUCash - 5.1 flatpak on debian 11.I have been using GC for 
> 15years now and the Advance Portfolio report does not list all the COA or 
> highlight the selected accounts the report is based on unlike earlier 
> versions > 4.xx. This also applies to the investment portfolio report
> 
> Selecting Reports>>Assets & Liabilities>>Advance Portfolio>> report runs fine
> I want to change this report so that I can run the report from each 
> investment broker selected from COA. 
> 
> Selecting Reports>>Advance Portfolio>>options>>accounts
> It fails to list all the COA, it only lists Assets and the sub accounts under 
> this e.g. fixed assets and current assets and I have retirement assets but 
> not list my investment assets .
> It also does not list which accounts the report is based on and it fails to 
> show equity, expenses or liabilities as previous versions of GC.
> Therefore I cannot select/filter the report by investment broker as previous 
> GC versions.
> I ran my report on GC 4.13 and I can create and amend the report with all COA 
> listed in the default Advanced Portfolio options (GC 4.13 running my VM), but 
> the current release 5.1 does not show all the accounts and it cannot be 
> modified. 

As part of rewriting the options code I fixed a bug in the Advance Portfolio 
Report: The accounts presented for selection are filtered to Asset, Stock, and 
Mutual Fund, and the default selection is all accounts of type stock and mutual 
fund. Makes sense, right? It had been in the report code all along but the 
implementation of the account option tree view didn't work right so you got the 
whole CoA. Now it works. Great, right? Not quite. The problem is that the 
accounts page in the options does a recursive search and it filters out parent 
accounts that aren't one of those types so if you have stock accounts under, 
for example, a Bank account they won't display on the selector. The initial 
query that loads the report does the filtering only on the leaf accounts so it 
gets all of the stock and mutual fund accounts, but if you open Options the 
GtkTreeView drops them--even if you don't visit that page on the options dialog.

This was first reported in https://bugs.gnucash.org/show_bug.cgi?id=798796

Regards,
John Ralls

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

Re: [GNC] Transaction Report Advance Portfolio - Options - Account List

[Murugan Muruganandam]

martin

The accounts selection windows is scrollable, it is not visible but you can 
scroll to see all the accounts.

to check, you can click on select all button , which will display the full COA




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Martin Booth via gnucash-user 
Sent: Sunday, May 7, 2023 4:17 AM
To: gnucash-user@gnucash.org 
Subject: [GNC] Transaction Report Advance Portfolio - Options - Account List


I am running GNUCash - 5.1 flatpak on debian 11.I have been using GC for 
15years now and the Advance Portfolio report does not list all the COA or 
highlight the selected accounts the report is based on unlike earlier versions 
> 4.xx. This also applies to the investment portfolio report

Selecting Reports>>Assets & Liabilities>>Advance Portfolio>> report runs fine
I want to change this report so that I can run the report from each investment 
broker selected from COA.

Selecting Reports>>Advance Portfolio>>options>>accounts
It fails to list all the COA, it only lists Assets and the sub accounts under 
this e.g. fixed assets and current assets and I have retirement assets but not 
list my investment assets .
It also does not list which accounts the report is based on and it fails to 
show equity, expenses or liabilities as previous versions of GC.
Therefore I cannot select/filter the report by investment broker as previous GC 
versions.
I ran my report on GC 4.13 and I can create and amend the report with all COA 
listed in the default Advanced Portfolio options (GC 4.13 running my VM), but 
the current release 5.1 does not show all the accounts and it cannot be 
modified.

I believe this will apply to other users so I will submit a bug report.
thanks,Martin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Transaction Report Advance Portfolio - Options - Account List

[Martin Booth via gnucash-user]

I am running GNUCash - 5.1 flatpak on debian 11.I have been using GC for 
15years now and the Advance Portfolio report does not list all the COA or 
highlight the selected accounts the report is based on unlike earlier versions 
> 4.xx. This also applies to the investment portfolio report

Selecting Reports>>Assets & Liabilities>>Advance Portfolio>> report runs fine
I want to change this report so that I can run the report from each investment 
broker selected from COA. 

Selecting Reports>>Advance Portfolio>>options>>accounts
It fails to list all the COA, it only lists Assets and the sub accounts under 
this e.g. fixed assets and current assets and I have retirement assets but not 
list my investment assets .
It also does not list which accounts the report is based on and it fails to 
show equity, expenses or liabilities as previous versions of GC.
Therefore I cannot select/filter the report by investment broker as previous GC 
versions.
I ran my report on GC 4.13 and I can create and amend the report with all COA 
listed in the default Advanced Portfolio options (GC 4.13 running my VM), but 
the current release 5.1 does not show all the accounts and it cannot be 
modified. 

I believe this will apply to other users so I will submit a bug report.
thanks,Martin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report not working

[Chris Ledbetter via gnucash-user]

Thank you, I will try upgrading.

> On Apr 10, 2023, at 4:08 PM, Tommy Trussell  wrote:
> 
> Hi! Please remember to copy the GnuCash List on all replies. Thanks for your 
> version information.
> 
> Since you're using an older version, you might try a more recent version. 
> Version 5.0 is available, as well as the last of the 4.x versions, 4.14. If 
> you want to be completely cautious you might try upgrading to 4.14 first and 
> plan to upgrade to the newer version later.
> 
> https://www.gnucash.org/download.phtml
> 
> 
> 
> On Mon, Apr 10, 2023 at 2:09 PM Chris Ledbetter  > wrote:
>> Hi, I found about in Help via Search:
>> Version: 4.12
>> Build ID: 4.12+(2022-09-24)
>> Finance::Quote: -
>> 
>>> On Apr 10, 2023, at 1:50 PM, Tommy Trussell >> > wrote:
>>> 
>>> On Mon, Apr 10, 2023 at 11:13 AM Chris Ledbetter via gnucash-user 
>>> mailto:gnucash-user@gnucash.org>> wrote:
 Hi - New to gnucash and am inputting all accounts.  Trying to run a 
 Transaction report but after hitting options, I am not able to choose any 
 options. It opens to the General Tab of options but I am not able to 
 select any tab such as Accounts etc and am not able to select anything in 
 the General tab.  I click on the interface and it takes me back to the 
 Transaction Report with no information, just a link to options.
 
 MacBook Pro M1, Ventura 13.3.1
 Sorry I can’t figure out what version. (It’s probably stable 5.0)
>>> 
>>> Are you able to choose 
>>> 
>>> Help --> About 
>>> 
>>> in GnuCash? That will show you the version you are using.
>>> 
>>> As for not being able to choose any of the report options, I have not seen 
>>> that happen, so I cannot advise. 
>>> 
>>> If you suspect the download might have been glitchy, you might try 
>>> downloading GnuCash again. As long as you've saved your data file you won't 
>>> lose any of your entries. Be sure to get an official stable release version 
>>> for your operating system as linked from www,gnucash.org 
>>>  and install it as you normally would (copy and run it 
>>> from the Applications folder, if I recall, though it's been years since 
>>> I've used a Mac).
>>> 
>>>  
 -
 Please remember to CC this list on all your replies.
 You can do this by using Reply-To-List or Reply-All.
>> 

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

Re: [GNC] Transaction Report not working

[Tommy Trussell]

Hi! Please remember to copy the GnuCash List on all replies. Thanks for
your version information.

Since you're using an older version, you might try a more recent version.
Version 5.0 is available, as well as the last of the 4.x versions, 4.14. If
you want to be completely cautious you might try upgrading to 4.14 first
and plan to upgrade to the newer version later.

https://www.gnucash.org/download.phtml



On Mon, Apr 10, 2023 at 2:09 PM Chris Ledbetter 
wrote:

> Hi, I found about in Help via Search:
> Version: 4.12
> Build ID: 4.12+(2022-09-24)
> Finance::Quote: -
>
> On Apr 10, 2023, at 1:50 PM, Tommy Trussell 
> wrote:
>
> On Mon, Apr 10, 2023 at 11:13 AM Chris Ledbetter via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>> Hi - New to gnucash and am inputting all accounts.  Trying to run a
>> Transaction report but after hitting options, I am not able to choose any
>> options. It opens to the General Tab of options but I am not able to select
>> any tab such as Accounts etc and am not able to select anything in the
>> General tab.  I click on the interface and it takes me back to the
>> Transaction Report with no information, just a link to options.
>>
>> MacBook Pro M1, Ventura 13.3.1
>> Sorry I can’t figure out what version. (It’s probably stable 5.0)
>>
>
> Are you able to choose
>
> Help --> About
>
> in GnuCash? That will show you the version you are using.
>
> As for not being able to choose any of the report options, I have not seen
> that happen, so I cannot advise.
>
> If you suspect the download might have been glitchy, you might try
> downloading GnuCash again. As long as you've saved your data file you won't
> lose any of your entries. Be sure to get an official stable release version
> for your operating system as linked from www,gnucash.org and install it
> as you normally would (copy and run it from the Applications folder, if I
> recall, though it's been years since I've used a Mac).
>
>
>
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report not working

[Tommy Trussell]

On Mon, Apr 10, 2023 at 11:13 AM Chris Ledbetter via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi - New to gnucash and am inputting all accounts.  Trying to run a
> Transaction report but after hitting options, I am not able to choose any
> options. It opens to the General Tab of options but I am not able to select
> any tab such as Accounts etc and am not able to select anything in the
> General tab.  I click on the interface and it takes me back to the
> Transaction Report with no information, just a link to options.
>
> MacBook Pro M1, Ventura 13.3.1
> Sorry I can’t figure out what version. (It’s probably stable 5.0)
>

Are you able to choose

Help --> About

in GnuCash? That will show you the version you are using.

As for not being able to choose any of the report options, I have not seen
that happen, so I cannot advise.

If you suspect the download might have been glitchy, you might try
downloading GnuCash again. As long as you've saved your data file you won't
lose any of your entries. Be sure to get an official stable release version
for your operating system as linked from www,gnucash.org and install it as
you normally would (copy and run it from the Applications folder, if I
recall, though it's been years since I've used a Mac).



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

Re: [GNC] Transaction Report Overlaps Page Breaks

[Adrien Monteleone]

I usually have to Export, then open with a web browser and either Print 
to PDF or to a printer from there.


Regards,
Adrien

On 3/10/23 12:37 PM, p...@kroitor.ca wrote:

Hi all. Not for the first time I've run across an issue in which printing
the Transaction Report (at least - there may be others) doesn't handle page
breaks gracefully at all. Whether I click Print and choose a PDF printer, or
simply click Make PDF, the last line of page 1 is clipped horizontally so
that the top of each character is on page 1, and the bottom at the top of
page 2 (the same being true for each subsequent page break). This of course
doesn't make for professional reporting at all!

  


In fact, the only way I've found to get decent formal output is to use
Export, then open the HTML document in Word and print to a PDF printer.

  


I'm on Windows 10 running GnuCash 4.13, but the issue has been around for
years. Is there a better way to do this?


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

Re: [GNC] Transaction Report Overlaps Page Breaks

[Vincent Dawans]

If I recall older messages, this is due to an incompatibility with a third
party library used by gnuCash and Windows, so not something easily fixed by
gnuCash. Being on Can't recall exactly which library. Being on Windows as
well, I personally no longer use the Make PDF or print to PDF options
anymore. Instead I use the export to html option then open in chrome and
print to PDF from there. Added advantage is that in Chrome I can adjust the
scale when printing so that if there are only one or 2 lines on the next
page I can set it to 95% or so and get it all on one page.

On Fri, Mar 10, 2023 at 12:48 PM  wrote:

> Yes, thanks, that works - although it took some experimentation to discover
> the correct number for this installation is 9.5mm.
>
>
>
> Nonetheless, it seems a bizarre way to have to fine-tune one's print setup
> in this day and age. I can't remember going through this kind of rigamarole
> for several decades (at least, not for pagination issues).
>
>
>
> Thanks nonetheless,
>
> Paul
>
>
>
> From: Murugan Muruganandam 
> Sent: Friday, March 10, 2023 2:32 PM
> To: p...@kroitor.ca; gnucash-user@gnucash.org
> Subject: Re: [GNC] Transaction Report Overlaps Page Breaks
>
>
>
> paul
>
>
>
> In File Page Setup reduce the Bottom Margin to 7 and try it out
>
>
>
>
>
>
>
> Saludos Cordiales
>
>
>
> Murugan
>
>   _
>
> From: gnucash-user
>  <mailto:gnucash-user-bounces+m.muruganandam=hotmail@gnucash.org> > on
> behalf of p...@kroitor.ca <mailto:p...@kroitor.ca>   <mailto:p...@kroitor.ca> >
> Sent: Friday, March 10, 2023 3:37 PM
> To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> mailto:gnucash-user@gnucash.org> >
> Subject: [GNC] Transaction Report Overlaps Page Breaks
>
>
>
> Hi all. Not for the first time I've run across an issue in which printing
> the Transaction Report (at least - there may be others) doesn't handle page
> breaks gracefully at all. Whether I click Print and choose a PDF printer,
> or
> simply click Make PDF, the last line of page 1 is clipped horizontally so
> that the top of each character is on page 1, and the bottom at the top of
> page 2 (the same being true for each subsequent page break). This of course
> doesn't make for professional reporting at all!
>
>
>
> In fact, the only way I've found to get decent formal output is to use
> Export, then open the HTML document in Word and print to a PDF printer.
>
>
>
> I'm on Windows 10 running GnuCash 4.13, but the issue has been around for
> years. Is there a better way to do this?
>
>
>
> Paul
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report Overlaps Page Breaks

[paul]

Yes, thanks, that works - although it took some experimentation to discover
the correct number for this installation is 9.5mm.

 

Nonetheless, it seems a bizarre way to have to fine-tune one's print setup
in this day and age. I can't remember going through this kind of rigamarole
for several decades (at least, not for pagination issues).

 

Thanks nonetheless,

Paul

 

From: Murugan Muruganandam  
Sent: Friday, March 10, 2023 2:32 PM
To: p...@kroitor.ca; gnucash-user@gnucash.org
Subject: Re: [GNC] Transaction Report Overlaps Page Breaks

 

paul

 

In File Page Setup reduce the Bottom Margin to 7 and try it out

 

 

 

Saludos Cordiales

 

Murugan

  _  

From: gnucash-user
mailto:gnucash-user-bounces+m.muruganandam=hotmail@gnucash.org> > on
behalf of p...@kroitor.ca <mailto:p...@kroitor.ca>  mailto:p...@kroitor.ca> >
Sent: Friday, March 10, 2023 3:37 PM
To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
mailto:gnucash-user@gnucash.org> >
Subject: [GNC] Transaction Report Overlaps Page Breaks 

 

Hi all. Not for the first time I've run across an issue in which printing
the Transaction Report (at least - there may be others) doesn't handle page
breaks gracefully at all. Whether I click Print and choose a PDF printer, or
simply click Make PDF, the last line of page 1 is clipped horizontally so
that the top of each character is on page 1, and the bottom at the top of
page 2 (the same being true for each subsequent page break). This of course
doesn't make for professional reporting at all!

 

In fact, the only way I've found to get decent formal output is to use
Export, then open the HTML document in Word and print to a PDF printer.

 

I'm on Windows 10 running GnuCash 4.13, but the issue has been around for
years. Is there a better way to do this?

 

Paul

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

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

Re: [GNC] Transaction Report Overlaps Page Breaks

[Murugan Muruganandam]

paul

In File Page Setup reduce the Bottom Margin to 7 and try it out




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
p...@kroitor.ca 
Sent: Friday, March 10, 2023 3:37 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Transaction Report Overlaps Page Breaks

Hi all. Not for the first time I've run across an issue in which printing
the Transaction Report (at least - there may be others) doesn't handle page
breaks gracefully at all. Whether I click Print and choose a PDF printer, or
simply click Make PDF, the last line of page 1 is clipped horizontally so
that the top of each character is on page 1, and the bottom at the top of
page 2 (the same being true for each subsequent page break). This of course
doesn't make for professional reporting at all!



In fact, the only way I've found to get decent formal output is to use
Export, then open the HTML document in Word and print to a PDF printer.



I'm on Windows 10 running GnuCash 4.13, but the issue has been around for
years. Is there a better way to do this?



Paul

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

[GNC] Transaction Report Overlaps Page Breaks

[paul]

Hi all. Not for the first time I've run across an issue in which printing
the Transaction Report (at least - there may be others) doesn't handle page
breaks gracefully at all. Whether I click Print and choose a PDF printer, or
simply click Make PDF, the last line of page 1 is clipped horizontally so
that the top of each character is on page 1, and the bottom at the top of
page 2 (the same being true for each subsequent page break). This of course
doesn't make for professional reporting at all!

 

In fact, the only way I've found to get decent formal output is to use
Export, then open the HTML document in Word and print to a PDF printer.

 

I'm on Windows 10 running GnuCash 4.13, but the issue has been around for
years. Is there a better way to do this?

 

Paul

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

[GNC] Transaction report

[Fred Tydeman]

OS:  Linux
GnuCash 4.13
Default currency: USD

I am doing a Transaction Report for one account that is in COP for last
year.
Each month, I receive a fixed amount of COP.
In the Options for the report, in Currency, I have checked both
Common Currency and Show original currency amount.
The Report currency is USD
The price source is Last up through report date.

In the report:
The Debit column shows the same amount each month (as expected).
The Debit (USD) column shows different amounts each month.
If the price source were based upon report date, I would expect the USD
amounts to also be constant.

Perhaps, the price source is Last up through <> date.

Also, is Report date:
  Date I run the report (today)?
  End date (in General Option)?
  Something else?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report << offline >>

[Michael or Penny Novack]

I solved my problem.


I may not be using GNUCash the correct way but it works for my needs.
...
All my deposits would go to income account and all my withdrawals would come 
out of my expense account.
Since the expense account started with a zero balance it would always have a 
negative balance that would continue to grow as transactions where added as 
credit/withdrawal.


It is not so much using gnucash (in particular) the wrong way as not 
doing double entry bookkeeping properly. It means that most helper folks 
here will not be able to help you. We won't be able to answer questions 
like the one with which you began "why is this negative?"


a) Using an app like gnucash to partially automate double entry 
bookkeeping does not mean that you can skip learning the fundamentals of 
double entry bookkeeping << those who learned the old way, pen and ink 
on paper, first entering in the journal and then posting to the ledger 
accounts will know what is being automated >>  You will be far better 
off in the long run not skipping the "fundamentals".


b) Somebody like myself, having learned in the old days doing 
bookkeeping by hand, can utilize gnucash in unorthodox ways. And I do 
that sometimes. But I know how that will affect what report now means 
what, etc.  Not to be recommended until you really know what you are doing.


Michael D Novack


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

Re: [GNC] Transaction Report << offline >>

[rovero]

I solved my problem.
I created a new TYPE bank account named it expense.
Imported all my transactions from the TYPE A/payable account that was causing 
my issue to the new TYPE bank account expense.
When I did the import the dollar amount import went in as a credit/withdraw.
Created transaction report with two accounts: My Type bank income and My Type 
bank expense.
Set reverse option to credit accounts.
I now have all the transactions in the expense account that show as a negative 
dollars and the total of them as a negative dollars.

I may not be using GNUCash the correct way but it works for my needs.
My intent was to set the two accounts sort of like a checking account.
All my deposits would go to income account and all my withdrawals would come 
out of my expense account.
Since the expense account started with a zero balance it would always have a 
negative balance that would continue to grow as transactions where added as 
credit/withdrawal.
Since the income account started with a zero balance it would always have a 
positive balance that would continue to grow as transactions where added as 
debit/deposit.
The transaction report was to simply show all the expense transactions and all 
the income transactions, and then to show the Grand Total as Income minus 
Expense ( i.e balance)

Thanks Everyone For the help provided
Joe



-Original Message-
From: Michael or Penny Novack  
Sent: Friday, December 9, 2022 10:31 AM
To: rov...@comcast.net
Subject: Re: [GNC] Transaction Report << offline >>

On 12/8/2022 6:33 PM, rov...@comcast.net wrote:
> Michael,
>Hope this explains it better
>
>
> There are two accounts in the transaction report
>
> Expense  Type A/Payable
> IncomeType  Bank
>
Some fundamentals of double entry accounting.

Take a MUCH harder look at "Income Type Bank". Part of your problem is with the 
"subtypes" being allowed (both by standard accounting and gnucash.

There are only three FUNDAMENTAL types, Asset, Liability, and Equity. 
The other types will actually be under one of those. In this case you have A/P 
and Bank. Bank would be under Assets. A/P under Liabilities. 
Neither is of type Income or Expense.

When you purchased each item or otherwise incurred the expense that transaction 
was a debit to the particular expense and a credit to A/P. 
The normal balance of a liability is credit, so you were INCREASING pour 
payables balance.

When you paid each of these using the bank card that was a debit to A/P 
(reduces the temporary debt) and a credit to the bank account (reduces the bank 
account  balance). Nothing to do with any expenses, you bought with debt and 
now you are paying that debt off (transfer between asset and liability)

Your choice to use +/1 as your senses rather than debit/credit.

Michael D Novack

PS -- please note, even if you are creating the payable and immediately paying 
the bill in the logical sense still two transaction. Doing it in one means not 
using A/P so will not show in A/P totals, which I assume is what you want. But 
do note in a larger business,might be two people doing this, a "purchase clerk" 
ordering things for the company and creating bills to be paid and somebody else 
trusted with the company bank account doing the actual paying.





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

Re: [GNC] Transaction Report

[Derek Atkins]

HI,
Are you willing to share your data file?   Or create a small data file
that shows the issue?
If neither is possible, could you create screen shots of all the registers
and the report, along with the account settings, report settings, and user
preferences?
-derek

On Thu, December 8, 2022 8:10 pm, rov...@comcast.net wrote:
> Accounts are set up identical in ver 2.2.6 and 4.1.2. The "reverse sign"
> preference is set as credit in both versions.
> The transaction report is identical in both versions other than the Total
> dollars being positive in the expense section in ver 4.1.2 vs dollars
> being negative in 2.6.6
>
> Thanks
> Joe
>
> -Original Message-
> From: Derek Atkins 
> Sent: Thursday, December 8, 2022 4:56 PM
> To: rov...@comcast.net
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Transaction Report
>
> HI,
>
>
> On Thu, December 8, 2022 7:32 pm, rov...@comcast.net wrote:
>> Hope this explains it better
>>
>>
>>
>>
>>
>> There are two accounts in the transaction report
>>
>>
>>
>> Expense  Type A/Payable
>
> An A/Payable account is not an expense.  It is a liability.
>
>>
>> IncomeType  Bank
>
> Similarly, a Bank account is not an income.
>
>>
>>
>>
>> In the expense account register transactions show as a positive number
>> in the payment/debit column and the balance column is a negative
>> number that augments negative as transaction are added.
>
> It sounds like your accounts are not set up correctly.
>
>>
>>
>>
>> In the Income account register transactions show as a positive number
>> in the deposit/debit column  and the balance column is a positive
>> number that augments positive as transaction are added.
>
> Yes, because it's not Income, it is a Bank that you "labeled" Income.  And
> yes, in a Bank account, a debit increases the account value/total.
>
>>
>>
>>
>> The report is a simple one that shows all expense transactions form
>> the Expense Account as a debit/payment negative dollar amount and all
>> transactions from the Income Account as a debit/deposit positive
>> dollar amount. So in the end my grand total should be the negative sum
>> of all transactions in the Expense account minus the sum of all
>> positive transaction in the income account.
>>
>>
>>
>> Again, in ver 2.6.6 I get the desired results. In ver 4.1.2 the
>> expense account Totals show as a positive number so Instead of
>> subtracting expense from income they add together in the grand total.ie.
>>
>>
>>
>> Ver 2.6.1Expense Total ($-1200) Income Total $2400Grand
>> total
>> $1200
>>
>> Ver 4.1.2Expense Total $1200  Income Total $2400Grand
>> total
>> $3600
>
>
> You might want to check the value of your "reverse sign" preference.
> I suspect it's not the same.
>
>>
>>
>>
>> Thanks
>>
>> Joe
>
>> 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 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

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

Re: [GNC] Transaction Report

[rovero]

Accounts are set up identical in ver 2.2.6 and 4.1.2. The "reverse sign" 
preference is set as credit in both versions.
The transaction report is identical in both versions other than the Total 
dollars being positive in the expense section in ver 4.1.2 vs dollars being 
negative in 2.6.6

Thanks
Joe

-Original Message-
From: Derek Atkins  
Sent: Thursday, December 8, 2022 4:56 PM
To: rov...@comcast.net
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Transaction Report

HI,


On Thu, December 8, 2022 7:32 pm, rov...@comcast.net wrote:
> Hope this explains it better
>
>
>
>
>
> There are two accounts in the transaction report
>
>
>
> Expense  Type A/Payable

An A/Payable account is not an expense.  It is a liability.

>
> IncomeType  Bank

Similarly, a Bank account is not an income.

>
>
>
> In the expense account register transactions show as a positive number 
> in the payment/debit column and the balance column is a negative 
> number that augments negative as transaction are added.

It sounds like your accounts are not set up correctly.

>
>
>
> In the Income account register transactions show as a positive number 
> in the deposit/debit column  and the balance column is a positive 
> number that augments positive as transaction are added.

Yes, because it's not Income, it is a Bank that you "labeled" Income.  And yes, 
in a Bank account, a debit increases the account value/total.

>
>
>
> The report is a simple one that shows all expense transactions form 
> the Expense Account as a debit/payment negative dollar amount and all 
> transactions from the Income Account as a debit/deposit positive 
> dollar amount. So in the end my grand total should be the negative sum 
> of all transactions in the Expense account minus the sum of all 
> positive transaction in the income account.
>
>
>
> Again, in ver 2.6.6 I get the desired results. In ver 4.1.2 the 
> expense account Totals show as a positive number so Instead of 
> subtracting expense from income they add together in the grand total.ie.
>
>
>
> Ver 2.6.1Expense Total ($-1200) Income Total $2400Grand total
> $1200
>
> Ver 4.1.2Expense Total $1200  Income Total $2400Grand
> total
> $3600


You might want to check the value of your "reverse sign" preference.
I suspect it's not the same.

>
>
>
> Thanks
>
> Joe

> 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 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant


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

Re: [GNC] Transaction Report

[Derek Atkins]

HI,


On Thu, December 8, 2022 7:32 pm, rov...@comcast.net wrote:
> Hope this explains it better
>
>
>
>
>
> There are two accounts in the transaction report
>
>
>
> Expense  Type A/Payable

An A/Payable account is not an expense.  It is a liability.

>
> IncomeType  Bank

Similarly, a Bank account is not an income.

>
>
>
> In the expense account register transactions show as a positive number in
> the payment/debit column and the balance column is a negative number that
> augments negative as transaction are added.

It sounds like your accounts are not set up correctly.

>
>
>
> In the Income account register transactions show as a positive number in
> the
> deposit/debit column  and the balance column is a positive number that
> augments positive as transaction are added.

Yes, because it's not Income, it is a Bank that you "labeled" Income.  And
yes, in a Bank account, a debit increases the account value/total.

>
>
>
> The report is a simple one that shows all expense transactions form the
> Expense Account as a debit/payment negative dollar amount and all
> transactions from the Income Account as a debit/deposit positive dollar
> amount. So in the end my grand total should be the negative sum of all
> transactions in the Expense account minus the sum of all positive
> transaction in the income account.
>
>
>
> Again, in ver 2.6.6 I get the desired results. In ver 4.1.2 the expense
> account Totals show as a positive number so Instead of subtracting expense
> from income they add together in the grand total.ie.
>
>
>
> Ver 2.6.1Expense Total ($-1200) Income Total $2400Grand total
> $1200
>
> Ver 4.1.2Expense Total $1200  Income Total $2400Grand
> total
> $3600


You might want to check the value of your "reverse sign" preference.
I suspect it's not the same.

>
>
>
> Thanks
>
> Joe

> 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 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

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

[GNC] Transaction Report

[rovero]

Hope this explains it better

 

 

There are two accounts in the transaction report

 

Expense  Type A/Payable

IncomeType  Bank

 

In the expense account register transactions show as a positive number in
the payment/debit column and the balance column is a negative number that
augments negative as transaction are added.

 

In the Income account register transactions show as a positive number in the
deposit/debit column  and the balance column is a positive number that
augments positive as transaction are added.

 

The report is a simple one that shows all expense transactions form the
Expense Account as a debit/payment negative dollar amount and all
transactions from the Income Account as a debit/deposit positive dollar
amount. So in the end my grand total should be the negative sum of all
transactions in the Expense account minus the sum of all positive
transaction in the income account.

 

Again, in ver 2.6.6 I get the desired results. In ver 4.1.2 the expense
account Totals show as a positive number so Instead of subtracting expense
from income they add together in the grand total.ie.

 

Ver 2.6.1Expense Total ($-1200) Income Total $2400Grand total
$1200

Ver 4.1.2Expense Total $1200  Income Total $2400Grand total
$3600  

 

Thanks

Joe

 

-Original Message-

From: gnucash-user mailto:gnucash-user-bounces+rovero=comcast@gnucash.org> > On Behalf Of
Michael or Penny Novack

Sent: Thursday, December 8, 2022 1:51 PM

To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 

Subject: Re: [GNC] Transaction Report

 

I am not sure what you are asking or what your expectations might be.

 

This is a "transaction report" against what account?  What is the "type" 

of that account? What is the normal state of the balance of that account in
terms of the formal terms :debit" and "credit" -- in other words, if you
were thinking of those in terms of positive and negative numbers, how would
those match up?

 

I'm not asking you to answer those questions for us as to think about them
for a moment and answer for yourself.

 

Thus, I am thinking that the account is a bank account (type asset, normal
balance debit) against which these are transactions are purchases made by
"debit card". In which case they would be CREDITS to that account, reducing
the DEBIT balance of that account  Or if you insist on positive and negative
numbers, if the normal balance of that account is positive, these would be
negative.

 

Michael D Novack.

 

 

 

 

On 12/8/2022 2:31 PM, rov...@comcast.net <mailto:rov...@comcast.net>  wrote:

> I updated from ver 2.6.6 to ver  4.1.2. I used the same data file 

> created in

> 2.6.6 and opened it in 4.1.2. All the data looks good and accounts 

> transactions all match. The problem is when I create a Transaction 

> report in ver 4.1.2 and use totals. The total shows up as a positive 

> numbers although all the transactions show up as negative numbers. Example
shown below:

> 

>   

> 

> July 2022

> 

> 07/02/2022 DIRECT DEBIT PAYPALL Amazon Labels

> (Supplies)$(28.25)

> 

> 07/02/2022 DIRECT DEBIT PAYPALL Safeway Water,

> Snacks for 7/4 Parade (Events)   $(15.57)

> 

> 07/03/2022 DIRECT DEBIT PAYPALL All In One Google
Ad

> Grant Management (Administrative Fees)$(499.00)

> 

> 07/08/2022 1009   Check Paid BHOA Cabana Fee for YA Summer

> Gathering (Events)   $(20.00)

> 

> 07/14/2022 DIRECT DEBIT PAYPALL Costco Plastic

> Containers   (Supplies)$(29.64)

> 

> 07/17/2022 DIRECT DEBIT PAYPALL Antioch Recreation

> City of Antioch Application Fee Antioch IOAD(Events)

> $(140.00)

> 

> 07/17/2022 DIRECT DEBIT PAYPALL Safeway Gift Cards

> and Supplies for Youth Ambassdor Gathering(Events)

> $(320.62)

> 

> 07/18/2022 DIRECT DEBIT PAYPALL Safeway Beverages

> and Food for Youth Ambassdor Gathering(Events)

> $(40.77)

> 

> 07/19/2022 1011   Check Paid Monica Kamran, food reimbursement

> for YA Gathering(Events)$(56.30)

> 

> 07/25/2022 DIRECT DEBIT PAYPALL Safeway Candy For

> Oakland Health Fair Tabling(Events)$(28.98)

> 

> 07/26/2022 DIRECT DEBIT PAYPALL Quickship Ink

> Printer(Printing) $(38.29)

> 

> 07/27/2022 DIRECT DEBIT PAYPALL Amazon Flameless

> Candles Raleigh IOAD (Events)   $(149.40)

> 

> 07/27/2022  

Re: [GNC] Transaction Report

[Michael or Penny Novack]

I am not sure what you are asking or what your expectations might be.

This is a "transaction report" against what account?  What is the "type" 
of that account? What is the normal state of the balance of that account 
in terms of the formal terms :debit" and "credit" -- in other words, if 
you were thinking of those in terms of positive and negative numbers, 
how would those match up?


I'm not asking you to answer those questions for us as to think about 
them for a moment and answer for yourself.


Thus, I am thinking that the account is a bank account (type asset, 
normal balance debit) against which these are transactions are purchases 
made by "debit card". In which case they would be CREDITS to that 
account, reducing the DEBIT balance of that account  Or if you insist on 
positive and negative numbers, if the normal balance of that account is 
positive, these would be negative.


Michael D Novack.




On 12/8/2022 2:31 PM, rov...@comcast.net wrote:

I updated from ver 2.6.6 to ver  4.1.2. I used the same data file created in
2.6.6 and opened it in 4.1.2. All the data looks good and accounts
transactions all match. The problem is when I create a Transaction report in
ver 4.1.2 and use totals. The total shows up as a positive numbers although
all the transactions show up as negative numbers. Example shown below:

  


July 2022

07/02/2022 DIRECT DEBIT PAYPALL Amazon Labels
(Supplies)$(28.25)

07/02/2022 DIRECT DEBIT PAYPALL Safeway Water,
Snacks for 7/4 Parade (Events)   $(15.57)

07/03/2022 DIRECT DEBIT PAYPALL All In One Google Ad
Grant Management (Administrative Fees)$(499.00)

07/08/2022 1009   Check Paid BHOA Cabana Fee for YA Summer
Gathering (Events)   $(20.00)

07/14/2022 DIRECT DEBIT PAYPALL Costco Plastic
Containers   (Supplies)$(29.64)

07/17/2022 DIRECT DEBIT PAYPALL Antioch Recreation
City of Antioch Application Fee Antioch IOAD(Events)
$(140.00)

07/17/2022 DIRECT DEBIT PAYPALL Safeway Gift Cards
and Supplies for Youth Ambassdor Gathering(Events)
$(320.62)

07/18/2022 DIRECT DEBIT PAYPALL Safeway Beverages
and Food for Youth Ambassdor Gathering(Events)
$(40.77)

07/19/2022 1011   Check Paid Monica Kamran, food reimbursement
for YA Gathering(Events)$(56.30)

07/25/2022 DIRECT DEBIT PAYPALL Safeway Candy For
Oakland Health Fair Tabling(Events)$(28.98)

07/26/2022 DIRECT DEBIT PAYPALL Quickship Ink
Printer(Printing) $(38.29)

07/27/2022 DIRECT DEBIT PAYPALL Amazon Flameless
Candles Raleigh IOAD (Events)   $(149.40)

07/27/2022 DIRECT DEBIT PAYPALL Amazon Luminary Bags
& Candles Raleigh IOAD   (Events)$(127.60)

Total For July 2022   $1,494.42

  


I have tried all the different report options and can not get this to
change. In ver 2.6.6 the Total showed as negative. The other difference is
that the account register of one of the accounts in the report also shows
positive values in the register balance column in ver 4.1.2, but negative
values in 2.6.6,

The account in question is type A/Payable in both versions.  In the accounts
view the account in question also shows Total as positive number in ver
4.1.2 and Total as a negative number in ver 2.6.6

Any help would be appreciated.

  


Thanks

Joe

  


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



--
There is no possibility of social justice on a dead planet except the equality 
of the grave.

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

Re: [GNC] Transaction Report

[rovero]

Fixed the account register balance column issue as well as account now
showing negative amount instead of positive amount. The issue with the
transaction report total showing positive vs negative  still exist however.

Joe

-Original Message-
From: gnucash-user  On
Behalf Of rov...@comcast.net
Sent: Thursday, December 8, 2022 11:32 AM
To: gnucash-user@gnucash.org
Subject: [GNC] Transaction Report

I updated from ver 2.6.6 to ver  4.1.2. I used the same data file created in
2.6.6 and opened it in 4.1.2. All the data looks good and accounts
transactions all match. The problem is when I create a Transaction report in
ver 4.1.2 and use totals. The total shows up as a positive numbers although
all the transactions show up as negative numbers. Example shown below:

 

July 2022

07/02/2022 DIRECT DEBIT PAYPALL Amazon Labels
(Supplies)$(28.25)

07/02/2022 DIRECT DEBIT PAYPALL Safeway Water,
Snacks for 7/4 Parade (Events)   $(15.57)

07/03/2022 DIRECT DEBIT PAYPALL All In One Google Ad
Grant Management (Administrative Fees)$(499.00)

07/08/2022 1009   Check Paid BHOA Cabana Fee for YA Summer
Gathering (Events)   $(20.00)

07/14/2022 DIRECT DEBIT PAYPALL Costco Plastic
Containers   (Supplies)$(29.64)

07/17/2022 DIRECT DEBIT PAYPALL Antioch Recreation
City of Antioch Application Fee Antioch IOAD(Events)
$(140.00)

07/17/2022 DIRECT DEBIT PAYPALL Safeway Gift Cards
and Supplies for Youth Ambassdor Gathering(Events)
$(320.62)

07/18/2022 DIRECT DEBIT PAYPALL Safeway Beverages
and Food for Youth Ambassdor Gathering(Events)
$(40.77)

07/19/2022 1011   Check Paid Monica Kamran, food reimbursement
for YA Gathering(Events)$(56.30)

07/25/2022 DIRECT DEBIT PAYPALL Safeway Candy For
Oakland Health Fair Tabling(Events)$(28.98)

07/26/2022 DIRECT DEBIT PAYPALL Quickship Ink
Printer(Printing) $(38.29)

07/27/2022 DIRECT DEBIT PAYPALL Amazon Flameless
Candles Raleigh IOAD (Events)   $(149.40)

07/27/2022 DIRECT DEBIT PAYPALL Amazon Luminary Bags
& Candles Raleigh IOAD   (Events)$(127.60)

Total For July 2022   $1,494.42

 

I have tried all the different report options and can not get this to
change. In ver 2.6.6 the Total showed as negative. The other difference is
that the account register of one of the accounts in the report also shows
positive values in the register balance column in ver 4.1.2, but negative
values in 2.6.6,

The account in question is type A/Payable in both versions.  In the accounts
view the account in question also shows Total as positive number in ver
4.1.2 and Total as a negative number in ver 2.6.6

Any help would be appreciated.

 

Thanks

Joe

 

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

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

[GNC] Transaction Report

[rovero]

I updated from ver 2.6.6 to ver  4.1.2. I used the same data file created in
2.6.6 and opened it in 4.1.2. All the data looks good and accounts
transactions all match. The problem is when I create a Transaction report in
ver 4.1.2 and use totals. The total shows up as a positive numbers although
all the transactions show up as negative numbers. Example shown below:

 

July 2022

07/02/2022 DIRECT DEBIT PAYPALL Amazon Labels
(Supplies)$(28.25)

07/02/2022 DIRECT DEBIT PAYPALL Safeway Water,
Snacks for 7/4 Parade (Events)   $(15.57)

07/03/2022 DIRECT DEBIT PAYPALL All In One Google Ad
Grant Management (Administrative Fees)$(499.00)

07/08/2022 1009   Check Paid BHOA Cabana Fee for YA Summer
Gathering (Events)   $(20.00)

07/14/2022 DIRECT DEBIT PAYPALL Costco Plastic
Containers   (Supplies)$(29.64)

07/17/2022 DIRECT DEBIT PAYPALL Antioch Recreation
City of Antioch Application Fee Antioch IOAD(Events)
$(140.00)

07/17/2022 DIRECT DEBIT PAYPALL Safeway Gift Cards
and Supplies for Youth Ambassdor Gathering(Events)
$(320.62)

07/18/2022 DIRECT DEBIT PAYPALL Safeway Beverages
and Food for Youth Ambassdor Gathering(Events)
$(40.77)

07/19/2022 1011   Check Paid Monica Kamran, food reimbursement
for YA Gathering(Events)$(56.30)

07/25/2022 DIRECT DEBIT PAYPALL Safeway Candy For
Oakland Health Fair Tabling(Events)$(28.98)

07/26/2022 DIRECT DEBIT PAYPALL Quickship Ink
Printer(Printing) $(38.29)

07/27/2022 DIRECT DEBIT PAYPALL Amazon Flameless
Candles Raleigh IOAD (Events)   $(149.40)

07/27/2022 DIRECT DEBIT PAYPALL Amazon Luminary Bags
& Candles Raleigh IOAD   (Events)$(127.60)

Total For July 2022   $1,494.42

 

I have tried all the different report options and can not get this to
change. In ver 2.6.6 the Total showed as negative. The other difference is
that the account register of one of the accounts in the report also shows
positive values in the register balance column in ver 4.1.2, but negative
values in 2.6.6,

The account in question is type A/Payable in both versions.  In the accounts
view the account in question also shows Total as positive number in ver
4.1.2 and Total as a negative number in ver 2.6.6

Any help would be appreciated.

 

Thanks

Joe

 

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

Re: [GNC] Transaction report

[David T. via gnucash-user]

Glad that worked. 

The Transaction Report has a lot of tricks hidden away that can be very useful. 

David

On July 4, 2022 12:48:27 PM EDT, rmom...@gmail.com wrote:
>David,
>
> 
>
>Both worked, thanks. Did not know about the account report from the search 
>results register. The Transaction report is more flexible and got the exact 
>results that I wanted. It just isn’t that obvious how to set the parameters. 
>
> 
>
>I got the results I was looking for using Reports/Transaction report with the 
>following settings: 
>
>1. Accounts tab: Set the account to the credit card I used for the 
>purchases 
>2. Filter tab in the block titled, “Transaction filter” I entered the name 
>of the vendor. This one was a lucky guess as it was not obvious to me how that 
>block related to the journal entry.
>3. General tab: set the starting and ending dates of the period I was 
>interested in.
>
> 
>
>Thanks much,
>
>Roger 
>
> 
>
>From: David T.  
>Sent: Monday, July 4, 2022 8:48 AM
>To: gnucash-user@gnucash.org; rmom...@gmail.com; GnuCash 
>
>Subject: Re: [GNC] Transaction report
>
> 
>
>You can either use a generic Transaction Report and set the search parameters 
>as you need (presumably, date, account, and description). Or you can use the 
>Account Report from the search results register. I suspect you'll have more 
>configuration options using the former approach. 
>
>David T.
>
>On July 4, 2022 9:05:58 AM EDT, rmom...@gmail.com <mailto:rmom...@gmail.com>  
>wrote:
>
>How would I pull up a report of how much I spent with a specific supplier in
>a given period, e.g. the last fiscal year? All the transactions were made
>with a single credit card. I can get the information with a search but would
>like to get a report with totals from July 21 to June 22. I've tried several
>different reports but haven't found one with the appropriate options to
>produce the report I'm looking for.
>
> 
>
>Thanks,
>
>Roger
>
>
>  _  
>
>gnucash-user mailing list
>gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see 
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>
>
>  _  
>
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction report

[rmomxtx]

David,

 

Both worked, thanks. Did not know about the account report from the search 
results register. The Transaction report is more flexible and got the exact 
results that I wanted. It just isn’t that obvious how to set the parameters. 

 

I got the results I was looking for using Reports/Transaction report with the 
following settings: 

1.  Accounts tab: Set the account to the credit card I used for the 
purchases 
2.  Filter tab in the block titled, “Transaction filter” I entered the name 
of the vendor. This one was a lucky guess as it was not obvious to me how that 
block related to the journal entry.
3.  General tab: set the starting and ending dates of the period I was 
interested in.

 

Thanks much,

Roger 

 

From: David T.  
Sent: Monday, July 4, 2022 8:48 AM
To: gnucash-user@gnucash.org; rmom...@gmail.com; GnuCash 

Subject: Re: [GNC] Transaction report

 

You can either use a generic Transaction Report and set the search parameters 
as you need (presumably, date, account, and description). Or you can use the 
Account Report from the search results register. I suspect you'll have more 
configuration options using the former approach. 

David T.

On July 4, 2022 9:05:58 AM EDT, rmom...@gmail.com <mailto:rmom...@gmail.com>  
wrote:

How would I pull up a report of how much I spent with a specific supplier in
a given period, e.g. the last fiscal year? All the transactions were made
with a single credit card. I can get the information with a search but would
like to get a report with totals from July 21 to June 22. I've tried several
different reports but haven't found one with the appropriate options to
produce the report I'm looking for.

 

Thanks,

Roger


  _  

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


  _  

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

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

Re: [GNC] Transaction report

[David T. via gnucash-user]

You can either use a generic Transaction Report and set the search parameters 
as you need (presumably, date, account, and description). Or you can use the 
Account Report from the search results register. I suspect you'll have more 
configuration options using the former approach. 

David T.

On July 4, 2022 9:05:58 AM EDT, rmom...@gmail.com wrote:
>How would I pull up a report of how much I spent with a specific supplier in
>a given period, e.g. the last fiscal year? All the transactions were made
>with a single credit card. I can get the information with a search but would
>like to get a report with totals from July 21 to June 22. I've tried several
>different reports but haven't found one with the appropriate options to
>produce the report I'm looking for.
>
> 
>
>Thanks,
>
>Roger
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see 
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Transaction report

[rmomxtx]

How would I pull up a report of how much I spent with a specific supplier in
a given period, e.g. the last fiscal year? All the transactions were made
with a single credit card. I can get the information with a search but would
like to get a report with totals from July 21 to June 22. I've tried several
different reports but haven't found one with the appropriate options to
produce the report I'm looking for.

 

Thanks,

Roger

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

Re: [GNC] Transaction Report Account Name Style

[Derek Atkins]

Hi,

On Thu, August 19, 2021 8:37 am, flywire wrote:
> I want to change character style (font attributes), just for Account
> Names.
>
>> Under Display tab, there are the "Use Full Account Name" options.

Ah, that's probably not do-able with the current report implementation.

> 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 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

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

Re: [GNC] Transaction Report Account Name Style

[flywire]

I want to change character style (font attributes), just for Account Names.

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

Re: [GNC] Transaction Report Account Name Style

[Derek Atkins]

Under Display tab, there are the "Use Full Account Name" options.

-derek

On Thu, August 19, 2021 8:00 am, flywire wrote:
> How can I change the Transaction Report Account Name Style? I can't see it
> listed in Edit, Stylesheets or a unique class in the html.
>
> (The CSS-based stylesheet is a welcome addition. Not that long ago I
> didn't
> know what CSS was but it works well for GnuCash.)
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

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

[GNC] Transaction Report Account Name Style

[flywire]

How can I change the Transaction Report Account Name Style? I can't see it
listed in Edit, Stylesheets or a unique class in the html.

(The CSS-based stylesheet is a welcome addition. Not that long ago I didn't
know what CSS was but it works well for GnuCash.)
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction report not seeing selected account

[David Carlson]

If you want to repeat a report later with the same or similar settings you
need to memorize it with a name that makes sense to you.

On Sun, Jun 27, 2021, 10:35 AM Rich Shepard 
wrote:

> For some reason I need to learn a transaction report fails telling me it
> needs an account name. I've selected the single account for which I want to
> see all transactions to a payee. The failure report shows the account (see
> attached) and I don't know what's missing or what I did incorrectly.
>
> A clue stick will be helpful.
>
> Regards,
>
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Transaction report not seeing selected account

[Rich Shepard]

For some reason I need to learn a transaction report fails telling me it
needs an account name. I've selected the single account for which I want to
see all transactions to a payee. The failure report shows the account (see
attached) and I don't know what's missing or what I did incorrectly.

A clue stick will be helpful.

Regards,

Rich


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

[GNC] Transaction report export file type

[flywire]

Last year I found the process of getting a budget report in a spreadsheet
confusing (
https://lists.gnucash.org/pipermail/gnucash-user/2020-May/091064.html). I
understood it after help from the community and twigging to turning off the
white background colour for the cells on the page. It would be worth
discussing in the user guide.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction report export file type

[David Cousens]

Rich
 I just managed to get a balance sheet report into calc on LM20 by copying the
html from the report to the clipboeard then used Edit->Paste Special-
>Unformatted Text then selected only the tab separator (having  comma or space
selected is a disaster). It copied from the clipboard with no problem and put
everything in the right rows and columns.

David Cousens

On Thu, 2021-06-24 at 15:56 -0700, Rich Shepard wrote:
> On Fri, 25 Jun 2021, David H wrote:
> 
> > You'll probably have to do a bit of cleaning up whichever way you go if
> > you want to get rid of all the extraneous headers the are in the html file
> > to get to a true .csv looking file :-)
> 
> David,
> 
> Figured out how to do it. In Calc -> Sheet -> Link to external data brings
> in the .html. And saving as .csv does work.
> 
> Cleaning up the cruft in emacs is simple.
> 
> I've learned something new today.
> 
> Thanks,
> 
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Transaction report export file type

[David H]

Ah I didn't think of that - been a long while since I stopped writing
design docs and had to link in an external object :-)  So we're both still
learning which is good !!!

Cheers David H.


On Fri, 25 Jun 2021 at 08:58, Rich Shepard  wrote:

> On Fri, 25 Jun 2021, David H wrote:
>
> > You'll probably have to do a bit of cleaning up whichever way you go if
> > you want to get rid of all the extraneous headers the are in the html
> file
> > to get to a true .csv looking file :-)
>
> David,
>
> Figured out how to do it. In Calc -> Sheet -> Link to external data brings
> in the .html. And saving as .csv does work.
>
> Cleaning up the cruft in emacs is simple.
>
> I've learned something new today.
>
> Thanks,
>
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction report export file type

[Rich Shepard]

On Fri, 25 Jun 2021, David H wrote:


You'll probably have to do a bit of cleaning up whichever way you go if
you want to get rid of all the extraneous headers the are in the html file
to get to a true .csv looking file :-)


David,

Figured out how to do it. In Calc -> Sheet -> Link to external data brings
in the .html. And saving as .csv does work.

Cleaning up the cruft in emacs is simple.

I've learned something new today.

Thanks,

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

Re: [GNC] Transaction report export file type

[David H]

I just used Ubuntu's file explorer to open the folder with the .html file
in and then right clicked which gives me a dialog box that I can choose
lots of options one of which is what I want to do - it's actually the 2nd
option down not the bottom one which says "Other Application"...

Cheers David


On Fri, 25 Jun 2021 at 08:51, Rich Shepard  wrote:

> On Fri, 25 Jun 2021, David H wrote:
>
> > Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will
> open
> > the .html file directly and you can save it as .csv from there - you just
> > have to make sure when you are asked what you want to open the .html file
> > with you click on "Other Application" at the bottom of the dialog box and
> > scroll down until you find the LibreOffice calc menu item and click on
> it.
>
> David,
>
> When I invoke LO and select ctrl-o to open a file I'm not asked which tool
> should open it. It opens as a read-only Writer file.
>
> Regards,
>
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction report export file type

[David H]

You'll probably have to do a bit of cleaning up whichever way you go if you
want to get rid of all the extraneous headers the are in the html file to
get to a true .csv looking file :-)

Cheers David H.


On Fri, 25 Jun 2021 at 08:46, Rich Shepard  wrote:

> On Fri, 25 Jun 2021, David H wrote:
>
> > Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will
> open
> > the .html file directly and you can save it as .csv from there - you just
> > have to make sure when you are asked what you want to open the .html file
> > with you click on "Other Application" at the bottom of the dialog box and
> > scroll down until you find the LibreOffice calc menu item and click on
> it.
>
> David,
>
> Okay. I sit corrected.
>
> I'll try that rather than opening a new spreadsheet and then opening the
> data file.
>
> Thanks,
>
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction report export file type

[Rich Shepard]

On Fri, 25 Jun 2021, David H wrote:


Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will open
the .html file directly and you can save it as .csv from there - you just
have to make sure when you are asked what you want to open the .html file
with you click on "Other Application" at the bottom of the dialog box and
scroll down until you find the LibreOffice calc menu item and click on it.


David,

When I invoke LO and select ctrl-o to open a file I'm not asked which tool
should open it. It opens as a read-only Writer file.

Regards,

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

Re: [GNC] Transaction report export file type

[Rich Shepard]

On Fri, 25 Jun 2021, David H wrote:


Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will open
the .html file directly and you can save it as .csv from there - you just
have to make sure when you are asked what you want to open the .html file
with you click on "Other Application" at the bottom of the dialog box and
scroll down until you find the LibreOffice calc menu item and click on it.


David,

Okay. I sit corrected.

I'll try that rather than opening a new spreadsheet and then opening the
data file.

Thanks,

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

Re: [GNC] Transaction report export file type

[Rich Shepard]

On Fri, 25 Jun 2021, David H wrote:


What about the cut and paste from html into Calc ?


David,

I'd first have to remove all the html markup. If I do that I have a plain,
ASCII text file regardless of where it's used. And I can reformat it in
emacs however I want.

Regards,

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

Re: [GNC] Transaction report export file type

[David H]

Er yes - I'm running LibreOffice Calc 7.1 on Ubuntu 21.04 and it will open
the .html file directly and you can save it as .csv from there - you just
have to make sure when you are asked what you want to open the .html file
with you click on "Other Application" at the bottom of the dialog box and
scroll down until you find the LibreOffice calc menu item and click on it.

Cheers David H.


On Fri, 25 Jun 2021 at 08:15, Rich Shepard  wrote:

> On Fri, 25 Jun 2021, David H wrote:
>
> > Don't know what your objective is but if it helps MS Excel on MacOS will
>
> David,
>
> That's fine if you run Apple and Microsoft software; the linux spreadsheets
> I use, gnumeric and LibreOffice's Calc won't work with .pdf or anything
> other than .xls(x) or .csv.
>
> Thanks,
>
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction report export file type

[David H]

What about the cut and paste from html into Calc ?

Cheers David H.

On Fri, 25 Jun 2021 at 08:15, Rich Shepard  wrote:

> On Fri, 25 Jun 2021, David H wrote:
>
> > Don't know what your objective is but if it helps MS Excel on MacOS will
>
> David,
>
> That's fine if you run Apple and Microsoft software; the linux spreadsheets
> I use, gnumeric and LibreOffice's Calc won't work with .pdf or anything
> other than .xls(x) or .csv.
>
> Thanks,
>
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction report export file type

[Rich Shepard]

On Fri, 25 Jun 2021, David H wrote:


Don't know what your objective is but if it helps MS Excel on MacOS will


David,

That's fine if you run Apple and Microsoft software; the linux spreadsheets
I use, gnumeric and LibreOffice's Calc won't work with .pdf or anything
other than .xls(x) or .csv.

Thanks,

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

Re: [GNC] Transaction report export file type

[Rich Shepard]

On Thu, 24 Jun 2021, David Carlson wrote:


I have not tested this, but sometimes one can either open a pdf file with
a spreadsheet application or copy a PDF file and paste it into a new
spreadsheet. Once that is done it is often relatively easy to clean up
stray cells and save in CSV format.


David,

I don't think that LibreOffice's Calc or gnumeric will do this.

Thanks,

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

Re: [GNC] Transaction report export file type

[Rich Shepard]

On Thu, 24 Jun 2021, John Ralls wrote:


It usually works to copy-and-paste the report into a spreadsheet.


John,

Oh. Okay.

Thanks,

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

Re: [GNC] Transaction report export file type

[David H]

Rich,

Don't know what your objective is but if it helps MS Excel on MacOS will
open a txn report html directly - looks ok and you could probably save as
csv from there ?  Also Numbers won't open it directly but you can highlight
everything and paste it into a blank sheet which you could export to csv.

Cheers David H.

On Fri, 25 Jun 2021 at 07:32, Rich Shepard  wrote:

> Is there a way to export a transaction report as a .csv or .txt file? I
> looked at all options and didn't see any place to select the export format.
> When I did export the file it defaulted to .html; that would take a lot of
> cleaning and it would be nice to export to .csv or .txt.
>
> Any thoughts?
>
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction report export file type

[David Carlson]

I have not tested this, but sometimes one can either open a pdf file with a
spreadsheet application or copy a PDF file and paste it into a new
spreadsheet.  Once that is done it is often relatively easy to clean up
stray cells and save in CSV format.

On Thu, Jun 24, 2021 at 4:32 PM Rich Shepard 
wrote:

> Is there a way to export a transaction report as a .csv or .txt file? I
> looked at all options and didn't see any place to select the export format.
> When I did export the file it defaulted to .html; that would take a lot of
> cleaning and it would be nice to export to .csv or .txt.
>
> Any thoughts?
>
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


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

Re: [GNC] Transaction report export file type

[John Ralls]

> On Jun 24, 2021, at 2:31 PM, Rich Shepard  wrote:
> 
> Is there a way to export a transaction report as a .csv or .txt file? I
> looked at all options and didn't see any place to select the export format.
> When I did export the file it defaulted to .html; that would take a lot of
> cleaning and it would be nice to export to .csv or .txt.
> 
> Any thoughts?

It usually works to copy-and-paste the report into a spreadsheet.

Regards,
John Ralls

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

[GNC] Transaction report export file type

[Rich Shepard]

Is there a way to export a transaction report as a .csv or .txt file? I
looked at all options and didn't see any place to select the export format.
When I did export the file it defaulted to .html; that would take a lot of
cleaning and it would be nice to export to .csv or .txt.

Any thoughts?

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

Re: [GNC] Transaction Report Question

[Adrien Monteleone]

Gareth,

Can you provide a screenshot of the incorrect report?

Can you describe *exactly* how you want it to look?

That report has lots of options. The default sorting is by Account Name, 
then by Register Date for the current accounting period. (default for 
which is 'This Year')


Also, please change the option for "Add options summary" to 'Always' on 
the General Tab and make sure that is included in your screenshot. (they 
will print at the top of the report) That way, we can see what options 
you have selected that generate the format shown.


We probably don't need to see the entire report, just the first page 
will illustrate the format being presented vs. your description of what 
you are trying to achieve.


Regards,
Adrien

On 2/11/21 4:10 AM, Gareth Davies via gnucash-user wrote:

Thanks, for the reply Adrien,

I think I have tried every tick box without having any luck.
It looks like I will have to accept it as it is for now, but I will keep on 
trying.

Regards,
Gareth


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

Re: [GNC] Transaction Report Question

[Gareth Davies via gnucash-user]

Thanks, for the reply Adrien,

I think I have tried every tick box without having any luck.
It looks like I will have to accept it as it is for now, but I will keep on 
trying.

Regards,
Gareth




-Original Message-
From: gnucash-user 
 On Behalf Of 
Adrien Monteleone
Sent: 29 January 2021 01:21
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Transaction Report Question

Sounds like you need to fiddle with the Sort tab options.

Regards,
Adrien

On 1/28/21 3:25 PM, Gareth Davies via gnucash-user wrote:
> Windows 10   Gnucash 4.4
>   
> Hi,
> My Laptop died on me and although everything was backed up the Transaction 
> Reports I had saved were lost.
> I have installed Ver 4.4 on my new laptop, but when I create a Transaction 
> Report it will not let me list the dates in order under the Payee’s name.
>   
> With the previous version the dates were in order, so I don’t know if this is 
> because I am not ticking in the correct boxes or not.

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

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

Re: [GNC] Transaction Report Question

[Gareth Davies via gnucash-user]

Thanks, for the reply Adrien,

I think I have tried every tick box without having any luck.
It looks like I will have to accept it as it is for now, but I will keep on 
trying.

Regards,
Gareth




-Original Message-
From: gnucash-user 
 On Behalf Of 
Adrien Monteleone
Sent: 29 January 2021 01:21
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Transaction Report Question

Sounds like you need to fiddle with the Sort tab options.

Regards,
Adrien

On 1/28/21 3:25 PM, Gareth Davies via gnucash-user wrote:
> Windows 10   Gnucash 4.4
> 
> Hi,
> My Laptop died on me and although everything was backed up the Transaction 
> Reports I had saved were lost.
> I have installed Ver 4.4 on my new laptop, but when I create a Transaction 
> Report it will not let me list the dates in order under the Payee’s name.
> 
> With the previous version the dates were in order, so I don’t know if this 
> is because I am not ticking in the correct boxes or not.

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

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

Re: [GNC] Transaction Report Question

[Adrien Monteleone]

Sounds like you need to fiddle with the Sort tab options.

Regards,
Adrien

On 1/28/21 3:25 PM, Gareth Davies via gnucash-user wrote:

Windows 10   Gnucash 4.4
  
Hi,

My Laptop died on me and although everything was backed up the Transaction 
Reports I had saved were lost.
I have installed Ver 4.4 on my new laptop, but when I create a Transaction 
Report it will not let me list the dates in order under the Payee’s name.
  
With the previous version the dates were in order, so I don’t know if this is because I am not ticking in the correct boxes or not.


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

[GNC] Transaction Report Question

[Gareth Davies via gnucash-user]

Windows 10   Gnucash 4.4
 
Hi,
My Laptop died on me and although everything was backed up the Transaction 
Reports I had saved were lost.
I have installed Ver 4.4 on my new laptop, but when I create a Transaction 
Report it will not let me list the dates in order under the Payee’s name.
 
With the previous version the dates were in order, so I don’t know if this is 
because I am not ticking in the correct boxes or not.
 
Any help appreciated,
Gareth
 

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

Re: [GNC] transaction report missing subtotals

[Fran_3 via gnucash-user]

 I see the problem. After some experimentation I failed to discover a solution. 
Hopefully someone else here can chip in.

On Saturday, October 17, 2020, 3:57:15 AM EDT, Gal  
wrote:  
 
 GnuCash - User mailing list wrote
> .. On Sorting Tab - set Primary Key to Date to "enable " Primary Subtotal
> Date Key)

When the primary key is the date, the primary subtotal are displayed.
The issue arises when the date is chosen as the secondary key, in which case
"secondary subtotal" checkbox can't be checked, and accordingly, no monthly
subtotals are displayed in the table.

Why are date subtotals limited to appear only when the date is the primary
key?



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

Re: [GNC] transaction report missing subtotals

[Gal]

GnuCash - User mailing list wrote
> .. On Sorting Tab - set Primary Key to Date to "enable " Primary Subtotal
> Date Key)

When the primary key is the date, the primary subtotal are displayed.
The issue arises when the date is chosen as the secondary key, in which case
"secondary subtotal" checkbox can't be checked, and accordingly, no monthly
subtotals are displayed in the table.

Why are date subtotals limited to appear only when the date is the primary
key?



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

Re: [GNC] transaction report missing subtotals

[Fran_3 via gnucash-user]

 I missed the OP but saw a followup on this question. Here is my attempt to 
explain Transaction Reports Monthly Totals.
I'm running Windows 10 and GnuCash Version 4.1 and getting Transaction Reports 
Monthly Totals seems to work perfectly here.
My Process:
- Click Reports
- Click Transaction Reports
- Click Edit Report Options
.. On General Tab - set date range
.. On Accounts Tab - select Assets > Current Assets > Checking (or whatever 
accout you choose)
.. On Sorting Tab - set Primary Key to Date to "enable " Primary Subtotal Date 
Key)
.. On Sorting Tab - set Primary Subtotal for Date Key to "Monthly" (thats the 
default on my Win 10 GnuCash)
.. On Sorting Tab - Make sure Primary Subtotal is checked
.. Click Apply or OK

and KaBoom - there you go

PS - You can also use the Filter Tab to... for instance... only show 
transactions with a key word in the Descriptio Memo or Note Fields...
BUT... this is tricky so make sure your case matches as the Filter uses Regular 
Expressions...
or if you know Regular Expressions you can match any way you like.

Hope this helps.









On Friday, October 16, 2020, 5:43:28 PM EDT, Gal  wrote: 
 
 
 Christopher Lam wrote
> Can you attach a screenshot of the problem?
> 
> Use MSPaint or something to hide any sensitive data. Also switch on
> "General / Add options summary" to "Always" to show us which options were
> set.

Having the same issue. can't get monthly sub totals.
Here's a screenshot:
 



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

Re: [GNC] transaction report missing subtotals

[Gal]

Christopher Lam wrote
> Can you attach a screenshot of the problem?
> 
> Use MSPaint or something to hide any sensitive data. Also switch on
> "General / Add options summary" to "Always" to show us which options were
> set.

Having the same issue. can't get monthly sub totals.
Here's a screenshot:
 



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

Re: [GNC] Transaction Report issue when using GC from 2 locations via Google Drive

[John Ralls]

No, that was about macOS just like it said. Unfortunately GnuCash has a variety 
of features that prevent it from being ported to mobile. We had a Google Summer 
of Code student a few years ago who wrote a companion app for Android but he's 
since moved on and it's no longer maintained.

Regards,
John Ralls


> On Oct 9, 2020, at 4:14 PM, Fran_3  wrote:
> 
> In this case the PC"s are running the latest GnuCash download version for 
> Windows.
> 
> I haven't explored the "App" yet. I assume you are talking about an app to 
> run on a smart phone... right?
> 
> Regardless, I want to learn more about the  App but I think that will be 
> another thread down the road.
> 
> Thanks.
> 
> 
> On Friday, October 9, 2020, 1:04:23 PM EDT, John Ralls  
> wrote:
> 
> 
> 
> 
> > On Oct 9, 2020, at 4:09 AM, Manfred Usselmann  wrote:
> > 
> > Under MacOS X the following directory is used: 
> > ~/Library/Preferences/gnucash.plist.
> 
> That depends on how you get GnuCash. If it's Gnucash.app then the preferences 
> file is ~/Library/Preferences/org.gnucash.Gnucash.plist. gnucash.plist will 
> be used if you've installed GnuCash from MacPorts or built it yourself.
> 
> Regards,
> John Ralls
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Transaction Report issue when using GC from 2 locations via Google Drive

[Fran_3 via gnucash-user]

 In this case the PC"s are running the latest GnuCash download version for 
Windows.

I haven't explored the "App" yet. I assume you are talking about an app to run 
on a smart phone... right?
Regardless, I want to learn more about the  App but I think that will be 
another thread down the road.
Thanks.

On Friday, October 9, 2020, 1:04:23 PM EDT, John Ralls  
wrote:  
 
 

> On Oct 9, 2020, at 4:09 AM, Manfred Usselmann  wrote:
> 
> Under MacOS X the following directory is used: 
> ~/Library/Preferences/gnucash.plist.

That depends on how you get GnuCash. If it's Gnucash.app then the preferences 
file is ~/Library/Preferences/org.gnucash.Gnucash.plist. gnucash.plist will be 
used if you've installed GnuCash from MacPorts or built it yourself.

Regards,
John Ralls

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

Re: [GNC] Transaction Report issue when using GC from 2 locations via Google Drive

[John Ralls]

> On Oct 9, 2020, at 4:09 AM, Manfred Usselmann  wrote:
> 
> Under MacOS X the following directory is used: 
> ~/Library/Preferences/gnucash.plist.

That depends on how you get GnuCash. If it's Gnucash.app then the preferences 
file is ~/Library/Preferences/org.gnucash.Gnucash.plist. gnucash.plist will be 
used if you've installed GnuCash from MacPorts or built it yourself.

Regards,
John Ralls

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

Re: [GNC] Transaction Report issue when using GC from 2 locations via Google Drive

[Manfred Usselmann]

In addition:

For syncing settings as well under Linux I use the following start 
script to import settings before running gnucash and export settings 
afterwards with dconf:


8< 
#!/bin/sh
# Start GnuCash with import and export of settings
#
HOME_DIR="${HOME}"
GNUCASH="$(command -v gnucash)"
[ "$?" -ne 0 ] && { echo 'gnucash: command not found.'; exit 1; }
DCONF_BKP="${HOME_DIR}/.config/gnucash/preferences.dconf"
if [ -f "${DCONF_BKP}" ]; then
dconf load /org/gnucash/ < "${DCONF_BKP}"
fi
"${GNUCASH}" $*
dconf dump /org/gnucash/ > "${DCONF_BKP}"
8< 

Under MacOS X the following directory is used: 
~/Library/Preferences/gnucash.plist.


Under Windows the windows registry is used to store the settings under 
HKEY_CURRENT_USER/software/GSettings. You could use Powershell or the 
command line to import and export the settings. Use e.g. "reg export /?" 
to get detailed help.


I do synchronize the following directories. They are not all required at 
the same time, some are for older and some for newer versions of gnucash 
and aqbanking. This is for Linux. As Adrien said, check the wiki for the 
correct locations for your operating system and which you need for your 
version of GnuCash:


.aqbanking
.gnucash
.abtransfers
.local/share/gnucash
.gconf/apps/gnucash
.config/gnucash

Regards,
Manfred

Am 08.10.2020 20:55, schrieb Adrien Monteleone:

#1 yes (see the wiki about storage locations for your operating system)

#2 I don't think you can change it, buy you can add it to your
GoogleDrive sync list.


Regards,
Adrien

On 10/8/20 12:13 PM, Fran_3 via gnucash-user wrote:
The GnuCash file entityA.gnucash is saved on Google Drive.GnuCash is 
installed on both pcX and pcY at locations X and Y.
Google Drive is sync'd on both pcX and on pcY...So the entityA.gnucash 
file is available locally on both computers hard drive.


This way  work can be done from either location.
The Issue:When a custom Transaction Report is created on pcX and 
saved...It does not get sync'd up to the cloud so it is not available 
if GnuCash is used with pcY from location Y.
The questions:1 - Are the custom Transaction Reports saved as a 
special file... or set of files in some local folder?2 - If so can 
that folder be changed such that the custom Transaction Reports can be 
sync'd to the Google Drive and ultimately be available to both pc's?3 
- If not  are what alternate solutions exist?

Thanks for any help.




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

Re: [GNC] Transaction Report issue when using GC from 2 locations via Google Drive

[Adrien Monteleone]

#1 yes (see the wiki about storage locations for your operating system)

#2 I don't think you can change it, buy you can add it to your 
GoogleDrive sync list.



Regards,
Adrien

On 10/8/20 12:13 PM, Fran_3 via gnucash-user wrote:

The GnuCash file entityA.gnucash is saved on Google Drive.GnuCash is installed 
on both pcX and pcY at locations X and Y.
Google Drive is sync'd on both pcX and on pcY...So the entityA.gnucash file is 
available locally on both computers hard drive.

This way  work can be done from either location.
The Issue:When a custom Transaction Report is created on pcX and saved...It 
does not get sync'd up to the cloud so it is not available if GnuCash is used 
with pcY from location Y.
The questions:1 - Are the custom Transaction Reports saved as a special file... 
or set of files in some local folder?2 - If so can that folder be changed such 
that the custom Transaction Reports can be sync'd to the Google Drive and 
ultimately be available to both pc's?3 - If not  are what alternate solutions 
exist?
Thanks for any help.


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

[GNC] Transaction Report issue when using GC from 2 locations via Google Drive

[Fran_3 via gnucash-user]

The GnuCash file entityA.gnucash is saved on Google Drive.GnuCash is installed 
on both pcX and pcY at locations X and Y.
Google Drive is sync'd on both pcX and on pcY...So the entityA.gnucash file is 
available locally on both computers hard drive.

This way  work can be done from either location.
The Issue:When a custom Transaction Report is created on pcX and saved...It 
does not get sync'd up to the cloud so it is not available if GnuCash is used 
with pcY from location Y.
The questions:1 - Are the custom Transaction Reports saved as a special file... 
or set of files in some local folder?2 - If so can that folder be changed such 
that the custom Transaction Reports can be sync'd to the Google Drive and 
ultimately be available to both pc's?3 - If not  are what alternate solutions 
exist?
Thanks for any help.

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

Re: [GNC] Transaction Report Filter for keyword in Description ?

[Fran_3 via gnucash-user]

 I think the implied meaning of "Account" got me confused...
Transaction Report - Accounts Tab:I selected the "Account" via the Accounts Tab 
to be...
"Assets > Current Assets > Checking Account"

Transaction Report - Filter Tab - Account Name Filter field:
Is the "Account Name Filter" field expecting the name of an Expense Account... 
or Income Account... that the Checking transaction was charged to?
Transaction Report: - Filter Tab - Transaction Filter field:Regular 
Expressions... Rats!Rant...I can, more or less, program in a number of 
languages... Assembly Language, Basic, Visual Basic, Visual Basic for 
Applications, HTML, Java Script, PHP, Active Server Pages, SQL... plus on rare 
occasions Python, C, & C++ and a few more more...But, that said, I will do 
almost anything to avoid Regular Expressions.Can I do it... sure if I take the 
day off to refresh myself and then hack, hack, hack, and groan, groan, 
groan.Rant finished.Sorry. Not Sorry.
In this case my Keyword string may have any case letters, anywhere in it... and 
it may have a punctuation mark before or after it... like...WebsiTenAme.cOm
Anyway, thanks for the help John... I was moving so fast to get done that I 
skipped right over the obvious... Too. Tips.



On Monday, September 21, 2020, 12:43:05 PM EDT, John Ralls 
 wrote:  
 
 

> On Sep 21, 2020, at 8:57 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> How can I create a Transaction Report for the Check Register...
> set to only display transactions where a keyword appears in the Description 
> field?
> I'm confused by the "Account Name" Filter and the "Transaction Filter" 
> fields...
> 
> Thanks for any help.

Even after reading the tooltips? (Hover your pointer over each field.)

Summarizing them, use the Accounts filter to select from which accounts to 
select the transactions and the transactions filter to select which 
transactions based on the entered string or regular expression [1] matching the 
transaction description or notes, or a split memo.

Regards,
John Ralls

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

Re: [GNC] Transaction Report Filter for keyword in Description ?

[John Ralls]

> On Sep 21, 2020, at 8:57 AM, Fran_3 via gnucash-user 
>  wrote:
> 
> How can I create a Transaction Report for the Check Register...
> set to only display transactions where a keyword appears in the Description 
> field?
> I'm confused by the "Account Name" Filter and the "Transaction Filter" 
> fields...
> 
> Thanks for any help.

Even after reading the tooltips? (Hover your pointer over each field.)

Summarizing them, use the Accounts filter to select from which accounts to 
select the transactions and the transactions filter to select which 
transactions based on the entered string or regular expression [1] matching the 
transaction description or notes, or a split memo.

Regards,
John Ralls

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

[GNC] Transaction Report Filter for keyword in Description ?

[Fran_3 via gnucash-user]

How can I create a Transaction Report for the Check Register...
set to only display transactions where a keyword appears in the Description 
field?
I'm confused by the "Account Name" Filter and the "Transaction Filter" fields...

Thanks for any help.

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

Re: [GNC] Transaction report: selected date range

[Adrien Monteleone]

And if you want to really get fancy, you have more filtering options with a 
Find than with a Transaction Report, then running the Account Report on the 
resulting register tab.

The Transaction Report however does provide some nice dimensional sorting the 
Account Report lacks.

Regards,
Adrien

> On May 24, 2020 w22d145, at 1:13 PM, D.  wrote:
> 
> Further: if you want to use the Account Report,  first filter the register 
> for the dates  (View->Filter by) and then run the report. If you want  to use 
> the Transaction Report, once it informs you that you haven't selected any 
> account, open the Options and select the account and date range.
> 


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

Re: [GNC] Transaction report: selected date range

[D. via gnucash-user]

Further: if you want to use the Account Report,  first filter the register for 
the dates  (View->Filter by) and then run the report. If you want  to use the 
Transaction Report, once it informs you that you haven't selected any account, 
open the Options and select the account and date range. 


 Original Message 
From: Adrien Monteleone 
Sent: Sun May 24 13:39:03 EDT 2020
To: gnucash-user 
Subject: Re: [GNC] Transaction report: selected date range

The Transaction Report can be for multiple accounts, so it doesn’t matter what 
register is open at the time.

The Account Report is for the currently viewed register.

The two reports are quite different in their available options, however.

Regards,
Adrien

> On May 24, 2020 w22d145, at 12:08 PM, Rich Shepard  
> wrote:
> 
> On Sun, 24 May 2020, Fred Bone wrote:
> 
>> When I run the transaction report it points out that I need to select the
>> account in "Options".
> 
> Fred,
> 
> Huh! I saw the link but missed the instruction above it. Mea culpa!
> 
>> Having said which, I'm not on the latest version. What version are you
>> running?
> 
> 3.10
> 
> Thanks,
> 
> Rich

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

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

Re: [GNC] Transaction report: selected date range

[David Carlson]

As Adrien points out, the Account report is only for the currently selected
account.  For that report use the account View > Sort and View >Filter
options to limit the report to the desired transactions.

On Sun, May 24, 2020 at 12:41 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> The Transaction Report can be for multiple accounts, so it doesn’t matter
> what register is open at the time.
>
> The Account Report is for the currently viewed register.
>
> The two reports are quite different in their available options, however.
>
> Regards,
> Adrien
>
> > On May 24, 2020 w22d145, at 12:08 PM, Rich Shepard <
> rshep...@appl-ecosys.com> wrote:
> >
> > On Sun, 24 May 2020, Fred Bone wrote:
> >
> >> When I run the transaction report it points out that I need to select
> the
> >> account in "Options".
> >
> > Fred,
> >
> > Huh! I saw the link but missed the instruction above it. Mea culpa!
> >
> >> Having said which, I'm not on the latest version. What version are you
> >> running?
> >
> > 3.10
> >
> > Thanks,
> >
> > Rich
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


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

Re: [GNC] Transaction report: selected date range

[Adrien Monteleone]

The Transaction Report can be for multiple accounts, so it doesn’t matter what 
register is open at the time.

The Account Report is for the currently viewed register.

The two reports are quite different in their available options, however.

Regards,
Adrien

> On May 24, 2020 w22d145, at 12:08 PM, Rich Shepard  
> wrote:
> 
> On Sun, 24 May 2020, Fred Bone wrote:
> 
>> When I run the transaction report it points out that I need to select the
>> account in "Options".
> 
> Fred,
> 
> Huh! I saw the link but missed the instruction above it. Mea culpa!
> 
>> Having said which, I'm not on the latest version. What version are you
>> running?
> 
> 3.10
> 
> Thanks,
> 
> Rich

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

Re: [GNC] Transaction report: selected date range

[Rich Shepard]

On Sun, 24 May 2020, Fred Bone wrote:


When I run the transaction report it points out that I need to select the
account in "Options".


Fred,

Huh! I saw the link but missed the instruction above it. Mea culpa!


Having said which, I'm not on the latest version. What version are you
running?


3.10

Thanks,

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

Re: [GNC] Transaction report: selected date range

[Fred Bone]

On 24 May 2020 at 8:56, Rich Shepard said:

> I'm missing something in my attempts to define a date range for a
> transaction report on a single account.
> 
> The account is displayed and has focus. I select Reports -> Account report
> -> Options and do find where I can specify starting and ending dates. When
> I try Reports -> Transactions GC tells me no account's been selected.

When I run the transaction report it points out that I need to select the 
account in "Options".

I don't think there is a mechanism for remembering which account had 
focus before you focused on selecting a report to run.

Having said which, I'm not on the latest version. What version are you 
running?

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

Re: [GNC] Transaction report: selected date range

[Rich Shepard]

On Sun, 24 May 2020, Rich Shepard wrote:


-> Options and do find where I can specify starting and ending dates. When I

   ^ NOT

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

[GNC] Transaction report: selected date range

[Rich Shepard]

I'm missing something in my attempts to define a date range for a
transaction report on a single account.

The account is displayed and has focus. I select Reports -> Account report
-> Options and do find where I can specify starting and ending dates. When I
try Reports -> Transactions GC tells me no account's been selected.

What am I missing?

Rich

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

Re: [GNC] Transaction Report Filter Questions

[Fran_3 via gnucash-user]

 Thanks Christopher.

On Thursday, May 21, 2020, 1:58:52 AM EDT, Christopher Lam 
 wrote:  
 
 Until 4.x is ready, yes you'll have to use this syntax.
On Thu, 21 May 2020, 12:19 am Fran_3 via gnucash-user, 
 wrote:

Transaction Filter seems to be case sensitive as searching for "Chevron" will 
not find "CHEVRON" so you must use regx like 
[Cd][Hh][Er][Vv][Rr][On][Nn]Right?
Thanks.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Transaction Report Filter Questions

[Christopher Lam]

Until 4.x is ready, yes you'll have to use this syntax.

On Thu, 21 May 2020, 12:19 am Fran_3 via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> Transaction Filter seems to be case sensitive as searching for "Chevron"
> will not find "CHEVRON" so you must use regx like
> [Cd][Hh][Er][Vv][Rr][On][Nn]Right?
> Thanks.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Transaction Report Filter Questions

[Fran_3 via gnucash-user]

Transaction Filter seems to be case sensitive as searching for "Chevron" will 
not find "CHEVRON" so you must use regx like 
[Cd][Hh][Er][Vv][Rr][On][Nn]Right?
Thanks.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report Default Account

[flywire]

Thanks @John Ralls that wiki page was what prompted this thread, hoping to
tweak report without going through the full report development process.

> just save the report configuration

The issue is Save Report Configuration saves those reports in a different
part of the menu to the default reports. I specifically wanted to change
the default report rather than having to check in the Saved Report
Configurations before selecting a default report. (A Linux shadow [report]
file would work.)

Looking through C:\Users\User\AppData\Roaming\GnuCash\saved-reports-2.8
(might have been another file) seems easy enough to understand. *Should all
the required accounts and sub-accounts be specifically selected?* Selecting
all accounts (including sub-accounts) includes the account ids in the
report so I expect any new accounts would not appear on the report.

@Michael or Penny Novack Re experience - commercial programming for a
period with procedural languages, system support, member of numerous system
development teams, user rep, testing. No LISP, no OOP experience, use
classes as procedures. Regardless, once I get to the detail I can normally
understand what is going on.

> Are you being required to choose that display option?
> How about asking here how people use that display option?

No, it's the default. I asked if people thought it was a bug. When I
realised the reports in the guide were like other accounting packages that
was enough confirmation of a bug for me so I reported it. (Also explains
why it is difficult to do the exercises in the guide.)
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report Default Account

[John Ralls]

> On May 10, 2020, at 12:43 AM, flywire  wrote:
> 
> Something must have changed eg:
> https://www.gnucash.org/docs/v3/C/gnucash-guide/figures/cbook_TransactionRptAssets.png
> 
> I know I can change the report setting. Can someone point me to the guile
> file on my computer for that report? I'd like to tweak it.

The transaction report is in C:\Program Files 
(x86)\gnucash\share\gnucash\scm\gnucash\report\standard-reports\transaction.scm

If you can configure the report to your liking with the options there's no need 
to mess with the report code, just save the report configuration.

If you decide that you really do need to customize the report you'll want to 
read https://wiki.gnucash.org/wiki/Custom_Reports.

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