I have to use excel for this

Below are the transactions for November 2022, for The Widget Company. Owner, Marla James has asked you the office manager to record the transactions into the correct journal. She has supplied you with the following journals, General Journal, Sales Journal, Cash Receipts Journal, Purchase Journal and Cash Payments Journals

Transactions for November:

Nov 1 - Marla James invested $ 12,500 in the card store.

Nov 1 - Paid this months' rent to Howard Realty, cheque No. 1001 $2,800.

Nov 1 - Purchased merchandise from Upper-Card Company on account, $ 5,600. Invoice No. 710, dated Nov 1, terms 2/10, n/30.

Nov 2 - Sold merchandise to Jas Investors on account, $ 1,900. Invoice No. 602, terms 2/10, n/30. Cost of Goods sold was $1,100.

Nov 9 - Sold merchandise to Los Cabos on account, $ 1,000. Invoice No. 603, terms 2/10, n/30. Cost of Goods Sold was $550.

Nov 10 - Paid Able Cleaning Service $ 320. Cheque No. 1002.

Nov 11 - Paid UpperCard Company invoice No. 710, dated May 1, cheque No. 1003, taking discount.

Nov 12 - Los Cabos returned merchandise that cost $ 100 to the Widget Company. Marla issued credit memorandum No. 1 to Los Cabos for $ 100. All goods were returned to inventory, the cost of the goods returned was $26.

Nov 12 - Purchased merchandise from Kaelynn Imports on account, $ 4,600. Invoice No. 311, dated Nov 12, terms 1/15, n/60.

Nov 14 - Sold $ 1,800 worth of card merchandise for cash. Invoice No. 604. Cost of goods sold was $875.

Nov 15 - Returned merchandise to Kaelynn Imports in the amount of $ 1,300. The Widget Company issued debit memorandum No. 1 to Kaelynn Imports.

Nov 16 - Received payment from Los Cabos, invoice No. 603 (less returned merchandise), less discount.

Nov 16 - Jas Investors paid invoice No. 602, no discount.

Nov 23 - Paid Kaelynn Imports balance owed, cheque No. 1004, less returns and discounts.

Nov 28 - Received invoice $1,300 from Able Cleaning service, for cleaning the basement of the building. Invoice # 148 to be paid in 30 days.

Nov 30 - Marla made cheque No. 1005 payable to her sons school for tuition in amount of $2,000.

Chart of Accounts
Assets			Revenue
101	Cash		400	Sales
104	Accounts Receivable		401	Sales Discounts
106	Inventory		404	Sales Returns and Allowances
Liabilities			Expenses
204	Accounts Payable		500	Maintenance Expense
			505	Cost of Goods Sold
Owners Equity			520	Rent Expense
300	M. James, Withdrawals
301	M James, Capital

Required:

Part A - Journalize the transactions for the month of November in the correct journal. (Explanations are not required on any entry in the general journal).

Part B - Total Each Column of Each Journal as required.

Part C - Provide Posting references as if each entry had been posted. The Chart of Accounts will assist with this part.