GST Calculation Worksheet

This GST Calculation Worksheet helps you calculate the GST amounts for sales and purchases. It provides a breakdown of GST on sales and purchases for a specific period. Use this worksheet to accurately calculate your GST obligations.

GST Calculation
Worksheet
Activity Statement | Mohua Australia Pty Ltd - AccountingPod | 1 Apr 2018 to 30 Jun 2018 Page 1 of 5
Mohua Australia Pty Ltd - AccountingPod
For the period 1 April 2018 to 30 June 2018
GST amounts you owe the Tax Office from sales
Total sales (including any GST) G1 4,597.99
Export sales G2 0.00
Other GST-free sales G3 549.99
Input taxed sales G4 0.00
G2 + G3 + G4 G5 549.99
Total sales subject to GST (G1 minus G5) G6 4,048.00
Adjustments (if applicable) G7 0.00
Total sales subject to GST after adjustments (G6 + G7) G8 4,048.00
GST on sales (G8 divided by eleven) G9 368.00
GST amounts the Tax Office owes you from purchases
Capital purchases (including any GST) G10 0.00
Non-capital purchases (including GST) G11 8,872.77
G10 + G11 G12 8,872.77
Purchases for making input taxed sales G13 0.00
Purchases without GST in the price G14 882.00
Estimated purchases for private use or not income tax deductable G15 0.00
G13 + G14 + G15 G16 882.00
Total purchases subject to GST (G12 minus G16) G17 7,990.77
Adjustments (if applicable) G18 0.00
Total purchases subject to GST after adjustments (G17 + G18) G19 7,990.77
GST on purchases (G19 divided by eleven) G20 726.43

Business Activity
Statement
Activity Statement | Mohua Australia Pty Ltd - AccountingPod | 1 Apr 2018 to 30 Jun 2018 Page 2 of 5
Mohua Australia Pty Ltd - AccountingPod
For the period 1 April 2018 to 30 June 2018
ABN 11111111138
GST Accounting Method Cash Basis
Goods and Services Tax (Option 1)
Total sales G1 4,597.99
Does the amount shown at G1 include GST Yes
Export sales G2 0.00
Other GST-free sales G3 549.99
Capital purchases (including any GST) G10 0.00
Non-capital purchases (including GST) G11 8,872.77
Amounts you owe the Tax Office
GST on sales 1A 368.00
Deferred company/fund instalment 7 0.00
1A+7 8A 368.00
Amounts the Tax Office owes you
GST on purchases 1B 726.00
1B 8B 726.00
Payment or Refund
Is 8A more than 8B? No
Your refund 9 358.00

GST Audit Report
Activity Statement | Mohua Australia Pty Ltd - AccountingPod | 1 Apr 2018 to 30 Jun 2018 Page 3 of 5
Mohua Australia Pty Ltd - AccountingPod
For the period 1 April 2018 to 30 June 2018
Date Account Reference Details Gross GST Net
GST on Income
24 Apr 2018 Sales (200) INV-0002 Payment: Market
Sales
4,048.00 368.00 3,680.00
Total GST on Income 4,048.00 368.00 3,680.00
GST on Expenses
1 Apr 2018 Software
Subscriptions (486)
Domain Name AUS
- Payed for software
subscriptions for
domain name
56.35 5.12 51.23
1 Apr 2018 Telephone &
Internet (489)
Fone2U 495.73 45.07 450.66
1 Apr 2018 Travel - National
(493)
Flites 4you Travel -
Traveled nationally
456.00 41.45 414.55
1 Apr 2018 Wool Purchases
(315)
#38 Wool and supplies
paid for privately -
Wool supplies paid
privately - 50x100g
@ $9incl less 10%
discount
405.00 36.82 368.18
1 Apr 2018 Consumables (414) #38 Wool and supplies
paid for privately -
Consumable knitting
supplies paid
privately
88.40 8.04 80.36
1 Apr 2018 Computer
Equipment (720)
#39 Laptop and printer
sold to business at
valuation - Used
Laptop sold to
business at
valuation (verified)
700.00 63.64 636.36
1 Apr 2018 Office Equipment
(710)
#39 Laptop and printer
sold to business at
valuation - Used
Printer sold to
business at
valuation (verified)
150.00 13.64 136.36
3 Apr 2018 Furniture and
Fittings (700)
Department Store -
MktUmbrella and
Base
318.00 28.91 289.09
3 Apr 2018 General Expenses
(429)
AccomOh 189.75 17.25 172.50
9 Apr 2018 Rent (469) Market 50.00 4.55 45.45
12 Apr 2018 General Expenses
(429)
Machine hire2U 34.50 3.14 31.36
20 Apr 2018 Payment Gateway
and Sales Fees
(310)
INV-0001 Payment: Daily
Website Sales
19.54 1.78 17.76
25 Apr 2018 Legal expenses
(441)
Legal Fees Payment: Lawyer &
Lawyer
862.50 78.41 784.09

GST Audit Report
Activity Statement | Mohua Australia Pty Ltd - AccountingPod | 1 Apr 2018 to 30 Jun 2018 Page 4 of 5
Date Account Reference Details Gross GST Net
25 Apr 2018 Consulting &
Accounting (412)
Accounting Fee Payment:
Accountant &
Accountant
550.00 50.00 500.00
25 Apr 2018 Intangibles (730) Brand Design Payment: Design &
Design
2,875.00 261.36 2,613.64
25 Apr 2018 Packaging (316) Mohua Packaging Payment: Packaging
Company Limited
287.50 26.14 261.36
25 Apr 2018 Low value assets
(403)
Mohua Packaging Payment: Packaging
Company Limited
402.50 36.59 365.91
30 Apr 2018 Software
Subscriptions (486)
Xero 50.00 4.55 45.45
Total GST on Expenses 7,990.77 726.46 7,264.31
GST Free Income
20 Apr 2018 Sales (200) INV-0001 Payment: Daily
Website Sales
549.99 0.00 549.99
Total GST Free Income 549.99 0.00 549.99
GST Free Expenses
1 Apr 2018 Low value assets
(403)
BizCards4U - Tui's
new business bag
127.59 0.00 127.59
1 Apr 2018 General Expenses
(429)
CoverURphone -
Tui's new phone
cover
52.06 0.00 52.06
3 Apr 2018 Low value assets
(403)
BizBags2U 63.49 0.00 63.49
3 Apr 2018 Bank Fees (404) Urgent Card Fee 25.00 0.00 25.00
4 Apr 2018 Bank Fees (404) Card Fee 6.25 0.00 6.25
15 Apr 2018 Advertising &
Marketing - Online
(400)
Social2U - Online
marketing and
advertising
75.98 0.00 75.98
15 Apr 2018 Bank Fees (404) Card Fee 25.00 0.00 25.00
19 Apr 2018 Advertising &
Marketing - Online
(400)
SocialAdv -
Social1234.Com Sg
425.01 0.00 425.01
27 Apr 2018 Software
Subscriptions (486)
Httpswebsite4U 39.57 0.00 39.57
30 Apr 2018 Bank Fees (404) Business Bank Fee 5.00 0.00 5.00
30 Apr 2018 Donations (418) Native Bird CT 37.00 0.00 37.00
30 Apr 2018 Bank Fees (404) Monthly - Batch
Paymt fee
0.20 0.00 0.20
Total GST Free Expenses 882.15 0.00 882.15
BAS Excluded
1 Apr 2018 Shareholder Current
Account (845)
#38 Wool and supplies
paid for privately -
Wool and supplies
paid for privately -
shareholder current
account
(493.40) 0.00 (493.40)
1 Apr 2018 Shareholder Current
Account (845)
#39 Laptop and printer
sold to business at
valuation - Used
Laptop and printer
sold to business at
valuation through
(850.00) 0.00 (850.00)

GST Audit Report
Activity Statement | Mohua Australia Pty Ltd - AccountingPod | 1 Apr 2018 to 30 Jun 2018 Page 5 of 5
Date Account Reference Details Gross GST Net
shareholder current
account
3 Apr 2018 10,000 Ordinary
Shares (970)
Tui - Ordinary
shares
(10,000.00) 0.00 (10,000.00)
30 Apr 2018 10,000 Ordinary
Shares (970)
Drawings -
Shareholder
drawings Draw Via
Cur
500.00 0.00 500.00
Total BAS Excluded (10,843.40) 0.00 (10,843.40)
Total 6,568.47 (358.46) 6,926.93