Introduction 📚

For my high school dissertation project, I tackled a recurring challenge from our "Business Economics" book exercises: manually creating profit and loss statements and balance sheets based on various input details. The task, while straightforward, was repetitive and time-consuming, with only slight variations depending on the exercise (they were repetitive on purpose, as that's the goal of homework 😅). So, I decided to make it more intresting 😎

Solution 💡

To optimize this process, I developed an application using PHP and MariaDB that could automatically generate these financial statements. By implementing the algorithms and logic I had studied, I was able to create a tool that accurately produced the necessary reports based on the provided input details.

Project Duration ⏳

This project took six months to complete and involved a substantial data collection process. I enlisted the support of some friends who were interested in learning SQL, which not only helped expedite the data collection but also fostered a collaborative learning environment.

Features 🛠️

Program Assistance 🧑‍🏫

BilancioEA assists students during their exercises by providing a series of pre-made exercises that can be compared with the student's work to facilitate understanding and correction.

Sharing Made Simple 🔗

Sharing an exercise is easy—just scan a QR code! Alternatively, a direct link to the selected exercise is always available.

Easy Creation ✏️

Creating an exercise is simple. Just enter all the accounts from the exercise you intend to create and add it to the list! (This requires a special access code available only to teachers.)

Advantages ⏱️

Using this program significantly optimizes the time available for correcting assigned exercises. Drafting the statements on the board takes an average of 15 minutes per statement, whereas BilancioEA takes less than 2 seconds.

Supported Financial Statements 📊

Bilancio EA offers the possibility to generate the following statements:

• Income Statement
• Balance Sheet
• Income Statement Reclassified by Value Added
• Income Statement Reclassified by Cost of Goods Sold
• Calculation of Value Added
• Calculation of Cost of Goods Sold
• Reclassified Balance Sheet without Profit Distribution
• Reclassified Balance Sheet with Profit Distribution
• Profit Distribution Statement
• Additionally, it provides ratio analysis for profitability, asset structure, and financial structure.

Outcome 🏆

The automation not only saved time but also ensured accuracy and consistency in the results. The project was well-received, and I was awarded the highest grade for my efforts! A truly satisfying achievement! This project not only demonstrated my ability to apply theoretical knowledge to practical problems but also showcased my initiative, project management skills, and entrepreneurial spirit.

This was the booklet used to present the project during the final exam. Maybe it was a little bit too much 😅, but I really put a lot of effort into this project at that time. As you can see, the project has been published on the school's official website, which is an honour! Unfortunately, the brochure is only available in Italian.