Business activity statement and AMWin

Notes on AMWin and postings to the BAS statement

Invoicing

GST Type 1 : Normal GST

2 : Doesn’t apply in invoicing
3 : Doesn’t apply in invoicing
4 : Doesn’t apply in invoicing

However, if the export button [GST exempt] is checked on an invoice

GST Type 

1: Doesn’t apply in invoicing
2: Doesn’t apply in invoicing
3: Doesn’t apply in invoicing
4: Doesn’t apply in invoicing

In invoicing, if the stock has No GST then it will be invoiced as No GST.

Purchasing

If there is no ABN on Supplier then GST = zero
GST Type 
1: GST = other acquisition on the BAS
2: No GST
3: Capital Acquisition
4: NEW Motor vehicle. Either Purchased or HP (hire purchase). 
5: If leased, then it should be Type 1 (GST).

Type 1: 
Anything you may purchase for the everyday running of the business, except for capital acquisitions. 
A capital acquisition is any depreciable asset purchase over $300.

More details on the 4 GST Types
All capital acquisitions are assets and are in the 1000-1999 ledger range.
You may have to use GL masks and include the capital acquisitions account in the expense range in order to purchase or pay for this acquisition.

Journal Entries
Journal entries DO NOT calculate GST and you will not under any circumstance journal to or from the 2999 GST account to calculate GST on sales and purchases. However, you MUST use journal entries to record a payment from the bank to the 2999 ledger account when remitting a cheque to the government for the GST. Further explanation of this will be provided in the next few pages.

Any item that is exempt from GST, for eg- bank charges, wages, first aid, superannuation etc, should be accounted for by doing a journal entry, crediting the bank account, and debiting the expense account. This is because the journal entry will not post these figures to the BAS, and wages (and other items exempt from GST) should not appear on the BAS.

If you use cheque entry for these purchase expenses, it will incorrectly show on your BAS as a GST free purchase, as long as you have set up the account as a Type 2 (No GST) account. 

Journal entries will NOT CALCULATE GST regardless of the type of GST set up on the account.

Cheque entries should only be used for GST free accounts, if these purchases are actual GST free purchases (fresh food, milk, etc). 

BUSINESS ACTIVITY SHEET:

Draft Calculation Sheet
G1: 
This is the total sales (regardless of whether they are including or excluding GST) and income and other supplies. If you are on an accrual method, the total = the total value invoiced out for the period, regardless of whether the amount has been paid or not. 

If you are on a cash method, the total will include only invoices which have been paid this GST period regardless of whether the invoice happened this month or period or at any time in the past, unless the invoice was pre July 2000.

G2: 
This is the exports which are calculates when you use the export Button for invoicing or adjustment notes. Please refer to the Distinction between cash and accrual method outlined in G1.

G3: 
This is the total of GST free sales for sales of items such as fresh food etc, invoiced to a customer.

G4: 
This is not relevant to the motor industry

G5: 
This is the total of G2 + G3 + G4, which is the total value where GST has not been applied to the sale.

G6: 
This equals G1 – G5, which is the total of sales where GST has been applied.

G7: 
This is any manual adjustment made to the sales figures to account for errors in previous periods or sales, which have not been processed through AMWIN. G7 is the gross value including GST of any adjustments and is manually entered by the user. This figure can be negative by placing a negative sign in front of the figure.

G8: 
This is G6 + G7 and is the total of sales revenue including adjustments where GST has been applied.

G9: 
This is G8 divided by 11, which is the value of GST that has been charged during this period. This figure is transferred to 1A on the front of your BAS.

G10: 
This is the total of all purchases that are type 3 (capital acquisitions) and have been entered into the computer via purchase/purchase order or cheque entry. They won’t be included if they were made by journal entry. Please refer to G1 regarding the method of GST being cash or accrual.

G11: 
This is the total of purchases that are Type 1 GST (except capital acquisitions) which have been entered via a purchase/purchase order/cheque entry. Not included if made by journal entry. 

G12: 
This is G10 + G11, and is the total of your GST applicable purchases.

G13: not used by AMWIN.

G14: 
This is purchases that are exempt of GST (eg: fresh food, medical supplies etc). If you have used cheque entries to process wages, superannuation etc, then it will incorrectly appear in this section of the BAS which is why journal entries should be used to process wages etc.

G15: 
This is the estimated private use of acquisitions which can’t be claimed as a GST input tax, and therefore you can’t get GST credit for these purchases. This has to be manually entered the user and will not be updated by AMWin.

G16: 
This is G13 + G14 + G15 which is the total of non-creditable acquisitions where tax credit can not be claimed.

G17: 
This is G12 – G16, which is the total of acquisitions where GST credit can be claimed.

G18: 
This is a manual adjustment the user makes for the gross value of GST of any purchases for a previous period or purchases that haven’t been entered through AMWin. This figure can be negative if a negative sign is placed in front of it. 

G19: 
This is G17 + G18, which is the total acquisitions after adjustments whereby GST credit can be claimed. 

G20: 
This is G19 divided by 11. This is the GST credit calculated from your purchases and expenses, where a GST credit can be claimed. G20 is transferred to 1B on the front of the BAS.

W1: 
This is the total of salary, wages and other Pay As You Go (PAYG) payments. As SIM users over the last 14 years have had different accounts setup for wages and some users have several accounts dissected for wages, you are required to manually enter the total of these payments. It is proposed in future to consolidate and co-ordinate specific accounts to be used as wage accounts, after which they will be transferred to the BAS. Note that PAYG is uSUAlly done monthly.

W2: 
This is the value of the tax withheld from wages for PAYG or group tax. This figure will be automatically transferred from the 2040 account if there is a figure in the 2040 account. Otherwise it can be manually entered by the user. As a result, it is recommended that income or group tax be journalled on a weekly basis, using journal entry’s, crediting the 2040 account, and debiting your PAYG tax expense account in the 5, 7 or 9’s, each week for the value of the PAYG tax. You can then journal from the bank, to the 2040 account when the PAYG is paid to the government. Further explanation of this is provided in the next pages. W2 includes other payments such as child support, which has been deducted from wages.

W3: 
This is any amount withheld by banks or other financial institutions, because a tax file number has not been supplied to a financial institution. This figure needs to be manually entered by the user.

W4: 
This is the 48.5% withheld from payments to supplier, where the supplier has not provided an ABN. This figure is automatically transferred to the BAS from the 2030 account. This account was previously used for sales tax calculations. Please ensure that sales tax prior to July 2000 has been paid or you transfer any outstanding sales tax to another liability account using a journal entry.

W2 + W3 + W4 are transferred to 4 on the front of the BAS.

T1: 
Instalment income is the value of PAYG tax.

T2: 
This is a commissioners % tax rate which will be supplied to you by the tax office and must be manually entered.

T3: 
Varied instalment rate supplied by the tax office which must be manually entered.

PAYG tax 
PAYG tax is uSUAlly paid monthly even if you have a quarterly GST period. You are required to complete a BAS every month, even if 2 out of every 3 are only used for PAYG. The calculated instalment income is transferred to 5A on the front of the BAS. 

F1: This is the calculated fringe benefit tax instalment.

F2: This is the estimated total fringe benefit tax total.

F3: This is the variable Fringe Benefit Tax instalment.

F4: This is the reason for such variation.

The fringe benefit tax instalment is transferred to 6A on the front of the BAS. The user must manually enter all of the fringe benefit tax figures.

Front of the BAS

The front of the BAS includes your company name and address.

A1: 
this is a document identification number presented by the tax office.

A2: 
this is your company ABN

A3: 
this is the period covered by the BAS. If you are on monthly BAS 

Then it will begin at the beginning of the current month, and end at the end of the current month. If you are on a quarterly BAS, it will begin at the beginning of the quarter, and end at the end of the quarter.

A4 
Wine equalisation section is left out of AMWIN intentionally. 

A5: 
This is the date that the payment of the GST owed is due. This is 

USUAlly the 21st of the following month, however some leniency has been provided for the first 2 BAS periods.

1A: 
This is the amount owed for sales which was transferred from G9.

1E: 
This equals the tax payable on luxury cars. This should be manually entered by the user.

2A: 
This is the total of 1A and 1E, which is the total of GST and luxury car tax payable. We have purposely excluded wine equalisation tax from the BAS report. 

1B: 
This is the credit for GST paid on acquisitions transferred from G20.

1F: 
This is luxury car tax refundable. 1F should be manually entered by the user.

1G: 
This is the credit for wholesale sales tax for stock on hand for the 30/6/2000. During the conversion process from SIM Version 8, AMWIN accurately calculated the sales tax component of stock on hand as at 30/6/2000, according to the stock figures present in SIM at the time. 

This was calculated as follows:
For each item- cost including tax – cost excluding tax X the quantity on hand.

This formula only applies if the tax paid for stock items was Y for Yes, and the tax class was not N for non taxable. 

This is assuming that you are entitled to a full 100% rebate of the sales tax paid for stock on hand, as at 30/6/2000. Certain regulations may prohibit claiming all of this sales tax. Please refer to your accountant for further clarification. AMWIN will by default include 100% of calculated sales tax figures in 1G. Please ensure that this figure is verified by yourself and your accountant.

Please note that the developers of AMWin accept no responsibility for the truth or validity of this figure.