Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Prepare a transaction statement. The way my professor set this up is extremely confusing. Any help is much appreciated. Closing Inventory (####....) is 3,500 .
Prepare a transaction statement. The way my professor set this up is extremely confusing. Any help is much appreciated.
Closing Inventory (####....) is 3,500. Sorry about that.
What I need is a transaction statement from the following spreadsheet. I removed the account numbers and names as they may be confusing (only some of the accounts are relevent in the spreadsheet below). Other than that, I do not know what else is needed, so please clarify what else you need. As I said, my professor set this up in a confusing way.
Description Date Amount 12/15/16 1,500 Sold books on account to Dr. Seuss for with terms 2/15 net/30. 12/15/16 12/16/16 5,000 Company borrowed on the line of credit (Note this was added after the intial file was posted) 12/16/16 $ 2,500 Purchased books on account from Random House for with terms 2/10 net/30 12/17/16 $ 2,000 Purchased books on account from Barnes & Noble for with terms 2/15 net/30 12/18/16 $1,000 Sold books on account to Charles Dickens with terms 2/10 net/30 12/18/16 Received payment from Leo Tolstoy for the open invoice number 132 Received payment from Dr. Seuss for the open invoice number 122 Made payment on the open invoice from Random House purchase order number 207. 12/19/16 12/20/16 250 Paid interest on the line of credit through 12/16/13. 12/22/16 12/22/16 12/23/16 12/23/16 $ 1,000 Returned part of the books purchased from Barnes & Noble on 12/17 12/24/16 $ 1,000 Owner withdrew cash for personal use. 12125/16 $750 Sold books on account to Leo Tolstoy with terms 2/10 net/30. 12/25/16 $ 200 Paid current utility bill. 12/26/16 $ 50 Received deposit on new Walking Dead book due out in January. 12/28/16 $ 500 Paid for December radio advertising. 12/30/16 $ 2,400 Purchased a Computer paying $250 in cash the remainder on a note. (No salvage value, 3 Year life, SL dep.) 12/30/16 $ 6,000 owners contributed another vehicle to the business recorded at market Value. (Salvage Value $1,000, Life 3 Years, SL.) 12/31/16 $1,800 Paid next 6 months of auto insurance. Received payment from Charles Dickens for the open invoice number 128 Charles Dickens returned the books sold to him on 12/18/13. Made payment on the open invoice from Barnes & Noble purchase order number 212. Adjusting and Closing Entry Information Record depreciation for the year. The prepaid insurance account contains the unexpensed vehicle premium for December. The Line of Credit (Note Payable) has a stated annual interest rate of The physical inventory shows a balance of (NOTE: Periodic system used) 12%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started