Answered step by step
Verified Expert Solution
Question
1 Approved Answer
how to put this information into an AR form? General ledger account balances as of May 31, 20.. Information: Balance per bank statement as of
how to put this information into an AR form?
General ledger account balances as of May 31, 20.. Information: Balance per bank statement as of May 31 was $41,615.95 Balance per Hughes Company's Cash account at May 31 was \$41,378.51 A late deposit on May 31 did not appear on the bank statement, $550.65 Outstanding checks as of May 31 totaled $888.10 The Bank Service Charge was $100 Wholesale on account for $735.30, Invoice No 91 Dated May 1, terms 2/10, n30 May 2 Purchased merchandise from Fryes Electronics on account for $1500 Invoice no 102 Dated May 2, terms 2/10, n/30 May 3, Sold Merchandise on account to Dana Lonview, $169.50 plus tax of 0.825, Sale No. 51 May 4, Sold merchandise on account to Daisy Rangel on account, $799.99 plus tax of 0.825, Sale No. 52 May 6, Received payment from Kevin Sanders on account, $100.00. May 7, Issued a Credit Memo No. 68 to Mark Parsons for merchandise returned that had sold on account, $72.75 May 9, Issued a check No 895 to Keys Wholesale Invoice 91 less 2% discount. May 10, Received payment from Daisy Rangel on account, $500 Sole no. 63 May 12, Received a Credit Memo from Edible Pursuits for catering credit for event on April 25 for 3450.00 Moy 14, Received poyment from Angel Garcia for half of the amount on account settiement of 32,500.00 Moy 14, Purchosed merchandise from Custom Works on eccount for $395.00 plus 0825 Sales Tox, trvolce No 289 doted May 14 , terms 2/10, r May 15, Recelved credit memo from Custom Works for merchandise purchosed on May 14., $79.00 Moy 17, Sold merchandise on occount to Kevin Sandars, $565.00 plus tax of $46.61 Sale No, 45 Mey 19, Sold merchandise for Cash to Mark Parsons, 579.95 plus tax of 56.60 Sales 46 Moy 21, Issued. Credit Memo 49 to for merchandise returned that hod been scid on account to Dana Lengriew, 583, 45 including tox of 55,23 Moy 23, Issued a Check No. 897 to Custom Works for merchandise purhcosed on May 14. Moy 24, Recehved payment from Eduard Quintana on account, $50000 Moy 25, Sold merchandise on occount to Angel Garcio, 5189.50 plus tax of 516.33 Sole.No. 47 Moy 26, Received peyment from Dane Longviaw on bccount, 3550.65. Moy. 27, Purchased merchandise from Fryes Electronics on account 9478.63 invoice 857 dated Moy 27, terms 2/10, a/30 Moy 28, Sold merchandise on occount to File Home Insert Draw Page Layout Formulas Data Review View Developer Help Power Piv General ledger account balances as of May 31, 20.. Information: Balance per bank statement as of May 31 was $41,615.95 Balance per Hughes Company's Cash account at May 31 was \$41,378.51 A late deposit on May 31 did not appear on the bank statement, $550.65 Outstanding checks as of May 31 totaled $888.10 The Bank Service Charge was $100 Wholesale on account for $735.30, Invoice No 91 Dated May 1, terms 2/10, n30 May 2 Purchased merchandise from Fryes Electronics on account for $1500 Invoice no 102 Dated May 2, terms 2/10, n/30 May 3, Sold Merchandise on account to Dana Lonview, $169.50 plus tax of 0.825, Sale No. 51 May 4, Sold merchandise on account to Daisy Rangel on account, $799.99 plus tax of 0.825, Sale No. 52 May 6, Received payment from Kevin Sanders on account, $100.00. May 7, Issued a Credit Memo No. 68 to Mark Parsons for merchandise returned that had sold on account, $72.75 May 9, Issued a check No 895 to Keys Wholesale Invoice 91 less 2% discount. May 10, Received payment from Daisy Rangel on account, $500 Sole no. 63 May 12, Received a Credit Memo from Edible Pursuits for catering credit for event on April 25 for 3450.00 Moy 14, Received poyment from Angel Garcia for half of the amount on account settiement of 32,500.00 Moy 14, Purchosed merchandise from Custom Works on eccount for $395.00 plus 0825 Sales Tox, trvolce No 289 doted May 14 , terms 2/10, r May 15, Recelved credit memo from Custom Works for merchandise purchosed on May 14., $79.00 Moy 17, Sold merchandise on occount to Kevin Sandars, $565.00 plus tax of $46.61 Sale No, 45 Mey 19, Sold merchandise for Cash to Mark Parsons, 579.95 plus tax of 56.60 Sales 46 Moy 21, Issued. Credit Memo 49 to for merchandise returned that hod been scid on account to Dana Lengriew, 583, 45 including tox of 55,23 Moy 23, Issued a Check No. 897 to Custom Works for merchandise purhcosed on May 14. Moy 24, Recehved payment from Eduard Quintana on account, $50000 Moy 25, Sold merchandise on occount to Angel Garcio, 5189.50 plus tax of 516.33 Sole.No. 47 Moy 26, Received peyment from Dane Longviaw on bccount, 3550.65. Moy. 27, Purchased merchandise from Fryes Electronics on account 9478.63 invoice 857 dated Moy 27, terms 2/10, a/30 Moy 28, Sold merchandise on occount to File Home Insert Draw Page Layout Formulas Data Review View Developer Help Power Piv 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