Review all the GST transactions for a period (see GST information)
The GST explorer is not intended to be a tax advice tool. It simply assists with the completion of activity statements.
Please verify the figures presented with a qualified tax professional.
Use the BAS Statement tab to calculate the amounts to enter on your BAS statement.
This specifies the date range that applies to all of the totals and journal lists on the form.
The BAS Reporting Period must be specified for the host company (Admin menu, Your Host Company, 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 (Admin menu, config, 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 period name is made up of the financial year and the period. If the last month of the financial year is December then the financial year will be the 4 digit year, e.g. 2013, otherwise it will be the years, e.g. 2012-2013. If the BAS Reporting Period is Annually then there is no period after the financial year. If it is monthly then the period is a 3 character abbreviation of the month, e.g. Jan. If it is Quarterly then the period is Q followed by the quarter in the financial year, e.g. Q4. Otherwise it is the first and last month of the period, e.g. May-Jun.
If the period is locked then 'Locked' will show after the period name.
The default period selected is the most recently completed period, i.e. the period before the current one.
The selected period name is displayed in the box to the right of the Period button.
Click the 'Period' button to choose a different period. The periods displayed will be:
The options available on the Action menu depend on the selected period:
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.
When a period is locked all of the totals for that period are saved. When a locked period is displayed then the saved totals are displayed. They are not recalculated.
When a period is locked all of the journals that are included in the totals for that period are locked and cannot be changed or deleted.
Any new journal with a date in a locked period becomes an unlocked journal in a locked period.
When the period after the last locked period is being calculated it will include all journals within the period plus all unlocked journals from the start of the previous financial year or from the start of the first locked period, whichever is later. When this period is locked then these journals will be locked with it.
To determine the journals included in a period but which are dated before that period (i.e. new journals added to a locked period) then list the journals in the period and note those with a date before the period.
Only journals for the company of the user are used in all GST Explorer calculations and lists.
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:
The tax amount in a journal does not have a sign. The tax is considered to have the same sign as the total of the journal line on which it appears.
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.
This total is calculated as G2 + G3 + G6.
The total of (credit - debit) for all journal lines with an EXP tax type in journals that include a line to Trade Debtors.
The total of (credit - debit) for all journal lines with a FRE tax type in journals that include a line to Trade Debtors.
This total is calculated as G2 + G3.
The total of (credit - debit) +/- tax for all journal lines with a GST tax type in journals that include a line to Trade Debtors.
This total is calculated as G6 / 11.
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) in all journal lines to GST Collected in journals that include a line to Trade Debtors.
The total of (debit - credit) +/- tax for all journal lines with a CAP tax type and not to GST Paid or Withholding Tax.
All capital purchases are taxable.
For the purpose of calculating G11, G14 and G17, purchases are considered to be all journal lines not to GST Paid or Withholding Tax:
The total of (debit - credit) +/- tax for all purchases with a tax type other than CAP, NA or GIM.
G11 includes taxable and non-taxable non-capital purchases.
This total is calculated as G10 + G11.
The total of (debit - credit) for all purchases with a tax type other than GST, CAP, NA or GIM.
All non-taxable purchases are non-capital.
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 type and not to GST Paid or Withholding Tax.
G17 includes capital and non-capital taxable purchases.
This total is calculated as G17 / 11.
The total in the first column is the total of the tax amount for all purchases with a tax type 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.
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 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.
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 with the exception of the 'Taxable non-capital purchases' list the lists are not restricted to the selected period.
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.
Lists journals where the total journal tax amount differs from the amount debited or credited to the GST Paid or GST Collected GL accounts. The Amount and Tax columns show the totals for the journal. The PaidCollected column shows the amount credited or debited to the GST Paid or GST Collected GL accounts. The amounts are absolute.
Lists journal lines with a GST or CAP tax type or a non-zero tax amount where the difference between the tax amount and the amount divided by 10 is greater than $0.03. The Tax type, Amount and Tax columns show the values for the journal line. Calc Tax shows the Amount divided by 10 and Difference the difference between the Tax and Calc Tax columns. The amounts are absolute.
Lists journal lines with a non-zero tax amount and a tax type other than GST or CAP.
This tab shows lists of journals as selected using the asterisk button beside a figure or the List Journals for ... button on the BAS Statement tab.