Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need each journal is on separate worksheet. and it should be sales, cash,purchases,cash Disburements and general journal. like as exaples. look the second pic

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

i need each journal is on separate worksheet. and it should be sales, cash,purchases,cash Disburements and general journal. like as exaples. look the second pic of table and see notes up on the excel sheet. thank you

The Elephant Store uses a Sales Journal, a Purchases Journal, a Cash Receipts Journal, a Cash Disbursements Journal, and a General Journal. The Elephant Store uses a perpetual inventory system. The following transactions occurred during June 2022: June 4 Purchased merchandise from Caribou Co. for $6,500 under credit terms of 1/10, n/30, FOB factory. June 6 Sold merchandise to Smith Co. for $8,200 under credit terms of 2/15, n/30, FOB destination. The cost of the merchandise was $5,300. Invoice #1986. June 9 Caribou Co requested a price reduction on the June 4 purchase because the merchandise did not meet specifications. Caribou Co. agreed to a $800 price reduction to resolve the issue. June 10 Paid Glad Movers $200 for shipping charges on the sale of June 6 with cheque #255. June 12 Sold merchandise to Stem Co. for $950 cash. The merchandise cost $420. June 13 Issued a credit memo regarding a $1,400 allowance granted to Smith Co. to cover defective merchandise sold on June 6th. June 13 Paid the balance due to Caribou Co. with cheque #256. June 15 Purchased a $950 printer from Staples Inc. Terms Net 30. June 20 Received Smith Co.'s payment of the amount due from the June 6 sale. Instructions: Note: The General Journal is an all-purpose journal where we record any other transactions NOT recorded in the special journals (Sales, Receipts, Purchase and Cash Disbursements). One mark will be deducted for each transaction recorded on the General Journal that does not belong BW V2 Note: This page has been formatted to print out in Landscape orientation Each Journal is on a separate worksheet. Click the tab at the bottom to pick the journal to use for each transaction. 7 Note: there is no need to use the Accounts Receivable or Accounts Payable label in the Account Debited column, just the name of the cust Column totals are not required 10 Type the date here> 12 The Elephand Store Sales Journal Accounts Receivable DR. Invoice Number PR Sales CR. Cost of Goods Sold DR. Merchandise Inventory CR. Date Account Debited 16 18 19 20 21 2 23 24 28 Sales Cash Receipts Purchases Cash Disburements General Journal a., b., and c. Sales Journal Account Debited Invoice No. Accounts Receivable Dr. Sales Cr. Date Ref. Oct. 4. Petro Corp. 17 Trudeau Co. 25 Golden Corp. 30 Trudeau Co. 204 205 206 207 8,600 5,530 5,520 5,200 24,850 (112)/(401) S1 Cost of Goods Sold Dr. Merchandise Inventory Cr. 5,590 3,595 3,588 3,380 16,153 (505)/(120) General Journal J1 Ref. Debit Credit Date Account Titles and Explanations 260 201 120 260 Oct. 13 Accounts Payable-Chen Corp.... Merchandise Inventory. To record purchase return. Account Credited Date Oct. 7 12 Petro Corp. 14 16 Land 21 25 Trudeau Co. 28 Cash Receipts Journal CR1 COGS Dr. Merch. Other Cash A/R Sales Inventory Accounts Ref. Dr. Cr. Cr. Cr. Cr. 9,610 9,610 6,247 8,600 8,600 8,810 8,810 5,727 140 45,000 45,000 8,640 8,640 5,616 5,530 5,530 9,320 9,320 6,058 95,510 14,130 36.380 23,648 45,000 (101) (112) (401) (505)/(120) (X)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cpa Financial Services A Guide To Fitting The Pieces Together

Authors: Billy Hemby

1st Edition

1958331007, 978-1958331002

More Books

Students also viewed these Accounting questions