Re: New Report. Suitable for VAT/GST returns.

2017-08-11 Thread Spandan Sinha
Chris, That definitely works! Thanks to you, I have my very first project on GitHub. the fork branch is available at https://github.com/spandan888/bas-report/tree/GST-india-edits I still need to create the 6 totals columns, which would come before the bank remittance column Total Output CGST

Re: New Report. Suitable for VAT/GST returns.

2017-08-10 Thread Spandan Sinha
Or could you tell me how to modify the .scm file so that tax table rates "Input 18", "Output 18", "Input 28", "Output 28" etc are also looked up by name? tried adding the names with the operator "and", but it just gives errors. Regards, Spandan Sinha http://about.me/spandan On Thu, 10 Aug

Re: New Report. Suitable for VAT/GST returns.

2017-08-10 Thread Spandan Sinha
We have mutiple slabs - 0%, 5%, 12%, 18% and 28%. So i have to make all these tax tables... excluding the 0%, there would be 4 tables for each slab - let's take 18% as an example - the slabs would be 9% INPUT, 9% OUTPUT, 18% INPUT and 18% OUTPUT. here the 18% is divided between the Centre

Re: New Report. Suitable for VAT/GST returns.

2017-08-09 Thread Christopher Lam
https://forum.manager.io/t/indian-gst-tax-code-tax-summary/10315 This seems to show exactly what my report produced :-) And the attached chart of accounts seems to fit the bill. Just make sure you assign the correct tax account per multisplit transaction. In my updated report you can merge all

Re: New Report. Suitable for VAT/GST returns.

2017-08-02 Thread Christopher Lam
Report is refined to show multiple tax accounts. This will be useful for e.g. UKVAT normal and EC sales. Tax column names are copied from the Account names. Terminology changed from VAT/GST to generic 'tax' and TaxTables must use 'Input'/'Output' names. Disabled zero-amount cells. Technically it

New Report. Suitable for VAT/GST returns.

2017-07-31 Thread Christopher Lam
Hi All After many years of trying to hack scheme, I've finally been able to create a custom report building on previous efforts by Doug Doughty. Report is accessible in Report > Business > BAS/VAT Report. I attach .scm file to be loaded into ~/.gnucash/config.user as usual, and an example report