top of page

2 TIER SOLUTION

LIVE VIEW
Frontend
Middleware
Backend
InterfaceWith
MS Access
MS SQL Server
MS Excel

The Prepaid Expenses App is a Microsoft Access desktop application with an MS SQL Server backend, designed to manage the amortization schedules of prepaid expenses efficiently. Key features include:

  • Amortization Schedule Management: Automates the creation and maintenance of amortization schedules for prepaid expenses, ensuring accurate expense recognition over time.

  • Centralized Data Maintenance: Provides a centralized repository for master data and transactional records, facilitating easy access and management.

  • Maker-Checker Model: Implements a dual-authorization system where one user (Maker) inputs data and another (Checker) reviews and approves it, enhancing internal controls and audit compliance.

  • GL Entry Generation for SAP Integration: Generates General Ledger entries formatted for seamless integration with SAP, supporting accurate financial postings and reconciliations.

  • Supporting Document Repository: Acts as a data repository by providing upload functionality for supporting documents, ensuring all relevant information is stored and accessible.

  • Validation Against SAP Entries: Mirrors entries generated by the SAP program, allowing for secondary validation and ensuring consistency between systems.

This automation enhances efficiency in managing prepaid expenses by reducing manual effort, improving accuracy in financial reporting, and ensuring compliance with audit requirements.

Prepaid Expenses

bottom of page