Re: [GNC] Fwd: Tips for maintining different accounting for different countries?

2020-05-19 Thread Jim DeLaHunt
Hello, James: On 2020-05-18 12:54, James Cook wrote: Thanks, Jim, your responses are helpful. A couple of follow-up questions about doing cost-basis tracking outside of GnuCash (either for Jim or for the list): * When you do cost-basis tracking in a separate spreadsheet, do you have a way

[GNC] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?

2020-05-19 Thread Fran_3 via gnucash-user
To get a register, or part of a register out of GC and into  a spreadsheet you can... File > Export > etcThen import the csv file into the spreadsheetthen dink with it to delete or hide unwanted columns, etc... Or do it faster and with more control via... Open the registerClick Reports

Re: [GNC] How to "relaunch" Transaction Report Options Window

2020-05-19 Thread Derek Atkins
Of course! Just click the "Options" button in the toolbar. It kind of looks like a wrench. -derek On Tue, May 19, 2020 11:43 am, Fran_3 via gnucash-user wrote: > After I create a "Transaction Report" I often close the  "Transaction > Report Options Window"That is the window that allows me to

[GNC] How to "relaunch" Transaction Report Options Window

2020-05-19 Thread Fran_3 via gnucash-user
After I create a "Transaction Report" I often close the  "Transaction Report Options Window"That is the window that allows me to select the date range, choose what columns to display, etc.And often, after I close the Options Window... I wish I hadn't as I want to tweak something about the

Re: [GNC] How to "relaunch" Transaction Report Options Window

2020-05-19 Thread Fran_3 via gnucash-user
Dad Burn It... I should have seen that. Thanks! On Tuesday, May 19, 2020, 11:51:07 AM EDT, Derek Atkins wrote: Of course!  Just click the "Options" button in the toolbar. It kind of looks like a wrench. -derek On Tue, May 19, 2020 11:43 am, Fran_3 via gnucash-user wrote: > After I

Re: [GNC] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?

2020-05-19 Thread Adrien Monteleone
Thanks Fran! I had previously resorted to Account Report or Transaction Report with copy/paste, but I hadn’t noticed the Export > Active Register option. I wonder how new that is? I see it could be quite useful as it includes data that is otherwise hidden from the Register tab. (transaction

Re: [GNC] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?

2020-05-19 Thread Fran_3 via gnucash-user
Adrien, yes, File > Export> Transactionsallows you to choose a delimiter, select an account (like checking), and select a date rangewhile > Registerwill let you export an entire register... like the check register or whatever.There are also other options. I found this useful when trying to

[GNC] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?

2020-05-19 Thread flywire
A useful tip but an unfortunate post title because this exports the transactions. The Transaction Report can be exported as a html and opened directly in a spreadsheet (LibreCalc). GnuCash csv import not initially recognising anything in the csv file it just exported is also a surprise and

Re: [GNC] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?

2020-05-19 Thread David Cousens
The reason GnuCash does not associate accounts automatically with those in the file they have just been exported from is not really surprising at all. If I have exported records from GnuCash it is highly unlikely that I am going to reimport them into the same data file. It is far more likely that

Re: [GNC] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?

2020-05-19 Thread Fran_3 via gnucash-user
I'm not quite sure I understand the comment here but fyi I have had zero problems importing csv data into GnuCash checking and savings accounts from Wells Fargo... but there is a process I use. 1 - Download the transactions from your bank as a csv file.2 - Import them into a spreadsheet.3 -