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 -

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

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

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

[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