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 <m...@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
uk-vat-accounts.gnucash
Description: application/gnucash
_______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
