Topic: Cash and Cash Equivalents / Intermediate Accounting 1 XYZ Co. uses the imprest system. The following are excerpts fromXYZ's "Cash in bank - ABC Bank" subsidiary ledger and the Novemberbank statementDateCheck No.DebitsCreditsBalanceNov. 110,000.00Nov. 433934,000.0044,000.00Nov. 913417,000.0027,000.00Nov. 1213513,000.0014,000.00Nov. 13Cash16,000.0030,000.00Nov. 161368,000.0022,000.00Nov. 2123452,000.0074,000.00Nov. 2278419,000.0093,000.00Nov. 291377,600.00 85,400.00Nov. 3084623,500.00108,900.00144,500.00 45,600.00 Bank statementPeriod covered: Nov. 1, 2021 to Nov. 30, 2021DateCheck No.DebitsCreditsBalanceNov. 110,000.00Nov. 533934,000.0044,000.00Nov. 638978,000.00 122,000.00Nov. 13Cash16,000.00 138,000.00Nov. 1613513,000.00125,000.00Nov. 1898433,000.00 158,000.00Nov. 191368,000.00150,000.00Nov. 2123425,000.00 175,000.00Nov. 2278419,000.00 194,000.00Nov. 25|0784 (NSF)19,000.00175,000.00Nov. 28(DM)2,000.00173,000.00Nov. 301377,600.00165,400.00Required:Prepare the November bank reconciliation. Assumethe error is committed by XYZ Co.

There are two type of cash balances that is being used and recorded in business. These are cash…

Answered: Required: Prepare the November bank…

Business

Accounting

Required: Prepare the November bank reconciliation. Assume the error is committed by XYZ Co.

Principles of Accounting Volume 1

19th Edition

ISBN:9781947172685

Author:OpenStax

Publisher:OpenStax

Chapter8: Fraud, Internal Controls, And Cash

Section: Chapter Questions

Problem 11PB: Leann Company received the following bank statement. Using the information from PB11 and PB12,...

See similar textbooks

Related questions

Q: Sundae Inc. sells land to Parfait Co. for 9k. The land had cost S 10k 5 years ago. Provide the…

A: P is the hodling company of S [80% shares owned by P of S]. So when Q sold land…

Q: At the end of last year, Edwin Inc. reported the following income statement (in millions of…

A: An income statement is a statement that shows a company's income and costs. It also displays if a…

Q: Please verify that all June 1 balances are in the ledgers by comparing them to the May 31, 2021…

A: Ledger Account The purpose of preparing the ledger account is to know the actual balance which are…

Q: The following are Mueller Company’s cash flow activities: Prepare Mueller Company’s statement of…

A: Statement of cash flows forms a part of financial statements and is prepared with a view to…

Q: Use the following to answer questions 4 – 7 (Round answers to the nearest dollar) TR issues 6.0%,…

A: Given, Face value of bond= $1,500,000 Interest rate= 6%, semi-annual Time = 10 years Market interest…

Q: s of January 1, 2020, the City of Monroe had $12,000,000 in general obligation bonds outstanding.…

A: Journal entries needs to prepare Relating with bonds and treatment of expenditure and interest

Q: ix) Wages and salaries are expected to be $2,304,000 per annum and will be paid monthly. x) In the…

A: Cash Budget- A cash budget is a strategy for determining an organization's cash inputs and outflows.…

Q: Prepare a classified balance sheet for the partnership on January 1, 2022. (List Current Assets in…

A: Statement of financial position refers to a statement which provides a brief summary of the…

Q: I The list below shows select accounts for Reading Readiness Company as of January 31, 20X1 2…

A: Income Statement: It is a statement prepared by the company which helps in calculating the net…

Q: On a CVP graph, the intersection of the sales revenue line and the total cost line is known as the:…

A: The Break-even point indicates that total units are to be sold by the business entity to recover its…

Q: Randall Corporation (a C Corporation) acquires an apartment building for $200,000 on September 1,…

A: As per IRS rules you can depreciation apartment builidng used for business as…

Q: Kabe owns a fleet of light delivery vehicles. One of his delivery vehicles with a market value of…

Q: The City of Wilmington, Delaware, has an Other Postemployment Benefit Trust Fund and a Tax…

A: The statement of fiduciary net position is a statement used to represent all the changes i.e.…

Q: The AW values for retaining a presently owned machine for additional years are shown in the table.…

A: Economic service life refers to the period of useful life that reduces the corresponding annual cost…

Q: On May 1, 2014 Barton Corporation purchased for cash of S37.500 a patent with a useful ife of 10…

A: The journal entries are prepared to keep the record of day to day transactions of the business on…

Q: lease help with question B and C: B.) Another team member who is preparing the Budgeted Balance…

A: Cash Budget Budgeted Cash Collection for Trade receivable Budgeted Cash Collection for Trade…

Q: A company has a $15,000 loan payable that is due over five years. $3,000 of the loan must be paid in…

A: Current liabilities include all those liabilities which are payable within a time period of twelve…

Q: During the current year, Cartwright Corporation’s accountant recorded numerous transactions in an…

A: According to the logic of a journal entry, every business transaction should be documented in at…

Q: Accordingly, the following entries relating to the contingency for warranty costs were recorded…

A: Warranty expenses are the expenses that are incurred with respect to the repair, replacement, or…

Q: sed on your analysis in requirement 1, which product or products should be sold at the split-off…

A: A split-off point occurs when formerly jointly created components are now manufactured separately,…

Q: Oven Roasted sold $394,000 of consumer electronics during July under a two-year warranty. The cost…

A: The journal entries are prepared to keep the record of day to day transactions of the business on…

Q: 1) A monthly depreciation expense of $600 is recorded on a truck that was purchased for $27 000 and…

A: Depreciation rate = Annual depreciation / Depreciable value of the assets where, Depreciable value…

Q: ONLY ANSWER QUESTION (B) the task of preparing the cash budget for the business for the quarter…

A: A cash budget is an estimate of a corporation's cash flows for a given time span. A cash budget is…

Q: the “paperless payroll law” and many employers opted to give their employees pay cards instead of…

A: Pay method The pay method refers to how the employer distributes money to employees. Cash, check,…

Q: The Chapter 7 Form worksheet is to be used to create your own worksheet version of the Review…

A: Office Mart Order consists of following Customers 1 Customer Orders 11 orders Number of…

Q: from pension contribution state two other expenses that an individual may use to reduce his/her tax…

A: A taxpayer is allowed certain deductions that can be used to reduce the taxable income and…

Q: Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in…

Q: On June 1, Snow Company established a petty cash fund of $1,000 to pay for various office supplies.…

A: Petty Cash Book seems to be an accounting book being used tracking little and low-value costs such…

Q: Pleasant Planes Co. purchased a new jet on January 1, 2019 for $5,000,000. Pleasant Planes Co.…

A: Calculation of Depreciation Expense for 2019 Depreciation Expense for 2019 = Number of miles flew in…

Q: Sean and Co is a new pizza delivery business that was created by depositing £20,000 in a bank…

A: In the given question, details about Sean and Co's pizza delivery business details are mentioned.…

Q: Fairfield Company management has budgeted the following amounts for its next fiscal Selling price…

A: Formula to calculate Break Even Point. BEP = Fixed Cost / Contribution per unit Where, Contribution…

Q: The comparative balance sheets and income statement of Piura Manufacturing follow Additional…

A: I am answering the first three sub-parts of the question as per bartleby guidelines. Please…

Q: During 2021, a company sells 359 units of inventory for $86 each. The company has the following…

A: Formula: Cost of goods sold = Cost of goods available for sale - Ending inventory value

Q: Oriole Corporation has 74.000 shares of common stock outstanding It declares a $2 per share cash…

A: Introduction: Journals: Recording of a business transactions in a chronological order. First step in…

Q: Assume a company receives an actual return of goods. Which of the following needs to happen? Sales…

A: The return of goods is the amount of goods that were sold to customers but were returned to…

Q: Assuming the following facts, calculate the total tax provision Sales…

A: Given that : Pre-tax book net income 75,000 Tax rate…

Q: Western Trucking operates a fleet of delivery trucks. The fixed expenses to operate the fleet are…

A: Fixed cost is the cost that never changes/ varies as a whole and variable cost is the cost that…

Q: Sales $1248000 Contribution margin 466560 Total direct fixed costs 405000 Total operating assets…

A: Formula: ROI = Net profit / Average Operating Assets.

Q: On January 1, 2021, Pet Friendly Stores adopted the retall inventory method. Inventory transactions…

A: The ratio signifying the amount of cost in a retail price is referred to as the cost-to retail…

Q: On January 31, 2021, the Term Deposit Account is closed and the balance is transferred to the Demand…

A: Term Deposit Account Demand Deposit Account

Q: Prepare the following financial statements for Sea View Tour Income Statement for the yearended 31…

A: Introduction : An income statement is a financial statement that shows the income and expenses of a…

Q: Windsor Corporation enters into a 7-year lease of equipment on December 31, 2019, which requires 7…

A: Leasee Windsor Corporation Lease Payment beginning of dec 31, 2019 $ 41,100 Period 7…

Q: Please help with question B and C: B.) Another team member who is preparing the Budgeted Balance…

A: Cash Budget It is important for the business entity to prepare the cash budget which knows the…

Q: Walmart Blackout Power Company constructed a new power plant to supply energy to the Castle…

A: Avoidable interest relating to non-asset specific borrowing: Principal x Interest Rate Interest…

Q: he following information for the past year for the Magic Corporation has been provided: Fixed costs:…

A: Contribution margin refers to a gross or per unit basis. it shows that the incremental money is…

Q: What is the total profit in the planning budget for the month?

A: Needs to plan flexible budget as per the requirement

Q: Below are three independent and unrelated errors. On December 31, 2017, Wolfe-Bache Corporation…

A: Solution:- Explanation of the effect of each error on the income statement and the balance sheet in…

Q: Icebreaker Company (a U.S.-based company) purchases materials from a foreign supplier on December 1,…

A: Given that : Icebreaker purchase material from foreign supplies on 1 December 2020 and sales to be…

Q: On March 1, 20x1, ABC assigned its P4,000,000 accounts receivable to XYZ Bank in exchange for a…

A: Introduction The formula in computing the Equity on Assigned Accounts of ABC is shown below. Equity…

Concept explainers

Cash Book

So, before coming to the topic of cash books, I will let you briefly explain about the cash so that you all can be familiar with the word cash. Cash comes under the category of the current asset which is used as a medium of exchange for all the financial transactions in the firm. Cash is something that is universally accepted as a mode of payment. So, now comes to the topic i.e., cash book.

Question

Topic: Cash and Cash Equivalents / Intermediate Accounting 1

XYZ Co. uses the imprest system. The following are excerpts from
XYZ's "Cash in bank - ABC Bank" subsidiary ledger and the November
bank statement
Date
Check No.
Debits
Credits
Balance
Nov. 1
10,000.00
Nov. 4
339
34,000.00
44,000.00
Nov. 9
134
17,000.00
27,000.00
Nov. 12
135
13,000.00
14,000.00
Nov. 13
Cash
16,000.00
30,000.00
Nov. 16
136
8,000.00
22,000.00
Nov. 21
234
52,000.00
74,000.00
Nov. 22
784
19,000.00
93,000.00
Nov. 29
137
7,600.00 85,400.00
Nov. 30
846
23,500.00
108,900.00
144,500.00 45,600.00

Bank statement
Period covered: Nov. 1, 2021 to Nov. 30, 2021
Date
Check No.
Debits
Credits
Balance
Nov. 1
10,000.00
Nov. 5
339
34,000.00
44,000.00
Nov. 6
389
78,000.00 122,000.00
Nov. 13
Cash
16,000.00 138,000.00
Nov. 16
135
13,000.00
125,000.00
Nov. 18
984
33,000.00 158,000.00
Nov. 19
136
8,000.00
150,000.00
Nov. 21
234
25,000.00 175,000.00
Nov. 22
784
19,000.00 194,000.00
Nov. 25
|0784 (NSF)
19,000.00
175,000.00
Nov. 28
(DM)
2,000.00
173,000.00
Nov. 30
137
7,600.00
165,400.00
Required:
Prepare the November bank reconciliation. Assume
the error is committed by XYZ Co.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Accounting for Cash and cash equivalents

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Leann Company received the following bank statement. Using the information from PB11 and PB12, prepare the bank reconciliation.
Prepare the journal entry to reconcile the bank statement in EB9.
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
O CDE3. From the following, construct a bank reconciliation with heading for Woody Co. as of May 31, 2022. GL Cash balance $1,869.60 Outstanding cheques Bank service charge NSF cheque 427.80 Bank statement balance 1,951.20 13.80 Deposits in transit 271.20 61.20
YOU CAN DO IT The accounting records and bank statement of Entity A show the following information. SUBSIDIARY LEDGER CASH IN BANK – FCB CURRENT ACCOUNT Date Description Debit Credit Balance 6/1 Balance forwarded 881,000 750,200 530,200 826,000 1,496,000 80,000 1,416,000 380,000 1,036,000 1,196,000 130,800 220,000 6/11 Check #1113 6/15 Check #1114 295,800 670,000 6/16 Deposit Deposit Check #1115 6/22 6/24 6/28 Check #1116 6/29 Deposit 160,000 |FirstCitizens Bank Account Number 5022-0007-00 Account Type FCB CURRENT ACCOUNT Branch VILLAMOR BRANCH Period Covered 6/1/2019 – 6/30/2019 Date Description Ref Details Debit Credit Balance BALANCE FORWARDED 881,000.00 5/10/2019 CASH DEPOSIT 050 PASAY 350,000.00 1,231,000.00 5/11/2019 PAYMENT 010 2,000.00 1,229,000.00 5/12/2019 CHECK ENCASHMENT 090 CK#1114 220,000.00 1,009,000.00 5/15/2019 CHECK DEPOSIT 040 PASAY 295,800.00 1,304,800.00 5/18/2019 PAYMENT 011 50,000.00 1,254,800.00 5/26/2019 CASH DEPOSIT 051 670,000.00 1,924,800.00 6/24/2019 CHECK…
Read and understand the transaction. Prepare a Bank Reconciliation Statement using the following methods: a. Adjusted Method b. Book-to-bank Method c. Bank-to-book Method Use the space provided for each method for you answer. Moonlight Company maintains cash in ODB Bank. The following information was made available for the month of October 2021: • The bank statement at the of the month shows P10,000. • Deposits not yet reflected in the bank statement, P84,000. • Checks issued but not yet encashed by the payees, P65,000. The bank made an error of debiting the account of Moonlight Company, which was actually a debit for Crescent Company, P4,000. • The ledger shows a cash-in-bank balance of P12,000. Notes receivable collected by the bank for Moonlight Company amounted to P16,000. • Interest earned by Moonlight Company from keeping their cash at ODB Bank is P5,000. • ODB Bank charged Moonlight Company P1,000 service charges directly debited to their account as seen in the bank statement. •…
The following information pertains to jeng Company: Balance per bank statement, Dec. 31, 2013, P73,350Cash ledger balance, Dec. 31, 2013, P63,675Proceeds of a customer’s note collected by the bank including P50 interest, P6,525Bank service charges, P45Deposit in transit, P4,158NSF check of customer deposited and returned, P378Outstanding checks, P7,731 Requirement:a. Prepare the bank reconciliation statement.b. Journalize the adjusting entries
The balance of the general ledger cash accounts as of December 31, 20P1 is P7,120. On the other hand, the bank statement showed a December 31 20P1 balance of P6,580. You were tasked to prepare the bank reconciliation statement for the company's bank account. Your analysis of the bank statement and the general ledger account revealed the following: |Deposit in transit Credit memo for direct collection of a note receivable Credit memo for interest income Auto debit of cell phone bill Customers NSF check |Outstanding check Debit memo for bank charges A check received from a customer was recorded in the accounting books for P3,280. The bank statement revealed that the customer check cleared at the correct amount of P3,820. P1,345 755 65 290 455 575 25 The bank deducted P360 from the account of JECAF for a check issued by Claire Inc. Page 13 of 17 Required: Prepare the bank reconciliation statement as of December 31, 20P1 for JECAF bank account. Solution: Bank Book
Use the following information that was drawn from the books of Ralesego as on 31December 2020 to draw the bank reconciliation statement. Details Amount ‘Pulas’Cash at bank as per cashbook bankcolumn 2,910Unpresented Cheques 730 Bank lodgments 560Credit transfers appearing in the bank 340statement but not entered in the cashbookCash balance as per bank statement 3,420
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
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?
Reconcile the bank account and theaccounting books based on the followinginformation: a. The bank statement for theaccount of Hungry Joe Companyreflects the July 31 balance ofP54,780.00 b. P68,757 was the ending balance ofthe general ledger cash account onJuly 31. c. A check issued by Hungry JoeCompany for P3,000 was recorded inthe accounting books as P4,500. d. checks that were issued and received bypayees that have not yet cleared the bankas of July 31 totaled to P9,885. e. Bank service charge according tothe July bank statement is P210.Hungry Joe ‘s accountant has not yetrecorded this on the books. f. Deposit in transit as for July amountedto P13,425 g. Comparison of the accountingrecords and bank statement showeda July 3 P600 deposit (with validateddeposit slip on file) that was notfound in the bank statement. h. There were two customers checks thatwere dishonored by the bank in July fornonsufficient funds: From Cris Corporation = P1,296 From May Incorporated = P14,265 i. The…