general ledger and trial balance! Please!

ASAP

Assignment Tasks:

The first step of this assessment is to review the scenario and detailed information provided below, about a company titled Banco Extrusion Inc. All required information to complete the bookkeeping for this company using Excel is included there. Produce the following:

• you are required to complete the set of books for Banco Extrusion Inc.
• You are required to post the journal entries for the transactions listed below.
• You are required to create a general ledger and trial balance based on the journal entries.
• Ignore decimal places. Round to the nearest dollar. Use all Excel functions where reasonable.
• Record all prepaid expenses to prepaid accounts.
• You must provide a short description for each journal entry. Ignore HST unless otherwise explicitly stated

During the first month of operations, the Banco Extrusion Inc, located in Ontario Canada, which specializes in auto component manufacturing completed the following transactions.
Date
1	George Leblanc started the business by making a deposit into company bank account for $35,000, in exchange for 3,500 shares of $10 par value common stock.
1	Banco acquired a small machinist shop for $25,000 cash which represented- Computer - $5,800, Furniture, - $6,500 and Store equipment $12,700.
2	Received bank loan for $100,000, 6% annual interest. Payments are due on the last day of each month in the amount of $4,000.
2	Paid rent for the 3-month quarter January to March in the amount of $3,000 per month.
2	Paid the premium on a 1-year insurance policy, $5,000.
3	Purchased $800 in office supplies
5	Purchased inventory on account for $25,000 + 13% HST. Terms 2/10, n30.
13	Hired two full-time staff members, Lan and Liz, both who earn $36,000 a year and are paid bi-weekly beginning Jan 24.. Assume basic payroll deductions for Ontario. They work five days a week (Mon-Fri).
17	Record cash sales for the week in the amount of $10,000 + 13% HST. Cost of Goods Sold amounted to $5,500.
17	Purchased extrusion machine and equipment from Patel Inc. for $6,000. Paid $1,500 down and the balance was placed on account. Payments will be $375.00 per month for 12 months. The first payment is due Feb 1. Note: Use accounts payable for the balance due. Ignore HST and interest.
17	Record sales on account for the week in the amount of $12,000 + HST. Cost of goods sold was $8,000.
24	Paid both Lan and Liz their bi-weekly pay. Calculate deductions for CPP, EI and Ontario tax. Record employee portion only.
24	Record cash sales for the week in the amount of $15,000 + 13% HST. Cost of Goods Sold amounted to $10,000.
27	Record sales on account for the week in the amount of $15,000 + HST. Cost of goods sold was $8000.
28	Paid accounts payable in full from January 5.
30	Record collection on outstanding accounts receivable for January in the amount of $20,000 + HST.
30	Purchased inventory on account in the amount of $6,000 + HST.
30	Paid loan payment of $4,000 plus interest of $500.

Want general ledger and trial balance. Thank you!

		Journal Entries
Date	Particulars					Debit	Credit
1	Bank account Dr					35000
	to share capital						35000
	(issued 3500 shares of $10)
1	Computer Dr					5800
	Furniture Dr					6500
	Store Equipment Dr					12700
	To Cash						25000
2	bank dr					100000
	to bank loan						100000
	(taken bank loan)
2	prepaid rent dr					9000
	to bank						9000
	(prepaid rent for Jan to Mar)
2	prepaid insurance premium Dr					5000
	to bank						5000
	(prepaid insurance)
3	office supplies dr					800
	to bank						800
5	purchase dr					25000
	input HST 13% dr					3250
	to creditors						28250
17	cash dr					11300
	to sales						10000
	to output HST 13%						1300
17	extrusion machine dr					6000
	to bank						1500
	to patel inc						4500
17	debtors dr					13560
	to sales						12000
	to patel inc						1560
24	salary dr					2770
	to bank						2450
	to CPP payable						146
	to EI payable						44
	to Ontario tax payable						130
24	cash dr					16950
	to sales						15000
	to output HST 13%						1950
27	sale on account					16950
	to sale						15000
	to out put HST						1950
28	creditors dr					28250
	to bank						28250
30	bank dr					22660
	to Debtors						22660
30	Purchase dr					6000
	input HST 13%					780
	to creditors						6780
30	interest dr					500
	to bank loan dr						500
	(6% of $100000 interest ,first month)
30	bank loan dr					4000
	interest dr					500
	to bank						4500