[GNC] Transaction report

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 se

[GNC] Transaction Report

Just filed bug 797018 for the below: O/S: Ubuntu 18.04 GnC: 3.4-18 (git maint branch) Unable to location option on Transaction Report to split amount column into Debit/Credit columns when creating a new Transaction report. If I run a saved version from 3.3, the amount column is split. But still u

[GNC] Transaction Report

When doing double columns for the amount (DR/CR), the sub-totals/totals only show the combined total.  Is there an option to show the totals per column?  (similar to what the Reconciliation report shows). --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-

[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 al

[GNC] Transaction Report

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 acco

[GNC] Transaction report

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 cur

[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 Nam

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 J

Re: [GNC] Transaction report

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

Re: [GNC] Transaction report

tarting 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 repo

[GNC] Transaction Report Question

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

[GNC] Transaction Report Filter ?

Hello, I want to use Filter to filter My Transactions included with "words" i want. For example : transaction-report-1.png i spent some money for gas in "gas account" 1 for "car" 1 for anythings else So when i create

Re: [GNC] Transaction Report

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

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 we

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 acc

Re: [GNC] Transaction Report

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

Re: [GNC] Transaction Report

n 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 Rep

Re: [GNC] Transaction Report Shortcomings

tly 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 Tran

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 gr

Re: [GNC] Transaction Report Shortcomings

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

Re: [GNC] Transaction Report Shortcomings

istopher 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

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.

Re: [GNC] Transaction Report Question

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

Re: [GNC] Transaction Report Question

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

Re: [GNC] Transaction Report Question

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

[GNC] Transaction Report Preference missing?

Hello, Long time user; MacOS Mojave, GnuCash 3.4. I have a saved report I use around this time of year (I call it “W-2 - David”) that shows me the total amounts assigned to a subset of my expense accounts (i.e., my tax expense accounts). The purpose of this report is to allow me to compare my G

[GNC] Transaction Report Sign Reverses

Hello, I am trying to create a YTD Capital Gains report, and am encountering a problem with how the Transaction Report implements the Sign Reverses setting. I recall some time back a discussion about the fact that the Sign Reverses setting reverses signs in these reports in a confusing way.

[GNC] Transaction Report Default Account

A Transaction Report is grouped by Account. The Default Display selecting Account Name and not Other Account Name seems wrong, the whole group has that account name. The setting is contrary to the equivalent report in other Financial packages. Any concerns with me listing it as a bug? _

[GNC] Transaction Report Filter Questions

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 pref

[GNC] transaction report missing subtotals

hi all under the transaction report, i am able to get a view of any accounts i want per month, but doesn't show a per month grand total (its blank). i am only shown a total for all the months combined. i am also shown on the per month transaction report, a separate total per account and no subto

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

] 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

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

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 nega

[GNC] Transaction Report - Split Transactions

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, Servic

Re: [GNC] Transaction Report - Split Transactions

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 re

Re: [GNC] transaction report missing subtotals

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:

Re: [GNC] transaction report missing subtotals

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 Repor

Re: [GNC] transaction report missing subtotals

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

Re: [GNC] transaction report missing subtotals

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 Subtot

[GNC] Transaction report export file type

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? Ri

[GNC] Transaction report export file type

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

[GNC] Transaction Report Account Name Style

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

Re: [GNC] Transaction Report Preference missing?

There's "Sorting / Show subtotals only (hide transactional data)" You may be right that 'Display / Amount' = none is not completely handled as before. Please file a bug, and screenshot a sample report, anonymised; please enable 'General / Add options summary' to display options used. Also,

Re: [GNC] Transaction Report Preference missing?

Chris, Thank you for the lead. It turns out that I can get almost exactly the same result using the hide transactional data option, when I combine it with "Amount - Single”. The only difference is that the Account name is not presented before the total line. I consider that to be an improveme

Re: [GNC] Transaction Report Preference missing?

Chris, I do note one issue with the new transaction report: it doesn’t seem to utilize the Sign Reverses option—at least, not that I can see. Cheers, David > On Jan 16, 2019, at 7:29 PM, David T. via gnucash-user > wrote: > > Chris, > > Thank you for the lead. > > It turns out that I can

Re: [GNC] Transaction Report Preference missing?

This is by design. Previously a transaction report including *all* accounts for a specified period would erroneously add the sign-reversed amounts as displayed, which would lead to the grand total being a nonsensical number. Eg income $100 expense $50. Amounts: Bank $100 -$50 Income $100 Expense $

Re: [GNC] Transaction Report Preference missing?

Then why include the option? It no longer does anything, except imply to the user that they have control over something they Nik longer can control. David On January 17, 2019, at 6:27 AM, Christopher Lam wrote: This is by design. Previously a transaction report including *all* accounts for

Re: [GNC] Transaction Report Preference missing?

Sadly, the gnucash project has a long history of never removing features. The amount sign reversal is still functional for the transactional amounts. Only the subtotals are unaffected. On Thu., 17 Jan. 2019, 09:08 D Then why include the option? It no longer does anything, except imply to > the u

Re: [GNC] Transaction Report Preference missing?

Chris, While I understand and respect the goal of backward compatibility, I'll point out that your changes to this report have already broken backward compatibility, as evidenced by my original example.  Settings which worked previously yield meaningless results now, and I have had to go through

Re: [GNC] Transaction Report Preference missing?

I don't know, sorry. You're very welcome to dive into code and try. https://github.com/Gnucash/gnucash/pull/229 will be a good place to start research. On Thu., 17 Jan. 2019, 10:24 David T. Chris, > > While I understand and respect the goal of backward compatibility, I'll > point out that your ch

Re: [GNC] Transaction Report Preference missing?

Chris,  Thanks for the offer, but readers of these lists over the years can vouch for my utter inability to contribute meaningfully to any code. That's why I've tried to contribute to the documentation (although to be truthful, even that is a stretch). I apologize for suggesting tasks for you to

Re: [GNC] Transaction Report Preference missing?

It seems the Balance sheet honors the setting, but using the ’None’ option in Preferences produces a disconcerting result. With the option set to Credit Accounts, all amounts (normally balanced) are positive. With the option set to None, the Liability and Equity line items are negative, but wi

Re: [GNC] Transaction Report Preference missing?

It's fine to make recommendations. During the transaction upgrade I remembered some wishlist items and was able to implement them. The limitations for reversing subtotals stem from the fact that subtotal & grouping is not limited to account types, but can also be organised by date and other keys.

Re: [GNC] Transaction Report Sign Reverses

https://wiki.gnucash.org/wiki/FAQ#Q:_Why_does_the_Transaction_Report_.27Sign_Reversal.27_setting_not_work_on_subtotals This issue could be fixed if the scenario addressed in this FAQ can be resolved. I don't really know how to handle that particular case. On Mon., 12 Aug. 2019, 13:02 David T. via

Re: [GNC] Transaction Report Sign Reverses

David, Try Display > Amount > Double (default is ’Single’) I’m not sure why this works when both debit & credit columns are visible, and not when only the credit column is visible, but it does. I have my Global preference for Sign Reverses set to ‘Credit Accounts’ and I set the report to ‘Glob

Re: [GNC] Transaction Report Sign Reverses

Well, it seems odd to me that "Double" display (as Adrien noted)(thank you, Adrien!) is able to display the figures as the user prefers. It is also odd to me that the report knows to switch the values of the individual transactions, but is unable to remember that fact when it comes to the total

Re: [GNC] Transaction Report Sign Reverses

I agree, the FAQ example is incorrect. It doesn’t reverse the sign of Business:Expenses when it should. Even if that were a contra-income account, it would still normally have a debit balance (+) and get reversed. The same goes for using the ‘Credit Accounts’ setting. 1) Assets = Liabilities +

Re: [GNC] Transaction Report Sign Reverses

Maybe I'm being thick here, but it's still not easy. We need to start with the knowledge that *internally* income amounts are negative -- after all they usually balance with positive asset amounts. Also, liability amounts are also internally negative, but no one seems to have a problem with that.

Re: [GNC] Transaction Report Sign Reverses

> On Aug 13, 2019, at 12:12 AM, Christopher Lam > wrote: > > Maybe I'm being thick here, but it's still not easy. We need to start with > the knowledge that *internally* income amounts are negative -- after all they > usually balance with positive asset amounts. Also, liability amounts are a

Re: [GNC] Transaction Report Default Account

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

Re: [GNC] Transaction Report Default Account

On 5/10/2020 3: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. Quest

Re: [GNC] Transaction Report Default Account

On 5/10/2020 3:25 AM, flywire wrote: A Transaction Report is grouped by Account. The Default Display selecting Account Name and not Other Account Name seems wrong, the whole group has that account name. The setting is contrary to the equivalent report in other Financial packages. Any concerns wit

Re: [GNC] Transaction Report Default Account

> 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

Re: [GNC] Transaction Report Default Account

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

Re: [GNC] Transaction Report Filter Questions

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][O

Re: [GNC] Transaction Report Filter Questions

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

[GNC] Transaction report: selected date range

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

Re: [GNC] transaction report missing subtotals

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. On Wed, 8 Aug 2018, 20:08 lebyarules via gnucash-user < gnucash-user@gnucash.org> wrote: > hi all > > und

[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 s

Re: [GNC] Transaction Report not working

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 b

Re: [GNC] Transaction Report not working

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 u

Re: [GNC] Transaction Report not working

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 availabl

Re: [GNC] Transaction Report - Split Transactions

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 l

Re: [GNC] Transaction Report - Split Transactions

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

Re: [GNC] Transaction Report - Split Transactions

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

Re: [GNC] Transaction Report - Split Transactions

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 furt

Re: [GNC] Transaction Report - Split Transactions

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 c

Re: [GNC] Transaction Report - Split Transactions

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

Re: [GNC] Transaction Report - Split Transactions

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 m

[GNC] Transaction Report Options menu bug report

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

Re: [GNC] Transaction report export file type

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

Re: [GNC] Transaction report export file type

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 w

Re: [GNC] Transaction report export file type

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

Re: [GNC] Transaction report export file type

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:

Re: [GNC] Transaction report export file type

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

Re: [GNC] Transaction report export file type

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.

Re: [GNC] Transaction report export file type

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 sof

Re: [GNC] Transaction report export file type

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 sc

Re: [GNC] Transaction report export file type

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 __

Re: [GNC] Transaction report export file type

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"

Re: [GNC] Transaction report export file type

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"

Re: [GNC] Transaction report export file type

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

Re: [GNC] Transaction report export file type

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

Re: [GNC] Transaction report export file type

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 d

Re: [GNC] Transaction report export file type

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 proba

Re: [GNC] Transaction report export file type

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 prob

[GNC] Transaction report not seeing selected account

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 cl

Re: [GNC] Transaction Report Account Name Style

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 wel

Re: [GNC] Transaction Report Account Name Style

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 unsubscri

Re: [GNC] Transaction Report Account Name Style

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

Re: [GNC] Transaction report: selected date range

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 unsubs

  1   2   >