New Report. Suitable for VAT/GST returns.

Christopher Lam christopher.lck at gmail.com
Mon Jul 31 08:22:34 EDT 2017 

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:Paid)

   Output Tax accounts: (Assets:GST:Collected)

   Date Description Total
   Sales
   BAS G1 GST on
   Sales
   BAS 1A/VAT 1 Sales
   without GST
   VAT 6 Total
   Purchases
   BAS G11 GST on
   Purchases
   BAS 1B/VAT 4 Purchases
   without GST
   VAT 7 Bank
   Remittance
   [1]Expenses
   05/02/2017 Purchase services for $2000 + $200 [2]$0.00 [3]$0.00
   [4]$0.00 [5]$2,200.00 [6]$200.00 [7]$2,000.00 [8]-$2,200.00
   08/02/2017 Purchase services for $1500, no GST charged [9]$0.00
   [10]$0.00 [11]$0.00 [12]$1,500.00 [13]$0.00 [14]$1,500.00
   [15]-$1,500.00
   26/04/2017 Hybrid. Earn $4000 + $400 GST, spend $1000 + $100 GST. Net =
   $3300 into bank [16]-$4,400.00 [17]-$400.00 [18]-$4,000.00
   [19]$1,100.00 [20]$100.00 [21]$1,000.00 [22]$3,300.00
   Total For Expenses -$4,400.00 -$400.00 -$4,000.00 $4,800.00 $300.00
   $4,500.00 -$400.00
   [23]Foreign Purchases
   10/02/2017 Foreign purchase. £500GBP = $800, with $80 GST #meaningless
   [24]$0.00 [25]$0.00 [26]$0.00 [27]$880.00 [28]$80.00 [29]$800.00
   [30]-$880.00
   15/04/2017 Foreign purchase. £625 = $1000, no tax involved [31]$0.00
   [32]$0.00 [33]$0.00 [34]$1,000.00 [35]$0.00 [36]$1,000.00
   [37]-$1,000.00
   Total For Foreign Purchases $0.00 $0.00 $0.00 $1,880.00 $80.00
   $1,800.00 -$1,880.00
   [38]Income
   01/01/2017 Income $1000 + $100GST [39]-$1,100.00 [40]-$100.00
   [41]-$1,000.00 [42]$0.00 [43]$0.00 [44]$0.00 [45]$1,100.00
   03/01/2017 Double Income $2x1000 + 2x$100 GST [46]-$2,200.00
   [47]-$200.00 [48]-$2,000.00 [49]$0.00 [50]$0.00 [51]$0.00 [52]$2,200.00
   08/01/2017 Income $1000, but only $300 attracted a tax of $30. $700 was
   not taxable. [53]-$1,030.00 [54]-$30.00 [55]-$1,000.00 [56]$0.00
   [57]$0.00 [58]$0.00 [59]$1,030.00
   Total For Income -$4,330.00 -$330.00 -$4,000.00 $0.00 $0.00 $0.00
   $4,330.00
     __________________________________________________________________

   Grand Total -$8,730.00 -$730.00 -$8,000.00 $6,680.00 $380.00 $6,300.00
   $2,050.00

References

   1. gnc-register:acct-guid=84bf6de2a6e0dc44fbeae960a644dcb6
   2. gnc-register:trans-guid=105c39a63908b4f002791bb1c8457d2d
   3. gnc-register:trans-guid=105c39a63908b4f002791bb1c8457d2d
   4. gnc-register:trans-guid=105c39a63908b4f002791bb1c8457d2d
   5. gnc-register:trans-guid=105c39a63908b4f002791bb1c8457d2d
   6. gnc-register:trans-guid=105c39a63908b4f002791bb1c8457d2d
   7. gnc-register:trans-guid=105c39a63908b4f002791bb1c8457d2d
   8. gnc-register:trans-guid=105c39a63908b4f002791bb1c8457d2d
   9. gnc-register:trans-guid=1ea5114fa662a4661e0cce96a0770de1
  10. gnc-register:trans-guid=1ea5114fa662a4661e0cce96a0770de1
  11. gnc-register:trans-guid=1ea5114fa662a4661e0cce96a0770de1
  12. gnc-register:trans-guid=1ea5114fa662a4661e0cce96a0770de1
  13. gnc-register:trans-guid=1ea5114fa662a4661e0cce96a0770de1
  14. gnc-register:trans-guid=1ea5114fa662a4661e0cce96a0770de1
  15. gnc-register:trans-guid=1ea5114fa662a4661e0cce96a0770de1
  16. gnc-register:trans-guid=7fc1a61ec5f6db9ee6352c672022007c
  17. gnc-register:trans-guid=7fc1a61ec5f6db9ee6352c672022007c
  18. gnc-register:trans-guid=7fc1a61ec5f6db9ee6352c672022007c
  19. gnc-register:trans-guid=7fc1a61ec5f6db9ee6352c672022007c
  20. gnc-register:trans-guid=7fc1a61ec5f6db9ee6352c672022007c
  21. gnc-register:trans-guid=7fc1a61ec5f6db9ee6352c672022007c
  22. gnc-register:trans-guid=7fc1a61ec5f6db9ee6352c672022007c
  23. gnc-register:acct-guid=6f699d49e5af88ed9138a576ed4147d5
  24. gnc-register:trans-guid=959074dd6e5e59d1a4ae145abb884043
  25. gnc-register:trans-guid=959074dd6e5e59d1a4ae145abb884043
  26. gnc-register:trans-guid=959074dd6e5e59d1a4ae145abb884043
  27. gnc-register:trans-guid=959074dd6e5e59d1a4ae145abb884043
  28. gnc-register:trans-guid=959074dd6e5e59d1a4ae145abb884043
  29. gnc-register:trans-guid=959074dd6e5e59d1a4ae145abb884043
  30. gnc-register:trans-guid=959074dd6e5e59d1a4ae145abb884043
  31. gnc-register:trans-guid=04b7445ded7b9c8626510cc8dce8e97b
  32. gnc-register:trans-guid=04b7445ded7b9c8626510cc8dce8e97b
  33. gnc-register:trans-guid=04b7445ded7b9c8626510cc8dce8e97b
  34. gnc-register:trans-guid=04b7445ded7b9c8626510cc8dce8e97b
  35. gnc-register:trans-guid=04b7445ded7b9c8626510cc8dce8e97b
  36. gnc-register:trans-guid=04b7445ded7b9c8626510cc8dce8e97b
  37. gnc-register:trans-guid=04b7445ded7b9c8626510cc8dce8e97b
  38. gnc-register:acct-guid=bf46a6f47ced28e6ecd75d42dce5a46d
  39. gnc-register:trans-guid=f70352cd2240ed2277da2c6961ba07bf
  40. gnc-register:trans-guid=f70352cd2240ed2277da2c6961ba07bf
  41. gnc-register:trans-guid=f70352cd2240ed2277da2c6961ba07bf
  42. gnc-register:trans-guid=f70352cd2240ed2277da2c6961ba07bf
  43. gnc-register:trans-guid=f70352cd2240ed2277da2c6961ba07bf
  44. gnc-register:trans-guid=f70352cd2240ed2277da2c6961ba07bf
  45. gnc-register:trans-guid=f70352cd2240ed2277da2c6961ba07bf
  46. gnc-register:trans-guid=3153c297d88ceaf1b16671642bdb9ddf
  47. gnc-register:trans-guid=3153c297d88ceaf1b16671642bdb9ddf
  48. gnc-register:trans-guid=3153c297d88ceaf1b16671642bdb9ddf
  49. gnc-register:trans-guid=3153c297d88ceaf1b16671642bdb9ddf
  50. gnc-register:trans-guid=3153c297d88ceaf1b16671642bdb9ddf
  51. gnc-register:trans-guid=3153c297d88ceaf1b16671642bdb9ddf
  52. gnc-register:trans-guid=3153c297d88ceaf1b16671642bdb9ddf
  53. gnc-register:trans-guid=3fe2faa990ca84c3164cc82b97480dac
  54. gnc-register:trans-guid=3fe2faa990ca84c3164cc82b97480dac
  55. gnc-register:trans-guid=3fe2faa990ca84c3164cc82b97480dac
  56. gnc-register:trans-guid=3fe2faa990ca84c3164cc82b97480dac
  57. gnc-register:trans-guid=3fe2faa990ca84c3164cc82b97480dac
  58. gnc-register:trans-guid=3fe2faa990ca84c3164cc82b97480dac
  59. gnc-register:trans-guid=3fe2faa990ca84c3164cc82b97480dac
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bas-vat-report.scm
Type: text/x-scheme
Size: 76802 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170731/bd62f450/attachment-0002.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.gnucash
Type: application/x-gnucash
Size: 3498 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170731/bd62f450/attachment-0003.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: config.user
Type: application/octet-stream
Size: 64 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170731/bd62f450/attachment-0001.obj>

More information about the gnucash-user mailing list