File - General Ledger System
Download
Report
Transcript File - General Ledger System
LOCAL GOVERNMENT UNIT TEAM
AUTOMATED GENERAL LEDGER SYSTEM
BSIT 4101-11A
What the system does as a whole?
Automated General Ledger System is the summary of accounting reports such
as:
Balance sheet
Income Statement
General ledger
Transaction covered of AGLS
Downloading of supporting document
Journal Entry Voucher of every department
a. Disbursement
b. Revenues
Chart of accounts
a. General funds
b. Others
Accounting templates
Queries
User log in
Downloading of supporting documents
Transfer of journal entry voucher to AGLS
Validation of JEV if bad entry or good entry
Saving JEV to database
Reports
Balance sheet
Income statement
General ledger reports
Special Technology
Submission of supporting documents will be automated meaning no
paper works will be send to AGLS.
Sending SMS for forgot password
Document extraction into MS excel file, MS word file, Adobe PDF file.
Major difference from other similar system
AGLS is integrated with other subsystem under LGU.
Integration with other system
BUDGET PREPARATION SYSTEM
COLLECTION SYSTEM
AUTOMATED GENERAL LEDGER SYSTEM
AGLS database
Solution Architecture
LGU
database
BUDGET PREPARATION SYSTEM
COLLECTION SYSTEM
Budget preparation system has own on database as well as collection system. The
JEV posted in general ledger will directly save into bad entry table. However posted
will remain.
AUTOMATED GENERAL LEDGER SYSTEM
System Layout
Accountant
AGLS
Accounting Manager
The accountant can log on to system, complete the process while
accounting manager can log on as well, can manage automated
general ledger system and admin is the programmer who manage
the entire LGU
AGLS database
LGU database
Admin
Work Flow
Accountant
• Download supporting documents
• Open JEV
Bookkeeper
• Upload supporting documents
• Post JEV
• Generate reports
AGLS
AGLS database
• Bad entry analyze
• Select transaction
• Validate JEV
•Edit JEV template
Timeline
Automated general ledger system members and advisers:
Dalao, Rommel C. – Project Manager
Balantes, Ana Margarita V. – Business Analyst
Nicanor, Majie F. – System Analyst
Samot, Marlon P. – Programmer
Arpon, Andrea P. – Document Specialist
Daniel, Jaife Paulsor G. – Member
Advised by:
Mr. Rico Bundoc & Mr. Dennis Gonzales