Proj 2 2019, Q2 BAS - ABCD - Microsoft Excel In compliance with new TPB requirements, we have amended our assessment method. The foresaid project files Helvetica will be shared in the online exam. For more details, please kindly refer to "HOW TO PASS THE UNIT?' section. Paste Format Painter $ Merge & Center . $ - % * 188 408 Conditional Format Cell Insert Delete Format Sort & Find & Formatting * as Table . Styles 2 Clear Filter . Select Clipboard Font Alignment Number Styles Cells Editing F21 A B C D E F G H K L M GST Calculation Worksheet ABCD Pty Ltd W N For the period 01/10/2018 - 31/12/2018 ABN 48906549591 GST Accounting Method Cash Basis 8 Goods and Services Tax (Option 1) 10 Total sales G1 11 Does the amount shown at G1 include GST N 12 Export sales G2 13 Other GST-free sales G3 14 Capital purchases (including any GST) G10 15 Non-capital purchases (including GST) G11 16 17 PAYG Tax Withheld 18 Total salary, wages and other payments W1 + 19 Amount withheld from payments shown at W1 W2 20 Amount withheld where no ABN is quoted W4 21 Other amounts withheld (excluding any amount shown in W2 or W4) W3 22 Total amounts withheld (W2 + W4 + W3) W5 $0.00 23 24 PAYG Income Tax Instalment (Option 1) 25 Instalment (copy from BAS) T7 26 If varying this amount, complete T8, T9 and T4. 27 Estimated tax for the year T8 28 Varied amount for the quarter T9 29 Reason code for variation List of codes T4 30 31 Amounts you owe the Tax Office 32 GST on sales 1A 4 ) |BAS GST Calculation wages Rev-Original Exp-original / 3Proj 2 2019, Q2 BAS - ABCD - Microsoft Excel In compliance with new TPB requirements, we have amended our assessment method. The foresaid project files will be shared in the online exam. For more details, please kindly refer to "HOW TO PASS THE UNIT?' section. Helvetica Paste Conditional Format Cell Sort & Find & Format Painter BI U IDA $ Merge & Center . $ ~ % * 68 408 Insert Delete Format Formatting . as Table . Styles . 2 Clear . Filter . Select - Clipboard Font Alignment Number Styles Cells Editing C16 A B C D E F G H J K M N O GST Calculation Worksheet For the period 1 October 2018 to 31 December 2018 GST amounts you owe the Tax Office from sales Total sales (including any GST) G1 Export sales G2 Other GST-free sales G3 0 Input taxed sales G4 50 1 62+ G3 + G4 G5 2 Total sales subject to GST (G1 minus G5) G6 $0 3 Adjustments (if applicable) G7 $0 4 Total sales subject to GST after adjustments (G6 + G7) G8 $0 5 GST on sales (G8 divided by eleven) G9 $0 6 17 GST amounts the Tax Office owes you from purchases 8 Capital purchases (including any GST) G10 $0 9 Non-capital purchases (including GST) G11 0 G10 + G11 G12 50 1 Purchases for making input taxed sales G13 50 2 Purchases without GST in the price G14 $0 3 Estimated purchases for private use or not income tax deductable 915 $0 G13+ G14+ G15 $0 5 Total purchases subject to GST (G12 minus G16) G17 $0 6 Adjustments (if applicable) G18 $0 7 Total purchases subject to GST after adjustments (G17 + G18) G19 $0 8 GST on purchases (G19 divided by eleven) G20 $0 BAS GST Calculation wages Rev-Original Exp-originalProj 2 2019, Q2 BAS - ABCD - Microsoft Excel In compliance with new TPB requirements, we have amended our assessment method. The foresaid project files will be shared in the online exam. For more details, please kindly refer to "HOW TO PASS THE UNIT?" section. imes Paste B IUDA Merge & Center . $ - % Conditional Format Cell Insert Delete Format Sort & Find & Format Painter Formatting . as Table . Styles . 2 Clear . Filter . Select Clipboard Font Alignment Number Styles Cells Editing G15 A B C D E F G H K M 1 period name days No hrs hrs rate gross amt tax held after tax super date paid October Cindy Conway salary $ 1,000.00 95 28/10/2018 Alice salary $ 1,000.00 95 28/10/2018 Jean McDonald salary $ 11, 250. 00 $3, 300. 00 $ 7,950.00 1068.75 28/10/2018 November Cindy Conway salary $ 1,000.00 95 28/11/2018 Alice salary $ 1,000.00 95 28/11/2018 Jean McDonald salary $ 11, 250. 00 $3, 300. 00 $ 7,950.00 1068.75 28/11/2018 TO L ACC 10 December Cindy Conway salary $ 1,000.00 95 28/12/2018 11 Alice salary $ 1,000.00 95 28/12/2018 12 Jean Mcdonald salary $ 11, 250. 00 $ 3, 300. 00 $ 7,950.00 1068.75 28/12/2018 13 Oct - Dec 18 Wendy Lee part time 75 20.00 $ 1,500.00 142.50 8/12/2018 14 15 16 17 18 19 20 21 Total $ 41,250.00 $ 9,900.00 $ 23,850.00 22Proj 2 2019, Q2 BAS - ABCD - Microsoft Excel In compliance with new TPB requirements, we have amended our assessment method. The foresaid project files will be shared in the online exam. For more details, please kindly refer to "HOW TO PASS THE UNIT?" section. Paste : Merge & Center . $ ~ % * 188 408 Conditional Format Cell Insert Delete Format Sort & Find & Format Painter Formatting . as Table . Styles 2 Clear . Filter . Select * Clipboard Font Alignment Number Styles Cells Editing E25 B C D E M N P Q Revenue 2 Date Customer Inv No. Desc Amount (GST incl) GST Amount (GST exel) Payment Menthod 3 21/10/2018 HING LI RETURN THE OVERPAID SALART 9900 03/11/2018 HENAN BAO ResMed 59 goods fee USD33,150 SHANGHAI CENTRAL 9/12/2018 INTERNATIONAL Wine goods fee USD,91490 HK KING CROWN Mechanical Cardiopulmonary 22/12/2018 HOLDING LTD Resuscitator Goods /4s USD106000 31/12/2018 JIALE ZHAO TBA Fee 24,900.00 2263 24/12/2018 JIALE ZHAO TBA Fee 20000 1818 24/12/2018 Haizhen Long Wine Goods Fee 1300 23/12/2018 Qi Xiao Wine Goods Fee 10000 December Suppertime referal fee 1518.78 138.07 12 14/11/2018 RUBIN JI wine sale 1111.22 101.02 13 1/10/18-31/12/18 Westpac interest income 145.63 14 80576 15 Total 23 25 26 + 27 14 |BAS GST Calculation wages Rev Original /Exp-originalProj 2 2019, Q2 BAS - ABCD - Microsoft Excel O In compliance with new TPB requirements, we have amended our assessment method. The foresaid project files will be shared in the online exam. For more details, please kindly refer to "HOW TO PASS THE UNIT?" section. Paste Insert Delete Format Sort & Find & Format Painter BLUE - 3 A Merge & Center $ ~ % * 88 408 Conditional Format Cell Formatting . as Table . Styles . 2 Clear . Filter . Select Clipboard Font Alignment G Number Styles Cells Editing C33 B C D G M N 0 P Q 1 Expenses Amount 2 Date Supplier Inv No. Desc Amount (GST incl) GST GST exel) Pint Method 3 OCT-DEC Bank Fee USD42.8 Bank Fee 388.45 5 OCT-DEC Train & Parking 488.50 $44.40 EFT ATO Q1 BAS 4411.00 18/12/2018 Infiniti Sydney car repair 1345.89 122.35 21/10/2018 RTA CAR REGO 1140.00 737+403 28/10/2018 RAY WHITE office rental for Jul-De 4779.00 10 oct-dec CAR expenses Patrol and Etoll 866.92 78.00 To Hing 15/10/2018 Plaintum Ace accounting Fee 165.00 15.00 Account 12 OCT-DEC Optus and Vodphone office phonedinternet 452.65 EFT 13 18/10/2018 Ctrip/Qantas Adelaide air ticket 1,574.00 14 19/10/2018 Quest at Franklin Adelaide accormadation 416.00 37.88 15 25/11/2018 Gold coast Hilton accommodation 604.00 54.90 16 13. 12. 2018 Mantra chatswood Hing li accormadation 743.08 67.60 17 01/12/2018 Buget car rental Gold Coast Car rental 233.73 21.25 TRS 18 12/11/2018 Jetstar Gold Coast air tickets 620.00 56.36 19 09/11/2018 Artarmon Newsagent/JBHiFi Office use 136.00 12.40 20 04/11/2018 Apple Shop Office use 199.00 18.09 TRS 02,23/12 Pearsons Florist office equipments 187.00 17.00 22 17/11/2018 Lucky Charm entertainment 100.20 TRS 23 28/10/2018 Bunning OFFICE USING 78.10 7.10 6/12/2018 Sorrento Gift OFFICE USING 85.90 7.81 TRS BAS GST Calculation wages Rev-Original Exp-original