3:355GSearchPractice Bank Rec Problem.xlsxCheck RegisterBank StmtLightman CompanyCheck Register11/30/18DateItemDebitCreditBalance4,930DepositCheck 721Check 722Check 723Check 724Check 725Check 726DepositCheck 727Check 72814-Nov Deposit1-Nov182867581-Nov2867302-Nov56661643-Nov83253324-Nov5452784-NovVOIDED52785-Nov1052687-Nov2024729210-Nov11492-420011-Nov1418-56186480862Check 729DepositCheck 73030-Nov Deposit20-Nov2492-163021-Nov5292366221-Nov152351038847,394The following checks were outstanding on October's bank reconciliation.Check #Amount700$200707$1,000719$520720$920 3:355GSearchPractice Bank Rec Problem.xlsxCheck RegisterBank StmtShoreline National BankStatement Date 11/30/18Statement of: Lightman Company1130 Davis StreetDaily BalancesAmountChecks/DebitsDeposits/CreditsDateCheck No. AmountDateAmountDate2-Nov2-Nov4-Nov4-Nov6-Nov8-Nov12-Nov12-Nov7002002-Nov18281-Nov757070710008-Nov20242-Nov819872092015-Nov64804-Nov725022-Nov26-Nov7212852926-Nov6418723832816 CM8-Nov83887245430-Nov84 IN12-Nov83387261012-Nov8348NSF2014-Nov653412-NovDM1015-Nov1301414-Nov24-Nov26-Nov30-Nov728181422-Nov183067271149224-Nov681473015226-Nov7478SC830-Nov7554|Code:CM - Credit MemoDM - Debit Memo|NSF - Non-SufficientIN - InteresSC - Service ChargeFundsAdditional Info:The NSF check was received from a customer for merchandise. The debit memois the fee for the NSF check. The credit memo represents an $816 note receivablecollected by the bank. Check number 728 for a purchase of merchandise inventorywas incorrectly recorded in the check register as $1,418 instead of $1,814.Prepare a bank reconciliation and journal entries for November 30, 2018.

Check No Amount 719 520 722 566 729 2492 Total 3578

Answered: Prepare a bank reconciliation and…

Business

Accounting

Prepare a bank reconciliation and journal entries for November 30, 2018.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: Choose the correct option. If you prepare a bank reconciliation based on the following information,…

A: BANK RECONCILIATION STATEMENTA bank reconciliation statement is a financial document that reconciles…

Q: Attached is some information about DGA Groceries. Use this information to prepare a bank…

A: Bank Reconciliation statement as on 30/4/20 Particulars Amount Balance as per Bank statement…

Q: In preparing its bank reconciliation for the month of April 2021, Waterway, Inc. has available the…

A: A bank reconciliation statement is a method of matching the cash balance with the book balance at a…

Q: Balance as per bank statement (Favourable) 17 200 Add: Outstanding deposits: 10 April 2021 8 500 30…

A: A bank reconciliation statement refers to the statement that matches the balance as per the bank…

Q: Prepare adjusted cash book and also bank reconciliation statement as on 31 December, 2019.

A: a. Attached below the adjusted cash book: Adjusted Cash Book Bahrain Ltd For the period…

Q: Use the following bank statement and T-account to prepare any journal entries needed as a result of…

A: Journal entries are accounting transactions arranged in chronological order with equal debit and…

Q: Whispering Winds Corp. had the following transactions involving notes payable. July 1, 2022 Borrows…

A: A journal entry is a record of a financial transaction in a company's accounting system. It…

Q: Will journal entries be necessary based on the book or bank adjustments you discovered in the bank…

A: As per the honor code, We’ll answer the first question since the exact one wasn’t specified. Please…

Q: Include your bank recon in your PDF upload!! 1. The balance on the 10/31 bank statement is $8,000.…

A: Solution: Balancers Inc Bank Reconciliation - October 31 Bank's Cash balance Company's cash…

Q: Suppose there was a third transfer on the interbank transfer schedule for $16,500. Assume that the…

A: The possible concern that I would have for this transfer is regarding on the possible reason as to…

Q: Bank Statement Cheques/Charges Deposits/Credits 31-Мay Balance 12.192.92 6/1 9.050.00 20.677.92 #884…

A: Bank reconciliation statement is prepared where an entry which is found in one book (Cash book or…

Q: BANK RECONCILIATION AND JOURNAL ENTRIES - In the Bank Reconciliation Template, prepare a bank…

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

Q: D a. The EFT credit was a receipt of rent. The EFT debit was an insurance payment. b. The NSF check…

A: The bank reconciliation statement is prepared to equate the balances of cash book and passbook with…

Q: repare a bank reconciliation as of December 31, 2020

A: The bank reconciliation statement is the statement prepared to rectify or reconcile the difference…

Q: In reconciling a bank statement, when a check from the previous month appears on the bank statement…

A: A Bank Reconciliation Statement is a statement prepared on a particular day to reconcile the Bank…

Q: PART 3 - Prepare the bank reconciliation and the necessary journal entries based on the information…

A: Bank Reconciliation Bank cash book Company cash book Per bank statement $12,751 Per…

Q: What is a Bank Reconciliation? Provide 2 examples in which a business must make journal entries…

A: What is a Bank Reconciliations A bank reconciliation statement is a summary of banking and business…

Q: pt in Progress Patricia Sells is unable to reconcile the bank balance at January 31. Patricia's…

A: Bank reconciliation is a statement which is used to reconcile the amount recorded in the books of…

Q: The following information pertains to Carla Vista Company. 1. Cash balance per books, August 31,…

A: Introduction: Bank Reconciliation statement: To reconcile the differences between the cash and bank…

Q: a) From the following information, update the cash book and prepare a bank reconciliation statement…

A: Step 1: Compare the Bank Statement and Cash Book BalancesStart by comparing the ending balance of…

Q: Which of the following are common POSITIVE bank covenants? Indicate ALL that apply. Achieve a…

A: Positive bank covenant are the covenants meant for maintaining the financial health and well-being…

Q: In preparing its bank reconciliation for the month of April 2020, Sunland, Inc. has available the…

A: Bank Reconciliation is prepare in every organisation for reconciliation of bank passbook balance…

Q: On a 32 day notice deposit account, if you opt to withdraw funds sooner than the 32 day notice…

A: A 32-day notice deposit account is a special type of bank account that facilitates the multiple and…

Q: You received your August_2019 bank statement. The August 31, 2019 cash balance in your accounting…

A: Bank reconciliation: It is a statement drawn up by the business to verify the cash book balance with…

Q: 1. NSF check from customer is returned on September 25 but not yet recorded by this company.…

A: Sometimes due to certain reasons the balance of the cash book and the bank statement doesn't…

Q: Discuss three reasons why it is important for companies to prepare monthly bank reconciliations.

A: CONCEPT Bank Reconciliation is process in which bank statements are compared with company's…

Q: ments Journal Payee Grocery nvenience Store pre Gomer Chec y to

A: The Bank Statement and Bank column of the cash book need to be reconciled to understand the deposits…

Q: estion list Question 5 Data table Beginning Balance Deposits and other Credits: Dec. 1 Dec 5 Dec. 10…

A: Note/Definition: Bank reconciliation statement is the statement prepared by company on a particular…

Q: Requirements 1. Prepare the bank reconciliation of Davidson Insurance at December 31, 2018. 2.…

A: Prepare Bank reconciliation statement as follows: Result:

Q: Identify each of the following statements as either true or false. A guideline for safeguarding cash…

Q: What adjustment is required when a check written in a prior month appears on the bank statement for…

A: A bank statement is just a monthly document sent by a bank to its customers that lists the…

Q: 4/30/19 bank statement 900 /19 7,000 0/19 10,400 April 40 usted cash balance at April 30, 2019?

A: BRS is the statement which gives the reasons for difference in bank column and bank statement.

Q: QUIXNO COMPANY Bank Reconciliation November 30, 2018 Cash balance per bank Add: Deposits in transit…

A: What is Bank Reconciliation: A statement is prepared to reconcile the balance as per the cash book…

Q: Exercise 9.7 Preparing a bank reconciliation statement. LO 9-9 Di Stefano Office Supply Company…

A: Bank reconciliation statement is a statement that shows the reconciliation of balance as per bank…

Q: Can i get a step by step explanation on the book to bank method?

A: Book to bank method is a bank reconciliation method in which the reconciliation starts from the…

Q: Good day please assist with this question Show the adjustments that would be required in the…

A: Cash Book It is important for the organisation to maintain the cash book which is involve in all the…

Q: You have been provided with the following information from the books of Zebra Traders: Information…

A: A bank reconciliation statement refers to the statement that matches the balance as per the bank…

Q: 4. Define the following bank reconciliation terms: Deposit in transit: Outstanding check:

A: Bank reconciliation is a statement which is prepared to reconcile the difference between bank…

Q: After posting the journal entries to the Cash T-account, the balance in the Čash T- account should…

A: Cash T-account: It is a ledger account that carries the opening balance of cash, records debits, and…

Q: Using the following, prepare a bank reconciliation for Samtani Co. for August 31, 2020, including a…

A: The objective of this question is to prepare a bank reconciliation statement for Samtani Co. for…

Q: At August 31, 2025, Sage Hill Nail Bar has this bank information: cash balance per bank $10,790,…

A: Lets understand the basics.Bank reconciliation statement is prepare to reconcile the balance as per…

Q: C. A Bank Reconciliation Statement as at June 30, 2020.

A: Any differences between the cash balance as per the bank and the cash balance as per the depositor's…

Q: When a drawee bank certifies a check, it charges the drawer's account with the amount of the check…

A: The drawer account from the banking perspective is an account that involves either an individual or…

Q: 10. Company K has several checking accounts with Bank J. Which of the following will require…

A: Ideally cash balance as per books and bank balance as per bank statement must reconcile with each…

Q: Hesham Geer Inc. has a difference in the balance as per Cash Book and bank statement as on 30h…

A: The bank reconciliation statement is prepared to adjust the balances of cash book and pass book to…

Q: explain why it is important for a business to do a bank reconciliation monthly.

Concept explainers

Bank Reconciliation Statement

As a commerce student, we all know that every business has to maintain a cash book to maintain all his cash and bank transactions. A cash book is a book which has two columns, one cash column and one bank column.

Question

3:35
5G
Search
Practice Bank Rec Problem.xlsx
Check Register
Bank Stmt
Lightman Company
Check Register
11/30/18
Date
Item
Debit
Credit
Balance
4,930
Deposit
Check 721
Check 722
Check 723
Check 724
Check 725
Check 726
Deposit
Check 727
Check 728
14-Nov Deposit
1-Nov
1828
6758
1-Nov
28
6730
2-Nov
566
6164
3-Nov
832
5332
4-Nov
54
5278
4-Nov
VOIDED
5278
5-Nov
10
5268
7-Nov
2024
7292
10-Nov
11492
-4200
11-Nov
1418
-5618
6480
862
Check 729
Deposit
Check 730
30-Nov Deposit
20-Nov
2492
-1630
21-Nov
5292
3662
21-Nov
152
3510
3884
7,394
The following checks were outstanding on October's bank reconciliation.
Check #
Amount
700
$200
707
$1,000
719
$520
720
$920

3:35
5G
Search
Practice Bank Rec Problem.xlsx
Check Register
Bank Stmt
Shoreline National Bank
Statement Date 11/30/18
Statement of: Lightman Company
1130 Davis Street
Daily Balances
Amount
Checks/Debits
Deposits/Credits
Date
Check No. Amount
Date
Amount
Date
2-Nov
2-Nov
4-Nov
4-Nov
6-Nov
8-Nov
12-Nov
12-Nov
700
200
2-Nov
1828
1-Nov
7570
707
1000
8-Nov
2024
2-Nov
8198
720
920
15-Nov
6480
4-Nov
7250
22-Nov
26-Nov
721
28
5292
6-Nov
6418
723
832
816 CM
8-Nov
8388
724
54
30-Nov
84 IN
12-Nov
8338
726
10
12-Nov
8348
NSF
20
14-Nov
6534
12-Nov
DM
10
15-Nov
13014
14-Nov
24-Nov
26-Nov
30-Nov
728
1814
22-Nov
18306
727
11492
24-Nov
6814
730
152
26-Nov
7478
SC
8
30-Nov
7554
|Code:
CM - Credit Memo
DM - Debit Memo
|NSF - Non-Sufficient
IN - Interes
SC - Service Charge
Funds
Additional Info:
The NSF check was received from a customer for merchandise. The debit memo
is the fee for the NSF check. The credit memo represents an $816 note receivable
collected by the bank. Check number 728 for a purchase of merchandise inventory
was incorrectly recorded in the check register as $1,418 instead of $1,814.
Prepare a bank reconciliation and journal entries for November 30, 2018.

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Computation of check issued but not presented for payment

VIEW

Bank Reconciliation Statement

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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

On the Excel worksheet are the T- accounts for cash and other accounts need to record the bank reconciliation. Also, the format for the bank reconciliation is provided. Complete the bank reconciliation, using formulas when possible.
A table for a monthly bank reconciliation dated September 30 is given below. For each item 1 through 12, indicate whether the item should be added to or subtracted from the book or bank balance, and whether it should or should not appear on the reconciliation.
Bank reconciliation and entriesThe cash account for Coastal Bike Co. at October 1, 2019, indicated abalance of $5,140. During October, the total cash deposited was $39,175,and checks written totaled $40,520. The bank statement indicated abalance of $8,980 on October 31, 2019. Comparing the bank statement,the canceled checks, and the accompanying memos with the recordsrevealed the following reconciling items: A. Checks outstanding totaled $5,560.B. A deposit of $1,050 representing receipts of October 31 had beenmade too late to appear on the bank statement.C. The bank had collected for Coastal Bike Co. $2, 120 on a note leftfor collection. The face of the note was $2,000. D. A check for $370 returned with the statement had beenincorrectly charged by the bank as $730.E. A check for $310 returned with the statement had been recordedby Coastal Bike Co. as $130. The check was for the payment of anobligation to Rack Pro Co. on account. F. Bank service charges for October amounted to $25.G. A…
prepare a bank reconciliation report.
Use the information taken from BM traders to complete the following: 1. the cash book receipts and cash book payments for july 2019
i upload this question but you solve just part 1.. i need all parts. urgently please have a look
Are 1 year certificates of deposit recorded on bank reconciliation?
A table for a monthly bank reconciliation dated September 30 is given below. For each item 1 through 12, indicate whether the item should be added to or subtracted from the book or bank balance, and whether it should or should not appear on the reconciliation. (Select the answers in the appropriate cells. Leave no cells blank. Be certain to select "NA" in fields which are not applicable.)
a) prepare the genral journal entries necessary to update the Bank account in the general ledger for Nov 2017\ b) prepare the bank reconcilation as at 30 Nov 2017
The folowing are extracts from the cash book and the bank statement of R. Wright. You are required to. (a) Write the cash book up to date and state the new balance as on 28 February 2020. (b) Draw up a bank reconcaliation statement as on 28 February 2020 Cash Book 2005 Feb 8 A. Kirkland 3500 Feb. 15 R. Mason Feb 28 G. Harris Feb 28 W. Mullings 330 2020 Febi Balancel 10500 350 Feb. 7 R. Clarke Feb 22 K. Hughes Feb 25 K. Wood Feb 26 A. Aiken 1230 275 220 300 750 Feb 28 C. Mills Feb 28 Bal ed 220 12395 7115 7115 12395 March I Bal bif Bank Statement 2020 Cr Balance FebI Balance bf Feb 7 R. Clarke Feb 8 A Kirkland Feb 15 R. Mason Feb 22 K. Hughes Feb 23 R. Brooks Feb 24 P. Peart Feb 28 U. Ulet Feb 28 K. Campbel 10500 10850 7350 6120 350 3500 1230 275 6395 6895 6025 7525 8325 500 870 1500 800 Updated Cash Book Date Details Felio Amount Date Detail Foho Amount Bank Reconciliation Statement aat February 28, 2020 Details
Attached is some information about DGA Groceries. Use this information to prepare a bank reconciliation for April 30, 2020. Bank of Edmonton Downtown Edmonton, Alberta, Canada Bank Statement Period: Apr 1 - 30, 2020 Client Name DCA Groceries Account Number 7800-7802364 Description Deposit Withdrawal Date Balance Balance Forward 1-Apr-20 15,032.00 Cheque#7801010 200.00 1-Apr-20 14,832.00 EFT 2,900.00 1-Apr-20 17,732.00 Cheque Deposit 1,800.00 2-Apr-20 19,532.00 Cheque Deposit 800.00 3-Apr-20 20,332.00 Cheque#7801012 1,500.00 3-Apr-20 18,832.00 Cheque#7801013 1,912.00 3-Apr-20 16,920.00 Checque Deposit 13,200.00 3-Apr-20 30,120.00 Cheque#7801014 110.00 6-Apr-20 30,010.00 Cash Withdrawal 100.00 7-Apr-20 29,910.00 Cash Deposit 1,275.00…
The Treasurer for Marvel Inc., was preparing a bank reconciliation statement as of September 30, 2020. The following were identified: Marvel Inc., book balance =$37,200 Deposit in Transit = $6,200 Outstanding checks = $1,100 Interest earned on checking account =$200 Customer NSF check returned by bank =$600 Find out the adjusted cash balance as at September 30, 2020.