PYLE GARAGE Bank Reconciliation March 31, Year 2 |
||
Unadjusted Bank Balance, March 31,Year 2 | $ 14,152 | |
Add: Deposit in transit | $ 3,583 | |
Less: Outstanding checks | ||
Cheque # 1469 | ($ 1,534) | |
Cheque # 1470 | ($ 778) | ($ 2,312 ) |
True cash balance, March 31, 2018 | $ 15,423 | |
Unadjusted book Balance, March 31,Year 2 | $ 13,077 | |
Add: Credit Memo for Collection of Account Receivable | $ 3,086 | |
Less: | ||
Error in recording check # 1468 ($ 810 (-) $ 125 ) |
($ 685 ) | |
Debit Memo (or )Bank Service charges | ($ 55) | ($ 740 ) |
True cash balance, March 31, Year 2 | $ 15,423 |
Item No | Affect on the cash Account |
1 | No Effect on cash Account |
2 | Increase in Cash Account balance |
3 | No Effect on cash Account |
4 | Decrease in Cash Account balance |
5 | No Effect on cash Account |
6 | Decrease in Cash Account balance |
The following information is available for Pyle Garage for March, Year 2:
BANK STATEMENT | |||||||||||
HAZARD STATE BANK | |||||||||||
215 MAIN STREET | |||||||||||
HAZARD, GA 30321 | |||||||||||
Pyle Garage | Account number | ||||||||||
629 Main Street | 62-00062 | ||||||||||
HAZARD, GA 30321 | March 31, Year 2 | ||||||||||
Beginning balance 3/1/Year 2 | $9,075 | ||||||||||
Total deposits and other credits | 30,123 | ||||||||||
Total checks and other debits | 25,054 | ||||||||||
Ending balance 3/31/Year 2 | 14,144 | ||||||||||
Checks and Debits | Deposits and Credits | ||||||||||
Check No. | Amount | Date | Amount | ||||||||
1462 | $ | 3,798 | March | 1 | $ | 1,145 | |||||
1463 | 1,688 | March | 2 | 6,550 | |||||||
1464 | 8,045 | March | 6 | 4,981 | |||||||
1465 | 2,947 | March | 12 | 6,212 | |||||||
1466 | 1,451 | March | 17 | 6,009 | |||||||
1467 | 6,222 | March | 22 | 2,130 | |||||||
DM | 63 | CM | 3,096 | ||||||||
1468 | 840 | ||||||||||
The following is a list of checks and deposits recorded on the books of Pyle Garage for March, Year 2:
Date | Check No. | Amount of Check | Date | Amount of Deposit | ||||||||
March | 1 | 1463 | $ | 1,688 | March | 1 | $ | 6,550 | ||||
March | 5 | 1464 | 8,045 | March | 5 | 4,981 | ||||||
March | 6 | 1465 | 2,947 | |||||||||
March | 9 | 1466 | 1,451 | March | 10 | 6,212 | ||||||
March | 10 | 1467 | 6,222 | |||||||||
March | 14 | 1468 | 140 | March | 16 | 6,009 | ||||||
March | 19 | 1469 | 1,542 | March | 19 | 2,130 | ||||||
March | 28 | 1470 | 786 | March | 29 | 3,588 |
Other Information
Check no. 1462 was outstanding from February.
A credit memo for collection of accounts receivable was included in the bank statement.
All checks were paid at the correct amount.
The bank statement included a debit memo for service charges.
The February 28 bank reconciliation showed a deposit in transit of $1,145.
Check no. 1468 was for the purchase of equipment.
The unadjusted Cash account balance at March 31 was $13,071.
Required:
Prepare the bank reconciliation for Pyle Garage at the end of March.
Explain how the adjustments described above affect the cash account.
The following information is available for Pyle Garage for March, Year 2: BANK STATEMENT HAZARD STATE...
The following information is available for Pyle Garage for March, Year 2: BANK STATEMENT HAZARD STATE BANK 215 MAIN STREET HAZARD, GA 30321 Pyle Garage Account number 629 Main Street 62-00062 HAZARD, GA 30321 March 31, Year 2 Beginning balance 3/1/Year 2 $9,063 Total deposits and other credits 30,048 Total checks and other debits 24,959 Ending balance 3/31/Year 2 14,152 Checks and Debits Deposits and Credits Check No. Amount Date Amount 1462 $3,789 March 1 $1,131 1463 1,676 March 2...
The following information is available for Pyle Garage for March, Year 2: BANK STATEMENT HAZARD STATE BANK 215 MAIN STREET HAZARD, GA 30321 Pyle Garage Account number 629 Main Street 62-00062 HAZARD, GA 30321 March 31, Year 2 Beginning balance 3/1/Year 2 $9,095 Total deposits and other credits 30, 233 Total checks and other debits 25,231 Ending balance 3/31/Year 2 14,097 Checks and Debits Deposits and Credits Check No. Amount Date Amount 1462 $3,818 March 1 $1,162 1463 1,704 March...
The following information is available for Pyle Garage for March, Year 2: BANK STATEMENT HAZARD STATE BANK 215 MAIN STREET HAZARD, GA 30321 Pyle Garage 629 Main Street HAZARD, GA 30321 Account number 62-00062 March 31, Year 2 Beginning balance 3/1/Year 2 $9,070 Total deposits and other credits 30,096 Total checks and other debits 25,024 Ending balance 3/31/Year 2 14,142 Checks and Debits Deposits and Credits Check No. Amount Date Amount 1462 $ 3,795 March 1 $ 1,140 1463 1,684...
The following information is available for Pyle Garage for March, Year 2: BANK STATEMENT HAZARD STATE BANK 215 MAIN STREET HAZARD, GA 30321 Pyle Garage Account number 629 Main Street 62-00062 HAZARD, GA 30321 March 31, Year 2 Beginning balance 3/1/Year 2 $9,047 Total deposits and other credits 29,912 Total checks and other debits 24,758 Ending balance 3/31/Year 2 14,201 Checks and Debits Deposits and Credits Check No. Amount Date Amount 1462 $3,770 March 1 $1,113 1463 1,662 March 2...
Help The following information is available for Trinkle Company for the month of June: 1. The unadjusted balance per the bank statement on June 30 was $57,972. 2. Deposits in transit on June 30 were $2,005. 3. A debit memo was included with the bank statement for a service charge of $7. 4. A $4,240 check written in June had not been paid by the bank. 5. The bank statement included a $1100 credit memo for the collection of a...
Problem 6-21B Bank reconciliation and adjustments to the cash account The following information is available for Pyle Garage for March Year 1: BANK STATEMENT HAZARD STATE BANK 215 MAIN STREET HAZARD, GA 30321 Pyle Garage 629 Main Street Hazard, GA 30321 Account number 62-00062 March 31, Year1 Beginning balance V1/Year 1 Total deposits and other credits $15,000.00 7,000.00 Total checks and other debits 6,000.00 16,000.00 Ending balance 3/31/Year 1 Checks and Debits Deposits and Credits Amount $1,000.00 Check No. Amount...
Reebies Food Store developed the following information in month of March recording its bank statement for $ 2,905 $10,900 Balance per books March 31 Balance per bank statement March 31 (1) Checks wniten in March but still outstanding $7,000 (2) Checks writtern in February but still outstanding $2.800 (3) Deposits of March 30 and 31 not yet recorded by bank $5,200 (4) NSF check of customer returned by bank $1,200. (5) Check No. 210 for $594 was correctly issued and...
Bank Reconciliation The following information is available to assist you in preparing a bank reconciliation for Karen's Catering on March 31: The balance on the March 31 bank statement is $6,506.10. Not included on the bank statement is a $423 deposit made by Karen's late on March 31. A comparison between the canceled checks listed on the bank statement and the company records indicated that the following checks are outstanding at March 31: No. 112 $42.92 No. 117 307.00 No....
The following information is available for Park Valley Spa for July Year 1: BANK STATEMENT STATE BANK BOLTA VISTA, NV 10001 Park Valley Spa 10 Main Street Bolta Vista, NV 10001 Beginning balance 6/30/Year 1 Total deposits and other credits Total checks and other debits Ending balance 7/31/Year 1 Checks and Debits Check No. Amount 2350 $3,762 2351 1,644 2352 8,002 2354 1, 399 2355 6,188 2357 1,501 DM 19 Account number 12-4567 July 31, Year 1 $ 9,990 29,809...
Reebles Food Store developed the following information in recording its bank statement for the month of March. Balance per books March 31 $ 3,622 Balance per bank statement March 31 $11,400 (1) Checks written in March but still outstanding $8,000. (2) Checks written in February but still outstanding $3,200. (3) Deposits of March 30 and 31 not yet recorded by bank $7,200. (4) NSF check of customer returned by bank $700. (5) Check No. 210 for $591 was correctly issued...