Attached is my Final quickbooks project. Can you please verify my excel answers are correct?

Your Name Retailers Inc. 9:56 PM 06/14/14 Transaction List by Customer December 2014 AQAAAAkFASA AQB9HFRyYW 5zYWN0aW9uI AAAAAAAAAA Audio Answers Expc3QgYnkgQ AAAAAABAAA 3VzdG9tZXIAA A AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA Credit Card Sales AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAFAA iPrint Design AAAAAAAAAA AAAAABEVwE AMgANAAEAA AAAAAAAAQA NAQEM3gcfD N4HAAABAAA Video Solutions AAAAAAAAAA AAAAAAAAAA AAAAAAAAAz URXEwACAAA ARFcFAHIGAf8 AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA A+P+8AkFyaW FsAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAE AAAAAAAABA A+P+8AkFyaW FsAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAE AAAAAAAABA A+P+QAUFya WFsAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AEAAAAAAAA BAA+P+8AkFya Type Date Num 6 Memo Account Invoice 12/24/2014 Payment 12/30/2014 Sales Receipt 12/24/2014 Invoice 12/24/2014 Payment 12/30/2014 Invoice 12/24/2014 7 11000 Accounts Receivable Credit Memo 12/27/2014 8 11000 Accounts Receivable Clr 11000 Accounts Receivable 12000 Undeposited Funds 2 12000 Undeposited Funds 5 11000 Accounts Receivable 12000 Undeposited Funds Page 4 of 16 Your Name Retailers Inc. 9:56 PM 06/14/14 Transaction List by Customer December 2014 AQAAAAkFASA AQB9HFRyYW 5zYWN0aW9uI AAAAAAAAAA Audio Answers Expc3QgYnkgQ AAAAAABAAA 3VzdG9tZXIAA A AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA Credit Card Sales AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAFAA iPrint Design AAAAAAAAAA AAAAABEVwE AMgANAAEAA AAAAAAAAQA NAQEM3gcfD N4HAAABAAA Video Solutions AAAAAAAAAA AAAAAAAAAA AAAAAAAAAz URXEwACAAA ARFcFAHIGAf8 AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA A+P+8AkFyaW FsAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAE AAAAAAAABA A+P+8AkFyaW FsAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAE AAAAAAAABA A+P+QAUFya WFsAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AEAAAAAAAA BAA+P+8AkFya Split Debit 46000 Sales 300.00 11000 Accounts Receivable 300.00 -SPLIT- 800.00 46000 Sales 400.00 11000 Accounts Receivable 400.00 46000 Sales 720.00 46000 Sales Credit 120.00 Page 5 of 16 Your Name Retailers Inc. 9:55 PM 06/14/14 Accrual Basis AQAAAAkFASA AQCZFlB1cmN oYXNlcyBieSB AAAAAAAAAA eBooks Express WZW5kb3IgU3V AAAAAABAAA tbWFyeQAAAA A Podcast Ltd. AAAAAAAAAA AAAAAAAAAA TV Flix AAAAAAAAAA TOTAL AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAVwAA AAAAAAAAAA AAAABEVwEA MgAPAAEAAA AAAAAAAQAN AQEM3gcfDN4 HAAABAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAER XBQByBgH/AA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAPj /vAJBcmlhbAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAABAAA AAAAAAQAPj/v AJBcmlhbAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAABAAAA AAAAAQAPj/kA FBcmlhbAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAABAAAAA AAAAQAPj/vAJ BcmlhbAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAABAAAAAA AAAQAPT/vAJ BcmlhbAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAABAAAAAA AIAQAPL/vAJB cmlhbAAAAAA AAAAAAAAAA Purchases by Vendor Summary December 2014 Dec 14 350.00 330.00 660.00 1,340.00 Page 6 of 16 Your Name Retailers Inc. 9:53 PM 06/14/14 Transaction List by Vendor December 2014 AQAAAAkFASA AQB9HFRyYW 5zYWN0aW9uI AAAAAAAAAA eBooks Express Expc3QgYnkgV AAAAAABAAA mVuZG9yAAA A AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA Podcast Ltd. AAAAAAAAAA AAAAAAAAAA AAAAAAAAAF QAAAAAAAAA AAAAAAABEV wEAMgAPAAE AAAAAAAAAA TV Flix QANAQEM3gcf DN4HAAABAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAAz URXEwACAAA ARFcFAHIGAf8 AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA A+P+8AkFyaW FsAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAE AAAAAAAABA A+P+8AkFyaW FsAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAE AAAAAAAABA A+P+QAUFya WFsAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AEAAAAAAAA BAA+P+8AkFya Type Date Num Memo Account Bill 12/21/2014 Invoice No. 101eb 22000 Accounts Payable Credit 12/23/2014 CM2 22000 Accounts Payable Bill Pmt -Check 12/30/2014 22000 10000 Home State Bank-Cash Bill 12/21/2014 Invoice No. 95PS 22000 Accounts Payable Bill Pmt -Check 12/30/2014 22000 10000 Home State Bank-Cash Bill 12/30/2014 Invoice No. 152PS 22000 Accounts Payable Bill 12/21/2014 Invoice No. 352TV 22000 Accounts Payable Bill Pmt -Check 12/30/2014 22000 10000 Home State Bank-Cash Page 7 of 16 Your Name Retailers Inc. 9:53 PM 06/14/14 Transaction List by Vendor December 2014 AQAAAAkFASA AQB9HFRyYW 5zYWN0aW9uI AAAAAAAAAA eBooks Express Expc3QgYnkgV AAAAAABAAA mVuZG9yAAA A AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA Podcast Ltd. AAAAAAAAAA AAAAAAAAAA AAAAAAAAAF QAAAAAAAAA AAAAAAABEV wEAMgAPAAE AAAAAAAAAA TV Flix QANAQEM3gcf DN4HAAABAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAAz URXEwACAAA ARFcFAHIGAf8 AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA A+P+8AkFyaW FsAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAE AAAAAAAABA A+P+8AkFyaW FsAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAE AAAAAAAABA A+P+QAUFya WFsAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AEAAAAAAAA BAA+P+8AkFya Clr Split Debit 12100 Inventory Asset 12100 Inventory Asset Credit 400.00 50.00 22000 Accounts Payable 350.00 12100 Inventory Asset 180.00 22000 Accounts Payable 180.00 12100 Inventory Asset 150.00 12100 Inventory Asset 660.00 22000 Accounts Payable 660.00 Page 8 of 16 Your Name Retailers Inc. 9:51 PM 06/14/14 June 14, 2014 Active Status Type Item Description Sales Tax Code Account COGS Account Active Inventory Part eBook PDF files 46000 Sales 50001 *Cost of Goods Sold Active Inventory Part Podcast audio files 46000 Sales 50001 *Cost of Goods Sold Active Inventory Part TV Programs video files 46000 Sales 50001 *Cost of Goods Sold Page 9 of 16 9:51 PM 06/14/14 Your Name Retailers Inc. June 14, 2014 Asset Account Accumulated Depreciation Purchase Description Quantity On Hand Cost 12100 Inventory Asset 0.00 PDF files 7.00 25.00 12100 Inventory Asset 0.00 audio files 21.00 15.00 12100 Inventory Asset 0.00 video files 15.00 30.00 Page 10 of 16 Your Name Retailers Inc. 9:51 PM 06/14/14 June 14, 2014 Preferred Vendor Tax Agency Price eBooks Express 50.00 Podcast Ltd. 30.00 TV Flix 60.00 Reorder Point MPN Page 11 of 16 Your Name Retailers Inc. 9:51 PM 06/14/14 Journal December 2014 Trans # 32 33 34 35 36 37 38 39 40 Type Bill Bill Bill Credit Invoice Invoice Invoice Sales Receipt Credit Memo Date Num 12/21/2014 12/21/2014 12/21/2014 12/23/2014 12/24/2014 12/24/2014 12/24/2014 12/24/2014 12/27/2014 5 6 7 2 8 Adj Name Memo eBooks Express Invoice No. 101eb eBooks Express PDF files TV Flix Invoice No. 352TV TV Flix video files Podcast Ltd. Invoice No. 95PS Podcast Ltd. audio files eBooks Express CM2 eBooks Express PDF files iPrint Design iPrint Design PDF files iPrint Design PDF files iPrint Design PDF files Audio Answers Audio Answers audio files Audio Answers audio files Audio Answers audio files Video Solutions Video Solutions video files Video Solutions video files Video Solutions video files Credit Card Sales Credit Card Sales -MULTIPLE- Credit Card Sales -MULTIPLE- Credit Card Sales -MULTIPLE- Video Solutions Video Solutions video files Video Solutions video files Page 12 of 16 Your Name Retailers Inc. 9:51 PM 06/14/14 Journal December 2014 Trans # Type Date Num Adj Name Video Solutions 41 Payment 12/30/2014 Memo video files Audio Answers Audio Answers 42 Payment 12/30/2014 iPrint Design iPrint Design 43 44 45 46 47 Bill Pmt -Check Bill Pmt -Check Bill Pmt -Check Bill Deposit 12/30/2014 12/30/2014 12/30/2014 12/30/2014 eBooks Express 22000 eBooks Express 22000 Podcast Ltd. 22000 Podcast Ltd. 22000 TV Flix 22000 TV Flix 22000 Podcast Ltd. Invoice No. 152PS Podcast Ltd. audio files 12/30/2014 Deposit -MULTIPLE- Deposit TOTAL Page 13 of 16 Your Name Retailers Inc. 9:51 PM 06/14/14 Journal December 2014 Account Debit 22000 Accounts Payable 12100 Inventory Asset 400.00 400.00 400.00 22000 Accounts Payable 12100 Inventory Asset 660.00 22000 Accounts Payable 180.00 180.00 50.00 12100 Inventory Asset 50.00 50.00 11000 Accounts Receivable 660.00 180.00 180.00 22000 Accounts Payable 400.00 660.00 660.00 12100 Inventory Asset Credit 50.00 400.00 46000 Sales 400.00 12100 Inventory Asset 200.00 50001 *Cost of Goods Sold 200.00 600.00 11000 Accounts Receivable 600.00 300.00 46000 Sales 300.00 12100 Inventory Asset 150.00 50001 *Cost of Goods Sold 150.00 450.00 11000 Accounts Receivable 450.00 720.00 46000 Sales 720.00 12100 Inventory Asset 360.00 50001 *Cost of Goods Sold 360.00 1,080.00 12000 Undeposited Funds 800.00 46000 Sales 800.00 12100 Inventory Asset 50001 *Cost of Goods Sold 400.00 400.00 1,200.00 11000 Accounts Receivable 46000 Sales 12100 Inventory Asset 1,080.00 1,200.00 120.00 120.00 60.00 Page 14 of 16 Your Name Retailers Inc. 9:51 PM 06/14/14 Journal December 2014 Account Debit 50001 *Cost of Goods Sold 60.00 180.00 12000 Undeposited Funds 300.00 300.00 400.00 400.00 10000 Home State Bank-Cash 350.00 10000 Home State Bank-Cash 180.00 10000 Home State Bank-Cash 660.00 22000 Accounts Payable 150.00 150.00 1,500.00 12000 Undeposited Funds TOTAL 660.00 150.00 150.00 10000 Home State Bank-Cash 180.00 660.00 660.00 12100 Inventory Asset 350.00 180.00 180.00 22000 Accounts Payable 400.00 350.00 350.00 22000 Accounts Payable 300.00 400.00 11000 Accounts Receivable 22000 Accounts Payable 180.00 300.00 11000 Accounts Receivable 12000 Undeposited Funds Credit 1,500.00 1,500.00 1,500.00 8,340.00 8,340.00 Page 15 of 16 9:49 PM 06/14/14 Accrual Basis AQAAAAkFASA AQCZFlRyaWFs IEJhbGFuY2UA AAAAAAAAAA AAAAAAAAAA AAAAAABAAA AAAAAAAAAA A 10000 Home State Bank-Cash AAAAAAAAAA AAAAAAAAAA 11000 Accounts Receivable AAAAAAAAAA 12000 Undeposited Funds AAAAAAAAAA AAAAAAAAAA 12100 Inventory Asset AAAAAAAAAA AAAAAAAAGw 13000 Supplies AAAAAAAAAA 18000 Prepaid Insurance AAAAAABEVw EAMgAMAAEA 14000 Computer Equipment AAAAAAAAAQ ANAQAAAAAA 15000 Furniture and Equipment AAAAAAABAA 22000 Accounts Payable AAAAAAAAAA AAAAAAAAAA 26000 Your Name Notes Payable AAAAAAAAAA zURXBQByBgH 30000 Common Stock /AAAAAAAAAA 30200 Dividends AAAAAAAAAA AAAAAAAAAA 46000 Sales AAAAAAAAAA AAAAAAAAAA 50001 *Cost of Goods Sold AAAAAAAAAA 60400 Bank Service Charges Expense AAAAAAAAAA AAAAAAAAAA TOTAL AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA APj/vAJBcmlhb AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAABA AAAAAAAAQA Pj/vAJBcmlhbA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAABAA AAAAAAAQAPj /kAFBcmlhbAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAABAAA AAAAAAQAPj/v AJBcmlhbAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAABAAAA AAAAAQAPT/v AJBcmlhbAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAABAAAA AAAIAQAPL/vA JBcmlhbAAAA AAAAAAAAAA Your Name Retailers Inc. Trial Balance All Transactions Dec 30, 14 Debit Credit 50,335.00 600.00 0.00 940.00 2,700.00 2,500.00 2,400.00 4,000.00 150.00 20,000.00 41,500.00 200.00 4,070.00 2,035.00 10.00 65,720.00 65,720.00 Page 16 of 16 Exercise 4-1. Follow the instructions below to complete Exercise 4-1 (pp. 180-181) 1. If necessary start QuickBooks and open Your Name Retailers. Restore the Your Name Chapter 4 End File. 2. Identify the Home page icon that will be used to record each of the December transactions listed below. Date Transaction Home Icon 12/21 Pay BOS44 to The Business Store for the $400 for laptop computer purchase on 11/21. PAY BILLS 12/21 Invoice No. 101eB received from eBooks Express for the purchase of 16 PDF files, $25 each, for a total of $400. ENTER BILLS 12/21 Invoice No. 352TV received from TV Flix for the purchase of 22 video files, $30 each, for a total of $660. ENTER BILLS 12/21 Invoice No. 95PS received from Podcast Ltd. for the purchase of 12 audio files, $15 each, for a total of $180. ENTER BILLS 12/23 Returned two PDF files to eBooks Express, Credit memo for a total of $50. ENTER BILLS; CREDIT radio button 12/24 Sold 8 eBooks (PDF files) on account to iPrint Design for a total credit sale of $400, Invoice No. 5. CREATE INVOICE 12/24 Sold 10 Podcasts (audio files) on account to Audio Answers for a total credit sale of $300 Invoice No. 6. CREATE INVOICE 12/24 Sold 12 TV Programs (video files) on account to Video Solutions for a total credit sale of $720, Invoice No. 7. CREATE INVOICE 12/26 Sold 4 eBooks for $200; 8 Podcasts for $240; and 6 TV Programs for $360; for total credit card sales of $800, Sale No. 2. CREATE SALES RECEIPTS 12/27 Video Solutions returned 2 TV Programs (video files), $120. REFUNDS AND CREDITS 12/30 Received a check in full payment of Audio Answers' account, $300 RECEIVE PAYMENT 12/30 Received a check in full payment of iPrint Design's account, $400. RECEIVE PAYMENT 12/30 Your Name Retailers pays all outstanding vendor bills for a total of $1,190. (Hint: Remember to Set Credit for the 12/23/20XX return to eBooks Express.) PAY BILLS 12/30 Invoice No. 152PS received from Podcast Ltd. for the purchase of 10 audio files, $15 each, for a total of $150. ENTER BILLS 12/30 Make bank deposit into Home State Bank account of all undeposited funds. RECORD DEPOSITS Exercise 4-2. Follow the instructions below to complete Exercise 4-2 (pp. 181-182). Exercise 4-1 must be completed before starting Exercise 4-2. 1. Print the following reports. Please save the reports in PDF format. Refer to the read me box in Chapter 3, p. 117, for saving reports as PDFs. a. Trial Balance 12/31/20XX.- Total Debits and Credits $67,720 b. Journal 12/01/20xx to 12/31/20xx-Total Debits and Credits $8,740 c. Inventory Valuation Detail - Three Items d. Transaction List by Vendor 12/01/20xx to 12/31/xx - 9 Transactions e. Purchases by Vendor Detail 12/01/20xx to 12/31/20xx - Total Amount 1,340, Total Balance $1,340 f. Transaction List by Customer 12/01/20xx to 12/31/20xx- 7 transactions g. NOT TO BE COMPLETED