Re: [GNC] column summary in transaction reports

2022-02-23 Thread Karl May
Hi, @Adrien: that was good . thanks a lot. On Wednesday, 23 February 2022 9:33:42 PM AEDT Adrien Monteleone wrote: > Karl, before running your Account Report, do View > Filter by... and set > your date range. > > Just don't forget you filtered the register view! (there is a 'Filtered

Re: [GNC] column summary in transaction reports

2022-02-23 Thread Adrien Monteleone
Karl, before running your Account Report, do View > Filter by... and set your date range. Just don't forget you filtered the register view! (there is a 'Filtered' identifier in the upper-right of the register, but it is easy to miss) Regards, Adrien On 2/23/22 3:17 AM, Karl May wrote: Hi,

[GNC] column summary in transaction reports

2022-02-23 Thread Karl May
Hi, I am wondering whether it is possible to get a transaction report which list for an account the sum of each column (debit:credit, increase:decrease, etc) for a specific time period. Google pointed to a few similar questions in this email list and in reddit, but the suggestions don't work:

Re: [GNC] CSS Troubleshooting for Transaction reports

2021-02-22 Thread Adrien Monteleone
es, I'd recommend opening the report in a spreadsheet and making it pretty there instead. Regards, Adrien On 2/22/21 10:40 AM, Andreas Vyrides wrote: Dear Sir, I hope this email find you well. I have been having some issues with setting up transaction reports the way I want them to look.

[GNC] CSS Troubleshooting for Transaction reports

2021-02-22 Thread Andreas Vyrides
Dear Sir, I hope this email find you well. I have been having some issues with setting up transaction reports the way I want them to look. I have been able to get the printed version of the report (which is my main concern) the way I want it, but I have not been able to implement some of

Re: [GNC] How to work with paypal transaction reports?

2020-01-02 Thread friedem...@masur.de
Yes, that is sadly true. I tried two times to get answers from them but their hotline agents didn't even know some of the classification tags that PayPal uses in the reports. In the meantime, i found a german financial software provider that has a really good PayPal import, where it even show you

Re: [GNC] How to work with paypal transaction reports?

2020-01-01 Thread Alan
Frank, I saw that program while trying to get AqBanking to work, and I have no idea what it’s for. PayPal never supported direct transaction downloads. For some reason (sloppy web site design?) not every customer has access to the transaction download menus. I’m only able to use older incomplet

Re: [GNC] How to work with paypal transaction reports?

2020-01-01 Thread Frank H. Ellenberger
Hi, Am Do., 2. Jan. 2020 um 06:04 Uhr schrieb Alan via gnucash-user : > > I have a lot of experience with PayPal transaction import with Quicken, and > what > you're trying to do is impossible. Unless if PayPal radically changed their > system over the past year, all you can get that would be com

Re: [GNC] How to work with paypal transaction reports?

2020-01-01 Thread Alan via gnucash-user
I have a lot of experience with PayPal transaction import with Quicken, and what you're trying to do is impossible. Unless if PayPal radically changed their system over the past year, all you can get that would be compatible with a financial program, would be QIF format. QIF has no dupe detection,

Re: [GNC] How to work with paypal transaction reports?

2020-01-01 Thread Adrien Monteleone
I would think the first import would be assigned to the pending account, then the second would be split between pending and whatever current final account you’re using. There shouldn’t be any duplication that way. Regards, Adrien > On Jan 1, 2020 w1d1, at 4:47 PM, friedem...@masur.de wrote: >

Re: [GNC] How to work with paypal transaction reports?

2020-01-01 Thread friedem...@masur.de
Yes theoretically possible but then i would need to manually check all transactions to make sure that they go from pending to final. This kind of extra work i would like to avoid :D Is there a way to automate escrow accounts? I have a similar issue in my normal accounts when money leaves one acco

Re: [GNC] How to work with paypal transaction reports?

2020-01-01 Thread John Ralls
> On Jan 1, 2020, at 1:30 PM, friedem...@masur.de wrote: > > Hi, > > im manually importing all my paypal report into gnucash and technically > everything works. > > However paypal has a strange way of handling some transactions. > Sometimes transactions are "pending" e.g. when I have recei

[GNC] How to work with paypal transaction reports?

2020-01-01 Thread friedem...@masur.de
Hi, im manually importing all my paypal report into gnucash and technically everything works. However paypal has a strange way of handling some transactions. Sometimes transactions are "pending" e.g. when I have received money from an ebay buyer but the money will only show up as "confirmed" w

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-22 Thread Chris Good
; > From: Fran_3 > > To: Gnucash Users , Adrien Monteleone > > > > Subject: Re: [GNC] How to compare 2 Transaction Reports to find orphan > >transactions > > Message-ID: <1766876513.1811024.1573323422...@mail.yahoo.com> > > Content-Type: text/pla

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-10 Thread Adrien Monteleone
You’re welcome. Note as well, the Help Guide documents each menu in each context. While it may seem rather mundane at first, there are a few gems to glean from looking it over. This was one I stumbled on a while back and noticed that the menu entries change depending on the current tab. (rather

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Fran_3 via gnucash-user
Christopher said "You've stumbled upon a limitation SFX of regular expressions on filtering the transaction report." My Question: Wikipedia list numerous definitions for SFX... in this case what? (Self Extracting Software or what?) Greg Francis suggested NotePad++ My Response: Yes, I am a longtim

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Fran_3 via gnucash-user
Adrian, you said... "instead do a Find operation then run an Account Report instead of a Transaction Report. (since Find can filter on more fields)" My comment: I did not know about the "Account Report"  option... It seems it only appears under the Reports Menu if you are looking at a register

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Christopher Lam
Oops. The regex filter is a late addition from 2017. Unfortunately regex negate string match (I.e. match not containing a string) is a general weakness of POSIX regex. May I suggest file an enhancement request in Bugzilla? On Sat, 9 Nov 2019, 23:38 Christopher Lam, wrote: > Hi Fran > > You've

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Greg Feneis
If the reports you're interested in comparing are text based, and your computer's OS allows you to use Notepad++, you might consider using Notepad++ to compare the two files. Notepad++ is a free open source text editor that has a great file comparison tool. Kind regards, Greg Feneis On Sa

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Christopher Lam
Hi Fran You've stumbled upon a limitation SFX of regular expressions on filtering the transaction report. You may be aware that the transaction report was, for many years, the most versatile report to extract information from a Gnucash data file. It had severe limitations and bugs and On Sat, 9

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Adrien Monteleone
I forgot to mention, when trying to craft a better resulting report, ask yourself, “What makes the transactions on either report not show up on the other?” Then use *that* info to craft the intended report. (as it is the set of transactions you are looking for) Regards, Adrien > On Nov 9, 201

Re: [GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Adrien Monteleone
I would say consider the criteria you used to create the set of transactions for each report, then try to craft a report using the options that gives you only those that don’t lie in the joint set. If *every* transaction on both reports is between two and only the *same two* accounts then you m

[GNC] How to compare 2 Transaction Reports to find orphan transactions

2019-11-09 Thread Fran_3 via gnucash-user
I want to compare Transaction Report A to Transaction Report B and find transactions that appear on one report but not on the other... aka orphan transactions In past I have either... - Done a screen capture of each, pasted them side by side in PC Paint and marked off matching transactions one by

Re: [GNC] Transaction reports with only debits or credits

2018-08-20 Thread Adrien Monteleone
There are two ways. One involves adding a ’tag’ to each transaction, the other involves using a spreadsheet. If you want GnuCash to produce the report directly, you would need some sort of ’tag’ (this if figurative here, GnuCash doesn’t have a ’tag’ feature) in either the Description, Notes, or

Re: [GNC] Links in transaction reports

2018-08-17 Thread Nancy Tague
Found it! (Under the General tab of Style Sheets.) I knew I’d seen links somewhere. Thank you so much. From: Christopher Lam Sent: Thursday, August 16, 2018 3:07 AM To: Nancy Tague Cc: GnuCash users group Subject: Re: [GNC] Links in transaction reports Hi Nancy, welcome to Gnucash user

Re: [GNC] Links in transaction reports

2018-08-16 Thread David T. via gnucash-user
:07 AM, Christopher Lam > > <mailto:christopher@gmail.com>> wrote: >> > >> > Hi Nancy, welcome to Gnucash user list! >> > >> > You can disable links but it's not obvious in the transaction report. >> > You'll need to modify the s

Re: [GNC] Links in transaction reports

2018-08-16 Thread Christopher Lam
t;> wrote: >> > >> > Hi Nancy, welcome to Gnucash user list! >> > >> > You can disable links but it's not obvious in the transaction report. >> > You'll need to modify the style sheet used (edit menu) then reload the >> > transact

Re: [GNC] Links in transaction reports

2018-08-16 Thread David T. via gnucash-user
but it's not obvious in the transaction report. > > You'll need to modify the style sheet used (edit menu) then reload the > > transaction report. > > > > On Thu, 16 Aug 2018, 16:55 Nancy Tague > <mailto:nancyta...@centurytel.net>> wrote: > >

Re: [GNC] Links in transaction reports

2018-08-16 Thread Christopher Lam
; You'll need to modify the style sheet used (edit menu) then reload the > > transaction report. > > > > On Thu, 16 Aug 2018, 16:55 Nancy Tague > wrote: > > > >> I’m a brand new GnuCash user trying to figure out its features. This > one > >> has m

Re: [GNC] Links in transaction reports

2018-08-16 Thread David T. via gnucash-user
to modify the style sheet used (edit menu) then reload the > transaction report. > > On Thu, 16 Aug 2018, 16:55 Nancy Tague wrote: > >> I’m a brand new GnuCash user trying to figure out its features. This one >> has me stumped. The numbers in transaction reports show a

Re: [GNC] Links in transaction reports

2018-08-16 Thread Christopher Lam
ing to figure out its features. This one > has me stumped. The numbers in transaction reports show as blue and > underlined – they’re links to the register. Is there a way to turn that > off? I don’t want my reports to have blue underlined numbers. Thanks for

[GNC] Links in transaction reports

2018-08-16 Thread Nancy Tague
I’m a brand new GnuCash user trying to figure out its features. This one has me stumped. The numbers in transaction reports show as blue and underlined – they’re links to the register. Is there a way to turn that off? I don’t want my reports to have blue underlined numbers. Thanks for your

[GNC] Transaction reports with only debits or credits

2018-08-15 Thread AC
Is there a way to configure a transaction report (or any of the available reports) to show only the debits or the credits (but not both) of an account? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to un

Transaction reports

2017-10-06 Thread Denis_gmail
I had no problem with version 16 and transaction report. Gnucash was loading without delay. With version 17 there was a very long delay. Gnucash was stuck for 36 seconds for loading two transaction reports. I return to version 16 and no more delay. With version 18 I get the same problem

Re: Problem with balance sheet and transaction reports

2017-06-07 Thread Pierre Maitre
[SOLVED] Thanks to everyone for your answers. I proceeded as Adrien suggested and found that there was a problem each time I had a transaction in a different currency (EUR). In fact, the transactions in foreign currency were not "translated" into the local currency in the report, and therefore Gnuc

Re: Problem with balance sheet and transaction reports

2017-06-07 Thread Geert Janssens
Hi, You should probably start by uprading to a newer version of gnucash. 2.6.1 has known issues attempting to report on large data sets. It is unfortunate Ubuntu 14.04 is tied to version 2.6.1. You may get a newer one via the getdeb repository. Regards, Geert On Wed, Jun 7, 2017 at 12:34 PM,

Re: Problem with balance sheet and transaction reports

2017-06-07 Thread David Carlson
From: Adrien Monteleone > Date: Wed, Jun 7, 2017 at 1:19 PM > Subject: Re: Problem with balance sheet and transaction reports > To: Pierre Maitre > > > For the balance sheet issue, I'd start with 12/31/10 as the target date and > work my way backwards to 1/1/10 dividing the

Fwd: Problem with balance sheet and transaction reports

2017-06-07 Thread Adrien Monteleone
-- Forwarded message -- From: Adrien Monteleone Date: Wed, Jun 7, 2017 at 1:19 PM Subject: Re: Problem with balance sheet and transaction reports To: Pierre Maitre For the balance sheet issue, I'd start with 12/31/10 as the target date and work my way backwards to 1

Problem with balance sheet and transaction reports

2017-06-07 Thread Pierre Maitre
Hi everyone I have imported QIF data from Quicken into Gnucash from three different bookkeeping periods in order to have all my bookkeeping data in a single file. My Gnucash version is 2.6.1, running under Linux (Ubuntu 14.04). The import went smoothly. I now have been working 5 months on it wit