AI Payroll System

An AI-powered payroll processing system that automates timesheet data extraction and pay calculations.

Features

• Upload timesheet photos
• AI-powered OCR for data extraction
• Automatic pay calculation
• Employee management
• Secure authentication
• File storage
• Review and approval workflow

Tech Stack

• Frontend: Next.js, Tailwind CSS, Shadcn UI
• Backend: Next.js Server Actions, Drizzle ORM
• Database: PostgreSQL
• Authentication: Clerk
• Storage: Supabase Storage
• AI/OCR: Azure Computer Vision

Getting Started

1. Clone the repository

2. Install dependencies:

   npm install

3. Copy .env.example to .env.local and fill in the environment variables:

   • Database connection
   • Clerk authentication keys
   • Supabase credentials
   • Azure Computer Vision credentials

4. Set up the database:

   npm run db:push

5. Run the development server:

   npm run dev

Environment Variables

• DATABASE_URL: PostgreSQL connection string
• NEXT_PUBLIC_CLERK_PUBLISHABLE_KEY: Clerk public key
• CLERK_SECRET_KEY: Clerk secret key
• NEXT_PUBLIC_SUPABASE_URL: Supabase project URL
• NEXT_PUBLIC_SUPABASE_ANON_KEY: Supabase anonymous key
• SUPABASE_SERVICE_ROLE_KEY: Supabase service role key
• AZURE_COMPUTER_VISION_ENDPOINT: Azure Computer Vision endpoint
• AZURE_COMPUTER_VISION_KEY: Azure Computer Vision API key

Project Structure

• actions/ - Server actions for data operations
• app/ - Next.js app router pages and components
• components/ - Reusable UI components
• db/ - Database schema and configuration
• lib/ - Utility functions and hooks
• public/ - Static assets
• types/ - TypeScript type definitions

Development Workflow

1. Create a new branch for your feature
2. Make your changes
3. Run tests and linting
4. Submit a pull request

License

MIT