Internal Control Matrix
Internal Control Matrix
As can be appreciated from the above, and despite not having detailed mention made
Of all the regulations, the risks that companies are exposed to are many and
they must imperatively be brought under control.
The constant advancement of state and para-state bureaucracy in various countries over
private entities have led them to the search for tools or instruments that
allow, as expressed at the beginning, "to eliminate and/or significantly reduce the risks
to which they are exposed.
A company is exposed on one side to good faith internal errors, but also to
actions that accidentally or otherwise expose it to losses. If we take as
For example, a banking entity is exposed to the actions of bad faith from its
personal, as well as that of its clients and suppliers, the possibility of committing
non-compliance with legal regulations, the actions of scammers or thieves, the lack of
forecasts in internal security matters (such as fires, or losses of
files in the computer system). Any of these events originate for the entity
economic losses. Losses that in many cases can put the continuity at risk
same as the company. Let's think about what the theft of formulas or plans implies.
concerning manufacturing processes or products, or the illegal sale of databases of
customers to the competition.
No less important are the losses caused by defects in the production processes.
the quality of products and services, and with it the costs (reprocessing, warranties,
waste) as well as the degradation of the company's reputation.
Very few companies have systematically established policies, plans, and methodologies.
to avoid the aforementioned risks. They generally act based on experience, intuition or
They plan in a biased manner.
Nowadays, no serious company, whether aspiring to excellence or not, can continue operating.
in such a way. One of the serious shortcomings of external audits lies precisely in not
to control and properly evaluate the internal controls in their entirety, nor
evaluate from a systemic point of view the audited companies. Let us think about this in regard to
the effects that the loss of information has on the economic value of a company
ultraconfidential how could the development of a pharmaceutical product still be
patented. For such reasons, this control tool is also of great utility for the
external audits.
One might wonder how many times organizations are subject to monetary sanctions.
for breach of formal duties solely for not having carried out the
inquiries or the lack of planned controls and respective actions.
As the matrix system makes use of effectiveness scores, the aspects or areas of greatest
risks, which arise from the lowest scores, are those in which one must
prioritize adjustments and corrections, also through the analysis of the reasons for the low
scores allow us to know the reasons that originate them and in this way adopt the best ones
actions aimed at its resolution.
In that Matrix, we have that in the columns the External Regulations are recorded.
Internal, as well as the Principles and Policies whose application must be verified.
On the side of the rows, we have the Products, Services, Areas / Sectors - Activities /
Processes that take place in the company.
Thus, once the titles of the columns and rows are placed, it is time to interrelate.
the same (Example: Sales / National Taxes "Point 1.1") based on the
regulations and principles that the areas, activities, and
products. In the event that there is no interrelation between the item in the row and that in the column,
that space is canceled (shaded) (Example: Research and Development has no standard of
Central Bank application.
The points assigned to each slot correspond to the applicable control questionnaires and
to the Audit Manual, it will also serve to allocate resources in the budget of
control, as well as to establish the number of controls over periods and delegate
responsibility of the respective control.
NORM
AS Y
PRINCE
PIOS A
VERIFI
CAR
1 2 3 4 5 6 7 8 9 10 11 12 13 14
LABORATORY IS PRIN PRIN
AREA RALE Oh CIPI CIPIO
S- S 90 OS S Y
PROD (National LAW 00 OF NOR
UCTO - ES IS MORE BAN NOR POLITIC
S- IMP. Pciale DE THE TROUBLE OF THE HOUSE A REGI
ACTI IMP.NA PROVI IMP.L s. - SEG CON 14 THE SEG CEN INTE ORGANIC SOCI STRO
LIFE CIONAL NCIAL OCAL Local URO TABL 00 INTE URID TRA RNA ZACION ETARI PROP
DES EN ES ES es) S ES 0 RNO AD L S AL AS IEDAD
VENT
1AS 1,1 1,2 1.3 1,4 1,5 1,6 1,7 1,8 1.9 ["1.11","1.12"]
COMP
2RAS 2.1 2.2 2.3 2,4 2,5 2,6 2,7 2,8 2.9 ["2.11","2.12"]
HR
3. 3.1 3.2 3.3 3,4 3,5 3,6 3,7 3,8 3.9 3.11 3.12
COMP
4UTOS 4.1 4.2 4.3 4.4 4.5 4.6 4.7 4.8 4.9 4.11 4.12 4.13 4.14
CONT
5ABLE 5.1 5.2 5.3 5,4 5,5 5,6 5,7 5,8 5,9 5,10 5,11 5,12 ["5.13","5.14"]
PROD
UCCIO
6N 6.1 6.2 6.3 6,4 6,5 6,6 6,7 6,8 6.9 6.11 6.12 6,14
1SERVI 12 12.1
2CIOS 12.1 12.2 12.3 12.4 12.5 12.6 7 12.8 12.9 1 12,12
Starting from this matrix, we proceed to break down these points. In the case of Sales,
these are subject to national tax provisions, linked on one side to
to the regulations on invoicing and, on the other hand, those relating to perceptions, tax on
added value and the related documentation for the clients. Then in
The questionnaires will be formulated based on this function to verify the various points of the
Matrices are being duly completed.
The scores instead of one, two, and three, could be one, three, and five, to make it more
sensible the final score to the most important aspects.
The same reasoning applies to obtain the score corresponding to each point of the
matrix, so if counting a certain point in the matrix with four questionnaires whose
the maximum score for answering all questions positively would be 40 points and it
he obtained a total of 35 points, the effectiveness percentage is 87.05%, and the score is 8.71
points.
Finally, and given that not all areas - activities or products are subject to the same
amounts of control points, all control points are multiplied by 10
by obtaining the maximum possible score, the points obtained are added according to the paragraph
previous and is divided by said maximum obtaining the effectiveness score by area.
Let's see: the area or activity 'Sales' out of a total of 14 boxes has 11 control points.
If we multiply 11 by ten, we have a maximum score of 110 points. Let's suppose that from
The conducted controls result in a maximum score of 80 points, the percentage of effectiveness.
It is 72.72%, that is, a score of 7.27.
The same criterion applies to the columns, so we have that "Property Registry" has
six scoring boxes out of a total of 12, so the maximum score is 60 points. If
The score obtained is 60 points, we will have 100% effectiveness and a score of 10.
Thus a low score in product and service ratings in relation to ISO standards.
9000 and ISO 14000 would indicate problems in terms of quality controls, to the
which should receive immediate attention.
It is worth noting that the total number of columns included in the Matrix is for example purposes.
depending on the quantity and content of them to the regulations specific to each place or
country, as well as the activities that the company under control develops. For example
the regulations concerning the provision of information to the
official entities of Industrial Statistics.
NORM
AS Y
PRINCI
A PIOS
VERIFY
CAR
1 2 3 4 5 6 7 8 9 10 11 12 13 14
LAB IS PRIN PRIN
AREA ORA The CIPI CIPI
S- THE 90 OS OS Y
PRO (Nation. LAW 00 OF NOR REGI
DUCT - ES IS WITH MORE BAN NOR POLITI STR
OS - IMP. Special DE THE TROUBLE OF CO MAS CA O
ACTI IMP.NA PROVI IMP.L es. - SEG WITH 14 The segment centers integrate social organizations
LIFE FINANCIAL LOCAL Local EURO TABLE 00 INTERURBAN TRANSACTION ITALY FOOT
DES THE ES ES is) S ES 0 RNO AD L S NAL AS AD
5.9
7.23 7.18 6.33 6.88 6.74 7.41 6.88 6.51 5.80 7.037.16 6.93 10.00
Thus, from the total scores observed in this Matrix, problems in the area of
Purchases (resulting from a very ineffective compliance with tax regulations, of
quality and internal control), on the regulatory side, there is a low performance in terms of
compliance with the provisions of the ISO 9000 / ISO 14000 regulations and in the
corresponding to the provisions of the Central Bank (formation of credit folders
the special information required by the oversight body to access the
bank financing; which could result in a cut in the lines
credit, or an increase in the interest rate.
For the implementation of the system, a total of 10 basic steps must be carried out.
fundamentals, which we will describe below.
1.Training. It constitutes one of the main tasks of the plan. It must be trained and
to train both the System Builder Team and the users, whether they are
the managers and those responsible for the controls (controllers), such as the receivers
of information.
1.Formation of Teams. They are the Constructor Teams of the System for each
segment (sector and standard to be verified). To do this, they will work in the respective teams:
members of the affected area, auditor (external or internal, specialist in the subject) and
company specialists or external. For example, for the design of the questionnaire
corresponding to the accounting sector in tax matters will work: the person in charge of
tax of the accounting sector, the internal (or external) auditor dedicated to auditing
respective, and the company's tax advisor.
1. Construction of the Matrix. The identification of all the Standards will proceed.
Internal and external factors that may or may not affect the company. Based on this, it
proceed to prepare the respective questionnaires, assigning to the questions a
a certain level of weighting in such a way that the sum of all of them reaches
a total of 1 -one- (so if we have three questions: a?, b? and z?. Question a? is granted a
weighting of 0.50; to b? 0.25 and to z? 0.25; in such a way that the sum of all the
weights give a total of 1.00). It will be determined for each question (point of
control) of the questionnaire the frequency of its control and the person responsible for its execution.
(Example: the accountant of each bank branch would have to carry out daily the
cash reconciliation - question: does the total reconciled match the accounting total? - if not
If the total matches, that response would be recorded as 'NO' in the system.
computer scientist, clarifying the magnitude of the difference in question, in such a way at home
Automatically centralizes both the General Manager and the Branch Manager.
The Branch Manager and the Internal Audit Manager would take note of
that difference and its magnitude.
Regarding the way to reach the weighting levels, it will be necessary once
selected all the questions corresponding to a certain questionnaire use the
next matrix:
If we assign a letter to each question and place it at the top of the column.
the letter corresponding to each question, doing the same to the left of each row,
we will have a formed matrix. From there we relate each letter
corresponding to the different rows in relation to each column. Thus we will assign a score
of 1 if it has priority or greater importance in relation to the other question, if it has less
We will assign a value of zero to importance, and if it holds equal importance, the value will be 0.50.
In the case below, since 'A' is more important than 'B' according to the criteria of
A working group is given a value of 1; since 'A' has a lower value than 'C', a value is given.
from "zero"; having the same value as "D" the value of the box is 0.50; and when exceeding in
importance is given to both 'E' and 'F' in both boxes, the value 1 is placed. We arrive at such
it forms a total of 3.50 for question 'A'; of 2.50 for the corresponding question
letter 'B'. When we total all the letters, we have a grand total of 16.50. Then we calculate the
percentage relationship of the total of each letter in relation to the overall total. In other words, how much it represents.
3.50 out of 16.50 (is 21.21%, which represented in decimal values is 0.21). The sum of
All these calculations give 100%, or in other words, 1.
FACTORS
A B C D E F WEIGHTING
A 1 0 0.5 1 1 3,50 21.21% 0.21
In this way, the weighted values of each question are determined; with a 0.21.
for questions 'A' and 'D'; a 0.09 for 'E'; a 0.15 for 'B'; a 0.31 for 'C'
corresponds to the 'C' and a 0.03 for the 'F'.
1. Report Reception and Ongoing Monitoring. The system will inform permanently.
immediate shortcomings, errors, or discrepancies detected. In the case presented as
example at point '5' the designated authorities for that point would be
informed immediately of the detected difference, saving reports of
audit and preparation time of the report, and its respective reading (including for
a certain type of control can report such shortcomings to different
employees by virtue of the magnitude or size of the detected difference or deviation.
A permanent monitoring will also be allowed to know the current situation.
What internal control measures does the company have.
1. System Evaluation. The number of errors and failures detected will be measured by the
SMCI, the frequency of the same. Costs will also be calculated and analyzed.
attributable: audit, inspection, and verification costs plus costs for failures or
failures. The goal is to minimize these costs, thus increasing the
organizational efficiency and effectiveness.
7. Conclusiones
In this way, senior management can verify through the SMCI that it
is fulfilling all the controls, those in charge of them
verifications, when was the last time they conducted checks for each point and with
what frequency. Based on the relative importance of the different points and of the
Problems that they have will be given priority for control and correction.
The area managers and those responsible for control, whether internal or external auditors
they can verify and reason based on the matrix (matrix reasoning) the
compliance with the various provisions.
The matrix considers 100% of the risk factors, thus being a vehicle.
formidable to avoid or correct defects that harm patrimonial and economically to
the entity.
The Matrix System of Internal Control places great importance on compliance with
tax provisions, such as control to prevent fraud, or safeguarding the quality of the
Products and services, as well as protecting human resources among others. Therefore
reason for a quick view of said matrix, printed or on monitor, by the executives
they allow them to know the areas that compromise the company, and proceed to analyze the causes or
reasons, in order to then apply the corresponding adjustment measures.
F.de
POINT 3.4 - Credits / Internal Control Ctrol. 20/05/2003
clients?
guarantors?
6 credits? X completes
Credits?
The Responsible and other staff of the Sector Only the person in charge of
11 has ca_ X Sector count
The staff of the Sector updates its It's been more than two years since
12 periodic knowledge X do not act
they refine or perfect their
mind? (at least twice a year) knowledge
terms of service.
There are regulations on indicators or indices.
13 minimums to analyze
some indicators.
The score indicates a problem in the area, product, or activity, but it does not imply that people
of said sector or process are
always responsible for any problems that may be observed. The rule of must be taken into account
85/15 (J. Juran) according to which
85% of the problems are not related to the employees or workers, but to the system, and therefore
it is the responsibility of the Management
its correction.
guarantors properties
credit
The matrix system of internal control allows not only for the automatic calculation of scores
both by questionnaire, as well as by matrix cell and by area or regulation/principle, but rather
Additionally, the automatic generation of the report by exception. Yes for each negative response.
it indicates in the program the corresponding observation and its implications and risks, once
after the control has been carried out and the mark (“X”) placed in the “NO” column of the questionnaire, the
the report is carried out automatically. This allows standardization of reports, reducing
the paperwork and bureaucratic tasks, allowing for a quick report for the respective officials
and greater uniformity in the information criteria.
10. Annex 3 – Work scheme
INTERNAL AUDITORS
WORK IN Taxes, Labor
TEAM SPECIALISTS Security, ISO
STAFF OF Ventas, Producción,
SECTOR Finance
INTERNOS
CONTROLS OF
SPECIALIST
TAS
VERIFICATIONS BY THE AUDITORS
INTERNALS
Autor:Mauricio Lefcovich