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

[Christopher Lam]

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.
>
>
>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: uk-vat-accounts.gnucash
Type: application/x-gnucash
Size: 41636 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-devel/attachments/20190502/9c4f550e/attachment-0001.bin>