SIGESP: Integrated Management System Guide
SIGESP: Integrated Management System Guide
User Instructions
INDEX
• GENERAL CONSIDERATIONS
• INSTALLATION
• MAIN MODULES
• PATRIMONIAL ACCOUNTING
• BUDGETARY ACCOUNTING OF EXPENSE
• AUXILIARY MODULES
• SYSTEM MODULES
• OPENING (PROCESS)
• INSTALL
• SECURITY
• PROCESS FLOW
• GLOSSARY
GENERAL CONSIDERATIONS
SIGESP has been designed observing the legal regulations governing budgetary matters.
established by the National Budget Office for public institutions (ONAPRE), the Law
Organic Law of Financial Administration of the Public Sector and its Regulations, and other publications
from the General Comptroller's Office of the Republic, the National Office of Public Accounting and the
National Superintendency of Internal Audit.
Characteristics of SIGESP
Requirements:
Server
• Pentium IV processor or its equivalent
• 80 GB SCSI Hard Drive and mirrored drive
• 2 GB RAM
• Operating System: Linux (Debian, Red Hat 9, OpenSuse, Knoppix), Windows
2000 Server or higher
• Gestor de Base de Datos : Mysql 5.0 (Libre), Postgresql 8.0 (Libre) , Oracle 9.2
(Owner), Anywhere 9 (Owner)
• Web Server: Linux Apache, Windows IIS
• Languages: PHP 5.0 with libraries for support of the chosen DB manager and handling
of images.
Workstation
• Pentium II processor or later or its equivalent
• Operating System: Linux (Derian, Knoppix, OpenSus, Red Hat9), Mac Os, Windows
• Browser: Internet Explorer, Mozilla (firefox / Iceweasel), Netscape, Opera, Safari
• Plugin for opening documents in portable format (PDF)
The application was developed by the company SIGESP, C.A., under the Free Software modality, its
source code (programming) is structured in PHP and the information is stored in a database
of Data (preferably using Libre Mysql or Postgresql).
Since the application is fully web-based or graphical, it does not require any physical installation on the
user workstations their implementation, access and use are exclusively
subject to a network connection, in the private LAN of each entity, from where it will be executed.
through the link provided by the network administrator of each organization.
Como pantalla inicial de la aplicación esta la bienvenida en la que se deberá seleccionar dos datos
important for entering it, which are: Database, which will indicate to which DB it
wants to access (each BD will be a fiscal exercise for the entity) and Company, which indicates the entity from which it
it will carry out administrative and accounting management, as the application is multi-company it can be handled
accounting for more than one entity or organization within the same database.
After selecting the operating area, authorization will proceed to access the system.
depending on each user's privilege, for which it is necessary to provide the username (login),
by default 'admin', and the access password (password), by default 'admin', as to
it is observed:
One of the characteristics of this application is its flexibility in the parameters to be used, that is,
allows it to be adjusted to the procedures of each entity, designed in such a way that it can be configured and
adjust the parameters required for administrative management.
Iconography
Upon entering the system, a screen will present a menu, using icons, of all the modules.
present in the application as shown below:
Initially, all users will be able to view the icon corresponding to all the modules, but
you will only be able to access those modules and functionalities that have been defined in your profile
user.
Por otra parte, en todos las pantallas o formularios de la aplicación se presentara una barra de iconos o
tools that will indicate the actions that can be executed on each of them. This bar, given the
case, will show the following actions:
Blank Page: To indicate a new record, it will clear the screen data.
Magnifying glass: to search for existing records using parameters or search filters.
Toothed Wheel: Icon to execute the action on the selected record(s), this
Action can be: process, approve, account, reverse, annul, etc., this will depend on the
module and screen where it is located.
OpenOffice Calc icon: Indicates that the selected report can be exported to some
electronic spreadsheet application such as OpenOffice Calc or MS Excel.
Para la instalación de la aplicación se deben realizar tres pasos como se listan a continuación:
1. Creation of the database on the selected database server. This is done through the sql script.
the empty database with the necessary structure and data for the initial installation and setup
functioning.
The process can be carried out from an administrative tool such as: MYSQL
Administrator, MYSQL WorkBench, phpMyadmin, PGADMIN III, phpPgadmin, etc.
2. Creation of the source code hosting directory in the site publishing directory
from the web server where it will operate. The activities of this operation will depend on the OS where it
run the Web server.
For servers with the GNU/Linux Debian operating system or derivatives, a directory must be created in
/var/www where the compressed file [Link] will be extracted that contains the
source files of the application. The tree of all the folders of the modules will be created that
they compose the application.
The created directory must be given attributes or property to the user executing the daemon.
web, in this case www-data.
3. You must edit the filesigesp_config.php in the directory /var/www/sigesp/ to configure the
database connection parameters and the entity's logo, as shown below:
<?php
?>
The file with the entity's logo will be used for all reports of the application and
must be located in the folders: /var/www/sigesp/shared/imagebanks/ and
/var/www/sigesp/shared/class_folder/tcpdf/
The network or ICT unit administrator of each entity must configure the DNS services to
create a simple name for the access link for users at their workstations,
for example: [Link] or [Link], etc.
CONFIGURATION MODULE - DEFINITIONS - BASIC PARAMETRIZATIONS
This module of the application is of utmost importance, as it must be established from the very beginning.
the information for the proper functioning. When you are ready to parameterize the application, you
they must be clear about the options they want to establish, which should be done together with
staff from all areas that manage the entity and thus ensure that the information
selected is the correct one, since in most cases this information will remain
unalterable throughout the fiscal year.
Sigesp
Asset / Fiscal Accounting
Income Budget
Expense Budget
Accounts Payable
Solicitud de Ejecución Presupuestaria
Purchase Orders
Bank
Sigesp
In this option, general information about the management of the Entity must be loaded, such as legal data and
financials of their fiscal year, such as: Accounting and Budget modality, etc..
must provide the information that cannot be modified once the processing has started
administrative information.
It has nine (09) forms:
The form is so extensive that we will divide it into sections starting with:
Consolidation Information:
Legal Representative: these data refer to the company that is being defined, they are not
mandatory but it is advisable to indicate them for use by the application in the
different reports and letters generated by the application.
Formats: this section is important as it will indicate from the beginning how the work will be done.
the budgetary and accounting accounts, and their configuration cannot be modified
once the information processing for the fiscal year has begun
application.
Account Digits: In this section, the initial digits that will identify will be indicated.
both accounting and budget accounts
• Account Digits – General Accounting: it must be indicated what the digit will be.
identification of the accounts of Assets, Liabilities, Income, Expense, Result and
Capital. Estos dígitos deberían ser apegados a las normas y recomendaciones de
the ONCOP can be adjusted to the policies of the entity.
• Account Digits - Budget: it must be indicated which digit will be
identification of the Order, Expense, and Income accounts. These digits should
to adhere to the rules and recommendations of the ONCOP or they can be
adjusted to the policies of the entity.
• Account Digits – Tax Accounting: it should indicate what the digit will be
identification of Asset, Liability, Income, Expense, Result accounts and
Capital, both for TREASURY and TREASURY. These figures should be
attached to the rules and recommendations of the ONCOP or can be adjusted to
the entity policies.
Sección Datos de la Gestión II:
• Profit and Loss Accounts: In this option, you must indicate to the application the
accounting account numbers for the results of the current fiscal year
Result of Previous Fiscal Year. These accounts are part of the chart of accounts.
accountant of each entity and the application will use it to carry out the closing process
of each fiscal year.
• Treasury Situation: In this option, the application must be informed of the
accounting account numbers if they are managed within their chart of accounts and
applies to its accounting system.
• Budgetary or Programmatic Structure Configuration: It must be
select the way in which the budget structure will be established, this
it will depend on each entity, there are two options: By Programs or By
Projects.
• Level Number of the Structure: It establishes the number of levels that it will have.
the structure, this parameter depends on the needs of each entity and depends on what
selected in the previous option.
• Budget Structure: The names of the levels will be indicated,
previously defined, What will the budget structure contain? No
confusing the name of the level with the names of the projects or programs. For
example, if Project Budget was chosen and three (03) levels were selected
the following designations could be assigned: Name Level 1 Projects
y/o Centralized Actions, Name Level 2Specific Actions, Name
Level 3 Activities.
• Length of the Budgetary Structure Code: Here the definition is established
length that each level of the budget structure code will have. It must
indicate a length for each level that was defined earlier. This field
it must be defined precisely, as it cannot be modified once started
the process of loading information into the application.
• ONAPRE Code Assigned to the Company: In this field, it should indicate the
assigned number by the National Budget Office. This code is
used in the reports of the Budgetary Accounting module for expenses to
issue budget accountability reports in the formats of the Guidelines
issued by the ONAPRE.
• Opening Modality: It indicates the way the budget is opened
Entity spending, the modality can be Monthly or Quarterly.
• Initial Balances: The balances must be indicated for each case, only the
use of the application after the fiscal year of the entity.
• Modules where they will be generated: The application can generate the receipts.
of tax retention (municipal, VAT, ISLR) in the Accounts modules
for Payable (CXP) or Cash and Banks. By default, they will be generated in the CXP module,
since it is here where the legal withholdings are applied at the time of receipt
invoices. It is the policy of each entity how the receipts are generated.
withholding tax.
• Initial value of the Counter: By default, they start at number 1, but if you have
previous withholding vouchers must indicate the number of the last one
printed receipt for the application to take it as a basis. The numbering
The VAT withholding certificates comply with the required parameters.
by the SENIAT, that is four digits of the year, two digits of the month and eight digits
for the consecutive.
• Beneficiario:Se debe indicar el beneficiario del ente que generara las Cartas
Order of payment commitment to be used in the Accounts Module
Pay and Cash and Bank.
Sección Datos de la Gestión IV:
• VAT management: It must be selected how VAT will be affected in the management of
The VAT can be affected in two ways: Budgetary, it requires that each
budget structure contains the budget item and availability for
It can be executed and the accounting department can use the centralized VAT entry.
affect it at the level of accounting entries as a single expense. This configuration
it is only established at the beginning of the management and cannot be modified during the
course of the fiscal year.
Geographic Locations: These are forms for the registration of Countries, States,
Municipalities, Parishes, and Communities. The application has preloaded certain
general information but allows adding and modifying to adapt it to the
particular needs.
Currency: In this option, the monetary units that the company will use are defined.
to record your transactions. These monetary units must adhere to the
laws that regulate each entity.
Equity / Tax Accounting:
In this option, information about the chart of accounts to be used is configured for
keep the accounting of the entity. The chart of accounts must be carefully established.
customized, which will be required by the other modules of the application.
Balance Sheet Accounts Plan: this form defines all accounting accounts
heritage established by ONCOP to carry out the accounting of entities in the public sector.
It is worth noting that the database comes preloaded with the general and parent accounting chart of accounts that
It will serve as a template to create the specific accounting chart of accounts for each entity.
In this form, new accounts can be added or existing ones modified if necessary.
due to an update made by the ONCOP.
Catalog of Resources and Expenses: in this form all accounts are defined
budgetary guidelines established by ONAPRE for managing budgetary accounting of expenses
and income from entities of the public sector. It should be noted that the plan is preloaded in the database.
general budget accounts that will serve as a template to create the chart of accounts
budgetary, both for expenditure and income, specific to each entity.
In this form, new accounts can be added or existing ones can be modified if required.
due to an update made by ONAPRE.
Chart of Accounts: this form defines the personalized accounting chart of accounts for
The entity will be based on the single chart of accounts of ONCOP as a pattern.
It is worth noting that the number of digits in the accounting code is predefined by a format that
It is indicated that this format was specified in the company's definition form.
The process to create the specific accounting accounts consists of selecting the parent account.
by clicking on the magnifying glass next to the accounting code of the account to be defined. A will open
catalog of accounts of the unique accounting plan to select the one that will serve as a guide.
For example, if it is required to create an accounting account for a public bank, the choice will be made.
account 111010201 as parent account.
Then the required number of digits must be completed to meet the format.
established, and in turn, the name must be customized according to the need.
The names of the accounting accounts can also be modified, both the specific ones.
like those of higher education.
Budget Marriage: This option allows us to associate one or more accounts.
income or expense budgetary to an accounting account of the chart of accounts
customized for each entity. This is so that the application takes care of automatically
to make the budgetary and accounting entries in the corresponding accounts.
First, the budget account(s) are added in the left column and then
the accounting accounts of the chart of accounts defined in the previous option are located to be
associated with its respective budget account, this will depend or vary for each entity.
It should be taken into account that the form handles up to 50 simultaneous accounts, which indicates
If you want to associate more than 50 accounts, it must be done in groups, recording the first 50.
accounts and then others will be added until the total number is complete.
This process can also be carried out, and it is recommended, when setting up the
budget structure of the entity.
Income Budget:
In this option, the information about the revenue budget for the management of the Entity must be defined.
• Chart of Accounts.
First, the budget account(s) are added in the left column and then
the accounting accounts of the defined chart of accounts are located to be associated with their respective
budget account, this will depend or vary for each entity.
It should be noted that the form handles up to 50 simultaneous accounts, which indicates
If you want to associate more than 50 accounts, you must do it in groups, recording the first 50.
accounts and then others will be added until the total number is complete.
The budget income account plan will be based on the Resources catalog and
Expenses of the ONAPRE, which could be observed in the option of Heritage Accounting.
Expense Budget:
In this option, information about the spending budget for the management of the Entity must be defined. It
they will define important aspects for the way budgetary allocations are made, as well as the
structures that will be managed at the budget level.
Funding Source: This form allows us to define the sources from which they originate.
the resources that will be distributed in the spending budget of the entity, with the possibility of more than one existing
source of funding.
El proceso de creación de la estructura se realiza desde el nivel superior a los niveles inferiores.
First, the Higher Level is defined and for this example, the modality of
Centralized Projects and/or Actions.
• Code: alphanumeric field of defined length in the configuration section
company.
• Denomination: defines the name that will identify the higher level.
• Intercompany: it will be checked if the higher level is available for multi-company.
• Account code: optional if the intercompany field is checked.
• Project / Centralized Action: it must be chosen in which category the Higher Level is.
to define.
After defining all or at least one higher level, one must choose which one is desired.
continue working to then proceed to define the lower levels within it, as
indicates:
One must click on
the link Go to Actions
specifics for
enter the following
form
There may be one or more specific Actions for each Project and/or Centralized Action, for which
which should be defined for each one using the same procedure.
Subsequently, when defining all or at least one specific action, it should be chosen on which to...
it is desired to continue working to then proceed to define the lower levels within it,
as indicated:
There can be one or more levels for each specific Action of each Project and/or Action.
Centralized, so each one must be defined with the same procedure.
To return to the higher levels of the budget structure, one can make use of the
linksGo to Specific ActionsGo to Project and/or Centralized Actions.
Subsequently, you need to click on the link Add Detail Funding Source to
Open the catalog of the sources of funding defined earlier. It can be added.
one or more sources of financing for each budget structure.
Chart of Accounts: Section where the budget chart of accounts is created and modified
customized expense that will be used by each previously defined structure.
Add accounts: Open the catalog of the unique plan of budget expenditure accounts
proposals by ONAPRE to select those that will be incorporated into the structure
that is being worked on.
Once the budget accounts have been added, they must be associated with the
accounting account that corresponds to it within the entity's accounting chart of accounts, previously
defined. To do this, click on the magnifying glass in the accounting account column of
form, a process that will be repeated for each of the budget accounts; it is to be done
Note that multiple budget accounts can be associated with the same accounting account.
It should be noted that the form handles up to 50 simultaneous accounts, which indicates
That if more than 50 accounts are to be inserted, they must be done in groups, recording the first ones.
50 accounts and then others will be added until the total number is complete.
Administering Unit: In this option, the units that make up the entity will be defined.
The definition will be made based on the organizational chart of it.
It must be supplied
information about:
Code:
Identifier
internal of the
application, is
number
consecutive
auto generated.
Central Unit: Check the option if it is the administrative unit that centralizes everything.
budget.
Executing Unit: The units responsible will be defined, modified, and eliminated.
execution of a budget and therefore will be associated with one or more structure(s)
budgetary. The executing unit must be associated with an administering unit.
It must be supplied
information about:
Code:
Identifier
inside of the
application it
number
consecutive car
generated.
Issue Requisition: It must be checked to ensure that the unit can request.
budget execution or require administrative procedures.
In this section, information about the accounts payable processes of the Entity must be defined.
they will define important aspects such as legal deductions, credits, and types of accounting documents and
budgetary aspects that the application will manage.
Deductions: All deductions or legal taxes will be defined, modified, and eliminated.
that the entity must apply, such as: municipal tax withholdings, VAT, income tax, etc.. These
deductions will be used in the Accounts Payable module when making the
document receptions.
It must be supplied
information about:
Code:
Identifier
internal of the
application, is
number
consecutive
auto generated.
Accounting Code: The accounting account defined in the chart of accounts must be selected.
accounting of the entity, to record the entries associated with the deduction.
Deductible: Amount that will be deducted at the time of its application, this if the concept...
merit.
Type of Deduction: One of the options corresponding to the type must be checked.
deduction that is being defined.
ISLR Withholding: You must choose the code from the table provided by SENIAT.
which is pre-loaded, corresponding to the deduction being defined. This
apply for ISLR deductions, if another type of deductions is defined it should be
choose not to apply.
Formula: By clicking on the formula button, a wizard will open to build the
calculation process of the deduction.
Type of Person: It will be indicated which type of persons (Legal or Natural) will apply.
deduction.
Other Credits: All credits or taxes by law will be defined, modified, and eliminated.
that the entity must cancel, such as VAT. These credits will be used in the modules of
Inventory and Configuration when defining goods and services.
If should supply
information about:
Code: Identifier
inside of the
application, is number
consecutive car
generated.
The form will vary the following field, depending on how it has been configured.
VAT modality in the Company configuration section.
If it is IV budgetary modality:
Budget: The expense budget account, defined in
the chart of accounts of each budget structure of the entity, to settle the
tax.
If it is VAT accounting mode:
Accounting Code: The accounting account defined in the plan must be selected.
accounting accounts of the entity, to record the entries associated with the tax.
Purchase Book: The option is checked to record the tax entries in the book.
of purchase.
Formula: By clicking the formula button, a wizard will open to build the
tax calculation process.
Documents: The types of documents to be managed will be defined, modified, and deleted.
at the level of accounts payable, and how these will affect the budget and the accounting of the entity.
These documents are personalized and adjustable to the needs of each entity.
If must supply
information about:
Code:
Identifier
internal of the
application es
number
consecutive auto-generated.
Budget-wise: It should indicate how the payment order operation will affect the
budget. It can be selected that the document is for: Cause, Commits and
Cause, None or without Impact.
Accounting-wise: It should indicate how the payment order operation will affect the
Accounting. It can be selected that the document is: Credit or without Affectation.
Document Type: It will only be checked to identify the documents that are defined.
as an advance payment.
In this section, you must define the information about the document that will initiate the process.
administrative within the application. Aspects such as how to affect the budget will be defined
the concepts for its execution. This document can be referred to as a Request for
Budget Execution, Administrative Procedure or Request for Goods/Services, that will depend on
each entity.
Type: The types of Procedures that will be managed will be defined, modified, and eliminated.
application for the execution of the budget, and how these will affect the budget of the entity.
These documents are personalized and adjustable to the needs of each entity.
It must be supplied
information about:
Code:
Identifier
inside of the
application, it is
number
consecutive
auto generated.
Name: Name of the Document for control and internal input of the application.
Examples: Purchases (Asset/Consumable goods), Services, Transfers, Works, etc.
Budget Impact: It should be indicated how it will affect the request operation
through the budget. It can be selected that the document is: Precommitment,
Commitment or without Impact.
Type: It will be marked to identify the documents that are defined as procedures.
Goods (assets/consumables), Services, Others (works, transfers, etc.) or Aids
Personal Economics.
Concept: The concepts for Procedures that are not in will be defined, modified, and eliminated.
the category of Goods or Services that directly commit the entity's budget.
These concepts are personalized and adjustable to the needs of each entity.
Account: The budgetary expense account will be associated with which the application will charge.
the movements for the concept.
Observation: Any relevant comment regarding the concept to be defined will be indicated.
Add Charges: The charge or charges (taxes) that affect the concept will be associated.
will be automatically included at the time of carrying out the procedure. These charges or
taxes were previously defined in the Accounts Payable - Other section
Credits.
Purchase Orders:
In this section, the information about the parameters to be used in the Order module must be defined.
Purchase and Request for Budget Execution. Aspects such as the services to be contracted will be defined.
purchase or contracting clauses.
Code: Identifier
internal of the application,
it's a consecutive number
auto generated.
Milco Catalog: It must be indicated to which family of the MILCO catalog it belongs.
manage this categorization (optional).
Services: The Services that the entity may contract will be defined, modified, and eliminated.
will be included in the details of the procedures.
It must be provided
information about:
Code:
Identifier
inside of the
application it
number
car consecutive
generated.
Type: It must
associate with a
Type of Service.
Price: A reference price for the service must be indicated. This price can be
modified at the time of processing the procedure or at the time of placing the order
service for your hiring.
Account: The budget expenditure account for which the application will charge will be associated.
the movements for the service.
Add Charges: The charge or charges (taxes) that affect the service will be associated.
will be automatically included at the time of processing the procedure. These charges or
taxes were previously defined in the Accounts Payable section - Others
Credits.
Bank:
In this section, information about the parameters to be used in the Cash module should be defined.
Bank. Aspects such as banks and accounts of the entity, checkbooks, and placements will be defined.
Bank: Financial Entities with which it has will be defined, modified, and eliminated.
relationship the being.
It must be provided
information about:
Code:
Identifier
inside of the
application, it is
number
consecutive
auto generated.
Manager: The name of the manager of the financial entity must be indicated.
Phone:
National Treasury: If the defined entity belongs to the National Treasury of the
Republic.
Account Type: The types of bank accounts will be defined, modified, and eliminated.
the entity will be able to handle.
If must supply
information about:
Code:
Identifier
internal of the
application is
number
auto-generated consecutive.
Bank Account: The bank accounts that you have will be defined, modified, and deleted.
require the entity.
Code: Identifier of
the account, is numeric and
can be supplied by
the user. Commonly
the code of the
cuenta.
Denomination:
Account identification
banking.
Cta. Extended:
20-digit identifier
from the bank account.
Tipo Cuenta:Se seleccionara el tipo de cuenta bancaria que se esta definiendo.
Bank: The Financial Institution to which the bank account belongs will be selected.
Account Number: The accounting account from the entity's chart of accounts will be assigned, created.
specifically to record the entries associated with the bank account.
Closing Date: Legal closing date of the bank account. If it is being defined then
leave by default.
Checkbooks: The checkbooks associated with the accounts will be defined, modified, and eliminated.
banking that it possesses. This option will only be filled if it was configured in the Company section that
the issuance of checks should be automatic.
Agencies: The locations of financial entities will be defined, modified, and eliminated.
defined previously. At least one must be defined for each entity.
Manages data registration and provides information about financial management of the
organization. Operations can be recorded directly and through auxiliary modules.
In this last case, the accounting unit focuses its activities on reviewing, checking, verifying and
examine all movements and records.
Generated Reports
Standards
• Balance sheet
• Trial balance
• Income Statement
• more analytical
Compared
• General Balance Form 0718
• Income statements Form 0406
• Origin and application of funds Form 0719
• Investments Form 0714
Listings
• Receipt
• Format 1
• Format 2
• Chart of accounts
• Unique chart of accounts
• Movement of the month
Within the file structure of the system, this module has its source files in the following
carpeta: /var/www/sigesp/scg
• Receipt Accountant
End of Year Settlement Receipt,
Report Scheduling y
OAF Reports Programming
This process allows for the creation, modification, and deletion of receipts and accounting entries that
They are directly made to the accounting books of the entity. It allows viewing vouchers.
accounts created by the auxiliary modules of the system.
Form Fields:
Origin:
Internal identifier of the
application that indicates
where was created the
receipt.
Receipt:
Identifier del
document field
alphanumeric can be
supplied by the
user. If the application is not modified, it will automatically generate a consecutive code based on the last one.
registered.
Type: Headline (Supplier or Beneficiary) in the name of whom the receipt will be. By default
None.
In the Accounting Details section, the accounting accounts, amounts, and operation will be assigned.
will be part of the receipt:
Accounting Code: The account from the entity's accounting plan is selected, which will be the subject of the
operation. It is necessary to operate account by account until completing the required ones to close the
receipt.
Operación:Se selecciona como sera afectada la cuenta, por el debe o por el haber.
Accounts will be added or removed in ascending order through the links Add Detail /
Delete Detail. It must be verified that the Difference between the columns of DEBE and the
Enter zero (0) to be able to save the receipt.
Closing Exercise Receipt:
This process allows for the creation of the accounting closing certificate for the fiscal year, which is
it will be executed once it has been agreed with the administrative department.
In order for this process to be executed, the Budget Closure of must be carried out beforehand.
Exercise in the Budgetary Accounting Module of Expenditure.
Its execution disables the performance of subsequent transactions in the entity's accounting.
Manage tasks and provide information on the financial physical execution of the budget.
Operations can be recorded directly or through auxiliary modules.
Instruction 05
• Monthly financial execution of the expenditure budget Form 0503
• Standard
• Accumulated
• Financial Execution of the projects of the entity Form 0514
• Financial Execution of the projects of the entity Form 0516
• Financial Execution of the centralized actions of the entity Form 0517
• Financial Execution of specific actions Form 0518
Instruction 07
• Summary of the expenditure budget by item Form 0704
• Summary of the budget at the project level and centralized actions Form 0705
• Financial Execution of the expenditure budget Form 0707
• Cash budget Form 0717
Within the system file structure, this module has its source files in the following
carpeta: /var/www/sigesp/spg
This Module contains eight (08) processes as shown below:
Opening:
This process allows the entry of amounts into the budget expenditure items for each
structure. The opening modality depends on what is configured in the Company section,
being able to be Monthly or Quarterly.
Form Fields:
Date: It is the one indicated at the time of configuring the company as the start date of the period.
Distribution: Method for making the distribution or scheduling of the amount assigned to each item.
If Automatic is selected, the amount allocated to each item will be divided by 12 months. If
manual selection, the amount must be assigned for each month.
Once the budget structure is selected, in the OPENING section, the will be displayed
budget items defined in the chart of accounts and the amount will be entered
corresponding to each item in the Allocation column.
This process allows the creation, modification, and deletion of receipts or entries that affect
directly the financial physical execution of the entity's budget.
Form Fields:
Origin:
Internal identifier
from the application that
indicate where it was
created the
receipt.
Date: It should be
indicate the date that
it is desired to assign to the
movement
budgetary.
Receipt:
Identifier out
document, field
alphanumeric can be supplied by the user. If not modified, the application will auto-generate a
consecutive code based on the last one registered.
Funding Source: The funding source for the resources that will be selected.
involved in the budget voucher.
In the Budget Detail Addition section, the expense accounts, amounts, and operations will be assigned.
that will be part of the receipt:
Project and/or Centralized Actions: Select the 1st level of the budget structure.
Account: The account is selected from the budget account plan for the structure.
selected, which will be the subject of the operation. It is necessary to operate account by account until
complete the required fields to close the receipt.
Operation: It is selected how the account will be affected at the budgetary level, it can be: Pre-
Compromiso, Compromiso Simple, Compromiso Gasto Causado, Gasto Causado, Gasto
Paid Cause, Payment, Commitment Cause Paid.
Budget Modifications:
This process allows for the execution of variations in the entity's budget through the creation,
modification and elimination of the following subprocesses:
• Rectifications, Insubsistences,
Transfers and Additional Credits.
Form Fields:
Origin:
Internal identifier of
the application that indicates
where was it created
receipt.
In the Add to Other Accounts section, the accounts that will receive the resources will be assigned.
amounts and operations that will be part of the receipt:
Fields del
Form:
Origin:
Internal identifier
from the application that
indicate where it was
created the
receipt.
Date: It must
indicate the date you wish to assign to the budget movement.
In the Add Expense Detail section, the accounts that are objects of deduction will be assigned to
the credits, amounts, and operation that will be part of the receipt:
Fields delete
Formulario:
Origin:
Internal identifier of
the application that indicates
where it was created the
receipt.
Source of Funding: The source of funding for the resources is selected that
they will be involved in the budget report.
Administering Unit: The Administering Unit to which the transfer will affect is selected.
budgetary.
In the Transferring Items section, the budget accounts that are the source of the
resources, amounts, and operation that will be part of the receipt:
Centralized Project and/or Actions:
Select the 1st level of the structure
budgetary.
In the Receivable Items section, the accounts that will receive the resources, amounts and
operation that will be part of the receipt:
It should be taken into account that the transfer process can be structured in various ways.
between the Grantor and Receiving Parties, these can be: One to one, One to several, From
various to one or, failing that, various to various. The most important thing that must be anticipated is that the
the total amount of the Assignor entries must be equal to the amount of the Receiver entries.
Credit/Additional Income: Modification receipts are created, modified, and deleted.
budgetary through which increments to budgetary credits are made that are
they agree on the projects and/or centralized action of the entity.
Fields of
Form:
Origin:
Internal identifier of
the application that indicates
where was it created
receipt.
Administrative Unit: The Administrative Unit that will be affected by the credit is selected.
additional income.
In the Add Expense Detail section, the budget accounts that will receive will be assigned.
the resources, amounts and operation that will be part of the voucher:
In the Add Accounting Detail section, the accounting accounts will be assigned to record the
origin of the resources, amounts and operation that will form part of the receipt:
This process allows for the execution of the budget closure for the fiscal year, an operation that
it prevents subsequent movements from being executed.
It is executed by clicking the central button on the screen 'CLOSE EXPENSE BUDGET'
This process can be booked in the same option by clicking the central button on the screen.
REVERSE BUDGET EXPENDITURE CLOSURE
AUXILIARY MODULES
APPLICATION MODULE OF
BUDGET EXECUTION
The source files of this module, as well as its reports, are located at:/var/www/sigesp/sep
Registro:
This process allows the creation, modification, and deletion of Requisitions, Procedures, or Requests.
for the purchase of goods, contracting of services and/or initiation of commitments for other concepts
(works, transfers, etc.) that different budget executing units are required to carry out within.
of the entity.
Form Fields:
Status: Identifier of
document status.
Being able to have the statuses
of Registration, Approved and
Processed.
Request: Code of
Document numbering,
it is a consecutive number and
auto generated by the
application.
Date: The date that you wish to assign to the document must be indicated.
Type: It is selected what type the requirement or procedure will be. This typology has been declared.
previously in the Configuration Module in its Budget Execution Request section.
Depending on the selected type, the form will change the fields to be registered.
When the type is Purchase, it can be indicated whether the purchase will be for: Materials and/or
Supplies or of an Asset.
Executing Unit: The executing unit is selected, including the budget structure.
what will generate the procedure.
Concept: Field for a detailed description of the object of the request, procedure, or requisition.
Finally, the Application, Requisition or Procedure must be saved and printed in order to proceed with it.
management.
Approval:
This option allows for the approval to proceed with the management of the requisition document, request
or process, as well as the approval reverse to modify any document. Its execution
it can be carried out by the duly authorized personnel for that.
Cancellation:
This option allows the cancellation of the requisition document, request or procedure, as well as
reverse of its annulment. Its execution can be carried out by duly authorized personnel to
Hello.
1. As an initial step, it should be indicated that
action is desired to Cancel or Reverse
Cancellation
2. Then the search begins,
through some filter, of the documents
available for cancel/reverse
through the icon so that it
unfold the document grid.
3. The document or documents to be canceled or reversed will be checked.
The action will be processed using the icon.
APPLICATION MODULE OF
BUDGET EXECUTION
This module facilitates the processes for acquisitions. It includes options for analyzing quotes,
issuance of purchase or service orders, automatically checks the existence or non-existence of
budget availability, and generates the commitment record in budget accounting in
automatically, prints and issues the purchase or service order according to the requirements of the
institution.
Generated Reports
• Purchase order
• Request for quotations
• Quotation record
• Analysis of quotes
The procedure for purchasing goods or contracting services can be done through two ways. One to
through the analysis of quotes and the other directly from an Execution Request
Budgetary:
This process allows the creation, modification, and deletion of quotation requests to
suppliers, based on a requisition or budget execution request.
Form Fields:
Estatus:Identificador del estado
from the document. Having been able to
the Registration status and
Processed.
Number: Code of
Document numbering, is
a consecutive number and self
generated by the application.
Date: The date that you wish to assign to the document must be indicated.
Type: It is selected what type the requirement or procedure will be (Good or Service). When the
the category of goods can indicate whether the purchase will be of: Materials and/or Supplies or of a
Active.
Associated Unit: Field that indicates the Executing Unit and the Budget Structure of
document.
Personal: Select the person, from the payroll list, who is originating the request for
quotation.
In the Add Supplier section, one or more suppliers will be added to whom requests will be made.
quotation of the goods or services that are subject to the procedure:
Once all the information is completed, the request for quotes is saved for
subsequently print it/them.
Quotation Register:
This process allows for the creation, modification, and deletion of provided quote records.
by the suppliers at the request of the entity, based on a request for quotation.
Form Fields:
Status: Identifier of the document's status. There may be statuses of Registration and
Processed.
In the Add Quotation Request section, the quotation request that was added will be
sent to the supplier and that originated the quote that is being registered.
When selecting the Quotation Request, the details of associated goods or services will be loaded.
to her in order to proceed to modify the prices with the actual amounts provided by the
provider in its quotation or budget.
Quote Analysis:
This process allows for the creation, modification, and deletion of quotation analyses to proceed.
to select the supplier to whom the purchase of goods or service contract will be awarded, based on
in a quotation request.
Form Fields:
In the Add Quote section, the quotes sent by suppliers will be added.
they wish to be analyzed and associated with a specific quotation request.
When selecting the Quote, the details of associated goods or services will be loaded for
proceed to assign the lines to the providers. If there are two or more lines and they are assigned to
different suppliers will automatically generate as many purchase or service orders as
suppliers have been selected.
Once all the information is complete, the analysis of quotations is saved for
subsequently print it.
This option allows the approval to proceed with the management of the analysis of quotes, as well as
also the reverse of approval to modify any document. Its execution can be carried out
by the duly authorized personnel for this purpose.
This option allows for the creation of purchase or service orders that are assigned through the
analysis of quotes. Its execution can be carried out by duly authorized personnel to
Hello.
1. Then the search begins, through
some filter, of the available documents
to approve through the icon for
let the document grid be displayed.
The document or documents to be generated will be checked.
3. The action will be processed through the icon
This process allows the creation, modification, and deletion of Purchase or Service Orders.
suppliers, based on a requisition or budget execution request.
Form Fields:
Estatus:Identificador
delete state del
document. Being able to
check the statuses of
Register, Issued,
Issued (Approved)
Committed
(Processed) and Canceled.
Supplier: Select from the supplier catalog, the one to which the Purchase Order will be assigned.
or Service.
Budget Execution Request: This link opens the catalog of requisitions or
requests, with processed status, available to start the purchase process or
hiring. When the request to be processed is selected, its data will be loaded in
the form.
Concept: Field for detailed description of the object of the request, procedure, or requisition.
Associated Unit: Field that indicates the Executing Unit and the Budgetary Structure of
document.
The Delivery Conditions section must include important information for the Orders.
Purchase or Service as the Office and Dependency where the delivery of the good is required
service, as well as the time period for it and whether it will be subject to insurance coverage.
When selecting the Budget Execution Request (Requisition), the details will be loaded
goods or services associated with it in order to proceed to modify the prices with the actual amounts
supplied by the provider in their quotation or budget.
Once all the information is complete, the Purchase or Service Order is then saved for
subsequently print it.
This option allows for the approval to proceed with the purchasing process of goods or contracting.
services, as well as the approval reverse to modify any document. Its execution
It can be carried out by personnel duly authorized for this.
Cancellation:
This option allows the cancellation of Purchase or Service Orders. Its execution can be
performed by the duly authorized personnel for this purpose.
Generated Reports
Listings
• Deductions
• Other credits
• Documents
Document receptions
Accounts payable
Requests
• Formato 1
• Format 2
Withholdings
• I.S.L.R
• General
• Specific
• VAT
• Informative statement
• Municipal
• Invoice list
• Consecutive relationship of requests
• CXP summarized
• Relationship of balances by request
• Relationship of debit/credit notes
• AR-C
Purchase book
• General
• Summarized
This Module contains two (02) main Actions, each divided into three (03) processes.
as observed below:
• Reception de Documents:
Record, Approval y
Cancellation.
Record:
This process allows for the creation, modification, and deletion of document receipts (Invoices,
Per diems, payrolls, transfers that originate from commitments with suppliers or
beneficiaries, based on a budget execution request, purchase/service orders,
request for travel expenses or payroll processing.
Form Fields:
Estatus:Identificador
del state del
document. Being able
check the status of
Registration, Issued,
Accounted y
Cancelled.
Registration Date: It
you must indicate the date
that is desired to be assigned to the
document.
Document Type:
It is selected from that
type will be document
budgetary y
accounts payable. This typology was defined in the module of
configuration in the Accounts Payable section.
Depending on what is selected in this field, the form will change its appearance to
adapt to the selected operation. The typeDocumento Causa is commonly used.
Provider/Beneficiary: Select from the catalog of providers or beneficiaries who will be the
holder of the payment document.
Issue Date: The issue date of the document or invoice must be indicated.
Expiration Date: The date on which the document expires must be indicated.
Concept: Field for detailed description of the object of the application, procedure or request.
Executing Unit: Field that indicates the Executing Unit and the Budgetary Structure of
document.
In the Add section
Commitments will be deployed
the payment commitments to
provider or beneficiary, before
selected, generated by
Purchase/Service Orders or
Requests of Execution
Processed budgets.
Al select the
commitments for Request of
Budget Execution
(Requisition) or Order of
Purchase/Service will be charged
the details of goods, services, or concepts associated with it in order to proceed to verify the
amounts and apply the legal deductions if applicable.
Once the necessary deductions have been applied and the information has been completed, you must click on the
Close Button Entry, so that the application builds the accounting entry that will be generated
moment to process the document.
Once all the information is completed, the Document Receipt is saved for
subsequently print it.
Approval:
This option allows for the approval of the document, as well as the reversal of approval for
modify any document. Its execution can be carried out by properly authorized personnel
for that.
Cancellation:
This option allows the cancellation of the Document Receipt. Its execution can be carried out by
the personnel duly authorized for it.
Payment Requests
Record:
This process allows for the creation, modification, and deletion of Payment Orders that are
coming from commitments with suppliers or beneficiaries, based on Document Receipts
(Invoices, Travel Expenses, Payrolls, Transfers)
Form Fields:
Status: Identifier of
document status.
Being able to news the
status of Registration
Issued, Accounted and
Cancelled.
Issue Date: Se
must indicate the date that
it is desired to assign to
document.
Number Request:
Identifier of the
Request of Payment.
Consecutive car number
generated for the
application.
Provider/Beneficiary: Select from the supplier or beneficiary catalog who will be the
holder of the payment order.
In the Add Reception Details section, the Invoices or Documents will be displayed.
Payment commitments to the supplier or beneficiary, previously selected.
When selecting Invoice or Document, the details of goods, services, or concepts will be loaded.
associated with her to proceed.
One or more document receptions can be added for the same provider.
Once all the information is completed, the Payment Order is saved for later.
print it.
Approval:
This option allows for the approval of the payment order to proceed, as well as the reversal of
approval to modify it. Its execution can be carried out by duly authorized personnel
for that.
Cancellation:
This option allows for the cancellation of the payment order, as well as the reversal of its cancellation. Its
execution can be carried out by personnel duly authorized for it.
Manage all transactions and movements made in the different bank accounts and
provides general and detailed information about them. Additionally, it allows for the registration of payments in the
payment order modules, budget accounting, and general accounting. Similarly
records transactions such as: credit note, debit note, deposits, withdrawals, placements and
bank reconciliations.
Generated Reports
Standard
• Financial availability
List of documents
• Documents
• Reconciled
• Documents in transit
List of direct payment orders
Payment
Accounting record
Bank reconciliation
Account statement
• Format 1
• Summarized
Others
• Budget movement by bank
• List of checkbooks
• Selective relationship of checks
• Selective document relation (does not include checks)
• Checks in custody
• Bank book
• Municipal withholding receipt
Bank Movement:
This process will allow registering, modifying, and deleting the movements executed by the entity in accounts.
from the bank, such as: Deposits, Debit and Credit Notes. It can be used to manage petty cash.
from the institution giving it the same treatment as a financial entity.
Form Fields:
Operation: Selection combo to indicate the type of operation (Deposit, Debit Note,
Credit, Withdrawal or Check.
Payment Order Number Ministry: Optional field to indicate the source document of the
resources if they are transfers from the overseeing entity.
Fund Type: Optional field to indicate the type of fund if they are transfers from an entity
assignment.
Impact: Indicates what type of impact the financial resources will have and will depend on the type.
of selected operation.
Account: The bank account that is the subject of the transaction must be selected.
Account: Accounting account where movements associated with the bank account are recorded.
Order Letter Number: It is used to identify the payment order letter document for suppliers.
through the use of bank transfers. (optional)
Concept: Field to provide information about the reason for the bank transaction.
Withholding Amount: Informational field that indicates the amount resulting from applying withholdings to
movement, if applicable.
Interest: It is checked to identify that the amount of the bank transaction represents some interest.
Not Accountable: It is checked to indicate that the bank transaction will not affect the
accounting, only bank book.
Then it should be selected whether the bank transaction being created will include details.
budgetary of income or expense, accounting or withholding.
In the Budget Detail Addition section, a form will be displayed to select the
budget structure and the expenditure items that are required.
This option applies to movements of
Debit Note.
Once all the information is completed, the banking transaction is saved for
subsequently print it.
Cancellations:
Payment Scheduling
This option allows for scheduling the issuance of checks to adjust them to the cash flow or
financial of the institution.
Form Fields:
Travel Type: Field that is activated in conjunction with the beneficiary option and only
will deploy the payments originated from travel expense requests.
Bank: The bank from which the payment should be made must be selected.
Account: Select the bank account through which the payment issuance will be scheduled.
This option allows for the deprogramming of payment orders for the issuance of checks for the purpose of
make any required modification.
Form Fields:
When selecting Provider or Beneficiary, the requests scheduled for payment will be displayed.
in the grid to proceed to check the payment orders to be unprogrammed, then it must be
save the process.
Issuance of Checks:
This option allows for the creation of the payment document based on payment requests.
Scheduled. A check can be created with one or more payment requests from the same holder.
Form Fields:
When selecting Provider or Beneficiary, the scheduled requests will be displayed in the grid.
to proceed to mark the payment order(s) to be included in the check. Then it must be
save the process and a window will automatically open with the document for your
printing.
Elimination of Unaccounted Checks:
This option allows you to delete checks that have not been processed in the integrative module.
Form Fields:
When selecting Provider or Beneficiary, you must click on the Load Checks link to
the checks are displayed on the grid and then proceed to check them, then you must press the
processing icon.
Bank Reconciliation:
This process will allow auditing or tracking of bank transactions for all accounts.
of the entity and ensure they correspond with the financial institutions' account statements.
Form Fields:
Close Reconciliation: It must be checked when all movements have been reconciled.
bank statements of the month.
The account movements to be reconciled must be uploaded by clicking the Load link.
Movements, with this all deposits, checks, debit notes will be displayed in the grid.
credits that are recorded for the selected account.
Then it should be checked off as indicated with the bank statement issued by the entity.
financial, until the difference between balances according to the bank and the book is equal to zero (0) with which it
I would achieve reconciling the account. Changes made are being saved.
VAT Withholdings:
This process will allow the creation, modification, and deletion of VAT retention certificates for the
suppliers of the institution. When creating the receipts, the information will be provided for the
after the creation of the declaration file with the SENIAT. This procedure must be executed one
It has been verified that the checks for the payment of the retention commitments have been accounted for.
Form Fields:
Provider/Beneficiary: Selection
to indicate the type of check holder.
From/To: The holder for whom the receipt needs to be created is specifically selected.
of retention.
Then you must click on the Run link so that the retention certificate(s) is generated.
of VAT.
PAYROLL MODULE
This module allows for the processing of: Calculation of Trust for Social Benefits,
Management of payroll history, Accounting for payroll and contributions, Allows movements
between payrolls, Calculation of loans and installments to be deducted once defined, Import and
data export, management of savings accounts, among other functions of vital importance for the
personnel management within an institution.
Generated Reports
Personal
• Staff list
• List of contracted personnel
• List of personnel with administrative units
• Generic Personnel List
• Personal file
• Birthday celebrants
• Relatives
• Holidays
• Certificate of employment
• Credentials
• Antiquity
Compared
Instructions 04
• Human Resources Form 0406
Instruction 05
• Human Resources Form 0506
Instruction 07
• Human resources classified by job type Form 0711
• Retired personal pension and survivor allowances Form 0712
Withholdings
• Retention relationship AR-C
• Withholding relationship I.S.L.R
Consolidated
• Concepts
• Employer contribution
• List to the bank
• Payment receipt
• Ticket path
Length of service benefit
This is one of the most extensive and delicate modules of the application due to the information it handles.
process.
This Module, due to its peculiarity, has definitions or configurations that are carried out specifically.
inside it, of which we will focus on the essentials for its operation, such as
son
Definitions
• Payroll: in weekly, biweekly, monthly, and annual periods
• Professions: all the professions of the staff
• Administrative Units
• Holidays, Permits and Social Benefits
• Methods for the operation of Cesta Ticek and Sodexho
allowing to also define the value
• Charges
• Loans
Definition of PAYROLLS:
In this option, the payrolls that will be handled in the system will be created, modified, and deleted.
The creation of the payroll includes the general configuration of important parameters for its execution.
Code: Unique number provided by the user for internal identification of the
payroll
Tipo de Nomina:Se selecciona que personal estará amparado por la nomina (empleados,
workers, etc.).
The special attributes can be configured according to the internal personnel policies of each
institution. Among the most important special attributes is that of RAC which indicates how
The payroll will manage the assignment of positions. There are two options if it will be managed by positions.
individuals should not check the option or alternatively, tabs and Registration will be managed
of Assignment of Position, which must be defined at the time of creating the payroll, since not
it may be modified.
It should then be specified whether the payroll being created is for Meal Tickets or Bonuses.
Nutrition.
The following parameters for payroll accounting, contributions, and must be configured
antiquity
It should be indicated how the payroll, contributions, and seniority will affect the budget of
spending as to the accounting of the institution. Depending on what is selected,
They should mark the parameters that are deemed appropriate for each case.
Definition of Professions:
This option allows for the creation, modification, and deletion of the professions that the staff will have.
that will be part of the institution.
Denominación:Nombre de la profesión.
Definition of Administrative Unit:
This option allows the creation, modification, and deletion of the administrative units.
organizational structure of the institution. The budget structure must be assigned to allocate the expenses of
personnel assigned to the administrative unit.
Form Fields:
Code:Identifier
supplied numerical
by the user.
Denomination:
Unit Name
Administrative.
Definition of Personnel:
This option allows the creation, modification, and deletion of the people who will be part of the
employees of the institution. Each person will possess a data and attribute form that must be filled out during
Enter the institution to then be used by the system when assigning staff to a payroll.
Los demás campos requeridos: Nombre, Apellido, Dirección, Fecha de Nacimiento, Estado
Civil, Nacionalidad, Genero, Profesión, Nivel Académico, Ubicación Geográfica, Numero de
Children, Type of Personnel, Type of Housing, Date of Entry into Public Administration and
Date of Admission to the Institution.
In addition, the personnel file has attached forms such as: Family members, Studies, Jobs,
ISLR, Permit, Trust, Vacation and Beneficiaries, these can be accessed through
the buttons at the bottom of the main form.
Definition of Vacation Table:
This option allows for the creation, modification, and deletion of the different calculation methods.
vacations that the institution grants to its workers.
Form Fields:
Code:
Identifier
numeric
supplied by the
user
Denomination:
Description del
name of the Table or
picture.
The option to Take into account Previous Years of Service will be checked, if you wish the system
take this parameter for the calculation of vacation.
Then the table will be completed with the guidelines or internal policies of each
institution for the calculation of vacations, providing for each Period or Year: Days of
Enjoy, Additional Days of Enjoyment, Bonus Days and Additional Bonus Days. Making
Click on the checkmark in the row to add new ones until all the information is complete.
Once the table is completed, the vacation table will be saved so that it is
used in each payroll for their calculation.
Definition of Dedications:
This option allows the creation, modification, and deletion of the different types of patterns.
work of the institution's staff, for example: Full-time, part-time, etc..
Form Fields:
Code: Numeric identifier
supplied by the user.
Denominación:Descripción del
time pattern for work.
This option allows the creation, modification, and deletion of the different workplaces or locations.
from the institution and where the workers can be assigned.
Form Fields:
Denominación:Descripción de la
headquarters or location.
Location Geographic: If
select the Country State,
Municipality and Parish where it is located
find the headquarters that is being
defining.
Once the form is completed, the physical location will be saved so that the
personal assigned to them within the payrolls.
Definition of Charges:
This option allows the creation, modification, and deletion of the different positions held by the
organizational structure of the institution and where workers can be assigned. This section
it will only be used if the payroll is configured to use independent positions
moment of its creation or for special payrolls.
Form Fields:
Code: Identifier
numeric provided by the
user
Denominación:Descripción o
Job Title.
Payroll: The payroll to which the position to be defined will belong is selected.
Once the form is completed, the position will be saved so it can be used for
moment of adding a personnel to the payroll. The same position can be used by one or
various people.
Definition of Tabulator:
This option allows the creation, modification, and deletion of the different tabs or list of
all the salaries assigned to each position that the organizational structure of the institution has and to
where workers can be assigned. This section will only be used in case it is
The payroll is configured to use RAC at the time of its creation.
Form Fields:
Code:
Identifier
numeric
supplied
by the user.
Denomination:
Description of
name del
Tabulator o
picture.
Payroll: The payroll to which the table to be defined will belong is selected.
Total steps per degrees: It will be declared how many steps, according to the internal personnel policy or
The law governing the matter will contain each degree or step of the scale.
Then the table will be completed with the guidelines or internal policies of each
institution for the calculation of salaries, providing for each Grade or step: Step, Salary,
Compensation and Salary + Compensation. Clicking on the checkmark in the row will add them.
new until all the information is complete.
Once the table is completed, the salary tab will be saved so that it is
used in each payroll for the calculation of the salaries and wages of the staff.
This option allows for the creation, modification, and deletion of the different positions that the
organizational structure of the institution, as well as its budget allocation parameters, and to
where workers can be assigned. This section will only be used in the event that it is
the payroll is configured to use RAC at the time of its creation.
Form Fields:
Administrative Unit: The organizational unit where the position will be located is selected.
that is being defined. Depending on the administrative unit, the structure will be loaded.
budgetary where the expenses attributed to the position will be charged.
Salary scale: A salary scale must be assigned that will govern the position.
Grade: A grade or step within the salary scale for the position must be assigned.
Number of Vacancies: The number of positions to be created with the same characteristics must be indicated.
and that belong to the same administrative unit.
Once the form is completed, the position will be saved so that it can be used for
moment to add a staff member to the payroll. The same position can be used by one or
various people.
PAYROLL PROCESSES
Once the general parameters that will be used in the payroll module have been defined,
they will proceed to execute certain specific processes, such as:
Select Payroll:
This option allows the selection of the payroll that you wish to process. The following describes all
the aspects of this process:
INTEGRATOR MODULE
This module allows the processing of documents from the other modules of the system, in order to achieve
the budgetary and accounting integration. So that the workflow flows or moves from one module to another
the processes specified for each section of the system must be executed as described in
continuation:
Account for: It is executed to create the budget pre-commitment according to the established.
the document for the purchase of goods, contracting of services, and commitment in the case of another
concept.
Purchase:
Account for: It is executed to create the budget commitment according to what is established in the
purchase order for goods or service contract.
As a first step, documents should be searched using some filter.
available to commit via the icon to be deployed to the
document grid.
2. The document or documents to be accounted for will be checked.
3. The action will be processed through the icon
Accounts payable:
This option allows the execution, reversal, and annulment of the budgetary cause and accounting entries.
what payment requests prepared in the Accounts Payable module require.
Accounting: It is executed to create the budgeted expense and accounting entry according to it.
established in the payment request.
Reverse: It is executed to eliminate the budgetary cause and accounting entries of the
payment request, in order for them to be modified.
Cancellation: It is carried out to annul the budgetary effect and accounting entries of the
payment requests.
1. As an initial step, one must search for documents using some filter.
available to cancel via the icon to display the grid of
documents.
2. The document(s) to be canceled will be checked.
3. The action will be processed using the icon
This option allows for the execution, reversal, and annulment of the budget payment, accounting entries and
financial impact of bank accounts that require the bank transactions created in the
Cash and Bank module.
Account for: It is executed to create the moment of budgeted payment, accounting entry and
financial impact of bank accounts according to what is established in the bank statements.
1. As an initial step, it should be indicated which operation is desired to be accounted for (Check,
Deposito, Nota de Débito o Crédito) y luego buscar, mediante algún filtro, los
documents available for accounting using the icon so that
Unfold the document grid.
The document(s) to be accounted for will be checked.
3. The action will be processed using the icon
Reversal: It is executed to eliminate the moment of budgetary payment, accounting entry and
financial impact of bank accounts according to the established bank transactions.
1. As a first step, it must be indicated which operation you wish to reverse (Check,
Deposit, Debit or Credit Note) and then search, using some filter, the
available documents to reverse the accounting using the icon
to display the document grid.
2. The document(s) to be reversed will be checked.
3. The action will be processed through the icon
VOID: It is performed to cancel the effect of the budgetary payment moment, accounting entry.
and financial impact of bank accounts according to what is established in the bank statements.
1. As a first step, it should be indicated which operation you wish to annul (Check,
Deposit, Debit or Credit Note) and then search, using some filter, the
documents available for cancellation through the icon for what it is
deploy the document grid.
2. The document(s) to be canceled will be checked.
3. The action will be processed through the icon
Nomination:
This option allows for the execution and reversal of budget entries, accounting entries and
financial impact resulting from the processing of payroll for the institution's created workers
in the Payroll module.
Account for: It is executed to create budget entries, accounting entries, and impacts.
financial product of payroll processing.
1. As an initial step, it should be indicated which payroll and period you wish to account for.
(Check, Deposit, Debit or Credit Note) and then search, through some
filter, the documents available for accounting through the icon for
let the document grid be displayed.
2. The document(s) to be accounted will be checked.
3. The action will be processed through the icon
This option allows the execution and reversal of the budgetary entries resulting from movements.
as Transfers, Additional Credits, Inexistences and Corrections to the budgetary resources
created in the Budgetary Expense Accounting module.
This module was designed and developed for the recording, control, and tracking of entries and
output of items in the warehouse. It is based on Lifo, Fifo, and weighted average cost methods.
Generated Reports
Existence of articles
Movements
Items to request
List of items by warehouse
Shipping orders
Supply entries to warehouses
Transfer between warehouses
Inventory summary
List of warehouses
Inventory valuation
Closing of purchase orders
Inventory Taking Valuation
Inventory adjustment valuation
Receipt of goods document
Warehouse Operations
Allows entering via the Internet the data of suppliers and contractors that work for the State,
streamlining the registration of them and the updating of their data. This module verifies and validates the
RIF with the SENIAT portal.
Reporte Generados
Providers
Beneficiaries
Supplier sheets
FIXED ASSETS MODULE
The fixed assets module was designed for the registration of movable and immovable property.
Republic, as well as the states and municipalities. Furthermore, it allows the registration of fixed assets of the
decentralized entities with or without business purposes, and calculates their depreciation through
the different methods.
Generated Reports
Assets
Incorporation
Disincorporation
Reassignment
Modification
Depreciation
Monthly Depreciation
SIGECOF catalog list
List of assets
Incorporation certificate
Decommissioning certificate
Reassignment receipt
The source files and reports of the module are located at:/var/www/sigesp/saf
TRAVEL EXPENSE CONTROL MODULE
It allows the calculation, recording, and control of per diems. This module is integrated with the ordering modules.
of payments, cash and bank, budgetary accounting and equity accounting.
This module has been designed according to the matrix of the Logical Framework and other provided guidelines.
by the Ministry of Planning and Development for the programmatic levels of the Operational Plan
Annual, and to the rules and instructions of ONAPRE for budget formulation.
Generated Reports
OPENING MODULE
Manages the start of each exercise of the organization's administrative management. The operations
consider the opening entries from a source database (previous year) to the new database,
transferring accounting, banking, and budget balances.
Opening
The source files of this module are contained in the folder: /var/www/sigesp/base/xml,
/var/www/sigesp/controller/apr/, /var/www/sigesp/model/apr/ and /var/www/sigesp/view/apr/
The opening is nothing more than the transfer of information called 'masters' or definitions.
general to be used in a new database, remember that each database behaves
as a tax exercise. These definitions must be made prior to entering the system.
1.- The first thing to do is to create a database container and have ONLY it.
structure of the tables, without any information.
There, just like the 'sigesp_config.php' file, the connection criteria for the database are established.
DESTINATION data, the structure of the file is as follows:
Example POSTGRES:
<?xml version="1.0" encoding="UTF-8"?>
<connections>
connection
<servidor>IP_DEL_SERVIDOR</servidor>
<puerto>5432</puerto>
<basedatos>db_apertura</basedatos>
<nombre>NOMBRE_A_MOSTRAR</nombre>
<login>usuario_db</login>
<password>clave_db</password>
<gestor>POSTGRES</gestor>
</conexion>
</connections>
SERVER = IP of the target server, in the case that it is local, you can use both the IP of the
machine like [Link]
PORT = Database engine communication port
BASEDATOS = Base de datos destino
NAME = This is the name that will be displayed upon entering the module
LOGIN = Este es el usuario para accesar a la base de datos
PASSWORD = Contraseña del usuario para accesar a la base de datos
MANAGER = This is where the database manager is indicated; it must be written in uppercase as such.
how is it in the sigesp_config
2.- The next step is to configure the virtual directory in the SOURCE DB, this is indicated by the
next way:
[Link]
The word "dirvirtual" is the location folder of the application on the server, here it is indicated.
"virtualdir" but this will depend on the institution:
EXAMPLE:
[Link]
Once the virtual address is determined, a field called 'dirvirtual' located in the
sigesp_company table, this can be done manually (query_browser with pgadmin3 with
postgres or any other frontend for your database manager) or by executing the following SCRIPT:
OPENING PHASES:
Next, we will describe the process to be used to carry out an opening as long as the
The accounting and budgeting structure will not undergo modifications; there are 2 other types of openings.
additional to this but this is the most common.
In this phase, you enter the opening module, select the option Processes \Data Transfer
basics, there each of the modules will be processed in the order indicated, IT IS NOT
It is advisable to transfer data from a later option if a previous one has encountered issues.
faults.
To determine the failures that occurred in the presented case, this module keeps a LOG of the
operations carried out that the same will indicate in the "DOWNLOAD" option in the same window.
These logs are saved in the following path: /sigesp/vista/apr/resultados
In cases where issues arise, I can tell you that they are mostly due to 'default data', already
that the system does not transfer all data by default.
Analyze what these data are and transfer them manually from one database to another.
(Consult with the IT Department).
In the case of the payrolls, the system can transfer them by updating the dates, indicating the
date 01/01/YEAR in the case of employees and in the case of workers the date must be placed
Sunday of week 1 (in the case of 2016, the first Sunday is 03/01/2012)
At the conclusion of the transfers, the system is ready to start operations in the database.
DESTINY.
It is suggested to enter the new database and execute the RELEASE within the INSTALL module.
additionally carry out all the reprocessing of balances (Accounting, Expense Budget and
Revenue Budget). And after this step, the database can be used normally.
data.
To carry out this process, ALL bank reconciliations must have been completed in all
banks, although accounts can be transferred individually by selecting bank and account.
To carry out this operation, the following fields must be indicated:
Once all this is indicated, the 'PROCESS' option is used. Just like the data transfer.
basics, the system keeps a LOG in the same path showing all the transferred records, in the
In case of any error, they will be indicated there.
Tips:
Phase III: Pending payment requests, Opening Entry, and initial inventory balances.
NOTE: To carry out this phase, the budget closure and the accounting closure must have already been completed.
(Each one in their respective module).
a) Payment requests will be transferred in two ways: Only accounting and with
Budgetary impact, the type is determined by the institution according to its nature.
Indicate the date of the first day of the new fiscal year.
In the search criteria section, the search interval must be specified.
of the pending requests.
A prefix must be indicated.
You must select the type of requests: partial payment or accounted for, in the
the first case is that a payment request still has a fraction to be settled and
In the second, nothing has been canceled.
We proceed to search for and select those applications that are going to be
transferred to the new exercise.
ii) To transfer the commitments and causes (budgetary allocation), the following must be used:
same criteria indicated above with the variation that the structure must be indicated
budgetary which will affect. These budget accounts that the system requests are
the matches.
b) Opening Entry.
This is a process that is responsible for transferring a balance sheet (assets, liabilities and
heritage/capital) as of the end of the previous year's fiscal year in the DESTINATION database,
this is done this way to avoid altering the movements of the current exercise (our
example of the entry would be dated 31/12/(previous year)
This process transfers the remaining stock of items from the warehouses, it is suggested
perform an inventory update in the INSTALL module before transferring the
stocks.
INSTALL MODULE
Manages certain maintenance tasks in the system's database as well as the update or release of the
executables, their options are:
Processes
Equity Accounting
• Reprocess Balances
• Reprocess Levels and References
Budget of Expenses
• Reprocess Balances
• Unbalanced Receipts
Reprocess Dates of Vouchers
Release
Report of Discrepant Vouchers
Report of requests without associated details
Reprocess Movements
Definition
System Creation
Group Creation
User Creation
Processes
Systems
Maintenance
Update windows
Password change
Manage password change
Manage permission by system
1. Configuration:
Press ok.
Press OK.
For the establishment of the Petty Cash, Direct Payment is made, accounting details are added.
with the petty cash account.
Step 1: In the Bank module > Processes, select Cancellations > Direct Payment
Then enter the following data:
➔ Type of operation: payment
➔ Select bank
➔ Select account
➔ Select the concept of Petty Cash Constitution
➔ Select source of funding
➔ Place the concept of movement
➔ Select the type of beneficiary
➔ Enter the beneficiary
➔ Enter amount, then add accounting details with Account
petty cash
➔ Save
4. Integrative Module
The check created in the previous step is recorded through Systems > Cash and Banks.
Bank Movement > Account for
The SEP commitment type (Petty Cash) is carried out, and the request for approval is issued and approved.
Budget execution with the requesting beneficiary.
6. Integrative Module
The SEP generated through Systems > Execution Request is accounted for.
Budgetary > Account for
7. Accounts Payable
The reception of Documents caused by the SEP originating in step 5 is carried out.
register and approve the payment request.
➔ SelectBeneficiary
➔ Add reception detail
➔ Save
8. Integrative Module
The scheduling of the previous payment is done and the check is issued, the document
it is coded as CACHXXX (Petty Cash).
To issue the check in the process menu go to Cancellations > Check Issuance.
The check is recorded in Systems > Cash and Banks > Bank Movements >
Account for.
The Credit Note is recorded in Systems > Cash and Banks > Transactions
Bank > Record.
The analytical accounting ledger is consulted to verify and analyze the movement of the
accounting account.
PROCESS FLOWCHART