[GNC] Export Invoice to CSV

[Adrien Monteleone]

Not explicitly, but there are two methods that might get you something useful.

#1 - ‘Print’ the invoice (to the screen) then either copy/paste into a spreadsheet (Excel has issues at times, but Open/Libreoffice works well, as does Numbers) export it to html and then open with said spreadsheet. This will get you all the info in individual cells, but it will look like the printed version, and won’t be laid out like a CSV with rows as line items.

#2 - For posted invoices, make sure the option to ‘Accumulate Splits’ is *not* selected. This will make each invoice line item its own split in the affected registers. You can then export or run a Transaction Report (and then copy/paste) on the AR/AP or other relevant registers.

Regards,
Adrien

> On Dec 5, 2019 w49d339, at 10:28 AM, Axel Essbaum <axel at essbaum.com> wrote:
> 
> 
> Hello all,
> 
> I have been using GnuCash for 10 years, currently running GC 3.6 under macOS Mojave.
> 
> Is it possible to export an invoice (both unposted and posted) to a CSV file?  Or a way to copy-paste all of the lines and columns I see when looking at an invoice into Numbers / Excel is also fine.
> 
> Thanks all!
> 
> - Axel