Can someone help with the general ledgers, AR and AP ledgers, and journal entries, and possibly December Worksheet too? If not, I can figure out the Worksheet from the ledgers. The worksheet for November is posted below! The equipment depreciates $10 a month, monthly insurance is $100, interest is $31.25. The cost of the mixers in November was $580 and sold for $1200. November 23, three mixers were sold to Peter on account for $3600 terms n/30. I always give thumbs up for the effort. :)
At the beginning of December, Madison finds out that Batter Blender Supply Co. has raised the cost of their mixers to $615 each, so she will only make one more purchase from them this month. She was lucky enough to find comparable mixers at Garcia Co., a local manufacturer, so she has signed a contract to buy mixers from them this month. Garcia Co. also has a $610 cost for each mixer. She still plans to sell them for $ 1,200. Madison is running out of storage space in her small apartment, so she decides to rent a small office space to hold all of her supplies and inventory. Rent is due at the beginning of each month. The following transactions occurred during the month of December. Dec. 1 Paid $700 rent for the month of December. Check 166. 2 Purchased three mixers on account from Batter Blender Supply Co. for $1,845, terms n/30. 4 Paid $45 freight for the December 2 purchase. Check 167. 6 Sold three mixers for $3,600 on account to Seafood Shack, invoice 1012, terms n/30. 7 Bought four mixers on account from Garcia Co. for $2,440, terms n/30. 8 Collected the amount due from Peter's Pastries for the November 23 transaction. 9 Returned one of the mixers purchased on Dec 7th because it was damaged during shipping. Garcia Co. issues Sweet Treats credit for the cost of the mixer. 10 Paid Batter Blender the amount due for the December 2 purchase. Check 168. 12 Bought three mixers on account from Garcia Co. for $1,830, terms n/30. 13 Paid $45 freight for the December 7 purchase. Check 169. 16 Three mixers are sold on account for $3,600 to the Chop House, invoice 1013, terms n/30. 16 One mixer is sold to a new customer, Bagel Depot, on account for $1,200, invoice 1014, terms n/30. 18 Paid a $75 cell phone bill for December. Check 170. 19 Paid $45 freight for items received on the December 12 purchase. Check 171. 20 Taught a 3hr cupcake making class at Winslow Sweets for $150 per hour. Winslow Sweets paid in full at the end of the class. 20 Paid Garcia Co. the amount due for the December 7 purchase. Check 172. 20 Collected the amount due from Chop House for the December 16 transaction. 21 Purchased baking supplies for $350 cash. Check 173. 23 Issued a check to Madison's assistant for $960 for the first two weeks in December. Check 174. 23 Two mixers are sold on account for $2,400 to the Chop House, invoice 1015, terms n/30. Taught a 2hr holiday cookie workshop at Young Souls, the local senior center. Madison offered her workshop at a discounted price of $50 per hour. She left invoice 1016 with the director of Young Souls after the workshop. 26 Collected the amount due from Bagel Depot for the December 16 transaction. 27 Madison withdrew $1,200 cash for personal use. Check 175. As of December 31, the following adjusting entry data is available. 1. Accrued utilities total $340 for the current month. 2. Another month's worth of depreciation needs to be recorded on the baking equipment. 3. A count reveals that $135 of baking supplies are remaining in the supply room. 4. Another month's worth of insurance has expired. 5. Madison owes her assistant $960 for the last two weeks of December, but will not pay it until January 2 6. Madison records another month of accrued interest on her grandma's loan. A B C 1 2 Trial Balance Dr. Cr. Account Titles 3 4 Cash 1,655.00 D E F G H K November Worksheet Adjustments Adjusted Trial Bal.Income Statement Balance Sheet Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr. 1,655.00 1,655.00 3,600.00 3,600.00 1,875.00 1,875.00 95.00 95.00 100.00 1,100.00 1,100.00 1,200.00 1,200.00 5 Accounts Receivable 3,600.00 1,875.00 95.00 1,200.00 1,200.00 10.00 10.00 20.00 20.00 6 Inventory 7 Baking Supplies 8 Prepaid Insurance 9 Equipment 10 Accum. Depr.-Equipment 11 Accounts Payable 12 Salaries and Wages Payable 13 Interest Payable 14 Notes Payable 15 Owner's Capital 16 Owner's Drawings 17 Service Revenue 18 Sales Revenue 31.25 62.50 62.50 31.25 .......... 5,000.00 5,000.00 5,000.00 2,600.00 2,600.00 2,600.00 ---------- 850.00 850.00 850.00 435.00 435.00 435.00 7,200.00 7,200.00 7,200.00 3,480.00 3,480.00 3,480.00 75.00 75.00 75.00 45.00 -------- 10.00 45.00 ---- 20.00 45.00 ---- 20.00 10.00 ................ 19 Cost of Goods Sold 20 Advertising Expense 21 Baking Supplies Expense 22 Depreciation Expense 23 Insurance Expense ............................. 24 Salaries and Wages Expense 25 Rent Expense 26 Utilities Expense 27 Interest Expense 100.00 100.00 100.00 1,005.00 1,005.00 1,005.00 ---- 155.00 155.00 155.00 31.25 31.25 62.50 62.50 28 29 TOTALS 15,276.25 15,276.25 141.25 4,942.50 30 141.25 15,317.50 15,317.50 Net Income TOTALS 2,692.50 7,635.00 10,375.00 7,682.50 2,692.50 ............. 7,635.00 10,375.00 10,375.00 31 7,635.00
