130 likes | 446 Views
LOCAL GOVERNMENT UNIT TEAM. AUTOMATED GENERAL LEDGER SYSTEM. BSIT 4101-11A. What the system does as a whole? Automated General L edger System is the summary of accounting reports such as: Balance sheet Income Statement General ledger Transaction covered of AGLS
E N D
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 Accounting Manager AGLS 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 AGLSdatabase LGU database Admin
Work Flow Accountant Bookkeeper • Download supporting documents • Generate reports • Upload supporting documents • Post JEV • Open JEV AGLS AGLS database • Bad entry analyze • Select transaction • Validate JEV • Edit JEV template
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, JaifePaulsor G. – Member Advised by: Mr. Rico Bundoc & Mr. Dennis Gonzales