Re: [GNC] Are accountants happy with CVS exports?

2023-01-05 Thread Michael or Penny Novack
I would expect that the .csv file could be imported in a "modern" spreadsheet program (Excel, localc, etc.) by the accountant. If there is a header row, the columns would be labeled. I expect most modern spreadsheet programs can re-order columns. No offense, but this sort of thing is what I

Re: [GNC] Are accountants happy with CVS exports?

2023-01-05 Thread Robert Heller
At Thu, 5 Jan 2023 11:52:04 -0500 stepbystepf...@comcast.net wrote: > > This discussion merits a comment. > > ALL .csv means is an indication that the data is in a file of "records" > each of which contains data fields separated by commas. It does not mean > ANYTHING about what the fields

Re: [GNC] Are accountants happy with CVS exports?

2023-01-05 Thread Michael or Penny Novack
This discussion merits a comment. ALL .csv means is an indication that the data is in a file of "records" each of which contains data fields separated by commas. It does not mean ANYTHING about what the fields mean (what sort of data is there) or what is the logical order of the fields.

Re: [GNC] Are accountants happy with CVS exports?

2023-01-05 Thread R. Victor Klassen
I do my own taxes (by hand). > On Jan 4, 2023, at 8:33 PM, Dr. David Kirkby > wrote: > > On Wed, 4 Jan 2023 at 22:29, R. Victor Klassen > wrote: > I generally export a transaction report with all (relevant) accounts > selected. I generally do a select-all from

Re: [GNC] Are accountants happy with CVS exports?

2023-01-04 Thread Dr. David Kirkby
On Wed, 4 Jan 2023 at 22:29, R. Victor Klassen wrote: > I generally export a transaction report with all (relevant) accounts > selected. I generally do a select-all from the open report window and then > paste it into OpenOffice/LibreOffice Calc. > > That I can sort on any key I like - normally

Re: [GNC] Are accountants happy with CVS exports?

2023-01-04 Thread R. Victor Klassen
I generally export a transaction report with all (relevant) accounts selected. I generally do a select-all from the open report window and then paste it into OpenOffice/LibreOffice Calc. That I can sort on any key I like - normally date within (sub)account, and run subtotals and look for

Re: [GNC] Are accountants happy with CVS exports?

2023-01-03 Thread Stephen M. Butler
On 1/3/23 17:43, Dr. David Kirkby wrote: multi-page Q his office provides. Do you not provide details of what the individual transactions to your accountant? If you do provide that, do you just use the unedited CSV files exported from GnuCash? Dave I do print off a detailed

Re: [GNC] Are accountants happy with CVS exports?

2023-01-03 Thread Dr. David Kirkby
On Mon, 2 Jan 2023 at 22:08, Stephen M. Butler wrote: > My CPA accepts the Balance Sheet and Profit/Loss Statement along with a > multi-page Q his office provides. Do you not provide details of what the individual transactions to your accountant? If you do provide that, do you just use the

Re: [GNC] Are accountants happy with CVS exports?

2023-01-02 Thread Stephen M. Butler
My CPA accepts the Balance Sheet and Profit/Loss Statement along with a multi-page Q his office provides. On 1/2/23 13:30, Dr. David Kirkby wrote: I asked my accountant about using GnuCash. He doesn’t know it, but said if can export a CSV file that will be okay. Previously I have used

Re: [GNC] Are accountants happy with CVS exports?

2023-01-02 Thread Maf. King
I run my business accounts out of GC into LibreOffice for pretty formatting and so on and thence to my accountant for his magic touch for companies house and HMRC. dead easy to get calc to open the HTML export from GC, or you can copy-paste IIRC. HTH, Maf. On Monday, 2 January 2023 21:30:04