Canada GST Report: GST34 Worksheet

Note:

This topic is for NetSuite accounts that use the Country Tax Report page to generate the GST34 Worksheet. If you are using the Tax Reports (International) page, see GST34 Worksheet - Canada.

The following tables describe the reported values on the Canada GST report. It also shows the Search Type, Transaction Types, Tax Codes, Tax Transaction Types, Tax Item Types, and Tax Reporting Category filters. The Canada Sales Tax Reports SuiteApp uses the filters to get the values for each of the boxes on the report. These filters are automatically set up but can be modified.

Box	Report Label	Amount	Search Type	Transaction Types	Tax Codes	Tax Transaction Types	Tax Item Types	Tax Reporting Category
101	Enter your total sales and other revenue. Do not include provincial sales tax, GST or HST. If you are using the Quick Method of accounting, include the GST or HST.	Net amount	Sales	Cash Sale Credit Memo Invoice	CA_GST CA_HST CA_PE_HST CA_ON_HST CA_NS_HST CA_NL_HST CA_NB_HST CA_ZR CA_NB_ZR CA_NL_ZR CA_NS_ZR CA_NT_ZR CA_NU_ZR CA_ON_ZR CA_PE_ZR	Domestic Sales	Goods Services	–
			Sales	Cash Sale Credit Memo Invoice	CA_ZR CA_NB_ZR CA_NL_ZR CA_NU_ZR CA_NT_ZR CA_NS_ZR CA_PE_ZR CA_ON_ZR	Exports	Goods Services	–
			Billable Expenses	Cash Sale Invoice	CA_GST CA_HST CA_NB_HST CA_NB_ZR CA_NL_HST CA_NL_ZR CA_NS_HST CA_NS_ZR CA_NT_ZR CA_NU_ZR CA_ON_HST CA_ON_ZR CA_PE_HST CA_PE_ZR CA_ZR	Domestic Sales	–	–
			Billable Expenses	Cash Sale Invoice	CA_NB_ZR CA_NL_ZR CA_NS_ZR CA_NT_ZR CA_NU_ZR CA_ON_ZR CA_PE_ZR CA_ZR	Exports	–	–
103	Enter the total of all GST and HST amounts that you collected or that became collectible by you in the reporting period.	Tax amount	Sales	Cash Sale Credit Memo Invoice	CA_GST CA_HST CA_PE_HST CA_ON_HST CA_NS_HST CA_NL_HST CA_NB_HST	Domestic Sales	Goods Services	–
103		Tax amount	Billable Expenses	Cash Sale Invoice	CA_GST CA_HST CA_NB_HST CA_NL_HST CA_NS_HST CA_ON_HST CA_PE_HST	Domestic Sales	–	–
104	Enter the total amount of adjustments to be added to the net tax for the reporting period (for example, the GST/HST obtained from the recovery of a bad debt).	(Enter amount)
105	Total GST/HST and adjustments for period (add lines 103 and 104)	(Autogenerated)
106	Enter the GST/HST you paid or that is payable by you on qualifying expenses (input tax credits - ITCs) for the current period and any eligible unclaimed ITCs from a previous period.	Tax amount	Purchases	Bill Bill Credit	CA_RC	Imports	Goods Services	–
106		Tax amount	Expenses	Expense Report Bill Bill Credit	CA_NB_HST CA_NL_HST CA_NS_HST CA_ON_HST CA_PE_HST	Domestic Sales	–	–
107	Enter the total amount of adjustments to be deducted when determining the net tax for the reporting period (for example, the GST/HST included in a bad debt).	(Autogenerated)
108	Total ITCs and adjustments (add lines 106 and 107)	(Autogenerated)
109	Net tax (subtract line 108 from line 105)	(Autogenerated)
110	Enter any installment and other annual filer payments you made for the reporting period. If the due date of your return is June 15, see the instructions.	(Data of the selected account)
111	Enter the total amount of the GST/HST rebates, only if the rebate form indicates that you can claim the amount on this line. For filing, information, see instructions.	(Enter amount)
112	Total other credits (add lines 110 and 111)	(Autogenerated)
113A	Balance (subtract line 112 from line 109)	(Autogenerated)
205	Enter the total amount of the GST/HST due on the acquisition of taxable real property.	Tax amount	Purchases	Bill Bill Credit	CA_GST CA_HST	Domestic Purchases	Goods	CA - Real Property
405	Enter the total amount of other GST/HST to be self-assessed.	Tax amount	Purchases	Bill Bill Credit	CA_RC	Imports	Goods Services	–
113B	Total other debits (add lines 205 and 405)	(Autogenerated)
113C	Balance (add lines 113 A and 113 B)	(Autogenerated)
114	Refund claimed	(Autogenerated)
115	Payment enclosed	(Autogenerated)

To enter amounts on boxes 104, 107, and 111, see Making Adjustments on a Country Tax Report.

The value reported on box 110 is from the data of the selected account upon Canada tax return setup. To select an account, see Customizing Localized Tax Returns.

To view the General Ledger, click the View General Ledger button.

To view the Canada GST report in detail, see Viewing a Generated Country Tax Report.

To learn more about the Canada Sales Tax Reports SuiteApp providing the Canada GST34 Worksheet report, see Canada Sales Tax Reports.

Related Topics