HELP with adjusting journal. I'm having a hard time when it comes to inventory. Required: 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 Amount a Physcial inventory count on June 30 $570,000 b Store supplies used during the month. 1,000 c Insurance expired during the Month 1,200 d Depreciation for the current month 1,150 e Accrued salaries on June 30: Sales salaries $5,600 Office salaries 4,500 Total 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 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. 6. Journalize the closing entries. Then post the closing entries to the general ledger . this is how I currently have it Page: 175 DESCRIPTION "POST. REF." DEBIT CREDIT Adjusting Journal Entries cost of goods sold inventory adjustment of inventory store supplies expense 1,000.00 supplies 1,000.00 store supplies used insurance expense 1,200.00 prepaid insurance 1,200.00 adjustment to prepaid insurance depreceation expense 1,150.00 accumulated depreciation expense- equipment 1,150.00 store equipment depreciation sales salaries expense 5,600.00 office salaries expense 4,500.00 salaries payable 10,100.00 accured salaries expense sales returns and allowances 4,500.00 accounts receivable 4,500.00 customer refunds estimated returns inventrory 2,600.00 cost of goods sold 2,600.00 cost of merchandise sole

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 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 historvand industrv averages. 2% of credit sales are Problem Detail Chart of Accounts Adjusting General Journal 175 Closing General Journal 176 General Ledger Worksheet income Statement Stmt of Stackholders' Equity Balance Sheet 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. 6. Journalize the closing entries. Then post the closing entries to the general ledger . 7. Prepare a post-closing trial balance. (bonus points) GENERAL LEDGER ACCOUNT: Cash ACCOUNT NO: 110 \begin{tabular}{|l|l|l|} \hline \multicolumn{2}{|l|}{ DATE } & \\ \hline 2023 & & \\ \hline June & 30 & Balance \\ \hline & & \\ \hline \end{tabular} ACCOUNT: Accounts Receivable ACCOUNTNO: 112 \begin{tabular}{|l|l|l|l|l|} \hline DATE & HIM & POST \\ \hline 2023 & & REF. & DEBIT \\ \hline June & 30 & Balance \\ \hline & & & \\ \hline & & & \\ \hline \end{tabular} ACCOUNT: Allowance for Uncollectible Accounts ACCOUNT NO: 113 \begin{tabular}{|l|l|l|} \hline & DATE \\ \hline 2023 & & \\ \hline June & 30 & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} ACCOUNT: POST Inventory \begin{tabular}{|c|c|} \hline BALANCE \\ \hline DEBIT CREDIT & CRI,938.00 \\ \hline 260 & \\ \hline \end{tabular} CREDIT DEBIT CREDIT Problem Detail Chart of Accounts Adjusting General journal 175 closing General journal 175 General Ledger Wrkshee ACCOUNT NO: 118 \begin{tabular}{|c|c||c|c||c|} \hline \multicolumn{1}{|c|}{ DATE } & & ITEM & POSTREF. & DEBIT \\ \hline 2023 & & & & \\ \hline June & 30 & Balance & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & \\ \hline \end{tabular} \begin{tabular}{|c|r|} \hline \multicolumn{2}{|c|}{ BALANCE } \\ \hline DEBIT & CREDIT \\ \hline & \\ \hline 9,850.00 & \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} ACCOUNT: Store Equipment ACCOUNT NO: 123 A B B C ACCOUNT: \begin{tabular}{|l|l|l|} \hline DATE & & \\ \hline 2023 & & \\ \hline June & 30 & Balance \\ \hline & & ITM \\ \hline & & \\ \hline \end{tabular} Advertising Expense Depreciation Expense ACCOUNT NO: 521 G H ACCOUNTNO: 522 ACCOUNT: \begin{tabular}{|c|c|} \hline POSTREF. & DEBII \\ \hline & \\ \hline \end{tabular} ACCOUNT: Store Supplies Expense ACCOUNT NO: 523 \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ DATE } \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} \begin{tabular}{|c|} \hline POST \\ \hline REF. \\ \hline \\ \hline \end{tabular} ACCOUNT: Miscellaneous Selling Expense ACCOUNT NO: 529 POST BALANCE ACCOUNT: Miscellaneous Selling Expense ACCOUNT NO: 529 \begin{tabular}{|l|} \hline POST \\ REF. \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ BALANCE } \\ \hline DEBIT & CREDIT \\ \hline & \\ \hline 1,050.00 & \\ \hline & \\ \hline & \\ \hline \end{tabular} ACCOUNT: Office Salaries Expense ACCOUNT NO: 530 \begin{tabular}{|c|c|c|l|} \hline 68 & & & \\ \hline 69 & \multicolumn{1}{|c||}{ DATE } & \multicolumn{2}{|c|}{ ITEM } \\ \hline 70 & 2023 & & \\ \hline 71 & June & 30 & Balance \\ \hline 72 & & & \\ \hline 73 & & & \\ \hline 75 & & & \\ \hline 0 & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline POSTREF. \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} Rent Expense ACCOUNTNO: BALANCE 77 ACCOUNT: ITEM BALANCE \begin{tabular}{|c|c|c|} \hline \multicolumn{2}{|c|}{ DATE } & \multicolumn{2}{|c|}{ ITEM } \\ \hline 2023 & & \\ \hline June & 30 & Balance \\ \hline & & \\ \hline & & \\ \hline \end{tabular} DEBIT CREDIT \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ BALANCE } \\ \hline DEBIT & CREDIT \\ \hline 7,390.00 & \\ \hline & \\ \hline & \\ \hline \end{tabular} ACCOUNT: Insurance Expense ACCOUNT NO: 532 Statement of f tockholders Equity For the month ended June 30, 2023 Beginning balance June 1, 2023 Issuance of common stock Add: Net income (or Less: Net loss) Less: Dividends Ending balance June 30, 2023 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Total Common stock Retained Stockholders' Earnings Equity 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 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 historvand industrv averages. 2% of credit sales are Problem Detail Chart of Accounts Adjusting General Journal 175 Closing General Journal 176 General Ledger Worksheet income Statement Stmt of Stackholders' Equity Balance Sheet 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. 6. Journalize the closing entries. Then post the closing entries to the general ledger . 7. Prepare a post-closing trial balance. (bonus points) GENERAL LEDGER ACCOUNT: Cash ACCOUNT NO: 110 \begin{tabular}{|l|l|l|} \hline \multicolumn{2}{|l|}{ DATE } & \\ \hline 2023 & & \\ \hline June & 30 & Balance \\ \hline & & \\ \hline \end{tabular} ACCOUNT: Accounts Receivable ACCOUNTNO: 112 \begin{tabular}{|l|l|l|l|l|} \hline DATE & HIM & POST \\ \hline 2023 & & REF. & DEBIT \\ \hline June & 30 & Balance \\ \hline & & & \\ \hline & & & \\ \hline \end{tabular} ACCOUNT: Allowance for Uncollectible Accounts ACCOUNT NO: 113 \begin{tabular}{|l|l|l|} \hline & DATE \\ \hline 2023 & & \\ \hline June & 30 & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} ACCOUNT: POST Inventory \begin{tabular}{|c|c|} \hline BALANCE \\ \hline DEBIT CREDIT & CRI,938.00 \\ \hline 260 & \\ \hline \end{tabular} CREDIT DEBIT CREDIT Problem Detail Chart of Accounts Adjusting General journal 175 closing General journal 175 General Ledger Wrkshee ACCOUNT NO: 118 \begin{tabular}{|c|c||c|c||c|} \hline \multicolumn{1}{|c|}{ DATE } & & ITEM & POSTREF. & DEBIT \\ \hline 2023 & & & & \\ \hline June & 30 & Balance & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & \\ \hline \end{tabular} \begin{tabular}{|c|r|} \hline \multicolumn{2}{|c|}{ BALANCE } \\ \hline DEBIT & CREDIT \\ \hline & \\ \hline 9,850.00 & \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} ACCOUNT: Store Equipment ACCOUNT NO: 123 A B B C ACCOUNT: \begin{tabular}{|l|l|l|} \hline DATE & & \\ \hline 2023 & & \\ \hline June & 30 & Balance \\ \hline & & ITM \\ \hline & & \\ \hline \end{tabular} Advertising Expense Depreciation Expense ACCOUNT NO: 521 G H ACCOUNTNO: 522 ACCOUNT: \begin{tabular}{|c|c|} \hline POSTREF. & DEBII \\ \hline & \\ \hline \end{tabular} ACCOUNT: Store Supplies Expense ACCOUNT NO: 523 \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ DATE } \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} \begin{tabular}{|c|} \hline POST \\ \hline REF. \\ \hline \\ \hline \end{tabular} ACCOUNT: Miscellaneous Selling Expense ACCOUNT NO: 529 POST BALANCE ACCOUNT: Miscellaneous Selling Expense ACCOUNT NO: 529 \begin{tabular}{|l|} \hline POST \\ REF. \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ BALANCE } \\ \hline DEBIT & CREDIT \\ \hline & \\ \hline 1,050.00 & \\ \hline & \\ \hline & \\ \hline \end{tabular} ACCOUNT: Office Salaries Expense ACCOUNT NO: 530 \begin{tabular}{|c|c|c|l|} \hline 68 & & & \\ \hline 69 & \multicolumn{1}{|c||}{ DATE } & \multicolumn{2}{|c|}{ ITEM } \\ \hline 70 & 2023 & & \\ \hline 71 & June & 30 & Balance \\ \hline 72 & & & \\ \hline 73 & & & \\ \hline 75 & & & \\ \hline 0 & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline POSTREF. \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} Rent Expense ACCOUNTNO: BALANCE 77 ACCOUNT: ITEM BALANCE \begin{tabular}{|c|c|c|} \hline \multicolumn{2}{|c|}{ DATE } & \multicolumn{2}{|c|}{ ITEM } \\ \hline 2023 & & \\ \hline June & 30 & Balance \\ \hline & & \\ \hline & & \\ \hline \end{tabular} DEBIT CREDIT \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ BALANCE } \\ \hline DEBIT & CREDIT \\ \hline 7,390.00 & \\ \hline & \\ \hline & \\ \hline \end{tabular} ACCOUNT: Insurance Expense ACCOUNT NO: 532 Statement of f tockholders Equity For the month ended June 30, 2023 Beginning balance June 1, 2023 Issuance of common stock Add: Net income (or Less: Net loss) Less: Dividends Ending balance June 30, 2023 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Total Common stock Retained Stockholders' Earnings Equity