Question

I'm having a difficult time with my accounting workbook. I post the adjusting entries, but my balance sheet never equalizes. Can someone point me where i'm going wrong?
1. A supplier shipped $3,000 of ingredients on 12/29/17. Peyton receives an invoice for the goods, as well as a bill for freight for $175, all dated 12/29/17. Goods were shipped FOB supplier’s warehouse.
2. At 12/31/17, Peyton has $200 worth of merchandise on consignment at Bruno’s House of Bacon.
3. On 12/23/17, Peyton received a $1,000 deposit from Pet Globe for product to be shipped by Peyton in the second week of January.
4. On 12/03/2017, a mixer with cost of $2,000, accumulated depreciation $1,200, was destroyed by a forklift. As of 12/23/17, insurance company has agreed to pay $700 in January, 2018, for accidental destruction.
5. Note about later borrowing financials will show loan from parents repaid and use of bank financing.
PEYTON APPROVED
TRIAL BALANCE
As of December 31, 2017
Unadjusted trial balance Adjusting entries Adjusted trial balance
Dr Cr ref Dr Cr ref Dr Cr
Cash 67,520.04 67,520.04
Accounts Receivable 68,519.91 68,519.91
Other Receivable - Insurance Baking Supplies 15,506.70 15,506.70
Merchandise Inventory 1,238.07 1,238.07
Consignment Inventory Prepaid Rent 2,114.55 2,114.55
Prepaid Insurance 2,114.55 2,114.55
Misc. Supplies 170.49 170.49
Baking Equipment 14,000.00 14,000.00
Accumulated Depreciation 1,606.44 1,606.44
Customer Deposit - Accounts Payable 20,262.11 20,262.11
Wages Payable 3,383.28 3,383.28
Interest Payable 211.46 211.46
Notes Payable 5,000.00 5,000.00
Common Stock 20,000.00 20,000.00
Beginning Retained earnings 50,144.84 50,144.84
Dividends 105,000.00 105,000.00
Bakery Sales 327,322.55 327,322.55
Merchandise Sales 1,205.64 1,205.64
Cost of Goods Sold - Baked 105,834.29 105,834.29
Cost of Goods Sold - Merchandise 859.77 859.77
Rent Expense 24,549.19 24,549.19
Wages Expense 10,670.72 10,670.72
Misc. Supplies Expense 3,000.46 3,000.46
Business License Expense 2,045.77 2,045.77
Misc. Expense 1,363.84 1,363.84
Depreciation Expense 677.86 677.86
Insurance Expense 1,091.08 1,091.08
Advertising Expense 1,549.74 1,549.74
Interest Expense 818.31 818.31
Telephone Expense 490.98 490.98
Gain/Loss on disposal of equipment 429,136.32 429,136.32 - - 429,136.32 429,136.32

Answer 1

Answer:

PEYTON APPROVED

TRIAL BALANCE

As of December 31, 2017

                                        Unadjusted           Adjusting          Adjusted

                                      Trial balance             Entries         Trial balance

                                   Dr                Cr  ref   Dr         Cr  ref   Dr            Cr

Cash                          67,520.04           3   1,000              68,520.04

Accounts Receivable 68,519.91                                         68,519.91

Other Receivable -

Insurance Baking

 Supplies                  15,506.70                                         15,506.70

Merchandise

 Inventory                  1,238.07             1  3,175             1     4,413.07

Consignment

 Inventory                                            2   200             2      200

Prepaid Rent             2,114.55                                             2,114.55

Prepaid Insurance    2,114.55                                             2,114.55

Misc. Supplies             170.49                                               170.49

Baking Equipment 14,000.00              4  2,000          4 12,000.00

Accumulated Depreciation   1,606.44 4                      4                    406.44

Customer Deposit

- Accounts Payable            20,262.11                                           20,262.11

Wages Payable                     3,383.28                                            3,383.28

Interest Payable                        211.46                                                211.46

Notes Payable                     5,000.00                                           5,000.00

Common Stock                 20,000.00                                        20,000.00

Beginning Retained

 earnings                           50,144.84                                          50,144.84

Dividends                        105,000.00                                       105,000.00

Bakery Sales                   327,322.55                                      327,322.55

Merchandise Sales              1,205.64                                           1,205.64

Cost of Goods

Sold - Baked 105,834.29                                         105,834.29

Cost of Goods

Sold -

 Merchandise    859.77                                                 859.77

Rent Exp.       24,549.19                                            24,549.19

Wages Exp.   10,670.72                                             10,670.72

Misc. Supplies

 Expense       3,000.46                                              3,000.46

Business

License

Expense       2,045.77                                               2,045.77

Misc.

 Expense      1,363.84                                                1,363.84

Depreciation

 Expense        677.86                                                  677.86

Insurance

 Expense      1,091.08                                                1,091.08

Advertising

Expense     1,549.74                                                 1,549.74

Interest

 Expense       818.31                                                     818.31

Telephone

Expense      490.98                                                   490.98

Gain/Loss on

disposal of equipment 429,136.32 429,136.32 - - 429,136.32 429,136.32

Explanation:

a) Data and Calculations:

PEYTON APPROVED

TRIAL BALANCE

As of December 31, 2017

Unadjusted trial balance Adjusting entries Adjusted trial balance

Dr Cr ref Dr Cr ref Dr Cr

Cash 67,520.04 67,520.04

Accounts Receivable 68,519.91 68,519.91

Other Receivable - Insurance Baking Supplies 15,506.70 15,506.70

Merchandise Inventory 1,238.07 1,238.07

Consignment Inventory Prepaid Rent 2,114.55 2,114.55

Prepaid Insurance 2,114.55 2,114.55

Misc. Supplies 170.49 170.49

Baking Equipment 14,000.00 14,000.00

Accumulated Depreciation 1,606.44 1,606.44

Customer Deposit - Accounts Payable 20,262.11 20,262.11

Wages Payable 3,383.28 3,383.28

Interest Payable 211.46 211.46

Notes Payable 5,000.00 5,000.00

Common Stock 20,000.00 20,000.00

Beginning Retained earnings 50,144.84 50,144.84

Dividends 105,000.00 105,000.00

Bakery Sales 327,322.55 327,322.55

Merchandise Sales 1,205.64 1,205.64

Cost of Goods Sold - Baked 105,834.29 105,834.29

Cost of Goods Sold - Merchandise 859.77 859.77

Rent Expense 24,549.19 24,549.19

Wages Expense 10,670.72 10,670.72

Misc. Supplies Expense 3,000.46 3,000.46

Business License Expense 2,045.77 2,045.77

Misc. Expense 1,363.84 1,363.84

Depreciation Expense 677.86 677.86

Insurance Expense 1,091.08 1,091.08

Advertising Expense 1,549.74 1,549.74

Interest Expense 818.31 818.31

Telephone Expense 490.98 490.98

Gain/Loss on disposal of equipment 429,136.32 429,136.32 - - 429,136.32 429,136.32

b) The adjustments are made in the Adjusting entries column and referenced accordingly, while the effect is reflected in the adjusted trial balance column.