Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Now that all adjusting entries have been posted to the general ledger, you are asked to prepare the schedule of accounts receivable and the schedule

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Now that all adjusting entries have been posted to the general ledger, you are asked to prepare the schedule of accounts receivable and the schedule of accounts payable as at June 30, 2019. The purpose of preparing the schedule of accounts receivable is to verify that the sum of the customer Receivable control account in the general ledger. Similarly, the purpose of the schedule of accounts payable is to confirm that the sum of the supplier balances recorded in the accounts payable subsidiary ledger is equal to the balance of the Accounts Payable control account in the general ledger. Instructions for schedules of accounts Using the subsidiary ledgers and the general ledger 1) Create a schedule of accounts receivable as at the end of June. 2) Create a schedule of accounts payable as at the end of June. Remember to enter all answers to the nearest whole dollar. Back-On-Track functionality Please note that any answers from previous pages carried through onto this page (either on the page or in a popup information page) have been reset, if necessary, to the correct answers. Your particular answers from previous pages are no longer shown. (0-900.schedulesOfAccounts) Cover 2 Cover Schedule of Accounts Receivable June 30, 2019 Account No. Name Balance ($) 110-1 ARC Attic Books 110-2 ARC - Cliff s Notes 110-3 ARC Cough-up bookstore 110-4 ARC Bovine & Hobbitson 110-5 ARC Amazone.com 110-6 ARC Hoarders Total Cover 2 Cover Schedule of Accounts Payable June 30, 2019 Account No. Name Terms Balance () 210-1 APC Deterministic Garage 210-2 APC Albatross 210-3 APC Polar Bear Books 210-4 APC Books R Us 210-5 APC Booked Inn 210-6 APC Noir Novels 2/10, /30 1/15, n/30 net 30 2/10, /30 net 30 net 30 Total SUBSIDIARY LEDGERS POST ADJUSTING Account: ARC - Attic Books Account No. 110-1 Description Date May 31 Balance Jun13Repayment Jun 30Adjusted Balance Credit Balance 5,000 DR CRJ 5,000 Account: ARC - Cliff's Notes Account No. 110-2 Description Date May 31 Balance Jun 30Adjusted Balance Credit Balance 6,090 DR 6,090 DR Account: ARC - Cough-up bookstore Account No. 110 -3 Date May 31 Balance Jun 5 Credit sale Jun 17 Repayment Jun 30Adjusted Balance Description Ref Credit Balance 49,131 DR 59,904 DR 0 SJ 10,773 CRJ 59,904 Account: ARC Bovine & Hobbitson Account No. 110-4 Description Date May 31 Balance Jun29 Repayment Jun 30Adjusted Balance Credit Balance 5,805 DR CRJ 5,805 Account: ARC - Amazone.com Account No. 110-5 Description Date May 31 Balance Jun15 Credit sale Jun 30Adjusted Balance Credit Balance 0 56,175 DR 56,175 DR SJ 56,175 Account: ARC Hoarders Account No. 110-6 Description Ref Date May 31 Balance Jun 11Credit sale Jun 20 Repayment Jun 22 Credit sale Jun 30 Not-Sufficient-Funds (NSF) check Jun 30Adjusted Balance Balance SJ CRJ SJ GJ 0 26,733 DR 9,733 DR 10,531 DR 27,531 DR 27,531 DR 26,733 17,000 798 17,000 Account: APC Deterministic Garage Account No. 210-1 Date May 31Balance Jun 2 Credit purchase Jun 23 Repayment Jun 30Adjusted Balance Description Ref, Credit Balance 8,568 CR 13,068 CR 0 PJ 4,500 CPJ 13,068 Account: APC -Albatross Account No. 210-2 Date May 31Balance Jun 2 Repayment Jun 30Adjusted Balance Description Credit Balance 6,700 CR CPJ 6,700 0 Account: APC Polar Bear Books Account No. 210-3 Description Credit Date May 31 Balance Jun 2 Credit purchase Jun 21 Purchase return Jun 23 Repayment Jun 30Adjusted Balance Balance PJ GJ CPJ 40,938 CR 44,898 CR 44,258 CR 0 3,960 640 44,258 Account: APC - Books R Us Account No. 210-4 Description Ref Date May 31 Balance Jun3Repayment Jun 30 Credit purchase Jun 30Adjusted Balance Credit Balance 7,600 CR CPJ 7,600 PJ 4,200 4,200 CR 4,200 CR Account: APC - Booked Inn Account No. 210-5 Description Ref Date May 31 Balance Jun 12 Repayment Jun 30Adjusted Balance Debit Credit Balance 9,900 CR CPJ 9,900 0 Account: APC - Noir Novels Account No. 210-6 Date May 31 Balance Jun 30Adjusted Balance Description Ref Debit Credit Balance 0 GENERAL LEDGER POST ADJUSTING Account: Cash Account No. 100 Description Date May 31 Balance Jun 30 Total from cash receipts journal Jun 30 Total from cash payments journal Jun 30 Interestreceived from the bank Jun 30 Not-Sufficient-Funds (NSF) check Jun 30 Bank service charge Jun 30Adjusted Balance Ref Balance 73,154 DR 344,608 DR 228,975 DR 229,573 DR 212,573 DR 212,563 DR 212,563 DR CRJI 271,454 CPJ GJ GJ GJ 115,633 598 17,000 10 Account: Short-term Investments Account No. 102 Description Ref Date May 31 Balance Jun 30Adjusted Balance Debit Credit Balance 23,000 DR 23,000 DR Account: Interest Receivable Account No. 112 Date May 31 Balance Jun 30 Accrued interest revenue Jun 30Adjusted Balance Description Ref Credit Balance GJ 115 115 DR 115 DR Account: ARC -Accounts Receivable Control Account No. 110 Description Date May 31 Balance Jun 30 Total from sales journal Jun 30 Total from cash receipts journal Jun 30 Not-Sufficient-Funds (NSF) check Jun 30Adjusted Balance Ref Balance SJ CRJ GJ 66,026 DR 160,505 DR 72,796 DR 89,796 DR 89,796 DR 94,479 87,709 17,000 Account: Merchandise Inventory Account No. 120 Description Credit Balance Date May 31 Balance Jun 21 Purchase return to Polar Bear Books Jun30 Total from sales journal Jun 30 Total from purchases journal Jun 30 Total from cash receipts journal Jun 30 Total from cash payments journal Jun 30Adjusted Balance Ref Debit GJ SJ PJ CRJ CPJ 115,840 DR 115,200 DR 70,580 DR 83,240 DR 18,240 DR 26,720 DR 26,720 DR 640 44,620 12,660 65,000 8,480 Account: office Supplies Account No. 130 Date May 31 Balance Jun 30 Supplies used Jun 30Adjusted Balance Description Ref, Debit Credit Balance 3,266 DR 2,450 DR 2,450 DR GJ 816 Account: Prepaid Rent Account No. 140 Date May 31 Balance Jun 15 Prepaid rent Jun 30 Rent expired Jun 30Adjusted Balance Description Ref Credit Balance 1,600 DR 4,800 DR 1,600 DR 1,600 DR CPJ 3,200 GJ 3,200 Account: Prepaid Advertising Account No. 141 Description Ref Credit Date May 31 Balance Jun 30 Benefits consumed Jun 30Adjusted Balance Balance 9,000 DR 6,000 DR 6,000 DR GJ 3,000 Account: Prepaid Insurance Account No. 142 Date May 31Balance Jun 30Insurance expired Jun 30Adjusted Balance Description Ref Debit Credit Balance 2,500 DR 2,000 DR 2,000 DR GJ 500 Account: Office Furniture Account No. 150 Date May31 Balance Jun | 301 Adjusted Balance Description Ref, Debit Credit Balance 9,000 DR 9,000 DR Account: Accum Depn: Office Furniture Account No. 151 Description Ref Credit Date May 31 Balance Jun 30 Depreciation one month Jun 30Adjusted Balance Debit Balance 1,889 CR 2,000 CR 2,000 CR GJ Account: Office Equip Account No. 160 ment Date May 31 Balance Jun 30Adjusted Balance Description Ref Debit Credit Balance 51,000 DR 51,000 DR Account: Accum Depn: Office Equipment Account No. 161 Date May 31Balance Jun 30 Depreciation one month Jun 30Adjusted Balance Description Ref, Credit Balance 19,792 CR 20,188 CR 20,188 CR GJ 396 Account: APC - Accounts Payable Control Account No. 210 Description Credit Date May 31 Balance Jun 21 Purchase return to Polar Bear Books Jun 30 Total from purchases journal Jun 30 Total from cash payments journal Jun 30Adjusted Balance Balance GJ PJ CPJ 73,706 CR 73,066 CPR 85,726 CR 4,200 CR 4,200 CR 640 12,660 81,526 count: Wages Payable Account No. 220 Ac Description Ref Date May 31 Balance Jun4Staff wages Jun 30 Accrued wages expense Jun 30Adjusted Balance Credit Balance 2,000 CR CPJ 2,000 GJ 3,540 3,540 CR 3,540 CR Account: Electricity Payable Account No. 221 Description Ref Date May 31 Balance Jun 13 Paid electricity bill Jun 30 Accrued electricity expense Jun 30Adjusted Balance Credit Balance 1,275 CR 51 CR 434 CR 434 CR CPJ 1,224 GJ 383 Account: Water Payable Account No. 222 Date May 31 Balance Jun 30 Accrued water expense Jun 30Adjusted Balance Description Ref Credit Balance 128 CR 245 CR 245 CR GJ Account: Interest Payable Account No. 225 Description Date May 31 Balance Jun 30Accrued interest expense Jun 30Adjusted Balance Credit Balance GJ 200 200 CR 200 CR Account: Sales Tax Payable Account No. 240 Description Credit Date May 31 Balance Jun 30 Total from sales journal Jun 30 Total from cash receipts journal Jun 30Adjusted Balance Ref Debit Balance 15,775 CR 20,274 CR 27,119 CR 27,119 CR SJ 4,499 CRJ 6,845 Account: Bank Loan Payable Account No. 250 Date May 31 Balance JunLoan from EastPac Bank Jun 30Adjusted Balance Description Ref Credit Balance CRJ 40,000 40,000 CR 40,000 CR Account: Common Stock Account No. 300 Description Ref Date May 31 Balance Jun 30Adjusted Balance Debit Credit Balance 60,000 CR 60,000 CR Account: Retained Earnings Account No. 301 Description Ref Date May 31 Balance Jun 30Adjusted Balance Credit Balance 179,821 CR 179,821 CR Account: Income Summary Account No. 310 Date May 31 Balance Jun 30Adjusted Balance Description Ref Credit Balance 0 Account: Sales Revenue Account No. 400 Date May 31 Balance Jun 30 Total from sales journal Jun 30 Total from cash receipts journal Jun 30Adjusted Balance Description Ref Balance SJ 89,980 89,980 CR 226,880 CR 226,880 CR CRJ 136,900 Account: Interest Revenue Account No. 403 Date May 31 Balance Jun 30 Interest received from the bank Jun 30 Accrued interest revenue Jun 30Adjusted Balance Description Ref Credit Balance GJ 598 598 CR 713 CR 713 CR GJ 115 Account: Cost of Goods Sold Account No. 500 Description Date May 31 Balance Jun 30 Total from sales journal Jun30 Total from cash receipts journal Jun 30Adjusted Balance Ref Balance 0 44,620 DR 109,620 DR 109,620 DR SJ 44,620 CRJ 65,000 Account: Advertising Expense Account No. 511 Date May 31 Balance Jun 30 Benefits consumed Jun 30Adjusted Balance Description Credit Balance GJ 3,000 3,000 DR 3,000 DR count: Wages Expense Account No. 516 Date May 31 Balance Jun 30 Total from cash payments journal Jun 30Accrued wages expense Jun 30 Adjusted Balance Description Credit Balance CPJ 13,803 DR 17,343 DR 17,343 DFR 13,803 GJ 3,540 Account: Rent Expense Account No. 540 Date May 31 Balance Jun | 30 |Rent expired Jun 30Adjusted Balance Description Ref, Credit Balance GJ 3,200 3,200 DR 3,200 DR Account: Electricity Expense Account No. 541 Description Credit Date May 31 Balance Jun 30 Accrued electricity expense Jun 30Adjusted Balance Balance GJ 383 383 DR 383 DR Account: Water Expense Account No. 542 Description Credit Date May 31 Balance Jun 30 Accrued water expense Jun 30Adjusted Balance Balance 0 117 DR 117 DR GJ Account: Insurance Expense Account No. 543 Date May 31 Balance Jun 30Insurance expired Jun 30Adjusted Balance Description Ref, Credit Balance GJ 500 500 DR 500 DR Account: Office Supplies Expense Account No. 544 Description Credit Date May 31 Balance Jun 30 Supplies used Jun 30Adjusted Balance Balance GJ 816 816 DR 816 DR Account: Salary Expense Account No. 545 Date May 31 Balance Jun 30 Owner salary Jun 30Adjusted Balance Description Ref Credit Balance CPJ 5,400 5,400 DR 5,400 DR Account: Depn Expense: Office Furniture Account No. 560 Description Date May 31 Balance Jun 30 Depreciation one month Jun 30Adjusted Balance Credit Balance GJ 111 DR 111 DR Account: Depn Expense: Office Equipment Account No. 561 Date May 31 Balance Jun 30 Depreciation one month Jun 30Adjusted Balance Description Credit Balance GJ 396 396 DR 396 DR Account: Interest Expense Account No. 571 Date May 31 Balance Jun 30 Accrued interest expense Jun 30Adjusted Balance Description Credit Balance GJ 200 200 DR 200 DR Account: Admin. Expense Bank Charges Account No. 572 Description Date May 31 Balance Jun 30 Bank service charge Jun 30Adjusted Balance Credit Balance GJ 10 10 DR 10 DR

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

More Books

Students also viewed these Accounting questions