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
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.