✅ Feature List

This document lists all the features of the RedeemBooks Accounting App, built with professional accounting principles and GAAP compliance.
The app is designed for multi-company support, full CRUD operations, and future scalability into a complete company management solution.

---

🟢 MVP Features (Capstone Scope)

1️⃣ Company & User Management

• Create and manage multiple companies
• Add multiple users to each company with roles: Owner, Manager, Staff
• Users can belong to multiple companies
• Role-based access control for sensitive operations
• CRUD:
  • Create: Add new companies and users
  • Read: View company profiles and user lists
  • Update: Edit company info and user roles
  • Delete: Remove companies or revoke user access

---

2️⃣ Approver Management

• Assign specific users as invoice approvers for each company
• Supports multi-level invoice approvals
• Links directly to invoice status workflow
• CRUD:
  • Create: Add approvers to a company
  • Read: List all approvers for a company
  • Update: Modify approver permissions
  • Delete: Remove approver access

---

3️⃣ Vendor Management

• Full CRUD for vendor profiles
• Store contact details, tax ID, address
• Track preferred payment method and payment terms
• Upload and link W-9 documents for compliance
• CRUD:
  • Create: Add new vendors
  • Read: View vendor profiles and history
  • Update: Edit vendor information or upload documents
  • Delete: Remove vendors

---

4️⃣ Categories Management

• CRUD for expense categories
• Used to classify invoices for reporting
• Linked to invoices for financial analytics
• CRUD:
  • Create: Add expense categories
  • Read: List and search categories
  • Update: Rename or update category details
  • Delete: Remove categories

---

5️⃣ Invoice Management

• Create, view, update, and delete invoices
• Unique invoice numbers per company
• Attach digital invoice files links
• Approval workflow with pending → approved → paid status
• Voucher date tracking
• Automatic due status indicators:
  • 🟢 Green = Not due
  • 🟡 Yellow = Due this week
  • 🔴 Red = Past due
• CRUD:
  • Create: Add invoices with details and file attachments
  • Read: View invoice lists, filter by status or vendor
  • Update: Edit invoice details, approve or mark as paid
  • Delete: Remove invoices

---

6️⃣ Payments (Partial Payments)

• Multiple payments allowed per invoice
• Tracks unpaid balances
• Automatically updates invoice status when fully paid
• Links directly to vendors and invoices
• CRUD:
  • Create: Record new payments or partial payments
  • Read: View payment history and balances
  • Update: Adjust payment details or status
  • Delete: Remove payment entries

---

7️⃣ AP Run / Payment Batches

• Group payments into scheduled AP runs
• Set processing dates for batch payments
• Compare total AP run amount with company bank balance
• Tracks batch status: scheduled → processed
• CRUD:
  • Create: Generate payment batches for AP runs
  • Read: View and filter batch history
  • Update: Modify batch details, mark processed
  • Delete: Cancel or delete batches

---

8️⃣ Bank Balances

• Store and track bank account balances for each company
• Used to compare available funds against AP runs
• Helps with weekly cash flow planning
• CRUD:
  • Create: Add new balance records
  • Read: View balance history and current funds
  • Update: Adjust balances for corrections
  • Delete: Remove old or incorrect entries

---

9️⃣ Audit Trail

• Automatic logging of all create, update, and delete actions
• Stores old and new data for every change
• Fully GAAP-compliant for auditing and traceability
• CRUD:
  • Create: Logs automatically generated on every action
  • Read: View historical logs for changes
  • Update: Not applicable (logs are immutable)
  • Delete: Remove logs only with admin rights

---

🔮 Future Enhancements

• Accounts Receivable (AR) tracking
• Invoice Lifecycle Management covering full AP/AR process
• Financial Statement Generation (Balance Sheet, P&L, Cash Flow)
• Expense Management with budget tracking
• Inventory Management for stock and procurement
• Asset Management with depreciation tracking
• Advanced Reports & Analytics for actionable insights
• AI-Powered Automation: Planned training in AI and Machine Learning after completing this capstone to add intelligent decision-making tools and automated data extraction from documents
• And more to transform RedeemBooks into a complete financial management solution

---

🧩 Feature-to-Database Mapping

Feature	Related Tables
Company & User Management	companies, users, user_companies
Approver Management	approvers
Vendor Management	vendors
Categories	categories
Invoice Management	invoices, categories, vendors, approvers
Payments (Partial)	payments, invoices, vendors
AP Run / Payment Batches	payment_batches, payments
Bank Balances	bank_balances
Audit Trail	audit_logs