[GNC] Export values to Excel

[Christopher Lam]

Maf, you were privileged to have a bespoke report. I believe the latest
version is at
https://raw.githubusercontent.com/christopherlam/gnucash/maint-csv-export/gnucash/report/standard-reports/uk-vat-report.scm

The current plans will be to augment the income-gst-statement.scm to allow
presets for default/UK/Australia. See the screenshots
https://github.com/Gnucash/gnucash/pull/500#issuecomment-515655676 --
someone recommends changing the ECVAT/ECGOODS tags to EUVAT/EUGOODS.

Summary the uk-vat-report isn't merged in yet. The income-gst-statement can
be used to manually tally the periodic net/tax/gross amounts into separate
subtotals, and the current plans are to allow presets to export the
country-specific headers.

On Sun, 3 Nov 2019 at 12:24, Maf. King <maf at chilwell.net> wrote:

> On Sunday, 3 November 2019 12:00:02 GMT Bumbling Amateur via gnucash-user
> wrote:
> > In order to submit my VAT return to HMRC I need to populate an Excel
> > spreadsheet with some values (maximum of 9) from various accounts in
> > gnucash. The spreadsheet then submits the values to HMRC.
> >
> > For example one value I need to place in to an Excel spreadsheet can be
> > found in the gnucash  account called Output Vat on the date 31st October
> > 2019.
> >
> > Is there a way to do this?
> >
>
> Hi,
>
> yes, there is.  I did it last week.  You're basically talking about MTD
> (Making Tax Difficult) aren't you?
>
> Christopher Lam has recently added a report to produce a CSV file that can
> be
> imported into a spreadsheet and submitted to HMRC.
>
> I'm not certain which versions of GC include it, 3.7 should, I think....
> I'm
> using a development version of GC from the summer, which puts a "UK VAT
> Report" under the Income/Expense reports menu entry.  I'm supposed to
> write
> some documentation for it, but as yet haven't found the time.   If you
> find the
> report I'll help you get the numbers out of GC.
>
>
> Christopher: can you confirm the versions of GC which include the UK VAT
> report, please?
>
> best regards,
> Maf.
>
>
>