Release Notes

Stay updated with the latest features and improvements

Version 1.0.0

Initial Release

Released

December 2025

Welcome to Rex AI! This initial release brings powerful receipt processing and management capabilities to help you manage your expense receipts more efficiently.

Authentication & User Management

  • Google Sign-In integration using Google Identity Services
  • JWT-based authentication with secure token management
  • Role-based access control (Staff, Supervisor, Manager, Director, Executive)
  • Position level-based restrictions for receipt uploads
  • Admin user management system

AI-Powered Receipt Processing

  • Google Gemini AI integration for automatic data extraction
  • Automatic extraction of merchant, amount, date, payment method, and category
  • Support for multiple receipt types (Regular, Electric Bill, Utilities or Phone)
  • Special handling for Philippine bus tickets with punch holes
  • OCR text extraction with error correction
  • Automatic exclusion of convenience fees and tips from amounts
  • Transaction number and reference number extraction

BIR Compliance Validation

  • Automatic validation against BIR RMC No. 77-2024 requirements
  • PTP/ATP (BIR Permit/Authority to Print) verification
  • Business name and address validation
  • Receipt label verification (Invoice/Official Receipt)
  • Seller's TIN validation
  • POS machine and PTU verification for tape receipts
  • Visual compliance indicators in the UI

Receipt Type Support

  • Regular Receipt: Gas/Toll/Airfare, Meals, Internet Bill, Utilities or Phone
  • Electric Bill: Requires SOA upload with address verification
  • Utilities or Phone: Water, Phone, Cable/Satellite TV, Trash, Gas (LPG), Mobile/data load
  • Automatic category detection and validation
  • Type-specific validation rules

Google Drive Integration

  • Automatic receipt upload to Google Drive
  • Organized folder structure by year, quarter, and month
  • Separate storage for SOA files
  • Direct links to view receipts from transaction list
  • Service account-based authentication
  • Automatic folder creation and organization

Google Sheets Integration

  • Automatic transaction logging to Google Sheets
  • User-specific sheets organized by year
  • Automatic data synchronization
  • Direct access from transactions page
  • Series number tracking
  • Comprehensive transaction data logging

Cut-off Period Management

  • Configurable quarterly cut-off periods
  • Position level-based cut-off periods (Supervisor, Manager, Director, Executive)
  • Automatic receipt date validation
  • Monthly cut-off date tracking
  • Visual indicators showing current cut-off period
  • Admin bypass validation option for testing

Address Verification

  • Automatic address extraction from SOA files
  • HRIS address comparison for electric bills
  • Visual match/not match indicators
  • Prevents submission of incorrect address receipts
  • Integration with HRIS database for address lookup

Transaction Management

  • View all transactions with comprehensive filters
  • Search by merchant, transaction number, or series number
  • Filter by year, month, and category
  • Pagination for large transaction lists
  • Total amount calculation based on filters
  • Admin bulk update and delete capabilities
  • CSV export functionality

User Interface

  • Modern, responsive design with Tailwind CSS
  • Drag-and-drop receipt upload
  • Real-time receipt preview and editing
  • Visual BIR compliance indicators
  • Cut-off period information display
  • Mobile-responsive sidebar navigation
  • FAQ page with interactive chatbot
  • Release notes page

Technical Features

  • FastAPI backend with async support
  • Nuxt.js 3 frontend with Vue 3 Composition API
  • Pinia state management
  • MySQL database with separate receiptai database
  • SQLAlchemy ORM with proper relationships
  • JWT authentication with secure token handling
  • Google Gemini AI integration
  • Google Drive and Sheets API integration
  • Comprehensive error handling and logging
  • RESTful API with proper status codes

Database & Migration

  • Standalone receiptai database for transaction tracking
  • Integration with hris_core database for user authentication
  • Automatic transaction creation on receipt upload
  • Series number generation for transaction tracking
  • Foreign key constraints for data integrity
  • Migration scripts for database schema updates

More releases coming soon

Stay tuned for updates and new features