Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone help me with the Trial Balance . I don't know where I will get the Adjusted trail balance. It is under the step

image text in transcribed

Can someone help me with the Trial Balance . I don't know where I will get the Adjusted trail balance. It is under the step 6 tab at the bottom. I have attached the entire workbook below. Thank you

image text in transcribed Asset Accounts Acct # Cash Baking Supplies Prepaid Rent Prepaid Insurance Baking Equipment Misc. Supplies Accounts Receivable Accumulated Depreciation Merchandise Inventory 101 102 103 104 105 106 107 108 109 This chart of accounts should help you identify the appropriate accounts to record to as you are analyzing and journaling transactions for this workbook. There is nothing to complete on this page; this is simply a resource for you. Liability Accounts Equity Accounts Acct # Notes Payable Accounts Payable Wages Payable Interest Payable he appropriate accounts to record to as you are analyzing and is nothing to complete on this page; this is simply a resource for you. 201 Common Stock 202 Dividends 203 204 Revenue Accounts Bakery Sales Merchandise Sales Expense Accounts Baking Supplies Expense Rent Expense Insurance Expense Misc. Expense Business License Expense Advertising Expense Wages Expense Telephone Expense Interest Expense Depreciation Expense Misc. Supplies Expense Cost of Goods Sold s Acct # 301 302 ts Acct # 401 402 ts Acct # 501 502 503 504 505 506 507 508 509 510 511 512 Peyton Approved General Journal Entries Jul-14 Date Accounts 1-Jul Cash Common Stock Contributed cash for common stock 1-Jul Baking Supplies Purchased on Account Account payable 3-Jul Cash Notes Payables 7-Jul Rent Expense Prepaid Rent Cash 10-Jul Peyton Business License cash 11-Jul Miscellaneous Expense cash 13-Jul Baking equipment common stock 13-Jul advertising expense cash 14-Jul Miscellaneous Supplies cash 30-Jul Telephone expense Accrued Telephone Expense accounts payable 31-Jul Prepaid insurance cash Paid insurance in advance 31-Jul Wage Expense Wages Payables Accure Wages 31-Jul Cash Bakery Sales 31-Jul Accounts receiveables bakery sales Bakery Sa on account Debit 15,000.00 8,500.00 10,000.00 1,500.00 1,500.00 375.00 250.00 5,000.00 200.00 300.00 45.00 1,200.00 120.00 10,000.00 5,000.00 Credit 15,000.00 8,500.00 10,000.00 3,000.00 375.00 250.00 5,000.00 200.00 300.00 45.00 1,200.00 120.00 10,000.00 5,000.00 Peyton Approved General Journal Entries Aug-14 Date Accounts 5-Aug Wage Payables Cash Payroll Ending July 31 8-Aug Cash Accounts Receiveable 10-Aug Accounts Payable Cash Telephone Expense 15-Aug Baking Supplies Expense Accounts Payable 15-Aug Wages Expense Wage Payables Accure wages 15-Aug Rent expense cash 18-Aug Cash Accounts Receiveable 20-Aug Accounts Payable Cash 20-Aug Wage Payables cash Payroll ending Aug 15 22-Aug Miscellaneous Supllies Cash 31-Aug Telephone Expense Accounts Payable Accrued Telephone Expense 31-Aug Wages Expense Wages Payable Accrue wages 31-Aug Cash Bakery Sales 31-Aug Accounts Receiveable bakery sales bakery Sales on account Debit 120.00 3,200.00 45.00 5,000.00 480.00 1,500.00 1,000.00 8,500.00 480.00 300.00 45.00 420.00 12,500.00 7,500.00 Credit 120.00 3,200.00 45.00 5,000.00 480.00 1,500.00 1,000.00 8,500.00 480.00 300.00 45.00 420.00 12,500.00 7,500.00 Peyton Approved General Journal Entries Sep-14 Date Accounts 1-Sep Dividends Cash 5-Sep Wage Payable Cash Payroll ending Aug 31 7-Sep Merchandise Inventory Cash 8-Sep Cash Accounts Receivable 10-Sep Accounts payable cash Telephone expense 11-Sep Baking Supply Expense Accounts payable 13-Sep Accounts Payable Cash 15-Sep Wages Expense Wages Payable Accrue wages 15-Sep Rent Expense Cash 15-Sep CASH Merchandise Sales Revenue Record sale of inventory 15-Sep Cost of goods merchandise inventory recorded the cost of good sold 20-Sep Wage Payable Cash Payroll ending Sept 15th 20-Sep Merchandise Inventory (20x6.10) Cash Purchased inventory 24-Sep Cash (18x8.50) Merchandise Sales Revenue Record sale of inventory 24-Sep Cost of goods sold (2x$6) +(16x$6.10) merchandise inventory Debit 3,000.00 Credit 3,000.00 420.00 420.00 60.00 60.00 4,000.00 4,000.00 45.00 45.00 7,000.00 7,000.00 5,000.00 5,000.00 456.00 456.00 1,500.00 1,500.00 68.00 68.00 48.00 48.00 456.00 456.00 122.00 122.00 153.00 153.00 109.60 109.60 recorded the cost of good sold 30-Sep Merchandise Inventory (25x6.05) Cash Purchased inventory 30-Sep Wages Expense Wages Payable Accrue wages 30-Sep Cash Bakery Sales 30-Sep Accounts Receivable Bakery Sales Bakery sales on account 151.25 151.25 480.00 480.00 19,000.00 19,000.00 6,000.00 6,000.00 FIFO Date 7-Sep Purchases 10 $ 6.00 $ Sales 60.00 15-Sep 20-Sep 8 $ 20 $ 6.10 $ 55 LIFO 7-Sep 6.05 $ 151.25 $ 333.25 Purchases 10 $ 6.00 $ 6.10 $ 6.05 $ $ 12.00 97.60 109.60 157.60 4 4 25 29 29 10 6.00 $ 48.00 122.00 151.25 2 2 20 22 18 $ 25 $ 6.00 $ 6.10 $ $ 60.00 24-Sep 30-Sep 26 8 $ 20 $ 2 Sales 15-Sep 20-Sep 48.00 2 20 22 2 $ 16 $ 25 $ 6.00 $ 122.00 24-Sep 30-Sep 10 6.10 $ 109.80 2 2 4 2 55 weighted average 7-Sep $ Purchases 10 $ 6.00 $ 333.25 6.10 $ 10 55 48.00 6.05 $ 151.25 $ 333.25 2 2 20 22 18 $ 25 $ 6.00 $ 122.00 24-Sep 30-Sep 157.80 60.00 8 $ 20 $ $ Sales 15-Sep 20-Sep 26 2 25 29 29 26 6.09 $ 109.62 4 157.62 4 25 29 Ending Inventory $ 6.00 $ 60.00 $ 6.00 $ 12.00 $ $ 6.00 $ 6.10 $ $ 12.00 122.00 134.00 $ 6.10 $ 24.40 $ $ 6.10 $ 6.05 $ $ $ 24.40 151.25 175.65 175.65 Ending Inventory $ 6.00 $ 60.00 $ $ $ $ $ $ 6.00 $ 6.00 $ 6.10 $ $ 6.00 $ 6.10 $ $ 6.00 $ 7-Sep Merchandise Inventory (10 x $6) Cash Purchased inventory Dr 60.00 15-Sep Cash (8 x $8.50) Merchandise Sales Revenue Record sale of inventory 68.00 15-Sep Cost of Goods Sold (8 X $6) Merchandise Inventory Recorded the cost of goods sold 48.00 20-Sep Merchandise Inventory (20 x $6.10 ) Cash 122.00 24-Sep Cash (18 x 8.50) Merchandise Sales Revenue Record sale of inventory 153.00 24-Sep Cost of Goods Sold (2 x $6)+(16 x $6.10) Merchandise Inventory Recorded the cost of goods sold 109.60 30-Sep Merchandise Inventory (25 x $6.05) Cash 151.25 7-Sep Merchandise Inventory (10 x $6) Cash Purchased inventory 60.00 12.00 12.00 122.00 134.00 12.00 12.20 24.20 12.00 15-Sep Cash (8 x $8.50) Merchandise Sales Revenue Record sale of inventory 68.00 15-Sep Cost of Goods Sold (8 X $6) Merchandise Inventory Record inventory reduction due to sale 48.00 20-Sep Merchandise Inventory (20 x $6.10) Cash 122.00 $ $ 6.10 $ 6.05 $ $ $ 12.20 151.25 175.45 175.45 Ending Inventory $ 6.00 $60 $ $ $ 6.00 $ 6.00 $ 6.10 $ $ $ $ $ 6.05 $ $ 24-Sep Cash (18 x 8.50) Merchandise Sales Revenue Record sale of inventory 153.00 24-Sep Cost of Goods Sold (18 x $6.10) Merchandise Inventory Record inventory reduction due to sale 109.80 30-Sep Merchandise Inventory (25 x $6.05) Cash 151.25 7-Sep Merchandise Inventory (10 x $6) Cash Purchased inventory 60.00 12.00 12.00 122.00 per unit 134.00 $6.09 24.38 151.25 151.25 $5.22 15-Sep Cash (8 x $8.50) Merchandise Sales Revenue Record sale of inventory 68.00 15-Sep Cost of Goods Sold (8 X $6) Merchandise Inventory Record inventory reduction due to sale 48.00 20-Sep Merchandise Inventory (20 x $6.10) Cash 122.00 24-Sep Cash (18 x 8.50) Merchandise Sales Revenue Record sale of inventory 153.00 24-Sep Cost of Goods Sold (18 x $6.09) Merchandise Inventory Record inventory reduction due to sale 109.62 30-Sep Merchandise Inventory (25 x $6.05) Cash 151.25 Cr 60.00 68.00 ### 122.00 153.00 109.60 151.25 ### 68.00 ### 122.00 Purchases 9/7: 10 bottles purchased at $6 9/20: 20 bottles purchased at $6.10 9/30: 25 bottles purchased at $6.05 Sales - selling price, $8.50 a bottle 9/15: 8 bottles 9/24: 18 bottles 153.00 109.80 151.25 ### 68.00 ### 122.00 153.00 109.62 151.25 date 1-Jul 3-Jul 31-Jul 8-Aug 18-Aug 31-Aug 8-Sep 15-Sep 24-Sep 30-Sep Cash 15,000.00 10,000.00 10,000.00 3,200.00 1,000.00 12,500.00 4,000.00 68.00 153.00 19,000.00 3,000.00 375.00 250.00 200.00 300.00 1,200.00 120.00 45.00 1,500.00 8,500.00 480.00 300.00 3,000.00 420.00 60.00 45.00 5,000.00 1,500.00 456.00 122.00 date 7-Jul 10-Jul 11-Jul 13-Jul 14-Jul 31-Jul 5-Aug 10-Aug 15-Aug 20-Aug 20-Aug 22-Aug 1-Sep 5-Sep 7-Sep 10-Sep 13-Sep 15-Sep 20-Sep 20-Sep 151.25 30-Sep date Notes Payable 10,000 date 3-Jul 10,000 31-Jul 31-Aug sept Accounts Rec. 5000 3200 7500 1000 6000 4000 10300 8-Aug 18-Aug 8-Sep 31-Jul 74,921.00 47,896.75 11-Jul 27,024.25 Misc. expense 250 13-Jul Baking equipment 5,000 5,000 250 1-Jul 15-Aug 11-Sep Baking supplies 8,500 5000 7000 20,500 7-Jul Prepaid rent 1,500 14-Jul 22-Aug Misc. supplies 300 300 600 Prepaid insurance 31-Jul 1,200 1,200 1,500 10-Aug 20-Aug 10-Sep 13-Sep Accounts payable 45 8500 8,500 45 45 5,000 5,000 45 7,000 1-Jul 30-Jul 15-Aug 31-Aug 11-Sep Salary and wages expense 31-Jul 120 15-Aug 480 31-Aug 420 15-Sep 456 30-Sep 480 7,000 10-Aug 10-Sep Telephone expense 45 45 1,956 1-Sep Dividends 3,000 90 3,000 adj baking supplies expense 1,100 1,100 misc supplies expense COGS LIF0 adj 0 Merchandise Sales Revenue 68.00 153.00 15-Sep 24-Sep 221.00 COGS Weighted Avg. 7-Sep 20-Sep 30-Sep - Business License exp 375 375 Common Stock 15,000 5,000 1-Jul 13-Jul 20,000 Insurance expense 1200 COMPLETION OF STEPS 1- 4 DELIVERABLE: CONGRATULATIONS! YOU ARE NOW READY TO SUBMIT YOUR WORKBOOK TO COMPLETE THE 3-3 CHECKPOINT REQUIREMENT 1200 13-Jul Advertising expense 200 200 7-Jul 15-Aug 15-Sep Rent expense 1,500 1500 1500 4,500 Bakery Sales 10,000 5,000 12,500 7,500 19,000 6,000 60,000 31-Jul 31-Jul 31-Aug 31-Aug 30-Sep 30-Sep Salaries and wages payable 5-Aug 120 120 20-Aug 480 480 5-Sep 420 420 20-Sep 460 456 480 30-Jul 15-Aug 31-Aug 15-Sep 30-Sep 476 adj 15-Sep 24-Sep depreciation expense acc dep 0 Interest expense 50 Interest payable 50 COGS FIFO 48.00 109.60 157.60 0 50 adj 50 Merch. Inv. FIFO 60.00 48.00 122.00 109.60 151.25 175.65 Merch. Inv. LIFO - Merch. Inv. Avg. - Merch. Inv. Avg. Account Cash Baking Supplies Merchandise Inventory Prepaid Rent Prepaid Insurance Baking Equipment Misc. Supplies Accounts Receivable Notes Payable Accounts Payable Wages Payable Common Stock Dividends Bakery Sales Merchandise Sales Baking Supplies Expense Rent Expense Insurance Expense Misc. Expense Business License Expense Advertising Expense Wages Expense Telephone Expense COGS Depreciation Expense Accumulated Depreciation Misc Supplies Expense* Interest Expense* Interest Payable* Peyton Approved Trial Balance 2014 Unadjusted trial balance Debit Credit 47,896.75 20,500.00 175.66 1,500.00 1,200.00 5,000.00 600.00 10,300.00 10,000.00 7,000.00 480.00 20,000.00 3,000.00 60,000.00 221.00 4,500.00 250.00 375.00 200.00 1,956.00 90.00 157.60 97,701.01 97,701.00 - *These accounts will not be utilized before the adjusting process. They should have zero balance in the unadjusted t Approved Balance 014 Adjusting entries Debit Credit Adjusted trial balance Debit Credit 19,400.00 1,100.00 200.00 1,000.00 550.00 50.00 ### 19,400.00 ### 200.00 ### COMPLETION OF STEPS 5-7 DELIVERABLE: CONGRATULATIONS! YOU ARE NOW R ### 208.33 ### 208.33 550.00 50.00 208.33 ### ### 50.00 20,408.33 WORKBOOK TO COMPLETE THE 4-3 CHECKP 20,408.33 50.00 22,933.33 7,258.33 have zero balance in the unadjusted trial balance. N OF STEPS 5-7 DELIVERABLE: ULATIONS! YOU ARE NOW READY TO SUBMIT YOUR TO COMPLETE THE 4-3 CHECKPOINT REQUIREMENT Peyton Approved Adjusting Journal Entries 2014 Date Accounts 30-Sep Depreciation Expense accumulated depreciation 30-Sep interest expense interest payable 30-Sep Insurance expense prepaid insurance 30-Sep Baking supplies Expense baking supplies 30-Sep Misc supplies expense misc supplies Debit 208.33 Credit 208.33 50.00 50.00 200.00 200.00 19,400.00 19,400.00 550.00 550.00 Peyton Approved Income Statement For Qtr. Ending 9/30/2014 Revenue Bakery Sales Merchandise Sales $ 60,000.00 221.00 60,221.00 Cost of Good Sold Total Revenue 157.6 60,063.40 Expense Baking Supplies Expense Rent Expense Insurance Expense Misc Expense Peyton Business License Expense Advertising Expense Telephone Expense Depreciation Expense Misc Expense Interest Expense 19,400.00 4,500.00 200.00 250.00 375.00 200.00 1,956.00 90.00 157.60 550.00 50.00 Total Expenses Net Income $ 27,728.60 32,334.80 Peyton Approved Statement of Retained Earnings For Qtr. Ending 9/30/2014 Beginning Balance Net Income 0 32,334.80 Dividends -3,000.00 Retained Earnings $ 29,334.80 Peyton Approved Balance Sheet As of September 30, 2014 Assets Peyton Approved Balance Sheet As of September 30, 2014 Liabilities and Owners' Equity Peyton Approved Closing Entries 9/30/2014 Date Accounts Debit Credit Peyton Approved Post Closing Trial Balance 9/30/2014 Account Unadjusted Trial Balance Debit adjusted Trial Balance Credit Peyton Approved Reversing Entries 9/30/2014 Date Accounts Debit Credit COMPLETION OF STEPS 8-11 DELIVERABLE: CONGRATULATIONS! YOU ARE NOW READY TO SUBMIT YOUR COMPLETED WORKBOOK (STEPS 1 - 11)TO COMPLETE THE 6-2 CHECKPOINT REQUIREMENT

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

=+how the customer arrived at their site.

Answered: 1 week ago