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