[GNC] VAT Reporting

Laurel Brunner lb at digitaldots.org
Fri Apr 26 06:34:58 EDT 2019


Dear Christopher,

Thanks so much for the prompt and comprehensive answer. I am struggling but getting there.

Much appreciated.

Happy Friday!

-Laurel.

> On 25 Apr 2019, at 17:03, Christopher Lam <christopher.lck at gmail.com> wrote:
> 
> Hi Laurel
> 
> Quarterly VAT reports are a breeze if your VAT collected/paid accounts are set up as liability/asset accounts. Use the "Income & GST Statement" report present in version 3.0 and above, select income & expense accounts and your VAT accounts.
> 
> You'll probably wish to select 'start of last quarter' to 'end of last quarter' in the date filter. Each transaction found is analysed; the sales&purchases, and the VAT parts are pulled out, and reported and summed - either into each account, or per amount type (sales/purchase/vat-sales/vat-purchases). To that matter, if you have EC sales you'll need separate EC VAT liability accounts which can be reported separately.
> 
> MTD is another issue altogether and there is no inbuilt solution. Unless someone creates a built-in MTD bridge, your best bet for now is to find a suitable HMRC VAT bridging software, and plug the amounts obtained above.
> 
> Good luck, ask any questions!
> 
> On Thu, 25 Apr 2019 at 15:44, Laurel Brunner <lb at digitaldots.org <mailto:lb at digitaldots.org>> wrote:
> Dear Helpful people,
> 
> How do I produce quarterly VAT reports from Gnucash?
> 
> I did it once before for the previous quarter and crosschecked it with a manual accounting of the VAT. And it worked, but I cannot remember how I did this, and cannot find any help online.
> 
> Also, have you done anything to support the UK government’s mandate that VAT returns are filed automatically: Making Tax Digital?
> 
> Many thanks.
> 
> -Laurel.
> 
> Laurel Brunner
> Digital Dots Limited
> The Clock Tower
> Southover
> Spring Lane
> Burwash
> East Sussex
> TN19 7JB
> UK
> 
> +44 (0)1435 883565
> +44 (0)7721 424449
> 
> Please check out our subscriber supported journal at http://www.spindrift.click <http://www.spindrift.click/> <http://www.spindrift.click/ <http://www.spindrift.click/>> and our environmental blogs at http://www.verdigrisproject.com <http://www.verdigrisproject.com/> <http://www.verdigrisproject.com/ <http://www.verdigrisproject.com/>>
> 
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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.

-Laurel.

Laurel Brunner
Digital Dots Limited
The Clock Tower
Southover
Spring Lane
Burwash
East Sussex
TN19 7JB
UK

+44 (0)1435 883565
+44 (0)7721 424449

Please check out our subscriber supported journal at http://www.spindrift.click and our environmental blogs at http://www.verdigrisproject.com




More information about the gnucash-user mailing list