hardy-sapphire System Requirements Document

Introduction

The hardy-sapphire project aims to develop an artificial intelligence system for comparing two Excel database files and identifying discrepancies. This document outlines the system requirements for the project, ensuring that all functionalities and user needs are addressed.

System Overview

The hardy-sapphire project is designed to assist finance professionals in efficiently comparing Excel files to detect inconsistencies. The system will leverage AI to automate the comparison process, providing accurate and timely results.

Functional Requirements as Story Points

• As a finance team member, I should be able to upload two Excel files for comparison.
• As a finance team member, I should be able to view a detailed report of discrepancies between the two files.
• As a finance team member, I should be able to export the discrepancy report in a user-friendly format.
• As a finance team member, I should be able to receive notifications when the comparison is complete.
• As a finance team member, I should be able to access historical comparison reports for reference.
• As a finance team member, I should be able to configure comparison settings to tailor the analysis to specific needs.

User Personas

• Finance Team Member: Includes Данііл Пащенко and other finance professionals who will use the system to compare Excel files and analyze discrepancies.
• System Administrator: Responsible for managing user access and system configurations.

Core User Flows

• Finance team member uploads two Excel files -> System processes files -> AI identifies discrepancies -> User views discrepancy report -> User exports report if needed.
• Finance team member configures comparison settings -> Uploads files -> System processes with custom settings -> User receives tailored discrepancy report.

Visuals Colors and Theme

[Default — not specified by user]

• primary: #2E86C1 (a professional blue)
• primary_light: #AED6F1 (a lighter tint of blue)
• secondary: #F1C40F (a complementary yellow for highlights)
• accent: #E74C3C (a vibrant red for CTAs and alerts)
• highlight: #F39C12 (an orange for active states and notifications)
• bg: #F8F9F9 (a light grey for background)
• surface: #FFFFFF (white for cards and panels)
• text: #2C3E50 (dark blue for primary text)
• text_muted: #7F8C8D (grey for secondary text)
• border: #D5D8DC (a subtle grey for borders)

Signature Design Concept

The hardy-sapphire landing page will feature an interactive "Data River" concept. Users will see a flowing river of data cells, representing the Excel files. As users hover over the river, discrepancies will light up in vibrant colors, and clicking on them will reveal detailed insights. This dynamic visualization will be created using motion/react for smooth animations and interactions.

Landing Hero Motion Brief

The hero section will depict a continuous flow of data cells moving from left to right. As the cells progress, discrepancies will be highlighted in red, showing the AI's real-time analysis. The animation will loop every 10 seconds, with a clear transformation from raw data to highlighted discrepancies, emphasizing the system's capability to identify and resolve issues. The animation will be responsive, ensuring clarity on all devices.

Interaction Model & Motion Direction

• Interaction Model: Animated
• The landing page will feature moderate scroll-triggered reveals and hover transitions, providing a polished and engaging user experience.

Non-Functional Requirements

• The system must process Excel files efficiently, with a maximum processing time of 2 minutes per file.
• The system should ensure data security and confidentiality, adhering to industry standards.

Tech Stack

• Frontend: React for Web
• Backend: Python, FastAPI
• Database: MySQL or MariaDB
• AI Models: GPT 5.4 for user-friendly response
• Local Orchestration: Docker, docker-compose

Assumptions and Constraints

• The system will primarily be used by finance professionals in Ukraine.
• The system must support Excel file formats commonly used in financial analysis.

Glossary

• AI: Artificial Intelligence
• CTA: Call to Action
• Excel File: A spreadsheet file format used for data organization and analysis
• Discrepancy: A difference or inconsistency between data sets

This document provides a comprehensive overview of the hardy-sapphire project requirements, ensuring that all user needs and system functionalities are clearly defined and addressed.