Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help woth the highlighted boxes. this is all the given information begin{tabular}{|c|c|c|c|c|c|c|} hline multirow{3}{*}{begin{tabular}{|c|} Account: Date 2023 end{tabular}} & multicolumn{3}{|l|}{ Cash
please help woth the highlighted boxes. this is all the given information
\begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow{3}{*}{\begin{tabular}{|c|} Account: \\ Date \\ 2023 \\ \end{tabular}} & \multicolumn{3}{|l|}{ Cash } & \multirow{3}{*}{ CR } & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{l|} GL No: 101 \\ Balance (DR or CR) \end{tabular}}} \\ \hline & Description & PR & DR & & & \\ \hline & Opening Balance & & & & 29,920 & DR \\ \hline 1-Nor & & & 14,600 & & 44,520 & DR \\ \hline 1 -NOV & & & & 15,000 & 29,520 & DR \\ \hline 1NOV & & & & 5200 & 24,320 & DR \\ \hline 2NaV & & & 32,500 & & 56.820 & DR \\ \hline 15 - NaV & & & & 9.200 & 47,620 & DR \\ \hline 18 -Nov & & & 5,900 & & 53,520 & DR \\ \hline 23 -NoV & & & & 9.110 & 62630 & DR \\ \hline 26NoV & & & 31,450 & & 94080 & DR \\ \hline 28NoV & & & & 7540 & 86540 & DR \\ \hline 29Nor & & & & 8000 & 78540 & DR \\ \hline 30NOV & & & & 578 & 77962 & DR \\ \hline \end{tabular} Quest Cruise is a travel agency that offers international and local travel packapes. The company is owned and operated by Gray Pelletier. The closirg balances at the end of October 2023 and the chart of accounts are shown below. \begin{tabular}{|c|c|c|c|c|c|c|} \hline Account: & Accounts Payable & & & & & \\ \hline Date & Description & & & & Batance(GLNoI & (OR or CH ) \\ \hline 2023 & \begin{tabular}{l} Oeticription \\ Opering Balance \end{tabular} & PR & DR & CR & Balance (5 & CR \\ \hline 5NOV & gunce & & & & 11.500 & CRCB \\ \hline 15NoV & & & & 12.450 & 23950 & CRCB \\ \hline 20NOV & & & 9200 & & 14750 & CRCR \\ \hline & & & & & 15,745 & ER \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{|c|} Ascount: \\ Date \\ \end{tabular}} & \multicolumn{3}{|l|}{ Interest Payable } & & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{l} GL No: 205 \\ Batance (OR or CR ) \end{tabular}}} \\ \hline & Description & PA & OR & CH & & \\ \hline 2027 & Opening Balance & & & & 0 & CR \\ \hline 30 Noul & Advostment & & & 210 & 210 & CR \\ \hline & & & & & & \\ \hline & & & & & = & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{|c|} Account: \\ Date \\ \end{tabular}} & \multicolumn{3}{|l|}{ Salary Payable } & \multirow{3}{*}{CR} & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{l} GL No: 210 \\ Balance (OR or CR ) \end{tabular}}} \\ \hline & Description & PR & DR & & & \\ \hline 2023 & Opening Balance & & & & 0 & \\ \hline 301604 & Adjustiment & & & 4555 & 4,555 & CR \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline- & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline Account: Unearned Revenue & Description & PR & DR & CR & \multicolumn{2}{|c|}{ Balance (DR or CR) } \\ \hline Date & Os No: 21S \\ \hline 2073 & Opening Bolance & & & & 9000 & \\ \hline 26NoV & & & & 31456 & 40450 & \\ \hline 30NOV & & & & 6300 & 34150 & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline Account: Bank Loan & PR & DR & CR & \multicolumn{2}{|c|}{ Btalance (OR or CR) } \\ \hline Date & Description & & & & 27.000 & CR \\ \hline 2023 & Opening Balance & & 375 & & 26625 & CR \\ \hline 30NOV & & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{|c|} Account: \\ Date \\ \end{tabular}} & \multicolumn{3}{|l|}{ Note Payable } & \multirow{2}{*}{CH} & \multirow{2}{*}{\multicolumn{2}{|c|}{Balance(DRorCR)GLNos225}} \\ \hline & Description & Ph & DR & & & \\ \hline 2023 & Opening Bslance & & & & 0 & CR \\ \hline \multirow{2}{*}{\multicolumn{7}{|c|}{2NOV}} \\ \hline & & & & & & \\ \hline Account: & \multicolumn{3}{|l|}{ Pelletier, Capital } & & ohint. & \\ \hline Date & Description & PQ & DR & CR & \multicolumn{2}{|c|}{ Balance (DR or Ch) } \\ \hline 2023 & Opening Balance & & & & 22720 & ICR \\ \hline 1Mor & & & & 29600 & 52320 & \\ \hline 30NOO & Closing contry & & & & & \\ \hline 30100 & Closing extry & & & & & \\ \hline \end{tabular} At the end of November, the following adjustment had to be journalized to properly report the balances of th company's accounts: Required: a) Enter the opening balances from the October 2023 balance sheet into the general ledger accounts. b) Prepare the journal entries for the month of November and post them to the appropriate general ledger accounts. c) Create the trial balance in the worksheet, and then complete the remaining section of the worksheet taking into account the information for adjustments shown above. d) Create the income statement, statement of owner's equity and the classified balance sheet. e) Prepare the journal entries for the adjustments and post them to the appropriate general ledger accounts. f) Prepare the journal entries to close the books for the month of November 2023 (use the income summary account), and post the journal entries to the appropriate general ledger accounts. g) Create the post-closing trial balance. \begin{tabular}{|c|c|c|c|c|c|c|} \hline Account: & Pelletier, Withdrawals & & & & GLNo: & \\ \hline Date & Description & PR & DR & CR & Balance & Deror(R) \\ \hline 2023 & t & & & & & \\ \hline 29Nor & & & 8000 & & 3000 & 0R \\ \hline 30Nav & Closing Entry & & & 8000 & 0 & DR \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account: & Income Summary & & & & GL No: 315 \\ \hline Date & Description & PR & DR & CR & Balance (DR or CR ) \\ \hline 2023 & & & & & \\ \hline 30NoW & Cocsing Entry & & & & \\ \hline 30NOW & Crosing Entry & & & & \\ \hline 30NCW & closing Entry & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account: & Service Revenue & & & & GL No: 4C0 \\ \hline Date & Description & PR & DR & CR & Ealunce (DR or CR ) \\ \hline 2023 & & & + & & \\ \hline 2Nov & & & . & & \\ \hline 30NOU & & & & & \\ \hline 30Na & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account: & Advertising Expense & & & & GLNo: \\ \hline Date & Description & PR & DR & CR & Balance (DR or CR) \\ \hline 2023 & & & & & \\ \hline 28kON & & & & & \\ \hline 3ONON & Closing Entry & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{|c|} Account: \\ Date \\ \end{tabular}} & \multicolumn{3}{|l|}{ Depreciation Expense } & \multirow[b]{2}{*}{ CR } & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{l} GL No: \\ Balance (OR or CR) \end{tabular}}} \\ \hline & Description & PR & DR & & & \\ \hline 2073 & & & & & & \\ \hline 30NON & Advostment & & 1440 & & 01410 & DRDR \\ \hline 30NOV & Closing Entry & & & 1440 & 0 & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{|c|} Account: \\ Date \\ \end{tabular}} & \multicolumn{3}{|l|}{ Insurance Expense } & \multirow[b]{2}{*}{CR} & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{l} Ga Nos \\ Balance (OR or CR) \end{tabular}}} \\ \hline & Description & PR & DR & & & \\ \hline 2023 & & & & & & \\ \hline 30NON & & & 1250 & & 1250 & DR \\ \hline 30NO & Orosing fatry & & 8= & 1250 & 0 & DE \\ \hline & & & & & & \\ \hline \end{tabular} Step 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