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. _______________________________________________ gnucash-user mailing list gnucash-user@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.