Automated Liquidation Forms and Reports
NORVHEE JOY B. GALLARDO
Information technology has progressively upgraded all aspects of human endeavor, including the workplace. ICT becomes indispensable and the main resource identified by every organization as an instrument to accomplish every task to attain productivity. Innovative computer software likewise adds convenience to completing time-wasting tasks. Software commonly used in any workplace is Microsoft Excel.
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft Office suite of software. (Wikipedia)
The Automated Liquidation Forms and Reports were offline systems that work with the different features accessible in Microsoft Excel. The offline system work with Microsoft Excel’s computation capabilities and its macro programming language, Visual Basic for Applications. The computation capabilities of Microsoft Excel play a significant role in any transactions concerning simple or complex calculation of large numbers, such as financial and accounting transactions. The offline systems work with the following Microsoft Excel Functions: Financial; Date & Time; Math & Trig; Lookup & References; Logical; Information; and Data Validation. These functions offer the users the effortlessness of calculating and preparing various forms in just one go. In Microsoft Excel, Visual Basic for Applications (VBA) allows manipulation that is difficult with the standard spreadsheet techniques. Both offline systems similarly operate with simple macro programming for commands that automatically hide and unhide rows and columns, and the conversion of amounts in figures to words.
Each offline system contains a HOME page, a sheet comprising fund sources and Unified Accounts Code Structure (UACS), and multiple sheets relating to the different liquidation forms essential in the preparation of Liquidation Reports (LR), as provided in the General Accounting Manual (GAM) Volume II – Accounting Books, Registries, Records, Forms, and Reports issued by the Commission on Audit (COA). These forms comprise of the following: Disbursement Voucher (Appendix 32); Journal Entry Voucher (Appendix 36); Cash Disbursement Register (Appendix 43); Liquidation Report (Appendix 44); Status of Fund; Itinerary of Travel (Appendix 45); Reimbursement Expense Receipt (Appendix 46); Certificate of Travel Completed (Appendix 47); Inventory Custodian Slip (Appendix 59); Purchase Request (Appendix 60); Purchase Order (Appendix 61) or Job Order; Inspection and Acceptance Report (Appendix 62); Requisition and Issuance Slip (Appendix 63); Property Acknowledgement Receipt (Appendix 71); Certification of Expenses Not Requiring Receipt (Annex A); Contract of Service; Pre-Repair Inspection; Post-Repair Inspection; Program of Work; and Canvass Form.
With a basic familiarity with Microsoft Excel, users can effortlessly become accustomed to the functionality of these offline systems. Each cell on the HOME page and on some of the liquidation forms of each system has instructions provided and by following these instructions correctly, the offline systems will get the rest of the work done. From simple to complex computations to the identification of suppliers and/or payees with the lowest bids, the systems will get it done for users. Every form was configured, from the paper size, margins, etc., all users need to do is just hit the print button and you’re Liquidation Reports will be complete.