Accounting Web App | Excel Nightmares

Updated on 6th June 2023

A basic accounting web app build with HTML, CSS, JavaScript and PHP.

Introduction

Excel Nightmares Home Page

This is a group project that we did with a team for a small assignment. This application can generate Statements of Financial Position and Statements of Profit/Loss by entering the details of the transactions which are entered by searching for the account type. As shown below, The application will automatically suggest the account type upon user input.

Inputting data into the application

After entering the details, the user can generate the Statements by clicking the generate button. The application will then display the Statements of Financial Position and Statements of Profit/Loss. The application also has a feature to export the Statements into an encrypted file which can only be viewed by importing to the application itself.

Output of the application

Output of the application

Methodology

This application was built with HTML, CSS, JavaScript and PHP. The application uses MySQL as the database. The application is hosted on the same server as the database.

Final Thoughts

This was a fun project to work on. We learned a lot about how accounting software works as the assignment was to do a small case study on different accounting software and how they work. We tried to implement our findings into this application and we believe it turned out pretty well.