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 Total Output SGST Total Output IGST Total Input
CGST Total Input SGST Total Input IGST
these accounts are under Liabilities:GST:
I have attached a file named gstreport_demo02 .html with this mail
and you can see the tax tables also in the image file.
There are also two spreadsheets in github, one a final tax payable
calculator, another a list of tax tables and accounts.
The calculation of the final amount is complex, and would leave that to
the spreadsheet for now.
Regards,
Spandan Sinha
http://about.me/spandan
--
Using Opera's mail client: http://www.opera.com/mail/
Business Tax Report
>From 01-04-2017 To 31-03-2018
Input Tax accounts: Liabilities:GST:CGST:Input CGST,
Liabilities:GST:SGST:Input SGST, Liabilities:GST:CGST:Input CGST,
Liabilities:GST:SGST:Input SGST, Liabilities:GST:CGST:Input CGST,
Liabilities:GST:SGST:Input SGST, Liabilities:GST:CGST:Input CGST,
Liabilities:GST:SGST:Input SGST, Liabilities:GST:IGST:Input IGST,
Liabilities:GST:IGST:Input IGST, Liabilities:GST:IGST:Input IGST,
Liabilities:GST:IGST:Input IGST, Liabilities:GST:CGST:Input CGST,
Liabilities:GST:SGST:Input SGST
Output Tax accounts: Liabilities:GST:CGST:Output CGST,
Liabilities:GST:SGST:Output SGST, Liabilities:GST:CGST:Output CGST,
Liabilities:GST:SGST:Output SGST, Liabilities:GST:CGST:Output CGST,
Liabilities:GST:SGST:Output SGST, Liabilities:GST:CGST:Output CGST,
Liabilities:GST:SGST:Output SGST, Liabilities:GST:IGST:Output IGST,
Liabilities:GST:IGST:Output IGST, Liabilities:GST:IGST:Output IGST,
Liabilities:GST:IGST:Output IGST, Liabilities:GST:CGST:Output CGST,
Liabilities:GST:SGST:Output SGST
Date Num Description Memo/Notes Total Sales Net Sales Output CGST
Output SGST Output CGST Output SGST Output CGST Output SGST Output CGST
Output SGST Output IGST Output IGST Output IGST Output IGST Output CGST
Output SGST Total Purchases Net Purchases Input CGST Input SGST Input
CGST Input SGST Input CGST Input SGST Input CGST Input SGST Input IGST
Input IGST Input IGST Input IGST Input CGST Input SGST Bank Remittance
Tax Refund
[1]Accounts Receivable
08-05-2017 demo
14-05-2017 000001 demo [2]Rs. -1,450.00 [3]Rs. -1,450.00
[4]Rs. 1,450.00
19-05-2017 demo
10-07-2017 000002 demo [5]Rs. -1,200.00 [6]Rs. -1,200.00
[7]Rs. 1,200.00
19-07-2017 demo
25-07-2017 000003 demo [8]Rs. -600.00 [9]Rs. -600.00
[10]Rs. 600.00
08-08-2017 demo
Total For Accounts Receivable Rs. -3,250.00 Rs. -3,250.00
Rs. 3,250.00
[11]Cash
07-04-2017 Recharge
[12]Rs. 309.00 [13]Rs. 309.00
[14]Rs. -309.00
12-04-2017 CASH DEPOSIT
25-04-2017 CASH WITHDRAWAL
25-04-2017 CASH DEPOSIT
08-05-2017 CASH DEPOSIT
22-05-2017 CASH WITHDRAWAL
19-07-2017 Recharge
[15]Rs. 399.00 [16]Rs. 399.00
[17]Rs. -399.00
Total For Cash
Rs. 708.00 Rs. 708.00
Rs. -708.00
[18]Savings Account
16-04-2017 Ecommerce Purchase
18-04-2017 Ecommerce Purchase
18-04-2017 Ecommerce Purchase
20-04-2017 Ecommerce Refund
02-05-2017 Ecommerce Purchase
08-05-2017 Ecommerce Purchase
08-05-2017 Ecommerce Purchase
19-05-2017 CASH DEPOSIT
24-05-2017 Ecommerce Purchase
27-05-2017 ATM ANNUAL FEE
[19]Rs. 115.00 [20]Rs. 115.00
[21]Rs. -115.00
31-05-2017 CREDIT INTEREST [22]Rs. -14.00 [23]Rs. -14.00
[24]Rs. 14.00
22-06-2017 CASH DEPOSIT
31-07-2017 IRCTC Ticket
01-08-2017 Ecommerce Purchase
06-08-2017 IRCTC Ticket
09-08-2017 IRCTC Ticket
Total For Savings Account Rs. -14.00 Rs. -14.00
Rs. 115.00 Rs. 115.00
Rs. -101.00
__________________________________________________________________
Grand Total Rs. -3,264.00 Rs. -3,264.00
Rs. 823.00 Rs. 823.00
Rs. 2,441.00
References
1. gnc-register:acct-guid=88165f08ec0f3cf2a0d6821de4df4766
2. gnc-register:trans-guid=03a9aed673071fdddbc946d609fe7cd9
3. gnc-register:trans-guid=03a9aed673071fdddbc946d609fe7cd9
4. gnc-register:trans-guid=03a9aed673071fdddbc946d609fe7cd9
5. gnc-register:trans-guid=d605a110cfccf41374b70de9a4057119
6. gnc-register:trans-guid=d605a110cfccf41374b70de9a4057119
7. gnc-register:trans-guid=d605a110cfccf41374b70de9a4057119
8. gnc-register:trans-guid=731cdec9d52ef1fa1af166295c9cc7e2
9. gnc-register:trans-guid=731cdec9d52ef1fa1af166295c9cc7e2
10. gnc-register:trans-guid=731cdec9d52ef1fa1af166295c9cc7e2
11. gnc-register:acct-guid=c82e5ae7d9908ba7d18a0294cd130221
12. gnc-register:trans-guid=41c3851376e63bb2a740bbd4903e555a
13. gnc-register:trans-guid=41c3851376e63bb2a740bbd4903e555a
14. gnc-register:trans-guid=41c3851376e63bb2a740bbd4903e555a
15. gnc-register:trans-guid=f8ca7d7fd5a15c88e377359253b1c1ab
16. gnc-register:trans-guid=f8ca7d7fd5a15c88e377359253b1c1ab
17. gnc-register:trans-guid=f8ca7d7fd5a15c88e377359253b1c1ab
18. gnc-register:acct-guid=bd8e3e8f303e2261d4368eba7d036491
19. gnc-register:trans-guid=ac55f15b31248ebaa5650bf670dd3cee
20. gnc-register:trans-guid=ac55f15b31248ebaa5650bf670dd3cee
21. gnc-register:trans-guid=ac55f15b31248ebaa5650bf670dd3cee
22. gnc-register:trans-guid=481a26efeb2ff89698f19d59e3ec5563
23. gnc-register:trans-guid=481a26efeb2ff89698f19d59e3ec5563
24. gnc-register:trans-guid=481a26efeb2ff89698f19d59e3ec5563
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
