• Home
  • /
  • Jcurve Support Articles
  • /
  • Journal Shows the Same Figures in Columns Net Amount and Tax Amount in the Business Activity Statement Total Sales Box G1 in a VAT/GST Report

Journal Shows the Same Figures in Columns Net Amount and Tax Amount in the Business Activity Statement Total Sales Box G1 in a VAT/GST Report

Written by
John David Dy
Published on
November 28, 2023 at 3:24:53 AM PST November 28, 2023 at 3:24:53 AM PSTth, November 28, 2023 at 3:24:53 AM PST

Scenario:

Reports>VAT/GST>Business Activity Statement> Drilldown Total Sales Box G1 > Journals show the same Figures in Columns Net Amount and Tax Amount


Here are few illustrations of the standard behavior when applying GST in Journal Entries.

#Journal Entry Scenario 1
Debit Bank = $1100 | Tax Rate = 0% | Tax Account = none
Credit Sales = $1000 | Tax Rate = 10% | Tax Account = GST Collected

Result:BAS Report Total Sales: Net Amount = $1000 | Tax Amount = $100

Note:No GST Tax Account selected in the Debit line so the system reads the journal line as non-taxable. Even if a Tax Code is set in the debit line, as long as there is no Tax Account, the system will disregard the amount.

===============

#Journal Entry Scenario 2
Debit Bank = $1000 | Tax Rate = 10% | Tax Account = GST Paid
Credit Sales = $1000 | Tax Rate = 10% | Tax Account = GST Collected

Result:BAS Report Total Sales: Net Amount = $1000 | Tax Amount = $100

Note:GST Paid Tax Account was used in the Debit line so the system reads the journal line as a Purchase transaction, thus, will not be reflected in the BAS Sales Report.

===============

#Journal Entry Scenario 3
Debit Bank = $1000 | Tax Rate = 10% | Tax Account = GST Collected
Credit Sales = $1000 | Tax Rate = 10% | Tax Account = GST Collected

Result:BAS Report Total Sales: Net Amount = $0 | Tax Amount = $0

Note:The debit and credit lines have the same GST Tax Account. The net amount of the transaction becomes zero as the debit and credit lines offset their values.

===============

#Journal Entry Scenario 4
Debit Bank = $1100 | Tax Rate = 0% | Tax Account = GST Collected
Credit Sales = $1000 | Tax Rate = 10% | Tax Account = GST Collected

Result:BAS Report Total Sales: Net Amount = $-100 | Tax Amount = $100

Note:The debit and credit lines have the same GST Tax Account so the system included them in Sales Taxation. The net amount -100 is the result of deducting the Debit amount from the Credit amount (Credit less Debit). Same goes for the Tax Amount which was Credit less Debit.

===============

Findings:Journal Entry #4 is most likely the scenario of the journal entries in the BAS Drilldown Report.

Solution:

Update the Journal Line according to the desired outcome as illustrated in the sample journals.