Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Re: [GNC-dev] [GNC] UK VAT and "Making Tax Digital"

Christopher Lam
Feel free to replace the standard-report files with the following. Note
they must both be replaced simultaneously. Ideally v3.5, may work on recent
releases.

https://raw.githubusercontent.com/christopherlam/gnucash/maint-export-csv/gnucash/report/standard-reports/transaction.scm
https://raw.githubusercontent.com/christopherlam/gnucash/maint-export-csv/gnucash/report/standard-reports/income-gst-statement.scm


On Thu, 11 Apr 2019 at 03:48, Christopher Lam <[hidden email]>
wrote:

> 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, <[hidden email]>
> 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, [hidden email] <[hidden email]> 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: [hidden email]
>>>    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
>>>      [hidden email]
>>>      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
>>> [hidden email]
>>> 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-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel