Salem Auto Service
Bank Reconciliation
January 31,2018
| Bank | Books | ||
| Balance January 31 | 3828 | Balance January 31 | 2535 |
| Add: | Add: | ||
| Deposit in transit | 260 | Bank collection | 610 |
| Interest | 13 | ||
| 4088 | 3158 | ||
| Less: | Less: | ||
| Outstanding Check | -950 | Service charge | -20 |
| Adjusted Bank Balance | 3138 | Adjusted Book balance | 3138 |
The T-account for Cash and the bank statement of Salem Auto Services for the month of...
1 of 4 (0 complete) HW Score: 0%, 0 of 8 pts Score: 0 of 2 pts S7-3 (similar to) Question Help O The T-account for Cash and the bank statement of Hampton Food Services for the month of March 2018 follows: (Click the icon to view the T-account.) (Click the icon to view the bank statement.) Prepare Hampton Food Services' bank reconciliation at March 31. i Data Table Bank Statement: Bal, Mar 1 2,957) Deposits: Hampton Food Services Bank...
Superior Printing, Inc. has provided you with its bank statement and Cash T-Account for the month of June. The Controller has asked you to prepare the Bank Reconciliation for the month of June. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=B11" was entered, the...
fill out excel at the bottom
The June bank statement and the cash T-account for Superior Printing, Inc., is A The June bank statement and the cash T-account for Superior Printing, Inc., is shown below. BANK STATEMENT Deposits Other Checks Date June 1 10,000 440 1,200 500 1,200 250 80 9,800 350 4,600 700 920 NSF 840 Balance 18,500 18,060 16,860 16,360 15,160 24,910 23,990 49,190 48,840 44,240 60,540 59,570 59,000 35,000 17,000 600 Serv. Charge Interest Earned Cash June...
Using the following information: The bank statement balance is $5,550. The cash account balance is $5,720. Outstanding checks amounted to $875. Deposits in transit are $1,002. The bank service charge is $34. A check for $43 for supplies was recorded as $34 in the ledger. Prepare a bank reconciliation for Candace Co. for May 31. Candace Co. Bank Reconciliation May 31 Cash balance according to bank statement$ Adjustments: Deposits in transit not recorded by bank $ Outstanding checks Total adjustments...
Using the following information: The bank statement balance is $4,690. The cash account balance is $5,080. Outstanding checks amounted to $715. Deposits in transit are $1,020. The bank service charge is $40. A check for $72 for supplies was recorded as $27 in the ledger. Prepare a bank reconciliation for Miller Co. for August 31. Miller Co. Bank Reconciliation August 31 Cash balance according to bank statement $ Add deposits in transit not recorded by bank $ Deduct outstanding checks...
Wright Company's cash account shows a $28,500 debit balance and its bank statement shows $26,800 on deposit at the close of business on May 31. a. The May 31 bank statement lists $150 in bank service charges; the company has not yet recorded the cost of these services. b. Outstanding checks as of May 31 total $6,100. c. May 31 cash receipts of $6,700 were placed in the bank's night depository after banking hours and were not recorded on the...
Wright Company's cash account shows a $28,700 debit balance and its bank statement shows $27,000 on deposit at the close of business on May 31. a. The May 31 bank statement lists $160 in bank service charges; the company has not yet recorded the cost of these services. b. Outstanding checks as of May 31 total $6,200. c. May 31 cash receipts of $6,800 were placed in the bank's night depository after banking hours and were not recorded on the...
Using the following information: The bank statement balance is $4,045. The cash account balance is $4,474. Outstanding checks amounted to $769. Deposits in transit are $1,121. The bank service charge is $68. A check for $34 for supplies was recorded as $25 in the ledger. Prepare a bank reconciliation for Candace Co. for May 31. Candace Co. Bank Reconciliation May 31 Cash balance according to bank statement $ Adjustments: $ Total adjustments Adjusted balance $ Cash balance according to company's...
Wright Company's cash account shows a $29,100 debit balance and its bank statement shows $27,400 on deposit at the close of business on May 31 a. The May 31 bank statement lists $180 in bank service charges; the company has not yet recorded the cost of these services. b. Outstanding checks as of May 31 total $6,400. c. May 31 cash receipts of $7,000 were placed in the bank's night depository after banking hours and were not recorded on the...
October 31, 2018, bank statement from City National Bank, and the statement shows an ending balance wing the cash records, the business identified outstanding checks totaling $455 and a deposit in transito 31 balance of $2,122 conciliation 0 Requirements 1. Prepare the bank reconciliation at October 31. 2. Journalize any transactions required from the bank reconciliation Print Done k Check Answer Clear All care 5 checks Expense and creang Cuthor , 30 dage for these The business Cashcourt shows in...