[GNC] UK VAT and "Making Tax Digital"

Christopher Lam christopher.lck at gmail.com
Tue Feb 19 09:33:40 EST 2019


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.
>


More information about the gnucash-user mailing list