Re: [GNC] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?
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 - Delete the columns you don't want and arrange the remainder in any order you want.4 - For checking & savings I use 5 fields (columns) Date, Num, Description, Deposit, Withdrawal5 - Now save/export that from your spreadsheet as a csv file6 - Now open GC and click File > Import > Transactions from CSVthen follow the bouncing ball. I suggest you make a test copy of your GC file and experiment with this until you feel comfortable with the process. During the import process if you select your Assets > Current Assets > Checking Accountthe import feature of GC allows you to assign which expense account to assign each transaction to.After awhile it "learns" which one even though I always check each one. Frankly, for me, it works flawlessly as the developers have done one hell of a job building the application. The biggest problem I have with GC is me. I don't do it every day and often stumble around remembering how I did it.I'm also prone to rushing and shooting myself in the foot.Cockpit error is my number one enemy. Finally, the original post was simply to let folks know that you can just copy a Transaction Report from the GC screen and then paste it into Google Sheets. Now need to export. Plus the Transaction Report gives you the option of selecting which columns you want... and more. An application for this is when you are looking for some error between banking and say the GC cecking transactions. For instance for checking I have copied 3 years of transactions from the Transaction Report and pasted it into a Google Sheet tab.Then imported csv banking transactions into another tab in the spreadsheet.Then copied the date & amount of each into a 3rd tab.Then sorted each by amount, date.Then with a column in the middle enter the formula...=if(Bank Amount <> GC Amount, "X",)This will place an X anywhere the two don't agree so any mismatching transaction will jump out at you. Sorry, too much info here but maybe it will help somebody... and I'm sure there is an easier way but, worked for me :-) Fran On Tuesday, May 19, 2020, 6:56:19 PM EDT, flywire wrote: 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 disappointment. ___ 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. ___ 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] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?
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 i will import them into another data file which may not necessarily and more than likely will not have the same account structure. The second reason is that the CSV importer deals with the import of data from many more sources than GnuCash itself and it has to have the flexibility to cope with much more than simply importing its own export data. The current version is a considerable improvemnt over the past CSV import process. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?
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 disappointment. ___ 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] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?
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 understand to organize fields for import into GC... but later learned that the import feature will let you tell it what field is what...In that regard I normally import fieldsDate, Num, Description, Deposits, WithdrawalsRemembering that GC wants both deposits and withdrawals to be positive numbers. But the ability to cut and paste from a report is awsome and so simple. FYI, Google Sheets, the free Google spreadsheet, works perfectly either importing GC comma delimited data or bank exported csv files... and when copying a GC report and pasting directly into a spreadsheet. Fran On Tuesday, May 19, 2020, 2:15:37 PM EDT, Adrien Monteleone wrote: 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 ID, Currency, Rate/Price, Reconcile Date) While most people might not have a use for them, I could see they might come in hand when trying to solve a problem —say with an import. I also like that you get a column both with and without currency symbols. (some spreadsheets don’t play nice with the symbols, so you have to remove them. This saves a step) I don’t use Excel, but some years ago, I recall a few threads where there were quirks. It seemed OOo or LO (and I suppose Google Sheets) were better suited, or at least didn’t require extra hoops to get to the end result. I can’t remember what Excel was choking on though. Regards, Adrien > On May 19, 2020 w21d140, at 11:55 AM, Fran_3 via gnucash-user > wrote: > > 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 Transaction ReportEdit Report Options > And then just highlight the transactions with the mouse and paste them right > into a Google Sheet ! > Much quicker (to me) and you have more control in that you can select the > columns you want and more. > I wonder if this works in Excel too? ___ 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. ___ 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] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?
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 ID, Currency, Rate/Price, Reconcile Date) While most people might not have a use for them, I could see they might come in hand when trying to solve a problem —say with an import. I also like that you get a column both with and without currency symbols. (some spreadsheets don’t play nice with the symbols, so you have to remove them. This saves a step) I don’t use Excel, but some years ago, I recall a few threads where there were quirks. It seemed OOo or LO (and I suppose Google Sheets) were better suited, or at least didn’t require extra hoops to get to the end result. I can’t remember what Excel was choking on though. Regards, Adrien > On May 19, 2020 w21d140, at 11:55 AM, Fran_3 via gnucash-user > wrote: > > 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 Transaction ReportEdit Report Options > And then just highlight the transactions with the mouse and paste them right > into a Google Sheet ! > Much quicker (to me) and you have more control in that you can select the > columns you want and more. > I wonder if this works in Excel too? ___ 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] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?
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 Transaction ReportEdit Report Options And then just highlight the transactions with the mouse and paste them right into a Google Sheet ! Much quicker (to me) and you have more control in that you can select the columns you want and more. I wonder if this works in Excel too? ___ 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.