Gibson Energy Ltd.'s general ledger account for Cash in Bank showed the following at December 31,...
All of this question needs to be completed on excel, and make sure to use the same layout. Gibson Energy Ltd.'s general ledger account for Cash in Bank showed the following at December 31, 2019: Cash in Bank Folio Debit Date Nov. 30 Dec. 1-31 Dec. 1-31 Description Balance (overdraft) Cash receipts Cash Payments Acct. No. 101 Balance DR Credit (CR) 221,000 1,034,000 + 972,000 62,000 CR10 CDI21 813,000 December deposits made and checks issued were as follows: Deposits Date...
800 In October 2019, Old City Antiques checking account at Barnett Bank. The bank statement dated October 31, 2019 for Old City Antiques follows: Beginning Balance, October 1, 2019 Deposits and other credits Oct. 2 $36.000 10 14.000 52.000 24. EFT St. Augustine Hotel 450 31. Interest revenue 50 103,300 Checks and other debits Oct. 2 EFT to FPL (utilities) 6 Ck#325 3.415 10 Ck8327 10 Ck8326 2.700 27 Ck#329 1,925 27 EFT to ATT 28 Ck340 295 31 Bank...
Accounting Help The general ledger of Michelle Company Ltd. showed a cash balance of $21,195 on 31 December 20X2, while the bank showed a balance of $60,600. The following facts were available: a. The bank collected $12,160 as a direct deposit for one of Michelle's customer as a payment on account. A $30 fee was charged by the bank for administration. Michelle has yet to record either of these amounts. b. Michelle paid a utilities bill of $460 through direct...
The Cash account in the general ledger of Lyco Corporation showed a balance of $21,749 at December 31 (but prior to performing a bank reconciliation). The company's bank statement showed a balance of $22,000 at the same date. The only reconciling items consisted of (1) a $5,000 deposit in transit, (2) a bank service charge of $200, (3) outstanding checks totaling $9,000, (4) a $3,000 check marked "NSF" from Susque Company, one of Lyco's customers, and (5) a check written...
solve the following question with full expiration on each step General Ledger CASH BOOK 2019 35,000 April 6 Payment customer P 25,000 2019 Rs Rs April 1 Balance b/d 4 Cheque customer X 9 Cheque -customer Y 29 Cheque - customer Z 10,000 12 Payment customer Q 14,000 20 Payment customer R 12,000 29,000 80,000 15,000 20,000 80,000 30 Balance c/d Bank Statement ABC Company Balance Withdrawals Deposits 2019 April Rs Rs 1 Balance b/d 6 Cheque deposit customer X...
The Cash account in the general ledger of Lyco Corporation showed a balance of $21,749 at December 31 (but prior to performing a bank reconciliation). The company's bank statement showed a balance of $22.000 at the same date. The only reconciling items consisted of: (1) a $5.000 deposit in transit. (2) a bank service charge of $200. (3) outstanding checks totaling $9,000. (4) a $3,000 check marked NSF from Susque Company, one of Lyco's customers, and (5) a check written...
Miller Corporation’s December 31, 2019, bank statement showed a $2,049.25 balance. On this date, Miller’s Cash account reflected a $146.90 overdraft. In reconciling these amounts, the following information is discovered: 1. Cash on hand for undeposited sales receipts, December 31, $130.25. 2. Customer NSF check returned with bank statement, $419.20. 3. Cash sales of $634.25 for the week ended December 18 were recorded on the books. The cashier reports this amount missing, and it was not deposited in the bank....
The bank statement for the checking account of Management Systems Inc. (MSI) showed a December 31, 2021, balance of $15.734.87 Information that might be useful in preparing a bank reconciliation is as follows: a. Outstanding checks were $1,431.90 b. The December 31, 2021, cash receipts of $630 were not deposited in the bank until January 2, 2022 One check written in payment of rent for $257 was correctly recorded by the bank but was recorded by MSI as a $275...
Purple Bank Dute Description Det C BEC's adjusted cash general ledger balance at January 31, 2036 $5,16. The bookkeeper has compiled the following information and notes 12,500 ILTON $ 622 Depot in December 31, 2017 Outstanding chegues December 31, 2017 1. LABO 23 Amount 14.250 12.00 12.ME 14 77 70 88 $ $ $ 180 da DORTY GOOD - NOT ODPOST 05-18 NIGHT DEPOST NOTLO NE 11- NOT DEPOT - Director 15- Mered 11 OCR 15--OGRS NOM DOO 161 OORTO...
The December bank statement and cash T-account for Stewart Company follow: Withdrawals Deposits $ 550 7,500 125 Balance $50,500 49,950 42,450 42,325 72,225 70,075 57,575 600 $30,500 2,150 12,500 Date Dec. 1 2-Cheque 4-Cheque 6-Cheque 11-Cheque 13-Cheque 17-Cheque 23-Cheque 26-Cheque 28-Cheque 30-Cheque 30–NSF* 31-Cheque 31-Interest earned 31-Service charge 36,500 . 925 93,085 2,450 17,500 350 1,700 90,6 92,6 о л л op www л л 19,500 92,285 90,585 90,640 90,465 175 *NSF cheque from J. Left, a customer. + Cash...