Transcript Project Proposal Presentation

Proposal by Cheryl Mesagna
10/15/2014
1
PROPOSAL
A web server using a database back end and
hosting SQL Ledger accounting software.
 Advantages of this system:
 Hosting an accounting package on a web server
allows users to access the software across the
internet, so they can work remotely from any
location that has internet access.
2
Requirements
 Virtual Machine
 Web server = Apache open source software
 SQL Database backend = MySQL
 Accounting Package = SQL Ledger
 Security = SSL Certificates
3
Advantages of Apache as webserver
 Open source – low expense, widely used, large
user community
 Modular – plugins for functionality are easily
added, and can be downloaded individually or built
 Ability to rewrite URLs – Can use regular
expressions (regex) to rewrite URLs, forcing
applications to use HTTPS.
4
Advantages of SQL Ledger for
accounting package
 Free accounting software
 Double-entry bookkeeping (debits/credits)
 Standard Accounting Functionality
 Chart of Accounts
 General Ledger
 Subsidiary Ledgers (Accounts Payable/Receivable)
 Audit Trail
5
Advantages of SQL Ledger for
accounting package (Continued)
 Billing and Invoicing
 Automated Transactions
 Billable Hours
 Check Printing
 Credit Card Processing
 Purchase Orders
 Reports and Templates
 Balance Sheets
 Cash Flow Statements
 Profit and Loss Reports
 Sales Reports
 Budgets and Forecasting
6
Security
 Use of SSL Certificates to permit system access only
to authorized individuals
7
Proposed Timeline
 Week 9 (10/20/14, 10/22/14) - Set up Webserver
 Week 10 (10/27/14, 10/29/14) – Set up Database Back-end
 Week 11: (11/03/14, 11/05/14) – Set up Database Back-end
 Week 12: (11/10/14, 11/12/14) – Install SQL Ledger
 Week 13: (11/17/14, 11/19/14) – Set up SSL certificates
8
Questions?
9
Advantages of SQL Ledger for
accounting package (Continued)
 Billing and Invoicing
 Automated Transactions
 Billable Hours
 Check Printing
 Credit Card Processing
 Purchase Orders
 Reports and Templates
 Balance Sheets
 Cash Flow Statements
 Profit and Loss Reports
 Sales Reports
 Budgets and Forecasting
10