The FYRS Project

Authored by Mohan Atkuri

Figure 1: FYRS Program

Have you ever wondered how your generous donations here at the temple are processed? It's more complex than you might think, involving data manipulation, report generation, and secure communication. Luckily, our team of hardworking interns has come up with an ingenious solution: FYRS (Financial Yearly Reports Email Sender)!

What is FYRS?

FYRS is a computer program designed to streamline the creation and distribution of financial reports to our valued donors. Think of it as a smart assistant that takes donation data, looks and fixes any issues, creates personalized reports, and securely delivers them to the donors!

What have our interns done?

We've been there every step of the way for our project here at HSMN. We started by identifying the core problem: the manual, time-consuming process of generating and sending donation reports. Then, with the help of our tech-chair, Vishwaji, delegated tasks and broke the problem down into manageable steps.

Each intern tackled a specific module: data cleaning, report design, email integration, and secure file transfer. After each intern wrote their section of the code, the real fun began: extensive testing! Our team worked closely to make sure each module worked perfectly with the others, catching and squashing bugs along the way.

Finally, to make FYRS accessible to everyone at the temple, I designed a user-friendly visual interface. Now, our vice treasurer can effortlessly generate and distribute reports! This interface, built with PySimpleGUI, allows the user to easily configure the software for general settings, emailer settings, excel files, and orchestration options.

Surface Level Details

FYRS has a modular architecture, using Python scripts for various tasks. It handles data ingestion from Excel files, uses anomaly detection to identify errors like missing emails, aggregates data, generates PDFs with donor information using HTML templates, sends emails, and even uploads the reports to Google Drive! Once any edits are made, the program is packaged using a combination of GitHub Actions and PyInstaller, so that our vice treasurer can have the latest changes at hand!

More to come!

While some of the other interns have moved on to new and exciting projects, I'm still here, committed to making FYRS even better! I'm currently focusing on optimizing the anomaly detection algorithms and improving the overall user experience.