Module 7.2
Module 7.2
Module 7.2
Fundamentals of
Accountancy,
Business and
Management
2 Quarter 2 – Module
7.2:
Bank Reconciliation
Statement
Writer:
NESSA B. DIMALANTA
Teacher-II BACOLOR HIGH SCHOOL
Editors:
JANE P. VALENCIA, ED. D., EPS Mathematics
CHAIRMAN
BETHEL GRACE M. GUIAO- Teacher-III
VIENNAH MARIE M. BUSTOS Teacher-II
1
4. ABC company has P1,000,000 cash balanced per bank statement P550,000 deposit
in transit 900 interest earned on the deposit not yet recorded in the books of accounts,
1,000 bank service charge, and P200,100 outstanding check. What is the adjusted
cash balance?
C.P1,349,100
A. P1,350,000
D.
B. P1,750,
P1,351,000
100
5. Carlos Repairs has a P1,500,000 cash balance per bank statement P600,000 deposit
in transit, P5,000 interest earned on the deposit, net of tax, P1,000 service charge,
P250,000 outstanding checks, and P90,000 NSF check. What is the adjusted cash
balance?
P1,349,100
A. P2,114,000
B. P1,750, D.
100 P1,850,000
C.
6. Carol Laundry Shop has a P2,300,000 cash balance per bank statement, a P398,000
deposit in transit, P320,000 NSF checks, and a P200,000 outstanding check. What is
the adjusted cash balance?
P2,498,000
A. P2,178,000
D.
B.
P2,142,000
P2,620,000
C.
7. Miracle Builders has P1,478,000 cash balance per bank statement, P533,000
deposit in transit, P233,000 NSF check, P205,000 erroneous credit by the bank to the
entity's account, and P221,000 outstanding check. What is the adjusted cash
balance?
C. P1,542,000
A. P1,585,000
D.
B.
P1,818,000
P1,352,000
8. Cristine, the bookkeeper, erroneously recorded a deposit of P420 as P720. What is
the adjustment in the bank reconciliation?
A. P720 addition to the book balance
B. P720 deduction from the book balance
C. P300 addition to the book balance
D. P300 deduction from the book balance
9. Boyet Computer Store recorded a check withdrawal of P78,400 as P76,400. The
check cleared the bank at the correct amount of P78,400. What is the adjusted correct
cash balance per book?
A. P78,400 addition to the book balance.
B. P78,400 deduction from the book balance.
C P2,000 addition to the book balance.
D. P2,000 deduction from the book balance.
10. XYZ company's records show a cash balance of P31,200, but the bank statement
shows a balance of P30,000. If there is only one reconciling item, the P1,200 difference
would most likely be a(an)
check. D. NSF check
A. credit memo.
B. overstated book credit.
C. outstanding
2
Lesso Analyze the effects of the
n 2 identified reconciling
items and bank
reconciliation statements
preparation
It is usual for a company's bank balance as per accounting records to differ from the
balance as per bank statement. The difference between these figures is the reasons
why companies prepare a bank reconciliation statement. Bank reconciliation
statement is a report which compares the bank balance as per the company's
accounting records with the balance stated in the bank statement.
What’s In
FIX ME! Arrange the scrambled words.
1. DRTIEC MOEM CREDIT MEMO____ 2. TSOIDEP IN SAINTRT
_______________________________ 3. ABKN ELCCIAONITNIOR TTEENASMT
_______________________________ 4. BDTIE MOME
_______________________________ 5. NKAB SIERCEV CRGEAH
_______________________________ 6. LCREIOPRAC UCTCNSAO
_______________________________ 7. TDNUINTASOG CKCHES
_______________________________ 8. SETTIENR COEINM
_______________________________ 9. BKOO RESORR
_______________________________ 10. AUOT DBTIE
_______________________________
What’s New
Everyone makes a mistake; the only thing you can do is find ways and fix it.
Determine the amount of the error and state whether the amount will be added or
deducted in the preparation of the bank reconciliation (use adjusted method): Write
your answer on a separate sheet of paper.
1. Romel Repairs received Ᵽ2,000 from Alessandro. The company recorded the amount
as Ᵽ200.
2. Pampanga Bank collected from the customer of Romel Repairs the sum of Ᵽ7,000
representing the said customer's payment to Romel Repairs. No entry made in the
books of Romel Repairs.
3. The bank teller debited a check amounting to Ᵽ2,500 from the account of Romel
Repairs. The said check issued by Romel Refrigeration, a different depositor of the
bank.
3
4. Romel Repairs recorded in the Cash Disbursement Journal a check amounting to
Ᵽ4,010. The correct amount of the check was Ᵽ4,100.
5. Romel Repairs deposits gained the interest of Ᵽ200 for the month. Romel Repairs did
not know of any interest gained until the bank statement was received.
What is It
Analysis of the Effects of the Identified Reconciling Items
TRANSACTION NAME OF ADD/ ADD/DEDU
THE BANK / DEDUCT CT TO BANK
BOOK TO BOOK
RECONCILIN
G ITEM
1. A check of Ᵽ35, 000 Outstandi Deduct to bank
issued to a supplier, was ng Check
not yet presented as
payment to the bank
2. Ᵽ1,500 cash received by the Deposit in Add to bank
company, recorded on Transit
March
31, however, the cash
deposited at the bank on the
afternoon of
April 1.
4
7. A collection of Ᵽ10,000 Book Error Add to
recorded in the book
company’s book as Note: The
Ᵽ1,000. The bank cash book
statement shows the balance
correct amount of was
Ᵽ10,000 understate
d; thus
the
correction
is an
addition
of Ᵽ9,000
(10,000-
1,000) to
the cash
book
balance
8. A collection of Ᵽ5,000 Book Error Deduct to
recorded in the book
company’s book as Note: The
Ᵽ50,000. The cash book
bank statement shows balance
the correct amount of overstate
Ᵽ5,000 d; thus
the
correction
is a
deduction
of Ᵽ45,000
(5,000-
50,000) to
the cash
book
balance
9. Charge for printing Bank Deduct to
company checks and Service book
service fee Charge
(Debit
Memo)
10.Interest credited to Interest Add to book
the bank account Income
(Credit
Memo)
11. The bank statement NSF- No Deduct to
shows a return check of sufficient book
Ᵽ500 by the customer. fund (Debit
Memo)
PER BANK
Unadjusted Bank Balance Ᵽ XX
5
Add: Deposit in Transit (DIT) XX
Less: Outstanding Checks (OC) (XX)
Add/Less: Bank errors XX
Adjusted Bank Balance Ᵽ XX
PER BANK
Unadjusted Bank Balance Ᵽ 510,000
6
a. Credit Memo – Ᵽ19,000
b. Interest Income – Ᵽ100
c. Debit Memo – Ᵽ4,000
d. Deposit in Transit – Ᵽ60,000
e. Outstanding Checks – Ᵽ55,900
Requirement: Prepare the Bank Reconciliation
Solution:
Agyumu Repairs
Bank Reconciliation
For the month ended June 30, 2020
PER BOOK
Unadjusted Book Balance Ᵽ 200,000
PER BANK
Unadjusted Bank Balance Ᵽ 330,000
7
Solution:
Compare the amount in the ledger and the bank statement to determine the
reconciling items.
Bank reconciling items are the amount in the ledger but not in the bank statement.
a. From ledger dated 4/21, Ck#111 amount Ᵽ60,000 is an outstanding check
b. From ledger dated 4/30, Deposit amount Ᵽ250,000 is a deposit in transit
Book reconciling items are the amount in the bank statement but not in the ledger.
a. From the bank statement dated 4/12 described as PAYMENT amount, Ᵽ 35,000
is a Debit Memo
b. From bank statement dated 4/26 described as CHECK DEPOSIT amount Ᵽ
80,000 is a Credit Memo
Ikawpa Repairs
Bank Reconciliation
For the month ended April 30, 2020
PER BOOK
Unadjusted Book Balance Ᵽ1010,000
PER BANK
Unadjusted Bank Balance Ᵽ 865,000
8
❖ T-account analysis
❖ Entry Made Should be Entry
CASH
CASH Dr. Cr.
Dr. Cr.
g. Ᵽ12,000
g. -
Bal. Ᵽ12,000 Bal. -
Correction made
CASH
Dr. Cr.
Ᵽ 12,000
(deduct) Ᵽ 12,000
Bal. -
• Overstated by Ᵽ12,000
❖ Book Error was the collection of Ᵽ220,000 was erroneously recorded as
Ᵽ120,000, which understated the cash balance per book. Therefore, the
correction of Ᵽ100,000(220,000-120,000) added to the cash book balance.
T-account analysis
Entry Made Should be Entry
CASH
CASH
Dr. Cr. Dr. Cr.
a. Ᵽ 120,000 h. Ᵽ 120,000
Bal. Ᵽ 120,000 Bal. Ᵽ 220,000
Correction made
CASH
Dr. Cr.
Ᵽ 120,000
(add) 100,000
Bal. Ᵽ 220,000
9
Bank Errors:
Nature of Error Effect on the Correction
ending cash
balance
Bank debit Overstatement Deduct (Debit)
understated (Sobra) the amount
(Kulang sa overstated
pagbawas) (bawasan)
Bank debit Understatement Add (Credit) the
overstated (Sobra (Kulang) amount
sa pagbawas) understated
(dagdagan)
Bank credit Understatement Add (Credit) the
understated (Kulang) amount
(Kulang sa understated
pagdagdag) (dagdagan)
Book credit Overstatement Deduct (Debit)
overstated (Sobra (Sobra) the amount
sa pagdagdag) overstated
(bawasan)
What’s More
Activity 1
Have you ever been in a situation you need to know what’s left or the balance
in your allowance? Below will make you experience it.
Given the following information, compute the correct cash balance using the adjusted
method. Write your answer on a separate sheet of paper.
Balance per bank Ᵽ20,100 Deposit in Transit 1,500 Outstanding
Checks 2,350 Balance per book 19,555 Additional Information:
Collection of Ᵽ130 was recorded by book as Ᵽ310
Auto-debit of Ᵽ125 for mobile data
Requirement: Compute for the correct cash balance:
_____________________ Assessment 1
10
It is not easy to search for things missing, it will make you dizzy, but if you
have the perseverance to find it, you will be able to answer what is asked
below.
Given the following information, compute the missing information using the adjusted
method. Write your answer on a separate sheet of paper.
Sulong CO.’s cash has the following information
a. Cash balance per bank Ᵽ 9,000
b. Credit Memo 5,000
c. Debit Memo 2,000
d. Deposit in Transit 5,000
e. Outstanding Checks 2,000
Requirement: How much is the cash unadjusted book balance?
Activity 2
Typo errors happen, even when you send messages via text, though still, you
correct it by sending another message which same goes with this activity, you
will be able to correct it.
For the month of May 2019, Kulot Company issued the following checks as recorded
in its Cash Disbursement Journal:
Check Date Check No Payee Amount
5/2/2019 1256 Mary Ᵽ 1,000
As per the bank statement received by Tope, the following checks were presented and
paid by the bank:
Check No. Payee Amount
1256 Mary Ᵽ 1,000
Requirement: Identify the outstanding checks as of the end of May 2019. Write
your answer on a separate sheet of paper.
Assessment 2
Practice makes perfect. By correcting mistakes, you’ll have tons of ways.
The cash receipts journal of Malaya Merchandising reflected the following collections
for the month of April 2019:
Official Receipt Official Receipt No. Customer Amount
Date
5/2/2019 1256 Mary Ᵽ 6,000
5/8/2019 1257 Jane 3,000
5/9/2019 1528 Alessandro 900
5/25/2019 1259 Alejo 800
5/26/2019 1260 Dan 3,000
5/30/2019 1261 Juven 4,500
5/30/2019 1262 Net 4,000
11
It is the policy of the company to deposit collection within the following day from the
date of collection.
The bank statement for April 2019 revealed following deposits made:
Deposit Date Amount
5/3/2019 Ᵽ 6,000
5/9/2019 3,000
5/10/2019 900
5/26/2019 800
5/26/2019 3,000
Requirement: Compute for the deposit in transit or undeposited collection as of
end of April 2019. Write your answer on a separate sheet of paper.
Activity 3 Check Me!
Determine whether the following reconciling items should be added to the book
or bank account balance or deducted from the book or bank account balance by
putting a (√) checkmark. Write your answer on a separate sheet of paper.
RECONCILING ITEMS ADD DEDU ADD DEDU
TO CT TO CT
BOOK FROM BANK FROM
BOOK BANK
1. Jodi Dela Cruz Company had a
receipt of Ᵽ100,000 and correctly
prepared its bank deposit slip for
Ᵽ100,000. However, the company
recorded the receipt in its Cash
account as Ᵽ101,000. How is the
difference of Ᵽ1,000 handled on the
bank reconciliation?
2. Blaze Mudlong wrote a check worth
Ᵽ46,000, and it cleared the bank for
Ᵽ46,000. However, the company
recorded the receipt in its Cash
account as Ᵽ64,000. How is the
difference of Ᵽ18,000 handled on the
bank reconciliation?
3. Bank erroneously posted another
company’s Credit memo to MN Mitz
Company bank account
4. Bank inadvertently charged Mikka
Joson Company’s bank account for
another Company’s bank fees
5. Bank service charge
6. Deposit in transit
7. The fee charged by the bank for a
returned check
8. Interest credited to the bank account
9. Outstanding checks
10. The bank collected a Note
Receivable for the Acer Garcia
Corporation and Credited the
company’s bank account for
Ᵽ1,000,000
Assessment 3
12
After fixing and correcting, what do you think will be next?
Prepare for the Bank Reconciliation of Matiaga Company for the month of
September 30, 2019. Write your answer on a separate sheet of paper.
a. The bank statement for September 2019 shows an ending balance of Ᵽ3,490.
b. On September 30, the bank statement shows charges of Ᵽ35 for the service charge
for maintaining the checking account.
c. On September 26, the bank statement shows a returned item of Ᵽ100 plus a related
bank fee of Ᵽ10. The returned item is a customer's check returned because of
insufficient funds.
d. The bank statement shows a charge of Ᵽ80 for check printing on September 22.
e. The bank statement shows that Ᵽ8 was added to the checking account on September
30 for interest earned by the company during September.
f. The bank statement shows that a note receivable of Ᵽ1,000 was collected by the bank
on September 29 and deposited into the company's account. On the same day, the
bank withdrew Ᵽ40 from the company's account as a fee for collecting the note
receivable.
g. The company's Cash account at the end of September shows a balance of Ᵽ967.
h. During September, the company wrote checks totaling more than Ᵽ50,000. As of
September 30, Ᵽ3,021 check written in September had not yet cleared the bank, and
Ᵽ200 of checks written in July had not yet cleared the bank.
13
Maganda Company recorded a check received from customers amounting Ᵽ2,120. The
bank statement showed that the customer checks cleared at the amount of Ᵽ2,210.
The bank erroneously deducted Ᵽ210 from the Maganda Company account, a check
issued by another company.
Requirement: Prepare for the Bank Reconciliation of Maganda Company for the
month of December 31, 2019. Write your answer on a separate sheet of paper.
What I Can Do
To gauge understanding in the activities provided, better answer the questions
provided below.
MULTIPLE CHOICE. Write the correct letter of your answer on a separate sheet of paper.
1. Masigasig Company issued a check for Ᵽ56, and it cleared the bank for Ᵽ56.
However, the company recorded the check on its cash ledger as Ᵽ66. How is the
difference of Ᵽ10 be treated on the bank reconciliation?
A. Add to BOOK Balance B. C. Add to BANK Balance D.
Deduct from BOOK Balance Deduct from BANK Balance
2. Bank incorrectly charged the company account for Masipag Company's bank service
charge.
A. Add to BOOK Balance B. C. Add to BANK Balance D.
Deduct from BOOK Balance Deduct from BANK Balance
3. Bank mistakenly post Masipag Company's credit memo to Masigasig Company bank
account.
A. Add to BOOK Balance
B. Deduct from BOOK Balance 4. BELIEVE IN YOURSELF! You can do
Interest charged to the bank account
it! Bank Reconciliation Problem
A. Add to BOOK Balance
B. Deduct from BOOK Balance 5. C. Add to BANK Balance D. Deduct
from BANK Balance
Interest credited to the bank account
A. Add to BOOK Balance
B. Deduct from BOOK Balance C. Add to BANK Balance D. Deduct
from BANK Balance
The bank statement for Kulot Company shows a balance per bank of Ᵽ15,907.45 on
April 30, 2015. On this date, the balance of cash per book is Ᵽ11,589.45.
Additional information is provided below:
Deposits in transit:
April 30 deposit (received by the bank on May 1) Ᵽ2,201.40
14
Outstanding checks:
No. 453- Ᵽ3,000.00
No. 457- Ᵽ1,401.30
No. 460- Ᵽ1,502.70
Errors:
Juan wrote the check no. 443 for Ᵽ1,226.00, and the bank correctly paid that amount.
However, he recorded the check as Ᵽ1,262.00.
Bank memoranda:
Debit– NSF check from Pedro Ᵽ425.60.
Debit– Charge for printing company checks Ᵽ30.00
Credit – Collection of a note receivable for Ᵽ1,000 plus interest earned of Ᵽ50, less
bank collection fee of Ᵽ15.00.
Required: Prepare a bank reconciliation statement using the adjusted method.
Write your answer on a separate sheet of paper.
Additional Activities
Be enthusiastic about achieving your goal.
EOREDRCD EACANLB
OOKB ACLDEER
RWEON
Fill in the blanks by choosing your answer to the scrambled word box. Write your
answer on a separate sheet of paper.
1. The person or company writing a check is the __________ of the check
2. Items on the bank statement that are not yet on the company's books will need to be
___________ on the books.
3. A check that has been paid and therefore appears on the bank statement is said to
have _________ the bank.
4. The adjusted balance per bank statement should agree with the adjusted balance
per _________.
5. A bank service charge is a deduction from the _________ per books
15
book 4.
Answer Key
balance 5. Balance 12,204.85 Ᵽ
Add to BOOK a. 5.
cleared 3. deducted in
recorded 2. P90 will be 4.
owner 1. records.
added to bank
Activity P2,500 will be 3.
dditional A books
added to the
P7,000 will be 2.
books.
records added to the
to the book P1,800 will be 1. 930 , 7 Ᵽ
balance
P200 is added 5. ’s New What d cash
records Adjuste 1.
the book
C 2.
Learned C 1.
Have What I Know
What I
BOOK Balance
Deduct from b. 4.
BANK Balance
Deduct from d. 3.
Balance 1,719 Ᵽ 1.
Add to BANK c. 2. 9. Deduct from Bank 10 Add to
BOOK Balance 3 Assessment Book 7. Deduct from Book 8. Add
from Deduct b. 1. 00 5, 8 Ᵽ 1.
to Book 5. Deduct from Book 6.
Add to Bank Bank
Can Do What I 2 Assessment 3. Deduct from Bank 4. Deduct
from Book
AUTO DEBIT 10. 9,000 Ᵽ 1. 1. Deduct from Book 2. Deduct
BOOK ERRORS 9. Assessment 1 from Activity 3
INTEREST INCOME 8.
CHECKS ’s More hat W
OUTSTANDING 7. Adjusted cash balance ,500 2
ACCOUNTS Ᵽ for Alessandro issued to 00
RECIPROCAL 6. Assessment and Check 1528 4 Ᵽ for
CHARGE Jane Check 1257 issued to 1.
SERVICE BANK 5.
DEBIT MEMO 4. Activity 2
STATEMENT D 10.
RECONCILIATION D 9.
BANK 3. D 8. 19,250 Ᵽ 1.
DEPOSIT IN TRANSIT 2. A 7.
CREDIT MEMO 1. C 6. Activity 1
NI ’s What D 5.
C 4. ’s More What
B 3.
16
References:
By
• Curriculum Guide in Fundamentals of Accountancy, Business and
Management 2
• Beticon, J. L, & Domingo, J. D, & Yabut, F. D. (2016).
Fundamentals of Accountancy, Business, and Management 2
Teacher’s Manual (2016). Quezon City: Vibal Group, Inc.
• Fundamentals of ABM 2: Senior high school SHS teaching guide.
(2019, April 3). Retrieved from
https://www.teacherph.com/fundamentals-abm-2-senior-high-school
teaching-guide/
• Ferrer, R. C, & Millan, Z. B., (2018). Fundamentals of
Accountancy, Business, and Management 2 (2nd ed., Ser. 2018).
Baguio: Bandolin Enterprise.
17
Development Team of the Module
Writers: Nessa B. Dimalanta
Editors: Jane P. Valencia, Ed. D., EPS - Mathematics
Reviewers: Bethel Grace M. Guiao/Viennah Marie M. Bustos
Illustrator: Nessa B. Dimalanta
Layout Artist: Nessa B. Dimalanta
Management Team:
ZENIA G. MOSTOLES, EdD, CESO V, Schools Division Superintendent
LEONARDO C. CANLAS, EdD, CESE. Asst. Schools Division Superintendent
ROWENA T. QUIAMBAO, CESE, Asst. Schools Division Superintendent
CELIA R. LACNALALE, PhD, CID Chief
JANE P. VALENCIA, EdD, Education Program Supervisor, Mathematics
JUNE E. CUNANAN, Education Program Supervisor/ Language Editor
RUBY M. JIMENEZ, PhD., Education Program Supervisor, LRMDS
18