Re: [GNC] Reporting Woes - Newbie incompetence
Hi Brook You are correct in that reports are in html. However, all you have to do is highlight the whole report with the mouse. With that done do a Control and C copy. Next open your spread sheet and paste. Alternatively save the report, then open it with your spreadsheet. You will likely get asked about the document layout - it is Tab delimited. Having chosen that the file shoul load. You can then save it in the native format of the spreadsheet. Regards Pete Dr Peter Cuthbert Creuddyn Coedlan y Plas Llangawsai Aberystwyth Sir Ceredigion SY23 1HJ From: Keith N. McKenna Sent: March 26, 2023 11:34:13 PM GMT+01:00 To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Reporting Woes - Newbie incompetence Brook Milligan wrote: On Mar 24, 2023, at 10:35 AM, R. Victor Klassen wrote: I use a transaction report for what you seek. With the right options I get the account, date, description and amount. Copy paste the result into a spreadsheet Perhaps I am doing something wrong, but how do you copy/paste the result into a spreadsheet. My understanding is that the reports are HTML documents. Perhaps there is some magic I am not aware of? Cheers, Brook ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user <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. Most spreadsheet programs will open HTML files. Apache OpenOffice, LibraOffive, and Excel I know will. Regards Keith N. McKenna ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user <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] Reporting Woes - Newbie incompetence
Brook Milligan wrote: On Mar 24, 2023, at 10:35 AM, R. Victor Klassen wrote: I use a transaction report for what you seek. With the right options I get the account, date, description and amount. Copy paste the result into a spreadsheet Perhaps I am doing something wrong, but how do you copy/paste the result into a spreadsheet. My understanding is that the reports are HTML documents. Perhaps there is some magic I am not aware of? Cheers, Brook ___ 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. Most spreadsheet programs will open HTML files. Apache OpenOffice, LibraOffive, and Excel I know will. Regards Keith N. McKenna ___ 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] Reporting Woes - Newbie incompetence
On 2023-03-24 12:57, Adrien Monteleone wrote: > I haven't tested other apps, but both LibreOffice Calc & Apple Numbers > can either open the exported file directly as it is just an HTML table, > and both accept copy/pasted reports though either or both methods may > pop up a dialog for handling column widths, delimiters, special > characters, etc. > > I'm pretty certain folks have reported that Excel and Google Sheets also > handle this just fine. Others reported in this thread that Copy/Paste into Excel works. I reported that File » Open allows opening the HTML file directly in Excel. Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ 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] Reporting Woes - Newbie incompetence
Hi Everybody Thanks Murugan. Glad to know it works in Excel. For those of us on pensions who may be using LibreOffice Calc your exported report will work fine with no error messages, If you save it, you can then have it in one of the spreadsheet formats. Regards Pete -- Original Message -- From: "Murugan Muruganandam" To: "Brook Milligan" ; "R. Victor Klassen" Cc: "gnucash-user@gnucash.org" Sent: Friday, 24 Mar, 2023 At 18:25 Subject: Re: [GNC] Reporting Woes - Newbie incompetence when you export give a .xls you can then open it in excel, it will give an alert but you can override it Saludos Cordiales Murugan From: gnucash-user on behalf of Brook Milligan Sent: Friday, March 24, 2023 1:41 PM To: R. Victor Klassen Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Reporting Woes - Newbie incompetence On Mar 24, 2023, at 10:35 AM, R. Victor Klassen wrote: I use a transaction report for what you seek. With the right options I get the account, date, description and amount. Copy paste the result into a spreadsheet Perhaps I am doing something wrong, but how do you copy/paste the result into a spreadsheet. My understanding is that the reports are HTML documents. Perhaps there is some magic I am not aware of? Cheers, Brook ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user <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 <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. Dr Peter Cuthbert Creuddyn Coedlan Y Plas Llangawsai Aberystwyth Ceredigion SY23 1HJ 01970 623 447 ___ 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] Reporting Woes - Newbie incompetence - SOLVED!
Hi Maf (and everybody who has taken the trouble to respond to this query) Thank you all for your thoughts. I am amazed to have an inbox full already. I have investigated Maf's suggestion of using the Transaction Report and have managed to get out something like what I was seeking. I was amused that my first attempt was all for 2019 transactions despite getting the date limits set correctly to 2023. Attempt two was much closer and included 2019 transactions forward to my set closing date. Clearly this is going to work, but only once I find all the correct settings! Thanks too for colleagues in the US, some of whom have made clear instructions for how to use the system for submitting a US Tax return. I am sorry that I failed to mention where I was located. However, there may be Newbies in the US who will benefit from your suggestions. Here in the UK the tax authorities have moved to simpler and more simple accounts. I have to certify that my return is based on cash in and cash out and contains no accruals or prepayments. Picking up on Brook's point about getting the data out of the Report and into a spreadsheet, that is quite straight forward. Simply place the cursor in the top left hand corner then click, hold down the left button and drag down to the right hand corner. When you release the mouse button the whole page should be high lighted. Control and C will copy that page and then in your spreadsheet you can do a Control V or or use Edit Paste Special. You may be asked about the format of the paste. It is Tab deliminated so if you choose Tab and nothing else (ignore, comma, space, etc) your data will layout in the spreadsheet as on screen. Thank you again. I will now get down to playing with the parameters until it gives what I thought I had asked it to supply. Best wishes Pete -- Original Message -- From: "Maf. King" To: gnucash-user@gnucash.org Sent: Friday, 24 Mar, 2023 At 16:02 Subject: Re: [GNC] Reporting Woes - Newbie incompetence On Friday, 24 March 2023 12:54:19 GMT p.f.cuthb...@btinternet.com p.f.cuthbert--- via gnucash-user wrote: Hi Folks The end of the UK Tax Year approaches and I am thinking about my tax return. When I used Quicken there was a report that listed every transcation in particular accounts which was useful since not all my accounts are related to the Return. I had been hoping to do the same in GNU but I don't seem to be able to find a way to do something so simple. (Yes I have read all about Reporting but am not a lot the wiser) Opening a relevant account, choosing Select All, Copy and Paste into a spreadsheet does not seem to be possible either. I am sure that somebody has worked out how to do this hence my request. I think the transaction report will do what you want, with a bit of careful options settings. I'm in the UK, I run one transaction report for relevant income and one for expenses each year as the basis for my tax return numbers. HTH, Maf. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user <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. Dr Peter Cuthbert Creuddyn Coedlan Y Plas Llangawsai Aberystwyth Ceredigion SY23 1HJ 01970 623 447 ___ 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] Reporting Woes - Newbie incompetence
If the Transaction Report can't get you what you want, consider an Account Report. You could filter any register to show just the transactions you are concerned with. If the filters are not quite nuanced enough for you, or if you want multiple accounts in one report, then craft a Find set of criteria to get you exactly the transactions you want which will appear in a single search result tab in register form. Then simply run an Account Report while viewing those results. Regards, Adrien On 3/24/23 7:54 AM, p.f.cuthb...@btinternet.com p.f.cuthbert--- via gnucash-user wrote: Hi Folks The end of the UK Tax Year approaches and I am thinking about my tax return. When I used Quicken there was a report that listed every transcation in particular accounts which was useful since not all my accounts are related to the Return. I had been hoping to do the same in GNU but I don't seem to be able to find a way to do something so simple. (Yes I have read all about Reporting but am not a lot the wiser) Opening a relevant account, choosing Select All, Copy and Paste into a spreadsheet does not seem to be possible either. I am sure that somebody has worked out how to do this hence my request. ___ 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] Reporting Woes - Newbie incompetence
I haven't tested other apps, but both LibreOffice Calc & Apple Numbers can either open the exported file directly as it is just an HTML table, and both accept copy/pasted reports though either or both methods may pop up a dialog for handling column widths, delimiters, special characters, etc. I'm pretty certain folks have reported that Excel and Google Sheets also handle this just fine. Regards, Adrien On 3/24/23 11:41 AM, Brook Milligan wrote: On Mar 24, 2023, at 10:35 AM, R. Victor Klassen wrote: I use a transaction report for what you seek. With the right options I get the account, date, description and amount. Copy paste the result into a spreadsheet Perhaps I am doing something wrong, but how do you copy/paste the result into a spreadsheet. My understanding is that the reports are HTML documents. Perhaps there is some magic I am not aware of? ___ 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] Reporting Woes - Newbie incompetence
when you export give a .xls you can then open it in excel, it will give an alert but you can override it Saludos Cordiales Murugan From: gnucash-user on behalf of Brook Milligan Sent: Friday, March 24, 2023 1:41 PM To: R. Victor Klassen Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Reporting Woes - Newbie incompetence > On Mar 24, 2023, at 10:35 AM, R. Victor Klassen wrote: > > I use a transaction report for what you seek. With the right options I get > the account, date, description and amount. Copy paste the result into a > spreadsheet Perhaps I am doing something wrong, but how do you copy/paste the result into a spreadsheet. My understanding is that the reports are HTML documents. Perhaps there is some magic I am not aware of? Cheers, Brook ___ 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] Reporting Woes - Newbie incompetence
>>> On Mar 24, 2023, at 10:35 AM, R. Victor Klassen >>> wrote: >>> >>> I use a transaction report for what you seek. With the right >>> options I get the account, date, description and amount. Copy >>> paste the result into a spreadsheet >> On Mar 24, 2023, at 12:41 PM, Brook Milligan wrote: >> Perhaps I am doing something wrong, but how do you copy/paste the >> result into a spreadsheet. >> >> My understanding is that the reports are HTML documents. Perhaps >> there is some magic I am not aware of? On 2023-03-24 09:50, R. Victor Klassen wrote: > What works for me is just selecting the contents of the report and > doing copy. Then opening a spreadsheet and doing paste Excel will also open an HTML file directly, in the File » Open dialog. (That's Excel 2010 in Windows 10. I can't imagine later versions would have lost that capability, but I don't know about Excel in other OSes.) Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ 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] Reporting Woes - Newbie incompetence
What works for me is just selecting the contents of the report and doing copy. Then opening a spreadsheet and doing paste Sent from my iPhone > On Mar 24, 2023, at 12:41 PM, Brook Milligan wrote: > > >> On Mar 24, 2023, at 10:35 AM, R. Victor Klassen wrote: >> >> I use a transaction report for what you seek. With the right options I get >> the account, date, description and amount. Copy paste the result into a >> spreadsheet > > Perhaps I am doing something wrong, but how do you copy/paste the result into > a spreadsheet. > > My understanding is that the reports are HTML documents. Perhaps there is > some magic I am not aware of? > > Cheers, > Brook > ___ 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] Reporting Woes - Newbie incompetence
> On Mar 24, 2023, at 10:35 AM, R. Victor Klassen wrote: > > I use a transaction report for what you seek. With the right options I get > the account, date, description and amount. Copy paste the result into a > spreadsheet Perhaps I am doing something wrong, but how do you copy/paste the result into a spreadsheet. My understanding is that the reports are HTML documents. Perhaps there is some magic I am not aware of? Cheers, Brook ___ 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] Reporting Woes - Newbie incompetence
I use a transaction report for what you seek. With the right options I get the account, date, description and amount. Copy paste the result into a spreadsheet Sent from my iPhone > On Mar 24, 2023, at 12:30 PM, Michael or Penny Novack > wrote: > > >>> The end of the UK Tax Year approaches and I am thinking about my tax >>> return. When I used Quicken there was a report that listed every >>> transcation in particular accounts which was useful since not all my >>> accounts are related to the Return. I had been hoping to do the same in >>> GNU but I don't seem to be able to find a way to do something so simple. >>> (Yes I have read all about Reporting but am not a lot the wiser) >>> >>> Opening a relevant account, choosing Select All, Copy and Paste into a >>> spreadsheet does not seem to be possible either. >>> >>> I am sure that somebody has worked out how to do this hence my request. > > Keep in mind jurisdictions differ, so what I am about to describe would be US > (and 501(c)3 non-profits) > > Gnucash is a basic accounting system, keeps standard double entry books. You > need to set up your CaO so that the data will be usefully grouped for tax and > other reporting purposes. BUT also keep in mind that you might have to > do some work outside of gnucash because you might need to be reporting to > different entities (the state might require different from the feds) and you > can have only one hierarchy of accounts. > > For example, "printing and postage" is a line item on the 990/990-EZ > *Federal" so each expense parent that has those as a component of that > parent's total* should have a separate "printing and postage" child. If what > you "pay" and intern is partly PAY and partly Mileage Reimbursement you'd > want those as separate children under that intern (because the pay part might > mean a 1099-MISC) > > In other words, it is going to be up to YOU to create a suitable CoA so it > will make it easy to get the data you need for the reports you must fill out. > > 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. ___ 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] Reporting Woes - Newbie incompetence
The end of the UK Tax Year approaches and I am thinking about my tax return. When I used Quicken there was a report that listed every transcation in particular accounts which was useful since not all my accounts are related to the Return. I had been hoping to do the same in GNU but I don't seem to be able to find a way to do something so simple. (Yes I have read all about Reporting but am not a lot the wiser) Opening a relevant account, choosing Select All, Copy and Paste into a spreadsheet does not seem to be possible either. I am sure that somebody has worked out how to do this hence my request. Keep in mind jurisdictions differ, so what I am about to describe would be US (and 501(c)3 non-profits) Gnucash is a basic accounting system, keeps standard double entry books. You need to set up your CaO so that the data will be usefully grouped for tax and other reporting purposes. BUT also keep in mind that you might have to do some work outside of gnucash because you might need to be reporting to different entities (the state might require different from the feds) and you can have only one hierarchy of accounts. For example, "printing and postage" is a line item on the 990/990-EZ *Federal" so each expense parent that has those as a component of that parent's total* should have a separate "printing and postage" child. If what you "pay" and intern is partly PAY and partly Mileage Reimbursement you'd want those as separate children under that intern (because the pay part might mean a 1099-MISC) In other words, it is going to be up to YOU to create a suitable CoA so it will make it easy to get the data you need for the reports you must fill out. 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] Reporting Woes - Newbie incompetence
On Friday, 24 March 2023 12:54:19 GMT p.f.cuthb...@btinternet.com p.f.cuthbert--- via gnucash-user wrote: > Hi Folks > > The end of the UK Tax Year approaches and I am thinking about my tax > return. When I used Quicken there was a report that listed every > transcation in particular accounts which was useful since not all my > accounts are related to the Return. I had been hoping to do the same in > GNU but I don't seem to be able to find a way to do something so simple. > (Yes I have read all about Reporting but am not a lot the wiser) > > Opening a relevant account, choosing Select All, Copy and Paste into a > spreadsheet does not seem to be possible either. > > I am sure that somebody has worked out how to do this hence my request. > I think the transaction report will do what you want, with a bit of careful options settings. I'm in the UK, I run one transaction report for relevant income and one for expenses each year as the basis for my tax return numbers. HTH, Maf. ___ 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] Reporting Woes - Newbie incompetence
I live in the U. S., and here the tax report is tied to the IRS form 1040. That would be worse than useless in the U. K. I am not sure what might be available there. On Fri, Mar 24, 2023, 8:11 AM Fred Tydeman wrote: > Try: > Edit: > Tax Report Options > to set up which (Income & Expense) accounts matter. > > Then, run: > Reports: > Tax Schedule Report & TFX Export > > This is mentioned in the Tutorial and Concepts Guide (search for Tax > Report) > > > On Fri, Mar 24, 2023 at 2:54 PM p.f.cuthb...@btinternet.com > p.f.cuthbert--- > via gnucash-user wrote: > > > > > Hi Folks > > > > The end of the UK Tax Year approaches and I am thinking about my tax > > return. When I used Quicken there was a report that listed every > > transcation in particular accounts which was useful since not all my > > accounts are related to the Return. I had been hoping to do the same in > > GNU but I don't seem to be able to find a way to do something so simple. > > (Yes I have read all about Reporting but am not a lot the wiser) > > > > Opening a relevant account, choosing Select All, Copy and Paste into a > > spreadsheet does not seem to be possible either. > > > > I am sure that somebody has worked out how to do this hence my request. > > > > Many thanks > > > > Pete > > > > Dr Peter Cuthbert > > Creuddyn > > Coedlan Y Plas > > > > Llangawsai > > Aberystwyth > > Ceredigion > > SY23 1HJ > > 01970 623 447 > > ___ > > 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. > ___ 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] Reporting Woes - Newbie incompetence
Bear in mind that that option is designed for US Income Taxes only. I believe someone did a version for Germany but am not sure if it is up-to-date. You can, of course, try to use it anyway. Perhaps a response from a gnucash user in the UK might be helpful? Alex > -- Forwarded message -- > From: Fred Tydeman > To: "p.f.cuthb...@btinternet.com p.f.cuthb...@btinternet.com" < > p.f.cuthb...@btinternet.com> > Cc: gnucash-user@gnucash.org > Bcc: > Date: Fri, 24 Mar 2023 15:10:37 +0200 > Subject: Re: [GNC] Reporting Woes - Newbie incompetence > Try: > Edit: > Tax Report Options > to set up which (Income & Expense) accounts matter. > > Then, run: > Reports: > Tax Schedule Report & TFX Export > > This is mentioned in the Tutorial and Concepts Guide (search for Tax > Report) > > > On Fri, Mar 24, 2023 at 2:54 PM p.f.cuthb...@btinternet.com > p.f.cuthbert--- > via gnucash-user wrote: > > > > > Hi Folks > > > > The end of the UK Tax Year approaches and I am thinking about my tax > > return. When I used Quicken there was a report that listed every > > transcation in particular accounts which was useful since not all my > > accounts are related to the Return. I had been hoping to do the same in > > GNU but I don't seem to be able to find a way to do something so simple. > > (Yes I have read all about Reporting but am not a lot the wiser) > > > > Opening a relevant account, choosing Select All, Copy and Paste into a > > spreadsheet does not seem to be possible either. > > > > I am sure that somebody has worked out how to do this hence my request. > > > > Many thanks > > > > Pete > > > > Dr Peter Cuthbert > > Creuddyn > > Coedlan Y Plas > > > > Llangawsai > > Aberystwyth > > Ceredigion > > SY23 1HJ > > 01970 623 447 > > ___ > > 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] Reporting Woes - Newbie incompetence
Try: Edit: Tax Report Options to set up which (Income & Expense) accounts matter. Then, run: Reports: Tax Schedule Report & TFX Export This is mentioned in the Tutorial and Concepts Guide (search for Tax Report) On Fri, Mar 24, 2023 at 2:54 PM p.f.cuthb...@btinternet.com p.f.cuthbert--- via gnucash-user wrote: > > Hi Folks > > The end of the UK Tax Year approaches and I am thinking about my tax > return. When I used Quicken there was a report that listed every > transcation in particular accounts which was useful since not all my > accounts are related to the Return. I had been hoping to do the same in > GNU but I don't seem to be able to find a way to do something so simple. > (Yes I have read all about Reporting but am not a lot the wiser) > > Opening a relevant account, choosing Select All, Copy and Paste into a > spreadsheet does not seem to be possible either. > > I am sure that somebody has worked out how to do this hence my request. > > Many thanks > > Pete > > Dr Peter Cuthbert > Creuddyn > Coedlan Y Plas > > Llangawsai > Aberystwyth > Ceredigion > SY23 1HJ > 01970 623 447 > ___ > 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.