[GNC-dev] [GNC] UK VAT and "Making Tax Digital"
Christopher Lam
christopher.lck at gmail.com
Thu Apr 11 10:08:53 EDT 2019
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 <christopher.lck at gmail.com>
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, <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.
>>>
>>
More information about the gnucash-devel
mailing list