[GNC] UK VAT and "Making Tax Digital"

[Christopher Lam]

3.5 is out and I promised to offer CSV output. Has anyone confirmed the
exact CSV (or JSON)  format desired by their *bridging* software?

Please be aware that direct communication to HMRC is best done by bridging
software outside gnucash. It'll be a nice project for anyone to do in
python or similar.

On Tue., 19 Feb. 2019, 22:33 Christopher Lam, <christopher.lck at gmail.com>
wrote:

> To all interested in beta-testing CSV export, for now I think it's safest
> to export CSV in carefully selected reports, because all reports do tables
> differently.
>
> After version 3.5 is out of the door (in a couple months) I'll provide
> some customized transaction.scm and income-gst-statement.scm which can
> export CSV, and could be finalised for 3.6 due mid-year. The current
> iteration of these reports depend heavily upon the supporting files which
> are undergoing heavy maintenance, and may not work for those using 3.4
> releases. Alternatively anyone comfortable buildling from maint can beta
> test now :)
>
> C
>
> On Tue, 19 Feb 2019 at 19:42, refdoc at gmx.net <refdoc at gmx.net> wrote:
>
>>    I am struggling to.understand at the moment the reporting language,
>>    which I understand is a lisp variant. But what I can see from reading
>>    the transaction report's source files, is that all logic is very nicely
>>    compartmentalized, which makes me wonder if a more general solution
>>    would not be to have parallel to the html render output csv output for
>>    all reports which rely upon it. This would then allow a much wider use
>>    and remove the accusation by another member here on the list that I (or
>>    others) want something UK specific.
>>    This would also improve in general interoperability on all kinds of
>>    levels.
>>    Peter
>>    Sent from my mobile. Please forgive shortness, typos and weird
>>    autocorrects.
>>
>>    -------- Original Message --------
>>    Subject: Re: [GNC] UK VAT and "Making Tax Digital"
>>    From: "Maf. King"
>>    To: gnucash-user at gnucash.org
>>    CC:
>>
>>      On Sunday, 17 February 2019 12:23:39 GMT Maf. King wrote:
>>      > On Sunday, 17 February 2019 11:57:58 GMT Christopher Lam wrote:
>>      > > I can amend Income-GST-statement, which is tailor-made for
>>      periodic
>>      > > GST/VAT returns, to output CSV or XML. But so far there's little
>>      demand
>>      > > nor willing beta-testers.
>>      >
>>      > *Raises Hand in the Air* I'll volunteer to test. With the caveat
>>      that my
>>      > VAT is not normally very complicated.
>>      >
>>      > The GST report I ran earlier this morning spat out numbers which
>>      matched my
>>      > last quarter's return (generated from customised options to
>>      transaction
>>      > reports), which is a good start!
>>      >
>>      > Maf.
>>      Further to this, I've found and downloaded a bridging spreadsheet
>>      for
>>      LibreOffice (for free, without even having to register an email
>>      address) from
>>      https://filemyvatreturn.co.uk/download/ (seems to be a "trading
>>      name" for CHM
>>      software, https://www.chm-software.co.uk/companies where you do have
>>      to
>>      register to download...)
>>      No endorsement or recommendation to use them, I'm not even a
>>      satisfied user
>>      (yet). Seems that it will cost £7.50 for each VAT return to be
>>      filed. But
>>      gotta make a start somewhere. If anyone else knows of other options,
>>      please
>>      do chime into this thread.
>>      According to their help file, all you need is a spreadsheet (or
>>      sheets) that
>>      contain the 7 relevant box totals that you link into the downloaded
>>      sheet. It
>>      may be possible to tweak it to (automagically) fill from a CSV file,
>>      I'll need
>>      to look at that next month when I have some more time.
>>      I will note that depending on how orderly the exit from the EU ends
>>      up, the 7
>>      box totals required may change - but we're not going to know how
>>      that
>>      particular cookie is going to crumble yet...
>>      Christopher: what sort of timescale do you think you'll need to
>>      tweak the GST
>>      report etc to give CSV out? There is a clear workflow to export from
>>      GC to
>>      Calc and munge the totals there so it isn't especially critical,
>>      despite the
>>      first digital filings being due early August. But it seems to me
>>      that if a new
>>      workflow can be figured out in time, why tweak the old way first
>>      then change a
>>      quarter or two later?
>>      I'm pretty busy the rest of this month, but will do more digging
>>      into this in
>>      March.
>>      Maf.
>>      _______________________________________________
>>      gnucash-user mailing list
>>      gnucash-user at 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 at 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.
>>
>