how do you go about the adjusting, closing and the ledger?

A B C 1. The unadjusted trial balance has been entered on a 10 -column end-of-period spreadsheet (work sheet) for you. Complete the spreadsheet using the following adjustment data a Physcial inventory count on June 30 b Store supplies used during the month. c Insurance expired during the Month d Depreciation for the current month e Accrued salaries on June 30: Sales salaries Office salaries Total Amount $570,000 1,000 1,200 1,150 $5,600 4,500 10,100 f The adjustment for customer returns and allowances is $4,500 for sales with $2,600 in related cost of goods sold. g The Company uses the percent of credit sales method of estimated uncollectible accounts exnense. Based on nast historv and industrv averapes. 2% of credit sales are f The adjustment for customer returns and allowances is $4,500 for sales with $2,600 in related cost of goods sold g The Company uses the percent of credit sales method of estimated uncollectible accounts expense. Based on past history and industry averages, 2% of credit sales are expected to be uncollectible. 2. Journalize the adjusting entries. Post the adjusting entries to the general Ledger 3. Prepare a multiple-step income statement. 4. Prepare a statement of stockholders' equity. 5. Prepare a balance sheet. Report receivables net of the allowance as demonstrated on page 428 of the text. 5. Journalize the closing entries. Then post the closing entries to the general ledger. 7. Prepare a post-closing trial balance. (bonus points) C8 263938 GENERAL LEDGER ACCOUNT: Cash ACCOUNT NO: 110 \begin{tabular}{|c||} \hline POST \\ REF. \\ \hline \\ \hline \end{tabular} \begin{tabular}{|c||c|c|c|} \hline \multirow{2}{*}{ DEBIT } & CREDIT & \multicolumn{2}{|c|}{ BALANCE } \\ \cline { 3 - 4 } & DEBIT & CREDIT \\ \hline & & & \\ \hline & & 123,525.00 & \\ \hline & & & \\ \hline & & & \\ \hline \end{tabular} ACCOUNT: Accounts Receivable ACCOUNT NO: 112 \begin{tabular}{|c|c|c|} \hline \multicolumn{2}{|c|}{ DATE } \\ \hline 2023 & & \\ \hline June & 30 & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} ACCOUNT: Allowance for Uncollectible Accounts ACCOUNT NO: 113 ACCOUNT: Prepaid Insurance ACCOUNT NO: 117 \begin{tabular}{|c|c|c|c|} \hline DATE & & \\ \hline 2023 & & \\ \hline June & 30 & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|c} \hline POSTREF. \\ \hline \\ \hline \end{tabular} ACCOUNT: Store Supplies ACCOUNT NO: 118 Store Equipment ACCOUNT NO: 123 COOUN: Accumulated Depreciation, Store Equipment ACCOUNT NO: 124 ACCOUNT NO: ACCOUNT NO: ACCOUNT NO: ACCOUNT: Advertising Expense ACCOUNT NO: 521 \begin{tabular}{|l|l|l|c||c||} \hline DATE & & ITEM & POST \\ \hline 2023 & & & REF. & DEBIT \\ \hline June & 30 & Balance & c \\ \hline & & & & \\ \hline & & & - \\ \hline \end{tabular} CREDIT \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ BALANCE } \\ \hline DEBIT & CREDIT \\ \hline 24,000.00 & \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} ACCOUNT: Depreciation Expense ACCOUNT NO: 522 DEBIT BALANCE \begin{tabular}{|l|l|l|} \hline DATE \\ \hline & & \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} ACCOUNT NO: 523 Store Supplies Expense \begin{tabular}{|c|c|c|} \hline POSTREF. & DEBIT \\ \hline & CREDIT \\ \hline & \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ BALANCE } \\ \hline DEBIT & CREDIT \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} ACCOUNT: Miscellaneous Selling Expense ACCOUNT NO: 529 POST BALANCE Coffee Creek Co For the month ended June 30, 2023 elling expenses: Sales Salaries Expense Advertising Expense Depreciation Expense Store Supplies Expense Miscellaneous Selling Expense Total selling expenses idministrative expenses: Office Salaries Expense Rent Expense Insurance Expense Miscellaneous Administrative Expense Bad Debt Expense Total administrative expenses Total expenses Net income A B C 1. The unadjusted trial balance has been entered on a 10 -column end-of-period spreadsheet (work sheet) for you. Complete the spreadsheet using the following adjustment data a Physcial inventory count on June 30 b Store supplies used during the month. c Insurance expired during the Month d Depreciation for the current month e Accrued salaries on June 30: Sales salaries Office salaries Total Amount $570,000 1,000 1,200 1,150 $5,600 4,500 10,100 f The adjustment for customer returns and allowances is $4,500 for sales with $2,600 in related cost of goods sold. g The Company uses the percent of credit sales method of estimated uncollectible accounts exnense. Based on nast historv and industrv averapes. 2% of credit sales are f The adjustment for customer returns and allowances is $4,500 for sales with $2,600 in related cost of goods sold g The Company uses the percent of credit sales method of estimated uncollectible accounts expense. Based on past history and industry averages, 2% of credit sales are expected to be uncollectible. 2. Journalize the adjusting entries. Post the adjusting entries to the general Ledger 3. Prepare a multiple-step income statement. 4. Prepare a statement of stockholders' equity. 5. Prepare a balance sheet. Report receivables net of the allowance as demonstrated on page 428 of the text. 5. Journalize the closing entries. Then post the closing entries to the general ledger. 7. Prepare a post-closing trial balance. (bonus points) C8 263938 GENERAL LEDGER ACCOUNT: Cash ACCOUNT NO: 110 \begin{tabular}{|c||} \hline POST \\ REF. \\ \hline \\ \hline \end{tabular} \begin{tabular}{|c||c|c|c|} \hline \multirow{2}{*}{ DEBIT } & CREDIT & \multicolumn{2}{|c|}{ BALANCE } \\ \cline { 3 - 4 } & DEBIT & CREDIT \\ \hline & & & \\ \hline & & 123,525.00 & \\ \hline & & & \\ \hline & & & \\ \hline \end{tabular} ACCOUNT: Accounts Receivable ACCOUNT NO: 112 \begin{tabular}{|c|c|c|} \hline \multicolumn{2}{|c|}{ DATE } \\ \hline 2023 & & \\ \hline June & 30 & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} ACCOUNT: Allowance for Uncollectible Accounts ACCOUNT NO: 113 ACCOUNT: Prepaid Insurance ACCOUNT NO: 117 \begin{tabular}{|c|c|c|c|} \hline DATE & & \\ \hline 2023 & & \\ \hline June & 30 & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|c} \hline POSTREF. \\ \hline \\ \hline \end{tabular} ACCOUNT: Store Supplies ACCOUNT NO: 118 Store Equipment ACCOUNT NO: 123 COOUN: Accumulated Depreciation, Store Equipment ACCOUNT NO: 124 ACCOUNT NO: ACCOUNT NO: ACCOUNT NO: ACCOUNT: Advertising Expense ACCOUNT NO: 521 \begin{tabular}{|l|l|l|c||c||} \hline DATE & & ITEM & POST \\ \hline 2023 & & & REF. & DEBIT \\ \hline June & 30 & Balance & c \\ \hline & & & & \\ \hline & & & - \\ \hline \end{tabular} CREDIT \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ BALANCE } \\ \hline DEBIT & CREDIT \\ \hline 24,000.00 & \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} ACCOUNT: Depreciation Expense ACCOUNT NO: 522 DEBIT BALANCE \begin{tabular}{|l|l|l|} \hline DATE \\ \hline & & \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} ACCOUNT NO: 523 Store Supplies Expense \begin{tabular}{|c|c|c|} \hline POSTREF. & DEBIT \\ \hline & CREDIT \\ \hline & \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ BALANCE } \\ \hline DEBIT & CREDIT \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} ACCOUNT: Miscellaneous Selling Expense ACCOUNT NO: 529 POST BALANCE Coffee Creek Co For the month ended June 30, 2023 elling expenses: Sales Salaries Expense Advertising Expense Depreciation Expense Store Supplies Expense Miscellaneous Selling Expense Total selling expenses idministrative expenses: Office Salaries Expense Rent Expense Insurance Expense Miscellaneous Administrative Expense Bad Debt Expense Total administrative expenses Total expenses Net income