Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

what informaiton do i put in the cells ? what would the bank reconcilation be based on the statement and the cash statment Presented below

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
what informaiton do i put in the cells ?
what would the bank reconcilation be based on the statement and the cash statment
Presented below are the company's records and bank statemnt for April 2018. BANK STATEMENT TO: Nmm Sandler Company Fairbanks Alaska April 30, 2018 FAIRBANKS NATIONAL BANK LE Cash Blance 4/1/18 11,960.00 Deposits & Credits no. Total 9 9,655 Withdrawals & Debits n o. Total 10 6,644 Cash Blance 4/1/18 14,971.00 $ M e HK 4/ 2 E ONIM Deposits and Credits Amount Descr 4/1 1,300 DEP 4/3 1,680 DEP 4/7 1,250 DEP 4/13 1020 DEP 4/18 | 840 DP 4/23 | 990 DEP 4/27 1,340 DEPT 4/30 1,160 DEP 4/30 75 INT Withdrawalls and Debits No Amount Desc 804 690 CHK 807 730 CHK 808 1,240 CHK 809 838 CHK 810 1,040 CHK 811 326 CHK 813 640 CHK 814 600 CHK 500 NSE 40 SC 4/16 4/13 4/27 4/23 4/18 4/30 more 16 Item Codes: EC: Error Correction SC: Service Charge IN: Interest Earned DM: Debit Memo OD: Overdraft NSF: Non-sufficient Funds CM: Credit Memo RT: Returned item SANDLER COMPANY Cash account records April 1, 2018 - April 30, 2018 Cash Blance 4/1/18 12,020.00 + Deposits Checks Cash Blance 4/1/18 14,206.00 9,705 7,519 $ Amount Date No 1,680 1,250 3/31 Deposits Deser 4/2 Sales 4/6 Sales 4/10 Sales 4/17 Sales 4/22 Sales 4/24 Sales 4/29 Sales 4/30 Sales 1,020 840 990 1,340 1,160 1,425 Checks Written Desc 807 Legal Fees 808 Salaries 809 Supplies 810 Advetising 811 Delivery Expense 812 Miscellaneous 813 Utilities Expense 814 Equipment Rental 815 Utilities Expense 816 Property Taxes 4/11 Amount 730 1,246 838 1,046 236 948 640 600 372 E875 225 4/21 4/16 4/28 Total Deposits 9,705 Total Withdrawals | NEMA 7,519 55 56 The bank reconciliation made by Sandler Company, a sole proprietorship, on 57 March 31 showed a deposit in transit of $1,300 and two outstanding checks, No. 797 for $550 and No. 58 804 for $690. The reconciled cash balance on March 31 was $12,020 50 Beginning Balance reconciliation 52 Books 54 Bank 1 56 Difference identified Difference 00 69 by the bank, 70 the accountant discovered that check No. 811, written for $326 for delivery expense, was recorded in the 71 cash disbursements journal as $236. The NSF check for $500 was that of customer R. Koppa, deposited 72 in April. Interest for April added to the account by the bank was $75. 76 ERROR TYPE 78 Bank Cleared 80 Book Recorded 82 Error to Adjust: 85 Error Correction 86 Bank makes a mistake 87 Deposit in Transit: Outstanding Check: 89 You make a mistake: Unrecorded Deposit: Bank deducts money in error from your account Bank deposits money in error into your account Unrecorded Expense You record a check for MORE than it cleared the bank or: You record a deposit for Less than it cleared the bank You record a check for LESS than it cleared the bank or: You record a deposit for MORE than it cleared the bank

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions