90.2K

Verified Solution

Link Copied!

Please Reply ASAP

Insert Draw Page Layout Formulas Data Review View Automate Q Tell n \begin{tabular}{|l|l|l|l|l|l|l|} \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account - & Telephone Experse & & & & GLNo: \\ \hline Date & Deveription & PR & DR & CR & Bolance (DRCR ) \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account: & Travel Expense & & & & GLNos: \\ \hline Date & Description & PR & DR & CR & Balance (DR or CR) \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account & Rent Expense & & & & Q.NO: \\ \hline Oonte & Description & ph & DR & CR & Balance (DR or CR) \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} At the end of November, the following adjustment had to be joumalized to properly report the balances of the 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. Adjustment Add header Quest Cruise is a travel agency that offers international and local travel packages. The company is owned and operated by Gray Pelletier. The closing balances at the end of October 2023 and the chart of accounts are shown below. Insert Draw Page Layout Formulas Data Review View Automate Q Tell n \begin{tabular}{|l|l|l|l|l|l|l|} \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account - & Telephone Experse & & & & GLNo: \\ \hline Date & Deveription & PR & DR & CR & Bolance (DRCR ) \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account: & Travel Expense & & & & GLNos: \\ \hline Date & Description & PR & DR & CR & Balance (DR or CR) \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account & Rent Expense & & & & Q.NO: \\ \hline Oonte & Description & ph & DR & CR & Balance (DR or CR) \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} Closing entries =fx \begin{tabular}{|c|c|c|c|c|c|c|} \hline Accounte & Income Summary & DR & DR & CR & \multicolumn{2}{|c|}{ GL.No: } \\ \hline Datance (DR or CR) \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline Account Service Revenve & Description & PR & DR & CR & \multicolumn{1}{|c|}{ GL No: } \\ \hline Date & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account: & Advertising Expense & & & & GLNo: \\ \hline Date & Description & PR & OR & CR & Balance (DR or CR ) \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & 2 & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline Account - & Depreclation Expense & & & & & \\ \hline Date & Description & PR & DR & Cr & & brace (OR or OR ) \\ \hline & & & & & & \\ \hline & & & & & . & \\ \hline & & & & - & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account & Imaurance Expense & & & & GLNo: \\ \hline Oate & Description & PQ & OR & CA & Balunce (OR or CR ) \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} Add footer Add header D. ACCT1100 Individual Assignment at Fall 20 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline Insert & Draw & Page Layou: & & Formulas & Data & Review & View & Automate 8 Tell & & \\ \hline=x & Calibri (Body) & v & & AA & & = & . & ib Wrap Text * & General & \\ \hline 8 & B I y & B* & . & AA. & & & & Merge s Center v & $.%, & +28 th \\ \hline \end{tabular} xfx Add header \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{11}{|c|}{ Quenciven } \\ \hline \multirow{2}{*}{\multicolumn{11}{|c|}{\begin{tabular}{l} Wertsiteet \\ November 30, , 2013 \end{tabular}}} \\ \hline & & & & & & & & & & \\ \hline & & \multicolumn{2}{|c|}{ Muntmane } & \multicolumn{2}{|c|}{ Adinted Trat toberen } & \multicolumn{2}{|c|}{ ivame statument } & \multicolumn{2}{|c|}{ Balunse Sheet } \\ \hline Actiont Tiven & on & a & & an & ba & or & on & a & on & a \\ \hline \multicolumn{11}{|l|}{ oinh } \\ \hline \multicolumn{11}{|l|}{ Lomons Recriable } \\ \hline \\ \hline \multirow{2}{*}{\multicolumn{11}{|c|}{ Coionemt }} \\ \hline & \\ \hline Amanth Reritie & & & & & & & & & & x2 \\ \hline interst propter & & & & & & & & & +2 & +2 \\ \hline Solary Ferald & & & & & & & & & & +2 \\ \hline Unemed keverien & & & & 1 & & & & & & +2 \\ \hline \multicolumn{11}{|l|}{ Barkloge } \\ \hline \multicolumn{11}{|l|}{ hationate } \\ \hline Notrter open & & % & & & & & & & & E \\ \hline \\ \hline \\ \hline Robvitting Expenue & & & & & & & & & & \\ \hline \\ \hline \multicolumn{11}{|l|}{ iminnce fipemis } \\ \hline \\ \hline Sabovilicense & & & - & & & & & +2 & -2 & = \\ \hline filephone formen & z & & & & & & & & +2 & \\ \hline \multicolumn{11}{|l|}{ Fowet Esermar } \\ \hline Gentromir & & & - & & & & & & + & = \\ \hline Gial & 2= & & & +1 & - & & & & & \\ \hline Butucient & & III & & & & = & & + & & \\ \hline Foed & & & & 2= & & & & + & 2= & = \\ \hline \end{tabular} Add footer Add header Insert Draw Page Layout Formulas Data Review View Automate P Tell me Add footer Add footer Add header Add footer Journal Insert Draw Page Layout Formulas Data Review View Automate Q Tell me fx \begin{tabular}{|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{|r|} Acrount \\ Date \\ \end{tabular}} & \multicolumn{3}{|l|}{ Cash: } & \multirow[b]{2}{*}{CR} & \multirow{2}{*}{\begin{tabular}{l} G. Ne: \\ Balance (DR or CR ) \end{tabular}} \\ \hline & Description & PR & OR & & \\ \hline & Opening Ealunce & & - & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & . & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account: & \multirow{3}{*}{\begin{tabular}{l} Accounts Recelvable \\ \begin{tabular}{|c|} \multicolumn{1}{c}{ Description } \\ Opening Balance \\ \end{tabular} \end{tabular}} & & & \multirow[b]{2}{*}{CR} & \multirow{2}{*}{\begin{tabular}{l} GL No: \\ Batance (OR or CR) \end{tabular}} \\ \hline \multirow[t]{2}{*}{ Date } & & \multirow[t]{2}{*}{PR} & \multirow[t]{2}{*}{ OR } & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline Account: & Prepaid Insurance & PR & DR & CR & \multicolumn{2}{|c|}{ Balance (DR or CR) } \\ \hline Date & Description & & & & & \\ \hline & Opening Balance & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account & Equloment: & & & \multirow{3}{*}{OR} & \multirow{2}{*}{\begin{tabular}{l} GL Ne: \\ Balance (OR or CR) \end{tabular}} \\ \hline \multirow[t]{2}{*}{ Date } & Descriptien & \multirow[t]{2}{*}{ PA } & \multirow[t]{2}{*}{DR} & & \\ \hline & Opening Balance & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account: & Actumulated Depreclation & & & & GLNe: \\ \hline Daste & Description & PR & OR & CR & Balance ( DP or CR ) \\ \hline & Openins Balance & & & & \\ \hline \end{tabular} Insert Draw Page Layout Formulas Data Review View Automate Q Tell n \begin{tabular}{|l|l|l|l|l|l|l|} \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account - & Telephone Experse & & & & GLNo: \\ \hline Date & Deveription & PR & DR & CR & Bolance (DRCR ) \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account: & Travel Expense & & & & GLNos: \\ \hline Date & Description & PR & DR & CR & Balance (DR or CR) \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account & Rent Expense & & & & Q.NO: \\ \hline Oonte & Description & ph & DR & CR & Balance (DR or CR) \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} At the end of November, the following adjustment had to be joumalized to properly report the balances of the 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. Adjustment Add header Quest Cruise is a travel agency that offers international and local travel packages. The company is owned and operated by Gray Pelletier. The closing balances at the end of October 2023 and the chart of accounts are shown below. Insert Draw Page Layout Formulas Data Review View Automate Q Tell n \begin{tabular}{|l|l|l|l|l|l|l|} \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account - & Telephone Experse & & & & GLNo: \\ \hline Date & Deveription & PR & DR & CR & Bolance (DRCR ) \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account: & Travel Expense & & & & GLNos: \\ \hline Date & Description & PR & DR & CR & Balance (DR or CR) \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account & Rent Expense & & & & Q.NO: \\ \hline Oonte & Description & ph & DR & CR & Balance (DR or CR) \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} Closing entries =fx \begin{tabular}{|c|c|c|c|c|c|c|} \hline Accounte & Income Summary & DR & DR & CR & \multicolumn{2}{|c|}{ GL.No: } \\ \hline Datance (DR or CR) \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline Account Service Revenve & Description & PR & DR & CR & \multicolumn{1}{|c|}{ GL No: } \\ \hline Date & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account: & Advertising Expense & & & & GLNo: \\ \hline Date & Description & PR & OR & CR & Balance (DR or CR ) \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & 2 & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline Account - & Depreclation Expense & & & & & \\ \hline Date & Description & PR & DR & Cr & & brace (OR or OR ) \\ \hline & & & & & & \\ \hline & & & & & . & \\ \hline & & & & - & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account & Imaurance Expense & & & & GLNo: \\ \hline Oate & Description & PQ & OR & CA & Balunce (OR or CR ) \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} Add footer Add header D. ACCT1100 Individual Assignment at Fall 20 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline Insert & Draw & Page Layou: & & Formulas & Data & Review & View & Automate 8 Tell & & \\ \hline=x & Calibri (Body) & v & & AA & & = & . & ib Wrap Text * & General & \\ \hline 8 & B I y & B* & . & AA. & & & & Merge s Center v & $.%, & +28 th \\ \hline \end{tabular} xfx Add header \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{11}{|c|}{ Quenciven } \\ \hline \multirow{2}{*}{\multicolumn{11}{|c|}{\begin{tabular}{l} Wertsiteet \\ November 30, , 2013 \end{tabular}}} \\ \hline & & & & & & & & & & \\ \hline & & \multicolumn{2}{|c|}{ Muntmane } & \multicolumn{2}{|c|}{ Adinted Trat toberen } & \multicolumn{2}{|c|}{ ivame statument } & \multicolumn{2}{|c|}{ Balunse Sheet } \\ \hline Actiont Tiven & on & a & & an & ba & or & on & a & on & a \\ \hline \multicolumn{11}{|l|}{ oinh } \\ \hline \multicolumn{11}{|l|}{ Lomons Recriable } \\ \hline \\ \hline \multirow{2}{*}{\multicolumn{11}{|c|}{ Coionemt }} \\ \hline & \\ \hline Amanth Reritie & & & & & & & & & & x2 \\ \hline interst propter & & & & & & & & & +2 & +2 \\ \hline Solary Ferald & & & & & & & & & & +2 \\ \hline Unemed keverien & & & & 1 & & & & & & +2 \\ \hline \multicolumn{11}{|l|}{ Barkloge } \\ \hline \multicolumn{11}{|l|}{ hationate } \\ \hline Notrter open & & % & & & & & & & & E \\ \hline \\ \hline \\ \hline Robvitting Expenue & & & & & & & & & & \\ \hline \\ \hline \multicolumn{11}{|l|}{ iminnce fipemis } \\ \hline \\ \hline Sabovilicense & & & - & & & & & +2 & -2 & = \\ \hline filephone formen & z & & & & & & & & +2 & \\ \hline \multicolumn{11}{|l|}{ Fowet Esermar } \\ \hline Gentromir & & & - & & & & & & + & = \\ \hline Gial & 2= & & & +1 & - & & & & & \\ \hline Butucient & & III & & & & = & & + & & \\ \hline Foed & & & & 2= & & & & + & 2= & = \\ \hline \end{tabular} Add footer Add header Insert Draw Page Layout Formulas Data Review View Automate P Tell me Add footer Add footer Add header Add footer Journal Insert Draw Page Layout Formulas Data Review View Automate Q Tell me fx \begin{tabular}{|c|c|c|c|c|c|} \hline \multirow{2}{*}{\begin{tabular}{|r|} Acrount \\ Date \\ \end{tabular}} & \multicolumn{3}{|l|}{ Cash: } & \multirow[b]{2}{*}{CR} & \multirow{2}{*}{\begin{tabular}{l} G. Ne: \\ Balance (DR or CR ) \end{tabular}} \\ \hline & Description & PR & OR & & \\ \hline & Opening Ealunce & & - & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & . & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account: & \multirow{3}{*}{\begin{tabular}{l} Accounts Recelvable \\ \begin{tabular}{|c|} \multicolumn{1}{c}{ Description } \\ Opening Balance \\ \end{tabular} \end{tabular}} & & & \multirow[b]{2}{*}{CR} & \multirow{2}{*}{\begin{tabular}{l} GL No: \\ Batance (OR or CR) \end{tabular}} \\ \hline \multirow[t]{2}{*}{ Date } & & \multirow[t]{2}{*}{PR} & \multirow[t]{2}{*}{ OR } & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|c|c|c|c|} \hline Account: & Prepaid Insurance & PR & DR & CR & \multicolumn{2}{|c|}{ Balance (DR or CR) } \\ \hline Date & Description & & & & & \\ \hline & Opening Balance & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account & Equloment: & & & \multirow{3}{*}{OR} & \multirow{2}{*}{\begin{tabular}{l} GL Ne: \\ Balance (OR or CR) \end{tabular}} \\ \hline \multirow[t]{2}{*}{ Date } & Descriptien & \multirow[t]{2}{*}{ PA } & \multirow[t]{2}{*}{DR} & & \\ \hline & Opening Balance & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Account: & Actumulated Depreclation & & & & GLNe: \\ \hline Daste & Description & PR & OR & CR & Balance ( DP or CR ) \\ \hline & Openins Balance & & & & \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer