Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What did you guys get for an answer? 1. EX 07.01 Bank reconciliation and entries Instruction Chart of Accounts Amount Descriptions Bank Reconciliation Journal HI
What did you guys get for an answer?
1. EX 07.01 Bank reconciliation and entries Instruction Chart of Accounts Amount Descriptions Bank Reconciliation Journal HI 2 EX 07.02 3. EX07.03 Instructions 4. EX.07.18 ALGO 5. PR.07.01 Beeler Future Company deposits al cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required to reconcile the bank statement as of June 30, 2012, have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters. Al checks were written for payments on account 6. PR.07.04ABLANKSHEET 7. PR.07.05A BLANKSHEET CASH ACCOUNT $9,317.40 Balance as of June 1 CASH RECEIPTS FOR MONTH OF JUNE 9223.76 DUPLICATE DEPOSIT TICKETS Date and amount of each deposit in June Date Amount Date Date Amount Amount $996.61 June 1 $1,080.50 June 10 June 22 $89734 1. EX 07.01 Bank reconciliation and entries Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2. EX 07.02 3. EX.07.03 Instructions 3 15 4. EX 07. 18. ALGO 854.17 840 50 882.95 1,606 74 24 30 94721 1.117.74 17 5. PROT01A 6. PR.07.04A BLANKSHEET Check No 754 Amount $44975 7. PR OTOSA BLANKSHEET CHECKS WRITTEN Number and amount of each check issued in June Check No Amount Check No. Amount 740 $23.50 747 Vold 741 49515 $450.90 742 501.90 640.13 743 761.30 750 27677 744 5068 751 209.37 745 117.25 752 53701 745 298.66 753 380.95 755 756 27275 11395 407.95 757 758 250 60 90150 759 750 48539 1. EX 07.01 Bank reconciliation and entries Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2. EX.07.02 3. EX 07.03 Instructions 4. EX07.18 ALGO Total amount of checks issued in June 58.38566 5. PROT01A BANK RECONCILIATION FOR PRECEDING MONTH 6. PR.0704A BLANKSHEET 7. PROT05A BLANKSHEET Beeler Furniture Company Bank Reconciliation May 31, 2072 Cash balance according to bank statement Add Deposit in transit on May 31 Deduct: Outstanding Check No.731 $9.41.20 690.25 $162.15 1. EX.07.01 Bank reconciliation and entries C Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2. EX 07.02 3. EX 07.03 345.95 4. EX 07.18 ALGO 251.00 5. PR.07.01A 6. PROZOA BLANKSHEET Instructions Outstanding Check No. 736 Outstanding Check No.758 Outstanding Check No.799 Total deductions Adjusted balance (2005) 59.317.40 7. PR OTOSA BLANKSHEET - Cash balance according to company's seconds 11 Deduct: Bank senior changes 12 usted balance 59.352.50 (35.00 $931740 Bank reconciliation and entries 1. EX.07.01 2 Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2. EX 07.02 3. EX 07.03 Instructions Refer to the une Bank Statement 4. EX.07.18 ALGO 5. PRO701A 6. PR.07.04A BLANKSHEET 7. PR 07 05A BLANKSHEET Required: 1. Prepared a bank reconciliation as sof June 30, 2012. Ferrors in recording deposits or checks are discovered, assume that the errors were made by the company. Assume that all deposits are from cash sales All checks are written to satisfy accounts payable Refer to the Amount Descriptions is provided for the exact wording of the answer choices for text entries "Add & Deduct will automatically appear is required Round your answers to two decimal pieces. For those bores in which you must enter subtracted or negative numbers use a minus sign 2 Joumalize the necessary entries. Refer to the Chat of Accounts for exact wording of account stes. Round your answers to ho decine pieces. 2. What is the amount of Cash that should appear on the balance sheet as of June 30, 2012? 4. Assume that a canceled check for $390 has been incorrectly recorded by the bank as $900. Brieflyplain how the error would be included in a bank reconciliation and how it should be corrected Bank reconciliation and entries 1. EX 07.01 Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2 EX 07.02 3. EX 07.03 Chart of Accounts 4. EX.07.18 ALGO Beeler Furniture Company General Ledger 5. PR 07.01A 6. PROT OLA BLANKSHEET REVENUE 410 Sales 610 Interest Revenue 7. PROTOSA BLANKSHEET ASSETS 110 Cash 111 Pety Cash 120 Accounts Receivable 131 Notes Receivable 141 Merchandise Inventory 145 Ofice Supplies 145 Store Supplies 151 Prepaid insurance 181 Land EXPENSES 510 Cost of Merchandise Sold 515 Credit Card Expense 515 Cash Short and Over 520 Salaries Expense 531 Advertising Epe Bank reconciliation and entries 1. EX.07.01 Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2. EX 07.02 3. EX 07.03 x 4. EX07.18 ALGO 5. PR.07.01A 6. PR.07.DA BLANKSHEET 7. PROPOSABLANICSHEET Chart of Accounts 181 Land 191 Otice Equipment 192 Accumulated Depreciation Office Equipment 193 Store Equipment 194 Accumulated Depreciation Store Equipment 531 Advertising Expense 532 Delivery Expense 533 Insurance Expense 534 Ole Supplies Expense 535 Rent Expense 536 Repairs Expense 537 Seling Expenses 538 Store Supplies Expense 561 Depreciation Expense-Office Equipment 582 Depreciation Expense-Store Equipment 590 Miscellaneous Expense 710 Interest Expense LIABILITIES 210 Accounts Payable 221 Notes Payable 222 Interest Payable 231 Salaries Payabile 241 Sales Tax Payable EQUITY Bank reconciliation and entries C 1. EX.07.01 Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2 EX 07.02 3. EX 07.03 4. EX 07 18 ALGO 5. PROT01A Chart of Accounts LIABILITIES 210 Accounts Payable 221 Notes Payable 222 Interest Payable 231 Salaries Payable 241 Sales Tax Payable 537 Seling Expenses 530 Store Supplies Expense 561 Depreciation Expense-Otice Equipment 562 Depreciation Expense-Store Equipment 500 Miscellaneous Expense 710 Interest Expense 6. PROT OLA BLANKSHEET 7. PR OTOSA BLANKSHEET EQUITY 310 Common Stock 311 Retained Earnings 312 Dividends 1. EX.07.01 Bank reconciliation and entries 2. EX.07.02 Instructions Chart of Accounts Amount Descriptions Journal Bank Reconciliation 3. EX 07.03 4. EX.07.18 ALGO 5. PR 07 01A 6. PR.07 04A BLANKSHEET 7. PR.OYOSA BLANCSHEET Amount Descriptions Check returned because of insuficient funds Emor in recording June 10 deposit Emor in recording June 24 deposit Emor in recording Check No. 743 Deposit in transit on June 30 Note collected by bank, including 5210 interest Outstanding Check No 738 Outstanding Check No. 756 Outstanding Check No.750 Outstanding Chuck No 750 Total additions Total deductions 1. EX 07.01 Bank reconciliation and entries Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2. EX 07.02 3. EX 07.03 Bank Reconciliation Shaded cells have feedback 4. EX.07.18.ALGO 5. PROT01A 1. Prepare a bank reconciliation as of June 30 2072. Ferrors in recording droosts or checks are discovered assume that the errors were made by the Company Assume that al deposits are from cash sales. Al checks are written to satisfy accounts payable. Refer to the Amount Description is provided for the exact wording of the answer choices for text entries "Ast & Deduct. will automatically coer is required Round your answers to two decimal places Note: For those banes in which you must enter Subtracted or negative numbers use a minus sign) 6. PR.07.04A BLANKSHEET 7. PR.07 OSA BLANKSHEET Questionne etcompred Score: 0/163 Beeler Furniture Company Bank Reconciliation June 30, 2012 Cash balance according to bank statement Check My Work Previous 1. EX 07.01 Bank reconciliation and entries Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 0 HI 2 EX 07.02 3. EX OT 03 Bank Reconciliation Shaded ces have feedrack 4. EX.07.18 ALGO Cash balance According to company's records 5. PRO701A 6. PR.O704A BLANKSHEET 7. PR OTOGA BLANKSHEET 14 1. EX 07.01 Bank reconciliation and entries Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2. EX 07.02 3. EX 07.03 Journal Shaded cells have feedback 4. EX 07. 18. ALGO 2 maize the necessary toes Ruter to the Chart of Accounts for exact wording of account tous. Round your answers to bodecim peces 5. PR 07.01A Question et attempted. 6. PRODUA BLANKSHEET 7. PR OTOSA BLANKSHEET NES JOUR Score 6/99 ACCOUNTING EQUATION DATE DESCRIPTION POSTRE CREDE COUNTY 1. EX.07.01 Bank reconciliation and entries Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2. EX.07.02 3. EXO7.00 Final Questions Shaded Cells have feedback 4. EX.07.18 ALGO 3. What is the amount of Cash that should appear on the balance sheet as of June 30? 5 5. PR 07.01A Points 0/1 6. PR 07.04A BLANKSHEET 1. EX 07.01 Bank reconciliation and entries Instruction Chart of Accounts Amount Descriptions Bank Reconciliation Journal HI 2 EX 07.02 3. EX07.03 Instructions 4. EX.07.18 ALGO 5. PR.07.01 Beeler Future Company deposits al cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required to reconcile the bank statement as of June 30, 2012, have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters. Al checks were written for payments on account 6. PR.07.04ABLANKSHEET 7. PR.07.05A BLANKSHEET CASH ACCOUNT $9,317.40 Balance as of June 1 CASH RECEIPTS FOR MONTH OF JUNE 9223.76 DUPLICATE DEPOSIT TICKETS Date and amount of each deposit in June Date Amount Date Date Amount Amount $996.61 June 1 $1,080.50 June 10 June 22 $89734 1. EX 07.01 Bank reconciliation and entries Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2. EX 07.02 3. EX.07.03 Instructions 3 15 4. EX 07. 18. ALGO 854.17 840 50 882.95 1,606 74 24 30 94721 1.117.74 17 5. PROT01A 6. PR.07.04A BLANKSHEET Check No 754 Amount $44975 7. PR OTOSA BLANKSHEET CHECKS WRITTEN Number and amount of each check issued in June Check No Amount Check No. Amount 740 $23.50 747 Vold 741 49515 $450.90 742 501.90 640.13 743 761.30 750 27677 744 5068 751 209.37 745 117.25 752 53701 745 298.66 753 380.95 755 756 27275 11395 407.95 757 758 250 60 90150 759 750 48539 1. EX 07.01 Bank reconciliation and entries Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2. EX.07.02 3. EX 07.03 Instructions 4. EX07.18 ALGO Total amount of checks issued in June 58.38566 5. PROT01A BANK RECONCILIATION FOR PRECEDING MONTH 6. PR.0704A BLANKSHEET 7. PROT05A BLANKSHEET Beeler Furniture Company Bank Reconciliation May 31, 2072 Cash balance according to bank statement Add Deposit in transit on May 31 Deduct: Outstanding Check No.731 $9.41.20 690.25 $162.15 1. EX.07.01 Bank reconciliation and entries C Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2. EX 07.02 3. EX 07.03 345.95 4. EX 07.18 ALGO 251.00 5. PR.07.01A 6. PROZOA BLANKSHEET Instructions Outstanding Check No. 736 Outstanding Check No.758 Outstanding Check No.799 Total deductions Adjusted balance (2005) 59.317.40 7. PR OTOSA BLANKSHEET - Cash balance according to company's seconds 11 Deduct: Bank senior changes 12 usted balance 59.352.50 (35.00 $931740 Bank reconciliation and entries 1. EX.07.01 2 Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2. EX 07.02 3. EX 07.03 Instructions Refer to the une Bank Statement 4. EX.07.18 ALGO 5. PRO701A 6. PR.07.04A BLANKSHEET 7. PR 07 05A BLANKSHEET Required: 1. Prepared a bank reconciliation as sof June 30, 2012. Ferrors in recording deposits or checks are discovered, assume that the errors were made by the company. Assume that all deposits are from cash sales All checks are written to satisfy accounts payable Refer to the Amount Descriptions is provided for the exact wording of the answer choices for text entries "Add & Deduct will automatically appear is required Round your answers to two decimal pieces. For those bores in which you must enter subtracted or negative numbers use a minus sign 2 Joumalize the necessary entries. Refer to the Chat of Accounts for exact wording of account stes. Round your answers to ho decine pieces. 2. What is the amount of Cash that should appear on the balance sheet as of June 30, 2012? 4. Assume that a canceled check for $390 has been incorrectly recorded by the bank as $900. Brieflyplain how the error would be included in a bank reconciliation and how it should be corrected Bank reconciliation and entries 1. EX 07.01 Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2 EX 07.02 3. EX 07.03 Chart of Accounts 4. EX.07.18 ALGO Beeler Furniture Company General Ledger 5. PR 07.01A 6. PROT OLA BLANKSHEET REVENUE 410 Sales 610 Interest Revenue 7. PROTOSA BLANKSHEET ASSETS 110 Cash 111 Pety Cash 120 Accounts Receivable 131 Notes Receivable 141 Merchandise Inventory 145 Ofice Supplies 145 Store Supplies 151 Prepaid insurance 181 Land EXPENSES 510 Cost of Merchandise Sold 515 Credit Card Expense 515 Cash Short and Over 520 Salaries Expense 531 Advertising Epe Bank reconciliation and entries 1. EX.07.01 Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2. EX 07.02 3. EX 07.03 x 4. EX07.18 ALGO 5. PR.07.01A 6. PR.07.DA BLANKSHEET 7. PROPOSABLANICSHEET Chart of Accounts 181 Land 191 Otice Equipment 192 Accumulated Depreciation Office Equipment 193 Store Equipment 194 Accumulated Depreciation Store Equipment 531 Advertising Expense 532 Delivery Expense 533 Insurance Expense 534 Ole Supplies Expense 535 Rent Expense 536 Repairs Expense 537 Seling Expenses 538 Store Supplies Expense 561 Depreciation Expense-Office Equipment 582 Depreciation Expense-Store Equipment 590 Miscellaneous Expense 710 Interest Expense LIABILITIES 210 Accounts Payable 221 Notes Payable 222 Interest Payable 231 Salaries Payabile 241 Sales Tax Payable EQUITY Bank reconciliation and entries C 1. EX.07.01 Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2 EX 07.02 3. EX 07.03 4. EX 07 18 ALGO 5. PROT01A Chart of Accounts LIABILITIES 210 Accounts Payable 221 Notes Payable 222 Interest Payable 231 Salaries Payable 241 Sales Tax Payable 537 Seling Expenses 530 Store Supplies Expense 561 Depreciation Expense-Otice Equipment 562 Depreciation Expense-Store Equipment 500 Miscellaneous Expense 710 Interest Expense 6. PROT OLA BLANKSHEET 7. PR OTOSA BLANKSHEET EQUITY 310 Common Stock 311 Retained Earnings 312 Dividends 1. EX.07.01 Bank reconciliation and entries 2. EX.07.02 Instructions Chart of Accounts Amount Descriptions Journal Bank Reconciliation 3. EX 07.03 4. EX.07.18 ALGO 5. PR 07 01A 6. PR.07 04A BLANKSHEET 7. PR.OYOSA BLANCSHEET Amount Descriptions Check returned because of insuficient funds Emor in recording June 10 deposit Emor in recording June 24 deposit Emor in recording Check No. 743 Deposit in transit on June 30 Note collected by bank, including 5210 interest Outstanding Check No 738 Outstanding Check No. 756 Outstanding Check No.750 Outstanding Chuck No 750 Total additions Total deductions 1. EX 07.01 Bank reconciliation and entries Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2. EX 07.02 3. EX 07.03 Bank Reconciliation Shaded cells have feedback 4. EX.07.18.ALGO 5. PROT01A 1. Prepare a bank reconciliation as of June 30 2072. Ferrors in recording droosts or checks are discovered assume that the errors were made by the Company Assume that al deposits are from cash sales. Al checks are written to satisfy accounts payable. Refer to the Amount Description is provided for the exact wording of the answer choices for text entries "Ast & Deduct. will automatically coer is required Round your answers to two decimal places Note: For those banes in which you must enter Subtracted or negative numbers use a minus sign) 6. PR.07.04A BLANKSHEET 7. PR.07 OSA BLANKSHEET Questionne etcompred Score: 0/163 Beeler Furniture Company Bank Reconciliation June 30, 2012 Cash balance according to bank statement Check My Work Previous 1. EX 07.01 Bank reconciliation and entries Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 0 HI 2 EX 07.02 3. EX OT 03 Bank Reconciliation Shaded ces have feedrack 4. EX.07.18 ALGO Cash balance According to company's records 5. PRO701A 6. PR.O704A BLANKSHEET 7. PR OTOGA BLANKSHEET 14 1. EX 07.01 Bank reconciliation and entries Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2. EX 07.02 3. EX 07.03 Journal Shaded cells have feedback 4. EX 07. 18. ALGO 2 maize the necessary toes Ruter to the Chart of Accounts for exact wording of account tous. Round your answers to bodecim peces 5. PR 07.01A Question et attempted. 6. PRODUA BLANKSHEET 7. PR OTOSA BLANKSHEET NES JOUR Score 6/99 ACCOUNTING EQUATION DATE DESCRIPTION POSTRE CREDE COUNTY 1. EX.07.01 Bank reconciliation and entries Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal 2. EX.07.02 3. EXO7.00 Final Questions Shaded Cells have feedback 4. EX.07.18 ALGO 3. What is the amount of Cash that should appear on the balance sheet as of June 30? 5 5. PR 07.01A Points 0/1 6. PR 07.04A BLANKSHEETStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started