Local Media6165884361470988327
Local Media6165884361470988327
Local Media6165884361470988327
Accounting, Business
and Management 2
Quarter 2 – Module 1:
Bank Reconciling Items
Republic Act 8293, section 176 states that: No copyright shall subsist in any work of
the Government of the Philippines. However, prior approval of the government agency or office
wherein the work is created shall be necessary for exploitation of such work for profit. Such
agency or office may, among other things, impose as a condition the payment of royalties.
Borrowed materials (i.e., songs, stories, poems, pictures, photos, brand names,
trademarks, etc.) included in this module are owned by their respective copyright holders.
Every effort has been exerted to locate and seek permission to use these materials from their
respective copyright owners. The publisher and authors do not represent nor claim ownership
over them.
Team Leaders:
School Head : Reynaldo B. Visda
LRMDS Coordinator : Melbourne L. Salonga
This learning resource hopes to engage the learners into guided and independent
learning activities at their own pace and time. Furthermore, this also aims to help
learners acquire the needed 21st century skills while taking into consideration their
needs and circumstances.
In addition to the material in the main text, you will also see this box in the body of
the module:
As a facilitator you are expected to orient the learners on how to use this module.
You also need to keep track of the learners' progress while allowing them to manage
their own learning. Furthermore, you are expected to encourage and assist the
learners as they do the tasks included in the module.
1
For the learner:
The hand is one of the most symbolized part of the human body. It is often used to
depict skill, action and purpose. Through our hands we may learn, create and
accomplish. Hence, the hand in this learning resource signifies that you as a learner
is capable and empowered to successfully achieve the relevant competencies and
skills at your own pace and time. Your academic success lies in your own hands!
This module was designed to provide you with fun and meaningful opportunities for
guided and independent learning at your own pace and time. You will be enabled to
process the contents of the learning resource while being an active learner.
What I Need to Know This will give you an idea of the skills or
competencies you are expected to learn in the
module.
2
What I Can Do This section provides an activity which will
help you transfer your new knowledge or skill
into real life situations or concerns.
1. Use the module with care. Do not put unnecessary mark/s on any part of the
module. Use a separate sheet of paper in answering the exercises.
2. Don’t forget to answer What I Know before moving on to the other activities
included in the module.
3. Read the instruction carefully before doing each task.
4. Observe honesty and integrity in doing the tasks and checking your answers.
5. Finish the task at hand before proceeding to the next.
6. Return this module to your teacher/facilitator once you are through with it.
If you encounter any difficulty in answering the tasks in this module, do not
hesitate to consult your teacher or facilitator. Always bear in mind that you are
not alone.
We hope that through this material, you will experience meaningful learning and
gain deep understanding of the relevant competencies. You can do it!
3
What I Need to Know
At the end of the month, the bank will release a bank statement. To monitor and
balance the records of cash in the bank and records of cash of the company, we need
to do bank reconciliation. This module will let us understand bank reconciliation.
We will start with the Bank Reconciling Items.
4
What I Know
2. These are deposits already recorded in the company’s book balance but not
yet recorded in the bank records.
a. Deposit in transit
b. Bank errors
c. Outstanding checks
d. None of the above
3. These are items mistakenly recorded by the bank to the company’s account.
a. Bank error
b. Book error
c. Bank checks
d. None of the above
5. These are deposits made by the bank to the company’s account but not yet
reflected in the company’s books.
a. Bank credits
b. Bank debits
c. Bank checks
d. None of the above
5
Lesson
From the last module, you have learned about the elements of a bank statement. You
have learned that every end of the month, the bank will release a bank statement.
However, the records of the bank are not always in agreement with how we record
cash transactions in our books. To monitor and balance the (1) records of cash in
the bank and (2) records of cash of the company, we need to do bank reconciliation.
=
BANK STATEMENT CASH LEDGER
“Bank” “Book”
6
Note: For the ease of discussion, we will use the term “bank” to refer bank reconciling
items and “book” for book reconciling items. It is important to note that to increase
the cash in the books we need to debit it. However, it is not the same for bank records.
The bank recognizes the company’s cash as a liability in its balance sheet, therefore
cash of the company is increased by crediting the amount to its account.
Here are the items to reconcile for both bank and book records.
1. Bank debits - bank charges that the bank deducts against the company’s
account and not yet reflected in the books.
2. Bank credits - deposits made by the bank but not yet reflected in the books.
3. Book errors - item erroneously recorded by the company in its books.
7
What’s In
There is a lot to figure out about reconciling items, isn’t it? Let us have a quick review
by filling out the table with the reconciling items. Choose the answers from the box
below and define each.
1. 1.
2. 2.
3. 3.
8
What’s New
3. Bank errors - items erroneously recorded by the bank during the month.
9
• Cash in bank P xxx
Loan Payable P xxx
To record proceeds of the loan.
3. Book errors are corrected through reversal entry of the affected accounts.
Activity: Finding bank reconciling items are sometimes complicated. Let us have a
drill to understand these reconciling items better. This will help us analyze the
process of computing for deposit in transit and outstanding checks and necessary
adjusting entries.
Identify the items being described. Select the letter of the best answer.
1. On Jan 31, Mr. Ahn deposits P100,000 in his checking account. The deposit
was reflected on Feb 2. The P100,000 is the __________.
a. Deposit in transit, beginning of the month
b. Outstanding check, beginning of the month
c. Deposits made per book
d. Checks issued per book
2. Upon checking the books, all deposits for the month amounted to P10,000,
P12,000 and P23,000, respectively. How much are the deposits made per
book?
a. P46,000
b. P23,000
c. P45,000
d. P12,000
3. Checks issued on Jan 24 was paid by the bank on Feb 12. The checks cleared
on Feb 12 is called __________.
a. Outstanding check, end of the month
b. Outstanding check, beginning of the month
c. Checks that should have been cleared
d. Deposit in transit
4. WWW Bank recorded a P34,000 deposit as P43,000. What do you call this
error?
a. Book error
b. Bank error
c. NSF
d. Bank debit
5. Super Bank returned an NSF check and collected charge for it. What is the
entry for the bank charge for the NSF?
a. Debit: Bank charge | Credit: Cash in bank
b. Debit: Miscellaneous expense | Credit: Cash in bank
10
c. Debit: Accounts Receivable | Credit: Cash in bank
d. Debit: Loans Payable | Credit: Cash in bank
6. Makabayan School Supplies registered its business and applied for a loan in
Makatao Bank amounting to P2,000,000. The bank approves the loan and
deposited it in Makabayan’s checking account.
The transaction is called _______.
a. Bank Credits
b. Bank Debits
c. Bank Charges
d. Checking account
8. A deposit of P67,897 is recorded in the book as P67,789. What do you call this
error?
a. Book error
b. Bank error
c. NSF
d. Bank debit
9. On item #8, what is the journal entry to correct the cash account?
a. Debit: Cash in bank P108 | Credit: Sales P108
b. Debit: Sales P108 | Credit: Cash in bank P108
c. Debit: Cash in bank P67,897 | Credit: Sales P67,897
d. No entry
10. Malikhain Bank collects notes receivable for ABM Merchandise. The note
amounted to P55,000 and the bank charges P300 for the collection. What is
the entry to update the books?
a. Debit: Bank charge P300 | Credit: Cash in bank P300
b. Debit: Cash in bank P55,000 | Credit: Notes receivable P55,000
c. Debit: Cash in bank P55,000 and Miscellaneous expense P300 | Credit:
Notes receivable P55,300
d. Debit: Cash in bank P54,700 and Miscellaneous expense P300 | Credit:
Notes receivable P55,000
11
What is It
ITEMS TO RECONCILE
A. BANK Reconciling Items – these are the items that need to be computed in
order to balance it with the book. These items will be adjusted by the bank in
its records. No book entry is needed.
Example scenario:
Jan 3. The company’s everyday sales are deposited in the bank. December 31 deposits
are reflected on January 3 amounting to P10,000. Adding all the deposits recorded in
the book, it amounts to P100,000, however, in the bank statement only P90,000 is
reflected. Compute for the deposit in transit at the end of January.
Example scenario:
Jan1. The company pays its suppliers by issuing checks. Checks issued from December
purchases amounting to P25,000 was reflected in January bank statement. As per the
records in the book, all checks issued amounting to P230,000. However, of all checks
issued, only P200,000 was cleared by the bank. Compute for the outstanding checks at
the end of January.
12
Outstanding checks, beg. of the month P 25,000
Add: Checks issued per books 230,000
Total checks that should have been cleared P255,000
Less: Checks paid by the bank 200,000
Outstanding checks, end of the month P 55,000
Analysis: P55,000 of worth of checks issued to suppliers have not yet been paid by the
bank.
B. BOOK Reconciling Items – these are the items that need journal entries to
adjust the accounts in the books.
13
Journal entry to update the books:
Wrong Entry:
Cash in bank P 20,000
Sales P 20,000
Wrong Entry:
Cash in bank P 200,000
Sales P 200,000
14
Activity: The previous activity should have prepared you for a more advanced
computation. Identifying items from the previous activity will help you understand
bank reconciliation better. Let us complete the concept by answering the problems
below. Each will represent situations for reconciling items.
3. The bank collected the company’s notes receivable of P230,000 and collected
a charge of P300. It was reflected in the bank statement. What is the entry to
update the books?
4. The company is approved for P500,000 loan. The bank deposited the proceeds
of the loan. What is the entry to update the book?
6. There is a P50 service charge for the request of a new check booklet. What is
the entry for the bank service charge?
15
What’s More
Let us try to figure out more about bank reconciling items and how do they appear
in the process of bank reconciliation.
Matapat Bank
Limay, Bataan Branch
16
4. The loan of the company is approved and been credited to the bank account
amounting P150,000.
Activity 1. Compare the bank and book transactions for July. Answer the following
guide questions with YES or NO.
_______________1. Is there any deposit found in the bank that is not seen in the book
transactions for July?
_______________2. Is there any check number that is found in the bank that is not seen
in the book transactions for July?
_______________3. Is there any check number found in the book that is not yet reflected
in the bank?
_______________4. Is there any deposit found in the book that has not reflected in the
bank?
_______________5. Is there a need for journal entry for the bank error of P11,000?
_______________6. Is there a need for journal entry for the credit memo of P150,000?
_______________7. Is there a need for journal entry for the debit memo of P2,500?
_______________8. Is there a need for journal entry for the NSF check of P21,000?
17
What I Have Learned
1. What are the documents we need in the preparation for bank reconciliation?
___________________________________________________________________________
18
What I Can Do
BANK BOOK
List of checks paid by the Bank List of checks issued in the Book
BANK BOOK
19
Assessment
A. Identify the items being described. Select the letter of the best answer.
1. On June 30, Ms. Montenegro deposits P150,000 in her checking account. The
deposit is reflected on July 2. The P150,000 is the __________.
a. Deposit in transit, beginning of the month
b. Outstanding check, beginning of the month
c. Deposits made per book
d. Checks issued per book
2. Upon checking the books, all deposits for the month amounted to P90,620,
P112,000, and P23,080, respectively. How much is the deposits made per
book?
a. P202,620
b. P135,080
c. P225,700
d. P112,000
3. Checks issued on January 24 was paid by the bank on January 25. The
checks cleared on January 25 is counted as __________.
a. Outstanding check, end of the month
b. Outstanding check, beginning of the month
c. Checks that should have been cleared
d. Checks paid by the bank
5. Palugit Bank returned an NSF check and collected charge for it. What is the
entry for the NSF?
a. Debit: Bank charge | Credit: Cash in bank
b. Debit: Miscellaneous expense | Credit: Cash in bank
c. Debit: Accounts Receivable | Credit: Cash in bank
d. Debit: Loans Payable | Credit: Cash in bank
6. The bank approves the P20,000 loan and the proceeds were deposited in the
account. The transaction is called _______.
a. Bank Credits
20
b. Bank Debits
c. Bank Charges
d. Checking account
7. A check of P67,897 is recorded in the bank as P67,789. What do you call this
error?
a. Book error
b. Bank error
c. NSF
d. Bank debit
8. On item #8, what is the journal entry to correct the cash account?
a. Debit: Cash in bank P108 | Credit: Sales P108
b. Debit: Sales P108 | Credit: Cash in bank P108
c. Debit: Cash in bank P67,897 | Credit: Sales P67,897
d. No entry
1. May 31 deposits are reflected on June 3 amounting to P16,800. Adding all the
deposits recorded in the book, it amounts to P84,000. However, in the bank
statement, only P79,000 is reflected. Compute for the deposit in transit at the
end of June.
3. The company is approved for a P2,000,000 loan. The bank deposited the
proceeds of the loan. What is the entry to update the books?
21
C. Using your answers in Case Problem 2 on Comparison of Bank and Book
of ABM Consultancy Services, match by putting a check mark on both
items.
BANK BOOK
List of checks paid by the Bank List of checks issued in the Book
BANK BOOK
22
Additional Activities
_______________1. How much is the deposit found in the bank that is not seen in the
book transactions for July?
_______________2. How much is the total amount of check that is found in the bank
that is not seen in the book transactions for July? Do not include bank errors.
_______________3. How much is the total amount of check found in the book that is
not yet reflected in the bank?
_______________4. How much is the deposit found in the book that has not reflected in
the bank?
_______________5. What is the journal entry for the bank error of P11,000?
_______________6. What is the journal entry for the credit memo of P150,000?
_______________7. What is the journal entry for the debit memo of P2,500?
_______________8. What is the journal entry for the NSF check of P21,000?
23
24
What Is It (Present in good form) What I Know:
1. DIT, end = 61,800 1. D
2. A
2. OC, end = 154,261 3. A
4. B
3. CIB 229,700 5. A
ME 300
NR 230,000
What’s in
4. CIB 500,000 Bank Recon Items
LP 500,000
1. DIT
5. AR 15,000 2. OC
CIB 15,000 3. Bank Errors
Book Recon Items
6. ME 50
CIB 50 1. BD
2. BC
7. CIB 381 3. Book errors
SALES 381
What’s New
What’s More
1. A
Activity 1. 2. C
3. B
1. YES 4. B
2. YES 5. B
3. YES 6. A
4. YES 7. C
5. NO 8. A
6. YES 9. A
7. YES 10. D
8. YES
Answer Key
25
What Can I Do
Activity 1
BANK BOOK
List of checks paid by the List of checks issued in the
Bank Book
Chk No 00100 12,000 Chk No 00101 6,000
Chk No 00101 6,000 Chk No 00102 3,000
Chk No 00105 20,000 Chk No 00103 9,900
Chk No 00103 9,900 Chk No 00104 15,000
Chk No 21090 11,000 Chk No 00105 20,000
BANK BOOK
List of deposits recorded in
List of deposits in the Bank
the Book
July 1 13,000 July 4 9,000
July 4 9,000 July 18 30,000
July 18 30,000 July 24 23,000
July 28 5,400
What I Have Learned
1. Book records and bank statement
2. DIT, OC, Bank error
3. BD, BC, Book Error
4. From the last month’s deposit reflected in the Bank statement
on the date of the bank recon
5. Checks from the last month’s issuance reflected in the bank
statement at the date of the bank recon
6. The beginning DIT adding total deposits for the month less
deposit reflected in the bank
7. The beginning OC adding all the total checks issued for the
month less checks reflected in the bank statement.
8. Account receivable
Cash in bank
9. Miscellaneous expense
Cash in bank
10. Sales
Cash in Bank
26
Assessment C:
BANK BOOK
List of checks paid by the List of checks issued in the
Bank Book
Chk No 00100 12,000 Chk No 00101 6,000
Chk No 00101 6,000 Chk No 00102 3,000
Chk No 00105 20,000 Chk No 00103 9,900
Chk No 00103 9,900 Chk No 00104 15,000
Chk No 21090 11,000 Chk No 00105 20,000
BANK BOOK
List of deposits recorded in
List of deposits in the Bank
the Book
July 1 13,000 July 4 9,000
July 4 9,000 July 18 30,000
July 18 30,000 July 24 23,000
July 28 5,400
Assessment A:
1. A
2. C
3. D
Additional Activities: 4. A
5. C
Activity 1. 6. A
7. B
1. 13,000
2. 12,000 8. D
3. 18,000
4. 28,400 Assessment B: (Answer in good
5. No entry form)
6. Dr: CIB 150,000 Cr: LP 150,000
7. Dr: ME 2,500 Cr: CIB 2,500 1. DIT, June 30 = 21,800
8. Dr: AR 21,000 Cr: CIB 21,000
2. OC, June 30 = 247,090
3. CIB 2,000,000
LP 2,000,000
4. CIB 1,000
Sales 1,000
5 No Entry
References
Ong, Flocer Lao, and Janelle Gomendoza. 2017. Fundamentals of Accounting,
Business and Management 2 for Senior High School. C & E Publishing,
Inc.
n.d. Oxford Languages. Accessed September 20, 2020.
https://www.google.com/search?q=reconcile&rlz=1C1SQJL_enPH910
PH910&oq=recon&aqs=chrome.1.69i57j0l7.2788j0j15&sourceid=chro
me&ie=UTF-8.
27
For inquiries or feedback, please write or call: