12

ACCOUNTANCY BUSINESS & MANAGEMENT

FUNDAMENTALS OF ACCOUNTANCY,
BUSINESS & MANAGEMENT 2
QUARTER 2 - WEEK 3

CapSLET
Capsulized
Self - Learning
Empowerment
Toolkit
Schools Division Office of Zamboanga City
Region IX, Zamboanga Peninsula
Zamboanga City
 CapSLET
Capsulized Self - Learning Empowerment Toolkit

SUBJECT & FABM 2- GRADE 11 QUARTER 2 WEEK 3

GRADE/LEVEL
TOPIC BASIC BANK RECONCILIATION STATEMENT

LEARNING CODE
COMPETENCY PREPARES A BANK RECONCILIATION
STATEMENT ABM_FABM12-IId-13

LEARNING Prepare a bank reconciliation statement.

OBJECTIVES

IMPORTANT: Do not write anything on this material. Write your answers on the learner’s activity and
assessment sheets provided separately.

UNDERSTAND

There are three methods of preparing bank reconciliation statement, namely:

a. Adjusted Method wherein the balances per bank and per book are separately determined.
b. Book to Bank Method wherein the book balance is adjusted to agree with the bank balance.
c. Bank to Book Method wherein the bank balance is adjusted to agree with book balance.

In this Capsulized Learning tool, the adjusted method will be used and as it is commonly practiced.

The Common Format of Bank Reconciliation Statement

The amount
ABC's Enterprise is taken
The amount
Bank Reconciliation Statement from the
is taken from June 31, 2020 bank
the total cash
statement’s
receipts less Unadjusted Book Balance PHP XXXX Unadjusted Bank Balance PHP XXXX ending
cash
balance
disburse- Bank Debit Memo Deposit in Transit XXXX
ments NSF Check (XXXX)
Amounts Printing Charge (XXXX) Outstanding Checks (XXXX) Amounts
that are that are
incorrectly Bank Credit Memo Errors XXXX/(XXX) incorrectly
entered in Collection XXXX Adjusted Bank Balance PHP XXXX included in
the books of Deposit in transit – difference of total the bank
the business. Errors XXXX/(XXX) deposits reflected in the bank and cash statement. It
It is either Adjusted Book Balance PHP XXXX receipts total. Deposits not yet reflected in is either
increase or the bank statement. Outstanding Checks – increase or
These items are taken from the checks that are not yet presented to the decrease
decrease
bank statement, these are bank for payment or encashment. depending
depending
Difference between the cash
on the errors unreflected and unrecorded in on the errors
disbursements journal and the checks at
committed. the books of the business. committed.
the withdrawal column shown in the bank
statement.

2|Pa ge
 SAQ 1 : Instruction: Determine the outstanding checks and its total as of May
2019. Copy the table on your paper and write the answer.

For the month of May 2016, Tope Company issued the following checks recorded in its
Cash Disbursement Journal:

Check
Check Date No. Payee Amount
05/02/2019 1256 JaneUno PHP 2,000.00
05/10/2019 1257 May Flor 300.00
05/15/2019 1258 Nicole Eli 4,500.00
05/18/2019 1259 Kathy Lee 8,700.00
05/30/2019 1260 Perry Dew 1,200.00
Let’s Practice!
As per bank statement received by Tope Company, the following checks were presented
and paid by the bank.

Check
Check Date No. Payee Amount
05/02/2019 1256 JaneUno PHP 2,000.00
05/18/2019 1259 Kathy Lee 8,700.00
05/30/2019 1260 Perry Dew 1,200.00

Outstanding checks:

Check
Check Date No. Payee Amount

Total

SAQ 2 : Instruction: Determine the outstanding checks and its total as of May
2019. Copy the table on your paper and write the answer.

The cash receipts journal Malay Merchandising reflected the following collections for the
month of May 2019:

Official
Receipt Date OR No. Customer Amount
05/02/2019 4171 Carl See PHP 4,000.00
05/08/2019 4172 Vince Ent 2,000.00
05/09/2019 4173 Ryan Bang 8,900.00
05/25/2019 4174 Fatima Mee 7,800.00
05/26/2019 4175 Cherry Lida 3,200.00

It is the policy of the company to deposit collection within the following day from the date
of collection.

3|Pa ge
 The bank statement for May 2019 revealed following deposits made:

Deposit Date Amount

05/03/2019 PHP 4,000.00
05/09/2019 2,000.00
05/10/2019 8,900.00
05/26/2019 7,800.00

Deposit in transit: _______________________________

Illustrative Example

Instruction: Analyze and determine each item whether it is a book reconciling or a bank
reconciling item. Prepare a bank reconciliation statement and the journal entries.

Item 1 The bank statement for August 2019 shows an ending balance of PHP3,490.

Item 2 On August 31 the bank statement shows charges of PHP35 for the service charge for
maintaining the checking account.

Item 3 On August 28 the bank statement shows a return item of Php100 plus a related bank fee of
PHP10. The return item is a customer's check that was returned because of insufficient funds.

Item 4 The bank statement shows a charge of PHP80 for check printing on August 20.

Item 5 The bank statement shows that PHP8 was added to the checking account on August 31 for
interest earned by the company during the month of August.

Item 6 The bank statement shows that a note receivable of PHP1,000 was collected by the bank on
August 29 and was deposited into the company's account. On the same day, the bank withdrew PHP40
from the company's account as a fee for collecting the note receivable.

Item 7 The company's Cash account at the end of August shows a balance of PHP967.

Item 8 During the month of August the company wrote checks totaling more than PHP50,000. As of
August 31 PHP3,021 of the checks written in August had not yet cleared the bank and PHP200 of
checks written in June had not yet cleared the bank.

Item 9 The PHP1,450 of cash received by the company on August 31 was recorded on the company's
books as of August 31. However, the PHP1,450 of cash receipts was deposited at the bank on the
morning of September 1.

Item 10 On August 29 the company's Cash account shows cash sales of PHP145. The bank statement
shows the amount deposited was actually PHP154. The company reviewed the transactions and found
that PHP54 was the correct amount.

4|Pa ge
Solution:

GALING COMPANY
Bank Reconciliation
August 31, 2019
Items 8 , 9, 1 Items 10, 6, 5, 7
Cash Balance per Bank Statement PHP 3,490.00 Cash Balance per Book PHP 967.00
Add: Deposit in Transit 1,450.00 Add: Interest Earned 8.00
Total Notes Receivable Collected Less Fees 960.00
Errors in Company's Cash Account 9.00
Less: Outstanding Checks 3,221.00 Total PHP 1,944.00
Adjusted Cash Balance per Bank PHP 1,719.00 Items 4, 3, 2
Less: Bank Service Charges PHP 35.00
NSF Checks and Fees 110.00
Check Printing Charges 80.00 225.00
Adjusted Cash Balance per Book PHP 1,719.00

Journal Entries:

2019 Account Titles and Description Debit Credit

Aug. 31 Cash In Bank PHP 1,017.00
Interest Earned PHP 8.00
Notes Receivable 1,000.00
Cash Sales 9.00
To record the interest earned, collection by the
bank and error in the recording

Accounts Receivable 100.00

Miscellaneous Expense 165.00
Cash in Bank 265.00
To record the various bank charges

Let’s Practice

Instruction: Analyze and determine each item whether it is a book reconciling or a bank
reconciling item. Prepare a bank reconciliation statement using the adjusted method and the
journal entries to reconcile the cash balance per book.

The bank statement for Johannes Marketing shows a balance per bank of PHP15,907.45 on April
30,2019. On this date the balance of cash per book is PHP11,589.45.

Additional information is provided below:

Deposits in transit: April 30 deposit (received by the bank on May 1) PHP2,201.40

Outstanding checks: No. 453-PHP3,000.00 No. 457-PHP1,401.30 No. 460-PHP1,502.70
Errors: Juan wrote check no. 443 for PHP1,226.00 and the bank correctly paid that amount.
However, he recorded the check as P1,262.00.
Bank memoranda:
Debit– NSF check from Pedro P425.60.
Debit– Charge for printing company checks P30.00
Credit – Collection of note receivable for P1,000 plus interest earned of P50, less bank collection fee
of P15.00.
5|Pa ge
 REMEMBERER
Key Points

 The bank reconciliation statement is prepared from the viewpoint of the depositor and not from
the bank.

 Common procedures in preparing bank reconciliation statement;

Step 1 – Compare the bank balance per bank statement against the book balance per
Cash in Bank Ledger.

2 - Make a pencil total in the bank statement under Deposit column and compare the
total against the debit entry in the Cash in Bank account to find out the “deposit
in transit”, and other amount added to the deposits or “credit memo”.

3 - Compare the amounts in the withdrawal column of the bank statement against
the Cash Disbursements Journal to determine if there are unpaid checks called
“outstanding checks”, charges or debit memo.

 Prepare the journal entries that will update the balance of the Cash in Bank.

TRY
Let’s see how much have you learned today!

Instruction: Answer the questions 1-8 (8 pts). Prepare a bank reconciliation statement using the
adjusted method and the journal entries to reconcile the cash balance per book. The learner
will be graded base on the following criteria.

Criteria Pts
Accuracy 11
Presentation 7
Completeness 4
Total 22

Refer to the Cash Receipts Journal, Cash Disbursements Journal and Bank
Statement. Answer the following questions:
1. How much is the total of your Cash Receipts Journal? ____________________
2. How much is the total of your Cash Disbursements Journal?
____________________
3. How much is the General Ledger balance of your Cash in Bank account as of June
2020? _______________________
4. How much is the total deposit column of Mindanao Bank Statement?
__________________________
5. Comparing the total of your Cash Receipts Journal and the deposit column of the
bank statement, how much is the amount of difference? _____________________
6. How much is the total deposit in transit? ____________________
7. How much is the outstanding checks? ______________________
8. What other reconciling items will be taken into considerations for the books of the
entity? ___________________

6|Pa ge
Presented hereunder are the details of your Cash Receipts Journal, Cash
Disbursements Journal and the Bank Statement of Mindanao Bank of Mio Grocery.

CASH RECEIPTS JOURNAL Mindanao Bank

Date Payor O.R. Number Amount Bank Statement
June 03 Jessa Lleva 0001 PHP 30,000.00 For the Month of June 2020
20 Arnie Naval 0002 20,000.00
29 Kaye Jamir 0003 5,000.00 Date Withdrawal Deposit Balance
30 Johnny Namin 0004 10,000.00 June 04 PHP 30,000.00 PHP 30,000.00
15 6581 PHP 5,000.00 25,000.00
CASH DISBURSEMENTS JOURNAL 21 20,000.00 45,000.00
Date Payee Check Number Amount 25 6584 8,000.00 37,000.00
June 05 Star Grocery 6581 PHP 5,000.00 28 6585 9,000.00 28,000.00
15 24/7 Store 6582 7,000.00 29 SC 90.00 27,910.00
21 MYX Convenience Store 6583 10,000.00 29 CM 3,000.00 30,910.00
25 Gamez Ellie 6584 8,000.00
28 Rudy De LaTorre 6585 9,000.00 Mio Grocery Count-Credit 2 PHP 53,000.00
Canela, Zamboang City Count-Debit 3 22,090.00
Bal. of Last Statement 30,910.00

SC-Service Charge
CM- Credit Memo due to note collected

Lopez, Rafael M. 2017-First Edition.Fundamentals of Accountancy, Business &

Management 2 .Davao City: MS LOPEZ Printing & Publishing

REFERENCE/S Ballada,Win L. 2014- 19th Edition .Basic Accounting Made Easy, ed. Susan
Ballada Domdane Publishers & Made Easy Books

2016. “Fundamentals Of Accountancy, Business And Management 2.”Teaching

Guide for Senior High. Quezon City:Commision on Higher Education

This learning resource contains copyrighted materials. The use of which has not
been specifically authorized by the copyright owner. We are making this learning
resource in our efforts to provide printed and e-copy learning resources available
DISCLAIMER for the learners in reference to the learning continuity plan of this division in this
time of pandemic.
This LR is produced and distributed locally without profit and will be used for
educational purposes only. No malicious infringement is intended by the writer.
Credits and respect to the original creator/owner of the materials found in this
learning resource.

Developed by:
IVONNEH M. HOMBOY
Teacher II
Manicahan National High School
7|Pa ge
 Answer Key

SAQ1
Check
Check Date No. Payee Amount
05/10/2019 1257 May Flor PHP 300.00
05/15/2019 1258 Nicole Eli 4,500.00
Total PHP 4,800.00

SAQ 2
Official Receipt
Date OR No. Customer Amount
05/26/2019 4175 Cherry Lida PHP 3,200.00

Let’s Practice!!

Johannes Marketing
Bank Reconciliation Statement
April 30, 2019

Unadjusted Book Balance PHP 11,589.45 Unadjusted Bank Balance PHP 15,907.45

Error in Recording Check No. 443 36.00 Deposit in Transit 2,201.40

(P1,226-1,262)
Bank Debit Memo Outstanding Checks
NSF Check ( 425.60 ) No. 453 ( 3,000.00 )
Printing Charge ( 30.00 ) No. 457 ( 1,401.30 )
Bank Credit Memo No. 460 ( 1,502.70 )
Collection (P1,000+50-15) 1,035.00
Adjusted Book Balance PHP 12,204.85 Adjusted Bank Balance PHP 12,204.85

2019 Account Titles and Description Debit Credit

Apr. 30 Cash In Bank PHP 1,086.00
Interest Earned PHP 50.00
Notes Receivable 1,000.00
Overstated amount in the check 36.00
To record the interest earned on notes collected by the
bank and the error in the check.

Accounts Receivable 425.60

Miscellaneous Expense 45.00
Cash in Bank 470.60
To record the various bank charges

Try!!

8|Pa ge
 1. How much is the total of your Cash Receipts Journal? PHP65,000.00
2. How much is the total of your Cash Disbursements Journal? PHP39,000.00
3. How much is the General Ledger balance of your Cash in Bank account as of June 2020? PHP26,000.00
4. How much is the total deposit column of Mindanao Bank Bank Statement? PHP53,000.00
5. Comparing the total of your Cash Receipts Journal and the deposit column of the bank statement, how much is the amount of difference ? PHP12,000.00
6. How much is the total deposit in transit? PHP15,000.00
7. How much is the outstanding checks? PHP17,000.00
8. What other reconciling items will be taken into considerations for the books of the entity? Service Charge and Credit Memo

Mio Grocery
Bank Reconciliation Statement
June 30, 2020

Unadjusted Book Balance PHP 26,000.00 Unadjusted Bank Balance PHP 30,910.00

Service Charge ( 90.00 ) Deposit in Transit 15,000.00

Credit Memo 3,000.00 Outstanding Checks

Check No. 6582 ( 7,000.00 )
Check No. 6583 ( 10,000.00 )

Adjusted Book Balance PHP 28,910.00 Adjusted Bank Balance PHP 28,910.00

2020 Account Titles and Description Debit Credit

June 30 Cash In Bank PHP 3,000.00
Notes Receivable PHP 3,000.00
To record the collection of note receivable.

Miscellaneous Expense 90.00

Cash in Bank 90.00
To record the bank charge.

9|Pa ge
 Republic of the Philippines
Department of Education
Division of Zamboanga City

EVALUATION TOOL FOR CONTENT AND LAYOUT & DESIGN

CAPSULIZED SELF-LEARNING EMPOWERMENT TOOLKIT (CapSLET)

Learning Area: FABM 2 Grade Level: 12

Title: NATURE AND STRUCTURE OF BANK RECONCILIATION STATEMENT
Quarter: TWO
Week: 1
Learning Competency: DESCRIBE THE NATURE OF THE BANK RECONCILIATION
ABM_FABM12-IId-10
ANALYZE THE EFFECTS OF THE IDENTIFIED RECONCILING ITEMS
ABM_FABM12-IId-12
Instructions:

1. Read carefully the learning resource (LR) page by page to evaluate the LR for compliance to standards
indicated in the criterion items under each factor below.
2. Put a check mark (/) in the appropriate column beside each criterion item. If your answer is NO, cite
specific page/s, briefly indicate the errors found, and give your recommendations in the attached Summary
of Findings form.
3. Write Not Applicable (NA) for criterion items that does not apply in the LR evaluated.

Standards /Criterion Items Yes No

CONTENT
Factor I. Intellectual Property Rights Compliance
1. The learning resource has no copyright violations. ∕
2. The copyrighted texts and visuals used in the LR are ∕
cited.
3. The copyrighted materials used in the LR are accurately ∕
cited.
4. The references are properly cited in the Reference/s box ∕
using the DepEd LR Referencing Guide.
Note: At least 3 criterion items must be marked YES to Complied Not
indicate compliance to this factor. Complied

Factor II. Learning Competencies

1. Content is consistent with the targeted DepEd Most ∕
Essential Learning Competencies (MELCs) intended for
the learning area and grade level.
2. The MELC is subtasked into learning objectives based ∕
on the Compressed Curriculum Guide Syllabus (CCGS)
of a specific learning area.

Note: These 2 criterion items must be marked YES to Complied Not

indicate compliance to this factor. Complied

Factor III. Instructional Design and Organization

1. The LR contributes to the achievement of specific ∕
objectives of the learning area and grade level for which
it is intended.
2. Sequencing of contents and activities from ∕
UNDERSTAND, REMEMBER and TRY within each
lesson facilitates achievement of objectives.
10 | P a g e
 3. Content is suitable to the target learner’s level of ∕
development, needs, and experience.
4. Content reinforces, enriches, and / or leads to the ∕
mastery of the targeted learning competencies intended
for the learning area and grade level.
5. The LR develops higher cognitive skills (e.g., critical ∕
thinking skills, creativity, learning by doing, problem
solving) and 21st century skills.
6. The LR enhances the development of desirable values ∕
and traits such as: (Mark the appropriate box with an
“X” applicable for values and traits only)

Note: At least 5 criterion items must be marked YES to Complied Not

indicate compliance to this factor. Complied

Factor IV. Instructional Quality

1. Content and information are accurate. ∕
2. Content and information are up-to-date. ∕
3. The LR is free from any social content violations. ∕
4. The LR is free from factual errors. ∕
5. The LR is free from computational errors (if applicable) ∕
6. The LR is free from grammatical errors. ∕
7. The LR is free from typographical errors. ∕
Note: At least 6 criterion items must be marked YES to Complied Not
indicate compliance to this factor. Complied

Factor V. Assessment
1. The LR provides useful measures and information that ∕
help the teacher evaluate learner’s progress in mastering
the target competencies.
2. Assessment aligns with the learning competency/ies. ∕

3. Assessment provides clear instructions in the TRY ∕

section.
4. Assessment provides correct answer/s. ∕
Note: All criterion items must be marked YES to indicate Complied Not
compliance to this factor. Complied

Factor VI. Readability

1. Vocabulary level is adapted to target users’ experience ∕
and understanding.
2. Length of sentences is suited to the comprehension level ∕
of the target user.
3. Sentences and paragraph structures are varied and ∕
appropriate to the target user.
4. Lessons, instructions, exercises, questions, and activities ∕
are clear to the target user.
5. The LR provides appropriate mother tongue for the ∕
target user.
Note: At least 4 criterion items must be marked YES to Complied Not
indicate compliance to this factor Complied
11 | P a g e
 LAYOUT AND DESIGN
Factor I. Physical Attributes
1. All necessary elements are complete. ∕
2. Cover elements are correct and complete. (i.e., w/ grade ∕
indicator & learning area, CapsLET title, quarter,
headings, division tagline)
3. The CapsLET follows the prescribed learning area color. ∕
4. The LR observes correct pagination. ∕
5. Contains accurate learning competency and code. ∕
Note: All criterion items must be marked YES to indicate Complied Not
compliance to this factor Complied

Factor II. Layout and Design ∕

1. The LR follows the prescribed CapsLET template. ∕
(maximum of 10 pages and minimum of 3 pages)
2. The LR follows the prescribed CapsLET paper size ∕
(long bond paper - 21.59cm x 33.02cm).
Note: All items be marked YES to indicate compliance to this Complied Not
factor. Complied

Factor III. Typographical Organization

1. The LR uses appropriate font size (12 or 14) and styles ∕
(Calibri Body, Arial or Times New Roman).
2. The LR follows the rules in the use of boldface and ∕
italics.
Note: All criterion items must be YES to indicate compliance Complied Not
to this factor. Complied

Factor IV. Visuals

1. It contains visuals that illustrate and clarify the concept. ∕
2. It has images that are easily recognizable. ∕
3. Layout is appropriate to the child. ∕
4. Text and visuals are properly placed. ∕
Note: All criterion items must be marked YES to indicate Complied Not
compliance to this factor. Complied

Recommendation: (Please put a check mark (/) in the appropriate box.)

Minor revision. This material is found compliant to the minimum requirements in all six factors. Revision based
on the recommendations included in the Summary of Content Findings form and LR with marginal notes must be
implemented.

Major revision. This material is non-compliant to the requirements in one or more factors. Revision based on the
recommendations included in the Summary of Content Findings form and LR with marginal notes must be
implemented.

For field validation. This material is found compliant to all factors with NO corrections.

I certify that this evaluation report and the recommendation(s) in the summary report are my own and have been
made without any undue influence from others.

12 | P a g e
 Name/s Signature/s

Evaluator/s: Ritchie C Basilio ________________________

Elma A. Ferrer ________________________

Divina Larrocochea ________________________

Date accomplished: ___________________________

Note:
This tool is anchored on the Guidelines in ADM Content Evaluation, Guidelines in ADM
Layout Evaluation and Level 2 DepEd Evaluation Rating Sheet for 2 DepEd Evaluation Rating
Sheet for Story Books and Big Books.
.

13 | P a g e
 Summary of Content Findings, Corrections and Review for Locally Developed
CapSLET

Title of the CapSLET: BASIC BANK RECONCILIATION STATEMENT

Grade Level: Grade 11
Quarter: 2
Week: 3
Part of the Brief Specific Put a check mark
CapSLET/ descriptio recommendati
Paragraph n of ons for
/ Line / Errors/ improving the
Page Findings/ identified Not
number (in Observatio criterion Implement
Implement
chronologi ns ed
ed
cal order)

Learning Since it has If there is only one /

Objective pg 2 only one objective no need to
objective I write the are as
removed the follows. Keep it
No. 1 and the direct
word “to be
able”
Redundant word Two the same I just remove the /
“Bank” pg 6. word is being one word “Bank”
repeated
References of Not align I just move it to /
the third line align the above
format pg. 7 statement

Legend: (Type of Error) C - Content, L – Language, DL – Design and Layout

Other Findings: Write additional comments and recommendations not captured

in the evaluation tools used.
So far the presentation of the Capslet where done properly. Exercise undertaken are just
simple and I believe the students will be able to learn the basic Bank Reconciliation
Statement. _______________________________________________________________
Prepared by: Date accomplished:

RITCHIE C. BASILIO OCTOBER 11, 2020

(Signature Over Printed Name)
14 | P a g e