Re: [GNC] Reports to match Quicken
The Transaction Report can produce various totals, including by account. But after you paste into a spreadsheet, you can strip the currency symbols with a find/replace. If that doesn’t change those cells to number, you could change the format on them. Most spreadsheets also have a function to convert strings of numbers to numbers as well. I’ve never experienced any problem with the currency symbols myself, however. (I use both Libreoffice and Apple Numbers) If you get a dialog when you paste, make sure the option to ‘detect special numbers’ is checked if it is available. Regards, Adrien > On Aug 17, 2019, at 3:50 PM, Graham wrote: > > On 17/08/2019 19:50, Adrien Monteleone wrote: >> That looks like what you can get out of a Transaction Report. >> >> Regards, >> Adrien > > > Thanks, but the export of a transaction report seems to be pdf or html only, > and if I cut and paste into a spreadsheet, the values seem to come out as a > string, like > > $26.75 > > and using the Sum function gives a zero total > > -- > Cheerio, > > Graham ___ 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] Reports to match Quicken
On 17/08/2019 19:50, Adrien Monteleone wrote: That looks like what you can get out of a Transaction Report. Regards, Adrien Thanks, but the export of a transaction report seems to be pdf or html only, and if I cut and paste into a spreadsheet, the values seem to come out as a string, like $26.75 and using the Sum function gives a zero total -- Cheerio, Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ 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] Reports to match Quicken
That looks like what you can get out of a Transaction Report. Regards, Adrien > On Aug 17, 2019, at 12:36 PM, Graham wrote: > > Hi folks, > > I'm sorry to bother the list with what I suspect is a trivially easy problem, > but I've been trying and trying to get a report to match the sort I used to > get from Quicken. [and failing spectacularly badly!] > > I'm after an income and expense list, subtotalled by what used to be Category > in Quicken, to give a format such as: > > > DateAccount Description > Amount > > > > > > > > > > > > > > > > Interest Inc > > > > > > 29/03/2018 ANZ Online SaverCredit Interest $23.21 > > 28/02/2018 ANZ Online SaverCredit Interest $22.41 > > 31/01/2018 ANZ Online SaverCredit Interest $26.39 > > 29/12/2017 ANZ Online SaverCredit Interest $29.42 > > 30/11/2017 ANZ Online SaverCredit Interest $38.67 > > 06/11/2017 ANZ Joint (Acc Adv Chq) Account Credit Interest > $0.20 > > 06/11/2017 ANZ Online SaverBonus Interest $16.77 > > 31/10/2017 ANZ Online SaverCredit Interest $51.02 > > Any advice would be most welcome! > > -- > Cheerio, > > Graham ___ 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] Reports to match Quicken
Hi folks, I'm sorry to bother the list with what I suspect is a trivially easy problem, but I've been trying and trying to get a report to match the sort I used to get from Quicken. [and failing spectacularly badly!] I'm after an income and expense list, subtotalled by what used to be Category in Quicken, to give a format such as: DateAccount Description Amount Interest Inc 29/03/2018 ANZ Online SaverCredit Interest $23.21 28/02/2018 ANZ Online SaverCredit Interest $22.41 31/01/2018 ANZ Online SaverCredit Interest $26.39 29/12/2017 ANZ Online SaverCredit Interest $29.42 30/11/2017 ANZ Online SaverCredit Interest $38.67 06/11/2017 ANZ Joint (Acc Adv Chq) Account Credit Interest $0.20 06/11/2017 ANZ Online SaverBonus Interest $16.77 31/10/2017 ANZ Online SaverCredit Interest $51.02 Any advice would be most welcome! -- Cheerio, Graham --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ 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.