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

Share this project:

Updates

Submission history