Thursday, June 28, 2012

BANK RECONCILIATION


TITLE: BANK RECONCILIATION

Have you ever handed a check or seen one at least? Have you experienced using one before? What are your experiences regarding the use of checks? Most people who has bank accounts use checks for some other reasons such as using checks for safety, especially nowadays that robbery or stealing is extremely existing. Also to avoid hassle, for example in paying with a big amount of money in cash, it takes time to count and recount the money unlike with checks that requires only a minimum of time. In this blog, you’ll know more about the use of checks, its importance and so on and so forth also the Bank Reconciliation.

What is a Bank Reconciliation? Bank Reconciliation is the process of bringing the bank's monthly report for each depositor showing deposits made, check written, cancelled checks, and service charges. Checkbook contains checks and check stubs. The checks are filled out by the depositors made, and of charges made by the bank. 
Reconciliation Statement is putting an agreement the bank statement balance and the checkbook balance.
There are also differences in balance due to the following:1.      Outstanding checks - are checks issued by the depositor but have not yet been presented to the bank for payment.
2.      Deposits in Transit - These are deposits made but late to be included in the monthly bank statement. This can also be called as an error.
3.      Service Charges
4.      Errors in a check stub entries
5.      Cancelled checks - are checks that have been paid by the bank.

What is a Check? A check is a printed form on which you write an amount of money and who it is to be paid to. Your bank then pays the money to that person from your account.When and how do we use checks? We use checks when we are to pay a big amount of money. For example, in an enrolment you are to pay the amount of Seventy – five thousand pesos. Of course you do not want to be in danger holding that kind of big amount of money in cash. What you do, is you carry your check with you, sign it with proper information and present it to the cashier. With that case, you do not have to worry about losing money bills. When you have bank account, you can have your own check provided you are 18 years old and above.

What are the most frequent check writing mistakes?

5) Written amount doesn't match the numeric amount.For instance, a person may complete a check with the written amount as one hundred dollars, but the numeric amount is only $10.00. Almost daily we return checks for this reason. In cases like this, the bank is has the option of accepting the check for only the written amount, contacting the customer to authorize a change, or returning the check.

4) Not dated or incorrect date.Some customers simply neglect to date their checks. Others supply the wrong date (post or stale dated) both intentionally and unintentionally. When post dating your check, make an effort to inform the payee of it. Checks with no date, future dates or those dated a certain number of days in the past will be returned.

3) Not signed.Surprisingly enough, many people will complete every other portion of their check and then forget to sign it. These are returned instantly.

2) Signature doesn't match the one on file.As we age, our signature changes. Other events can also alter the way a person signs documents. If the signature on a check differs noticeably from the initial sample provided it will be returned. The best way to remedy this is to furnish a more recent sample of the signature.

1) Modified or altered checks.Checks that appear to have been altered with scratch outs, write overs, different colored inks or multiple handwriting styles are considered altered. Even if the cause is a simple mistake, these changes look suspicious and may cause the check to be returned. If a mistake absolutely must be corrected, use one line to cross out the error and initial the changes. This may not guarantee that the check remains valid, but it will lower the level of suspicion. Never use whiteout on or photocopy any checking documents.To reiterate, closely examine checks and other banking documents before submitting them. Items are much more likely to be processed quickly if they have been completed correctly.

What is a checkbook A book containing blank checks issued by a bank.
1. A folder or small book containing preprinted paper instruments issued to checking account holders and used to pay for goods or services. A checkbook contains sequentially numbered checks that account holders can use as a bill of exchange. The checks are usually preprinted with the account holder's name, address and other identifying information. In addition, each check will also include the bank's routing number, the account number and the check number.


2. A checkbook is comprised of a series of checks that can be used to make purchases, pay bills, etc. With the advent of online commerce and banking, more people are making purchases and paying bills online, thereby reducing or eliminating the need for paper checkbooks. Checkbooks include a set quantity of numbered checks, and, in addition, usually contain some type of register in which users can keep track of check details and balance account statements


If ever you committed a mistake on a check, probably the spelling, the date or whatsoever, For a small mistake,  Cross-out the incorrect information and write your initials above what you crossed out. Then, write the correct information. Note: some stores do not accept checks with cross-out. 
If you happen to make a large mistake,  Write “VOID” across the check, or tear up the check. A check with “VOID” across it is no longer usable. A voided check will look like this: 

  voided check sample 



Example of a Reconciliation Statement:

1.      On May 16, 2012, Mr. Marcus Gonzales received his bank statement. He has a balance of P 5, 162.00. His check book balance was P 4, 572.00. He found out that cheques 22 and 23 are not yet cashed with amounts of P 1, 600.00 and P 500.00. His deposit of P 1, 000.00 at the end of the month was late to be included in the bank statement. While checking his chequebook, he noticed that an amount of P 10.00 was deducted from his account for the service charge. P 5.75 was the amount of the error made. The cancelled check of P 1, 000.00 was not deducted either from the check book balance.

Solution:
Mr. Marcus Gonzales
Reconciliation Statement
May 16, 2012

Check book balance:                  P 4, 572.00                 Bank Statement Balance: P 5, 162.00
    Add: Error                                          P 5.75                   Add: Deposit in Transit:  P 1, 000.00
                                                    P 4, 577.75                                                        P 6, 162.00
Less:                                                                                     Less: Outstanding Checks:
     Service Charge: P 10.00                                                                 #22         P 1, 600.00
     Cancelled Check: P 1,000.00                                                         #23          P 500.00
Adjusted Check book Balance:    P 3, 567.75                         Adjusted Balance:      P 4, 062.00


_______________
Checked by: Prof. Crisencio Paner 
 

Thursday, June 21, 2012

BUSINESS MATH: PROFIT AND LOSS


TITLE: BUSINESS MATH: PROFIT AND LOSS


TITLE: BUSINESS MATH: PROFIT AND LOSS
I’m Carla Gatdula, 19 years old from Sta. Rosa Laguna. Currently studying Industrial Design at the University of Santo Tomas for the third year in college, belongs to the section 3IND-2. This is actually the first time that I’d be doing a blog. I often surf the net for fun, but thus blog thing is a first for me. :)
On the first day of our class, we had a discussion about Loss and Profit. Where Profit is defined as the amount by which the sales are greater that the cost of goods sold and the operating expenses. Profit can also mean as gain or Margin. In getting the profit, there are formulas to be followed:
  • Gross Sales – Refunds and Allowances = NET SALES
  • Gross Profit – Operating Expenses = NET PROFIT
For example:
  1. National Bookstore has net sales of P 20, 458.00 and the cost of goods sold P 4, 358.00 therefore, how much is the net profit of National Bookstore? The operating expenses account is P 12, 000.00.
Solution:
         P 20, 458.00    net sales
      -    P 4, 358.00    cost of goods
         P 16, 100.00    gross profit
      -  P 12, 000.00    operating expenses
           P 4, 100.00   net profit
What do we mean when we say Gross Sales, Gross Profit, Refunds, Net Sales, Net Profit and Operating Expenses? Gross Sales is the actual amount received for selling the good, Gross Profit is the difference between the net sales and the cost of goods sold, Refunds is defined as the amounts returned, Net Sales are obtained when refunds are being deducted from the gross sales, Net Profit is the amount obtained when all the selling expenses or other cost of doing business are deducted from the gross profit and the Operating Expenses or overhead are selling expenses such as salaries or wages, traveling expenses, rentals, water, electric bills, commissions, taxes.
It is not only getting the net sales and net profits are the ones discussed in the class but also getting the gross profit. How are we going to get the gross profit? Here is an example.
  1. The Blackberry Company has sales of P 1, 000, 000.00 for the first eight months of the business. The expenses are the following: Wages and salaries P 353, 163.00, rent to cost of goods amounting to P 333,300.00, light and water bills P 430, 785.00. If there is a refund of P 78, 453.00 for defective phones, compute for net sales, gross profit, and net profit.
Solution:
Gross Sales                                                             P 1, 000, 000.00
Less: Refunds                                                                P 78, 453.00
  1. Net Sales                                                               P 921, 547.00
Less: Cost of Goods                                                      P 333, 300.00
  1. Gross Profit                                                            P 588, 247.00
Less:  Operating Expenses
Salaries and Wages                               P 353, 163.00
Light and Water                                     P 430, 785.00
Rent                                                     P 333, 300.00
Total Operating Expenses                                          P 1, 117, 248.00
Net Profit                                                                      P 529, 001.00
We have also tackled about the inventory. Inventory is an itemized list of goods on hand. How do we do an inventory? In a company every end of the month inventory is made. For example in a market, the owner or the employee makes a list of the each product, its quantities, its price, how many was the product at the first and how many product was sold at the end of the month, etc. I remember when I walked in at the Ministop, there was this employee who keeps on roaming around the market, counting the products, calculating the expenses and so on. It was an inventory being done.
I have mentioned the refund above. What is a refund? Refund is the amount or money returned whenever you have sold a defective product. When you buy at mall or anywhere, you should always check for the product if it is completely working, the appearance is not damaged meaning no scratches. If so the products you have sold are defective, the consumer has the right to get a refund of what they have paid you for the product. With that case, your money or what you paid for what you consumed will be returned to you. Refund only happens when the product itself is defective. You cannot get a refund if you were the one who got to apply or give damage to the product.
When you are to give price to a certain product, you do not just give what pops on your mind. In pricing your product, you have to compute for your operating expenses.But first, what is operating expenses? It is the way of selling expenses such as salaries or wages, traveling expenses, rentals, water, electric bills, commissions, taxes. You price your product by all the expenses you have had for the product. Example you are planning to create a perfume business. You have a quantity of 300 bottles of perfume at P 1, 000.00 each when you bought it at the main store. You had a total of P 300.00 for your transportation back and forth, and renting a carrier cost you P 200.00. Compute for your buying price this way: 300 bottles of perfume for P 300,000.00 plus P 500.00 for transportation and carrier, you get P 300, 500.00. Your buying price now would be P 3, 005.00.
Studying Business Math would help you find a job, or even make a job of your own. Whatever college course you have taken, if it fails you then business math comes in your way. You do not have to be always present while working. Nowadays since technology and internet are widely used, you can just create your own site and start selling your products online. Are you familiar with sulit.com.ph? It is a buying and selling site where you can just post your blog and pictures of your product. You might be worrying about the payment. It could be done online using credit card or other transactions that can be done online or you can also pay personally so you may also see the product before you purchase it.


Curriculum Vitae of Prof. Crisencio M. Paner


iCRISENCIO M. PANER    



                                                                                                                
CP : 0915-1429675                                                             Email : panercris@gmail.com                                                                                            

Glimpse of Crisencio Paner: http://www.youtube.com/watch?v=JmOWKyzryGk

EDUCATION

       Ph.D. in Biological Science (candidate)
University of Santo Tomas, Graduate School
  • M.S. Microbiology
University of Santo Tomas
      Thesis: “Chemical Control of Fungi Infesting Easel Oil Paintings at
                   University of Santo Tomas Museum of Arts and Sciences”
     
      Published in: Prime Journal of Microbiology Research
                            http://primejournal.org/PJMR/abstract/2012/may/Paner.htm
                                 http://primejournal.org/PJMR/cont/2012/may.htm
  
  • Italian Scholarship Grant
Restoration and Conservation of Artworks Attacked by Biological Agents
Istituto Centrale Per Il Restauro, Rome, Italy (January 1-June 30, 2004)

  • B.S. Biochemistry
University of Santo Tomas

  • Professional Teaching Certification Program (Major in Biological Science)
Caloocan City Polytechnic College

PUBLICATIONS

 Book:
  Co-author in LET Reviewer in Biology, 2006-2010 eds. Published by MET Inc.
                          ISBN # 97193249-6-1, sold in National Bookstores                                                                                                
Articles:
  • Understanding Museum Pests: The Molds. CFAD Atelier Journal, University of  Santo Tomas, Vol. 2 No. 1, 2003-2004, pp. 80-83
  • On the Conservation of 20th Century Color Photographs Attacked by Molds. CFAD Atelier Journal, UST., Vol. 2 No. 1, 2003-2004, pp. 106-113
  • Witnessing the Glory of Italy in Its Art History and Ancient Spaces. CFAD Atelier Journal, UST, Vol. 3 No. 1, 2004-2005, pp. 55-72 
  • _______________. Panorama Magazine, November 13, 2005, pp. 12, 13, & 21.
  • Deterioration of Paintings and Painting Components Caused by Microorganisms. CFAD Atelier Journal, UST., Vol. 3 No. 1, 2004-2005, pp. 91-94
  • Microbial Deterioration of Painting Materials. CFAD Atelier Journal, UST., Vol. 3 No. 1, 2004-2005, pp. 94-97.
  • Conservation of Paintings Attacked by Molds. In College Freshman English Book II. Agalabia, U., Aranda, R., et. al., pp. 124-125, UST Publishing House, 2004
  • Today’s Restoration Establishments.  CFAD Atelier Journal, UST., Vol. 4 & 5 No. 1, 2005-2006 & 2006-2007, pp. 95-99

RESEARCH WORK

·       Indoor Air Quality of Beato Angelico Building of the University of Santo Tomas -Commissioned by UST (Nov. 2009-May 2010)


BLOGS/ADS

1.     http://internet-moneymakingsecrets.blogspot.com (Money-Making Secrets)
2.     http://internet-moneymakingsecrets.weebly.com   (Internet Marketing Secrets)
3.     http://cmpaner.blogspot.com  (The Painting Doctor-“Restorer/Conservator”)
4.     http://sulit.com.ph/3498047  (Research assistance/Thesis Assistance/Thesis Editing)
5.     http://sulit.com.ph/4829772 (LET Review by a LET Topnotcher and Veteran Reviewer)
6.     http://sulit.com.ph/5040331 (Lotto Secrets Revealed!)
7.     http://sulit.com.ph/5058879 (Muscle Building Cookbook)
8.     http://sulit.com.ph/5069982 (Wedding Photography Secrets)
9.     http://sulit.com.ph/4973311 (Food Cart Franchise Business)
10.  http://sulit.com.ph/4833582 (St. Peter Life Plan and Memorial Chapels)
11.  http://sulit.com.ph/4186306 ( Art and Craft Materials for Sale At Low Price!)
12.  http://sulit.com.ph/4621349 (Cleaning and Restoration of Paintings)
13.  http://sulit.com.ph/4869897  (Natracare Food Supplements)
14.  http://sulit.com.ph/4802983 (LET Reviewer Books)
15.  http://sulit.com.ph/5021693 (How to Lose Weight Fast!)
16.  http://sulit.com.ph/5093345 ( How to Stop Hair Loss and Regrow It the Natural Way)
17.  http://sulit.com.ph/5126659  (How to Get Pregnant Fast!)
18.  http://sulit.com.ph/4930508  (Condo for Rent at 39K Infinity Tower, Global City, Taguig)
19.  http://sulit.com.ph/5538321  (Licensure Exams for Teachers LET online review)
20.  http://sulit.com.ph/5423603  (Internet Marketing Illuminati- How to Make Money Online Fast!)
21.  http://sulit.com.ph/5352564  (Internet Millionaire Looking for Students!)
22.  http://sulit.com.ph/5628715  (The Ultimate Diablo 3 Guide)



WORK  EXPERIENCE

  • Instructor 5, CFAD, IPEA, Pharmacy, CTHM, University of Santo Tomas
SY 1995-Present
Subjects taught: Organic Chemistry lab., Statistics, College Algebra,
                           Algebra with Trigonometry, Business Math, Physics,
                          Plane & Solid Geometry, Environmental Science, Biology
                                                                                                                                                
  • Part Time Instructor, Our Lady of Perpetual Help College, Manila
Subjects taught: Food Microbiology (Lecture and Laboratory)                                                                                        
  • Part Time Instructor, St. Paul’s College, Quezon City
Subjects taught: Lec. & Lab: General Microbiology, Biochemistry, Microtechnique

  • Part Time Instructor, Unciano Colleges and General Hospital, Inc., Manila
Subjects taught: Lec. & Lab: General Microbiology and Parasitology, Inorganic Chemistry,
                          Comparative Anatomy, Botany, Organic Chemistry, General Zoology,
                          Biology, Biochemistry

OTHER PROFESSIONAL EXPERIENCE

·        Editor and Professional Consultant, MET Publishing House, Manila
·        Microbiologist, Silver Swan Manufacturing Inc.,Panghulo, Malabon
·        Biochemist, Watercare Philippines, Inc., Valenzuela City
·        Food Production Researcher(Mushroom Culture), TWH, Inc., Cainta Rizal
·        Review Director for LET, Center for Educational Excellence, Inc.
·        Project Consultant on “Biodeterioration of Artworks”, Paper Conservation Laboratory, Archives Dept., Arzobispado de Manila
Projects: Conservation of paintings by Fernando Amorsolo, Botong Francisco,
               Ben Cab, Cezar Legaspi, Simon Flores, Betsy Westerndorp
·       Licensure Exams For Teachers (LET) Reviewer at:
- Malabon City University,MET Review Center, UST-College of Education, Caloocan   Polytechnic College, Trinity College, & Center for Educational Excellence Inc.

AWARDS AND HONORS

  • Beato  Angelico Service Award
  • 10th Placer (85.60%), Licensure Examinations for Teachers (LET)
  • Full College Scholarship by Lourdes Reyes Foundation
  • Professional Civil Service Examinations, weighted ave: 86.49%
  • Valedictorian, High School
  • Salutatorian, Elementary
  • Certificate of Appreciation as resource speaker on the topic “Visual Arts and Restorations”, Faculty-Student Art Forum, Beato Angelico Bldg.,UST.
  • Recognition Award for invaluable support and committed service to HARIBON UST as adviser from 2002-2004
  • Honored as 4th Degree(highest degree) member of the Knights of Columbus
 Given by Philippine District IV-NCR
·          Loyalty and Faithful Award for 13 years of Service
 Knights of Columbus UST- Faculty Council 4321
·          Dedicated and Competent Service Award as LET Reviewer
 Malabon City University                                                                                            
·          Champion, Pautakan Quiz Bee for Coaches, UST                                                
·          Family of the Year Award
            Knights of Columbus UST Faculty Council 4321
·       UST Graduate School Thesis Writing Grant
  UST Graduate School Alumni Association
·       Certificate of Recognition for invaluable Contribution as Lecturer/Reviewer
 Pilot Project on Review Classes for Licensure Examinations for Teachers
 College of Education, UST                                           
·     Certificate of Appreciation as guest speaker on the topic “Products that Cause Cancer”, given by NEWAYS International (Phils.), Makati City

       

TRAINING /SEMINAR WORKSHOPS

  • Seminar on Test and Measurement Evaluation
  • Seminar on Principles/Philosophy of Education
·       Faculty Development Seminar
  • Traditional Filipino Art
  • Curriculum Development                                                
  • Rubrics Development Across Disciplines                                           
  • Certificate on Adobe Photoshop
  • Certificate on PC Troubleshooting and Networking
  • The Ethics of Teaching
  • Rights and Responsibilities of the Faculty Members, Academic and Administrative Officials and Office Staff Seminar                                                   
  • UST-CFAD Planning and Development Seminar
  • Shepherding the Shepherds
  • Workshop on Syllabus Construction                                                              
  • Textbook and Learning Materials Development
  • Computer Literacy on Adobe Illustrator, Photoshop, & MS Excel
  • Symposium on Waste Management
  • Ecological Symposium
  • Bringing Out the Best in Me and the Best in You
  • Integrating Media in Classroom Instruction( Design, Production, and Utilization of Media)
  • Principles and Methods of Humane Educators
  • Certificate on Basic Industrial Electronics
  • Certificate on Information Technology
  • Symposium on the Preservation of our Environment
·        Research Colloquia on Indoor Air and Water Quality in Relation to Building Design
·        Convention of Philippine Association of Academic Biochemists,            
  • 16th Annual Convention of Philippine Biochemical Society
  • Script Writing Workshop
  • Basic Business and Financial Management                                                              




AFFILIATIONS

  • Member, CFAD- Adhoc Committee on Math Department
  • Member, CFAD-Committee on Environmental Advocacy
  • Member, CFAD-Adhoc Committee on Value Formation
  • Board of Director
Philippine Association  for the Scientific Conservation of Cultural Properties   
  • Deputy Grand Knight, Knights of Columbus UST Faculty Council No. 4321
  • Auditor
College of Fine Arts & Design Faculty Association
  • Adviser, HARIBON UST
  • Business Manager, NOH-SCC Alumni Association
  • Member, Outreach Program Committee
College of Architecture and Fine Arts

LANGUAGES SPOKEN

English, Filipino, Italian, Japanese


OTHER SPECIAL SKILLS/TALENTS

  • Thesis Editing/Research Assistance
  • Computer operation using MS Word, Excel, Powerpoint, Adobe Photoshop, Internet
  • Computer Hardware repair and Software installations
  • Website/Blog Construction
  • Photography
  • Swimming
  • Playing Banduria
  • Singing
  • Riding ATV