The GST session Worksheet tab includes a range of fields that form your GST calculation sheet. Each field is labelled with codes equivalent to those that appear on your Australian Taxation Office (ATO) issued BAS statement, as displayed below. Most of the Worksheet tab values are calculated from the transactions you have selected to include in a GST session, and are based on the tax codes allocated in every transaction in Jim2. Therefore, all tax code allocations must be selected with careful consideration.
For more information on the tax codes used in Jim2, see Setup > Tax Codes.
 |
Always take a few minutes to review the figures in your worksheet before completing your BAS. Do they look correct? Are there any values in fields where there should not be values, such as G2 when you do not have any export sales? |
From the Worksheet tab, you can print a hard copy of the GST Calculation Worksheet report and transfer your figures to your BAS.
Jim2 can calculate GST on a monthly or quarterly basis using either the cash or accrual method. For more information on how to configure the GST calculation basis, see the section on GST Sessions and the BAS. Your calculation basis is normally provided to you by the ATO.
You or your company accountant will have registered your business with the ATO, advising them of your business activity. You will have the option of lodging the BAS as a written document or as an electronic form. Your BAS layout will differ depending on which taxes are applicable to your registration, and when they are actually payable.
For businesses that lodge a monthly Instalment Activity Statement (IAS) for PAYG withholding on wages, please see the section on IAS Monthly PAYG Lodgement.
GST Amounts You Owe the Australian Taxation Office from Sales
Field |
Description |
Source |
G1 |
Total sales (invoiced) and any additional income. |
Jim2 |
G2 |
Any of those sales that were export sales (no GST). |
Jim2 |
G3 |
Any of those sales that were other GST-free sales. |
Jim2 |
G4 |
Any of those sales that were input taxed sales (no GST). |
Jim2 |
G5 |
Total of sales that did not include GST (G2+G3+G4). |
Jim2 |
G6 |
Total of sales subject to GST (G1–G5). |
Jim2 |
G7 |
This is for manually calculated adjustments as advised by your accountant. |
Other |
G8 |
Total sales subject to GST after adjustments (G6 + G7). |
Jim2 |
G9/1A |
GST on sales (G8 divided by eleven). |
Jim2 |
The amounts for G1, G2, G3, G4, G5, G6 and G8 are automatically calculated in the Worksheet tab of your GST session. You can view the details of these values in the Sales tab and By Tax tab of the GST session.
GST Amounts the Australian Taxation Office Owes You from Purchases
Field |
Description |
Source |
G10 |
Capital purchases (including GST). |
Jim2 |
G11 |
Non-capital purchases (from Jim2 purchase orders). |
Jim2 |
G12 |
Total of all GST-inclusive purchases (G10+G11). |
Jim2 |
G13 |
Purchases for making input taxed sales. |
Jim2 |
G14 |
GST-free purchases. |
Jim2 |
G15 |
Estimated purchases for private use, or purchases that are not income tax deductible. |
Jim2 |
G16 |
Total of all purchases that do not include GST (G13+G14+G15). |
Jim2 |
G17 |
Total purchases subject to GST (G12-G16). |
Jim2 |
G18 |
This is for manually calculated adjustments as advised by your accountant. |
Other |
G19 |
Total purchases subject to GST after adjustments (G17+G18). |
Jim2 |
G20/1B |
GST on purchases (G19 divided by eleven). |
Jim2 |
The amounts for G10, G11, G12, G13, G14, G15, G16, G17 and G19 are automatically calculated in the Worksheet tab of your GST session. You can view the details of these values in the Purchases tab and By Tax tab of the GST Session.
PAYG Tax Withheld (from Wages) Amounts You Owe the ATO
Field |
Description |
Source |
W1 |
The total of all salaries and wages recorded (gross amount). |
Jim2 |
W2 |
The total of all PAYG tax withheld (from W1). |
Jim2 |
W3 |
Other amounts withheld (excluding any amount shown at W2 or W4). |
Other |
W4 |
Any GST withheld where no ABN is quoted by a supplier. |
Jim2 |
W5/4 |
The total amount of PAYG withheld (W2+W4 +W3). |
Jim2 |
The amounts for W1 and W2 are automatically calculated in the Worksheet tab of your GST session. You can view the details of these values in the PAYG tab and By Tax tab of the GST session.
The following instructions are for accrual reporting only.
PAYG Income Tax Instalment
There are several options for paying your PAYG income tax instalment. You either pay an instalment amount (written at T7 on your BAS) issued by the ATO or you can calculate your PAYG instalment using income times rate (written at T1/T2/T11).
You need to calculate this amount manually, based on the income for the period which is reported on the profit & loss report x % rate advised by the ATO.
▪The T1 value is derived from the total reportable income eligible for instalment tax.
▪T2 is an ATO issued rate expressed as a percentage (can be varied if required).
▪T11 is your calculated instalment (income x % rate).
Jim2 is able to calculate specific taxes for you, depending on the activity your business is involved in. The BAS frequency, tax types and tax codes you have selected in the Jim2 Options and Setups are used to create the totals you will enter in specific fields on your BAS form. Simplified BAS summary reports and detailed BAS support documents are available in Jim2 but are only suited to the Accrual method.
 |
Reportable amounts on your BAS, such as PAYG instalment income tax, fringe benefits tax, and wine equalisation tax, must be calculated on a manual basis. |
The following fields in the Summary section of the Worksheet tab are editable, allowing you to enter your manually calculated liabilities so they are included in the calculated totals in 8A and 8B:
▪Field 5A – PAYG income tax instalment.
▪Field 6A – FBT instalment.
▪Field 7 – Deferred company/fund instalment.
The GST session worksheet summary is effectively telling you two things: amounts you owe the ATO, and amounts the ATO owes you.
Amounts You Owe the ATO, Made up of:
Field |
Description |
Source |
1A: |
Any GST you have collected via sales (invoices) or income. |
Jim2 |
1C: |
Any wine equalisation tax you have collected via sales. |
Other |
1E: |
Any luxury car tax you have collected via sales. |
Jim2 |
4: |
Any PAYG tax withheld (W2+W4+W3). |
Jim2 |
5A: |
Any PAYG income tax instalment that is due (either T7 or T11). |
Other |
6A: |
Any FBT instalment that is due (F3). |
Other |
7: |
Any deferred company/fund instalment that is due. |
Other |
7A: |
Any GST deferred on imported goods. |
Jim2 |
8A: |
The total of all of the above. |
Jim2 |
Amounts the Australian Taxation Office Owe You, Made up of:
Field |
Description |
Source |
1B: |
Any GST you have paid via purchases. |
Jim2 |
1D: |
Any refundable wine equalisation tax. |
Other |
1F: |
Any refundable luxury car tax. |
Jim2 |
5B: |
Any credit PAYG income tax instalment variation. |
Other |
6B: |
Any credit from FBT instalment variation. |
Other |
8B: |
The total of all of the above. |
Jim2 |
9: |
Payment or refund. |
Jim2 |
If the amount at 8A is more than 8B, then this amount is payable to the ATO.
If the amount at 8A is less than 8B, then this amount is refundable to you (or offset against other tax debt that you may have).
If you have any further questions or require any clarification regarding the GST and the BAS report please contact your accountant or the ATO.
|
The GST reports found under Management > Reports pre-date the introduction of GST sessions and were designed for the Accrual method only. All transactions are automatically included to calculate your liability, and these reports do not reconcile transactions. These legacy GST reports have been renamed as reportname(old) and are not to be used. Happen advises you to use GST sessions to calculate your GST liability. |
Further information: