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 Christopher Lam
Hi Frank 1. it comes from the original transaction.scm which has sat unchanged for years. 2. I figured these tax options mainly relate to Income tax reporting with numerous categories for various allowable deductions and are rather hard to set up for each country, and hard to keep up to date. I

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

2017-08-10 Thread Christopher Lam
A dirty hack, but you'll probably want to change (gncTaxTableGetEntries (gncTaxTableLookupByName (gnc-get-current-book) " Input")) to (append (gncTaxTableGetEntries (gncTaxTableLookupByName (gnc-get-current-book) "Input 18")) (gncTaxTableGetEntries (gncTaxTableLookupByName (gnc-get-current-book) "I

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

2017-08-10 Thread Frank H. Ellenberger
Hi, Christopher, Am 02.08.2017 um 17:39 schrieb Christopher Lam: > Terminology changed from VAT/GST to generic 'tax' and TaxTables must use > 'Input'/'Output' names. I liked the old terminology more. AFAIK in most countries the businesses or it's owners have to pay one or more income based taxes,

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 (C

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-09 Thread Spandan Sinha
Good to see your work on a report for GST returns. In India, we have just changed our Tax System to GST since 1 July 2017. We need to file monthly returns. Your test file and the reports show as expected. Thanks. I haven't yet quite figured out how to set up the accounts for GST. Could you point t

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 wi