Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The firm's in-house accountant has gone overseas for one month. You have been hired by Scallion Ltd to carry out the accounting duties in the

The firm's in-house accountant has gone overseas for one month. You have been hired by Scallion Ltd to carry out the accounting duties in the accountant's absence. This assignment provides you with the unadjusted trial balance at the end of May and requires you to record typical transactions for a retail business for the last month of the financial year. Once these transactions have been recorded and posted, you are required to complete the accounting cycle by journalising and posting adjusting and closing entries and preparing financial statements.

UNADJUSTED TRIAL BALANCE

The unadjusted trial balance as at 1 June 2023 is presented below:

ACCOUNT NAME 1 June Opening Balances
Cash $ 70,785
Accounts Receivable 25,740
Allowance for doubtful debts 2,645
Inventory 32,400
Office Supplies 1,800
Prepaid General Insurance 3,600
GST Paid 6,300
Equipment 13,500
Machinery 65,000
Truck 46,100
Land 350,000
Accounts Payable 69,300
GST Collected 15,795
Share Capital 340,000
Discount received 13,200
Repairs and maintenance 7,400
Purchases 486,200
Purchases returns & allowances 7,040
Salaries expense 83,600
Sales 789,800
Sales returns & allowances 8,800
Electricity expense 12,100
Telephone expense 2,505
Office expenses 13,500
Discount allowed 8,450

SUBSIDIARY LEDGERS

The individual balances of Accounts receivable and Accounts payable as at 1 June 2023 are shown below. Amounts include GST.

Accounts Receivable Subsidiary Ledger

CUSTOMER 1 June Opening Balances
Croft Ltd $ 2,970
M. Biller 14,850
O. Mowen 7,920
TOTAL 25,740

Accounts Payable Subsidiary Ledger

CREDITOR 1 June Opening Balances
Tumult Ltd $ 17,820
Lynwood Ltd 29,700
Dyson Ltd 21,780
TOTAL 69,300

ACCOUNTING PROCEDURES

Transactions are recorded by the accountant on a daily basis in the appropriate journal. Transactions are posted daily from the General Journal and the Cash Receipts and Cash Payments Journal to the Accounts receivable and Accounts payable subsidiary ledgers. Totals of the special journals are posted to the appropriate accounts at the end of the month.

Note: Amounts are to be recorded as the exact amounts in the journals and ledgers but are to be rounded to the nearest dollar when preparing financial statements.

TRANSACTIONS

The following transactions occurred during June 2023 and are INCLUSIVE of GST where appropriate.

2023

June 1Scallion Ltd shareholders invested $60,000 cash in the business.

Purchased land and an existing retail store for $110,000 of which $77,000 is considered land cost. Paid $33,000 by cheque no. 98 for the retail store and signed a mortgage payable for the balance. The retails store is depreciated over its useful life of 10 years.

2Paid Lynwood Ltd $14,700 less a discount of $594 with cheque no. 99.

Received cheque from M. Biller for $10,000 as part payment of his account

Purchased store furniture on credit terms from Corma Ltd for $7,480, terms n/60.

5Purchased inventory on credit terms from Tumult Ltd $4,400; invoice date 6 June, terms 2/10, n/60.

6Purchased a 3-year fire insurance policy for $792, cheque no. 100.

7Sent cheque no. 101 to Tumult Ltd in full settlement of May invoice

8Purchased inventory for $5,500, cheque no. 102.

Paid Lynwood Ltd $15,000 cheque no. 103 for balance owing on May account.

9Returned unsatisfactory goods to Tumult Ltd and received a credit note for $880.

13Sold inventory to M. Biller on account, $9,020; invoice no. 210, terms 1/10, n/30.

15O. Mowen paid his account in full.

Paid Tumult Ltd amount due for June 6 invoice, cheque no.104.

Cash sales for period to 15 June were recorded today, $3,740.

16Sold inventory to O. Mowen on account $5,170; invoice no. 211, terms 1/10, n/30.

Paid salaries for period to 15 June totaling $2,650, cheque no. 105.

17M. Biller paid the balance of his May invoice.

20Purchased inventory on credit terms, from Lynwood Ltd, $5,390; invoice date 20 June, terms 1/10, n/30.

Sent cheque, no. 106 to Dyson Ltd in full settlement of the account.

22Received account for $143 from M. Parson for items chargeable to office expenses, terms n/30.

23Received inventory returned by O.Mowen and issued a credit note for $2,200.

Received a cheque from M. Biller for invoice no. 210.

26Received a cheque from O. Mowen for balance due on invoice no. 211

Purchased inventory from Dyson Ltd for $35,750, terms, 1/20, n/30.

29Sold inventory worth $15,400 on credit to J. Rowls; invoice no. 212, terms 1/10, n/30.

Paid $220 for electricity expenses, cheque no. 107.

Paid Lynwood Ltd for the invoice dated 20 June, cheque no. 108.

30Purchased inventory on account from Amcor Ltd $26,400, terms 2/10, n/30.

Cash sales from 16 June to 30 June were $2,145.

Paid salaries for period 16-30 June totaling $2,850, cheque no. 109.

Purchased office supplies for $330, cheque no. 110.

Received account from C. Bond for $110 for delivery expenses for the month.

Sold inventory on credit to O. Mowen for $17,600, invoice no. 213, terms 1/10, n/30.

Purchased printer for use in the business office at a cost of $825 using a short-term loan.

Required

a) Record the transactions in the special journals in the following order: sales journal, purchases journal, cash receipts, cash payments and general journal. You will need to use the general journal for more adjusting entries coming up, so make sure you leave room. The business uses sales and purchases journals for inventory transactions on credit only. Returns are processed through the general journal. (Remember that special journals replace the general journal, so transactions will be recorded in a special journal or the general journal but not both).

b) Prepare the accounts receivable control account as it would appear in the general ledger at the end of the reporting period, together with the related subsidiary ledger. Provide the accounts payable control account as per the general ledger at the end of the financial year and the subsidiary ledger. Scallion Ltd. Accounting Transactions June 2023 a) Special Journals:

1. Sales Journal:

Date Invoice No. Customer Account Credited Amount (GST incl.) June 13 210 M. Biller Accounts Receivable $9,020 June 16 211 O. Mowen Accounts Receivable $5,170 June 29 212 J. Rowls Accounts Receivable $15,400 June 30 213 O. Mowen Accounts Receivable $17,600 2. Purchases Journal:

Date Invoice No. Supplier Account Debited Amount (GST incl.) June 5 - Tumult Ltd Accounts Payable $4,400

Explanation:

Scallion Ltd. Accounting Transactions June 2023 a) Special Journals:

1. Sales Journal:

Date Invoice No. Customer Account Credited Amount (GST incl.) June 13 210 M. Biller Accounts Receivable $9,020 June 16 211 O. Mowen Accounts Receivable $5,170 June 29 212 J. Rowls Accounts Receivable $15,400 June 30 213 O. Mowen Accounts Receivable $17,600 2. Purchases Journal:

Date Invoice No. Supplier Account Debited Amount (GST incl.) June 5 - Tumult Ltd Accounts Payable $4,400 June 20 - Lynwood Ltd Accounts Payable $5,390 June 26 - Dyson Ltd Accounts Payable $35,750 June 30 - Amcor Ltd Accounts Payable $26,400 3. Cash Receipts Journal:

Date Description Account Credited Amount (GST incl.) June 2 M. Biller (partial payment) Accounts Receivable $10,000 June 7 Tumult Ltd (May invoice) Accounts Payable $ June 15 O. Mowen (full payment) Accounts Receivable $7,920 June 15 Tumult Ltd (June 6 invoice) Accounts Payable $4,400 June 17 M. Biller (May invoice balance) Accounts Receivable $4,850 June 23 M. Biller (invoice 210) Accounts Receivable $9,020 June 26 O. Mowen (invoice 211) Accounts Receivable $5,170 June 30 J. Rowls (invoice 212) Accounts Receivable $15,400 June 30 Cash Sales (to June 15) Sales $3,740 June 30 Cash Sales (June 16-30) Sales $2,145 4. Cash Payments Journal:

Date Cheque No. Description Account Debited Amount (GST incl.) June 1 98 Land & Retail Store Land $77,000 June 1 98 Land & Retail Store Mortgage Payable $33,000 June 2 99 Lynwood Ltd (partial payment) Accounts Payable $14,700 June 5 100 Fire Insurance Prepaid General Insurance $792 June 6 101 Tumult Ltd (May invoice) Accounts Payable $ June 8 102 Inventory Inventory $5,500 June 8 103 Lynwood Ltd (full payment) Accounts Payable $15,000 June 15 104 Tumult Ltd (June 6 invoice) Accounts Payable $4,400 June 16 105 Salaries Salaries Expense $2,650 June 20 106 Dyson Ltd (full payment) Accounts Payable $21,780 June 22 M. Parson (office expenses) Office Expenses $143 June 26 107 Electricity Expense Electricity Expense $220 June 26 108 Lynwood Ltd (June 20 invoice) Accounts Payable $5,390

june 29 109

make only the financial statement for above

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

Intermediate Accounting

Authors: Loren A Nikolai, D. Bazley and Jefferson P. Jones

10th Edition

324300980, 978-0324300987

More Books

Students also viewed these Accounting questions

Question

=+7. For the cost matrix of Exercise 3,

Answered: 1 week ago