I have attached the filesTrial Balance 1-6-XX Kennedy Tax and Business Services 4/207 Barkly St,...

Question

I have attached the filesTrial Balance 1-6-XX 	Kennedy Tax and Business Services 	4/207 Barkly St, Footscray VIC 3011 	(03) 9939 6480 	ABN: 55 635 329 523 	Financial Year:	2019 	 Trial Balance as at:  01-Jun-		2019 	Account Name	Account No.	Dr ($)	Cr ($) 	Bank	100	21,500 	Petty Cash	101	400 	Debtors Control	110	3,020 	Allowance for Doubtful Debts	115		400 	Stock Control	120	1,000 	GST Paid	125	4,500 	Tools & Equipment	150	15,000 	Accumulated Depreciation of T & E	155		5,000 	Motor Vehicles	160	65,000 	Accumulated Depreciation of MV	165		20,000 	Fixtures & Fittings	170	30,000 	Accumulated Depreciation of F & F	175		5,000 	Creditors Control	210		4,900 	GST Collected	220		9,000 	Long Term Loan - XYZ Bank	250		50,000 	Capital	300		67,708 	Drawings	310	20,000 	Sales Revenue	400		14,000 	Service Fees	410		123,800 	Discount Received	450		1,400 	Purchases	500	3,000 	Freight Inwards	510	200 	Advertising	600	1,500 	Salaries & Wages	700	80,000 	Personal Leave	701	3,000 	Annual Leave	702	5,000 	Superannuation	703	7,000 	Utilities	710	1,600 	Staff Amenities	720	1,500 	Insurance	730	4,000 	Motor Vehicle Expenses	740	10,000 	Rent	750	20,000 	Repairs & Maintenance	760	700 	Stationery	770	400 	Discount Allowed	800	600 	Interest Expense	810	2,200 	Bank Fees	840	88 			301,208	301,208 Receipts 		Kennedy Tax and Business Services			Receipt				Kennedy Tax and Business Services			Receipt 		4/207 Barkly St, Footscray VIC 3011							4/207 Barkly St, Footscray VIC 3011 		(03) 9939 6480							(03) 9939 6480 		ABN: 55 635 329 523							ABN: 55 635 329 523 					Receipt No.:  	176						Receipt No.:  	181 		Paid by: 			Date:	05/06/	2019		Paid by: 			Date:	20/06/	2019 		Cash			Total (Inc GST)		$   1,650.00		EFTPOS			Total (Inc GST)		$   330.00 		Description: Service Fees			Discount(s)				Description: Service Fees			Discount(s) 		Thank you for your business!			Total Less Discount(s)		$   1,650.00		Thank you for your business!			Total Less Discount(s)		$   330.00 					Includes GST		$   150.00					Includes GST		$   30.00 					Balance Paid		$   1,650.00					Balance Paid		$   330.00 		Received by:							Received by: 		Kennedy Tax and Business Services			Receipt				Kennedy Tax and Business Services			Receipt 		4/207 Barkly St, Footscray VIC 3011							4/207 Barkly St, Footscray VIC 3011 		(03) 9939 6480							(03) 9939 6480 		ABN: 55 635 329 523							ABN: 55 635 329 523 					Receipt No.:  	177						Receipt No.:  	182 		Paid by: 			Date:	07/06/	2019		Paid by: 			Date:	21/06/	2019 		EFTPOS			Total (Inc GST)		$   880.00		Cash			Total (Inc GST)		$   275.00 		Description: Service Fees			Discount(s)				Description: Product Sales			Discount(s) 		Thank you for your business!			Total Less Discount(s)		$   880.00		Thank you for your business!			Total Less Discount(s)		$   275.00 					Includes GST		$   80.00					Includes GST		$   25.00 					Balance Paid		$   880.00					Balance Paid		$   275.00 		Received by:							Received by: 		Kennedy Tax and Business Services			Receipt				Kennedy Tax and Business Services			Receipt 		4/207 Barkly St, Footscray VIC 3011							4/207 Barkly St, Footscray VIC 3011 		(03) 9939 6480							(03) 9939 6480 		ABN: 55 635 329 523							ABN: 55 635 329 523 					Receipt No.:  	178						Receipt No.:  	183 		Paid by: 			Date:	10/06/	2019		Paid by: 			Date:	24/06/	2019 		HRM Pty Ltd			Total (Inc GST)		$   960.00		Cash			Total (Inc GST)		$   220.00 		Description: Payment of Account			Discount(s)				Description: Product Sales			Discount(s) 		Thank you for your business!			Total Less Discount(s)		$   960.00		Thank you for your business!			Total Less Discount(s)		$   220.00 					Includes GST							Includes GST		$   20.00 					Balance Paid		$   960.00					Balance Paid		$   220.00 		Received by:							Received by: 		Kennedy Tax and Business Services			Receipt				Kennedy Tax and Business Services			Receipt 		4/207 Barkly St, Footscray VIC 3011							4/207 Barkly St, Footscray VIC 3011 		(03) 9939 6480							(03) 9939 6480 		ABN: 55 635 329 523							ABN: 55 635 329 523 					Receipt No.:  	179						Receipt No.:  	184 		Paid by: 			Date:	15/06/	2019		Paid by: 			Date:	28/06/	2019 		Cash			Total (Inc GST)		$   220.00		EFTPOS			Total (Inc GST)		$   660.00 		Description: Service Fees			Discount(s)				Description: Service Fees			Discount(s) 		Thank you for your business!			Total Less Discount(s)		$   220.00		Thank you for your business!			Total Less Discount(s)		$   660.00 					Includes GST		$   20.00					Includes GST		$   60.00 					Balance Paid		$   220.00					Balance Paid		$   660.00 		Received by:							Received by: 		Kennedy Tax and Business Services			Receipt				Kennedy Tax and Business Services			Receipt 		4/207 Barkly St, Footscray VIC 3011							4/207 Barkly St, Footscray VIC 3011 		(03) 9939 6480							(03) 9939 6480 		ABN: 55 635 329 523							ABN: 55 635 329 523 					Receipt No.:  	180						Receipt No.:  	185 		Paid by: 			Date:	17/06/	2019		Paid by: 			Date:	29/06/	2019 		Paul Smiths			Total (Inc GST)		$   1,320.00		Cash			Total (Inc GST)		$   165.00 		Description: Payment of Account			Discount(s)				Description: Product Sales			Discount(s) 		Thank you for your business!			Total Less Discount(s)		$   1,320.00		Thank you for your business!			Total Less Discount(s)		$   165.00 					Includes GST							Includes GST		$   15.00 					Balance Paid		$   1,320.00					Balance Paid		$   165.00 		Received by:							Received by: Cheque Butts 		BANK OF BUSINESS							BANK OF BUSINESS 			DATE:	1st	June	2019				DATE:	18th	June	2019 			PAYEE:	Cash Purchases						PAYEE:	Dell (Purchases) for Inv 673 				$	₵						$	₵ 			Bal B/Fwd:							Bal B/Fwd: 			Deposits:							Deposits: 			This Cheque:	110	00	Inc GST				This Cheque:	187	00	Inc GST 			Balance B/Fwd:							Balance B/Fwd: 			Cheque No.:	261						Cheque No.:	267 		BANK OF BUSINESS							BANK OF BUSINESS 			DATE:	3rd	June	2019				DATE:	18th	June	2019 			PAYEE:	Advertiso (Magazine Advertising)						PAYEE:	Ergon Energy (Electricity) 				$	₵						$	₵ 			Bal B/Fwd:							Bal B/Fwd: 			Deposits:							Deposits: 			This Cheque:	220	00	Inc GST				This Cheque:	418	00	Inc GST 			Balance B/Fwd:							Balance B/Fwd: 			Cheque No.:	262						Cheque No.:	268 		BANK OF BUSINESS							BANK OF BUSINESS 			DATE:	3rd	June	2019				DATE:	18th	June	2019 			PAYEE:	Kmart Tyre & Auto (Purchases) for Inv A743						PAYEE:	Petty Cash 				$	₵						$	₵ 			Bal B/Fwd:							Bal B/Fwd: 			Deposits:							Deposits: 			This Cheque:	990	00	Inc GST				This Cheque:	252	00	Inc GST 			Balance B/Fwd:							Balance B/Fwd: 			Cheque No.:	263						Cheque No.:	269 		BANK OF BUSINESS							BANK OF BUSINESS 			DATE:	5th	June	2019				DATE:	22nd	June	2019 			PAYEE:	Dept of Transport (Vehicle Rego)						PAYEE:	Drawings 				$	₵						$	₵ 			Bal B/Fwd:							Bal B/Fwd: 			Deposits:							Deposits: 			This Cheque:	935	00	Inc GST 				This Cheque:	750	00	GST Free 			Balance B/Fwd:							Balance B/Fwd: 			Cheque No.:	264						Cheque No.:	270 		BANK OF BUSINESS							BANK OF BUSINESS 			DATE:	9th	June	2019				DATE:	22nd	June	2019 			PAYEE:	Melbourne Water (Water)						PAYEE:	Robins Realty (Rent) 				$	₵						$	₵ 			Bal B/Fwd:							Bal B/Fwd: 			Deposits:							Deposits: 			This Cheque:	160	00	GST Free				This Cheque:	1800	00	Inc GST 			Balance B/Fwd:							Balance B/Fwd: 			Cheque No.:	265						Cheque No.:	271 		BANK OF BUSINESS							BANK OF BUSINESS 			DATE:	12th	June	2019				DATE:	28th	June	2019 			PAYEE:	Cash Purchases						PAYEE:	Caltex Fuel (M/V Fuel Card) 				$	₵			330			$	₵ 			Bal B/Fwd:							Bal B/Fwd: 			Deposits:							Deposits: 			This Cheque:	165	00	Inc GST				This Cheque:	225	00	Inc GST 			Balance B/Fwd:							Balance B/Fwd: 			Cheque No.:	266						Cheque No.:	272 Invoices 		INVOICES SENT						INVOICES RECEIVED 		TAX INVOICE		Invoice No.:	2051			TAX INVOICE		Invoice No.:	A743 				Date:	02/06/	2019				Date:	02/06/	2019 		Kennedy Tax and Business Services		To: 				Kmart Tyre & Auto		To:  		4/207 Barkly St, Footscray VIC 3011		HRM Pty Ltd						Kennedy Tax and Business Services 		(03) 9939 6480								4/207 Barkly St, Footscray VIC 3011 		ABN: 55 635 329 523 		Description:  Product Sales		Total (Inc GST)		$   165.00		Description:  Product Purchase		Total (Inc GST)		$   1,100.00 		Thank you for your business!		Discount(s)				Thank you for your business!		Discount(s) 				Total Less Discount(s)		$   165.00				Total Less Discount(s)		$   1,100.00 				Includes GST		$   15.00				Includes GST		$   100.00 				Balance Due		$   165.00				Balance Due		$   1,100.00 		Discount Terms:	5% discount if paid within 7 days					Discount Terms:	10% discount if paid within 7 days 		TAX INVOICE		Invoice No.:	2052			TAX INVOICE		Invoice No.:	673 				Date:	12/06/	2019				Date:	05/06/	2019 		Kennedy Tax and Business Services		To: 				Dell		To:  		4/207 Barkly St, Footscray VIC 3011		Paul Smiths						Kennedy Tax and Business Services 		(03) 9939 6480								4/207 Barkly St, Footscray VIC 3011 		ABN: 55 635 329 523 		Description:  Service Fees		Total (Inc GST)		$   1,320.00		Description:  Product Purchase		Total (Inc GST)		$   1,870.00 		Thank you for your business!		Discount(s)				Thank you for your business!		Discount(s) 				Total Less Discount(s)		$   1,320.00				Total Less Discount(s)		$   1,870.00 				Includes GST		$   120.00				Includes GST		$   170.00 				Balance Due		$   1,320.00				Balance Due		$   1,870.00 		Discount Terms:	5% discount if paid within 7 days					Discount Terms:	10% discount if paid within 7 days 		TAX INVOICE		Invoice No.:	2053			TAX INVOICE		Invoice No.:	1056 				Date:	22/06/	2019				Date:	27/06/	2019 		Kennedy Tax and Business Services		To: 				Officeworks		To:  		4/207 Barkly St, Footscray VIC 3011		Footscray Community Centre						Kennedy Tax and Business Services 		(03) 9939 6480								4/207 Barkly St, Footscray VIC 3011 		ABN: 55 635 329 523 		Description:  Service Fees		Total (Inc GST)		$   4,400.00		Description:  Product Purchase		Total (Inc GST)		$   550.00 		Thank you for your business!		Discount(s)				Thank you for your business!		Discount(s) 				Total Less Discount(s)		$   4,400.00				Total Less Discount(s)		$   550.00 				Includes GST		$   400.00				Includes GST		$   50.00 				Balance Due		$   4,400.00				Balance Due		$   550.00 		Discount Terms:	5% discount if paid within 7 days					Discount Terms:	10% discount if paid within 14 days 		TAX INVOICE		Invoice No.:	2054			TAX INVOICE		Invoice No.:	A792 				Date:	15/06/	2019				Date:	02/06/	2019 		Kennedy Tax and Business Services		To: 				Mac Tech		To:  		4/207 Barkly St, Footscray VIC 3011		HRM Pty Ltd						Kennedy Tax and Business Services 		(03) 9939 6480								4/207 Barkly St, Footscray VIC 3011 		ABN: 55 635 329 523 		Description:  Product Sales		Total (Inc GST)		$   165.00		Description:  Product Purchase		Total (Inc GST)		$   330.00 		Thank you for your business!		Discount(s)				Thank you for your business!		Discount(s) 				Total Less Discount(s)		$   165.00				Total Less Discount(s)		$   330.00 				Includes GST		$   15.00				Includes GST		$   30.00 				Balance Due		$   165.00				Balance Due		$   330.00 		Discount Terms:	5% discount if paid within 7 days					Discount Terms:	10% discount if paid within 7 days Sample Stock 		Product Code:	AA-1001		Product Code:	AA-1005 		Item Name:	Sample Product 1		Item Name:	Sample Product 5 		Purchase Price (per unit):	$   180.00		Purchase Price (per unit):	$   76.00 		Quantity in Stock:	8		Quantity in Stock:	9 		Product Code:	AA-1002		Product Code:	AA-1006 		Item Name:	Sample Product 2		Item Name:	Sample Product 6 		Purchase Price (per unit):	$   212.00		Purchase Price (per unit):	$   82.00 		Quantity in Stock:	2		Quantity in Stock:	12 		Product Code:	AA-1003		Product Code:	AA-1007 		Item Name:	Sample Product 3		Item Name:	Sample Product 7 		Purchase Price (per unit):	$   798.00		Purchase Price (per unit):	$   221.00 		Quantity in Stock:	16		Quantity in Stock:	5 		Product Code:	AA-1004		Product Code:	AA-1008 		Item Name:	Sample Product 4		Item Name:	Sample Product 8 		Purchase Price (per unit):	$   15.00		Purchase Price (per unit):	$   324.00 		Quantity in Stock:	3		Quantity in Stock:	8 Staff Commissions 		Staff Member Name	Sales Figures  excluding GST 		Low, Stephanie	$   3,970.00 		Widdom, Rebecca	$   5,001.00 		Windam, Margaret	$   4,085.00 		Micco, Paulo	$   2,300.00 		Song, Brenda	$   6,218.00 		Bach, Robert	$   2,999.00 		Sales Amount	Commission Rate 		Under $3000.00	15% 		$3000.00 to $4499.00	20% 		$4500.00 to $5499.00	25% 		$5500.00 or higher	30% New Invoice Template

Yash · Accepted Answer

Solution 1
Some of the advanced features of excel were as follows:
1.) Vlookup
This capacity assists with looking through an incentive in a table. It restores a relating esteem. All in all, it looks for the given worth and returns a coordinating an incentive from another section. 
Syntax of the Vlookup is VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
In the above language structure, lookup_value is the incentive to look for. It very well may be text, date or number. Table_array is at least two information sections. Col_index_num is the segment number in table_array from which the incentive in the similar line ought to be returned.
2.) IFERROR Function
On the off chance that you are in the field of information examination,

Trial Balance 1-6-XX Kennedy Tax and Business Services 4/207 Barkly St, Footscray VIC 3011 XXXXXXXXXX ABN: XXXXXXXXXX Financial Year:2019 Trial Balance as at: 01-Jun- 2019 Account NameAccount No.Dr...

Answer To: Trial Balance 1-6-XX Kennedy Tax and Business Services 4/207 Barkly St, Footscray VIC 3011...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment