Question: please provide how I should enter these transactions in excel ideally thanks in advance Challenge Exercise 02 C2B-1, Brides RECEIVABLES, INVENTORY & SERVICES and COMPANY

please provide how I should enter these transactions in excel ideally

please provide how I should enter these transactions in excel ideally thanks

thanks in advance

Challenge Exercise 02 C2B-1, Brides RECEIVABLES, INVENTORY & SERVICES and COMPANY Modules 1 > Refer to Exercise 1-1b to unzip the 02 C2B-1 Brides.exe file. 2 > Open the 02 C2B-1 Brides file and enter Receivable transactions for May for a company that sells bridal gowns, other dresses, accessories, and repairs (alterations) to dresses as needed. HST is 13%. Brides Company does not print Sales invoices or receipts. Note: All sales are picked up in person; therefore, leave Shipped by field blank. May 3 Issued Sales Order #30 to Marlene's Bridal Fashions for 4 bridesmaid dresses, style BM-126. Each dress will sell for $410.00, plus HST. Accept default terms 2/10, net 30. Total order $1,853.20. Delivery date will be May 27. May 3 Received cheque #689 for $3,330.00 (net of $60.00 discount) as payment in full from Bev's Bridal Shop re outstanding invoice #381. May 5 Retail sale to credit card customer Navneet Banwait of 1 bridal gown, style BG-253, for $1,200.00 and 4 accessories, code AC-30, at $30.00 each (all items plus HST). Credit card authorization #D1962 for $1,491.60. May 6 Sold 3 bridal gowns, style BG-224, to Brenda's Dresses at $800.00 each, plus HST. Terms 2/10, net 30 days. Invoice total $2,712.00. Close message re customer credit limit exceeded. The owner has permitted the transaction. May 9 Sold 3 bridal gowns, style BG-362, at $800.00 each and 10 accessories, code AC-25, at $25.00 each, plus HST, to new customer, Your Actual Name Dresses, contact Your Actual Name, 967 Spadina Street, Markville, Ontario, L3X 2Z9. Phone and fax number are 905-826-3820. Credit limit will be $5,000.00 with terms of 2/10, net 30 days, Invoice total $2,994.50. Close message re inventory dropping below re-order point and post the transaction. More inventory will be ordered on the next purchase order. May 14 Your Actual Name Dresses returned 10 accessories. Return accepted, and credit note referring to invoice #403 sent to customer. May 19 Sold a party dress, style PD-04, at $250.00, plus HST, to Mrs. Petra Kurek for an engagement party. Mrs. Kurek qualifies for the 10% senior's discount Cheque #556 received. May 19 Your Actual Name Dresses cheque #613, for payment in full, was received. May 24 The bank advised that Mrs. Kurek's cheque #556 for $254.25 was returned "Account Closed." Charged a $15.00 Handling Fee. Mrs. Kurek will be sending a certified cheque to cover the error. Use any address information for Mrs. Kurek. May 24 A new customer, Saira Heggie (any address information is acceptable), ordered a dress at $900.00, plus HST. Bridal gown, code BG-143, to be delivered by June 12. Sales Order #31 was issued and a $300.00 cheque, #134, was received as a deposit. Leave discount terms blank. May 25 The bridesmaid dresses ordered on sales order #30 arrived and were picked up by Marlene's Bridal Fashions. Invoice amount per the May 3 order. May 31 The owner, Mrs. Mehta, gave you a bank transfer for $4,000.00, which is for her additional investment in the business. May 31 Marlene's Bridal Fashions sent in a bridesmaid dress for alterations. Issued next invoice for 2 units of 20 minutes (alterations), at $30 each, plus HST. 3 When you have recorded the above entries, print the following: a) Customer Aged Detail Report as at May 31 b) All Journal Entries, for the monthly activity c) General Journal Entries, for the monthly activity d) Sales Journal Entries for May e) Receipts Journal Entries for May

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!