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.

Principles of Accounting Volume 1

19th Edition

ISBN:9781947172685

Author:OpenStax

Publisher:OpenStax

Chapter8: Fraud, Internal Controls, And Cash

Section: Chapter Questions

Problem 9PA: Domingo Company received the following bank statement. Using PA9, prepare the bank reconciliation.

See similar textbooks

Related questions

Q: In quickbooks, Describe the steps used to record an automatic loan payment that appears on a bank…

A: QuickBooks is an accounting software developed to record and manage the loan account, loan payments,…

Q: Encashing the bill before the due date is called from bank

A: Introduction: Bills of exchange: Bills of exchange is mostly used for international trade. Its an…

Q: Prepare the bank reconciliation statement as at 31 December 2020.

A: Bank reconciliation statement involves reconciling balance of bank balance as per books and balance…

Q: Prepare a bank reconciliation using good format. b. Prepare any necessary adjusting journal entries…

A: Sometimes There may be a difference in cash & passbook Balances. Usually Cash & Bank Pass…

Q: Prepare the Bank Reconciliation Statement

A: Bank Reconciliation statement is prepared in order to reconcile the cash account balance as per the…

Q: The "Select Payments Included in This Deposit" se

A: The "Select Payments Included in This Deposit" section of the Bank Deposit form lists Payment…

Q: Safe Security Doors Ltd. undertakes bank reconciliation at the end of each month before preparing…

A: Ideally cash balance as per cash book and bank balance as per bank statement should reconcile with…

Q: prepare a Bank Reconciliation Statement.

A: Bank reconciliation statement is the statement which is prepared at the end of the period in order…

Q: received a check from the Asif and paid in to the bank journal entry

A: Cash and Bank are two different assets for the business. These assets will be debited in case of…

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: A table for a monthly bank reconciliation dated September 30 is given below. For each item 1 through…

A: Bank reconciliation refers to the method used by the company to match the bank statement as well as…

Q: Compute for the deposits in transit as of December 31, 2018. Compute for the outstanding checks…

A: Bank Reconciliation Statement The purpose of preparing the bank reconciliation statement to know the…

Q: a. Prepare a bank reconciliation for Adam Company at April 30. b. Prepare the necessary journal…

A: a) Particulars Amount Amount Particulars Amount Amount Cash Balance according to the statement…

Q: Mr. Matee Nik, the accountant of Tikoy Inc. prepared the following ba reconciliation for November…

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

Q: a. Bank Ledger for November Bank (Asset) Date Details Folio Amount Date Details Folio AmoUne b. Bank…

A: Bank reconciliation is the statement which is prepared by the company in order to match and know the…

Q: In preparing the August 31, 2021 bank reconciliation, Apex Company provided the following…

A: The bank reconciliation statement is prepared to reconcile the items of bank statement and cash…

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: Prepare a bank reconciliation statement for Juan Company for the month of April 2020, using the…

A: The bank reconciliation statement is prepared to equate the balances of cash book and pass book 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: Using the information below, prepare the Bank Reconciliation for the month of August. Be sure to…

A: A)

Q: The following is a comprehensive problem which encompasses all of the elements leamed in previous…

A: Bank reconciliation is the statement which is prepared to rectify all the difference in the cash…

Q: From the following information, construct a bank reconciliation for P.J. Co. as of March 31, 2022:…

A: A bank reconciliation statement is prepared by the management at a particular time period. It helps…

Q: Prepare a reconciliation of the bank and book balances to the correct cash balance and provide the…

A: A journal entry is a form of accounting entry that is used to report a business transaction in a…

Q: For Nos. 26-27 Iron Company has provided the following data in relation to its bank recondiliation…

A: The procedure of balancing the balances of an entity's financial statements for just a cash account…

Q: Prepare a bank reconciliation at July 31, 2022. (List items that increase balance as per bank &…

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

Q: You are the bookkeeper of Holmes Traders. You undertake a bank reconciliation at the end of every…

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

Q: Prepare any necessary journal entries based on the following data regarding the bank reconciliation…

A: Journal entries, in the books of an entity, are recorded to prepare a daily report of the…

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: e) Prepare the bank reconciliation statement for the month ended 31 December 2021 une Harrison,…

A: A bank reconciliation statement reconciles an entity's bank account with its financial records by…

Q: posit in transit of $14,040 and two outstanding cheques (no. 363 for $3,672 and no. 371 for $7,560).…

A: Given: To prepare the general journal entries and bank reconciliation statement as,

Q: uestion Prepare the bank reconciliation statement as at 30 April 2021.

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

Q: Which account is the main focus of a bank reconciliation? Why? Explain the importance of monthly…

A: The answers for the questions relating to Bank Reconciliation Statement are discussed hereunder :

Q: ash Date Debit Credit Balance 10/1/2020 Beginning Balance 8,259.86 10/1/2020 Ck…

A: A bank reconciliation statement is a statement that is prepared to reconcile the bank balance as per…

Q: The April 30 bank statement of Counselling Service Association(CSA) has just arrived from…

A: It is prepared to match the balances of cash and bank.

Q: Accompanying the bank statement was a credit memo for a short-term note collected by the bank for…

A: Bank statement credit memo: Bank statement credit memo is an item enclosed on the bank statement…

Q: What is the adjusting entry of Bank Reconciliation : Credit Memo- Proceed Bank Loan

A: Credit memo - proceed bank loan : A bank's credit memo is defined as the item where the bank account…

Q: Can you please show your work on how you came up with the balance per bank and the balance per book…

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

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: ived its bank statement for the month ending 31 May 2021. The bank reconciliation at the end of…

A: 1) Journal Entries: S no Accounts and explanation Debit Credit (i) Cash 10530…

Q: Which of the following practices contributes to efficientcash management? a. Never borrow…

Q: Compute for Deposits in Transits and Outstanding Checks. After which, prepare the bank…

A: Bank reconciliation statement is the statement which is prepared by the company with the aim and…

Q: The following selected data were taken from the bank statement and cash records of Taehyung V for…

A: Unadjusted cash disbursements per bank statement during the month of December = checks written +…

Q: Prepare the bank account in the general ledger on 31 May 2021.

A: General ledger transactions are a summary of journal entries to sub-ledger accounts. It encompasses…

Q: a) prepare the genral journal entries necessary to update the Bank account in the general ledger for…

A: Bank reconciliation statement is prepared to reconcile cash balance as per cashbook and bank balance…

Q: With the information below, discuss each item whether it is a book reconciling or a bank reconciling…

A: The difference between transactions that are book reconciling and that are Bank reconciling: Those…

Q: Prepare a bank reconciliation statement

A: Bank Reconciliation statement is prepared when there is difference between cash balance as per…

Q: The folowing are extracts from the cash book and the bank statement of R. Wright. You are required…

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

Q: The Treasurer for Marvel Inc., was preparing a bank reconciliation statement as of September 30,…

A: Bank reconciliation is a statement which was prepared by the business organisation where it helps to…

Q: In preparing a monthly bank reconciliation, which of the following would be added to the balance per…

A: Ideally, cash balance as per cash book and bank balance as per bank statement should reconcile or…

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

Domingo Company received the following bank statement. Using PA9, prepare the bank reconciliation.
Prepare the journal entry to reconcile the bank statement in EB9.
Leann Company received the following bank statement. Using the information from PB11 and PB12, prepare the bank reconciliation.
Using the following information, prepare a bank reconciliation. Bank balance: $7,651 Book balance: $10,595 Deposits in transit: $2,588 Outstanding checks: $489 Interest income: $121 NSF check: $966
12 - CODE AND NAME OF THE ACCOUNT WILL BE DEBT 102 02 BANK CURRENCY DTH 62.000121 02 CERTIFICATES OF FX RECEIVABLES 62.000What transaction does the registration made above belong to?A) Acceptance of the policy by the bankB) Endorsement of the policyC) Returning the policy to the bankD) Payment of the policy by the bankE) Collection of the policy by the bank
MC49 The following bank reconciliation is presented for the Pony Co. for the month of November, 2020: Balance per bank statement, 11/30/2020 P180,400 Add: Deposit in transit P41,500 Erroneous bank charge 15,500 56,500 Subtotal P236,900 Less: Outstanding Checks 78,200 Balance per books, 11/30/2020 P158,700 Data for the month of December 2020 follow: Per bank: December deposits/credits — P261,000 December charges/debits — P224,200 Balance, December 31, 2020 — P217,200 All items that were outstanding as of November 30 cleared through the bank in December, including the bank charge. In addition, P25,000 checks were outstanding as of December 31, 2020. What is the amount of cash disbursements per books in December 2020? (WITH SOLUTION) a. P146,000 b. P171,000 c. P249,200 d. P249.200
MC51 The following bank reconciliation is presented for the Pony Co. for the month of November, 2020: Balance per bank statement, 11/30/2020 P180,400 Add: Deposit in transit P41,500 Erroneous bank charge 15,500 56,500 Subtotal P236,900 Less: Outstanding Checks 78,200 Balance per books, 11/30/2020 P158,700 Data for the month of December 2020 follow: Per bank: December deposits/credits — P261,000 December charges/debits — P224,200 Balance, December 31, 2020 — P217,200 All items that were outstanding as of November 30 cleared through the bank in December, including the bank charge. In addition, P25,000 checks were outstanding as of December 31, 2020. What is the amount of cash balance per books in December 2020? (WITH SOLUTION) a. P257,200 b. P242,200 c. P207,200 d. P192,200
12 - CODE AND NAME OF THE ACCOUNT WILL BE DEBT 320 SELLERS HS 45.000101 CHECKS RECEIVED HS 45.000 Which of the following transactions belongs to the journal entry?A) Check collectionB) Sellers debt payment by check turnoverC) Issuing a checkD) Sellers pay debt by issuing checksE) Returning the Check
12 - CODE AND NAME OF THE ACCOUNT WILL BE DEBT 102 02 BANK CURRENCY DTH 62.000121 02 SHARES OF FX RECEIVABLES 62.000What transaction does the above record belong to?A) Acceptance of the policy by the bankB) Endorsement of the policyC) Returning the policy to the bankD) Payment of the policy by the bankE) Collection of the policy by the bank
10.The following are reconciling items in an enterprise's bank reconciliation statement.I. Deposit in transitII. Company check for P32,500 recorded in the books for P23,500III. Check of another company erroneously charged by bank in the company's accountIV. Deposit of another company erroneously credited by bank to the company's accountV. Bank service chargesVI. No sufficient fund check charged back by the bankVII. Company deposit for P32,500 recorded in the books for P23,500Which of the foregoing adjustments would be shown as deduction from the cash balance per books in order to arrive at the correct cash balance? a.II, IV, V, VI and VII b.II, V, VI and VII c.II, V and VI d.V, VI and VII
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
17. In preparing its August 31, 2022 bank reconciliation, AA Corp. has available following information: Balance per bank statement, 8/31/22, P18, 050 Deposit in transit, 8/31/22,P3, 250 Return of customer’s check for insufficient funds, 8/29/22, P600 Outstanding checks, 8/31/22, P2, 750 Bank service charges for August, P100 Check disbursement recorded in August (correct amount is P5,000), P500 AA deposited P15,000 in August but credited by bank at, P1,500 What is the unadjusted balance per book on August 31, 2021?