PA9. Domingo Company received the following bank statement. Using the following information, prepare a bank reconciliation. Include the information from the bank statement below. A. The owners invested $10,000 from their personal account to the business account. B. Paid rent $500 with check #101. C. Initiated a petty cash fund $500 with check #102. D. Received $1,000 cash for services rendered. E. Purchased office supplies for $158 with check #103. F. Purchased computer equipment $2,500, paid $1,350 with check # 104, and will pay the remainder in 30 days. G. Received $800 cash for services rendered. H. Paid wages $600, check #105. I. Petty cash reimbursement: office supplies $256, maintenance expense $108, postage expense $77, miscellaneous expense $55. Cash on hand $11. Check #106. J. Increased petty cash by $30, check #107.

PA9. Domingo Company received the following bank statement. Using the following information, prepare a bank reconciliation. Include the information from the bank statement below. A. The owners invested $10,000 from their personal account to the business account. B. Paid rent $500 with check #101. C. Initiated a petty cash fund $500 with check #102. D. Received $1,000 cash for services rendered. E. Purchased office supplies for $158 with check #103. F. Purchased computer equipment $2,500, paid $1,350 with check # 104, and will pay the remainder in 30 days. G. Received $800 cash for services rendered. H. Paid wages $600, check #105. I. Petty cash reimbursement: office supplies $256, maintenance expense $108, postage expense $77, miscellaneous expense $55. Cash on hand $11. Check #106. J. Increased petty cash by $30, check #107.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 2R: Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas...

See similar textbooks

Similar questions

2. DETAILS rise BRECMBC9 4.11.TB.011. On May 27, you received your bank statement showing a balance of $1,026.34. Your checkbook shows a balance of $1,056.29. Outstanding checks are $245.50 and $377.20. The account earned $62.59. Deposits in transit amount to $705.24, and there is a service charge of $10.00. Calculate the reconciled balance. O $29.95 O $943.80 O $1,003.70 $1,108.88
Ablema has provided you with the following bank statement and bank account details in respect of the month ended 31 January 2018. Statement date - 31 January, 2018. Account No 1452800 Date Particulars Debit Credit Balance GH¢ GH¢ GH¢ 01-Jan-18 Balance forward 67,580 Cr 06-Jan-18 Cheque 597 120 67,460 Cr 06-Jan-18 Direct debit 2,020 65,440 Cr 12-Jan-18 Credit transfer 4,660 70,100 Cr 13-Jan-18 Cheque 600 1,420 68,680 Cr 14-Jan-18 Cheque 601 12,028 56,652 Cr 16-Jan-18 Lodgement 9,000 65,652 Cr 19-Jan-18 Cheque 599 18,004 47,648 Cr 23-Jan-18 Bank charges for December 2017 422 47,226 Cr 25-Jan-18 Quarterly interest received 62 47,288 Cr 27-Jan-18 Dishonoured cheque 1,600 45,688 Cr 27-Jan-18 Cheque 598 26,090 19,598 Cr 30-Jan-18 Cheque 603 5,048 14,550 Cr 31-Jan-18 Lodgement 14,500 29,050 Cr 31-Jan-18 Standing order: rent first quarter 2018 27,000 2,050 Cr The books and records of Ablema show the followings transactions through the bank account for the month of January 2018: Date Receipts…
Problem Solving. 1. Assuming the following information for Uno Company: bank balance P65,000; book balance ? ; deposit in transit P11,000; outstanding check P10,000; credit memo P2,000; and debit memo P500. How much is the adjusted bank balance?
Use the information from the attached image to answer questions 10 – 14. This is Mason's monthly bank statement and check register. What is the ending balance on the statement? Answers A. $1,352.61 B. $1,257.23 C. $1,241.66 D. $747.61 Question11. What is the total of the outstanding deposits? Answers A. $20 B. $625 C. $605 D. $8 Question12. What is the total of the outstanding withdrawals? Answers A. $130.95 B. $87.38 C. $8.00 D. $43.57 Question13. What is the revised statement balance? Answers A. $1,241.66 B. $1,277.23 C. $1,233.66 D. $1,352.61 Question14. What is the revised balance of the check register? Answers A. $1,198.09 B. $1,257.23 C. $1,233.66 D. $1,291.66
Using general GL codes (expense, receivable, revenue, etc.), write out the JE necessary to post each of these bank transactions: Account Activity Transaction Date 07/01/2022 07/01/2022 07/01/2022 07/01/2022 07/01/2022 Description Beginning Balance FX 157510619000001 EUR 17145 R ATE: 1.03944INV3318 INV3307 BRAINTREE FUNDING 6XDJXT LONGTAILVIDEO WIRE IN 220701B1Q8021C018706 202218219086;ORG AMAGI MEDIA L ABS PRIVATE LIMITED;OBI S1023 ADP 401K ADP 401k 94YL7 063026V01 LONGTAIL AD SOLUTIONS Debits -$17,821.20 $0.00 $0.00 -$54,337,80 Credits $0.00 $55,477.13 $8,175.00 $0.00 B
The Cash account of Silver Maple Art Gallery shows the following at April 30, 2014CashDate Item Jrnl. Ref. Debit Credit BalanceApril 1 Balance 13,911April 30 CR.6 10,672 24,583April 30 CR.11 10,924 13,659On April 30, 2014, Silver Maple Art Gallery received the following bank statement:Bank Statement for April 2014Beginning Balance $13,911Deposits & Other Credits:April 1 $ 300 EFTApril 4 4,174April 9 501April 12 559April 17 2,187April 22 1,300 BCApril 23 1,854 10,875Checks & Other Debits:April 7 (cheque no. 3113) $ 891April 13 (cheque no. 3115) 1,390April 14 900 USApril 15 (cheque no. 3114) 147April 18 (cheque no. 3116) 664April 21 200 EFTApril 26 (cheque no. 3117) 1,472April 30 (cheque no. 3118) 1,000April 30 20 SC (6,684)Ending Balance $18,102Explanations: EFT – electronic funds transfer; BC – bank collections; US – unauthorizedsignature; SC – service charge.Additional data for the bank reconciliation:a. The EFT deposit was a receipt of rent. The EFT debit was an…
Prepare the journal entry to reconcile the bank statement in EB9.
zto.mheducation.com/ext/map/index.html?_con=con&external_browser Saved Help Save & Exit Required information Use the following information for the Exercises 12-13 below. (Algo) [The following information applies to the questions displayed below.] of 2 Del Gato Clinic's cash account shows an $15,472 debit balance and its bank statement shows $16,254 on deposit at the close of business on June 30. a. Outstanding checks as of June 30 total $3,069. b. The June 30 bank statement lists a $35 bank service charge. c. Check No. 919, listed with the canceled checks, was correctly drawn for $389 in payment of a utility bill on June 15. Del Gato Clinic mistakenly recorded it with a debit to Utilities Expense and a credit to Cash in the amount of $398. d. The June 30 cash receipts of $2,261 were placed in the bank's night depository after banking hours and were not recorded on the June 30 bank statement. 3251 ok Exercise 6-13 (Algo) Entries from bank reconciliation LO P3 Prepare any necessary…
gleusercontent.com/viewer/secure/pdf/ki7h0e5ernovil8j8jhia898nvne1h7r/0bntlihe Tutorial 10 Submission date: 18 January 2021 before 12.00pm 1. The following are extract from the cash book and bank statement of Fifi Enterprise. Cash Book (Bank Account only) 2020 RM 2020 Dec RM Dec 1 Balance b/d 3,419 8 Basri 462 7 Farah 101 15 Farid 21 22 Ghaz 44 28 Tengku 209 31 Weiwei 319 31 Siti 246 31 Balance c/d 3,437 4,129 4,129 Bank Statement Debit Date Items Credit Balance Dec 1 Balance b/d 3,419 3,520 3,058 3,037 3,081 3,174 7 Cheque 101 11 Basri 462 20 Farid 21 22 Cheque 31 Credit Transfer: Tina 31 Bank Charges 44 93 47 3,127 Required: a) Prepare the updated cashbook. b) Prepare the bank reconciliation statement as at 31 December 2020.
The accompanying table, Data table Date Deposit (Withdrawal) Date Deposit (Withdrawal) 1/1/20 $8,000 1/1/22 $3,272 1/1/21 $(6,540) 1/1/23 $5,255 (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) , shows a series of transactions in a savings account. The account pays 5% simple interest, and the account owner withdraws interest as soon as it is paid. Calculate the following: a. The account balance at the end of each year. (Assume that the account balance at December 31, 2019, is zero.) b. The interest earned each year. c. The true rate of interest that the investor earns in this account. Question content area bottom Part 1 a. The account balance at the end of 2020 is $8,0008,000. (Round to the nearest dollar.) Part 2 The account balance at the end of 2021 is $1,9531,953. (Round to the nearest dollar.)
Which of the following item, have been recorded on the company's books but not yet by the bank: ered f1.00 Select one: stion a. Cash per bank b. Outstanding checks c. Cash per book d. Deposits in transit
6. A portion of your bank statement is shown. Your previous balance was $228.73. What is your present balance Date Checks and Other Charges Number 13-Oct 18-Oct 143 27-Oct 144 31-Oct ATM AT-Phone Service Charge >>> Amount $43.60 112.76 10.64 50.00 5.14 Date Deposits and Credits Amount $146.90 188.42 135.65 5-Oct 12-Oct 19-Oct [ATM] Present Balance