PayPilot AI – Intelligent Payment & Finance Copilot
Inspiration
Managing payments involves more than simply sending and receiving money. Users need to monitor transactions, understand payment statuses, identify failed payments, track financial activity and make better financial decisions.
We built PayPilot AI to bring payment monitoring and financial intelligence together in one unified platform.
What it does
PayPilot AI is a full-stack payment and finance copilot that provides a centralized dashboard for transaction management and financial insights.
Key Features
- Transaction Management: View transaction records, amounts, categories and payment statuses.
- Smart Transaction Insights: Generate summaries and financial insights using stored transaction data.
- Smart Alerts: Identify failed and pending transactions that require attention.
- Monthly Financial Analytics: Analyze monthly transaction counts, payment statuses and completed totals by currency.
- Finance Assistant: Ask questions about transactions and receive database-grounded, rule-based answers.
- PayPal Sandbox Integration: Authenticate with PayPal Sandbox and create payment orders.
How we built it
We developed PayPilot AI using a full-stack architecture.
Frontend: React and Vite
Backend: Python and FastAPI
Database: SQLite and SQLAlchemy
Payment Integration: PayPal Sandbox REST API
The React frontend communicates with the FastAPI backend through REST APIs. Transaction records are stored in SQLite. The analytics and finance assistant process the stored database records to generate relevant insights and answers.
Challenges we faced
One of our major challenges was integrating PayPal Sandbox payment processing. We successfully configured OAuth authentication and tested payment order creation.
However, the Sandbox checkout currently reports a seller currency-acceptance error. Therefore, buyer approval and end-to-end payment capture validation are still pending.
Another challenge was ensuring that financial insights and analytics are generated from actual stored transaction data.
Accomplishments
- Developed a functional full-stack financial dashboard.
- Implemented database-backed transaction management.
- Built smart transaction insights and alerts.
- Implemented monthly financial analytics.
- Developed a rule-based finance assistant.
- Integrated PayPal Sandbox authentication and payment order creation.
What we learned
Through this project, we gained practical experience in full-stack development, REST API integration, database management, financial data analysis and payment gateway integration.
What's next
- Complete PayPal Sandbox buyer approval and capture validation.
- Expand finance assistant capabilities.
- Integrate additional payment providers.
- Improve financial reporting and analytics.
PayPilot AI – Making payment activity easier to understand.
Built With
- api
- artificial
- copy
- data
- fastapi
- financial
- intelligence
- javascript
- paypal
- python
- react
- rest
- sqlalchemy
- sqlite
- technology
- vite