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

[Christopher Lam]

Ok checking understanding: Report options for tailored UK VAT report should
request following source accounts:

(1) Output VAT (on Sales) [Liability]
(2) Output VAT (Reverse EC Purchases) [Liability]
(3) Input VAT (on Purchases) [Asset]
(4) Sales Accounts [any type, default Income]
(5) Purchase Accounts [any type, default Expense]
(6) EC Goods Sales [any type, default Income]
(7) EC Goods Purchases [any type, default Expense]

Noting that (6) will be subset of (4), ditto (7) subset of (5).

Box 1 = (1)
Box 2 = (2)
Box 3 = (1) + (2)
Box 4 = (3)
Box 5 = (1) + (2) - (3)
Box 6 = (4)
Box 7 = (5)
Box 8 = (6)
Box 9 = (7)

It would seem the way forward would be a tailored report, requesting the 7
source accounts as above, and they will by default select accounts
according to the UK VAT template accounts. e.g. (1) preselected to accounts
with substrings "VAT" "Output" and "Sales", (2) to accounts with substrings
"VAT" "Output" "EC", etc.

Unfortunately the above strategy will not be easily generalisable to other
countries, let alone other EC VAT reports.

C

References:
-
https://www.tolley.co.uk/__data/assets/file/0007/27088/tg_guide_to_completing_a_uk_vat_return.pdf

On Tue, 7 May 2019 at 16:43, Maf. King <maf at chilwell.net> wrote:

> Hi Christopher.
>
> updated VAt accounts for your attention.
>
> I'd be happy to fill in the return with these numbers:
> Box1 220
> Box 2 40
> Box 3 260
> Box 4 109
> Box 5 151
> Box 6 1475
> Box 7 545
> box 8 100
> Box 9 200
>
> the GST report is close, subject to including the asset purchases.
>
> thanks,
> Maf.
>
>
>
> On Thursday, 2 May 2019 12:36:06 BST Christopher Lam wrote:
> > Are you referring to the Multicolumn report with multiple embedded
> reports?
> > This one would be very annoying to create CSV export from... each
> embedded
> > report exposes its html output only.
> >
> > The links I attached earlier (replacing transaction.scm and
> > income-gst-statement.scm) would enable CSV export, exposing the headers
> and
> > the grand-totals.
> >
> > Meanwhile I'm rather more interested in generating a proper solution :-)
> >
> > For UK VAT I'd think the more complex requirements here would warrant a
> > customised solution based on the existing VAT account structure, rather
> > than to try shoehorn hacks on the existing report.
> >
> > If you can create a sample datafile based on the CoA as suggested by
> > New-account wizard, I'll see about an appropriate report. Sample datafile
> > should have, appropriately described in each transaction description:
> >
> > - standard UK VAT sales/purchases with a split to
> > VAT-on-sales/VAT-on-purchases
> > - reduced VAT rate sales/purchases?
> > - EC VAT sales/purchases with a split to vat-reverse-EC accounts
> > - VAT-free sales/purchases with a zero-amount split to vat-free sales
> >   (i.e. asset:bank -100 GBP, expense:bizpurchases +100 GBP,
> > asset:vat-free-purchases 0 GBP)
> > - VAT to/from HMRC txns sent during periodic VAT returns
> > - sample refund txn for any of the above
> > - sample VAT&annual reports
> > - sample .csv output
> >
> > Thereafter I think the customised report would request:
> > - start/end dates (default to last quarter)
> > - VAT accounts (asset for vat-on-purchase and liability for vat-on-sales)
> > - sales accounts (usually INCOME accounts but can also be capital ASSET
> > accounts)
> > - purchase accounts (usually EXPENSE accounts but can also be capital
> > LIABILITY accounts [???])
> >
> > and will generate a multicolumn vat report similar to
> > income-gst-statement.scm, *and* will have CSV output.
> >
> > I've attached a starter sample-vat-accounts.gnucash but not sure how to
> > book various txns as above.
> >
> > C
> >
> > On Thu, 2 May 2019 at 09:55, Maf. King <maf at chilwell.net> wrote:
> > > On Wednesday, 1 May 2019 01:14:34 BST Christopher Lam wrote:
> > > > > Sorry for long answer, hope is informative. If you have a better
> > >
> > > strategy
> > >
> > > > > to offer, to account for your Asset:Bank -> Asset:CapitalAssets +
> > > > > VAT:Paid-on-Purchases use cases, I'm all ears! Meanwhile the short
> > > > > workaround above *may* be an acceptable solution for the current
> > > > > reports...
> > >
> > > Hi Christopher,
> > >
> > > been thinking a bit more about this.  it seems to me that I have got
> more
> > > or
> > > less the reports I need, I just need to automate the middle step of
> going
> > > from
> > > reports totals to Bridging spreadsheet (by CSV).
> > >
> > > Would it be possible to use a multi-column report, which contains each
> of
> > > my
> > > (maybe tweaked a bit) individual reports.
> > >
> > > the Multi column parent could grab the bottom line totals for each of
> the
> > > contained reports and stuff them into CSV?
> > >
> > > I have no idea if the Multi-column has hooks to grab totals from it's
> > > columns,
> > > or how hard that would be to implement.
> > >
> > > I imagine that the transaction report could be tweaked fairly easily
> > > export a
> > > bottom line total, if it doesn't do it already?
> > >
> > > just some thoughts.
> > > Maf.
>
>
> --
> Maf. King
> PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542
>
>
>