Overview

Review all the GST transactions for a period (see GST information)

...

Use the BAS Statement tab to calculate the amounts to enter on your BAS statement.

Layout of the form

Across the top is the period that applies to the displayed totals as well as the journal lists, the Action button to recalculate the totals after the period has changed and the 'List Journals for...' buttons to display diagnostic lists to identify potential errors in journals.

In the top right is the 'Details total'. This shows the total accumulation of the journals listed on the 'Journals List (Details)' tab. If the list is of taxable transactions, e.g. Taxable Sales, then the total is the sum of the Amount column plus the Tax column. If the list is of a tax amount, e.g. GST on Sales, then the total is the sum of the Tax column only.

On the left side of the form are the totals required on the BAS Statement. The figures on the same line and to the right of each of these totals are the sub totals that theses totals are made up of. The other figures are for information.

On the right side of the form are the totals of sales under warranty. These totals are hidden if no warranty account is specified (see Accounts under Data selection below).

Listing the journals that are included in a given total

 Many of the figures have an asterisk button to their right. Clicking this button will produce a list of the journals included in this total.

Period

This specifies the date range that applies to all of the totals and journal lists on the form, including the diagnostic lists under the 'List Journals for ...' button.

BAS Reporting Period

The BAS Reporting Period must be specified for the host company (Administration Admin menu, Your Host Company, 'G/L and BAS' tab, General tab, Extended Attributes, GST/BAS) before you can select a period on the GST Explorer. Choose from Monthly, Two Monthly, Quarterly, Four Monthly, Six Monthly or Annually.

The last month of the financial year can be specified in a Symbols Config (Administration Admin menu, Configurationconfig, Symbols Config) with a key of financialYearEndMonth. The value should be the month number, e.g. 1 for January, 12 for December. If not specified it defaults to 6 (June).

...

The selected period name is displayed in the box to the right of the Period label. The date range of the selected period is shown below the namebutton.

Click the 'Select Period' button to choose a different period. The periods displayed will be:

• The Current period, if it is not selected
• The Last period, if it is not selected
• The period before the selected period (Previous)
• The period after the selected period (Next)
• If a date is entered in the box to the right of the 'Select Period' between the period name and the Action button then the period that includes the entered date
• All locked periods
  • If there are more than 12 locked periods and the BAS Reporting Period is not Annually then the locked periods will be grouped by financial year

...

• If the selected period is not locked then 'Calculate Period'
• If the selected period is not locked, it ends before today and either there are no locked periods or the previous period is locked then 'Calculate and Lock Period'
• If the selected period is locked then 'Display Period'
• If the selected period is locked and the next period is not locked then 'Unlock Period'
• If a period has been calculated or displayed then Print Displayed Totals to produce a PDF report showing the totals in the same format as the form.

Locked Periods

Once a period has been locked only the next period after the last locked period can be locked and only the last locked period can be unlocked.

...

The account specified on a journal line is used in the selection of journals or journal lines to be included in a number of totals. The accounts referred to are defined in the GL Control Configuration form (Admin menu, Finance, GL Control Accounts).The accounts used are:

1. GL tab:
   1. Trade Debtors
   2. Trade Creditors
   3. GST Paid
   4. GST Collected
   5. Withholding Tax
   Sales tab:
   2. Default Income
   3. Warranty

Tax Amount

The tax amount in a journal does not have a sign. The tax will be is considered to have the same sign as the total of the journal line on which it appears.

Calculated Totals

Taxable Sales

This total is not required on the BAS statement but is included for information. It is used to calculate G1 Total Sales and 1A GST on Sales. It is the total of the Default Income, Other Sales and Warranty figures on the same line and to the right of this total.

Default Income

The total of (credit - debit) + or - tax for all journal lines with the Default Income account and a GST tax type in journals with a line for the Tax Collected account.

Other Sales

The total of (credit - debit) + or - tax for all journal lines with neither the Default Income account nor the Warranty account and a GST tax type in journals with a line for the Tax Collected account.

Warranty

The total of (credit - debit) + or - tax for all journal lines with the Warranty account and a GST tax type in journals with a line for the Tax Collected account.

G1 Total Sales

The total of Taxable Sales, G2 Export Sales and G3 GST Free Sales.

G2 Export Sales

The total of the Default Income and Warranty figures on the same line and to the right of this total.

Default Income

...

Listing the journals that are included in a given total

 Many of the totals have an exclamation mark (!) button to their right. Clicking this button will produce a list of the journals included in this total. The list is displayed on the Journal List (Details) tab.

G1 Total sales (incl GST)

This total is calculated as G2 + G3 + G6.

G2 Export sales

The total of (credit - debit) for all journal lines with the Default Income account and an EXP tax type in journals that include a line to Trade Debtors.

Warranty

G3 Other GST free sales

The total of (credit - debit) for all journal lines with the Warranty account and an EXP tax type.

G3 GST Free Sales

The total of the Default Income and Warranty figures on the same line and to the right of this total.

Default Income

The total of (credit - debit) for all journal lines with the Default Income account and a FRE tax type.

Warranty

a FRE tax type in journals that include a line to Trade Debtors.

G5

This total is calculated as G2 + G3.

G6 Total sales subject to GST

The total of (credit - debit) +/- tax for all journal lines with the Warranty account and a FRE tax typeGST tax type in journals that include a line to Trade Debtors.

1A GST on

...

sales

The total of the Accumulated Default Income, Other Sales and Warranty figures on the same line and to the right of this total.

Default Income (Accumulated)

The total of the tax amount for all journal lines with the Default Income account and a GST tax type in journals with a line for the Tax Collected account.

Other Sales (Accumulated)

The total of the tax amount for all journal lines with neither the Default Income account nor the Warranty account and a GST tax type in journals with a line for the Tax Collected account.

Warranty (Accumulated)

The total of the tax amount for all journal lines with the Warranty account and a GST tax type in journals with a line for the Tax Collected account.

Default Income (Calculated)

Calculated as tax on Taxable Sales, Default Income

Other Sales (Calculated)

Calculated as tax on Taxable Sales, Other Sales

Warranty (Calculated)

Calculated as tax on Taxable Sales, Warranty

GST Collected

The This total is calculated as G6 / 11.

GST accumulated / collected

The total in the first column is the total of the tax amounts in all journal lines with a GST tax type in journals that include a line to Trade Debtors.

The total in the second column is the total of (credit - debit) for  in all journal lines with the to GST Collected accountin journals that include a line to Trade Debtors.

G10 Capital

...

The same as the Taxable figure on the same line and to the right of this total.

Taxable

purchases (incl GST)

The total of (debit - credit) + or /- tax for all journal lines with a CAP tax typetype and not to GST Paid or Withholding Tax.

G11 Non-capital Purchases

The total of the Taxable and Non-taxable figures on the same line and to the right of this total.

Purchases All capital purchases are taxable.

Purchases

For the purpose of calculating G11, G14 and G17, purchases are considered to be all journal lineslines not to GST Paid or Withholding Tax:

• With no control type, in a creditor invoice, creditor credit note or creditor prompt payment orpayment OR
• To an expenses account, in a creditor general journal or a general journal

Taxable

G11 Non-capital purchases (incl GST)

The total of (debit - credit) + or /- tax for all purchases with a tax type of GSTother than CAP, NA or GIM.

...

G11 includes taxable and non-taxable non-capital purchases.

G12

This total is calculated as G10 + G11.

G14 Purchases without GST in the price

The total of (debit - credit) for all purchases with a tax type other than GST, CAP, GST, NA or GIM and an account other than GST Paid or Withholding Tax.

1B GST on Purchases

The total of the Accumulated Capital, Non-capital and GST on Imports figures on the same line and to the right of this total.

Capital (Accumulated)

The total of the tax amount .

All non-taxable purchases are non-capital.

G17 Total purchases subject to GST

The total of (debit - credit) +/- tax for all purchases with a tax type of GST PLUS 
the total of (debit - credit) +/- tax for all journal lines with a CAP tax typetype and not to GST Paid or Withholding Tax.

Non-capital (Accumulated)

The total of the G17 includes capital and non-capital taxable purchases.

1B GST on purchases

This total is calculated as G17 / 11.

GST accumulated / paid

The total in the first column is the total of the tax amount for all purchases with a tax type of GST..

Capital (Calculated)

Calculated as tax on Taxable Capital Purchases.

Non-capital (Calculated)

Calculated as tax on Taxable Non-capital Purchases.

Withholding Tax

The total of (debit - credit) for all journal lines with the Withholding Tax account.

GST Paid

The total of (debit - credit) for all journal lines with the GST Paid account.

GST on Imports

The total of GST PLUS 
the total of the tax amount for all journal lines with a CAP tax type and not to GST Paid or Withholding Tax.

The total in the second column is the total of (credit - debit) in all journal lines to GST Paid in journals that include a line to Trade Creditors or to an Expense account.

Withholding tax / Tax on imports

The total in the first column is the total of (credit - debit) for all journal lines to Withholding Tax in journals that include a line to Trade Creditors or to an Expense account.

The total in the second column is the total of (debit - credit) for all journal lines with a GIM tax type.type and not to GST Paid or Withholding Tax.

Note that this shows the total value of the taxable imports, not the amount of tax paid on them. The tax paid is included in the GST Paid total.

List Journals for

...

button

Use this button to display diagnostic lists of journals that might be in error. These reports show the journal reference number, date and description, the debtor or creditor ID (search code) and name, the journal amount and the journal tax amount, as well as other fields relevant to the particular list. '''NOTE''' that the date range also applies to the diagnostic lists, i.e. only journals within the date range will be listed. Choose the Clear option from the Date button drop-down menu to search all journals of your company forr possible errors.

Sales with tax type not GST, FRE or EXP

NOTE that with the exception of the 'Taxable non-capital purchases' list the lists are not restricted to the selected period.

Taxable non-capital purchases

Lists taxable non-capital purchases that are included in the GST Explorer totals. These purchases are not shown in a separate total on the form but they are added to G14 to make G11 and added to G10 to make G17.

Lists journal lines that have a tax type other than GST, FRE or EXP and a non-zero amount and or or tax amount. The Amount, Tax and Tax type columns show the values of the line, not the journal.

...