New Report. Suitable for VAT/GST returns.

Wed Aug 2 11:39:34 EDT 2017

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 will count multiple currencies however this is likely to be
meaningless.
I think this is as far as this needs to go. Please let me know any bugs
prior to submitting for inclusion.
See sample output report attached, source in repository.
https://github.com/christopherlam/bas-report

On 31 July 2017 at 20:22, Christopher Lam <christopher.lck at gmail.com> wrote:

> 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 output. I feel this is the missing report for periodic
> (eg quarterly) tax reporting as required in some authorities e.g. UK and
> Australia. Formulas are modifiable with some effort.
>
> I hope this is useful to some. The learning curve was painful! Repo at
> https://github.com/christopherlam/bas-report
>
> C
>
-------------- next part --------------
  BAS/VAT Report (beta)

  From 01/07/2016 To 30/06/2017

   Input Tax accounts: (Assets:GST:GST on Purchases)

   Output Tax accounts: (Assets:GST:Reduced GST Sales Assets:GST:Standard
   GST Sales)

   Date Description Total Sales Net Sales Reduced GST Sales Standard GST
   Sales Total Purchases Net Purchases GST on Purchases Bank Remittance
   Tax Refund
   [1]Income
   01/01/2017 Income $1000 + $100GST [2]-$1,100.00 [3]-$1,000.00
   [4]-$100.00             [5]$1,100.00 [6]-$100.00
   02/01/2017 Income $1000 + $50GST Reduced GST rate [7]-$1,050.00
   [8]-$1,000.00 [9]-$50.00                 [10]$1,050.00 [11]-$50.00
   03/01/2017 Double Income $2x1000 + 2x$100 GST [12]-$2,200.00
   [13]-$2,000.00     [14]-$200.00             [15]$2,200.00 [16]-$200.00
   08/01/2017 Income $1000, but only $500 services was subject to 10%GST
   [17]-$1,050.00 [18]-$1,000.00     [19]-$50.00             [20]$1,050.00
   [21]-$50.00
   26/04/2017 Hybrid transaction - earn $4000 + $400 GST, spend $1000 +
   $100 GST. Net = $3300 into bank [22]-$4,400.00 [23]-$4,000.00
   [24]-$400.00 [25]$1,100.00 [26]$1,000.00 [27]$100.00 [28]$3,300.00
   [29]-$300.00
   Total For Income -$9,800.00 -$9,000.00 -$50.00 -$750.00 $1,100.00
   $1,000.00 $100.00 $8,700.00 -$700.00
   [30]Expenses
   05/02/2017 Purchase services for $2000 + $200
   [31]$2,200.00 [32]$2,000.00 [33]$200.00 [34]-$2,200.00 [35]$200.00
   08/02/2017 Purchase services for $1500, no GST charged
   [36]$1,500.00 [37]$1,500.00     [38]-$1,500.00
   Total For Expenses                 $3,700.00 $3,500.00 $200.00
   -$3,700.00 $200.00
   [39]Foreign Purchases
   10/02/2017 Purchase foreign services for $800 = £500, with $80 GST
   #ThisIsMeaningless.                 [40]$880.00 [41]$800.00 [42]$80.00
   [43]-$880.00 [44]$80.00
   15/04/2017 Purchase foreign services $1000 = £625, no tax involved
               [45]$1,000.00 [46]$1,000.00     [47]-$1,000.00
   Total For Foreign Purchases                 $1,880.00 $1,800.00 $80.00
   -$1,880.00 $80.00
     __________________________________________________________________

   Grand Total -$9,800.00 -$9,000.00 -$50.00 -$750.00 $6,680.00 $6,300.00
   $380.00 $3,120.00 -$420.00

References

   1. gnc-register:acct-guid=bf46a6f47ced28e6ecd75d42dce5a46d
   2. gnc-register:trans-guid=f70352cd2240ed2277da2c6961ba07bf
   3. gnc-register:trans-guid=f70352cd2240ed2277da2c6961ba07bf
   4. gnc-register:trans-guid=f70352cd2240ed2277da2c6961ba07bf
   5. gnc-register:trans-guid=f70352cd2240ed2277da2c6961ba07bf
   6. gnc-register:trans-guid=f70352cd2240ed2277da2c6961ba07bf
   7. gnc-register:trans-guid=f6e4d11f55f3547773ea00d155f68e46
   8. gnc-register:trans-guid=f6e4d11f55f3547773ea00d155f68e46
   9. gnc-register:trans-guid=f6e4d11f55f3547773ea00d155f68e46
  10. gnc-register:trans-guid=f6e4d11f55f3547773ea00d155f68e46
  11. gnc-register:trans-guid=f6e4d11f55f3547773ea00d155f68e46
  12. gnc-register:trans-guid=3153c297d88ceaf1b16671642bdb9ddf
  13. gnc-register:trans-guid=3153c297d88ceaf1b16671642bdb9ddf
  14. gnc-register:trans-guid=3153c297d88ceaf1b16671642bdb9ddf
  15. gnc-register:trans-guid=3153c297d88ceaf1b16671642bdb9ddf
  16. gnc-register:trans-guid=3153c297d88ceaf1b16671642bdb9ddf
  17. gnc-register:trans-guid=3fe2faa990ca84c3164cc82b97480dac
  18. gnc-register:trans-guid=3fe2faa990ca84c3164cc82b97480dac
  19. gnc-register:trans-guid=3fe2faa990ca84c3164cc82b97480dac
  20. gnc-register:trans-guid=3fe2faa990ca84c3164cc82b97480dac
  21. gnc-register:trans-guid=3fe2faa990ca84c3164cc82b97480dac
  22. gnc-register:trans-guid=7fc1a61ec5f6db9ee6352c672022007c
  23. gnc-register:trans-guid=7fc1a61ec5f6db9ee6352c672022007c
  24. gnc-register:trans-guid=7fc1a61ec5f6db9ee6352c672022007c
  25. gnc-register:trans-guid=7fc1a61ec5f6db9ee6352c672022007c
  26. gnc-register:trans-guid=7fc1a61ec5f6db9ee6352c672022007c
  27. gnc-register:trans-guid=7fc1a61ec5f6db9ee6352c672022007c
  28. gnc-register:trans-guid=7fc1a61ec5f6db9ee6352c672022007c
  29. gnc-register:trans-guid=7fc1a61ec5f6db9ee6352c672022007c
  30. gnc-register:acct-guid=84bf6de2a6e0dc44fbeae960a644dcb6
  31. gnc-register:trans-guid=105c39a63908b4f002791bb1c8457d2d
  32. gnc-register:trans-guid=105c39a63908b4f002791bb1c8457d2d
  33. gnc-register:trans-guid=105c39a63908b4f002791bb1c8457d2d
  34. gnc-register:trans-guid=105c39a63908b4f002791bb1c8457d2d
  35. gnc-register:trans-guid=105c39a63908b4f002791bb1c8457d2d
  36. gnc-register:trans-guid=1ea5114fa662a4661e0cce96a0770de1
  37. gnc-register:trans-guid=1ea5114fa662a4661e0cce96a0770de1
  38. gnc-register:trans-guid=1ea5114fa662a4661e0cce96a0770de1
  39. gnc-register:acct-guid=6f699d49e5af88ed9138a576ed4147d5
  40. gnc-register:trans-guid=959074dd6e5e59d1a4ae145abb884043
  41. gnc-register:trans-guid=959074dd6e5e59d1a4ae145abb884043
  42. gnc-register:trans-guid=959074dd6e5e59d1a4ae145abb884043
  43. gnc-register:trans-guid=959074dd6e5e59d1a4ae145abb884043
  44. gnc-register:trans-guid=959074dd6e5e59d1a4ae145abb884043
  45. gnc-register:trans-guid=04b7445ded7b9c8626510cc8dce8e97b
  46. gnc-register:trans-guid=04b7445ded7b9c8626510cc8dce8e97b
  47. gnc-register:trans-guid=04b7445ded7b9c8626510cc8dce8e97b