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, 2020. The purpose of preparing the schedule of accounts receivable is to verify that the sum of the customer balances recorded in the accounts receivable subsidiary ledger is equal to the balance of the Accounts 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 ledgers: 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. (Q=900.schedulesOfAccounts) Bean Counters Coffeehouse Schedule of Accounts Receivable June 30, 2020 Account No. Name Balance ($) 110-1 ARC - Quick Bolt Coffee 110-2 ARC - Kava Java 110-3 ARC - SloZone 4 110-4 ARC - Central Coffee 110-5 ARC - Jandesh's Hot Spot 110-6 ARC - Con's Coffee Total Bean Counters Coffeehouse Schedule of Accounts Payable June 30, 2020 Account No. Name Terms Balance ($) 210-1 APC - Brazil Imports Group 2/10, n/30 210-2 APC - Jordo Gourmet Coffee 1/15, n/30 210-3 APC - Dominga Wholesalers net 30 210-4 APC - East Tangiers Cooperative 2/10, n/30 210-5 APC - Abejundio Coffee net 30 210-6 APC - Buena Vista Coffee net 30 Total SUBSIDIARY LEDGERS POST ADJUSTING Account: ARC - Quick Bolt Coffee Account No. 110-1 Date Description Ref. Debit Credit Balance 2,930 DR May Jun 31 Balance 9 Repayment 30 Adjusted Balance CRJ 2,930 0 Jun 0 Account: ARC - Kavajava Account No. 110-2 Date Description Ref. Debit Credit Balance May 31 Balance 4,036 DR Jun 30 Adjusted Balance 4,036 DR Account: ARC - SloZone Account No. 110-3 Date Description Ref. Debit Credit Balance May 31 | Balance Jun SJ 4,900 10 Credit sale 19 Sales return 12,028 DR 16,928 DR 12,028 DR Jun GJ 4,900 Jun 24 Repayment CRJ 12,028 0 Jun 30 Adjusted Balance 0 Account: ARC - Central Coffee Account No. 110-4 Date Ref. Debit Credit Balance 4,913 DR May Jun Description 31 Balance 29 Repayment 30 Adjusted Balance CRJ 4,913 0 Jun 0 Account: ARC - Jandesh's Hot Spot Account No. 110-5 Date Ref. Debit Credit Balance May 2,759 DR Jun Description 31 Balance 5 Repayment 15 Credit sale 23 Credit sale CRJ 2,759 0 Jun SJ 3,990 Jun SJ 50,020 3,990 DR 54,010 DR 54,010 DR Jun 30 Adjusted Balance Account: ARC - Con's Coffee Account No. 110-6 Date Description Ref. Debit Credit Balance May 31 Balance Jun 20 Repayment CRJ 1,200 4,446 DR 3,246 DR 15,216 DR 16,416 DR Jun 25 Credit sale SJ 11,970 1,200 Jun 30 Not-Sufficient-Funds (NSF) check GJ Jun 30 Adjusted Balance 16,416 DR Account: APC - Brazil Imports Group Account No. 210-1 Date Description Ref. Debit Credit Balance May 31 Balance 2,417 CR Jun CPJ 2,417 Jun PJ 7,360 7,360 CR 14 Repayment 16 Credit purchase 28 Repayment 30 Adjusted Balance Jun CPJ 7,360 0 Jun 0 Account: APC - Jordo Gourmet Coffee Account No. 210-2 Date Description Ref. Debit Credit Balance May 31 Balance 3,427 CR Jun CPJ 3,427 0 10 Repayment 30 Adjusted Balance Jun 0 Account: APC - Dominga Wholesalers Account No. 210-3 Date Description Ref. Debit Credit Balance May 31 Balance 25,489 CR 25,489 CR Jun 30 Adjusted Balance Account: APC - East Tangiers Cooperative Account No. 210-4 Date Ref. Debit Credit Balance May Description 31 Balance 30 Credit purchase 30 Adjusted Balance 3,647 CR 9,167 CR Jun PJ 5,520 Jun 9,167 CR Account: APC - Abejundio Coffee Account No. 210-5 Date Description Ref. Debit Credit Balance May 31 Balance 4,680 CR Jun CPJ 4,680 0 Jun 13 Repayment 17 Credit purchase 28 Purchase return PJ 3,900 3,900 CR Jun GJ 1,800 2,100 CR 2,100 CR Jun 30 Adjusted Balance Account: APC - Buena Vista Coffee Account No. 210-6 Date Description Ref. Debit Credit Balance May 31 | Balance 4,898 CR Jun CPJ 4,898 0 Jun 6 Repayment 8 Credit purchase 30 Adjusted Balance PJ 4,200 4,200 CR 4,200 CR Jun GENERAL LEDGER POST ADJUSTING Account: Cash Account No. 100 Date Description Ref. Debit Credit Balance 71,227 DR May Jun CRJ 129,381 200,608 DR Jun CPJ 48,117 152,491 DR Jun 31 Balance 30 Total from cash receipts journal 30 Total from cash payments journal 30 Interest received from the bank 30 Not-Sufficient-Funds (NSF) check 30 Bank service charge 30 Adjusted Balance GJ 585 153,076 DR Jun GJ 1,200 151,876 DR Jun GJ 10 151,866 DR 151,866 DR Jun Account: ARC - Accounts Receivable Control Account No. 110 Date Description Ref. Debit Credit Balance 31 Balance May Jun 31,112 DR 26,212 DR 19 Sales return from SloZone GJ 4.900 Jun SJ 70,880 97,092 DR 73,262 DR Jun CRJ 23,830 30 Total from sales journal 30 Total from cash receipts journal 30 Not-Sufficient-Funds (NSF) check 30 Adjusted Balance Jun GJ 1,200 74,462 DR Jun 74,462 DR Account: Merchandise Inventory Account No. 120 Date Description Ref. Debit Credit Balance May 31 Balance GJ 2,800 Jun Jun GJ 1,800 Jun SJ 41,100 78,578 DR 81,378 DR 79,578 DR 38,478 DR 59,458 DR 21,404 DR 23,252 DR 23,252 DR 19 Sales return from SloZone 28 Purchase return to Abejundio Coffee 30 Total from sales journal 30 Total from purchases journal 30 Total from cash receipts journal 30 Total from cash payments journal 30 Adjusted Balance Jun PJ 20,980 Jun CRJ 38,054 Jun CPJ 1,848 Jun Account: Office Supplies Account No. 130 Date Description Ref. Debit Credit Balance May 31 Balance Jun 5 Cash purchase CPJ 401 3,981 DR 4,382 DR 3,944 DR 3,944 DR Jun GJ 438 30 Supplies used 30 Adjusted Balance Jun Account: Prepaid Rent Account No. 140 Date Description Ref. Debit Credit Balance 31 Balance 0 May Jun 9,500 9,500 DR Jun 1 Prepaid rent 30 Rent expired 30 Adjusted Balance GJ 4,750 4,750 DR Jun 4,750 DR Account: Prepaid Advertising Account No. 141 Date Description Ref. Debit Credit Balance May 31 Balance 12,000 DR Jun 30 Benefits consumed GJ 4,000 8,000 DR Jun 30 Adjusted Balance 8,000 DR Account: Prepaid Insurance Account No. 142 Date Description Ref. Debit Credit Balance May 31 Balance 4,200 DR Jun 30 Insurance expired GJ 840 3,360 DR Jun 30 Adjusted Balance 3,360 DR Account: Office Furniture Account No. 150 Date Description Ref. Debit Credit Balance May 31 Balance 7,000 DR Jun 30 Adjusted Balance 7,000 DR Account: Accum Depn: Office Furniture Account No. 151 Date Description Ref. Debit Credit Balance May 31 Balance 1,083 CR 1,166 CR Jun GJ 83 30 Depreciation - one month 30 Adjusted Balance Jun 1,166 CR Account: Office Equipment Account No. 160 Date Description Ref. Debit Credit Balance May 31 Balance 51,000 DR Jun 30 Adjusted Balance 51,000 DR Account: Accum Depn: Office Equipment Account No. 161 Date Description Ref. Debit Credit Balance May 31 Balance 16,875 CR Jun GJ 375 17,250 CR 30 Depreciation - one month 30 Adjusted Balance Jun 17,250 CR Account: APC - Accounts Payable Control Account No. 210 Date Ref. Debit Credit Balance May Jun 1,800 Description 31 Balance 28 Purchase return to Abejundio Coffee 30 Total from purchases journal 30 Total from cash payments journal 30 Adjusted Balance GJ PJ Jun 20,980 44,558 CR 42,758 CR 63,738 CR 40,956 CR 40,956 CR Jun 22,782 Jun Account: Wages Payable Account No. 220 Ref. Debit Credit Balance 1,194 CR Date Description May 31 Balance Jun 4 Paid staff wages Jun 30 Accrued wages expense Jun 30 Adjusted Balance CPJ 1,194 0 GJ 1,860 1,860 CR 1,860 CR Account: Electricity Payable Account No. 221 Date Ref. Debit Credit Balance 917 CR May Jun Description 31 Balance 7 Paid electricity bill 30 Accrued electricity expense 30 Adjusted Balance CPJ 854 63 CR Jun GJ 240 303 CR 303 CR Jun Account: Water Payable Account No. 222 Ref. Debit Credit Balance Date Description May 31 Balance Jun 30 Accrued water expense Jun 30 Adjusted Balance GJ 1,155 1,120 CR 2,275 CR 2,275 CR Account: Interest Payable Account No. 225 Ref. Debit Credit Balance 0 Date Description May 31 Balance Jun 30 Accrued interest expense Jun 30 Adjusted Balance GJ 200 200 CR 200 CR Account: Bank Loan Payable Account No. 250 Ref. Debit Credit Balance 0 Date Description May 31 Balance Jun 1 Loan from Earth Bank Jun 30 Adjusted Balance CRJ 40,000 40,000 CR 40,000 CR Account: Common Stock Account No. 300 Ref. Debit Credit Balance Date Description May 31 Balance Jun 30 Adjusted Balance 45,000 CR 45,000 CR Account: Retained Earnings Account No. 301 Ref. Debit Credit Date Description May 31 Balance Jun 30 Adjusted Balance Balance 148,351 CR 148,351 CR Account: Income Summary Account No. 310 Ref. Debit Credit Balance Date Description May 31 Balance Jun 30 Adjusted Balance 0 0 Account: Sales Revenue Account No. 400 Ref. Debit Credit Balance 0 Date Description May 31 Balance Jun 30 Total from sales journal Jun 30 Total from cash receipts journal Jun 30 Adjusted Balance SJ 70,880 CRJ 65,844 70,880 CR 136,724 CR 136,724 CR Account: Sales Returns and Allowances Account No. 401 Date Ref. Debit Credit Balance May Jun Description 31 Balance 19 Sales return from SloZone 30 Adjusted Balance GJ 4,900 4,900 DR 4,900 DR Jun Account: Sales Discounts Account No. 402 Ref. Debit Credit Balance 0 Date Description May 31 Balance Jun 30 Total from cash receipts journal Jun 30 Adjusted Balance CRJ 293 293 DR 293 DR Account: Interest Revenue Account No. 403 Ref. . Debit Credit Balance 0 Date Description May 31 Balance Jun 30 Interest received from the bank Jun 30 Adjusted Balance GJ 585 585 CR 585 CR Account: Cost of Goods Sold Account No. 500 Date Description Ref. Debit Credit Balance May 31 Balance 0 Jun 19 Sales return from SloZone GJ 2,800 2,800 CR Jun SJ 41,100 Jun 30 Total from sales journal 30 Total from cash receipts journal 30 Adjusted Balance CRJ 38,054 38,300 DR 76,354 DR 76,354 DR Jun Account: Advertising Expense Account No. 511 Date Description Ref. Debit Credit Balance May 31 Balance 0 Jun 30 Benefits consumed GJ 4,000 4,000 DR Jun 30 Adjusted Balance 4,000 DR Account: Wages Expense Account No. 516 Date Description Ref. Debit Credit Balance May 31 Balance 0 Jun 30 Total from cash payments journal CPJ 7,438 7,438 DR Jun 30 Accrued wages expense GJ 1,860 9,298 DR Jun 30 Adjusted Balance 9,298 DR Account: Rent Expense Account No. 540 Date Description Ref. Debit Credit Balance May 31 Balance 0 Jun 30 Rent expired GJ 4,750 4,750 DR Jun 30 Adjusted Balance 4,750 DR Account: Electricity Expense Account No. 541 Date Description Ref. Debit Credit Balance May 31 Balance 0 Jun 30 Accrued electricity expense GJ 240 240 DR Jun 30 Adjusted Balance 240 DR Account: Water Expense Account No. 542 Date Description Ref. Debit Credit Balance May 31 Balance 0 Jun 30 Accrued water expense GJ 1,155 1,155 DR Jun 30 Adjusted Balance 1,155 DR Account: Insurance Expense Account No. 543 Date Description Ref. Debit Credit Balance May 31 Balance 0 Jun 30 Insurance expired GJ 840 840 DR Jun 30 Adjusted Balance 840 DR Account: Office Supplies Expense Account No. 544 Date Description Ref. Debit Credit Balance May 31 Balance Jun GJ 438 438 DR 30 Supplies used 30 Adjusted Balance Jun 438 DR Account: Salary Expense Account No. 545 Date Description Ref. Debit Credit Balance May 31 Balance 0 Jun CPJ 4,100 4,100 DR 30 Owner salary 30 Adjusted Balance Jun 4,100 DR Account: Depn Expense: Office Furniture Account No. 560 Date Description Ref. Debit Credit Balance 31 Balance 0 May Jun GJ 83 83 DR 30 Depreciation - one month 30 Adjusted Balance Jun 83 DR Account: Depn Expense: Office Equipment Account No. 561 Date Description Ref. Debit Credit Balance May 31 Balance 0 Jun GJ 375 375 DR 30 Depreciation - one month 30 Adjusted Balance Jun 375 DR Account: Interest Expense Account No. 571 Date Description Ref. Debit Credit Balance May 31 Balance Jun 30 Accrued interest expense GJ 200 200 DR Jun 30 Adjusted Balance 200 DR Account: Admin. Expense - Bank Charges Account No. 572 Date Description Ref. Debit Credit Balance May 31 Balance 0 Jun 30 Bank service charge GJ 10 10 DR Jun 30 Adjusted Balance 10 DR