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