Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Who could help me with the first part of my task?The first part is Journalize Transactions. A ll information is attached. I will give good
Who could help me with the first part of my task?The first part is Journalize Transactions. All information is attached.
I will give good tip for good job.
PART 1 - Journalize Monthly Transactions 1) Record the transactions for the month in the special journals and general journal as applicable. Notes: - Get Out posts daily to the A/R and A/P subsidiary ledger accounts and to the general ledger accounts for any amounts entered in the 'Other' column. - General journal entries are posted daily - HST is charged on both purchases and sales at 13%. Be sure to calculate and record HST on each sale and purchase. - Use the Inventory Valuation tab to calculate inventory values (Perpetual Inventory Systems, FIFO). Cost of Goods Sold for each transaction will be derived from this tab. Make sure to update this tab for EVERY sale and EVERY purchase. Note that discounts on inventory purchases and returns will also need to be updated. SPECIAL NOTES Both the Payroll and HST remitances will use the opening balances from the beginning of the month. Case: Get Out Get Out Get Out sells outdoor sporting equipment. You have been working for the company since its inception a few years ago and have been promoted to be their accounting manager. They use the perpetual inventory system and use FIFO to determine value for The opening balances for the month of September are as follows: Get Out Balance Sheet As at September 30, 2017 Assets Liabilities Cash $12,000 Accounts Payable Accounts Receivable 52,100 HST Payable Allowance for Doubtful Accounts -900 HST Recoverable Inventory 14,880 CPP Payable Office Supplies 800 EI Payable Equipmen t 108,000 Income Tax Payable Accumulated Depreciation -12,400 Bank Loan Total Liabilities Owners' Equity Smith, Capital Total Assets $174,480 Total Liabilities & Owners' Equity $32,400 9,800 -4,600 1,250 650 2,900 20,000 $62,400 $112,080 $174,480 Notes Relating to Balances: Customers and balances Woodsman Bill Outback Karen Moose Time Hiker Mike Dark Forest Total $28,000 $13,500 $8,500 $1,200 $900 $52,100 The inventory figure includes 310 units purchased at $48 each. 14880 310 48 Suppliers and Balances Outdoor T-Shirts Hiking Caps Camping Retailers Total $15,900 $12,300 $4,200 $32,400 The Chart of Accounts (GL no.) is shown below: Account Description Account # ASSETS Cash 101 Petty Cash 105 Accounts Receivable 110 Allowance for Doubtful Accounts 115 Inventory 120 Prepaid Insurance 125 Office Supplies 130 Equipmen t 140 Accumulated Depreciation 145 LIABILITIES Accounts Payable 200 Interest Payable 205 HST Payable 210 HST Recoverable 215 CPP Payable 220 EI Payable 225 Income Tax Payable 230 Salaries Payable 235 Unearned Revenue 240 Bank Loan 245 OWNER'S EQUITY Capital Account 300 Owner's Drawings 305 Income Summary 315 Account Description REVENUE Sales Revenue Sales Discounts Sales Returns and Allowances Interest Revenue EXPENSES Cost of Goods Sold Employee Benefits Expense Depreciation Expense Insurance Expense Interest Expense Office Supplies Expense Rent Expense Salaries Expense Bank Charges Expense Maintenance Expense Entertainment Expense Account # 400 405 410 420 500 510 515 520 525 530 535 540 545 550 555 Transactions for the month of October: 170 50 100 95 60 95 142 4565 Bought inventory from Outdoor T-Shirts on account, invoice #5455; 340 units at $48 each plus HST. Terms of the Oct 1 purchase were 4/10, net 30. Update the inventory table after each purchase. Oct 1 Paid $2,300 for monthly rent with cheque #142. Oct 1 Established a petty cash fund for $400 with cheque #143. Sold goods to Outback Karen, 320 units at $95 each plus HST with invoice #4565. The invoice terms were 5/10, Oct 2 net 30. Update the inventory table after each sale. Oct 3 Purchased a one year insurance policy from Ultimate Insurance with cheque #144 for $3,600. Oct 4 The owner invested $10,000 cash into the company. Oct 5 Paid $5,200 with cheque #145 to Outdoor T-Shirts for an amount owing from last month. Oct 5 Bought inventory from Camping Retailers with cheque #146, 170 units at $50 per unit plus HST. Outback Karen returned 30 units from the purchase on October 2. They were ordered incorrectly. Use the cost Oct 7 from the October 1 purchase to put the items back in inventory. Oct 7 Returned 25 defective units to Camping Retailers and received cash. Record this in the general journal. Oct 8 Received $4,100 from Woodsman Bill for a sale on account last month. Oct 9 Made a cash sale to Woodsman Bill, 60 units at $95 per unit plus HST. Oct 10 Oct 12 Oct 13 Oct 14 Oct 14 Oct 15 Oct 15 Oct 16 Outback Karen paid invoice #4565 on time and took advantage of the early payment discount. The owner went to the bank and received a $14,000 loan. Purchased new equipment with cheque #147 for $12,000 plus HST. Paid $6,200 with cheque #148 to Hiking Caps for an amount owing from last month. Remitted the balance of CPP, EI and income tax owing from the beginning of the month to the receiver general with cheque #149. Paid the amount owing to Outdoor T-Shirts on invoice #5455 with cheque #150. Prepared the payroll for the first half of the month. Gross pay is $7,000, CPP is $347, EI is $132 and income tax is $1,400. The employer matches CPP contributions and pays 1.4 times the EI deduction. Use the general journal Purchased office supplies for $1,100 plus HST with cheque #151 from Staplers Supplies. Oct 16 Oct 17 Oct 18 Oct 20 Oct 25 Oct 26 Oct 26 Oct 27 Oct 29 Oct 29 Oct 30 Oct 30 Oct 31 Oct 31 Oct 31 Adjustments Oct 31 Oct 31 Oct 31 Oct 31 Oct 31 Paid the employees the net pay from the payroll transaction on October 15. For simplicity, use cheque #152 for the total amount. Received $4,800 from Outback Karen for a sale last month. Purchased inventory on account from Camping Retailers. Invoice #6235; 200 units at $50 each plus HST. Terms of purchase 2/10,Mike net 30. Sold goodswere to Hiker on account. Sold 70 units at $100 per unit plus HST with invoice #4566. The invoice terms wereinventory 5/10, neton 30.account from Hiking Caps. Invoice #4528; 110 units at $50 each plus HST. Terms of Purchased purchase wereRetailers 2/10, netthe 30.amount owing from the purchase on October 18 and took advantage of the early Paid Camping payment discount. Paid with cheque #153. Update the inventory table to apply the discount as a reduction to Sold goods to Moose Time on account. Sold 470 units at $95 per unit plus HST with invoice #4567. The invoice terms were 5/10, net 30. Received $1,300 cash from Moose Time as a deposit for products that will be delived next month. The owner withdrew $3,100 cash from the business with cheque #154 for personal use. Hiker Mike paid the amount owing from the sale on October 20 and took advantage of the early payment discount. The petty cash is replenished and increased to $500 with cheque #155. Receipts in the petty cash box are: office supplies $70 plus HST, maintenance expense for $120 plus HST and entertainment expense for $140 plus HST. Sold goods to Moose Time for 100 units at $95 per unit plus HST. Moose Time paid cash. Prepared the payroll for the second half of the month. Gross pay is $7,500, CPP is $371, EI is $141 and income tax is $1,500. The employer matches CPP contributions and pays 1.4 times the EI deduction. Use the general Dark Forest is unable to pay the amount owing. The full amount owing is written off using the AFDA account. Remitted the HST owing to the receiver general with cheque #156. Use the balances from the HST accounts from the beginning of the month Accrued the amount of interest owing on the bank loan for the month. The interest rate is 3% per annum. One month of insurance has been used. A count of office supplies shows that $650 is left on hand. A physical count of inventory shows that 5 are missing. Adjust the inventory values based on the missing inventory. Record straightline depreciation on the equipmentfor the month. All equipment purchased is expected to last 5 years and have no residual value at the end of its useful lifeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started