AutoSave . Off H 9 ACC 201 Company Accounting Workbook Template (1) - Excel Ramel Talk File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri 11 ~ AA = = E ab Wrap Text General Normal Bad Good Neutral Calculation _ AutoSum AY O Fill Paste [ Copy E =E Merge & Center $ ~ % 2 00 20 Conditional Format as Check Cell Explanatory ... Input Linked Cell Note nsert Delete Format Sort & Find & Format Painter Formatting Table v Clear Filter ~ Select v Clipboard Font Alignment Number Styles Cells Editing GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more R7 X V fax Sales - selling price, $8.50 a box B C D E G H K L M N O P Q R S T U V 1 IN FIFO 3 Purchases Sales Ending Inventory Purchases No. of No. of No. of Date Items Unit Price Total Price Items Unit Price Total Price |Items Unit Price Total Price Date 12/7: 10 boxes purchased at $6 D Cr 7-Dec 10 $ 6.00 $ 60.00 10 $ 6.00 $ 60.00 7-Dec Merchandise Inventory (10 x $6) 60.00 12/20: 20 boxes purchased at $6.10 Cash 60.00 12/30: 25 boxes purchased at $6.05 15-Dec 8 $ 6.00 $ 48.00 2 $ 6.00 $ 12.00 Purchased inventory Sales - selling price, $8.50 a box Co 12/15: 8 boxes 20-Dec 20 $ 6.10 $ 122.00 2 $ 6.00 $ 12.00 15-Dec Cash (8 x $8.50) 68.00 12/24: 18 boxes 20 $ 6.10 $ 122.00 Merchandise Sales Revenue 68.00 22 $ 134.00 ale of inventory 24-Dec 2 $ 6.00 $ 12.00 15-Dec Cost of Goods Sold (8 X $6) 48.00 16 $ 6.10 $ 97.60 4 $ 6.10 $ 24.40 Merchandise Inventory 48.00 18 $ 109.60 Recorded the cost of goods sold 30-Dec 25 $ 6.05 $ 151.25 4 $ 6.10 $ 24.40 20-Dec Merchandise Inventory (20 x $6.10 ) 122.00 25 $ 6.05 $ 151.25 Cash 122.00 29 $ 175.65 Net Inventor 55 $ 333.25 26 $ 157.60 29 $ 175.65 24-Dec Cash (18 x 8.50) 153.00 Merchandise Sales Revenue 153.00 Record sale of inventory INNNNB 24-Dec Cost of Goods Sold (2 x $6)+(16 x $6.10) 109.60 Merchandise Inventory 109.60 Recorded the cost of goods sold 30-Dec Merchandise Inventory (25 x $6.05) 151.25 Cash 151.25 OneDrive Screenshot saved The screenshot was added to your T-Accounts - autofill Inventory Valuation Trial Balance Adjusting Entries Income Statement Statement of Stockholder Equity Balance Sheet ... + OneDrive. Ready Type here to search O X ? 5:23 AM 66'F AQ198 ~ 9 A (4 4)) 7/5/2021AutoSave . Off H 9 ACC 201 Company Accounting Workbook Template (1) - Excel Ramel Talk File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut _ AutoSum Calibri 11 ~ A A = = ab Wrap Text Accounting Normal Bad Good Neutral Calculation AY O Fill Paste [ Copy nsert Delete Format Sort & Find & BIULA E E Merge & Center $ ~ % 9 00 20 Conditional Format as Check Cell Explanatory ... Input Linked Cell Note Format Painter Formatting Table v Clear Filter ~ Select v Editing Clipboard Font Alignment Number Styles Cells GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more E10 X V ='Adjusting Entries"!D11 A B C D E F G H K L M N P Q R S T U A Company Trial Balance N N 20xx Unadjusted trial balance Adjusting entries Adjusted trial balance UI AL Account Debit Credit Debit Credit Debit Credit 6 7 Baking Supplies 8 Merchandise Inventory 9 Prepaid Rent 10 Prepaid Insurance 11 Baking Equipment 12 Accumulated Depreciation 13 Office Supplies 14 Accounts Receivable 15 Notes Payable 16 Interest Payable 17 Accounts Payable 18 Wages Payable 19 Common Stock 20 Dividends 21 Bakery Sales 22 Merchandise Sales 23 Baking Supplies Expense 24 Rent Expense 25 Interest Expense 26 Insurance Expense 27 Depreciation Expense 28 Misc. Expense 29 Office Supplies Expense 30 Business License Expense 31 Advertising Expense 32 Wages Expense P OneDrive 33 Telephone Expense 34 COGS Screenshot saved 35 The screenshot was added to your OneDrive. T-Accounts - autofill Inventory Valuation Trial Balance Adjusting Entries Income Statement Statement of Stockholder Equity Balance Sheet ... + : Ready 5:23 AM Type here to search O X 66'F AQ198 ~ 9 A (4 4)) 7/5/2021